16.09.2010, 11:46
Hey, i got problem with mysql, his don't save guns files what is wrong?
Mysql:
Код:
for (new tmp=0; tmp<12; tmp++) GetPlayerWeaponData(playerid,tmp,weps[0][tmp],weps[1][tmp]); format(query,256,"UPDATE `"TABLENAME"` SET `Ginklas0` = '%i', `Ginklas1` = '%i', `Ginklas2` = '%i', `Ginklas3` = '%i', `Ginklas4` = '%i',\ `Ginklas5` = '%i', `Ginklas6` = '%i', `Ginklas7` = '%i', `Ginklas8` = '%i', `Ginklas9` = '%i', `Ginklas10` = '%i', `Ginklas11` = '%i' WHERE (`PName` = '%s')",\ weps[0][0],weps[0][1],weps[0][2],weps[0][3],weps[0][4],weps[0][5],weps[0][6],weps[0][7],weps[0][8],weps[0][9],weps[0][10],weps[0][11],pName); mysql_query(query); format(query,256,"UPDATE `"TABLENAME"` SET `Ammo0` = '%i', `Ammo1` = '%i', `Ammo2` = '%i', `Ammo3` = '%i', `Ammo4` = '%i', `Ammo5` = '%i',\ `Ammo6` = '%i', `Ammo7` = '%i', `Ammo8` = '%i', `Ammo9` = '%i', `Ammo10` = '%i', `Ammo11` = '%i' WHERE (`PName` = '%s')",\ weps[1][0],weps[1][1],weps[1][2],weps[1][3],weps[1][4],weps[1][5],weps[1][6],weps[1][7],weps[1][8],weps[1][9],weps[1][10],weps[1][11],pName); mysql_query(query);
Код:
`Ginklas0` int(6) NOT NULL default '0', `Ammo0` int(6) NOT NULL default '0', `Ginklas1` int(6) NOT NULL default '0', `Ammo1` int(6) NOT NULL default '0', `Ginklas2` int(6) NOT NULL default '0', `Ammo2` int(6) NOT NULL default '0', `Ginklas3` int(6) NOT NULL default '0', `Ammo3` int(6) NOT NULL default '0', `Ginklas4` int(6) NOT NULL default '0', `Ammo4` int(6) NOT NULL default '0', `Ginklas5` int(6) NOT NULL default '0', `Ammo5` int(6) NOT NULL default '0', `Ginklas6` int(6) NOT NULL default '0', `Ammo6` int(6) NOT NULL default '0', `Ginklas7` int(6) NOT NULL default '0', `Ammo7` int(6) NOT NULL default '0', `Ginklas8` int(6) NOT NULL default '0', `Ammo8` int(6) NOT NULL default '0', `Ginklas9` int(6) NOT NULL default '0', `Ammo9` int(6) NOT NULL default '0', `Ginklas10` int(6) NOT NULL default '0', `Ammo10` int(6) NOT NULL default '0', `Ginklas11` int(6) NOT NULL default '0', `Ammo11` int(6) NOT NULL default '0',