Top 10 posters

[Internet]

Hello everyone,

How do we show the top 10 or top 20 posters?

Any simple scripts?

Thank you.

[Allan]

...../forum/memberlist.php?order=DESC&sort=posts&pp=10?

[Internet]

...../forum/memberlist.php?order=DESC&sort=posts&pp=10?


Link's not working.

[Logikos]

http://www.YOURSITENAME.com/forum/memberlist.php?order=DESC&sort=posts&pp=10?

Change yoursitename.com to your sites name.

[Allan]

http://www.YOURSITENAME.com/forum/memberlist.php?order=DESC&sort=posts&pp=10?

Change yoursitename.com to your sites name.

lol ;)

[Internet]

I need a hack of the top 10 posters to place on the index of website or forum.

Anyone?

Thanks.

[Adrian Schneider]

Pretty simple to do.. just add something like:

$topposters = $DB_site->query("
SELECT username, userid, posts
FROM user
ORDER BY posts DESC
LIMIT 10
");
$topposter=$DB_site->fetch_array($topposters))
{
eval('$var .= "' . fetch_template('template_name') . '";');
}


Replace $var and template_name with the variable used in FORUMHOME and template_name is your template which repeats for each user found. Customize the HTML in that template however you want it... Key phrases are:
$topposter[userid]
$topposter[username]
$topposter[posts]

oh and the " . TABLE_PREFIX . " was implied.....okay? :) meanies

[TCattitude]

Or use the new Zero Tolerance's SDK (vbexternal) hack:
https://vborg.vbsupport.ru/showthread.php?threadid=81943
It's easy ;)

[Internet]

Thanks TCattitude. I think Zero Tolerance requires some files to be uploaded and linked to it. I hope not to do such major changes. Thanks for the link and help. ;)

Thanks TheSpecialist. Your coding is database query. Am not really sure if i am able to get it working. :) Will give it a try.

If there's anyone with codes to share, please feel free to add. Much appreciated. Thank you.