Hi all.
I tryed to do a form that sends your account to forums database on 'serveraccount' field of 'users' table.
Here's the code located at the trigger that gets triggered when you click login and entered username + password:
addEvent("rru:requestloginsite", true)
addEventHandler("rru:requestloginsite", root,
function(player, username, password)
password = mysql_query(forum_connect,"SELECT password FROM user WHERE username = '"..username)
encrypt.password = md5(password)
local useraccount = getAccountName(getPlayerAccount(player))
outputChatBox(encrypt.password)
if (encrypt.password == password) then
-- SENDING YOUR ACCOUNT TO FORUMS
outputChatBox"sending"
--mysql_query(forum_connect,"ALTER TABLE users ADD serveraccount varchar(100)")
mysql_query(forum_connect,"UPDATE users SET serveraccount = "..useraccount.." WHERE username = '"..username.."'")
else
-- FAILED SENDING YOUR ACCOUNT TO FORUMS
outputChatBox"failed"
end
end
)
The problem is that it outputs "failed". Can somebody help me, please ?
Thanks.