Automated Thread Posting System

[maximux1]

I am currently developing a system to deliver timed news releases using vBulletin and VBAdvanced. I am not really going for integration and had not planned to release as a hack - perhaps more of an add-on, perhaps not.

I currently have a non vb db setup to hold posts in "queue". The table structure is as follows:

| key | title | article | userid | username | day | month | year | hour | minute |

The date fields contain the time the article is to be posted. I am simply converting the date/time to a unix timestamp and comparing it to $now = time(). If it's later than the time stamp then the article gets published.

Here's the code I have so far - this is getting programmed articles out of non vb db to input into vb db as new threads. These new threads in turn should show up on the VBAdvanced homepage, thus allowing programmed articles.

PHP Code:

Code removed - had to rewrite. 


This is producing unexpected results. For instance, it creates a new thread, but the contents are not in the thread. It appears that it is using the contents of another post in some ways, but I am unsure how at this point.

Id appreciate anyone taking a look at that code snippit above. In particular check out the part I outlined as needing attention. I think I have something missing or wrong there.

Any and all advice is most welcome.

Thanks!

Max