Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists Details »»
NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists
Version: 3.5.0Alpha, by lierduh lierduh is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.5.0 Rating:
Released: 07-20-2005 Last Update: Never Installs: 271
DB Changes
Additional Files Is in Beta Stage  
No support by the author.

The latest version: V3.5.0Alpha 1 (21 Jul 2005)

What is it?

This hack provides a gateway from vBulletin forums to the USENET. It allows forum members to read newsgroup messages as well as to send posts to the newsgroups. In a nutshell, it turns vBulletin forums into a basic function news reader.

For an added bonus, this package also supports mailing list archive and forum to mailing list gateway. The software retrieves messages from a pop3 account and import them into the forums threaded. It also allows a forums user to send messages to the mailing list by the forum posting interface.

Why?

The gateway will be appreciated by forum members who do not know how to set up a news reader, or people who do not have port 119 open in their network. A forum interface to read and post news are often considered to be better than a news reader.

The gateway adds more contents to your forums and allows the members to interact with wider audience. It is common to see new users signing up to use this feature.

History

This hack was originally coded by Gilby for vB2. I modified the hack to work with vB3 and have been maintaining and improving the hack. I have now done the modification for this to work with vB3.5.

The very original hack by Gilby can be found here:

https://vborg.vbsupport.ru/showthrea...7&page=1&pp=15

The vB3 version can be found here:

https://vborg.vbsupport.ru/showthread.php?t=65152

Features

Some of the features and improvement include:
  • Handles both newsgroup posts and mailing lists.
  • Handles MIME encoded messages and attachment.
  • Handles UUEncoded messages.
  • Two Admin Control Panels for all settings.
  • Automated installation.
  • Correct thread implementation. All imported messages and posts sent to newsgroups will be threaded correctly according to References and Message-ID headers.
  • Optional setting to thread by subject for mailing lists that strip references header.
  • Imported messages will be searchable just like normal forum posts.
  • Similar threads are built when the messages are imported if the system setting is on.
  • Multiple attachments importing.
  • Save attachment to database or file according to vB setting.
  • Thumbnail created while importing image files.
  • Multiple attachment post to newsgroup is also supported.
  • Selectable X-No-Archive header honouring system.
  • Light on system resources.
  • Global Killfile to filter out unwanted messages. Killfiles can have OR and AND effectiveness.
  • Strip footer by setting for incoming messages. Strips out repeated message footers.
  • Built options to disable signatures and footers for out going messages.

Future development
  • Traditional "> " lead posting interface.

What do you need and do not need?

You do not need to edit vB php files.
No need to manually run SQL.

Installation

Basically the AdminCP interfaces take care of installation as well as upgrade in the background. Back up your database first. The scripts can modify your database without alerting you!

Please follow the instructions in the readme.txt file for more details.

It is not a must to click "INSTALL" for this hack if you use it, I do try better answering the questions from people who do.

Support

Please post your support questions to this thread. Please check the FAQ in the second post within this thread first. It may be surprising, but it is possible your question is answered in the adminCP NNTP settings.

Please always provide more details about your problem. Examples and debug messages will certainly help. Well, if you don't even try to have some effort to compose your question, the answer you get may also not include much effort.

================== UPDATES ======================
Jul 21 2005 (release version 3.5.0 Alpha 1)

AdminCP xml file is written by Kadence.
  • Ported to work with vB3.5.
  • Existing bug fixes.
  • Debug message can be sent by email or logged in vB Tast Scheduler.
  • Known problem: image attachment thumb nail creation still needs work.
  • Needs to be done: Documentation.

Quick installation instruction:
1) Upload files to their correct directory
2) Enter AdminCP, click on NNTP Settings once to install/upgrade. Change settings to your like.
3) Click on NNTP Groups once to install/upgrade.
3a) For new install. Run once
http://www.yourdomain.com/setlastmsg.php

Delete this file afterwards.
If you are upgrading from an older version. There is no need to upload this file. Actually this file should not be there except brand new install.

4)
Manually run in debug mode: http://forums.yourdomain.com/gateway.php?debug=1

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #572  
Old 12-13-2007, 03:53 PM
b00k b00k is offline
 
Join Date: Feb 2005
Posts: 251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

-----------
Reply With Quote
  #573  
Old 12-29-2007, 02:45 PM
dodgez dodgez is offline
 
