Klaida su mysql offline dejimu

[Dedman]

Neuždeda mysql nesuprantu kodel

 

KODAS:

command(emigruotioff,playerid,params[])
{
	if( useris.epriziuretojas [ playerid ] !=1) return SendClientMessage ( playerid, COLOR_RED, NERA_CMD ) ;
	new Query [ 128 ] , Emigruotas, swxName [ MAX_PLAYER_NAME ] ;
	if( sscanf ( params , "s[24]",swxName ) ) return UseMSG( playerid , "/emigruotioff [ vardasID ] ");
	new Zaidejas = GetPlayeridMid ( swxName ) ;
	if( Zaidejas != INVALID_PLAYER_ID ) return SendClientMessage ( playerid, COLOR_RED, "Žaidėjas yra žaidime!");
	format ( Query , sizeof(Query ) , "SELECT * FROM `zaidejai` WHERE `vardas` = '%s'", swxName ) ;
	mysql_query ( Query ) ;
	mysql_store_result ( ) ;
	mysql_retrieve_row ( ) ;
	if( mysql_num_rows ( ) )
	{
	    mysql_fetch_field_row ( Query , "Emigruotas") ; Emigruotas = strval(Query) ;
	    if( Emigruotas == 1) return SendClientMessage ( playerid, COLOR_RED, "Žaidėjas jau yra emigruotas!");
	    else // jei nėra žaidėjas emigruotas
	    {
	        format ( Query , sizeof(Query),"UPDATE `zaidejai` SET Emigruotas = '1', pPinigai = 'pPinigai+%i', pPatirtis = 'pPatirtis+%i' WHERE `vardas` = '%s'", EMIGRACIJOS_LT,EMIGRACIJOS_XP, swxName ) ;
	        mysql_query ( Query ) ;
	        SuccessMSG ( playerid , "Žaidėjas sėkmingai emigruotas!");
	    }
	}
	return 1;
}

[Virsenas]

Ką mysql log'as sako ?

[Dedman]

[00:07:26] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `vardas` = 'Jeff_Jon') - Successfully executed.

[00:07:26] >> mysql_store_result( Connection handle: 1 )

[00:07:26] CMySQLHandler::StoreResult() - Result was stored.

[00:07:26] >> mysql_retrieve_row( Connection handle: 1 )

[00:07:26] >> mysql_num_rows( Connection handle: 1 )

[00:07:26] CMySQLHandler::NumRows() - Returned 1 row(s)

[00:07:26] >> mysql_fetch_field_row( Connection handle: 1 )

[00:07:26] CMySQLHandler::FetchField("Emigruotas") - 0

[00:07:26] >> mysql_query( Connection handle: 1 )

[00:07:26] CMySQLHandler::Query(UPDATE `zaidejai` SET Emigruotas = '1', pPinigai = 'pPinigai+10000', pPatirtis = 'pPatirtis+2500' WHERE `vardas` = 'Jeff_Jon) - 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 ''Jeff_Jon' at line 1)

[00:07:27] >> mysql_query( Connection handle: 1 )

[Virsenas]

Padidink Query dydį, tikriausiai neužtenka atminties.