[SQL-QUERY] request

[dianagirl]

Hello , i've tried to find a sql query to make all players lvl 8 .. i want to delete everything except the players and their items, means like houses,frags,guilds and everything only accounts+players+ their items on them, house items should be cleaned aswell, someone can help me please?

 

[dianagirl]

if i use this sql query

UPDATE players SET level = 8, health = 185, healthmax = 185, experience = 4200, maglevel = 0, mana = 100, manamax = 100, manaspent = 0, soul = 100, posx = 1000, posy = 1000, posz = 7, cap = 440, skull = 0, skulltime = 0, stamina = 201660000, loss_experience = 100, loss_skills = 100, loss_items = 100, blessings = 0

UPDATE player_skills SET value = 10, count = 0

also players should lose their promotion
then all players will be lvl 8 but their health and mana will be same, but i want set all druids mages same hp/mana , all paladins same hp/mana, and all knights same hp/mana

 

[Evil Puncker]

yes we will help you when you TELL US MORE INFO SINCE WE ARE NOT SOOTHSAYERS

READ THIS SPECIALLY NUMBER 5

READ THIS ONE AS WELL NUMBER 5

AND THIS ONE.

 

[dianagirl]

Iam sorry,

Iam using tfs 0.3.6 for client version 8.60, gesior 0.3.6 aswell, i would like to reset the server complet , except the items players wear and ofc the accounts and players self,
and also im sorry for the wrong board, should i repost it on other board or just keep it here i guess some mod can move it if he see it, sorry for this !

any other informations you need?

 

[dianagirl]

@Evil Puncker you just came here to tell me what i did wrong and just leave again? I really thought you gonna help me and not just tell me ,you make this wrong, this wrong and this ..