How do I change the Top 10 list to Top 20? [Answered]

[zhiichiro]

how to change top 10 to top 20?

[trollis76]

Go to the stat.php, and find this part:

PHP Code:

// Loop out code...

$num = 0;

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 10";
$result = mysql_query($query);
$num = mysql_numrows($result);

$gennum = $num;

if($num > 5){
$gennum = $num - 5;
} 


And change into this:

PHP Code:

// Loop out code...

$num = 0;

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 20";
$result = mysql_query($query);
$num = mysql_numrows($result);

$gennum = $num;

if($num > 5){
$gennum = $num - 5;
} 


Am I right?[hr]
Then you can change the Name of the list in the Lang.php.

[Bloodrun]

Originally Posted by trollis76

Go to the stat.php, and find this part:

PHP Code:

// Loop out code...

$num = 0;

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 10";
$result = mysql_query($query);
$num = mysql_numrows($result);

$gennum = $num;

if($num > 5){
$gennum = $num - 5;
} 


And change into this:

PHP Code:

// Loop out code...

$num = 0;

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 20";
$result = mysql_query($query);
$num = mysql_numrows($result);

$gennum = $num;

if($num > 5){
$gennum = $num - 5;
} 


Am I right?[hr]
Then you can change the Name of the list in the Lang.php.

You are correct. Nicely answered.

Just point out that the thing he is changing is this part:

PHP Code:

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 10"; 


To this:

PHP Code:

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 20"; 


[trollis76]

Yea, I just wanted to take a bigger part so that he would find it... :)
Ah, well...

[zhiichiro]

ok tnx :)[hr]
uhm... it's not working, it still shows top 10 only[hr]
ow haha.. it's working now, tnx again