mysql_error 1054 onknown column '452' in 'field list'
mysql_error 1054 onknown column '0' in 'field list'
mysql_error 1054 onknown column '0' in 'field list'
mysql_error 1054 onknown column '600' in 'field list'
452 = Geld
0 = Fraktion
0 = Rang
600 = Spielstunden(in Sec)
Du meinst mysql_errno() ?
Wenn ja ist es der oben genannte Fehler 1054
Hilft leider nicht. Immernoch die gleiche Fehlermeldung.
Update:
Habe den Code geändert:
function setMysqlData (player, data,value)
local pname = getPlayerName(player)
local sql = mysql_query(handler,"UPDATE `user` SET `"..data.."` = `"..value.."` WHERE `Nick` = '"..pname.."'")
if sql then
return true
else
outputServerLog("Mysql Error"..mysql_errno(handler))
return false
end
mysql_free_result(sql)
endnun bekomme ich die Fehlermeldung
Mysql Error1054
Mysql Error1054
Mysql Error1054
Mysql Error1054
Hier mal alle meine Scripts:
register_server.lua
exports.scoreboard:scoreboardAddColumn( "Spielzeit" )
function PlayerCheck()
local player = source
local pname = getPlayerName(player)
local sql = mysql_query(handler, "SELECT * FROM `user` WHERE `Nick` = '"..pname.."'")
if sql then
local run = mysql_num_rows(sql)
if run == 1 then
outputChatBox("Account gefunden! Willkommen zurück!")
triggerClientEvent(player,"openLogin",player)
elseif run == 0 then
triggerClientEvent(player,"showRegister",player)
end
else
outputServerLog("MySQL Error "..mysql_errno(handler))
end
mysql_free_result(sql)
end
addEvent("PlayerCheck",true)
addEventHandler("PlayerCheck",getRootElement(),PlayerCheck)
function register_func (player,password)
local password = md5(password)
local sql = mysql_query(handler,"INSERT INTO `user`(`Nick`, `Passwort`) VALUES ('"..getPlayerName(player).."','"..password.."')")
if sql then
spawnThePlayer(player)
triggerClientEvent(player,"closeRegister",player)
else
outputServerLog("Mysql Error"..mysql_errno(handler))
end
mysql_free_result(sql)
end
addEvent("register_func",true)
addEventHandler("register_func",getRootElement(),register_func)
function login_func ( player,password)
local password = md5(password)
local sql = mysql_query(handler,"SELECT * FROM `user` WHERE `Nick` = '"..getPlayerName(player).."' AND `Passwort` = '"..password.."'")
if sql then
local run = mysql_num_rows(sql)
if run == 1 then
triggerClientEvent(player,"closelogin",player)
spawnThePlayer(player)
else
outputChatBox("Das eingegebene Passwort ist falsch!",125,0,0)
end
else
outputServerLog("Mysql Error"..mysql_errno(handler))
end
mysql_free_result(sql)
end
addEvent("login_func",true)
addEventHandler("login_func",getRootElement(),login_func)
function saveData ( )
local player = source
if getElementData(player,"isLoggedIn") == true then
local pname = getPlayerName(player)
setMysqlData(player,"Geld",getPlayerMoney(player))
setMysqlData(player,"Fraktion",getElementData(player,"Fraktion"))
setMysqlData(player,"Rang",getElementData(player,"Rang"))
setMysqlData(player,"Zeit",getElementData(player,"playtime"))
outputDebugString("Daten fuer den Spieler "..pname.." wurden gespeichert!")
killTimer(_G["onlineTimer"..getPlayerName(player)])
end
end
addEventHandler("onPlayerQuit",getRootElement(),saveData)register_client.lua
cp = getLocalPlayer()
pw = password
function centerWindow(center_window)
local screenW,screenH=guiGetScreenSize()
local windowW,windowH=guiGetSize(center_window,false)
local x,y = (screenW-windowW)/2,(screenH-windowH)/2
guiSetPosition(center_window,x,y,false)
end
----------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
------------------------------------------------------ Register ------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
-- Registrierungsfenster erstellen
register = {
edit = {},
button = {},
label = {},
window = {},
}
register.window[1] = guiCreateWindow(372, 230, 297, 173, "Register", false)
centerWindow(register.window[1])
guiWindowSetSizable(register.window[1], false)
register.label[1] = guiCreateLabel(10, 32, 281, 21, "Willkommen auf dem Scripting Test Server by Blue", false, register.window[1])
register.label[2] = guiCreateLabel(10, 53, 123, 18, "Username", false, register.window[1])
register.label[3] = guiCreateLabel(158, 53, 123, 18, "Passwort", false, register.window[1])
register.edit[1] = guiCreateEdit(9, 77, 125, 29, "", false, register.window[1])
register.edit[2] = guiCreateEdit(156, 74, 125, 29, "", false, register.window[1])
register.button[1] = guiCreateButton(23, 113, 248, 44, "Register", false, register.window[1])
guiEditSetMasked(register.edit[2], true)
guiSetVisible(register.window[1],false)
-- Registrierungsfenster anzeigen
function showRegister ( )
guiSetInputEnabled(true)
showCursor(true)
guiSetVisible(register.window[1],true)
--guiSetText(register.label[2]," Username : "..getPlayerName(cp))
end
addEvent ("showRegister",true)
addEventHandler("showRegister",getRootElement(),showRegister)
-- Registrierungsfenster schließen
function closeRegister ( )
guiSetInputEnabled(false)
showCursor(false)
guiSetVisible(register.window[1],false)
end
addEvent("closeRegister",true)
addEventHandler("closeRegister",getRootElement(),closeRegister)
-- Klick auf den Registrieren Button
function onKlickRegister ()
local pw = guiGetText(register.edit[2])
if pw ~= "" then
if #pw >= 6 then
triggerServerEvent("register_func",cp,cp,pw)
else
outputChatBox("Dein Passwort muss mindestens 6 Zeichen Lang sein!",125,0,0)
end
end
end
addEventHandler("onClientGUIClick",register.button[1],onKlickRegister)
-- Spielername überprüfen lassen
function callServerForRegister ()
triggerServerEvent("PlayerCheck",cp,cp)
end
addEventHandler("onClientResourceStart",getResourceRootElement(),callServerForRegister)
----------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------- Login -------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------
login = {
edit = {},
button = {},
label = {},
window = {},
}
login.window[1] = guiCreateWindow(372, 230, 297, 173, "LoginPanel", false)
guiWindowSetSizable(login.window[1], false)
centerWindow(login.window[1])
login.button[1] = guiCreateButton(44, 200, 337, 51, "Login", false, login.window[1])
login.label[2] = guiCreateLabel(10, 32, 281, 21, "Willkommen auf dem Scripting Test Server by Blue", false, login.window[1])
login.label[3] = guiCreateLabel(10, 53, 123, 18, "Username", false, login.window[1])
login.label[4] = guiCreateLabel(158, 53, 123, 18, "Password", false, login.window[1])
login.edit[3] = guiCreateEdit(156, 74, 125, 29, "", false, login.window[1])
guiEditSetMasked(login.edit[3], true)
guiSetVisible(login.window[1],false)
function openLogin ()
guiSetInputEnabled(true)
showCursor(true)
guiSetVisible(login.window[1],true)
--guiSetText("")
end
addEvent("openLogin",true)
addEventHandler("openLogin",getRootElement(),openLogin)
function onKlickLogin ()
local pw = guiGetText(login.edit[3])
if pw ~= "" then
triggerServerEvent("login_func",cp,cp,pw)
end
end
addEventHandler("onClientGUIClick",login.button[1],onKlickLogin)
function closelogin ()
guiSetInputEnabled(false)
showCursor(false)
guiSetVisible(login.window[1],false)
end
addEvent("closelogin",true)
addEventHandler("closelogin",getRootElement(),closelogin)_____________________________________________________________________
spawn.lua
function GiveTimePlayer ( player )
setElementData(player,"playtime",getElementData(player,"playtime") + 1)
local playtime = getElementData(player,"playtime")
playtime = math.floor(playtime /60).." : "..(playtime - math.floor(playtime / 60) * 60)
setElementData(player,"Spielzeit",playtime)
end
function refreshTime (player)
local playtime = getElementData(player,"playtime")
playtime = math.floor(playtime /60).." : "..(playtime - math.floor(playtime / 60) * 60)
setElementData(player,"Spielzeit",playtime)
end
function spawnThePlayer ( player )
setElementData(player,"isLoggedIn",true)
spawnPlayer(player,1292.6999511719,171.10000610352,20.5)
fadeCamera(player,true)
setCameraTarget(player,player)
setPlayerMoney(player,getMysqlData(player,"Geld"))
setElementData(player,"Fraktion",getMysqlData(player,"Fraktion"))
setElementData(player,"Rang",getMysqlData(player,"Rang"))
setElementData(player,"playtime",getMysqlData(player,"Zeit"))
refreshTime( player)
_G["onlineTimer"..getPlayerName(player)] = setTimer(GiveTimePlayer,60000,-1,player)
end
mysql_connect.lua
-- Connect zur MySQL Datenbank ( "hostname", "Benutzer", "Passwort", "Datenbank" )
handler = mysql_connect("localhost", "root", "123456", "bluereallife")
if ( not handler ) then -- Falls der Connect fehlschlägt
outputDebugString("Kann keine Verbindung zum MySQL Server herstellen!")
else -- Beendet den Connect zum Server
outputServerLog("|-------------------------------------------------|")
outputServerLog("|-- Verbindung zur Datenbank wurde Hergestellt! --|")
outputServerLog("|-------------------------------------------------|")
end
function getMysqlData (player, data)
local pname = getPlayerName(player)
local sql = mysql_query(handler, "SELECT * FROM `user` WHERE `Nick` = '"..pname.."'")
if sql then
local data2 = mysql_fetch_assoc(sql)
return data2[data]
else
outputServerLog("Mysql Error"..mysql_errno(handler))
return nil
end
mysql_free_result(sql)
end
function setMysqlData (player, data,value)
local pname = getPlayerName(player)
local sql = mysql_query(handler, "UPDATE 'user' SET '"..data.."'='"..value.."' WHERE 'Nick'='"..pname.."'")
if sql then
return true
else
outputServerLog("Mysql Error"..mysql_errno(handler))
return false
end
mysql_free_result(sql)
endmeta.xml
<meta>
<info author="TheLPEXP" type="gamemode" name="Reallife" description="German Reallife" />
<!-- Das Script !mysql_connect" immer als erstes starten lassen !-->
<script src="mysql\mysql_connect.lua" type="server" />
<!-- Ressourcen ab hier einfügen !-->
<script src="spawn.lua" />
<script src="chat.lua" />
<script src="noobfahrraeder.lua" />
<script src="register\register_client.lua" type="client" />
<script src="register\register_server.lua" type="server" />
</meta>//Beiträge zusammengefügt aufgrund Doppelposts | AlexanderIBK
Hallo Leute.
Seit heute mittag hab ich das Problem das meine Daten nichtmehr in der MySQL Datenbank gespeichert werden können.
function GiveTimePlayer ( player )
setElementData(player,"playtime",getElementData(player,"playtime") + 1)
local playtime = getElementData(player,"playtime")
playtime = math.floor(playtime /60).." : "..(playtime - math.floor(playtime / 60) * 60)
setElementData(player,"Spielzeit",playtime)
end
function refreshTime (player)
local playtime = getElementData(player,"playtime")
playtime = math.floor(playtime /60).." : "..(playtime - math.floor(playtime / 60) * 60)
setElementData(player,"Spielzeit",playtime)
end
function spawnThePlayer ( player )
setElementData(player,"isLoggedIn",true)
spawnPlayer(player,1292.6999511719,171.10000610352,20.5)
fadeCamera(player,true)
setCameraTarget(player,player)
setPlayerMoney(player,getMysqlData(player,"Geld"))
setElementData(player,"Fraktion",getMysqlData(player,"Fraktion"))
setElementData(player,"Rang",getMysqlData(player,"Rang"))
setElementData(player,"playtime",getMysqlData(player,"Zeit"))
refreshTime( player)
_G["onlineTimer"..getPlayerName(player)] = setTimer(GiveTimePlayer,60000,-1,player)
endfunction saveData ( )
local player = source
if getElementData(player,"isLoggedIn") == true then
local pname = getPlayerName(player)
setMysqlData(player,"Geld",getPlayerMoney(player))
setMysqlData(player,"Fraktion",getElementData(player,"Fraktion"))
setMysqlData(player,"Rang",getElementData(player,"Rang"))
setMysqlData(player,"Zeit",getElementData(player,"playtime"))
outputDebugString("Daten fuer den Spieler "..pname.." wurden gespeichert!")
killTimer(_G["onlineTimer"..getPlayerName(player)])
end
end
addEventHandler("onPlayerQuit",getRootElement(),saveData)Fehleranzeige:
Mysql Error1064
Mysql Error1064
Mysql Error1064
Mysql Error1064
Es werden keine Daten mehr in der MySQL DB gespeichert deswegen denke ich
das es dabei um die SaveData Function geht.
Schonmal danke für Hilfe jeglicher Art 
Hey Leute brauche eure Hilfe.
Habe mir heute spaßhalber angefangen ein kleines Login Register Script zu schreiben.
Doch habe mittendrin zwei Fehler die ich nicht wegkriege.
Clientseitig:
cp = getLocalPlayer
login = {
edit = {},
button = {},
label = {},
window = {},
}
login.window[1] = guiCreateWindow(372, 230, 297, 173, "Register", false)
guiWindowSetSizable(login.window[1], false)login.label[1] = guiCreateLabel(10, 32, 281, 21, "Willkommen auf dem Scripting Test Server by Blue", false, login.window[1])
login.label[2] = guiCreateLabel(10, 53, 123, 18, "Username", false, login.window[1])
login.label[3] = guiCreateLabel(158, 53, 123, 18, "Passwort", false, login.window[1])
login.edit[1] = guiCreateEdit(9, 77, 125, 29, "", false, login.window[1])
login.edit[2] = guiCreateEdit(156, 74, 125, 29, "", false, login.window[1])
login.button[1] = guiCreateButton(23, 113, 248, 44, "Register", false, login.window[1])
guiEditSetMasked(login.edit[2], true)function showRegister ( )
showCursor ( true )
guiSetVisible(login.window[1],true)
--guiSetText(login.label[2]," Username : "..getPlayerName(cp))
end
addEvent ("showRegister",true)
addEventHandler("showRegister",getRootElement(),showRegister)function onKlickRegister ()
local pw = guiGetText(login.edit[2])
if pw ~= "" then
if #pw >= 6 then
triggerServerEvent("register",cp)
else
outputChatBox("Dein Passwort muss mindestens 6 Zeichen lang sein!",125,0,0)
end
end
end
addEventHandler("onClientGUIClick",login.button[1],onKlickRegister)function callServerForLogin ()
triggerServerEvent("checkPlayerInDB",cp )
end
addEventHandler("onClientRessourceStart",getRessourceRootElement(),callServerForLogin)
Serverseitig:
function checkPlayerInDB()
local player = source
local pname = getPlayerName(player)
local sql = mysql_query(handler, "SELECT * FROM `user` WHERE `Nick` = '"..pname.."'")
if sql then
local run = mysql_num_rows(sql)
outputServerLog(run)
if run == 1 then
-- Account verfügbarelseif run == 0 then
triggerClientEvent(player,"showRegister",player)
end
else
outputChatBox("MySQL Error "..mysql_errno(handler))
end
end
addEvent("checkPlayerInDB",true)
addEventHandler("checkPlayerInDB",getRootElement(),checkPlayerInDB)function register_func ( player,password)
outputServerLog(password)
end
addEvent("register",true)
addEventHandler("register",getRootElement(),register_func)
Fehlermeldungen:
1. "ERROR: Testmode\register\register_client:43: attempt to call global 'getRessourceRootElement' (a nil Value)"
2."WARNING: Testmode\register\register_client:32: Bad argument @ 'triggerServerEvent' [Expected element at argument 2, got function]
Schnelle hilfe wäre Top
_________________________________________________________________
Sry für den Doppelpost, aber hab das Problem gelöst.
Fehler war in Zeile1 (CS) versteckt.
Vorher:
cp = getLocalPlayer
Nachher:
cp = getLocalPlayer()
Beiträge zusammengefügt aufgrund Doppelposts | AlexanderIBK