the word echo or a @ ?

thicko here when it comes to php you know and which php file ?

Thanks Gilby
I did what you said with the sql and everything seems to be working now.
I have another question that I know if kind of dumb, but I cannot figure it out. If I want to make a new forum in my control panel, how to I set the forum ID so that I can pipe the newsgroup posts into it . The only setting I could find to change was the order and they all seem to be set to 1
Thanks again

If you hover over the forum title in the Admin CP you will see something like this:

http://wocs.net/forumdisplay.php?forumid=60

The forum ID is mentioned at the end of the link

eg: forumid=60

Thats where you get the forum ID from, all you do then is enter that number into the MySQL database in the relevent section.

Hope this answers your question.

Andrew

I dont think you can alter or choose the forumid, the vbulletin software does that for you, if you do find away tho, give me a shout, cos my forumsids are in the 60 - 80 range, and I only have around 12 forums.

Thanks for the reply Sanjiyan
I never understood where they got the forum Id's before.
I fixed the forum ID and ran went to the gateway.php in my browser, but it does not seem to pipe anything in, I just get this on the white screen and nothing more. Any ideas on what else I need to do, sorry to be such a pain

1 group(s) gatewayed.
Logging in to east.usenetserver.com, group alt.binaries.nude.celebrities.female

<a href="http://www.africaplanet.com/" target="_blank">http://www.africaplanet.com/</a>

Success, I was able to successfully install this hack with vbulletin 2.2.4 version. You can see it in action at the above URL

<a href="https://groups.google.com/groups?" target="_blank">http://groups.google.com/groups?</a>

Anyway to download and display forums based not just on a particular newsgroup but refined more by topic/word search as
is possible through doing a search at google?

Do you mean from all newsgroups? Or posts just from one newsgroup? If the first, I am not aware of anything in the NNTP specifications that allow searching, but maybe there is. If there isn't, you'll have to download all newsgroups you want to search through and throw out the irrelevant posts.

If just in the one newsgroup you want to narrow it down, then you'd just throw out the irrelevant posts. I have not implimented anything to do this yet though.

See the google search feature for the newsgroups.
I included a link to it!

Does that mean you want it for all newsgroups? Then just set up all the newsgroups with this script! ;) Oh and if you do that, please let me know how the script handles that many posts. :)

I can send newsgroup messages but Iam not receiving them or they are not being posted into the section.

Whats up??

Brian

Hey Gilby
Since you were online, I just wanted to see if I could get some feedback on getting the newsgroup posts to show up on my bulletin board. Right now I get this when I run gateway.php

1 group(s) gatewayed.
Logging in to east.usenetserver.com, group alt.binaries.nude.celebrities.female

I set the forum ID to 9 in nntp_groups which corresponds to the forums I named newsgroups on my bulletin board. Any help would be appreciated.
Thanks

Gibly,

Now that my board is downloading newsgroup posts using the cron job you specified, I've noticed that the time listed for every post is the time when it was downloaded, not the time the post was made. It didn't do that when I initially ran gateway.php to get the first batch of messages, but only since I've had it running automatically. It's strange looking at the messages and having their time all end with 5! Any idea what's causing this?

Paid install
Hello I have tried everything I can think of but I cannot get this to work on my bulletin board. I would at this point like to pay somebody who know what they are doing to install it for me. I can pay through Paypal so if you are interested please email me and let me know how much you want to do the install.
Thank you

Brian Cruz: AFAICS the date on posts is the date of insertion to db not the date of post on NNTP server. Even if the script would retrieve date from NNTP server I'm not quite sure it's possible to add original post date without messing about with showthread.php, showpost.php and then adding template calls.

It was programmed to do it that way. It does this because the date on posts are defined by the poster and their clocks are usually not in sync with everyone elses. What this does in the forums then is it causes some new posts to be inserted and appear before posts that were already there.

Just curious:

Since VB updates sometimes change the sql table structure, what would be the effect when this gateway is installed?

Will future VB upgrades fail if they don't find the table structure they presume is there?

This hack only adds tables and columns to the database and does not change any existing data structures, so upgrading to a new version should not be a problem for vb. However, if vb changes the data structure, then it could affect the functionality of this hack.

It would be truly fantastic if a system like this existed which also adds the site's signature to any messages posted through it.

So it's advertising the site on each posting, even if the user doesn't have the site in their signature.

Can this be incorporated into the next release, or what files should we change to achieve this?

Thanks for such a useful hack - adds immeasurably to the forums,

Cheers,

Ross

Hi Gilby.

First of all : GREAT WORK !

BUT ;)

Your mime.php seems not to handle the following mime format:

=?iso-8859-1?q?this=20is=20some=20text?=

Many usernames contain special charsets that seem to to be encoded this way.

Where is your mime.php from ? Is there a newer version with support for it ?

