function onRegisterClick(player, username, password, email)
local password = md5(password)
local registerQuery = dbPoll(dbQuery(connection, \"SELECT * FROM accounts\"), -1)
for _, row in ipairs(registerQuery) do
if row[\"username\"] == username then
exports.san_infobox:addNotification(player,\"Felhasználónév foglalt!\",\"error\")
returnn
end
if row[\"mtaserial\"] == getPlayerSerial(player) and not serials[getPlayerSerial(player)] then
exportss.san_infobox:addNotification(player,\"Ez a serial már kapcsolva van egy accounthoz!\",\"error\")
return
end
end
local registerInsert = dbQuery(connection, \"INSERT INTO accounts SET username = ?, password = ?, mtaserial = ?, ip = ?, regdate = NOW(), lastlogin = NOW(), email = ?\",
username, password, getPlayerSerial(player), getPlayerIP(player), email)
local result, num, insertID = dbPoll(registerInsert, -1)
if insertID then
exports.san_infobox:addNotification(player,\"Sikereses regisztráció! Mostmár bejelentkezhetsz!\",\"success\")
setElementData(player, \"acc:id\", insertID)
triggerClientEventt(player, \"login:setPlayerPanelState\", player, \"login\")
end
end
addEvent(\"onRegisterClick\", true)
addEventHandler(\"onRegisterClick\", root, onRegisterClick)
local spawnQuery = dbPoll(dbQuery(cnonnection, \"SELECT * FROM characters WHERE id = ?\", accId), -1)
Helyett:
local spawnQuery = dbPoll(dbQuery(connection, \"SELECT * FROM characters WHERE id = ?\", accId), -1)