HELP Removing Owners of Shops and Castles

12/11/2009 08:05 BetuDM#1

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.

12/11/2009 09:32 wbl4352#2

please check in cq_dynanpc for the castle and shops..

12/11/2009 10:11 PraDevil[ELITE]#3

Quote:

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

12/11/2009 11:37 BetuDM#4

Quote:

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?

12/11/2009 14:24 PraDevil[ELITE]#5

here is it

Spoiler

12/11/2009 18:55 javairc#6

Quote:

DELETE from account.account;

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

;)

12/11/2009 21:33 DaLaughinMan8#7

Quote:

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;)]

12/12/2009 05:56 .Ash#8

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