Top 'X' Stats

[InfiniteWebby]

Security Fix: The uploaded version fixes all issues concerned with the recent security vulnerabilities. Sorry I haven't been around I don't really do anything plugin wise anymore.

Oh this version also works with all current version of vB 3.6. So feel free to use it on that version.

- InfiniteWebby

The low down

Well this is the vB 3.5.0 version of my hack. It is much the same as the original except that for some added stuff that I never released ;)

Basically what it does is show the Top 'X' (edited via the vBulletin options in the admincp) newest members, top posters and newest replies on the Forumhome.

So what's new in this version?

Well for one all settings, which include amount of stats to show on forumhome and the extended page, thread title and username truncation, excluded forums and 'new' and 'old' thread prefixes.

Secondly there is now an extra page where you are able to choose exactly how many stats to show.

And lastly and most importantly it only takes 3 simple steps to install =)

What's on the horizon?

- More "stat blocks" including top reputation and top thread based on views or replies. If you have a suggestion please let me know, prefferably via pm.
- Proper can view other users threads permissions. At the moment I cannot think of how to block other people threads while still showing your own without totally re-writing the hack =(.

Version 1.2.1 is a re-release with who's online additions as well as some template changes. So you are best to reinstall the whole thing all over again.

So anyway enjoy and click install.

[Azhrialilu]

Just what I was waiting for, thanks!!! :D

[Chris M]

Permissions are pretty easy and I must say vital to the functionality of this hack :)

It's nice - Similar to my Latest threads hack but obviously with a few more sets of stats :)

I'm interested to know how many extra queries this adds, and whether any cached data could be used to prevent queries being used etc...

Satan

[Barakat]

its gives Invalid Argument suplied for foreach() in n function.php at line 771 while trying to upload the plugin file ???

[Anfiniti.net]

Sweeet.../me clicks install

[mrgizmo]

The XML file when uploaded doesn't have any code or a title name, there for it doesn't show up, just a blank plugin.

[plateau]

hi mate, u r great, it is what i was just waiting for!

[prawn]

The XML file when uploaded doesn't have any code or a title name, there for it doesn't show up, just a blank plugin.

Same for me.

[Barakat]

The XML file when uploaded doesn't have any code or a title name, there for it doesn't show up, just a blank plugin.

its true but before that it gives u an error which is invalid .......... online line 771

[Neal-UK]

its true but before that it gives u an error which is invalid .......... online line 771

blank for me to and the error also

[Neal-UK]

blank for me to and the error also

sorry, install it under products....mind you, i then got a db error and couldn't viw the forum and had to remove it.

My forum has db prefix FORUM so will that be a problem?

[Zorck]

Hello, I get this error :

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost
Error Number : 1064
Date : Thursday, July 28th 2005 @ 09:26:18 PM
Script : http://www.pixsell.com.ar/forums/index.php
Referrer : http://www.pixsell.com.ar/forums/private.php?do=showpm&pmid=1
IP Address : 201.255.27.156
Username : admin
Classname : vb_database



any idea?

[Neal-UK]

I get that too:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM FORUMthread AS thread
LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter)
LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DE
Error Number : 1064
Date : Friday, July 29th 2005 @ 12:31:36 AM
Script : http://www.burnleyweb.com/community/index.php
Referrer : http://www.burnleyweb.com/community/online.php
IP Address : 212.***.***.***
Username : *******
Classname : vb_database

[InfiniteWebby]

Ok the database errors are because you left the excluded forums setting blank, put a zero in there for now and it should be okay. I'll put in a check statement that will make sure this doesn't happen in the future.

To everyone else having troubles uploading the plugin. I should have stated this before. IT IS A PRODUCT to import it you must go into your admincp click the Manage Products link in the nav bar. Click [Add/Import Product] then import it. If you have already tried to import it then it is best if you select 'yes' for Allow Overwrite. If you are still having troubles then pm me with the exact problem and I will look into it.

[Neal-UK]

im struggling to find where you mean, i though i did the above but it still gives me the error

[InfiniteWebby]

Ok, sorry the settings didn't export. It *should* be fixed now, just download the new zip and follow the instructions.

Again if there are any problems pm me, it is much easier that way =)

[Neal-UK]

Ok, sorry the settings didn't export. It *should* be fixed now, just download the new zip and follow the instructions.

Again if there are any problems pm me, it is much easier that way =)

lol, no worries, will try now thanks very much for your help

[Neal-UK]

lol, no worries, will try now thanks very much for your help

No, still getting an error on forumhome:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM FORUMthread AS thread
LEFT JOIN FORUMuser AS user ON (user.username = thread.lastposter)
LEFT JOIN FORUMdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND deletionlog.primaryid IS NULL
ORDER BY thread.lastpost DE
Error Number : 1064
Date : Friday, July 29th 2005 @ 01:42:01 AM
Script : http://www.burnleyweb.com/community/index.php
Referrer : http://www.burnleyweb.com/community/usercp.php
IP Address : 212.***.****.*****
Username : ******
Classname : vb_database

[Neal-UK]

my forum prefix is FORUM, that causing a problem?

[InfiniteWebby]

Are the settings in the vB options this time?

[Neal-UK]

Are the settings in the vB options this time?

no, just the default

[InfiniteWebby]

did you select yes when it asked you to allow overwrite?

[plateau]

Well Done but I think more Columns could be added such as: Top Viewed Threads, Top Replied Threads, like these.

Cheers.

[InfiniteWebby]

You mean it works for you?

And I will be working on extra columns once I get permissions and username formatting done.

[Neal-UK]

did you select yes when it asked you to allow overwrite?

no as i unistalled it then reinstalled it. Am i best selecting overwrite and try again?

[InfiniteWebby]

Probably and if you are still having troubles then contact me via pm. They are in my profile.

[Barakat]

it works finaly thanks a loooooooooooooooooooooooooooooooot for that hack

[Neal-UK]

it works finaly thanks a loooooooooooooooooooooooooooooooot for that hack

whoo oooo, it's working thanks. If only I could move the shoutbox to the bottom now....... Thanks AnimeWebby

[chizzzz]

EVERYTHING WORKS FINE, BUT THERE IS A SMALL PROBLEM. THE TITLE "Top Poster" doesnt show, Other than that, its fine.

[Neal-UK]

EVERYTHING WORKS FINE, BUT THERE IS A SMALL PROBLEM. THE TITLE "Top Poster" doesnt show, Other than that, its fine.

eh? that was working earlier. Help??

[Neal-UK]

eh? that was working earlier. Help??

is this a phrase issue? which phrase will it be?

[InfiniteWebby]

To fix the top poster not showing just add a new phrase.

Phrase Type: GLOBAL
Product: Top 'X' Stats by InfiniteWebby
Varname: top_posters
Text: Top Posters

[Neal-UK]

weird, still not showing. It was earlier, i'm sure of it.

[InfiniteWebby]

Sorry made a mistake again. It is meant to have a varname of top_posters!

[InfiniteWebby]

I updated the zip to fix the missing phrase so if you'd prefer to reinstall the product then feel free to do so.

[Neal-UK]

yup, working now many thanks again ;-)

[Brinnie]

Ooooo, I have gotta have one of these. :)

[haiboss]

very well, thx man !

[plateau]

Well Done but I think more Columns could be added such as: Top Viewed Threads, Top Replied Threads, like these.

Cheers.

yes it is.

thanks mate, and i m waiting for ur further works done!

[Loki12]

I love this hack, thanks AnimeWebby. :)

One thing though...

On the FORUMHOME, this works well with usergroup permissions, i.e. I can only see the threads that I am allowed to view under my usergroup. BUT... when I click on the link to see all 30 top entries (http://www......../forum/topXstats.php ), then ALL posts show... and unfortunately even guests will see the threads of the staff forum, for example... :(

Any fix for this?

[InfiniteWebby]

The permissions bundled with the previous version was just me experimenting so you shouldn't have seen that. But I have re-released the hack with the final permissions code as well as proper deletion notices code. So go an re-install the whole thing.

I still have to figure out how I am going to implement the can view other users thread but I have some ideas ;).

