shape1
shape2
shape3
shape4
shape7
shape8

Не сохроняет в базу даных знчение


dryaka

dryaka

Новичок
Пользователь
23.10.2016
0
0
0
Не сохроняет в базу даных знчение bExitX, bExitY, bExitZ.

Вот код.

enum biInfo//èíôîðìàöèÿ áåð¸òñÿ èç bInts
{
biInt,
Float:biX,
Float:biY,
Float:biZ,
biName[255],
bIcon,
}
new bInts[][biInfo]=
{
{1,2337.8071, 1766.7714, -13.9917,"24/7",17},//4 ýòî èíò,äàëüøå êîîðäèíàòû ïîÿâëåíèÿ â èíòåðüåðå è íàçâàíèå áèçíåñà
{2,2337.8071, 1766.7714, -13.9917,"Ñòîëîâàÿ",50},
{3,2337.8071, 1766.7714, -13.9917,"Êàçèíî",44}};
enum bInfo
{
bID,
bOwned,
bOwner[64],
bMessage[128],
bExtortion[24],
Float:bEntranceX,
Float:bEntranceY,
Float:bEntranceZ,
bExitX,
Float:bExitY,
Float:bExitZ,
bBuyPrice,
bEntranceCost,
bTill,
bLocked,
bInterior,
bProducts,
bMaxProducts,
bPriceProd,
Text3D: bLabel,
b2Till,
bCena,
Float:bBarX,
Float:bBarY,
Float:bBarZ,
bMafia,
bZahvat,
bTakings
};

new HouseInfo[900][hInfo];
main(){}
stock CustomPickups(){
new Float:eek:ldposx, Float:eek:ldposy, Float:eek:ldposz;
new enters[256];
for(new i = 0; i < MAX_PLAYERS; i++){
if(IsPlayerConnected(i)){
GetPlayerPos(i, oldposx, oldposy, oldposz);
if(oldposx!=0.0 && oldposy!=0.0 && oldposz!=0.0){
for(new b = 0; b < sizeof(BizzInfo); b++){
if (PlayerToPoint(1, i,BizzInfo[bEntranceX], BizzInfo[bEntranceY], BizzInfo[bEntranceZ])){
if(BizzInfo[bOwned] == 0)
{
format(enters,sizeof(enters), "{FFFFFF}Âû äåéñòâèòåëüíî õîòèòå ïðèîáðåñòè {fde910}%s {FFFFFF}?",BizzInfo[bMessage]);
ShowPlayerDialog(i,9828,DIALOG_STYLE_MSGBOX,"Ïîêóïêà áèçíåñà", enters, "Äà", "Íåò");
return true;
}
if(PlayerInfo[pPbiskey] == 999){}
if(b == 0 || b == 1 || b == 2|| b == 3 ||b == 4 || b == 5 || b == 6)
{
if(enterbiz == 0)
{
if(BizzInfo[bLocked] == 1) return SCM(i, COLOR_GRAD1, "Áèçíåñ çàêðûò!");
format(enters,sizeof(enters), "{FFFFFF}Âõîä ïëàòíûé è ñîñòàâëÿåò {FF9900}%d$\n{66CC00}Âû óâåðåíû ÷òî õîòèòå âîéòè ñþäà ?",BizzInfo[bEntranceCost]);
ShowPlayerDialog(i,9898,DIALOG_STYLE_MSGBOX,"Áèçíåñ", enters, "Äà", "Íåò");
return true;
}
else
{
SetPlayerInterior(i,BizzInfo[bInterior]);
SetPlayerPos(i,bInts[BizzInfo[bExitX]][biX], bInts[BizzInfo[bExitX]][biY], bInts[BizzInfo[bExitX]][biZ]);
SetPlayerInterior(i, BizzInfo[bInterior]);
SetPlayerVirtualWorld(i,0);
}
if(PlayerInfo[pPbiskey] == b)
{
if(BizzInfo[bLocked] == 1) return SCM(i, COLOR_GRAD1, "Áèçíåñ çàêðûò!");
SetPlayerInterior(i,BizzInfo[bInterior]);
SetPlayerPos(i,bInts[BizzInfo[bExitX]][biX], bInts[BizzInfo[bExitX]][biY], bInts[BizzInfo[bExitX]][biZ]);
SetPlayerInterior(i, BizzInfo[bInterior]);
SetPlayerVirtualWorld(i,0);
return true;
}
}
else
{
SetPlayerInterior(i,BizzInfo[bInterior]);
SetPlayerPos(i,bInts[BizzInfo[bExitX]][biX], bInts[BizzInfo[bExitX]][biY], bInts[BizzInfo[bExitX]][biZ]);
SetPlayerInterior(i, BizzInfo[bInterior]);
SetPlayerVirtualWorld(i,0);}}}}}}return true;}

if(strcmp(cmd, "/exitxx", true) == 0){
if(IsPlayerConnected(playerid)){
for(new i = 0; i < sizeof(BizzInfo); i++){
if (PlayerToPoint(3, playerid,bInts[BizzInfo[bExitX]][biX], bInts[BizzInfo[bExitX]][biY], bInts[BizzInfo[bExitX]][biZ])){
SetPlayerInterior(playerid,0);
SetPlayerPos(playerid,BizzInfo[bEntranceX],BizzInfo[bEntranceY],BizzInfo[bEntranceZ]);}}}return true;}

case 2000:
{
if(response)//Åñëè ïðîäîëæàåì
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 2000, DIALOG_STYLE_INPUT, "Íàçâàíèå", "Ââåäèòå íàçâàíèå:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
SetPVarString(playerid, "b_name", inputtext);//Çàïèñûâàåì
ShowPlayerDialog(playerid, 2001, DIALOG_STYLE_INPUT, "Íîìåð", "Ââåäèòå íîìåð:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
}
}
case 2006:
{
if(response)
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 2006, DIALOG_STYLE_INPUT, "Íàçâàíèå", "Ââåäèòå íàçâàíèå:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
SetPVarString(playerid, "b_name", inputtext);//Çàïèñûâàåì
ShowPlayerDialog(playerid, 2005, DIALOG_STYLE_MSGBOX, "Ïîäòâåðæäåíèå", "Âû äåéñòâèòåëüíî æåëàåòå ñîçäàòü Áèçíåñ?", "V", "X");//Ïîäòâåðæäàåì
}
}
case 2001:
{
if(response)//Åñëè ïðîäîëæàåì
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 2001, DIALOG_STYLE_INPUT, "Íîìåð", "Ââåäèòå íîìåð:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
SetPVarInt(playerid, "b_number", strval(inputtext));
ShowPlayerDialog(playerid, 2002, DIALOG_STYLE_INPUT, "Ñòîèìîñòü", "Ââåäèòå ñòîèìîñòü áèçíåñà:","Äàëåå","Íàçàä");//Åñëè íå ââåäåíî - ï
}
else DeletePVar(playerid, "b_number"), ShowPlayerDialog(playerid, 2001, DIALOG_STYLE_INPUT, "Íîìåð", "Ââåäèòå íîìåð:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
}
case 2002:
{
if(response)//Åñëè ïðîäîëæàåì
{
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, 2003, DIALOG_STYLE_INPUT, "Ñòîèìîñòü", "Ââåäèòå ñòîèìîñòü áèçíåñà:","Äàëåå","Íàçàä");//Åñëè íå ââåäåíî - ïîâòîðÿåì
SetPVarInt(playerid, "b_price", strval(inputtext));
LString = "";
for(new i; i < sizeof(bInts); i++)
{
strcat(LString, bInts[biName]);
strcat(LString, "\n");
}
ShowPlayerDialog(playerid, 2003, DIALOG_STYLE_LIST, "Èíòåðüåð", LString, "Äàëåå", "Íàçàä");//Ïîêàçûâàåì Äèàëîã ñ âûáîðîì Èíòåðüåðà
}
else DeletePVar(playerid, "b_number"), ShowPlayerDialog(playerid, 2001, DIALOG_STYLE_INPUT, "Ñòîèìîñòü", "Ââåäèòå ñòîèìîñòü Áèçíåñà:", "Äàëåå", "Îòìåíà");//Ïîêàçûâàåì Äèàëîã ñ Öåíîé
}
case 2003:
{
if(response)//Åñëè ïðîäîëæàåì
{
SetPVarInt(playerid, "b_int", listitem);
ShowPlayerDialog(playerid, 2004, DIALOG_STYLE_MSGBOX, "Ïîäòâåðæäåíèå", "Âû äåéñòâèòåëüíî æåëàåòå ñîçäàòü Áèçíåñ?", "V", "X");//Ïîäòâåðæäàåì
}
else DeletePVar(playerid, "b_price"), ShowPlayerDialog(playerid, 2003, DIALOG_STYLE_INPUT, "Ñòîèìîñòü", "Ââåäèòå ñòîèìîñòü Áèçíåñà:", "Äàëåå", "Íàçàä");//Èíà÷å
}
case 2004:
{
if(response)//Åñëè ïðîäîëæàåì
{
for(new i = 0; i < sizeof(BizzInfo); i++)
{
new Float:x[3], str[64];
GetPlayerPos(playerid, x[0], x[1], x[2]);//Ïîëó÷àåì ïîçèöèþ
GetPVarString(playerid, "b_name", str, 64);
BizzInfo[bID] = GetPVarInt(playerid, "b_number");
new bouse = BizzInfo[bID];
BizzInfo[bouse][bEntranceX] = x[0];//Ïðèñâàèâàåì Êîîðäèíàòó X
BizzInfo[bouse][bEntranceY] = x[1];//Ïðèñâàèâàåì Êîîðäèíàòó Y
BizzInfo[bouse][bEntranceZ] = x[2];//Ïðèñâàèâàåì Êîîðäèíàòó Z
strmid(BizzInfo[bouse][bMessage], str, 0, 32, 32);//Ïðèñâàèâàåì Èìÿ
BizzInfo[bouse][bCena] = GetPVarInt(playerid, "b_price");//Ïðèñâàèâàåì Öåíó
BizzInfo[bouse][bExitX] = GetPVarInt(playerid, "b_int");//Ïðèñâàèâàåì Èíòåðüåð
strmid(BizzInfo[bouse][bMessage], str, 0, 32, 32);//Ïðèñâàèâàåì Èìÿ
SaveBiz(bouse);//Ñîõðàíÿåì
BuyBiz(bouse);
GameTextForPlayer(playerid, "~w~Áèçíåñ ~g~Ñîçäàí",100,1);
DeletePVar(playerid, "b_price");
DeletePVar(playerid, "b_name");
DeletePVar(playerid, "b_number");
DeletePVar(playerid, "b_int");
}
}
else DeletePVar(playerid,"b_price"),DeletePVar(playerid,"b_number"),DeletePVar(playerid,"b_menu"), DeletePVar(playerid, "b_name"), DeletePVar(playerid, "b_int");//针֌
}

