[phpws-comm-commits] modules/article/boost install.php,NONE,1.1 install.sql,NONE,1.1 uninstall.php,N

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/phpwebsite-comm/modules/article/boost
In directory sc8-pr-cvs1:/tmp/cvs-serv30555/boost

Added Files:
	install.php install.sql uninstall.php uninstall.sql 
Log Message:
Initial  commit to CVS

--- NEW FILE: install.php ---
<?php
/**
 * This is the ArticleManager install file for Boost
 *
 * @version \$Id\$
 * @author Eloi George <el...@NO...>
 * @module Article Manager
 */
if (!$_SESSION["OBJ_user"]->isDeity())
{
    header("location:index.php");
    exit();
}

/* Don't overwrite the tables for this module if they're already there */
if ($GLOBALS['core']->sqlTableExists("mod_article", true)
        && $GLOBALS['core']->sqlTableExists("mod_article_sections", true)
        && $GLOBALS['core']->sqlTableExists("mod_article_config", true)   )
{
    $content .= "All Article Manager tables already exist.  Old data will be used.<br />";
    $olddata = true;
}
else
{
    $content .= "This is a new installation of Article Manager.<br />";
    $olddata = false;
}

/* If the old tables are already there or if new ones have sucessfully been written... */
if ($olddata || $GLOBALS['core']->sqlImport(PHPWS_SOURCE_DIR . "mod/article/boost/install.sql", TRUE)) 
{
    if (!$olddata)
        $content .= "All ArticleManager tables successfully written.<br />";

    CLS_Help::setup_help("article");

    function makedir ($dir)
    {
      $dirname = PHPWS_HOME_DIR . $dir;
      if (is_dir($dirname))
      {
        $text = 'Article Manager image directory '.$dirname.' already exists!<br />';
        return;
      }
      mkdir($dirname);
      if (is_dir($dirname))
      {
        $text = 'Article Manager image directory '.$dirname.' successfully created!<br />';
        chmod($dirname,0777);
      }
      else
        $text = 'We could not create the image archive: '. $dirname
                . '<br />You\'ll have to do this manually!<br />';
      return $text;
    }
    /* Create the main image directory */
    $content .= makedir('images/article');
    /* Create the image library directory */
    $content .= makedir('images/article/library');
    /* Create the first image storage directory */
    $content .= makedir('images/article/1');
    /* Create the image archive directory */
    $content .= makedir('images/article/old');
    /* Create import directories for PageMaster & Announce */
    $content .= makedir('images/article/PM');
    $content .= makedir('images/article/ANN');

    /* Register with search module */
    if(isset($_SESSION['OBJ_search']))
    {
        $search['module'] = 'article';
        $search['search_class'] = 'PHPWS_ArticleManager';
        $search['search_function'] = 'search';
        $search['search_cols'] = 'S.title, S.text'; 
        $search['view_string'] = '&amp;view=';
        $search['show_block'] = 1;

        if(!$GLOBALS['core']->sqlInsert($search, 'mod_search_register'))
          $content .= 'Problem registering search<br />';
        else
          $content .= 'Registered with Search module!<br />';
    }

    $status = 1;
} 
else
    $content .= 'There was a problem writing to the database.<br />';
?>
--- NEW FILE: install.sql ---
CREATE TABLE mod_article (
  id int PRIMARY KEY,
  title varchar(80) NOT NULL,
  section_order text NOT NULL,
  mainarticle smallint NOT NULL DEFAULT '0',
  rank smallint NOT NULL DEFAULT '50',
  created_username varchar(20) NOT NULL,
  updated_username varchar(20) NOT NULL,
  created_date datetime NOT NULL,
  updated_date datetime 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 datetime,
  publication_date datetime NOT NULL,
  wordcount smallint NOT NULL DEFAULT '0',
  pages smallint NOT NULL,
  template varchar(50) NOT NULL DEFAULT 'Blank',
  editlock int NOT NULL,
  edituser int NOT NULL,
  approved smallint NOT NULL DEFAULT '0',
  version smallint NOT NULL DEFAULT '0',
  announce smallint NOT NULL DEFAULT '1',

	key (hits),
	key (expiration_date),
	key (updated_date),
	key (publication_date)
);

