upgrade120-20.php

来自「日程 BosDates v4.5 Copyright ?2004-2005 B」· PHP 代码 · 共 697 行 · 第 1/3 页

		 function checkForm(form) {
		 	if(form.uusDatabase.value == "") {
		 		form.uusDatabase.focus();
		 		return false;
		 		}
		 	if(form.uusDatabaseHost.value == "") {
		 		form.uusDatabaseHost.focus();
		 		return false;
		 		}
		 	if(form.uusDatabaseUser.value == "") {
		 		form.uusDatabaseUser.focus();
		 		return false;
		 		}
		 	if(form.uusDatabasePassword.value == "") {
		 		form.uusDatabasePassword.focus();
		 		return false;
		 		}
		 	return true;
		 	}
		 </script>
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		 <form method="post" action="upgrade120-20.php" onSubmit="return checkForm(this);">
		 <input type="hidden" name="step" value="5">
		 <input type="hidden" name="insUrl" value="$insUrl">
		 <input type="hidden" name="insPath" value="$insPath">
		  <tr>
		   <td class="headtd">Database information</td>
		  </tr>
		  <tr>
		   <td>
		    Please enter the following requested information for the BosDev Universal User System.  If you have another BosDev application installed which uses the BosDev Universal User System the requested information would be the same as the other application.<br>
		    <br>
		    If you do not have another BosDev product which uses this system, we suggest using the same information as the classifieds.<br>
		    <br>
		    UUS Database name: <input type="text" name="uusDatabase" value="$database_name"><br>
		    UUS Database host: <input type="text" name="uusDatabaseHost" value="$database_host"><br>
		    UUS Database user: <input type="text" name="uusDatabaseUser" value="$database_username"><br>
		    UUS Database password: <input type="text" name="uusDatabasePassword" value="$database_password"><br>
		    <br>
		    Please enter the information below regarding how cookies will be set for the classifieds.<br>
		    <br>
		    Cookie prefix: <input type="text" name="cookiePrefix" value=""><br>
		    Cookie path: <input type="text" name="cookiePath" value="/"><br>
		    Cookie domain: <input type="text" name="cookieDomain" value="$cookieDomain"> example: .domain.com<br>
		    <br>
		    <input type="submit" value="Proceed">
		   </td>
		  </tr>
		 </form>
		 </table>
ENDPRINT;
		break;

	case "5":
		echo<<<ENDPRINT
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		 <form method="post" action="upgrade120-20.php" onReset="javascript:history.go(-1);">
		 <input type="hidden" name="step" value="6">
		 <input type="hidden" name="insUrl" value="$insUrl">
		 <input type="hidden" name="insPath" value="$insPath">
		 <input type="hidden" name="uusDatabase" value="$uusDatabase">
		 <input type="hidden" name="uusDatabaseHost" value="$uusDatabaseHost">
		 <input type="hidden" name="uusDatabaseUser" value="$uusDatabaseUser">
		 <input type="hidden" name="uusDatabasePassword" value="$uusDatabasePassword">
		 <input type="hidden" name="cookiePrefix" value="$cookiePrefix">
		 <input type="hidden" name="cookiePath" value="$cookiePath">
		 <input type="hidden" name="cookieDomain" value="$cookieDomain">

		  <tr>
		   <td class="headtd">Testing database connection</td>
		  </tr>
		  <tr>
		   <td>
		    The upgrade script has now tested the database connection using the information you have supplied.  If there are any error messages below, you will need to go back and supply correct database information.  If you are unsure about the correct database information, please contact your host.<br>
		    <br>
ENDPRINT;
		if($uus_link = @mysql_connect("$uusDatabaseHost", "$uusDatabaseUser", "$uusDatabasePassword")) { echo "Calendar database user connection established.<br><br>"; }
			else { $errorFound = 1; echo "<b>Cannot login using the username of $uusDatabaseUser with a password of $uusDatabasePassword to $uusDatabaseHost</b><br><br>"; }
		if(@mysql_select_db("$uusDatabase",$uus_link)) { echo "Calendar database can be accessed.<br><br>"; }
			else { $errorFound = 1; echo "<b>Could not connect to the database $uusDatabase.  Please check to ensure this is the correct database, and that the user $uusDatabaseUser has rights to this database.</b><br><br>"; }

		if($errorFound == 1) { $button = "<input type=\"reset\" value=\"Reenter database information\">"; }
			else { $button = "<input type=\"submit\" value=\"Proceed\">"; }

		echo<<<ENDPRINT
		    $button
		   </td>
		  </tr>
		 </form>
		 </table>
