15.04.2014, 08:40
When i stop my sa:mp server, i have some errors in mysql_log.
mysql_log.txt
gamemode.pwn
mysql_log.txt
Код:
[22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-185.539993', `MinY`='-2255.850098', `MaxY`='48.820000' WHERE `ID`='1'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-70.309998', `MinY`='-2154.290039', `MaxY`='212.889999' WHERE `ID`='2'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-68.349998', `MinY`='-2003.900024', `MaxY`='117.180000' WHERE `ID`='3'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-291.010010', `MinY`='-2005.849976', `MaxY`='-68.349998' WHERE `ID`='4'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='46.869999', `MinY`='-2703.120117', `MaxY`='292.959991' WHERE `ID`='5'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='48.820000', `MinY`='-2416.010010', `MaxY`='169.919998' WHERE `ID`='6'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-64.449997', `MinY`='-2597.649902', `MaxY`='48.820000' WHERE `ID`='7'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-201.169998', `MinY`='-2417.959961', `MaxY`='50.779999' WHERE `ID`='8'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='-199.210007', `MinY`='-2599.600098', `MaxY`='-62.500000' WHERE `ID`='9'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='169.899994', `MinY`='-2542.959961', `MaxY`='292.959991' WHERE `ID`='10'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='292.959991', `MinY`='-2699.209961', `MaxY`='470.700012' WHERE `ID`='11'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='292.959991', `MinY`='-2546.870117', `MaxY`='470.700012' WHERE `ID`='12'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='714.840027', `MinY`='-2523.429932', `MaxY`='814.450012' WHERE `ID`='13'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='814.450012', `MinY`='-2525.389893', `MaxY`='908.200012' WHERE `ID`='14'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='908.200012', `MinY`='-2525.389893', `MaxY`='1015.619995' WHERE `ID`='15'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='716.750000', `MinY`='-2382.810059', `MaxY`='917.960022' WHERE `ID`='16'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='923.820007', `MinY`='-2138.669922', `MaxY`='1103.510010' WHERE `ID`='17'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='742.179993', `MinY`='-2138.669922', `MaxY`='925.780029' WHERE `ID`='18'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='570.309998', `MinY`='-2000.010010', `MaxY`='744.140015' WHERE `ID`='19'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='744.140015', `MinY`='-2001.949951', `MaxY`='966.789978' WHERE `ID`='20'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='613.280029', `MinY`='-1708.979980', `MaxY`='738.280029' WHERE `ID`='21'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='851.559998', `MinY`='-1890.619995', `MaxY`='1089.839966' WHERE `ID`='22'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='738.280029', `MinY`='-1802.729980', `MaxY`='853.510010' WHERE `ID`='23'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='853.510010', `MinY`='-1710.930054', `MaxY`='1111.319946' WHERE `ID`='24'' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='1103.510010', `MinY`='-2142.570068', `MaxY`='1281.250000' WHERE `ID`='25' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='1173.819946', `MinY`='-1878.900024', `MaxY`='1281.250000' WHERE `ID`='26' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='1111.319946', `MinY`='-1712.890015', `MaxY`='1281.250000' WHERE `ID`='27' at line 1 [22:44:13] [ERROR] CMySQLQuery::Execute[()] - (error #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 '`MaxX`='412.100006', `MinY`='-1847.650024', `MaxY`='617.179993' WHERE `ID`='28'' at line 1
Код:
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
/* * OnGameModeExit * */
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
public OnGameModeExit()
{
//...
STeri();
//...
return 1;
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
/* * TERI * */
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
public LTeri()
{
new Rows, Fields, t=0, ax=0, nrt;
cache_get_data(Rows, Fields, mysql);
if(Rows)
{
for(; t != Rows; ++t, ax = 0)
{
if ( t >= 29 ) {
printf( " !ERROR! Numarul de teritorii depaseste numarul maxim !ERROR!" ) ;
break ;
}
TeriInfo[t][zID] = cache_get_row_int(t, ax++, mysql) ;
TeriInfo[t][zOwned] = cache_get_row_int(t, ax++, mysql) ;
TeriInfo[t][zMinX] = cache_get_row_float(t, ax++, mysql) ;
TeriInfo[t][zMaxX] = cache_get_row_float(t, ax++, mysql) ;
TeriInfo[t][zMinY] = cache_get_row_float(t, ax++, mysql) ;
TeriInfo[t][zMaxY] = cache_get_row_float(t, ax++, mysql) ;
ter[t] = GangZoneCreateEx(TeriInfo[t][zMinX], TeriInfo[t][zMaxX], TeriInfo[t][zMinY], TeriInfo[t][zMaxY], t, 0.7);
nrt++;
}
}
printf("* Total Teritorii War: %d", nrt);
return 1;
}
public STeri()
{
for(new t=0; t<teritoriii; t++)
{
mysql_format(mysql, query, sizeof(query), "UPDATE `teritorii` SET `Owned`='%d', `MinX`='%f' `MaxX`='%f', `MinY`='%f', `MaxY`='%f' WHERE `ID`='%d'",
TeriInfo[t][zOwned], TeriInfo[t][zMinX], TeriInfo[t][zMaxX], TeriInfo[t][zMinY], TeriInfo[t][zMaxY], TeriInfo[t][zID]);
mysql_tquery(mysql, query, "", "");
}
return 1;
}