case 2005:
{
if(response)//Åñëè ïðîäîëæàåì
{
for(new i = 0; i < sizeof(BizzInfo); i++)
{
new str[255];
new bouse = BizzInfo[bID];
GetPVarString(playerid, "b_name", str, 64);
strmid(BizzInfo[bouse][bMessage], str, 0, 32, 32);//Ïðèñâàèâàåì Èìÿ
SendClientMessage(playerid, COLOR_WHITE, "Íàçâàíèå óñòàíîâëåíû");
BuyBiz(bouse);
}
}
else DeletePVar(playerid, "b_name");//针֌
}
case 9828:{
if(response){
new sendername[MAX_PLAYER_NAME];
new Float:eek:ldposx, Float:eek:ldposy, Float:eek:ldposz;
GetPlayerName(playerid, playername, sizeof(playername));
GetPlayerPos(playerid, oldposx, oldposy, oldposz);
if(PlayerInfo[playerid][pPbiskey] != 999) return SCM(playerid, COLOR_WHITE, "Ó Âàñ óæå åñòü áèçíåñ!");
for(new b = 0; b < sizeof(BizzInfo); b++){
if(PlayerToPoint(2.0, playerid, BizzInfo[bEntranceX], BizzInfo[bEntranceY], BizzInfo[bEntranceZ]) && BizzInfo[bOwned] == 0){
if(PlayerInfo[playerid][pCash] > BizzInfo[bBuyPrice]){
PlayerInfo[playerid][pPbiskey] = b;
BizzInfo[bOwned] = 1;
BizzInfo[bLocked] = 0;
BizzInfo[bCena] = 100;
BizzInfo[bTill] = 0;
BizzInfo[b2Till] = 0;
BizzInfo[bProducts] = 10;
BizzInfo[bMafia] = 0;
BizzInfo[bEntranceCost] = 100;
GetPlayerName(playerid, sendername, sizeof(sendername));
strmid(BizzInfo[bOwner], sendername, 0, strlen(sendername), 255);
PlayerInfo[playerid][pCash] -=BizzInfo[bBuyPrice];
SetPlayerInterior(playerid,BizzInfo[bInterior]);
SetPlayerInterior(playerid, BizzInfo[bInterior]);
SetPlayerPos(playerid,bInts[BizzInfo[bExitX]][biX], bInts[BizzInfo[bExitX]][biY], bInts[BizzInfo[bExitX]][biZ]);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerInterior(playerid, BizzInfo[bInterior]);
SCM(playerid, COLOR_LIGHTGREEN, " Áèçíåñ ïðèîáðåò¸í");
SCM(playerid, COLOR_WHITE, "Ïîìîùü ïî áèçíåñó: /business");
format(string,sizeof(string), "{FFFF00}%s\n{ffffff}Âëàäåëåö: {0099FF}%s\n{66CC00}Âõîä: {FF9900}%d$", BizzInfo[bMessage], BizzInfo[bOwner], BizzInfo[bEntranceCost]);
Update3DTextLabelText(BizzInfo[bLabel], -1, string);
SaveBiz(b);
return true;}else{
SCM(playerid, COLOR_WHITE, "Íà Âàøåì ñ÷åòó íåò ñòîëüêî äåíåã!");
return true;}}}}else{return true;}}

stock BuyBiz(d){
new string2[300];
for(new S; S < sizeof(bInts); S++)
{
new icon = 0, bint = bInts[BizzInfo[d][bInterior]][biInt];
if(bint == 1) icon = 17;
else if(bint == 2) icon = 50;
else if(bint == 3) icon = 44;
else if(bint == 4) icon = 58;
else if(bint == 5) icon = 49;
else if(bint == 6) icon = 45;
if(BizzInfo[d][bOwned] == 0)
{
AddStaticPickup(19132, 23, BizzInfo[d][bEntranceX], BizzInfo[d][bEntranceY], BizzInfo[d][bEntranceZ]);
AddStaticPickup(19132, 23, bInts[BizzInfo[d][bExitX]][biX], bInts[BizzInfo[d][bExitX]][biY], bInts[BizzInfo[d][bExitX]][biZ]);
format(string2, sizeof(string2), "{FFFF00}%s\n{66CC00}Ïðîäà¸òñÿ\nÖåíà: {FFCD00}%d$",BizzInfo[d][bMessage],BizzInfo[d][bBuyPrice]);
BizzInfo[d][bLocked] = 1;
Update3DTextLabelText(BizzInfo[d][bLabel],0xFFFFFFFF,string2);
}
if(BizzInfo[d][bOwned] == 1)
{
AddStaticPickup(19132, 23, BizzInfo[d][bEntranceX], BizzInfo[d][bEntranceY], BizzInfo[d][bEntranceZ], BizzInfo[d][bLocked]);
AddStaticPickup(19132, 23, bInts[BizzInfo[d][bExitX]][biX], bInts[BizzInfo[d][bExitX]][biY], bInts[BizzInfo[d][bExitX]][biZ]);
format(string2,sizeof(string2), "{FFFF00}%s\n{ffffff}Âëàäåëåö: {0099FF}%s\n{66CC00}Âõîä: {FF9900}%d$", BizzInfo[d][bMessage], BizzInfo[d][bOwner],BizzInfo[d][bEntranceCost]);
Update3DTextLabelText(BizzInfo[d][bLabel],0xFFFFFFFF,string2);
CreateDynamicMapIcon(BizzInfo[d][bEntranceX], BizzInfo[d][bEntranceY], BizzInfo[d][bEntranceZ], icon, 0, -1, -1, -1, 400.0);
}
}
}

