I'm trying to save profile data ( player type the data in the memos and I want to save it in the SQL by the account name ) but when I restart the resource the data don't appear in the memo
The code:
Client:
addEventHandler('onClientGUIClick',root,
function()
if source == profile['save_label'] then
triggerServerEvent('onClickSave',localPlayer,getPlayerName(localPlayer),guiGetText(profile['name_memo']),guiGetText(profile['birthday_m']),guiGetText(profile['birthday_d']),guiGetText(profile['birthday_y']),guiGetText(profile['mail_memo']))
triggerServerEvent('onSaveSettings',localPlayer)
end
end
)
addEventHandler('onLoginLoad',root,
function(name,month,day,year,mail)
guiSetText(profile['name_memo'],name)
guiSetText(profile['birthday_m'],month)
guiSetText(profile['birthday_d'],day)
guiSetText(profile['birthday_y'],year)
guiSetText(profile['mail_memo'],mail)
end
)
Server:
local table = executeSQLQuery("CREATE TABLE IF NOT EXISTS Profile ( player TEXT, name TEXT, month NUMBER, day NUMBER, year NUMBER, mail TEXT )")
addEvent('onSaveOutput',true)
addEvent('onClickSave',true)
addEventHandler('onSaveOutput',root,
function()
outputChatBox('#ABCDEF* #ffffffYour settings have been saved!',source,255,255,255,true)
end
)
addEventHandler('onPlayerLogin',root,
function()
local select = executeSQLQuery("SELECT * FROM Profile WHERE player = '"..getAccountName(getPlayerAccount(source)).."'")
if not result or #result == 0 then
local result = executeSQLQuery("INSERT INTO Profile VALUES ( '"..getAccountName(getPlayerAccount(source)).."', '', 'Month', 'Day', 'Year', '' )")
else
local resultt = executeSQLQuery("SELECT * FROM Profile WHERE player = "..getAccountName(getPlayerAccount(source)).."'")
triggerClientEvent('onLoginLoad',source,tostring(resultt[1]['name']),tostring(resultt[1]['month']),tostring(resultt[1]['day']),tostring(resultt[1]['year']),tostring(resultt[1]['mail']))
end
end
)
addEventHandler('onClickSave',root,
function(thePlayer,name,month,day,year,mail)
local update = executeSQLQuery("UPDATE Profile SET name='"..name.."', month='"..month.."', day='"..day.."', year='"..year.."', mail='"..mail.."' WHERE player='"..getAccountName(getPlayerAccount(source)).."'")
triggerEvent('onSaveOutput',source)
end
)
I get no errors.
