Invision Power Services, Inc. * @copyright (c) Invision Power Services, Inc. * @license https://www.invisioncommunity.com/legal/standards/ * @package Invision Community * @subpackage Content * @since 11 Dec 2015 */ namespace IPS\cms\tasks; /* To prevent PHP errors (extending class does not exist) revealing path */ use IPS\cms\Databases; use IPS\cms\Pages\Page; use IPS\cms\Records; use IPS\Db; use IPS\Task; use IPS\Task\Exception; use OutOfRangeException; use function defined; use function in_array; if ( !defined( '\IPS\SUITE_UNIQUE_KEY' ) ) { header( ( $_SERVER['SERVER_PROTOCOL'] ?? 'HTTP/1.0' ) . ' 403 Forbidden' ); exit; } /** * updaterecords Task */ class updaterecords extends Task { /** * Execute * * If ran successfully, should return anything worth logging. Only log something * worth mentioning (don't log "task ran successfully"). Return NULL (actual NULL, not '' or 0) to not log (which will be most cases). * If an error occurs which means the task could not finish running, throw an \IPS\Task\Exception - do not log an error as a normal log. * Tasks should execute within the time of a normal HTTP request. * * @return mixed Message to log or NULL * @throws Exception */ public function execute() : mixed { foreach( Databases::databases() as $database ) { $recordClass = 'IPS\cms\Records' . $database->id; /* @var $recordClass Records */ $fixedFields = $database->fixed_field_perms; if ( ! in_array( 'record_expiry_date', array_keys( $fixedFields ) ) ) { continue; } /* Check the database is placed on a valid page */ try { Page::loadByDatabaseId( $database->id ); } catch( OutOfRangeException $ex ) { continue; } $permissions = $fixedFields['record_expiry_date']; if ( ! empty( $permissions['visible'] ) ) { foreach( Db::i()->select( '*', $recordClass::$databaseTable, array( 'record_expiry_date > 0 and record_expiry_date <= ? and record_approved=1', time() ),'primary_id_field ASC', 250 ) as $row ) { $record = $recordClass::constructFromData( $row ); $record->hide( FALSE ); } } } return NULL; } /** * Cleanup * * If your task takes longer than 15 minutes to run, this method * will be called before execute(). Use it to clean up anything which * may not have been done * * @return void */ public function cleanup() { } }