install.php

发布管理系统(sps)v2.0

<?php
function check_sql_error()
{
	if (mysql_errno()) {
		die("<SCRIPT LANGUAGE=JavaScript>alert(\"数据库参数不正确!\\n".mysql_errno().":".mysql_error()."\");history.go(-1);</SCRIPT>");
	}
}

$table_db = $db_plus."db";
$table_content = $db_plus."content";
$table_type = $db_plus."type";

$link = @mysql_connect($db_url,$db_user,$db_pass);	
check_sql_error();
@mysql_select_db($db_name,$link);
check_sql_error();

if ($del_table == "del_table") {
	#Caution: the following three lines are dangrous !!
	@mysql_query("DROP TABLE $table_db;");
	@mysql_query("DROP TABLE $table_content;");
	@mysql_query("DROP TABLE $table_type;");
}

mysql_query("CREATE TABLE $table_db (  id int(11) NOT NULL auto_increment,  prog_name varchar(100) NOT NULL default '',  short_name varchar(100) NOT NULL default '',  introduction text,  author varchar(50) NOT NULL default '',  type varchar(10) NOT NULL default '',  filename varchar(100) NOT NULL default '',  last_update datetime NOT NULL default '0000-00-0000:00:00',  PRIMARY KEY  (id)) TYPE=MyISAM;");
check_sql_error();
mysql_query("CREATE TABLE $table_content (  cid tinyint(4) NOT NULL auto_increment,  id tinyint(4) NOT NULL default '0', name varchar(50) NOT NULL, content mediumtext NOT NULL, length tinyint(10) NOT NULL default '0',  PRIMARY KEY  (cid)) TYPE=MyISAM;");
check_sql_error();
mysql_query("CREATE TABLE $table_type (  tid tinyint(4) NOT NULL auto_increment,   type varchar(100) NOT NULL,  PRIMARY KEY  (tid)) TYPE=MyISAM;");
check_sql_error();
mysql_close($link);

$fp=fopen("global.inc.php","w");
$str = "<?php\n";
$str .= "\$url_base = \"$url_base\";\n";
$str .= "\$up_filepath = \"$up_filepath\";\n";
$str .= "\$tmp_dir = \"$tmp_dir\";\n";
$str .= "\$top_str = \"$top_str\";\n";
$str .= "\$table_db = \"$table_db\";\n";
$str .= "\$table_content = \"$table_content\";\n";
$str .= "\$table_type = \"$table_type\";\n";
$str .="?>\n";
fputs($fp,$str);
fclose($fp);

$fp=fopen("admin.inc.php","w");
$str = "<?php\n";
$str .= "\$admin_user = \"$admin_user\";\n";
$str .= "\$admin_pass = \"$admin_pass\";\n\n";
$str .= "if (!isset(\$PHP_AUTH_USER) || \$PHP_AUTH_USER!=\$admin_user || !isset(\$PHP_AUTH_PW) || \$PHP_AUTH_PW!=\$admin_pass) {\n";
$str .= "	Header(\"WWW-Authenticate: Basic realm=\\\"管理员登陆\\\"\");\n";
$str .= "	Header(\"HTTP/1.0 401 Unauthorized\");\n";
$str .= "	die(\"登录失败!\");\n";
$str .= "}\n";
$str .="?>\n";
fputs($fp,$str);
fclose($fp);

$fp=fopen("database.inc.php","w");
$str = "<?php\n";
$str .= "\$db_name = \"$db_name\";\n";
$str .= "\$db_user = \"$db_user\";\n";
$str .= "\$db_pass = \"$db_pass\";\n";
$str .= "\$db_url = \"$db_url\";\n\n";
$str .= "mysql_connect(\$db_url,\$db_user,\$db_pass);\n";
$str .= "mysql_select_db(\$db_name);\n";
$str .="?>\n";
fputs($fp,$str);
fclose($fp);

unlink("install.htm");
unlink("install.php");
die("<meta http-equiv=\"Refresh\" content=\"2;url=index.php\"><center><H1>安装成功!</H1></center>");
?>