Jump to content

Question

Posted

: 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.

Nu mai deschideti in pu*a mea servere de SA:MP !

Jucati-va pe cele care sunt !   Sunt suficiente !

Reguli de bun simt:

1. Nu faceti reclama unde nu trebuie !

2. Nu injurati ca la usa cortului !

3. Daca esti analfabeti, taci din gura !

4. Nu abuza de 'scuze', 'din greseala' !

 

My work ::: http://pastebin.com/VRNRcaAs

1 answer to this question

Recommended Posts

Posted

Rezolvat!

Am uitat o " , "

Nu mai deschideti in pu*a mea servere de SA:MP !

Jucati-va pe cele care sunt !   Sunt suficiente !

Reguli de bun simt:

1. Nu faceti reclama unde nu trebuie !

2. Nu injurati ca la usa cortului !

3. Daca esti analfabeti, taci din gura !

4. Nu abuza de 'scuze', 'din greseala' !

 

My work ::: http://pastebin.com/VRNRcaAs

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.