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


All times are GMT. The time now is 02:42 PM.

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.01464 seconds
  • Memory Usage 1,764KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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