Top (10) Posters Module

[Acido]

2 templates
1 file

Put the topten.php file in the Modules folder
create 2 new templates : adv_portal_topposters and top_posters with the content included in the aproriate txt files.

It give a module with the Top 10 users with more posts

Is you want change the amount of users to show in this module, simpley change the LIMIT option in the php file:

PHP Code:

$top_posters = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."user ORDER BY posts DESC LIMIT 10"); 


where LIMIT 10 is the number of userr to include in this query. Yo can change the numbre 10 for 5, 20, or wathelse that you want.

[seidel]

Hi!

I have vbadvanced homepage 1.1

How put your excellent module?

Please helpme!

Thanks!

[Zachery]

The modules only work with vBadvanced CMPS

[seidel]

Oh!, many thanks!

[joeychgo]

See screenshot ---

Seems to function properly. Nice hack.

But there is no border around it....

Also -- even though I took out the >> on the rest of the page, it came back on this block?

[Acido]

Originally Posted by joeychgo

See screenshot ---

Seems to function properly. Nice hack.

But there is no border around it....

Also -- even though I took out the >> on the rest of the page, it came back on this block?

Sorry for the borders:

In Template: adv_portal_topposters

Find:

 <table cellpadding="4" cellspacing="$stylevar[cellspacing]" border="0"  width="100%">

Replace it with:

<table cellpadding="4" cellspacing="$stylevar[cellspacing]" border="0" class="tborder" width="100%">

Border Fixed

[seidel]

Your module is great!

*installed* here expertforum.info/vbulletin

[bluesteel]

Simple, but good. Thanks!
*installed*

[Socket]

Cheers Acido just what I needed

[BoNfiRe]

yea thx for that shame I only have 3 posters, and one of them is me lol

[joeychgo]

Originally Posted by Acido

Border Fixed

Thats what I like - service with a smile thanks alot

[Rids]

Thanks for this Acido, a useful little module - *installed*

[hpwilhelm]

Thanks for a wery usefull add-on!

Would it be possible to make it display "Most popular users", Top 10 reputation with points display?

[Acido]

Originally Posted by hpwilhelm

Thanks for a wery usefull add-on!

Would it be possible to make it display "Most popular users", Top 10 reputation with points display?

I'l try write it tomorrow

[hpwilhelm]

Originally Posted by Acido

I'l try write it tomorrow

Thanks! Looking forward to it!

[Acido]

Originally Posted by hpwilhelm

Thanks! Looking forward to it!

I rewrite a new module. But if you want take a easy way, you can change the query in this module, to get people sorted by reputation, posts, referrals... etc

Check the file topten.php

Where you see: SELECT * FROM ".TABLE_PREFIX."user ORDER BY posts DESC LIMIT 10"

you can change that field (posts) by reputation or joindate, lastactivity etc.

Regards.

[Zachery]

I suggest for larger boards if its possible for you to store this number in the datastore or somthing else, so this doesnt have to be run every time a user browses the board, ^^ just a thought that might speed things up

[Acido]

Originally Posted by Zachery

I suggest for larger boards if its possible for you to store this number in the datastore or somthing else, so this doesnt have to be run every time a user browses the board, ^^ just a thought that might speed things up

I have not enought skills to do that.
Can you help?

[Zachery]

Sadly im not that good with php ^^ altho Brian should be

[bluesteel]

Made a VERY minor change to this hack.

In adv_portal_topposters template, find

PHP Code:

<td width="100%"><span class="smallfont">$top_stats[top_posters] 
                        </span></td> 


And replace with

PHP Code:

<td width="100%"><ol><span class="smallfont">$top_stats[top_posters] 
                        </span></ol></td> 


This should give you something like this