Automatic Reward System

[Scooty]

hi!

i need that script(sql query?):

top 1-10 players(sorted by level) gains 80 "premium_points"
top 11-30 players(sorted by level) gains 60 "premium_points"
top 31-50 players(sorted by level) gains 40 "premium_points"
top 51-100 players(sorted by level) gains 20 "premium_points"

Rep for help

 

[Ped0bear]

You mean the top players in highscores?

How often do you want the query to be launched (how often should the reward be given)

 

[Scooty]

Yes, top players in highscores(only level)

Only 1 time

 

[Zonet]

Then simply make a query instead in phpmyadmin
top 1-10 players(sorted by level) gains 80 "premium_points"

UPDATE `players` SET `premium_points` = 80 LIMIT 0, 10;

top 11-30 players(sorted by level) gains 60 "premium_points"

UPDATE `players` SET `premium_points` = 60 LIMIT 11, 20;

etc...

 

[Scooty]

boyka: i dont need set premium_points...

look:

when player have 100 premium points and he is in top10:

100+80=180

now you understand?



and premium_points is in table "accounts" not players

 

[Cykotitan]

CREATE TEMPORARY TABLE t1 SELECT account_id FROM players ORDER BY level DESC LIMIT 10;
UPDATE accounts SET premium_points = premium_points + 80 WHERE id IN (SELECT * FROM t1);

CREATE TEMPORARY TABLE t2 SELECT account_id FROM players ORDER BY level DESC LIMIT 20 OFFSET 10;
UPDATE accounts SET premium_points = premium_points + 60 WHERE id IN (SELECT * FROM t2);

CREATE TEMPORARY TABLE t3 SELECT account_id FROM players ORDER BY level DESC LIMIT 20 OFFSET 30;
UPDATE accounts SET premium_points = premium_points + 40 WHERE id IN (SELECT * FROM t3);

CREATE TEMPORARY TABLE t4 SELECT account_id FROM players ORDER BY level DESC LIMIT 50 OFFSET 50;
UPDATE accounts SET premium_points = premium_points + 20 WHERE id IN (SELECT * FROM t4);

Be advised, if someone has more than 1 character in top 100 players, he'll get rewarded accordingly for each one.