sadasdsa

Kellan123 · **Author**

000000000000000000000

jimaway · 01-18-2017 , 05:09 Re: [SQL] How i get fast rank loading in AMXX ?

instead of looping through everything in the table in the plugin just fetch the rank and total number of entries from the database.

you can use the sql COUNT() to achieve this

Kellan123 · 02-03-2017 , 09:40 Re: [SQL] How i get fast rank loading in AMXX ?

Still waiting for help ;)

klippy · 02-03-2017 , 09:46 Re: [SQL] How i get fast rank loading in AMXX ?

Jimaway already told you what to do and you gave no feedback. Did you even try implementing what he proposed?

Kellan123 · *Last edited by Kellan123; 06-12-2017 at 10:19.*

00000000000000000

jimaway · 02-06-2017 , 15:55 Re: [SQL] How i get fast rank loading in AMXX ?

Quote:

Originally Posted by Kellan123

i'm using this for rank and total !

PHP Code:


			
SELECT `lifes` as a, (SELECT COUNT(lifes) + 1 FROM `dr_stats` WHERE `lifes` > a) as b, (SELECT COUNT(*) FROM `dr_stats`) as c FROM `dr_stats` WHERE `authid` = '%s'

but top is not correct why ?

PHP Code:


			
SELECT * FROM `dr_stats` ORDER BY `lifes` DESC

i'm pretty sure the querys in parenthesis are parsed first in sql, therefore 'a' has no value when you are using it in the "WHERE" clause

try this:

Code:

SELECT (SELECT COUNT(*)
        FROM   dr_stats)                        AS total,
       (SELECT COUNT(*)
        FROM   dr_stats
        WHERE  lifes >= (SELECT lifes
                         FROM   dr_stats
                         WHERE  authid = '%s')) AS rank