/* Includes */
#include <a_samp>
#include <a_mysql>
#include <sscanf2>

/* dCMD */
#define dcmd(%1,%2,%3) if ((strcmp((%3)[1], #%1, true, (%2)) == 0) && ((((%3)[(%2) + 1] == 0) && (dcmd_%1(playerid, "")))||(((%3)[(%2) + 1] == 32) && (dcmd_%1(playerid, (%3)[(%2) + 2]))))) return 1

/* MySQL */
#define SQL_HOST        "127.0.0.1"
#define SQL_USER        "root"
#define SQL_PASS        "123456"
#define SQL_DATA        "samp"

new MySQL;

/* Farben */
#define FARBE_SMARAGD 0xFFBFDB69

/* Forwards */
forward OnLanguageMsg(playerid);

public OnFilterScriptInit()
{
    print("\n**********************************");
    print("* LanguageBasis wurde geladen.   *");
    print("* @Autor:  Azcaq                 *");
    print("* @Skype:  Azcaaq                *");
    print("**********************************\n");

    MySQL_Connect();
    return 1;
}

public OnFilterScriptExit()
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[]) {
    dcmd(text, 4, cmdtext);
    return 1;
}

dcmd_text(playerid, params[]) {
    new language[8], text[128];
    if(sscanf(params, "s[8]s[128]", language, text)) return Usage(playerid, "/text [Sprache] [Text]");
    SendLanguageMsg(playerid, language, text);
    return 1;
}

stock Usage(playerid, text[]) {
    new string[256];
    format(string, sizeof(string), "Benutze: {CCE874}%s", text);
    return SendClientMessage(playerid, FARBE_SMARAGD, string);
}

stock SendLanguageMsg(playerid, language[], text[]) {
    new Query[128];
    mysql_format(MySQL, Query, sizeof(Query), "SELECT `Result` FROM `Texts` WHERE `Text` = '%s' AND `Language` = '%s'", text, language);
    mysql_function_query(MySQL, Query, true, "OnLanguageMsg", "d", playerid);
    return 1;
}

public OnLanguageMsg(playerid) {
    new rows, fields;
    cache_get_data(rows, fields);
    if(rows) {
        new string[128];
        cache_get_field_content(0, "Result", string);
        format(string, sizeof(string), "%s", string);
        SendClientMessage(playerid, 0xFFFFFFFF, string);
    }
    return 1;
}

stock MySQL_Connect() {
    MySQL = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(!mysql_errno()) {
        print("[MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt.");
    } else {
        print("[MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden.");
        print("[MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen...");
        MySQL = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
        if(!mysql_errno()) {
            print("[MYSQL] Es konnte im 2. Versuch eine Verbindung hergestellt werden.");
        } else {
            print("[MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden.");
            print("[MYSQL] Der Server wird nun beendet.");
            SendRconCommand("exit");
        }
    }
    return true;
}