Usenet gateway

THIS THREAD IS CLOSED!
Posts in here will NOT be answered

This hack has undergone many major changes since this thread was started. Consequently, most of the posts have become dated and of little use. To coincide with the latest major release (20010712), a new one has been started.

See this thread for the latest version and discussion

[fastforward]

Gilby,

If you want to try out the new function to strip the bbcode, replace your existing one with this.

You can be the guinea pig and take all the flack from the usenet users if it goes wrong No, but seriously, I'd appreciate some help in testing it. It's getting a bit boring posting test messages to myself

sub remove_bb_code {
    my $text = $_[0];
    my ($bbo,$bbc);
    $text =~ s/&/&/ig;
    $text =~ s/\[size=[0-9]+\]|\[\/size\]//ig;
    $text =~ s/\[color=(\"\#)?[A-Za-z0-9]+(\")?\]|\[\/color\]//ig;
    $text =~ s/\[url=(\")?//ig; $text =~ s/(\")?\](.)+\[\/url\]//gi;
    $text =~ s/\[email=(\")?//ig; $text =~ s/(\")?\](.)+\[\/email\]//gi;
    $text =~ s/\[font=(\"\#)?[A-Za-z]+(\")?\]|\[\/font\]//ig;
    $text =~ s/\[list(=)?[1Aa]?\]|\[\/list(=)?[1Aa]?\]//ig;
    $text =~ s/\[\*\]/ - /ig;
    $text =~ s/\[(\/)?code\]//ig;
    my $bbcodes = db_fetch("SELECT bbcodetag FROM bbcode");
    while (my $bbcode = $bbcodes->fetchrow_array) {
      $bbo=quotemeta("[".$bbcode."]");
	   $bbc=quotemeta("[/".$bbcode."]");
	   $text =~ s/$bbo|$bbc//gi;
    }
    return $text;
}

[Dioxin]

Originally posted by tamarian


How about a a listing of the database schema? Only the relevant table/fields.

I'm still running the old hack 1.8 on RC3 since my database is no longer compatible with the last hack. Couldn't figure which fields I didn't revert/update.

Looking forward to the update!

this would be a nice feature. i am also on hack release 1.8 and i plan to alter the tables manually. this would save me a lot of time

dioxin

[jarvis]

Well, update on the Win32 install...

Looks like this won't work with Win32 systems without additional coding.

Also, some of the Perl mods don't match up, or I can't find them.

Net::NNTP and SMTP are not listed as ActivePerl mods, but NNTPClient and SMTP client are. Might be same, but then again, I'm not a technical expert.

All of the others I can find, except Date::Parse and MIME::WordDecoder.

So, I guess I'll have to wait until someone ports this to a Win32 Environment (hint, hint, maybe even money)

Thanks though for the hack...

here is html version of it.. nothing that i have done
i just added content type and br tags to it
so you can execute it online with browsers..

i was tired of getting into telnet and execute it to see the realtime result of the page..

just replace the existing newnews.pl with attached file (newnews.txt) and rename it to newnews.pl and call it from a web browser..
i checked if it works with crontab and it works of course..

[fastforward]

Nice one. I'll see if I can get time to add this. I'll add some checking to see if it's running on the console or a browser and hide the <br>'s accordingly.

[SeanM]

Are there any problems with upgrading to RC3? I have noticed that the Usenet Gateway hack has been updated to work with RC3. Just curious if there's any problems..

Originally posted by fastforward
Nice one. I'll see if I can get time to add this. I'll add some checking to see if it's running on the console or a browser and hide the <br>'s accordingly.

Great!!
(so i don't have modify coming up version of it any more.. )

[Dioxin]

one question:

if i add this:

PHP Code:

// START USENET HACK
ORDER BY seq, dateline $postorder
// END USENET HACK 


to showthread, the postorder istn't correct. i use the latest release.

why do you use this function in newnews.pl:

PHP Code:

sub order_local_posts {
   my $posts = db_fetch("SELECT threadid,postid,dateline FROM post WHERE isusenetpost=0 AND ord=0");
   while (my $post = $posts->fetchrow_hashref()) {
       my $countposts = db_fetch("SELECT COUNT(*) FROM post WHERE threadid = $post->{threadid} AND dateline < $post->{dateline}");
       my $ord = $countposts->fetchrow_array;
       $countposts->finish;
       db_execute("UPDATE post SET ord=$ord, seq=$ord+1 WHERE postid = $post->{postid}");
   } $posts->finish;
} 


it counts all posts and update the seq-field. but wgy?? if a member post to a forum, the post is added with seq = 0 and the post is displayed in the middle of the thread. so i removed the "order by seq".

please help, thanx in advance.

[fastforward]

The date you have elected to use for posts in your control panel will determine whether these functions are needed.

If you remove the order by seq line and you have selected nntpdate in your control panel, then usenet posts will not be ordered correctly for reasons explained in several posts in this thread. To get around it the posts are 'sequenced' and the thread is ordered using that column. The order_local_posts() function is to allow people to use the nntp date without editing the newreply.php file. It will simply add the sequence number for any local posts when the script is executed.

This is all irrelevent in the next release anyway so I shouldn't worry about it to much. But the bottom line is in the current version, those things are needed unless you want confused users.

[Mark Hewitt]

I actually removed the seq part a long time ago as it was causing threads in my normal forums to appear out of order.