SQLite no guarda datos - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: SQLite no guarda datos (/showthread.php?tid=597254)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: SQLite no guarda datos (/showthread.php?tid=597254)
SQLite no guarda datos - Ghost112397 - 28.12.2015
Buenas, podrнan ayudarme con este cуdigo por favor? A la hora de guardar no almacena nada en la base de datos.
PHP код:
//OnGamemodeInit
datos = db_open("datos.db");
if(datos){
print("Base de datos 'DATOS' ha sido cargada.\n");
db_free_result(db_query(datos, "CREATE TABLE IF NOT EXISTS `carteles`(`ID` INTEGER PRIMARY KEY AUTOINCREMENT,`Texto` VARCHAR(24),`X` FLOAT,`Y` FLOAT,`Z` FLOAT,\
`RotX` FLOAT,`RotY` FLOAT,`RotZ` FLOAT,`Font` VARCHAR(32),`TTexto` INTEGER,`ColorTexto` VARCHAR(16),`ColorFondo` VARCHAR(16))"));
CargarCarteles();
}
stock CrearCartel(c){
new query[200];
format(query,sizeof(query),"INSERT INTO `carteles` (`Texto`,`X`,`Y`,`Z`,`RotX`,`RotY`,`RotZ`,`Font`,`ColorTexto`,`ColorFondo`) VALUES ('Vacнo','%f','%f','%f','%f','%f','%f','-1','-16777216');",InfoCarteles[c][cccPos][0],InfoCarteles[c][cccPos][1],InfoCarteles[c][cccPos][2],
InfoCarteles[c][cccRot][0],InfoCarteles[c][cccRot][1],InfoCarteles[c][cccRot][2]);
db_free_result(db_query(datos,query));
}
stock GuardarCartel(c){
new query[256];
format(query,sizeof(query),"UPDATE `carteles` SET `Texto` = '%q',`X` = '%f',`Y` = '%f',`Z` = '%f',\
`RotX` = '%f',`RotY` = '%f',`RotZ` = '%f',`Font` = '%q',`TTexto` = '%i',`ColorTexto` = '%q',`ColorFondo` = '%q' WHERE `ID` = '%i'",
InfoCarteles[c][cccTexto],InfoCarteles[c][cccPos][0],InfoCarteles[c][cccPos][1],InfoCarteles[c][cccPos][2],
InfoCarteles[c][cccRot][0],InfoCarteles[c][cccRot][1],InfoCarteles[c][cccRot][2],
InfoCarteles[c][cccFont],InfoCarteles[c][cccTTexto],InfoCarteles[c][cccColorTexto],InfoCarteles[c][cccColorFondo],c);
db_free_result(db_query(datos,query));
}
Re: SQLite no guarda datos - F1N4L - 28.12.2015
Use a include de Gammix
https://sampforum.blast.hk/showthread.php?tid=581453
Vai facilitar teu trabalho!
Respuesta: Re: SQLite no guarda datos - Ghost112397 - 28.12.2015
Quote:
|
Originally Posted by F1N4L
 Use a include de Gammix
https://sampforum.blast.hk/showthread.php?tid=581453 Vai facilitar teu trabalho! |
