Points sql command

[3mR]

Points sql command ???

 

[Cornex]

What?

Please be more specific what you want, you can't go to an car shop an say "Buy car?"

 

[mrady2001]

he want sql to remove x points from x player

 

[3mR]

he want sql to remove x points from x player

yes

- - - Updated - - -

Bumbbbbbbbbbbbbbbbbbbbb

 

[Yodot]

Hi 3mR,

Before I put ANY effort into helping you, can you please provide just a little more information (my mind reading skills are rusty).

Do you want this as an lua for in-game? Do you want this as a php script? Do you just want to know the sql to do it (without php)?

Do you want it to check if they have enough points before removing the points (or are you happy for them to go into a negative point balance?).

Some of this information would help us to help you.

Cheers,
Yodot.

 

[Ninja]

UPDATE accounts SET premium_points = premium_points - 10 WHERE id IN (SELECT account_id FROM players WHERE name = "Test" GROUP BY account_id);