954,585 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article
2 Years Ago
0

Install file is not creating all the tables

Hi,

My install file is not creating all the tables- it's only creating the " abuse_report" and not any of the others. Can someone give it a look see? Or can someone tell me how to put the tables int a sql file that I can just upload instead?

<?
if($install_step_1)
{
	$fp = fopen("connect.txt", "r");
    $content = '';
    while(!feof($fp)) {
        $content .= fread($fp, 1024);
    }
    fclose($fp);
    $content = str_replace("{db_host}", $db_host, $content);
	$content = str_replace("{db_user}", $db_user, $content);
	$content = str_replace("{db_pass}", $db_pass, $content);
	$content = str_replace("{db_name}", $db_name, $content);
	$fp = fopen("../includes/.connect.php", "w+");
	fputs ($fp, $content);
	fclose($fp);
	include ('../includes/.connect.php');
	$test_create = mysql_query("CREATE TABLE test (id int(255) primary key NOT NULL,test char(255))");
	if ($test_create)
	{
		$test_insert = mysql_query("INSERT INTO test values ('','test')");
		if ($test_insert)
		{
			$delete_test = mysql_query("DELETE FROM test WHERE test = 'test'");
			if ($delete_test)
			{
				$delete_test_table = mysql_query("DROP TABLE test");
				if ($delete_test_table)
				{
					$message = "good";
				}
				else
				{
					$message = '<div align=center><font color=red>Test connection to the database has failed!</font></div>Please ensure database exists and database info is correct<a href="javascript:history.back(1)">Go back</a></font></div>';					
				}
			}
			else
			{
				$message = '<div align=center><font color=red>Test connection to the database has failed!</font></div>Please ensure database exists and database info is correct<a href="javascript:history.back(1)">Go back</a></font></div>';				
			}
		}
		else
		{
			$message = '<div align=center><font color=red>Test connection to the database has failed!</font></div>Please ensure database exists and database info is correct<a href="javascript:history.back(1)">Go back</a></font></div>';			
		}
	}
	else
	{
		$message = '<div align=center><font color=red>Test connection to the database has failed!</font></div>Please ensure database exists and database info is correct<a href="javascript:history.back(1)">Go back</a></font></div>';		
	}
	if ($message == "good")
	{
		$action = "step_2";
	}
	else
	{
		echo $message;
		exit;
	}
	$www_location = 'http://' . getenv('HTTP_HOST') . getenv('SCRIPT_NAME');
	$www_location = substr($www_location, 0, strpos($www_location, 'install'));
}
if ($install_step_2)
{
	include ('../includes/.connect.php');
	$create_banner = mysql_query("CREATE TABLE `banners` (
  `id` int(255) NOT NULL auto_increment,
  `user_id` varchar(255) NOT NULL default '',
  `banner_url` varchar(255) NOT NULL default '',
  `forward_url` varchar(255) NOT NULL default '',
  `status` varchar(255) NOT NULL default '',
  `credits` decimal(250,1) NOT NULL default '0.0',
  `views` int(255) NOT NULL default '0',
  `clicks` int(255) NOT NULL default '0',
  `date_added` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
	$create_config = mysql_query("CREATE TABLE `config` (
  `id` int(255) NOT NULL default '0',
  `site_name` varchar(255) NOT NULL default '',
  `site_url` varchar(255) NOT NULL default '',
  `admin_email` varchar(255) NOT NULL default '',
  `send_from_email` varchar(255) NOT NULL default '',
  `credit_earn` decimal(250,1) NOT NULL default '0.0',
  `credit_cost` decimal(250,1) NOT NULL default '0.0',
  `timer` int(255) NOT NULL default '0',
  `start_credits` varchar(255) NOT NULL default '',
  `last_banner` int(255) NOT NULL default '0',
  `h_limit` int(255) NOT NULL default '0',
  `w_limit` int(255) NOT NULL default '0',
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
	$create_sessions = mysql_query("CREATE TABLE `sessions` (
  `id` int(255) NOT NULL auto_increment,
  `session_id` varchar(255) NOT NULL default '',
  `user_id` varchar(255) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `credits_earned` decimal(250,1) NOT NULL default '0.0',
  `cheat` varchar(255) NOT NULL default '',
  `next_view` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
	$create_abuse = mysql_query("CREATE TABLE `abuse_report` (
  `id` int(255) NOT NULL auto_increment,
  `user_id` varchar(255) NOT NULL default '',
  `url_id` varchar(255) NOT NULL default '',
  `url_reported` varchar(255) NOT NULL default '',
  `reason` text NOT NULL,
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
	$create_urls = mysql_query("CREATE TABLE `urls` (
  `id` int(255) NOT NULL auto_increment,
  `user_id` varchar(255) NOT NULL default '',
  `display` varchar(255) NOT NULL default '',
  `status` varchar(255) NOT NULL default '',
  `credits` decimal(250,1) NOT NULL default '0.0',
  `views` int(255) NOT NULL default '0',
  `date_added` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
	$create_users = mysql_query("CREATE TABLE `users` (
  `id` int(255) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `contact` varchar(255) NOT NULL default '',
  `status` varchar(255) NOT NULL default '',
  `confirmkey` varchar(255) NOT NULL default '',
  `credits` decimal(250,1) NOT NULL default '0.0',
  `last_banner` int(255) NOT NULL default '0',
  `last_url` int(255) NOT NULL default '0',
  `date_joined` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1");
	$add_config = mysql_query("INSERT INTO `config` VALUES (1, 'Test Auto Surf Exchange', '$site_url', 'webmaster@yourdomain.com', 'noreply@yourdomain.com', 0.6, 1.0, 10, '1000', 1, 60, 468, 'autosurf,traffic,excahnge', 'My autosurf traffic exchange')");
	$action = "step_3";
}
if (!is_writable("../includes"))
{
	echo "<div align=center>includes directory is not writable please CHMOD to 777!</div>";
}
else
{
	if ($action == "")
	{
		?>
		<form method="post">
		<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2" bgcolor="#FF0000">Database Info </td>
    </tr>
  <tr>
    <td>Database host </td>
    <td><input name="db_host" type="text" id="db_host"></td>
    </tr>
  <tr>
    <td>Database username </td>
    <td><input name="db_user" type="text" id="db_user"></td>
    </tr>
  <tr>
    <td>Database password </td>
    <td><input name="db_pass" type="text" id="db_pass"></td>
    </tr>
  <tr>
    <td>Database name </td>
    <td><input name="db_name" type="text" id="db_name"></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><input name="install_step_1" type="submit" id="install_step_1" value="Next"></td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>
<?
}
if ($action == "step_2")
{
?>
<form method="post">
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="2">Site Info</td>
  </tr>
  <tr>
    <td>Site URL </td>
    <td><input name="site_url" type="text" id="site_url" value="<? echo $www_location ?>"></td>
  </tr>
  <tr>
    <td><input name="install_step_2" type="submit" id="install_step_2" value="next"></td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>
<?
}
if ($action == "step_3")
{
	?>
	<div align="center">Install Complete<a href="../admin">Click here</a> to go to the admin interface</div>
	<?
}
}
?>

Thank you,
Joseph.

streetrodfanati
Light Poster
30 posts since Oct 2008
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
 
© 2012 DaniWeb® LLC
Home | About Us | Contact Us | Terms of Service | Advertising Opportunities
RSS Feed RSS Feed