local gMysqlHost = "host1"
local gMysqlUser = "user1"
local gMysqlPass = "pw1"
local gMysqlDatabase = "database 1"
handler = nil
playerUID = {}
playerUIDName = {}
local gMysqlHostExt = "host2"
local gMysqlUserExt = "user2"
local gMysqlPassExt = "pw2"
local gMysqlDatabaseExt = "database 2"
handler2 = nil
function MySQL_Startup ( )
handler = dbConnect ( "mysql", "dbname=".. gMysqlDatabase .. ";host="..gMysqlHost..";port=3306", gMysqlUser, gMysqlPass )
handler2 = dbConnect ( "mysql", "dbname=".. gMysqlDatabaseExt .. ";host="..gMysqlHostExt..";port=3306", gMysqlUserExt, gMysqlPassExt )
if not handler then
outputDebugString("[MySQL_Startup] Couldn't run query: Unable to connect to the MySQL server!")
outputDebugString("[MySQL_Startup] Please shutdown the server and start the MySQL server!")
return
end
if not handler2 then
outputDebugString("[MySQL_Startup] Couldn't run query: Unable to connect to the MySQL server!")
outputDebugString("[MySQL_Startup] Please shutdown the server and start the MySQL server!")
return
end
local result = dbPoll ( dbQuery ( handler, "SELECT UID, Name FROM ??", "players" ), -1 )
for i=1, #result do
local id = tonumber ( result[i]["UID"] )
local name = result[i]["Name"]
playerUID[name] = id
playerUIDName[id] = name
end
playerUIDName[0] = "none"
playerUID["none"] = 0
end
MySQL_Startup()
Alles anzeigen
Unter den logs würde ich die Zeile 43 auf "dbExec ( handler2, "INSERT INTO ?? (??,??,??) VALUE (?,?,?)", "logs", "Typ", "Text", "Timestamp", logsArray[i][1], logsArray[i][2], logsArray[i][3] )" abändern