Jump to content

Recommended Posts

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

 

there is my img :mta-screen_2016-10-22_17-00-19.png

 

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)





 

Link to comment

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.

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...