📄 201.php

📁 jsp程序开发系统
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php
// +-------------------------------------------------------------+
// | DeskPRO v [2.0.1 Production]
// | Copyright (C) 2001 - 2004 Headstart Solutions Limited
// | Supplied by WTN-WDYL
// | Nullified by WTN-WDYL
// | Distribution via WebForum, ForumRU and associated file dumps
// +-------------------------------------------------------------+
// | DESKPRO IS NOT FREE SOFTWARE
// +-------------------------------------------------------------+
// | License ID : Full Enterprise License =) ...
// | License Owner : WTN-WDYL Team
// +-------------------------------------------------------------+
// | $RCSfile: 201.php,v $
// | $Date: 2004/02/12 21:16:57 $
// | $Revision: 1.10 $
// +-------------------------------------------------------------+
// | File Details:
// | - Worker script to upgrade from v2.0.0 Beta 1 to v2.0.0 Beta 2
// +-------------------------------------------------------------+

error_reporting(E_ALL & ~E_NOTICE);
ob_implicit_flush();
install_check();

############################################# STEP 1 #############################################

if ($_REQUEST['step'] == 1) {

	/*
		- Remove duplicated id indexes (unique when we have primary already)
		- Set some ids as primary which are currently just an index
	*/

	$db->Halt_On_Error = 'no';

	do_message("Removing duplicate id indexes & adding primary keys");

	$queries = array(
		"ALTER TABLE `gateway_error` DROP INDEX `id`",
		"ALTER TABLE `gateway_error` ADD INDEX (`id`)",
		"ALTER TABLE `gateway_error` CHANGE `id` `id` INT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT",
		"ALTER TABLE `gateway_error` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `gateway_error` DROP INDEX `id`",
		"ALTER TABLE `escalate` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `languages` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `user_help_cats` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `ticket_notes` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `tech_ticket_save` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `ticket_fielddisplay` DROP PRIMARY KEY , ADD PRIMARY KEY ( `id` ) ",
		"ALTER TABLE `blobs ` DROP INDEX `id`",
		"ALTER TABLE `calendar_task` DROP INDEX `id`",
		"ALTER TABLE `faq_articles` DROP INDEX `id`",
		"ALTER TABLE `faq_attachments` DROP INDEX `id`",
		"ALTER TABLE `faq_cats` DROP INDEX `id`",
		"ALTER TABLE `faq_comments` DROP INDEX `id`",
		"ALTER TABLE `faq_searchlog` DROP INDEX `id`",
		"ALTER TABLE `faq_searchlog` DROP INDEX `id_2`",
		"ALTER TABLE `faq_word` DROP INDEX `id`",
		"ALTER TABLE `gateway_accounts` DROP INDEX `id`",
		"ALTER TABLE `gateway_spam` DROP INDEX `id`",
		"ALTER TABLE `gateway_spam` DROP INDEX `id_2`",
		"ALTER TABLE `news` DROP INDEX `id`",
		"ALTER TABLE `quickreply` DROP INDEX `id`",
		"ALTER TABLE `quickreply_cat` DROP INDEX `id`",
		"ALTER TABLE `report` DROP INDEX `id`",
		"ALTER TABLE `report_stat` DROP INDEX `id`",
		"ALTER TABLE `report_style` DROP INDEX `id`",
		"ALTER TABLE `search` DROP INDEX `id`",
		"ALTER TABLE `search` DROP INDEX `techid_2`",
		"ALTER TABLE `settings` DROP INDEX `id`",
		"ALTER TABLE `settings_cat` DROP INDEX `id`",
		"ALTER TABLE `tech` DROP INDEX `id`",
		"ALTER TABLE `tech_attachments` DROP INDEX `id`",
		"ALTER TABLE `tech_news` DROP INDEX `id`",
		"ALTER TABLE `tech_sendmail` DROP INDEX `id`",
		"ALTER TABLE `tech_ticket_watch` DROP INDEX `id`",
		"ALTER TABLE `template_cat` DROP INDEX `id`",
		"ALTER TABLE `template_email` DROP INDEX `id`",
		"ALTER TABLE `template_replace` DROP INDEX `id`",
		"ALTER TABLE `ticket_attachments` DROP INDEX `id`",
		"ALTER TABLE `ticket_cat` DROP INDEX `id`",
		"ALTER TABLE `ticket_def` DROP INDEX `id`",
		"ALTER TABLE `ticket_log` DROP INDEX `id`",
		"ALTER TABLE `ticket_message` DROP INDEX `id`",
		"ALTER TABLE `ticket_pri` DROP INDEX `id`",
		"ALTER TABLE `user` DROP INDEX `id`",
		"ALTER TABLE `user_def` DROP INDEX `id`",
		"ALTER TABLE `user_notes` DROP INDEX `id`",
		"ALTER TABLE `user_help_cats` DROP INDEX `id`",
		"ALTER TABLE `tech_ticket_save` DROP INDEX `id`",
		"ALTER TABLE `ticket` DROP INDEX `id`"
	);

	execute($queries);
	do_message_yes();

}

