<?php
require_once("config.php"); 
$dbcheck = mysql_connect("$dbhost", "$dbuname", "$dbpass"); 
if (!$dbcheck) { 
	die("
Connection Test Script was unable to connect to MySQL sever!
One or more of these variables are wrong in your config.php: <font color=purple>$dbhost, $dbuname, $dbpass</font>"); 
}else{ 
	echo "<font color=red>If everything looks good, but you still have problems, get the ";
	echo "<a href=\"http://nukecops.com/downloads-cat-7.htm\">analyzer from NukeCops</a></font>

";
	echo "Connection Test Script connected to your MySQL sever successfully!
"; 
	if (mysql_select_db($dbname)) { 
		echo "
Connection to your database \"<font color=purple>$dbname</font>\" was also successful.
"; 
		$result = mysql_list_tables($dbname); 
    	if (!$result) {
        	print "DB Error, could not list tables\n";
        	print 'MySQL Error: ' . mysql_error();
        	die();
    	}  
    	$i=0;
    	$stufftoprint = "";  
    	while ($row = mysql_fetch_row($result)) {
    		$tablename = $row[0];
    		if($tablename == "".$prefix."_authors") {
    			$result4 = mysql_query("select aid from $tablename"); 
    			while(list($admin_name) = mysql_fetch_row($result4)) {
    				$admin_names .= "$admin_name, &";
    			}
    		}
    		$result3 = mysql_query("select * from $tablename"); 
			$numFields = mysql_num_fields($result3);
			$fields = "fields";
			if($numFields == 1) {$fields = "field";}
        	$stufftoprint .= "Table: <font color=purple>$tablename</font> &($numFields $fields)\n
";
       		$i++;
    	}
    	if($dbtype != "MySQL" AND eregi("mysql",$dbtype)) {
    		echo "
<font color=red>But, you need to set </font><font color=purple> \$dbtype = \"MySQL\"; </font>";
    		echo "<font color=red> && in your config.php!!!!!!!!</font>
";
    	}
    	echo "
There are <font color=purple>$i tables</font> in your \"<font color=purple>$dbname</font>\" database
";
    	echo "(by default, there are 89 fields in phpnuke 6.5 and 76 fields in phpnuke 6.0)
";
    	if($i<66) {
    		echo "
<font color=red>You don't seem to have all the tables installed.
Get the ";
    		echo "<a href=\"http://www.nukeresources.com/modules.php?name=Downloads&d_op=viewdownload&cid=79\">Web Installer</a> for your version of phpnuke</font>
";
    	}
    	echo "
These are the admin names (aid) in your nuke_authors table: &<font color=purple>$admin_names</font>
";
    	echo "
Now check this list of tables with your nuke.sql file:

$stufftoprint";
	}else { 
		if(mysql_query("CREATE DATABASE $dbname")) {
			echo "
Your database \"$dbname\" did not exist, but this script just created it sucessfully
";
			echo "Now, you need to get the appropriate <a href=\"http://www.nukeresources.com/modules.php?name=Downloads&d_op=viewdownload&cid=79\">";
			echo "Web Installer from nukeresources.com</a>";
			die();
		}
		echo "
However, the \"$dbname\" database does not exist. If that is not the correct name, then put in the correct ";
		echo "name for
<font color=purple>\$dbname = \"$dbname\";</font>&& (in your config.php)
If you have not created the database yet, then ";
		echo "create it. If you are not the server, then ask your web host to create it for you.
";
		echo "
Then, get the appropriate <a href=\"http://www.nukeresources.com/modules.php?name=Downloads&d_op=viewdownload&cid=79\">";
		echo "Web Installer from nukeresources.com</a>";
	} 
}
?>