[Interlude] script para deletar char inativo

[mullet]

SEGUINTE,EU TAVA PROCURANO SCRIPTS PRO MEU SITE NE DAI AXEI ESSE
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

DELTANDO CAR INATIVO SOH QUE EH DE TIBIA,DAI EU KERIA SABE SE ALGUEM NAO TEM UM DESSE PRA L2
SAKA,AKELES QUE NA LOGAREM EM 1 MES,O CHAR E A CONTA SAO DELETADOS
MTOS AKI EU AXO QUE GOSTARIAM POIS ISSOIRIA ALIVIAR UM POUCO O DB

[paytaly]

Teste com esse:
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

[mullet]

paytaly

SET @dt = 60;

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 obj_Id FROM characters);
DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_quests WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT obj_Id 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 obj_Id FROM characters));
DELETE FROM items WHERE owner_id NOT IN (SELECT obj_Id FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT obj_Id 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);


me explic: COMO EU EDITO O TEMPO PRO BANGUE DELETA OS CHAR,EH SOH BOTA LA QUE ELE VIA DELETANDO?

[paytaly]

SET @dt = 60;

No lugar do 60 você coloca o número de Dias.
Depois é só salvar como .SQL e dar Execute Batch File no seu DataBase.

[mullet]

Soh =] 60 eeh 60 dias?

EU TENHO QUE FIK EXECUTANDO SEMPRE??? ou ele deleta os char ozin?

[paytaly]

Não tenho certeza absoluta mais quase que o 60 é dias mesmo.

Você tem que ficar executando... Mais também não precisa ser toda hora.