public plugin_cfg()

    g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);

 

    static Query[10048];

    new Len;

 

    Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `paintball_new_30`");

    Len += formatex(Query[Len], charsmax(Query)-Len, "(`username` varchar(32) NOT NULL, ");

         Len += formatex(Query[Len], charsmax(Query)-Len, "`password` varchar(32) NOT NULL, ");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Lada` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`XP` int(11) NOT NULL,");

    Len += formatex(Query[Len], charsmax(Query)-Len, "`viporok` int(11) NOT NULL,");

 

 

    for(new i;i < 15; i++)

        Len += formatex(Query[Len], charsmax(Query)-Len, "`F_%d` int(11) NOT NULL,", i);

 

 

   

    Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");

 

    SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);

public Load(id, iMode ) {

    static Query[10048];

    new Data[1], Name[32];

    get_user_name(id, Name, 31);

    Data[0] = id;

         static sText[ 128 ], iArray[ 1 ];

   

         iArray[ 0 ] = id;

         if ( iMode == 1 )

         {

    formatex(Query, charsmax(Query), "SELECT * FROM `paintball_new_30` WHERE username = ^"%s^";", g_sUserName[id]);

    }

         else formatex( sText, charsmax( sText ), "SELECT * FROM `paintball_new_30 ` WHERE username = ^"%s^" AND password = ^"%s^";", g_sUserName[id], g_sPassword[id]);

    SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1, sText, iArray, sizeof( iArray ));

public QuerySelectData( iFailState, Handle:iQuery, const sErrorMsg[ ], iErrorCode, const iARRAY[ ], iArraySize, Float:fQueueTime )

   

    if ( iFailState == TQUERY_CONNECT_FAILED )

    {

        set_fail_state( "Nem tudtam csatlakozni az adatbazishoz." );

        return;

    }

    else if ( iFailState == TQUERY_QUERY_FAILED )

    {

        set_fail_state( "Query Error" );

        return;

    }

   

    if ( iErrorCode )

    {

        log_amx( "%i - %s", iErrorCode, sErrorMsg );

        return;

    }

    new id = iARRAY[ 0 ];

    if ( id )

    {

        if ( id > 100 )

        {

            id -= 100;

            if ( SQL_NumResults( iQuery ) > 0 )

            {

                g_iLoggedIn[ id ] = 3;

                ChatColor( id, "Sikeresen bejelentkeztel." );

                MainMenu( id, 0 );

            }

            else

            {

                ChatColor( id, "Hibas felhasznalonev es/vagy jelszo." );

                MainMenu( id, 2 );

            }

        }

        else

        {

            if ( SQL_NumResults( iQuery ) > 0 )

            {

                ChatColor(id, "Ez a felhasznalonev mar foglalt." );

                MainMenu(id, 1 );

            }

            else

            {

                g_iLoggedIn[id] = 3;

                ChatColor( id, "Sikeresen regisztraltal. Felhasznaloneved: %s, Jelszavad: %s.", g_sUserName[ id ], g_sPassword[ id ] );

                Save(id);

                MainMenu( id, 0 );

            }

        }

    }

   

    return;

    else {

        new id = Data[0];

 

        if(SQL_NumRows(Query) > 0) {

            Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar"));

            Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));

            Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));

            Lada[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Lada"));

                            Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));

            Skin[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin"));

            xp[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "XP"));

            viporok[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "viporok"));

 

           

            for(new i=0;i < 15; i++)

            {

                new String[64];

                formatex(String, charsmax(String), "F_%d", i);

                OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));

            }

 

 

        }

        else

        {

            Save(id);

        }

   

    }

 

 

 

public Save(id)

    static Query[256];

    new Name[32]; get_user_name(id, Name, 31);

 

    formatex(Query, charsmax(Query), "INSERT INTO `paintball_new_30` (`username`, `password`) VALUES (^"%s^", ^"%s^");"Í, g_sUserName[ id ], g_sPassword[ id ] );

 

    SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);

public Update(id)

    static Query[10048];

    new Len;

    new Name[32]; get_user_name(id, Name, 31);

 

    Len += formatex(Query[Len], charsmax(Query), "UPDATE `paintball_new_30` SET Dollar = ^"%i^", ",Dollar[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Szint[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "Lada = ^"%i^", ", Lada[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^", ", Kulcs[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "Skin = ^"%i^", ", Skin[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "XP = ^"%i^", ", xp[id]);

    Len += formatex(Query[Len], charsmax(Query)-Len, "viporok = ^"%i^", ", viporok[id]);

 

   

 

    for(new i=0;i < 15; i++)

        Len += formatex(Query[Len], charsmax(Query)-Len, "F_%d = ^"%i^", ", i, OsszesSkin[i][id]);

 

   

          Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^"WHERE username = ^"%s^" AND password = ^"%s^";", Masodpercek[id]+get_user_time(id), g_sUserName[ iId ], g_sPassword[ iId ] );

 

    SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);

public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {

    if(FailState == TQUERY_CONNECT_FAILED)

        set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!");

    else if(FailState == TQUERY_QUERY_FAILED)

        set_fail_state("Query Error");

    if(Errcode)

        log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);

public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {

    if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {

        log_amx("%s", Error);

        return;

    }