function operator($id) { $this->result = $GLOBALS['db']->query('SELECT * FROM `operators` WHERE `id`="' . $id . '"'); $this->result[0]['onlinetime'] = secs_to_hms($this->result[0]['onlinetime']); $this->result2 = $GLOBALS['db']->query('SELECT * FROM `reviews` WHERE `operatorid`="' . $id . '"'); $total = 0; if (isset($this->result2[0])) { foreach ($this->result2 as $key => $val) { $total += $this->result2[$key]['rating']; } $this->result[0]['rating'] = $total / count($this->result2); } else { $this->result[0]['rating'] = 0; } return $this->result[0]; }
function info($chatid) { if ($this->result = $GLOBALS['db']->query('SELECT * FROM `traffic` WHERE `id`="' . $chatid . '"')) { if ($this->result2 = $GLOBALS['db']->query('SELECT * FROM `footprints` WHERE `chatid`="' . $chatid . '" AND `current`="1" ORDER BY `id` DESC')) { $this->result[0]['page'] = $this->result2[0]['page']; $this->result[0]['page_time'] = secs_to_hms(time() - $this->result2[0]['timestamp']); $this->result[0]['footprints'] = $this->result2; } $this->result[0]['site_time'] = secs_to_hms(time() - $this->result[0]['start']); if (isset($this->result[0]['footprints'][0])) { foreach ($this->result[0]['footprints'] as $key => $val) { $this->result[0]['footprints'][$key]['time'] = gmdate('G:i:s D jS F Y', $this->result[0]['footprints'][$key]['timestamp'] + 3600 * $GLOBALS['conf']['offset']); if ($GLOBALS['hotpage']->check($this->result[0]['footprints'][$key]['page'])) { $this->result[0]['footprints'][$key]['hotpage'] = 'true'; } else { $this->result[0]['footprints'][$key]['hotpage'] = 'false'; } if (strlen($this->result[0]['footprints'][$key]['page']) > 60) { $this->result[0]['footprints'][$key]['url'] = $this->result[0]['footprints'][$key]['page']; $this->result[0]['footprints'][$key]['page'] = substr($this->result[0]['footprints'][$key]['url'], 0, 40) . '...' . substr($this->result[0]['footprints'][$key]['url'], -20, 20); } else { $this->result[0]['footprints'][$key]['url'] = $this->result[0]['footprints'][$key]['page']; } } } if ($this->result[0]['history'] = $GLOBALS['db']->query('SELECT * FROM `footprints` WHERE `chatid`="' . $chatid . '" AND `current`="0" ORDER BY `id` DESC')) { if (isset($this->result[0]['history'][0])) { foreach ($this->result[0]['history'] as $key => $val) { $this->result[0]['history'][$key]['time'] = gmdate('G:i:s D jS F Y', $this->result[0]['history'][$key]['timestamp'] + 3600 * $GLOBALS['conf']['offset']); if ($GLOBALS['hotpage']->check($this->result[0]['history'][$key]['page'])) { $this->result[0]['history'][$key]['hotpage'] = 'true'; } else { $this->result[0]['history'][$key]['hotpage'] = 'false'; } if (strlen($this->result[0]['history'][$key]['page']) > 60) { $this->result[0]['history'][$key]['url'] = $this->result[0]['history'][$key]['page']; $this->result[0]['history'][$key]['page'] = substr($this->result[0]['history'][$key]['url'], 0, 40) . '...' . substr($this->result[0]['history'][$key]['url'], -20, 20); } else { $this->result[0]['history'][$key]['url'] = $this->result[0]['history'][$key]['page']; } } } } if (isset($this->result[0]['page'])) { if (strlen($this->result[0]['page']) > 60) { $this->result[0]['url'] = $this->result[0]['page']; $this->result[0]['page'] = substr($this->result[0]['url'], 0, 40) . '...' . substr($this->result[0]['url'], -20, 20); } else { $this->result[0]['url'] = $this->result[0]['page']; } } else { $this->result[0]['page'] = ''; $this->result[0]['url'] = ''; } if (isset($this->result[0]['referrer'])) { if (strlen($this->result[0]['referrer']) > 60) { $this->result[0]['refurl'] = $this->result[0]['referrer']; $this->result[0]['referrer'] = substr($this->result[0]['refurl'], 0, 40) . '...' . substr($this->result[0]['refurl'], -20, 20); } else { $this->result[0]['refurl'] = $this->result[0]['referrer']; } } else { $this->result[0]['referrer'] = ''; $this->result[0]['refurl'] = ''; } } return $this->result[0]; }