public static function getPollsInfo($sorting_field, $sorting_order, $limit, $num_rows, &$pollsCount)
{
$order = 'ORDER BY ';
switch ($sorting_field) {
case 'user_group':
$order .= " user_group_sid {$sorting_order}";
break;
case 'status':
$order .= " `active` {$sorting_order}";
break;
default:
$order .= " {$sorting_field} {$sorting_order}";
break;
}
$pollsCount = count(SJB_DB::query('SELECT * FROM `polls`'));
$result = SJB_DB::query("SELECT * FROM `polls` {$order} LIMIT {$limit}, {$num_rows}");
$polls = array();
foreach ($result as $key => $val) {
$polls[$key] = $val;
if (!empty($val['user_group_sid'])) {
$polls[$key]['user_group'] = SJB_UserGroupManager::getUserGroupNameBySID($val['user_group_sid']);
} else {
$polls[$key]['user_group'] = 'All';
}
}
return $polls;
}