当前位置：编程学习网 >>祝福短信 > 同学 > > phpstudy|php 文件安装三

phpstudy|php 文件安装三

【www.gdgbn.com--同学】

/////////////////////////////////////////////////////////////////////////////
// 迷你同学录 (http://www.piscdong.com/?m=mini_class)
//
// (c)PiscDong studio (http://www.piscdong.com/)
//
// 程序完全免费，请保留这段代码。
// 请勿出售本程序或其修改版，请勿利用本程序或其修改版进行任何商业活动。
/////////////////////////////////////////////////////////////////////////////

require_once("inc.php");
if(!file_exists($l_file)){
echo getstop(2);
if($_SERVER["REQUEST_METHOD"]=="POST" && $_POST["title"]!="" && $_POST["username"]!="" && $_POST["name"]!="" && $_POST["password"]!=""){
  require_once($c_file);
  echo "安装MySQL数据库";
  $query="create table {$dbprefix}main (
  id int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL,
  school varchar(255) default NULL,
  classname varchar(255) default NULL,
  open int(5) NOT NULL default "0",
  openreg int(5) NOT NULL default "0",
  gid varchar(255) default "1|2|3",
  content text,
  email int(5) NOT NULL default "0",
  pagesize int(10) NOT NULL default "20",
  upload int(5) NOT NULL default "0",
  maxsize int(10) NOT NULL default "0",
  filetype varchar(255) default "jpg",
  thum int(5) NOT NULL default "0",
  slink int(5) NOT NULL default "0",
  veri int(5) NOT NULL default "0",
  icp varchar(255) default NULL,
  skin int(10) NOT NULL default "0",
  timefix varchar(255) NOT NULL default "0",
  ip varchar(255) default NULL,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."main：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}member (
  id int(10) NOT NULL auto_increment,
  username varchar(255) NOT NULL,
  password varchar(255) NOT NULL,
  name varchar(255) NOT NULL,
  status int(5) NOT NULL default "0",
  power int(5) NOT NULL default "0",
  regdate int(15) NOT NULL default "0",
  visit int(10) NOT NULL default "0",
  visitdate int(15) NOT NULL default "0",
  question varchar(255) default NULL,
  answer varchar(255) default NULL,
  email varchar(255) default NULL,
  gender int(5) NOT NULL default "0",
  bir_y int(4) NOT NULL default "0",
  bir_m int(2) NOT NULL default "0",
  bir_d int(2) NOT NULL default "0",
  address varchar(255) default NULL,
  location varchar(255) default NULL,
  url varchar(255) default NULL,
  work varchar(255) default NULL,
  phone varchar(255) default NULL,
  tel varchar(255) default NULL,
  qq varchar(255) default NULL,
  msn varchar(255) default NULL,
  gtalk varchar(255) default NULL,
  gid int(5) NOT NULL default "0",
  rela varchar(255) default NULL,
  photo varchar(255) default NULL,
  pupload int(5) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."member：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}online (
  aid int(10) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  online int(5) NOT NULL default "1",
  ip char(15) default NULL,
  UNIQUE KEY aid (aid)
  ) ".(chksqlv()?"ENGINE=MEMORY DEFAULT CHARSET=gb2312":"type=HEAP");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."online：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}topic (
  id int(10) NOT NULL auto_increment,
  content text NOT NULL,
  aid int(10) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  sticky int(5) NOT NULL default "0",
  sid int(10) NOT NULL default "0",
  tid int(5) NOT NULL default "0",
  mid int(5) NOT NULL default "0",
  disp int(5) NOT NULL default "0",
  `lock` int(5) NOT NULL default "0",
  rid int(10) NOT NULL default "0",
  lasttime int(15) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."topic：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}vote (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  tid int(10) NOT NULL default "0",
  vid int(10) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."vote：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}photo (
  id int(10) NOT NULL auto_increment,
  url text NOT NULL,
  title varchar(255) default NULL,
  aid int(10) NOT NULL default "0",
  cid int(10) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  upload int(5) NOT NULL default "0",
  disp int(5) NOT NULL default "0",
  vid int(5) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."photo：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}pcomment (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  pid int(10) NOT NULL default "0",
  disp int(5) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  content text NOT NULL,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."pcomment：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}camp (
  id int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL,
  aid int(10) NOT NULL default "0",
  sticky int(5) NOT NULL default "0",
  closed int(5) NOT NULL default "0",
  disp int(5) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  cdate varchar(255) default NULL,
  cloc varchar(255) default NULL,
  cpay varchar(255) default NULL,
  content text,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."camp：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}ccomment (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  cid int(10) NOT NULL default "0",
  sid int(10) NOT NULL default "0",
  disp int(5) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  content text,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."ccomment：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}cuser (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  cid int(10) NOT NULL default "0",
  tid int(10) NOT NULL default "1",
  datetime int(15) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."cuser：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}message (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  tid int(10) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  readed int(5) NOT NULL default "0",
  content text NOT NULL,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."message：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}adminop (
  id int(10) NOT NULL auto_increment,
  aid int(10) NOT NULL default "0",
  sid int(10) NOT NULL default "0",
  tid int(5) NOT NULL default "0",
  datetime int(15) NOT NULL default "0",
  content text NOT NULL,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."adminop：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}link (
  id int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL,
  url varchar(255) NOT NULL,
  thread int(10) NOT NULL default "0",
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."link：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query="create table {$dbprefix}skin (
  id int(10) NOT NULL auto_increment,
  path varchar(255) NOT NULL,
  title varchar(255) default NULL,
  sfile varchar(255) NOT NULL,
  UNIQUE KEY id (id)
  ) ".(chksqlv()?"ENGINE=MyISAM DEFAULT CHARSET=gb2312":"type=MyISAM");
  $result=mysql_query($query);
  echo "建立数据表 ".$dbprefix."skin：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $title=htmlspecialchars(trim($_POST["title"]),ENT_QUOTES);
  $query=sprintf("insert into %s (title) values (%s)", $dbprefix."main",
   SQLString($title, "text"));
  $result=mysql_query($query);
  echo "写入新数据 ".$dbprefix."main：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $username=trim($_POST["username"]);
  $password=enc_p(trim($_POST["password"]));
  $name=htmlspecialchars(trim($_POST["name"]),ENT_QUOTES);
  $query=sprintf("insert into %s (username, password, name, power, regdate) values (%s, %s, %s, 9, %s)", $dbprefix."member",
   SQLString($username, "text"),
   SQLString($password, "text"),
   SQLString($name, "text"),
   time());
  $result=mysql_query($query);
  echo "写入新数据 ".$dbprefix."member：成功":"f00;">失败")."";
  unset($query);
  unset($result);

  $query=sprintf("insert into %s (path, title, sfile) values (%s, %s, %s)", $dbprefix."skin",
   SQLString("blue", "text"),
   SQLString("蓝色梦想", "text"),
   SQLString("styles.css", "text"));
  $result=mysql_query($query);
  echo "写入新数据 ".$dbprefix."skin：成功":"f00;">失败")."";
  unset($query);
  unset($result);
  echo "";
  writeText($l_file,time());
}else{
?>
第2步：配置信息

}
echo getsfoot();
}else{
header("Location:../");
}
?>

本文来源：http://www.gdgbn.com/zhufuduanxin/19640/

上一篇：丁磊网易|丁磊的1995年：我想当一个小老板

下一篇：【javascript学习指南】Java 和 C/C++ 中的char 类型长度学习笔记

phpstudy|php 文件安装三

相关推荐

网友关注

热门标签

最新同学

同学热门文章