unnamedghost
05-25-2013, 01:32 AM
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.
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.
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.
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.