Join Date: Dec 2004
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Anyone know the fix to run it on 3.7?



Code:
Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:

                       INSERT INTO vb3_cronlog
                               (varname, dateline, description, type)
                       VALUES
                               ('gateway14',
                               1198943338,
                               'Ran NNTP Gateway<br />',
                               0);

MySQL Error   : Duplicate entry '64376' for key 1
Error Number  : 1062
Reply With Quote
  #574  
Old 12-29-2007, 11:56 PM
Amenothep Amenothep is offline
 
Join Date: Jul 2007
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TSR View Post
I have been reading through this thread and haven't seen an answer for this yet.

I'd check postcount ..
Reply With Quote
  #575  
Old 12-30-2007, 04:29 AM
AWS's Avatar
AWS AWS is offline
 
Join Date: Nov 2001
Location: Joliet, IL
Posts: 235
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dodgez View Post
Anyone know the fix to run it on 3.7?



Code:
Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:

                       INSERT INTO vb3_cronlog
                               (varname, dateline, description, type)
                       VALUES
                               ('gateway14',
                               1198943338,
                               'Ran NNTP Gateway<br />',
                               0);

MySQL Error   : Duplicate entry '64376' for key 1
Error Number  : 1062
Evidently something changed with the cron scripts in vbulletin. In your cron task uncheck the option to write to log.
Reply With Quote
  #576  
Old 01-03-2008, 03:05 PM
b00k b00k is offline
 
Join Date: Feb 2005
Posts: 251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

-----------
Reply With Quote
  #577  
Old 01-10-2008, 08:06 PM
solokron solokron is offline
 
Join Date: Mar 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why would I receive the following:

Code:
<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.6.8:

Invalid SQL:

			SELECT post.*, thread.*,
			post.dateline AS postdateline, post.msgid AS postmsgid,
			thread.title AS threadtitle, post.visible AS postvisible,
			thread.visible AS threadvisible
			FROM post as post LEFT JOIN thread as thread
			ON (thread.threadid = post.threadid
			AND post.userid = thread.postuserid
			AND post.postid = thread.firstpostid)
			WHERE post.isusenetpost = 0
			AND post.postid &gt; 
			AND thread.forumid = 27;

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 thread.forumid = 27' at line 11
Error Number : 1064
Date         : Monday, December 10th 2007 @ 07:00:51 PM
Script       : http://www.mydomain.com/forum/gateway.php?debug=1
Referrer     : 
IP Address   : 000.000.000.000
Username     : admin
Classname    : vB_Database</textarea></form>
forumid = 27 is a valid id and is writable.
Reply With Quote
  #578  
Old 01-11-2008, 04:08 AM
KW802's Avatar
KW802 KW802 is offline
 
Join Date: Jul 2003
Location: A galaxy far, far away...
Posts: 1,450
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by solokron View Post
Why would I receive the following:

Code:
... 
            AND post.postid &gt; 
            AND thread.forumid = 27;
...
If you check ACP => NNTP Gateway Options => NNTP Gateway Settings, is there a value for the "The max postid in post table when the script was last run." settings?
Reply With Quote
  #579  
Old 01-12-2008, 06:18 PM
mindfrost82 mindfrost82 is offline
 
Join Date: Feb 2002
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just installed this and so far it is running good, with the exception of 1 problem.

Certain messages will generate a "PHP has encountered a Stack overflow" error. The only way I can figure out to get around it is to go in and manually change the last downloaded message number so that it skips that message.

Any ideas on how to fix this? I'm running a Windows 2003 server. I have already tried increasing the memory limit in PHP and it doesn't seem to have helped.
Reply With Quote
  #580  
Old 01-14-2008, 06:18 PM
solokron solokron is offline
 
Join Date: Mar 2003
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's empty.

Quote:
Originally Posted by KW802 View Post
If you check ACP => NNTP Gateway Options => NNTP Gateway Settings, is there a value for the "The max postid in post table when the script was last run." settings?
Reply With Quote
  #581  
Old 01-14-2008, 06:36 PM
KW802's Avatar
KW802 KW802 is offline
 
Join Date: Jul 2003
Location: A galaxy far, far away...
Posts: 1,450
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by solokron View Post
It's empty.
Find the last post ID in your vBulletin and then insert that ID as the value.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:58 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05350 seconds
  • Memory Usage 2,318KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete