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

[zhiichiro]

how to change top 10 to top 20?

 

[trollis76]

RE: what am i going to change?

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

// 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:

// 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?

---

Then you can change the Name of the list in the Lang.php.

 

[Bloodrun]

RE: what am i going to change?

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

// 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:

// 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?

---

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:

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

To this:

$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

---

uhm... it's not working, it still shows top 10 only

---

ow haha.. it's working now, tnx again