Не сохраняются бизы[MySQL R7]

arhan4hel · 15 Апр 2013

Сохранения

PHP:

stock SaveBizz(const bizid)
{
new str[1024];
format(str, sizeof(str), "UPDATE `bizzes` SET `Owned`=%d,`Owner`=%s,`Message`=%s,`Extortion`=%s,`EntranceX`=%f,`EntranceY`=%f,`EntranceZ`=%f", BizzInfo[bizid][bOwned],BizzInfo[bizid][bOwner],BizzInfo[bizid][bMessage],BizzInfo[bizid][bExtortion],BizzInfo[bizid][bEntranceX],BizzInfo[bizid][bEntranceY],BizzInfo[bizid][bEntranceZ]);
format(str, sizeof(str), "%s,`ExitX`=%f,`ExitY`=%f,`ExitZ`=%f,`BuyPrice`='%d',`EntranceCost`=%d,`Till`=%d,`Locked`=%d,\
`Interior`=%d,`Products`=%d,`MaxProducts`=%d,`PriceProd`=%d,`Virtual`=%d WHERE ID = %d",str,BizzInfo[bizid][bExitX],BizzInfo[bizid][bExitY],BizzInfo[bizid][bExitZ],BizzInfo[bizid][bBuyPrice],BizzInfo[bizid][bEntranceCost],BizzInfo[bizid][bTill],BizzInfo[bizid][bLocked],BizzInfo[bizid][bInterior],
BizzInfo[bizid][bProducts],BizzInfo[bizid][bMaxProducts],BizzInfo[bizid][bPriceProd],BizzInfo[bizid][bVirtual],BizzInfo[bizid][bID]);
mysql_function_query(1, str, false, "", "");
return true;
}

Добавления

PHP:

stock AddBizz(const bizz)
{
	new sql[1024];
	format(sql, sizeof(sql), "INSERT INTO `bizzes` (`Owned`,\
	`Owner`,\
	`Message`,\
	`Extortion`,\
 	`EntranceX`,\
  	`EntranceY`,\
  	`EntranceZ`,\
  	`ExitX`,\
  	`ExitY`,\
  	`ExitZ`,\
  	`BuyPrice`,\
  	`EntranceCost`,\
  	`Till`,\
  	`Locked`,\
  	`Interior`,\
	`Products`,\
	`MaxProducts`,\
	`PriceProd`,\
	`Virtual`) VALUES (%d, '%s', '%s', '%s', %.3f, %.3f, %.3f, %.3f, %.3f, %.3f, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)",
	BizzInfo[bizz][bOwned],
	BizzInfo[bizz][bOwner],
	BizzInfo[bizz][bMessage],
	BizzInfo[bizz][bExtortion],
	BizzInfo[bizz][bEntranceX],
	BizzInfo[bizz][bEntranceY],
	BizzInfo[bizz][bEntranceZ],
	BizzInfo[bizz][bExitX],
	BizzInfo[bizz][bExitY],
	BizzInfo[bizz][bExitZ],
	BizzInfo[bizz][bBuyPrice],
	BizzInfo[bizz][bEntranceCost],
	BizzInfo[bizz][bTill],
	BizzInfo[bizz][bLocked],
	BizzInfo[bizz][bInterior],
	BizzInfo[bizz][bProducts],
	BizzInfo[bizz][bMaxProducts],
	BizzInfo[bizz][bPriceProd],
	BizzInfo[bizz][bVirtual]);
	mysql_function_query(1, sql, false, "", "");
	BizzInfo[bizz][bID] = mysql_insert_id();
	return true;
}

Вот лог ошибки

PHP:

19:07:30] Passing query INSERT INTO `bizzes` (`Owned`,`Owner`,`Message`,`Extortion`,`EntranceX`,`EntranceY`,`EntranceZ`,`ExitX`,`ExitY`,`ExitZ`,`BuyPrice`,`EntranceCost`,`Till`,`Locked`,`Interior`,`Products`,`MaxProducts`,`PriceProd`,`Virtual`) VALUES (0, '', '', '', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0, 0, 0, 0, 0, 0, 0, 0, 0, ) | 
[19:07:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[19:07:30] Passing query INSERT INTO `bizzes` (`Owned`,`Owner`,`Message`,`Extortion`,`EntranceX`,`EntranceY`,`EntranceZ`,`ExitX`,`ExitY`,`ExitZ`,`BuyPrice`,`EntranceCost`,`Till`,`Locked`,`Interior`,`Products`,`MaxProducts`,`PriceProd`,`Virtual`) VALUES (0, '', '', '', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0, 0, 0, 0, 0, 0, 0, 0, 0, ) | 
[19:07:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[19:07:30] Passing query INSERT INTO `bizzes` (`Owned`,`Owner`,`Message`,`Extortion`,`EntranceX`,`EntranceY`,`EntranceZ`,`ExitX`,`ExitY`,`ExitZ`,`BuyPrice`,`EntranceCost`,`Till`,`Locked`,`Interior`,`Products`,`MaxProducts`,`PriceProd`,`Virtual`) VALUES (0, '', '', '', 0.000, 0.000, 0.000, 0.000, 0.000, 0.000, 0, 0, 0, 0, 0, 0, 0, 0, 0, ) | 
[19:07:30] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

---------- Post added at 21:45 ---------- Previous post was at 21:23 ----------

Решил сам проблему [CLOSED] :3(совсем голова поехала) там не доставил ``, а там замного %d))

Переход в группу "Пользователь"

Не сохраняются бизы[MySQL R7]

arhan4hel

Компетентный