INSERT INTO mod_article VALUES ('Article Manager Demo Article', 'a:1:{i:0;i:1;}', 1, 50, 'eloi', 'eloi', '2002-12-05 13:51:40', '2002-12-05 15:29:24', '', 0, 0, 16, '2007-12-05 00:00:00', '2002-12-05 00:00:00', 54, 1, 'Blank', 0, 0, 1, 0, 1);
INSERT INTO mod_article VALUES ('Introduction to Article Manager', 'a:11:{i:0;i:2;i:1;i:3;i:2;i:4;i:3;i:6;i:4;i:7;i:5;i:5;i:6;i:8;i:7;i:9;i:8;i:10;i:9;i:11;i:10;i:12;}', 0, 50, 'eloi', 'eloi', '2002-12-05 15:14:06', '2003-03-25 23:19:36', 'The ArticleManager module lets you create dynamic web articles that display your site\'s content the way -you- want it to be displayed!', 0, 0, 57, '2007-12-05 00:00:00', '2002-12-05 00:00:00', 1661, 5, 'Blank', 0, 0, 1, 3, 1);

CREATE TABLE mod_article_sections (
     id int PRIMARY KEY,
     title varchar(100) NOT NULL,
     text longtext NOT NULL,
     image_name varchar(255),
     image_directory varchar(255) NOT NULL,
     image_height int NOT NULL,
     image_width int NOT NULL,
     image_alt varchar(255) NOT NULL,
     image_link varchar(255) NOT NULL,
     image_caption varchar(255) NOT NULL,
     template varchar(255) NOT NULL DEFAULT 'Centered Image',
     new_page smallint NOT NULL DEFAULT '0',
     article_id int NOT NULL DEFAULT '0',

     key (article_id)
);

