New Import

1 files changed, 238 insertions, 0 deletions

diff --git a/lib/install.php b/lib/install.php
new file mode 100644
index 00000000..c337b1e8
--- /dev/null
+++ b/lib/install.php
@@ -0,0 +1,238 @@
+<?
+/*
+
+ Copyright (c) 2001 - 2005 Ampache.org
+ All rights reserved.
+
+ This program is free software; you can redistribute it and/or
+ modify it under the terms of the GNU General Public License
+ as published by the Free Software Foundation; either version 2
+ of the License, or (at your option) any later version.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+
+*/
+/*!
+	@header Install docuement
+	@discussion this document contains the functions needed to see if 
+		ampache needs to be installed
+*/
+
+/*!
+	@function split_sql
+	@discussion splits up a standard SQL dump file into distinct
+		sql queryies 
+*/
+function split_sql($sql) {
+        $sql = trim($sql);
+        $sql = ereg_replace("\n#[^\n]*\n", "\n", $sql);
+        $buffer = array();
+        $ret = array();
+        $in_string = false;
+        for($i=0; $i<strlen($sql)-1; $i++) {
+                if($sql[$i] == ";" && !$in_string) {
+                        $ret[] = substr($sql, 0, $i);
+                        $sql = substr($sql, $i + 1);
+                        $i = 0;
+                }
+                if($in_string && ($sql[$i] == $in_string) && $buffer[1] != "\\") {
+                        $in_string = false;
+                }
+                elseif(!$in_string && ($sql[$i] == '"' || $sql[$i] == "'") && (!isset($buffer[0]) || $buffer[0] != "\\")) {
+                        $in_string = $sql[$i];
+                }
+                if(isset($buffer[1])) {
+                        $buffer[0] = $buffer[1];
+                }
+                $buffer[1] = $sql[$i];
+        }
+        if(!empty($sql)) {
+                $ret[] = $sql;
+        }
+        return($ret);
+} // split_sql
+
+/*!
+	@function install_check_status()
+	@discussion this function checks to see if we actually
+		still need to install ampache. This function is
+		very important, we don't want to reinstall over top
+		of an existing install
+*/
+function install_check_status($configfile) { 
+
+	/* 
+	  Check and see if the config file exists
+	  if it does they can't use the web interface
+	  to install ampache. 
+	*/
+	if (!file_exists($configfile)) { 
+		return true;	
+	}
+
+	/* 
+	  Check and see if they've got _any_ account
+	  if they don't then they're cool
+	*/
+	$results = read_config($GLOBALS['configfile'], 0, 0);
+	$dbh = check_database($results['libglue']['local_host'],$results['libglue']['local_username'],$results['libglue']['local_pass'],$results['libglue']['local_db']);	
+		
+	if (is_resource($dbh)) { 
+		mysql_select_db($results['libglue']['local_db'],$dbh);
+		$sql = "SELECT * FROM user";
+		$db_results = @mysql_query($sql, $dbh);
+		if (!@mysql_num_rows($db_results)) { 
+			return true;
+		}
+	}
+
+	
+	/* Defaut to no */
+	return false;
+
+} // install_check_status
+
+/*!
+	@function install_insert_db()
+	@discussion this function inserts the database 
+		using the username/pass/host provided
+		and reading the .sql file
+*/
+function install_insert_db($username,$password,$hostname,$database) {
+
+	/* Attempt to make DB connection */
+	$dbh = @mysql_pconnect($hostname,$username,$password);
+	
+
+	/* Check/Create Database as needed */
+	$db_selected = @mysql_select_db($database, $dbh);
+	if (!$db_selected) { 
+		$sql = "CREATE DATABASE `" . $database . "`";
+		if (!$db_results = @mysql_query($sql, $dbh)) { 
+			return false;
+		}
+		@mysql_select_db($database, $dbh);
+	} // if db can't be selected
+		
+
+	/* Attempt to insert database */
+         $query = fread(fopen("sql/ampache.sql", "r"), filesize("sql/ampache.sql"));
+         $pieces  = split_sql($query);
+         for ($i=0; $i<count($pieces); $i++) {
+                 $pieces[$i] = trim($pieces[$i]);
+                 if(!empty($pieces[$i]) && $pieces[$i] != "#") {
+			   //FIXME: This is for a DB prefix when we get around to it
+//                         $pieces[$i] = str_replace( "#__", $DBPrefix, $pieces[$i]);
+                         if (!$result = mysql_query ($pieces[$i])) {
+                                 $errors[] = array ( mysql_error(), $pieces[$i] );
+                         } // end if
+                 } // end if
+         } // end for
+
+	return true;
+
+} // install_insert_db
+
+/*!
+	@function install_create_config()
+	@discussion attempts to write out the config file
+		if it can't write it out it will prompt the
+		user to download the config file.
+*/
+function install_create_config($web_path,$username,$password,$hostname,$database) { 
+
+	/* 
+	  First Test The Variables they've given us to make
+	  sure that they actually work!
+	*/
+	// Connect to the DB
+	if(!$dbh = @mysql_pconnect($hostname,$username,$password)) { 
+		return false;
+	}
+	if (!$db_selected = @mysql_select_db($database, $dbh)) { 
+		return false;
+	}
+
+
+	/* Read in the .dist file and spit out the .cfg */
+	$dist_handle 	= @fopen("config/ampache.cfg.php.dist",'r');
+	$dist_data 	= @fread($dist_handle,filesize("config/ampache.cfg.php.dist"));
+	fclose($dist_handle);
+
+	$dist_array = explode("\n",$dist_data);
+
+	// Rather then write it out right away, let's build the string
+	// incase we can't write to the FS and have to make it a download
+
+	foreach ($dist_array as $row) { 
+
+		if (preg_match("/^#?web_path\s*=/",$row)) { 
+			$row = "web_path = \"$web_path\"";
+		}
+		elseif (preg_match("/^#?local_db\s*=/",$row)) { 
+			$row = "local_db = \"$database\"";
+		}
+		elseif (preg_match("/^#?local_host\s*=/",$row)) { 
+			$row = "local_host = \"$hostname\"";
+		}
+		elseif (preg_match("/^#?local_username\s*=/",$row)) { 
+			$row = "local_username = \"$username\"";
+		}
+		elseif (preg_match("/^#?local_pass\s*=/",$row)) { 
+			$row = "local_pass = \"$password\"";
+		}
+	
+		$config_data .= $row . "\n";
+
+	} // foreach row in config file	
+
+	/* Attempt to Write out File */
+	if (!$config_handle = @fopen("config/ampache.cfg.php",'w')) { 
+		$browser = new Browser();
+		$browser->downloadHeaders("ampache.cfg.php","text/plain",false,filesize("config/ampache.cfg.php.dist"));
+
+		echo $config_data;
+		exit();
+		
+	}
+	if (!@fwrite($config_handle,$config_data)) {
+		return false;
+	}
+
+	return true;
+
+} // install_create_config
+
+/*!
+	@function install_create_account
+	@discussion this creates your initial account
+*/
+function install_create_account($username,$password) { 
+
+        $results = read_config($GLOBALS['configfile'], 0, 0);
+	$dbh = check_database($results['libglue']['local_host'],$results['libglue']['local_username'],$results['libglue']['local_pass'],$results['libglue']['local_db']);
+		
+	@mysql_select_db($results['libglue']['local_db'],$dbh);
+
+	$username = sql_escape($username,$dbh);
+	$password = sql_escape($password,$dbh);
+
+	$sql = "INSERT INTO user (`username`,`password`,`offset_limit`,`access`) VALUES ('$username',PASSWORD('$password'),'50','admin')";
+	$db_results = mysql_query($sql, $dbh);
+	
+	$insert_id = mysql_insert_id($dbh);
+	
+	if (!$insert_id) { return false; }
+
+	return true;
+		
+} // install_create_account
+
+?>