[HELP] Reset DB...

Page 1 of 2

10/12/2011 03:11 exilio0001#1

hi guys, I wonder how do to eliminate any record of
some existing account earlier in my DB :confused:... Id Eudemon, characters, accounts, castles created,
shopflag characters or occupied by legions, Occupied family, among
others :D... grasias beforehand...:handsdown:

Excuse me for my bad English ... google translator .... XD:D

10/12/2011 05:04 luqman hakim#2

just go to navicat and find column account, cq castle, cq family, cq eudemon, cq donation dynasort rec, cq user and right click empty table

10/12/2011 06:32 mid93#3

Here It Is : Give A Thank If Helped ;)

Code:

DELETE from my.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 where ownerid > 9999;
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;

10/12/2011 07:34 exilio0001#4

families were deleted but are still registered in the positions
of the cities ... war famili ... I want my users when they enter and create families that do not conflict with ... which obtained the prize in the registration ...

Excuse me for my bad English ... google translator .... XD

10/13/2011 07:31 mid93#5

The Other Tables Just Right Click Then Choose Empty Table Then Your Done..

Give A Thank Please :)

11/06/2013 19:55 xirc85#6

which db i should delete if i want reset already occupying family in family war map.. i try search in each db, still cant figure it out.. and i also want to reset id number when we do 2nd evolve eudemons pet..

11/07/2013 00:03 idlemonkey#7

lol cq_ family will show you the families ids and cq_map will show u these ids as owners of that map if i remember right u just need to clear the cq_family and cq_family_attr tables and empty the owner column in cq_map

11/07/2013 00:39 hio77#8

10-13-2011

the skeletons in this thread are starting to decay at this point xirc85...

11/07/2013 01:55 idlemonkey#9

Quote:

Originally Posted by hio77

10-13-2011

the skeletons in this thread are starting to decay at this point xirc85...

the older threads are far more informative than the newer ones that people have made based on the older threads in most cases I think .... although this isnt one of those lol ... there are much more informative threads on this subject

11/07/2013 02:56 hio77#10

Quote:

Originally Posted by idlemonkey

the older threads are far more informative than the newer ones that people have made based on the older threads in most cases I think .... although this isnt one of those lol ... there are much more informative threads on this subject

Quote:

#5. NO NECROPOSTING(to post in a thread that has been "dead", by being inactive for a relatively long period.) There is no need for it and it causes problems.

this is what i was referring to.

older posts have far more information because currently there is next to no one who bothers to dig deep and understand anymore..

11/07/2013 03:11 idlemonkey#11

lol yes I do realize what you were refering to lol and it is a valid point in most cases ....
but as you put it .... there is next to no one who bothers to dig deep and understand anymore .... if these things people dont dig far enough to find got brought to light maybe a lot of these other useless threads asking about things they cant find without looking back to the beginning of time wouldnt pop up every day

personally I would like to see more people posting in the orignal threads these things were brought up in instead of the newer threads people made biting off of those threads

almost every release someone has made concerning a matter that has already been brought up years ago is literally a copy of those threads, except they put their own name on the release and often dont include all of the information....
I think thats a lot worse than posting in a thread that someone might actually get some information out of from yesteryear and giving credit to the person who actually released it

but i dont run this forum

because of this now this thread will probably be closed and the recent posts removed ...
and when someone actually has a question about this then they will not be able to post in this thread to get an answer(although they could have picked a better one)

at least this guy got his answer before that happened

11/07/2013 03:20 xirc85#12

Quote:

Originally Posted by idlemonkey

lol cq_ family will show you the families ids and cq_map will show u these ids as owners of that map if i remember right u just need to clear the cq_family and cq_family_attr tables and empty the owner column in cq_map

now i'll look at cq_map in deep...

Quote:

Originally Posted by hio77

10-13-2011

the skeletons in this thread are starting to decay at this point xirc85...

hio77 , sorry for bring up old thread.. im just had to.

11/07/2013 03:48 idlemonkey#13

Quote:

Originally Posted by xirc85

now i'll look at cq_map in deep...
.

dont forget to empty the family tables too .... u only need to empty that one column in cq_map though

11/07/2013 10:17 funhacker#14

Quote:

Originally Posted by idlemonkey

lol yes I do realize what you were refering to lol and it is a valid point in most cases ....
but as you put it .... there is next to no one who bothers to dig deep and understand anymore .... if these things people dont dig far enough to find got brought to light maybe a lot of these other useless threads asking about things they cant find without looking back to the beginning of time wouldnt pop up every day

personally I would like to see more people posting in the orignal threads these things were brought up in instead of the newer threads people made biting off of those threads

almost every release someone has made concerning a matter that has already been brought up years ago is literally a copy of those threads, except they put their own name on the release and often dont include all of the information....
I think thats a lot worse than posting in a thread that someone might actually get some information out of from yesteryear and giving credit to the person who actually released it

but i dont run this forum

because of this now this thread will probably be closed and the recent posts removed ...
and when someone actually has a question about this then they will not be able to post in this thread to get an answer(although they could have picked a better one)

at least this guy got his answer before that happened

I totally agree, I got a warning/infraction for posting relevant information to the MOST RECENT but DEAD thread.
It's in clear conflict with "Search before posting"
I think the only way around necro-threading whilst still using the search function would be to post a new thread with your question and link to the old thread for reference -.-

But with all that said rules are rules

11/07/2013 10:33 idlemonkey#15

Quote:

Originally Posted by funhacker

I totally agree, I got a warning/infraction for posting relevant information to the MOST RECENT but DEAD thread.
It's in clear conflict with "Search before posting"
I think the only way around necro-threading whilst still using the search function would be to post a new thread with your question and link to the old thread for reference -.-

But with all that said rules are rules

I got a warning for almost the same thing lol adding relevent updated information to expand the information i provided in my own post that had grown stale (and not even that old)

Page 1 of 2