INSERT INTO mod_article_sections VALUES ('Article Manager Demo Section', 'Welcome to Article Manager!\r\n\r\nThis article was automatically generated when you installed Article Manager.\r\n\r\nIf you want to see an overview of the features of this module, check out "<a href="index.php?module=article&amp;view=2">Introduction to Article Manager</a>".\r\n\r\nTo get started using Article Manager, proceed to the <a href="index.php?module=article&amp;disp=main_menu">administrative menu</a> or go the the <a href="index.php?module=article&amp;disp=news">"News"</a> page that lists all articles on your site.\r\n\r\nAnd most importantly, have fun with it!\r\neloi', '', '', 0, 0, '', '', '', 'Centered Image', 0, 1);
INSERT INTO mod_article_sections VALUES ('Features', 'NOTE: This introduction is for demo purposes only and is current as of the first release of Article Manager. For the most up-to-date version, look under the docs directory.\r\n\r\nCustom articles - each section can look completely different\r\nDefine your own article and section templates\r\nAdmins can allow/deny ability to display external pages in an embedded frame\r\nUsers can add comments to your article\r\nUsers can view a list of the articles that they have created\r\nArticles keep track of how many times thay\'ve been viewed\r\nArticles can be set to start showing at a future date\r\nArticles can expire on specified dates\r\nArticles can be viewed in summary format with a link to the full article\r\nMULTI-ARTICLE STORIES with automatic navigation controls!\r\nOptimization: Images are stored in multiple directories for faster access\r\nA library of approved images can be easily maintained\r\nImages can be clickable links with alternate text and photo captions\r\nExpired articles can be accessed from a list and re-activated\r\nModule settings are easily changeable\r\nUser-submitted articles can require approval before activation\r\n"Also on this site.." Block\r\n"Previous n Articles" Block\r\n"Most Popular Articles" Block\r\nArticles can be set to not show up in the homepage summary listings\r\nArticles can be assigned to topic categories\r\nArticles can be viewed only by certain groups\r\nAll of your old Announcements &amp; PageMaster Module content can be imported\r\nAutomatic rerouting of old mod.php, Announcements &amp; PageMaster links\r\nDisplay a printable version\r\nNothing is saved to disk until you hit "Save Page"\r\n"Edit Locking" - Only 1 user can edit a page at a time\r\nA "News" page that displays all articles', '', '', 0, 0, '', '', '', 'Centered Image', 0, 5);
INSERT INTO mod_article_sections VALUES ('The Main Menu', 'The main menu is the nerve center of the entire module. It allows you to do four basic tasks -- list articles, create a new article, change Article Manager configuration settings and manage the Image Library.', '', '', 0, 0, '', '', '', 'Centered Image', 1, 3);
INSERT INTO mod_article_sections VALUES ('List Articles:', 'Here you can choose to view all approved articles on the site or just your articles ordered by Title or by the date of creation, publication, expiration, or the last update. This list can be viewed in ascending or descending order.\r\n\r\nEach article in the listing is accompanied by buttons allowing you to set it as the homepage, edit it, delete it, or immediately publish or expire it. Of course buttons or options can only be seen if you are authorized to use them.', '', '', 0, 0, '', '', '', 'Centered Image', 0, 2);
INSERT INTO mod_article_sections VALUES ('Image Library Management', 'Instead of taking the security risk of allowing users to upload images to the server, admin-approved images can be stored in and selected from the Image Library.\r\n\r\nAfter an image is uploaded to the library using the "Image Library Management" interface, it will appear on the list underneath that also gives you the opportunity to delete existing pictures.', '', '', 0, 0, '', '', '', 'Centered Image', 0, 3);
INSERT INTO mod_article_sections VALUES ('Create a new article:', 'See the next section "CREATING &amp; EDITING ARTICLES".', '', '', 0, 0, '', '', '', 'Centered Image', 0, 2);
INSERT INTO mod_article_sections VALUES ('Change configuration settings:', 'We\'ve made module customization easier for you by allowing you to change the following default settings:\r\n\r\n	The default page template\r\n	The default section template\r\n	The # of summaries that show up on the Home Page\r\n	The # of summaries that show up on article summary listings\r\n	The # of article listings that show up under the main menu\r\n	Whether articles need approval before publication\r\n	Whether articles can expire on a predefined date\r\n	Default expiration date offsets (years, months, days)\r\n	How many years in advance publication dates can be set\r\n	Uploaded image size limits (filesize, height, width)\r\n\r\nAdministrators can also decide whether users can:\r\n\r\n	upload images\r\n	include images in articles\r\n	add comments to articles\r\n	post comments without registering (Anonymous)\r\n	create new articles\r\n	edit/delete any, all, or just their own articles\r\n	choose when their articles expire\r\n	publish articles without admin approval\r\n	change the module configuration ', '', '', 0, 0, '', '', '', 'Centered Image', 0, 3);
INSERT INTO mod_article_sections VALUES ('Creating &amp; Editing Articles', 'Articles are basically made up of a title, article summary, and sections. Other information found on the article can include information on the author and the date created or edited. \r\n\r\nTITLE:\r\nAll articles need titles! Enter one here.\r\n\r\n\r\nSUMMARY:\r\nType in a SHORT description of the article here. When a list of articles is shown on the site, this will be displayed as a teaser to get the user to read more.\r\n\r\n\r\nSECTIONS:\r\nThis is the meat of the article. A article can contain as few or as many sections as you like. When you create or start editing a article, all currently save sections are displayed as finished. After each section you will see buttons to edit that section or to move the section above or below its neighbors.\r\n\r\nNear the bottom of the article a new blank section is created for you with its own "Save" button. See "Editing Sections" for a description of how they work.\r\n\r\nCONFIGURATION OPTIONS: \r\nCategory: \r\nThe topic categories that this article falls under.\r\n\r\nAllow Comments: \r\nWhether users can add discussion or comments to this article\r\n\r\nAllow Anonymous Comments: \r\nWhether unregistered user can add comments (NOT RECOMMENDED!)\r\n\r\nPublication Date: \r\nA story can only be viewable on the site after it is published. You don\'t need to change this value. It is automatically set to the date this story was created. If you want this story to be invisible until a future date, then you can set it here.\r\n\r\nExpiration Date:\r\nA story can only remain on the site until it expires. You don\'t need to change this value. The site administrator has set a default period before stories expire. If you want this story to be deleted before or after this date, then you can set it here.\r\n\r\n\r\nWHAT DO I NEED CATEGORIES FOR?\r\nIf this article is assigned to a category, ArticleManager can then work with other phpWebsite modules to group related articles together and give interested users suggestions on other articles to surf.\r\n\r\nARTICLE INFORMATION:\r\nNOTE -- These items are not editable. \r\nCreated By: Who created the article\r\nUpdated By: the last person to edit the article\r\nCreated On: When the article was created\r\nUpdated On: When the article was last edited\r\n\r\nSave Article:\r\nClick this button when you\'re finished editing. If all information was entered in correctly, you\'ll be taken back to the main menu.', '', '', 0, 0, '', '', '', 'Centered Image', 1, 2);
INSERT INTO mod_article_sections VALUES ('Creating &amp; Editing Sections', 'Each section consists of a title and text (and sometimes an image). You can think of the title of a section as a subtitle of the article. Whenever you start editing a article or save a section, a new one is created for you.\r\n\r\nSTART ON NEW PAGE:\r\nThis option enables multi-article stories. When enabled, this section will be the first of a new page.\r\n\r\nTITLE:\r\nNot necessary, but recommended. Enter the section title here.\r\n\r\nTEXT:\r\nType in the section\'s text here. I\'m not sure if there is a limit to how much text you can put here, but if you hit it, you\'ll know. Above this entry box is a text formatting bar that you can use to add html formatting to your text. You\'ll at least need to use the "new line" button to create line breaks.\r\n\r\nIMAGE:\r\nIf you already added an image to this section, it\'s displayed here. If you are authorized, you will be given the options of uploading an image or selecting an existing image to display.\r\n\r\nUPLOAD A NEW IMAGE:\r\nThis lets you upload an image that will be associated with this section. If you choose to use an image, you must also add a Short Image Description.\r\n\r\nSELECT AN IMAGE FROM THE LIBRARY:\r\nThis site maintains a library of pre-approved images to use as an alternative to making, optimizing and uploading custom images. Just select the image you want to be associated with this section. If you choose to use an image, you must also add a Short Image Description.\r\n\r\nALTERNATE TEXT (Short Image Description): \r\nREQUIRED! Enter a short description of the image that will display if a browser can\'t or won\'t show the image. \r\n\r\nLINK:\r\nPutting a link URL in here will turn the image into a clickable link.\r\n\r\nLINK (PHOTO) CAPTION:\r\nSometimes you might want some text to appear above or below the image (eq: Photo Credits). Enter that text here.\r\n\r\nCONFIGURATION OPTIONS: \r\nStart on New Article: Whether this section starts a new article. See "MAKING MULTIPLE-ARTICLE STORIES".\r\nTemplate	 : Choose a display format for this section.\r\n\r\nSAVE SECTION:\r\nClick this button when you\'re finished editing. If all information was entered in correctly, the article will re-display with the section in its proper place.\r\n\r\n\r\nWHAT ARE TEMPLATES?\r\nEach section can be displayed in a different way -- with an image on the left, right, above the text, with a different-colored title, or even with all the text centered on the article! This is all controlled by templates that the administrator creates. All you have to do is select which display format you want to use for this section. If you want to read about creating or changing templates, see TEMPLATES.TXT.', '', '', 0, 0, '', '', '', 'No Images', 1, 3);
INSERT INTO mod_article_sections VALUES ('Making Multiple-Article Stories', 'Although webarticle content should always be as short and concise as possible, sometimes your article needs to be spread across more that one article. Usually when this happens we create several similarly-titled articles with links to related content:\r\n\r\nHow to Plan a Party: Getting Started\r\nHow to Plan a Party: Choosing the Place\r\nHow to Plan a Party: Picking the Music\r\nHow to Plan a Party: Get the Word Out\r\nHow to Plan a Party: Collect the Cash!\r\nLease Negotiation Tactics\r\nHow to get a DJ\r\nAdvertisement Media Effectiveness Statistics\r\n\r\nProblem is, for each one of the "Planning the Party" articles, we have to create links to 4 other articles! What happens if we add a article? We have to add &amp; change links in 6 articles!', '', '', 0, 0, '', '', '', 'Centered Image', 1, 2);
INSERT INTO mod_article_sections VALUES ('Enter ArticleManager!', 'Whenever you want a section to start on a new page, just check the "Start on new page" box. ArticleManager will automagically divide your story into pages when it\'s displayed on your site. Each page\'s title will be the title of the first section on that page. So now your list of pages looks like this:\r\n\r\nHow to Plan a Party\r\nLease Negotiation Tactics\r\nHow to get a DJ\r\nAdvertisement Media Effectiveness Statistics\r\n\r\nand when you click on "How to Plan a Party", the bottom of the pages will look like this:\r\n\r\n\r\n<center>Previous Page &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp Next Page\r\n\r\n			Page 1: Getting Started\r\n			Page 2: Choosing the Place\r\n			Page 3: Picking the Music\r\n			Page 4: Get the Word Out\r\n			Page 5: Collect the Cash!</center>\r\n\r\nSince this is all basically one article, they will all have the same link (example:www.yoursite.com/index.php ?module=article &amp;view=2). However, if you want to link directly to page 4 just add"&amp;page_num=4" to the end of the url so it looks like this: www.yoursite.com/index.php ?module=article &amp;view=2&amp;page_num=4\r\n\r\nIf you click the Print Icon, the ENTIRE story will print out. Not just the current page.', '', '', 0, 0, '', '', '', 'Centered Image', 0, 2);
INSERT INTO mod_article_sections VALUES ('Cool Tip!', 'If you want to see the entire article on one webpage, change the url to &amp;page_num=all', '', '', 0, 0, '', '', '', 'Centered Image', 0, 2);

