and resets ranck

01/12/2010 18:07 Maribela#1
hello I need help I know how to reset the Ranck and noble animal and when the player enters the rack and noble animal automatically goes into place to help me please
01/12/2010 18:09 rexes13#2
Quote:
Originally Posted by Maribela View Post
hello I need help I know how to reset the Ranck and noble animal and when the player enters the rack and noble animal automatically goes into place to help me please
Didnt understand anything...can u plz explain it in simple english??
01/12/2010 18:14 Maribela#3
I would like to know how to reset the pet Ranck and nobility'm sorry my English in Brazil
01/12/2010 19:08 ygorzhyper#4
she mean, i want to know how to reset the eudemons and nobility ranking, its not delete, its reseting ok
01/12/2010 21:18 hio77#5
close your msg server fully

clear the following tables...

Eudemons: cq_dyna_rank_rec

Donations/Nobility Ranking : cq_donation_dynasort_rec

then open your server
01/13/2010 15:10 rexes13#6
Quote:
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;
Run this script in your database...
01/13/2010 17:11 Maribela#7
Quote:
Originally Posted by hio77 View Post
close your msg server fully

clear the following tables...

Eudemons: cq_dyna_rank_rec

Donations/Nobility Ranking : cq_donation_dynasort_rec

then open your server
hio77 sheltered for helping me, worked perfectly
01/13/2010 17:16 Maribela#8
Quote:
Originally Posted by rexes13 View Post
Run this script in your database...
rexes13, thank you
01/13/2010 21:09 hio77#9
Quote:
Originally Posted by rexes13 View Post
Run this script in your database...
that would clear the whole info of the server not just the ranks...
01/13/2010 22:54 rexes13#10
Quote:
Originally Posted by hio77 View Post
that would clear the whole info of the server not just the ranks...
Most of us when we start a new server we want to clear everything and she maybe summed up everything in the word "ranks"...
01/13/2010 22:57 hio77#11
Quote:
Originally Posted by rexes13 View Post
Most of us when we start a new server we want to clear everything and she maybe summed up everything in the word "ranks"...
it seems like she wants to clear the ranks only not everything ...
01/14/2010 06:45 rexes13#12
Quote:
Originally Posted by hio77 View Post
it seems like she wants to clear the ranks only not everything ...
She must have told something about the script then...