SproutCMS

/config/require_ssl.php   Highlighted file source

Line 21: * If you have a cert, it's probably not a bad idea to protect dbtools too

/config/super_ops.php   Highlighted file source

Line 3: 'chris' => ['uid' => 100000, 'hash' => '$2y$12$AXlkoYo5QoaTD42.iLhQVur1vhJlmSmPWpnFTFJMDdwnOjzRY9skG', 'salt' => 'FMRe'],

/index.php   Highlighted file source

Line 24: // information is provided when errors occur, among other things.
Line 46: // The timezone is explicitly set to avoid warnings from bad server configuration

/modules/Demo/Controllers/Admin/DemoItemAdminController.php   Highlighted file source

Line 16: use InvalidArgumentException;
Line 92: * Saves the provided POST data into a new record in the database
Line 94: * @param int $item_id After saving, the new record id will be returned in this parameter
Line 97: public function _addSave(&$item_id)
Line 99: return parent::_addSave($item_id);
Line 107: protected function _editPreRender($view, $item_id)
Line 109: parent::_editPreRender($view, $item_id);
Line 117: public function _getEditSubActions($item_id)
Line 119: $actions = parent::_getEditSubActions($item_id);
Line 128: * @param int $item_id The record to save
Line 131: public function _editSave($item_id)
Line 133: $item_id = (int) $item_id;
Line 134: if ($item_id <= 0) throw new InvalidArgumentException('$item_id must be greater than 0');
Line 136: return parent::_editSave($item_id);
Line 147: if (!empty($_GET['id'])) {
Line 148: $q = "SELECT name AS label FROM ~words WHERE id = ?";
Line 149: $res = Pdb::q($q, [$_GET['id']], 'arr');
Line 153: $q = "SELECT id, name AS value
Line 168: $q = "SELECT id, CONCAT('#', id, ' - ', name) AS value

/modules/Demo/Controllers/DemoController.php   Highlighted file source

Line 16: use InvalidArgumentException;
Line 47: throw new InvalidArgumentException();
Line 73: $skin = new View('skin/wide');

/modules/Demo/views/admin/demo_item_delete.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/modules/Demo/views/steps/details.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 28: Form::nextFieldDetails('How did you hear about us?', false);

/modules/Demo/views/steps/phone.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/modules/HarborAndSprout/Helpers/GoogleDriveApi.php   Highlighted file source

Line 31: * @return void Redirects
Line 39: 'client_id' => $config['client_id'],
Line 63: 'client_id' => $config['client_id'],
Line 73: if (empty($resp['access_token'])) $errors[] = 'Did not receive "access_token" field';
Line 74: if (empty($resp['refresh_token'])) $errors[] = 'Did not receive "refresh_token" field';
Line 93: * @return void
Line 103: 'client_id' => $config['client_id'],

/modules/HomePage/Controllers/Admin/HomePageAdminController.php   Highlighted file source

Line 34: * Return the fields to show in the sidebar when adding or editing a record.
Line 44: public function _identifier(array $row)
Line 46: return Pdb::q("SELECT name FROM ~subsites WHERE id = ?", [$row['subsite_id']], 'val');
Line 80: public function _addSave(&$id) { return null; }

/modules/HomePage/Helpers/HomePages.php   Highlighted file source

Line 27: * @param int $subsite_id Sub-site record ID. Default of zero/auto
Line 31: public static function getForSubSite($subsite_id = 0)
Line 33: $subsite_id = (int) $subsite_id;
Line 34: if ($subsite_id < 1) $subsite_id = SubsiteSelector::$subsite_id;
Line 38: WHERE home.subsite_id = ?";
Line 40: return Pdb::query($q, [$subsite_id], 'row');
Line 47: * @param int $homepage_id Home page record ID
Line 51: public static function getActiveBanners($homepage_id, $limit = 0)
Line 65: ON file.id = banner.file_id
Line 68: AND banner.homepage_id = ?
Line 70: banner.id
Line 76: return Pdb::query($q, [$homepage_id], 'arr');
Line 83: * @param int $homepage_id Home page record ID
Line 87: public static function getActivePromos($homepage_id, $limit)
Line 101: ON file.id = promo.file_id
Line 104: AND promo.homepage_id = ?
Line 106: promo.id
Line 112: return Pdb::query($q, [$homepage_id], 'arr');
Line 119: * @param int $homepage_id Home page record ID
Line 123: public static function getRandomActiveBanner($homepage_id)
Line 135: ON file.id = banner.file_id
Line 138: AND banner.homepage_id = ?
Line 140: banner.id
Line 145: return Pdb::query($q, [$homepage_id], 'row');

/modules/Welcome/config/routes.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/modules/Welcome/Controllers/WelcomeController.php   Highlighted file source

Line 38: use Sprout\Helpers\Validator;
Line 280: $_SESSION['db_conf']['field_values'] = Validator::trim($_POST);
Line 282: $valid = new Validator($_POST);
Line 283: $valid->required(['production', 'host', 'user', 'pass', 'database']);
Line 285: if ($valid->hasErrors()) {
Line 286: $_SESSION['db_conf']['field_errors'] = $valid->getFieldErrors();
Line 497: * @return void Echos directly
Line 507: $config .= "' => ['uid' => {$user['uid']}, " . "'hash' => '" . Enc::html(Enc::js($user['hash']));
Line 548: * @return void Redirects
Line 552: $_SESSION['super_op']['field_values'] = Validator::trim($_POST);
Line 554: $valid = new Validator($_POST);
Line 555: $valid->required(['username', 'password1', 'password2']);
Line 556: $valid->check('username', 'Validity::length', 0, 50);
Line 559: $valid->check('username', 'Validity::uniqueValue', 'operators', 'username', 0, 'An operator already exists with that username');
Line 561: Notification::error('Please configure Database - Step 1 of checklist. It\'s required for validation!');
Line 565: $valid->check('username', 'Validity::regex', '/^[a-zA-Z0-9]+$/');
Line 566: $valid->check('password1', 'Validity::length', 8, 60);
Line 567: $valid->check('password2', 'Validity::length', 8, 60);
Line 568: $valid->multipleCheck(['password1', 'password2'], 'Validity::allMatch');
Line 573: $valid->addFieldError('password1', 'Not complex enough');
Line 574: $valid->addFieldError('password2', 'Not complex enough');
Line 583: if ($valid->hasErrors()) {
Line 584: $_SESSION['super_op']['field_errors'] = $valid->getFieldErrors();
Line 658: Pdb::query("DELETE FROM ~page_widgets", [], 'null');
Line 681: $cat_id = Pdb::insert('files_cat_list', $data);
Line 683: $file_id = 0;
Line 687: $file_id += 1;
Line 692: $data['id'] = $file_id;
Line 694: $data['filename'] = "{$file_id}_{$filename}";
Line 703: $data['file_id'] = $file_id;
Line 704: $data['cat_id'] = $cat_id;
Line 707: File::putExisting("{$file_id}_{$filename}", $orig);
Line 709: File::postUploadProcessing("{$file_id}_{$filename}", $file_id, FileConstants::TYPE_IMAGE);
Line 722: $page_id = 0;
Line 728: $page_id += 1;
Line 731: $parent_id = $parent_lookup[(string)$elem['parent']];
Line 733: $parent_id = 0;
Line 737: $data['id'] = $page_id;
Line 738: $data['parent_id'] = $parent_id;
Line 739: $data['subsite_id'] = 1;
Line 748: $parent_lookup[$name] = $page_id;
Line 751: $data['page_id'] = $page_id;
Line 758: $revision_id = Pdb::insert('page_revisions', $data);
Line 761: $data['page_revision_id'] = $revision_id;
Line 762: $data['area_id'] = 1;
Line 767: Pdb::insert('page_widgets', $data);
Line 779: . '<p>This being said, the ownership issues inherent in dominant thematic implementations cannot be understated</p>';
Line 780: Pdb::update('homepages', $data, ['id' => 1]);
Line 783: $data['homepage_id'] = 1;
Line 785: $data['file_id'] = 1;
Line 793: $data['homepage_id'] = 1;
Line 796: $data['file_id'] = 2;
Line 803: $data['homepage_id'] = 1;
Line 806: $data['file_id'] = 3;
Line 814: $data['homepage_id'] = 1;
Line 817: $data['file_id'] = 4;

/modules/Welcome/views/db_conf_form.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 23: max-width: 900px;

/modules/Welcome/views/phpinfo.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 23: max-width: 1200px;
Line 35: <table width="600" cellpadding="3" border="0">

/modules/Welcome/views/super_op_result.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 24: max-width: 1200px;
Line 53: echo "' => ['uid' => {$user['uid']}, 'hash' => '", Enc::html(Enc::js($user['hash']));

/skin/default/config/sprout.php   Highlighted file source

Line 35: * Image gallery widget
Line 43: 'slider_size' => 'c800x450'
Line 89: * Specify the number of nav groups for each top-level page id
Line 91: * Syntax is page_id => num_groups / columns
Line 112: * Override the dropdown logic for a given top-level page in the mega menu
Line 114: * Key Top-level page id
Line 135: $config['admin_richtext_width'] = 700;
Line 141: * 1 - no slideout
Line 142: * 2 - single level of slideout
Line 143: * 3 - two levels of slideout
Line 154: $config['related_heading'] = '<h3 class="widget-title">SECTION</h3>';
Line 158: * Widget heading/title
Line 160: * Anywhere where the string TITLE is found, it will be replaced with the user given widget heading
Line 162: $config['widget_title'] = '<h2 class="widget-title">TITLE</h2>';
Line 185: * The profile id of this site in Google Analytics
Line 188: $config['google_analytics_id'] = '';
Line 209: 'skin/wide' => 'Full-width',
Line 220: * Widget wrapper templates
Line 222: * Your partial must contain HTML with the merge tag: {{widget}}
Line 223: * to be replaced with the actual widget's HTML
Line 225: $config['widget_templates'] = array(

/skin/default/exception.php   Highlighted file source

Line 12: #main {width: 600px; margin: 0 auto; padding: 0;}
Line 14: img {margin: 0; width: 227px; height: 300px; margin: 0 auto; display:block;background:url(data:image/gif;base64,R0lGODlhBQAEAKEBAAAAAP%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FyH5BAEKAAIALAAAAAAFAAQAAAIHDBypBncJCgA7) 50% 50% no-repeat;}
Line 20: <div id="main">
Line 22: <img src="<?php echo Sprout::absRoot(); ?>media/images/system_error3.jpg" width="227" height="300">
Line 23: <div id="nice">
Line 25: <p>When reporting this error, quote the code <?php echo 'SE' . str_pad($log_id, 5, '0', STR_PAD_LEFT); ?>.</p>
Line 27: <div id="tech">

/skin/default/inner.php   Highlighted file source

Line 12: use Sprout\Helpers\Widgets;
Line 38: <?php Skin::css('normalize', 'flexboxgrid', 'global', 'frankenmenu'); ?>
Line 48: <div id="wrap">
Line 49: <a class="-vis-hidden" href="#content">Skip to Content</a>
Line 53: <div id="content" class="section section--content bg-white">
Line 78: <div class="sidebar">
Line 80: <?php echo Widgets::renderArea('sidebar'); ?>

/skin/default/partials/_google_analytics.php   Highlighted file source

Line 5: $analytics_id = Kohana::config('sprout.google_analytics_id');
Line 12: } else if (!$analytics_id or AdminAuth::isLoggedIn()) {
Line 24: ga('create', '<?php echo $analytics_id; ?>', 'auto');

/skin/default/partials/_meta-data.php   Highlighted file source

Line 10: <meta name="viewport" content="width=device-width, initial-scale=1">

/skin/default/popup.php   Highlighted file source

Line 4: <div id="popup-wrap">

/skin/harbor/config/sprout.php   Highlighted file source

Line 35: * Image gallery widget
Line 43: 'slider_size' => 'c800x450'
Line 89: * Specify the number of nav groups for each top-level page id
Line 91: * Syntax is page_id => num_groups / columns
Line 112: * Override the dropdown logic for a given top-level page in the mega menu
Line 114: * Key Top-level page id
Line 135: $config['admin_richtext_width'] = 700;
Line 141: * 1 - no slideout
Line 142: * 2 - single level of slideout
Line 143: * 3 - two levels of slideout
Line 154: $config['related_heading'] = '<h3 class="widget-title">SECTION</h3>';
Line 158: * Widget heading/title
Line 160: * Anywhere where the string TITLE is found, it will be replaced with the user given widget heading
Line 162: $config['widget_title'] = '<h2 class="widget-title">TITLE</h2>';
Line 185: * The profile id of this site in Google Analytics
Line 188: $config['google_analytics_id'] = '';
Line 209: 'skin/wide' => 'Full-width',
Line 214: * Widget wrapper templates
Line 216: * Your partial must contain HTML with the merge tag: {{widget}}
Line 217: * to be replaced with the actual widget's HTML
Line 219: $config['widget_templates'] = array(

/skin/harbor/_meta-data.php   Highlighted file source

Line 10: <meta name="viewport" content="width=device-width, initial-scale=1">

/skin/unavailable/coming_soon.php   Highlighted file source

Line 11: <meta name="viewport" content="width=device-width, initial-scale=1">

/sprout/cli_bootstrap.php   Highlighted file source

Line 23: // These are identical to those in .htaccess and nginx.conf.

/sprout/config/admin_seo.php   Highlighted file source

Line 74: "becomes", "becoming", "been", "before", "beforehand", "behind", "being", "below", "beside", "besides", "between", "beyond",
Line 86: "side", "since", "sincere", "six", "sixty", "so", "some", "somehow", "someone", "something", "sometime", "sometimes", "somewhere",

/sprout/config/cache_memcache.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/sprout/config/config.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 66: * server bandwidth usage, at the cost of slightly higher CPU usage. Set to

/sprout/config/database.php   Highlighted file source

Line 41: // accidently become public), it's much better to include this in
Line 42: // a separate file, preferably outside of DOCROOT.

/sprout/config/file.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 26: * ResizeImageTransform ( width , height )
Line 27: * CropImageTransform ( width , height , top_pos = 'center' , left_pos = 'center')
Line 29: * Transformations get applied in the order they are provided in the array.

/sprout/config/inflector.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/sprout/config/mimes.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 25: * expected MIME type, as well as any additional information you can provide.
Line 37: 'asf' => array('video/x-ms-asf'),
Line 38: 'asr' => array('video/x-ms-asf'),
Line 39: 'asx' => array('video/x-ms-asf'),
Line 41: 'avi' => array('video/avi', 'video/msvideo', 'video/x-msvideo'),
Line 60: 'divx' => array('video/divx'),
Line 74: 'flc' => array('video/flc'),
Line 75: 'fli' => array('video/fli'),
Line 76: 'flv' => array('video/x-flv'),
Line 106: 'm4p' => array('video/mp4v-es'),
Line 107: 'm4v' => array('video/mp4'),
Line 110: 'midi' => array('audio/midi'),
Line 111: 'mid' => array('audio/midi'),
Line 114: 'mkv' => array('video/x-matroska'),
Line 115: 'mov' => array('video/quicktime'),
Line 116: 'movie' => array('video/x-sgi-movie'),
Line 119: 'mp4' => array('application/mp4','audio/mp4','video/mp4'),
Line 120: 'mpa' => array('video/mpeg'),
Line 121: 'mpe' => array('video/mpeg'),
Line 122: 'mpeg' => array('video/mpeg'),
Line 123: 'mpg' => array('video/mpeg'),
Line 124: 'mpg4' => array('video/mp4'),
Line 127: 'mpv' => array('video/x-matroska'),
Line 128: 'mpv2' => array('video/mpeg'),
Line 145: 'ogv' => array('video/ogg'),
Line 173: 'qt' => array('video/quicktime'),
Line 183: 'rv' => array('video/vnd.rn-realvideo'),
Line 211: 'wm' => array('video/x-ms-wm'),
Line 215: 'wmv' => array('video/x-ms-wmv', 'application/octet-stream'),
Line 216: 'wmx' => array('video/x-ms-wmx'),
Line 221: 'wvx' => array('video/x-ms-wvx'),
Line 236: 'xvid' => array('video/x-xvid'),

/sprout/config/require_ssl.php   Highlighted file source

Line 6: * @author David Cruz
Line 7: * @copyright (c) 2009 David Cruz

/sprout/config/session.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
Line 36: * Session parameters to validate: userAgent, ip_address, expiration.
Line 38: $config['validate'] = array();
Line 54: * Number of page loads before the session id is regenerated.
Line 55: * A value of 0 will disable automatic session id regeneration.

/sprout/config/upload.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/sprout/config/view.php   Highlighted file source

Line 3: * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;

/sprout/Controllers/Admin/CategoryAdminController.php   Highlighted file source

Line 29: use Sprout\Helpers\Validator;
Line 107: * Return the fields to show in the sidebar when adding or editing a record.
Line 159: * Saves the provided POST data into a new record in the database
Line 161: * @param int $item_id After saving, the new record id will be returned in this parameter
Line 164: public function _addSave(&$item_id)
Line 168: $valid = new Validator($_POST);
Line 169: $valid->required(['name']);
Line 170: $valid->check('name', 'Validity::length', 0, 50);
Line 171: if ($valid->hasErrors()) {
Line 172: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 173: $valid->createNotifications();
Line 183: $item_id = Pdb::insert($this->table_name, $update_fields);
Line 194: * @param int $id The id of the record to get the edit form of
Line 196: public function _getEditForm($id)
Line 198: if (! $this->parent_inst->catAllowEdit($id)) {
Line 203: $id = (int) $id;
Line 206: $q = "SELECT * FROM ~{$this->table_name} WHERE id = ?";
Line 207: $item = Pdb::query($q, [$id], 'row');
Line 219: $view->id = $id;
Line 229: $this->_editPreRender($view, $id);
Line 232: 'title' => 'Editing ' . Enc::html(Inflector::singular($this->friendly_name)) . ' <strong>' . Enc::html($this->_identifier($item)) . '</strong>',
Line 239: * Saves the provided POST data the specified record
Line 241: * @param int $item_id The record to update
Line 244: public function _editSave($item_id)
Line 246: if (! $this->parent_inst->catAllowEdit($item_id)) {
Line 248: Url::redirect('admin/edit/' . $this->controller_name . '/' . $item_id);
Line 251: $item_id = (int) $item_id;
Line 253: // Validate
Line 254: $valid = new Validator($_POST);
Line 255: $valid->required(['name']);
Line 256: $valid->check('name', 'Validity::length', 0, 50);
Line 257: if ($valid->hasErrors()) {
Line 259: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 260: $valid->createNotifications();
Line 275: Pdb::update($this->table_name, $update_fields, ['id' => $item_id]);
Line 287: * @param int $id The category id
Line 289: public function _getDeleteForm($id)
Line 291: if (! $this->parent_inst->catAllowDelete($id)) {
Line 301: $q = "SELECT * FROM ~{$cat_table} WHERE id = ?";
Line 302: $category = Pdb::q($q, [$id], 'row');
Line 304: $q = "SELECT COUNT(main.id) AS C
Line 306: INNER JOIN ~{$joiner_table} AS joiner ON joiner.{$main_controller}_id = main.id
Line 307: WHERE joiner.cat_id = ?";
Line 308: $num_in_cat = Pdb::q($q, [$id], 'val');
Line 315: $view->id = $id;
Line 328: * @param int $id The record to delete
Line 331: public function _deleteSave($id)
Line 333: $id = (int) $id;
Line 335: if (! $this->parent_inst->catAllowDelete($id)) {
Line 337: Url::redirect('admin/delete/' . $this->controller_name . '/' . $id);
Line 350: $q = "SELECT main.id
Line 352: INNER JOIN ~{$joiner_table} AS joiner ON joiner.{$main_controller}_id = main.id
Line 353: WHERE joiner.cat_id = ?
Line 354: ORDER BY main.id";
Line 355: $res = Pdb::q($q, [$id], 'col');
Line 357: foreach ($res as $row_id) {
Line 358: $res = $this->parent_inst->_deleteSave($row_id);
Line 364: $this->deleteRecord($this->table_name, $id);
Line 368: Pdb::delete($joiner_table, ['cat_id' => $id]);
Line 379: public function _extraReorder($category_id)
Line 381: $category_id = (int) $category_id;
Line 392: $q = "SELECT * FROM ~{$this->table_name} WHERE id = ?";
Line 394: $page = Pdb::q($q, [$category_id], 'row');
Line 396: return new AdminError('Invalid id specified - category does not exist');
Line 403: ON item.id = joiner.{$item_name}_id
Line 404: WHERE joiner.cat_id = ?
Line 406: $items = Pdb::q($q, [$category_id], 'arr');
Line 413: $item['name'] = $this->parent_inst->_identifier($item);
Line 418: $view->id = $category_id;
Line 431: public function reorderSave($category_id)
Line 433: $category_id = (int) $category_id;
Line 448: foreach ($_POST['items'] as $id) {
Line 449: $id = (int) $id;
Line 451: $where = ['cat_id' => $category_id, "{$item_name}_id" => $id];
Line 458: Url::redirect("admin/contents/{$item_name}?_category_id={$category_id}");
Line 474: $q = "SELECT id, name FROM ~{$this->table_name} ORDER BY record_order, name";
Line 505: foreach ($_POST['items'] as $id) {
Line 506: $id = (int) $id;
Line 508: Pdb::update($this->table_name, ['record_order' => $record_order], ['id' => $id]);
Line 522: public function ajaxArchiveAction($category_id)
Line 528: Pdb::update($this->table_name, $data, ['id' => $category_id]);
Line 537: public function ajaxUnarchiveAction($category_id)
Line 543: Pdb::update($this->table_name, $data, ['id' => $category_id]);

/sprout/Controllers/Admin/CronJobAdminController.php   Highlighted file source

Line 22: use Sprout\Helpers\RefineWidgetSelect;
Line 23: use Sprout\Helpers\RefineWidgetTextbox;
Line 58: $this->refine_bar->addWidget(new RefineWidgetTextbox('name', 'Name'));
Line 59: $this->refine_bar->addWidget(new RefineWidgetSelect('status', 'Status', array('Incomplete', 'Complete')));
Line 81: * Return the fields to show in the sidebar when adding or editing a record.
Line 95: public function _addSave(&$item_id) { return false; }
Line 96: public function _editSave($item_id) { return false; }
Line 159: // Instance class - this may throw an exception if class not found or invalid

/sprout/Controllers/Admin/EmailTextAdminController.php   Highlighted file source

Line 18: use Sprout\Helpers\Validator;
Line 54: public function _addSave(&$item_id)
Line 63: protected function _editPreRender($view, $item_id)
Line 65: parent::_editPreRender($view, $item_id);
Line 75: public function _getEditSubActions($item_id)
Line 77: $actions = parent::_getEditSubActions($item_id);
Line 84: * Saves the provided POST data the specified record
Line 89: public function _editSave($id)
Line 91: $id = (int) $id;
Line 93: $_SESSION['admin']['field_values'] = Validator::trim($_POST);
Line 95: // Validate form fields
Line 96: $valid = new Validator($_POST);
Line 97: $valid->required(['text']);
Line 98: $valid->check('text', 'Validity::length', 0, 5000);
Line 99: if ($valid->hasErrors()) {
Line 100: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 101: $valid->createNotifications();
Line 112: $logdata = $this->loadRecord($this->table_name, $id);
Line 114: Pdb::update($this->table_name, $update_fields, ['id' => $id]);
Line 116: $this->logEdit($this->table_name, $id, $logdata);

/sprout/Controllers/Admin/FileAdminController.php   Highlighted file source

Line 43: use Sprout\Helpers\RefineWidgetSelect;
Line 44: use Sprout\Helpers\RefineWidgetTextbox;
Line 52: use Sprout\Helpers\Validator;
Line 92: $this->refine_bar->addWidget(new RefineWidgetTextbox('name', 'Name'));
Line 93: $this->refine_bar->addWidget(new RefineWidgetSelect('type', 'Type', FileConstants::$type_names));
Line 94: $this->refine_bar->addWidget(new RefineWidgetTextbox('filename', 'Filename'));
Line 97: $this->refine_bar->addWidget(new RefineWidgetSelect('document_type', 'Document Type', Pdb::lookup('document_types')));
Line 99: $this->main_modes['thumb'] = array('Thumbnails', 'grid');
Line 106: * Return the fields to show in the sidebar when adding or editing a record.
Line 115: $file_id = Admin::getRecordId();
Line 116: $file = !empty($file_id) ? Pdb::get('files', $file_id) : null;
Line 129: * These may be false if the UI provides its own save mechanism (e.g. multi-add)
Line 165: * @return void Outputs JSON
Line 170: Json::error('Invalid "index" param');
Line 173: Json::error('Invalid "code" param');
Line 199: * Other keys provided are passed to the ajaxDragdropForm method.
Line 203: * @return void Outputs JSON
Line 208: Json::error('Invalid "num" param');
Line 211: Json::error('Invalid "code" param');
Line 294: * @return void Outputs HTML
Line 340: if ($view->shrunk_img['original_width'] > $max_dims['width']) {
Line 358: $view->data['category_id'] = key($view->categories);
Line 359: } else if (!empty($_GET['form']['category_id'])) {
Line 360: $view->data['category_id'] = $_GET['form']['category_id'];
Line 363: $q = "SELECT id, name
Line 380: * @return void Outputs JSON
Line 433: $file_id = Pdb::insert('files', $update_fields);
Line 438: $filename = $file_id . '_' . File::filenameMakeSane($_POST['orig_name']);
Line 440: // Filename is only set after upload because the ID is in the name
Line 444: Pdb::update('files', $update_fields, ['id' => $file_id]);
Line 450: if (!empty($_POST['category_id'])) {
Line 451: Category::insertInto('files', $file_id, $_POST['category_id']);
Line 460: if ($size[0] > $max_dims['width'] or $size[1] > $max_dims['height']) {
Line 464: $img->resize($max_dims['width'], $max_dims['height']);
Line 483: File::postUploadProcessing($filename, $file_id, $type);
Line 491: $html .= '<p class="file-upload__item__feedback__name"><a href="admin/edit/file/' . $file_id . '" target="_blank">' . Enc::html($filename) . '</a></p>';
Line 497: 'file_id' => $file_id,
Line 506: * May receive two different variations on the provided POST data:
Line 510: * @return void
Line 522: * @return void Outputs JSON directly (see {@see Json::out})
Line 549: public function _addSave(&$item_id)
Line 560: Json::out(array('valid' => 0, 'error' => $message));
Line 577: $result = $this->doUpload(@$_POST['category_id']);
Line 585: * @param int $category_id ID of category to store file in
Line 587: private function doUpload($category_id)
Line 589: $category_id = (int) $category_id;
Line 591: // Check upload exists and has valid metadata
Line 645: $file_id = Pdb::insert('files', $update_data);
Line 656: $category_id = Category::create('files', $_POST['category_new']);
Line 663: if ($category_id) {
Line 665: Category::insertInto('files', $file_id, $category_id);
Line 671: // Upload the file - uses the file id
Line 672: $filename = $file_id . '_' . $filename;
Line 680: File::postUploadProcessing($filename, $file_id, $file_type);
Line 689: 'id' => $file_id,
Line 692: 'cat_id' => $category_id,
Line 701: public function _editPreRender($view, $item_id)
Line 743: public function _getEditSubActions($item_id)
Line 745: $actions = parent::_getEditSubActions($item_id);
Line 748: 'url' => 'admin/extra/' . $this->controller_name . '/find_usage/' . $item_id,
Line 758: * Saves the provided POST data into this file in the database
Line 760: * @param int $item_id The record to update
Line 764: public function _editSave($item_id)
Line 766: $item_id = (int) $item_id;
Line 768: $file = Pdb::get('files', $item_id);
Line 770: $_SESSION['admin']['field_values'] = Validator::trim($_POST);
Line 772: $valid = new Validator($_POST);
Line 773: $valid->required(['name']);
Line 774: $valid->check('name', 'Validity::length', 1, 200);
Line 775: $valid->check('description', 'Validity::length', 1, 10000);
Line 776: $valid->check('author', 'Validity::length', 1, 80);
Line 779: // Check upload is valid
Line 780: if (!Upload::valid($_FILES['replace'])) {
Line 782: $valid->addFieldError('replace', 'File upload failed');
Line 789: $valid->addFieldError('replace', 'File must be of type: ' . FileConstants::$type_names[$file['type']]);
Line 793: if ($valid->hasErrors()) {
Line 794: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 795: $valid->createNotifications();
Line 805: $new_filename = $item_id . '_' . File::filenameMakeSane($_FILES['replace']['name']);
Line 862: throw new Exception('Invalid image manipulation "' . $_POST['manipulate'] . '"');
Line 934: Pdb::update('files', $data, ['id' => $item_id]);
Line 936: $this->reindexItem($item_id, $_POST['name'], $file['plaintext'], $data['enable_indexing']);
Line 944: $this->updateCategories($item_id, @$_POST['categories']);
Line 958: $new_path = 'file/download/' . $item_id;
Line 1002: * @param int $item_id The record to delete
Line 1006: public function _deleteSave($item_id)
Line 1008: return parent::_deleteSave($item_id);
Line 1015: * @param int $item_id
Line 1021: private function reindexItem($item_id, $name, $plaintext, $enabled = true)
Line 1024: Search::selectIndex('file_keywords', $item_id);
Line 1056: $q = "SELECT id, name, filename, plaintext, enable_indexing FROM ~files";
Line 1068: Pdb::update('files', ['plaintext' => $plain], ['id' => $row['id']]);
Line 1073: $this->reindexItem($row['id'], $row['name'], $plain ?: $row['plaintext'], $row['enable_indexing']);
Line 1090: public function frontEndSearch($item_id, $relevancy, $keywords)
Line 1092: $q = "SELECT name, filename, plaintext, enable_indexing FROM sprout_files WHERE id = ?";
Line 1093: $row = Pdb::q($q, [$item_id], 'row');
Line 1141: * Return the list of sidebar tools
Line 1148: $tools[] = '<li class="config"><a href="admin/extra/file/cleanup_invalid">Cleanup invalid files</a></li>';
Line 1159: * Provides a UI for doing a 'cleanup' - removes invalid files
Line 1161: public function _extraCleanupInvalid()
Line 1163: $view = new View("sprout/admin/file_cleanup_invalid");
Line 1166: $q = "SELECT id, filename, name, type FROM ~files";
Line 1182: 'title' => 'Cleanup invalid files',
Line 1191: public function cleanupInvalidAction()
Line 1197: $this->cleanupInvalidActionInner();
Line 1200: Url::redirect('admin/extra/file/cleanup_invalid');
Line 1211: public function cronCleanupInvalid()
Line 1213: Cron::start('Cleanup invalid files');
Line 1214: $this->cleanupInvalidActionInner();
Line 1220: * Remove invalid files, such as:
Line 1227: private function cleanupInvalidActionInner()
Line 1233: $q = "SELECT id, filename, name, type FROM ~files";
Line 1247: Pdb::delete('files', ['id' => $file['id']]);
Line 1249: Pdb::delete($joiner_table, ['file_id' => $file['id']]);
Line 1298: * The width and height is specified width . 'x' . height (e.g. 200x100)
Line 1352: * @return void
Line 1391: $_GET['category_id'] = (int) $_GET['category_id'];
Line 1397: if ($_GET['category_id'] > 0) {
Line 1399: ON files.id = joiner.file_id AND joiner.cat_id = ?";
Line 1400: $params[] = $_GET['category_id'];
Line 1429: $q = "SELECT COUNT(DISTINCT id) AS C
Line 1437: $q = "SELECT DISTINCT files.id, files.name, files.filename
Line 1464: 'id' => $row['id'],
Line 1522: * @param int $file_id
Line 1525: public function _extraFindUsage($file_id)
Line 1527: $file = Pdb::get('files', $file_id);
Line 1576: * Provide the contents of a temporarily uploaded file, for e.g. listening to uploaded audio
Line 1578: * @return void Sets headers and outputs file content

/sprout/Controllers/Admin/ListAdminController.php   Highlighted file source

Line 32: * id
Line 53: $q = "SELECT id, name FROM ~{$this->table_name} ORDER BY record_order";
Line 61: $view->record_id = (int) Admin::getRecordId();
Line 89: * @param int $item_id The record to delete.
Line 92: final public function _deleteSave($item_id)
Line 94: $item_id = (int) $item_id;
Line 96: if (!$this->_isDeleteSaved($item_id)) return false;
Line 98: $this->deleteRecord($this->table_name, $item_id);
Line 111: $q = "SELECT id, name
Line 141: foreach ($_POST['items'] as $id) {
Line 142: $id = (int) $id;
Line 146: WHERE id = ?";
Line 147: Pdb::q($q, [$record_order, $id], 'count');
Line 152: $this->_invalidateCaches('reorder');
Line 163: * @param int $item_id Record-id to update
Line 165: protected function fixRecordOrder($item_id)
Line 169: WHERE id = ?";
Line 171: $order = Pdb::q($q, [$item_id], 'val');
Line 188: WHERE id = ?";
Line 189: Pdb::q($q, [$order, $item_id], 'count');

/sprout/Controllers/Admin/MySettingsAdminController.php   Highlighted file source

Line 26: use Sprout\Helpers\Validator;
Line 77: * @return void Redirects
Line 82: $_SESSION['admin_my_settings']['field_values'] = Validator::trim($_POST);
Line 84: $valid = new Validator($_POST);
Line 85: $valid->required(['name', 'email']);
Line 86: $valid->check('name', 'Validity::length', 1, 200);
Line 87: $valid->check('email', 'Validity::length', 1, 200);
Line 88: $valid->check('email', 'Validity::email');
Line 89: $valid->multipleCheck(['password1', 'password2'], 'Validity::allMatch');
Line 93: $result = AdminAuth::checkPassword($_POST['old_password'], AdminAuth::getId());
Line 95: $valid->addFieldError('old_password', 'Old password is incorrect');
Line 101: $valid->addFieldError('password1', 'Not complex enough');
Line 102: $valid->addFieldError('password2', 'Not complex enough');
Line 110: if ($valid->hasErrors()) {
Line 111: $_SESSION['admin_my_settings']['field_errors'] = $valid->getFieldErrors();
Line 121: Pdb::update('operators', $data, ['id' => AdminAuth::getId()]);
Line 124: AdminAuth::changePassword($_POST['password1'], AdminAuth::getId());
Line 140: $q = "SELECT tfa_method, username FROM ~operators WHERE id = ?";
Line 141: $operator = Pdb::query($q, [AdminAuth::getLocalId()], 'row');
Line 190: Pdb::update('operators', $data, ['id' => AdminAuth::getLocalId()]);
Line 206: Pdb::update('operators', $data, ['id' => AdminAuth::getLocalId()]);

/sprout/Controllers/Admin/OperatorAdminController.php   Highlighted file source

Line 27: use Sprout\Helpers\Validator;
Line 67: $this->main_where[] = "(SELECT 1 FROM ~operators_cat_join WHERE operator_id = item.id AND cat_id IN ({$cats}) LIMIT 1) = 1";
Line 130: public function _getEditForm($item_id)
Line 132: if (!AdminPerms::canEditOperator($item_id) and $item_id != AdminAuth::getId()) {
Line 136: return parent::_getEditForm($item_id);
Line 143: public function _getDeleteForm($item_id)
Line 145: if (!AdminPerms::canEditOperator($item_id)) {
Line 149: if ($item_id == AdminAuth::getLocalId()) {
Line 153: return parent::_getDeleteForm($item_id);
Line 170: * Saves the provided POST data into a new record in the database
Line 172: * @param int $item_id After saving, the new record id will be returned in this parameter
Line 175: public function _addSave(&$item_id)
Line 179: $_SESSION['admin']['field_values'] = Validator::trim($_POST);
Line 182: $valid = new Validator($_POST);
Line 183: $valid->required(['name', 'email', 'username', 'password1', 'password2']);
Line 184: $valid->check('name', 'Validity::length', 0, 200);
Line 185: $valid->check('email', 'Validity::email');
Line 186: $valid->check('email', 'Validity::length', 0, 200);
Line 187: $valid->check('username', 'Validity::length', 0, 50);
Line 188: $valid->check('username', 'Validity::uniqueValue', 'operators', 'username', 0, 'An operator already exists with that username');
Line 189: $valid->check('username', 'Validity::regex', '/^[a-zA-Z0-9]+$/');
Line 190: $valid->check('password1', 'Validity::length', 8, self::MAX_PASSWORD_LENGTH);
Line 191: $valid->check('password2', 'Validity::length', 8, self::MAX_PASSWORD_LENGTH);
Line 192: $valid->multipleCheck(['password1', 'password2'], 'Validity::allMatch');
Line 194: if ($valid->hasErrors()) {
Line 195: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 220: foreach ($_POST['categories'] as $cat_id) {
Line 221: if (!$this->manage_cats[$cat_id]) {
Line 222: Notification::error('You do not have access to manage category id ' . $cat_id);
Line 243: $item_id = Pdb::insert('operators', $update_fields);
Line 245: $this->logAdd('operators', $item_id);
Line 247: AdminAuth::changePassword($_POST['password1'], $item_id);
Line 250: $this->updateCategories($item_id, $_POST['categories']);
Line 273: protected function _editPreRender($view, $item_id)
Line 275: parent::_editPreRender($view, $item_id);
Line 277: if (AdminAuth::hasDatabaseRecord() and $item_id == AdminAuth::getId()) {
Line 283: foreach ($view->data['categories'] as $cat_id) {
Line 284: if (!$this->manage_cats[$cat_id]) {
Line 285: Notification::error('This operator is in a category you do not have permission to manage - category id ' . $cat_id);
Line 293: * Saves the provided POST data the specified record
Line 295: * @param int $item_id The record to update
Line 298: public function _editSave($item_id)
Line 300: $item_id = (int) $item_id;
Line 302: if (AdminAuth::hasDatabaseRecord() and $item_id == AdminAuth::getId()) {
Line 306: $can_access = AdminPerms::canEditOperator($item_id);
Line 309: $_SESSION['admin']['field_values'] = Validator::trim($_POST);
Line 312: $valid = new Validator($_POST);
Line 313: $valid->required(['username', 'name', 'email']);
Line 314: $valid->check('username', 'Validity::length', 0, 50);
Line 315: $valid->check('username', 'Validity::uniqueValue', 'operators', 'username', $item_id, 'An operator already exists with that username');
Line 316: $valid->check('username', 'Validity::regex', '/^[a-zA-Z0-9]+$/');
Line 317: $valid->check('name', 'Validity::length', 0, 200);
Line 318: $valid->check('email', 'Validity::length', 0, 200);
Line 319: $valid->check('password1', 'Validity::length', 8, self::MAX_PASSWORD_LENGTH);
Line 320: $valid->check('password2', 'Validity::length', 8, self::MAX_PASSWORD_LENGTH);
Line 321: $valid->multipleCheck(['password1', 'password2'], 'Validity::allMatch');
Line 323: if ($valid->hasErrors()) {
Line 324: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 325: $valid->createNotifications();
Line 350: foreach ($_POST['categories'] as $cat_id) {
Line 351: if (!$this->manage_cats[$cat_id]) {
Line 352: Notification::error('You do not have access to manage category id ' . $cat_id);
Line 370: $logdata = $this->loadRecord('operators', $item_id);
Line 372: Pdb::update('operators', $update_fields, ['id' => $item_id]);
Line 374: $this->logEdit('operators', $item_id, $logdata);
Line 377: AdminAuth::changePassword($_POST['password1'], $item_id);
Line 378: $this->logAction('operators', $item_id, 'Change password');
Line 382: $this->updateCategories($item_id, $_POST['categories']);
Line 393: * @param int $item_id The record to delete
Line 394: * @return void
Line 397: public function _deletePreSave($item_id)
Line 399: $item_id = (int) $item_id;
Line 401: if (!AdminPerms::canEditOperator($item_id)) {
Line 405: if ($item_id == AdminAuth::getLocalId()) {

/sprout/Controllers/Admin/PageAdminController.php   Highlighted file source

Line 24: use Sprout\Exceptions\ValidationException;
Line 56: use Sprout\Helpers\RefineWidgetTextbox;
Line 68: use Sprout\Helpers\Validator;
Line 70: use Sprout\Helpers\WidgetArea;
Line 91: $this->refine_bar->addWidget(new RefineWidgetTextbox('name', 'Name'));
Line 94: $this->refine_bar->addWidget(new RefineWidgetTextbox('_keyword', 'Keyword search'));
Line 95: $this->refine_bar->addWidget(new RefineWidgetTextbox('_phrase', 'Exact phrase'));
Line 107: * Return the WHERE clause to use for a given key which is provided by the RefineBar
Line 124: return "item.id IN (SELECT record_id FROM ~page_keywords AS pk
Line 125: INNER JOIN ~search_keywords AS k ON pk.keyword_id = k.id WHERE k.name LIKE ?)";
Line 130: return "item.id IN (SELECT page_id FROM ~page_revisions AS rev
Line 143: * @param int $item_id The item which was affected. Bulk actions (e.g. reorders) will have this set to NULL.
Line 145: public function _invalidateCaches($action, $item_id = null)
Line 161: $q = "SELECT id FROM ~homepages WHERE subsite_id = ?";
Line 164: $view->home_page_id = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'val');
Line 168: $view->record_id = Admin::getRecordId();
Line 219: 'parent_id' => (int) @$_GET['parent_id'],
Line 286: * Saves the provided POST data into a new page in the database
Line 288: * @param int $page_id After saving, the new record id will be returned in this parameter
Line 291: public function _addSave(&$page_id)
Line 301: $valid = new Validator($_POST);
Line 302: $valid->required(['name']);
Line 303: $valid->check('name', 'Validity::length', 1, 200);
Line 304: $valid->check('meta_description', 'Validity::length', 0, 200);
Line 309: 'subsite_id' => $_SESSION['admin']['active_subsite'],
Line 310: 'parent_id' => (int)@$_POST['parent_id']
Line 313: } catch (ValidationException $exp) {
Line 314: $valid->addFieldError('name', 'this will result in a conflicting URL, please try another.');
Line 318: // Validate fields specific to tool pages
Line 319: $valid->required(['controller_entrance']);
Line 320: $valid->check('controller_entrance', 'Validity::length', 1, 200);
Line 321: if (!self::checkControllerEntrance($_POST['controller_entrance'], $page_id)) {
Line 322: $valid->addFieldError('controller_entrance', 'Invalid value');
Line 325: // Tell core AdminController the right URL to redirect to upon validation error
Line 329: if ($valid->hasErrors()) {
Line 331: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 332: $valid->createNotifications();
Line 350: $update_fields['parent_id'] = $_POST['parent_id'];
Line 354: $update_fields['subsite_id'] = $_SESSION['admin']['active_subsite'];
Line 375: $page_id = Pdb::insert('pages', $update_fields);
Line 377: $this->fixRecordOrder($page_id);
Line 380: $res = $this->addHistoryItem($page_id, 'Created empty new page');
Line 385: $update_fields['page_id'] = $page_id;
Line 407: foreach ($_POST['admin_permissions'] as $id) {
Line 408: $id = (int) $id;
Line 409: if ($id == 0) continue;
Line 413: $update_fields['item_id'] = $page_id;
Line 414: $update_fields['category_id'] = $id;
Line 423: foreach ($_POST['user_permissions'] as $id) {
Line 424: $id = (int) $id;
Line 425: if ($id == 0) continue;
Line 429: $update_fields['item_id'] = $page_id;
Line 430: $update_fields['category_id'] = $id;
Line 444: return 'admin/edit/' . $this->controller_name . '/' . $page_id . '?suppress=true';
Line 479: // Validate upload
Line 481: $error = 'No file provided';
Line 483: $error = 'No file provided';
Line 484: } else if (! Upload::valid($_FILES['import'])) {
Line 523: // Check the result is valid XML
Line 606: echo '<p><i>Invalid import type</i></p>';
Line 672: // Basic validation
Line 682: $cat_id = Category::lookupOrCreate('files', 'Imported document images');
Line 699: $file_id = Pdb::insert('files', $update_fields);
Line 700: $image_filename = $file_id . '_' . $image_filename;
Line 702: // Set filename to contain file id
Line 705: Pdb::update('files', $update_fields, ['id' => $file_id]);
Line 708: Category::insertInto('files', $file_id, $cat_id);
Line 763: throw new Exception("Invalid import type '{$_POST['import_type']}'.");
Line 770: $result = $this->createPageTreenode($child, (int)$_POST['parent_id'], $images, $headings, $operator);
Line 784: private function createPageTreenode($node, $parent_id, $images, $headings, $operator)
Line 796: $update_fields['parent_id'] = $parent_id;
Line 797: $update_fields['subsite_id'] = $_SESSION['admin']['active_subsite'];
Line 801: $page_id = Pdb::insert('pages', $update_fields);
Line 803: $this->fixRecordOrder($page_id);
Line 807: $update_fields['page_id'] = $page_id;
Line 814: $rev_id = Pdb::insert('page_revisions', $update_fields);
Line 821: $update_fields['page_revision_id'] = $rev_id;
Line 822: $update_fields['area_id'] = 1;
Line 827: Pdb::insert('page_widgets', $update_fields);
Line 830: $res = $this->addHistoryItem($page_id, "Imported page from uploaded file");
Line 834: $res = $this->reindexItem($page_id, $node['name'], $html);
Line 840: $count += $this->createPageTreenode($child, $page_id, $images, $headings, $operator);
Line 847: public function _getCustomEditSaveHTML($item_id)
Line 851: $user_id = AdminAuth::getId();
Line 852: $q = "SELECT operators.id, operators.name
Line 854: INNER JOIN ~operators_cat_join AS joiner ON joiner.operator_id = operators.id
Line 855: AND operators.id != ?
Line 856: INNER JOIN ~operators_cat_list AS cat ON joiner.cat_id = cat.id
Line 859: $approval_admins = Pdb::q($q, [$user_id], 'map');
Line 862: $view->id = (int) $item_id;
Line 863: $view->preview_url = Subsites::getAbsRootAdmin() . 'admin/call/page/preview/' . $item_id;
Line 865: $view->allow_delete = $this->_isDeleteSaved($item_id);
Line 876: * @param int $item_id Record which is being editied
Line 880: public function _getEditLiveUrl($item_id)
Line 882: return Page::url($item_id);
Line 889: * @param int $id The record to show the edit form for
Line 892: public function _getEditForm($id)
Line 894: $id = (int) $id;
Line 897: $q = "SELECT * FROM ~subsites WHERE id = ?";
Line 901: return new AdminError("Invalid id specified - current subsite does not exist");
Line 905: $q = "SELECT * FROM ~pages WHERE id = ?";
Line 907: $page = Pdb::q($q, [$id], 'row');
Line 909: return new AdminError("Invalid id specified - page does not exist");
Line 918: $res = AdminPerms::checkPermissionsTree('pages', $id);
Line 924: WHERE page_id = ?
Line 926: $revs = Pdb::q($q, [$id], 'arr');
Line 928: return new AdminError("Invalid id specified - page does not have any revisions");
Line 935: $sel_rev = ['id' => 0];
Line 937: if (!empty($_SESSION['admin']['field_values']['rev_id'])) {
Line 939: if ($rev['id'] == $_SESSION['admin']['field_values']['rev_id']) {
Line 947: $rev_id = (int)$_GET['revision'];
Line 949: if ($rev['id'] == $rev_id) {
Line 977: // Type override caused by clicking a sidebar 'change to' option
Line 982: // Remember the edit type for use in sidebar; i.e. _getCustomEditSaveHTML
Line 998: // Load widgets and collate rich text as page text
Line 1000: $widgets = [];
Line 1001: $q = "SELECT area_id, type, settings, conditions, active, heading, template
Line 1002: FROM ~page_widgets
Line 1003: WHERE page_revision_id = ?
Line 1004: ORDER BY area_id, record_order";
Line 1005: $wids = Pdb::q($q, [$sel_rev['id']], 'arr');
Line 1007: foreach ($wids as $widget) {
Line 1008: $widgets[$widget['area_id']][] = $widget;
Line 1010: // Embedded rich text widgets
Line 1011: if ($widget['area_id'] == 1 and $widget['type'] == 'RichText') {
Line 1012: $settings = json_decode($widget['settings'], true);
Line 1029: AdminSeo::addLinks(Page::determineRelatedLinks($id));
Line 1032: $widgets = [];
Line 1035: return new AdminError("Invalid page type");
Line 1039: $admin_permissions = AdminPerms::getAccessableGroups('pages', $id);
Line 1048: $user_permissions = UserPerms::getAccessableGroups('pages', $id);
Line 1068: WHERE page_id = ?
Line 1070: $history = Pdb::q($q, [$id], 'arr');
Line 1093: $attributes = MultiEdit::load('page_attributes', ['page_id' => $id]);
Line 1121: // Richtext width and height
Line 1122: $richtext_width = Kohana::config('sprout.admin_richtext_width');
Line 1124: if (!$richtext_width) $richtext_width = 700;
Line 1136: $view->id = $id;
Line 1141: $view->widgets = $widgets;
Line 1152: $view->richtext_width = $richtext_width;
Line 1156: $view->sel_rev_id = $sel_rev['id'];
Line 1181: * @param int $id The revision to get the text of
Line 1183: public function ajaxGetRev($id)
Line 1185: $id = (int) $id;
Line 1187: $rev = Pdb::get('page_revisions', $id);
Line 1214: $out['changes_made'] = "...... (based on revision {$rev['id']}: '{$changes}')";
Line 1226: public function ajaxGetMenuGroups($parent_page_id)
Line 1229: $parent_page_id = (int) $parent_page_id;
Line 1232: if ($parent_page_id === 0) {
Line 1239: $node = $root->findNodeValue('id', $parent_page_id);
Line 1240: if ($node === null) Json::error('Invalid parent page');
Line 1245: $groups = NavigationGroups::getGroupsAdmin($top_parent['id']);
Line 1248: foreach ($groups as $id => $row) {
Line 1249: $names[$id] = $row['name'];
Line 1257: * Makes the provided html text be in a standard format to ensure the integrity of the change check
Line 1266: * Saves the provided POST data into this page in the database
Line 1268: * @param int $page_id The record to update
Line 1271: public function _editSave($page_id)
Line 1273: $res = AdminPerms::checkPermissionsTree('pages', $page_id);
Line 1276: $page_id = (int) $page_id;
Line 1277: $rev_id = (int) $_POST['rev_id'];
Line 1281: INNER JOIN ~page_revisions AS rev ON page.id = rev.page_id
Line 1282: AND rev.id = ?
Line 1283: WHERE page.id = ?";
Line 1284: $orig_page = Pdb::q($q, [$rev_id, $page_id], 'row');
Line 1294: // Collate POSTed widgets.
Line 1295: $new_widgets = [];
Line 1296: if (@count($_POST['widgets'])) {
Line 1297: foreach ($_POST['widgets'] as $area_name => $widgets) {
Line 1298: $area = WidgetArea::findAreaByName($area_name);
Line 1302: foreach ($widgets as $info) {
Line 1306: if ($_POST['widget_deleted'][$area_name][$index] == '1') {
Line 1310: $settings = @$_POST['widget_settings_' . $index];
Line 1316: if (isset($_POST['widget_active'][$area_name][$index])) {
Line 1317: $active = (int) (bool) $_POST['widget_active'][$area_name][$index];
Line 1321: if (isset($_POST['widget_conds'][$area_name][$index])) {
Line 1322: $conditions = $_POST['widget_conds'][$area_name][$index];
Line 1326: if (isset($_POST['widget_heading'][$area_name][$index])) {
Line 1327: $heading = $_POST['widget_heading'][$area_name][$index];
Line 1331: if (isset($_POST['widget_template'][$area_name][$index])) {
Line 1332: $template = $_POST['widget_template'][$area_name][$index];
Line 1335: $new_widgets[] = [
Line 1336: 'area_id' => $area->getIndex(),
Line 1349: // Compare new widgets with old ones -- if changed, need a new revision
Line 1350: $q = "SELECT area_id, active, type, settings, conditions, heading, template, record_order
Line 1351: FROM ~page_widgets
Line 1352: WHERE page_revision_id = ?
Line 1353: ORDER BY area_id, record_order";
Line 1354: $old_widgets = Pdb::query($q, [$rev_id], 'arr');
Line 1355: if (count($new_widgets) != count($old_widgets)) {
Line 1358: foreach ($old_widgets as $key => $widget) {
Line 1359: if ($widget != @$new_widgets[$key]) {
Line 1368: $q = "SELECT rev.*, page.parent_id
Line 1370: INNER JOIN ~pages AS page ON page.id = rev.page_id
Line 1371: WHERE rev.id = ?";
Line 1372: $orig_rev = Pdb::q($q, [$rev_id], 'row');
Line 1388: foreach($_POST['mediareplace_fr'] as $idx => $replace_from) {
Line 1389: $replace_to = $_POST['mediareplace_to'][$idx];
Line 1398: foreach ($new_widgets as &$widget) {
Line 1399: if ($widget['area_id'] != 1 or $widget['type'] != 'RichText') continue;
Line 1400: $settings = json_decode($widget['settings'], true);
Line 1404: $widget['settings'] = json_encode($settings);
Line 1408: unset($widget);
Line 1420: if ((int) $orig_page['parent_id'] != (int) $_POST['parent_id']) {
Line 1428: // Set up validation rules
Line 1429: $valid = new Validator($_POST);
Line 1430: $valid->setLabels([
Line 1431: 'parent_id' => 'Parent page',
Line 1436: $valid->required(['name', 'slug']);
Line 1437: $valid->check('name', 'Validity::length', 1, 200);
Line 1438: $valid->check('slug', 'Validity::length', 1, 200);
Line 1439: $valid->check('slug', 'Slug::valid');
Line 1442: 'subsite_id' => $_SESSION['admin']['active_subsite'],
Line 1443: 'parent_id' => (int)$_POST['parent_id'],
Line 1444: ['id', '!=', $page_id],
Line 1446: $valid->check('slug', 'Slug::unique', 'pages', $slug_conditions);
Line 1448: $valid->check('meta_keywords', 'Validity::length', 0, 200);
Line 1449: $valid->check('meta_description', 'Validity::length', 0, 200);
Line 1450: $valid->check('alt_browser_title', 'Validity::length', 0, 200);
Line 1451: $valid->check('alt_nav_title', 'Validity::length', 0, 200);
Line 1454: $valid->check('redirect', 'Validity::length', 0, 200);
Line 1457: $valid->check('changes_made', 'Validity::length', 0, 250);
Line 1461: $valid->required(['approval_operator_id']);
Line 1464: $q = "SELECT * FROM ~operators WHERE ID = ?";
Line 1465: $approval_operator = Pdb::query($q, [(int) $_POST['approval_operator_id']], 'row');
Line 1467: $valid->addFieldError('approval_operator_id', 'Invalid value');
Line 1472: $valid->required(['date_launch']);
Line 1476: $valid->required(['controller_entrance', 'controller_argument']);
Line 1477: $valid->check('controller_entrance', 'Validity::length', 1, 200);
Line 1478: if (!self::checkControllerEntrance($_POST['controller_entrance'], $page_id)) {
Line 1479: $valid->addFieldError('controller_entrance', 'Invalid value');
Line 1482: $valid->required(['redirect']);
Line 1483: $valid->check('redirect', function($value) {
Line 1484: if (!Lnk::valid($_POST['redirect'])) {
Line 1485: throw new ValidationException('Invalid redirect target');
Line 1490: if ($orig_page['id'] == $_POST['parent_id']) {
Line 1491: $valid->addFieldError('parent_id', 'A page can\'t be its own parent.');
Line 1496: $new_parent = $root_node->findNodeValue('id', $_POST['parent_id']);
Line 1500: if ($anc['id'] == $page_id) {
Line 1501: $valid->addFieldError('parent_id', 'You can\'t set a descendent of this page as its parent');
Line 1508: // Check validation
Line 1509: if ($valid->hasErrors()) {
Line 1511: $_SESSION['admin']['field_errors'] = $valid->getFieldErrors();
Line 1512: $valid->createNotifications();
Line 1576: $update_fields['parent_id'] = (int) $_POST['parent_id'];
Line 1580: Pdb::update('pages', $update_fields, ['id' => $page_id]);
Line 1582: if ($parent_changed) $this->fixRecordOrder($page_id);
Line 1590: $update_fields['operator_id'] = $operator['id'];
Line 1605: Pdb::update('page_revisions', $update_fields, ['page_id' => $page_id, 'id' => $rev_id]);
Line 1607: $res = $this->addHistoryItem($page_id, "Updated revision {$rev_id}");
Line 1612: $update_fields['page_id'] = $page_id;
Line 1613: $update_fields['approval_operator_id'] = (int) @$_POST['approval_operator_id'];
Line 1616: $rev_id = Pdb::insert('page_revisions', $update_fields);
Line 1618: $res = $this->addHistoryItem($page_id, "Created new revision {$rev_id}");
Line 1624: Page::activateRevision($rev_id);
Line 1627: // Widgets
Line 1628: Pdb::delete('page_widgets', ['page_revision_id' => $rev_id]);
Line 1630: foreach ($new_widgets as $widget) {
Line 1631: $update_fields = $widget;
Line 1632: $update_fields['page_revision_id'] = $rev_id;
Line 1633: Pdb::insert('page_widgets', $update_fields);
Line 1642: Pdb::update('page_revisions', $update_fields, ['page_id' => $page_id, 'id' => $rev_id]);
Line 1668: Pdb::delete('page_admin_permissions', ['item_id' => $page_id]);
Line 1671: foreach ($_POST['admin_permissions'] as $id) {
Line 1672: $id = (int) $id;
Line 1673: if ($id == 0) continue;
Line 1677: $update_fields['item_id'] = $page_id;
Line 1678: $update_fields['category_id'] = $id;
Line 1687: Pdb::delete('page_user_permissions', ['item_id' => $page_id]);
Line 1690: foreach ($_POST['user_permissions'] as $id) {
Line 1691: $id = (int) $id;
Line 1692: if ($id == 0) continue;
Line 1696: $update_fields['item_id'] = $page_id;
Line 1697: $update_fields['category_id'] = $id;
Line 1706: Pdb::delete('page_attributes', ['page_id' => $page_id]);
Line 1709: foreach ($_POST['multiedit_attrs'] as $idx => $data) {
Line 1713: $update_fields['page_id'] = (int) $page_id;
Line 1722: // Do indexing on the page text, which is found in the embedded widgets
Line 1723: $text = Page::getText($page_id, $rev_id, $_SESSION['admin']['active_subsite']);
Line 1732: $view->url = Sprout::absRoot() . "page/view_specific_rev/{$page_id}/{$rev_id}/{$approval_code}";
Line 1748: $view->url = Sprout::absRoot() . "page/view_specific_rev/{$page_id}/{$rev_id}";
Line 1765: $res = $this->reindexItem($page_id, $_POST['name'], $text);
Line 1770: $this->addHistoryItem($page_id, "Changed the page type");
Line 1783: return "admin/edit/page/{$page_id}?revision={$rev_id}";
Line 1844: foreach ($all_groups as $page_id => $groups) {
Line 1845: foreach ($groups as $id => $name) {
Line 1847: $update_data['name'] = @$_POST['groups'][$id]['name'];
Line 1851: $conditions['subsite_id'] = (int)$_SESSION['admin']['active_subsite'];
Line 1852: $conditions['page_id'] = (int)$page_id;
Line 1853: $conditions['id'] = (int)$id;
Line 1860: $update_data['subsite_id'] = (int)$_SESSION['admin']['active_subsite'];
Line 1861: $update_data['page_id'] = (int)$page_id;
Line 1864: $update_data['text'] = $_POST['extras'][$page_id]['text'];
Line 1867: if (empty($_POST['extras'][$page_id]['image'])) {
Line 1868: $_POST['extras'][$page_id]['image'] = null;
Line 1870: $update_data['image'] = $_POST['extras'][$page_id]['image'];
Line 1877: unset($update_data['page_id']);
Line 1878: Pdb::update('menu_extras', $update_data, array('page_id' => $page_id));
Line 1891: private function addHistoryItem($page_id, $changes_made, $editor = null)
Line 1901: $update_fields['page_id'] = $page_id;
Line 1914: * @param int $id The record to show the edit form for
Line 1917: public function _getDeleteForm($id)
Line 1919: $id = (int) $id;
Line 1922: $view->id = $id;
Line 1925: $q = "SELECT * FROM ~pages WHERE id = ?";
Line 1927: $view->page = Pdb::q($q, [$id], 'row');
Line 1929: return new AdminError("Invalid id specified - page does not exist");
Line 1933: $res = AdminPerms::checkPermissionsTree('pages', $id);
Line 1938: $node = $root->findNodeValue('id', $id);
Line 1957: * @param int $item_id The record to delete
Line 1958: * @return void
Line 1961: public function _deletePreSave($item_id)
Line 1963: if (!AdminPerms::checkPermissionsTree('pages', $item_id)) {
Line 1971: * @param int $item_id The record to delete
Line 1972: * @return void
Line 1974: public function _deletePostSave($item_id)
Line 1983: public function _extraLinks($id)
Line 1985: $id = (int) $id;
Line 1987: $res = AdminPerms::checkPermissionsTree('pages', $id);
Line 1991: $view->id = $id;
Line 1997: ON revs.page_id = pages.id AND revs.status = ?
Line 1998: WHERE pages.id = ?";
Line 1999: $view->page = Pdb::q($q, ['live', $id], 'row');
Line 2002: $node = $root->findNodeValue('id', $id);
Line 2006: $q = "SELECT pages.id, pages.name, revs.text
Line 2009: ON revs.page_id = pages.id
Line 2020: $items[] = array('id' => $row['id'], 'name' => $row['name'], 'text' => $matches[1]);
Line 2041: $items[] = array('id' => $match[1], 'url' => $match[1], 'text' => $match[2]);
Line 2075: $q = "SELECT pages.id, pages.name, DATE_FORMAT(pages.date_modified, '%d/%m/%Y') AS date_modified,
Line 2078: WHERE subsite_id = ?
Line 2094: $q = "SELECT pages.id, pages.name, DATE_FORMAT(page_revisions.date_modified, '%d/%m/%Y') AS date_modified,
Line 2097: INNER JOIN ~pages AS pages ON page_revisions.page_id = pages.id
Line 2099: AND subsite_id = ?
Line 2125: private function reindexItem($item_id, $name, $text)
Line 2127: Search::selectIndex('page_keywords', $item_id);
Line 2153: $q = "SELECT pages.id, pages.name, pages.active, widget.settings
Line 2156: ON rev.page_id = pages.id AND rev.status = ?
Line 2157: LEFT JOIN ~page_widgets AS widget ON rev.id = widget.page_revision_id
Line 2158: AND widget.area_id = 1 AND widget.active = 1 AND widget.type = 'RichText'
Line 2159: ORDER BY widget.record_order";
Line 2165: $pages[$row['id']] = ['name' => $row['name'], 'text' => ''];
Line 2169: if (!isset($pages[$row['id']])) {
Line 2170: $pages[$row['id']] = ['name' => $row['name'], 'text' => $settings['text']];
Line 2172: $pages[$row['id']]['text'] .= "\n" . $settings['text'];
Line 2183: foreach ($pages as $id => $page) {
Line 2184: $this->reindexItem($id, $page['name'], $page['text']);
Line 2194: * Validate given controller implements FrontEndEntrance
Line 2197: * @param int $page_id Page record ID
Line 2200: private static function checkControllerEntrance($controller, $page_id)
Line 2202: $page_id = (int) $page_id;
Line 2223: $_GET['record_id'] = (int) $_GET['record_id'];
Line 2228: $top_node = $root->findNodeValue('id', basename($_POST['dir']));
Line 2247: $admin_perms = AdminPerms::checkPermissionsTree('pages', $top_node['id']);
Line 2250: if ($top_node['id'] == $_GET['record_id']) $class .= ' current-edit';
Line 2260: $rel = Enc::html($_POST['dir'] . $child['id']);
Line 2262: $admin_perms = AdminPerms::checkPermissionsTree('pages', $child['id']);
Line 2268: if ($child['id'] == $_GET['record_id']) $class .= ' current-edit';
Line 2284: echo "&#43; <a href=\"SITE/admin/add/page?parent_id={$top_node['id']}\">Add Child</a>";
Line 2286: echo "&#8597; <a href=\"SITE/page/reorder/{$top_node['id']}\" onclick=\"$.facebox({'ajax':this.href}); return false;\">Re-order</a>";
Line 2320: $q = "SELECT id, name
Line 2322: WHERE subsite_id = ? AND parent_id = 0
Line 2334: $view->id = 0;
Line 2348: * @param int $item_id Record-id to update
Line 2350: protected function fixRecordOrder($item_id)
Line 2352: $q = "SELECT record_order, subsite_id, parent_id FROM ~{$this->table_name} WHERE id = ?";
Line 2353: $item = Pdb::q($q, [$item_id], 'row');
Line 2359: WHERE subsite_id = ?
Line 2360: AND parent_id = ?";
Line 2362: $max = Pdb::q($q, [$item['subsite_id'], $item['parent_id']], 'val');
Line 2367: $q = "UPDATE ~{$this->table_name} SET record_order = ? WHERE id = ?";
Line 2368: Pdb::q($q, [$max + 1, $item_id], 'count');
Line 2383: $q = "SELECT id, page_id
Line 2389: Cron::message("Launching revision {$row['id']} on page {$row['page_id']}");
Line 2392: Pdb::update('page_revisions', ['status' => 'live'], ['id' => $row['id']]);
Line 2394: $this->addHistoryItem($row['page_id'], "AutoLaunched revision {$row['id']}", 'n/a');
Line 2397: 'page_id' => $row['page_id'],
Line 2398: ['id', '!=', $row['id']],
Line 2426: $q = "SELECT id
Line 2435: Cron::message("De-activating page {$row['id']}");
Line 2438: Pdb::update('pages', ['active' => 0], ['id' => $row['id']]);
Line 2440: $this->addHistoryItem($row['id'], "Deactivated page {$row['id']}", 'n/a');
Line 2528: Notification::error("Invalid 'send_to' argument");
Line 2533: Notification::error("You didn't enter an email address");
Line 2549: Url::redirect('admin/extra/page/link_checker_info/' . $info['job_id']);
Line 2556: public function _extraLinkCheckerInfo($id)
Line 2558: $id = (int) $id;
Line 2581: $q = "SELECT pages.id, pages.name, revs.date_modified, revs.modified_editor
Line 2583: INNER JOIN ~pages AS pages ON revs.page_id = pages.id
Line 2585: AND pages.subsite_id = ?
Line 2586: GROUP BY pages.id
Line 2621: * @return void
Line 2632: $q = "SELECT page.id, page.subsite_id, page.name,
Line 2634: op.id AS op_id, op.name AS operator, op.email
Line 2637: ON page.id = rev.page_id AND rev.status = 'live' AND rev.type = 'standard'
Line 2639: ON rev.operator_id = op.id
Line 2644: ORDER BY age DESC, page.id";
Line 2659: foreach ($res as $id => $row) {
Line 2660: $url = Page::url($id);
Line 2663: $url = Subsites::getAbsRoot($row['subsite_id']) . $url;
Line 2666: 'id' => $row['id'],
Line 2675: $op = $row['op_id'];
Line 2685: 'id' => $row['id'],
Line 2692: foreach ($op_emails as $id => $details) {
Line 2701: $view->show_op = ($id == 0);
Line 2719: $conds = [['id', 'IN', array_keys($res)]];
Line 2743: public function preview($item_id = 0) {
Line 2744: $item_id = (int) $item_id;
Line 2748: 'page_revisions' => ['id' => $_POST['rev_id']],
Line 2749: 'page_widgets' => 0,
Line 2763: $item_id = Preview::load($this, $tables, $item_id);
Line 2766: Preview::run($ctlr, 'viewById', [$item_id]);
Line 2771: * Return JSON list of custom widget templates as defined by skin config
Line 2775: * @return void Echos HTML directly
Line 2777: public function ajaxListWidgetTemplates()
Line 2779: $templates = Kohana::config('sprout.widget_templates');

/sprout/Controllers/Admin/RedirectAdminController.php   Highlighted file source

Line 20: use Sprout\Helpers\RefineWidgetTextbox;
Line 21: use Sprout\Helpers\Validator;
Line 57: 'Subsite' => [new ColModifierLookupTable('subsites'), 'subsite_id'],
Line 63: $this->refine_bar->addWidget(new RefineWidgetTextbox('path_exact', 'Path exact match'));
Line 64: $this->refine_bar->addWidget(new RefineWidgetTextbox('path_contains', 'Path contains'));
Line 71: * Do any additional validation prior to saving the record
Line 73: * @param int $id Record ID or 0 for adds
Line 74: * @param Validator $validator Validator instance to attach your errors to
Line 75: * @return void
Line 77: protected function jsonExtraValidate($id, Validator $validator)
Line 79: $validator->multipleCheck(
Line 80: ['path_exact', 'path_contains', 'subsite_id', 'domain_contains'],
Line 81: 'Validity::oneRequired'