Habe mein save script ausversehen gelösche und muss es jetzt neu schreiben soo jetzt bekomme ich ein ERROR
ERROR:
[16:42:49] WARNING: Server\Saver\settings.lua:33:
dbExc failed; Unknown column 'Blackputty' in 'field list'
er speichert denn namen nicht kp warum
Lua
mysqlhost1 = "localhost"
mysqluser1 = "root"
mysqlpassword1 = ""
mysqlhandler1 = "wojtek"
addEventHandler("onResourceStart", getResourceRootElement(), function()
handler = dbConnect("mysql", "dbname="..mysqlhandler1..";host="..mysqlhost1, mysqluser1, mysqlpassword1, "autoreconnect=1")
if handler then
outputDebugString ('Datenbank-Connect')
else
outputDebugString ("Datenbank-ERROR")
end
end)
function saveAccounts ()
local serial = getPlayerSerial ( source )
local Spielername = getPlayerName ( source )
local x,y,z = getElementPosition( source )
local i = getElementInterior( source )
local d = getElementDimension( source )
local skin = getPedSkin ( source )
local money = getPlayerMoney ( source )
local health = getElementHealth ( source )
local armor = getPedArmor ( source )
local wanted = getPlayerWantedLevel ( source )
local q = dbQuery(handler,"SELECT * FROM `accounts` WHERE `serial` = '".. serial .."'")
local result, rows = dbPoll(q, -1)
if rows == 0 then
dbExec( handler, "INSERT INTO accounts ( name ,`serial` , x, y, z, intterior, demension, skin, money, health, armor, wanted ) VALUES ( ".. Spielername ..",'" .. serial .. "', " .. x .. ", " .. y .. ", " .. z .. "," .. i .. ", " .. d .. "," .. skin .. "," .. money .. ", ".. health ..", ".. armor ..", " .. wanted .. " )" )
else
res = dbExec( handler, "UPDATE `accounts` SET name = ".. Spielername ..",x = ".. x ..", y = ".. y ..", z = ".. z ..", intterior = ".. i ..", demension = ".. d ..", skin = ".. skin ..", money = ".. money ..", health = ".. health ..", armor = ".. armor ..", wanted = ".. wanted .." WHERE `serial` = '"..serial.."'")
end
end
function loadAccounts ()
local serial = getPlayerSerial ( source )
local result = dbQuery( handler ,"SELECT * FROM `accounts` WHERE `serial` = ?", serial)
if result then
local row = dbPoll(result, -1)[1]
setElementPosition ( source, row.x, row.y, row.z)
setElementInterior ( source, row.intterior )
setElementDimension ( source, row.demension )
setPedSkin ( source, row.skin )
setPlayerMoney ( source, row.money )
setElementHealth ( source, row.health)
setPedArmor ( source, row.armor )
setPlayerWantedLevel ( source, row.wanted )
setPlayerName ( source, row.name )
end
end
addEventHandler ( "onPlayerJoin", getRootElement(), loadAccounts )
addEventHandler ( "onPlayerQuit", getRootElement(), saveAccounts )
Alles anzeigen