Solved Need some query

[martinadicto]

for example if one account have 10 points and you execute for example "UPDATE accounts SET premium_points= 3" the value 10 change to 3 ... how i make to change to "13" from "10+3" ?? hehe help

 

[iKaS]

UPDATE accounts SET premium_points= premium points + 3

 

[martinadicto]

UPDATE accounts SET premium_points= premium points + 3

how do I give it only to players who are level greater than 300?

pd: thanks for the query

 

[Cronox]

you need this..
1. Send all accounts 3 Points, you edit number points..

UPDATE accounts SET premium_points = premium_points + 3

2. Send premium points specific account.. edit account name for acc playe you need send.

UPDATE accounts SET premium_points = premium_points + 3 WHERE name = 'account name';

 

[sn3ejk]

how do I give it only to players who are level greater than 300?

UPDATE `accounts` SET `premium_points` = `premium points` + 3 AND `account_id` IN (SELECT `account_id` FROM `players` WHERE `level` >= 300);

I didn't check it.

 

[martinadicto]

you need this..
1. Send all accounts 3 Points, you edit number points..

UPDATE accounts SET premium_points = premium_points + 3

2. Send premium points specific account.. edit account name for acc playe you need send.

UPDATE accounts SET premium_points = premium_points + 3 WHERE name = 'account name';

if i wanna send points only for player online? you know the query??

 

[T0MBIE]

UPDATE `accounts` SET `premium_points` = `premium points` + 3 AND `account_id` IN (SELECT `account_id` FROM `players` WHERE `level` >= 300);

I didn't check it.

UPDATE `accounts` SET `premium_points` = `premium points` + 3 AND `account_id` IN (SELECT `account_id` FROM `players` WHERE `online` = 1);

For players that is online (did not check it)

 

[martinadicto]

UPDATE `accounts` SET `premium_points` = `premium points` + 3 AND `account_id` IN (SELECT `account_id` FROM `players` WHERE `online` = 1);

For players that is online (did not check it)

it not working :c

 

[T0MBIE]

it not working :c

whats the error code ?

 

[martinadicto]

whats the error code ?

I can fix it the code for woriking 100%, here are:

UPDATE accounts SET premium_points = (premium_points + 3) WHERE id IN (SELECT account_id FROM players WHERE online = 1);

thank you