[Loki12]

The permissions bundled with the previous version was just me experimenting so you shouldn't have seen that. But I have re-released the hack with the final permissions code as well as proper deletion notices code. So go an re-install the whole thing.


Works like a charm, thanks. :)

So quick... uninstall and reinstall in less than a minute!

[ForYou]

Hello ,

thank you for this plugin , it is very nice

my qustion is ,

is there any future to appear user name color for user gruops like what i setting im it ,

for example :

members : red
Mod : green
Admin : white

Regards

[Damien2005]

Hello ,

thank you for this plugin , it is very nice

my qustion is ,

is there any future to appear user name color for user gruops like what i setting im it ,

for example :

members : red
Mod : green
Admin : white

Regards

this is a good idea
so maybe can AnimeWebby think about it and add the usergroup colors :rolleyes:

[InfiniteWebby]

It's already on my todo list. It will use whatever formatting you have set in your usergroup settings.

[ForYou]

It's already on my todo list. It will use whatever formatting you have set in your usergroup settings.

Hello Anime,

It's very nice to hear that from u :)

but when it will be ready to use it ,

Regards

[akanevsky]

To let people view self-posted threads in restricted forums, just do the forum check in
while ($getstats_thread = $db->fetch_array($getstats_threads))
instead of doing $excludedforums before that...

What is esspecially notable is the neat code of yours :) Nice! Installed.

[EasyTarget]

Nice hack, its working good.
I was wondering how I could attach the board statistics box to the bottom of this.

the box that says:
Threads: #, Posts: #, Members: #
Welcome to our newest member, Username

[InfiniteWebby]

To let people view self-posted threads in restricted forums, just do the forum check in
while ($getstats_thread = $db->fetch_array($getstats_threads))
instead of doing $excludedforums before that...

What is esspecially notable is the neat code of yours :) Nice! Installed.

Yah I was thinking that but that would mean that I would have to change the query to grab alot more results, changing the while loop to only run until there are 5 results SHOWN instead of while there are still results from the quert and check inside the loop.

And call me paedantic but I don't like using while loops like that, I'd prefer to somehow just grab the full query.

Nice hack, its working good.
I was wondering how I could attach the board statistics box to the bottom of this.

the box that says:
Threads: #, Posts: #, Members: #
Welcome to our newest member, Username

Try this (it looks a bit silly but it's the best I could do.:

Find on your FORUMHOME:


</table>
<br />
<!-- end what's going on box -->

And replace with:

<thead>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a>
<a href="topXstats.php$session[sessionurl_q]">$vbphrase[statistics] - <phrase 1="$displayrecords">$vbphrase[top_x]</phrase></a></td>
</tr>
</thead>
<tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]">
<tr>
<td class="alt2" colspan="2">
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr>
<td class="alt2" width="23%" align="$stylevar[left]" nowrap="nowrap"><b>$vbphrase[top_posters]</b></td>
<td class="alt1" width="22%" align="$stylevar[left]" nowrap="nowrap"><b>$vbphrase[newest_members]</b></td>
<td class="alt2" width="55%" nowrap="nowrap"><b>$vbphrase[latest_replies]</b></td>
</tr>
<tr>
<td class="alt2" width="23%" valign="top">
<table>
<tr>
<td width="100%" nowrap="nowrap">$vbphrase[member]:</td>
<td align="right" nowrap="nowrap">$vbphrase[posts]:</td>
</tr>
$topXstats_posters_bits
</table>
</td>
<td class="alt1" width="22%" valign="top">
<table>
<tr>
<td width="100%" nowrap="nowrap">$vbphrase[member]:</td>
<td align="right" nowrap="nowrap">$vbphrase[posts]:</td>
</tr>
$topXstats_members_bits
</table>
</td>
<td class="alt2" width="55%" valign="top">
<table>
<tr>
<td width="70%" nowrap="nowrap">$vbphrase[thread]:</td>
<td width="30%" nowrap="nowrap">$vbphrase[last_poster]:</td>
<td align="right" nowrap="nowrap">$vbphrase[views]:</td>
<td align="right" nowrap="nowrap">$vbphrase[replies]:</td>


</tr>
$topXstats_threads_bits
</table>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>

<br />
<br />
<!-- end top statistics box -->

[GrendelKhan{TSU]

everything peachy here

thanks!
<<< 3.5 RC1 INSTALLED :D :D

[EasyTarget]

thanks animewebby. I moved the stats to the top of the forum by including it under the navbar in the forumhome and I thought it'd look nice to have the other stats box run underneath it as well. I'll be messing around with the code you provided to see if I can figure something out, thanks again.

[akanevsky]

Yah I was thinking that but that would mean that I would have to change the query to grab alot more results, changing the while loop to only run until there are 5 results SHOWN instead of while there are still results from the quert and check inside the loop.

And call me paedantic but I don't like using while loops like that, I'd prefer to somehow just grab the full query.

You just do it by incrementing $i or any other variable after actually showing the thread. On the other hand, I don't see why do you need to see threads that you cannot actually read (since they're in private forums).

[dbembibre]

Installed, work ok, thabks alot

[InfiniteWebby]

You just do it by incrementing $i or any other variable after actually showing the thread. On the other hand, I don't see why do you need to see threads that you cannot actually read (since they're in private forums).

Yes but you still need to grab a query that will be substantially bigger than if you were to just grab the first 5.

And they are not in private forums. The can view others thread works so that you can still make your own new threads and view them, you just cant view others. Say you setup a feedback forum or something similar where only the admins could see all the threads and therefore reply to them however you can only see the threads you make, therefore preventing unwanted replies from other people. So it is imperitive to be able to see new replies in your thread on the top 5 stats without seeing other threads from the forum.

But like I said earlier. I think I have got a fix for this so you might see an update soon.

[InfiniteWebby]

Updated for username formatting based on usergroup settings.

Also updated the screenshots to see how such formatting works as well as how deleted threads work.

[XtremeOffroad]

Installed and worked great, Thanks.

[Damien2005]

Hi AnimeWebby,

Can you add the usergroup colors in to this great hack from you?
I love the top5 and would see it with more colors ;) so i hope you can added soon for us, you will make a lot people very happy

Best Regards
Damien..

[Neal-UK]

Hi AnimeWebby,

Can you add the usergroup colors in to this great hack from you?
I love the top5 and would see it with more colors ;) so i hope you can added soon for us, you will make a lot people very happy

Best Regards
Damien..

It already does, download the latest version ;-)

See > www.burnleyweb.com/forum

[Damien2005]

Oeps jup sorry I see it

Great hack thanks mate you rock vbulletin

[yupfish]

Could you provide us with a code to make a simple table with a border? Thank you.

[ForYou]

username

Hello ,

I was download the last virsion of this hack but the user name formatting still not change to the color groups , what is the problem with me , and how can i let the color of user names work ,

regards

[plateau]

still waiting for more columns, cheers.

[InfiniteWebby]

Hello ,

I was download the last virsion of this hack but the user name formatting still not change to the color groups , what is the problem with me , and how can i let the color of user names work ,

regards

Are you sure you have some sort of formatting in your usergroup settings?

still waiting for more columns, cheers.

I'm working on other stuf atm but once I start on this it shouldn't be too hard.

[ForYou]

Hello AnimeWebby ,

yes i have , becuase the users name appear color on the forums , Admin have read , Mod have green , Members have Blue ,

I don't know why it's not appear in the Top X

please help
Regards

[InfiniteWebby]

I don't know whats wrong. Try re-importing the latest version and make sure you have allow overwrite selected.

[ForYou]

I don't know whats wrong. Try re-importing the latest version and make sure you have allow overwrite selected.

I was re-importing the latest version and allow overwrite , but without any solve , the users name still not cloring ,

I was put these setting to the Admin Group ,

<font color="#FC0404"><b> </font></b>

is that right ,

please help

Regards

