mysql login Panel

[2013martin1212]

i change all my login data  but the debug says i dont add ther serverside event to server side cant trigger

 

there is my img :

 

my server side :

local mysql = exports.mysql


addEvent("logIn", true) 
function logThePlayer(thePlayer,username,password)
	if thePlayer and username and password then
		if getElementType(thePlayer) == "player" then
			local account = mysql:db_Query("SELECT FROM users WHERE username'" .. username .."'")
			for i, sor in ipairs(account) do
				is sor["password"] == password then
				
			    mysql:db_Exec("UPDATE users SET serial='" .. getPlayerSerial(thePlayer) .. "' WHERE username='" .. username .. "'") 
			    mysql:db_Exec("UPDATE users SET ip='" .. getPlayerIP(thePlayer) .. "' WHERE username='" .. username .. "'") 
	
		local character = mysql:db_Query("SELECT * FROM characters WHERE accountname ='" .. username .. "'") 
		if character then
			outputDebugString("Sikeressen talaltam charactert")
			for i, sor in ipairs(character) do	
				setElementData(thePlayer, "acc:username", username)
				setPlayerMoney(thePlayer, sor["money"])
				spawnPlayer(thePlayer,sor["posX"], sor["posY"],sor["posZ"], sor["pRot"], sor["pSkin"], sor["pInt"], sor["pDim"]))
				setPlayerName(thePlayer, sor["charactername"]) 
				 setCameraTarget(thePlayer, thePlayer) 
				triggerClientEvent(thePlayer, "showHide", getRootElement()) 	
			    outputChatBox("elvileg jo :D") 

               end 
             end 
        else 
              --  triggerClientEvent(thePlayer, "charactervalaszto", getRootElement()) 
                triggerClientEvent(thePlayer, "showHide", getRootElement()) 
                    end 
                end 
            end 
        end 
    end 
end 
addEventHandler("logIn", getRootElement(), logThePlayer) 		
				
				
				
				

my client side:

fadeCamera(true)
setCameraMatrix( 1468.8785400391, -919.25317382813, 100.153465271, 1468.388671875, -918.42474365234, 99.881813049316)


GUIEditor = {
    tab = {},
    tabpanel = {},
    edit = {},
    button = {},
    window = {}
}
addEventHandler("onClientResourceStart", resourceRoot,
    function()
        GUIEditor.window[1] = guiCreateWindow(411, 200, 438, 337, "Login Panel by Martin", false)
        guiWindowSetSizable(GUIEditor.window[1], false)

        GUIEditor.tabpanel[1] = guiCreateTabPanel(14, 62, 404, 258, false, GUIEditor.window[1])

        GUIEditor.tab[1] = guiCreateTab("Login", GUIEditor.tabpanel[1])

        GUIEditor.edit[1] = guiCreateEdit(122, 49, 194, 40, "", false, GUIEditor.tab[1])
        GUIEditor.edit[2] = guiCreateEdit(122, 123, 194, 40, "", false, GUIEditor.tab[1])


        GUIEditor.button[1] = guiCreateButton(122, 170, 194, 40, "Login", false,GUIEditor.tab[1]) 
    
        GUIEditor.tab[2] = guiCreateTab("Register", GUIEditor.tabpanel[1])

        GUIEditor.edit[3] = guiCreateEdit(122, 49, 194, 40, "x", false, GUIEditor.tab[2])
        GUIEditor.edit[4] = guiCreateEdit(122, 123, 194, 40, "y", false, GUIEditor.tab[2])


        GUIEditor.button[2] = guiCreateButton(122, 170, 194, 40, "Register", false, GUIEditor.tab[2] )
        
    end
)


addEvent("showHide",true)
function showHide()
    if guiGetVisible(GUIEditor.window[1]) == true then
        guiSetVisible(GUIEditor.window[1],false)
        showCursor(false)
    elseif
        guiGetVisible(GUIEditor.window[1]) == false then
        guiSetVisible(GUIEditor.window[1],true)
        showCursor(true)
    end
end
addEventHandler("showHide", getLocalPlayer(),showHide)

showHide()

function buttonClick()
    if source == GUIEditor.button[2] then
        local username = guiGetText(GUIEditor.edit[3])
        local password = guiGetText(GUIEditor.edit[4])
        triggerServerEvent("registerRequest",getLocalPlayer(),getLocalPlayer(),username,password)
    elseif source == GUIEditor.button[1] then
        local username = guiGetText(GUIEditor.edit[1])
        local password = guiGetText(GUIEditor.edit[2])
        triggerServerEvent("logIn",getLocalPlayer(),getLocalPlayer(),username,password)
    end
end
addEventHandler("onClientGUIClick",root,buttonClick)

 

[Captain Cody]

Server -

 

    local mysql = exports.mysql


    addEvent("logIn", true) 
    function logThePlayer(thePlayer,username,password)
    	if thePlayer and username and password then
    		if getElementType(thePlayer) == "player" then
    			local account = mysql:db_Query("SELECT FROM users WHERE username'" .. username .."'")
    			for i, sor in ipairs(account) do
    				if sor["password"] == password then
    				
    			    mysql:db_Exec("UPDATE users SET serial='" .. getPlayerSerial(thePlayer) .. "' WHERE username='" .. username .. "'") 
    			    mysql:db_Exec("UPDATE users SET ip='" .. getPlayerIP(thePlayer) .. "' WHERE username='" .. username .. "'") 
    	
    		local character = mysql:db_Query("SELECT * FROM characters WHERE accountname ='" .. username .. "'") 
    		if character then
    			outputDebugString("Sikeressen talaltam charactert")
    			for i, sor in ipairs(character) do	
    				setElementData(thePlayer, "acc:username", username)
    				setPlayerMoney(thePlayer, sor["money"])
    				spawnPlayer(thePlayer,sor["posX"], sor["posY"],sor["posZ"], sor["pRot"], sor["pSkin"], sor["pInt"], sor["pDim"]))
    				setPlayerName(thePlayer, sor["charactername"]) 
    				 setCameraTarget(thePlayer, thePlayer) 
    				triggerClientEvent(thePlayer, "showHide", getRootElement()) 	
    			    outputChatBox("elvileg jo :D") 

                   end 
                 end 
            else 
                  --  triggerClientEvent(thePlayer, "charactervalaszto", getRootElement()) 
                    triggerClientEvent(thePlayer, "showHide", getRootElement()) 
                        end 
                    end 
                end 
            end 
        end 
    end 
    addEventHandler("logIn", getRootElement(), logThePlayer) 		
    				
    				
    				
    				

 

 

Typo at line 11, had is instead of if.

 

[2013martin1212]

i dont get u

 

[Captain Cody]

Replace your server side script with the one I just posted and try it.

[2013martin1212]

triggered serverside event logIn but event not added to server side

 

[Captain Cody]

Make sure the server side script is defined before the client side script in the meta file.