wfschannel.sql

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Mar 18, 2004 at 05:10 AM
# Server version: 3.23.56
# PHP Version: 4.3.4
# 
# Database : `xoops2`
# 

# --------------------------------------------------------

#
# Table structure for table `wfschannel`
#

CREATE TABLE wfschannel (
  CID tinyint(4) NOT NULL auto_increment,
  pagetitle varchar(255) NOT NULL default '0',
  pageheadline varchar(255) NOT NULL default '0',
  page text NOT NULL,
  weight int(11) NOT NULL default '1',
  html int(11) NOT NULL default '0',
  smiley int(11) NOT NULL default '1',
  xcodes int(11) NOT NULL default '1',
  breaks int(10) NOT NULL default '1',
  defaultpage int(10) NOT NULL default '0',
  indeximage varchar(255) default 'blank.png',
  htmlfile varchar(255) default NULL,
  mainpage int(11) NOT NULL default '0',
  submenu int(11) NOT NULL default '0',
  created int(10) unsigned NOT NULL default '0',
  comments tinyint(11) NOT NULL default '0',
  allowcomments tinyint(11) NOT NULL default '0',
  usedoctitle tinyint(1) NOT NULL default '0',
  publishdate int(10) unsigned NOT NULL default '0',
  expiredate int(10) unsigned NOT NULL default '0',
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (CID),
  UNIQUE KEY topicID (CID),
  FULLTEXT KEY answer (page)
) TYPE=MyISAM COMMENT='WF-Channel by Catzwolf';

#
# Dumping data for table `wfschannel`
#

INSERT INTO wfschannel VALUES (1, 'Welcome Page', 'Welcome Page', '<H4 align=center><SPAN>Welcome To WF-Channel</SPAN></H4>\r\n<P align=left><SPAN><STRONG>What is WF-Channel?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></STRONG></SPAN></P>\r\n<P align=left><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Verdana">WF-Channel is a way of managing those pages of information that other modules just don\'t seem to fit. You can keep together those \'about Us\', \'Refer a Friend\', \'Link to Us\', Privacy Statements or just about any type of information that you believe would benefit your users.&nbsp;<o:p></o:p></SPAN></P>\r\n<P align=left><SPAN><STRONG>What it is not!<o:p></o:p></STRONG></SPAN></P>\r\n<P align=left><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Verdana">WF-Channel is not a full blown article management system and should not be used as such, there are better modules for this purpose and I would suggest you use them if that is what you are looking for.&nbsp; Other than that WF-Channel should be perfect for your needs.<o:p></o:p></SPAN></P>\r\n<P align=left><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Verdana">Enjoy and have Fun!<o:p></o:p></SPAN></P>\r\n<P align=left><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Verdana">ATB<o:p></o:p></SPAN></P>\r\n<P align=left><SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Verdana">Catz<o:p></o:p></SPAN></P>', 1, 0, 0, 0, 0, 1, 'logo.png', '', 0, 0, 1078399017, 0, 1, 0, 1079305800, 0, 33);

# --------------------------------------------------------

#
# Table structure for table `wfslinktous`
#

CREATE TABLE wfslinktous (
  submenuitem int(10) NOT NULL default '10',
  textlink varchar(255) NOT NULL default '',
  linkpagelogo varchar(255) NOT NULL default '',
  banner80x15 varchar(255) NOT NULL default '',
  button varchar(255) NOT NULL default '',
  logo varchar(255) NOT NULL default '',
  banner varchar(255) NOT NULL default '',
  mainpage int(10) NOT NULL default '1',
  newsfeed int(10) NOT NULL default '0',
  texthtml varchar(255) NOT NULL default '',
  titlelink varchar(255) NOT NULL default '',
  newsfeedjs mediumint(10) NOT NULL default '0',
  newstitle varchar(255) NOT NULL default '',
  linkintro text NOT NULL,
  PRIMARY KEY  (submenuitem)
) TYPE=MyISAM;

#
# Dumping data for table `wfslinktous`
#

INSERT INTO wfslinktous VALUES (1, 'Change Me', 'linktous.png', 'banner80x15.png', 'poweredby.gif', 'logo.gif', 'xoops_banner_2.gif', 1, 1, '', 'Link to us', 1, '', 'We welcome you to link to our Web site.  Feel free to create links from any section of your Web site to our articles about your website.  You are also welcome to link to our website directories and other resource pages.\r\n<br /><br />Whenever possible, we ask that you include our logo with the link on your Web site.  You may use any of the logos below.  Please make the logo a clickable link to the home page of our site, or another appropriate page if you are linking to a specific article or resource.\r\n<br /><br />To get a copy of the logo file, simply right-click on the logo of your choice below, and select \'Save Picture as...\' from the pop-up menu to save the image to your hard drive.  Then post the logo to the appropriate page on your site.');

# --------------------------------------------------------

#
# Table structure for table `wfsrefer`
#

CREATE TABLE wfsrefer (
  titlerefer varchar(255) NOT NULL default '',
  chanrefheadline text NOT NULL,
  submenuitem int(10) NOT NULL default '10',
  mainpage int(10) NOT NULL default '1',
  referpagelogo varchar(255) NOT NULL default '',
  emailaddress int(10) NOT NULL default '1',
  usersblurb int(10) NOT NULL default '0',
  defblurb varchar(255) NOT NULL default '',
  smiley tinyint(11) NOT NULL default '0',
  xcodes tinyint(11) NOT NULL default '0',
  breaks tinyint(4) NOT NULL default '0',
  html tinyint(11) NOT NULL default '1',
  privacy int(1) NOT NULL default '1',
  emailcheck int(1) NOT NULL default '1',
  privacy_statement text NOT NULL,
  PRIMARY KEY  (submenuitem)
) TYPE=MyISAM;

#
# Dumping data for table `wfsrefer`
#

INSERT INTO wfsrefer VALUES ('Refer a friend', 'Let a friend know about us.', 1, 1, 'referfriend.png', 1, 1, 'Please visit this fantastic website that I have just found.', 0, 1, 1, 1, 1, 1, 'We will not and do not collect, sell, or distribute in any way or form the email addresses gathered through this referral option. The intended recipient(s) will only receive the following message and no one else. ');