Attempt to call global. and etc.

supernovaa · February 23, 2016

Hi guys!

My problem's.

Thanks in advance.

__________________________________________________________________________________________________________________________________________________________

Problem

__________________________________________________________________________________________________________________________________________________________

ERROR: sg_hud\server.lua:8: attempt to call global 'food' (a nil value)

__________________________________________________________________________________________________________________________________________________________

Script

__________________________________________________________________________________________________________________________________________________________

addCommandHandler("set", function(player) 
setPedArmor ( player, 100 )  
setElementHealth(player, 100) 
setElementData(player, "food", 100) 
setElementData(player, "drink", 100) 
end) 
  
food() 
  
drink() 
  
function drink(player) 
    if getElementData(player, "logedin") then 
        setTimer(function() 
            setElementData(player, "drink", getElementData(player, "drink") - 1)         
        end, 50, 0) 
     
     
    end 
end 
  
function food(player) 
    if getElementData(player, "logedin") then 
        setTimer(function() 
            setElementData(player, "food", getElementData(player, "food") - 1)       
        end, 50, 0) 
     
     
    end 
end

Problem

 ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"]

Script

local kapcsolat = exports["mysql"]:getConnection() 
  
addEvent("updateServerTuning", true) 
addEventHandler("updateServerTuning", getRootElement(), function(veh, buzi1, buzi2, where, szam) 
local dbid = getElementData(veh, "veh:id") 
setVehicleHandling(veh, buzi2, buzi1) 
outputChatBox("MELEG MIKI MERT".. buzi2.."És".. where.. "Meg".. szam) 
dbExec(kapcsolat, "UPDATE vehicles SET ".. where .." = ? WHERE ID = ?",szam, dbid) 
  
end) 
  
function enter (theVehicle, seat) 
triggerClientEvent ( source, "playTurboSound", source) 
end 
addEventHandler ( "onPlayerVehicleEnter", getRootElement(), enter ) 
  
--[[addEvent("updateneon", true) 
addEventHandler("updateneon", getRootElement(), function(neon, veh) 
local dbid = getElementData(veh, "veh:id") 
dbExec(kapcsolat, "UPDATE jarmuvek SET neon = ? WHERE ID = ?",neon, dbid) 
end)]]-- 
  
function addUpgrade(vehicle, tuning, slot, curr) 
    if curr == 6 then 
        removeVehicleUpgrade(vehicle, slot) 
        addVehicleUpgrade(vehicle, tuning) 
        addVehicleUpgrade(vehicle, tuning+1)         
    else 
        removeVehicleUpgrade(vehicle, slot) 
        addVehicleUpgrade(vehicle, tuning)   
    end 
  
end 
addEvent("addVehicleUpgradeOptik", true) 
addEventHandler("addVehicleUpgradeOptik", getRootElement(), addUpgrade)

And

[22:25:34] SCRIPT ERROR: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery' 
[22:25:34] ERROR: Loading script failed: sg_login\server.lua:30: ')' expected (to close '(' at line 21) near 'dbQuery'

Script

local mysql = exports.mysql 
local postable = {} 
local regisztalhat = true 
  
