03.10.2013, 10:41
The lenght is not enough then and it fails to execute the query.
Do:
And see if it cuts the query.
Do:
pawn Код:
strcat(string, "CREATE TABLE IF NOT EXISTS users ");
strcat(string, " (userid INTEGER PRIMARY KEY AUTOINCREMENT, username VARCHAR(24) COLLATE NOCASE, ip VARCHAR(16) COLLATE NOCASE, password VARCHAR(129),");
strcat(string, " score INTEGER DEFAULT 0 NOT NULL, money INTEGER DEFAULT 5000 NOT NULL hours INTEGER DEFAULT 0 NOT NULL, minutes INTEGER DEFAULT 0 NOT NULL, seconds INTEGER DEFAULT 0 NOT NULL,");
strcat(string, " admin INTEGER DEFAULT 0 NOT NULL, vip INTEGER DEFAULT 0 NOT NULL, speedboost INTEGER DEFAULT 1 NOT NULL, cookies INTEGER DEFAULT 0 NOT NULL,");
strcat(string, " mb INTEGER DEFAULT 0 NOT NULL)");
db_query(Database, string);
print( string ); // Let's see the output