[MYSQL R5 > R34] Перевод команды с 2 SELECT.

[Johurt]

CMD:sellhouse(playerid, params[])
{
     new house, pID = INVALID_PLAYER_ID, hQuery[65];
     if(sscanf(params, "d", house)) return 1;
     format(hQuery, 42, "SELECT * FROM `houses` WHERE `ID` = '%d'", house);
     mysql_query(hQuery);
     mysql_store_result();
     if(mysql_num_rows())
     {
          for(new p; p < MAX_PLAYERS; p++)
          {
               if(!IsPlayerConnected(p) || IsPlayerNPC(p)) continue;
               if(!strcmp(hInfo[house][Savininkas], GetPlayerNameEx(p), true))
               {
                    pID = p;
                    break;
               }
          }
          if(pID != INVALID_PLAYER_ID)
          {
               ...
          }
          else
          {
               new bMoney;
               format(hQuery, 65, "SELECT * FROM `players` WHERE `Vardas` = '%s'", hInfo[house][Savininkas]);
               mysql_query(hQuery);
               mysql_store_result();
               mysql_retrieve_row();
               if(mysql_num_rows())
               {
                    mysql_fetch_field_row(hQuery, "PinigaiBanke"); bMoney = strval(hQuery);
                    ...
               }
          }
     }
     mysql_free_result();
     ...
     return 1;
}

Как переделать команду на MYSQL R34?

CMD:sellhouse(playerid, params[])
{
    new house, hQuery[65];
    if(sscanf(params, "d", house)) return 1;
    format(hQuery, 42, "SELECT * FROM `houses` WHERE `ID` = '%d'", house);
    mysql_tquery(connectionhandle, hQuery, "PardokNama", "ddd", playerid, house, 0);
 
    ...
    return 1;
}
forward PardokNama(playerid, house, bbzkas);
public    PardokNama(playerid, house, bbzkas)
{
    switch(bbzkas)
    {
        case 0:
        {
            if(cache_get_row_count())
            {
                new pID = INVALID_PLAYER_ID, hQuery[65];
                for(new p; p < MAX_PLAYERS; p++)
                {
                    if(!IsPlayerConnected(p) || IsPlayerNPC(p)) continue;
                    if(!strcmp(hInfo[house][Savininkas], GetPlayerNameEx(p), true))
                    {
                        pID = p;
                        break;
                    }
                }
                if(pID != INVALID_PLAYER_ID)
                {
                    ...
                }
                else
                {
                    format(hQuery, 65, "SELECT * FROM `players` WHERE `Vardas` = '%s'", hInfo[house][Savininkas]);
                    mysql_tquery(connectionhandle, hQuery, "PardokNama", "ddd", playerid, house, 1);
                }
            }
        }
        case 1:
        {
            if(cache_get_row_count())
            {
                new bMoney;
                mysql_fetch_field_row(hQuery, "PinigaiBanke"); bMoney = strval(hQuery);
                ...
            }
        }
    }
}

© Cpt. Scott