[HELP] Ranking Donation

02/14/2010 17:16 mathpaiva1#1

how can I delete my raking to donate, delete all the char that are kings, Duke ... ?

02/14/2010 17:23 chathouse#2

8 topics below and you would have found the right

That clears everything here was already available for a new start has to go.

Code:

King_Arthur

The first one is a quicky:

Quote from 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;

Exactly what you need you can find under:

cq_donation_dynasort_rec

02/14/2010 17:28 mathpaiva1#3

thanks very helpful

02/14/2010 18:03 magewarior2#4

you also can edit the users you want off the "king" or what ever by going to the cq_user table and than under the param "donation"

02/14/2010 18:05 catface2345#5

anyone know how to make sombody legion leader and do i need maint for it to take effect ty

02/14/2010 18:22 matrix89#6

Quote:

Originally Posted by chathouse

8 topics below and you would have found the right

That clears everything here was already available for a new start has to go.

Code:

King_Arthur

The first one is a quicky:

Quote from 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;

Exactly what you need you can find under:

cq_donation_dynasort_rec

but how to delete self skill...
example : Chainchop
i want delete it..
what file db name to delete it?

02/14/2010 19:45 King_Arthur#7

Quote:

Originally Posted by catface2345

anyone know how to make sombody legion leader and do i need maint for it to take effect ty

cq_synattr.rank is the field you are looking for. Rank 1000 is leader. I don't think you need a maintenance just need to relog on the character.