Custom News script also needs to generate new thread with same details

[Snetty]

I've been redeveloping one of my sites (www.mousepilot.co.uk) for the past week or so, using vBulletin as the base for it. My custom scripts allow myself and users to post articles and news on the main site. I can obviously edit these etc.

Something I want to be able to add to these scripts is the ability to automatically create a corresponding discussion thread in vb. The main site and vBulletin use the same database so in theory it should be easy. I've had a look at the thread and post tables, and decided that there are to many fields that I don't understand their purpose for me to be able to have a go at this without more information.

Something else that occurred to me is that I'd probably need to update the various statistics associated (total threads, posts per user etc etc) which I guess is something that I shouldn't have any major difficulty with. I just need confirmation that this is necessary really.

Has anyone ever tried something similar? Either way, is there any chance that someone can give me an insight into the various fields in the thread and posts tables, their uses and what values I need to put in each.

I'm also not sure that this is in the right forum, so mods feel free to move it.

[Danny.VBT]

Here's a post by Andreas that shows how to create a new thread using vBulletin's datamanager: http://www.vbulletin.org/forum/showp...01&postcount=7

HTH,
Danny

[roosevelt]

I've been redeveloping one of my sites (www.mousepilot.co.uk) for the past week or so, using vBulletin as the base for it. My custom scripts allow myself and users to post articles and news on the main site. I can obviously edit these etc.

Something I want to be able to add to these scripts is the ability to automatically create a corresponding discussion thread in vb. The main site and vBulletin use the same database so in theory it should be easy. I've had a look at the thread and post tables, and decided that there are to many fields that I don't understand their purpose for me to be able to have a go at this without more information.

Something else that occurred to me is that I'd probably need to update the various statistics associated (total threads, posts per user etc etc) which I guess is something that I shouldn't have any major difficulty with. I just need confirmation that this is necessary really.

Has anyone ever tried something similar? Either way, is there any chance that someone can give me an insight into the various fields in the thread and posts tables, their uses and what values I need to put in each.

I'm also not sure that this is in the right forum, so mods feel free to move it.

I did something similar in my website. What I did basically as soon as the article is posted, a thread is created on the specified forum. I simply added the info directly in the database with the user's name, id and such that. And then I have setup a cron to recount all the posts, threads, every hour... so this also takes care of the posts stats. Ask in the www.vbulletin.org and you will get someone... and I think web programmers might charge you for this work.