Esempio n. 1
0
 function jz_db_simple_query($sql)
 {
     global $JZLINK;
     if (!isset($JZLINK)) {
         if (!($JZLINK = jz_db_connect())) {
             die("could not connect to database.");
         }
     }
     $results = jz_db_query($JZLINK, $sql);
     // Now let's close out
     //jz_db_close($link);
     // Return the data
     if ($results->rows > 0) {
         return $results->data[0];
     } else {
         return false;
     }
 }
Esempio n. 2
0
function jz_db_simple_query($sql)
{
    global $JZLINK;
    if (false !== ($res = jz_db_cache('simple', $sql))) {
        return $res;
    }
    if (!isset($JZLINK)) {
        if (!($JZLINK = jz_db_connect())) {
            die("could not connect to database.");
        }
    }
    $results = mssql_query($sql, $JZLINK);
    $res = @mssql_fetch_array($results, MSSQL_BOTH);
    jz_db_cache('simple', $sql, $res);
    return $res;
}
Esempio n. 3
0
    /**
     * 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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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">&nbsp;</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();">
								<!--&nbsp;&nbsp; <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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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>
								<!--&nbsp; <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">&nbsp;</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>
										<!--&nbsp; <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 "&nbsp;&nbsp;&nbsp; - " . $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 "&nbsp;&nbsp;&nbsp; - " . $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 "&nbsp;&nbsp;&nbsp; - " . $sql_db . ' - <font color="green">' . $word_exists . '</font><br><br>';
                        } else {
                            echo "&nbsp;&nbsp;&nbsp; - " . $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 '&nbsp;&nbsp;&nbsp; - Creating table: ' . $table . ' - <font color="green">' . $word_successful . '</font><br>';
                            } else {
                                if ($jz_nodes) {
                                    echo '&nbsp;&nbsp;&nbsp; - Creating table: ' . $table . ' - <font color="green">' . $word_exists . '</font><br>';
                                } else {
                                    echo '&nbsp;&nbsp;&nbsp; - 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;
        }
    }
Esempio n. 4
0
 /**
  * Adds a blurb to the node's discussion
  * 
  * @author Ben Dodson <*****@*****.**>
  * @version 8/11/05
  * @since 5/15/04
  */
 function addDiscussion($text, $username)
 {
     global $sql_type, $sql_pw, $sql_usr, $sql_socket, $sql_db;
     if (!($link = jz_db_connect())) {
         die("could not connect to database.");
     }
     $path = jz_db_escape($this->getPath("String"));
     $text = jz_db_escape($text);
     $username = jz_db_escape($username);
     $res = jz_db_query($link, "SELECT * FROM jz_discussions");
     $num = $res->rows + 1;
     if (false === jz_db_query($link, "INSERT INTO jz_discussions(my_id,path,my_user,comment,date_added)\n                     \t                  VALUES({$num},'{$path}','{$username}','{$text}'," . time() . ")")) {
         die(jz_db_error($link));
     }
     jz_db_close($link);
 }
Esempio n. 5
0
    /**
     * 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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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">&nbsp;</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();">
								<!--&nbsp;&nbsp; <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">&nbsp;</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();">
								<!--&nbsp; <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">&nbsp;</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>
										<!--&nbsp; <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 "&nbsp;&nbsp;&nbsp; - " . $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 "&nbsp;&nbsp;&nbsp; - " . $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 "&nbsp;&nbsp;&nbsp; - " . $sql_db . ' - <font color="green">' . $word_exists . '</font><br><br>';
                        } else {
                            echo "&nbsp;&nbsp;&nbsp; - " . $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 '&nbsp;&nbsp;&nbsp; - Creating table: ' . $table . ' - <font color="green">' . $word_successful . '</font><br>';
                            } else {
                                if ($jz_nodes) {
                                    echo '&nbsp;&nbsp;&nbsp; - Creating table: ' . $table . ' - <font color="green">' . $word_exists . '</font><br>';
                                } else {
                                    echo '&nbsp;&nbsp;&nbsp; - 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 '&nbsp;&nbsp;&nbsp; - jz_nodes - <font color="green">'. $word_successful. '</font><br>';
                    } else {
                    	if ($jz_nodes){
                    		echo '&nbsp;&nbsp;&nbsp; - jz_nodes - <font color="green">'. $word_exists. '</font><br>';
                    	} else {
                    		echo '&nbsp;&nbsp;&nbsp; - 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 '&nbsp;&nbsp;&nbsp; - jz_tracks - <font color="green">'. $word_successful. '</font><br>';
                    } else {
                    	if ($jz_tracks){
                    		echo '&nbsp;&nbsp;&nbsp; - jz_tracks - <font color="green">'. $word_exists. '</font><br>';
                    	} else {
                    		echo '&nbsp;&nbsp;&nbsp; - 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 '&nbsp;&nbsp;&nbsp; - jz_links - <font color="green">'. $word_successful. '</font><br>';
                    } else {
                    	if ($jz_links){
                    		echo '&nbsp;&nbsp;&nbsp; - jz_links - <font color="green">'. $word_exists. '</font><br>';
                    	} else {
                    		echo '&nbsp;&nbsp;&nbsp; - 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 '&nbsp;&nbsp;&nbsp; - jz_discussions - <font color="green">'. $word_successful. '</font><br>';
                    } else {
                    	if ($jz_discussions){
                    		echo '&nbsp;&nbsp;&nbsp; - jz_discussions - <font color="green">'. $word_exists. '</font><br>';
                    	} else {
                    		echo '&nbsp;&nbsp;&nbsp; - 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 '&nbsp;&nbsp;&nbsp; - jz_requests - <font color="green">'. $word_successful. '</font><br>';
                    } else {
                    	if ($jz_requests){
                    		echo '&nbsp;&nbsp;&nbsp; - jz_requests - <font color="green">'. $word_exists. '</font><br>';
                    	} else {
                    		echo '&nbsp;&nbsp;&nbsp; - 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;
        }
    }