芝麻web文件管理V1.00
编辑当前文件:/home/asmplong/www/ancien-site-2019/site/administrator/components/com_banners/helpers/banners.php
set($action, $user->authorise($action, $assetName)); } return $result; } /** * @return boolean * @since 1.6 */ public static function updateReset() { $user = JFactory::getUser(); $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select('*'); $query->from('#__banners'); $query->where('NOW() >= `reset`'); $query->where('`reset` != '.$db->quote('0000-00-00 00:00:00').' AND `reset`!=NULL'); $query->where('(`checked_out` = 0 OR `checked_out` = '.(int) $db->Quote($user->id).')'); $db->setQuery((string)$query); $rows = $db->loadObjectList(); // Check for a database error. if ($db->getErrorNum()) { JError::raiseWarning(500, $db->getErrorMsg()); return false; } JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR . '/tables'); foreach ($rows as $row) { $purchase_type = $row->purchase_type; if ($purchase_type < 0 && $row->cid) { $client = JTable::getInstance('Client','BannersTable'); $client->load($row->cid); $purchase_type = $client->purchase_type; } if ($purchase_type < 0) { $params = JComponentHelper::getParams('com_banners'); $purchase_type = $params->get('purchase_type'); } switch($purchase_type) { case 1: $reset='0000-00-00 00:00:00'; break; case 2: $reset = JFactory::getDate('+1 year '.date('Y-m-d',strtotime('now')))->toMySQL(); break; case 3: $reset = JFactory::getDate('+1 month '.date('Y-m-d',strtotime('now')))->toMySQL(); break; case 4: $reset = JFactory::getDate('+7 day '.date('Y-m-d',strtotime('now')))->toMySQL(); break; case 5: $reset = JFactory::getDate('+1 day '.date('Y-m-d',strtotime('now')))->toMySQL(); break; } // Update the row ordering field. $query->clear(); $query->update('`#__banners`'); $query->set('`reset` = '.$db->quote($reset)); $query->set('`impmade` = '.$db->quote(0)); $query->set('`clicks` = '.$db->quote(0)); $query->where('`id` = '.$db->quote($row->id)); $db->setQuery((string)$query); $db->query(); // Check for a database error. if ($db->getErrorNum()) { JError::raiseWarning(500, $db->getErrorMsg()); return false; } } return true; } }