############################################# STEP 2 #############################################

if ($_REQUEST['step'] == 2) {

	/*
		- Add new fields to the database
		- Modify fields in the database
	*/

	$db->Halt_On_Error = 'no';

	do_message("Adding / modifying database fields");

	$queries = array(
		"ALTER TABLE template_words ADD cust INT(1) NOT NULL DEFAULT '0'",
		"ALTER TABLE calendar_task ADD timezone_dst int(1) NOT NULL DEFAULT ''",
		"ALTER TABLE calendar_task ADD timezone int(10) NOT NULL DEFAULT ''",
		"ALTER TABLE user ADD name varchar(250) NOT NULL DEFAULT ''",
		"ALTER TABLE user ADD timezone INT(10) NOT NULL DEFAULT ''",
		"ALTER TABLE user ADD timezone_dst INT(1) NOT NULL DEFAULT ''",
		"ALTER TABLE calendar_task ADD weekstart int(11) NOT NULL DEFAULT '0'",
		"ALTER TABLE faq_articles ADD views int(10) NOT NULL DEFAULT '0'",
		"ALTER TABLE faq_comments ADD new int(1) NOT NULL DEFAULT '0'",
		"ALTER TABLE languages ADD isocode varchar(250) NOT NULL DEFAULT ''",
		"ALTER TABLE languages ADD contenttype varchar(250) NOT NULL DEFAULT ''",
		"ALTER TABLE languages ADD direction enum('ltr', 'rtl') default 'ltr' NOT NULL",
		"ALTER TABLE query_log ADD filename varchar(250) NOT NULL DEFAULT ''",
		"ALTER TABLE settings ADD options varchar(250)  NOT NULL DEFAULT ''",
		"ALTER TABLE tech ADD email_faq int(1) NOT NULL DEFAULT '0'",
		"ALTER TABLE tech ADD userfield_selection mediumtext NOT NULL DEFAULT ''",
		"ALTER TABLE tech ADD timezone varchar(32)  NOT NULL DEFAULT ''",
		"ALTER TABLE tech ADD p_html_tech int(1) NOT NULL DEFAULT '0'",
		"ALTER TABLE tech ADD p_html_user int(1) NOT NULL DEFAULT '0'",
		"ALTER TABLE tech ADD timezone_dst int(11) NOT NULL DEFAULT '0'",
		"ALTER TABLE user ADD timezone varchar(32) NOT NULL DEFAULT ''",
		"ALTER TABLE user ADD weekstart int(11) NOT NULL DEFAULT '0'",
		"ALTER TABLE query_log CHANGE duration duration decimal(15,10)",
		"ALTER TABLE `settings` CHANGE category category int(10) NOT NULL default '0'",
		"ALTER TABLE `pm_relations` CHANGE `pmid` `pmid` INT( 10 ) DEFAULT '0' NOT NULL",
		"ALTER TABLE `pm_relations` DROP INDEX `pmid`",
		"ALTER TABLE `pm_relations` DROP INDEX techid",
		"ALTER TABLE `pm_relations` DROP PRIMARY KEY , ADD PRIMARY KEY ( `pmid`, `techid` ) ",
		"ALTER TABLE quickreply DROP global",
		"ALTER TABLE settings DROP `int`",
		"ALTER TABLE settings DROP `type`",
		"ALTER TABLE tech DROP faq_editor_yes",
		"ALTER TABLE tech DROP faq_editor_no",
		"ALTER TABLE ticket DROP date_reply",
		"ALTER TABLE ticket DROP closed_by"
	);

	execute($queries);
	do_message_yes();

}

############################################# STEP 3 #############################################

if ($_REQUEST['step'] == 3) {

	/*
		- Drop unused tables
		- Create new tables
	*/

	$db->Halt_On_Error = 'no';

	do_message("Removing unused tables & creating tech_sendmail table");

	$queries = array(
		"DROP TABLE settingcat",
		"DROP TABLE ticket_message_source",
		"DROP TABLE faq_wordindex",
		"DROP TABLE spellwords",
		"DROP TABLE tech_cat",
		"DROP TABLE template_backup",
		"DROP TABLE templatecat",
		"CREATE TABLE tech_sendmail (
		  id int(10) NOT NULL auto_increment,
		  parent int(10) NOT NULL default '0',
		  techid int(10) NOT NULL default '0',
		  subject varchar(255) NOT NULL default '',
		  message mediumtext NOT NULL,
		  from_email varchar(255) NOT NULL default '',
		  to_email varchar(255) NOT NULL default '',
		  tracking int(1) NOT NULL default '0',
		  awaiting_reply int(1) NOT NULL default '0',
		  pass varchar(7) NOT NULL default '',
		  date_sent int(10) NOT NULL default '0',
		  PRIMARY KEY  (id),
		  UNIQUE KEY id (id)
		)"
	);

	execute($queries);
	do_message_yes();

}

