XoopsModules25x /
lexikon
| @@ 1348-1359 (lines=12) @@ | ||
| 1345 | WHERE u.uid = n.uid |
|
| 1346 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1347 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1348 | } elseif ($sort === 'read') { |
|
| 1349 | if ($compute_method === 'average') { |
|
| 1350 | $compute = 'sum( n.counter ) / count( n.entryID )'; |
|
| 1351 | } else { |
|
| 1352 | $compute = 'sum( n.counter )'; |
|
| 1353 | } |
|
| 1354 | $sql = 'SELECT u.' . $name . " AS name, u.uid , $compute AS count |
|
| 1355 | FROM " . $db->prefix('users') . ' u, ' . $db->prefix('lxentries') . ' n |
|
| 1356 | WHERE u.uid = n.uid |
|
| 1357 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1358 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1359 | } |
|
| 1360 | if (!$result = $db->query($sql, $limit)) { |
|
| 1361 | return false; |
|
| 1362 | } |
|
| @@ 772-783 (lines=12) @@ | ||
| 769 | WHERE u.uid = n.uid |
|
| 770 | AND n.datesub > 0 AND n.datesub <= ".time()." AND n.offline = 0 AND n.submit = 0 |
|
| 771 | GROUP BY u.uid ORDER BY count DESC"; |
|
| 772 | } elseif ($sort == "read") { |
|
| 773 | if ($compute_method == "average") { |
|
| 774 | $compute = "sum( n.counter ) / count( n.entryID )"; |
|
| 775 | } else { |
|
| 776 | $compute = "sum( n.counter )"; |
|
| 777 | } |
|
| 778 | $sql = "SELECT u.".$name." AS name, u.uid , $compute AS count |
|
| 779 | FROM ".$db->prefix("users")." u, ".$db->prefix("lxentries")." n |
|
| 780 | WHERE u.uid = n.uid |
|
| 781 | AND n.datesub > 0 AND n.datesub <= ".time()." AND n.offline = 0 AND n.submit = 0 |
|
| 782 | GROUP BY u.uid ORDER BY count DESC"; |
|
| 783 | } |
|
| 784 | if (!$result = $db->query($sql, $limit)) |
|
| 785 | return false; |
|
| 786 | ||
