Top 'X' Stats

This hack adds the top 'x' stats (top posters, newest members, newest replies) to your forumhome.

The original idea was nanoentities but he will not be releasing his hack for vB3. Basically this is the same idea, all new coding, all new templates.

This hack also shows a 'New' or 'Old' text if the thread was posted after your lastvisit or marking all forums as read. Also it posts the deleted message for those who can see it and can be set to exclude forums.

I am currently working on a seperate page where the user can set the number of stats he wishes to show.

Live demo at: *removed* (dow the bottom)

vB 3.5 version available at https://vborg.vbsupport.ru/showthrea...846#post743846 !!!

[ChrisBaktis]

Originally Posted by bspiller82

Anyway to prevent it from showing Priviate/locked forum posts in the top forum post list?

You need to change the line below with the forums ID you want excluded:

PHP Code:

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7" 


[bspiller82]

Originally Posted by ChrisBaktis

You need to change the line below with the forums ID you want excluded:

PHP Code:

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7" 


Good good, what file or template do I stick this in?

[bspiller82]

NM.. index.php shoulda looked first

[jluerken]

Originally Posted by AnimeWebby

This hack adds the top 'x' stats (top posters, newest members, newest replies) to your forumhome.

Hi AnimeWebby,

is it possible to remove threads from the newest threads section which are done from a special user?

I am using one user to post news from rss feeds into my board and now this is the only user shown in the list so I will exclude it
Is this possible?

[InfiniteWebby]

Add:

PHP Code:

$excludedusers = "0"; // users to be excluded from latest threads. Format "0,5,7" 


Under:

PHP Code:

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7" 


And change 0 to the id's of the user/s that you use to post rss feeds.

And Add:

PHP Code:

AND thread.userid NOT IN ($excludedusers) 


Under:

PHP Code:

WHERE thread.forumid NOT IN ($excludedforums) 


BTW this is untested so backup your index.php file before doing this, as you might need to re use it later.

Oh and terribly sorry for not releasing any new version I have been extremely busy with work and my sites. Hopefully I might get something done soon.

[jluerken]

Originally Posted by AnimeWebby

Add:

PHP Code:

$excludedusers = "0"; // users to be excluded from latest threads. Format "0,5,7" 


Under:

PHP Code:

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7" 


And change 0 to the id's of the user/s that you use to post rss feeds.

And Add:

PHP Code:

AND thread.userid NOT IN ($excludedusers) 


Under:

PHP Code:

WHERE thread.forumid NOT IN ($excludedforums) 


BTW this is untested so backup your index.php file before doing this, as you might need to re use it later.

Oh and terribly sorry for not releasing any new version I have been extremely busy with work and my sites. Hopefully I might get something done soon.

It must be

PHP Code:

AND user.userid NOT IN ($excludedusers) 


and not

PHP Code:

WHERE thread.forumid NOT IN ($excludedforums) 


then is your modification working.

You should add this to the downloadable version

[DeMiNe0]

Database error in vBulletin 3.0.3:

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 vb3_thread AS thread
LEFT JOIN vb3_user AS user ON (user.username = thread.lastposter)
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()

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 ')

ORDER BY thread.lastpost DESC LIMIT 0, 5' at line 6

mysql error number: 1064

Date: Wednesday 01st of September 2004 09:15:02 AM
Script: http://www.digitaltoxicity.net/forums/index.php?
Referer: http://www.digitaltoxicity.net/forum...ex.php?do=head
Username: DeMiNe0

[jluerken]

Originally Posted by DeMiNe0

Database error in vBulletin 3.0.3:

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 vb3_thread AS thread
LEFT JOIN vb3_user AS user ON (user.username = thread.lastposter)
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN ()

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 ')

ORDER BY thread.lastpost DESC LIMIT 0, 5' at line 6

mysql error number: 1064

Date: Wednesday 01st of September 2004 09:15:02 AM
Script: http://www.digitaltoxicity.net/forums/index.php?
Referer: http://www.digitaltoxicity.net/forum...ex.php?do=head
Username: DeMiNe0

Demineo is this a failure which came up after you installed the hack or my modification?
If this came from the small modification then please read my thread above yours and change the line to fix this.

[DeMiNe0]

its just from the hack itself.

[InfiniteWebby]

I don't think you can have a null value for your $excludedforums variable so just stick a 0 in there and tell me what happens.

I.E $excludedforums = "0";