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');
}