function playerRegister(player, username, password, password2) 
    local md5password = md5(password) 
    if(password~=password2)then 
     
    triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") 
        return 
    end 
    if(string.len(username)<5)then 
        triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") 
        return 
    end 
    if(string.len(password)<5)then 
            triggerClientEvent("info", player, "A jelszó túl rövid!", "red") 
        return 
    end 
        serial = getPlayerSerial(player) 
        dbQuery(function(qh, player, username, md5password) 
            local a, b, c = dbPoll(qh, 0) 
            if b > 0 then 
                outputChatBox("Neked már van accountod") 
                regisztalhat = false 
                return 
            end          
        end, {player,username,md5password}, mysql:getConnection(), ("SELECT * FROM characters WHERE charactername='" .. safecharname .. "' AND account='" .. mysql:escape_string(id) .. "' AND cked = 0") 
         
        dbQuery(function(qh, player, username, md5password) 
            local result, rows, errorMsg = dbPoll(qh, 0) 
            if not regisztalhat then return end 
            if rows > 0 then 
                exports.sg_box:addNotification("Ez a felhasználónév már foglalt!","red") 
            else 
                local _, id = mysql:query_free("INSERT INTO accounts SET serial = '".. serial .."', username = '"..tostring(username).."', password = '"..tostring(md5password).."'", true) 
                 
                exports.sg_box:addNotification("Sikeresen regisztráltál!","green") 
            end 
        end, {player,username,md5password}, mysql:getConnection(), "SELECT * FROM accounts WHERE username = ? LIMIT 1", username) 
end 
addEvent("playerRegister", true) 
addEventHandler("playerRegister", getRootElement(), playerRegister) 
  
function playerLogin(player, username, password) 
    password = md5(password) 
  
         
        local query = mysql:singleQuery("SELECT * FROM accounts WHERE username = ? AND password = ? LIMIT 1", username, password) 
        if query then    
  
            --local querys = mysql:singleQuery("SELECT serial FROM accounts WHERE username = ? LIMIT 1", username) 
                        outputChatBox("[socialGaming] #FFFFFFSikeres bejelentkezés!",player,169,139,101,true) 
                        setElementData(player, "accountID", query.id) 
                        acc = getElementData(player, "accountID") 
                        CharSelect(acc, player) 
                        setElementData(player, "adminlevel", query.admin) 
    else 
        outputChatBox("[socialGaming] #FFFFFFSikertelen bejelentkezés!",player,177,9,45,true) 
    end  
end 
addEvent("playerLogin", true) 
addEventHandler("playerLogin", getRootElement(), playerLogin) 
  
addEvent("createCharacter", true) 
addEventHandler("createCharacter", getRootElement(), function(p, nev, kor, suly, magassag, leiras, gender, color) 
  
    acc = getElementData(p, "accountID")     
    local qh = dbQuery( mysql:getConnection(), "SELECT `charactername` FROM `karakterek` WHERE `charactername` = ?", tostring(a)) 
    local result = dbPoll ( qh, -1 ) 
    local count = 0 
    local pw 
    u = nil 
    if result then 
        for _, row in ipairs ( result ) do 
            u = string.lower(row["charactername"]) 
        end 
        if u ~= nil then  
            exports.sg_box:createSmallNotification(client,"Már van ilyen karakter név, kérlek válassz másikat!", 1) 
            return 
        end 
    end 
    dbFree( qh ) 
    local user = getElementData(client, "username") 
    qhh = dbExec( mysql:getConnection(), "INSERT INTO `karakterek` SET `charactername` = ?, `id` = ?, `skin` = 1, `kor` = ?, `suly` = ?, `magassag` = ?, `leiras` = ?, `gender` = ?,`color` = ? ", nev, acc, kor, suly, magassag, leiras, gender, color) 
    if qhh then 
        CharSelect(acc, p) 
    end 
end) 
  
local postable = {} 
  
function CharSelect(acc, source) 
    local accid = getElementData(source,"accountID") 
    local qh = dbQuery(mysql:getConnection(),"SELECT * FROM karakterek WHERE id = ? LIMIT 1", accid) 
    local result, lineNumber = dbPoll ( qh, -1 ) 
    if(result) then 
        if(lineNumber > 0) then 
            for _, rows in ipairs( result ) do 
                postable = {} 
                level = rows["level"] 
                xp = rows["xp"] 
                jatszottpercek = rows["spentTime"] 
                nev = rows["charactername"] 
                anev = rows["adminnick"]                 
                fraki = rows["faction"] 
                frakir = rows["factionrank"] 
                factionleader = rows["factionleader"]                
                skin = rows["skin"] 
                dutyskin = rows["dutyskin"]              
                induty = rows["inDuty"]  
                kor = rows["kor"]            
                suly = rows["suly"] 
                mag = rows["magassag"] 
                job = rows["job"]                
                desc = rows["leiras"] 
                gender = rows["gender"]  
                health = rows["health"] 
                bankmoney = rows["bankmoney"]                
                keszpenz = rows["keszpenz"]              
                money = rows["money"]                    
                color = rows["color"]    
                pajzs = rows["pajzs"]                    
                ehesseg = rows["ehesseg"]                    
                maxvehicles = rows["maxvehicles"]                
                hasznaltkocsislot = rows["hasznaltkocsislot"]                
                premiumPont = rows["premiumPont"]                
                adminduty = rows["adminduty"]                    
                adminlevel = rows["adminlevel"]                  
                pozicio = fromJSON(rows["pozicio"]) 
                postable = {pozicio[1],pozicio[2],pozicio[3],pozicio[4]} 
                halal = rows["isDead"] 
            end 
                setPlayerName(source, string.gsub(nev, " ", "_")) 
                setElementData(source, "charactername", nev) 
                setElementData(source, "adminduty", 0) 
                setElementData(source, "adminnick", anev)                
                spawnPlayer(source, postable[1], postable[2], postable[3], postable[4]) 
                setElementData(source, "logedin", true) 
                setElementData(source, "jatszottpercek", jatszottpercek) 
                setElementData(source, "faction", fraki) 
                setElementData(source, "factionrank", frakir)    
                setElementData(source, "factionleader", factionleader)                   
                setElementData(source, "age", kor) 
                setElementData(source, "gender", gender) 
                setElementData(source, "bankmoney", bankmoney) 
                setElementData(source, "keszpenz", keszpenz) 
                setElementData(source, "adminduty", adminduty) 
                setElementData(source, "adminlevel", adminlevel) 
                setElementData(source, "premiumPont", premiumPont) 
                setElementData(source, "xp", xp) 
                setElementData(source, "level", level) 
                if halal == 1 then 
                    setElementHealth(source, 0) 
                else 
                    setElementHealth(source, health) 
                end 
                setElementData(source, "money", money) 
                setElementData(source, "color", color) 
                setPedArmor(source, pajzs) 
                setElementData(source, "weight", suly) 
                setElementData(source, "height", mag) 
                setElementData(source, "desc", desc) 
                setElementData(source, "job:id", job) 
                setElementData(source, "ehesseg", ehesseg)                   
                setElementData(source, "maxvehicles", maxvehicles)                   
                setElementData(source, "hasznaltkocsislot", hasznaltkocsislot)                   
                setElementData(source, "normalskin", skin) 
                setElementData(source, "dutyskin", dutyskin) 
                setElementData(source, "inDuty", induty) 
                if getElementData(source, "inDuty") then 
                    actualskin =  getElementData(source, "dutyskin") 
                else 
                    actualskin = getElementData(source, "normalskin") 
                end 
                setElementModel(source, actualskin)              
--color health  ehesseg pajzs   spentTime   faction factionrank factionleader   maxVeh  maxInt               
                setCameraTarget(source) 
                triggerClientEvent(source,"succes", source) 
    else 
            triggerClientEvent(source,"characterCreation", source) 
        end 
    end 
end 
  
  
addEventHandler("onPlayerQuit", getRootElement(), function() 
    if getElementData(source, "logedin") then 
        savePlayer(source) 
    end 
end) 
  
function savePlayer(p) 
    if isElement(p) then 
        local x,y,z = getElementPosition(p) 
        local rot = getPedRotation(p) 
        local dbid = tonumber(getElementData(p, "accountID")) or 0 
        local admin = tonumber(getElementData(p, "adminlevel")) or 0 
        local position = toJSON({x,y,z,rot}) 
        local orak = getElementData(p, "jatszottpercek") or 0 
        local faction = getElementData(p, "faction") or 0 
        local hp = getElementHealth(p) 
        local bankmoney = getElementData(p, "bankmoney") 
        local keszpenz = getElementData(p, "keszpenz") 
        local money = getElementData(p, "money") 
        local armor = getPedArmor(p) 
        local ehesseg = getElementData(p, "ehesseg") 
        local skin = getElementData(p, "normalskin") 
        local duty = getElementData(p, "inDuty") 
        local dutyskin = getElementData(p, "dutyskin") 
        local job = getElementData(p, "job:id") 
        local maxvehicles = getElementData(p, "maxvehicles") or 4 
        local hasznaltkocsislot = getElementData(p, "hasznaltkocsislot") or 0 
        local premiumPont = getElementData(p, "premiumPont") or 0 
        local xp = getElementData(p, "xp") or 0 
        local level = getElementData(p, "level") or 0 
         
        dbExec(mysql:getConnection(), "UPDATE karakterek SET pozicio = ?, spentTime = ?, faction = ?, health = ?, bankmoney = ?, money = ?, pajzs = ?, ehesseg = ?, skin = ?, job = ? WHERE ID = ?", position,  spentTime, faction, hp, bankmoney, money, armor, ehesseg, skin, job,  dbid) 
        dbExec(mysql:getConnection(), "UPDATE karakterek SET maxvehicles = ?,hasznaltkocsislot = ?,premiumPont = ?, inDuty = ?, dutyskin = ?, keszpenz = ? WHERE ID = ?", maxvehicles,hasznaltkocsislot,premiumPont, duty, dutyskin,keszpenz,dbid) 
        dbExec(mysql:getConnection(), "UPDATE accounts SET admin = ? WHERE ID = ?",admin,xp,level,dbid) 
        dbExec(mysql:getConnection(), "UPDATE karakterek SET xp=?,level=? WHERE ID = ?",xp,level,dbid) 
         
    end 
end 
addEvent("savePlayer", true) 
addEventHandler("savePlayer", getRootElement(), savePlayer) 
  
function saveAllPlayer() 
    local count = 0 
    for i, p in ipairs(getElementsByType("player")) do 
        if (getElementData(p, "logedin") or false) then 
            savePlayer(p) 
            count = count + 1 
        end 
    end 
    outputDebugString("Ellett mentve "..count.." jatekos adata!") 
end 
saveAllPlayer() 
setTimer(saveAllPlayer, 1000*60*10, 0) 
addCommandHandler("saveall",saveAllPlayer) 
  
addEvent("checkPlayerBanState", true) 
addEventHandler("checkPlayerBanState", getRootElement(), 
    function(player) 
        local serial = getPlayerSerial(player) 
        local query = dbQuery(mysql:getConnection(),"SELECT * FROM banlist WHERE serial=?",serial)  
        local qh = dbPoll(query, -1) 
        local playerSerial, timeStamp, bannedBy, reason 
        if #qh > 0 then 
            for k, data in ipairs (qh) do 
                outputChatBox("Ok") 
                playerSerial = data["serial"]

Tomas · February 23, 2016

1. You're calling the function before defining it.

2. Replace

local kapcsolat = exports["mysql"]:getConnection()

with

  
addEventHandler("onResourceStart", root,  
   function(res)  
      if ( ( res == getResourceFromName("mysql") ) or ( res == getThisResource() and getResourceState(res) == "running") ) then 
         kapcsolat = exports["mysql"]:getConnection() 
      end  
    end 
)

3.

  
local mysql = exports.mysql 
local postable = {} 
local regisztalhat = true 
  
function playerRegister(player, username, password, password2) 
    local md5password = md5(password) 
    if(password~=password2)then 
    
    triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") 
        return 
    end 
    if(string.len(username)<5)then 
        triggerClientEvent("info",player,"A felhasználónév túl rövid!", "red") 
        return 
    end 
    if(string.len(password)<5)then 
            triggerClientEvent("info", player, "A jelszó túl rövid!", "red") 
        return 
    end 
        serial = getPlayerSerial(player) 
        dbQuery(function(qh, player, username, md5password) 
            local a, b, c = dbPoll(qh, 0) 
            if b > 0 then 
                outputChatBox("Neked már van accountod") 
                regisztalhat = false 
                return 
            end         
        end, {player,username,md5password}, mysql:getConnection(), "SELECT * FROM characters WHERE charactername='" .. safecharname .. "' AND account='" .. mysql:escape_string(id) .. "' AND cked = 0") 
        
        dbQuery(function(qh, player, username, md5password) 
            local result, rows, errorMsg = dbPoll(qh, 0) 
            if not regisztalhat then return end 
            if rows > 0 then 
                exports.sg_box:addNotification("Ez a felhasználónév már foglalt!","red") 
            else 
                local _, id = mysql:query_free("INSERT INTO accounts SET serial = '".. serial .."', username = '"..tostring(username).."', password = '"..tostring(md5password).."'", true) 
                
                exports.sg_box:addNotification("Sikeresen regisztráltál!","green") 
            end 
        end, {player,username,md5password}, mysql:getConnection(), "SELECT * FROM accounts WHERE username = ? LIMIT 1", username) 
end 
addEvent("playerRegister", true) 
addEventHandler("playerRegister", getRootElement(), playerRegister) 
  
function playerLogin(player, username, password) 
    password = md5(password) 
  
        
        local query = mysql:singleQuery("SELECT * FROM accounts WHERE username = ? AND password = ? LIMIT 1", username, password) 
        if query then    
  
            --local querys = mysql:singleQuery("SELECT serial FROM accounts WHERE username = ? LIMIT 1", username) 
                        outputChatBox("[socialGaming] #FFFFFFSikeres bejelentkezés!",player,169,139,101,true) 
                        setElementData(player, "accountID", query.id) 
                        acc = getElementData(player, "accountID") 
                        CharSelect(acc, player) 
                        setElementData(player, "adminlevel", query.admin) 
    else 
        outputChatBox("[socialGaming] #FFFFFFSikertelen bejelentkezés!",player,177,9,45,true) 
    end  
end 
addEvent("playerLogin", true) 
addEventHandler("playerLogin", getRootElement(), playerLogin) 
  
addEvent("createCharacter", true) 
addEventHandler("createCharacter", getRootElement(), function(p, nev, kor, suly, magassag, leiras, gender, color) 
  
    acc = getElementData(p, "accountID")    
    local qh = dbQuery( mysql:getConnection(), "SELECT `charactername` FROM `karakterek` WHERE `charactername` = ?", tostring(a)) 
    local result = dbPoll ( qh, -1 ) 
    local count = 0 
    local pw 
    u = nil 
    if result then 
        for _, row in ipairs ( result ) do 
            u = string.lower(row["charactername"]) 
        end 
        if u ~= nil then 
            exports.sg_box:createSmallNotification(client,"Már van ilyen karakter név, kérlek válassz másikat!", 1) 
            return 
        end 
    end 
    dbFree( qh ) 
    local user = getElementData(client, "username") 
    qhh = dbExec( mysql:getConnection(), "INSERT INTO `karakterek` SET `charactername` = ?, `id` = ?, `skin` = 1, `kor` = ?, `suly` = ?, `magassag` = ?, `leiras` = ?, `gender` = ?,`color` = ? ", nev, acc, kor, suly, magassag, leiras, gender, color) 
    if qhh then 
        CharSelect(acc, p) 
    end 
end) 
  
local postable = {} 
  
function CharSelect(acc, source) 
    local accid = getElementData(source,"accountID") 
    local qh = dbQuery(mysql:getConnection(),"SELECT * FROM karakterek WHERE id = ? LIMIT 1", accid) 
    local result, lineNumber = dbPoll ( qh, -1 ) 
    if(result) then 
        if(lineNumber > 0) then 
            for _, rows in ipairs( result ) do 
                postable = {} 
                level = rows["level"] 
                xp = rows["xp"] 
                jatszottpercek = rows["spentTime"] 
                nev = rows["charactername"] 
                anev = rows["adminnick"]                
                fraki = rows["faction"] 
                frakir = rows["factionrank"] 
                factionleader = rows["factionleader"]               
                skin = rows["skin"] 
                dutyskin = rows["dutyskin"]             
                induty = rows["inDuty"]  
                kor = rows["kor"]           
                suly = rows["suly"] 
                mag = rows["magassag"] 
                job = rows["job"]               
                desc = rows["leiras"] 
                gender = rows["gender"]  
                health = rows["health"] 
                bankmoney = rows["bankmoney"]               
                keszpenz = rows["keszpenz"]             
                money = rows["money"]                   
                color = rows["color"]    
                pajzs = rows["pajzs"]                   
                ehesseg = rows["ehesseg"]                   
                maxvehicles = rows["maxvehicles"]               
                hasznaltkocsislot = rows["hasznaltkocsislot"]               
                premiumPont = rows["premiumPont"]               
                adminduty = rows["adminduty"]                   
                adminlevel = rows["adminlevel"]                 
                pozicio = fromJSON(rows["pozicio"]) 
                postable = {pozicio[1],pozicio[2],pozicio[3],pozicio[4]} 
                halal = rows["isDead"] 
            end 
                setPlayerName(source, string.gsub(nev, " ", "_")) 
                setElementData(source, "charactername", nev) 
                setElementData(source, "adminduty", 0) 
                setElementData(source, "adminnick", anev)               
                spawnPlayer(source, postable[1], postable[2], postable[3], postable[4]) 
                setElementData(source, "logedin", true) 
                setElementData(source, "jatszottpercek", jatszottpercek) 
                setElementData(source, "faction", fraki) 
                setElementData(source, "factionrank", frakir)    
                setElementData(source, "factionleader", factionleader)                  
                setElementData(source, "age", kor) 
                setElementData(source, "gender", gender) 
                setElementData(source, "bankmoney", bankmoney) 
                setElementData(source, "keszpenz", keszpenz) 
                setElementData(source, "adminduty", adminduty) 
                setElementData(source, "adminlevel", adminlevel) 
                setElementData(source, "premiumPont", premiumPont) 
                setElementData(source, "xp", xp) 
                setElementData(source, "level", level) 
                if halal == 1 then 
                    setElementHealth(source, 0) 
                else 
                    setElementHealth(source, health) 
                end 
                setElementData(source, "money", money) 
                setElementData(source, "color", color) 
                setPedArmor(source, pajzs) 
                setElementData(source, "weight", suly) 
                setElementData(source, "height", mag) 
                setElementData(source, "desc", desc) 
                setElementData(source, "job:id", job) 
                setElementData(source, "ehesseg", ehesseg)                  
                setElementData(source, "maxvehicles", maxvehicles)                  
                setElementData(source, "hasznaltkocsislot", hasznaltkocsislot)                  
                setElementData(source, "normalskin", skin) 
                setElementData(source, "dutyskin", dutyskin) 
                setElementData(source, "inDuty", induty) 
                if getElementData(source, "inDuty") then 
                    actualskin =  getElementData(source, "dutyskin") 
                else 
                    actualskin = getElementData(source, "normalskin") 
                end 
                setElementModel(source, actualskin)             
--color health  ehesseg pajzs   spentTime   faction factionrank factionleader   maxVeh  maxInt              
                setCameraTarget(source) 
                triggerClientEvent(source,"succes", source) 
    else 
            triggerClientEvent(source,"characterCreation", source) 
        end 
    end 
end 
  
  
addEventHandler("onPlayerQuit", getRootElement(), function() 
    if getElementData(source, "logedin") then 
        savePlayer(source) 
    end 
end) 
  
function savePlayer(p) 
    if isElement(p) then 
        local x,y,z = getElementPosition(p) 
        local rot = getPedRotation(p) 
        local dbid = tonumber(getElementData(p, "accountID")) or 0 
        local admin = tonumber(getElementData(p, "adminlevel")) or 0 
        local position = toJSON({x,y,z,rot}) 
        local orak = getElementData(p, "jatszottpercek") or 0 
        local faction = getElementData(p, "faction") or 0 
        local hp = getElementHealth(p) 
        local bankmoney = getElementData(p, "bankmoney") 
        local keszpenz = getElementData(p, "keszpenz") 
        local money = getElementData(p, "money") 
        local armor = getPedArmor(p) 
        local ehesseg = getElementData(p, "ehesseg") 
        local skin = getElementData(p, "normalskin") 
        local duty = getElementData(p, "inDuty") 
        local dutyskin = getElementData(p, "dutyskin") 
        local job = getElementData(p, "job:id") 
        local maxvehicles = getElementData(p, "maxvehicles") or 4 
        local hasznaltkocsislot = getElementData(p, "hasznaltkocsislot") or 0 
        local premiumPont = getElementData(p, "premiumPont") or 0 
        local xp = getElementData(p, "xp") or 0 
        local level = getElementData(p, "level") or 0 
        
        dbExec(mysql:getConnection(), "UPDATE karakterek SET pozicio = ?, spentTime = ?, faction = ?, health = ?, bankmoney = ?, money = ?, pajzs = ?, ehesseg = ?, skin = ?, job = ? WHERE ID = ?", position,  spentTime, faction, hp, bankmoney, money, armor, ehesseg, skin, job,  dbid) 
        dbExec(mysql:getConnection(), "UPDATE karakterek SET maxvehicles = ?,hasznaltkocsislot = ?,premiumPont = ?, inDuty = ?, dutyskin = ?, keszpenz = ? WHERE ID = ?", maxvehicles,hasznaltkocsislot,premiumPont, duty, dutyskin,keszpenz,dbid) 
        dbExec(mysql:getConnection(), "UPDATE accounts SET admin = ? WHERE ID = ?",admin,xp,level,dbid) 
        dbExec(mysql:getConnection(), "UPDATE karakterek SET xp=?,level=? WHERE ID = ?",xp,level,dbid) 
        
    end 
end 
addEvent("savePlayer", true) 
addEventHandler("savePlayer", getRootElement(), savePlayer) 
  
function saveAllPlayer() 
    local count = 0 
    for i, p in ipairs(getElementsByType("player")) do 
        if (getElementData(p, "logedin") or false) then 
            savePlayer(p) 
            count = count + 1 
        end 
    end 
    outputDebugString("Ellett mentve "..count.." jatekos adata!") 
end 
saveAllPlayer() 
setTimer(saveAllPlayer, 1000*60*10, 0) 
addCommandHandler("saveall",saveAllPlayer) 
  
addEvent("checkPlayerBanState", true) 
addEventHandler("checkPlayerBanState", getRootElement(), 
    function(player) 
        local serial = getPlayerSerial(player) 
        local query = dbQuery(mysql:getConnection(),"SELECT * FROM banlist WHERE serial=?",serial) 
        local qh = dbPoll(query, -1) 
        local playerSerial, timeStamp, bannedBy, reason 
        if #qh > 0 then 
            for k, data in

supernovaa · February 23, 2016

2.

local kapcsolat = exports["mysql"]:getConnection() 
addEventHandler("onResourceStart", root,  
   function(res)  
      if ( ( res == getResourceFromName("mysql") ) or ( res == getThisResource() and getResourceState(res) == "running") ) then 
         kapcsolat = exports["mysql"]:getConnection() 
      end  
    end 
)

[23:31:28] restart: Requested by Console 
[23:31:28] restart: Resource restarting... 
[23:31:28] Stopping sg_tuning 
[23:31:28] Resource 'sg_tuning' changed, reloading and starting 
[23:31:28] Starting sg_tuning 
[23:31:28] ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] 
[23:31:28] ERROR: sg_tuning\server.lua:5: exports: Call to non-running server resource (mysql) [string "?"] 
[23:31:28] sg_tuning restarted successfully

3. Working.

First i started the gamemode, then i want login and register but i cant.

Sorry for my bad English.

[23:34:27] WARNING: sg_login\server.lua:494: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got nil] 
[23:34:27] WARNING: sg_login\server.lua:496: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean] 
[23:34:27] ERROR: sg_login\server.lua:500: attempt to get length of local 'qh' (a boolean value) 
[23:34:38] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value 
[23:34:38] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value 
[23:35:20] DENIED: Denied 'James' access to command 'debugscript' 
[23:35:22] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value 
[23:35:22] ERROR: sg_login\server.lua:58: attempt to concatenate a nil value

Thanks for helping, please help again.

and

[23:39:02] ERROR: sg_tuning\server.lua:1: exports: Call to non-running server resource (mysql) [string "?"] 
[23:39:02] ERROR: sg_tuning\server.lua:5: exports: Call to non-running server resource (mysql) [string "?"] 
[23:39:02] ERROR: sg_login\server.lua:4: exports: Call to non-running server resource (mysql) [string "?"]

KariiiM · February 23, 2016

mysql resource isn't running,start it and add it to mtaserver.conf to be started automaticly on each time yourserver turn on.

supernovaa · February 23, 2016

How?

KariiiM · February 23, 2016

Well, are you hosting your server in local or global?

If it's local which means in your own computer,

For local server:

local disk(C:) /Program Files/MTA San Andreas 1.5/Server/Mods/deathmatch/mtaserver.conf

(for me it's like that)

For global server:

Mods/deathmatch/mtaserver.conf

Note: mtaserver.conf is a file you can open/edit it with any editor.

Sign In

Attempt to call global. and etc.

Recommended Posts

supernovaa

Link to comment

Tomas

Link to comment

supernovaa

Link to comment

KariiiM

Link to comment

supernovaa

Link to comment

KariiiM

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Browse

Activity

MTA Network

Social Media