HELP with database

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

The first one is a quicky:

Quote:

Originally Posted by 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;

Quote:

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.

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

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