INstall Script Problem

papillonstudios · July 28, 2009

ok i have been creating a install script for my cms, but well its not working right, and i dont know what is wrong i have went of the code many times, and tried different things and cant find whats wrong.

heres the code for step 1 where the problem is

<?php

if (!defined('error_check')) die('You Cannot Access This Page From This Location');
        //If the form hasn't been submitted, show it.
        if (!$_POST['post']) {

?>

<form method="post">
    <table width="75%">
    
        <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr>
        
        <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr>
        
        <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr>
        
        <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr>
        
        <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr>
        
     </table>

</form>

<?php

        }
        //Or else it has been submitted...
        else {
            //Get information from the forms secure it all.
            
            $host= secure($_POST['host']);
		$db = secure($_POST['dname']);
		$dbuser = secure($_POST['dbuser']);
		$dbpass = secure($_POST['dbpass']);


		$connect = mysql_connect($host,$db,dbpass); 

		if ($connect) {
                
			$select = mysql_select_db ($dbname);

				if ($select) {

					$users = "CREATE TABLE `users` (
							  `id` int(5) NOT NULL auto_increment,
							  `username` varchar(30) NOT NULL,
							  `password` varchar(255) NOT NULL,
							  `email` varchar(50) NOT NULL,
							  `location` varchar(50) NOT NULL,
							  `aim` varchar(30) NOT NULL,
							  `msn` varchar(30) default NULL,
							  `gtalk` varchar(30) NOT NULL,
							  `ip` varchar(30) NOT NULL,
							  `signup` varchar(30) NOT NULL,
							  `membergroup` varchar(30) NOT NULL,
							  `bio` varchar(400) NOT NULL,
							  PRIMARY KEY  (`id`)
							);";
					$permissions = "
							CREATE TABLE `permissions` (
							mg_id INT(10) NOT NULL AUTO_INCREMENT,
							mg_name VARCHAR(50) NOT NULL,
							editprofile INT(1) NOT NULL,
							viewprofile INT(1) NOT NULL,
							admin INT(1) NOT NULL,
							moderate INT(1) NOT NULL,
							PRIMARY KEY (`mg_id`)
							);";
					$addperm = "
							INSERT INTO `permissions` 
							(`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES 
							(1, 'user', 1, 1, 0, 0),
							(2, 'admin', 1, 1, 1, 1),
							(3, 'guest', 0, 0, 0, 0);
							(4, 'mod', 1, 1, 0, 1);
									";

					$info = "CREATE TABLE `info` (
							`id` INT( 11 ) NOT NULL ,
							`version` VARCHAR( 50 ) NOT NULL ,
							`sitename` VARCHAR( 100 ) NOT NULL ,
							`siteurl` VARCHAR( 100 ) NOT NULL ,
							`sitedesc` TEXT NOT NULL ,
							`aemail` VARCHAR( 300 ) NOT NULL ,
							`emailink` VARCHAR( 300 ) NOT NULL ,
							PRIMARY KEY ( `id` )
							) ENGINE = MYISAM";

					$news = "CREATE TABLE `news` (
						   `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
						   `title` VARCHAR( 50 ) NOT NULL ,
						   `username` VARCHAR( 50 ) NOT NULL ,
						   `date` TIMESTAMP NOT NULL 
						   `body` TEXT NOT NULL ,
						   PRIMARY KEY ( `id` )
						   ) ENGINE = MYISAM";

					$nav = "CREATE TABLE `nav` (
							`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
							`linkname` VARCHAR( 50 ) NOT NULL ,
							`url` VARCHAR( 100 ) NOT NULL ,
							PRIMARY KEY ( `id` )
							) ENGINE = MYISAM";

					$donwloads = "CREATE TABLE `downloads` (
								 `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
								 `name` VARCHAR( 100 ) NOT NULL ,
								 `url` VARCHAR( 100 ) NOT NULL ,
								 `date` VARCHAR( 20 ) NOT NULL ,
								 `username` VARCHAR( 50 ) NOT NULL ,
								 PRIMARY KEY ( `id` )
								 ) ENGINE = MYISAM";

					$games = "CREATE TABLE `games` (
							 `id` INT NOT NULL AUTO_INCREMENT ,
							 `name` VARCHAR( 20 ) NOT NULL ,
							 `source` VARCHAR( 100 ) NOT NULL ,
							 `gamedesc` TEXT NOT NULL ,
							 PRIMARY KEY ( `id` )
							 ) ENGINE = MYISAM ";

					$mysqlfile = fopen('../defs.php', 'w+');
					$content = "
					<?php
					//Database Information \n
					DEFINE ('DB_USER', '$dbuser'); \n
					DEFINE ('DB_PASSWORD', '$dbpass'); \n
					DEFINE ('DB_HOST', '$host'); \n
					DEFINE ('DB_NAME', '$db'); \n
					?>";

					header("Location: index.php?step=step2");

			}else{
						echo "Error message = ".mysql_error();
			}

		}else{
               echo "Error message = ".mysql_error(); 
		}

            //A query to update everything

}


