[Question] Database

03/10/2010 18:35 suanni#1

Is there a script that you can run to clean out your database. I've noticed there is a lot of things left over from the previous owner.

03/10/2010 18:43 ~WARNING~#2

yes, there is indeed a script you can run.

Code:

DELETE from my.cq_user;
DELETE from my.cq_eudemon;
DELETE from my.cq_item;
DELETE from my.cq_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;

this won't clean everything, but it will clean a lot of it.

03/10/2010 18:46 zspider#3

please use SEARCH IN THIS forum this is already released any way use this :)

Code:

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;

03/10/2010 19:19 suanni#4

Thanks my bad, Was just trying to get it done quick before work. I'll use this when I get home. =)

and about cleaning the nobility? xD

03/10/2010 19:50 ~WARNING~#5

post #5 reported, 1:47pm (-5 GMT) cause: double post
#PostsMerged

Quote:

Originally Posted by suanni

and about cleaning the nobility? xD

Code:

DELETE from my.cq_donation_dynasort_rec;

will take care of your nobility

03/10/2010 19:58 King_Arthur#6

This one is mine. It's even in alphabetical order :awesome:

Quote:

Originally Posted by King_Arthur

DELETE from account.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, price = initial_price, deposit = 0 where ownerid > 9999;

03/10/2010 22:10 suanni#7

Thanks everyone that helped. Appreciated much.

03/10/2010 22:50 ~WARNING~#8

#requesting close

thread has been solved

03/11/2010 00:28 alina1#9

DELETE from account.account; - This will only work if u have account and my in ur DB.

If ur db consist of my only then replace the line with DELETE from my.account;