TFS 1.2

[Itutorial]

I created a save players script for TFS 1.2. It works, the values of the player are input into the database. The problem I am having is the console gives errors even though it is working. Can someone help me with this?

Main function:

function savePlayerInfo(cid, info, value)
return db.storeQuery("UPDATE `players` SET `"..info.."` = "..value.." WHERE `id` = " .. getPlayerGUID(cid) .. ";")
end

Script:

function onThink(interval)
game_players = Game.getPlayers()
    for i = 1, #game_players do
        player = Player(game_players[i])
      
        savePlayerInfo(player, "level", player:getLevel())
        savePlayerInfo(player, "vocation", player:getVocation():getId())
        savePlayerInfo(player, "health", player:getHealth())
        savePlayerInfo(player, "healthmax", player:getMaxHealth())
        savePlayerInfo(player, "looktype", player:getOutfit().lookType)
        savePlayerInfo(player, "maglevel", player:getMagicLevel())
        savePlayerInfo(player, "mana", player:getMana())
        savePlayerInfo(player, "manamax", player:getMaxMana())
        savePlayerInfo(player, "posx", player:getPosition().x)
        savePlayerInfo(player, "posy", player:getPosition().y)
        savePlayerInfo(player, "posz", player:getPosition().z)
        savePlayerInfo(player, "skill_fist", player:getSkillLevel(SKILL_FIST))
        savePlayerInfo(player, "skill_sword", player:getSkillLevel(SKILL_SWORD))
        savePlayerInfo(player, "skill_club", player:getSkillLevel(SKILL_CLUB))
        savePlayerInfo(player, "skill_axe", player:getSkillLevel(SKILL_AXE))
        savePlayerInfo(player, "skill_dist", player:getSkillLevel(SKILL_DISTANCE))
        savePlayerInfo(player, "skill_shielding", player:getSkillLevel(SKILL_SHIELDING))
        savePlayerInfo(player, "skill_fishing", player:getSkillLevel(SKILL_FISHING))
        savePlayerInfo(player, "skill_fist_tries", player:getSkillTries(1))
        savePlayerInfo(player, "skill_sword_tries", player:getSkillTries(2))
        savePlayerInfo(player, "skill_club_tries", player:getSkillTries(3))
        savePlayerInfo(player, "skill_axe_tries", player:getSkillTries(4))
        savePlayerInfo(player, "skill_dist_tries", player:getSkillTries(5))
        savePlayerInfo(player, "skill_shielding_tries", player:getSkillTries(6))
        savePlayerInfo(player, "skill_fishing_tries", player:getSkillTries(SKILL_FISHING))
    end
    broadcastMessage("All players have been saved. !~NOTE~! You MUST log out for your items to be saved.", MESSAGE_STATUS_WARNING)
    return true
end

Error:

 

[Printer]

There is already function to save only player:

player:save()

 

[Itutorial]

Then why doesn't the server ever save the players? The only time it does is when the player logs out.

Anyway, it worked. I figured the function was broken or something. Lame asf.

Thank you.

 

[Mkalo]

Then why doesn't the server ever save the players? The only time it does is when the player logs out.

It does save if you use player:save()

However the problem in your code is that you are using storeQuery with UPDATE. Change it to db.query