Reset level

[Erexo]

Hello,
i looking for script to reset all players lvl to 100 (hp/mp/cap etc back too).

Someone can help? :}

 

[KylerXX]

local totalCapacity = 237 -- ???
function onSay(cid, words, param, channel)
     db.executeQuery("UPDATE `players` SET `level`= 100;")
     db.executeQuery("UPDATE `players` SET `health`= 1;")
     db.executeQuery("UPDATE `players` SET `mana`= 1;")
     db.executeQuery("UPDATE `players` SET `cap`= "..  totalCapacity ..";")
     return 0
end

This should work.

 

[Erexo]

I have 2ots on one database...

world = 0 and world = 1

thats the biggest problem,

 

[KylerXX]

Test this one:

local totalCapacity = 237 -- ???
local world_id = 1
function onSay(cid, words, param, channel)
     db.executeQuery("UPDATE `players` WHERE `world_id` = ".. world_id .." SET `level`= 100;")
     db.executeQuery("UPDATE `players` WHERE `world_id` = ".. world_id .." SET `health`= 1;")
     db.executeQuery("UPDATE `players` WHERE `world_id` = ".. world_id .." SET `mana`= 1;")
     db.executeQuery("UPDATE `players` WHERE `world_id` = ".. world_id .." SET `cap`= "..  totalCapacity ..";")
     return 0
end

 

[Erexo]

Not working

when i set this on db
UPDATE `players` WHERE `world_id` =1 SET `level` =100

error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `world_id` = 1 SET `level`= 100' at line 1

Can you do, delete all players with world = 1 without players with account_id = 1

 

[LucasFerraz]

How will it reset level? In-game?

What do you want? Talkaction? Globalevent?

UPDATE players WHERE world_id = 1 SET level= 100;

also you can do that

function onLogin(cid)
		if isPlayer(cid)
				local setPlayerLevelOnLogin = 100
				doPlayerAddExperience(cid, (getExperienceForLevel(setPlayerLevelOnLogin) - getPlayerExperience(cid)))
		end
	return TRUE
end

 

[Erexo]

But i wanna make 100lv to all players

 

[LucasFerraz]

When player login he will get lv150

function onLogin(cid)
		if isPlayer(cid)
				local setPlayerLevelOnLogin = 100
				doPlayerAddExperience(cid, (getExperienceForLevel(setPlayerLevelOnLogin) - getPlayerExperience(cid)))
		end
	return TRUE
end

 

[Erexo]

Not working,
set 100lv, but then hp is bugged


Someone can tell me, how can i delete all players with world_id = 1, without players with account_id = 1?

Please fast