initdatabase.jsp

BBS系统

       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,16,50000,'天王','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,17,100000,'法老','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,18,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,19,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (0,20,99999999,'法老','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (1,0,0,'高级天王 [荣誉]','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (2,0,0,'终极天王 [荣誉]','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br>");
       insertok=connect.executeUpdate("insert into grade (usermode,grade,mpostmark,mname,mgraphic) values (3,0,0,'究级天王 [荣誉]','pips10.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="管理员信息表";
    //开始创建
    query="CREATE TABLE admin (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT, authorid INT(6) UNSIGNED NOT NULL,authorname varchar(30) not null,forum SMALLINT(4) UNSIGNED NOT NULL,db SMALLINT(4) UNSIGNED NOT NULL,usermode tinyint(2) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="基本配置数据表";
    //开始创建
    query="CREATE TABLE config (id TINYINT(1) UNSIGNED NOT NULL, emailsupport enum('0','1') not null,smtp VARCHAR(30) NOT NULL ,sendemail VARCHAR(30) NOT NULL ,getemail VARCHAR(30) NOT NULL ,boarddescription VARCHAR(100) NOT NULL ,boardname VARCHAR(30) NOT NULL ,boardurl VARCHAR(30) NOT NULL ,copyright VARCHAR(255) NOT NULL ,title VARCHAR(30) NOT NULL ,support VARCHAR(200) NOT NULL ,programmer varchar(50) not null,programemail varchar(30) not null,programqq varchar(20) not null,version VARCHAR(30) NOT NULL,versionnumber VARCHAR(20) NOT NULL ,homename VARCHAR(50) NOT NULL ,homeurl VARCHAR(80) NOT NULL ,uploaddir VARCHAR(200) NOT NULL ,uploadurl VARCHAR(120) NOT NULL ,announcement enum('1','0') not null,floodcontrol enum('1','0') not null,floodcontrollimit tinyint(3) unsigned not null,togb enum('0','1') not null,status enum('1','0') not null,maintainreason VARCHAR(255) NOT NULL ,register enum('1','0') not null,registerreason VARCHAR(255) NOT NULL ,timedifference tinyint(3) not null,supername VARCHAR(30) NOT NULL ,superpassword VARCHAR(30) NOT NULL ,emoticons enum('1','0') not null,avatars enum('1','0') not null,allowusemsg enum('1','0') not null,maxmsgno smallint(6) unsigned not null,newusernotify enum('0','1') not null,oneaccountperemail  enum('0','1') not null,adimage varchar(100) not null,adimagelink varchar(100) not null,adimagewidth smallint(4) unsigned not null,adimageheight smallint(4) unsigned not null,arrowonlinemax smallint(4) unsigned not null,oicqshow enum('0','1') not null,useemote enum('1','0') not null,sticky enum('1','0') not null,dispboardsm enum('1','0') not null,dispborn enum('1','0') not null,recordviewstat  enum('1','0') not null,showfastlogin varchar(20) default 'top' not null,maxuploadava tinyint(3) unsigned not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
       String bbstitle="LyBBS『凌云论坛』";
       String support="http://www.unix-now.com/lybbs";
       String programmer="星语凌 『teddy』";
       String programemail="[e-mail]";
       String programqq="14606667";
       String version="ver 1.2.beta-2";
       String versionnumber="20020612";
       //凌云论坛内部信息，未经许可，绝对禁止修改，因为不听劝告，自行修改而可能带来的安装失败、数据破坏、升级失败、甚至服务器瘫痪等一切后果，概与本人无关。
       //谨记：因为坚持修改而带来的一切后果自负！！！
       //请尊重我的版权，请尊重我的劳动成果！
       insertok=connect.executeUpdate("insert into config (id,title,support,programmer,programemail,programqq,version,versionnumber) values (1,'"+bbstitle+"','"+support+"','"+programmer+"','"+programemail+"','"+programqq+"','"+version+"','"+versionnumber+"')");
       if(insertok)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="系统公告表";
    //开始创建
    query="CREATE TABLE announcement (id INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,db smallint(4) unsigned not null ,author varchar(40) not null ,title varchar(150) NOT NULL ,content text not null,postat datetime not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建
    title="论坛小字报表";
    //开始创建
    query="CREATE TABLE xzb (id INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,db smallint(4) unsigned not null ,author varchar(40) not null ,title varchar(150) NOT NULL ,content text not null,postat datetime not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建


    title="样式配置数据表";
    //开始创建
    query="CREATE TABLE style (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(30) NOT NULL ,adminselected enum('0','1') not null,forum smallint(4) not null,db smallint(4) not null,adminglow varchar(8) NOT NULL ,adminnamecolor varchar(8) NOT NULL ,advpost enum('0','1') not null,allowattachment enum('0','1') not null,announcemove enum('0','1') not null,arrawpostfontsize enum('0','1') not null,arrawpostpic enum('0','1') not null,arrawsignfontsize enum('0','1') not null,arrawsignpic enum('0','1') not null,arrowavaupload enum('0','1') not null,arrowupload enum('0','1') not null,arrowuserdel enum('0','1') not null,autofreshtime smallint(5) unsigned not null,banfreshtime tinyint(2) unsigned not null,banglow varchar(8) not null,boardlogo varchar(30) not null,catbackpic varchar(20) not null,catback varchar(8) not null,catfontcolor varchar(8) not null,cinoption tinyint(3) unsigned not null,defaultheight tinyint(3) unsigned not null,defaultsmileheight tinyint(3) unsigned not null,defaultsmilewidth tinyint(3) unsigned not null,defaultwidth tinyint(3) unsigned not null,dispquickreply enum('0','1') not null,dispview enum('0','1') not null,editjhmpself enum('0','1') not null,editusertitleself enum('0','1') not null,font varchar(10) not null,fontcolormisc varchar(8) not null,fonthighlight varchar(8) not null,forumcolorone varchar(8) not null,forumcolortwo varchar(8) not null,forumfontcolor varchar(8) not null,hottopicmark tinyint(2) unsigned not null,hotpollmark tinyint(3) unsigned not null,infosopen tinyint(2) unsigned not null,imageviewnumber tinyint(2) unsigned not null,lastpostfontcolor varchar(8) not null,lbbody varchar(150) not null,linesperpage tinyint(2) unsigned not null,logdelmax tinyint(2) unsigned not null,look enum('0','1') not null,maxdeloneday tinyint(3) unsigned not null,maxinslegth tinyint(3) unsigned not null,maxinsline tinyint(2) unsigned not null,maxlistpost tinyint(2) unsigned not null,maxpollitem tinyint(3) unsigned not null,maxposticonheight tinyint(3) unsigned not null,maxposticonwidth tinyint(3) unsigned not null,maxpostreport tinyint(2) unsigned not null,maxsavepost tinyint(2) unsigned not null,maxsignlegth smallint(3) unsigned not null,maxsignline tinyint(2) unsigned not null,maxsmail tinyint(2) unsigned not null,maxthreads tinyint(2) unsigned not null,maxtopics tinyint(2) unsigned not null,maxtoptopic tinyint(2) unsigned not null,maxupload smallint(5) not null,membergone tinyint(2) unsigned not null,memglow varchar(8) not null,menubackground varchar(8) not null,menubackpic varchar(20) not null,menufontcolor varchar(8) not null,miscbackone varchar(8) not null,miscbacktwo varchar(8) not null,movetopicname enum('0','1') not null,newmarktime tinyint(3) unsigned not null,newmsgpop enum('0','1') not null,newrefers tinyint(2) unsigned not null,noself enum('0','1') not null,onlineview enum('0','1') not null,otherbackpic varchar(20) not null,otherbackpic1 varchar(20) not null,pagechange enum('0','1') not null,paraspace tinyint(3) unsigned not null,postcolorone varchar(8) not null,postcolortwo varchar(8) not null,posternamecolor varchar(8) not null,posternamefont varchar(10) not null,postfontcolorone varchar(8) not null,postfontcolortwo varchar(8) not null,pvtip enum('0','1') not null,quotemode enum('0','1') not null,refreshforum enum('0','1') not null,regaccess enum('0','1') not null,searchopen enum('0','1') not null,sendwelcomemessage enum('0','1') not null,showskin enum('0','1') not null,smocanseeip enum('0','1') not null,smoglow varchar(8) not null,smonamecolor varchar(8) not null,sortalltopic enum('0','1') not null,sortposticonshow enum('0','1') not null,statsopen enum('0','1') not null,tablebordercolor varchar(8) not null,tablewidth varchar(8) not null,teamglow varchar(8) not null,teamnamecolor varchar(8) not null,timetoshow tinyint(3) unsigned not null,titleback varchar(8) not null,titleborder varchar(8) not null,titlecolor varchar(8) not null,titlefont varchar(8) not null,titlefontcolor varchar(8) not null,wordspace tinyint(3) not null,xzbopen enum('0','1') not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok_style=connect.executeUpdate(query); 
    if(createok_style) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
%>
<%@ include file="initstyle.jsp"%>
<%
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="短消息中心表";
    //开始创建
    query="CREATE TABLE webqq (id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT, fromname varchar(30) NOT NULL ,toname varchar(30) NOT NULL ,title varchar(200) not null, message text NOT NULL ,sendat datetime NOT NULL ,operation varchar(4) NOT NULL ,viewed enum('0','1') NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="短消息欢迎信息表";
    //开始创建
    query="CREATE TABLE regmsg (id TINYINT(2) UNSIGNED NOT NULL, content text NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
       String content="感谢您的注册，欢迎您的到来，希望这里能给您带来快乐！多多发言吧！<br><br><br>本站全体管理人员向您问好";
       insertok=connect.executeUpdate("insert into regmsg (id,content) values (1,'"+content+"')");
       if(insertok)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="用户好友表";
    //开始创建
    query="CREATE TABLE friend (id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT ,authorid int(6) unsigned not null ,friendname varchar(30) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="禁止ip列表表";
    //开始创建
    query="CREATE TABLE banip (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, banip varchar(20) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);