[HELP]Remove Record

[javairc]

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

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?

[PraDevil[ELITE]]

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

but for the owner of family map owner i dont know

[~WARNING~]

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".

[PraDevil[ELITE]]

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

[~WARNING~]

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

[javairc]

thanks dude..

[~WARNING~]

np glad i can help =P

[chathouse]

Originally Posted by javairc

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

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;

[javairc]

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