[nGen.SoNNy]

Hello! I have a top function for SQL but now i don't know to transform into MySQL(BlueG - GStylezz Plugin) If somebody want to help me... Will get +1 Rep and my kisses)

pawn Код:

ShowTop( playerid, stats[ ], what[ ], limit = MAX_TOP_LIMIT ) // THX to Zh3r0 & Roach_
{
    new Speed = GetTickCount( ),
        DialString[ 3_000 ],
        String[ 2 ][ 128 ],
        Query[ 2 ][ 256 ],
        DBResult:Result1,
        cColor[ 12 ] = "{FFFFFF}";
    g_dbKeptAlive = db_open( "Conturi.db" ); //Open DB

    format( Query[ 0 ], 256, "SELECT `Name` FROM `Users` ORDER BY (`%s` * 1) DESC limit %d", stats, limit);
    Result1 = db_query( g_dbKeptAlive, Query[ 0 ] );

    format( DialString, sizeof DialString, ""C_W"Server Statistics: "C_FG"%s\n\n\n"C_W"Top Players: "W"%s", what, stats );
    for( new Qr; Qr < db_num_rows( Result1 ); Qr ++ )
    {
        db_get_field( Result1, 0, String[ 0 ], 128 );
        format( Query[ 1 ], 256, "SELECT `%s` FROM `Users` WHERE `Name` = '%s'", stats, String[ 0 ] );
        new DBResult:Result2 = db_query( g_dbKeptAlive, Query[ 1 ] );
        db_get_field( Result2, 0, String[ 1 ], 128 );
        if( !strcmp( stats, "Ore" ) ) format( DialString, sizeof DialString, "%s\n"C_R"%d."C_FG" %s "C_W": "C_R"%s"C_W" Hours", DialString, Qr + 1, String[ 0 ], FormatNumber( strval( String[ 1 ] ) ) );
        else format( DialString, sizeof DialString, "%s\n"C_R"%d."C_FG" %s "C_W": %s%s", DialString, Qr + 1, String[ 0 ], cColor, FormatNumber( strval( String[ 1 ] ) ) );
        db_next_row( Result1 );
        db_free_result( Result2 );
    }
    db_free_result( Result1 );
    db_close( g_dbKeptAlive ); //Close DB
    format( DialString, sizeof DialString, "%s\n\n"W"Top list generated in "C_FG"%d "W"ms.", DialString, GetTickCount( ) - Speed );
    ShowPlayerDialog( playerid, Nothing, DIALOG_STYLE_MSGBOX, ""W"Location: "G"TOP PLAYERS", DialString, "(Close)", "" );

    return ( 1 );
}

[nGen.SoNNy]

Somebody?