stock SaveBiz(h)
{
new str[1500];
format(str, sizeof(str), "UPDATE `biz` SET `bOwned`='%i',`bOwner`='%s',`bMessage`='%s',`bExtortion`='%s'",BizzInfo[h][bOwned],BizzInfo[h][bOwner],BizzInfo[h][bMessage],BizzInfo[h][bExtortion]);
format(str, sizeof(str), "%s, `bEntranceX`='%f',`bEntranceY`='%f',`bEntranceZ`='%f'",str,BizzInfo[h][bEntranceX],BizzInfo[h][bEntranceY],BizzInfo[h][bEntranceZ]);
format(str, sizeof(str), "%s, `bExitX`='%i',`bExitY`='%f',`bExitZ`='%f'",str,BizzInfo[h][bExitX],BizzInfo[h][bExitY],BizzInfo[h][bExitZ]);
format(str, sizeof(str), "%s, `bCena`='%i',`bBuyPrice`='%i',`bEntranceCost`='%i',`bMafia`='%i',`bTakings`='%i'",str,BizzInfo[h][bCena],BizzInfo[h][bBuyPrice],BizzInfo[h][bEntranceCost],BizzInfo[h][bMafia],BizzInfo[h][bTakings]);
format(str, sizeof(str), "%s, `bTill`='%i',`bLocked`='%i',`bInterior`='%i',`b2Till`='%i'",str,BizzInfo[h][bTill],BizzInfo[h][bLocked],BizzInfo[h][bInterior],BizzInfo[h][b2Till]);
format(str, sizeof(str), "%s, `bProducts`='%i',`bMaxProducts`='%i',`bPriceProd`='%i'",str,BizzInfo[h][bProducts],BizzInfo[h][bMaxProducts],BizzInfo[h][bPriceProd]);
format(str, sizeof(str), "%s WHERE bID = '%i'",str,h);
mysql_function_query(1, str, false, "", "");
return true;
}
stock SaveSBiz(h)
{
new str[1000];
format(str, sizeof(str), "UPDATE `sbiz` SET `sbOwned`='%i',`sbOwner`='%s',`sbMessage`='%s'",SBizzInfo[h][sbOwned],SBizzInfo[h][sbOwner],SBizzInfo[h][sbMessage]);
format(str, sizeof(str), "%s, `sbLevelNeeded`='%i',`sbBuyPrice`='%i',`sbEntranceCost`='%i'",str,SBizzInfo[h][sbLevelNeeded],SBizzInfo[h][sbBuyPrice],SBizzInfo[h][sbEntranceCost]);
format(str, sizeof(str), "%s, `sbTill`='%i',`sbLocked`='%i',`sbInterior`='%i'",str,SBizzInfo[h][sbTill],SBizzInfo[h][sbLocked],SBizzInfo[h][sbInterior]);
format(str, sizeof(str), "%s, `sbProducts`='%i',`s2bTill`='%i',`sbPriceProd`='%i'",str,SBizzInfo[h][sbProducts],SBizzInfo[h][s2bTill],SBizzInfo[h][sbPriceProd]);
format(str, sizeof(str), "%s, `sbMafia`='%i',`sbTakings`='%i' WHERE sbID = '%i'",str,SBizzInfo[h][sbMafia],SBizzInfo[h][sbTakings],h);
mysql_function_query(1, str, false, "", "");
return true;
}
if(strcmp(cmd, "/addbiz", true) == 0)
{
if(PlayerInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, COLOR_WHITE, "Èñïîëüçóéòå êîìàíäó {ff9900}/mm {FFFFFF}äëÿ ïðîñìîòðà ñïèñêà êîìàíä.");
if(sscanf(params, "d", params[0])) return SendClientMessage(playerid, COLOR_WHITE, "Ââåäèòå: /addbiz [id]");
new Float:pos[3],query[500];
GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
format(query, sizeof(query), "INSERT INTO `biz`(`bID`, `bEntranceX`, `bEntranceY`, `bEntranceZ`) VALUES ('%d','%f', '%f', '%f')", params[0], Pos[0], Pos[1], Pos[2]);
mysql_tquery(1, query, "", "");
new house = params[0];
BizzInfo[house][bID] = house;
BizzInfo[house][bEntranceX] = Pos[0];
BizzInfo[house][bEntranceY] = Pos[1];
BizzInfo[house][bEntranceZ] = Pos[2];
BuyBiz(house);
SaveBiz(house);
}
if(strcmp(cmd, "/setnamebiz", true) == 0)
{
for(new b = 0; b < sizeof(BizzInfo); b++){
if(sscanf(params, "u", params[0])) return SendClientMessage(playerid, COLOR_WHITE, "Ââåäèòå: /setnamebiz [id èìÿ]");
if(PlayerInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, COLOR_WHITE, "Èñïîëüçóéòå êîìàíäó {ff9900}/mm {FFFFFF}äëÿ ïðîñìîòðà ñïèñêà êîìàíä.");
new house = BizzInfo[bID];
switch(params[0]){
case 0:{
strmid(BizzInfo[house][bMessage], "Ìàãàçèí 24/7", 0, 32, 32);}
case 1:{
strmid(BizzInfo[house][bMessage], "Ñòîëîâàÿ", 0, 32, 32);}
case 2:{
strmid(BizzInfo[house][bMessage], "Êàçèíî", 0, 32, 32);
BuyBiz(house);
SaveBiz(house);}}}}
if(strcmp(cmd, "/editbiz", true) == 0)
{
if(PlayerInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, COLOR_WHITE, "Èñïîëüçóéòå êîìàíäó {ff9900}/mm {FFFFFF}äëÿ ïðîñìîòðà ñïèñêà êîìàíä.");
ShowPlayerDialog(playerid, 2000, DIALOG_STYLE_INPUT, "Íàçâàíèå", "Ââåäèòå íàçâàíèå:", "Äàëåå","Îòìåíà");//Åñëè íå ââåäåíî - ïîâòîðÿåì
}

в логах ошибок нет

 
Вам необходимо войти или зарегистрироваться, чтобы здесь отвечать.
Верх Низ