Ich bekomme die ganze zeit diese error hier:
ERROR: registersystem/login_register/server_login.lua:24: attempt to call global 'mysql_query' (a nil value)
was muss ich da machen?
Lua
function checkPlayerInDatabase ()
if (not isElement(client)) then return; end
local sql = mysql_query(handler,"SELECT * FROM user_data WHERE Benutzername = '"..getPlayerName(client).."'");
if sql then
local check = mysql_num_rows(sql);
if check == 1 then
triggerClientEvent(client,"openSimuGuis",root);
triggerClientEvent(client,"changeTab",root,"login");
elseif check == 0 then
triggerClientEvent(client,"openSimuGuis",root);
triggerClientEvent(client,"changeTab",root,"register");
end
end
mysql_free_result(sql);
end
addEvent("checkPlayerInDatabase",true);
addEventHandler("checkPlayerInDatabase",root,checkPlayerInDatabase);
function login_player (passwort)
local pw = md5(passwort);
if (not isElement(client)) then return; end
local sql = mysql_query(handler,"SELECT * FROM user_data WHERE Benutzername = '"..getPlayerName(client).."' AND Passwort = '"..pw.."'");
if sql then
local check = mysql_num_rows(sql);
if check == 1 then
local row = mysql_fetch_assoc(sql)
setElementData(client, "Kills", row.Kills)
setElementData(client, "Deaths", row.Deaths)
triggerClientEvent(client,"closeSimuGuis",root);
outputChatBox("Welcome back, "..getPlayerName(client).."!",client,0,255,0);
else
outputChatBox("Wrong password!",client,255,0,0);
end
end
mysql_free_result(sql);
end
addEvent("loginPlayer",true);
addEventHandler("loginPlayer",root,login_player);
function save_player()
local sql = mysql_query(handler,"UPDATE user_data SET `Kills` = "..tostring(getElementData(source, "Kills") or 0)..", `Deaths` = "..tostring(getElementData(source, "Deaths") or 0).." WHERE Benutzername = '"..getPlayerName(client).."';");
mysql_free_result(sql)
end
addEventHandler("onPlayerQuit", root, save_player)
function register_player (username,passwort)
local pw = md5(passwort);
if (not isElement(client)) then return; end
local sql = mysql_query(handler,"INSERT INTO `user_data`(`Benutzername`, `Passwort`, `Serial`, `Kills`, `Deaths`) VALUES ('"..getPlayerName(client).."','"..pw.."', '"..getPlayerSerial(client).."', 0, 0);");
if sql then
triggerClientEvent(client,"closeSimuGuis",root);
outputChatBox("Welcome to our simulator server!",client,0,255,0);
end
mysql_free_result(sql);
end
addEvent("registerPlayer",true);
addEventHandler("registerPlayer",root,register_player);
Alles anzeigen