Топ пользователей

GET: module = top_users
SESSION: id = 5d411f1a6154237bb77877d5fe463c6e
SESSION: user = Гость
SESSION: lastAction = 1337527271
SESSION:

supervision =  array (
  'admin' => 
  array (
  ),
  'users' => 
  array (
  ),
  'bots' => 
  array (
    0 => 
    array (
      0 => '796ca067d474a79928c3a1bf125fdbbb',
      'sid' => '796ca067d474a79928c3a1bf125fdbbb',
      1 => 'Yandex',
      'uname' => 'Yandex',
      2 => '0',
      'is_admin' => '0',
      3 => '95.108.247.252',
      'ip' => '95.108.247.252',
      4 => '1337526552',
      'time' => '1337526552',
      5 => 'news',
      'module' => 'news',
      6 => '',
      'url' => '',
      7 => 'Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)',
      'user_agent' => 'Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    1 => 
    array (
      0 => '967cd2c05cecb13b74d0da9d813db57f',
      'sid' => '967cd2c05cecb13b74d0da9d813db57f',
      1 => 'Google',
      'uname' => 'Google',
      2 => '0',
      'is_admin' => '0',
      3 => '66.249.71.116',
      'ip' => '66.249.71.116',
      4 => '1337526519',
      'time' => '1337526519',
      5 => 'forum',
      'module' => 'forum',
      6 => '',
      'url' => '',
      7 => 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',
      'user_agent' => 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
  ),
  'guest' => 
  array (
    0 => 
    array (
      0 => '80cf4594e42f5d05a2c76b525026bcb1',
      'sid' => '80cf4594e42f5d05a2c76b525026bcb1',
      1 => '188.138.84.93',
      'uname' => '188.138.84.93',
      2 => '0',
      'is_admin' => '0',
      3 => '188.138.84.93',
      'ip' => '188.138.84.93',
      4 => '1337526783',
      'time' => '1337526783',
      5 => 'forum',
      'module' => 'forum',
      6 => '',
      'url' => '',
      7 => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      'user_agent' => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    1 => 
    array (
      0 => '5d411f1a6154237bb77877d5fe463c6e',
      'sid' => '5d411f1a6154237bb77877d5fe463c6e',
      1 => '38.107.179.240',
      'uname' => '38.107.179.240',
      2 => '0',
      'is_admin' => '0',
      3 => '38.107.179.240',
      'ip' => '38.107.179.240',
      4 => '1337526814',
      'time' => '1337526814',
      5 => 'news',
      'module' => 'news',
      6 => '',
      'url' => '',
      7 => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
      'user_agent' => 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    2 => 
    array (
      0 => '569913748d7c01ccdbe34551b873ce86',
      'sid' => '569913748d7c01ccdbe34551b873ce86',
      1 => '213.111.234.218',
      'uname' => '213.111.234.218',
      2 => '0',
      'is_admin' => '0',
      3 => '213.111.234.218',
      'ip' => '213.111.234.218',
      4 => '1337526516',
      'time' => '1337526516',
      5 => 'news',
      'module' => 'news',
      6 => '',
      'url' => '',
      7 => 'Mozilla/4.0 (compatible; MSIE 7.0b; Windows NT 6.0)',
      'user_agent' => 'Mozilla/4.0 (compatible; MSIE 7.0b; Windows NT 6.0)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    3 => 
    array (
      0 => 'db043a8e13c187b0e78db804b49dc1ed',
      'sid' => 'db043a8e13c187b0e78db804b49dc1ed',
      1 => '72.46.128.10',
      'uname' => '72.46.128.10',
      2 => '0',
      'is_admin' => '0',
      3 => '72.46.128.10',
      'ip' => '72.46.128.10',
      4 => '1337526650',
      'time' => '1337526650',
      5 => 'forum',
      'module' => 'forum',
      6 => '',
      'url' => '',
      7 => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      'user_agent' => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    4 => 
    array (
      0 => '7e2e906d4be532d00d764d23f78df98d',
      'sid' => '7e2e906d4be532d00d764d23f78df98d',
      1 => '91.207.8.78',
      'uname' => '91.207.8.78',
      2 => '0',
      'is_admin' => '0',
      3 => '91.207.8.78',
      'ip' => '91.207.8.78',
      4 => '1337526548',
      'time' => '1337526548',
      5 => 'forum',
      'module' => 'forum',
      6 => '',
      'url' => '',
      7 => 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.17 (KHTML, like Gecko) Chrome/10.0.649.0 Safari/534.17',
      'user_agent' => 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.17 (KHTML, like Gecko) Chrome/10.0.649.0 Safari/534.17',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
    5 => 
    array (
      0 => '87eaa7812a3489dc5fc27eb1115a6b83',
      'sid' => '87eaa7812a3489dc5fc27eb1115a6b83',
      1 => '72.46.134.138',
      'uname' => '72.46.134.138',
      2 => '0',
      'is_admin' => '0',
      3 => '72.46.134.138',
      'ip' => '72.46.134.138',
      4 => '1337526676',
      'time' => '1337526676',
      5 => 'forum',
      'module' => 'forum',
      6 => '',
      'url' => '',
      7 => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      'user_agent' => 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)',
      8 => 'default',
      'country' => 'default',
      9 => NULL,
      'uid' => NULL,
      10 => NULL,
      'user_id' => NULL,
      11 => NULL,
      'user_name' => NULL,
      12 => NULL,
      'user_group' => NULL,
      13 => NULL,
      'id' => NULL,
      14 => NULL,
      'title' => NULL,
      15 => NULL,
      'color' => NULL,
    ),
  ),
)

SESSION: topic_list = 354=1337526176,
SESSION_ID: 5d411f1a6154237bb77877d5fe463c6e
COOKIE: PHPSESSID = 5d411f1a6154237bb77877d5fe463c6e
COOKIE: online = 1337527515

[SELECT * FROM kasseler_sessions WHERE sid='5d411f1a6154237bb77877d5fe463c6e']

[INSERT INTO kasseler_sessions (country, is_admin, ip, sid, uname, time, module, url, user_agent) VALUES ('default', '0', '38.107.179.237', '5d411f1a6154237bb77877d5fe463c6e', '38.107.179.237', '1337527301', 'top_users', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')]

[SELECT s.sid, s.uname, s.is_admin, s.ip, s.time, s.module, s.url, s.user_agent, s.country, u.uid, u.user_id, u.user_name, u.user_group, g.id, g.title, g.color FROM kasseler_sessions AS s LEFT JOIN kasseler_users AS u ON(s.uname=u.user_name) LEFT JOIN kasseler_groups AS g ON(u.user_group=g.id)]

[SELECT u.uid, u.user_id, u.user_name, u.user_avatar, u.user_website, u.user_birthday, u.user_country, u.user_gender, u.user_regdate, u.user_last_ip, u.user_last_os, u.user_last_browser, u.user_group, u.user_points, u.rating, u.voted, g.id, g.title, g.color 
        FROM kasseler_users AS u LEFT JOIN kasseler_groups AS g ON (g.id=u.user_group) 
        WHERE u.user_name<>'Guest' 
        ORDER BY u.user_points DESC, BINARY(UPPER(u.user_name))
        LIMIT 0, 50]

[SELECT COUNT(u.uid) FROM kasseler_users AS u  WHERE u.user_name!='Guest']

[SELECT id, news_id, title, view FROM kasseler_news WHERE status='1' ORDER BY view DESC LIMIT 20]