?>

i also have a example up on a server http://isustest.hostzi.com

gevans · July 28, 2009

What do you get on screen? Is there an error, blank screen....

gevans · July 28, 2009

$db = secure($_POST['dname']);

where is this function? secure()

and there's a couple of little changes in this...

<?php

if (!defined('error_check')) die('You Cannot Access This Page From This Location');

//If the form hasn't been submitted, show it.
	if (isset($_POST['post'])) {

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" value="1" name="post" />
    <table width="75%">
   
        <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr>
       
        <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr>
       
        <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr>
       
        <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr>
       
        <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr>
       
     </table>

</form>

<?php

        }
        //Or else it has been submitted...
        else {
            //Get information from the forms secure it all.
            
            $host= secure($_POST['host']);
         $db = secure($_POST['dname']);
         $dbuser = secure($_POST['dbuser']);
         $dbpass = secure($_POST['dbpass']);

      
         $connect = mysql_connect($host,$db,dbpass); 
         
         if ($connect) {
                
            $select = mysql_select_db ($dbname);
            
               if ($select) {
                  
                  $users = "CREATE TABLE `users` (
                          `id` int(5) NOT NULL auto_increment,
                          `username` varchar(30) NOT NULL,
                          `password` varchar(255) NOT NULL,
                          `email` varchar(50) NOT NULL,
                          `location` varchar(50) NOT NULL,
                          `aim` varchar(30) NOT NULL,
                          `msn` varchar(30) default NULL,
                          `gtalk` varchar(30) NOT NULL,
                          `ip` varchar(30) NOT NULL,
                          `signup` varchar(30) NOT NULL,
                          `membergroup` varchar(30) NOT NULL,
                          `bio` varchar(400) NOT NULL,
                          PRIMARY KEY  (`id`)
                        );";
                  $permissions = "
                        CREATE TABLE `permissions` (
                        mg_id INT(10) NOT NULL AUTO_INCREMENT,
                        mg_name VARCHAR(50) NOT NULL,
                        editprofile INT(1) NOT NULL,
                        viewprofile INT(1) NOT NULL,
                        admin INT(1) NOT NULL,
                        moderate INT(1) NOT NULL,
                        PRIMARY KEY (`mg_id`)
                        );";
                  $addperm = "
                        INSERT INTO `permissions` 
                        (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES 
                        (1, 'user', 1, 1, 0, 0),
                        (2, 'admin', 1, 1, 1, 1),
                        (3, 'guest', 0, 0, 0, 0);
                        (4, 'mod', 1, 1, 0, 1);
                              ";
                              
                  $info = "CREATE TABLE `info` (
                        `id` INT( 11 ) NOT NULL ,
                        `version` VARCHAR( 50 ) NOT NULL ,
                        `sitename` VARCHAR( 100 ) NOT NULL ,
                        `siteurl` VARCHAR( 100 ) NOT NULL ,
                        `sitedesc` TEXT NOT NULL ,
                        `aemail` VARCHAR( 300 ) NOT NULL ,
                        `emailink` VARCHAR( 300 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $news = "CREATE TABLE `news` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `title` VARCHAR( 50 ) NOT NULL ,
                        `username` VARCHAR( 50 ) NOT NULL ,
                        `date` TIMESTAMP NOT NULL 
                        `body` TEXT NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $nav = "CREATE TABLE `nav` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `linkname` VARCHAR( 50 ) NOT NULL ,
                        `url` VARCHAR( 100 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $donwloads = "CREATE TABLE `downloads` (
                            `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                            `name` VARCHAR( 100 ) NOT NULL ,
                            `url` VARCHAR( 100 ) NOT NULL ,
                            `date` VARCHAR( 20 ) NOT NULL ,
                            `username` VARCHAR( 50 ) NOT NULL ,
                            PRIMARY KEY ( `id` )
                            ) ENGINE = MYISAM";
                  
                  $games = "CREATE TABLE `games` (
                         `id` INT NOT NULL AUTO_INCREMENT ,
                         `name` VARCHAR( 20 ) NOT NULL ,
                         `source` VARCHAR( 100 ) NOT NULL ,
                         `gamedesc` TEXT NOT NULL ,
                         PRIMARY KEY ( `id` )
                         ) ENGINE = MYISAM ";
                  
                  $mysqlfile = fopen('../defs.php', 'w+');
                  $content = "
                  <?php
                  //Database Information \n
                  DEFINE ('DB_USER', '$dbuser'); \n
                  DEFINE ('DB_PASSWORD', '$dbpass'); \n
                  DEFINE ('DB_HOST', '$host'); \n
                  DEFINE ('DB_NAME', '$db'); \n
                  ?>";
                  
                  header("Location: index.php?step=step2");
                  
            }else{
                     echo "Error message = ".mysql_error();
            }
            
         }else{
               echo "Error message = ".mysql_error();
         }

            //A query to update everything

}


?>

papillonstudios · July 28, 2009

with the way i code it doesnt show php errors but if theres a problem then it just doesn't show any after the error and thats what happening but the code syntax is right not sure whats wrong.

to see what i mean go to http://isustest.hostzi.com

gevans · July 28, 2009

Turn errors on when you're developing. or do some checks in the code to see where its stopping and why it's stopping there.

also...

$db = secure($_POST['dname']);

where is this function? secure()

papillonstudios · July 28, 2009

ok i got the function put that i forgot about

function secure($string)
{

    $string = strip_tags($string);
    $string = htmlspecialchars($string);
    $string = trim($string);
    $string = stripslashes($string);

    return $string;
}

so now when i load the page i get this.

Access denied for user 'GamingFusion'@'localhost' (using password: YES)

its a MYDQL Error but im not doign anything with MYsql untill the button is clicked

gevans · July 28, 2009

Show your updated code

papillonstudios · July 28, 2009

<?php

if (!defined('error_check')) die('You Cannot Access This Page From This Location');

//If the form hasn't been submitted, show it.
      if (isset($_POST['post'])) {

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
   <input type="hidden" value="1" name="post" />
    <table width="75%">
   
        <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr>
       
        <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr>
       
        <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr>
       
        <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr>
       
        <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr>
       
     </table>

</form>

<?php

        }
        //Or else it has been submitted...
        else {
            //Get information from the forms secure it all.
            
            $host= secure($_POST['host']);
         $db = secure($_POST['dname']);
         $dbuser = secure($_POST['dbuser']);
         $dbpass = secure($_POST['dbpass']);

      
         $connect = mysql_connect($host,$db,dbpass); 
         
         if ($connect) {
                
            $select = mysql_select_db ($dbname);
            
               if ($select) {
                  
                  $users = "CREATE TABLE `users` (
                          `id` int(5) NOT NULL auto_increment,
                          `username` varchar(30) NOT NULL,
                          `password` varchar(255) NOT NULL,
                          `email` varchar(50) NOT NULL,
                          `location` varchar(50) NOT NULL,
                          `aim` varchar(30) NOT NULL,
                          `msn` varchar(30) default NULL,
                          `gtalk` varchar(30) NOT NULL,
                          `ip` varchar(30) NOT NULL,
                          `signup` varchar(30) NOT NULL,
                          `membergroup` varchar(30) NOT NULL,
                          `bio` varchar(400) NOT NULL,
                          PRIMARY KEY  (`id`)
                        );";
                  $permissions = "
                        CREATE TABLE `permissions` (
                        mg_id INT(10) NOT NULL AUTO_INCREMENT,
                        mg_name VARCHAR(50) NOT NULL,
                        editprofile INT(1) NOT NULL,
                        viewprofile INT(1) NOT NULL,
                        admin INT(1) NOT NULL,
                        moderate INT(1) NOT NULL,
                        PRIMARY KEY (`mg_id`)
                        );";
                  $addperm = "
                        INSERT INTO `permissions` 
                        (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES 
                        (1, 'user', 1, 1, 0, 0),
                        (2, 'admin', 1, 1, 1, 1),
                        (3, 'guest', 0, 0, 0, 0);
                        (4, 'mod', 1, 1, 0, 1);
                              ";
                              
                  $info = "CREATE TABLE `info` (
                        `id` INT( 11 ) NOT NULL ,
                        `version` VARCHAR( 50 ) NOT NULL ,
                        `sitename` VARCHAR( 100 ) NOT NULL ,
                        `siteurl` VARCHAR( 100 ) NOT NULL ,
                        `sitedesc` TEXT NOT NULL ,
                        `aemail` VARCHAR( 300 ) NOT NULL ,
                        `emailink` VARCHAR( 300 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $news = "CREATE TABLE `news` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `title` VARCHAR( 50 ) NOT NULL ,
                        `username` VARCHAR( 50 ) NOT NULL ,
                        `date` TIMESTAMP NOT NULL 
                        `body` TEXT NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $nav = "CREATE TABLE `nav` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `linkname` VARCHAR( 50 ) NOT NULL ,
                        `url` VARCHAR( 100 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $donwloads = "CREATE TABLE `downloads` (
                            `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                            `name` VARCHAR( 100 ) NOT NULL ,
                            `url` VARCHAR( 100 ) NOT NULL ,
                            `date` VARCHAR( 20 ) NOT NULL ,
                            `username` VARCHAR( 50 ) NOT NULL ,
                            PRIMARY KEY ( `id` )
                            ) ENGINE = MYISAM";
                  
                  $games = "CREATE TABLE `games` (
                         `id` INT NOT NULL AUTO_INCREMENT ,
                         `name` VARCHAR( 20 ) NOT NULL ,
                         `source` VARCHAR( 100 ) NOT NULL ,
                         `gamedesc` TEXT NOT NULL ,
                         PRIMARY KEY ( `id` )
                         ) ENGINE = MYISAM ";
                  
                  $mysqlfile = fopen('../defs.php', 'w+');
                  $content = "
                  <?php
                  //Database Information \n
                  DEFINE ('DB_USER', '$dbuser'); \n
                  DEFINE ('DB_PASSWORD', '$dbpass'); \n
                  DEFINE ('DB_HOST', '$host'); \n
                  DEFINE ('DB_NAME', '$db'); \n
                  ?>";
                 
                  header("Location: index.php?step=step2");
                 
            }else{
                     echo "Error message = ".mysql_error();
            }
           
         }else{
               echo "Error message = ".mysql_error();
         }

            //A query to update everything

}


