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.