Solved [TFS 1.0] Databasequery/Maxhealth/Npc

[Giddran]

Hey guys, i'm trying to create a npc that can got the ability to raise values like health, cap, mana. I reconize that i got barely no clue how to query the database and make changes. I tried adding the function below which only gave me "attempt to call field 'executeQuery <a nil value>' stacktraceback: 'setmaxhealth' 'callback'

function setMaxHealth(cid, health)
return db.executeQuery("UPDATE players SET maxhealth=" .. health .. " WHERE id='" .. getPlayerGUID(cid))
end

 

[Ninja]

db.query or just use creature:setMaxHealth(maxHealth)

 

[Giddran]

Thanks, didint get the database query to work but the second one went smoothly