CREATE TABLE mod_article_config (
default_article_template varchar(255) NOT NULL DEFAULT "Blank",
default_section_template varchar(255) NOT NULL DEFAULT "Centered Image",
popular_articles smallint NOT NULL DEFAULT '5',
summaries_on_homepage smallint NOT NULL DEFAULT '5',
prev_n_articles smallint NOT NULL DEFAULT '5',
listings_per_page smallint NOT NULL DEFAULT '20',
need_approval smallint NOT NULL DEFAULT '1',
default_allow_comments smallint NOT NULL DEFAULT '1',
default_allow_anon smallint NOT NULL DEFAULT '0',
can_expire smallint NOT NULL DEFAULT '0',
expiration_years smallint NOT NULL DEFAULT '3',
expiration_months smallint NOT NULL DEFAULT '0',
expiration_days smallint NOT NULL DEFAULT '0',
default_year_count smallint NOT NULL DEFAULT '10',
max_image_size int NOT NULL DEFAULT '26700',
max_image_height int NOT NULL DEFAULT '400',
max_image_width int NOT NULL DEFAULT '400',
users_can_submit smallint NOT NULL DEFAULT '0',
users_select_article_tpl smallint NOT NULL DEFAULT '0',
users_select_section_tpl smallint NOT NULL DEFAULT '0',
users_allow_comments smallint NOT NULL DEFAULT '0',
users_change_dates smallint NOT NULL DEFAULT '0',
user_images_in_article smallint NOT NULL DEFAULT '0',
user_upload_images smallint NOT NULL DEFAULT '0',
restricted_viewing smallint NOT NULL DEFAULT '0',
lock_expiration_time int NOT NULL DEFAULT '3600',
make_metatags smallint NOT NULL DEFAULT '0',
print_header text NOT NULL
);

