Ok, thanks for a quick reply.

I used to run UBB so hacking is pretty familiar thing to me and I'm just trying to estimate what risks might be involved here. It seems that at this point this is not for me :(

This hack is just so good that it would be more than great if Jelsoft makes this part of vB at some point in the future.. sooner or later, preferably ASAP! ;)

I hope that there will be some version of this hack that is suitable for us who are not that familiar with php or mysql. (easy to install and maybe some script to uninstall this hack before a vB upgrade and then somehow install it back to the system).

This script will empty the forums of all usenet posts, users and clean up the index tables. It will empty all posts in a usenet forum regardless of who posted it.

Make sure you have a working backup before running this for the first time! :)

What it does:

1. Deletes all usenet threads from thread table for all usenet forums specified in usenet_group.
2. Sets the replycount, lastpost details to null for all usenet forums.
3. Delete all posts that belonged to the threads we just deleted.
4. Deletes all searchindex entries for posts that we just deleted.
5. Resets the lastmsg numbers to zero in the usenet_group table.
6. Empties the usenet_article and usenet_ref tables
7. Deletes all users with a usertitle of 'Usenet Poster'
8. Deletes userfield table entries for the users we just deleted

Mmmm.. I have a slight problem with 2.0b3... Everything runs smooth, the only flow is that in normal forums ( the vbb forums) I suddenly get Registered: and Location: field printed twice under username while in Usenet forums it's displayed only once. Went through instructions like 5 times already, everything seems to be just fine. I was just wondering if anyone else had simmilar issue...

fastfoward...

just one thing on the admin script. If you run the news script for a few weeks and then decide to ugrade to purge everything and do a re-install, the newsgroup posts sent via the forums won't be uploaded because it checks to ensure they are not there if you see what i mean. Is there a way to override this on a fresh install?

I thought of this myself while I was trying to figure out the best way of upgrading my boards. The easiest way is to add an option to bypass the check and just load everything in.

This release (2.1) fixes some bugs and made a few efficiency changes.

Files Changed:

1. config.php
2. newnews.pl
3. memberlist.php
4. newreply.php
5. functions.php

Changes:

• moved $usenetusergroupid to config.php to avoid hard coding the id
• added variable $lastactivethread_length in config.php to limit length of thread title if used in templates.
• corrected thread and forum replycount problems
• will re-import locally originated usenet posts if not already in forum
• added $recover_deleted_localposts option to re-import any locally originated posts that are on usenet but no longer in the forums due to being deleted. If this option is on, it will mean legitimately deleted posts will also be re-imported.
• fixed problem with outgoing messages being deleted from outgoing table before being sent!
• made multiple news server support an explicit option to prevent unnecessary connects/disconnects

The documentation has been updated and there is an upgrade set of instructions if you already installed version 2.0. Download The latest release is also in the first post of this thread

The link you just provided is broken. Can you check it and provided a new link please?

Ooops! :o
It's fixed now

Your installation instructions refer to "usenet.sql", but the file you provided for download does not have this file.

It contains "vB_sql_changes.sql". Do we use this file instead?

Yep. That's the one. I'll correct the docs now.