[ForYou]

Hello ,

It was OK now , the wrong was from the temp , becuase when i importing the new virsion and allow overwrite there is no overwrite of temp and i need to delate the old temp and re Create again ,

thanks Anime , :)

Regards

[InfiniteWebby]

I've added the topXstats.php to the who's online listing so there is a new zip (v1.2.1)

[plateau]

I'm working on other stuf atm but once I start on this it shouldn't be too hard.

cheers mate!

Remember adding the Hottest Thread (by view no.) and the Most Replied Thread :squareeyed:

waiting for these and will install once it has been added.

thank u for ur work, take care.

:surprised:

[mcyates]

Is it possible to change the amount of charecters shown on the top "x" stats that will not effect the charecters in the "Last Post By" on the forumhome as i want to fit 60 characters on the thread name for the top "x" stats but 60 characters in the last post area is far to big and i can only fit 20 in there.

Thanks in advance.

[poolking]

* poolking installed. :D

[InfiniteWebby]

Is it possible to change the amount of charecters shown on the top "x" stats that will not effect the charecters in the "Last Post By" on the forumhome as i want to fit 60 characters on the thread name for the top "x" stats but 60 characters in the last post area is far to big and i can only fit 20 in there.

Thanks in advance.

Yes, if you input any amount other than 0 into the "Latest Replies Thread Title Displayed Characters" setting then it will be different to that shown on the last post info.

[wilky49]

Clicks Install

[Dez_U]

Install and working great :)

[mcyates]

how do i exclude a forum?

[plateau]

how do i exclude a forum?

yea, i would like to know as well......

[Valter]

vBulletin Options > Top 'X' Stats by InfiniteWebby

[Brinnie]

