instal_en.php

软件类别： PHP源码 / 文章管理 软件语言： 简体中文 授权方式： 商业版 文件大小： 308K

  foreach ($query AS $table_name => $query_text) {
    query($query_text,0);
    if (geterrno() == 0) {
      echo "  <tr>\n    <td>Deleting Table: $table_name</td>\n  </tr>\n";
    } else {
      echo "  <tr>\n    <td>Error Deleting Table: $table_name<br>Error Number: ".geterrno()."<br>Error Description: ".geterrordesc()."</td>\n  </tr>\n";
      $error = 1;
    }
  }

  if ($error) {
      echo "  <tr>\n    <td>There has been an error deleting one or more of the tables.  Please examine this error and only continue if you are sure it will not effect the install process.  Click <a href=\"install.php?step=4\">here</a> to continue</td>\n  </tr>\n";
  } else {
      echo "  <tr>\n    <td>All tables are deleted, please click <a href=\"install.php?step=4\">here</a> to continue</tr>\n";
  }
}

if ($step > 3) {
  include("admin/config.php");
  include("includes/db_$dbservertype.php");
  $db = vn_connect();
}

if ($step == 4) {

  $query[news_activation] = "CREATE TABLE news_activation (
    id INT(10) NOT NULL auto_increment,
    userid INT(10) DEFAULT '0' NOT NULL,
    date INT(10) DEFAULT '' NOT NULL,
    activateid INT(10) UNSIGNED DEFAULT '0' NOT NULL,
    type TINYINT(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_adminlog] = "CREATE TABLE news_adminlog (
    id INT(10) UNSIGNED NOT NULL auto_increment,
    staffid SMALLINT(5) DEFAULT '0' NOT NULL,
    time INT(10) DEFAULT '' NOT NULL,
    script VARCHAR(20) DEFAULT '' NOT NULL,
    action VARCHAR(20) DEFAULT '' NOT NULL,
    extrainfo VARCHAR(200) DEFAULT '' NOT NULL,
    ipaddress VARCHAR(15) DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_announcement] = "CREATE TABLE news_announcement (
    catid SMALLINT(5) DEFAULT '0' NOT NULL,
    content MEDIUMTEXT DEFAULT '' NOT NULL,
    image VARCHAR(255) DEFAULT '' NOT NULL,
    link VARCHAR(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (catid))";

  $query[news_article] = "CREATE TABLE news_article (
    id SMALLINT(5) NOT NULL auto_increment,
    date INT(10) DEFAULT '' NOT NULL,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    staffid SMALLINT(5) DEFAULT '0' NOT NULL,
    authorname VARCHAR(255) DEFAULT '' NOT NULL,
    numpages SMALLINT(2) DEFAULT '' NOT NULL,
    views INT(10) DEFAULT '' NOT NULL,
    rating FLOAT DEFAULT '' NOT NULL,
    page1 MEDIUMTEXT DEFAULT '' NOT NULL,
    page2 MEDIUMTEXT DEFAULT '' NOT NULL,
    page3 MEDIUMTEXT DEFAULT '' NOT NULL,
    page4 MEDIUMTEXT DEFAULT '' NOT NULL,
    page5 MEDIUMTEXT DEFAULT '' NOT NULL,
    page6 MEDIUMTEXT DEFAULT '' NOT NULL,
    page7 MEDIUMTEXT DEFAULT '' NOT NULL,
    page8 MEDIUMTEXT DEFAULT '' NOT NULL,
    page9 MEDIUMTEXT DEFAULT '' NOT NULL,
    page10 MEDIUMTEXT DEFAULT '' NOT NULL,
    catid SMALLINT(5) DEFAULT '0' NOT NULL,
    parsenewline TINYINT(1) DEFAULT '1' NOT NULL,
    display SMALLINT(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_articlecat] = "CREATE TABLE news_articlecat (
    id SMALLINT(5) NOT NULL auto_increment,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    description MEDIUMTEXT DEFAULT '' NOT NULL,
    parentid SMALLINT(5) DEFAULT '0' NOT NULL,
    children SMALLINT(5) DEFAULT '0' NOT NULL,
    numarticles SMALLINT(5) DEFAULT '0' NOT NULL,
    displayorder SMALLINT(4) DEFAULT '0' NOT NULL,
    display SMALLINT(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_articlevote] = "CREATE TABLE news_articlevote (
    id INT(10) UNSIGNED NOT NULL auto_increment,
    articleid INT(10) DEFAULT '0' NOT NULL,
    userid INT(10) DEFAULT '0' NOT NULL,
    votedate INT(10) DEFAULT '' NOT NULL,
    voteoption INT(10) DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_category] = "CREATE TABLE news_category (
    id SMALLINT(5) NOT NULL auto_increment,
    parentid SMALLINT(5) DEFAULT '' NOT NULL,
    children SMALLINT(5) DEFAULT '' NOT NULL,
    name VARCHAR(255) NOT NULL,
    description MEDIUMTEXT NOT NULL,
    image VARCHAR(255) NOT NULL,
    posts SMALLINT(5) DEFAULT '' NOT NULL,
    allowcomments TINYINT(1) DEFAULT '' NOT NULL,
    allowview TINYINT(1) DEFAULT '' NOT NULL,
    showsitestats TINYINT(1) DEFAULT '' NOT NULL,
    showforumstats TINYINT(1) DEFAULT '' NOT NULL,
    showforumoptions TINYINT(1) DEFAULT '' NOT NULL,
    showpoll TINYINT(1) DEFAULT '' NOT NULL,
    showannouncement TINYINT(1) DEFAULT '' NOT NULL,
    showsubcats TINYINT(1) DEFAULT '' NOT NULL,
    defaulttheme SMALLINT(5) DEFAULT '' NOT NULL,
    forcetheme TINYINT(1) DEFAULT '' NOT NULL,
    recentpost VARCHAR(255) NOT NULL,
    display TINYINT(1) DEFAULT '' NOT NULL,
    displayorder SMALLINT(5) DEFAULT '' NOT NULL,
    displaymain TINYINT(1) DEFAULT '' NOT NULL,
    pollid SMALLINT(5) NOT NULL,
    PRIMARY KEY (id),
    KEY displayorder (displayorder))";

  $query[news_comment] = "CREATE TABLE news_comment (
    id INT(10) UNSIGNED NOT NULL auto_increment,
    newsid SMALLINT(5) DEFAULT '' NOT NULL,
    username VARCHAR(255) NOT NULL,
    userid SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    useremail VARCHAR(255),
    ip VARCHAR(15),
    comment MEDIUMTEXT NOT NULL,
    showsig TINYINT(1) DEFAULT '' NOT NULL,
    time INT(10) DEFAULT '' NOT NULL,
    parentid INT(10) DEFAULT '' NOT NULL,
    editlock TINYINT(1) DEFAULT '' NOT NULL,
    edituserid SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    editdate INT(10) DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY userid (userid),
    KEY newsid (newsid,time))";

  $query[news_hit] = "CREATE TABLE news_hit (
    time INT(10) DEFAULT '' NOT NULL,
    ip VARCHAR(20) NOT NULL,
    browser VARCHAR(15) NOT NULL,
    os VARCHAR(15) NOT NULL,
    location VARCHAR(255) NOT NULL,
    PRIMARY KEY (ip)
    ) TYPE=HEAP";

  $query[news_module] = "CREATE TABLE news_module (
    id MEDIUMINT(5) NOT NULL auto_increment,
    name VARCHAR(255) NOT NULL,
    text VARCHAR(255) NOT NULL,
    description MEDIUMTEXT,
    version VARCHAR(255),
    templates MEDIUMTEXT,
    table_list MEDIUMTEXT,
    display TINYINT(1) DEFAULT '' NOT NULL,
    enable TINYINT(1) DEFAULT '' NOT NULL,
    options MEDIUMTEXT,
    PRIMARY KEY (id))";

  $query[news_news] = "CREATE TABLE news_news (
    id INT(10) UNSIGNED NOT NULL auto_increment,
    catid SMALLINT(5) DEFAULT '' NOT NULL,
    title VARCHAR(255) NOT NULL,
    mainnews MEDIUMTEXT NOT NULL,
    extendednews MEDIUMTEXT NOT NULL,
    logoimage VARCHAR(50),
    logoimageborder SMALLINT(1) DEFAULT '' NOT NULL,
    commentcount SMALLINT(5) DEFAULT '' NOT NULL,
    lastcommentuser VARCHAR(255),
    time INT(11) DEFAULT '' NOT NULL,
    staffid SMALLINT(5) DEFAULT '' NOT NULL,
    stickypost TINYINT(1) DEFAULT '' NOT NULL,
    parsenewline TINYINT(1) DEFAULT '' NOT NULL,
    program SMALLINT(1) DEFAULT '' NOT NULL,
    display SMALLINT(1) DEFAULT '' NOT NULL,
    allowcomments SMALLINT(1) DEFAULT '' NOT NULL,
    editstaffid SMALLINT(5) DEFAULT '' NOT NULL,
    editdate INT(10) DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY catid (catid),
    KEY program (program),
    KEY staffid (staffid))";

  $query[news_option] = "CREATE TABLE news_option (
    id SMALLINT(5) NOT NULL auto_increment,
    optiongroup VARCHAR(100),
    varname VARCHAR(100) NOT NULL,
    value TEXT NOT NULL,
    title VARCHAR(100),
    description MEDIUMTEXT,
    code MEDIUMTEXT,
    PRIMARY KEY (id))";

  $query[news_page] = "CREATE TABLE news_page (
    id SMALLINT(5) NOT NULL auto_increment,