[Helpful] Query's For New Server Owners.

[Death[PM]]

Here i am going to release some query's to help some of you out. I am sure alot of the older members of server owners. Already no all of this.

Well here is the frist one.

Query For Deleteing Flowers Off of a Player.

 Spoiler

update cq_user set flower=0 where account_id=2;
update cq_user set flower_w=0 where account_id=2;
DELETE FROM cq_flower WHERE player_id >= 14481775;


/*Okay here is a little harder. Since you have to delete this form to places you will need
to change the account_id and the player_id to what ever the id's of the players that got flowers
gave to them. Hopefully you want have to do this. But after you run this script. Do a maintence. 
So that it will delete the flower from your character. Then this should work.*/

Vip award to players account.

 Spoiler

update account set vip=7 where id=(account id here);

Here is botjail and mute a player.

 Spoiler

update cq_user set disableFlag=1 where account_id=(player account id);
update cq_user set cheat_time=9999 where account_id=(players account id);

To Un botJail and Un mute a player

update cq_user set disableFlag=0 where account_id=(plaeryes account id);
update cq_user set cheat_time=0 where account_id=(Players Account Id);

[gege2900]

this will help alot of ppl in them servers

[AziQ]

maybe this query has been release here.cause i've seen this before.in thread Pserver all things guide i guess.

[C0D3R4ID3R]

Originally Posted by speederbodo123

maybe this query has been release here.cause i've seen this before.in thread Pserver all things guide i guess.

hmmmmmmm

[King_Arthur]

Originally Posted by Death[PM]

Query For Deleteing Flowers Off of a Player.
...
DELETE FROM cq_flower WHERE player_id >= 14481775;
...

This query is deleting entries for all player ids above and including 14481775. I suggest you remove the ">" from this query.

EDIT: You might be able to rewrite this so you don't need to know the player id. Something like:

delete from cq_flower where (cq_flower.player_id = cq_user.id and cq_user.account_id = 2);

Don't quote me on this though (well... you can if I'm right) b/c my sql coding skills are a little rusty and I can't test it atm.