Example #1
0
 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());
     }
 }