Hallo Community,
ich habe folgendes Problem und ich weiß nicht wieso das nicht funktioniert, wie ich es möchte 
In der Funktion ab Zeile 57 wird eigentlich ein Bool den Variablen "register" sowie "login" zugewiesen, aber irgendwie wird das in Zeile 42 bis 50 nicht verwendet.
Es passiert nichts wenn ich das Event auslöse.
Im Debugscript 3 steht nichts & ich habe schonmal testweise eine outputchatbox über die Abfrage in Zeile 42 gepackt, diese wurde dann ausgegeben.
client
Lua
local guivar = 0
local register = nil
local login = nil
function renderDX()
local sx,sy = guiGetScreenSize()
local px,py = 1920,1080
local x,y = (sx/px), (sy/py)
dxDrawImage(x*0, y*0, x*1920, y*1080, "bg.png", 0, 0, 0, tocolor(255, 255, 255, 255), false)
dxDrawImage(x*1319, y*888, x*205, y*62, "login.png", 0, 0, 0, tocolor(255, 255, 255, 255), false)
dxDrawText("Passwort:", x*1093, y*766, x*1245, y*813, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", false, false, false, true, false)
dxDrawText("Passwort:", x*1093, y*764, x*1245, y*811, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", false, false, false, true, false)
dxDrawText("Passwort:", x*1091, y*766, x*1243, y*813, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", false, false, false, true, false)
dxDrawText("Passwort:", x*1091, y*764, x*1243, y*811, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", false, false, false, true, false)
dxDrawText("Passwort:", x*1092, y*765, x*1244, y*812, tocolor(255, 255, 255, 255), 3.00, "default-bold", "left", "center", false, false, false, true, false)
dxDrawText("Username:", x*1093, y*692, x*1245, y*739, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", true, true, false, true, false)
dxDrawText("Username:", x*1093, y*690, x*1245, y*737, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", true, true, false, true, false)
dxDrawText("Username:", x*1091, y*692, x*1243, y*739, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", true, true, false, true, false)
dxDrawText("Username:", x*1091, y*690, x*1243, y*737, tocolor(0, 0, 0, 255), 3.00, "default-bold", "left", "center", true, true, false, true, false)
dxDrawText("Username:", x*1092, y*691, x*1244, y*738, tocolor(255, 255, 255, 255), 3.00, "default-bold", "left", "center", true, true, false, true, false)
dxDrawText(getPlayerName(getLocalPlayer()), x*1319, y*691, x*1471, y*738, tocolor(255, 255, 255, 255), 2.50, "default-bold", "left", "center", true, true, false, true, false)
end
function createGui()
if ( guivar == 1 ) then return end
local sx,sy = guiGetScreenSize()
local px,py = 1920,1080
local x,y = (sx/px), (sy/py)
guivar = 1
showCursor(true)
addEventHandler("onClientRender", getRootElement(), renderDX)
passwort = guiCreateEdit(x*1319, y*767, x*207, y*45, "Passwort", false)
guiEditSetMasked(passwort, true)
triggerServerEvent("onDatenbankCheck", getLocalPlayer())
addEventHandler("onClientClick", getRootElement(), function(button, state)
if isMouseOverElement(x*1319, y*888, x*205, y*62) and (state == "down" and button == "left") and guivar == 1 then
outputChatBox("test")
if register == true and login == false then
local text = guiGetText(passwort)
if text == "" then return end
triggerServerEvent("onDatenbankRegister", gMe, text)
elseif register == false and login == true then
local text = guiGetText(passwort)
if text == "" then return end
triggerServerEvent("onDatenbankLogin", gMe, text)
end
end
end)
end
addEventHandler("onClientResourceStart", getResourceRootElement(), function()
createGui()
end)
addEventHandler("onDatenbankCheckBack", getRootElement(), function(typ)
if(typ == false) then
register = true
login = false
else
register = false
login = true
end
end)
addEventHandler("onDatenbankLoginSuceed", getRootElement(), function()
destroyElement(passwort)
removeEventHandler("onClientRender", getRootElement(), renderDX)
Guivar = 0
showCursor(false)
outputChatBox("Du hast dich erfolgreich Eingeloggt!", 0, 255, 0)
fadeCamera(true)
end)
addEvent("onDatenbankCheckBack", true)
addEvent("onDatenbankLoginSuceed", true)
function isMouseOverElement(psx,psy,pssx,pssy)
if isCursorShowing() == false then
return false
end
local x,y = guiGetScreenSize()
local cx,cy = getCursorPosition()
cx,cy = cx*x,cy*y
if cx >= psx and cx <= psx+pssx and cy >= psy and cy <= psy+pssy then
return true,cx,cy
else
return false
end
endserver
Lua
local mysqlip = "localhost"
local mysqlname = "root"
local mysqlpw = ""
local mysqldatenbank = "csgo"
handler = mysql_connect(mysqlip, mysqlname, mysqlpw, mysqldatenbank)
addEventHandler("onDatenbankCheck", getRootElement(), function()
local result = mysql_query( handler, "SELECT * FROM accounts WHERE NAME = '"..getPlayerName(source).."';" )
if(result and mysql_num_rows( result ) > 0) then
triggerClientEvent(source, "onDatenbankCheckBack", source, true)
else
triggerClientEvent(source, "onDatenbankCheckBack", source, false)
end
end)
addEventHandler("onDatenbankRegister", getRootElement(), function(passwort)
if not(passwort) then return end
local newpw = md5(passwort)
local result = mysql_query(handler, "INSERT INTO accounts ( NAME, PASSWORT ) VALUES ( '"..getPlayerName(source).."', '"..newpw.."' );")
if(result) then
outputChatBox("Du hast dich Erfolgreich Registriert!", source, 0, 255, 0)
triggerEvent("onDatenbankCheck", source)
else
outputChatBox("Fehler beim Registrieren!", source, 255, 0, 0)
end
end)
addEventHandler("onDatenbankLogin", getRootElement(), function(passwort)
local result = mysql_query( handler, "SELECT * FROM accounts WHERE NAME = '"..getPlayerName(source).."' AND PASSWORT = '"..md5(passwort).."';" )
if(result and mysql_num_rows( result ) > 0) then
triggerClientEvent(source, "onDatenbankLoginSuceed", source)
local row = mysql_fetch_assoc(result)
setElementData(source, "kills", tonumber(row['KILLS']) or 0)
setElementData(source, "tode", tonumber(row['TODE']) or 0)
setElementData(source, "assists", tonumber(row['ASSTISTS']) or 0)
addEventHandler("onElementDataChange", source, function(theData, oldValue)
local newdata = getElementData(source, theData)
if(theData == "kills") then
mysql_query(handler, "UPDATE accounts SET KILLS = '"..newdata.."' WHERE NAME = '"..getPlayerName(source).."';")
end
end)
addEventHandler("onElementDataChange", source, function(theData, oldValue)
local newdata = getElementData(source, theData)
if(theData == "tode") then
mysql_query(handler, "UPDATE accounts SET TODE = '"..newdata.."' WHERE NAME = '"..getPlayerName(source).."';")
end
end)
addEventHandler("onElementDataChange", source, function(theData, oldValue)
local newdata = getElementData(source, theData)
if(theData == "assists") then
mysql_query(handler, "UPDATE accounts SET ASSISTS = '"..newdata.."' WHERE NAME = '"..getPlayerName(source).."';")
end
end)
else
outputChatBox("Dein Passwort ist nicht richtig oder dein Account exestiert nicht!", source, 255, 0, 0)
end
end)
addEvent("onDatenbankCheck", true)
addEvent("onDatenbankRegister", true)
addEvent("onDatenbankLogin", true)