[Helpful] Query's For New Server Owners.

08/27/2010 05:46 Death[PM]#1
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.

Vip award to players account.

Here is botjail and mute a player.
08/27/2010 06:52 gege2900#2
this will help alot of ppl in them servers
08/27/2010 08:06 AziQ#3
maybe this query has been release here.cause i've seen this before.in thread Pserver all things guide i guess.
08/27/2010 16:04 C0D3R4ID3R#4
Quote:
Originally Posted by speederbodo123 View Post
maybe this query has been release here.cause i've seen this before.in thread Pserver all things guide i guess.
hmmmmmmm

[Only registered and activated users can see links. Click Here To Register...]
08/27/2010 23:09 King_Arthur#5
Quote:
Originally Posted by Death[PM] View Post
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:
Code:
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.