houses - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: houses (/showthread.php?tid=492010)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: houses (/showthread.php?tid=492010)
houses - Mattakil - 02.02.2014
my createhouse script seems to bug, somewhere it returns 0, because im getting an unknown command error. If I add debug lines, it prints 1, but not 2, which makes me think that it is an issue in there, though all it does is set variables...
pawn Код:
CMD:createhouse(playerid, params[])
{
if(PlayerInfo[playerid][pAdmin] >=4)
{
new Query[400], price, string[100], owner[MAX_PLAYER_NAME];
housescreated++;
new id = housescreated;
new Float:X, Float:Y, Float:Z;
if(sscanf(params, "d", price)) return UsageMessage(pid, "/createhouse [price]");
GetPlayerPos(playerid, X, Y, Z);
print("1");
format(owner, sizeof(owner), "None");
HouseInfo[id][hAddress] = id;
HouseInfo[id][hOwner] = owner;
HouseInfo[id][hintX] = 0;
HouseInfo[id][hintY] = 0;
HouseInfo[id][hintZ] = 0;
HouseInfo[id][hextX] = X;
HouseInfo[id][hextY] = Y;
HouseInfo[id][hextZ] = Z;
HouseInfo[id][hVW] = 0;
print("2");
HouseInfo[id][hint] = id+1000;
format(Query, sizeof(Query), "INSERT INTO `HOUSES` (`ADDRESS`, `OWNER`, `INTX`, `INTY`, `INTZ`, `EXTX`, `EXTY`, `EXTZ`, `VW`, `INT`, `PRICE`) VALUES(%d, '%s', %f, %f, %f, %f, %f, %f, %d, %d, %d)", id, HouseInfo[id][hOwner], HouseInfo[id][hintX], HouseInfo[id][hintY], HouseInfo[id][hintZ], HouseInfo[id][hextX], HouseInfo[id][hextY], HouseInfo[id][hextZ], HouseInfo[id][hVW], HouseInfo[id][hint], price);
format(string, sizeof(string), "%House For Sale\nAddress: %d\nPrice: %d", id, price);
print("3");
HouseInfo[id][hLabel] = Create3DTextLabel(string, COLGREEN, X, Y, Z, 20.0, 0, 1);
db_query(gamemode, Query);
//SaveHouse(id);
return 1;
}
return 1;
}
Re: houses - CuervO - 02.02.2014
the ID (housescreated) may exceed the array's size?
Re: houses - Mattakil - 02.02.2014
no, that's not it, i tried to define it as 0, still bugged...It did work until I added SaveHouse, but thats why its commented out
Re: houses - Mattakil - 02.02.2014
I had an issue with mysql, so I had converted some things into sqlite, i found the cmd works if I dont load the houses, I reckon this is why.
pawn Код:
mysql_fetch_field_row(string, "ADDRESS");
HouseInfo[ID][hAddress] = strval(Field);
Re: houses - Mattakil - 02.02.2014
....
Re: houses - CuervO - 02.02.2014
Well i have no knowelge about SQLite, I find the actual SQL easier to manage;
Little thing:
pawn Код:
format(owner, sizeof(owner), "None");
HouseInfo[id][hOwner] = owner;
pawn Код:
format(HouseInfo[id][hOwner], 24, "None");
About your error, there's no reason on why it shouldn't print the "2"; It should fail after the second and before the third check if you're using two different methods of saving.