PHP код:
stock UpdateBizz(bizide)
{
format(query1, sizeof(query1), "SELECT * FROM `bizz` WHERE `id`=%d",bizide-1);
mysql_query(query1);
mysql_store_result();
new biz_num = mysql_num_rows();
if(biz_num > 0)
{
mysql_fetch_row(query1);
sscanf(query1, "e<p<|>is[24]s[64]ffffffddfffifffdddddddd>", BizzInfo[bizide]);
DestroyDynamicPickup(BizzInfo[bizide][bPickEnter]);
DestroyDynamicPickup(BizzInfo[bizide][bPickExit]);
DestroyDynamicPickup(BizzInfo[bizide][bBuyPick]);
DestroyDynamic3DTextLabel(BizzInfo[bizide][bEnterText]);
if(BizzInfo[bizide][bType] == 1) // 24/7
{
BizzInfo[bizide][bPickEnter] = CreateDynamicPickup(1318, 23, BizzInfo[bizide][bEnterX], BizzInfo[bizide][bEnterY], BizzInfo[bizide][bEnterZ]);
BizzInfo[bizide][bPickExit] = CreateDynamicPickup(1318, 23, BizzInfo[bizide][bExitX], BizzInfo[bizide][bExitY], BizzInfo[bizide][bExitZ], BizzInfo[bizide][bWorld], BizzInfo[bizide][bInt]);
BizzInfo[bizide][bBuyPick] = CreateDynamicPickup(1239, 23, BizzInfo[bizide][bBuyX], BizzInfo[bizide][bBuyY], BizzInfo[bizide][bBuyZ], BizzInfo[bizide][bWorld], BizzInfo[bizide][bInt]);
if(!strcmp(BizzInfo[bizide][bOwner], "None", true)) BizzInfo[bizide][bEnterText] = CreateDynamic3DTextLabel("Бизнес продается", COLOR_YELLOW, BizzInfo[bizide][bEnterX], BizzInfo[bizide][bEnterY], BizzInfo[bizide][bEnterZ]+1, 10.0);
else BizzInfo[bizide][bEnterText] = CreateDynamic3DTextLabel(BizzInfo[bizide][bName], COLOR_YELLOW, BizzInfo[bizide][bEnterX], BizzInfo[bizide][bEnterY], BizzInfo[bizide][bEnterZ]+1, 15.0);
}
else if(BizzInfo[bizide][bType] == 2) // АЗС
{
new string[80];
format(string, sizeof(string), "АЗС: %s\nЦена за 5л: %d", BizzInfo[bizide][bName], BizzInfo[bizide][bProdPrice]*5);
UpdateDynamic3DTextLabelText(BizzInfo[bizide][bEnterText], COLOR_LIGHTBLUE, string);
}
mysql_free_result();
}
}
stock LoadBizz()
{
format(query1, sizeof(query1), "SELECT * FROM `bizz`");
mysql_query(query1);
mysql_store_result();
new biz_num = mysql_num_rows();
if(biz_num > -1)
{
for(new i = 1; i <= biz_num; i++)
{
mysql_fetch_row(query1);
sscanf(query, "e<p<|>is[24]s[64]ffffffddfffifffddddds[32]ddd>", BizzInfo[i]);
if(BizzInfo[i][bType] == 1 || BizzInfo[i][bType] == 3 || BizzInfo[i][bType] == 4) // 24/7, ресторан, закусочная
{
BizzInfo[i][bPickEnter] = CreateDynamicPickup(1318, 23, BizzInfo[i][bEnterX], BizzInfo[i][bEnterY], BizzInfo[i][bEnterZ]);
BizzInfo[i][bPickExit] = CreateDynamicPickup(1318, 23, BizzInfo[i][bExitX], BizzInfo[i][bExitY], BizzInfo[i][bExitZ], BizzInfo[i][bWorld], BizzInfo[i][bInt]);
BizzInfo[i][bBuyPick] = CreateDynamicPickup(1239, 23, BizzInfo[i][bBuyX], BizzInfo[i][bBuyY], BizzInfo[i][bBuyZ], BizzInfo[i][bWorld], BizzInfo[i][bInt]);
if(!strcmp(BizzInfo[i][bOwner], "None", true)) BizzInfo[i][bEnterText] = CreateDynamic3DTextLabel("Бизнес продается", COLOR_YELLOW, BizzInfo[i][bEnterX], BizzInfo[i][bEnterY], BizzInfo[i][bEnterZ]+1, 10.0);
else BizzInfo[i][bEnterText] = CreateDynamic3DTextLabel(BizzInfo[i][bName], COLOR_YELLOW, BizzInfo[i][bEnterX], BizzInfo[i][bEnterY], BizzInfo[i][bEnterZ]+1, 15.0);
}
else if(BizzInfo[i][bType] == 2) // АЗС
{
new string[80];
format(string, sizeof(string), "АЗС: %s\nЦена за 5л: %d", BizzInfo[i][bName], BizzInfo[i][bProdPrice]*5);
BizzInfo[i][bEnterText] = CreateDynamic3DTextLabel(string, COLOR_LIGHTBLUE, BizzInfo[i][bBuyX], BizzInfo[i][bBuyY], BizzInfo[i][bBuyZ]+1, 10.0);
}
TOTALBIZZ++;
}
printf(" Бизнесов загружено: %d", TOTALBIZZ);
}
mysql_free_result();
}
stock SaveBizz(bizide)
{
format(query1, sizeof(query1), "UPDATE `bizz` SET `Name`='%s',`Owner`='%s',`EnterX`=%f,`EnterY`=%f,`EnterZ`=%f,`SpawnX`=%f,`SpawnY`=%f,`SpawnZ`=%f,`ExitX`=%f,`ExitY`=%f,`ExitZ`=%f,`Type`=%i,`BuyX`=%f,`BuyY`=%f,`BuyZ`=%f,`Int`=%d,`World`=%d,`Price`=%d,`Nalog`=%d,`ProdPrice`=%d,`Bank`=%d,`Prods`=%d WHERE `id`=%d",
BizzInfo[bizide][bName],
BizzInfo[bizide][bOwner],
BizzInfo[bizide][bEnterX],
BizzInfo[bizide][bEnterY],
BizzInfo[bizide][bEnterZ],
BizzInfo[bizide][bSpawnX],
BizzInfo[bizide][bSpawnY],
BizzInfo[bizide][bSpawnZ],
BizzInfo[bizide][bExitX],
BizzInfo[bizide][bExitY],
BizzInfo[bizide][bExitZ],
BizzInfo[bizide][bType],
BizzInfo[bizide][bBuyX],
BizzInfo[bizide][bBuyY],
BizzInfo[bizide][bBuyZ],
BizzInfo[bizide][bInt],
BizzInfo[bizide][bWorld],
BizzInfo[bizide][bPrice],
BizzInfo[bizide][bNalog],
BizzInfo[bizide][bProdPrice],
BizzInfo[bizide][bBank],
BizzInfo[bizide][bProds],
bizide-1);
mysql_query(query1);
Ошибки: