17.05.2016, 13:03
I'm trying to make an active system, admin can handle it even this player is offline but I have a problem to insert
PHP код:
[20:52:24] > MYSQL:
[20:52:24] * ERROR: Column count doesn't match value count at row 1 (1136)
[20:52:24] * FROM: CAN NOT BE FOUND.
[20:52:24] * QUERY: INSERT INTO accounts (`Name`,`Pass`,`Cash`,`Bank`,`Model`,`Interior`,`World`,`Tut`,`Age`,`Sex`,`PosX`,`PosY`,`PosZ`,`Health`,`Armour`,`MaskID`,`PhoneNum`,`WepSerial`,`OfflineReg`,`LastPrim`,`LastSec`,`LastMelee`,`Materials`) VALUES ('Sakura_Testss','630D8DADBA39B0C7A0E3BF7A84219403B0B0AE19661FB25CE48E1DD751625FBF',500,0,26,0,0,0,14,1,1642.729,-2240.559,13.495,99.0,0.0,6192190,3467661,8336956,1,-1,-1,-1)
Код:
mysql_format(handlesql, query, sizeof(query), "INSERT INTO accounts (`Name`,`Pass`,`Cash`,`Bank`,`Model`,`Interior`,`World`,`Tut`,`Age`,`Sex`,`PosX`,`PosY`,`PosZ`,`Health`,`Armour`,`MaskID`,`PhoneNum`,`WepSerial`,`OfflineReg`,`LastPrim`,`LastSec`,`LastMelee`,`Materials`) VALUES ('%s','%s',%i,%i,%i,%i,%i,%i,%i,%i,%f,%f,%f,%f,%f,%d,%d,%d,%i,%d,%d,%d)",name,password,500,0,26,0,0,0,14,1,1642.7285,-2240.5591,13.4945,99.0,0.0,randmask,randphone,randserial,1,-1,-1,-1,0);
mysql_tquery(handlesql, query);
mysql_format(handlesql, query, sizeof(query), "DELETE FROM applications WHERE Name = '%s'", name);
mysql_tquery(handlesql, query);