Erori mysql_log

[Punct.]

: Punct.

Problema: Primesc cateva erori in mysql_log cand opresc serverul SA:MP.

Erori / warnings:

[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

Lini/script:

[pawn]

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;

}

[/pawn]

Ai incercat sa rezolvi singur ?: Da. Aveam si la case aceeasi problema, dar s-a rezolvat.

[Punct.]

Rezolvat!

Am uitat o " , "