SA-MP Forums Archive
Mysql bug with guns - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql bug with guns (/showthread.php?tid=177107)


Mysql bug with guns - gedas123755 - 16.09.2010

Hey, i got problem with mysql, his don't save guns files what is wrong?
Код:
	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);
Mysql:
Код:
 `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',