Wockeez
Дебютант
Ошибка в mysql_query
Здравствуйте, вот при компилировании у меня возникла ошибка
Ошибка связана с MySQL
Ошибка возникает в строках с
хотя написано все правильно
Версия MySQL: R35
Помогите найти решение проблемы
Здравствуйте, вот при компилировании у меня возникла ошибка
Код:
(11972) : error 035: argument type mismatch (argument 1)
(12045) : error 035: argument type mismatch (argument 1)
Код:
format(query, sizeof(query), "SELECT * FROM houses WHERE ID = '%i'", idhouse);
11972 mysql_query(query);
mysql_store_result();
if(mysql_fetch_row_format(query)) return SCM(playerid,COLOR_GRAD2, "123");
GetPlayerPos(playerid, xch, ych, zch);
HouseInfo[idhouse][ExitX] = xch;
HouseInfo[idhouse][ExitY]= ych;
HouseInfo[idhouse][ExitZ] = zch;
HouseInfo[idhouse][hOwned] = 0;
HouseInfo[idhouse][hRentTime] = 5;
HouseInfo[idhouse][hClass] = classhouse;
HouseInfo[idhouse][hPrice] = pricehouse;
HouseInfo[idhouse][hWorld] = idhouse+50;
HouseInfo[idhouse][hLock] = 1;
HouseInfo[idhouse][hCarColorOne] = -1;
HouseInfo[idhouse][hCarColorTwo] = -1;
HouseInfo[idhouse][hUpdate] = 0;
if(HouseInfo[idhouse][hClass] == 0) HouseInfo[idhouse][hRentPlata] = 800;
if(HouseInfo[idhouse][hClass] == 1) HouseInfo[idhouse][hRentPlata] = 1500;
if(HouseInfo[idhouse][hClass] == 2) HouseInfo[idhouse][hRentPlata] = 2000;
if(HouseInfo[idhouse][hClass] == 3) HouseInfo[idhouse][hRentPlata] = 2000;
if(HouseInfo[idhouse][hClass] == 4) HouseInfo[idhouse][hRentPlata] = 3000;
if(HouseInfo[idhouse][hClass] == 5) HouseInfo[idhouse][hRentPlata] = 3500;
if(HouseInfo[idhouse][hClass] == 6) HouseInfo[idhouse][hRentPlata] = 5500;
if(HouseInfo[idhouse][hClass] == 7) HouseInfo[idhouse][hRentPlata] = 6000;
if(HouseInfo[idhouse][hClass] == 8) HouseInfo[idhouse][hRentPlata] = 10000;
switch(classhouse){
case 1:{
HouseInfo[idhouse][hInt] = 10;
HouseInfo[idhouse][ExitIntX] = 2261.3103;
HouseInfo[idhouse][ExitIntY] = -1136.4467;
HouseInfo[idhouse][ExitIntZ] = 1050.6328;}
case 2:{
HouseInfo[idhouse][hInt] = 2;
HouseInfo[idhouse][ExitIntX] = 225.9761;
HouseInfo[idhouse][ExitIntY] = 1239.9126;
HouseInfo[idhouse][ExitIntZ] = 1082.1406;}
case 3:{
HouseInfo[idhouse][hInt] = 5;
HouseInfo[idhouse][ExitIntX] = 318.6727;
HouseInfo[idhouse][ExitIntY] = 1117.6812;
HouseInfo[idhouse][ExitIntZ] = 1083.8828;}
case 4:{
HouseInfo[idhouse][hInt] = 10;
HouseInfo[idhouse][ExitIntX] = 23.8334;
HouseInfo[idhouse][ExitIntY] = 1340.4812;
HouseInfo[idhouse][ExitIntZ] = 1084.3750;}
case 5:{
HouseInfo[idhouse][hInt] = 4;
HouseInfo[idhouse][ExitIntX] = -261.9759;
HouseInfo[idhouse][ExitIntY] = 1456.8844;
HouseInfo[idhouse][ExitIntZ] = 1084.3672;}
case 6:{
HouseInfo[idhouse][hInt] = 2;
HouseInfo[idhouse][ExitIntX] = 491.0190;
HouseInfo[idhouse][ExitIntY] = 1399.0691;
HouseInfo[idhouse][ExitIntZ] = 1080.2578;}
case 7:{
HouseInfo[idhouse][hInt] = 12;
HouseInfo[idhouse][ExitIntX] = 2324.3262;
HouseInfo[idhouse][ExitIntY] = -1148.5212;
HouseInfo[idhouse][ExitIntZ] = 1050.7101;}
case 8:{
HouseInfo[idhouse][hInt] = 5;
HouseInfo[idhouse][ExitIntX] = 1298.8900;
HouseInfo[idhouse][ExitIntY] = -795.6447;
HouseInfo[idhouse][ExitIntZ] = 1084.0078;}
case 9:{
HouseInfo[idhouse][hInt] = 1;
HouseInfo[idhouse][ExitIntX] = 244.411987;
HouseInfo[idhouse][ExitIntY] = 305.032989;
HouseInfo[idhouse][ExitIntZ] = 999.148437;}}
format(query, sizeof(query), "INSERT INTO `houses` (ExitX,ExitY,ExitZ,ExitIntX,ExitIntY,ExitIntZ,Price,Inter,Locked,Class,renta,renttime,world,ID) VALUES ('%f','%f','%f','%f','%f','%f','%i','%i','%i','%i','%i','%i','%i','%i')"
,HouseInfo[idhouse][ExitX], HouseInfo[idhouse][ExitY],HouseInfo[idhouse][ExitZ],HouseInfo[idhouse][ExitIntX],HouseInfo[idhouse][ExitIntY],HouseInfo[idhouse][ExitIntZ],HouseInfo[idhouse][hPrice],HouseInfo[idhouse][hInt],HouseInfo[idhouse][hLock],HouseInfo[idhouse][hClass],HouseInfo[idhouse][hRentPlata],HouseInfo[idhouse][hRentTime],HouseInfo[idhouse][hWorld],idhouse);
12045 mysql_query(query);
mysql_store_result();
SaveHouse(idhouse);
UpdateHouse(idhouse);
}
else
{
}
}
return true;
}
Ошибка возникает в строках с
Код:
mysql_query(query);
Версия MySQL: R35
Помогите найти решение проблемы
Последнее редактирование:
