Arcturus Morningstar | Auto Diamonds keep spamming

[DanishAdam]

Hello DevBest!

Idk why'd this happened but last night I put the "hotel.auto.diamond.interval" to 1 and have change back to 1200. then I restarted the emu. But the diamonds keep spamming.

You must be registered for see images attach

You must be registered for see images attach

Additional question:
How do I set

$belcr_get2 = $dbh->prepare("SELECT * from users_currency WHERE type = 5 ORDER BY `amount` DESC  LIMIT 6");
                                    $belcr_get2->execute();
                                    while ($belcr_row2 = $belcr_get2->fetch())

to

$belcr_get2 = $dbh->prepare("SELECT * from users_currency WHERE type = 5 rank < 5 ORDER BY `amount` DESC  LIMIT 6");
                                    $belcr_get2->execute();
                                    while ($belcr_row2 = $belcr_get2->fetch())

 

[airilxx]

Hey , are you trying to disable the diamonds currency timer ? If so , you'll need to change put the "hotel.auto.diamond.interval" to 0 so it disables the auto-credited diamonds.

for the top stats query , try using this one :

$belcr_get2 = $dbh->prepare("SELECT * from users_currency WHERE type = 5 AND rank < 5 ORDER BY `amount` DESC  LIMIT 6");
                                    $belcr_get2->execute();
                                    while ($belcr_row2 = $belcr_get2->fetch())

Hope these will help you!

 

[DanishAdam]

Hey , are you trying to disable the diamonds currency timer ? If so , you'll need to change put the "hotel.auto.diamond.interval" to 0 so it disables the auto-credited diamonds.

for the top stats query , try using this one :

$belcr_get2 = $dbh->prepare("SELECT * from users_currency WHERE type = 5 AND rank < 5 ORDER BY `amount` DESC  LIMIT 6");
                                    $belcr_get2->execute();
                                    while ($belcr_row2 = $belcr_get2->fetch())

Hope these will help you!

Q1: Thanks but actually I want to makes my hotel get 5 diamond every 20 minutes.

Q2: Now I got the fatal error on the leaderboard;

You must be registered for see images attach

How do I connect the rank table into the "most diamond" leaderboard?

 

[boz]

Q1: Thanks but actually I want to makes my hotel get 5 diamond every 20 minutes.

Q2: Now I got the fatal error on the leaderboard;

You must be registered for see images attach

How do I connect the rank table into the "most diamond" leaderboard?

Users_currency doesn’t have a rank column so what’s what that errors for, you need to use this SELECT * FROM users INNER JOIN users_currency ON users.id=users_currency.user_id AND users_currency.type = '5' WHERE rank <= '5' ORDER BY users_currency.amount DESC LIMIT

 

[DanishAdam]

Users_currency doesn’t have a rank column so what’s what that errors for, you need to use this SELECT * FROM users INNER JOIN users_currency ON users.id=users_currency.user_id AND users_currency.type = '5' WHERE rank <= '5' ORDER BY users_currency.amount DESC LIMIT

it says syntax error

 

[Wieiscool]

it says syntax error

Try removing LIMIT at the end.
So it will be

SELECT * FROM users INNER JOIN users_currency ON users.id=users_currency.user_id AND users_currency.type = 5 WHERE rank <= 5 ORDER BY users_currency.amount DESC

 

[fosterzgod]

Its in your permissions of each rank

Post automatically merged: Jun 6, 2021

edit the auto_points_amount on each rank in permissions table problem solved, then :update_permissions

 

[DanishAdam]

Thank you guys, problem solved