LuaSQL Query

[Ninkobi]

How can I make these 3 queries in the same assert without making it bug... I cant have all three 3 queries right after each other it only executes the first query.

		assert(con:execute("UPDATE players SET level = 100, experience = 15694800, health = 1105, healthmax = 1105, maglevel = 17, manaspent = 0, mana = 1415,manamax = 1415, cap = 2310 WHERE name = '"..target.."';"))
		assert(con:execute("UPDATE player_skills SET skillid = 4, value = 80, count = 0 WHERE player_id = '"..cid.."';"))
		assert(con:execute("UPDATE player_skills SET skillid = 5, value = 60, count = 0 WHERE player_id = '"..cid.."';"))

 

[Dark Warrior]

That will not work unless the player is offline so i highly recommend you to make it with {Do player add exp} and {set player skill} or something...