\n"; return $ret; } // end method // ----------------------------- Set methods ------------------------------------ // /** * Sets the count of bots true. Bot accesses will also be shown in the statistics * * @access public */ function setCountBots(){ $this->countBots = true; } // end method /** * Sets the access values on database for calling remote. * set param true if you want to add the table (if not exists). * * @access public * @param boolean $addTable * @return true if log was affective */ function setAccess($addTable = true){ $ret = true; $sql = "UPDATE tabuseronline SET "; $sql .= "usoVisits = if(usoLastAccess < DATE_SUB(now(), INTERVAL ".$this->m_onlineTime." MINUTE), (usoVisits + 1), usoVisits),"; $sql .= "usoHits = (usoHits + 1),"; $sql .= "usoUseragent = '".$this->m_usoUseragent."',"; $sql .= "usoLastAccess = now() "; $sql .= "WHERE DATE_FORMAT(usoDay, '%Y%m%d') = ".date("Ymd"); $sql .= " AND usoIP = '".$this->m_usoIP."'"; $this->_sendSql($sql); $affRows = mysql_affected_rows(); if(mysql_errno() == $this->tableDoesNotExistError){ $ret = false; if($addTable){ if($this->_addAllTables()){ if($this->_addAccess()){ $ret = true; } } } } elseif($affRows == 0){ // if new remote on current day, create a new record with initial values if(!$this->_addAccess()){ $ret = false; } } return $ret; } // end method /** * Sets the userAgent to the botlist. * set param true if you want to add the table (if not exists). * * @access public * @param boolean $addTable * @return true if set was affective */ function setBot($userAgent, $addTable = true){ $ret = true; $sql = "UPDATE tabbotlist SET "; $sql .= "botState = 'active',"; $sql .= "botModdate = now() "; $sql .= "WHERE botUseragent = '".$userAgent."'"; $this->_sendSql($sql); $affRows = mysql_affected_rows(); if(mysql_errno() == $this->tableDoesNotExistError){ $ret = false; if($addTable){ if($this->_addAllTables()){ if($this->_addToBotList($userAgent)){ $ret = true; } } } } elseif($affRows == 0){ if(!$this->_addToBotList($userAgent)){ $ret = false; } } return $ret; } // end method // ----------------------------- Add methods ------------------------------------ // /** * Puts a new user access to the list (first access of the day). * * @access private * @return boolean true if INSERT was successful */ function _addAccess(){ $ret = true; $sql = "INSERT INTO tabuseronline (usoDay, usoIP, usoHost, usoUseragent, usoLastAccess) VALUES ("; $sql .= "now(),'".$this->m_usoIP."','".$this->m_usoHost."','".$this->m_usoUseragent."',now())"; $this->_sendSql($sql); if(mysql_affected_rows() < 1){ $ret = false; } return $ret; } // end method /** * Puts a new bot to the botlist. * * @access private * @param mixed $userAgent * @return boolean true if INSERT was successful */ function _addToBotList($userAgent){ $ret = true; $sql = "INSERT INTO tabbotlist (botUseragent, botEnterdate) VALUES ('".$userAgent."',now())"; $this->_sendSql($sql); if(mysql_affected_rows() < 1){ $ret = false; } return $ret; } // end method function _addAllTables(){ $ret = false; if(($this->_addTabuseronline()) && ($this->_addTabbotlist())){ $ret = true; } return $ret; } // end method /** * Creates the table tabuseronline if it does not exist * * @access private * @return true if system was able to create */ function _addTabuseronline(){ $ret = true; $sql = "CREATE TABLE tabuseronline ("; $sql .= "usoId INT(11) NOT NULL auto_increment,"; $sql .= "usoDay DATE NOT NULL,"; $sql .= "usoIP VARCHAR(20) NOT NULL,"; $sql .= "usoHost VARCHAR(100) default NULL,"; $sql .= "usoUseragent VARCHAR(200) default NULL,"; $sql .= "usoVisits INT(11) NOT NULL default '1',"; $sql .= "usoHits INT(11) NOT NULL default '1',"; $sql .= "usoLastAccess DATETIME NOT NULL, "; $sql .= "PRIMARY KEY (usoId),"; $sql .= "UNIQUE KEY uso_unique (usoDay,usoIP)"; $sql .= ") TYPE=MyISAM"; $res = $this->_sendSql($sql); if(!$res){ $ret = false; } return $ret; } // end method /** * Creates the table tabbotlist if it does not exist * * @access private * @return true if system was able to create */ function _addTabbotlist(){ $ret = true; $sql = "CREATE TABLE tabbotlist ("; $sql .= "botId INT(11) NOT NULL auto_increment,"; $sql .= "botUseragent VARCHAR(200) default NULL,"; $sql .= "botState ENUM('active','inactive') default 'active',"; $sql .= "botEnterdate DATETIME NOT NULL,"; $sql .= "botModdate DATETIME default NULL,"; $sql .= "PRIMARY KEY (botId),"; $sql .= "UNIQUE KEY bot_unique (botUseragent)"; $sql .= ") TYPE=MyISAM"; $res = $this->_sendSql($sql); if(!$res){ $ret = false; } return $ret; } // end method // ----------------------------- Remove methods ------------------------------------ // /** * Sets the bot entry to inactive * * @access public * @param boolean $addTable * @return true if log was affective */ function removeBot($botID){ $ret = true; $sql = "UPDATE tabbotlist SET botState = 'inactive',"; $sql .= "botModdate = now() WHERE botId = ".$botID; $this->_sendSql($sql); if(mysql_affected_rows() < 1){ $ret = false; } return $ret; } // end method // ----------------------------- Misc methods ------------------------------------ // /** * Includes all required js files for ajax live monitoring * * @access private * @return code */ function _includeJsFiles() { $ret = ""; $this->jsfilesincluded = true; $ret .= "\n"; $ret .= "\n"; return $ret; } // end method /** * Deletes older specified files * * @access public */ function delOldFiles($directory, $prefix) { if($dir = opendir($directory)) { while($file = readdir($dir)) { if(eregi("^".$prefix,$file)){ unlink($directory.$file); } } } closedir($dir); } // end method /** * Passes the sql query to the mysql database * * @access private * @return result from database */ function _sendSql($sql){ $res = false; $selected = MYSQL_SELECT_DB($this->m_dbName); if($selected){ $res = mysql_query($sql); if (!$res){ //echo mysql_error(); } } return $res; } // end method } // end class ?>db_host = $host; $this->db_name = $dbName; $this->db_user = $user; $this->db_pass = $pass; $this->dbConnect(); } // end constructor /** * builds up a non-persistent connection to database * * @access public */ function dbConnect(){ $this->db_linkId = mysql_connect($this->db_host,$this->db_user,$this->db_pass); } // end method /** * Disconnects the database * * @access public */ function dbDisconnect(){ if(mysql_close($this->db_linkId)){ $this->db_linkId = 0; } } // end method /** * Checks if there is a valid link ID * * @access public * @return boolean true if database is connected */ function isConnected(){ if($this->db_linkId){ return $this->db_linkId; } else{ return false; } } // end method /** * Passes the sql query to the mysql database * * @access public * @return result from database */ function sendSql($sql, $printError = false){ $res = false; $selected = MYSQL_SELECT_DB($this->db_name); if($selected){ $res = mysql_query($sql); if((!$res) && ($printError)){ echo mysql_error(); } } return $res; } // end method } // end class ?>