extension.driver.php

<?php
	
	class Extension_PublishNotesField extends Extension {

	/*-------------------------------------------------------------------------
		Extension Definition:
	-------------------------------------------------------------------------*/
		
		public function getSubscribedDelegates() {
			return array(
				array(
					'page'		=> '/backend/',
					'delegate'	=> 'InitaliseAdminPageHead',
					'callback'	=> 'initaliseAdminPageHead'
				)
			);
		}
		
		public function install()
		{
			return Symphony::Database()->query("CREATE TABLE `tbl_fields_publishnotes`(
					`id` int(11) unsigned NOT NULL auto_increment,
					`field_id` int(11) unsigned NOT NULL,
					`note` text NULL,
					`editable` tinyint(1) default '0',
					PRIMARY KEY (`id`),
					KEY `field_id` (`field_id`)
				) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;"
			);
		}
		
		public function uninstall()
		{
			Symphony::Database()->query("DROP TABLE `tbl_fields_publishnotes`");
			return TRUE;
		}
		
		public function update($previousVersion = false) 
		{
			$status = true;

			if(Symphony::Database()->tableContainsField('tbl_fields_publishnotes', 'editable') === false) {
				$status = Symphony::Database()->query(
					"ALTER TABLE `tbl_fields_publishnotes` ADD `editable` tinyint(1) default '0'"
				);
			}

			return $status;
		}
	
		/*-------------------------------------------------------------------------
			Delegates:
		-------------------------------------------------------------------------*/
		
		public function initaliseAdminPageHead($context)
		{
			$page = Administration::instance()->Page;
			if ($page instanceof ContentPublish AND ($page->_context['page'] == 'edit' OR $page->_context['page'] == 'new')) 
			{
				$page->addStylesheetToHead(URL . '/extensions/publishnotesfield/assets/publishnotesfield.publish.css', 'screen', 3220001);
				$page->addScriptToHead(URL . '/extensions/publishnotesfield/assets/publishnotesfield.publish.js', 3220003);
			}
		}
	}