function insertVisitor($sessiontime, $ip, $time) { $sessiontime = (int) $sessiontime; $time = (int) $time; // Check session time, insert new record if timeout $db =& JFactory::getDBO(); $query = ' SELECT COUNT(*) FROM #__vvisitcounter '; $query .= ' WHERE ip=' . $db->quote($ip); $query .= ' AND (tm + ' . $db->quote($sessiontime) . ') > ' . $db->quote($time); $db->setQuery($query); $items = $db->loadResult(); if ($db->getErrorNum()) { modVisitCounterHelper::createTable(); } if (empty($items)) { $query = " INSERT INTO #__vvisitcounter (id, tm, ip) "; $query .= " VALUES ('', " . $db->quote($time) . ", " . $db->quote($ip) . ")"; $db->setQuery($query); $db->query(); } if ($db->getErrorNum()) { JError::raiseWarning(500, $db->stderr()); } }