resources probs

[steven1l]

shop-sytem\s_generalshop_system.lua:520 attempt to index local "result"

function resStart() 
    local result = mysql:query_fetch_assoc("SELECT value FROM settings WHERE name='globalsupplies' LIMIT 1") 
    globalSupplies = tonumber(result["value"]) 
end 
addEventHandler("onResourceStart", getResourceRootElement(), resStart) 

account-system\s_main.lua:32 attempt to index local "motdresult

function resourceStart(resource) 
    setGameType("Roleplay") 
    setMapName("Los Santos") 
    setRuleValue("Script Version", scriptVersion) 
    setRuleValue("Author", "Scripting Team") 
     
    local motdresult = mysql:query_fetch_assoc("SELECT value FROM settings WHERE name='motd' LIMIT 1") 
    exports['anticheat-system']:changeProtectedElementDataEx(getRootElement(), "account:motd", motdresult["value" ], false ) 
    local amotdresult = mysql:query_fetch_assoc("SELECT value FROM settings WHERE name='amotd' LIMIT 1") 
    exports['anticheat-system']:changeProtectedElementDataEx(getRootElement(), "account:amotd", motdresult["value" ], false ) 
  
    for key, value in ipairs(exports.pool:getPoolElementsByType("player")) do 
        triggerEvent("playerJoinResourceStart", value, resource) 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart) 

hope some on can help me.

thanxs

[Callum]

Those errors are due to the fact that SQL can't retrieve the data correctly.

[steven1l]

can you tell me how to fix. i cant find what is wrong.

[Callum]

Well we cannot see how your SQL is setup, but I'm guessing the data doesn't exist.

[steven1l]

its valhalla rollplay mode. but i have fully installed mysql. and there is a file called like sql. and the db seem to be working good

[CapY]

Look pal, if you don't know how to configure it, make your own gamemode.