Nesaugo skin'o.

[Marshall]

stock savePlayerData ( playerid ) 
{
	new
		query [ 1000 ] ,
		Float:epos [ 3 ] 
	;
	GetPlayerPos ( playerid, epos [ 0 ] , epos [ 1 ] , epos [ 2 ] ) ;
	format ( query , 256 , "UPDATE `zaidejai` SET X = '%f', Y = '%f', Z = '%f' WHERE Vardas = '%s'",epos [ 0 ] , epos [ 1 ] , epos [ 2 ] , PlayerName ( pid ) ) ;
	mysql_query ( query ) ;
	/* Žaidėjo informacijos saugojimas */
	playerDB [ playerid ] [ Pinigai ] = GetPlayerMoney( pid ) ;
	playerDB [ playerid ] [ Patirtis ] = GetPlayerScore( pid ) ;
	playerDB[ pid ][ skin ] = GetPlayerSkin( playerid ) ;
	format ( query , 1000 , "UPDATE `zaidejai` SET Patirtis = '%i', Pinigai = '%i', vip = '%i', admin ='%i', lytis = '%i', skin = '%i', NamoID = '%d' WHERE Vardas = '%s'",\
	playerDB [ playerid ] [ Patirtis ] , 
	playerDB [ playerid ] [ Pinigai ],
	playerDB[ pid ][ vip ] ,
	playerDB[ pid ][ admin ],
	playerDB[ playerid ][ lytis ],
	playerDB[ pid ][ skin ],
	playerDB[ pid ][ NamoID ] ,
	PlayerName ( playerid ) ) ; 
	mysql_query ( query ) ;

	printf ( "[ SAVE ] Žaidėjas %s išsaugomas", PlayerName ( pid) ) ;
}

stock loadPlayerData ( playerid ) 
{
	new query [ 256 ] , fetch [ 16 ] , Float:epos [ 3 ] ;
	format ( query , 256 , "SELECT * FROM `zaidejai` WHERE Vardas = '%s'",PlayerName ( pid ) ) ;
	mysql_query ( query ) ;
	mysql_store_result ( );
	mysql_retrieve_row ( ) ;
	//--
	mysql_fetch_field_row ( fetch , "X" ) ; 	epos [ 0 ] = floatstr ( fetch ) ;
	mysql_fetch_field_row ( fetch , "Y" ) ; 	epos [ 1 ] = floatstr ( fetch ) ;
	mysql_fetch_field_row ( fetch , "Z" ) ;		epos [ 2 ] = floatstr ( fetch ) ;
	SetPlayerPos( pid , epos [ 0 ] , epos [ 1 ] , epos [ 2 ] ) ; 
	//--
	mysql_fetch_field_row ( fetch , "Pinigai" ) ; 		playerDB [ playerid ] [ Pinigai ] = strval ( fetch ) ; 		GivePlayerMoney( pid , playerDB [ playerid ] [ Pinigai ] ) ;
	mysql_fetch_field_row ( fetch , "Patirtis" ) ;		playerDB [ playerid ] [ Patirtis ] = strval ( fetch ) ; 	SetPlayerScore( pid , playerDB [ playerid ] [ Patirtis ] ) ;
	mysql_fetch_field_row ( fetch , "admin" ) ;			playerDB [ playerid ] [ admin ] = strval ( fetch ) ; 
	mysql_fetch_field_row ( fetch , "vip" ) ;			playerDB [ playerid ] [ vip ] = strval ( fetch ) ;		
	mysql_fetch_field_row ( fetch , "lytis" ) ;			playerDB [ playerid ] [ vip ] = strval ( fetch ) ;			
	mysql_fetch_field_row ( fetch , "skin" ) ;			playerDB [ playerid ] [ vip ] = strval ( fetch ) ;			SetPlayerSkin( playerid, playerDB[ playerid ][ skin ] ) ;
	mysql_fetch_field_row ( fetch , "NamoID" ) ;		playerDB [ playerid ] [ NamoID ] = strval ( fetch ) ;			

	printf( "[ LOAD ] Žaidėjas %s užkrautas" ) ;			
}

mySQL lentelėje

[Spirit]

	mysql_fetch_field_row ( fetch , "vip" ) ;			playerDB [ playerid ] [ vip ] = strval ( fetch ) ;		
	mysql_fetch_field_row ( fetch , "lytis" ) ;		//Klaida ir cia	playerDB [ playerid ] [ vip ] = strval ( fetch ) ;			
	mysql_fetch_field_row ( fetch , "skin" ) ;			playerDB[ playerid ][ skin ] = strval ( fetch ));

Zioplos klaidos..

 

    format ( query , 1000 , "UPDATE `zaidejai` SET Patirtis = '%i', Pinigai = '%i', vip = '%i', admin ='%i', lytis = '%i', skin = '%i', NamoID = '%d' WHERE Vardas = '%s'",\

    playerDB [ playerid ] [ Patirtis ] ,

    playerDB [ playerid ] [ Pinigai ],

    playerDB[ pid ][ vip ] ,

    playerDB[ pid ][ admin ],

    playerDB[ playerid ][ lytis ],

    playerDB[ playerid ][ skin ],

Redaguota Liepos 12, 2014, nario Spirit

[Marshall]

	mysql_fetch_field_row ( fetch , "vip" ) ;			playerDB [ playerid ] [ vip ] = strval ( fetch ) ;		
	mysql_fetch_field_row ( fetch , "lytis" ) ;		//Klaida ir cia	playerDB [ playerid ] [ vip ] = strval ( fetch ) ;			
	mysql_fetch_field_row ( fetch , "skin" ) ;			playerDB[ playerid ][ skin ] = strval ( fetch ));

Zioplos klaidos..

 

    format ( query , 1000 , "UPDATE `zaidejai` SET Patirtis = '%i', Pinigai = '%i', vip = '%i', admin ='%i', lytis = '%i', skin = '%i', NamoID = '%d' WHERE Vardas = '%s'",\

    playerDB [ playerid ] [ Patirtis ] ,

    playerDB [ playerid ] [ Pinigai ],

    playerDB[ pid ][ vip ] ,

    playerDB[ pid ][ admin ],

    playerDB[ playerid ][ lytis ],

    playerDB[ playerid ][ skin ],

 

lol durnelis AČIŪ labai.