The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 02-19-2002

This hack provides a gateway to any NNTP newsgroup such as those from Usenet and other newsgroup servers. Selected newsgroups are imported from your news server and post on the forum are sent out to the newsgroup. This hack was greatly inspired by fastforward's usenet gateway hack. This one is a complete rewrite of that hack written in PHP and works with vB 2.2.2.

Installation:
Installation is pretty simple. No modifications to the vB php files are needed and it simply consists of dropping in the files to your forums directory, running the SQL modifications, and modifying the newsgroup settings for your desired newsgroups. For the complete installation details, read the readme.txt file.

Here are some of the features:

Real cool vbcode to text conversion!
All posts are inserted, even if parent thread cannot be found for replies
Guests posts also get sent to the newsgroup.
Importing of attachments from the newsgroup
Poll info sent to newsgroup
Attachment link sent to newsgroup
Supports unlimited newsgroups and servers.
email notification of new replies, just like regular forum posts
Can import HTML messages and convert to limited vb code.

For control panel integration, please check out GameCrash's Graphical Interface addition.

What's not in it that was in fastforward's usenet gateway hack:

No control panel integration at the moment. (Available separately)
Does not support separate footers
Does not allow custom email address to be used via the users option
No spam control or string replacement support.
No purging or autoexpire.

There is still lots that I'd like to add to it, but this is competely functional for basic newsgroup gateway support. It is most likely not free of bugs.

If you have questions, suggestions or annoyances, please post in this thread.

vb3 support
lierduh modified this to provide support for the beta versions of vb3. When the release candidates of vb3 come out, I plan to add support for vb3 and add other features to this hack. If you have suggestions for new features, let me know.

E-mail gateway support
New in this version, you can now gateway with an email list. This will fetch emails from a POP email account and send via php's mail function to the mailing list's email address. To set up the list, in the newsgroup field, enter in the email address to send outgoing posts to. In the server field, enter in the pop3 server, and in the username and password fields enter in, you guessed it, the username and password to your pop account. Note: the email gateway capabilities has not been fully tested, so it might not work with your POP server. Also, it does not work in combo with a news<->forum gateway in the same forum (you can use either kind though in differnet forums within your forums).

GameCrash · #2 02-20-2002, 07:24 AM

very nice - will install it later

Does it need cron jobs?

GameCrash · #3 02-20-2002, 07:35 AM

Running the sql (that in nntp.sql) fails - the insert into nntp_groups includes a column footer which is not in the create table - I think it is from the usenet hack? Can I simply change the insert statement or do I have to change the select?

Erwin · #4 02-20-2002, 08:54 AM

This is my dream come true!

I will install it this weekend...

Thanks!

One question: If I don't do a cron job, then I have to manually run the gateway.php file myself - is that right?

dost · #5 02-20-2002, 09:36 AM

Thanks for the hack. I agree with Gamecrash:

Code:

ERROR 1054: Unknown column 'footer' in 'field list'
Query OK, 0 rows affected (0.01 sec)

Thanks

Sanjiyan · #6 02-20-2002, 12:52 PM

Quote:

Originally posted by GameCrash
Running the sql (that in nntp.sql) fails - the insert into nntp_groups includes a column footer which is not in the create table - I think it is from the usenet hack? Can I simply change the insert statement or do I have to change the select?

same here what do I need to do?

Sanjiyan · #7 02-20-2002, 12:52 PM

same here what do I need to do ?

Sanjiyan · #8 02-20-2002, 01:15 PM

Quote:

Originally posted by dost
Thanks for the hack. I agree with Gamecrash:

Code:

ERROR 1054: Unknown column 'footer' in 'field list' Query OK, 0 rows affected (0.01 sec)

Also I couldn't get it to work because nothing happens when I run gateway.php. Maybe we can have a better explanation of step 4. It seemed a little bit unclear to me. Like, should I put just news.xxx.com in the server part? And where can I check if I have PEAR installed or not?

Thanks

Same here, I can not get anything to happen when I run the gateway.php file either

I got the sql part installed by removing the footer text from the insert field, and also by removing the footers corosponding NULL entery.

Gilby · #9 02-20-2002, 02:11 PM

Quote:

Originally posted by Sanjiyan
I got the sql part installed by removing the footer text from the insert field, and also by removing the footers corosponding NULL entery.

I fixed the SQL in the first post. Please give this update a try. I removed the footer column at the last minute because I didn't implement any use for it and it might confuse some just by being there.

Gilby · #10 02-20-2002, 02:12 PM

Quote:

Originally posted by Sanjiyan

Same here, I can not get anything to happen when I run the gateway.php file either

Did anything happen? Any errors appear?

Sanjiyan · #11 02-20-2002, 02:14 PM

Quote:

Originally posted by Gilby

Did anything happen? Any errors appear?

nope no errors, just a blank white IE screen.

I didnt run it as cron, I just ran it from the address bar on IE, as I dont have access to cron and this will be ok with me, cos I can use MS TASK to run the url every 1 hour :P

Gilby · #12 02-20-2002, 02:14 PM

Quote:

Originally posted by Erwin Loh
One question: If I don't do a cron job, then I have to manually run the gateway.php file myself - is that right?

That's correct.

Sanjiyan · #13 02-20-2002, 02:25 PM

If you wish to try the link on my site Gilby:

http://www.wocs.net/gateway.php

You can see it just gives you a blank screen.

Urm I run my forums on the root of my domain, mainly because thats all I have on my website for now and the for seeable future.

Thanks

Sanjiyan · #14 02-20-2002, 02:26 PM

Quote:

Originally posted by Gilby

I fixed the SQL in the first post. Please give this update a try. I removed the footer column at the last minute because I didn't implement any use for it and it might confuse some just by being there.

I have ran a file compare on the sql file I edited and your new one and they are exatcly the same so I shall refrane from uploading this one, as theres no changes to the code. Just thought I'd let you know.

dost · #15 02-20-2002, 02:26 PM

Quote:

Originally posted by Sanjiyan
nope no errors, just a blank white IE screen.

I didnt run it as cron, I just ran it from the address bar on IE, as I dont have access to cron and this will be ok with me, cos I can use MS TASK to run the url every 1 hour :P

Same thing happened to me, but I found a solution. I searched my machine and found a file called pear.php.in, then I copied it to my forum folder and renamed it to pear.php and it worked.

Gilby: Some Turks use both the Re: and Ynt: prefix for replies in newsgroups. What can I do to recognize posts starting with Ynt: prefix as replies?

Thanks for the great hack

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06328 seconds Memory Usage 2,352KB Queries Executed 28 (?)
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 (2)bbcode_code (8)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 (2)pagenav_pagelink (2)pagenav_pagelinkrel (15)post_thanks_box (15)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (15)post_thanks_postbit_info (14)postbit (15)postbit_onlinestatus (15)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!