And so these IPB guys got a 'small' hack (http://www.dscripting.com/D2_Statistics_22-d13.html)

Top X emoticons used:
Top X Forums With Most Topics
Top X Forums With Most Posts
Top X Forums With Most Posts
Top X Topics With Most Views
Top X Posters In The Past Week
Top X Posters In The Past Month
Top X Topic Starters
Top X Newest Members With Their Posts
Top X Polls With The Most Votes
Top X Members With Highest Posts Per Day Average
Top Topics Created By Month
Top Posts Created By Month
Top Registrations By Month
Top Birthdays By Month
Top Instant Messengers Used
Top X Youngest Forum Members
Top X Oldest Forum Members
Top X Largest Posts
Top X Most Post Icons Used
Top X Downloaded Attachments

[LockeAG]

Hi Everyone..Before everithing.. I wil start writing 3 things:
1st: This is my First Post
2nd: My english is bad
3d: I'm very new in vbulletin (yes you will hate this post)

Well I'm Using this plugin at this moment (if not what a hell Im doing here , lol) .. but I have width problem with the topXstats.php page...

I have 3 languages and 2 Skins installed at the moment in my Forum , in the first skin in the english language everithing looks perfect, but in the same skin with the GERMAN and SPANISH Language the topxstats.php page looks out of place , I Mean like 20% of the right side, shows out of the Message Area Width in FireFox and in IE well, in IE looks Terrible.

and in the second skin, in all the languages is a mess the width.

I know may be I will fix this changing values in the templates of TopXStats, but I do not know where to start.

Hope you can help me, oh, by the way , I love this plug-in.

See'ja

[InfiniteWebby]

Hi Everyone..Before everithing.. I wil start writing 3 things:
1st: This is my First Post
2nd: My english is bad
3d: I'm very new in vbulletin (yes you will hate this post)


Well I'm Using this plugin at this moment (if not what a hell Im doing here , lol) .. but I have width problem with the topXstats.php page...

I have 3 languages and 2 Skins installed at the moment in my Forum , in the first skin in the english language everithing looks perfect, but in the same skin with the GERMAN and SPANISH Language the topxstats.php page looks out of place , I Mean like 20% of the right side, shows out of the Message Area Width in FireFox and in IE well, in IE looks Terrible.

and in the second skin, in all the languages is a mess the width.

I know may be I will fix this changing values in the templates of TopXStats, but I do not know where to start.

Hope you can help me, oh, by the way , I love this plug-in.

See'ja

Try truncating the thread titles or usernames. That is the only thing I can think of at the moment. I will start working on the next version where you will be able to set how many boxes are shown in a row so the extra stats will be able to fit in without distorting the page.

[volcan]

Hi
I cant find the Manage "Products link in the nav bar"
How do i get it please?\Thank you.

[Valter]

Hi
I cant find the Manage "Products link in the nav bar"
How do i get it please?\Thank you.
In Admin CP - left frame - at the bottom. Be sure menus are extended.

[wcbryant]

Hi all,

I'd like to install Amykhar's Hideaways extention, this allows certain usergroups to essentially spawn their own private forums.

What this creates for me is a situation where those will appear (for those users) in the TopXStats area, and I'd like to avoid that.

Does anyone know how I might turn the 'excludes' field into an 'includes' instead. There are only a few forums I want showing up on that list, and would much prefer to approach it from that angle.

[InfiniteWebby]

Hi all,

I'd like to install Amykhar's Hideaways extention, this allows certain usergroups to essentially spawn their own private forums.

What this creates for me is a situation where those will appear (for those users) in the TopXStats area, and I'd like to avoid that.

Does anyone know how I might turn the 'excludes' field into an 'includes' instead. There are only a few forums I want showing up on that list, and would much prefer to approach it from that angle.

In the plugin code:

Replace:

if ($vbulletin->options['topXstats_excludedforums'] !== '') {
$excludedforums = ',' . $vbulletin->options['topXstats_excludedforums'];
}

$forumpermissions = array();
foreach($vbulletin->forumcache AS $forum) {

$forumpermissions[$forum["forumid"]] = fetch_permissions($forum['forumid']);

// ## HIDE FORUMS WITHOUT THE CANVIEW, CANVIEWOTHERS OR CANSEEDELNOTICE PERMISSION ##
if (!($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) {
$excludedforums = $excludedforums . ',' . $forum['forumid'];
}
// filter out deletion notices if can't be seen
if ($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canseedelnotice'] OR can_moderate($forum['forumid'])){
$deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";
} else {
$deljoin = '';
}
}


unset($forum);

// get rid of initial comma
$excludedforums = substr($excludedforums, 1);

if ($excludedforums != "") {
$excludedforums = "AND thread.forumid NOT IN ($excludedforums)";
}

With:

if ($vbulletin->options['topXstats_excludedforums'] !== '') {
$includedforums = ',' . $vbulletin->options['topXstats_excludedforums'];
}

$forumpermissions = array();
foreach($vbulletin->forumcache AS $forum) {

$forumpermissions[$forum["forumid"]] = fetch_permissions($forum['forumid']);

// ## HIDE FORUMS WITHOUT THE CANVIEW, CANVIEWOTHERS OR CANSEEDELNOTICE PERMISSION ##
if (!($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) {
$excludedforums = ',' . $forum['forumid'];
}
// filter out deletion notices if can't be seen
if ($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canseedelnotice'] OR can_moderate($forum['forumid'])){
$deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";
} else {
$deljoin = '';
}
}


unset($forum);

// get rid of initial comma
$excludedforums = substr($excludedforums, 1);
$includedforums = substr($includedforums, 1);

if ($excludedforums != "") {
$excludedforums = "AND thread.forumid IN ($includedforums) AND thread.forumid NOT IN ($excludedforums)";
}

This is untested so I am not sure if it will work properly. You also still need to use the setting "excluded forums" to set which forums you want to show. Cause messing with settings is alot harder than a simple code edit.

[wcbryant]

Thanks IW, that's a huge help. Will try it out first thing tomorrow. Appreciate the 'above and beyond' on top of making an already outstanding plug-in.

[Pain86]

how do i stop private forums showin.. i dont want threads from the admin forum or mod forums showin as latest threads.

how do i stop this?

thanks.

[wcbryant]

Works perfectly Infinite, thank you for the help.

[InfiniteWebby]

how do i stop private forums showin.. i dont want threads from the admin forum or mod forums showin as latest threads.

how do i stop this?

thanks.

It should do this automatically based on forum permissions. Just because you can see the thread in the stats doesn't mean your members and guests can.

[peterska2]

nice one. thanks

[wcbryant]

Works perfectly Infinite, thank you for the help.

Actually, it's showing posts from forums that are not listed in excluded, but only a few. Bizarre behavior. Been looking at it, I'm no coder, but you'd think it's more a logic puzzle than anything else. In the unlikely event I can figure out why it's doing what it is, I'll post something here.

[InfiniteWebby]

Actually, it's showing posts from forums that are not listed in excluded, but only a few. Bizarre behavior. Been looking at it, I'm no coder, but you'd think it's more a logic puzzle than anything else. In the unlikely event I can figure out why it's doing what it is, I'll post something here.

It probably has something todo with the permissions, because I didn't really change that bit of code at all.

[y2krazy]

Interesting enough, there seems to be a small error in the product. I go to the topXstats.php page and everything that I've read shows up as [OLD], but when I go back to FORUMHOME, everything still shows up as [NEW]. Even when I clicked on the "Mark Forums Read" link for my forums they still show up as new. I'm at a loss of what I need to do to fix this... ><

BTW: I just ran all of the Update Counters features, and that didn't fix it. Just wondering, but would the reason for it not working be because I am using the Database (automatic forum marking) feature that is new to vB?

EDIT: I just tried all three of the Thread/Forum Read Marking Type options and they all had the same problem, so this can't be it either. :(

[InfiniteWebby]

It is working fine for me, the code that tags a post as new or old is the same on both pages so I can't see why they shouldn't work the same. Are you sure you haven't edited the plugin or file in some way? Or even the templates?

[y2krazy]

It is working fine for me, the code that tags a post as new or old is the same on both pages so I can't see why they shouldn't work the same. Are you sure you haven't edited the plugin or file in some way? Or even the templates?
Nope, I'll try re-installing though.

EDIT: Reinstalled and it seemed to work fine... that is until I logged out and logged back in. It's doing the same thing again. :(

[InfiniteWebby]

Nope, I'll try re-installing though.

EDIT: Reinstalled and it seemed to work fine... that is until I logged out and logged back in. It's doing the same thing again. :(

You've got me beat. For the moment you will have to put up with it untill I release the next version. It will be a major rehaul so maybe the change in code will stop the hiccup.

[y2krazy]

The only change is that I added a footer to the template, like I do with all the other hacks to make them look more streamlined with the forums. I also removed the extra <br> lines before and after the blocks because they were not necessary for me(you'll have to remove those youself if want to). Screenshots are included.

Phrase Manager -> Add New Phrase
Varname: topXstats_footer
Text: Powered by <b>topXstats</b> v1.2.1 by InfiniteWebby

Style Manager -> Choose the Style to Edit -> "topXstats_stats_bit"
Find:

</tbody>
</table>
<!-- end top statistics box -->

Add Above:

<tr>
<td class="tcat" align="right" colspan="3"><span class="smallfont">$vbphrase[topXstats_footer]</span></td>
</tr>

[angelo70]

Howto.. ?
Newest Members
--------------------
Member: JoinDate:

post --> joindate vbdata formating.. plz

[artonex]

i just installed this on my forums, its great thanks for coding it :)

[slank]

installs installs installs :D

[thetoolman]

thanks, but how do i pull/echo just one variable.. say the top posters?

[InfiniteWebby]

Howto.. ?
Newest Members
--------------------
Member: JoinDate:

post --> joindate vbdata formating.. plz

In the plugin code and topXstats.php find:


$getstats_member[musername] = fetch_musername($getstats_member);

After it add:


$getstats_member[joindate] = vbdate($vbulletin->options['timeformat'], $getstats_member[joindate]);

That should work. ;)

thanks, but how do i pull/echo just one variable.. say the top posters?

I'm not exactly sure what it is you want to do.

[Brinnie]

IW, is this the final version, or will you be adding to it?

[InfiniteWebby]

No, I'll be adding to it. When I get the time. ;)

[angelo70]

No, I'll be adding to it. When I get the time. ;)

I'll be adding to it.

But timeis 1126674609 ??

vbdate() not working

[thetoolman]

I'm not exactly sure what it is you want to do.

I want to display just the top posters not the other stats. Also, how do i move it to the footer template as when i do, it displays blank.

Thanks

[InfiniteWebby]

I'll be adding to it.

But timeis 1126674609 ??

vbdate() not working

Try vbulletin->options['dateformat'] instead of vbulletin->options['timeformat']

[angelo70]

Try vbulletin->options['dateformat'] instead of vbulletin->options['timeformat']

Thanks InfiniteWebby. ^^;

But joindate is only timeformat ?
What I want is timeforumat but dateformat.

sorry.. i am not good at English

[lairnoc]

hi guyz
got another question

how to import reputation into the top stats or/and rep power..

[geoff4787]

Works great, very nice!

[theArchitect]

Would it be possible to add control over how many stats are displayed?

AND

To have each stat as an individual box (which has its own stat limit?

So I could say that I wanted the Top 20 posters displayed, but only the Last 5 new members and have them as two seperate boxes.

I use to have a mod on my forum home called DevBox, but that does not seem to have been ported to 3.5.0 and by adding Top members with Rep will add some functionality that DevBox was missing.

[fortnox]

>Hi!

Does it run with gold? :rolleyes:

[InfiniteWebby]

Certainly does. =)

[Alien]

Is it possible to just have this run as an add-on script? So you would just go to sitename.com/topXstats.php if one wished to but not have it on the front page?

I know you can remove the template modification, but it still uses 3 queries on the forumhome. I'd love to keep it, but only as an add-on page.. Thoughts?

[Alien]

I tried disabling the modification, and only going to topXstats.php and it still *appears* to be working fine (and without the additional 3 queries on the forumhome). Is this safe enough? :)

[InfiniteWebby]

Yeah, the topXstats.php code is completely seperate to the plugin, it just uses the same settings and templates.

[Alien]

Excellent. I'll leave it disabled, and use it as an add on.. Working great on wtf.com right now (have it in the navbar).

Btw, typo bug fix.. If you search your xml file for "stong" you will find one occurance. Rename that to strong and you will have 100% XHTML valid code outputted!

Thanks again!

[Capricia]

Works great, thanks for this :D

[Blackhat]

exactly what I needed :) Great job, but how can I change from 5 to 10 ?

[ThePimp]

I just upgraded to 3.5.0 Gold and TopXStats seems to have broken, do I need to reinstall?

[ukbill69]

Working with Vbulletin 3.5 Gold

[lairnoc]

works fine here too.. Only want reputation added :)

[Pramodinfo]

works like a charm thanks

[q8-star]

Thanks a lot for that great hack ,generally working fine ,but ,there is a small problem .

hacks is ok in home page but when I try the expanded topxstat the page goes blank .

My forum is arabic language forum ,I hope there is no language problem with it .

My ragrds ,,,

[popowich]

What happened to the stats from the 3.0.x version?

I like the top X replied to threads, viewed threads, voted on threads, etc.

Will that be added into the 3.5 version of the hack?

