thanks a lot
now assuming the next run works and i don't find any more problems in the actual collection of the posts (let's hope) a few things/improvements for v2.0 (have a rest first after all the help though!)
1. Delete post from table to be sent if user deletes it. This may be because they post in wrong forum etc.
2. Using BPCode i would think to change the colour of quoted stuff
>stuff
>here
>for example
see. Not quite sure how this can be done really. Perhaps adding the bpcode on import would be best???
3. I am going to seperate posts in newsgroups to post on forums in user account, this won't be hard i doubt and will be part of vbulletin as opposed to this hack.
4. using more than one server, i know of some newsgroups i would like to mirror that are only on 1 specific server, would need a choice for these.
5. auto pruning of a guest's user posts and auto deletion of any of these posts upon upload (referenced by a username in a certain newsgroup or by an email address etc.)
6. Hard one this is, email notification of a new newsgroup post to a thread that a member of the forum has posted in.
7. Can variables be passed into the signature i would like a sig like
type thing. Would be quite cool.
anyway that is just a few possibile things i can think of, more i am sure will come

perhaps add a few of these in (email notification most useful probably) when you do the change for v2.0 (hope that is not too hard, shouldn't be i would not think).
Cheers again for all your help.
chris