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

Closed Thread
 
Thread Tools
Details »»

Version: , by (Guest)
Developer Last Online: Jan 1970 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-21-2001 Last Update: Never Installs: 3
 
No support by the author.

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

Show Your Support

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

Comments
  #192  
Old 03-29-2001, 04:44 AM
Guest
 
Posts: n/a
Default

You can do it from the control panel in the 'Groups Section'

There is an option at the very top to purge all posts, or you can do it for each group.

But if you want to do it by hand you are correct in what you said. 'where isusenetpost=1'
  #193  
Old 03-29-2001, 04:55 AM
Guest
 
Posts: n/a
Default

Oops, that didn't work right. It just deleted the posts from the usenet forum, not from the screwed up one! I'll table by table.
  #194  
Old 03-29-2001, 04:57 AM
Guest
 
Posts: n/a
Default

Ah.. yeah.. sorry. I should have realized that. It's another safety feature to only delete from forums that are specified in the usenet_group table. As you've deleted it from that table it ignores it.
  #195  
Old 03-29-2001, 05:39 AM
Guest
 
Posts: n/a
Default

Fastforward, I think I found the explanation to what happened. I grep'd on test and found this:

vB_sql_changes.sql:INSERT INTO usenet_group (newsgroup, forum, lastmsg, server,
username, password, enabled, footer) VALUES ( 'alt.test', '2', '0', '', '', '',
'1', '');

I'm not sure if this was 2.1 or 2.3, but one of them probably wasn't 9999. Just in case anyone has the same installation.

Those funny threads were probably sucked in before I deleted alt.test.

Everything's fine now, and I'll install the 2.4
  #196  
Old 03-29-2001, 05:49 AM
Guest
 
Posts: n/a
Default

The link for downloading 2.4 doesn't work?
  #197  
Old 03-29-2001, 05:56 AM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by tamarian
The link for downloading 2.4 doesn't work?
Doesn't work for me, but it did earlier. Here's a link that works: http://britishexpats.com/download/us...4__20b3.tar.gz
  #198  
Old 03-29-2001, 01:30 PM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by tamarian
Fastforward, I think I found the explanation to what happened. I grep'd on test and found this:

vB_sql_changes.sql:INSERT INTO usenet_group (newsgroup, forum, lastmsg, server,
username, password, enabled, footer) VALUES ( 'alt.test', '2', '0', '', '', '',
'1', '');

I'm not sure if this was 2.1 or 2.3, but one of them probably wasn't 9999. Just in case anyone has the same installation.

Those funny threads were probably sucked in before I deleted alt.test.
Well, I don't kow what to say, except I'm very sorry. I'm guessing I overwrote my original statement that had 9999 when I gave the docs an overhaul. To ensure everything worked I extracted the DDL & DML from my setup using phpMyAdmin. My setup was just for test and I did have the alt.test group pointing to forum #2.

I have now removed the alt.test group completely. I'll also add a note in the docs to double check the groups options page and make sure the forums specified are really where you want the usenet messages to go before runing the script for the first time.

The download link was a good one, but I woke up this morning to find my disk was full. Apparently I no longer have access to /dev/null so all my log files filled up. I guess I'll be on the phone all day to Host Pro

Has anybody installed 2.4 yet? Is it all working OK?
  #199  
Old 03-29-2001, 03:07 PM
Guest
 
Posts: n/a
Default

Quote:
Originally posted by fastforward
Well, I don't kow what to say, except I'm very sorry. I'm guessing I overwrote my original statement that had 9999 when I gave the docs an overhaul. To ensure everything worked I extracted the DDL & DML from my setup using phpMyAdmin. My setup was just for test and I did have the alt.test group pointing to forum #2.
[/B]
No problem Fastforward, was just a minor inconvenience, nothing compared to the work you've done on this hack, which is the best vb hack in my book
  #200  
Old 03-29-2001, 07:49 PM
Guest
 
Posts: n/a
Default

With 2.4 i'm actually getting
Parse error: parse error in /usr/local/apache/htdocs/forum/admin/functions.php on line 871

Fatal error: Call to undefined function: vbdate() in /usr/local/apache/htdocs/forum/admin/sessions.php on line 326

in both admin/ and forum

It's the
$DB_site->query("UPDATE forum SET lastactivethread = LEFT('"..addslashes(htmlspecialchars($threadinfo[title]))."',$lastactivethread_length) WHERE forumid = ".$threadinfo[forumid]);
line...
  #201  
Old 03-29-2001, 08:33 PM
Guest
 
Posts: n/a
Default

I wrote a script that let's you insert an archived newsgroup or mailing list into the usenet tables. I wrote it so that I could import all the messages since the newsgroup was created and so that I could feed the new messages in from two sources, the mailing list and the newsgroup. Feeding it in from the two sources, I hope will eliminate my missing posts problem for the ones that don't make it into the newsgroup.

This script will read mail in from a file or from an email alias and then parses it to be included in the database. Then the messages will be inserted with the newnews.pl script provided in the Usenet Gateway hack. This script does not make use of any of the spam/binary filtering or other replacement strings that occur before it's inserted.

How to use this script:

From the command line, execute the script like:
Code:
./mail2forum.pl < filename2messages.txt
That will insert all the messages in the text file into the database. The text file needs to conform to the mail standards, so it's the same format as the sendmail spool files and the same as what many other email programs use. (Basicly, the beginning of a message is signified by a line beginning with "From " followed by the headers, then an empty line, and then the body).

This script can also be used to insert a message sent to an email address right into the database. To do this, you'll need to create an alias in the sendmail aliases (usually at /etc/aliases) to execute the script. The alias would look like this:
Code:
forum: "|/path/to/mail2forum.pl"
Most systems are set up so that not just any script can be executed by sendmail for security reasons. Usually, you'll need to create a symbolic link to the file in a special directory (as root). In the systems I've used, this directory has been "/etc/smrsh/" or "/usr/adm/sm.bin/".

You'll need to rename the file to have the .pl extension.
Closed Thread


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 04:14 PM.


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.05057 seconds
  • Memory Usage 2,281KB
  • 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
  • (2)bbcode_code
  • (3)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
  • (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
  • 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