RCONCMD:redeemcodes(playerid, params[])
{
    mysql_query(connectionHandle, "SELECT * FROM vipcodes", true);


    new s[1500], title[64], code[64],x = 0, i;
    format(title, 64, "Unused Redeem Codes");
    format(s, 1500, "ID\tCodes\tFor Vip Level\n");


    for(new xx = cache_get_row_count(); x < xx; x++)
    {


        i = Iter_Free(Rcodes);
        VipRedeem[i][VipCodeID] = cache_get_field_content_int(x, "id");
        cache_get_field_content(x, "codes", code);
        VipRedeem[i][VipLevels] = cache_get_field_content_int(x, "viplevel");
        VipRedeem[i][CodeOwner] = cache_get_field_content_int(x, "owner");
        VipRedeem[i][CodeUsed] = cache_get_field_content_int(x, "used");
        Iter_Add(Rcodes, i);
        if(VipRedeem[i][CodeOwner])
        {
            continue;
        }

        if(VipRedeem[i][CodeUsed] != 0)
        {
            continue;
        }
        format(s, 1500, "%s%d\t%s\t%d\n", s, VipRedeem[i][VipCodeID], code, VipRedeem[i][VipLevels]);
    }
    Dialog_Show(playerid, DialogRedeemsend, DIALOG_STYLE_TABLIST_HEADERS, title, s, "Send", "Close");
    return 1;
}

Dialog:DialogRedeemsend(playerid, response, listitem, inputtext[])
{
    if(response)
    {
        new a;
        foreach(new i : Rcodes)
        {

            if(a == listitem)
            {

                pData[playerid][ChosenCode] = i;
                Dialog_Show(playerid, DialogRedeemsendopt, DIALOG_STYLE_LIST, "Sent Code To Player Options","Send by playerid ({FFFF66}If player is online{FFFFFF})\n{FFFFFF}Send by player name ({FFFF66}If player is offline{FFFFFF})", "Select", "Cancel");
                break;
            }
            else
              a++;


        }
    }
    return 1;
}

Dialog:DialogRedeemsendopt(playerid, response, listitem, inputtext[])
{
    if(response)
    {

        switch(listitem)
        {
            case 0:
            {
                Dialog_Show(playerid, DialogRedeemplayerid, DIALOG_STYLE_INPUT, "Sent Code By Playerid","Enter player id", "Send", "Cancel");
            }
            case 1:
            {
                Dialog_Show(playerid, DialogRedeemplayername, DIALOG_STYLE_INPUT, "Sent Code By Player name","Enter player name", "Send", "Cancel");
            }
        }

    }
    return 1;
}

Dialog:DialogRedeemplayerid(playerid, response, listitem, inputtext[])
{
    if(response)
    {
        new i = pData[playerid][ChosenCode],query[128];
        new m = strval(inputtext);
        if(!IsPlayerConnected(m))
          return SendClientMessage(playerid, COLOR_RED, "This player is not connected");

        mysql_format(connectionHandle, query, 128, "UPDATE vipcodes SET owner = %d WHERE id = %d",  pData[m][RealID], VipRedeem[i][VipCodeID]);
        mysql_query(connectionHandle, query, false);
        SendClientMessage(playerid, COLOR_YELLOW, "Redeem Code Sended");
        Iter_Remove(Rcodes, i);
        pData[playerid][ChosenCode] = -1;
    }
    return 1;
}


Dialog:DialogRedeemplayername(playerid, response, listitem, inputtext[])
{
    if(response)
    {
        new i = pData[playerid][ChosenCode],query[256];
        //new m = strlen(inputtext);
        mysql_format(connectionHandle, query, 256, "SELECT id FROM account WHERE username = '%e'",inputtext);
        mysql_query(connectionHandle, query, true);
        if(!cache_get_row_count())
          return ShowNotification(playerid, "Sent Code By Player name", "Invalid player name");

        mysql_format(connectionHandle, query, 256, "UPDATE vipcodes SET owner = %d WHERE id = %d", cache_get_field_content_int(0, "id"), VipRedeem[i][VipCodeID]);
        mysql_query(connectionHandle, query, false);
        SendClientMessage(playerid, COLOR_YELLOW, "Redeem Code Sended");

        Iter_Remove(Rcodes, i);
        pData[playerid][ChosenCode] = -1;
    }
    return 1;
}