Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Details »»

Version: , by fastforward fastforward is offline
Developer Last Online: Nov 2011 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 07-11-2001 Last Update: Never Installs: 25
 
No support by the author.

Description:

This hack provides a gateway to selected usenet groups. The entire usenet group is mirrored locally. Posts submitted locally to mirrored newsgroups will also be sent out to usenet. A single perl script is executed via cron that collects news and posts any outgoing articles. Incoming messages are parsed against customizable spam filters and threaded correctly before being placed in your forums. By default, no personal information is sent to usenet other than the posters username and whatever you have globally configured as a footer and organization. The option does exist for a user to include a custom email to use for usenet posts. After initial installation (which involves creating some new tables, adding a few columns to existing vB tables, and entering the database connection information to the news script) configuration is completed via the vB control panel.
  • See it in action at dBforums.com (usenet forums are at the bottom)
  • Download latest version for vB 2.2.4

Current version is 20020323 for vB2.xx

Current feature list:
  • correct threading of outgoing posts on usenet
  • full control panel integration
  • email notification to usenet replies
  • emoticon translation into vb icons
  • vb code removal or conversion prior to posting to usenet
  • hyperlinked urls in messages
  • color coded, italicized & indented quotes
  • vB style quote to usenet style quote conversions for outgoing posts
  • logging of outgoing posts
  • support for multiple news servers
  • support for seperate footers per forum in outgoing posts
  • multi-language (selectable) handling of quoted MIME printable headers (for all those funny foreign characters)
  • handling of mailing archive groups
  • flexible spam control and replacement variable options for incoming and outgoing messages
  • configurable auto-expire option
  • option for users to show email address in their outgoing usenet posts (may be different than normal one in profile
  • option to enable/disable user signatures on outgoing posts.
  • fully compatible with vB moderation functions
Still to be done:
  • canceling of messages after they have been sent to usenet via control message in accordance with RFC1036.
  • binary attachment support
  • email to PM gateway
Screeshots:
Main Options
More Options
Configuration of Newsgroups
Add New Newsgroups
Spam Control
What an imported usenet article looks like in vB

The latest version of this hack will always be in this first post of the thread.

Before asking questions in this thread, please read all the posts in this thread. If your question goes unanswered, it will probably be because the question has already been answered countless times in this thread.

This hack was created for use on my forums and will only be supported as time permits.


Links to required Perl Modules

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #112  
Old 08-03-2001, 10:30 AM
Pie'oh'pah
Guest
 
Posts: n/a
Default

Hi Paul,

first of all: Great hack, greatly appreaciate your efforts!

It would seem, i got 2 problems nobody else encountered so far.

When submitting the Options form in admin cp the following error appears all the time:

--------------------------------
Warning: GLOBAL variable declaration meaningless in main() scope in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 353
Your changes have been saved.
Parse error: parse error in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 378
--------------------------------

and when submitting the Groups:

---------------------------
Your changes have been saved.
Parse error: parse error in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 378
----------------------------

I can connect to the newsserver anyways, but after several 430's im getting this:

-----------------------------
Query failed:
UPDATE LOW_PRIORITY forum SET replycount=replycount+1, threadcount=threadcount+1 ,lastpost=995470170,lastposter='Trubnik.Com',lasta ctivethread='ôòõâá úï÷åô !!! TRUBNIK.COM äìñ ïðô...' WHERE forumid IN ()

DBD::mysql::db do failed: You have an error in your SQL syntax near ')' at line 1 at ./newnews.pl line 597, <SOCK1> line 4600.
bash-2.04$
-------------------------------

Can you make anything out of it?

Thanx

-Alex
Reply With Quote
  #113  
Old 08-03-2001, 10:44 AM
george_proost george_proost is offline
 
Join Date: Nov 2001
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Pie'oh'pah which release of PHP are you running? I had the same errors with PHP3, then I converted to PHP4 and no problems any more.

The errors (top2) can be ignored I think.

The other SQL error I do not know about.

The USENET code is acutally quite clean and runs without problems at may sites. If the installatuon instructions were followed to the T. It should all work ok.

But please try to upgrade to PHP4, this will really make an error report valid. I'm sure Paul will get to it soon... hang in there buddy
Reply With Quote
  #114  
Old 08-03-2001, 11:00 AM
Pie'oh'pah
Guest
 
Posts: n/a
Default

its php 4.0.4
Reply With Quote
  #115  
Old 08-03-2001, 12:50 PM
fastforward fastforward is offline
 
Join Date: Oct 2001
Location: NC, USA
Posts: 399
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Pie'oh'pah

--------------------------------
Warning: GLOBAL variable declaration meaningless in main() scope in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 353
Your changes have been saved.
Parse error: parse error in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 378
--------------------------------

and when submitting the Groups:

---------------------------
Your changes have been saved.
Parse error: parse error in /homepages/26/d17680768/htdocs/ua/vbulletin/admin/usenet.php3 on line 378
----------------------------

I can connect to the newsserver anyways, but after several 430's im getting this:

-----------------------------
Query failed:
UPDATE LOW_PRIORITY forum SET replycount=replycount+1, threadcount=threadcount+1 ,lastpost=995470170,lastposter='Trubnik.Com',lasta ctivethread='????? ????? !!! TRUBNIK.COM ??? ???...' WHERE forumid IN ()

DBD::mysql::db do failed: You have an error in your SQL syntax near ')' at line 1 at ./newnews.pl line 597, <SOCK1> line 4600.
bash-2.04$
-------------------------------
Are you sure you're on php 4.04? That usenet.php error is caused by the 'foreach()' loop. The foreach construct is not supported in php3.

The second error is probably a direct result of this as it would have caused the usenet groups not to be mapped correctly to the local forums. This is why you notice there is nothing in the SQL clause in the 'IN ()' clause. It should be full of the forums that this message belongs to.
Reply With Quote
  #116  
Old 08-03-2001, 12:55 PM
webhost's Avatar
webhost webhost is offline
 
Join Date: Oct 2001
Location: St. Louis
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Paul he is on the same server as I am, Mind is working perfectly.

Joey php 4.0.5
Reply With Quote
  #117  
Old 08-03-2001, 10:44 PM
webhost's Avatar
webhost webhost is offline
 
Join Date: Oct 2001
Location: St. Louis
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

iT is working but sometimes I get these errors when script runs

Any ideas? These were 2 different script runs, It still gets all messages and all newsgroups come back with a ok at the end of the run
============================================
Unmatched '<>' at /usr/local/lib/perl5/site_perl/5.6.1/Mail/Address.pm line 189, <SOCK1> line 177.
============================================
NNTPERROR: 421 No Next Article
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 421 No Next Article
Reply With Quote
  #118  
Old 08-03-2001, 10:54 PM
fastforward fastforward is offline
 
Join Date: Oct 2001
Location: NC, USA
Posts: 399
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by webhost
iT is working but sometimes I get these errors when script runs

Any ideas? These were 2 different script runs, It still gets all messages and all newsgroups come back with a ok at the end of the run
============================================
Unmatched '<>' at /usr/local/lib/perl5/site_perl/5.6.1/Mail/Address.pm line 189, <SOCK1> line 177.
============================================
NNTPERROR: 421 No Next Article
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 423 No Such Article In Group
NNTPERROR: 421 No Next Article
NNTPERROR: 421 No Next Article
That isn't a true error. It's just telling you the article number you requested is not available. Your lastmsgid may have got out of sync. this can happen if your news server rebuilds their index or expires a lot of news in one go. Check the latest article number using a convential news reader.
Reply With Quote
  #119  
Old 08-03-2001, 11:47 PM
tamarian tamarian is offline
 
Join Date: Oct 2001
Location: Canada
Posts: 1,205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by fastforward

You'll probably find it works fine. Obviously the line numbers for the php edits may have shifted slightly, but just search for the relevant bits. Also, remember that none of the code changes are necessary for this hack to run (discounting the minor html addition for control panel access).

If necessary, I'll release updated instructions for 2.03 over the weekend.
Paul, did you (or any usenet hack user) successfully send out going posts since upgrading to 2.0.3? I get the following error when there are any outgoinmg post:

Code:
Query failed:
INSERT IGNORE INTO usenet_outgoing(poster,email,signature,newsgroup,subject,body,threadid,postid) VALUES ('tamarian','
member@lowcarber.org',,'alt.support.diet.low-carb','N.A.S. Study: Carbs turn into fat','Scientists Find Protein That T
urns Carbs Into Fat \r\n\r\nBy Emma Hitt, PhD \r\n\r\nNEW YORK (Reuters Health) - Researchers have identified a small
protein in liver cells that may help convert excess dietary carbohydrates into fat stores. They hope that the finding
will lead to the development of obesity-fighting drugs that inhibit the actions of this protein. \r\n\r\nA team led by
 Dr. Kosaku Uyeda, of the University of Texas Southwestern Medical Center at Dallas, identified the protein they call
ChREBP in the liver of rats. \r\n\r\n``When people eat desserts, pasta, potatoes or other sugar- and starch-laden food
s beyond the body\'s energy and nutritional needs, these carbohydrates become a flood of glucose (sugar), and the live
r converts the surplus glucose to fat,\'\' Uyeda explained in a written statement. \r\n\r\nUyeda\'s team determined wh
ether ChREBP responded to excess dietary carbohydrates by feeding rats either a high-carbohydrate diet or a high-fat d
iet without starches. They found that the actions of ChREBP were enhanced with the high-carbohydrate diet, but not the
 high-fat diet. \r\n\r\nThese actions included increasing the activity of at least two and maybe three enzymes respons
ible for making fats out of excess carbohydrates, Uyeda told Reuters Health. \r\n\r\n``Inhibition of ChREBP activation
 would be expected to (lessen) excess fat accumulation resulting from a high-carbohydrate diet and provide novel oppor
tunities to address the health consequences stemming from obesity and diabetes,\'\' the researchers write in the July
31st issue of the Proceedings of the National Academy of Sciences (news - web sites). \r\n\r\n``By developing drugs to
 inhibit the actions of this protein, we should slow down the conversion of excess carbohydrates to fat,\'\' Uyeda sai
d. ``There is no medication that acts that way right now.\'\' \r\n\r\nBut such a drug remains a while off, according t
o the researcher. \r\n\r\n``Now we are just beginning to understand the structure and how this protein works,\'\' he s
aid. \r\n\r\nThe next step, Uyeda added, is to isolate large quantities of the protein so that research into drug deve
lopment can begin. \r\n\r\n``But,\'\' he said, ``this may take several years.\'\' \r\n\r\nSOURCE: Proceedings of the N
ational Academy of Sciences USA 2001;98:9116-',14835,123210)

DBD::mysql::db do failed: You have an error in your SQL syntax near ''alt.support.diet.low-carb','N.A.S. Study: Carbs
turn into fat','Scientists Find' at line 1 at ./newnews.pl line 594, <SOCK1> chunk 3.
bash$
Reply With Quote
  #120  
Old 08-03-2001, 11:53 PM
fastforward fastforward is offline
 
Join Date: Oct 2001
Location: NC, USA
Posts: 399
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by tamarian

Paul, did you (or any usenet hack user) successfully send out going posts since upgrading to 2.0.3? I get the following error when there are any outgoinmg post:
Did you do the last usenet upgrade? This error was caused by a bug introduced when I fixed the problem of the 'not include signature' problem.

It was subsequently fixed in the last version... I think
Reply With Quote
  #121  
Old 08-04-2001, 12:05 AM
tamarian tamarian is offline
 
Join Date: Oct 2001
Location: Canada
Posts: 1,205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by fastforward

Did you do the last usenet upgrade? This error was caused by a bug introduced when I fixed the problem of the 'not include signature' problem.

It was subsequently fixed in the last version... I think
Yes, I have the latest version with this signature:

$Id: newnews.pl,v 20010721 2001-07-21 03:06:32-05 paul Exp $
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:20 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05742 seconds
  • Memory Usage 2,328KB
  • Queries Executed 25 (?)
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
  • (1)bbcode_code
  • (5)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
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (9)postbit_onlinestatus
  • (11)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