21.07.2018, 23:09
estou mudando o salvamento para sqlite mas nгo estб salvando, somente em pouca quantia de strcat
http://prntscr.com/k9dkv5
http://prntscr.com/k9dky8
a conta id 6 (print acima) foi a que salvou em pouca quantia de strcat
as tabelas estгo sendo criadas normalmente
alguem sabe o que pode ser ??
http://prntscr.com/k9dkv5
http://prntscr.com/k9dky8
a conta id 6 (print acima) foi a que salvou em pouca quantia de strcat
as tabelas estгo sendo criadas normalmente
alguem sabe o que pode ser ??
PHP код:
SalvarDB(playerid) {
new corvip[8];
GetPVarString(playerid, "VIPCORA", corvip, 8);
new str[64];
format(DB_Query, sizeof(DB_Query), "");
strcat(DB_Query, "UPDATE CONTAS SET ");
format(str, 64, "NOME = '%s',", GetPlayerNameEx(playerid)); strcat(DB_Query, str);
format(str, 64, "SENHA = '%s',", pInfo[playerid][Senha]); strcat(DB_Query, str);
format(str, 64, "LEVEL = '%d',", pInfo[playerid][Level]); strcat(DB_Query, str);
format(str, 64, "DINHEIRO = '%d',", GetPlayerGrana(playerid)); strcat(DB_Query, str);
format(str, 64, "SKIN = '%d',", GetPlayerSkin(playerid)); strcat(DB_Query, str);
format(str, 64, "MATOU = '%d',", pInfo[playerid][fMatou]); strcat(DB_Query, str);
format(str, 64, "MORREU = '%d',", pInfo[playerid][fMorreu]); strcat(DB_Query, str);
format(str, 64, "PD = '%d',", permitidodivorcio[playerid]); strcat(DB_Query, str);
format(str, 64, "PCA = '%d',", permitido[playerid]); strcat(DB_Query, str);
format(str, 64, "PROFISSAO = '%d',", pInfo[playerid][Prof]); strcat(DB_Query, str);
format(str, 64, "TEMPOONLINE = '%d',", TempoOnline[playerid]); strcat(DB_Query, str);
format(str, 64, "EVENTOS = '%d',", pInfo[playerid][PontosEvento]); strcat(DB_Query, str);
format(str, 64, "ED = '%d',", pInfo[playerid][PontosDuelo]); strcat(DB_Query, str);
format(str, 64, "SEXO = '%d',", pInfo[playerid][Sexo]); strcat(DB_Query, str);
format(str, 64, "EVENTOS = '%d',", pInfo[playerid][PontosEvento]); strcat(DB_Query, str);
format(str, 64, "SKIN = '%d',", pInfo[playerid][SkinP]); strcat(DB_Query, str);
format(str, 64, "EXP = '%d',", pInfo[playerid][Exp]); strcat(DB_Query, str);
format(str, 64, "MINUP = '%d',", pInfo[playerid][MinUP]); strcat(DB_Query, str);
format(str, 64, "GASOLINA = '%d',", pInfo[playerid][GasG]); strcat(DB_Query, str);
format(str, 64, "ETANOL = '%d',", pInfo[playerid][GasE]); strcat(DB_Query, str);
format(str, 64, "DIESEL = '%d',", pInfo[playerid][GasD]); strcat(DB_Query, str);
format(str, 64, "CASH = '%d',", pInfo[playerid][MoedasCash]); strcat(DB_Query, str);
format(str, 64, "HABCARRO = '%d',", pInfo[playerid][HabTCarro]); strcat(DB_Query, str);
format(str, 64, "HABMOTO = '%d',", pInfo[playerid][HabTMoto]); strcat(DB_Query, str);
format(str, 64, "HABCAMINHAO = '%d',", pInfo[playerid][HabTCaminhao]); strcat(DB_Query, str);
format(str, 64, "HABTREM = '%d',", pInfo[playerid][HabTTrem]); strcat(DB_Query, str);
format(str, 64, "HABBARCO = '%d',", pInfo[playerid][HabNBarco]); strcat(DB_Query, str);
format(str, 64, "HABHELI = '%d',", pInfo[playerid][HabAHeli]); strcat(DB_Query, str);
format(str, 64, "HABAVIAO = '%d',", pInfo[playerid][HabAAviao]); strcat(DB_Query, str);
format(str, 64, "PORTE = '%d',", pInfo[playerid][HabP]); strcat(DB_Query, str);
format(str, 64, "PRESO = '%d',", pInfo[playerid][Preso]); strcat(DB_Query, str);
format(str, 64, "ABUSER = '%d',", pInfo[playerid][Abuser]); strcat(DB_Query, str);
format(str, 64, "TCRACK = '%d',", pInfo[playerid][Pego_QtaCrac]); strcat(DB_Query, str);
format(str, 64, "COCAINA = '%d',", pInfo[playerid][PT_Cocaina]); strcat(DB_Query, str);
format(str, 64, "MACONHA = '%d',", pInfo[playerid][PT_Maconha]); strcat(DB_Query, str);
format(str, 64, "GPS = '%d',", pInfo[playerid][Tem_GPS]); strcat(DB_Query, str);
format(str, 64, "HEAD = '%d',", pInfo[playerid][Tem_Head]); strcat(DB_Query, str);
format(str, 64, "KIT = '%d',", pInfo[playerid][Tem_Kit]); strcat(DB_Query, str);
format(str, 64, "CAPACETE = '%d',", pInfo[playerid][Tem_Capacete]); strcat(DB_Query, str);
format(str, 64, "MODELOCAPACETE = '%d',", pInfo[playerid][ModeloCapacete]); strcat(DB_Query, str);
format(str, 64, "SEGURO = '%d',", pInfo[playerid][Seguro]); strcat(DB_Query, str);
format(str, 64, "CONVENIO = '%d',", pInfo[playerid][Convenio]); strcat(DB_Query, str);
format(str, 64, "CELULAR = '%d',", pInfo[playerid][Celular]); strcat(DB_Query, str);
format(str, 64, "CARGO = '%d',", pCargo[playerid]); strcat(DB_Query, str);
format(str, 64, "PATENTE = '%d',", pPatente[playerid]); strcat(DB_Query, str);
format(str, 64, "ASSALTOS = '%d',", pAssalto[playerid]); strcat(DB_Query, str);
format(str, 64, "BOMBAS = '%d',", pBombas[playerid]); strcat(DB_Query, str);
format(str, 64, "REMOVIDOPOL = '%d',", IsNotCop[playerid]); strcat(DB_Query, str);
format(str, 64, "SEMPARAR = '%d',", ViaFacil[playerid]); strcat(DB_Query, str);
format(str, 64, "NEON = '%d',", pInfo[playerid][Neon]); strcat(DB_Query, str);
format(str, 64, "XENON = '%d',", pInfo[playerid][Xenon]); strcat(DB_Query, str);
format(str, 64, "SIRENE = '%d',", pInfo[playerid][Sirene]); strcat(DB_Query, str);
format(str, 64, "EMPRESTIMO = '%d',", pInfo[playerid][Emprestimo]); strcat(DB_Query, str);
format(str, 64, "PRATA = '%d',", pInfo[playerid][pratas]); strcat(DB_Query, str);
format(str, 64, "OURO = '%d',", pInfo[playerid][ouros]); strcat(DB_Query, str);
format(str, 64, "FERRO = '%d',", pInfo[playerid][ferros]); strcat(DB_Query, str);
format(str, 64, "DIAMANTE = '%d',", pInfo[playerid][diamantes]); strcat(DB_Query, str);
format(str, 64, "YT = '%d',", pInfo[playerid][*******r]); strcat(DB_Query, str);
format(str, 64, "PLANTAS = '%d',", pInfo[playerid][Plantas]); strcat(DB_Query, str);
format(str, 64, "SEMENTES = '%d',", pInfo[playerid][Sementes]); strcat(DB_Query, str);
format(str, 64, "NUMEROTEL = '%d',", pInfo[playerid][TemC]); strcat(DB_Query, str);
format(str, 64, "MP3 = '%d',", pInfo[playerid][MP3]); strcat(DB_Query, str);
format(str, 64, "ANOTAR = '%d',", pInfo[playerid][Anotar]); strcat(DB_Query, str);
format(str, 64, "CREDITOS = '%d',", pInfo[playerid][Creditos]); strcat(DB_Query, str);
format(str, 64, "BANCO = '%d',", pInfo[playerid][ContaBanco]); strcat(DB_Query, str);
format(str, 64, "SALDO = '%d',", pInfo[playerid][Saldo]); strcat(DB_Query, str);
format(str, 64, "PROCURADO = '%d',", pInfo[playerid][Procurado]); strcat(DB_Query, str);
format(str, 64, "GANHACASH = '%d',", GetPVarInt(playerid, "GanhaCash")); strcat(DB_Query, str);
format(str, 64, "LUTAS = '%d',", pInfo[playerid][Lutas]); strcat(DB_Query, str);
format(str, 64, "CORVIP = '%q',", corvip); strcat(DB_Query, str);
new Float:vida;
GetPlayerHealth(playerid, vida);
format(str, 64, "VIDA = '%f',", vida); strcat(DB_Query, str);
static Float:POS_[4];
GetPlayerPos(playerid, POS_[0], POS_[1], POS_[2]);
GetPlayerFacingAngle(playerid, POS_[3]);
format(str, 64, "UX = '%f',", POS_[0]); strcat(DB_Query, str);
format(str, 64, "UY = '%f',", POS_[1]); strcat(DB_Query, str);
format(str, 64, "UZ = '%f',", POS_[2]); strcat(DB_Query, str);
format(str, 64, "UW = '%f',", POS_[3]); strcat(DB_Query, str);
format(str, 64, "CW = '%d',", GetPlayerInterior(playerid)); strcat(DB_Query, str);
format(str, 64, "ANOTACAO = '%q',", pInfo[playerid][Anotacao]); strcat(DB_Query, str);
format(str, 64, "ADMIN = '%d'", pAdmin[playerid]); strcat(DB_Query, str);
format(str, 64, " WHERE ID = '%d'", pInfo[playerid][IDdb]); strcat(DB_Query, str);
db_query(Database, DB_Query);
printf("%s", DB_Query);
return 1;
}