[HELP] 2 Easy Questions

[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!

[Eurion]

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

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.

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.

[magewarior2]

Originally Posted by Eurion

First question would be

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.

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;

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!

[Eurion]

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

[magewarior2]

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.

[Eurion]

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.

[jayk10304]

Thank you guys, just please no fighting? =]

[Eurion]

There were no fights We just stated different opinions.