Help

[2013martin1212]

Hello please help i start to learnt the mysql and i try to make a log in panel but the system doesnt want to work

there is my script

Server side

  
host = "localhost"; 
name = "thesee"; 
user = "root"; 
password = ""; 
  
  
addEventHandler("onPlayerJoin", getRootElement(), 
    function() 
        triggerClientEvent(source, "onJoin", getRootElement()) 
    end 
) 
  
function onLogin ( player, user, pass ) 
    connect = dbConnect( "mysql", "dbname=" .. name .. ";host=" .. host, user, password  ) 
    local login = dbQuery(connect,"SELECT * FROM accounts WHERE username = '"..user( connect, user ).."' AND password = '"..pass( connect, md5(pass) ).."';") 
    if login then 
        local rows = mysql_num_rows(login) 
        if rows == 1 then 
            triggerClientEvent( player, "closeWindow", getRootElement() ) 
            outputChatBox("* You successfully logged in your account!", player, 255, 255, 255) 
            spawnPlayer( player, 0,0,3 )  
            fadeCamera( player, true ) 
            setCameraTarget( player, player ) 
        else 
            outputChatBox("* Login failed!", player, 255, 255, 255) 
        end 
        mysql_free_result(login) 
    end 
end 
addEvent( "onLogin", true ) 
addEventHandler( "onLogin", getRootElement(), onLogin ) 
  

And the client side

login_register_window = guiCreateWindow(448,192,419,227,"MySQL Login System",false) 
guiWindowSetMovable(login_register_window,false) 
guiWindowSetSizable(login_register_window,false) 
tab_panel = guiCreateTabPanel(0.0859,0.1982,0.8282,0.7225,true,login_register_window) 
login_tab = guiCreateTab("Login",tab_panel) 
user_edit_l = guiCreateEdit(0.2507,0.15,0.6311,0.2,"",true,login_tab) 
pw_edit_l = guiCreateEdit(0.2507,0.4143,0.634,0.1929,"",true,login_tab) 
login_btn_l = guiCreateButton(0.2536,0.6643,0.634,0.2071,"Login",true,login_tab) 
guiSetFont(login_btn_l,"default-bold-small") 
username_label_l = guiCreateLabel(0.0317,0.1571,0.219,0.1929,"Username: ",true,login_tab) 
guiLabelSetVerticalAlign(username_label_l,"center") 
guiLabelSetHorizontalAlign(username_label_l,"right",false) 
guiSetFont(username_label_l,"default-bold-small") 
pw_label_l = guiCreateLabel(0.0692,0.4286,0.17,0.1714,"  Password: ",true,login_tab) 
guiLabelSetVerticalAlign(pw_label_l,"center") 
guiLabelSetHorizontalAlign(pw_label_l,"center",false) 
guiSetFont(pw_label_l,"default-bold-small") 
guiEditSetMasked( pw_edit_l, true ) 
guiSetVisible( login_register_window, false ) 
  
function playerJoin() 
    guiSetVisible( login_register_window, true ) 
    showCursor( true ) 
    guiSetInputEnabled( true ) 
    setCameraMatrix( -1799.6999511719, 1856.5999755859, 30.39999961853, -1763.9000244141, 1852.5999755859, 19.799999237061 ) 
    fadeCamera (true) 
end 
addEvent("onJoin", true) 
addEventHandler("onJoin", getRootElement(), playerJoin) 
  
function closeWindow() 
    guiSetVisible( login_register_window, false ) 
    showCursor( false ) 
    guiSetInputEnabled( false ) 
end 
addEvent("closeWindow", true) 
addEventHandler("closeWindow", getRootElement(), closeWindow) 
  
function login_player ( source ) 
        triggerServerEvent ( "onLogin", getRootElement(), getLocalPlayer(), guiGetText(user_edit_l), guiGetText(pw_edit_l) ) 
end 
addEventHandler("onClientGUIClick", login_btn_l, login_player,false)