INSERT INTO mod_article_config VALUES ('Blank', 'Centered Image', 5, 5, 5, 20, 1, 1, 0, 0, 3, 0, 0, 10, 26, 400, 400, 0, 0, 0, 0, 0, 0, 0, 0, 3600, 0, '\r\n\r\n');

CREATE TABLE mod_article_oldversions (
     id int PRIMARY KEY,
     article_id int NOT NULL,
     archived_date datetime NOT NULL,
     changes text NOT NULL,

     key (article_id),
     key (archived_date)
);

--- NEW FILE: uninstall.php ---
<?php
/**
 * This is the Article Manager uninstall file for Boost
 *
 * @version \$Id\$
 * @author Eloi George <el...@NO...>
 */
if (!$_SESSION["OBJ_user"]->isDeity())
{
  header("location:index.php");
  exit();
}

if ($GLOBALS["core"]->sqlImport(PHPWS_SOURCE_DIR."mod/article/boost/uninstall.sql", 1, 1)) 
{
    $content .= "All tables successfully removed.<br />";

    $content .= "Removing images directory ".PHPWS_HOME_DIR."images/article<br />";
    system("rm -rf " . PHPWS_HOME_DIR . "images/article", $temp);

    /* Unregister from Help */
    if (isset($_SESSION["OBJ_help"]))
        $_SESSION["OBJ_help"]->uninstall_help("article");

    /* Unregister from Approval */
    if (isset($_SESSION["OBJ_approval"]))
        $_SESSION["OBJ_approval"]->remove("article");

    /* Unregister from Search */
    if(isset($_SESSION["OBJ_search"]))
        $GLOBALS["core"]->sqlDelete("mod_search_register", "module", "article");

    /* Unregister from Comments */
    if(isset($_SESSION['PHPWS_CommentManager']))
        $GLOBALS['core']->sqlDelete('mod_comments_data', 'module', 'article');

    $status = 1;
}
else 
{
    $content .= "There was a problem accessing the database.<br />";
    $bst_error = 1;
}
?>
--- NEW FILE: uninstall.sql ---
DROP TABLE mod_article;
DROP TABLE mod_article_sections;
DROP TABLE mod_article_config;
DROP TABLE mod_article_oldversions;

[phpws-comm-commits] modules/article/boost install.php,NONE,1.1 install.sql,NONE,1.1 uninstall.php,N

[phpws-comm-commits] modules/article/boost install.php,NONE,1.1 install.sql,NONE,1.1 uninstall.php,NONE,1.1 uninstall.sql,NONE,1.1