Hallo,
das folgende Skript hat irgendwie Probleme sich mit MySQL zu verbinden und hab keine Ahnung wieso, die Datenbank an sich verbindet mit anderen Sachen Problemlos und die Tabellen sind auch vorhanden.
Fehlermeldungen:
ERROR: server.lua:3: dbConnect failed; Can't connect to local MySQL server through socket '' (111)
WARNING: server.lua:4: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
WARNING: server.lua:5: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
ERROR: server.lua:6: attempt to compare number with nil
Lua
db = dbConnect("mysql", "dbname=ZENSIERT;host=ZENSIERT", "ZENSIERT", "ZENSIERT")
function initGarages()
local qh = dbQuery( db, "SELECT * FROM garages")
local result, num_affected_rows, errmsg = dbPoll ( qh, -1 )
if num_affected_rows > 0 then
for result, row in pairs ( result ) do
local garage = createObject(17950, row["x"], row["y"], row["z"], 0, 0, row["rot"])
local gate = createObject(7891, row["xg"], row["yg"], row["zg"], 0, 0, row["rot"]-90)
if row["owner"] == "none" then
local info = createPickup(row["xg"], row["yg"], row["zg"]+3, 3, 1274, 0)
setElementData(gate, "info", info)
end
setElementDoubleSided(gate, true)
setObjectScale ( gate, 0.872)
setElementData(gate, "isGarage", true)
setElementData(gate, "garageState", false)
setElementData(gate, "garageIsMoving", false)
setElementData(gate, "garageOwner", row["owner"])
setElementData(gate, "garageCost", row["cost"])
table.insert(garages, {garage, gate, row["x"], row["y"], row["z"], row["xg"], row["yg"], row["zg"]})
local garageMarker = createMarker(row["x"], row["y"], row["z"], "corona", 4.75, 0, 0, 0, 0)
addEventHandler("onMarkerHit", garageMarker, function(element) setElementData(element, "isInsideGarage", true) end)
addEventHandler("onMarkerLeave", garageMarker, function(element) setElementData(element, "isInsideGarage", false) end)
end
outputDebugString ("[Garagensystem] "..num_affected_rows.." Garage(s) loaded.")
else
outputDebugString ("[Garagensystem] 0 Garages loaded.")
end
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), initGarages)