function scheduled_events_update_category_counts($last_run) { $API = new PerchAPI(1.0, 'perch_events'); $Categories = new PerchEvents_Categories(); $Categories->update_event_counts(); return array('result' => 'OK', 'message' => 'Event category counts updated.'); }
<?php $Events = new PerchEvents_Events($API); $Categories = new PerchEvents_Categories($API); $HTML = $API->get('HTML'); $Form = $API->get('Form'); $Form->set_name('delete'); $message = false; if (isset($_GET['id']) && $_GET['id'] != '') { $Event = $Events->find($_GET['id']); } else { PerchUtil::redirect($API->app_path()); } if ($Form->submitted()) { if (is_object($Event)) { $Event->delete(); $Categories->update_event_counts(); if ($Form->submitted_via_ajax) { echo $API->app_path() . '/'; exit; } else { PerchUtil::redirect($API->app_path() . '/'); } } else { $message = $HTML->failure_message('Sorry, that event could not be deleted.'); } } $details = $Event->to_array();
<?php // Prevent running directly: if (!defined('PERCH_DB_PREFIX')) { exit; } $API = new PerchAPI(1.0, 'perch_events'); $Settings = $API->get('Settings'); if ($Settings->get('perch_events_update')->val() != '1.8') { $db = $API->get('DB'); $sql = "ALTER TABLE `" . PERCH_DB_PREFIX . "events` ADD FULLTEXT idx_search (`eventTitle`, `eventDescRaw`)"; $db->execute($sql); $sql = "ALTER TABLE `" . PERCH_DB_PREFIX . "events_categories` ADD `categoryEventCount` INT(0) UNSIGNED NOT NULL DEFAULT '0' AFTER `categorySlug`"; $db->execute($sql); $sql = "ALTER TABLE `" . PERCH_DB_PREFIX . "events_categories` ADD `categoryFutureEventCount` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `categoryEventCount`"; $db->execute($sql); $sql = "ALTER TABLE `" . PERCH_DB_PREFIX . "events_categories` ADD `categoryDynamicFields` TEXT NULL AFTER `categoryFutureEventCount`"; $db->execute($sql); $Cats = new PerchEvents_Categories($API); $Cats->update_event_counts(); $Settings->set('perch_events_update', '1.8'); }