ENDPRINT;
		break;

	case "6":
		include("connect.php");

		if(substr($insUrl,-1) != "/") { $insUrl = "{$insUrl}/"; }
		$insPath = str_replace("\\","\\\\",$insPath);

	 	$filecontents =<<<ENDFILE
<?php
/////////////////////////////// COPYRIGHT NOTICE /////////////////////////////////
// This script is part of BosClassifieds, a software application by BosDev, Inc //
// Use of any kind of part or all of this script or modification of this        //
// script requires a license from BosDev, Inc. Use or modification of           //
// this script without a license constitutes Software Piracy and will           //
// result in legal action from BosDev, Inc.  All rights reserved.               //
//            http://www.bosdev.com      [e-mail]                       //
//                                                                              //
//               BosClassifieds Copyright 2004, BosDev, Inc.                    //
//////////////////////////////////////////////////////////////////////////////////

global \$class_prefix,\$class_link,\$uus_link,\$integration_prefix,\$int_link;

//Classifieds database settings
\$class_name = "$database_name";
\$class_host = "$database_host";
\$class_username = "$database_username";
\$class_password = "$database_password";
\$class_prefix = "$class_prefix";

//BosDevUUS database settings
\$uus_name = "$uusDatabase";
\$uus_host = "$uusDatabaseHost";
\$uus_username = "$uusDatabaseUser";
\$uus_password = "$uusDatabasePassword";

//Integration database settings
\$integration_name = "";
\$integration_host = "";
\$integration_username = "";
\$integration_password = "";
\$integration_prefix = "";

//Cookie data settings
\$cookie_prefix = "$cookiePrefix";
\$cookie_path = "$cookiePath";
\$cookie_domain = "$cookieDomain";

//Installation location settings
\$insUrl = "$insUrl";
\$insPath = "$insPath";

//DO NOT EDIT ANYTHING BELOW
\$class_link = mysql_connect("\$class_host", "\$class_username", "\$class_password") or die("I cannot connect to the classifieds database.");
mysql_select_db ("\$class_name",\$class_link) or die("Could not select the classifieds database.");

\$uus_link = mysql_connect("\$uus_host", "\$uus_username", "\$uus_password") or die("I cannot connect to the BosDev UUS database.");
mysql_select_db ("\$uus_name",\$uus_link) or die("Could not select the BosDev UUS database.");

if(\$integration_name != "") {
	\$int_link = mysql_connect("\$integration_host", "\$integration_username", "\$integration_password") or die("I cannot connect to the integration database.");
	mysql_select_db ("\$integration_name",\$int_link) or die("Could not select the integration database.");
	}

function protect(\$nonprotected) {
	\$protected = mysql_escape_string(\$nonprotected);
	return \$protected;
	}
function query(\$query,\$database) {
    	\$mysql_error="";
    	\$mysql_result = @mysql_query(\$query,\$database);
    	if ( !\$mysql_result ) {
    		\$mysql_result_error = @mysql_error();
    		die("<div align=left><b>MySQL error!</b><br />Database: <i>\$database</i><br />The query: <i>\$query</i><br />The result: <i>\$mysql_result_error</i><br /></div>" );
    		}
		else { return \$mysql_result; }
	}
?>
ENDFILE;

		echo<<<ENDPRINT
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		 <form method="post" action="upgrade120-20.php" onReset="javascript:window.location.reload();">
		 <input type="hidden" name="step" value="7">
		  <tr>
		   <td class="headtd">Writing connection file</td>
		  </tr>
		  <tr>
		   <td>
		    The upgrade script is now reconfiguring your connect.php file to the new layout. If you receive an error message below, please check the file permissions on connect.php to ensure the upgrade script can write to the connect.php file.<br>
		    <br>
ENDPRINT;

		$fname = "connect.php";
	 	$fp = @fopen($insPath.$fname, "w");
		if(!@fputs($fp,$filecontents)) {
			echo "<b>The connect.php file could not be written to.  Please check the file permissions and try again.</b><br><br>";
			$button = "<input type=\"reset\" value=\"Try again\">";
			}
			else {
				echo "The connect.php file has been written.<br><br>";
				$button = "<input type=\"submit\" value=\"Proceed\">";
				}
		echo<<<ENDPRINT
		    $button
		   </td>
		  </tr>
		 </form>
		 </table>
