02.08.2017, 16:58
Got some problem with SAVE HOUSES
Can anyone help me ?
Here is the codes of the COMMAND [/sethouse]
The problem is when i type /sethouse It won't save on MySQL
Can anyone help me ?
Here is the codes of the COMMAND [/sethouse]
pawn Код:
CMD:sethouse(playerid,params[])
{
LogCallback("sethouse");
if(PlayerInfo[playerid][pAdmin] >= 4)
{
new Float:X,Float:Y,Float:Z,type,sqlQuery[64],string[128],string2[256];
GetPlayerPos(playerid,X,Y,Z);
if(sscanf(params, "d", type))
{
SCM(playerid, COLOR_GRAD2, "USAGE: /sethouse [type]");
SCM(playerid, COLOR_GRAD2, "TYPES: 0 Apartment - 1 Small - 2 Medium - 3 Big");
return 1;
}
for(new houseid = 0; houseid < sizeof(HouseInfo); houseid++)
{
if(HouseInfo[houseid][hSetted] == 0)
{
format(sqlQuery, sizeof(sqlQuery), "INSERT INTO `wcrp_houses` SET HouseID='%d'", houseid);
mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid);
switch(type)
{
case 0:
{
HouseInfo[houseid][hValue] = 45000;
HouseInfo[houseid][hLevel] = 3;
strmid(HouseInfo[houseid][hDiscription], "House Apartment", 0, strlen("House Apartment"), 255);
switch(nextapartment)
{
case 24: { nextapartment = 25; HouseInfo[houseid][hExitx] = 244.411987; HouseInfo[houseid][hExity] = 305.032990; HouseInfo[houseid][hExitz] = 999.231995; HouseInfo[houseid][hInt] = 1;}
case 25: { nextapartment = 27; HouseInfo[houseid][hExitx] = 266.4991; HouseInfo[houseid][hExity] = 304.9922; HouseInfo[houseid][hExitz] = 999.1484; HouseInfo[houseid][hInt] = 2; }
case 27: { nextapartment = 29;HouseInfo[houseid][hExitx] = 302.181000; HouseInfo[houseid][hExity] = 300.722992; HouseInfo[houseid][hExitz] = 999.231995; HouseInfo[houseid][hInt] = 4; }
case 29: { nextapartment = 24; HouseInfo[houseid][hExitx] = 346.870025; HouseInfo[houseid][hExity] = 309.259033; HouseInfo[houseid][hExitz] = 999.155700; HouseInfo[houseid][hInt] = 6; }
}
}
case 1:
{
HouseInfo[houseid][hValue] = 50000;
HouseInfo[houseid][hLevel] = 4;
strmid(HouseInfo[houseid][hDiscription], "House Small", 0, strlen("House Small"), 255);
switch(nexthouse)
{
case 2: { nexthouse = 3; HouseInfo[houseid][hExitx] = 225.756989; HouseInfo[houseid][hExity] = 1240.000000; HouseInfo[houseid][hExitz] = 1082.149902; HouseInfo[houseid][hInt] = 2; }
case 3: { nexthouse = 6; HouseInfo[houseid][hExitx] = 223.1929; HouseInfo[houseid][hExity] = 1287.0780; HouseInfo[houseid][hExitz] = 1082.1406; HouseInfo[houseid][hInt] = 1; }
case 6: { nexthouse = 12; HouseInfo[houseid][hExitx] = 328.1066; HouseInfo[houseid][hExity] = 1478.0106; HouseInfo[houseid][hExitz] = 1084.4375; HouseInfo[houseid][hInt] = 15; }
case 12: { nexthouse = 41; HouseInfo[houseid][hExitx] = 260.983978; HouseInfo[houseid][hExity] = 1286.549927; HouseInfo[houseid][hExitz] = 1080.299927; HouseInfo[houseid][hInt] = 4; }
case 41: { nexthouse = 2; HouseInfo[houseid][hExitx] = 446.5014; HouseInfo[houseid][hExity] = 507.0295; HouseInfo[houseid][hExitz] = 1001.4195; HouseInfo[houseid][hInt] = 12; }
}
}
case 2:
{
HouseInfo[houseid][hValue] = 65000;
HouseInfo[houseid][hLevel] = 6;
strmid(HouseInfo[houseid][hDiscription], "House Medium", 0, strlen("House Medium"), 255);
switch(nextmedium)
{
case 17: { nextmedium = 19; HouseInfo[houseid][hExitx] = 140.2267; HouseInfo[houseid][hExity] = 1365.9246; HouseInfo[houseid][hExitz] = 1083.8594; HouseInfo[houseid][hInt] = 5; }
case 19: { nextmedium = 21; HouseInfo[houseid][hExitx] = -68.294098; HouseInfo[houseid][hExity] = 1353.469971; HouseInfo[houseid][hExitz] = 1080.279907; HouseInfo[houseid][hInt] = 6; }
case 21: { nextmedium = 30; HouseInfo[houseid][hExitx] = -42.581997; HouseInfo[houseid][hExity] = 1408.109985; HouseInfo[houseid][hExitz] = 1084.449951; HouseInfo[houseid][hInt] = 8; }
case 30: { nextmedium = 32; HouseInfo[houseid][hExitx] = 2495.6416; HouseInfo[houseid][hExity] = -1692.2361; HouseInfo[houseid][hExitz] = 1014.7422; HouseInfo[houseid][hInt] = 3; }
case 32: { nextmedium = 38; HouseInfo[houseid][hExitx] = 2468.4502; HouseInfo[houseid][hExity] = -1698.4801; HouseInfo[houseid][hExitz] = 1013.5078; HouseInfo[houseid][hInt] = 2; }
case 38: { nextmedium = 39; HouseInfo[houseid][hExitx] = 2807.9172; HouseInfo[houseid][hExity] = -1174.4333; HouseInfo[houseid][hExitz] = 1025.5703; HouseInfo[houseid][hInt] = 8; }
case 39: { nextmedium = 17; HouseInfo[houseid][hExitx] = 318.7010; HouseInfo[houseid][hExity] = 1114.7716; HouseInfo[houseid][hExitz] = 1083.8828; HouseInfo[houseid][hInt] = 5; }
}
}
case 3:
{
HouseInfo[houseid][hValue] = 85000;
HouseInfo[houseid][hLevel] = 9;
strmid(HouseInfo[houseid][hDiscription], "House Big", 0, strlen("House Big"), 255);
switch(nextbig)
{
case 1: { nextbig = 4; HouseInfo[houseid][hExitx] = 235.3054; HouseInfo[houseid][hExity] = 1186.6835; HouseInfo[houseid][hExitz] = 1080.2578; HouseInfo[houseid][hInt] = 3; }
case 4: { nextbig = 11; HouseInfo[houseid][hExitx] = 225.630997; HouseInfo[houseid][hExity] = 1022.479980; HouseInfo[houseid][hExitz] = 1084.069946; HouseInfo[houseid][hInt] = 7; }
case 11: { nextbig = 13; HouseInfo[houseid][hExitx] = 227.722992; HouseInfo[houseid][hExity] = 1114.389893; HouseInfo[houseid][hExitz] = 1081.189941; HouseInfo[houseid][hInt] = 5; }
case 13: { nextbig = 14; HouseInfo[houseid][hExitx] = 221.7330; HouseInfo[houseid][hExity] = 1140.5146; HouseInfo[houseid][hExitz] = 1082.6094; HouseInfo[houseid][hInt] = 4; }
case 14: { nextbig = 15; HouseInfo[houseid][hExitx] = 27.132700; HouseInfo[houseid][hExity] = 1341.149902; HouseInfo[houseid][hExitz] = 1084.449951; HouseInfo[houseid][hInt] = 10; }
case 15: { nextbig = 40; HouseInfo[houseid][hExitx] = -262.601990; HouseInfo[houseid][hExity] = 1456.619995; HouseInfo[houseid][hExitz] = 1084.449951; HouseInfo[houseid][hInt] = 4;}
case 40: { nextbig = 1; HouseInfo[houseid][hExitx] = 2324.3267; HouseInfo[houseid][hExity] = -1149.1440; HouseInfo[houseid][hExitz] = 1050.7101; HouseInfo[houseid][hInt] = 12; }
}
}
}
HouseInfo[houseid][hEntrancex] = X; HouseInfo[houseid][hEntrancey] = Y; HouseInfo[houseid][hEntrancez] = Z; HouseInfo[houseid][hWorld] = houseid; HouseInfo[houseid][hSetted] = 1;
strmid(HouseInfo[houseid][hOwner],"The State",0,strlen("The State"),255); strmid(HouseInfo[houseid][hMessage],"For Sale",0,strlen("For Sale"),255); HouseInfo[houseid][hExVW] = GetPlayerVirtualWorld(playerid);
EvaluateHouse(houseid); HouseInfo[houseid][hExVW] = GetPlayerVirtualWorld(playerid); HouseInfo[houseid][hExINT] = GetPlayerInterior(playerid);
format(string, sizeof(string),"* Created the house number %d. The house was set automatically, Use /edit to edit it if you want.",houseid); SCM(playerid, COLOR_LIGHTBLUE, string);
format(string,sizeof(string),"[ADMIN]: %s Has Set House: [%d]'s entrance to [%f - %f - %f].",GPN(playerid),houseid,X,Y,Z); ABroadCast(COLOR_LIGHTRED,string, 5);
format(string2,sizeof(string2),"[For Sale]\n House ID: %d \n Price: $%d \n Description: %s \n Level Needed: %d",HouseInfo[houseid][hWorld], HouseInfo[houseid][hValue],HouseInfo[houseid][hDiscription], HouseInfo[houseid][hLevel]);
HouseLabel[houseid] = Create3DTextLabel(string2 ,0x00FF00AA,X,Y,Z,25, 0, 1);
HousePickup[houseid] = CreateDynamicPickup(1273, 1, HouseInfo[houseid][hEntrancex], HouseInfo[houseid][hEntrancey], HouseInfo[houseid][hEntrancez]);
FullHouseSave(houseid); OnPropTextdrawUpdate(1, houseid); OnHousePickupUpdate(houseid);
break;
}
}
} else return SendClientMessage(playerid,-1,"You are not an admin so you cannot use this command");
LogCallback("sethouse");
return 1;
}
