Simple problem creating a house - 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: Simple problem creating a house (/showthread.php?tid=435867)
+- 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: Simple problem creating a house (/showthread.php?tid=435867)
Simple problem creating a house - legho - 08.05.2013
Hello ive created this house system and it works perfectly i create the houses IG with a command. it works perfectly for the first house i create. but then i try to create another and it doesent do anything to the DB but it prints...
Код:
stock CreateHouse(Float:EnterPosX,Float:EnterPosY,Float:EnterPosZ,Float:ExitPosX,Float:ExitPosY,Float:ExitPosZ,Int,Price)
{
new query[128*4];
houseid ++;
HouseInfo[houseid][hEnterPos][0] = EnterPosX;
HouseInfo[houseid][hEnterPos][1] = EnterPosY;
HouseInfo[houseid][hEnterPos][2] = EnterPosZ;
HouseInfo[houseid][hExitPos][0] = ExitPosX;
HouseInfo[houseid][hExitPos][1] = ExitPosY;
HouseInfo[houseid][hExitPos][2] = ExitPosZ;
HouseInfo[houseid][hInt] = Int;
HouseInfo[houseid][hPrice] = Price;
format(query, sizeof(query), "INSERT INTO `houseinfo` (`HouseID`, `HouseOwner`, `EnterPosX`, `EnterPosY`, `EnterPosZ`, `ExitPosX`, `ExitPosY`, `ExitPosZ`, `World`, `Interior`, `Price` ) VALUES ('%d', 'For Sale', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d')",houseid,HouseInfo[houseid][hEnterPos][0],HouseInfo[houseid][hEnterPos][1],HouseInfo[houseid][hEnterPos][2],HouseInfo[houseid][hExitPos][0],HouseInfo[houseid][hExitPos][1],HouseInfo[houseid][hExitPos][2],
HouseInfo[houseid][hID],HouseInfo[houseid][hInt],HouseInfo[houseid][hPrice]);
mysql_function_query(mCon, query, false, "", "","");
printf("House ID: %d. has been created.",houseid);
return 1;
}
Код:
enum hInfo
{
hID,
hOwner[MAX_PLAYER_NAME],
Float:hEnterPos[3],
Float:hExitPos[3],
hInt,
hPrice,
Text3D:hText,
Text3D:hExitText
};
new HouseInfo[MAX_HOUSES][hInfo], houseid;
Regards.