Help Center Live Community

function clean()
        {
            if ($this->result = $GLOBALS['db']->query("SELECT * FROM chat WHERE 1 = 1 GROUP BY chatid")) {
                foreach ($this->result as $key => $val) {
                    if (!$GLOBALS['db']->query("SELECT * FROM sessions WHERE chatid='".$this->result[$key]['chatid']."'")) {
                        $this->result2 = $GLOBALS['db']->query("SELECT * FROM chat WHERE chatid='".$this->result[$key]['chatid']."' ORDER BY timestamp DESC LIMIT 1");
                        if ($this->result2[0]['timestamp'] < (time() - 3600)) {
                            $GLOBALS['db']->query("DELETE FROM chat WHERE chatid='".$this->result[$key]['chatid']."'");
                        }
                    }
                }
            }
        }

function referrers($limit = 25)
        {
            $this->result = $GLOBALS['db']->raw_query('SELECT `url`, COUNT(*) AS `count` FROM `'.$GLOBALS['conf']['prefix'].'stats_referrers` GROUP BY `url` ORDER BY `count` DESC LIMIT '.$limit, 'stats_referrers');
            if ($this->result[0]) {
                foreach ($this->result as $key => $val) {
                    if (strlen($this->result[$key]['url']) > 75) {
                        $this->result[$key]['title'] = substr($this->result[$key]['url'], 0, 55).'...'.substr($this->result[$key]['url'], -20, 20);
                    } else {
                        $this->result[$key]['title'] = $this->result[$key]['url'];
                    }
                }
            }
            return $this->result;
        }

'SELECT `url`, COUNT(*) AS `count` FROM `'.$GLOBALS['conf']['prefix'].'stats_referrers` GROUP BY `url` ORDER BY `count` DESC LIMIT '.$limit, 'stats_referrers'