Skin System (MySQL) | By iRaiDeN

#include    < a_samp >
#include    < a_mysql >
#include    < mSelection >
#include    < cpstream >

#define DB_SERVER   "127.0.0.1"
#define DB_USER		"root"
#define DB_PASS     ""
#define DB_DB       "samp"

new
	dbHandle ,
	pName [ MAX_PLAYERS ] [ 24 ] ,
	pSkinID [ MAX_PLAYERS ] ,
	gQuery [ 256 ] ,
	CP ,
	skinlist = mS_INVALID_LISTID ;

public OnGameModeInit ( )
{
	dbHandle = mysql_connect ( DB_SERVER , DB_USER , DB_DB , DB_PASS ) ;
	CP = CPS_AddCheckpoint ( 1433.6328,2622.6990,11.3926 , 2.5 , 100 ) ;
	skinlist = LoadModelSelectionMenu("skins.txt");
}

public OnPlayerConnect ( playerid )
{
	GetPlayerName ( playerid , pName [ playerid ] , 24 ) ;
	format ( gQuery , 256 , "SELECT skinid FROM skin WHERE username='%s'" , pName [ playerid ] ) ;
	mysql_function_query ( dbHandle , gQuery , 128 , "getPlayerData" , "i" , playerid ) ;
	return 1 ;
}

public OnPlayerEnterCheckpoint ( playerid )
{
    if ( CPS_IsPlayerInCheckpoint ( playerid , CP ) )
		return  ShowModelSelectionMenu ( playerid , skinlist , "Select Skin" ) ;
	return 1 ;
}

public OnPlayerModelSelection(playerid, response, listid, modelid)
{
	if ( listid == skinlist )
	{
	    if ( response )
	    {
		    SendClientMessage ( playerid , 0xFF0000FF , "Skin Changed" ) ;
		    pSkinID [ playerid ] = modelid ;
		    format ( gQuery , 256 , "INSERT INTO skin (username,skinid) VALUES (%i,%s) " , pSkinID [ playerid ] , pName [ playerid ] ) ;

	    	SetPlayerSkin ( playerid , modelid ) ;
	    }
	    else SendClientMessage ( playerid , 0xFF0000FF , "Canceled skin selection" ) ;
    	return 1;
	}
	return 1;
}

public OnPlayerDisconnect ( playerid , reason )
	return savePlayerData ( playerid ) ;

public OnPlayerSpawn ( playerid )
	return SetPlayerSkin ( playerid , pSkinID [ playerid ] ) ;

forward getPlayerData ( playerid ) ;
public getPlayerData ( playerid )
{
	pSkinID [ playerid ] = cache_get_field_content_int ( 0 , "skinid" , dbHandle ) ;
	return 1 ;
}

forward savePlayerData ( playerid ) ;
public savePlayerData ( playerid )
{
	format ( gQuery , 256 , "UPDATE skin SET skinid='%i'" , pSkinID [ playerid ] ) ;
	mysql_function_query ( dbHandle , gQuery , 256 , "" , "" ) ;
	return 1 ;
}