Windows Database query

[troxet]

Hello,

I have got a problem, i want to reset everything in database, levels, etc, I dont know how to do on my own.
I saw topic here when someone posted query that will reset everything, levels, depots and stuff, but the problem is that I cant find that topic, I have tried with different search names, but its impossible for me to find it.

Can someone help me with that?

Regards,
Troxet

 

[Hanoger]

remove & create new? It's also a way to do it

 

[troxet]

Well i got about 450 players in database. I dont want to loose it.
I just want a query that will update levels, storage id, items, hp,mp etc.

 

[Hanoger]

"i want to reset everything in database"

 

[Cronox]

For delete all? and make reset full?
execute query:
/phpmyadmin - SQL

DELETE FROM `player_storage`;
DELETE FROM `player_deaths`;
DELETE FROM `player_killers`;
DELETE FROM `players`;
DELETE FROM `guilds`;
DELETE FROM `guild_wars`;
DELETE FROM `accounts`;

For Delete all inside table just only use

DELETE FROM `nametable`;

just only for update players level 8 and remove depotitems and items..

delete from player_depotitems
delete from player_items
delete from tile_items

UPDATE players SET level = 8, health = 185, healthmax = 185, experience = 4200, lookaddons = 0, mana = 35, manamax = 35, manaspent = 0, soul = 0, town_id = 5, posx = 32369, posy = 32241, posz = 7, cap = 470, sex = 0, lastlogin = 0, lastip = 0, skull = 0, skulltime = 0, rank_id = 0, guildnick = '', lastlogout = 0, blessings = 0, balance = 0, stamina = 151200000, loss_experience = 100, loss_mana = 100, loss_skills = 100, loss_containers = 100, loss_items = 100, premend = 0, online = 0, marriage = 0, promotion = 0, deleted = 0, created = 0, hide_char = 0, comment = '';