Changeset 1502 in ExiteCMS


Ignore:
Timestamp:
07/02/08 08:50:05 (4 years ago)
Author:
hverton
Message:

updated the setup procedure with the latest database changes

Location:
trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • trunk/administration/tools/language_pack_English.php

    r1498 r1502  
    31273127        $localestrings['475'] = "News"; 
    31283128        $localestrings['476'] = "Panels"; 
    3129         $localestrings['477'] = "x"; 
     3129        $localestrings['477'] = "Reports"; 
    31303130        $localestrings['478'] = "PHP Info"; 
    31313131        $localestrings['479'] = "Polls"; 
    3132         $localestrings['480'] = "x"; 
     3132        $localestrings['480'] = "Searches"; 
    31333133        $localestrings['481'] = "Menu System"; 
    31343134        $localestrings['482'] = "x"; 
    … …  
    31563156        $localestrings['507'] = "Search"; 
    31573157        $localestrings['508'] = "Register"; 
     3158        $localestrings['509'] = "Reports"; 
    31583159        $localestrings['520'] = "Main Menu"; 
    31593160        $localestrings['521'] = "Online Users"; 

  • trunk/administration/tools/language_pack_Nederlands.php

    r1498 r1502  
    31273127        $localestrings['475'] = "Nieuws"; 
    31283128        $localestrings['476'] = "Panelen"; 
    3129         $localestrings['477'] = "x"; 
     3129        $localestrings['477'] = "Rapporten"; 
    31303130        $localestrings['478'] = "PHP informatie"; 
    31313131        $localestrings['479'] = "Polls"; 
    3132         $localestrings['480'] = "x"; 
     3132        $localestrings['480'] = "Zoekacties"; 
    31333133        $localestrings['481'] = "Menu systeem"; 
    31343134        $localestrings['482'] = "x"; 
    … …  
    31563156        $localestrings['507'] = "Zoeken"; 
    31573157        $localestrings['508'] = "Registreren"; 
     3158        $localestrings['509'] = "Rapportages"; 
    31583159        $localestrings['520'] = "Hoofdmenu"; 
    31593160        $localestrings['521'] = "Online gebruikers"; 

  • trunk/files/locales/en.main.setup.php

    r1478 r1502  
    33// locale       : English 
    44// locale name  : main.setup 
    5 // generated on : Wed Jun 18 2008, 12:56:20 CEST 
     5// generated on : Tue Jul 1 2008, 19:42:17 CEST 
    66// translators  : ExiteCMS team,WanWizard 
    77// ---------------------------------------------------------- 

  • trunk/includes/dbsetup_include.php

    r1496 r1502  
    22//---------------------------------------------------------- 
    33// ExiteCMS file : dbsetup_include.php 
    4 // Date generated  : `01/07/2008 22:00` 
    5 // Generated by : `WanWizard` 
     4// Date generated  : `02/07/2008 08:40` 
    65//---------------------------------------------------------- 
    76 
    8 define('CMS_VERSION', '7.20'); 
     7define('CMS_VERSION', '7.10'); 
    98define('CMS_REVISION', '1500'); 
    109 
    … …  
    228227    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('locale', 'English')"); 
    229228    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_expire', '7200')"); 
    230     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '604800')"); 
     229    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('login_extended_expire', '84600')"); 
    231230    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('longdate', '%m/%d/%Y %H:%M:%S')"); 
    232231    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance', '0')"); 
    … …  
    234233    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('maintenance_message', '')"); 
    235234    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users', '0')"); 
    236     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '1193029685')"); 
     235    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('max_users_datestamp', '0')"); 
    237236    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('navbar_range', '5')"); 
    238237    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('newsletter_email', 'noreply@example.com')"); 
    … …  
    265264    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('session_name', 'ExiteCMSid')"); 
    266265    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('shortdate', '%m/%d/%Y')"); 
    267     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'webmaster@example.com')"); 
     266    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteemail', 'website@example.com')"); 
    268267    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('siteintro', '<center>\r\n<b>This website is under construction at the moment!</b><br /><br />\r\nExiteCMS v7.2 ©2008 Exite BV.</center>')"); 
    269268    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('sitelinks_localisation', 'none')"); 
    … …  
    286285    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('unread_threshold', '90')"); 
    287286    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('validation_method', 'image')"); 
    288     $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('version', '7.20')"); 
     287    $result = dbquery("INSERT INTO ".$db_prefix."configuration (cfg_name, cfg_value) VALUES('version', '7.10')"); 
    289288} 
    290289 
    … …  
    850849 
    851850// 
    852 // Code to create table `reporting` 
    853 // 
    854 $result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."reporting"); 
    855 $result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."reporting ( 
     851// Code to create table `reports` 
     852// 
     853$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."reports"); 
     854$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."reports ( 
    856855  `report_id` smallint(5) unsigned NOT NULL auto_increment, 
    857   `report_ident` varchar(4) NOT NULL default '', 
    858   `report_title` varchar(50) NOT NULL default '', 
    859   `report_active` tinyint(1) NOT NULL default 0, 
    860   `report_groups` text NOT NULL, 
    861   `report_code` text NOT NULL, 
     856  `report_mod_id` smallint(5) unsigned NOT NULL default 0, 
     857  `report_name` varchar(100) NOT NULL default '', 
     858  `report_title` varchar(100) NOT NULL default '', 
     859  `report_version` varchar(10) NOT NULL default '0', 
     860  `report_active` tinyint(1) unsigned NOT NULL default 0, 
     861  `report_visibility` tinyint(3) NOT NULL default 0, 
    862862  PRIMARY KEY  (`report_id`) 
    863863) ENGINE=MyISAM;"); 
    864864if (!$result) { 
    865865    $fail = "1"; 
    866     $failed[] = "reporting : ".mysql_error(); 
     866    $failed[] = "reports : ".mysql_error(); 
     867} 
     868 
     869// 
     870// Code to create table `searches` 
     871// 
     872$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."searches"); 
     873$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."searches ( 
     874  `search_id` smallint(5) unsigned NOT NULL auto_increment, 
     875  `search_mod_id` smallint(5) unsigned NOT NULL default 0, 
     876  `search_name` varchar(100) NOT NULL default '', 
     877  `search_title` varchar(100) NOT NULL default '', 
     878  `search_version` varchar(10) NOT NULL default '0', 
     879  `search_visibility` tinyint(3) NOT NULL default 0, 
     880  PRIMARY KEY  (`search_id`) 
     881) ENGINE=MyISAM;"); 
     882if (!$result) { 
     883    $fail = "1"; 
     884    $failed[] = "searches : ".mysql_error(); 
    867885} 
    868886 

  • trunk/setup.php

    r1480 r1502  
    329329            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('UG', 'user_groups.gif', '".addslashes($locale['484'])."', 'user_groups.php', 2)"); 
    330330            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('UR', 'submissions.gif', '".addslashes($locale['496'])."', 'redirects.php', 1)"); 
    331             $result = dbcommands($commands, $db_prefix); 
    332  
    333             // add the default 404 page to the custom pages table 
    334             $commands = array(); 
    335             $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##custom_pages (page_title, page_access, page_content, page_allow_comments, page_allow_ratings) VALUES ('404 Error Page', 0, '".mysql_escape_string("<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\" width=\"100%\" align=\"center\"> <tbody><tr><td width=\"10\"> </td><td><div align=\"center\"><font size=\"6\"><span class=\"shoutboxname\"><br />404 - Page Not Found</span><br /></font></div><br /><br /><hr width=\"90%\" size=\"2\" /><br /><br /><div align=\"center\">".addslashes($locale['560'])."<br /></div><br /><div align=\"center\">".addslashes($locale['561'])."<br /></div><br /><div align=\"center\">".addslashes($locale['562'])."<br /></div><br /><br /><hr width=\"90%\" size=\"2\" /><br /><br /><div align=\"center\">".addslashes($locale['563'])."<br /></div><br /><div align=\"center\">".addslashes($locale['564'])."</div></td><td width=\"10\"> </td></tr></tbody></table><br />")."', 0, 0)"); 
    336             $commands[] = array('type' => 'db', 'value' => "UPDATE ##PREFIX##custom_pages SET page_id = 0"); 
     331            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('R',  'reports.gif', '".addslashes($locale['477'])."', 'reports.php', 3)"); 
     332            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##admin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S',  'searches.gif', '".addslashes($locale['480'])."', 'searches.php', 3)"); 
    337333            $result = dbcommands($commands, $db_prefix); 
    338334 
    … …  
    398394            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, panel_name) VALUES ('".addslashes($locale['506'])."', 'contact.php', '0', '1', '0', '8', 'main_menu_panel')"); 
    399395            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, panel_name) VALUES ('".addslashes($locale['507'])."', 'search.php', '0', '1', '0', '9', 'main_menu_panel')"); 
    400             $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, panel_name) VALUES ('".addslashes($locale['508'])."', 'register.php', '100', '2', '0', '10', 'main_menu_panel')"); 
     396            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, panel_name) VALUES ('".addslashes($locale['509'])."', 'reports.php', '0', '1', '0', '10', 'main_menu_panel')"); 
     397            $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, panel_name) VALUES ('".addslashes($locale['508'])."', 'register.php', '100', '2', '0', '11', 'main_menu_panel')"); 
    401398            $result = dbcommands($commands, $db_prefix); 
    402399 
Note: See TracChangeset for help on using the changeset viewer.