[HELP]Remove Record

02/13/2010 08:36 javairc#1

hello all, need help i wanna delete old record in DB i try use this :

Code:

DELETE from my.cq_castle;
DELETE from my.cq_castleitem;
DELETE from my.cq_castlemap;

look like nothing happen, castle still old owner, shop & map. How to delete it? :handsdown:

02/13/2010 11:48 PraDevil[ELITE]#2

for the shop go to the shop..then u buy it..after u buy sell them to cronus:p
for the castle is same..

but for the owner of family map owner i dont know:p

02/13/2010 13:33 ~WARNING~#3

To remove family owners, go into Cq_dynanpc, find id's 2600 - 2619 and make the ownerid "0" owner name "ʥ��ŷ˹�̻�", and the harvest date "0".

02/13/2010 14:29 PraDevil[ELITE]#4

Quote:

Originally Posted by ibeatuall

To remove family owners, go into Cq_dynanpc, find id's 2600 - 2619 and make the ownerid "0" owner name "ʥ��ŷ˹�̻�", and the harvest date "0".

thank u are really helpfull guy!! XD

02/13/2010 14:51 ~WARNING~#5

np =P i have no problems sharing tips and tricks to fellow EO server hosters

02/13/2010 17:35 javairc#6

thanks dude.. :D

02/13/2010 17:35 ~WARNING~#7

np :D glad i can help =P

02/13/2010 18:38 chathouse#8

Quote:

Originally Posted by javairc

hello all, need help i wanna delete old record in DB i try use this

Code:

King_Arthur

The first one is a quicky:

Quote from rexes13  
Run this script in your database...

Code:
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;

02/15/2010 13:35 javairc#9

not all record delete.. like map, shop & castle. i try do like ibeatuall say. its work!!