Hallo,
seid dem Upate 1.3.4 funktioniert keine Md5 Verschlüsselung mehr. Deswegen habe ich es mit sha256 ausprobiert, ging aber auch nicht.
Hier das Skript: Achja, registrieren kann ich mich ohne Probleme, aber beim Login sagt er mir ,dass mein Passwort falsch ist.
Lua
addEvent("onRegister", true)
addEvent("onLogin", true)
function resourceStart ()
handler = dbConnect("mysql", "dbname=register_login;host=127.0.0.1","root", "")
if handler then
outputServerLog("----------------------------------------------------")
outputServerLog("Verbindung zum MySQL Server erfolgreich hergestellt!")
outputServerLog("----------------------------------------------------")
outputConsole("----------------------------------------------------")
outputConsole("Verbindung zum MySQL Server erfolgreich hergestellt!")
outputConsole("----------------------------------------------------")
else
outputServerLog("-------------------------------------------")
outputServerLog("Verbindung zum MySQL Server fehlgeschlagen!")
outputServerLog("-------------------------------------------")
outputConsole("-------------------------------------------")
outputConsole("Verbindung zum MySQL Server fehlgeschlagen!")
outputConsole("-------------------------------------------")
end
end
addEventHandler("onResourceStart", getResourceRootElement(), resourceStart)
function onRegister( username, password )
local sha256password = sha256(password)
local sql = dbQuery(handler,"SELECT * FROM userdata WHERE username = '"..username.."'")
local result,num_rows = dbPoll(sql,-1)
if num_rows == 0 then
dbExec(handler,"INSERT INTO userdata (username, password) VALUES ( '"..username.."','"..sha256password.."')")
outputChatBox("[Info] You have successfully registered!",source,0,125,0)
setElementData(source,"aLoggedIn",true)
else
outputChatBox("[Info] It already exist an Account with this username!"..username.." !",source,125,0,0)
end
end
addEventHandler("onRegister",getRootElement(), onRegister )
function onLogin( username, password )
local sha256password = sha256(password)
local sql = dbQuery(handler,"SELECT * FROM userdata WHERE username = '"..username.."' AND password = '"..sha256password.."'")
local result,num_rows = dbPoll(sql,-1)
if num_rows == 1 then
outputChatBox("[Info] You have successfully logged in !",source,0,125,0)
outputChatBox("[Info] "..username.."( "..string.gsub(getPlayerName(source), "#%x%x%x%x%x%x", "").." ) has logged in!",getRootElement(),255,132,0)
triggerClientEvent(source,"close_register_login",source)
setElementData(source,"aLoggedIn",true)
else
outputChatBox("[Info] Your username or password is wrong !",source,125,0,0)
end
end
addEventHandler("onLogin",getRootElement(), onLogin)mfg