?>

gevans · July 28, 2009

typo

      if (isset($_POST['post'])) {

should be

      if (!isset($_POST['post'])) {

papillonstudios · July 28, 2009

those typos the pop out of no where lol

gevans · July 28, 2009

has that fixed the problem?

if yes please hit solved

papillonstudios · July 28, 2009

ok now after filling out the form with proper information it gives me that error

Error message = Access denied for user 'root'@'localhost' (using password: YES)Could not Connect

gevans · July 28, 2009

ok now after filling out the form with proper information it gives me that error

What error? the db connect error?

papillonstudios · July 28, 2009

ok i looked at the mysql_connect lesson on w3schools and i modified the code heres the new code.

<?php

if (!defined('error_check')) die('You Cannot Access This Page From This Location');

//If the form hasn't been submitted, show it.
      if (!isset($_POST['post'])) {

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
   <input type="hidden" value="1" name="post" />
    <table width="75%">
   
        <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr>
       
        <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr>
       
        <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr>
       
        <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr>
       
        <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr>
       
     </table>

</form>

<?php

        }
        //Or else it has been submitted...
        else {
            //Get information from the forms secure it all.
            
            $host= secure($_POST['host']);
         $db = secure($_POST['dname']);
         $dbuser = secure($_POST['dbuser']);
         $dbpass = secure($_POST['dbpass']);

      
         $connect = mysql_connect($host,$dbuser,dbpass); 
         
         if (!$con)
   	     {
	 die('Could not connect: ' . mysql_error());
     }
                
            $select = mysql_select_db ($dbname);
            
               if (!$con)
		   {
		   die('Could not Select: ' . mysql_error());
		   }
                  
                  $users = "CREATE TABLE `users` (
                          `id` int(5) NOT NULL auto_increment,
                          `username` varchar(30) NOT NULL,
                          `password` varchar(255) NOT NULL,
                          `email` varchar(50) NOT NULL,
                          `location` varchar(50) NOT NULL,
                          `aim` varchar(30) NOT NULL,
                          `msn` varchar(30) default NULL,
                          `gtalk` varchar(30) NOT NULL,
                          `ip` varchar(30) NOT NULL,
                          `signup` varchar(30) NOT NULL,
                          `membergroup` varchar(30) NOT NULL,
                          `bio` varchar(400) NOT NULL,
                          PRIMARY KEY  (`id`)
                        );";
                  $permissions = "
                        CREATE TABLE `permissions` (
                        mg_id INT(10) NOT NULL AUTO_INCREMENT,
                        mg_name VARCHAR(50) NOT NULL,
                        editprofile INT(1) NOT NULL,
                        viewprofile INT(1) NOT NULL,
                        admin INT(1) NOT NULL,
                        moderate INT(1) NOT NULL,
                        PRIMARY KEY (`mg_id`)
                        );";
                  $addperm = "
                        INSERT INTO `permissions` 
                        (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES 
                        (1, 'user', 1, 1, 0, 0),
                        (2, 'admin', 1, 1, 1, 1),
                        (3, 'guest', 0, 0, 0, 0);
                        (4, 'mod', 1, 1, 0, 1);
                              ";
                              
                  $info = "CREATE TABLE `info` (
                        `id` INT( 11 ) NOT NULL ,
                        `version` VARCHAR( 50 ) NOT NULL ,
                        `sitename` VARCHAR( 100 ) NOT NULL ,
                        `siteurl` VARCHAR( 100 ) NOT NULL ,
                        `sitedesc` TEXT NOT NULL ,
                        `aemail` VARCHAR( 300 ) NOT NULL ,
                        `emailink` VARCHAR( 300 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $news = "CREATE TABLE `news` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `title` VARCHAR( 50 ) NOT NULL ,
                        `username` VARCHAR( 50 ) NOT NULL ,
                        `date` TIMESTAMP NOT NULL 
                        `body` TEXT NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $nav = "CREATE TABLE `nav` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `linkname` VARCHAR( 50 ) NOT NULL ,
                        `url` VARCHAR( 100 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $donwloads = "CREATE TABLE `downloads` (
                            `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                            `name` VARCHAR( 100 ) NOT NULL ,
                            `url` VARCHAR( 100 ) NOT NULL ,
                            `date` VARCHAR( 20 ) NOT NULL ,
                            `username` VARCHAR( 50 ) NOT NULL ,
                            PRIMARY KEY ( `id` )
                            ) ENGINE = MYISAM";
                  
                  $games = "CREATE TABLE `games` (
                         `id` INT NOT NULL AUTO_INCREMENT ,
                         `name` VARCHAR( 20 ) NOT NULL ,
                         `source` VARCHAR( 100 ) NOT NULL ,
                         `gamedesc` TEXT NOT NULL ,
                         PRIMARY KEY ( `id` )
                         ) ENGINE = MYISAM ";
                  
                  $mysqlfile = fopen('../defs.php', 'w+');
                  $content = "
                  <?php
                  //Database Information \n
                  DEFINE ('DB_USER', '$dbuser'); \n
                  DEFINE ('DB_PASSWORD', '$dbpass'); \n
                  DEFINE ('DB_HOST', '$host'); \n
                  DEFINE ('DB_NAME', '$db'); \n
                  ?>";
                 
                  header("Location: index.php?step=step2");

}


?>

heres the error i get when submitting the form with proper information for my local server.

Could not connect: Access denied for user 'root'@'localhost' (using password: YES)

gevans · July 28, 2009

         if (!$con)
           {
       die('Could not connect: ' . mysql_error());
        }

You don't use $con you uesa $connect

         if (!$connect)
           {
       die('Could not connect: ' . mysql_error());
        }

Though the fact that you're getting that error tells me there's more to come!

papillonstudios · July 28, 2009

ok it connects and selects the database btu its not putting the tables in

gevans · July 28, 2009

I don't mind helping, but are you trying to fix this at all your self, or have you just given up? :shrug:

papillonstudios · July 28, 2009

i got it goin i forgot a piece at the end to run the mysql query to inert the table lol

papillonstudios · July 28, 2009

UPDATE: Ok i got everything working except the redirect. but i can get that myself thanks dude

papillonstudios · July 28, 2009

ok i modified it a bit and now its not working now. i need help i have triend it a different way and couldnt get it.

it's not doing any of the mysql queries or anything

index.php

<?php
include ('functions.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Isus 2.0 Install | Isus Reinvented</title>
<link rel="stylesheet" type="text/css" href="install.css" />
</head>
<body>
<center>
<div class="wrapper">
    
        <div class="banner">
           <img src="i/logo.png" alt="Isus 2.0 Install Script"/>
        </div>
        <div class="form" align="left">
            <?php
        
                define('error_check', 1);
			$step = $_GET['step'];
    
                if($_GET['step'] == NULL)
                {
                    include('welcome.php');
                }

			else if ($_GET['step'] == 'step1')
                {
                    include('steps/step1.php');
                }

                else if ($_GET['step'] == 'step2')
                {
                    include('steps/step2.php');
                }

                else if ($_GET['step'] == 'step3')
                {
                    include('steps/step3.php');
                }
            ?>
        </div>
        <div class="info">
            <?php
            echo 'Isus 2.0 Installer<br />';
		echo 'Coded By: gfadmin(Chad Gregory)<br />';
		echo 'Contributors: PHPFreaks users and Akura<br />';
		echo '<p>Thanks everyone for helpin out.</p>';
		?>
        </div>
        
    </div>
    </center>
</body>
</html>

step1.php

<?php

if (!defined('error_check')) die('You Cannot Access This Page From This Location');

//If the form hasn't been submitted, show it.
      if (!isset($_POST['post'])) {

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
   <input type="hidden" value="1" name="post" />
    <table width="75%">
   
        <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr>
       
        <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr>
       
        <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr>
       
        <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr>
       
        <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr>
       
     </table>

</form>

<?php

        }
        //Or else it has been submitted...
        else {
            //Get information from the forms secure it all.
            
            $host= secure($_POST['host']);
         $db = secure($_POST['db']);
         $dbuser = secure($_POST['dbuser']);
         $dbpass = secure($_POST['dbpass']);

      
         $connect = mysql_connect($host,$dbuser,dbpass); 
         
         if (!connect)
   	     {
	 die('Could not connect: ' . mysql_error());
     }
                
            $select = mysql_select_db ($db);
            
               if (!$select)
		   {
		   die('Could not Select: ' . mysql_error());
		   }
                  
                  $users = "CREATE TABLE `users` (
                          `id` int(5) NOT NULL auto_increment,
                          `username` varchar(30) NOT NULL,
                          `password` varchar(255) NOT NULL,
                          `email` varchar(50) NOT NULL,
                          `location` varchar(50) NOT NULL,
                          `aim` varchar(30) NOT NULL,
                          `msn` varchar(30) default NULL,
                          `gtalk` varchar(30) NOT NULL,
                          `ip` varchar(30) NOT NULL,
                          `signup` varchar(30) NOT NULL,
                          `membergroup` varchar(30) NOT NULL,
                          `bio` varchar(400) NOT NULL,
                          PRIMARY KEY  (`id`)
                        );";
                  $permissions = "
                        CREATE TABLE `permissions` (
                        mg_id INT(10) NOT NULL AUTO_INCREMENT,
                        mg_name VARCHAR(50) NOT NULL,
                        editprofile INT(1) NOT NULL,
                        viewprofile INT(1) NOT NULL,
                        admin INT(1) NOT NULL,
                        moderate INT(1) NOT NULL,
                        PRIMARY KEY (`mg_id`)
                        );";
                  $addperm = "
                        INSERT INTO `permissions` 
                        (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES 
                        (1, 'user', 1, 1, 0, 0),
                        (2, 'admin', 1, 1, 1, 1),
                        (3, 'guest', 0, 0, 0, 0);
                        (4, 'mod', 1, 1, 0, 1);
                              ";
                              
                  $info = "CREATE TABLE `info` (
                        `id` INT( 11 ) NOT NULL ,
                        `version` VARCHAR( 50 ) NOT NULL ,
                        `sitename` VARCHAR( 100 ) NOT NULL ,
                        `siteurl` VARCHAR( 100 ) NOT NULL ,
                        `sitedesc` TEXT NOT NULL ,
                        `aemail` VARCHAR( 300 ) NOT NULL ,
                        `emailink` VARCHAR( 300 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $news = "CREATE TABLE `news` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `title` VARCHAR( 50 ) NOT NULL ,
                        `username` VARCHAR( 50 ) NOT NULL ,
                        `date` TIMESTAMP NOT NULL 
                        `body` TEXT NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $nav = "CREATE TABLE `nav` (
                        `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                        `linkname` VARCHAR( 50 ) NOT NULL ,
                        `url` VARCHAR( 100 ) NOT NULL ,
                        PRIMARY KEY ( `id` )
                        ) ENGINE = MYISAM";
                  
                  $downloads = "CREATE TABLE `downloads` (
                            `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
                            `name` VARCHAR( 100 ) NOT NULL ,
                            `url` VARCHAR( 100 ) NOT NULL ,
                            `date` VARCHAR( 20 ) NOT NULL ,
                            `username` VARCHAR( 50 ) NOT NULL ,
                            PRIMARY KEY ( `id` )
                            ) ENGINE = MYISAM";
                  
                  $games = "CREATE TABLE `games` (
                         `id` INT NOT NULL AUTO_INCREMENT ,
                         `name` VARCHAR( 20 ) NOT NULL ,
                         `source` VARCHAR( 100 ) NOT NULL ,
                         `gamedesc` TEXT NOT NULL ,
                         PRIMARY KEY ( `id` )
                         ) ENGINE = MYISAM ";
			  
			  mysql_query($users) or 'Couldn\'t create users table.';
			  mysql_query($permissons) or 'Couldn\'t create permissions table.';
			  mysql_query($addperm) or 'Couldn\'t insert data into permissions table.';
			  mysql_query($info) or 'Couldn\'t create info table.';
			  mysql_query($news) or 'Couldn\'t create news table.';
			  mysql_query($nav) or 'Couldn\'t create navigation table.';
			  mysql_query($downloads) or 'Couldn\'t create downloads table.';
			  mysql_query($games) or 'Couldn\'t create games table.';
                  
                  $mysqlfile = fopen('defs.php', 'w+');
                  $content = "
                  <?php
                  //Database Information \n
                  DEFINE ('DB_USER', '$dbuser'); \n
                  DEFINE ('DB_PASSWORD', '$dbpass'); \n
                  DEFINE ('DB_HOST', '$host'); \n
                  DEFINE ('DB_NAME', '$db'); \n
                  ?>";
			  
			  fwrite($mysqlfile, $content);
			  fclose($mysqlfile);
                 
                  echo 'Click the link below to continue';
			  echo ''.anchor ('index.php?step=step2'.'Continue ->').'';

}


?>

gevans · July 28, 2009

You need to be more clear on your output, what happens when you attempt to run the script, what doesnt happen. And just as a starting point;

mysql_query($users) or 'Couldn\'t create users table.';

should be

mysql_query($users) or die('Couldn\'t create users table.');

papillonstudios · July 28, 2009

I ahve a welcome page that says click here to begin, when submitting the form it goes back to that welcome page and doesn't create the tables in the database or write data the file called defs.php

gevans · July 28, 2009

Did you fix the problem I showed you? and the secure() function still isnt in the second script.

papillonstudios · July 28, 2009

the function is included in the functions page

[quote]<?php
include('functions.php');
?>[/quote]

and yes i did fix that problem

Sign In

INstall Script Problem

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Archived

Important Information