Launcher Beispiel

//---------------------------------konfiguration---------------------------------
#define SQL_HOST                "HOSTNAME"
#define SQL_USER                "NAME"
#define SQL_PASSWORD            "PASSWORT"
#define SQL_DB                  "DATENBANK"
//------------------------------------------------------------------------------


#include <a_samp>
#include <mysql>


new MySQL:sql_init;

new buffer[256];
new spieler;
new admins;
public OnFilterScriptInit()
{
        sql_init = mysql_init(1);
        new sql_handle = mysql_connect(SQL_HOST, SQL_USER, SQL_PASSWORD, SQL_DB, sql_init, .auto_reconnect=1);
        if (sql_handle)
        {
                printf("[Launcher] Erfolgreich");
                mysql_query("create table if not exists online(typ varchar(6) not null,anzahl, INT default 0);");
                if (mysql_query("SELECT * FROM `online` WHERE 1")) mysql_ping();
                mysql_store_result();
                if (mysql_num_rows() == 0)
                {
                        mysql_query("insert into online (typ, anzahl) values('spieler','0');");
                        mysql_query("insert into online (typ, anzahl) values('admins','0');");
                }
                mysql_free_result();

                spieler = 0;
                admins = 0;
        } else {
                printf("[Launcher] ERROR");
                SendRconCommand("exit");
        }
        return 1;
}

public OnFilterScriptExit()
{
        format(buffer, sizeof(buffer), "UPDATE online SET anzahl='0' WHERE typ='admins';", admins);
        mysql_query(buffer);
        format(buffer, sizeof(buffer), "UPDATE online SET anzahl='0' WHERE typ='spieler';", spieler);
        mysql_query(buffer);
        return mysql_close(sql_init);
}

public OnPlayerConnect(playerid)
{
        spieler += 1;
        format(buffer, sizeof(buffer), "UPDATE online SET anzahl='%d' WHERE typ='spieler';", spieler);
        mysql_query(buffer);
        return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
        if(IsPlayerAdmin(playerid))
        {
            admins -= 1;
                format(buffer, sizeof(buffer), "UPDATE online SET anzahl='%d' WHERE typ='admins';", admins);
                mysql_query(buffer);
        }
        spieler -= 1;
        format(buffer, sizeof(buffer), "UPDATE online SET anzahl='%d' WHERE typ='spieler';", spieler);
        mysql_query(buffer);
        return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{   if(success)
        {
            admins += 1;
                format(buffer, sizeof(buffer), "UPDATE online SET anzahl='%d' WHERE typ='admins';", admins);
        mysql_query(buffer);
        }
        return 1;
}