install.php

日程 BosDates v4.5 Copyright ?2004-2005 BosDev

//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="install.php" onReset="javascript:window.location.reload();">
		 <input type="hidden" name="step" value="9">
		 <input type="hidden" name="integration" value="$integration">
		 <input type="hidden" name="adminUser" value="$adminUser">
		 <input type="hidden" name="adminPass" value="$adminPass">
		 <input type="hidden" name="adminEmail" value="$adminEmail">
		  <tr>
		   <td class="headtd">Writing connection file</td>
		  </tr>
		  <tr>
		   <td>
		    The installer is now writing all of your database information to the connect.php file.  If you receive an error message below, please check the file permissions on connect.php to ensure the install script can write to the connect.php file.<br>
		    <br>
ENDPRINT;
		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 "9":
		include("connect.php");
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}ad_types`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}ad_types` (`type_id` tinyint(3) NOT NULL auto_increment,`type_title` varchar(255) NOT NULL default '',`type_required` int(6) NOT NULL default '0',`type_use` int(6) NOT NULL default '0',`option1` varchar(255) NOT NULL default '',`def_option1` varchar(255) NOT NULL default '',`option2` varchar(255) NOT NULL default '',`def_option2` varchar(255) NOT NULL default '',`option3` varchar(255) NOT NULL default '',`def_option3` varchar(255) NOT NULL default '',`option4` varchar(255) NOT NULL default '',`def_option4` varchar(255) NOT NULL default '',`option5` varchar(255) NOT NULL default '',`def_option5` varchar(255) NOT NULL default '',`option6` varchar(255) NOT NULL default '',`def_option6` varchar(255) NOT NULL default '',`option7` varchar(255) NOT NULL default '',`def_option7` varchar(255) NOT NULL default '',`option8` varchar(255) NOT NULL default '',`def_option8` varchar(255) NOT NULL default '',`option9` varchar(255) NOT NULL default '',`def_option9` varchar(255) NOT NULL default '',`option10` varchar(255) NOT NULL default '',`def_option10` varchar(255) NOT NULL default '',PRIMARY KEY  (`type_id`)) TYPE=MyISAM;",$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, 'Notice', 9, 9, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (5, 'Jobs', 9, 253, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("INSERT INTO `{$class_prefix}ad_types` VALUES (6, 'Services', 9, 249, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}ads`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}ads` (`ad_id` int(10) NOT NULL auto_increment,`ad_status` tinyint(1) NOT NULL default '0',`ad_user_id` int(5) NOT NULL default '0',`ad_category` int(5) NOT NULL default '0',`ad_date_begin` varchar(10) NOT NULL default '',`ad_date_end` varchar(10) NOT NULL default '',`ad_type` tinyint(3) NOT NULL default '0',`ad_title` varchar(255) NOT NULL default '',`ad_description` text NOT NULL,`ad_image1` varchar(255) NOT NULL default '',`ad_image2` varchar(255) NOT NULL default '',`ad_image3` varchar(255) NOT NULL default '',`ad_image4` varchar(255) NOT NULL default '',`ad_image5` varchar(255) NOT NULL default '',`ad_options` int(10) NOT NULL default '0',`ad_optional_1` varchar(255) NOT NULL default '',`ad_optional_2` varchar(255) NOT NULL default '',`ad_optional_3` varchar(255) NOT NULL default '',`ad_optional_4` varchar(255) NOT NULL default '',`ad_optional_5` varchar(255) NOT NULL default '',`ad_type_optional1` varchar(255) NOT NULL default '',`ad_type_optional2` varchar(255) NOT NULL default '',`ad_type_optional3` varchar(255) NOT NULL default '',`ad_type_optional4` varchar(255) NOT NULL default '',`ad_type_optional5` varchar(255) NOT NULL default '',`ad_type_optional6` varchar(255) NOT NULL default '',`ad_type_optional7` varchar(255) NOT NULL default '',`ad_type_optional8` varchar(255) NOT NULL default '',`ad_type_optional9` varchar(255) NOT NULL default '',`ad_type_optional10` varchar(255) NOT NULL default '',`ad_price` varchar(255) NOT NULL default '0.00',`ad_condition` tinyint(4) NOT NULL default '0',`ad_views` int(4) NOT NULL default '0',`ad_city` varchar(255) NOT NULL default '',`ad_state` varchar(255) NOT NULL default '',`ad_postal` varchar(255) NOT NULL default '',`ad_country` varchar(255) NOT NULL default '',`ad_fee` float(6,2) NOT NULL default '0.00',PRIMARY KEY  (`ad_id`)) TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}banners`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}banners` (`banner_id` int(5) NOT NULL auto_increment,`banner_name` varchar(255) NOT NULL default '',`banner_text` varchar(255) NOT NULL default '',`banner_url` varchar(255) NOT NULL default '',`banner_image` varchar(255) NOT NULL default '',PRIMARY KEY  (`banner_id`)) TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}categories`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}categories` (`category_id` int(5) NOT NULL auto_increment,`category_order` int(3) NOT NULL default '0',`category_parent` int(5) NOT NULL default '0',`category_title` varchar(255) NOT NULL default '',`category_desc` text NOT NULL,`category_img` varchar(255) NOT NULL default '',`category_ad_types` varchar(255) NOT NULL default '',`category_ad_prices` varchar(255) NOT NULL default '',`category_optional_1` varchar(255) NOT NULL default '',`category_optional_1_def` varchar(255) NOT NULL default '',`category_optional_2` varchar(255) NOT NULL default '',`category_optional_2_def` varchar(255) NOT NULL default '',`category_optional_3` varchar(255) NOT NULL default '',`category_optional_3_def` varchar(255) NOT NULL default '',`category_optional_4` varchar(255) NOT NULL default '',`category_optional_4_def` varchar(255) NOT NULL default '',`category_optional_5` varchar(255) NOT NULL default '',`category_optional_5_def` varchar(255) NOT NULL default '',`category_subs` int(5) NOT NULL default '0',`category_listings` int(5) NOT NULL default '0',`banner_top` varchar(5) NOT NULL default '',`banner_bottom` varchar(5) NOT NULL default '',PRIMARY KEY  (`category_id`),KEY `category_id` (`category_id`)) TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}coupons`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}coupons` (`coupon_id` int(11) NOT NULL auto_increment,`coupon_code` varchar(255) NOT NULL default '',`coupon_percent` tinyint(3) NOT NULL default '0',`coupon_amount` float(3,2) NOT NULL default '0.00',`coupon_expires` date NOT NULL default '0000-00-00',`coupon_uses` int(5) NOT NULL default '0',`coupon_restrict` tinyint(1) NOT NULL default '0',PRIMARY KEY  (`coupon_id`)) TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}coupons_lock`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}coupons_lock` (`coupon_code` varchar(255) NOT NULL default '',`user_id` int(5) NOT NULL default '0') TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}statistics`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}statistics` (`stat_my` varchar(7) NOT NULL default '',`stat_item` char(1) NOT NULL default '',`stat_count` int(6) NOT NULL default '0') TYPE=MyISAM;",$class_link);
		$result = query("DROP TABLE IF EXISTS `{$class_prefix}system`;",$class_link);
		$result = query("CREATE TABLE `{$class_prefix}system` (`title` varchar(255) NOT NULL default '',`meta_key` varchar(255) NOT NULL default '',`meta_desc` varchar(255) NOT NULL default '',`auto_approve` tinyint(1) NOT NULL default '1',`page_header` text NOT NULL,`page_footer` text NOT NULL,`page_width` varchar(10) NOT NULL default '',`language` varchar(255) NOT NULL default 'english',`spider` tinyint(1) NOT NULL default '0',`fee_featured` float(3,2) NOT NULL default '0.00',`fee_bold` float(3,2) NOT NULL default '0.00',`fee_italic` float(3,2) NOT NULL default '0.00',`fee_color` float(3,2) NOT NULL default '0.00',`payment_gateway` varchar(255) NOT NULL default '',`payment_info_1` varchar(255) NOT NULL default '',`payment_info_2` varchar(255) NOT NULL default '',`expired_check` date NOT NULL default '0000-00-00',`from_email` varchar(255) NOT NULL default '',`max_size` int(4) NOT NULL default '300',`allow_featured` tinyint(1) NOT NULL default '1',`allow_bold` tinyint(1) NOT NULL default '1',`allow_italic` tinyint(1) NOT NULL default '1',`allow_color` tinyint(1) NOT NULL default '1',`num_images` tinyint(1) NOT NULL default '3',`fee_images` float(3,2) NOT NULL default '0.00',`time_1` int(11) NOT NULL default '7',`time_2` int(11) NOT NULL default '14',`time_3` int(11) NOT NULL default '21',`time_4` int(11) NOT NULL default '30',`time_1_multiplier` varchar(255) NOT NULL default '1.00',`time_2_multiplier` varchar(255) NOT NULL default '1.00',`time_3_multiplier` varchar(255) NOT NULL default '1.00',`time_4_multiplier` varchar(255) NOT NULL default '1.00',`css` varchar(255) NOT NULL default 'style.css',`banner` varchar(255) NOT NULL default '',`integration` varchar(255) NOT NULL default '',`panel_top` tinyint(1) NOT NULL default '0',`panel_bottom` tinyint(1) NOT NULL default '0',`cat_columns` tinyint(1) NOT NULL default '0',`list_columns` tinyint(1) NOT NULL default '0',`subcats` tinyint(1) NOT NULL default '0') TYPE=MyISAM;",$class_link);
		$result = query("INSERT INTO `{$class_prefix}system` VALUES ('BosClassifieds 2.0', 'classifieds,ads,wanted,for sale', 'The BosClassifieds classifieds ads system will allow your visitors to post, and look at ads for items they may need.', 1, '', '', '750', 'english', 1, 0.00, 0.00, 0.00, 0.00, '', '', '', '2005-08-25', '$adminEmail', 300, 1, 1, 1, 1, 5, 0.00, 7, 14, 30, 0, '2|0.00', '2|0.00', '2|0.00', '2|0.00', 'style.css', 'bosclassifieds_logo.gif', '$integration', 0, 0, 3, 2, 1)",$class_link);

		$result = query("CREATE TABLE IF NOT EXISTS bosdevUUS (id int(5) NOT NULL auto_increment,username varchar(255) NOT NULL,password varchar(255) NOT NULL,email varchar(255) NOT NULL, status TINYINT( 1 ) DEFAULT '0' NOT NULL, last_login DATE NOT NULL, bd1 varchar(255) NOT NULL,bd2 varchar(255) NOT NULL,bd3 varchar(255) NOT NULL,bd4 varchar(255) NOT NULL,bd5 varchar(255) NOT NULL,bc1 tinyint(255) DEFAULT '0' NOT NULL,bc2 varchar(255) DEFAULT '0' NOT NULL,bc3 varchar(255) NOT NULL,bc4 varchar(255) NOT NULL,bc5 varchar(255) NOT NULL,bdir1 varchar(255) NOT NULL,bdir2 varchar(255) NOT NULL,bdir3 varchar(255) NOT NULL,bdir4 varchar(255) NOT NULL,bdir5 varchar(255) NOT NULL,bm1 tinyint(255) DEFAULT '0' NOT NULL,bm2 varchar(255) NOT NULL,bm3 varchar(255) NOT NULL,bm4 varchar(255) NOT NULL,bm5 varchar(255) NOT NULL,bn1 tinyint(255) DEFAULT '0' NOT NULL,bn2 varchar(255) NOT NULL,bn3 varchar(255) NOT NULL,bn4 varchar(255) NOT NULL,bn5 varchar(255) NOT NULL,PRIMARY KEY (id));",$uus_link);

		$adminUser = protect($adminUser);
		$adminPass = md5(protect($adminPass));
		$adminEmail = protect($adminEmail);

		if($integration != "uus" && $integration != "uus-intranet") {
			//Get userid of existing user
			include("{$insPath}integration/{$integration}.php");
			$result = query("SELECT $intUserID FROM {$integration_prefix}{$intUserTable} WHERE {$intUserName}='$adminUser'",$int_link);
			list($newUserID) = mysql_fetch_row($result);

			//Check UUS to make sure they are not already listed
			$result = query("SELECT id FROM bosdevUUS WHERE id=$newUserID",$uus_link);
			list($chkID) = mysql_fetch_row($result);
			if($chkID != $newUserID) { $result = query("INSERT INTO bosdevUUS (id,bc1,bc2,status) VALUES ($newUserID,'2','1','1')",$uus_link); }
				else { $result = query("UPDATE bosdevUUS set bc1='2', bc2='1' WHERE id=$newUserID",$uus_link); }
			}
			else {
				//Insert user as normal
				//Check UUS to make sure they are not already listed
				$result = query("SELECT id FROM bosdevUUS WHERE username='$adminUser' OR email='$adminEmail'",$uus_link);
				list($chkID) = mysql_fetch_row($result);
				if($chkID == "") {
					//User doesn't exist
					$result = query("INSERT INTO bosdevUUS (id,username,password,email,bc1,bc2,status) VALUES (NULL,'$adminUser','$adminPass','$adminEmail','2','1',1)",$uus_link);
					}
					else {
						//User exists
						$result = query("UPDATE bosdevUUS set bc1='2', bc2='1' WHERE id=$chkID",$uus_link);
						}
				}

/*		function callBack($dataToSend) {
			$port=80;
			$host="www.bosdev.com";
			$path="/download/report-installation.php";
			if(!($fp = @fsockopen($host, $port))) return "Error: Error opening network socket.\n";
			socket_set_blocking($fp, TRUE);
			fwrite($fp, "POST $path HTTP/1.0\r\n");
			fwrite($fp, "Host: $host\r\n");
			fwrite($fp, "Content-type: application/x-www-form-urlencoded\r\n");
			fwrite($fp, "Content-length: " . strlen($dataToSend) . "\r\n\r\n");
			fwrite($fp, $dataToSend);
			for($result = ""; !feof($fp); $result .= fread($fp, 1000000));
			fclose($fp);
			}

        	callBack("url=$insUrl&user=[e-mail]&license=xxxxxxxxxx");*/

		echo<<<ENDPRINT
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		 <form method="post" action="install.php" onReset="javascript:window.location.reload();">
		 <input type="hidden" name="step" value="10">
		 <input type="hidden" name="adminUser" value="$adminUser">
		 <input type="hidden" name="adminPass" value="$adminPass">
		 <input type="hidden" name="adminEmail" value="$adminEmail">
		  <tr>
		   <td class="headtd">Populating database</td>
		  </tr>
		  <tr>
		   <td>
		    The install script has now populated the database with default values.<br>
		    <br>
		    <input type="submit" value="Proceed">
		   </td>
		  </tr>
		 </form>
		 </table>
ENDPRINT;

		break;

	case "10":
		echo<<<ENDPRINT
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		  <tr>
		   <td class="headtd">Installation complete</td>
		  </tr>
		  <tr>
		   <td>
		    Congratulation, your BosClassifieds classified ads system has now been installed.<br>
		    <br>
		    Please make sure that you remove or rename the install.php script, and all of the upgradeX.php scripts to prevent a visitor from accidentally running the scripts and damaging your installation.  <b>Also please reset the permissions on your connect.php file so it may not be written to.</b><br>
		    <br>
		    You may now run <a href="index.php">index.php</a> to begin using your classified ads.<br>
		    <br>
		    If you have questions about the classified ads system, please see our support forums at http://www.bosdev.com/support for assistance.<br>
		    <br>
		    To read or reference a manual for BosClassifieds, please visit http://www.bosdev.com/bosclassifieds/manual/.<br>
		    <br><br>
		    <b>Nulled by DGT</b><br>Our gReetZ fliez to WST, WDYL-WTN, CHT, RU & all others in warez scriptz scene.<br>
		    <br>
		   </td>
		  </tr>
		 </table>
ENDPRINT;
		break;

	default:
		echo<<<ENDPRINT
		 <table width="600" border="0" cellspacing="1" cellpadding="3">
		 <form method="post" action="install.php">
		 <input type="hidden" name="step" value="1">
		  <tr>
		   <td>
		    Welcome to the BosClassifieds 2.0 installation script.<br>
		    <br>
		    <b>If you are upgrading from a previous version, DO NOT PROCEED unless you wish to RESET the entire system/database.</b> Upgrades should be done by running the correct upgrade script instead.<br>
		    <br>
		    To complete this install, you will need to have MySQL installed on your server with a database ready for use.  You will also need a username and password for this database which has ALL permissions.<br>
		    <br>
		    This script will check to ensure that all files are present, directories have been created and permissions are set correctly.  It will also create the database tables as needed, and fill them with default information to complete the install.<br>
		    <br>
		    <input type="submit" value="Proceed">
		   </td>
		  </tr>
		 </form>
		 </table>
ENDPRINT;
		break;
	}

echo<<<ENDPRINT
   <br>
   <div id="copyright" align="center">
    Powered by BosClassifieds<br>Copyright 2002-2005. All Rights Reserved
   </div>
   <br>
   <br>
  </div>
 </body>
</html>
ENDPRINT;

?>