[alus1onZ]

With my noobish php knowledge I've made a script that extract information from the mysql db and display it as a top 100 ranking of the adoptables. But the problem is I don't know how to replace the get content function in extrapage.php:

PHP Code:

$query = "SELECT * FROM article_content WHERE page = 'extra'";
$result = mysql_query($query);
$num = mysql_numrows($result); 


With mine php top 100 script :(

Please if someone can tell me how to replace it I will be very thankful

Here it's the php Top 100 adoptables script, feel free to use it on your page if you want. It may have issues but as I say my knowledge in php is very poor. :)

PHP Code:

<?php
{
  $getscores="SELECT totalclicks,name,currentlevel,owner,type from owned_adoptables order by totalclicks DESC limit 100";
  $getscores2=mysql_query($getscores) or die("Could not get scores");
  $rank=1;
  echo "<center><h3>Top 100 adoptables</h3></center><center>";
  echo "<table width=50%><tr><th>Position</th><th>Name</th><th>Clicks</th><th>Level</th><th>Owner</th><th>Type</th></tr>";
  while($getscores3=mysql_fetch_array($getscores2))
  {
     $getscores3[name]=strip_tags($getscores3[name]);
     echo "<tr><td>$rank</td><td>$getscores3[name]</td><td>$getscores3[totalclicks]</td><td>$getscores3[currentlevel]</td><td>$getscores3[owner]</td><td>$getscores3[type]</td></tr>";
     $rank++;
  }
  echo "</table></center><br><br>";
}
?>

[hr]
OK, I got it! :D

The easiest way is to add a div class style in the main.css then in extrapage.php place this before the top 100 code

echo "<div class=\"your div class"\>";

and after the top 100 code put this

echo "</div>";

so your php code will look something like this:

PHP Code:

  echo "<div class=\"top100\">";
{
  $getscores="SELECT totalclicks,name,currentlevel,owner,type from owned_adoptables order by totalclicks DESC limit 100";
  $getscores2=mysql_query($getscores) or die("Could not get scores");
  $rank=1;
  echo "<center><h3>Top 100 adoptables</h3></center><center>";
  echo "<table width=50%><tr><th>Position</th><th>Name</th><th>Clicks</th><th>Level</th><th>Owner</th><th>Type</th></tr>";
  while($getscores3=mysql_fetch_array($getscores2))
  {
     $getscores3[name]=strip_tags($getscores3[name]);
     echo "<tr><td>$rank</td><td>$getscores3[name]</td><td>$getscores3[totalclicks]</td><td>$getscores3[currentlevel]</td><td>$getscores3[owner]</td><td>$getscores3[type]</td></tr>";
     $rank++;
  }
  echo "</table></center><br><br>";
}
  echo "</div>"; 


Best wishes, alus1onZ :P