[Private200]

You are formatting Query with a new input. You are simply clearing the old value and inserting

Quote:

"%d, `VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`) VALUES (0,0,'16777215',0,0,1,'%d',0,0,0,0)"

Go for:

PHP код:

strcat(Query, "INSERT INTO `users` (`name`, `password`, `ip`,`registro`,`score`, `dinero`, `admin`,`kills`, `deaths`, `jail`, `jailsec`, `skin`, `Turbo`, `Radio`, `Autofix`, `Nivel`, `Experiencia`,`MonsterKills`, `Color`,");
strcat(Query, "`Headshot`,`Horas`, `Minutos`, `Segundos`, `DuelosWins`,`VIP`, `VIPTIME`,`CHATCOLOR`, `RACE`,`HOUSES`, `CONNECTED`, `PLAYERID`, `LCONNECT`, `POSX`, `POSY`, `POSZ`");
strcat(Query, " VALUES ('%s','%s','%s,'%s',0,0,0,0,0,0,0,0,0,'1',0,0,0,0,'-1',0,0,0,0,0,0,0,'16777215',0,0,1,'%d',0,0,0,0)");
format(Query, sizeof(Query),  DB_Escape(PI[playerid][JugadorNick]),DB_Escape(hashpass), 
PlayerIP(playerid),PI[playerid][registro],playerid); 
                     
 db_query(_DB_, Query); 


It should work.