-Raymond @ WNYPoker.com (http://WNYPoker.com)

[InfiniteWebby]

Thanks a lot for that great hack ,generally working fine ,but ,there is a small problem .

hacks is ok in home page but when I try the expanded topxstat the page goes blank .

My forum is arabic language forum ,I hope there is no language problem with it .

My ragrds ,,,

It seems as though the templates weren't installed correctly. Check to see if the TOPXSTATS template has been installed.

What happened to the stats from the 3.0.x version?

I like the top X replied to threads, viewed threads, voted on threads, etc.

Will that be added into the 3.5 version of the hack?

-Raymond @ WNYPoker.com (http://wnypoker.com/)

The version you are talking about wasn't released by me. Though I will be adding some more "modules" to this hack soon.

[q8-star]

It seems as though the templates weren't installed correctly. Check to see if the TOPXSTATS template has been installed.


The template is there ,I can't see anything wrong with it.
check it here (http://www.arabic-av.com/forum/topXstats.php) please.

My regards ,,,

[jluerken]

Hi,

I want to exclude special userIDs from the TopPoster list. (like RSS Botusers etc.)

How can I manage this?

[InfiniteWebby]

@q8-star: I'm not sure what's going wrong with it.

@jluerken: Search this thread, I'm pretty sure someone else asked the same question.

[NotaBene]

Hi,

In one of my forums a membergroup's posts go directly into our moderation queue (the forum is not moderated !) Their posts are displayed in TopXStats, but are -of course- not readable until they get out of the moderation queue. That's why members get an error saying that the thread does not exist.
Do you have an explanation for this behaviour / can you change it ?

thx,
NotaBene

[jluerken]

Hi,

In one of my forums a membergroup's posts go directly into our moderation queue (the forum is not moderated !) Their posts are displayed in TopXStats, but are -of course- not readable until they get out of the moderation queue. That's why members get an error saying that the thread does not exist.
Do you have an explanation for this behaviour / can you change it ?

thx,
NotaBene

Check your usergroup settings. This has nothing to do with the hack.
I think you set the option to moderate this usergroup.

[NotaBene]

Check your usergroup settings. This has nothing to do with the hack.
I think you set the option to moderate this usergroup.

Yes, I checked it - I wanted to check it as I want posts from this usergroup to be moderated.
My problem: Although the new threads aren't displayed in forumdisplay and the posts / threads aren't readable by entering the Post-/Thread-ID (which is like it should be) the TopXStat displays them as new posts / threads.

greetz,
NotaBene

[jluerken]

@q8-star: I'm not sure what's going wrong with it.

@jluerken: Search this thread, I'm pretty sure someone else asked the same question.


I did so but I could not find the answer.

I want to exclude special userids or groups from showing up.

Example:
USERID. 1234 from an RSS Feed Bot
USERGROUP 8: Banned users should not be listed there.

[jluerken]

I found out how I can exclude users from the TOP Poster list.

In topXstats.php find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords");

I added a WHERE userid NOT IN (1282,1) which is an array of userid's.

In this example I excluded userid 1282 which is my RSS Bot and userid 1 which is the main Admin account.

In product-topXstats.xml find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords");


Reupload the topXstats.php and
then go to your ADMINCP - PLUGIN SYSTEM - MANAGE PRODUCTS - ADD/IMPORT PRODUCT and upload the change .xml file.
Make sure that "Allow Overwrite" is set to YES

Thats it!

I did not find out how to exclude a whole group like the banned group.

@InfiniteWebby:
Could you please release a version 1.3 where we can also exclude single userids and whole groups?

[jluerken]

I found a small cosmetic bug in version 1.2.1

I am displaying the top 5 posters on forumhome.
STATISTICS - TOP 5 is a link to the topXstats.php file displaying the whole toplist.

This is fine but when you click on this link its saying
STATISTICS - TOP 30 for example but redirecting to the topXstats.php file also.

On the Top30 list the link should redirect back to forumhome again I think.

Maybe something for 1.2.2 or 1.3? :D

[InfiniteWebby]

Ok, I start working on all of your requests soon, but I am having a little trouble with my hosting so I need to get that fixed first.

[vietkool]

is there any setting after import the XML files ? I've donw exactly what say in install.txt file but I can not get it to show the Stats at all

[InfiniteWebby]

Settings are in the vbulletin settings under top 'x' stats. If the stats aren't showing then it is likely the templates haven't been uploaded properly or you have plugins and products disabled.

[lairnoc]

he infinitewebby

How can i make an extra top latest threads and highest reputation ? Or will you do something like that in the future.. now people reply so fast that new threads survive lik e5 minutes on my forum...

[rb290]

thank you!
i wish all the other hacks were this easy to install

[rb290]

but one thing, is their a way i can put this at the top of the forum ?
cause its all the way at the bottom and it makes more sense to have it at the top

[jluerken]

but one thing, is their a way i can put this at the top of the forum ?
cause its all the way at the bottom and it makes more sense to have it at the top

Sure, you can place it whereever you want

In your Forumhome Template simply place it under the navbar like this


$navbar

<if condition="$show['topXstats']">
$topXstats
</if>

[rb290]

Sure, you can place it whereever you want

In your Forumhome Template simply place it under the navbar like this


$navbar

<if condition="$show['topXstats']">
$topXstats
</if>



thanks !

[xtreme-mobile]

how can i make my stats box a little less wide as it seems to be stretching my page and making my banner out of line :(

[auz1111]

Is there anyway to change which threads are shown as most recent depending on which style the user is using?

or there a way to show the stats box at the top of a subforum?

I am asking this bc I have affiliate forums that are basically subforums with different styles. When a user visites the affiliate subforum I want it to be pretty self contained and only show info from that subforum.

[bigmonay2k]

how do I change it to 10??

[InfiniteWebby]

In the vbulletin settings.

[bigmonay2k]

In the vbulletin settings.
thanks dude.

[Za4a Tuner]

Hy @ all,
at first => many thanks for the great work, i love this.

But i found a bug in this modifikation:

If someone opens a new thread with the following signs in title:
" ->
like this:
"How To Do" -> even nothing
the display of the thread in the statistic (@ Latest replies) is incorrect!

[Telegon80]

in 4 later

[blue6995]

Is there anyway of preventing the Top Posters Block from being displayed?

Thanks

[xhybrid]

hi,

your Extensions works fine @ www.r32-club.de

thank you :) :up:

[Crow]

I know this is a long shot but anyway to get this to show the newest photos from photopost (text Link)??? :nervous:

[InfiniteWebby]

Is there anyway of preventing the Top Posters Block from being displayed?

Thanks

There is no easy way at the moment. I just got a new PC so am in the middle of sorting some stuff out, I might be back later with a solution.

I know this is a long shot but anyway to get this to show the newest photos from photopost (text Link)??? :nervous:

I am not familiar with photopost so wouldn't even know where to start.

[GuaRRand]

works great!!

Maybe an idea for next version (if its not mentioned before)
Show the avatar of the #1 poster on the list?

[redlabour]

Hi,

how can i use TopXStats in iFrames in a xternal Portal PHP or HTML Block for vBa, vBP or MKPortal ?

[plateau]

stillllllllllllllll waiting for more columns coming out..................

come on mate. ... ... ^_^

[divided_by_fear]

is there any way you could get this working for vBadvanced CMPS v2.0.0 and if so thank you very much...

[caliman]

It would be nice if this did not show redirects if you move a thread.

Also if I remove top posters, what code do I have to remove so that it runs faster (doesn't query the db about top posters).

thanks! cool mod.

[outlaw621]

I found out how I can exclude users from the TOP Poster list.

In topXstats.php find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords");

I added a WHERE userid NOT IN (1282,1) which is an array of userid's.

In this example I excluded userid 1282 which is my RSS Bot and userid 1 which is the main Admin account.

In product-topXstats.xml find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords");


Reupload the topXstats.php and
then go to your ADMINCP - PLUGIN SYSTEM - MANAGE PRODUCTS - ADD/IMPORT PRODUCT and upload the change .xml file.
Make sure that "Allow Overwrite" is set to YES

Thats it!

I did not find out how to exclude a whole group like the banned group.

@InfiniteWebby:
Could you please release a version 1.3 where we can also exclude single userids and whole groups?

Did you try changing userid to usergroupid? I have not tested this yet. It is just a thought.

In topXstats.php find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords");


In product-topXstats.xml find:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

and change to:
$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords");


The above code MAY let you exclude by group instead of user. In the above examples, it should exclude group 8 which is the default banned users group.

[caliman]

Thank you outlaw I will try that.
Do you know anything about the 'moved thread' bug? It shows the redirect and the thread.

[Snoop-It]

How do i change the colour of [NEW] and [Old] - before in the 3.0.x version it was simple...

now that it has plugins etc.. its a lot harder... don't know where to look at...

Could some one please direct me to what part i should look at?

[outlaw621]

Thank you outlaw I will try that.
Do you know anything about the 'moved thread' bug? It shows the redirect and the thread.
No but I guess I can see if I can figure it out. I am in no way a coder for VB. I just figure stuff out pretty fast when I have to (but only if I have to becasue although I am not a coder, I am lazy:nervous: )

[aberg]

Question about languages translation.
Where can i translate the words [new] and [old] to a new language?
I can't find this two words.
These words display for the last treads

[LockeAG]

vbulletin Options> Top 'X' Stats by InfiniteWebby > :

Prefix Shown For New Posts:

(change)

[new]

(to)

nieuw

and do the same with :

Prefix Shown For Old Posts,

[old] to [oud]


See'a

[plateau]

how can I exclude some forums so that they will not be counted for the TOP Poster list?

[outlaw621]

how can I exclude some forums so that they will not be counted for the TOP Poster list?
To exclude certain user groups from showing in Top Posters, try the solution from post #159. As for excluding certain forums, I believe this is built in to the ACP interface part of the modification. Will be installing later today to test.

[bspiller82]

How do you hide hidden forum posts from showing in the top5 list? I have a few locked forums and the post names seem to sho in the list. On the older version I remember you edit the php file to exclude the forum but can't do that in this version.

[Telegon80]

they show for you because youre site admin but not for members with no access. i signed on with my troll account and they dont show.

[jluerken]

Small bug:

If you move a thread from one location to another and leave a pointer in the old forum then the post appears two times in the TopX list but one link is broken.

[bspiller82]

they show for you because youre site admin but not for members with no access. i signed on with my troll account and they dont show.

What I mean is when I log out and I'm a guest, I see the post title in the top5 list. You can't read the post. Is there a way to hide it from even showing the post?

[outlaw621]

What I mean is when I log out and I'm a guest, I see the post title in the top5 list. You can't read the post. Is there a way to hide it from even showing the post?
Look in the ACP interface. There is a spot where you can put the number(s) of the forum(s) that you do not want to display or even show on the top 5 list.

[InfiniteWebby]

To fix the showing of moved thread change:

$getstats_threads = $db->query_read("
SELECT
thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
" . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
$deljoin
WHERE NOT ISNULL(thread.threadid)
$excludedforums
" . iif(!$deljoin, "AND thread.visible <> 2") . "
ORDER BY lastpost DESC LIMIT 0, $displayrecords");

to:

$getstats_threads = $db->query_read("
SELECT
thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
" . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
$deljoin
WHERE NOT ISNULL(thread.threadid)
$excludedforums
" . iif(!$deljoin, "AND thread.visible <> 2") . "
AND thread.open <> 10
ORDER BY lastpost DESC LIMIT 0, $displayrecords");

I'll see about releasing a quick version update for excluding user ids and usergroup ids but at the moment ay major changes planned have been put on hold.

[The Chief]

Looking good, thanks for this awesome product ;)

[plateau]

To exclude certain user groups from showing in Top Posters, try the solution from post #159. As for excluding certain forums, I believe this is built in to the ACP interface part of the modification. Will be installing later today to test.


thanks

wating for the next version.

thank for the efforts.

[Rickie3]

thanx i love it *clicks instal*

[athoob]

that was a piece of cake .. thanx :D

[zzzxxzzz]

work with 3.5.1?

[caliman]

work with 3.5.1?

yes it well, works on mine.

[zzzxxzzz]

how can we change from top 5 stat to top 10?

[peterska2]

in the settings for it you can set the top x. change the 5 to 10.

[Club3G]

Any chance of getting code to show reputation? Latest users is kinda blah.

[teedizz]

hello, i just installed this & it works great but one problem is that it shows up in the parent style but not in the child styles...how can i get this to show in the child styles?

[poolking]

hello, i just installed this & it works great but one problem is that it shows up in the parent style but not in the child styles...how can i get this to show in the child styles?

Have you edited the FORUMHOME template in all of the styles?

[mainframe]

Hi Infinityweb,

Did you ever thought about the serverload?
a query suchs as your would defenitly slow down your page with your plugin installed. Als the forumcache table your using to get forum permissions is too big to access all the time.
Actually I think if someone would install your plugin it will use more than the whole vbulletin itself :ermm:

I think you should find a workarround for the forum permissions and try to get them in a different way, because now it's loading the whole forumcache. but only the last 5 posts are needed.

Regards,
MainFrame

[InfiniteWebby]

Hi Infinityweb,

Did you ever thought about the serverload?
a query suchs as your would defenitly slow down your page with your plugin installed. Als the forumcache table your using to get forum permissions is too big to access all the time.
Actually I think if someone would install your plugin it will use more than the whole vbulletin itself :ermm:

I think you should find a workarround for the forum permissions and try to get them in a different way, because now it's loading the whole forumcache. but only the last 5 posts are needed.

Regards,
MainFrame

I would welcome any suggestions you might have but experience has shown me that people who install this hack do not want their users to see what they shouldn't and therefore the newest posts must be grabbed on a per user basis.

As for server load I haven't really looked into it with and without this hack and don't really plan to as load isn't solely based on the one page load however the query you talk about takes a fraction of time to load, even if it is on my relatively small board.

Time Before: 0.37994 seconds
Time After: 0.38122 seconds
Time Taken: 0.00128 seconds

So at the moment load isn't a concern to me. If you find your forum slows up when this hack is installed then you are welcome to uninstall it.

[shama]

Thanks it works with me......

[caliman]

I would welcome any suggestions you might have but experience has shown me that people who install this hack do not want their users to see what they shouldn't and therefore the newest posts must be grabbed on a per user basis.

Perhaps a couple options via admin CP:

Queries:
1)Per User
2)Last 5 with private board screening
3)Raw last 5

Display:
() Latest Posts
() Newest Members
() Highest Posters
() Highest Rep
() Most Active Members

- This would be radio buttons with multi-select options

Like you said, your board is small. Just a guess, but I'd think the difference would magnify with big boards. I love your mod, but these pulls have bothered me a little. I'd love to see some of the above available for speed freaks like me.

[mainframe]

Hi Infinityweb,

thanks for your fast reply.
I have turned on debug mode and found the problem.
I have arround 90.000 registerred users on my forum(www.funfiles.ws) and arround 1500 online practicly every day arround 19:00. Because your plugin is sorting them on posts it's taking 0.34 seconds to get the top users from the database.
I've added an index in the mysql table users for posts and now it's only taking 0.0008 seconds so thats defenitly a change..

If anyone uses your plugin and have many registerred users and lots of them online I would suggest the same. add an index for posts in the user table by executing the below query in your admincp


ALTER TABLE `user` ADD INDEX ( `posts` )


Kindest Regards,
MainFrame

[tormodg]

This is a really nice hack...but I would *love* to see a "Top thread starters" stats in it! :)

[Qwest]

It doesn't work for me...

I installed it and get no errors but it's not showing up on the forumhome.

Is there a settign I need to adjust to get it to display?

I notice the code for forumhome says:<if condition="$show['topXstats']">
$topXstats
</if>

So where do I set that condition to true??

[Qwest]

CRAP nevermind I found it. It's on the bottm.

I want it on the top like on http://www.dholaholic.com/forum/ :)

[tormodg]

Read through the thread. You can place the code wherever you want in the FORUMHOME template.

[Snoop-It]

I think i asked this before.. but what vbphrase do i have to edit to change the colour for NEW and OLD.. i done this in the old version via template.. but since were using products its harder to find it.

I want to make [NEW] in red and [OLD] in blue - so its different and stands out. no one will take notice whats new and whats not if its not clearly highlighted on my board... which is why im looking into changingcolours etc....

any ideas on what vbphrase i have to edit?

cheers.

[InfiniteWebby]

I think i asked this before.. but what vbphrase do i have to edit to change the colour for NEW and OLD.. i done this in the old version via template.. but since were using products its harder to find it.

I want to make [NEW] in red and [OLD] in blue - so its different and stands out. no one will take notice whats new and whats not if its not clearly highlighted on my board... which is why im looking into changingcolours etc....

any ideas on what vbphrase i have to edit?

cheers.

It's in the settings.

[caliman]

Hi Infinityweb,

thanks for your fast reply.
I have turned on debug mode and found the problem.
I have arround 90.000 registerred users on my forum(www.funfiles.ws) and arround 1500 online practicly every day arround 19:00. Because your plugin is sorting them on posts it's taking 0.34 seconds to get the top users from the database.
I've added an index in the mysql table users for posts and now it's only taking 0.0008 seconds so thats defenitly a change..

If anyone uses your plugin and have many registerred users and lots of them online I would suggest the same. add an index for posts in the user table by executing the below query in your admincp


ALTER TABLE `user` ADD INDEX ( `posts` )


Kindest Regards,
MainFrame


I hope to have this problem some day! Thanks for sharing.

[lsgworldl]

I have a problem with my skin it dosnt fit right in it lol as you can see here

http://pspgameforums.com/forum/index.php?

[InfiniteWebby]

I have a problem with my skin it dosnt fit right in it lol as you can see here

http://pspgameforums.com/forum/index.php?

That's really a problem that your skin designer needs to fix.

[cbr929rrerion]

how can I adjust the width of the part that shows on forum home? I dont want 100% I want 95% but cant seem to find the part that determines the width that shows on the home page

[ShadowOne]

i put this and it doesnt stretch my tables on 3.5.1 plus i like the interface better without newest members showing up...

<!-- top statistics box --> <br /> <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"> <thead> <tr> <td class="tcat" colspan="3"> <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a> <a href="topXstats.php$session[sessionurl_q]">$vbphrase[statistics] - <phrase 1="$displayrecords">$vbphrase[top_x]</phrase></a></td> </tr> </thead> <tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]"> <tr> <td class="thead" width="23%" align="$stylevar[left]" nowrap="nowrap">$vbphrase[top_posters]</td> <td class="thead" width="77%" nowrap="nowrap">$vbphrase[latest_replies]</td> </tr> <tr> <td class="alt2" width="23%" valign="top"> <table> <tr> <td width="100%" nowrap="nowrap">$vbphrase[member]:</td> <td align="right" nowrap="nowrap">$vbphrase[posts]:</td> </tr> $topXstats_posters_bits </table> </td> <td class="alt2" width="77%" valign="top"> <table> <tr> <td width="70%" nowrap="nowrap">$vbphrase[thread]:</td> <td width="30%" nowrap="nowrap">$vbphrase[last_poster]:</td> <td align="right" nowrap="nowrap">$vbphrase[views]:</td> <td align="right" nowrap="nowrap">$vbphrase[replies]:</td> </tr> $topXstats_threads_bits </table> </td> </tr> </tbody> </table> <br /> <br /> <!-- end top statistics box -->

[cbr929rrerion]

I like it and it works but I wish it had the newest member in it, can you add that, I tried, no luck.. I have it on there now working the way you posted but I would like newest members and their post count as in original..

Thats for this tho.. if ya can add the other it will be great..


i put this and it doesnt stretch my tables on 3.5.1 plus i like the interface better without newest members showing up...

<!-- top statistics box --> <br /> <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"> <thead> <tr> <td class="tcat" colspan="3"> <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a> <a href="topXstats.php$session[sessionurl_q]">$vbphrase[statistics] - <phrase 1="$displayrecords">$vbphrase[top_x]</phrase></a></td> </tr> </thead> <tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]"> <tr> <td class="thead" width="23%" align="$stylevar[left]" nowrap="nowrap">$vbphrase[top_posters]</td> <td class="thead" width="77%" nowrap="nowrap">$vbphrase[latest_replies]</td> </tr> <tr> <td class="alt2" width="23%" valign="top"> <table> <tr> <td width="100%" nowrap="nowrap">$vbphrase[member]:</td> <td align="right" nowrap="nowrap">$vbphrase[posts]:</td> </tr> $topXstats_posters_bits </table> </td> <td class="alt2" width="77%" valign="top"> <table> <tr> <td width="70%" nowrap="nowrap">$vbphrase[thread]:</td> <td width="30%" nowrap="nowrap">$vbphrase[last_poster]:</td> <td align="right" nowrap="nowrap">$vbphrase[views]:</td> <td align="right" nowrap="nowrap">$vbphrase[replies]:</td> </tr> $topXstats_threads_bits </table> </td> </tr> </tbody> </table> <br /> <br /> <!-- end top statistics box -->

[ShadowOne]

I like it and it works but I wish it had the newest member in it, can you add that, I tried, no luck.. I have it on there now working the way you posted but I would like newest members and their post count as in original..

Thats for this tho.. if ya can add the other it will be great..

what you need to do, is revert the template, then.... change the 100% to 95% THEN you HAVE to change the other 3 number to add up to 95%....and it will work...or it should....if you wanna keep that other section...

[CUBS]

just upgraded to 3.5.0 my problem is when i go to my site to log on the stat box has top posters,new members and latest replies. well the top posters are right the new members are right,but the newest replies has old information and old members that are no longer around.now when i log in everything is correct. any ideas

[InfiniteWebby]

As a logged out user do you have permission to see any of the replies with the "new information"?

[cbr929rrerion]

what you need to do, is revert the template, then.... change the 100% to 95% THEN you HAVE to change the other 3 number to add up to 95%....and it will work...or it should....if you wanna keep that other section...

tired that, edited templates, xml, nothing works.. I need it at 98%

[HUMMERh3]

How do I DELETE the space right before the TOP Stats table?

On my Forum (http://www.hummerforum.org/hummers/index.php) at the bottom there is are the two different stats tables...I would like to connect them.

Anyone know What I would delete??
Thanks

[Vladi_187]

Hey i love this mod. Ive seen it on many many sites. Im trying to install it on my own site. Im pretty new to vB..i think ive done all the steps except the last one and its:

3) In your FORUMHOME template find:

<!-- end what's going on box -->

And after it add:

<if condition="$show['topXstats']">
$topXstats
</if>

Where is this 'FORUMHOME' stuff?

[Vladi_187]

Nvm i got it solved.

[newfun]

thanks you I just test on 3.5.2 still ok
But how can I move it on top near the wellcome guest area??

[Za4a Tuner]

thanks you I just test on 3.5.2 still ok
But how can I move it on top near the wellcome guest area??
Search in Template -> FORUMHOME:
</head>
<body>
$header
$navbar
und under this:
<if condition="$show['topXstats']">
$topXstats
</if>
Now the Box is placed under the Navbar ;)

