Wipe

[FireStreaM]

Alguem ai poderia me arruma o sql que da wiper no server?

[Jondxz]

Como realizar "Wipe" no seu servidor, deletando todas as informações relacionada à players.

No tópico tem a SQL.

Editado Janeiro 3, 2018 por Jondxz

[FireStreaM]

17 horas atrás, Jondxz disse:

Como realizar "Wipe" no seu servidor, deletando todas as informações relacionada à players.

No tópico tem a SQL.

mais esse ai nao ta funcionando nao da erro.

 

SET @dt = 40;

DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) > @dt;

DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);
DELETE FROM account_data WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM character_friends WHERE char_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_quests WHERE char_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId FROM characters);
DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT charId FROM characters));
DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT charId FROM characters);
DELETE FROM augmentations WHERE item_id NOT IN (SELECT item_id FROM items);
UPDATE characters SET clanid=0,title="",clan_privs=0 where clanid NOT IN (SELECT clan_id FROM clan_data);
UPDATE clanhall SET ownerID=0,paidUntil=0 where ownerID NOT IN (SELECT clan_id FROM clan_data);

[gustavopradoreis]

E qual seria o erro? rs

[FireStreaM]

8 minutos atrás, GustavoHPs disse:

E qual seria o erro? rs

eu fiz manual mesmo man vlw 

[ReynalDev]

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

L2jFrozen 1132

Editado Janeiro 4, 2018 por ReynalDev

[FireStreaM]

14 horas atrás, ReynalDev disse:

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

L2jFrozen 1132

vlw esse funcionou , obrigado eu ja tinha feito manualmente mais esse ai eu testei e pegou de boa vou guardar ele aqui vlw mesmo amigo