I am going to find out myself? I am going to be edditing the files in the next few mins. I will tell you if i find any problems.

The script does not import the attachments. The attachment stats page in the acp lists them all and says 0 bytes I can click on the link for each and it goes to a page not found. Is there something I missed?

It seems to work fine with vb3.0.4 EXtremeTim I don't use attachments on my message board, so i coundn't tell you why it doesn't work or if it should work.

Is there a way to import emails into a specific thread?

I can import into specific forums or subforums, but that is all I have as an option from the drop-down box in the Admin CP when specifying NNTP Newsgroups. I see no place where I can enter in a specific URL or already established thread...Is this possible?

Currently with this hack there is no option for this. It wouldn't be a bad idea though and really shouldn't be to hard to pull off with how this hack is coded.

heres the error this script is spitting my way from the attachments

[sql]
Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO attachment SET dateline = '1104692910',
filename = 'blackbar654.gif',
filedata = 'GIF89a?
\0?\0\0\0\0\0?\0\0\0?\0??\0\0\0??\0?\0?? ???????\0\0\0?\0??\0\0\0??\0?\0?????,\0\0\0\0?
\0 \0?I??8?ͻ?`(?di?h??l??p,?h\0;', visible = 1,
thumbnail = '',
thumbnail_dateline = ,
thumbnail_filesize = ,
filesize = 0,
postid = 82250
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 '
thumbnail_filesize = ,
filesize = 0,
po

mysql error number: 1064[/sql]

I will look at it latter tonight when I am done with my clients work and see if I can figure it out. But if anybody has any ideas for right now please let me know.

I did make one change to this script just a second ago so that I can now load in more than one newsgroup at a time. It was taking to long to load in all the messages of multiple groups and I didnt want to start with messages from that point only. Right now I am using my change to safely load in 4 newsgroups at a time which is my servers connection limit.

Lierduh, totally forgot to request this. Is there a way to block messages by their usenet username? For example it would be an extra way to block annoying messages by usenet denizens who like to OT to death certain forums under the same name.

When I try to prune in vb by using that name it never finds them either in the by name or by subject field.

Thanks again!

-Jason

Do you mean the Tile or User Title? Under the usergroup guest by default the title is "Guest - Unregistered / Not Logged In" and I have set the User Title to "Usenet Poster" how do I update all the old usenet posts to reflect the new user name?

Update Counters I think has a function to update names.

Hi!

What a great mod, thanks for sharing this!

I have two questions :

1. # of imported posts are different from those given by Outlook Express. Is there a way to search for duplicates ? (not that I trust OE, but...)
2. I'm wondering if it's legal to import msg from, say, MS newsgroups ? I mean it's not usenet

Thanks,
AG.

Hi everyone.

We still getting the same issue as listed here: https://vborg.vbsupport.ru/showpost....&postcount=677 posts going outbound get re-imported in the next run.

You can see and example here: http://forums.deeperblue.net/showpos...42&postcount=6 (original post in the forums) and http://forums.deeperblue.net/showpos...46&postcount=7 (reimported post).

Any ideas?

I have answered this question many, many times. You need to at least go through once all the NNTP settings in the control panel.

1. Need more details, does the gateway rereive more messages than OE? or the other way around. Do you have any kill files on one of these?

2. I think they wouldn't worry about archiving their newsgroups. Google does that anyway. MS newsgroups are Usenet. I am not a lawyer, so take care.:)

The kill file matches all header fields including the sender name.

May be they use some sort of ASCII charactors to fool.

You just need to forward the email with the same subject, by an automated way naturally, then it will be imported into the same thread.

The total counts are calculated based on each forum's counts when the main page loads. So it is impossible the total counts are wrong while the individual forum's stats are right.

I will check this when I get a chance to play on an empty forum.

The gateway retreive more messages than OE. I tested GW with microsoft.public.windowsxp.help_and_support, I ended with 25,261 threads and 75,698 posts, while OE retrieved 19,520 (OE showed something like 500K msg, then quickly went down to 19K)

I don't know, I'm not even sure what is a kill file :o

Thanks, lierduh! much appreciated!

Anyone know what this error is and how to fix it? I just got it 1 day after switching to a new data feed - I dont think that would cause it though

----------------------------------------------------------------------------

Database error in vBulletin 3.0.0:

Invalid SQL:
SHOW COLUMNS FROM nntp_groups
LIKE 'newsgroupid'

mysql error: Can't find file: 'nntp_groups.MYI' (errno: 2)

mysql error number: 1017

Date: Wednesday 12th of January 2005 07:15:57 PM
Script: http://www.homepokergames.com/vbforu...ntp_groups.php
Referer: http://www.homepokergames.com/vbforu...dex.php?do=nav
Username: ***
IP Address: *********

Table nntp_groups could be corrupted, as the database can not find the nntp_groups.MYI (the index file). You can try to rebuild the table, or just delete it altogher and let the script to create a new empty table.

OK, i deleted the table and re-made it. Now I am getting this error in my logs
---------------------------------------------------------------------------------

<!--
Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 1 AND userselect = 1)
OR styleid = 1
ORDER BY styleid ASC
LIMIT 1

mysql error: Unknown MySQL error

mysql error number: 2000

Date: Wednesday 12th of January 2005 08:05:04 PM
Script: http://
Referer:
Username: Unregistered
IP Address:
-->

</body></html>X-Powered-By: PHP/4.3.9
Content-Type: text/plain
Cache-Control: private

<br />
<b>Warning</b>: mysql_query(): Unable to save result set in <b>/www/k/kkiely/htdocs/vbforum/includes/db_mysql.php</b> on line <b>212</b><br />
<html><head><title>Forums Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the Forums database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:email">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>

<!--
Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1

mysql error: Unknown MySQL error

mysql error number: 2000

Date: Wednesday 12th of January 2005 08:10:05 PM
Script: http://
Referer:
IP Address:
-->

</body></html>

I installed and it´s absolutely great!

Just a few questions:

I have 2 columns, 1 for the thread starter and 1 for the last poster and long e-mail addresses, that have not set a name, are destroying the layout. Is there a workaround for this problem already been posted? I read the thread until page 27.
Is it probably because i set the table for the mailaccount from 32 to 64?

How do i make to download an archive from a mailing list?

Yes. I am using it to pull from multiple email accts and publishing to several different forums.

1. Messages are getting imported twice.. in all forums.

2. Username appears weird in many imported messages.

(*Check attachment for more details)

Regards,

PLEASE, can someone help me as soon as possible.

I read the entire Thread, but couldn´t find the answers to my questions.

I´ ve got a problem with very long e-mail addresses or long thread names. The vbulletin settings don´t match.

How is it possible to dl an entire archive?

I can´t download the same mails again. How do you do that?

*Bump.

I am using vb 3.0.3 with BB code enabled.

I just noticed that there is no chariot return between quotes and messages posted on Usenet. I got the following:

>quotemessage

My question is: How to insert (in the code) a chariot return after the quote ? Members can do it manually but it's not the best way.

Thanks

Just to make it clear, I talked to a couple of microsoft representatives about the microsoft groups and they told me that its public property so we can do what we want with it ;)

I'm currently testing this hack with the following newsgroups:

24hoursupport.helpdesk
alt.privacy.spyware
microsoft.public.security
microsoft.public.windows.inetexplorer.ie6.browser
microsoft.public.windowsxp.basics
microsoft.public.windowsxp.general
microsoft.public.windowsxp.help_and_support
microsoft.public.windowsxp.security_admin

The first three are working successfully with my account at news hosting. The last ones do not populate the forums. I've also tried the msnews.microsoft.com account and still cannot get the forums to show the posts. Is there something I am doing wrong?

Thanks.

I upgraded from older version and I get this...
I ran the upgrade and still doing this....

Thank you

Hi

I have noticed if we get the error "Could not connect to NNTP-server" the script still tries to post to the newsgroup. Would it be possible to edit the script so it doesnt try to post if it doesnt get a successful connection to the news server?

cheers

hi,

i have the problem that i set up one newsgroup in one forum for testing.

it works fine now it dont stop importing the news.
first i set the newgroup to inactive.
then i deleted the group.
then i delted the cronjob in crontab.

nothing works it is still importing like hell.
and it has still the same time. this time is hours ago.
looks like a nevernding poll of the gateway.php because the time didnt change. it is still the time when i started this the first time.

what can i do to stop this ?

thx

EDIT

all right, it seems that i found how to stop it.

i restarted apache2 webserver and now it stopped.

strange... :ermm:

exactly same problem for me.
all newsgroups are counted double.
normal forum threads just once.

and this is a clear, just one testpost, user- and hackfree (except this one) forum.
brand new installed.

Is there another way to exclude the usenet-posts from getnew instead of changing the getnew-param to
? We were informed by some users that they?ve encountered errorscausetheir browsers can?t handle the long version where everysingleforum-id is listed :ermm:

We import about 50 newsgroups in our forums and I would like tohavethem excluded likebut the string"...&exclude=120-140" won?t work. Anyone who couldshow me a quick?ndirty workaround ?

Any help appreciated.

I've been using the Usenet gateway on my vb2 forums - last sunday I did an update to vb306 at last. now i wanted to update the gateway hack too - and now I have a question - can I use this hack on existing usenet-forums within my site? Will the new hack recognize the posts and threads that are already stored on my usenet-forums and won't try to resend it to usenet groups?

I was curious as to how many different usenet newsgroup providers there were and how much they cost, so, Ive started a thread in the lounge entitled :

"What "Usenet" newsgroup provider do you use ?"

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

It would have been nice to have seen this question / link in the F.A.Q. post of this thread.

You should be able to upgrade from v2 version automatically by opening up the two control panel pages once.

No the posts already exported will not be exported again.

Will include the link in the FAQ post. Perhaps you need to make it more clear about the usage of newsgroup provider, ie. using it with a forum gateway and link back to this thread. So that people know it is not just for private access.

If you have many newsgroup forums. You can put all your local forums under one main forum. Then you can use the main forum id in the URL just as we have done for the NNTP forums.

/search.php?do=getnew&forumid=1
(1 is the main forum id for all your local forums)

lierduh,

I'm still having my issue that I posted above. I can get posts to show up on my forums, and I can successfully post. I am using the Scheduled Tasks in vb and it works fine. However, all is working fine for only the first forum in the list. I'm currently using the following groups in this order:

24hoursupport.helpdesk
alt.privacy.spyware
microsoft.public.security
microsoft.public.windows.inetexplorer.ie6.browser
microsoft.public.windowsxp.basics
microsoft.public.windowsxp.general
microsoft.public.windowsxp.help_and_support
microsoft.public.windowsxp.security_admin

All groups are enabled, and are using a personal newshosting.com account I have set up with posting access. When gateway.php runs via the scheduled tasks, it hits the first group on the list, and updates it with the new posts from the NG. I have gateway.php set to hit the groups listed above every 15 min (I've played with different times, and nothing seems to work).

Any idea why only the first group in my list will update? I've even set the first group to disabled, which allows the 2nd group to update just fine and allow posting, however the 3rd group on down are not updated. It'd be a real pain to have to enable/disable groups manually.