[newfun]

Got it, Thanks again

[LockeAG]

Hi ..

Well I was thinking if its possible to divide Excluded Forums in Usergroups .

For example:

The Privete Staff Forum only can be seen by X# usergroups

The Adult section only for X# of Usergroups ..

I don't know if I explain myself well, but this was the idea..

see'a

[brvheart]

*clicks install*

Is there a way to get this at the top of the main page instead of the bottom?

[Za4a Tuner]

*clicks install*

Is there a way to get this at the top of the main page instead of the bottom?
Yes, there is!

Search in Template -> FORUMHOME:
</head>
<body>
$header
$navbar
und under this:
<if condition="$show['topXstats']">
$topXstats
</if>
Now the Box is placed under the Navbar ;)

[brvheart]

Yes, there is!

Search in Template -> FORUMHOME:
</head>
<body>
$header
$navbar
und under this:
<if condition="$show['topXstats']">
$topXstats
</if>
Now the Box is placed under the Navbar ;)

Thanks man!!! Awesome!!!

[Julie]

Great hack! :) Thanks! *installs*

[Thug]

how can i center topx stats title

[firstrebel]

Great hack, clicks 'install'.

Bob

[Dollah]

hey i would like this to show at the top of the forum inbetween my welcome template re-write and my shout box instead of the bottom can some one please assist me on this

