ProjectGodMode.com

Code: Select all

SimpleSQLMySQLConnect( HostName[ ], UserName[ ], Password[ ], DataBase[ ] ) // Use this if you have a remote database
SimpleSQLSQLiteConnect( DataBase[ ] ) // Use this if you want to use a local database
SimpleSQLDisconnect( ) // Is not really required but is good if you use MySQL or SQLite only a few minutes per map
SimpleSQLQuery( Query[ ], Index, Data[ ] ) // Does the query. Set Index as zero for queries that are not including SELECT word

Code: Select all

0 -> SimpleSQLBad
1 -> SimpleSQLGood

Code: Select all

// Project headers
#include < amxmodx >
#include < SimpleSQL >

// Do not define null values
#define QUERY_MAP_START    8192

// Global variables
new gData[ SimpleSQLBufferSize ];
new gQuery[ SimpleSQLBufferSize ];

// When map starts
public plugin_init( )
{
    // Try connecting
    // Stop everything if connection fails
    // This is not a very common happening
    if( !SimpleSQLSQLiteConnect( "Database" ) )
        return;

    // Try to create the table
    // The second parameter is null, we are not requiring things from this query
    // The third parameter should be used even if it is empty
    SimpleSQLQuery( "CREATE TABLE IF NOT EXISTS Maps ( Name TEXT, Time NUMERIC )", 0, gData );

    // Insert current map name and current unix epoch time stamp into the table we created
    new Map[ 32 ];
    get_mapname( Map, sizeof Map - 1 );
    formatex( gQuery, sizeof gQuery - 1, "INSERT INTO Maps VALUES ( '%s', %d )", Map, get_systime( ) );
    SimpleSQLQuery( gQuery, 0, gData );

    // Print the names of all maps we played since database exists
    // Let's try to assign a value to gData
    // The second parameter is QUERY_MAP_START so we'll know that this is the query into function SimpleSQLFunction
    formatex( gData, sizeof gData - 1, "The maps we played since database exists." );
    SimpleSQLQuery( "SELECT Name FROM Maps", QUERY_MAP_START, gData );
}

// Our queries handler
// This should be defined in all of your plugins that use SimpleSQL
// In this function, you could use SimpleSQLQuery to update, delete, create or even select
public SimpleSQLFunction( Query, Index, Data[ ] )
{
    // Get the query first
    static Handle: pQuery;
    pQuery = Handle: Query;

    // Switch between queries
    switch( Index )
    {
        case QUERY_MAP_START:
        {
            // This is the query with index QUERY_MAP_START
            // Data will be "The maps we played since database exists."
            // Retrieve the map names
            static Name[ 32 ];

            while( SQL_MoreResults( pQuery ) )
            {
                SQL_ReadResult( pQuery, 0, Name, sizeof Name - 1 );

                server_print( "We played %s since database exists!", Name );

                // For functions like SQL_NextRow you have to check SQLX INC file
                SQL_NextRow( pQuery );
            }
        }
    }
}

// Our query errors handler
// This should be defined in all of your plugins that use SimpleSQL
public SimpleSQLErrorFunction( Error[ ] )
{
    log_amx( Error );
}