#DaMiAnO

Hi, me and my friend searching function for add new models and textures to MTA, or tutorial - How to add new models and textures, and how to give for that new ID.

Server: function onPlayerLoginToAccount(login, pass) local query = dbQuery(connect, "SELECT * FROM `accounts` WHERE `login` = '%s' AND `pass` = '%s'", login, pass) local acc = dbPoll(query, 0) if acc then outputChatBox("Zalogowano.", source ) else outputChatBox("#EE5555* #C0C0C0Podano zły #EE5555Login #C0C0C0lub #EE5555Hasło#C0C0C0!", source, 255, 255, 255, true ) triggerClientEvent("tryAgain", root ) end end addEvent("submitLogin", true) addEventHandler("submitLogin", root, onPlayerLoginToAccount)

Still got this, right? Yes.

Because, MySQL module by Ryden is easier for me.

@UP: Nope, I'm connected to MySQL. connect = mysql_connect("localhost", "root", "", "lh") if(connect) then outputServerLog("\n[MySQL] Pomyslnie polaczono z MySQL!") outputDebugString("Pomyslnie polaczono z MySQL!", 3, 0, 224, 0) else outputServerLog("\n[MySQL] Wystapil blad podczas laczenia z MySQL! Polaczenie zostalo zerwane...") outputDebugString("Wystapil blad podczas laczenia z MySQL! Polaczenie zostalo zerwane...", 3, 255, 0, 0) mysql_close(connect) end

Now: bad argument #1 to 'mysql_query' (mysqlHandler expected, got nil)

Bugged code: Client: function tryAgainLogin() guiSetVisible(loginButton, true) guiSetVisible(loginPassLabel, true) guiSetVisible(registerLabel, true) guiSetVisible(loginBox, true) guiSetVisible(passBox, true) guiSetVisible(keyImage, true) showCursor(true) guiSetInputEnabled(true) outputChatBox("Test4!", 255, 255, 255, true) addEventHandler("onClientRender", root, createDxOnLogin) end addEvent("tryAgain", true) addEventHandler("tryAgain", getResourceRootElement(getThisResource()), tryAgainLogin) function onPlayerLoginToAccount(login, pass) mysql = exports.mysql local acc = mysql_query(connect, "SELECT * FROM `accounts` WHERE `login` = '"..login.."' AND `password` = '"..pass"'") if acc then outputChatBox("Zalogowano.", source) else outputChatBox("#EE5555* #C0C0C0Podano zły #EE5555Login #C0C0C0lub #EE5555Hasło#C0C0C0!", source, 255, 255, 255, true) triggerClientEvent("tryAgain", getRootElement()) end end addEvent("submitLogin", true) addEventHandler("submitLogin", root, onPlayerLoginToAccount)

