[u3games]

Thx, i fix this error. Now work ^^

Need help with storage of data, for example "money". My code:

Code:

format(string, sizeof(string), "UPDATE `DINERO` SET `EFECTIVO` = '%s' WHERE NOMBRE= '%s'", GetPlayerMoney(playerid), DB_Escape(NombrePersonaje(playerid)));
	db_free_result(db_query(Sqlite, string));

But in db save this :S



Same error in skin:

Code:

format(string, sizeof(string), "UPDATE `PERSONAJES` SET `SKIN` = '%s' WHERE NOMBRE= '%s'", GetPlayerSkin(playerid), DB_Escape(NombrePersonaje(playerid)));
	db_free_result(db_query(Sqlite, string));

In db:



-----------------------------------------------------------------------------------------------------

My db code:

Code:

CREATE TABLE IF NOT EXISTS `CUENTAS` (`NOMBRE` VARCHAR(45) NOT NULL DEFAULT '', `PASSWORD` VARCHAR(45) DEFAULT 0, `ACCESLEVEL` TINYINT NOT NULL DEFAULT 0, `ESTADO` VARCHAR(3) DEFAULT 0, `IP` CHAR(15) NULL DEFAULT NULL)


CREATE TABLE IF NOT EXISTS `PERSONAJES` (`NOMBRE` VARCHAR(45), `PUNTOS` SMALLINT(5) DEFAULT 0, `KARMA` SMALLINT(5) DEFAULT 0, `POSX` FLOAT DEFAULT 0.0, `POSY` FLOAT DEFAULT 0.0, `POSZ` FLOAT DEFAULT 0.0, `SKIN` SMALLINT(3) DEFAULT 0)

CREATE TABLE IF NOT EXISTS `DINERO` (`NOMBRE` VARCHAR(45), `EFECTIVO` INT UNSIGNED DEFAULT NULL, `ELECTRONICO` INT UNSIGNED DEFAULT NULL)