[Help]How To Wipe Database[Help]

01/06/2011 17:06 azza2155#1
I Need To Wipe My Database But Dont Know How. I have Searched And Searched But Still No Look. Would Appreciate The Help Thanks

I Need To Wipe My Database But Dont Know How. I have Searched And Searched But Still No Look. Would Appreciate The Help Thanks
01/06/2011 17:33 keithbell17#2
Quote:
Originally Posted by azza2155 View Post
I Need To Wipe My Database But Dont Know How. I have Searched And Searched But Still No Look. Would Appreciate The Help Thanks
if u search the Guides and Releases u might find it cause last time i searched i found it straight away...
01/07/2011 00:01 ~*Kronic*~#3
This is not a guide and why did you make the same post in two different places?

# Request Close/Move
01/07/2011 05:53 Jack Sparrow#4
Use Search button next time

Code:
DELETE from my.account;
DELETE from my.cq_user;
DELETE from my.cq_eudemon;
DELETE from my.cq_item;
DELETE from my.cq_ad_log;
DELETE from my.cq_announce;
DELETE from my.cq_castle;
DELETE from my.cq_castleitem;
DELETE from my.cq_castlemap;
DELETE from my.cq_deluser;
DELETE from my.cq_donation_dynasort_rec;
DELETE from my.cq_dyna_rank_rec;
DELETE from my.cq_enemy;
DELETE from my.cq_family;
DELETE from my.cq_flower;
DELETE from my.cq_friend;
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.e_money;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;
01/07/2011 14:58 King_Arthur#5
#Merged