HELP Removing Owners of Shops and Castles

[BetuDM]

What db i need del to clear the owners in the game?
cuz i have reseted the server and i need all shops without owners and the castles too.

[wbl4352]

please check in cq_dynanpc for the castle and shops..

[PraDevil[ELITE]]

Originally Posted by BetuDM

What db i need del to clear the owners in the game?
cuz i have reseted the server and i need all shops without owners and the castles too.

do you mean want to reset your db with no body there..??

[BetuDM]

Originally Posted by PraDevil

do you mean want to reset your db with no body there..??

i am making a server, but i need start this with any information, and have shops and castles with hights prices, and i need del this, i have finded on cq_dynam.... do u have a query to clear all to standard?

[PraDevil[ELITE]]

here is it

 Spoiler

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;

[javairc]

DELETE from account.account;

some DB must change it my.account to account.account

[DaLaughinMan8]

Originally Posted by PraDevil

here is it

 Spoiler

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;

If he uses that his shops will still be own by who every bought them... or gets the same id as the person who bought them and same with the castle plots. Don't think you can just DELETE from my.dynanpc without losing the castle plots, shop flags, legion door/pole/shield and the targets in the training grounds. Think its one of those things you got to do by hand only tool I know that will help you is the npc translation tool[when it writes the npc sql file replace cq_npc with cq_dynanpc... shhh]

[.Ash]

Just do it manually...Lol Its fun ^_^