del

any ideas on how to stop it updating all threads?
I have tried to install this but the newsgroup i want to get threads from has 3 months worth of posts - i only want the last months threads.
everytime i manually prune the forum the next time the gateway.php runs it brings in the old posts again.

==============================================
Can someone tell me the correct syntax to run this line as a query and create this?

ALTER TABLE thread ADD isusenetpost TINYINT(2) DEFAULT 0 not null;

*I tried creating the table manually but after doing the mod and trying view new posts I got a white screen and suspect maybe the table I have is made wrong, thanks

I couldn't get that querie to worked - kept giving me a syntax error. The post beneath that one you quoted provided the solution for me. :)

which NNTP service provider is everyone here using??

thanks

Someone mentioned to remove certain users usenet posts you could do this

Using phpmyadmin I am trying to run a sql query and am not sure I am doing this properly and need confimation, is the exact line that needs to be typed

DELETE FROM post WHERE username='username'

of course replacing 'username' with the actual username who's posts you need deleted or is there some other code that must be added before this to the standard query from phpmyadmin? I seem to get a syntax error trying to run that line and assume i am missing a small code snippet that might go in front of that line of the querys?

Post #334 mentioned to alter the table thread and add

ALTER TABLE thread ADD isusenetpost TINYINT(2) DEFAULT 0 not null;

I did this manually and appears I have the table right but going by the last error I got was I supposed to make another change to mention that extra column?

*I did also make the mod to search.php and appears to be blocking posts from "view new posts but now I have this error"

I'm using Giganews and it's working fine. I also made some changes to the signature routines - because I wanted them to say something different and because the signature separator wasn't RFC 1036-compliant and some newsreaders were having problems strippng them off.

A compliant signature separator is <linefeed><dash><dash><space><linefeed> Gilby's hack (while outstanding) was missing the space and some newsreaders wouldn't strip the signature out of quoted vB Usenet posts.

This hack has added real value to my board - thanks, Gilby!

I was going to use my Easynews account, but chickened out when I read the TOS. They were very much ''you must use the account soley for your own use''. Technically it is, but I figured too dicey as I'm in the UK and my site is on a US server, and they might notice I can't be in two continents at once. :P In the end I went with teranews.com who give 50mb a day free, which is plenty for the couple of text groups I use. They charge a one off $3.95, which isn't bad. Had no problems so far.

I'm just gearing up to switch the posting function on. Am a bit nervous of that in case it posts what's already there. I guess I'm gonna have to re-read this whole thread again <whimpers> but am I remembering rightly that people can't use the normal vbcodes when replying? Or if they do they don't get converted like they do on the way in? That'll take some getting used to for some of my members.

Is anybody sucessfully doing this through phpmyadmin and if so what is the exact query you are using? I tried this and it gives me a syntax error on line 1 and I really have alot of posts I would like to remove asap...thanks

DELETE FROM post WHERE username='username' <---this give me bad syntax when i run this query from phpmyadmin? is there something that goes in front or behind this...sorry for asking again but I've been waiting all weekend to be able to remove bulk spam posts and would appreciate help from anybody using phpadmin to run this query and delete posts by user, note I cannot mass prune by user from admincp and when I try it hops to the next page but appears there is buttons missing and I cant perform the action...perhaps others know what I mean....