Need scripts to clear DB data

Ive searched, but i couldnt find any scripts to delete old DB info. Anyone know the mysql script to delete cq_user, account, cq_eudemon,etc?

Quote:

Originally Posted by viscidslime Ive searched, but i couldnt find any scripts to delete old DB info. Anyone know the mysql script to delete cq_user, account, cq_eudemon,etc?

Quote:

DELETE from my.cq_addresslist; DELETE from my.cq_user; DELETE from my.cq_eudemon; DELETE from my.cq_item; DELETE from my.account; DELETE from my.cq_castle; DELETE from my.cq_castleitem; DELETE from my.cq_castlemap; DELETE from my.cq_enemy; DELETE from my.e_money; DELETE from my.cq_donation_dynasort_rec; DELETE from my.cq_friend; DELETE from my.cq_ad_log; DELETE from my.cq_announce; DELETE from my.cq_deluser; DELETE from my.cq_dyna_rank_rec; DELETE from my.cq_family; DELETE from my.cq_flower; DELETE from my.cq_magic; DELETE from my.cq_partner; DELETE from my.cq_pk_bonus; DELETE from my.cq_shortcut_key; DELETE from my.cq_special_status; DELETE from my.cq_statistic; DELETE from my.cq_synattr; DELETE from my.cq_syndicate; DELETE from my.cq_trade; DELETE from my.cq_tutor; DELETE from my.cq_tutor_contributions; DELETE from my.cq_tutor_contributions2;

Enjoy them....:D
Credits to Underground Gaming Leader...!!!

DELETE from my2.cq_addresslist;
DELETE from my2.cq_user;
DELETE from my2.cq_eudemon;
DELETE from my2.cq_item;
DELETE from my2.account;
DELETE from my2.cq_castle;
DELETE from my2.cq_castleitem;
DELETE from my2.cq_castlemap;
DELETE from my2.cq_enemy;
DELETE from my2.e_money;
DELETE from my2.cq_donation_dynasort_rec;
DELETE from my2.cq_friend;
DELETE from my2.cq_ad_log;
DELETE from my2.cq_announce;
DELETE from my2.cq_deluser;
DELETE from my2.cq_dyna_rank_rec;
DELETE from my2.cq_family;
DELETE from my2.cq_flower;
DELETE from my2.cq_magic;
DELETE from my2.cq_partner;
DELETE from my2.cq_pk_bonus;
DELETE from my2.cq_shortcut_key;
DELETE from my2.cq_special_status;
DELETE from my2.cq_statistic;
DELETE from my2.cq_synattr;
DELETE from my2.cq_syndicate;
DELETE from my2.cq_trade;
DELETE from my2.cq_tutor;
DELETE from my2.cq_tutor_contributions;
DELETE from my2.cq_tutor_contributions2;

just incase its a my2 :P

Credits to Underground Gaming Leader

tyvm :)

Quote:

Originally Posted by viscidslime tyvm :)

np

Quote:

Originally Posted by keithbell1234 DELETE from my2.cq_addresslist; DELETE from my2.cq_user; DELETE from my2.cq_eudemon; DELETE from my2.cq_item; DELETE from my2.account; DELETE from my2.cq_castle; DELETE from my2.cq_castleitem; DELETE from my2.cq_castlemap; DELETE from my2.cq_enemy; DELETE from my2.e_money; DELETE from my2.cq_donation_dynasort_rec; DELETE from my2.cq_friend; DELETE from my2.cq_ad_log; DELETE from my2.cq_announce; DELETE from my2.cq_deluser; DELETE from my2.cq_dyna_rank_rec; DELETE from my2.cq_family; DELETE from my2.cq_flower; DELETE from my2.cq_magic; DELETE from my2.cq_partner; DELETE from my2.cq_pk_bonus; DELETE from my2.cq_shortcut_key; DELETE from my2.cq_special_status; DELETE from my2.cq_statistic; DELETE from my2.cq_synattr; DELETE from my2.cq_syndicate; DELETE from my2.cq_trade; DELETE from my2.cq_tutor; DELETE from my2.cq_tutor_contributions; DELETE from my2.cq_tutor_contributions2; just incase its a my2 :P

you could of just said if that doesnt work replace the my with my 2 lol

Quote:

Originally Posted by |>SomeGuy<| you could of just said if that doesnt work replace the my with my 2 lol

just trying to help :P but u are right that would be easier lmao

Quote:

Originally Posted by rexes13 Enjoy them....:D

Funny I released this no credits hahaha

Quote:

Originally Posted by Underground Gaming Leader Funny I released this no credits hahaha

UPDATE
I added the credits to u man...

Quote:

Originally Posted by Underground Gaming Leader Funny I released this no credits hahaha

sorry about that bro i added credits to u now :)

if u look more back u will find this made by me , i made it once the pally db released by Dibiase