[aRoach]

Wll...
I add new DB:Accounts;.
-------------------------------------------------------------
I add at OnGameModeInit:
new Table[ 420 ];
Accounts = db_open( "UrbansSF/Accounts.db" );
strcat( Table, "CREATE TABLE IF NOT EXISTS `Users` ", 420 );
strcat( Table, "( `Name` varchar(30), \
`IP` varchar(20),\
`RegDate` varchar(30),\
`Password` varchar(40),\
`Level` INT,\
`Cash` INT,\
`Kills` INT,\
`Deaths` INT,\
`Score` INT,\
`Cookies` INT,\
`Hours` INT,\
`Mins` INT,\
`Secs` INT,\
`LastON` INT,\
`Freezed` INT,\
`Jail` INT,\
`Muted` INT,\
`IQP` INT)" );
PS: formatQ is a Define that i use Only for Query...
-------------------------------------------------------------

Please, I need some Help

[jamesbond007]

whats your problem then? any errors?

[aRoach]

Wll...
It doesn't save the Accounts...
-------------------------------------------------------------
formatQ( "INSERT INTO `Users` VALUES('%s','%s','%s','%s','%d','%d','%d','%d','%d ','%d','%d','%d','%d','%s','%d','%d','%d','%d')", pName(playerid), IP, pDate, buf, 0, 0, 0, 0, 0, 0, 0, 0, 0, ("Never"), 0, 0 );
db_free_result( db_query( Accounts, Query ) );

[Jefff]

"INSERT INTO `Users` (`Name`,`IP`,`RegDate`,`Password`.....) VALUES('%s','%s''%s'.....);",pName(playerid),IP,.. ...

[aRoach]

It doesn't Work, Jeff...

Someone else?

[Sergei]

Код:

formatQ( "INSERT INTO Users VALUES('%s','%s','%s','%s',%d,%d,%d,%d,%d,%d,%d,%d,%d,'%s',%d,%d,%d,%d)", pName(playerid), IP, pDate, buf, 0, 0, 0, 0, 0, 0, 0, 0, 0, ("Never"), 0, 0 );
db_free_result( db_query( Accounts, Query ) );

Next time you can test your query in your SQLite manager and see what the error is.