Oh well. :(

I did write a small test perl script that basically inserted a row into a table and tried to use the mysql_insertid function to get the id, and it doesn't work, so I'm confident it's entirely my problem, and not your code at all ;).

I reinstalled my Msql-Mysql-modules and when I did a make test, I noticed some failures. Hrm. Something about my Solaris 8 sparc platform I think. I'm going to try upgrading the compiler to gcc 2.95.3 and seeing if that helps (rebuilding all the DBI related modules).

If not, I'll start bugging the DBI/MySQL developers :D

Thanks for the help anyway. Good job on the hack, in any case :)

chrome.

Ok I have about 15 newsgroups online. I reindexed and the turned ON usenet index. Got the same problem I had the other day with duplicate entries. I have turned back off,

All newsgroups are working fine except a small probel with 2 of the them. I run newnews.pl and watch it download messages for these 2 groups, example tonight each one downloaded 24 messages each. I go to my forums and they still show zero in the count. I went and looked at the orphan files for each but they also are empty. The 2 groups or comp.mail.smail and comp.mail.eudora.
Does anyone where these messages might be going?

Joey

Sorry guys I think I found it. It might have worked if someone had posted to either one of those groups in the last month. They must be dead or something

Joey

Did anyone ever come with a answer to somehow minimize the amount of orphans not be posted. I have been getting a alot of them. Some of them I see 4 or 5 the same ones all re: some of them are replies to a known thread that is already showing up on my board. Any ideas or fix's

Joey

Wow - this is exactly what I've been looking for! Thank you, thank you, thank you!

I am very excited about the possiblity of integrating 2 usenet newgroups with my vBulletin forums, but I'm worried about doing anything which might endanger my hosting account.

1.) Can this script be run on a virtual/shared host? (300 other hosting accounts per RH Linux server, P3 800, 1 GB Ram)
Is anyone running this on a shared host, or is it for dedicated servers only?

2.) What kind of server resources would be required if I was looking at including 2 usenet groups which currently have 100 messages per day max?

3.) What happens if connection to the news server hangs? (lingering processes?)

Also, I am a little worried about the possibility of being targeted by a spammer who could use my forums to spam usenet and thus get my hosting account suspended.

4.) Is there any type of post rate limiter designed in?

5.) Is there an option to allow only moderated posts to usenet (or maybe an option to have them appear in the forum before being approved for posting to usenet?)

Thanks very much - this is a fantastic option. I just hope that I will be able to use it.

I just installed the script - wow!
I am using Cyrilic encoding but on my forum i have WIN-1251-codepage and usenet-topics in russian are in KOI-8. How I can convert it to 1251?

Can i get this in .zip format? Im having problems with the tar.gz format...

<a href="http://www.winzip.com/" target="_blank">http://www.winzip.com/</a> unpacks it without any trouble...

I saw Ed post a reply about a similar problem just a three or four days ago. It involved editing the vB code somewhere. Your edits will need to be a little more complicated though as you only want to make changes to forums that contain usenet threads.

The character set options in the usenet control panel are just for the quoted printable character conversions.

Sorry I can't offer any more help.

I have found how to convert KOI8 to CP1251

Modules to install - Convert::Cyrillic; Unicode::Map8

Code to add:
use Convert::Cyrillic;

Code to change:
$wd->decode(YOURTEXT) replace to
Convert::Cyrillic::cstocs ('koi8','win', YOURTEXT)

for example
$$art{body} = $wd->decode($$art{body})
$$art{body} = Convert::Cyrillic::cstocs ('koi8','win', $$art{body});


:D