HELP with database

[chathouse]

Hy, i delete my char,pets von database and afterwards I create the same again.

Nevertheless I have still the same Item of pieces in the Inventory and/or the weapons of the old Char. Which cq_…. is where one it to delete can?

I have Problem with dyna_medal_rank.

I donate for King, but the symbol apart from the names is not indicated.

and why i have a green name when i have my equitment completely?

where can i change this

ty for help

[King_Arthur]

The first one is a quicky:

Originally Posted by rexes13

Run this script in your database...

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;

[chathouse]

Originally Posted by King_Arthur

The first one is a quicky:

nope I do not want to delete the tables completely there functioned nothing at all more.

The creation items if the user registered is in cq_item
That I found out and I emptied now. Now I have nevertheless the next problem. which it me with cq_eudemon.

The Char does not add whom the Pet thus belonged and/or which names of the Pets not.

I have with to provide one chars only 2 eggs in more hatcher which I not use cannot. And there is error in it.

I wanted only an ID reconciliation. more cq_user, cq_eudemon, cq_items with Truncate

ahh sry i delete only contents of the tables.

It thanks functioned now again without problems times. Which I see with the first view.

[XxTopsyKrettxX]

ok i used the code above but still have castles and nobility ranks how do i del them

ok i restared the server and no ranks now but still got castles make i wanna del them
and also i noticed that when i 2nd evolve my euds they dont start at id number 1 its at like 2870 sum? ne one no how to reset them

[cruey]

Your problem has been fixed by Crues magical powers. (: yw.