PS: More Info about the format:
http://www.faqs.org/rfcs/rfc2047.html

Thank You
etom

Quick question incase anyone knows how this works.

How do I configure lynx to not bother with the cookies that global.php tries to send?

Ross,

This is very easy to do (We already do it)

Just edit your gateway.php and look for:

And add any lines just above those you want appended to every outgoing message.

For example here is ours:

Wow.

Tremendous.

May I ask - who do you use as your Usenet provider? Are there any recommendations?

I use airnews.net ... awesome service with clarinet and other newsfeeds.

Well Its working great except, all the usenet posts that ends with "?" will get posted as a new post. (ie its not combining them like others.
(It gets quite wild, if there is a active topic, and all of a sudden you have 75 new posts :)
Does anyone else has this, or is it just us?
Thx

We use news ranger http://www.newsranger.com and they work great!

i have this each time i am running gateway.php

Database error in vBulletin 2.2.2:

Invalid SQL: UPDATE forum SET replycount=replycount+1,lastpost='1016766164',last poster='Christian Daumoinx' WHERE forumid IN () mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064

what's the matter ?

I've noticed several newsgroups threads being downloaded incorrectly. The replies aren't going into the same thread as the original post. It doesn't happen all the time, but often enough to make things look messy. Could it possibly be related to the feature that starts new threads when a reply uses a different subject line? I'd like to try turning that off to see what happens, but I don't know where in the script that is.

I think I fixed it a while ago, but I must not have updated it in this thread. So, I've uploaded my latest version. The problem that i am assuming is the case here is that I did not have it match the subject correctly by using the htmlentities function as that's how they are stored in the database (ie. a " would be &quot; in the database, thus they don't match).

Also in this version is a bug fix for long threads that would have tons of references. Some nntp servers complain if this header gets too big, so this fixes that.

E-mail gateway support
Also in this version, you can now gateway with email. This will fetch emails from a POP email account and send via th mail account 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 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).

Upgrade...

I dont care to use this pop e-mail thingy, can I still upgrade and use this latest upgrade? How do I disable the pop?

Just want to fix the posts, so they go to their right threads :)

Thx

Just drop the new files in. The email support is a bonus and everything else works the same. It'll only do the email thing if the newsgroup column has an email address in there instead of a newsgroup.

Hm... I have problems with ISO-Encoded subjects and textes... for example:

Hans-J?rgen Otten

is send as

=?ISO-8859-1?Q?Hans=2DJ=FCrgen_Otten?=

by some newsreaders (I think). The problem is that the gateway.php does not translate this to Hans-J?rgen Otten. That means that the postings are not added to the correct threads...

I think that

=?ISO-8859-1?Q?{SOMETEXT}?=

means that {SOMETEXT} is encoded.

=2D would mean -

=FC would mean ?

_ would mean a space.

Is there any class or something that would translate this automatically? If not, I will have to write something...

I have found a perl module (http://aspn.activestate.com/ASPN/Cod...rdDecoder.html) for that, but not a php class...

I have just fixed the decode problem that happens in the subject and from headers. The fix makes use of the imap_mime_header_decode php function which requires php to be compiled with the imap functions, so it may not work on all setups, but the gateway script will still work as it checks to see if this function is available for use before using it.

Hi,

I have an ISP who hosts my site, but doesn't provide Usenet.

Has anyone got any recommendations who to use for large Usenet access like this? Wish to install this hack as it would enhance my board greatly, but presumably I need a Usenet provider first? Then do I just put in a username and password within the config?

Regards,

Ross

Thanks for the quick fixes, Gilby! I think the downloading and insertion of messages is nearly perfect now.

There are only a few very minor things that might be improved upon, whenever you have time. First, a way to truncate very long usernames would be helpful, since long names make the "Thread Starter" and "Last Post" columns much too wide. Also, occasionally I see no name attached to a post, whereas looking at those same posts in a newsreader shows an e-mail address. Lastly, some messages that contain quotes miss coloring the very first line of a quote, like this:

> This first line is not colored
> but this second line is.

Like I said, those are just a few minor problems on an otherwise excellent hack.

Thank you - installing the imap support was a pain but this works now :)

Graphical interface for this hack now available

With this additional hack you can administrate the gateway via the admin cp. You will only get support in that this thread: https://vborg.vbsupport.ru/showthrea...threadid=36475

The mailing list idea is quite cool!!! I won't use it, but it's a fantastic addition! Well done! :)

bump i try the last version i have always the same problem

Hi,

I've now installed and setup this hack, and didn't encounter any problems until I ran gateway.php, which then tried to download after running on the server. The contents of gateway.php generated were :

But according to my forums, there doesn't seem to be any messages downloaded.

Can anyone give me an idea as to what could be going wrong?

Many thanks for what will surely be an excellent hack,

Kind Regards,

Ross Williams