Update of /cvsroot/phpwebsite-comm/modules/article/boost In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2278/boost Modified Files: permission.php dependency.xml uninstall.php boost.php controlpanel.php install.sql update.php Log Message: Article Manager 4.1.0 Index: uninstall.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/uninstall.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** uninstall.php 21 Oct 2007 05:52:53 -0000 1.9 --- uninstall.php 21 Aug 2008 20:17:29 -0000 1.10 *************** *** 1,19 **** ! <?php ! /** ! * This is the Article Manager uninstall file for Boost ! * ! * @version $Id$ ! * @author Eloi George <el...@NO...> ! */ ! function article_uninstall(&$content) ! { ! if (!PHPWS_File::rmdir(PHPWS_HOME_DIR.'files/article')) ! return FALSE; ! $content[] = dgettext('article', 'Article Manager configuration files removed.'); ! if (!PHPWS_DB::dropTable('article')) ! return FALSE; ! $content[] = dgettext('article', 'Article Manager tables removed.'); ! return TRUE; ! } ! ?> \ No newline at end of file --- 1,19 ---- ! <?php ! /** ! * This is the Article Manager uninstall file for Boost ! * ! * @version $Id$ ! * @author Eloi George <el...@NO...> ! */ ! function article_uninstall(&$content) ! { ! if (!PHPWS_File::rmdir(PHPWS_HOME_DIR.'files/article')) ! return FALSE; ! $content[] = dgettext('article', 'Article Manager configuration files removed.'); ! if (!PHPWS_DB::dropTable('article')) ! return FALSE; ! $content[] = dgettext('article', 'Article Manager tables removed.'); ! return TRUE; ! } ! ?> \ No newline at end of file Index: dependency.xml =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/dependency.xml,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** dependency.xml 21 Oct 2007 18:03:57 -0000 1.3 --- dependency.xml 21 Aug 2008 20:17:29 -0000 1.4 *************** *** 4,8 **** <title>core</title> <properName>phpWebSite Core</properName> ! <version>1.6.3</version> <url>http://phpwebsite.appstate.edu/downloads/modules/base/</url> </module> --- 4,8 ---- <title>core</title> <properName>phpWebSite Core</properName> ! <version>1.8.2</version> <url>http://phpwebsite.appstate.edu/downloads/modules/base/</url> </module> *************** *** 10,14 **** <title>categories</title> <properName>Categories</properName> ! <version>2.1.10</version> <url>http://phpwebsite.appstate.edu/downloads/modules/categories</url> </module> --- 10,14 ---- <title>categories</title> <properName>Categories</properName> ! <version>2.2.2</version> <url>http://phpwebsite.appstate.edu/downloads/modules/categories</url> </module> *************** *** 16,20 **** <title>controlpanel</title> <properName>Control Panel</properName> ! <version>2.1.3</version> <url>http://phpwebsite.appstate.edu/downloads/modules/controlpanel</url> </module> --- 16,20 ---- <title>controlpanel</title> <properName>Control Panel</properName> ! <version>2.1.6</version> <url>http://phpwebsite.appstate.edu/downloads/modules/controlpanel</url> </module> *************** *** 22,26 **** <title>filecabinet</title> <properName>File Cabinet</properName> ! <version>1.3.0</version> <url>http://phpwebsite.appstate.edu/downloads/modules/filecabinet</url> </module> --- 22,26 ---- <title>filecabinet</title> <properName>File Cabinet</properName> ! <version>2.1.0</version> <url>http://phpwebsite.appstate.edu/downloads/modules/filecabinet</url> </module> *************** *** 28,32 **** <title>users</title> <properName>Users</properName> ! <version>2.4.5</version> <url>http://phpwebsite.appstate.edu/downloads/modules/users</url> </module> --- 28,32 ---- <title>users</title> <properName>Users</properName> ! <version>2.5.0</version> <url>http://phpwebsite.appstate.edu/downloads/modules/users</url> </module> *************** *** 34,38 **** <title>version</title> <properName>Version</properName> ! <version>0.1.5</version> <url>http://phpwebsite.appstate.edu/downloads/modules/version</url> </module> --- 34,38 ---- <title>version</title> <properName>Version</properName> ! <version>0.1.6</version> <url>http://phpwebsite.appstate.edu/downloads/modules/version</url> </module> Index: permission.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/permission.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** permission.php 16 Sep 2007 23:15:48 -0000 1.2 --- permission.php 21 Aug 2008 20:17:29 -0000 1.3 *************** *** 1,19 **** ! <?php ! ! $use_permissions = TRUE; ! ! $permissions['create_articles'] = dgettext('article', 'Create Articles'); ! $permissions['edit_articles'] = dgettext('article', 'Edit Articles'); ! $permissions['delete_articles'] = dgettext('article', 'Delete Articles'); ! $permissions['images_in_article'] = dgettext('article', 'Place Images In Articles'); ! $permissions['choose_section_template'] = dgettext('article', 'Choose Section Templates'); ! $permissions['choose_article_template'] = dgettext('article', 'Choose Article Templates'); ! $permissions['insert_external_pages'] = dgettext('article', 'Insert External Pages'); ! $permissions['allow_comments'] = dgettext('article', 'Allow/Disallow Comments'); ! $permissions['allow_anon'] = dgettext('article', 'Allow/Disallow Anonymous Comments'); ! $permissions['change_dates'] = dgettext('article', 'Change dates of Publication/Expiration'); ! $permissions['set_mainarticle'] = dgettext('article', 'Set Mainarticle'); ! $permissions['edit_robots'] = dgettext('article', 'Edit Search Engine Instructions'); ! ! $item_permissions = TRUE; ! ?> --- 1,19 ---- ! <?php ! ! $use_permissions = TRUE; ! ! $permissions['create_articles'] = dgettext('article', 'Create Articles'); ! $permissions['edit_articles'] = dgettext('article', 'Edit Articles'); ! $permissions['delete_articles'] = dgettext('article', 'Delete Articles'); ! $permissions['images_in_article'] = dgettext('article', 'Place Images In Articles'); ! $permissions['choose_section_template'] = dgettext('article', 'Choose Section Templates'); ! $permissions['choose_article_template'] = dgettext('article', 'Choose Article Templates'); ! $permissions['insert_external_pages'] = dgettext('article', 'Insert External Pages'); ! $permissions['allow_comments'] = dgettext('article', 'Allow/Disallow Comments'); ! $permissions['allow_anon'] = dgettext('article', 'Allow/Disallow Anonymous Comments'); ! $permissions['change_dates'] = dgettext('article', 'Change dates of Publication/Expiration'); ! $permissions['set_mainarticle'] = dgettext('article', 'Set Mainarticle'); ! $permissions['edit_robots'] = dgettext('article', 'Edit Search Engine Instructions'); ! ! $item_permissions = TRUE; ! ?> Index: boost.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/boost.php,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** boost.php 26 Oct 2007 07:27:44 -0000 1.8 --- boost.php 21 Aug 2008 20:17:29 -0000 1.9 *************** *** 1,23 **** ! <?php ! /** ! * This is the Articlemaster mod_info file for Boost ! * ! * @version $Id$ ! * ! * @author Eloi George <el...@NO...> ! * @module Article Manager ! */ ! ! $proper_name = 'Article Manager'; ! $version = '4.0.6'; ! $register = FALSE; ! $unregister = FALSE; ! $import_sql = TRUE; ! $image_dir = TRUE; ! $file_dir = TRUE; ! $about = TRUE; ! $version_http = 'http://bygeorgeware.com/downloads/article/check.xml'; ! $priority = 50; ! $dependency = TRUE; ! ! ?> \ No newline at end of file --- 1,23 ---- ! <?php ! /** ! * This is the Articlemaster mod_info file for Boost ! * ! * @version $Id$ ! * ! * @author Eloi George <el...@NO...> ! * @module Article Manager ! */ ! ! $proper_name = 'Article Manager'; ! $version = '4.1.0'; ! $register = FALSE; ! $unregister = FALSE; ! $import_sql = TRUE; ! $image_dir = TRUE; ! $file_dir = TRUE; ! $about = TRUE; ! $version_http = 'http://bygeorgeware.com/downloads/article/check.xml'; ! $priority = 50; ! $dependency = TRUE; ! ! ?> Index: update.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/update.php,v retrieving revision 1.20 retrieving revision 1.21 diff -C2 -d -r1.20 -r1.21 *** update.php 26 Oct 2007 07:27:44 -0000 1.20 --- update.php 21 Aug 2008 20:17:29 -0000 1.21 *************** *** 1,154 **** ! <?php ! ! /** ! * @author Eloi George <el...@NO...> ! * @version $Id$ ! */ ! ! function article_update(&$content, $currentVersion) ! { ! switch ($currentVersion) { ! ! case version_compare($currentVersion, '4.0', '<'): ! $content[] = 'This package will not update versions prior to 4.0.'; ! return false; - case version_compare($currentVersion, '4.0.1', '<'): - $db = new PHPWS_DB('phpws_key'); - $sql = 'UPDATE phpws_key SET url = CONCAT("index.php?module=article&id=", item_id) WHERE module = "article"'; - $result = $db->query($sql); - if (PHPWS_Error::logIfError($result)) { - $content[] = 'Unable to fix key URLs.</pre>'; - return false; - } - $content[] = '+ Fixed Key URLs.'; - - $files = array('templates/edit.tpl', - 'templates/edit_section.tpl'); - $content[] = '+ Updated template files'; - if (PHPWS_Boost::updateFiles($files, 'article')) { - $content[] = ' o Files copied successfully:'; - } else { - $content[] = ' o Failed to copy files:'; - } - $content[] = ' ' . implode("\n ", $files); $content[] = '<pre> ======================== ! Changes in version 4.0.1 ======================== ! - I think core::loadobject may have changed, causing a bug in loading the right article ! - FilingCabinet\'s image selection dialog changed so that it\'s REAL BIG now. ! I made a small change to the editing form so that it won\'t look so cluttered. ! - Fixed a problem with MiniAdmin not showing up on some views. </pre>'; ! case version_compare($currentVersion, '4.0.2', '<'): ! $db = new PHPWS_DB('phpws_key'); ! $sql = 'UPDATE phpws_key SET edit_permission = "edit_articles" WHERE module = "article"'; ! $result = $db->query($sql); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to fix key URLs.</pre>'; ! return false; ! } ! $content[] = '+ Fixed Key permissions.'; ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.2 ! ======================== ! - Fixed a bug "Edit permission column does not exist" ! </pre>'; - case version_compare($currentVersion, '4.0.4', '<'): $db = new PHPWS_DB(); ! $result = $db->query('ALTER TABLE mod_article RENAME TO article'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_seq RENAME TO article_seq'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_seq.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_version RENAME TO article_version'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_version.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_version_seq RENAME TO article_version_seq'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_version_seq.</pre>'; ! return false; ! } ! $result = PHPWS_DB::dropTable('mod_article_langs'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to delete table "mod_article_langs"</pre>'; ! return false; ! } ! $content[] = '+ Renamed module tables to conform to 1.x naming'; ! ! $files = array('templates/list_articles.tpl', ! 'templates/summary_view.tpl', ! 'templates/search_advanced.tpl', ! 'templates/edit_section.tpl', ! 'templates/edit.tpl'); ! if (PHPWS_Boost::updateFiles($files, 'article')) ! $content[] = '+ Updated the following files:'; ! else ! $content[] = '+ Unable to update the following files:'; ! $content[] = " " . implode("\n ", $files); ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.4 ! ======================== ! + Fixed various error notices ! + Fixed various permissioning errors ! + Renamed module tables to conform to 1.x naming ! </pre>'; ! ! ! case version_compare($currentVersion, '4.0.5', '<'): ! if ($GLOBALS['PHPWS_DB']['tbl_prefix']) { ! $db = new PHPWS_DB(); ! $result = $db->query('ALTER TABLE article CHANGE '.$GLOBALS['PHPWS_DB']['tbl_prefix'].'mainarticle mainarticle SMALLINT NOT NULL DEFAULT 0'); ! $result = $db->query('ALTER TABLE article CHANGE is_base_'.$GLOBALS['PHPWS_DB']['tbl_prefix'].'article is_base_article SMALLINT NOT NULL DEFAULT 1'); ! $result = $db->query('ALTER TABLE article_version CHANGE '.$GLOBALS['PHPWS_DB']['tbl_prefix'].'mainarticle mainarticle SMALLINT NOT NULL DEFAULT 0'); ! $result = $db->query('ALTER TABLE article_version CHANGE is_base_'.$GLOBALS['PHPWS_DB']['tbl_prefix'].'article is_base_article SMALLINT NOT NULL DEFAULT 1'); ! $content[] = '+ Renamed maligned table columns'; ! } ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.5 ! ======================== ! + Image selection dialog now disappears when not authorized ! + Changed processing of ARTICLE_vars to avoid faulty "each()" command ! + Featured articles will now not show up in the summary lists as well ! + Configuration files are now deleted on uninstallation ! + Renamed maligned table columns to correct previous PHPWS_db prefixing bug ! </pre>'; ! ! ! case version_compare($currentVersion, '4.0.6', '<'): ! $files = array('templates/import_result.tpl'); ! if (PHPWS_Boost::updateFiles($files, 'article')) ! $content[] = '+ Updated templates/import_result.tpl'; ! else ! $content[] = '+ Unable to update templates/import_result.tpl'; ! $content[] = '<pre> ======================== ! Changes in version 4.0.6 ======================== ! + Fixed an XML article import bug that was importing all articles to 0 </pre>'; ! ! ! } // end of switch ! return true; ! } ! ?> \ No newline at end of file --- 1,219 ---- ! <?php ! ! /** ! * @author Eloi George <el...@NO...> ! * @version $Id$ ! */ ! ! function article_update(&$content, $currentVersion) ! { ! switch ($currentVersion) { ! ! case version_compare($currentVersion, '4.0', '<'): ! $content[] = 'This package will not update versions prior to 4.0.'; ! return false; ! ! case version_compare($currentVersion, '4.0.1', '<'): ! $db = new PHPWS_DB('phpws_key'); ! $sql = 'UPDATE phpws_key SET url = CONCAT("index.php?module=article&id=", item_id) WHERE module = "article"'; ! $result = $db->query($sql); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to fix key URLs.</pre>'; ! return false; ! } ! $content[] = '+ Fixed Key URLs.'; ! ! $files = array('templates/edit.tpl', ! 'templates/edit_section.tpl'); ! $content[] = '+ Updated template files'; ! if (PHPWS_Boost::updateFiles($files, 'article')) { ! $content[] = ' o Files copied successfully:'; ! } else { ! $content[] = ' o Failed to copy files:'; ! } ! $content[] = ' ' . implode("\n ", $files); ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.1 ! ======================== ! - I think core::loadobject may have changed, causing a bug in loading the right article ! - FilingCabinet\'s image selection dialog changed so that it\'s REAL BIG now. ! I made a small change to the editing form so that it won\'t look so cluttered. ! - Fixed a problem with MiniAdmin not showing up on some views. ! </pre>'; ! ! ! case version_compare($currentVersion, '4.0.2', '<'): ! $db = new PHPWS_DB('phpws_key'); ! $sql = 'UPDATE phpws_key SET edit_permission = "edit_articles" WHERE module = "article"'; ! $result = $db->query($sql); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to fix key URLs.</pre>'; ! return false; ! } ! $content[] = '+ Fixed Key permissions.'; ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.2 ! ======================== ! - Fixed a bug "Edit permission column does not exist" ! </pre>'; ! ! case version_compare($currentVersion, '4.0.4', '<'): ! $db = new PHPWS_DB(); ! $result = $db->query('ALTER TABLE mod_article RENAME TO article'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_seq RENAME TO article_seq'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_seq.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_version RENAME TO article_version'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_version.</pre>'; ! return false; ! } ! $result = $db->query('ALTER TABLE mod_article_version_seq RENAME TO article_version_seq'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to rename mod_article_version_seq.</pre>'; ! return false; ! } ! $result = PHPWS_DB::dropTable('mod_article_langs'); ! if (PHPWS_Error::logIfError($result)) { ! $content[] = 'Unable to delete table "mod_article_langs"</pre>'; ! return false; ! } ! $content[] = '+ Renamed module tables to conform to 1.x naming'; ! ! $files = array('templates/list_articles.tpl', ! 'templates/summary_view.tpl', ! 'templates/search_advanced.tpl', ! 'templates/edit_section.tpl', ! 'templates/edit.tpl'); ! if (PHPWS_Boost::updateFiles($files, 'article')) ! $content[] = '+ Updated the following files:'; ! else ! $content[] = '+ Unable to update the following files:'; ! $content[] = " " . implode("\n ", $files); ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.4 ! ======================== ! + Fixed various error notices ! + Fixed various permissioning errors ! + Renamed module tables to conform to 1.x naming ! </pre>'; ! ! ! case version_compare($currentVersion, '4.0.5', '<'): ! if ($GLOBALS['PHPWS_DB']['tbl_prefix']) { ! $db = new PHPWS_DB(); ! $result = $db->query('ALTER TABLE article CHANGE '.$GLOBALS['PHPWS_DB']['tbl_prefix'].'mainarticle mainarticle SMALLINT NOT NULL DEFAULT 0'); ! $result = $db->query('ALTER TABLE article CHANGE is_base_'.$GLOBALS['PHPWS_DB']['tbl_prefix'].'article is_base_article SMALLINT NOT NULL DEFAULT 1'); ! $result = $db->query('ALTER TABLE article_version CHANGE '.$GLOBALS['PHPWS_DB']['tbl_prefix'].'mainarticle mainarticle SMALLINT NOT NULL DEFAULT 0'); ! $result = $db->query('ALTER TABLE article_version CHANGE is_base_'.$GLOBALS['PHPWS_DB']['tbl_prefix'].'article is_base_article SMALLINT NOT NULL DEFAULT 1'); ! $content[] = '+ Renamed maligned table columns'; ! } ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.5 ! ======================== ! + Image selection dialog now disappears when not authorized ! + Changed processing of ARTICLE_vars to avoid faulty "each()" command ! + Featured articles will now not show up in the summary lists as well ! + Configuration files are now deleted on uninstallation ! + Renamed maligned table columns to correct previous PHPWS_db prefixing bug ! </pre>'; ! ! ! case version_compare($currentVersion, '4.0.6', '<'): ! $files = array('templates/import_result.tpl'); ! if (PHPWS_Boost::updateFiles($files, 'article')) ! $content[] = '+ Updated templates/import_result.tpl'; ! else ! $content[] = '+ Unable to update templates/import_result.tpl'; ! ! $content[] = '<pre> ! ======================== ! Changes in version 4.0.6 ! ======================== ! + Fixed an XML article import bug that was importing all articles to 0 ! </pre>'; + case version_compare($currentVersion, '4.0.9', '<'): + $files = array('templates/runtime_chronological.tpl', + 'templates/runtime_categorized.tpl', + 'templates/article/Blank.tpl', + 'templates/article/Byline.tpl', + 'templates/article/Dated.tpl', + 'templates/article/Image_Wrap_Left.tpl', + 'templates/article/Image_Wrap_Right.tpl', + 'templates/list_summaries.tpl'); + if (PHPWS_Boost::updateFiles($files, 'article')) + $content[] = '+ Updated the following files:'; + else + $content[] = '+ Unable to update the following files:'; + $content[] = " " . implode("\n ", $files); + $content[] = '<pre> ======================== ! Changes in version 4.0.9 ======================== ! + Created generic tags (CREATED_DATE, UPDATED_DATE) with time-format-specific template tags: ! CREATED_DATE_LONG ! UPDATED_DATE_LONG ! CREATED_DATE_SHORT ! UPDATED_DATE_SHORT ! CREATED_DATE_REL ! UPDATED_DATE_REL ! + Added summary image tags (IMAGE and CAPTION) to the default page and summary templates ! + Fixed notice where $_POST[`meta_keywords`] wasn`t being created. ! + Added image-related fields to PHPWS_AM_Data::bulk_load_db() so that images can show up on summary lists ! + trf000 reported that the import/export xml feature isn`t working with branches. Fixed by replacing the PHPWS_SOURCE_DIRs with PHPWS_HOME_DIRs </pre>'; ! case version_compare($currentVersion, '4.1.0', '<'): ! $files = array('templates/article/edit.tpl', ! 'templates/mail_link.tpl'); ! if (PHPWS_Boost::updateFiles($files, 'article')) ! $content[] = '+ Updated the following files:'; ! else ! $content[] = '+ Unable to update the following files:'; ! $content[] = " " . implode("<br />s\n ", $files); $db = new PHPWS_DB(); ! $db->query('ALTER TABLE article DROP allow_anonymous'); ! $content[] = '+ Deleted row "allow_anonymous" from Article table'; ! $content[] = '<pre> ======================== ! Changes in version 4.1.0 ======================== ! + CREATED_DATE & UPDATED_DATE tags use the CREATED_DATE_SHORT & UPDATED_DATE_SHORT date formats ! + Removed references to the obsolete Category::getTag() ! + The allow_anonymous setting is already stored in the Comment thread, so it`s been taken out of the Article record ! + AM now allows you to set the new Comments default_approval setting ! + Article->save() now exposes its Key (_key) and Comment_Thread (_thread) to reduce extra queries ! + Fixed Bug [2030665] Help not working properly ! + Fixed Bug [2030668] Email Article ! + Fixed Bug [2030733] Print doesn`t compile pages ! + Fixed Bug [2030671] Email Article Pt II ! + Fixed Bug [2008378] Comments are not converted correctly ! + Fixed Bug [2008368] Images are not converted correctly ! + 0.10.x Convertor now ignores comments if you`ve disabled them for the entire module </pre>'; ! ! ! } // end of switch ! return true; ! } ! ?> \ No newline at end of file Index: install.sql =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/install.sql,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** install.sql 17 Sep 2007 01:12:26 -0000 1.14 --- install.sql 21 Aug 2008 20:17:29 -0000 1.15 *************** *** 1,43 **** ! CREATE TABLE article ( ! id int NOT NULL default '0', ! key_id INT NOT NULL, ! title varchar(80) NOT NULL, ! mainarticle smallint NOT NULL DEFAULT '0', ! rank smallint NOT NULL DEFAULT '50', ! created_username varchar(20) NOT NULL, ! created_id int NOT NULL DEFAULT '0', ! updated_username varchar(20) NOT NULL, ! updated_id int NOT NULL DEFAULT '0', ! created_date int NOT NULL, ! updated_date int NOT NULL, ! summary text NOT NULL, ! allow_comments smallint NOT NULL DEFAULT '0', ! allow_anonymous smallint NOT NULL DEFAULT '0', ! hits int NOT NULL DEFAULT '0', ! expiration_date int NOT NULL, ! publication_date int NOT NULL, ! wordcount smallint NOT NULL DEFAULT '0', ! pagecount smallint NOT NULL, ! template varchar(50) NOT NULL DEFAULT 'Blank.tpl', ! editlock smallint NOT NULL DEFAULT '0', ! edituser int NOT NULL, ! approved smallint NOT NULL DEFAULT '0', ! version smallint NOT NULL DEFAULT '0', ! announce smallint NOT NULL DEFAULT '1', ! language char(2) NOT NULL DEFAULT 'en', ! is_base_article smallint NOT NULL DEFAULT '1', ! pages longtext NOT NULL, ! image_id int NOT NULL DEFAULT '0', ! image_link varchar(255) NOT NULL, ! image_caption varchar(255) NOT NULL, ! draft smallint NOT NULL DEFAULT '0', ! active smallint NOT NULL DEFAULT '1', ! ! PRIMARY KEY (id) ! ); ! CREATE INDEX hits_idx on article(hits); ! CREATE INDEX expiration_date_idx on article(expiration_date); ! CREATE INDEX updated_date_idx on article(updated_date); ! CREATE INDEX publication_date_idx on article(publication_date); ! CREATE INDEX language_idx on article(language); ! CREATE INDEX is_base_article_idx on article(is_base_article); --- 1,42 ---- ! CREATE TABLE article ( ! id int NOT NULL default '0', ! key_id INT NOT NULL, ! title varchar(80) NOT NULL, ! mainarticle smallint NOT NULL DEFAULT '0', ! rank smallint NOT NULL DEFAULT '50', ! created_username varchar(20) NOT NULL, ! created_id int NOT NULL DEFAULT '0', ! updated_username varchar(20) NOT NULL, ! updated_id int NOT NULL DEFAULT '0', ! created_date int NOT NULL, ! updated_date int NOT NULL, ! summary text NOT NULL, ! allow_comments smallint NOT NULL DEFAULT '0', ! hits int NOT NULL DEFAULT '0', ! expiration_date int NOT NULL, ! publication_date int NOT NULL, ! wordcount smallint NOT NULL DEFAULT '0', ! pagecount smallint NOT NULL, ! template varchar(50) NOT NULL DEFAULT 'Blank.tpl', ! editlock smallint NOT NULL DEFAULT '0', ! edituser int NOT NULL, ! approved smallint NOT NULL DEFAULT '0', ! version smallint NOT NULL DEFAULT '0', ! announce smallint NOT NULL DEFAULT '1', ! language char(2) NOT NULL DEFAULT 'en', ! is_base_article smallint NOT NULL DEFAULT '1', ! pages longtext NOT NULL, ! image_id int NOT NULL DEFAULT '0', ! image_link varchar(255) NOT NULL, ! image_caption varchar(255) NOT NULL, ! draft smallint NOT NULL DEFAULT '0', ! active smallint NOT NULL DEFAULT '1', ! ! PRIMARY KEY (id) ! ); ! CREATE INDEX hits_idx on article(hits); ! CREATE INDEX expiration_date_idx on article(expiration_date); ! CREATE INDEX updated_date_idx on article(updated_date); ! CREATE INDEX publication_date_idx on article(publication_date); ! CREATE INDEX language_idx on article(language); ! CREATE INDEX is_base_article_idx on article(is_base_article); Index: controlpanel.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/article/boost/controlpanel.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** controlpanel.php 9 Jul 2007 00:18:53 -0000 1.2 --- controlpanel.php 21 Aug 2008 20:17:29 -0000 1.3 *************** *** 1,9 **** ! <?php ! $link[] = array ('label' => dgettext('article', 'Article Manager'), ! 'restricted' => TRUE, ! 'url' => 'index.php?module=article&op=main_menu', ! 'description' => 'Go here to post articles, information & web pages.', ! 'image' => 'articlemanager.gif', ! 'tab' => 'content'); ! ?> \ No newline at end of file --- 1,9 ---- ! <?php ! $link[] = array ('label' => dgettext('article', 'Article Manager'), ! 'restricted' => TRUE, ! 'url' => 'index.php?module=article&op=main_menu', ! 'description' => 'Go here to post articles, information & web pages.', ! 'image' => 'articlemanager.gif', ! 'tab' => 'content'); ! ?> \ No newline at end of file |