[shadesvn]

I wanna change the width of Table to 762px for my template .. what should i edit ??? Thanks for reply !!

[cbr929rrerion]

I am using vbgallery, is there anyway to get this to also pull threads from the gallery as well?

[tidy_boy]

Hi there excellent hack it works fine but I did not want it at the bottom so i moved it to the top so I added this code

<if condition="$show['topXstats']">
$topXstats
</if>


just under $navbar but things are not lining up what do I need to change to get it to line up. http://www.harddanceaddict.net/forum/index.php


Thanks

[chimaira]

My admins/mods have a colour legend... like there names appear red/green/ whatever the colour i chose... When a post is a made by them the colour legend is on for the stats.
How do i make it so that when admin/mod posts... it doesnt show there name in colour on the top stats?

[brvheart]

My admins/mods have a colour legend... like there names appear red/green/ whatever the colour i chose... When a post is a made by them the colour legend is on for the stats.
How do i make it so that when admin/mod posts... it doesnt show there name in colour on the top stats?


Hmm....I have the same thing on my board....but the names show up for me...which hack do you have installed for the usergroup legend?

[chimaira]

Ah sorry what i meant was the colour of the user name... like for admins (reD) mods (green) id just rather all names be black in the top stats hack.. Just not sure if it can be done

[brvheart]

