Are these 2 things possible?

[r_sole]

1 - Auto thread creation:
---------------------------------
I want to have my forum somehow automatically create a thread for me each day, with info from one of my databases (a separate database to the one Vbulletin uses).

2 - Latest thread appear on my sites front page:
---------------------------------------------------------
Since my site isn't primarily a forum I was wondering if it's possible to have the latest thread from a certain one of my forums (the 'news and announcements forum) appear on the front page of my site.

Are these 2 things possible? How do I do it? Is there a plugin or something (Im using VB 3.6.8)

[Dismounted]

1. Yes, it is possible, but you will either have to code it yourself, or hire a coder to code it for you. It would be a script that pulls that info, and then hooks itself into vBulletin's database to post the information. It would be run as a cron job.

2. Yes, it is possible, but you will either have to code it yourself, or hire a coder to code it for you. You will just have to open a connection to vBulletin's database and run a SQL query to fetch the data. I believe a modification called "vBExternal" should help.

[r_sole]

Im quite comfortable with html/php/mysql so coding it myself is really a problem.

1. Can you give me some idea of what sort of mysql statement id need to run to post a new thread? I've looked at around and some people refer to 'build_new_post() in functions_newpost.php', but those are all old threads (2004) so I'm not sure if that's outdated.

2. vBExternal looks good. Thanks, I'll look into it.

[Dismounted]

The preferred way to create new threads is through the ThreadPost Datamanager. I believe there is an article that shows how to do this.

[r_sole]

Would the script on this page (if edited to suit) be what I'm after?
http://www.vbulletin.com/forum/showthread.php?t=224561

[Dismounted]

Yes, but disregard the second post in that thread as it is correct in the first example.

[r_sole]

Awesome thanks man :up:

[r_sole]

Alright I did this (the auto-thread creation) and it works. There's just one thing, the thread gets created, but on the main page of the forum the 'last post' part doesn't get updated. So I'll be able to add the new thread, but no-one will know it's been added unless they actually go into that forum.

[Dismounted]

I believe you need to run the function build_forum_counters() to rebuild the cache.