View Single Post
Striker black
Member
Join Date: Apr 2013
Old 11-12-2017 , 20:28   Re: [L4D2] Gifts Drop & Spawn
Reply With Quote #5

The plugin shows the gifts but still does not show advertisement and no sounds are heard

#define PLUGIN_VERSION "1.3.2"
#define TAG_GIFT "{G}[{L}GIFTS{G}]\x01"
#define SND_REWARD1 "level/loud/climber.wav"
#define SND_REWARD2 "level/gnomeftw.wav"

The version 1.3.3 is already released?

The plugin can work without the need for database?

PHP Code:
#define DATABASE_CONFIG     "l4dstats"




public OnConfigsExecuted()
{
    
GetCvars();
    
    if (!
ConnectDB())
    {
        
LogError("Connecting to database failed. Read error log for further details.");
    }
}

bool:ConnectDB()
{
    if (
db != INVALID_HANDLE)
        return 
true;

    if (
SQL_CheckConfig(DATABASE_CONFIG))
    {
        new 
String:Error[256];
        
db SQL_Connect(DATABASE_CONFIGtrueErrorsizeof(Error));

        if (
db == INVALID_HANDLE)
        {
            
LogError("Failed to connect to database: %s"Error);
            return 
false;
        }

        if (!
CheckDatabaseValidity())
        {
            
LogError("Database is missing required table or tables.");
            return 
false;
        }
    }
    else
    {
        
LogError("Databases.cfg missing '%s' entry!"DATABASE_CONFIG);
        return 
false;
    }

    return 
true;
}

bool:CheckDatabaseValidity()
{
    if (!
SQL_FastQuery(db"SELECT * FROM players WHERE 1 = 2"))
    {
        return 
false;
    }

    return 
true;

_____________________________________________ ______________________


Last edited by Striker black; 11-12-2017 at 21:50.
Striker black is offline