############################################# STEP 4 #############################################

if ($_REQUEST['step'] == 4) {

	/*
		Some queries to run but not produce errors
	*/

	$db->Halt_On_Error = 'no';

	do_message("Adding new indexes (1)");

	$queries = array(
		"ALTER TABLE `tech_ticket_watch` DROP INDEX techid ",
		"ALTER TABLE `tech_ticket_watch` ADD INDEX (`techid`,`created`)",
		"ALTER TABLE `ticket_def` DROP INDEX name ",
		"ALTER TABLE `ticket_cat` DROP INDEX user_view ",
		"ALTER TABLE `template_email` DROP INDEX name ",
		"ALTER TABLE `template_email` ADD INDEX (`name`)",
		"ALTER TABLE `template` DROP INDEX name ",
		"ALTER TABLE `template` ADD INDEX (`name`)",
		"ALTER TABLE `faq_cats_related` DROP INDEX show_cat ",
		"ALTER TABLE `faq_cats_related` ADD INDEX (`show_cat`)",
		"ALTER TABLE `faq_comments` DROP INDEX new",
		"ALTER TABLE `faq_comments` ADD INDEX (`new`)",
		"ALTER TABLE `faq_comments` DROP INDEX articleid",
		"ALTER TABLE `faq_comments` ADD INDEX (`articleid`)",
		"ALTER TABLE `quickreply` DROP INDEX techid",
		"ALTER TABLE `quickreply` ADD INDEX (`techid`) ",
		"ALTER TABLE `tech_attachments` DROP INDEX techid",
		"ALTER TABLE `tech_attachments` ADD INDEX (`techid`) ",
		"ALTER TABLE `tech_attachments` DROP INDEX category",
		"ALTER TABLE `tech_attachments` ADD INDEX (`category`) ",
		"ALTER TABLE `tech_email` DROP INDEX fieldname",
		"ALTER TABLE `tech_help_entry` DROP INDEX category",
		"ALTER TABLE `tech_help_entry` ADD INDEX (`category`) ",
		"ALTER TABLE `tech_notes` DROP INDEX category",
		"ALTER TABLE `tech_notes` DROP INDEX techid",
		"ALTER TABLE `tech_notes` ADD INDEX (`techid`,`category`) ",
		"ALTER TABLE `tech_email` DROP INDEX techid",
		"ALTER TABLE `tech_email` ADD INDEX techid",
		"ALTER TABLE `tech_bookmarks` DROP INDEX category",
		"ALTER TABLE `tech_bookmarks` DROP INDEX techid",
		"ALTER TABLE `tech_bookmarks` ADD INDEX (`techid`,`category`) ",
		"ALTER TABLE `tech_session` DROP INDEX techid",
		"ALTER TABLE `tech_session` ADD INDEX (`techid`) ",
		"ALTER TABLE `faq_articles` DROP INDEX ref ",
		"ALTER TABLE `faq_articles` ADD UNIQUE (`ref`) ",
		"ALTER TABLE `tech_ticket_search` DROP INDEX techid",
		"ALTER TABLE `tech_ticket_search` ADD INDEX (`techid`) ",
		"ALTER TABLE `tech_timelog` DROP INDEX techid",
		"ALTER TABLE `tech_timelog` ADD INDEX (`techid`) ",
		"ALTER TABLE `tech_timelog_archive` DROP INDEX techid",		
		"ALTER TABLE `tech_timelog_archive` ADD INDEX (`techid`) ",	
		"ALTER TABLE `template_words` DROP INDEX language",		
		"ALTER TABLE `template_words` ADD INDEX (`language`) ",	
		"ALTER TABLE `template_words` DROP INDEX category",	
		"ALTER TABLE `template_words` DROP INDEX wordref"

	);

	execute($queries);
	do_message_yes();

}

############################################# STEP 5 #############################################

if ($_REQUEST['step'] == 5) {
	
	/*
		Some queries to run but not produce errors
	*/

	$db->Halt_On_Error = 'no';

	do_message("Adding new indexes (2)");

	$queries = array(
		"ALTER TABLE `ticket` DROP INDEX date_opened",	
		"ALTER TABLE `ticket` ADD INDEX (`date_opened`) ",
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -