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

alesis404 · #**587** 07-26-2003, 10:02 PM

problem fixed thanks to Erwin

lierduh · #**588** 07-27-2003, 12:54 PM

Edit: 2 Nov 2003.

I have mucked around a bit more to get this to work under vBulletin Version 3. A new post can be found here:

https://vborg.vbsupport.ru/showpost....&postcount=658

Quote:

07-26-03 at 02:41 AM lierduh said this in Post #584
I am using version 1.9, but I too have the sorting problem. I have noticed the last reference picks up the wrong Message-ID.

Ok, I fixed the References problem. Not a elegant way, but I post here anyway for someone who tries to do something similar, or even for me to remember what I did. I have not really tested the codes by the way.

1) Add two columns to post table.

ref (type: Text)
pre_postid (type: int, length:10)

2)hack newreply.php

diff newreply_old.php newreply.php

PHP Code:


			
26a27,30

> if (isset($pre_postid)) {

>   $pre_postid=(int)$pre_postid;

> }

> 

305c309

<       $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");

---

>       $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,pre_postid) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible','$pre_postid')");

3) Modify template: newreply

Find: <input type="hidden" name="threadid" value="$threadid">
add a line
<input type="hidden" name="pre_postid" value="$postid">

4) Modify gateway.php

diff gateway_old.php gateway.php

PHP Code:


			
20c20

< include("global.php");

---

> require_once("global.php");

23c23

< include("nntp.php");

---

> require_once("nntp.php");

25c25

< include("class.POP3.php3");

---

> //require_once("class.POP3.php3");

27c27

< include("mime.php");

---

> require_once("mime.php");

66c66

<       $get_newthreads=$DB_site->query("SELECT post.postid,post.username,post.userid,post.dateline,post.attachmentid,post.pagetext,post.showsignature,post.ipaddress,thread.pollid,thread.title,post.threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ")");

---

>       $get_newthreads=$DB_site->query("SELECT post.postid,post.username,post.userid,post.dateline,post.attachmentid,post.pagetext,post.showsignature,post.ipaddress,thread.pollid,thread.title,post.threadid,thread.forumid,post.pre_postid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ")");

74c74

<       $get_newposts=$DB_site->query("SELECT post.postid,post.username,post.userid,post.dateline,post.attachmentid,post.pagetext,post.showsignature,post.ipaddress,thread.title,post.threadid,thread.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ")");

---

>       $get_newposts=$DB_site->query("SELECT post.postid,post.username,post.userid,post.dateline,post.attachmentid,post.pagetext,post.showsignature,post.ipaddress,thread.title,post.threadid,thread.forumid,thread.msgid,thread.prefix,post.pre_postid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=". implode(" OR thread.forumid=", $group[forum]) . ")");

125a126,132

>                               if ($message[references]){

>                                       $elements=imap_mime_header_decode($message[references]);

>                                       $message[references] = '';

>                                       for($i=0;$i<count($elements);$i++) {

>                                           $message[references] .= $elements[$i]->text;

>                                       }

>                               }

214,216c221,223

<                                       }

<                                       $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,isusenetpost,msgid) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($message[subject]))."','".addslashes(htmlspecialchars(from_name($message[from])))."','0','".$date."','$attachmentid','".addslashes($message[text])."','1','0','".addslashes(htmlspecialchars(from_email($message[from])))."','0','1','1','".addslashes($message[msgid])."')");

<                                       $postid=$DB_site->insert_id();

---

>                                       }

>                                         $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,isusenetpost,msgid,ref) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($message[subject]))."','".addslashes(htmlspecialchars(from_name($message[from])))."','0','".$date."','$attachmentid','".addslashes($message[text])."','1','0','".addslashes(htmlspecialchars(from_email($message[from])))."','0','1','1','".addslashes($message[msgid])."','".addslashes($message[references])."')");

>                                         $postid=$DB_site->insert_id();

258c265

<                                       $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,isusenetpost,msgid) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($message[subject]))."','".addslashes(from_name($message[from]))."','0','".$date."','$attachmentid','".addslashes($message[text])."','1','0','".addslashes(from_email($message[from]))."','0','1','1','".addslashes($message[msgid])."')");

---

>                                       $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible,isusenetpost,msgid,ref) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($message[subject]))."','".addslashes(from_name($message[from]))."','0','".$date."','$attachmentid','".addslashes($message[text])."','1','0','".addslashes(from_email($message[from]))."','0','1','1','".addslashes($message[msgid])."','".addslashes($message[references])."')");

608,613c615,617

<                       $get_attachinfo=$DB_site->query("SELECT msgid FROM post WHERE threadid=$newthread[threadid]");

<                       $ref = '';

<                       while ($thisref=$DB_site->fetch_array($get_attachinfo)){

<                               if ($thisref[msgid] and strlen($ref) < 600){ $ref .= "$thisref[msgid] "; }

<                       }

<                       $ref = "\r\nReferences: ".wordwrap($ref, 210, "\r\n        ");

---

>                       $get_references=$DB_site->query_first("SELECT msgid,ref FROM post WHERE postid=$newthread[pre_postid]");

>                       $references = $get_references[ref] . " " . $get_references[msgid];

>                       $ref = "\r\nReferences: ".wordwrap(stripslashes($references), 210, "\r\n        ");

629c633

<                       $DB_site->query("UPDATE post SET isusenetpost = -1, msgid = '<".addslashes($msgid).">' WHERE postid=$newthread[postid]");

---

>                       $DB_site->query("UPDATE post SET isusenetpost =1, msgid ='<".addslashes($msgid).">' , ref = '".$references."' WHERE postid=$newthread[postid]");

floridaideal · #**589** 08-01-2003, 02:57 PM

Hello all

Hope someone can please help me, I have installed this wonderful hack and seem to have got it all working fine, it downloads new posts and replys to the 2 newsgroups.

Anyway my problem is that the posts posted on my forum don't post on the newsgroups. I have posted one post and a reply and its been 3 hrs and still not appeared on the newsgroup.

Out of interest I have posted via Outlook a message to the newsgroup and then within about 10 mins it appeared on my forum.

Has anyone had this problem please and can point me in the right direction? Thanks very much

Stuart

poolking · #**590** 08-01-2003, 07:27 PM

I hope this is going to upgraded for vb3.

poolking · #**591** 08-01-2003, 07:28 PM

Sorry, only just noticed double post.

floridaideal · #**592** 08-01-2003, 10:37 PM

Hi all

I have been trying to work out the problem I talked about above about my posts on the forum not being sent to the newsgroups and still can't work the problem can someone please help me solve this problem!

A little more info

I am using VB 2.3
Using Clara.net as my news provider (has username and pass to access)
and also installed the interface.

Somone please help

my email is admin@floridaideal.com

Thank you

Stuart

lierduh · #**593** 08-02-2003, 03:41 AM

Quote:

Today at 10:37 AM floridaideal said this in Post #591
Hi all

I have been trying to work out the problem I talked about above about my posts on the forum not being sent to the newsgroups and still can't work the problem can someone please help me solve this problem!

Stuart

Have you had a cron job to run the script?

the gateway.php needs to be run regularly to retrieve and post your newly posted messeages to the news server. You can manually run the script and see what message you have on the screen. Just run:

http:/www.yourforums.com/gateway.php

MaDCaT75 · #**594** 08-13-2003, 05:22 AM

Wow I must be one stupid +++++ I cant understand how to install this :cry:

insanctus · #**595** 08-13-2003, 05:28 AM

Quote:

Today at 02:22 AM MaDCaT75 said this in Post #593
Wow I must be one stupid bitch I cant understand how to install this :cry:

Takes time just relax

MaDCaT75 · #**596** 08-13-2003, 05:30 AM

Quote:

Today at 07:28 AM insanctus said this in Post #594
Takes time just relax

I still say I'm a stupid ugly bitch

irubin · #**597** 08-13-2003, 02:17 PM

Hello,

I installed the hack with no problem. I am trying to execute gateway.php - and its updating the forum, but the lastmsg in the nntp_groups table never gets updated - and the browser is attempting to download gateway.php

any ideas?

floridaideal · #**598** 08-14-2003, 02:59 PM

Hello

Is there anyway of making the newsgroups you downloaded NOT count for the final forum post count at the top of the screen?

Thanks

Stuart

floridaideal · #**599** 08-14-2003, 03:00 PM

Hello

Is there anyway of making the newsgroups you downloaded NOT count for the final forum post count at the top of the screen?

Thanks

Stuart

RealCarAudio · #**600** 08-16-2003, 10:23 PM

In the admin section you can edit the forum and there is an option close to the bottom were you state if you want the post count for that forum to be calculated in the total post count.

saab340 · #**601** 08-18-2003, 03:39 PM

I receive this error from cron e-mail... and its killing the server after it gets in the loop.... it used to work fine, what is going on, and how could I fix this....

Here is the message:
Invalid SQL: SELECT thread.threadid FROM thread,post WHERE thread.threadid=post.threadid and (thread.title='BAR:Safety Hazard & High Performance/Complex?' OR post.title LIKE '%BAR:Safety Hazard & High Performance/Complex?' OR thread.title='BAR:Safety Hazard & High Performance/Complex?' OR post.title LIKE '%BAR:Safety Hazard & High Performance/Complex?') AND (thread.forumid=187) ORDER BY post.dateline DESC LIMIT 1
mysql error: Server shutdown in progress

mysql error number: 1053

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07104 seconds Memory Usage 2,443KB Queries Executed 30 (?)
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_php (4)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 (2)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)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!