ENDPRINT;
		break;


	case "7":
		include("connect.php");
		$result = query("SELECT * FROM {$class_prefix}system",$class_link);
		$SystemOptions = mysql_fetch_array($result);

		//Create our new tables
		$result = query("CREATE TABLE `{$class_prefix}coupons_lock` (`coupon_code` VARCHAR( 255 ) NOT NULL ,`user_id` INT( 5 ) NOT NULL);",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}banners` (`banner_id` INT( 5 ) NOT NULL AUTO_INCREMENT ,`banner_name` VARCHAR( 255 ) NOT NULL ,`banner_text` VARCHAR( 255 ) NOT NULL ,`banner_url` VARCHAR( 255 ) NOT NULL ,`banner_image` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `banner_id` ));",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}ad_types` (`type_id` TINYINT( 3 ) NOT NULL AUTO_INCREMENT ,`type_title` VARCHAR( 255 ) NOT NULL ,`type_required` INT( 6 ) NOT NULL ,`type_use` INT( 6 ) NOT NULL ,`option1` VARCHAR( 255 ) NOT NULL ,`def_option1` VARCHAR( 255 ) NOT NULL ,`option2` VARCHAR( 255 ) NOT NULL ,`def_option2` VARCHAR( 255 ) NOT NULL ,`option3` VARCHAR( 255 ) NOT NULL ,`def_option3` VARCHAR( 255 ) NOT NULL ,`option4` VARCHAR( 255 ) NOT NULL ,`def_option4` VARCHAR( 255 ) NOT NULL ,`option5` VARCHAR( 255 ) NOT NULL ,`def_option5` VARCHAR( 255 ) NOT NULL ,`option6` VARCHAR( 255 ) NOT NULL ,`def_option6` VARCHAR( 255 ) NOT NULL ,`option7` VARCHAR( 255 ) NOT NULL ,`def_option7` VARCHAR( 255 ) NOT NULL ,`option8` VARCHAR( 255 ) NOT NULL ,`def_option8` VARCHAR( 255 ) NOT NULL ,`option9` VARCHAR( 255 ) NOT NULL ,`def_option9` VARCHAR( 255 ) NOT NULL ,`option10` VARCHAR( 255 ) NOT NULL ,`def_option10` VARCHAR( 255 ) NOT NULL,PRIMARY KEY ( `type_id` ));",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (1, 'For Sale', 13, 511, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (2, 'Wanted', 9, 509, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (4, 'Jobs', 9, 253, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (8, 'Services', 9, 249, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (16, 'Notice', 9, 9, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);

		//Update the system table
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `integration` VARCHAR( 255 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` DROP `main_url`;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` DROP `main_path`;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` CHANGE `allow_featured` `allow_featured` TINYINT( 1 ) DEFAULT '1' NOT NULL ,CHANGE `allow_bold` `allow_bold` TINYINT( 1 ) DEFAULT '1' NOT NULL ,CHANGE `allow_italic` `allow_italic` TINYINT( 1 ) DEFAULT '1' NOT NULL ,CHANGE `allow_color` `allow_color` TINYINT( 1 ) DEFAULT '1' NOT NULL ,CHANGE `num_images` `num_images` TINYINT( 1 ) DEFAULT '3' NOT NULL;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `panel_top` TINYINT( 1 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `panel_bottom` TINYINT( 1 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `cat_columns` TINYINT( 1 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `list_columns` TINYINT( 1 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` ADD `subcats` TINYINT( 1 ) NOT NULL ;",$class_link);
		$result = query("ALTER TABLE `{$class_prefix}system` CHANGE `time_1_multiplier` `time_1_multiplier` VARCHAR( 255 ) DEFAULT '1.00' NOT NULL ,CHANGE `time_2_multiplier` `time_2_multiplier` VARCHAR( 255 ) DEFAULT '1.00' NOT NULL ,CHANGE `time_3_multiplier` `time_3_multiplier` VARCHAR( 255 ) DEFAULT '1.00' NOT NULL ,CHANGE `time_4_multiplier` `time_4_multiplier` VARCHAR( 255 ) DEFAULT '1.00' NOT NULL;",$class_link);
		$result = query("UPDATE {$class_prefix}system SET integration='uus',panel_top=1,panel_bottom=0,subcats=1,cat_columns=2,list_columns=1,time_1_multiplier='1|{$SystemOptions['time_1_multiplier']}',time_2_multiplier='1|{$SystemOptions['time_2_multiplier']}',time_3_multiplier='1|{$SystemOptions['time_3_multiplier']}',time_4_multiplier='1|{$SystemOptions['time_4_multiplier']}'",$class_link);
		if($SystemOptions['payment_gateway'] == "none") { $result = query("UPDATE {$class_prefix}system SET payment_gateway=''",$class_link); }