[HELP] 2 Easy Questions

07/01/2010 06:50 jayk10304#1

How do you delete PM's from Donation ranks? and
How do i remove a PM Girl account from the roses/flower rank.
And let me know if i have to run a maintence afterwords. Thank you

Please reply fast. Ill appreciate all of your help!

Thanks To:
ElitePvPers And The People Here for helping me with everything!

07/01/2010 06:56 Eurion#2

Quote:

Originally Posted by jayk10304

How do you delete PM's from Donation ranks? and
How do i remove a PM Girl account from the roses/flower rank.
And let me know if i have to run a maintence afterwords. Thank you

Please reply fast. Ill appreciate all of your help!

Thanks To:
ElitePvPers And The People Here for helping me with everything!

First question would be

Code:

UPDATE cq_user SET donation='0' WHERE name='StaffName';
DELETE from cq_donation where user_name='StaffName';

Then run a maint.

Second question would be.

Code:

UPDATE cq_user SET flower='0', flower_w='0' WHERE name='Girls Name';
DELETE from cq_flower WHERE player_id='GirlsCharacterId';

For this one, I would test it first just to make sure.

With both I believe you have to run a server maint.

07/01/2010 14:35 magewarior2#3

Quote:
Originally Posted by Eurion
First question would be
Code:
UPDATE cq_user SET donation='0' WHERE name='StaffName';
DELETE from cq_donation where user_name='StaffName';
Then run a maint.

Second question would be.
Code:
UPDATE cq_user SET flower='0', flower_w='0' WHERE name='Girls Name';
DELETE from cq_flower WHERE player_id='GirlsCharacterId';
For this one, I would test it first just to make sure.

With both I believe you have to run a server maint.

use;

Code:

UPDATE cq_user SET donation='[COLOR="Red"]30000000[/COLOR]' WHERE name='StaffName';
DELETE from cq_donation where user_name='StaffName';

why? because than your PM would only be a baron and no servermaint is needed!

07/01/2010 15:33 Eurion#4

He never wanted to lower their rank, his question was the delete the staff from donation ranks.

07/01/2010 18:55 magewarior2#5

Quote:

Originally Posted by Eurion

He never wanted to lower their rank, his question was the delete the staff from donation ranks.

well, why he want him off donation rank??

because 9/10 chance`s he got king or something high...

lower him to baron, and he wont even be on the list no longer .... (if you have enough people)

i did not say what you say is wrong, I just give another solution.

07/02/2010 04:13 Eurion#6

I understand what you said, What I did was give him his answer. There's no sense in having staff on the ranks anyways, staff are there to help not play. That is why they have mortal characters.

07/02/2010 07:03 jayk10304#7

Thank you guys, just please no fighting? =]

07/02/2010 07:20 Eurion#8

There were no fights :) We just stated different opinions.