XoopsModules25x /
lexikon
| @@ 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 | ||
| @@ 1374-1385 (lines=12) @@ | ||
| 1371 | WHERE u.uid = n.uid |
|
| 1372 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1373 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1374 | } elseif ($sort === 'read') { |
|
| 1375 | if ($compute_method === 'average') { |
|
| 1376 | $compute = 'sum( n.counter ) / count( n.entryID )'; |
|
| 1377 | } else { |
|
| 1378 | $compute = 'sum( n.counter )'; |
|
| 1379 | } |
|
| 1380 | $sql = 'SELECT u.' . $name . " AS name, u.uid , $compute AS count |
|
| 1381 | FROM " . $db->prefix('users') . ' u, ' . $db->prefix('lxentries') . ' n |
|
| 1382 | WHERE u.uid = n.uid |
|
| 1383 | AND n.datesub > 0 AND n.datesub <= ' . time() . ' AND n.offline = 0 AND n.submit = 0 |
|
| 1384 | GROUP BY u.uid ORDER BY count DESC'; |
|
| 1385 | } |
|
| 1386 | if (!$result = $db->query($sql, $limit)) { |
|
| 1387 | return false; |
|
| 1388 | } |
|