My current code: local screenWidth, screenHeight = guiGetScreenSize() function createDxOnLogin() dxDrawRectangle(769.0, 379.0, 211.0, 193.0, tocolor(255, 0, 0, 155), false) dxDrawText("Ping: "..tostring(getPlayerPing(getLocalPlayer())).."\n\n\n FPS: 0",778.0, 387.0, 970.0, 542.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(358.0, 379.0, 404.0, 193.0, tocolor(255, 192, 0, 155), false) dxDrawText("Rejestracja", 358.0, 380.0, 574.0, 418.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(769.0, 178.0, 211.0, 193.0, tocolor(0, 255, 0, 155), false) dxDrawText("Online:\n\n 1 / 100", 776.0, 180.0, 962.0, 215.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(358.0, 178.0, 404.0, 194.0, tocolor(0, 96, 255, 155), false) dxDrawText("Logowanie", 361.0, 180.0, 547.0, 215.0,tocolor(255, 255, 255,255), 1.0, "bankgothic", "left", "top", false, false, false) end function createGUIElements() loginButton = guiCreateButton(634, 323, 117, 37, "Zaloguj!", false) loginPassLabel = guiCreateLabel(481, 244, 48, 56, "Login:\n\n\nHaslo:", false) guiSetFont(loginPassLabel,"default-bold-small") registerLabel = guiCreateLabel(363, 424, 397, 86, "Jesli nie posiadasz konta, udaj sie na nasze forum i zarejestruj konto.\nKolejnym krokiem bedzie zalozenie postaci.\n\n\n[url=http://www.LostHeaven.pl]http://www.LostHeaven.pl[/url]", false) guiSetFont(registerLabel,"default-bold-small") loginBox = guiCreateEdit(525, 241, 145, 23, "", false) guiEditSetMaxLength(loginBox, 25) passBox = guiCreateEdit(525, 281, 145, 23, "", false) guiEditSetMasked(passBox, true) guiEditSetMaxLength(passBox, 30) keyImage = guiCreateStaticImage(358, 237, 111, 94, "key.png", false) guiSetVisible(loginButton, true) guiSetVisible(loginPassLabel, true) guiSetVisible(registerLabel, true) guiSetVisible(loginBox, true) guiSetVisible(passBox, true) guiSetVisible(keyImage, true) addEventHandler("onClientGUIClick", loginButton, clientSubmitLogin, false) end addEventHandler("onClientResourceStart",resourceRoot,function() createGUIElements() showCursor(true) guiSetInputEnabled(true) addEventHandler("onClientRender", root, createDxOnLogin) end) addEvent("tryAgain", true) function clientSubmitLogin(button,state) if button == "left" and state == "up" then local login = guiGetText(loginBox) local pass = guiGetText(passBox) if login and pass then triggerServerEvent("submitLogin", getRootElement(), login, pass) guiSetVisible(loginButton, false) guiSetVisible(loginPassLabel, false) guiSetVisible(registerLabel, false) guiSetVisible(loginBox, false) guiSetVisible(passBox, false) guiSetVisible(keyImage, false) guiSetInputEnabled(false) showCursor(false) else outputChatBox("#EE5555* #C0C0C0Prosze wpisac #EE5555Login #C0C0C0oraz #EE5555Haslo#C0C0C0, aby sie zalogowac!", 255, 255, 255, true) end end end Server: addEvent("submitLogin", true) addEventHandler("submitLogin", root, function(login, pass) local acc = mysql_query(connect, "SELECT * FROM `accounts` WHERE `login` = '"..login.."' AND `password` = '"..pass.."'") if acc then outputChatBox("Zalogowano.", source) triggerClientEvent(client,"close",root) else outputChatBox("#EE5555* #C0C0C0Podano zly #EE5555Login #C0C0C0lub #EE5555Haslo#C0C0C0!", source, 255, 255, 255, true) triggerClientEvent(client, "tryAgain", getRootElement()) end end)

I conected it to MySQL.

When I left empty boxes, dx is hiding, but gui is showing. Error: bad argument #1 to 'mysql_query' (mysqlHandler expected, got nil)

When I left empty boxes, dx is hiding, but gui is showing.

Code is bugged, for example outputChatBox is not showing.

My code. Client: local screenWidth, screenHeight = guiGetScreenSize() local players = getElementsByType("player") function createDxOnLogin() dxDrawRectangle(769.0, 379.0, 211.0, 193.0, tocolor(255, 0, 0, 155), false) dxDrawText("Ping: "..tostring(getPlayerPing(getLocalPlayer())).."\n\n\n FPS: 0",778.0, 387.0, 970.0, 542.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(358.0, 379.0, 404.0, 193.0, tocolor(255, 192, 0, 155), false) dxDrawText("Rejestracja", 358.0, 380.0, 574.0, 418.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(769.0, 178.0, 211.0, 193.0, tocolor(0, 255, 0, 155), false) dxDrawText("Online:\n\n "..tostring(#players).." / 100", 776.0, 180.0, 962.0, 215.0, tocolor(255, 255, 255, 255), 1.0, "bankgothic", "left", "top", false, false, false) dxDrawRectangle(358.0, 178.0, 404.0, 194.0, tocolor(0, 96, 255, 155), false) dxDrawText("Logowanie", 361.0, 180.0, 547.0, 215.0,tocolor(255, 255, 255,255), 1.0, "bankgothic", "left", "top", false, false, false) end function createGUIElements() loginButton = guiCreateButton(634, 323, 117, 37, "Zaloguj!", false) loginPassLabel = guiCreateLabel(481, 244, 48, 56, "Login:\n\n\nHaslo:", false) guiSetFont(loginPassLabel,"default-bold-small") registerLabel = guiCreateLabel(363, 424, 397, 86, "Jesli nie posiadasz konta, udaj sie na nasze forum i zarejestruj konto.\nKolejnym krokiem bedzie zalozenie postaci.\n\n\n[url=http://www.LostHeaven.pl]http://www.LostHeaven.pl[/url]", false) guiSetFont(registerLabel,"default-bold-small") loginBox = guiCreateEdit(525, 241, 145, 23, "", false) guiEditSetMaxLength(loginBox, 25) passBox = guiCreateEdit(525, 281, 145, 23, "", false) guiEditSetMasked(passBox, true) guiEditSetMaxLength(passBox, 30) keyImage = guiCreateStaticImage(358, 237, 111, 94, "key.png", false) guiSetVisible(loginButton, true) guiSetVisible(loginPassLabel, true) guiSetVisible(registerLabel, true) guiSetVisible(loginBox, true) guiSetVisible(passBox, true) guiSetVisible(keyImage, true) addEventHandler("onClientGUIClick", loginButton, clientSubmitLogin, false) end addEventHandler("onClientResourceStart",resourceRoot,function() createGUIElements() showCursor(true) guiSetInputEnabled(true) addEventHandler("onClientRender", root, createDxOnLogin) end) function tryAgainLogin() createGUIElements() addEventHandler("onClientRender", root, createDxOnLogin) end addEvent("tryAgain") addEventHandler("tryAgain", getRootElement(), tryAgainLogin) function clientSubmitLogin(button,state) if button == "left" and state == "up" then local login = guiGetText(loginBox) local pass = guiGetText(passBox) if login and pass then triggerServerEvent("submitLogin", getRootElement(), login, pass) guiSetVisible(loginButton, false) guiSetVisible(loginPassLabel, false) guiSetVisible(registerLabel, false) guiSetVisible(loginBox, false) guiSetVisible(passBox, false) guiSetVisible(keyImage, false) guiSetInputEnabled(false) showCursor(false) else outputChatBox("#EE5555* #C0C0C0Prosze wpisac #EE5555Login #C0C0C0oraz #EE5555Haslo#C0C0C0, aby sie zalogowac!", 255, 255, 255, true) end end end Server: addEvent("submitLogin", true) addEventHandler("submitLogin", root, function(login, pass) local acc = mysql_query(connect, "SELECT * FROM `accounts` WHERE `login` = '%s' AND `pass` = '%s'", login, pass) if acc then outputChatBox("Zalogowano.", source) else outputChatBox("#EE5555* #C0C0C0Podano zly #EE5555Login #C0C0C0lub #EE5555Haslo#C0C0C0!", source, 255, 255, 255, true) triggerServerEvent(source, "tryAgain", getRootElement()) end end) If i wrote bad login or pass, then GUI is invisible, but Dx is visible. If I wrote bad login or pass, I want Visible GUI and Visible Dx. If I wrote good login and pass, I want hide Dx and GUI. I'm triggering it, but does not working. Second question, bad argument #1 to 'mysql_query' (mysqlHandler expected, got nil). I'm connected to MySQL. ( Your methods to client-side not working ).

Working, but How to show Dx and GUI, when I wrote bad login or pass, and How to hide dx and gui, when i logged to account?

I edited this, and not working. : ((