OIC, sry, I mis understood ;)

[Julie]

I've had this installed some time now, but I just noticed one thing. Suddenly in the Latest Replies column, it has a thread from 2002! And no one's replied in it. It's just a thread with 1 very old post!

Anyone else had this problem, and know how to solve it?

It's not a bigbiggie, as it seems to pull the latest replies most of the time. Just this one from 2002 that got my attention :P

[Marris]

EDIT: Nevermind, I got it working with a duplicated template and duplicated function in the plugin. It's messy, but it works.

Does anyone know if there is a relatively easy way to split the forumhome Last Threads output across two columns, rather than one?

Like:

thread 1 poster | thread 6 poster
thread 2 poster | thread 7 poster
thread 3 poster | thread 8 poster
thread 4 poster | thread 9 poster
thread 5 poster | thread 10 poster

Would it be possible to have topXstats_thread_bit set to pull the latest 1-5 threads, and make a copy called topXstats_thread_bit2 to pull latest 6-10 threads?

If it is possible, please suggest some code or point me in the right direction.

Thanks.

[amizone143]

hi guys does this works on vb version 3.5.3 pls help

[firstrebel]

hi guys does this works on vb version 3.5.3 pls help
Works on my board.

Bob

[Za4a Tuner]

Yes, it does

[teedizz]

How do I make this a little smaller because as of right now its making my forumhome look off centered.

https://vborg.vbsupport.ru/

[teedizz]

I see why its doing it. Its because of long usernames, so with that being said. Is there a way to cut of a username like after lets say 12 characters & just follow the rest with ... ?

[pikapin]

Is there a version for 3.0.7??

Thanks

[Totti]

How do I make this a little smaller because as of right now its making my forumhome look off centered.

https://vborg.vbsupport.ru/


stripping the topictitles a bit earlier, think you set it in the options

[noreturn]

Hi - Very nice hack. Installed on our board earlier today and I, and others, have made several posts. In the column "Latest Replies" under the heading "THREAD:" it does not display any text for threads. When I do make a post into a thread it will change the tilte from "old" to "new" but no name will ever appear next to it.
Any ideas?

Thanks

EDITED: Never Mind...Dummy me had it set to "0" in admin cp. I thought it would use internal setting but it did not. When I manually told it to display 25 characters it works.

[thedvs]

Can this be fixed so that guests/not logged in, users awaiting email cannot see the stats...

or some quick code to prevent them?

[redlabour]

??? This is made by your own at the AdminCP options. !!!

[thedvs]

@ redlabour is that comment made to me redlabour?
as if so I don't see an option to deny certain usergroups permission to see the stats.

[The Realist]

Getting this error in regards to uncached templates on the botton of my forums:

Uncached templates: topXstats_member_bit (5)
Uncached templates: topXstats_poster_bit (5)
Uncached templates: topXstats_stats_bit (1)
Uncached templates: topXstats_thread_bit (5)

How to I cach them?

[RDX1]

After installing this, my unregistered users couldn't view the forums. Anyone else have this problem?

[Snake]

Thanks, works fine on my forums. :)

http://forums.philosopherslegacy.net

[The Realist]

Any ideas anyone?

Getting this error in regards to uncached templates on the botton of my forums:

Uncached templates: topXstats_member_bit (5)
Uncached templates: topXstats_poster_bit (5)
Uncached templates: topXstats_stats_bit (1)
Uncached templates: topXstats_thread_bit (5)

How to I cach them?

[Snake]

Yeah I would like to know as well.

[InfiniteWebby]

Any ideas anyone?

It's already in the product. Try re-uploading and installing it.

[CupraSi]

Uploaded fine for me thanks ;)

One question

When you are in ACP it says something about extended stats pages

What is this please as I cant see it and when I click on the stats link I get a 404 page

[RDX1]

When installing:

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'topXstats_displayrecords_forumhome',
'topXstats',
'5',
'5',
'number',
'',
10,
0,
1,
'topXstats'
),
(
'topXstats_displayrecords',
'topXstats',
'30',
'30',
'number',
'',
20,
0,
1,
'topXstats'
),
(
'topXstats_maxdisplayrecords',
'topXstats',
'200',
'200',
'number',
'',
30,
0,
1,
'topXstats'
),
(
'topXstats_excludedforums',
'topXstats',
'0',
'0',
'free',
'',
40,
0,
1,
'topXstats'
),
(
'topXstats_threadchars',
'topXstats',
'0',
'0',
'number',
'',
50,
0,
1,
'topXstats'
),
(
'topXstats_userchars',
'topXstats',
'0',
'0',
'number',
'',
60,
0,
1,
'topXstats'
),
(
'topXstats_newpostprefix',
'topXstats',
'[New]',
'[New]',
'free',
'',
70,
0,
1,
'topXstats'
),
(
'topXstats_oldpostprefix',
'topXstats',
'[Old]',
'[Old]',
'free',
'',
80,
0,
1,
'topXstats'
);

MySQL Error : Duplicate entry 'topXstats_displayrecords_forumhome' for key 1
Error Number : 1062
Date : Friday, February 17th 2006 @ 07:45:55 AM
Script : *
Referrer : http://www.*/plugin.php?do=productadd
IP Address : *
Username : *
Classname : vb_database

[CupraSi]

Uploaded fine for me thanks ;)

One question

When you are in ACP it says something about extended stats pages

What is this please as I cant see it and when I click on the stats link I get a 404 page

Anyone know about the extended stats?

[Muscolino]

Yet another hack I'm having problems with :(

I've installed it but get this:
Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM user ORDER BY posts DESC LIMIT 0,;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064

[georgedd]

There seems to be a bug/ security issue I just discovered with this plugin. If the title of a new thread contains HTML tags, it's displayed as is (not converted to entities) by the top x stats plugin...

[georgedd]

BTW, I've gone ahead and fixed the "non entity" bug I reported above. For those interested, inside topxstats.php (or edit directly in vbulletin control panel), find the lines:

else
{
$getstats_thread[titletrimmed] = $getstats_thread[title];
}
}


and add beneath it one extra line:

else
{
$getstats_thread[titletrimmed] = $getstats_thread[title];
}
}
$getstats_thread[titletrimmed]=htmlspecialchars($getstats_thread[titletrimmed]);


Also, inside the template "topXstats_thread_bit", find:

title="<phrase 1="$getstats_thread[title]"

and change that to:

title="<phrase 1="$getstats_thread[titletrimmed]">

I highly recommend you implement the above changes or changes of your own. Otherwise, someone can execute arbitrary JavaScript code on your site just by entering as the title of a thread the script, such as:

<script>alert("hi")</script>