Neįrašo į lentelę.

'ycin · Kovo 5, 2014

Sveiki pasiemiau Reno kodą ( rekordo siekimo ), pasidariau viską krč, pasidariau lentelę, Rekordas, o joje Rekordas( int ), nu va, kai įeinu į serverį nieko rašo tik, kad rekordas pasiektas : 1 blablabla, o jeigu iš naujo einu tai same shit, tai kaip padaryt kad įeitų į lentelę? Kodas

enum _srInfo
{
	zRekordas
};
new srInfo [_srInfo];

public OnPlayerConnect(playerid)
{
	new str [ 80 ];
 	mysql_query ( "SELECT rekordas FROM rekordas" ) ;
  	mysql_store_result ( ) ;
  	mysql_retrieve_row ( ) ;

	srInfo [ zRekordas ] = mysql_fetch_int ( ) ;

	if( GetPlayersOnline ( ) > srInfo [ zRekordas ] )
 	{
  	format ( str , 80 , "Pasiektas naujas rekordas: %i žaidėjai (ų)",srInfo [ zRekordas ] ) ;
   	SendClientMessageToAll ( -1,str ) ;
  	}
	mysql_free_result ( ) ;
	
	return 1;
}

stock UpdateRecord ( )
{
        new
                Query [ 80 ]
        ;
        format ( Query, sizeof(Query), "UPDATE `rekordas` rekordas = '%i'",srInfo [ zRekordas ] ) ;
        mysql_query ( Query ) ;

        printf("[ SAVED RECORD ]: %i ",srInfo [ zRekordas ] ) ;
}

stock GetPlayersOnline ( )
{
        new pOnline;
        for ( new i = 0; i < MAX_PLAYERS; i ++ )
        {
                if(IsPlayerConnected( i ) )
                                pOnline++;
                printf("[ PLAYERS ONLINE ]: %i",pOnline ) ;
        }
        return pOnline;
}

bebras · Kovo 5, 2014

MySQL log parodyk.

'ycin · Kovo 5, 2014

[17:16:44] MySQL Debugging activated (03/05/14)

[17:16:44] ---------------------------

[17:16:44]

[17:16:44] >> mysql_connect( )

[17:16:44] CMySQLHandler::CMySQLHandler() - constructor called.

[17:16:44] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "serveris" | Username: "root" ...

[17:16:44] CMySQLHandler::Connect() - Connection was successful.

[17:16:44] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:16:44] >> mysql_ping( Connection handle: 1 )

[17:16:44] CMySQLHandler::Ping() - Connection is still alive.

[17:17:08] >> mysql_query( Connection handle: 1 )

[17:17:08] CMySQLHandler::Query(SELECT rekordas FROM rekordas) - Successfully executed.

[17:17:08] >> mysql_store_result( Connection handle: 1 )

[17:17:08] CMySQLHandler::StoreResult() - Result was stored.

[17:17:08] >> mysql_retrieve_row( Connection handle: 1 )

[17:17:08] >> mysql_fetch_int( Connection handle: 1 )

[17:17:08] >> mysql_free_result( Connection handle: 1 )

[17:17:08] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:17:08] >> mysql_query( Connection handle: 1 )

[17:17:08] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Kevin_Cortez') - Successfully executed.

[17:17:08] >> mysql_store_result( Connection handle: 1 )

[17:17:08] CMySQLHandler::StoreResult() - Result was stored.

[17:17:08] >> mysql_num_rows( Connection handle: 1 )

[17:17:08] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:17:08] >> mysql_free_result( Connection handle: 1 )

[17:17:08] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:17:09] >> mysql_real_escape_string( Connection handle: 1 )

[17:17:09] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.

[17:17:09] >> mysql_query( Connection handle: 1 )

[17:17:09] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Kevin_Cortez' AND slaptazodis = '123') - Successfully executed.

[17:17:09] >> mysql_store_result( Connection handle: 1 )

[17:17:09] CMySQLHandler::StoreResult() - Result was stored.

[17:17:09] >> mysql_num_rows( Connection handle: 1 )

[17:17:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:17:10] >> mysql_query( Connection handle: 1 )

[17:17:10] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Kevin_Cortez') - Successfully executed.

[17:17:10] >> mysql_store_result( Connection handle: 1 )

[17:17:10] CMySQLHandler::StoreResult() - Result was stored.

[17:17:10] >> mysql_retrieve_row( Connection handle: 1 )