SQL queries when creating a new thread

[unnamedghost]

Hello.

I currently run a game server which uses Lua in conjunction with a MySQL database to store information. I'm attempting to make it so after an in game command is executed, it will launch an SQL query which will create a new thread inside a specific forum section on the vBulletin forums.

This is what I have so far, it basically connects the game to the vB database.

PHP Code:

local handler = mysql_connect("XXX", "XXX", "XXX", "XXX", 3306)
                  if (handler) then
                       mysql_query(handler, "query 1 goes here")
                       mysql_query(handler, "another query goes here and so forth")
                  end 


As stated earlier, I'm trying to make an automatic thread into a section using MySQL queries. I need all of the queries required when making a new thread to make sure it works properly, such as inserting the thread into the section, updating the amount of threads made, update user post count etc..

If I need to clarify anything, let me know. It might be a bit of a jumble.

Thanks in advance.