Windows_8
Умник
Записывает не те координаты в БД
PHP:
stock RepairHouse(playerid,listitem,idx)
{
new i = GetPVarInt(playerid, "PlayerHouse");
new string[90];
switch(listitem)
{
case 0:
{
if(HouseInfo[i][hDiscript] == 0) format(string,90,"2259.5068,-1135.9337,1050.6328,0,10");
if(HouseInfo[i][hDiscript] == 1) format(string,90,"2218.3875,-1076.1580,1050.4844,1,1");
if(HouseInfo[i][hDiscript] == 2) format(string,90,"377.1231,1417.3163,1081.3281,2,15");
if(HouseInfo[i][hDiscript] == 3) format(string,90,"-283.6001,1471.2211,1084.3750,3,15");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"140.2660,1366.1091,1083.8594,4,5");
if(HouseInfo[i][hDiscript] == 5) format(string,90,"234.1541,1063.7206,1084.2123,5,6");
}
case 1:
{
if(HouseInfo[i][hDiscript] == 0) format(string,90,"2233.6965,-1115.1270,1050.8828,0,5");
if(HouseInfo[i][hDiscript] == 1) format(string,90,"221.7789,1140.1970,1082.6094,1,4");
if(HouseInfo[i][hDiscript] == 2) format(string,90,"327.9864,1477.7328,1084.4375,2,15");
if(HouseInfo[i][hDiscript] == 3) format(string,90,"447.2238,1397.2926,1084.3047,3,2");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"24.0716,1340.1615,1084.3750,4,10");
if(HouseInfo[i][hDiscript] == 5) format(string,90,"235.2748,1186.6809,1080.2578,5,3");
}
case 2:
{
if(HouseInfo[i][hDiscript] == 0) format(string,90,"244.0883,305.0291,999.1484,0,1");
if(HouseInfo[i][hDiscript] == 1) format(string,90,"261.1874,1284.2982,1080.2578,1,4");
if(HouseInfo[i][hDiscript] == 2) format(string,90,"2237.5413,-1081.1516,1049.04,2,2");
if(HouseInfo[i][hDiscript] == 3) format(string,90,"295.2479,1472.2650,1080.2578,3,15");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"2196.8469,-1204.3524,1049.0234,4,6");
if(HouseInfo[i][hDiscript] == 5) format(string,90,"226.2956,1114.1615,1080.9929,5,5");
}
case 3:
{
if(HouseInfo[i][hDiscript] == 0) format(string,90,"266.9498,304.9866,999.1484,0,2");
if(HouseInfo[i][hDiscript] == 1) format(string,90,"2468.2080,-1698.2988,1013.5078,1,2");
if(HouseInfo[i][hDiscript] == 2) format(string,90,"2365.3345,-1135.5907,1050.8826,2,8");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"2317.7983,-1026.7651,1050.2178,4,9");
if(HouseInfo[i][hDiscript] == 5) format(string,90,"2324.3977,-1149.0601,1050.7101,5,12");
}
case 4:
{
if(HouseInfo[i][hDiscript] == 2) format(string,90,"387.1313,1471.7137,1080.1949,2,15");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"83.0791,1322.2808,1083.8662,4,9");
}
case 5:
{
if(HouseInfo[i][hDiscript] == 2) format(string,90,"226.4436,1239.9277,1082.1406,2,2");
if(HouseInfo[i][hDiscript] == 4) format(string,90,"-260.4934,1456.8430,1084.3672,4,4");
}
case 6: if(HouseInfo[i][hDiscript] == 2) format(string,90,"22.9848,1403.3345,1084.4370,2,5");
}
switch(idx)
{
case 0:
{
new Float:p[3],pp;
sscanf(string,"p<,>fffii",p[0],p[1],p[2],pp,pp);
SetPlayerPos(playerid,p[0],p[1],p[2]);
SetPlayerInterior(playerid,pp);
SetPlayerVirtualWorld(playerid,i);
}
case 1:
{
new cost;
switch(HouseInfo[i][hDiscript])
{
case 0: cost = 100000;
case 1: cost = 250000;
case 2: cost = 500000;
case 3: cost = 750000;
case 4: cost = 1000000;
case 5: cost = 1500000;
}
if(pInfo[playerid][pMoney] < cost) return SendClientMessage(playerid, -1,"Недостаточно средств."), DeletePVar(playerid,"RepairHouse");
pInfo[playerid][pMoney] -= cost;
sscanf(string,"p<,>fffii", HouseInfo[i][hExit][0],HouseInfo[i][hExit][1],HouseInfo[i][hExit][2],HouseInfo[i][hDiscript],HouseInfo[i][hInt]);
DeletePVar(playerid,"RepairHouse");
UpdateHouse(i);
SaveHouse(i);
return SendClientMessage(playerid, -1,"Вы сделали ремонт в своем доме.");
}
}
return true;
}
PHP:
stock SaveHouse(id)
{
new query[512];
format(query, sizeof(query), "UPDATE `house` SET `hExitx` = '%i', `hExity` = '%i', `hExitz` = '%i', `hOwner` = '%s', `hDiscript` = '%d', `hInt` = '%d', `hLock` = '%d', `hBuyPrice` = '%d', `hHeal` = '%d' WHERE `hID` = '%d'",
HouseInfo[id][hExit][0], HouseInfo[id][hExit][1], HouseInfo[id][hExit][2], HouseInfo[id][hOwner], HouseInfo[id][hDiscript], HouseInfo[id][hInt], HouseInfo[id][hLock], HouseInfo[id][hBuyPrice], HouseInfo[id][hHeal], HouseInfo[id][hID]);
mysql_tquery(mysql_connect_ID, query, "", "");
return 1;
}