Lua
[2013-07-06 20:06:46] ERROR: [gamemodes]/play/server/mysql_connection.lua:5: attempt to call global 'mysql_connect' (a nil value)
[2013-07-06 20:06:46] ERROR: [gamemodes]/play/Carsys/carsys_server.lua:2: attempt to call global 'mysql_query' (a nil value)
Lua
outputServerLog("|-----------------------------|")
outputServerLog("| Reallife Startet |")
outputServerLog("|-----------------------------|")
handler = mysql_connect("localhost","0815_1_DB","0815","0815_1_DB")
--(Host,User,Passwort, Datenbank)
if handler then
outputServerLog("Verbindung zur Datenbank erfolgreich!")
else
outputServerLog("Konnte keine Verbindung aufbauen Grund "..mysql_error(handler))
end
function getMysqlData ( player, data )
local pname = getPlayerName(player)
local sql = mysql_query(handler,"SELECT * FROM `players` WHERE `Username` = '"..pname.."'")
if sql then
local data2 = mysql_fetch_assoc(sql)
mysql_free_result(sql)
return data2[data]
else
outputServerLog("Mysql Error"..mysql_errno(handler))
mysql_free_result(sql)
return nil
end
end
function setMysqlData ( player, data,value )
local pname = getPlayerName(player)
local sql = mysql_query(handler,"UPDATE `players` SET `"..data.."` = '"..value.."' WHERE `Username` = '"..pname.."'")
if sql then
mysql_free_result(sql)
return true
else
outputServerLog("Mysql Error"..mysql_errno(handler))
mysql_free_result(sql)
return false
end
end
function ErrorMSG( text,player)
outputChatBox(text,player,125,0,0)
end
Alles anzeigen
Lua
function createAllCarsFromTable ()
local sql = mysql_query(handler,"SELECT * FROM cardata")
local auto = 0
if sql then
local carData = mysql_fetch_assoc(sql)
while(carData) do
local Besitzer = carData["Besitzer"]
local Slot = carData["Slot"]
local X = carData["X"]
local Y = carData["Y"]
local Z = carData["Z"]
local Rotation = carData["Rotation"]
local Autoid = tonumber(carData["Autoid"])
_G["PlayerAuto"..Besitzer..Slot] = createVehicle(Autoid,X,Y,Z,0,0,Rotation,Besitzer)
autos = autos + 1
end
mysql_free_result(sql)
outputServerLog("Es wurden "..autos.." Autos gefunden in der Datenbank!")
else
outputServerLog("[Carsys Error!] "..mysql_errno(handler).."[ "..mysql_error(handler).." ] ")
end
end
createAllCarsFromTable()
Alles anzeigen
ich hab keine ahnung warum ich habes genauso gemacht wie mir es erkärt wurde