Top Posters Hack?

[snyx]

Im looking for a hack that shows the top posters on your baords on the main page, so I can make it show up on my home page, anyone ever seen one?

SELECT user.posts, user.username FROM user ORDER BY user.posts DESC, user.username DESC LIMIT 0, 10

Wow thanks, but how do I, and what can I do with one line of code? What do i do to incorp it into a php file in another DIR

Sorry, I wasn't thinking...

PHP Code:

<?php
require("path/to/global.php");

print("<table><tr><td colspan=\"2\">Top Posters</td></tr>
<tr><td><b>Username</b></td><td><b>Posts</b></td></tr>");

$db_link = @mysql_pconnect("$dbservername", "$dbusername", "$dbpassword");
mysql_select_db ("$dbname", $db_link);

$query = mysql_query("SELECT posts, username FROM user ORDER BY user.posts DESC, user.username DESC LIMIT 0, 10");

while($row = mysql_fetch_array($query))
          {
          $username = $row["username"];
          $posts = $row["posts"];

          print("<tr><td>$username</td><td>$posts</td></tr>");
          }

print("</table>");

?>

Put this in any page you want to. Just change the path to global.php and the LIMIT statement to reflect how many people you want to display. It's set at 10.

HTH

-jim

THANKS MAN! Wow, this wasnt hard like it thought, sweet!

I did that and I get this error

Warning: Supplied argument is not a valid MySQL-Link resource in /web/sites/3/leokiller/www.flyaway.f2s.com/board/main.php on line 15

and on line 15 the only thing on is is this symbol -> {

help ...

help help help plzzzzzzz

try changing the lines to this:

PHP Code:

$db_link = @mysql_pconnect("$dbservername", "$dbusername", "$dbpassword");
mysql_select_db ("$dbname", $db_link)
  or die("Error connecting to DB");

$query = mysql_query("SELECT posts, username FROM user ORDER BY user.posts DESC, user.username DESC LIMIT 0, 10")
  or die("Query Error:$query"); 


This should tell you where your error is...
Good Luck,

is sais error connecting to DB ,how is that possible ? It uses my global.php yes ? Well since my vbulletin shows no problems and connects without errors ,how can this script make an error connecting ? Please help , I really want this script to work