SA-MP Forums Archive
Some problem with my house system - 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: Some problem with my house system (/showthread.php?tid=325930)


Some problem with my house system - Tanush123 - 15.03.2012

im making createhouse but when i debug it i get this
Код:
[10:46:29] CMySQLHandler::Query(INSERT INTO Houses (ID,OutX,OutY,OutZ,SpawnOutX,SpawnOutY,SpawnOutZ,SpawnOutAngle,SpawnWorld,SpawnInterior,Lock,World,Interior,HasOwner,Cost,Name,Owner) 
VALUES (1,426.670562,2535.133789,16.546875,425.783416,2537.471191,16.546875,0.000000,0,0,0,0,1,0,1,'No Owner','No Owner')) -
 An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lock,World,Interior,HasOwner,Cost,Name,Owner) VALUES (1,426.670562,2535.133789,1' at line 1)
pawn Код:
format(query,sizeof(query),"INSERT INTO Houses (ID,OutX,OutY,OutZ,SpawnOutX,SpawnOutY,SpawnOutZ,SpawnOutAngle,SpawnWorld,SpawnInterior,Lock,World,Interior,HasOwner,Cost,Name,Owner) VALUES (%d,%f,%f,%f,%f,%f,%f,%f,%d,%d,0,%d,%d,0,%d,'No Owner','No Owner')",GetHouseid(),X,Y,Z,xX,yY,Z,floatround((180 + A)),GetPlayerVirtualWorld(playerid),GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid),inte,amount);
    mysql_query(query);