AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQLX Issue/Question (https://forums.alliedmods.net/showthread.php?t=60049)

Riotblade 08-25-2007 21:19

SQLX Issue/Question
 
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 08-25-2007 22:36

Re: SQLX Issue/Question
 
okay, on here,
Code:
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
Code:
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 08-26-2007 01:17

Re: SQLX Issue/Question
 
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 08-26-2007 14:59

Re: SQLX Issue/Question
 
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.


All times are GMT -4. The time now is 16:14.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.