Thread: Storing data
View Single Post
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 01-31-2020 , 17:35   Re: Storing data
Reply With Quote #10

Can do something like this:
PHP Code:
#define MAX_USER_SKINS 1024 //let's say user can have max 1024 skins

enum SkinData
{
    
SkinID,
    
bool:IsStattrak,
    
SkinLevel
}

new 
g_sdPlayerSkinsMAX_PLAYERS ][ MAX_USER_SKINS ][ SkinData ];

public 
QueryHandleFailState Handle:Query , const Error[] , Errcode , const Data] , DataSize )
{
    new 
id Data]
    new 
0;
    
    while( ( 
MAX_USER_SKINS ) && SQL_MoreResultsQuery ) ) 
    {
        
g_sdPlayerSkinsid ][ ][ SkinID ] = SQL_ReadResultQuery );
        
g_sdPlayerSkinsid ][ ][ IsStattrak ] = bool:SQL_ReadResultQuery );
        
g_sdPlayerSkinsid ][ ][ SkinLevel ] = SQL_ReadResultQuery );
        
i++;
    } 


__________________

Last edited by Bugsy; 01-31-2020 at 17:36.
Bugsy is offline