XoopsModules25x /
lexikon
| @@ 1354-1365 (lines=12) @@ | ||
| 1351 | WHERE u.uid = n.uid |
|
| 1352 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1353 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1354 | } elseif ($sort === 'read') { |
|
| 1355 | if ($compute_method === 'average') { |
|
| 1356 | $compute = 'sum( n.counter ) / count( n.entryID )'; |
|
| 1357 | } else { |
|
| 1358 | $compute = 'sum( n.counter )'; |
|
| 1359 | } |
|
| 1360 | $sql = 'SELECT u.' . $name . " AS name, u.uid , $compute AS count |
|
| 1361 | FROM " . $db->prefix('users') . ' u, ' . $db->prefix('lxentries') . ' n |
|
| 1362 | WHERE u.uid = n.uid |
|
| 1363 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1364 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1365 | } |
|
| 1366 | if (!$result = $db->query($sql, $limit)) { |
|
| 1367 | return false; |
|
| 1368 | } |
|
| @@ 924-935 (lines=12) @@ | ||
| 921 | WHERE u.uid = n.uid |
|
| 922 | AND n.datesub > 0 AND n.datesub <= ".time()." AND n.offline = 0 AND n.submit = 0 |
|
| 923 | GROUP BY u.uid ORDER BY count DESC"; |
|
| 924 | } elseif ($sort == "read") { |
|
| 925 | if ($compute_method == "average") { |
|
| 926 | $compute = "sum( n.counter ) / count( n.entryID )"; |
|
| 927 | } else { |
|
| 928 | $compute = "sum( n.counter )"; |
|
| 929 | } |
|
| 930 | $sql = "SELECT u.".$name." AS name, u.uid , $compute AS count |
|
| 931 | FROM ".$db->prefix("users")." u, ".$db->prefix("lxentries")." n |
|
| 932 | WHERE u.uid = n.uid |
|
| 933 | AND n.datesub > 0 AND n.datesub <= ".time()." AND n.offline = 0 AND n.submit = 0 |
|
| 934 | GROUP BY u.uid ORDER BY count DESC"; |
|
| 935 | } |
|
| 936 | if (!$result = $db->query($sql, $limit)) |
|
| 937 | return false; |
|
| 938 | ||
