vB database question

[stuuu]

Hi,

how would I go about adding a thread to the database without using vB to add it?

I have an audio page and I want to use vB as the comments backend. So when I add the audio clip into my audio database, I also want it to add a thread into the vB database, so users can comment on the audio clip.

I have made a forum where I want all the threads to be made by my audio adding script.

I have had a quick look into it, I assume I will need to add a line to the "thread" and "post" tables of vB? Is that all?

Any info on this topic would be appreciated, thanks :)

[Xenon]

you have to insert a new row into the thread and the post table, afterwards you have to update the forum counters.

just look at newthread.php there is shown whats needet :)

[stuuu]

Cheers, I will do. One other quick question about this.

I dont really want the new comments for the audio shown in the "View All New Posts" page on vB, how do I stop that from happening?

Thanks in advance.

[stuuu]

Ignore that! I'll just hide the forum from everyone cept me.

[stuuu]

01-14-03 at 06:59 PM Xenon said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=342040#post342040)
you have to insert a new row into the thread and the post table, afterwards you have to update the forum counters.

just look at newthread.php there is shown whats needet :)


finally got round to doing this, i cant see the bit for updating forum counters! anyone help pls! :)

[Xenon]

it's the line UPDATE forum SET replycoun=replycount+1 ....

[cirisme]

Doesn't updateforumcounts()(or whatever that function is) do the same thing?

That's what I've been using.

[stuuu]

Today at 06:27 PM Xenon said this in Post #6 (https://vborg.vbsupport.ru/showthread.php?postid=404373#post404373)
it's the line UPDATE forum SET replycoun=replycount+1 ....

$query = "update forum set replycount=replycount+1,threadcount=threadcount+1, lastpost='".time()."',lastposter='".addslashes($postusername)."' where forumid in ($foruminfo[parentlist])");

in that, can i just change:

$foruminfo[parentlist]

to

34

34 being the number of the forum itz going to update.

[Xenon]

nope, as this wouldn't upgrade the forums one level above it...

you should change it into (34,forumid of it's category)...