problem mit mein selfmade

#include <a_samp>
#include <a_mysql>
#include <md5>

//MYSL DATEN
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_DATA "selfmade"
#define MYSQL_PASS ""
new Handle;

enum playerInfo{
     db_id,
     pEingeloggt,
     pNeuling,
     pAlter,
     pGeschlecht,
     pSkin,
     Float:pRussi,
     Float:pLeben
};
new pInfo[MAX_PLAYERS][playerInfo];

//DIALOGE
#define DIALOG_REGISTER 1
#define DIALOG_CHAR1 2
#define DIALOG_CHAR2 3
#define DIALOG_CHAR3 4
#define DIALOG_LOGIN 5
#define DIALOG_LOGINT 6

//Farben
#define geld 0xFFFF00FF
#define weiss 0xFFFFFFFF

//news
new Logintest[MAX_PLAYERS];


main()
{
    print("\n----------------------------------");
    print(" selfmade by kevin");
    print("----------------------------------\n");
}



public OnGameModeInit()
{

    SetGameModeText("Selfmade v0,0,0");

    //MYSQL Verbindung
    Handle=mysql_connect (MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    if (mysql_errno() <1) print ("MYSQL: Die Verbindung war erfolgreich!"),
    mysql_log (LOG_ALL);else print ("MYSQL: Die Verbindung konnte nicht hergestellt werden! | Server wirt herundergefahren!"),
    SendRconCommand ("exit");
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetSpawnInfo(playerid,0,0,0,0,0,0,0,0,0,0,0,0);
    SpawnPlayer(playerid);
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query [256];
    mysql_format (Handle, query, sizeof (query), "SELECT * FROM user WHERE Username='%e'",Spielername(playerid));
    mysql_tquery(Handle,query,"UserCheck","i",playerid);
    ClearChat(playerid);
    TogglePlayerSpectating(playerid,1);
    //news auf 0
    Logintest[playerid]=0;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SpielerSpeichern(playerid);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    SetPlayerVirtualWorld(playerid,0);
    SetCameraBehindPlayer(playerid);
    TogglePlayerControllable(playerid,1);
    if(pInfo[playerid][pNeuling]==1)
    {
        ClearChat(playerid);
        SendClientMessage(playerid,geld,"Herzlich Willkommen!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        pInfo[playerid][pNeuling]=0;
        pInfo[playerid][pLeben]=100;
        if(pInfo[playerid][pGeschlecht]==1)
        {
            SetPlayerSkin(playerid,60);
        }
        else
        {
            SetPlayerSkin(playerid,40);
          }
          GameTextForPlayer(playerid,"~y~Wilkommen ~n~auf ~n~Den besten ~g~Sever",6000,4);
          SpielerSpeichern(playerid);
    }
    else
    {
        SendClientMessage(playerid,geld,"Willkommen Zurück!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        if(pInfo[playerid][pGeschlecht]==1)
        {
            SetPlayerSkin(playerid,60);
        }
        else
        {
            SetPlayerSkin(playerid,40);
          }
    }
    SetPlayerColor(playerid,0xF3F3F3FF);
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{

    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    //mysql dialogen
    if(dialogid == DIALOG_REGISTER)
    {
        if(!response)return Kick(playerid);
        SetPVarString(playerid,"passwortvar",inputtext);
        if(strlen(inputtext) >=4)
        {
            ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich");
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    if(dialogid == DIALOG_CHAR1)
    {
        if(response)
        {
            //männ
            pInfo[playerid][pGeschlecht]=1;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }
        else
        {
            //weib
            pInfo[playerid][pGeschlecht]=2;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }

    }
    if(dialogid == DIALOG_CHAR2)
    {
        if(response)
        {
            if(listitem==0)
            {
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
            }
            if(listitem==1)
            {
                Kick(playerid);
            }
             if(listitem==2)
            {
                Kick(playerid);
            }
             if(listitem==3)
            {
               ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid == DIALOG_CHAR3)
    {
        if(response)
        {
            if(IsNummeric(inputtext))
            {
                //new alterabfrage=strval(inputtext);
                if(strval(inputtext)>=18 && strval(inputtext) <=48)
                {
                    pInfo[playerid][pAlter]=strval(inputtext);
                    pInfo[playerid][pEingeloggt]=1;
                    pInfo[playerid][pNeuling]=1;
                    new query [256],passworteingabe[128];
                    GetPVarString(playerid,"passwortvar",passworteingabe,128);
                    mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
                    mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
                    printf("%s",query);
                }
                else
                {
                  ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
                }
            }
            else
            {
                ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid  == DIALOG_LOGIN)
    {
        if(!response)return Kick(playerid);
        new query[256];
        mysql_format(Handle,query,sizeof(query),"SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
        mysql_tquery(Handle,query,"OnPassordResponse","i",playerid);
        return 1;
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

//OnPlayerRegister
forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    pInfo[playerid][db_id]=cache_insert_id(Handle);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayer(playerid);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//User-Check
forward UserCheck(playerid);
public UserCheck(playerid)
{
    new num_rows, num_fields;
    cache_get_data(num_rows,num_fields,Handle);
    SetPlayerVirtualWorld(playerid,1);
    if(num_rows == 0)
    {
        //reg
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    else
    {
        //log
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"{00FFFA}Einloggen","{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    return 1;
}

//für login
forward OnPasswordResponse(playerid);
public OnPasswordResponse(playerid)
{
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields);
    if(num_rows==0)
    {
        //Passwort Falsch
        Logintest[playerid]+=1;
        new string [250];
        format(string,sizeof(string),"{00FFFA}Einloggen {FF0005}[%d/3]",Logintest[playerid]);
        if(Logintest[playerid]>=3)
        {
            ShowPlayerDialog(playerid,DIALOG_LOGINT,DIALOG_STYLE_MSGBOX,"{FF0005}Fehler","{FF0005}Maximale {FFFFFF}Versuche verbraucht sie werden aus sicherheits gründen  von Server entfernt!","{FF0005}Okay","");
            return SetTimerEx("KickHackInfo",1000,false,"i",playerid);
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    else
    {
        //Passwort Richtig
        SendClientMessage(playerid,geld,"Erfolgreich Eingeloggt");
        LoadAccount(playerid);

    }
    return 1;
}

//LoadAccount
stock LoadAccount(playerid)
{
    pInfo[playerid][db_id]=cache_get_field_content_int(0,"ID",Handle);
    pInfo[playerid][pEingeloggt]=1;
    pInfo[playerid][pAlter]=cache_get_field_content_int(0,"Alter",Handle);
    pInfo[playerid][pGeschlecht]=cache_get_field_content_int(0,"Geschlecht",Handle);
    pInfo[playerid][pSkin]=cache_get_field_content_int(0,"Skin",Handle);
    pInfo[playerid][pNeuling]=cache_get_field_content_int(0,"Neuling",Handle);

    pInfo[playerid][pLeben]=cache_get_field_content_float(0,"Leben",Handle);
    pInfo[playerid][pRussi]=cache_get_field_content_float(0,"Russi",Handle);

    SetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    SetPlayerArmour(playerid,pInfo[playerid][pRussi]);

    SpawnPlayer(playerid);
    TogglePlayerSpectating(playerid,0);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//SpielerSpeichern
stock SpielerSpeichern(playerid)
{
    if(pInfo[playerid][pEingeloggt]!=1)return 1;
    if(IsPlayerNPC(playerid))return 1;
    GetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    GetPlayerArmour(playerid,pInfo[playerid][pRussi]);
    new query[256];
    mysql_format(Handle,query,sizeof (query),"Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'",GetPlayerSkin(playerid),
    pInfo[playerid][pAlter],    pInfo[playerid][pGeschlecht],pInfo[playerid][pNeuling],pInfo[playerid][pLeben],pInfo[playerid][pRussi],pInfo[playerid][db_id]);
    mysql_pquery(Handle,query,"","");
    printf("%s",query);
    pInfo[playerid][pEingeloggt]=0;
    return 1;
}

//KickHackInfo
forward KickHackInfo(playerid);
public KickHackInfo(playerid)
{
    return Kick(playerid);
}

//Spielername
stock Spielername(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}
//Clear-Chat

stock ClearChat(playerid)
{

    for(new i = 0;i<100;i++)
    {
        SendClientMessage(playerid,weiss,"");
    }
    return 1;
}
//IsNummeric
stock IsNummeric(string[])
{
    for(new i=0,j=strlen(string);i<j;i++)
    {
        if((string[i] > '9' || string[i] < '0'))return 0;
    }
    return 1;
}

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[10:28:39] 
[10:28:39] Server Plugins
[10:28:39] --------------
[10:28:39]  Loading plugin: streamer
[10:28:39] 

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[10:28:39]   Loaded.
[10:28:39]  Loading plugin: mysql
[10:28:39]  >> plugin.mysql: R39-3 successfully loaded.
[10:28:39]   Loaded.
[10:28:39]  Loaded 2 plugins.

[10:28:39] 
[10:28:39] Filterscripts
[10:28:39] ---------------
[10:28:39]   Loading filterscript 'samplife-mapps.amx'...
[10:28:39] Server Objecte werden geladen
[10:28:39] 0 Gemappte Objecte Geladen
[10:28:39]   Loaded 1 filterscripts.

[10:28:39] MYSQL: Die Verbindung war erfolgreich!
[10:28:39] 
----------------------------------
[10:28:39]  selfmade by kevin
[10:28:39] ----------------------------------

[10:28:39] Number of vehicle models: 0
[10:29:01] [connection] 127.0.0.1:54451 requests connection cookie.
[10:29:02] [connection] incoming connection: 127.0.0.1:54451 id: 0
[10:29:02] [join] ShadowKev1999 has joined the server (0:127.0.0.1)
[10:29:36] SELECT * FROM user WHERE Username='ShadowKev1999'AND Passwort=MD5('20')
[10:29:36] Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neuling`='0',`Leben`='0',`Russi`='0' WHERE `ID`='0'
[10:29:47] [part] ShadowKev1999 has left the server (0:1)
Console input: gmx
[11:14:18] MYSQL: Die Verbindung war erfolgreich!
[11:14:18] 
----------------------------------
[11:14:18]  selfmade by kevin
[11:14:18] ----------------------------------

[11:14:18] Number of vehicle models: 0
[11:14:34] [connection] 127.0.0.1:60783 requests connection cookie.
[11:14:35] [connection] incoming connection: 127.0.0.1:60783 id: 0
[11:14:35] [join] ShadowKev1999 has joined the server (0:127.0.0.1)
[11:14:54] INSERT * FROM user (Username, Passwort) VALUES ('ShadowKev1999',MD5('kevin7372'))
[11:15:00] Update `user` Set `Skin`='0',`Alter`='20',`Geschlecht`='1',`Neuling`='1',`Leben`='0',`Russi`='0' WHERE `ID`='0'
[11:15:00] [part] ShadowKev1999 has left the server (0:1)

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[10:54:25] 
[10:54:25] Server Plugins
[10:54:25] --------------
[10:54:25]  Loading plugin: streamer
[10:54:26] 

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[10:54:26]   Loaded.
[10:54:26]  Loading plugin: mysql
[10:54:26]  >> plugin.mysql: R39-3 successfully loaded.
[10:54:26]   Loaded.
[10:54:26]  Loaded 2 plugins.

[10:54:26] 
[10:54:26] Filterscripts
[10:54:26] ---------------
[10:54:26]   Loading filterscript 'samplife-mapps.amx'...
[10:54:26] Server Objecte werden geladen
[10:54:26] 0 Gemappte Objecte Geladen
[10:54:26]   Loaded 1 filterscripts.

[10:54:26] MYSQL: Die Verbindung war erfolgreich!
[10:54:26] 
----------------------------------
[10:54:26]  selfmade by kevin
[10:54:26] ----------------------------------

[10:54:26] Number of vehicle models: 0
[10:54:56] [connection] 127.0.0.1:58336 requests connection cookie.
[10:54:57] [connection] incoming connection: 127.0.0.1:58336 id: 0
[10:54:57] [join] kevin7372 has joined the server (0:127.0.0.1)
[10:55:17] INSERT INTO user (Username, Passwort) VALUES ('kevin7372',MD5('kevin7372'))
[10:55:18] Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neuling`='0',`Leben`='0',`Russi`='0' WHERE `ID`='0'
[10:55:43] [part] kevin7372 has left the server (0:1)
[10:55:56] [connection] 127.0.0.1:58337 requests connection cookie.
[10:55:57] [connection] incoming connection: 127.0.0.1:58337 id: 0
[10:55:57] [join] kevin7372 has joined the server (0:127.0.0.1)
[10:56:12] [part] kevin7372 has left the server (0:1)

[10:28:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:28:39] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:28:39] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:28:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:28:39] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:29:02] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[10:29:02] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i"
[10:29:02] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[10:29:02] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.612 milliseconds
[10:29:02] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:29:02] [DEBUG] Calling callback "UserCheck"..
[10:29:02] [DEBUG] cache_get_data - connection: 1
[10:29:02] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:29:36] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')"
[10:29:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'AND Passwort=MD", callback: "OnPlayerRegister", format: "i"
[10:29:36] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[10:29:36] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 0.481 milliseconds
[10:29:36] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:29:36] [DEBUG] Calling callback "OnPlayerRegister"..
[10:29:36] [DEBUG] cache_insert_id - connection: 1
[10:29:36] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:29:36] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[10:29:36] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)"
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.506 milliseconds
[10:29:36] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[11:14:18] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "selfmade", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[11:14:18] [DEBUG] CMySQLHandle::Create - creating new connection..
[11:14:18] [WARNING] CMySQLHandle::Create - connection already exists
[11:14:18] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:14:18] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:14:18] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:14:18] [DEBUG] mysql_errno - connection: 1
[11:14:18] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:14:18] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:14:18] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[11:14:18] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:14:18] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:14:18] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:14:18] [DEBUG] CMySQLConnection::Connect - connection was successful
[11:14:18] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:14:18] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[11:14:35] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[11:14:35] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i"
[11:14:35] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[11:14:35] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.625 milliseconds
[11:14:35] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[11:14:35] [DEBUG] Calling callback "UserCheck"..
[11:14:35] [DEBUG] cache_get_data - connection: 1
[11:14:35] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[11:14:54] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT * FROM user (Username, Passwort) VALUES ('%e',MD5('%e'))"
[11:14:54] [DEBUG] mysql_tquery - connection: 1, query: "INSERT * FROM user (Username, Passwort) VALUES ('ShadowKev1999',", callback: "OnPlayerRegister", format: "i"
[11:14:54] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[11:14:54] [ERROR] CMySQLQuery::Execute[OnPlayerRegister] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM user (Username, Passwort) VALUES ('ShadowKev1999',MD5('kevin7372'))' at line 1
[11:14:54] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - error will be triggered in OnQueryError
[11:15:00] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[11:15:00] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='0',`Alter`='20',`Geschlecht`='1',`Neul", callback: "(null)", format: "(null)"
[11:15:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[11:15:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.495 milliseconds
[11:15:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[10:54:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:54:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[10:54:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:54:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:54:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[10:54:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:54:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:54:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[10:54:57] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[10:54:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372'", callback: "UserCheck", format: "i"
[10:54:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[10:54:58] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 631.714 milliseconds
[10:54:58] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:54:58] [DEBUG] Calling callback "UserCheck"..
[10:54:58] [DEBUG] cache_get_data - connection: 1
[10:54:58] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:55:17] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))"
[10:55:17] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (Username, Passwort) VALUES ('kevin7372',MD5('k", callback: "OnPlayerRegister", format: "i"
[10:55:17] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[10:55:18] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 103.529 milliseconds
[10:55:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:55:18] [DEBUG] Calling callback "OnPlayerRegister"..
[10:55:18] [DEBUG] cache_insert_id - connection: 1
[10:55:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:55:18] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[10:55:18] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)"
[10:55:18] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[10:55:18] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 51.61 milliseconds
[10:55:18] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[10:55:57] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[10:55:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372'", callback: "UserCheck", format: "i"
[10:55:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[10:55:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.499 milliseconds
[10:55:57] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:55:57] [DEBUG] Calling callback "UserCheck"..
[10:55:57] [DEBUG] cache_get_data - connection: 1
[10:55:57] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[10:56:07] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * user FROM WHERE Username='%e'AND Passwort=MD5('%e')"
[10:56:07] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * user FROM WHERE Username='kevin7372'AND Passwort=MD5('k", callback: "OnPassordResponse", format: "i"
[10:56:07] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - starting query execution
[10:56:07] [ERROR] CMySQLQuery::Execute[OnPassordResponse] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user FROM WHERE Username='kevin7372'AND Passwort=MD5('kevi7372')' at line 1
[10:56:07] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - error will be triggered in OnQueryError

C:\Users\leck1\Desktop\selfmade\samp\gamemodes\selfmade.pwn(113) : warning 217: loose indentation
C:\Users\leck1\Desktop\selfmade\samp\gamemodes\selfmade.pwn(334) : warning 217: loose indentation
Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase

Header size:           2220 bytes
Code size:            12128 bytes
Data size:            49840 bytes
Stack/heap size:      16384 bytes; estimated max. usage=453 cells (1812 bytes)
Total requirements:   80572 bytes

2 Warnings.

#include <a_samp>
#include <a_mysql>
#include <md5>

//MYSL DATEN
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_DATA "selfmade"
#define MYSQL_PASS ""
new Handle;

enum playerInfo{
     db_id,
     pEingeloggt,
     pNeuling,
     pAlter,
     pGeschlecht,
     pSkin,
     Float:pRussi,
     Float:pLeben
};
new pInfo[MAX_PLAYERS][playerInfo];

//DIALOGE
#define DIALOG_REGISTER 1
#define DIALOG_CHAR1 2
#define DIALOG_CHAR2 3
#define DIALOG_CHAR3 4
#define DIALOG_LOGIN 5
#define DIALOG_LOGINT 6

//Farben
#define geld 0xFFFF00FF
#define weiss 0xFFFFFFFF

//news
new Logintest[MAX_PLAYERS];


main()
{
    print("\n----------------------------------");
    print(" selfmade by kevin");
    print("----------------------------------\n");
}



public OnGameModeInit()
{

    SetGameModeText("Selfmade v0,0,0");

    //MYSQL Verbindung
    Handle=mysql_connect (MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    if (mysql_errno() <1) print ("MYSQL: Die Verbindung war erfolgreich!"),
    mysql_log (LOG_ALL);else print ("MYSQL: Die Verbindung konnte nicht hergestellt werden! | Server wirt herundergefahren!"),
    SendRconCommand ("exit");
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetSpawnInfo(playerid,0,0,0,0,0,0,0,0,0,0,0,0);
    SpawnPlayer(playerid);
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query [256];
    mysql_format (Handle, query, sizeof (query), "SELECT * FROM user WHERE Username='%e'",Spielername(playerid));
    mysql_tquery(Handle,query,"UserCheck","i",playerid);
    ClearChat(playerid);
    TogglePlayerSpectating(playerid,1);
    //news auf 0
    Logintest[playerid]=0;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SpielerSpeichern(playerid);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    SetPlayerVirtualWorld(playerid,0);
    SetCameraBehindPlayer(playerid);
    TogglePlayerControllable(playerid,1);
    if(pInfo[playerid][pNeuling]==1)
    {
        ClearChat(playerid);
        SendClientMessage(playerid,geld,"Herzlich Willkommen!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        pInfo[playerid][pNeuling]=0;
        pInfo[playerid][pLeben]=100;
        if(pInfo[playerid][pGeschlecht]==1)
       {
           SetPlayerSkin(playerid,60);
       }
        else
    {
        SetPlayerSkin(playerid,40);
    }
        GameTextForPlayer(playerid,"~y~Wilkommen ~n~auf ~n~Den besten ~g~Sever",6000,4);
        SpielerSpeichern(playerid);
    }
    else
    {
        SendClientMessage(playerid,geld,"Willkommen Zurück!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        if(pInfo[playerid][pGeschlecht]==1)
        {
            SetPlayerSkin(playerid,60);
        }
        else
        {
            SetPlayerSkin(playerid,40);
        }
    }
    SetPlayerColor(playerid,0xF3F3F3FF);
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{

    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    //mysql dialogen
    if(dialogid == DIALOG_REGISTER)
    {
        if(!response)return Kick(playerid);
        SetPVarString(playerid,"passwortvar",inputtext);
        if(strlen(inputtext) >=4)
        {
            ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich");
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    if(dialogid == DIALOG_CHAR1)
    {
        if(response)
        {
            //männ
            pInfo[playerid][pGeschlecht]=1;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }
        else
        {
            //weib
            pInfo[playerid][pGeschlecht]=2;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }

    }
    if(dialogid == DIALOG_CHAR2)
    {
        if(response)
        {
            if(listitem==0)
            {
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
            }
            if(listitem==1)
            {
                Kick(playerid);
            }
            if(listitem==2)
            {
                Kick(playerid);
            }
            if(listitem==3)
            {
               ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid == DIALOG_CHAR3)
    {
        if(response)
        {
            if(IsNummeric(inputtext))
            {
                //new alterabfrage=strval(inputtext);
                if(strval(inputtext)>=18 && strval(inputtext) <=48)
                {
                    pInfo[playerid][pAlter]=strval(inputtext);
                    pInfo[playerid][pEingeloggt]=1;
                    pInfo[playerid][pNeuling]=1;
                    new query [256],passworteingabe[128];
                    GetPVarString(playerid,"passwortvar",passworteingabe,128);
                    mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
                    mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
                    printf("%s",query);
                }
                else
                {
                  ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
                }
            }
            else
            {
                ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid  == DIALOG_LOGIN)
    {
        if(!response)return Kick(playerid);
        new query[256];
        mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e'AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
        mysql_tquery(Handle,query,"OnPassordResponse","i",playerid);
        return 1;
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

//OnPlayerRegister
forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    pInfo[playerid][db_id]=cache_insert_id(Handle);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayer(playerid);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//User-Check
forward UserCheck(playerid);
public UserCheck(playerid)
{
    new num_rows, num_fields;
    cache_get_data(num_rows,num_fields,Handle);
    SetPlayerVirtualWorld(playerid,1);
    if(num_rows == 0)
    {
        //reg
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    else
    {
        //log
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"{00FFFA}Einloggen","{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    return 1;
}

//für login
forward OnPasswordResponse(playerid);
public OnPasswordResponse(playerid)
{
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields);
    if(num_rows==0)
    {
        //Passwort Falsch
        Logintest[playerid]+=1;
        new string [250];
        format(string,sizeof(string),"{00FFFA}Einloggen {FF0005}[%d/3]",Logintest[playerid]);
        if(Logintest[playerid]>=3)
        {
            ShowPlayerDialog(playerid,DIALOG_LOGINT,DIALOG_STYLE_MSGBOX,"{FF0005}Fehler","{FF0005}Maximale {FFFFFF}Versuche verbraucht sie werden aus sicherheits gründen  von Server entfernt!","{FF0005}Okay","");
            return SetTimerEx("KickHackInfo",1000,false,"i",playerid);
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    else
    {
        //Passwort Richtig
        SendClientMessage(playerid,geld,"Erfolgreich Eingeloggt");
        LoadAccount(playerid);

    }
    return 1;
}

//LoadAccount
stock LoadAccount(playerid)
{
    pInfo[playerid][db_id]=cache_get_field_content_int(0,"ID",Handle);
    pInfo[playerid][pEingeloggt]=1;
    pInfo[playerid][pAlter]=cache_get_field_content_int(0,"Alter",Handle);
    pInfo[playerid][pGeschlecht]=cache_get_field_content_int(0,"Geschlecht",Handle);
    pInfo[playerid][pSkin]=cache_get_field_content_int(0,"Skin",Handle);
    pInfo[playerid][pNeuling]=cache_get_field_content_int(0,"Neuling",Handle);

    pInfo[playerid][pLeben]=cache_get_field_content_float(0,"Leben",Handle);
    pInfo[playerid][pRussi]=cache_get_field_content_float(0,"Russi",Handle);

    SetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    SetPlayerArmour(playerid,pInfo[playerid][pRussi]);

    SpawnPlayer(playerid);
    TogglePlayerSpectating(playerid,0);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//SpielerSpeichern
stock SpielerSpeichern(playerid)
{
    if(pInfo[playerid][pEingeloggt]!=1)return 1;
    if(IsPlayerNPC(playerid))return 1;
    GetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    GetPlayerArmour(playerid,pInfo[playerid][pRussi]);
    new query[256];
    mysql_format(Handle,query,sizeof (query),"Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'",GetPlayerSkin(playerid),
    pInfo[playerid][pAlter],    pInfo[playerid][pGeschlecht],pInfo[playerid][pNeuling],pInfo[playerid][pLeben],pInfo[playerid][pRussi],pInfo[playerid][db_id]);
    mysql_pquery(Handle,query,"","");
    printf("%s",query);
    pInfo[playerid][pEingeloggt]=0;
    return 1;
}

//KickHackInfo
forward KickHackInfo(playerid);
public KickHackInfo(playerid)
{
    return Kick(playerid);
}

//Spielername
stock Spielername(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}
//Clear-Chat

stock ClearChat(playerid)
{

    for(new i = 0;i<100;i++)
    {
        SendClientMessage(playerid,weiss,"");
    }
    return 1;
}
//IsNummeric
stock IsNummeric(string[])
{
    for(new i=0,j=strlen(string);i<j;i++)
    {
        if((string[i] > '9' || string[i] < '0'))return 0;
    }
    return 1;
}

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[09:29:39] 
[09:29:39] Server Plugins
[09:29:39] --------------
[09:29:39]  Loading plugin: streamer
[09:29:39] 

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[09:29:39]   Loaded.
[09:29:39]  Loading plugin: mysql
[09:29:39]  >> plugin.mysql: R39-3 successfully loaded.
[09:29:39]   Loaded.
[09:29:39]  Loaded 2 plugins.

[09:29:40] 
[09:29:40] Filterscripts
[09:29:40] ---------------
[09:29:40]   Loading filterscript 'samplife-mapps.amx'...
[09:29:40] Server Objecte werden geladen
[09:29:40] 0 Gemappte Objecte Geladen
[09:29:40]   Loaded 1 filterscripts.

[09:29:40] MYSQL: Die Verbindung war erfolgreich!
[09:29:40] 
----------------------------------
[09:29:40]  selfmade by kevin
[09:29:40] ----------------------------------

[09:29:40] Number of vehicle models: 0
[09:30:58] [connection] 127.0.0.1:57876 requests connection cookie.
[09:30:59] [connection] incoming connection: 127.0.0.1:57876 id: 0
[09:30:59] [join] kevin7372 has joined the server (0:127.0.0.1)
[09:31:24] INSERT INTO user (Username, Passwort) VALUES ('kevin7372',MD5('kevin7372'))
[09:31:24] Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neuling`='0',`Leben`='0',`Russi`='0' WHERE `ID`='0'
[09:31:49] [part] kevin7372 has left the server (0:1)
[09:32:03] [connection] 127.0.0.1:57877 requests connection cookie.
[09:32:04] [connection] incoming connection: 127.0.0.1:57877 id: 0
[09:32:04] [join] kevin7372 has joined the server (0:127.0.0.1)
[09:32:39] [part] kevin7372 has left the server (0:1)

[09:29:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:29:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:29:40] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:29:40] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:29:40] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:29:40] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:29:40] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:29:40] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:30:59] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[09:30:59] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372'", callback: "UserCheck", format: "i"
[09:30:59] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[09:31:00] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.616 milliseconds
[09:31:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[09:31:00] [DEBUG] Calling callback "UserCheck"..
[09:31:00] [DEBUG] cache_get_data - connection: 1
[09:31:00] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[09:31:24] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))"
[09:31:24] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (Username, Passwort) VALUES ('kevin7372',MD5('k", callback: "OnPlayerRegister", format: "i"
[09:31:24] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[09:31:24] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - query was successfully executed within 46.33 milliseconds
[09:31:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[09:31:24] [DEBUG] Calling callback "OnPlayerRegister"..
[09:31:24] [DEBUG] cache_insert_id - connection: 1
[09:31:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[09:31:24] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[09:31:24] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)"
[09:31:25] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:31:25] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 19.502 milliseconds
[09:31:25] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[09:32:04] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[09:32:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372'", callback: "UserCheck", format: "i"
[09:32:04] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[09:32:04] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.468 milliseconds
[09:32:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[09:32:04] [DEBUG] Calling callback "UserCheck"..
[09:32:04] [DEBUG] cache_get_data - connection: 1
[09:32:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[09:32:28] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e' AND Passwort=MD5('%e')"
[09:32:28] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372' AND Passwort=MD5('", callback: "OnPassordResponse", format: "i"
[09:32:28] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - starting query execution
[09:32:28] [DEBUG] CMySQLQuery::Execute[OnPassordResponse] - query was successfully executed within 0.574 milliseconds
[09:32:28] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

#include <a_samp>
#include <a_mysql>
#include <md5>

//MYSL DATEN
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_DATA "selfmade"
#define MYSQL_PASS ""
new Handle;

enum playerInfo{
     db_id,
     pEingeloggt,
     pNeuling,
     pAlter,
     pGeschlecht,
     pSkin,
     Float:pRussi,
     Float:pLeben
};
new pInfo[MAX_PLAYERS][playerInfo];

//DIALOGE
#define DIALOG_REGISTER 1
#define DIALOG_CHAR1 2
#define DIALOG_CHAR2 3
#define DIALOG_CHAR3 4
#define DIALOG_LOGIN 5
#define DIALOG_LOGINT 6

//Farben
#define geld 0xFFFF00FF
#define weiss 0xFFFFFFFF

//news
new Logintest[MAX_PLAYERS];


main()
{
    print("\n----------------------------------");
    print(" selfmade by kevin");
    print("----------------------------------\n");
}



public OnGameModeInit()
{

    SetGameModeText("Selfmade v0,0,0");

    //MYSQL Verbindung
    Handle=mysql_connect (MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    if (mysql_errno() <1) print ("MYSQL: Die Verbindung war erfolgreich!"),
    mysql_log (LOG_ALL);else print ("MYSQL: Die Verbindung konnte nicht hergestellt werden! | Server wirt herundergefahren!"),
    SendRconCommand ("exit");
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetSpawnInfo(playerid,0,0,0,0,0,0,0,0,0,0,0,0);
    SpawnPlayer(playerid);
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query [256];
    mysql_format (Handle, query, sizeof (query), "SELECT * FROM user WHERE Username='%e'",Spielername(playerid));
    mysql_tquery(Handle,query,"UserCheck","i",playerid);
    ClearChat(playerid);
    TogglePlayerSpectating(playerid,1);
    //news auf 0
    Logintest[playerid]=0;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SpielerSpeichern(playerid);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    SetPlayerVirtualWorld(playerid,0);
    SetCameraBehindPlayer(playerid);
    TogglePlayerControllable(playerid,1);
    if(pInfo[playerid][pNeuling]==1)
    {
        ClearChat(playerid);
        SendClientMessage(playerid,geld,"Herzlich Willkommen!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        pInfo[playerid][pNeuling]=0;
        pInfo[playerid][pLeben]=100;
        if(pInfo[playerid][pGeschlecht]==1)
       {
           SetPlayerSkin(playerid,60);
       }
        else
    {
        SetPlayerSkin(playerid,40);
    }
        GameTextForPlayer(playerid,"~y~Wilkommen ~n~auf ~n~Den besten ~g~Sever",6000,4);
        SpielerSpeichern(playerid);
    }
    else
    {
        SendClientMessage(playerid,geld,"Willkommen Zurück!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        if(pInfo[playerid][pGeschlecht]==1)
        {
            SetPlayerSkin(playerid,60);
        }
        else
        {
            SetPlayerSkin(playerid,40);
        }
    }
    SetPlayerColor(playerid,0xF3F3F3FF);
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{

    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    //mysql dialogen
    if(dialogid == DIALOG_REGISTER)
    {
        if(!response)return Kick(playerid);
        SetPVarString(playerid,"passwortvar",inputtext);
        if(strlen(inputtext) >=4)
        {
            ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich");
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    if(dialogid == DIALOG_CHAR1)
    {
        if(response)
        {
            //männ
            pInfo[playerid][pGeschlecht]=1;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }
        else
        {
            //weib
            pInfo[playerid][pGeschlecht]=2;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }

    }
    if(dialogid == DIALOG_CHAR2)
    {
        if(response)
        {
            if(listitem==0)
            {
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
            }
            if(listitem==1)
            {
                Kick(playerid);
            }
            if(listitem==2)
            {
                Kick(playerid);
            }
            if(listitem==3)
            {
               ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid == DIALOG_CHAR3)
    {
        if(response)
        {
            if(IsNummeric(inputtext))
            {
                //new alterabfrage=strval(inputtext);
                if(strval(inputtext)>=18 && strval(inputtext) <=48)
                {
                    pInfo[playerid][pAlter]=strval(inputtext);
                    pInfo[playerid][pEingeloggt]=1;
                    pInfo[playerid][pNeuling]=1;
                    new query [256],passworteingabe[128];
                    GetPVarString(playerid,"passwortvar",passworteingabe,128);
                    mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
                    mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
                    printf("%s",query);
                }
                else
                {
                  ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
                }
            }
            else
            {
                ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid  == DIALOG_LOGIN)
    {
        if(!response)return Kick(playerid);
        new query[256];
        mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e' AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
        mysql_tquery(Handle,query,"OnPassordResponse","i",playerid);
        return 1;
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

//OnPlayerRegister
forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    pInfo[playerid][db_id]=cache_insert_id(Handle);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayer(playerid);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//User-Check
forward UserCheck(playerid);
public UserCheck(playerid)
{
    new num_rows, num_fields;
    cache_get_data(num_rows,num_fields,Handle);
    SetPlayerVirtualWorld(playerid,1);
    if(num_rows == 0)
    {
        //reg
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    else
    {
        //log
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"{00FFFA}Einloggen","{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    return 1;
}

//für login
forward OnPasswordResponse(playerid);
public OnPasswordResponse(playerid)
{
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields);
    if(num_rows==0)
    {
        //Passwort Falsch
        Logintest[playerid]+=1;
        new string [250];
        format(string,sizeof(string),"{00FFFA}Einloggen {FF0005}[%d/3]",Logintest[playerid]);
        if(Logintest[playerid]>=3)
        {
            ShowPlayerDialog(playerid,DIALOG_LOGINT,DIALOG_STYLE_MSGBOX,"{FF0005}Fehler","{FF0005}Maximale {FFFFFF}Versuche verbraucht sie werden aus sicherheits gründen  von Server entfernt!","{FF0005}Okay","");
            return SetTimerEx("KickHackInfo",1000,false,"i",playerid);
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    else
    {
        //Passwort Richtig
        SendClientMessage(playerid,geld,"Erfolgreich Eingeloggt");
        LoadAccount(playerid);

    }
    return 1;
}

//LoadAccount
stock LoadAccount(playerid)
{
    pInfo[playerid][db_id]=cache_get_field_content_int(0,"ID",Handle);
    pInfo[playerid][pEingeloggt]=1;
    pInfo[playerid][pAlter]=cache_get_field_content_int(0,"Alter",Handle);
    pInfo[playerid][pGeschlecht]=cache_get_field_content_int(0,"Geschlecht",Handle);
    pInfo[playerid][pSkin]=cache_get_field_content_int(0,"Skin",Handle);
    pInfo[playerid][pNeuling]=cache_get_field_content_int(0,"Neuling",Handle);

    pInfo[playerid][pLeben]=cache_get_field_content_float(0,"Leben",Handle);
    pInfo[playerid][pRussi]=cache_get_field_content_float(0,"Russi",Handle);

    SetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    SetPlayerArmour(playerid,pInfo[playerid][pRussi]);

    SpawnPlayer(playerid);
    TogglePlayerSpectating(playerid,0);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//SpielerSpeichern
stock SpielerSpeichern(playerid)
{
    if(pInfo[playerid][pEingeloggt]!=1)return 1;
    if(IsPlayerNPC(playerid))return 1;
    GetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    GetPlayerArmour(playerid,pInfo[playerid][pRussi]);
    new query[256];
    mysql_format(Handle,query,sizeof (query),"Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'",GetPlayerSkin(playerid),
    pInfo[playerid][pAlter],    pInfo[playerid][pGeschlecht],pInfo[playerid][pNeuling],pInfo[playerid][pLeben],pInfo[playerid][pRussi],pInfo[playerid][db_id]);
    mysql_pquery(Handle,query,"","");
    printf("%s",query);
    pInfo[playerid][pEingeloggt]=0;
    return 1;
}

//KickHackInfo
forward KickHackInfo(playerid);
public KickHackInfo(playerid)
{
    return Kick(playerid);
}

//Spielername
stock Spielername(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}
//Clear-Chat

stock ClearChat(playerid)
{

    for(new i = 0;i<100;i++)
    {
        SendClientMessage(playerid,weiss,"");
    }
    return 1;
}
//IsNummeric
stock IsNummeric(string[])
{
    for(new i=0,j=strlen(string);i<j;i++)
    {
        if((string[i] > '9' || string[i] < '0'))return 0;
    }
    return 1;
}

[14:30:26] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "selfmade", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[14:30:26] [DEBUG] CMySQLHandle::Create - creating new connection..
[14:30:26] [WARNING] CMySQLHandle::Create - connection already exists
[14:30:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:30:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:30:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:30:26] [DEBUG] mysql_errno - connection: 1
[14:30:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:30:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:30:26] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:30:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:30:26] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:30:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:30:26] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:30:37] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[14:30:37] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372'", callback: "UserCheck", format: "i"
[14:30:37] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[14:30:37] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.662 milliseconds
[14:30:37] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:30:37] [DEBUG] Calling callback "UserCheck"..
[14:30:37] [DEBUG] cache_get_data - connection: 1
[14:30:37] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:30:45] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e' AND Passwort=MD5('%e')"
[14:30:45] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='kevin7372' AND Passwort=MD5('", callback: "OnPasswordResponse", format: "i"
[14:30:45] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
[14:30:45] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.484 milliseconds
[14:30:45] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:30:45] [DEBUG] Calling callback "OnPasswordResponse"..
[14:30:45] [DEBUG] cache_get_data - connection: 1
[14:30:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "0"
[14:30:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Alter", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Alter", data: "20"
[14:30:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geschlecht", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geschlecht", data: "1"
[14:30:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Skin", data: "60"
[14:30:45] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Neuling", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Neuling", data: "0"
[14:30:45] [DEBUG] cache_get_field_content_float - row: 0, field_name: "Leben", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Leben", data: "100"
[14:30:45] [DEBUG] cache_get_field_content_float - row: 0, field_name: "Russi", connection: 1
[14:30:45] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Russi", data: "100"
[14:30:45] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:30:56] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[14:30:56] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='60',`Alter`='20',`Geschlecht`='1',`Neu", callback: "(null)", format: "(null)"
[14:30:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[14:30:56] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.633 milliseconds
[14:30:56] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[14:31:13] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM user WHERE Username='%e'"
[14:31:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username='ShadowKev1999'", callback: "UserCheck", format: "i"
[14:31:13] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[14:31:13] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.521 milliseconds
[14:31:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:31:13] [DEBUG] Calling callback "UserCheck"..
[14:31:13] [DEBUG] cache_get_data - connection: 1
[14:31:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:31:35] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))"
[14:31:35] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (Username, Passwort) VALUES ('ShadowKev1999',MD", callback: "OnPlayerRegister", format: "i"
[14:31:35] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - starting query execution
[14:31:35] [ERROR] CMySQLQuery::Execute[OnPlayerRegister] - (error #1062) Duplicate entry '0' for key 'PRIMARY'
[14:31:35] [DEBUG] CMySQLQuery::Execute[OnPlayerRegister] - error will be triggered in OnQueryError
[14:31:44] [DEBUG] mysql_format - connection: 1, len: 256, format: "Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'"
[14:31:44] [DEBUG] mysql_pquery - connection: 1, query: "Update `user` Set `Skin`='0',`Alter`='20',`Geschlecht`='2',`Neul", callback: "(null)", format: "(null)"
[14:31:44] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[14:31:44] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 30.790 milliseconds
[14:31:44] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    //mysql dialogen
    if(dialogid == DIALOG_REGISTER)
    {
        if(!response)return Kick(playerid);
        SetPVarString(playerid,"passwortvar",inputtext);
        if(strlen(inputtext) >=4)
        {
            ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich");
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    if(dialogid == DIALOG_CHAR1)
    {
        if(response)
        {
            //männ
            pInfo[playerid][pGeschlecht]=1;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }
        else
        {
            //weib
            pInfo[playerid][pGeschlecht]=2;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }

    }
    if(dialogid == DIALOG_CHAR2)
    {
        if(response)
        {
            if(listitem==0)
            {
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
            }
            if(listitem==1)
            {
                Kick(playerid);
            }
            if(listitem==2)
            {
                Kick(playerid);
            }
            if(listitem==3)
            {
               ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid == DIALOG_CHAR3)
    {
        if(response)
        {
            if(IsNummeric(inputtext))
            {
                //new alterabfrage=strval(inputtext);
                if(strval(inputtext)>=18 && strval(inputtext) <=48)
                {
                    pInfo[playerid][pAlter]=strval(inputtext);
                    pInfo[playerid][pEingeloggt]=1;
                    pInfo[playerid][pNeuling]=1;
                    new query [256],passworteingabe[128];
                    GetPVarString(playerid,"passwortvar",passworteingabe,128);
                    mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
                    mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
                    printf("%s",query);
                }
                else
                {
                  ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
                }
            }
            else
            {
                ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid  == DIALOG_LOGIN)
    {
        if(!response)return Kick(playerid);
        new query[256];
        mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e' AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
        mysql_tquery(Handle,query,"OnPasswordResponse","i",playerid);
        return 1;
    }
    return 1;
}

#include <a_samp>
#include <a_mysql>
#include <md5>

//MYSL DATEN
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_DATA "selfmade"
#define MYSQL_PASS ""
new Handle;

enum playerInfo{
     db_id,
     pEingeloggt,
     pNeuling,
     pAlter,
     pGeschlecht,
     pSkin,
     Float:pRussi,
     Float:pLeben
};
new pInfo[MAX_PLAYERS][playerInfo];

//DIALOGE
#define DIALOG_REGISTER 1
#define DIALOG_CHAR1 2
#define DIALOG_CHAR2 3
#define DIALOG_CHAR3 4
#define DIALOG_LOGIN 5
#define DIALOG_LOGINT 6

//Farben
#define geld 0xFFFF00FF
#define weiss 0xFFFFFFFF

//news
new Logintest[MAX_PLAYERS];


main()
{
    print("\n----------------------------------");
    print(" selfmade by kevin");
    print("----------------------------------\n");
}



public OnGameModeInit()
{

    SetGameModeText("Selfmade v0,0,0");


    //aututos sultan
    AddStaticVehicle(560,892.4884,-1668.8148,13.2555,179.2084,21,1); //
    AddStaticVehicle(560,892.6249,-1658.8854,13.2523,179.1803,21,1); //
    AddStaticVehicle(560,888.4724,-1669.5680,13.2518,178.5842,21,1); //
    AddStaticVehicle(560,887.8687,-1658.8271,13.2522,180.3682,21,1); //
    AddStaticVehicle(560,883.9625,-1668.3103,13.2515,180.6244,21,1); //
    AddStaticVehicle(560,883.8559,-1658.5575,13.2523,180.6242,21,1); //
    AddStaticVehicle(560,879.2274,-1668.4459,13.2521,178.5661,21,1); //
    AddStaticVehicle(560,879.4880,-1658.0333,13.2523,178.5659,21,1); //
    AddStaticVehicle(560,874.4413,-1668.7960,13.2521,180.0212,21,1); //
    AddStaticVehicle(560,874.4375,-1657.7222,13.2529,180.0210,21,1); //
    AddStaticVehicle(560,869.8978,-1668.2075,13.2517,179.1189,21,1); //
    AddStaticVehicle(560,870.0425,-1658.7791,13.2522,179.1190,21,1); //
    AddStaticVehicle(560,869.9100,-1678.0885,13.2515,359.5800,21,1); //
    AddStaticVehicle(560,875.0892,-1679.5377,13.2517,359.1576,21,1); //
    AddStaticVehicle(560,976.0642,-1408.6124,12.8225,271.7477,21,1); //
    AddStaticVehicle(560,1200.9709,-1209.3719,18.8133,270.5017,21,1); //
    AddStaticVehicle(560,1311.1044,-867.1094,39.2825,86.7155,21,1); //
    AddStaticVehicle(560,1331.6155,-896.5100,39.2820,180.3438,21,1); //
    AddStaticVehicle(560,1213.1965,-874.7578,42.6160,13.2779,21,1); //
    AddStaticVehicle(560,1221.8760,-880.6252,42.6000,94.6612,21,1); //
    AddStaticVehicle(560,1223.9897,-892.9338,42.5989,284.0572,21,1); //
    AddStaticVehicle(560,1215.5417,-902.7123,42.6227,4.8527,21,1); //
    AddStaticVehicle(560,1173.1782,-887.2821,43.0106,101.4971,21,1); //
    AddStaticVehicle(560,1143.8951,-920.5118,42.7895,52.0563,21,1); //
    AddStaticVehicle(560,1143.7371,-910.8324,42.7991,38.3274,21,1); //
    AddStaticVehicle(560,1086.9387,-929.1461,42.8410,356.4305,21,1); //
    AddStaticVehicle(560,1124.1018,-929.7202,42.8210,186.5953,21,1); //
    AddStaticVehicle(560,1017.5120,-916.5085,42.0488,7.5249,21,1); //
    AddStaticVehicle(560,1000.5903,-940.7648,41.8785,94.5884,21,1); //
    AddStaticVehicle(560,1008.8358,-940.1536,41.8589,95.1513,21,1); //
    AddStaticVehicle(560,1006.6532,-932.8140,41.8844,98.3228,21,1); //
    AddStaticVehicle(560,999.5803,-933.8484,41.8842,98.3229,21,1); //
    AddStaticVehicle(560,765.3916,-1027.8848,23.7505,177.3541,21,1); //
    AddStaticVehicle(560,768.3571,-1019.3671,24.6765,179.7523,21,1); //
    AddStaticVehicle(560,695.8920,-1181.6516,15.2115,57.4351,21,1); //
    AddStaticVehicle(560,694.5325,-1187.0692,15.1567,57.3080,21,1); //
    AddStaticVehicle(560,701.5531,-1198.3361,15.0218,323.3901,21,1); //
    AddStaticVehicle(560,768.3358,-1092.0402,23.7903,359.1352,21,1); //
    AddStaticVehicle(560,743.2710,-1138.2517,17.9426,81.6173,21,1); //
    AddStaticVehicle(560,713.0448,-1175.9325,15.7789,147.9130,21,1); //
    AddStaticVehicle(560,723.1871,-1159.6974,16.4644,148.5938,21,1); //
    AddStaticVehicle(560,550.5875,-1287.9443,16.9536,351.3201,21,1); //
    AddStaticVehicle(560,542.2619,-1287.2941,16.9476,350.2799,21,1); //
    AddStaticVehicle(560,536.5889,-1276.8265,16.9467,19.6378,21,1); //
    AddStaticVehicle(560,545.1462,-1270.5616,16.9540,22.7682,21,1); //
    AddStaticVehicle(560,502.4716,-1302.2209,16.9466,312.1037,21,1); //
    AddStaticVehicle(560,511.8238,-1293.7697,16.9466,312.1039,21,1); //
    AddStaticVehicle(560,660.2291,-1282.0693,13.2499,183.2422,21,1); //
    AddStaticVehicle(560,659.3704,-1264.7709,13.2511,183.0570,21,1); //
    AddStaticVehicle(560,660.8046,-1250.0739,13.4880,169.3111,21,1); //
    AddStaticVehicle(560,686.8462,-1224.3784,15.8819,120.7157,21,1); //
    AddStaticVehicle(560,705.0327,-1212.1742,17.3621,132.0988,21,1); //
    AddStaticVehicle(560,755.1609,-1337.9572,13.2375,87.2405,21,1); //
    AddStaticVehicle(560,767.6791,-1334.8102,13.2452,185.6558,21,1); //
    AddStaticVehicle(560,782.5638,-1344.5481,13.2439,260.1428,21,1); //
    AddStaticVehicle(560,783.5548,-1364.9758,13.2442,262.8366,21,1); //
    AddStaticVehicle(560,768.5583,-1380.3865,13.3583,170.9219,21,1); //
    AddStaticVehicle(560,735.7036,-1351.3926,13.2047,83.1394,21,1); //
    //MYSQL Verbindung
    Handle=mysql_connect (MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    if (mysql_errno() <1) print ("MYSQL: Die Verbindung war erfolgreich!"),
    mysql_log (LOG_ALL);else print ("MYSQL: Die Verbindung konnte nicht hergestellt werden! | Server wirt herundergefahren!"),
    SendRconCommand ("exit");
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetSpawnInfo(playerid,0,0,0,0,0,0,0,0,0,0,0,0);
    SpawnPlayer(playerid);
    return 1;
}

public OnPlayerConnect(playerid)
{
    new query [256];
    mysql_format (Handle, query, sizeof (query), "SELECT * FROM user WHERE Username='%e'",Spielername(playerid));
    mysql_tquery(Handle,query,"UserCheck","i",playerid);
    ClearChat(playerid);
    TogglePlayerSpectating(playerid,1);
    //news auf 0
    Logintest[playerid]=0;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SpielerSpeichern(playerid);
    return 1;
}

public OnPlayerSpawn(playerid)
{
    SetPlayerVirtualWorld(playerid,0);
    SetCameraBehindPlayer(playerid);
    TogglePlayerControllable(playerid,1);
    if(pInfo[playerid][pNeuling]==1)
    {
        ClearChat(playerid);
        SendClientMessage(playerid,geld,"Herzlich Willkommen!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        pInfo[playerid][pNeuling]=0;
        pInfo[playerid][pLeben]=100;
        if(pInfo[playerid][pGeschlecht]==1)
       {
           SetPlayerSkin(playerid,60);
       }
        else
    {
        SetPlayerSkin(playerid,40);
    }
        GameTextForPlayer(playerid,"~y~Wilkommen ~n~auf ~n~Dem besten ~g~Server",6000,4);
        SpielerSpeichern(playerid);
    }
    else
    {
        SendClientMessage(playerid,geld,"Willkommen Zurück!");
        SetPlayerPos(playerid,858.8041,-1655.6134,13.5523);
        SetPlayerFacingAngle(playerid,1.0462);
        if(pInfo[playerid][pGeschlecht]==1)
        {
            SetPlayerSkin(playerid,60);
        }
        else
        {
            SetPlayerSkin(playerid,40);
        }
    }
    SetPlayerColor(playerid,0xF3F3F3FF);
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{

    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    //mysql dialogen
    if(dialogid == DIALOG_REGISTER)
    {
        if(!response)return Kick(playerid);
        SetPVarString(playerid,"passwortvar",inputtext);
        if(strlen(inputtext) >=4)
        {
            ShowPlayerDialog(playerid,DIALOG_CHAR1,DIALOG_STYLE_MSGBOX,"{00FFFA}Charackter 1/3","{FFFFFF}Welches Geschlecht bist du?","{00FFFA}Männlich","{00FFFA}Weiblich");
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    if(dialogid == DIALOG_CHAR1)
    {
        if(response)
        {
            //männ
            pInfo[playerid][pGeschlecht]=1;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }
        else
        {
            //weib
            pInfo[playerid][pGeschlecht]=2;
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
        }

    }
    if(dialogid == DIALOG_CHAR2)
    {
        if(response)
        {
            if(listitem==0)
            {
            ShowPlayerDialog(playerid,DIALOG_CHAR2,DIALOG_STYLE_LIST,"{00FFFA}Charackter 2/3","{00AFFF}Hast du die Regeln gelesen?\n{00FF14}Ja\n{FF002D}Nein\n{F000FF}Was ech gibt Regeln?","00FFFA}Weiter","00FFFA}Abbrechen");
            }
            if(listitem==1)
            {
                Kick(playerid);
            }
            if(listitem==2)
            {
                Kick(playerid);
            }
            if(listitem==3)
            {
               ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid == DIALOG_CHAR3)
    {
        if(response)
        {
            if(IsNummeric(inputtext))
            {
                //new alterabfrage=strval(inputtext);
                if(strval(inputtext)>=18 && strval(inputtext) <=48)
                {
                    pInfo[playerid][pAlter]=strval(inputtext);
                    pInfo[playerid][pEingeloggt]=1;
                    pInfo[playerid][pNeuling]=1;
                    new query [256],passworteingabe[128];
                    GetPVarString(playerid,"passwortvar",passworteingabe,128);
                    mysql_format(Handle, query, sizeof(query), "INSERT INTO user (Username, Passwort) VALUES ('%e',MD5('%e'))",Spielername(playerid),passworteingabe);
                    mysql_function_query(Handle,query,true,"OnPlayerRegister","i",playerid);
                    printf("%s",query);
                }
                else
                {
                  ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
                }
            }
            else
            {
                ShowPlayerDialog(playerid,DIALOG_CHAR3,DIALOG_STYLE_INPUT,"{00FFFA}Charackter 3/3","\n{FF0023}Fehler: Eingabe ist Falsch{FFFFFF}Gebe nun Dein alter an(zwichen 18 bist 48 )","{00FFFA}Weiter","{00FFFA}Abbrechen");
            }
        }
        else
        {Kick (playerid);}
    }
    if(dialogid  == DIALOG_LOGIN)
    {
        if(!response)return Kick(playerid);
        new query[256];
        mysql_format(Handle,query,sizeof(query),"SELECT * FROM user WHERE Username='%e' AND Passwort=MD5('%e')",Spielername(playerid),inputtext);
        mysql_tquery(Handle,query,"OnPasswordResponse","i",playerid);
        return 1;
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

//OnPlayerRegister
forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    pInfo[playerid][db_id]=cache_insert_id(Handle);
    TogglePlayerSpectating(playerid,0);
    SpawnPlayer(playerid);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//User-Check
forward UserCheck(playerid);
public UserCheck(playerid)
{
    new num_rows, num_fields;
    cache_get_data(num_rows,num_fields,Handle);
    SetPlayerVirtualWorld(playerid,1);
    if(num_rows == 0)
    {
        //reg
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"{00FFFA}Neuanfang","{00FFFA}Herzlich Willkommen{FFFFFF},\n auf unseren Server bitte geben ein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    else
    {
        //log
        ClearChat(playerid);
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"{00FFFA}Einloggen","{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
    }
    return 1;
}

//für login
forward OnPasswordResponse(playerid);
public OnPasswordResponse(playerid)
{
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields);
    if(num_rows==0)
    {
        //Passwort Falsch
        Logintest[playerid]+=1;
        new string [250];
        format(string,sizeof(string),"{00FFFA}Einloggen {FF0005}[%d/3]",Logintest[playerid]);
        if(Logintest[playerid]>=3)
        {
            ShowPlayerDialog(playerid,DIALOG_LOGINT,DIALOG_STYLE_MSGBOX,"{FF0005}Fehler","{FF0005}Maximale {FFFFFF}Versuche verbraucht sie werden aus sicherheits gründen  von Server entfernt!","{FF0005}Okay","");
            return SetTimerEx("KickHackInfo",1000,false,"i",playerid);
        }
        else
        {
            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"{00FFFA}Willkommen Zurück{FFFFFF},\n auf unseren Server bitte geben Dein Passwort ein","{00FFFA}Weiter","{00FFFA}Abbrechen");
        }
    }
    else
    {
        //Passwort Richtig
        SendClientMessage(playerid,geld,"Erfolgreich Eingeloggt");
        LoadAccount(playerid);

    }
    return 1;
}

//LoadAccount
stock LoadAccount(playerid)
{
    pInfo[playerid][db_id]=cache_get_field_content_int(0,"ID",Handle);
    pInfo[playerid][pEingeloggt]=1;
    pInfo[playerid][pAlter]=cache_get_field_content_int(0,"Alter",Handle);
    pInfo[playerid][pGeschlecht]=cache_get_field_content_int(0,"Geschlecht",Handle);
    pInfo[playerid][pSkin]=cache_get_field_content_int(0,"Skin",Handle);
    pInfo[playerid][pNeuling]=cache_get_field_content_int(0,"Neuling",Handle);

    pInfo[playerid][pLeben]=cache_get_field_content_float(0,"Leben",Handle);
    pInfo[playerid][pRussi]=cache_get_field_content_float(0,"Russi",Handle);

    SetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    SetPlayerArmour(playerid,pInfo[playerid][pRussi]);

    SpawnPlayer(playerid);
    TogglePlayerSpectating(playerid,0);
    SetCameraBehindPlayer(playerid);
    return 1;
}

//SpielerSpeichern
stock SpielerSpeichern(playerid)
{
    if(pInfo[playerid][pEingeloggt]!=1)return 1;
    if(IsPlayerNPC(playerid))return 1;
    GetPlayerHealth(playerid,pInfo[playerid][pLeben]);
    GetPlayerArmour(playerid,pInfo[playerid][pRussi]);
    new query[256];
    mysql_format(Handle,query,sizeof (query),"Update `user` Set `Skin`='%d',`Alter`='%d',`Geschlecht`='%d',`Neuling`='%d',`Leben`='%.0f',`Russi`='%.0f' WHERE `ID`='%i'",GetPlayerSkin(playerid),
    pInfo[playerid][pAlter],    pInfo[playerid][pGeschlecht],pInfo[playerid][pNeuling],pInfo[playerid][pLeben],pInfo[playerid][pRussi],pInfo[playerid][db_id]);
    mysql_pquery(Handle,query,"","");
    printf("%s",query);
    pInfo[playerid][pEingeloggt]=0;
    return 1;
}

//KickHackInfo
forward KickHackInfo(playerid);
public KickHackInfo(playerid)
{
    return Kick(playerid);
}

//Spielername
stock Spielername(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,MAX_PLAYER_NAME);
    return name;
}
//Clear-Chat

stock ClearChat(playerid)
{

    for(new i = 0;i<100;i++)
    {
        SendClientMessage(playerid,weiss,"");
    }
    return 1;
}
//IsNummeric
stock IsNummeric(string[])
{
    for(new i=0,j=strlen(string);i<j;i++)
    {
        if((string[i] > '9' || string[i] < '0'))return 0;
    }
    return 1;
}