vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Top 'X' Stats (https://vborg.vbsupport.ru/showthread.php?t=59609)

ChrisBaktis 08-10-2004 01:36 PM

Quote:

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 08-10-2004 02:52 PM

Quote:

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 08-10-2004 02:54 PM

NM.. index.php shoulda looked first :)

jluerken 08-31-2004 10:55 AM

Quote:

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 :D
Is this possible?

InfiniteWebby 09-01-2004 12:20 AM

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 09-01-2004 10:54 AM

Quote:

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 :D

DeMiNe0 09-01-2004 12:16 PM

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 09-01-2004 02:05 PM

Quote:

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 09-02-2004 01:27 AM

its just from the hack itself.

InfiniteWebby 09-02-2004 09:27 AM

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";

Loki12 09-05-2004 12:07 PM

I would also like to see "Newest Posters" replaced with "Best Reputation". It works on this forum:

http://www.morcmtb.org/forums/

But no-one has yet given the details of how to change this. :( It would be greatly appreciated.

Nj?rd Eriksson 09-06-2004 12:31 PM

It's just a minor code change, but in general not recommended for forums on which The Curse of the Cosmo is a member, or he will start his sadsacking again. ;)

Loki12 09-07-2004 05:03 AM

Quote:

Originally Posted by Nj?rd Eriksson
It's just a minor code change, but in general not recommended for forums on which The Curse of the Cosmo is a member, or he will start his sadsacking again. ;)

LOL!!! One can never escape you mr Eriksson. :D

Loki12 09-07-2004 06:14 PM

Quote:

Originally Posted by Loki12
I would also like to see "Newest Posters" replaced with "Best Reputation". It works on this forum:

http://www.morcmtb.org/forums/

But no-one has yet given the details of how to change this. :( It would be greatly appreciated.

Alright, any takers? :ermm:

Mosh 09-23-2004 10:43 AM

* jd clicks install *

I have been testing this for a while, it is great just installed it on my live forum.
Only removed the post count for new members from the display (removed from forumhome_stats_poster template) as most usually stay at 0 before passing of the list (sign-up average of about 60 people a day).

Thank you.

JD. :)

Neal-UK 10-04-2004 12:12 PM

Quote:

Originally Posted by Loki12
Alright, any takers? :ermm:

I also would like to see Top Posters removed and just replaced with the reputation, if not, I would just like to remove top posters and leave it with Newest Members and Latest Threads, etc.

Any ideas anyone, or do I just delete this bit from the index.php file?

Bloodlust 10-04-2004 07:20 PM

I'm gonna install this ASAP. Thanks!

Blam Forumz 10-12-2004 05:36 PM

anyway to stop it grabbing posts from a selected forum?

Blam Forumz 10-12-2004 05:50 PM

nm got it :)

qwertzu 10-26-2004 09:10 AM

Quote:

Originally Posted by AnimeWebby
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)

thanks a lot

lange 10-31-2004 05:10 AM

Is there nobody, who can say me how to truncate Lastposter so that the username will be trim ?

msimplay 10-31-2004 07:07 AM

i'd like it if the latest threads also showed the thread icon chosen for it like the latest posts block on vbadvanced

but i'm also wondering how will it affect queries

Metropolitan 11-06-2004 10:03 PM

*installed*

But i have a small problem.

The statistics are shown up at the bottom of the forum home, but i want the statistics above the "Forum Contain New Posts" Icon and below the small board statistics (welcome to our...)

Can anyone help me?

TTG 11-07-2004 11:50 AM

Great hack .. installed with no problems on 3.0.3

Clicked install

Spencer F. 11-28-2004 10:22 PM

I got this hack to work on my vB 3.0.3 forum:

http://www.osdiscussion.com/

Installed!

Spyke 11-29-2004 11:37 PM

hi,

a user of mine has a long user name, becuase of its it drastically distorts my styles when it's listed in any of the top x stats table. Is there anyway to trunicate long user names in within that table? (so that if it's higher then 15 characters or something it will cut the rest off?)

Thanks.

Heo13 12-02-2004 02:47 PM

How can i make the forums (threads in them) which can only be viewed by moderators, to be viewed in Top 10 Stats at the bottom of the page?

folkish 12-05-2004 04:20 PM

/me clicks install.

Great hack, and I like the more slimline look that the member on page one of this thread suggested.

Zavsta6911 12-11-2004 04:59 AM

i installed hack fine and it shows Top 5 Stats bar, but no memebrs under the categories?

Lottis 12-20-2004 08:57 AM

Quote:

Originally Posted by Nmidia
take the ' from the front and end of the templates you created

Im missed this. Thanx fore the help. This is working great.
Clicks innstall.

kadafi_alive 12-29-2004 07:27 PM

Nevermind

shuichi_akai 12-30-2004 12:43 PM

I think it's not perfect,
The posts from invisible forum still be view by everybody,
Can you hide it from 'X' Starts ?

lanc3lot 01-02-2005 04:03 PM

Just installed this hack...anybody knows if we can exclude certain members from that table(i want to exclude the site stuff members) like we exlude forums for example?

Thanks in advance, great hack:)

I have only found this post but it seems that is only to exclude user that make specific threads...i want to exclude users from the top Posters listing

Thanks:)

lanc3lot 01-18-2005 12:48 AM

Nevermind the last one, with the kind help of animewebby i solved it:)

Does anyone knows if this is working for 3.0.5?

Rogue Pan 01-20-2005 05:49 AM

don't know but works in 3.0.6

EZ-Dozet 01-27-2005 07:16 AM

I read through this whole thread. I see spots where people ask to delete users for the top X posts. I am looking for this. I would like to have a Top X posters for all members, admin, and mods but I would like a separate box for Top X Members. Or any particular choice of user groups.

Any ideas??

TIA

Vizionz 01-28-2005 12:59 AM

this hack went smooth on 3.06 thanks for doing it up

EZ-Dozet 02-11-2005 05:05 AM

So no luck with my question then. Darn.

TRR 02-13-2005 01:28 AM

Awesome; installed..

soniceffect 02-17-2005 09:06 PM

Excellent hack ... *clicks installed*

Hoping someone can help me a little here though .. I know you`ve shown how you can stop threads being shown from a certain user .. But how do I stop a user from showing up in the top 'x' posters?


All times are GMT. The time now is 09:25 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01997 seconds
  • Memory Usage 1,842KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (12)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete