/**
* Installation for the backend.
* This allows for installs that require a web interface
* and those that don't.
*
* Returns 1 when complete
* Returns 0 when still in progress (requires info from the web)
* Returns -1 if failed.
*
* @author Ben Dodson
* @version 9/04/04
* @since 9/04/04
*/
function install()
{
global $backend, $version, $include_path, $jzSERVICES, $sql_type, $sql_socket, $sql_db, $sql_usr, $sql_pw;
// store version, details, and name (including SQL type)
// in a database.
// run the webpage found in install.php (move that code here.)
$step = isset($_POST["dbstep"]) ? $_POST["dbstep"] : "init";
switch ($step) {
case "init":
global $word_database_user, $word_database_pass, $word_database_name, $word_database_server, $word_database_type, $word_database_user_help, $word_database_pass_help, $word_database_name_help, $word_database_server_help, $word_database_type_help, $cms_type, $cms_mode, $word_cms_db_pick, $word_confirm_password, $word_create_database, $word_false, $word_true, $word_create_database_help, $word_drop, $word_drop_database_help;
?>
<input name="dbstep" value="db" type=hidden>
<table width="100%" cellspacing="0" cellpadding="3" border="0">
<tr>
<td class="td" width="30%" align="left">
<?php
echo $word_database_user;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_username" value="root" type="text" onmouseover="return overlib('<?php
echo $word_database_user_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_user_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_pass;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_password" type="password" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_confirm_password;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_password2" type="password" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_name;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left" class="td">
<?php
// They might not be installing under the CMS they intend on using...
$jzSERVICES->loadService("cms", $_POST['cms_type']);
$value = $jzSERVICES->cmsDefaultDatabase();
$jzSERVICES->loadService("cms", $cms_type);
?>
<input name="database" value="<?php
echo $value;
?>
" type="text" onmouseover="return overlib('<?php
echo $word_database_name_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_name_help;
?>
');" onmouseout="return nd();">?</a>-->
<br>
<?php
// If this is mambo we MUST use their db
if ($cms_type != "standalone" and $cms_type != "") {
echo $word_cms_db_pick;
}
?>
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_server;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="socket" value="localhost" type="text" onmouseover="return overlib('<?php
echo $word_database_server_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_server_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_type;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<select name="type" style="width:115px" onmouseover="return overlib('<?php
echo $word_database_type_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<option value="DBX_MYSQL" selected>MySQL
<option value="DBX_PGSQL">PostgreSQL
<option value="DBX_SQLITE">SQLite
<option value="DBX_MSSQL">Microsoft SQL Server
<option value="DBX_ODBC">ODBC
<option value="DBX_FBSQL">FrontBase
<option value="DBX_OCI8">Oracle (OCI8)
<option value="DBX_SYBASECT">Sybase-CT
</select>
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_type_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<?php
// Only show this in standalone mode
if ($cms_type == "" || $cms_type == "standalone") {
?>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_create_database;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<select name="create_db" style="width:115px" onmouseover="return overlib('<?php
echo $word_create_database_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<option value="true"><?php
echo $word_true;
?>
<option value="false" selected><?php
echo $word_false;
?>
<option value="drop"><?php
echo $word_drop;
?>
</select>
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_drop_database_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<?php
} else {
echo '<input type="hidden" name="create_db" value="true">';
}
?>
</table>
<?php
return 0;
break;
case "db":
// let's set the words we'll need
global $word_creating_database, $word_creating_tables, $word_database_created, $word_successful, $word_dropping_database, $word_failed, $word_exists;
// first write the constants file.
if ($_POST['db_password'] != $_POST['db_password2']) {
echo "Sorry, your password does not match. Please go back and try again.";
return -1;
}
$text = "";
$text .= "<?php\n";
$text .= "\$sql_type = \"" . $_POST['type'] . "\";\n";
$text .= "\$sql_usr = \"" . $_POST['db_username'] . "\";\n";
$text .= "\$sql_pw = \"" . $_POST['db_password'] . "\";\n";
$text .= "\$sql_socket = \"" . $_POST['socket'] . "\";\n";
$text .= "\$sql_db = \"" . $_POST['database'] . "\";\n";
$text .= "?>";
$fname = $this->data_dir . '/db_constants.php';
@unlink($fname);
if (!($handle = @fopen($fname, 'w'))) {
touch($this->data_dir . '/db_constants.php');
}
if (!fopen($fname, 'w')) {
echo "could not write {$this->data_dir} /db_constants.php";
return -1;
}
fwrite($handle, $text);
fclose($handle);
// Now to use it.
require_once $fname;
// Now should we drop first?
if ($_POST['create_db'] == "drop") {
jz_db_drop();
echo $word_dropping_database . "<br>";
echo " - " . $sql_db . ' - <font color="green">' . $word_successful . '</font><br><br>';
// Now let's clean the cache
@unlink($include_path . "data/backend/backend");
}
if ($_POST['create_db'] == "drop" or $_POST['create_db'] == "true") {
echo $word_creating_database . "<br>";
if (jz_db_create()) {
echo " - " . $sql_db . ' - <font color="green">' . $word_successful . '</font><br><br>';
} else {
@($link = jz_db_connect());
$results = @jz_db_query($link, "show tables from " . $sql_db);
if ($results->data[0][0] != "") {
echo " - " . $sql_db . ' - <font color="green">' . $word_exists . '</font><br><br>';
} else {
echo " - " . $sql_db . ' - <font color="red">' . $word_failed . '</font><br><br>';
}
}
}
if (!($link = jz_db_connect())) {
die("could not connect to database.");
return -1;
}
if ($_POST['create_db'] == "drop" or $_POST['create_db'] == "true" or $_POST['create_db'] == "false") {
echo $word_creating_tables . "<br>";
// Now let's see if we need to create each table if it does NOT exist
$results = jz_db_query($link, "show tables from " . $sql_db);
if ($results !== false && is_array($results) && $results != array()) {
foreach ($results as $data) {
if (isset($data[0])) {
foreach ($data as $a) {
${$a}[0] = true;
}
}
}
}
// Now let's open the sql script
global $include_path, $sql_type;
$data = file_get_contents($include_path . "install/jinzora.sql");
// Now let's break it out per table
$sqlArr = explode(";", $data);
foreach ($sqlArr as $sql) {
if (stristr($sql, "CREATE TABLE")) {
$table = substr($sql, strpos($sql, "-- Table structure for table") + strlen("-- Table structure for table") + 2);
$table = substr($table, 0, strpos($table, "`"));
$res = jz_db_query($link, $sql);
if ($res !== false) {
echo ' - Creating table: ' . $table . ' - <font color="green">' . $word_successful . '</font><br>';
} else {
if ($jz_nodes) {
echo ' - Creating table: ' . $table . ' - <font color="green">' . $word_exists . '</font><br>';
} else {
echo ' - Creating table: ' . $table . ' - <font color="red">' . $word_failed . '</font><br>';
}
}
} else {
if (false !== stristr($sql, "CREATE INDEX")) {
@jz_db_query($link, $sql);
}
}
}
echo "<br>" . $word_database_created;
}
echo '<input name="dbstep" value="pop" type=hidden>' . "\n";
// Now did they want to manually create it?
/*
if ($_POST['create_db'] == "false"){
// Now let's see if we need to create each table if it does NOT exist
$results = jz_db_query($link, "show tables from ". $sql_db);
if ($results !== false) {
foreach ($results as $data) {
if (count($data) == 5){
echo "Database connection successful!";
break;
} else {
?>
Sorry, there was an error reading your database. Please verify that you've created the database manually and click below to try again
<?php
exit();
}
}
}
}
*/
// The above form needs work to integrate with the installer.
// think about a keep_post_vars() function that keeps the values in hidden fields.
// add our root node to the database.
jz_db_query($link, "INSERT INTO jz_nodes(path,name,level,my_id) VALUES('','',0,'" . uniqid("T") . "')");
// add backend details:
parent::install_be();
parent::install_users();
return 1;
break;
}
}
/**
* Installation for the backend.
* This allows for installs that require a web interface
* and those that don't.
*
* Returns 1 when complete
* Returns 0 when still in progress (requires info from the web)
* Returns -1 if failed.
*
* @author Ben Dodson
* @version 9/04/04
* @since 9/04/04
*/
function install()
{
global $backend, $version, $include_path, $jzSERVICES, $sql_type, $sql_socket, $sql_db, $sql_usr, $sql_pw;
// store version, details, and name (including SQL type)
// in a database.
// run the webpage found in install.php (move that code here.)
$step = isset($_POST["dbstep"]) ? $_POST["dbstep"] : "init";
switch ($step) {
case "init":
global $word_database_user, $word_database_pass, $word_database_name, $word_database_server, $word_database_type, $word_database_user_help, $word_database_pass_help, $word_database_name_help, $word_database_server_help, $word_database_type_help, $cms_type, $cms_mode, $word_cms_db_pick, $word_confirm_password, $word_create_database, $word_false, $word_true, $word_create_database_help, $word_drop, $word_drop_database_help;
?>
<input name="dbstep" value="db" type=hidden>
<table width="100%" cellspacing="0" cellpadding="3" border="0">
<tr>
<td class="td" width="30%" align="left">
<?php
echo $word_database_user;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_username" value="root" type="text" onmouseover="return overlib('<?php
echo $word_database_user_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_user_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_pass;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_password" type="password" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_confirm_password;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="db_password2" type="password" onmouseover="return overlib('<?php
echo $word_database_pass_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_name;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left" class="td">
<?php
// They might not be installing under the CMS they intend on using...
$jzSERVICES->loadService("cms", $_POST['cms_type']);
$value = $jzSERVICES->cmsDefaultDatabase();
$jzSERVICES->loadService("cms", $cms_type);
?>
<input name="database" value="<?php
echo $value;
?>
" type="text" onmouseover="return overlib('<?php
echo $word_database_name_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_name_help;
?>
');" onmouseout="return nd();">?</a>-->
<br>
<?php
// If this is mambo we MUST use their db
if ($cms_type != "standalone" and $cms_type != "") {
echo $word_cms_db_pick;
}
?>
</td>
</tr>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_database_server;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<input name="socket" value="localhost" type="text" onmouseover="return overlib('<?php
echo $word_database_server_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_database_server_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<?php
// Only show this in standalone mode
if ($cms_type == "" || $cms_type == "standalone") {
?>
<tr>
<td class="td" width="30%" align="left" valign="top">
<?php
echo $word_create_database;
?>
</td>
<td width="1"> </td>
<td width="70%" align="left">
<select name="create_db" style="width:115px" onmouseover="return overlib('<?php
echo $word_create_database_help;
?>
', FGCOLOR, '#eeeeeee');" onmouseout="return nd();">
<option value="true"><?php
echo $word_true;
?>
<option value="false" selected><?php
echo $word_false;
?>
<option value="drop"><?php
echo $word_drop;
?>
</select>
<!-- <a class="helpbox2" href="javascript:void(0);" onmouseover="return overlib('<?php
echo $word_drop_database_help;
?>
');" onmouseout="return nd();">?</a>-->
</td>
</tr>
<?php
} else {
echo '<input type="hidden" name="create_db" value="true">';
}
?>
</table>
<?php
return 0;
break;
case "db":
// let's set the words we'll need
global $word_creating_database, $word_creating_tables, $word_database_created, $word_successful, $word_dropping_database, $word_failed, $word_exists;
// first write the constants file.
if ($_POST['db_password'] != $_POST['db_password2']) {
echo "Sorry, your password does not match. Please go back and try again.";
return -1;
}
$text = "";
$text .= "<?php\n";
$text .= "// settings for " . $backend . ":\n";
$text .= "\$sql_usr = \"" . $_POST['db_username'] . "\";\n";
$text .= "\$sql_pw = \"" . $_POST['db_password'] . "\";\n";
$text .= "\$sql_socket = \"" . $_POST['socket'] . "\";\n";
$text .= "\$sql_db = \"" . $_POST['database'] . "\";\n";
$text .= "?>";
$fname = $this->data_dir . '/db_constants.php';
@unlink($fname);
if (!($handle = @fopen($fname, 'w'))) {
touch($this->data_dir . '/db_constants.php');
}
if (!fopen($fname, 'w')) {
echo "could not write {$this->data_dir} /db_constants.php";
return -1;
}
fwrite($handle, $text);
fclose($handle);
// Now to use it.
require_once $fname;
// Now should we drop first?
if ($_POST['create_db'] == "drop") {
jz_db_drop();
echo $word_dropping_database . "<br>";
echo " - " . $sql_db . ' - <font color="green">' . $word_successful . '</font><br><br>';
// Now let's clean the cache
@unlink($include_path . "data/backend/backend");
}
if ($_POST['create_db'] == "drop" or $_POST['create_db'] == "true") {
echo $word_creating_database . "<br>";
if (jz_db_create()) {
echo " - " . $sql_db . ' - <font color="green">' . $word_successful . '</font><br><br>';
} else {
@($link = jz_db_connect());
$results = @jz_db_query($link, "show tables from " . $sql_db);
if ($results->data[0][0] != "") {
echo " - " . $sql_db . ' - <font color="green">' . $word_exists . '</font><br><br>';
} else {
echo " - " . $sql_db . ' - <font color="red">' . $word_failed . '</font><br><br>';
}
}
}
if (!($link = jz_db_connect())) {
die("could not connect to database.");
return -1;
}
if ($_POST['create_db'] == "drop" or $_POST['create_db'] == "true" or $_POST['create_db'] == "false") {
echo $word_creating_tables . "<br>";
// Now let's see if we need to create each table if it does NOT exist
$results = jz_db_query($link, "show tables from " . $sql_db);
if ($results !== false && is_array($results) && $results != array()) {
foreach ($results as $data) {
if (isset($data[0])) {
foreach ($data as $a) {
${$a}[0] = true;
}
}
}
}
// Now let's open the sql script
global $include_path, $sql_type;
$data = file_get_contents($include_path . "install/jinzora.sql");
// Now let's break it out per table
$sqlArr = explode(";", $data);
foreach ($sqlArr as $sql) {
if (stristr($sql, "CREATE TABLE")) {
$table = substr($sql, strpos($sql, "-- Table structure for table") + strlen("-- Table structure for table") + 2);
$table = substr($table, 0, strpos($table, "`"));
$res = jz_db_query($link, $sql);
if ($res !== false) {
echo ' - Creating table: ' . $table . ' - <font color="green">' . $word_successful . '</font><br>';
} else {
if ($jz_nodes) {
echo ' - Creating table: ' . $table . ' - <font color="green">' . $word_exists . '</font><br>';
} else {
echo ' - Creating table: ' . $table . ' - <font color="red">' . $word_failed . '</font><br>';
}
}
} else {
if (false !== stristr($sql, "CREATE INDEX")) {
@jz_db_query($link, $sql);
}
}
}
/*
/* nodes is nodes AND tracks' shared functionality.
$res = jz_db_query($link, "CREATE TABLE jz_nodes (
my_id varchar(20) NOT NULL UNIQUE,
name varchar(255) default NULL,
leaf varchar(5) default 'false',
lastplayed INT default 0,
playcount INT default 0,
directplaycount INT default 0,
dlcount INT default 0,
viewcount INT default 0,
rating FLOAT default 0,
rating_count FLOAT default 0,
rating_val FLOAT default 0,
main_art varchar(255) default NULL,
valid varchar(5) default 'true',
path varchar(255) default '/' NOT NULL PRIMARY KEY,
ptype varchar(20) default NULL,
hidden varchar(10) default 'false',
filepath varchar(255) default '/',
level INT default 0,
descr varchar(255) default NULL,
longdesc text default NULL,
date_added INT default NULL,
leafcount INT default 0,
nodecount INT default 0,
featured varchar(5) default 'false')");
if ($res !== false){
echo ' - jz_nodes - <font color="green">'. $word_successful. '</font><br>';
} else {
if ($jz_nodes){
echo ' - jz_nodes - <font color="green">'. $word_exists. '</font><br>';
} else {
echo ' - jz_nodes - <font color="red">'. $word_failed. '</font><br>';
}
}
$res = jz_db_query($link, "CREATE TABLE jz_tracks (
my_id varchar(20) NOT NULL UNIQUE,
path varchar(255) default '/' NOT NULL PRIMARY KEY,
filepath varchar(255) default NULL,
name varchar(255) default NULL,
level INT default 0,
hidden varchar(10) default 'false',
trackname varchar(255) default NULL,
number varchar(3) default '-',
valid varchar(5) default 'true',
bitrate varchar(10) default '-',
frequency varchar(10) default '-',
filesize varchar(10) default '-',
length varchar(10) default '-',
genre varchar(20) default '-',
artist varchar(100) default '-',
album varchar(150) default '-',
year varchar(5) default '-',
extension varchar(5) default NULL,
lyrics text default NULL,
sheet_music text default NULL)");
if ($res !== false){
echo ' - jz_tracks - <font color="green">'. $word_successful. '</font><br>';
} else {
if ($jz_tracks){
echo ' - jz_tracks - <font color="green">'. $word_exists. '</font><br>';
} else {
echo ' - jz_tracks - <font color="red">'. $word_failed. '</font><br>';
}
}
$res = jz_db_query($link, "CREATE TABLE jz_links (
my_id INT NOT NULL PRIMARY KEY,
parent varchar(255) default '/' NOT NULL,
path varchar(255) default '/' NOT NULL,
type varchar(5) NOT NULL)");
if ($res !== false){
echo ' - jz_links - <font color="green">'. $word_successful. '</font><br>';
} else {
if ($jz_links){
echo ' - jz_links - <font color="green">'. $word_exists. '</font><br>';
} else {
echo ' - jz_links - <font color="red">'. $word_failed. '</font><br>';
}
}
$res = jz_db_query($link, "CREATE TABLE jz_discussions (
my_id INT NOT NULL PRIMARY KEY,
date_added INT default NULL,
my_user varchar(32) default NULL,
comment TEXT default NULL,
path varchar(255) default NULL)");
if ($res !== false){
echo ' - jz_discussions - <font color="green">'. $word_successful. '</font><br>';
} else {
if ($jz_discussions){
echo ' - jz_discussions - <font color="green">'. $word_exists. '</font><br>';
} else {
echo ' - jz_discussions - <font color="red">'. $word_failed. '</font><br>';
}
}
$res = jz_db_query($link, "CREATE TABLE jz_requests (
my_id INT NOT NULL PRIMARY KEY,
entry TEXT default NULL,
comment TEXT default NULL,
my_user varchar(32) default NULL,
type varchar(10) default 'request',
path varchar(255) default NULL)");
if ($res !== false){
echo ' - jz_requests - <font color="green">'. $word_successful. '</font><br>';
} else {
if ($jz_requests){
echo ' - jz_requests - <font color="green">'. $word_exists. '</font><br>';
} else {
echo ' - jz_requests - <font color="red">'. $word_failed. '</font><br>';
}
}
*/
/* After the database has been released, if you want to add a column,
* alter the table. These functions will just not do anything
* if the table already exists, so you cannot just add fields above.
*/
echo "<br>" . $word_database_created;
}
echo '<input name="dbstep" value="pop" type=hidden>' . "\n";
// Now did they want to manually create it?
/*
if ($_POST['create_db'] == "false"){
// Now let's see if we need to create each table if it does NOT exist
$results = jz_db_query($link, "show tables from ". $sql_db);
if ($results !== false) {
foreach ($results as $data) {
if (count($data) == 5){
echo "Database connection successful!";
break;
} else {
?>
Sorry, there was an error reading your database. Please verify that you've created the database manually and click below to try again
<?php
exit();
}
}
}
}
*/
// The above form needs work to integrate with the installer.
// think about a keep_post_vars() function that keeps the values in hidden fields.
// add our root node to the database.
jz_db_query($link, "INSERT INTO jz_nodes(path,name,level,my_id) VALUES('','',0,'" . uniqid("T") . "')");
// add backend details:
parent::install_be();
parent::install_users();
return 1;
break;
}
}
