include/functions.php 1 location
|
@@ 785-797 (lines=13) @@
|
| 782 |
|
} |
| 783 |
|
|
| 784 |
|
// Returns the author's IDs for authorslist |
| 785 |
|
function lx_getAuthors($limit=0, $start=0) { |
| 786 |
|
global $xoopsDB ; |
| 787 |
|
|
| 788 |
|
$ret = []; |
| 789 |
|
$sql = 'SELECT distinct(uid) as uid FROM '.$xoopsDB->prefix('lxentries').' WHERE offline = 0 '; |
| 790 |
|
$sql .= " ORDER BY uid"; |
| 791 |
|
$result = $xoopsDB->query($sql); |
| 792 |
|
while ( $myrow = $xoopsDB->fetchArray($result) ) { |
| 793 |
|
$ret[] = $myrow['uid']; |
| 794 |
|
} |
| 795 |
|
|
| 796 |
|
return $ret; |
| 797 |
|
} |
| 798 |
|
|
| 799 |
|
// link to userprofile |
| 800 |
|
function lx_getLinkedProfileFromId($userid) { |
class/Utility.php 1 location
|
@@ 1117-1130 (lines=14) @@
|
| 1114 |
|
* @param int $start |
| 1115 |
|
* @return array |
| 1116 |
|
*/ |
| 1117 |
|
public static function getAuthors($limit = 0, $start = 0) |
| 1118 |
|
{ |
| 1119 |
|
global $xoopsDB; |
| 1120 |
|
|
| 1121 |
|
$ret = []; |
| 1122 |
|
$sql = 'SELECT DISTINCT(uid) AS uid FROM ' |
| 1123 |
|
. $xoopsDB->prefix('lxentries') |
| 1124 |
|
. ' WHERE offline = 0 '; |
| 1125 |
|
$sql .= ' ORDER BY uid'; |
| 1126 |
|
$result = $xoopsDB->query($sql); |
| 1127 |
|
while ($myrow = $xoopsDB->fetchArray($result)) { |
| 1128 |
|
$ret[] = $myrow['uid']; |
| 1129 |
|
} |
| 1130 |
|
|
| 1131 |
|
return $ret; |
| 1132 |
|
} |
| 1133 |
|
|