Beiträge von PlodyIce

gMysqlHost = "XXX"
gMysqlUser = "XXX"
gMysqlPass = "XXX"
gMysqlDatabase1 = "mta-reallife"
gMysqlDatabase2 = "mta-reallife"


function MySQL_Startup()
handler = mysql_connect(gMysqlHost, gMysqlUser, gMysqlPass, gMysqlDatabase1)
if( not handler) then
outputDebugString("Couldn't run query: Unable to connect to the MySQL server!")
outputDebugString("Please shutdown the server and start the MySQL server!")
end
handler_old = mysql_connect(gMysqlHost, gMysqlUser, gMysqlPass, gMysqlDatabase2)
if( not handler_old) then
outputDebugString("Couldn't run query: Unable to connect to the MySQL server!")
outputDebugString("Please shutdown the server and start the MySQL server!")
end
end
MySQL_Startup()


function MySQL_End()
mysql_close(handler)
end


function MySQL_GetVar(tablename, feldname, bedingung)
local result = mysql_query(handler, "SELECT "..feldname.." from "..tablename.." WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[GetVar]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
if(mysql_num_rows(result) > 0) then
local dsatz = mysql_fetch_assoc(result)
local savename = feldname
mysql_free_result(result)
return tonumber(dsatz[feldname])
else
mysql_free_result(result)
return false
end
end
end


function MySQL_GetString(tablename, feldname, bedingung)
local result = mysql_query(handler, "SELECT "..feldname.." from "..tablename.." WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[GetString]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
if(mysql_num_rows(result) > 0) then
local dsatz = mysql_fetch_assoc(result)
local savename = feldname
mysql_free_result(result)
return dsatz[feldname]
else
mysql_free_result(result)
return false
end
end
end


function MySQL_SetVar(tablename, feldname, var, bedingung)
if var then
local result = mysql_query(handler, "UPDATE "..tablename.." SET "..feldname.." = "..var.." WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[SetVar]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
mysql_free_result(result)
return false
end
end
end


function MySQL_DelRow(tablename, bedingung)
local result = mysql_query(handler, "DELETE FROM "..tablename.." WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[DelRow]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
mysql_free_result(result)
return false
end
outputDebugString ("geloescht?!")
end


function MySQL_SetString(tablename, feldname, var, bedingung)
if var and bedingung then
local result = mysql_query(handler, "UPDATE "..tablename.." SET "..feldname.." = '"..var.."' WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[SetString]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
mysql_free_result(result)
return false
end
end
end


function MySQL_DatasetExist(tablename, bedingung)
local result = mysql_query(handler, "SELECT * from "..tablename.." WHERE "..bedingung)
if( not result) then
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[DatasetExist]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
if(mysql_num_rows(result) > 0) then
mysql_free_result(result)
return true
else
mysql_free_result(result)
return false
end
end
end


function MySQL_Safe ( string )
return MySQL_Save ( string )
end


function MySQL_Save ( string )


if string then
return mysql_escape_string ( handler, string )
end
end


--[[function MySQL_Save ( string )
if(not(string) or type(string)~="string")then
outputDebugString("ErrorHelp save_message: "..debug.traceback())
end
return mysql_escape_string ( handler, string )




end
]]
function mysql_la_query ( query )


if stringSaveFind(query, "Adminlevel") then
outputDebugString ( "Query: "..query)
end
local result = mysql_query ( handler, query )
local oldres = result
if not result then
outputDebugString ( "Error: Invalid Query: "..tostring ( query ) )
outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
outputLog ( "[LaQuery]: Error executing the query: (".. mysql_errno(handler) .. ") " .. mysql_error(handler), "mysql" )
else
mysql_free_result ( result )
end
return oldres
end


function stringSaveFind ( arg1, arg2 )


if arg1 and arg2 then
return string.find ( arg1, arg2 )
else
return false
end
end


--addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()),MySQL_Startup )
addEventHandler ( "onResourceStop", getResourceRootElement(getThisResource()),MySQL_End)
[/spoiler]