main/inc/lib/sessionmanager.lib.php 1 location
|
@@ 3342-3346 (lines=5) @@
|
| 3339 |
|
src.session_id IN ($sessionsSQL) |
| 3340 |
|
$keywordCondition |
| 3341 |
|
"; |
| 3342 |
|
if ($getCount) { |
| 3343 |
|
$result = Database::query($sql); |
| 3344 |
|
$row = Database::fetch_array($result,'ASSOC'); |
| 3345 |
|
return $row['count'] + (int) $platformCourses; |
| 3346 |
|
} |
| 3347 |
|
|
| 3348 |
|
if (isset($from) && isset($limit)) { |
| 3349 |
|
$from = intval($from); |
main/inc/lib/usermanager.lib.php 1 location
|
@@ 4105-4109 (lines=5) @@
|
| 4102 |
|
if ($getSql) { |
| 4103 |
|
return $sql; |
| 4104 |
|
} |
| 4105 |
|
if ($getCount) { |
| 4106 |
|
$result = Database::query($sql); |
| 4107 |
|
$row = Database::fetch_array($result); |
| 4108 |
|
return $row['count']; |
| 4109 |
|
} |
| 4110 |
|
|
| 4111 |
|
$orderBy = null; |
| 4112 |
|
if ($getOnlyUserId == false) { |
main/work/work.lib.php 1 location
|
@@ 1781-1785 (lines=5) @@
|
| 1778 |
|
$direction = in_array(strtolower($direction), array('desc', 'asc')) ? $direction : 'desc'; |
| 1779 |
|
$column = Database::escape_string($column); |
| 1780 |
|
|
| 1781 |
|
if ($getCount) { |
| 1782 |
|
$result = Database::query($sql); |
| 1783 |
|
$result = Database::fetch_array($result); |
| 1784 |
|
return $result['count']; |
| 1785 |
|
} |
| 1786 |
|
|
| 1787 |
|
$sql .= " ORDER BY $column $direction"; |
| 1788 |
|
$sql .= " LIMIT $start, $limit"; |