A ALGUMA MANEIRA DE RESETAR MINHA DB MYSQL SEM PERDER OS SAMPLES? (varios)

execute isso em SQL.

 DELETE FROM `players` WHERE `name` NOT IN ('Administrador','Druid Sample','Sorcerer Sample','Knight Sample','Paladin Sample')

DELETE FROM `accounts` WHERE `name` NOT IN ('1','123456')

Se por acaso quiser manter os players mas limpar tudo:

UPDATE houses SET owner = '0' WHERE owner > 0;
DELETE FROM player_storage WHERE player_storage.`key` > 0;
DELETE FROM global_storage WHERE global_storage.`key` > 0;
DELETE FROM guilds WHERE name IS NOT NULL;
DELETE FROM guild_invites WHERE player_id IS NOT NULL;
DELETE FROM guild_membership WHERE player_id IS NOT NULL;
DELETE FROM guild_ranks WHERE id IS NOT NULL;
DELETE FROM guild_wars WHERE id IS NOT NULL;
UPDATE players SET level=1, vocation=0, health=150, healthmax=150, mana=0, manamax=0, experience=0, maglevel=0, lookaddons=0, town_id=6, posx=0, posy=0, posx=7, cap=500, skull=0, skulltime=0, blessings=0, balance=0, stamina=2520, skill_fist=10, skill_club=10, skill_sword=10, skill_axe=10, skill_dist=10, skill_shielding=10, skill_fishing=10 WHERE level < 500 AND name != 'Rook Sample' AND name != 'Sorcerer Sample' AND name != 'Druid Sample' AND name != 'Paladin Sample' AND name != 'Knight Sample';
DELETE FROM player_depotitems WHERE 1;
DELETE FROM player_inboxitems WHERE 1;
DELETE FROM player_items WHERE 1;
TRUNCATE `tile_store`;
TRUNCATE `player_deaths`;

Editado Agosto 30, 2015 9 anos por dezon (veja o histórico de edições)

Thank yous.. Agora me ajudem a resetar os items e as houses? vlw

  Em 30/08/2015 em 22:42, Jobs disse:

 

execute isso em SQL.

 DELETE FROM `players` WHERE `name` NOT IN ('Administrador','Druid Sample','Sorcerer Sample','Knight Sample','Paladin Sample')

DELETE FROM `accounts` WHERE `name` NOT IN ('1','123456')

E Mano, deletou todos os samples :[

@Edit: consegui, so preciso resetar os itens, as houses (itens), e as guilds

Editado Agosto 30, 2015 9 anos por arthurabreu (veja o histórico de edições)

  Em 30/08/2015 em 23:10, arthurabreu disse:

 

Thank yous.. Agora me ajudem a resetar os items e as houses? vlw

E Mano, deletou todos os samples :[

 

 

em accounts voce deveria ter colocado a account que é dos samples, e em players são os nomes.. Feito isso, não deletará nada..

Aonde tá  '1','123456' são as contas que não vão deletar. Eu usei hoje e sem estress. rs