15.03.2012, 14:44
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);