<h2>File Contents: /home/planet5/www/tracking/202-config/copy_of_setup-config.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/tracking/202-config/copy_of_setup-config.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

//include functions
require_once(dirname( __FILE__ ) . &#039;/functions.php&#039;);


//check to see if the sample config file exists
if (!file_exists(substr(dirname( __FILE__ ), 0,-10) . &#039;/202-config-sample.php&#039;)) {
	_die(&#039;Sorry, I need a 202-config-sample.php file to work from. Please re-upload this file from your Prosper202 installation.&#039;);
}


//lets make a new config file
$configFile = file(substr(dirname( __FILE__ ), 0,-10).&#039;/202-config-sample.php&#039;);


//check to see if the directory is writable
if ( !is_writable(substr(dirname( __FILE__ ), 0,-10) . &#039;/&#039;)) {
	_die(&quot;Sorry, I can&#039;t write to the directory. You&#039;ll have to either change the permissions on your Prosper202 directory or create your 202-config.php manually.&quot;);
}


// Check if 202-config.php has been created
if (file_exists(&#039;../202-config.php&#039;)) {
	//_die(&quot;&lt;p&gt;The file &#039;202-config.php&#039; already exists. If you need to reset any of the configuration items in this file, please delete it first. You may try &lt;a href=&#039;install.php&#039;&gt;installing now&lt;/a&gt;.&lt;/p&gt;&quot;);
    $re = &#039;/(\$\w*) = \&#039;(\w*)\&#039;;/i&#039;;
    
    $handle = fopen(substr(dirname( __FILE__ ), 0,-10) . &#039;/202-config.php&#039;, &#039;r&#039;);
    $old = [];
    while(!feof($handle)) {
        $line = fgets($handle);
        preg_match($re, $line, $matches);
    switch ($matches[1]) {
            case &#039;$dbname&#039;:
                $odbname=$matches[2];
                break;
            case &#039;$dbuser&#039;:
                $odbuser=$matches[2];
                break;
            case &#039;$dbpass&#039;:
                $odbpass=$matches[2];
                break;
            case &#039;$dbhost&#039;:
                $odbhost=$matches[2];
                break;
           case &#039;$dbhostro&#039;:
                $odbhostro=$matches[2];
                break;
            case &#039;$mchost&#039;:
                $omchost=$matches[2];
                break;            
        }
    }
    fclose($file);
     
}


if (isset($_GET[&#039;step&#039;])) {
	$step = $_GET[&#039;step&#039;];
} else {
	$step = 0;
}


switch($step) {
	case 0:
		info_top();
?&gt;
&lt;div class=&quot;main col-xs-7 install&quot;&gt;
&lt;center&gt;&lt;img src=&quot;&lt;?php echo get_absolute_url();?&gt;202-img/prosper202.png&quot;&gt;&lt;/center&gt;
	&lt;small&gt;Welcome to Prosper202. Before getting started, we need some information about your database. You will need to know the following items before proceeding.&lt;/small&gt;
	&lt;br&gt;&lt;/br&gt;
	&lt;small&gt;&lt;ul&gt;
		&lt;li&gt;Database name&lt;/li&gt;
		&lt;li&gt;Database username&lt;/li&gt;
		&lt;li&gt;Database password&lt;/li&gt;
		&lt;li&gt;Database host&lt;/li&gt;
		&lt;li&gt;Reporting Database host (optional)&lt;/li&gt;
		&lt;li&gt;Memcache host (optional)&lt;/li&gt;
	&lt;/ul&gt;&lt;/small&gt;
	&lt;small&gt;&lt;strong&gt;If for any reason this automatic file creation doesn&#039;t work, don&#039;t worry. All this does is fill in the database information to a configuration file. You may also simply open &lt;code&gt;202-config-sample.php&lt;/code&gt; in a text editor, fill in your information, and save it as &lt;code&gt;202-config.php&lt;/code&gt;. &lt;/strong&gt;
	&lt;br&gt;&lt;/br&gt;
	In all likelihood, these items were supplied to you by your ISP. If you do not have this information, then you will need to contact them before you can continue. 
	&lt;br&gt;&lt;/br&gt;
	If you&amp;#8217;re all ready, &lt;a href=&quot;setup-config.php?step=1&quot; class=&quot;btn btn-xs btn-p202&quot;&gt;let&amp;#8217;s go!&lt;/a&gt;&lt;/p&gt;
	&lt;/div&gt;
	&lt;?php

			info_bottom();

		break; 

		case 1:
		case 1.1:
			info_top();
		?&gt;
	&lt;/p&gt;
	&lt;?php 
	if($step==1){
	    $msg=&quot;Enter your database connection details. If you&#039;re not sure about these, contact your host&quot;;
	    $action=&quot;setup-config.php?step=2&quot;;
	}else{
	    $msg=&quot;Your 202-config.php needs to be updated to a new format. Please review the settings we got from your old file and make changes as needed&quot;;
	    $action=&quot;setup-config.php?step=2.2&quot;;
	}
	
	?&gt;
	&lt;div class=&quot;main col-xs-7 install&quot;&gt;
	&lt;center&gt;&lt;img src=&quot;&lt;?php echo get_absolute_url();?&gt;202-img/prosper202.png&quot;&gt;&lt;/center&gt;
	&lt;small&gt;&lt;?php echo $msg;?&gt;&lt;/small&gt;

	&lt;form method=&quot;post&quot; action=&quot;&lt;?php echo $action;?&gt;&quot; class=&quot;form-horizontal&quot; role=&quot;form&quot; style=&quot;margin-top:10px;&quot;&gt;
			&lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;dbname&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Database Name:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;dbname&quot; name=&quot;dbname&quot; value=&quot;&lt;?php echo (isset($odbname) ? $odbname : &#039;prosper202&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;The name of the database you want to run Prosper202 in.&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;dbuser&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;User Name:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;dbuser&quot; name=&quot;dbuser&quot; value=&quot;&lt;?php echo (isset($odbuser) ? $odbuser : &#039;username&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;Your MySQL username&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;dbpass&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Password:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;dbpass&quot; name=&quot;dbpass&quot; value=&quot;&lt;?php echo (isset($odbpass) ? $odbpass : &#039;password&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;...and MySQL password.&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;dbhost&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Database Host:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;dbhost&quot; name=&quot;dbhost&quot; value=&quot;&lt;?php echo (isset($odbhost) ? $odbhost : &#039;localhost&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;99% chance you won&#039;t need to change this value.&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

            &lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;dbhost&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Reporting Database:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;dbhostro&quot; name=&quot;dbhostro&quot; value=&quot;&lt;?php echo (isset($odbhostro) ? $odbhostro : &#039;localhost&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;If you have a dedicated db for running reports, enter it here. If not, leave as localhost. &lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;
			
			&lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			    &lt;label for=&quot;mchost&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Memcache Host:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;mchost&quot; name=&quot;mchost&quot; value=&quot;&lt;?php echo (isset($omchost) ? $omchost : &#039;localhost&#039;);?&gt;&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;If you don&#039;t know what this is, leave it alone.&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;form-group&quot;&gt;
			    &lt;label for=&quot;prefix&quot; class=&quot;col-xs-4 control-label&quot; style=&quot;text-align:left&quot;&gt;&lt;strong&gt;Table Prefix:&lt;/strong&gt;&lt;/label&gt;
			    &lt;div class=&quot;col-xs-8&quot; style=&quot;margin-top: 5px;&quot;&gt;
			      &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;prefix&quot; name=&quot;prefix&quot; value=&quot;202_&quot; readonly=&quot;true&quot;&gt;
			      &lt;span class=&quot;help-block&quot; style=&quot;font-size: 10px;&quot;&gt;The table prefix that will be used, this can not be changed.&lt;/span&gt;
			    &lt;/div&gt;
			&lt;/div&gt;

			&lt;button class=&quot;btn btn-sm btn-p202 btn-block&quot; type=&quot;submit&quot;&gt;Save database credentials&lt;span class=&quot;fui-check-inverted pull-right&quot;&gt;&lt;/span&gt;&lt;/button&gt;
	&lt;/form&gt;
&lt;/div&gt;
&lt;?php
		
		info_bottom();
	break;

	case 2:
	case 2.2:
	$dbname  = trim($_POST[&#039;dbname&#039;]);
	$dbuser   = trim($_POST[&#039;dbuser&#039;]);
	$dbpass = trim($_POST[&#039;dbpass&#039;]);
	$dbhost  = trim($_POST[&#039;dbhost&#039;]);
	$dbhostro  = trim($_POST[&#039;dbhostro&#039;]);
	$mchost  = trim($_POST[&#039;mchost&#039;]);

	//see if it can connect to the mysql host server
	$connect = @mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
	
	//if it could not connect, error
	if (!$connect) {
		_die(&quot;&lt;h6&gt;Error establishing a database connection&lt;/h6&gt;
			&lt;p&gt;&lt;small&gt;This either means that the username and password information in your &lt;code&gt;202-config.php&lt;/code&gt; file is incorrect or we can&#039;t contact the database server at &lt;code&gt;$dbhost&lt;/code&gt;. This could mean your host&#039;s database server is down.&lt;/small&gt;&lt;/p&gt;
			&lt;small&gt;
			&lt;ul&gt; 
				&lt;li&gt;Are you sure you have the correct username and password?&lt;/li&gt;
				&lt;li&gt;Are you sure that you have typed the correct hostname?&lt;/li&gt;
				&lt;li&gt;Are you sure that you have typed the correct database name?&lt;/li&gt;
				&lt;li&gt;Are you sure that the database server is running?&lt;/li&gt;
			&lt;/ul&gt;
			&lt;/small&gt; 
			&lt;p&gt;&lt;small&gt;If you&#039;re unsure what these terms mean you should probably contact your host. If you still need help, please visit the &lt;a href=&#039;http://support.tracking202.com/how-to-set-up-and-use-prosper202-pro/installing-prosper202?utm_source=db-install-error&#039;&gt;Prosper202 Support Site&lt;/a&gt;.&lt;/small&gt; &lt;/p&gt;
			&lt;p&gt;&lt;a href=&#039;setup-config.php?step=1&#039; class=&#039;btn btn-sm btn-p202 btn-block&#039;&gt;Go back and enter your database credentials again!&lt;/a&gt;&lt;/p&gt;
		&quot;);
	}
    //regex to find values in the config file
	$re = &#039;/(\$\w*) = \&#039;(\w*)\&#039;;/i&#039;;

	$handle = fopen(substr(dirname( __FILE__ ), 0,-10) . &#039;/202-config.php&#039;, &#039;w&#039;);

	foreach ($configFile as $line_num =&gt; $line) {
	    preg_match($re, $line, $matches);
		switch ($matches[1]) {
			case &#039;$dbname&#039;:
				fwrite($handle, str_replace(&quot;putyourdbnamehere&quot;, $dbname, $line));
				break;
			case &#039;$dbuser&#039;:
				fwrite($handle, str_replace(&quot;&#039;usernamehere&#039;&quot;, &quot;&#039;$dbuser&#039;&quot;, $line));
				break;
			case &#039;$dbpass&#039;:
				fwrite($handle, str_replace(&quot;&#039;yourpasswordhere&#039;&quot;, &quot;&#039;$dbpass&#039;&quot;, $line));
				break;
			case &#039;$dbhost&#039;:
				fwrite($handle, str_replace(&quot;localhost&quot;, $dbhost, $line));
				break;
		    case &#039;$dbhostro&#039;:
	       	    fwrite($handle, str_replace(&quot;localhost&quot;, $dbhostro, $line));
				break;				
			case &#039;$mchost&#039;:
				fwrite($handle, str_replace(&quot;localhost&quot;, $mchost, $line));
				break;
			default:
				fwrite($handle, $line);
		}
	}
	fclose($handle);
	chmod(substr(dirname( __FILE__ ), 0,-10) . &#039;/202-config.php&#039;, 0666);
	
	_die(&quot;&lt;p&gt;All right sparky! You&#039;ve made it through this part of the installation. Prosper202 can now communicate with your database. If you are ready, go ahead and &lt;a class=&#039;btn btn-xs btn-p202&#039; href=\&quot;install.php\&quot;&gt;run the install!&lt;/a&gt;&lt;/p&gt;&quot;);
	break;
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Ftracking%2F202-config'>⬅ Back to Directory</a>