In class\Action\User.php
Find:
Code: Select all
$users = User::getListFromDB($this->db,
'where countryId like "%'.$par[0].'%" and active=1 order by name');
Code: Select all
$users = User::getListFromDB($this->db,
'where countryId like "%'.$par[0].'%" and active=1 order by id');
Find:
Code: Select all
static public function getListFromDB(MyPDO $DB, $restrictions = '')
{
$data = $DB->query('select userFeedbacks.id, fromUser, toUser, bidId,
users1.name as fromUserName, users2.name as toUserName,
userFeedbacks.value, userFeedbacks.comment,
userFeedbacks.date, offerId, items.name as item
from '.self::DB_TABLE.' as userFeedbacks
left join '.Offer::DB_TABLE.' as offers on offers.id = userFeedbacks.offerId
left join '.Item::DB_TABLE.' as items on items.id = offers.itemId
left join '.User::DB_TABLE.' as users1 on users1.id = userFeedbacks.fromUser
left join '.User::DB_TABLE.' as users2 on users2.id = userFeedbacks.toUser
'.$restrictions)
->fetchAll(PDO::FETCH_ASSOC);
return $data;
}
Code: Select all
static public function getListFromDB(MyPDO $DB, $restrictions = '')
{
$data = $DB->query('select userFeedbacks.id, fromUser, toUser, bidId,
userFeedbacks.value, userFeedbacks.comment,
userFeedbacks.date, offerId, items.name as item
from '.self::DB_TABLE.' as userFeedbacks
left join '.Offer::DB_TABLE.' as offers on offers.id = userFeedbacks.offerId
left join '.Item::DB_TABLE.' as items on items.id = offers.itemId
'.$restrictions)
->fetchAll(PDO::FETCH_ASSOC);
return $data;
}