[Riotblade]

I'm trying to execute some basic queries using SQLX. However, some queries work and some queries don't (mainly the INSERT queries).

Here's a paste of my problem:
http://dev.ampaste.net/81117

I can execute the same(completed) query manually and it'll be successful. I was wondering if I was doing anything wrong.

I also don't have the mysql module enabled because it tends to crash the server everytime it is enabled. However, for some reason, this plugin does connect to the database and will work with mysql module disabled.

[thebobjones34]

okay, on here,

format(g_Cache,511,"INSERT INTO `%s`

you need to put a ... VALUES before you start putting what your inserting
okay here is a quick better example

format(g_Cache,511,"INSERT INTO %s VALUES(authid VARCHAR(36),headshots INT(11), kills INT(11)),authid_variable,headshots_variable,kills_variable)

you need to specify the type of column, and you need to add the "VALUES" thing.

[Riotblade]

I figured out what was causing it. Warcraft 3 FT mod is conflicting with my SQL queries for an odd reason. Anyone know why this might occur?

[thebobjones34]

impossible, when you thread a query, it creates a whole new process for it. there for wc3 and your plugin would be on diff proccesses.