pw_0609_8c2f55339c_1.sql

很好的一套PHP树形论坛程序

DROP TABLE IF EXISTS pw_tmsgs;
CREATE TABLE pw_tmsgs (
  tid mediumint(8) unsigned NOT NULL default '0',
  aid text NOT NULL,
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL,
  ipfrom varchar(80) NOT NULL default '',
  alterinfo varchar(50) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '1',
  content mediumtext NOT NULL,
  form varchar(30) NOT NULL default '',
  ifmark varchar(255) NOT NULL default '',
  c_from varchar(30) NOT NULL default '',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_posts;
CREATE TABLE pw_posts (
  pid int(10) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  aid text NOT NULL,
  author varchar(15) NOT NULL default '',
  authorid mediumint(8) unsigned NOT NULL default '0',
  icon tinyint(2) NOT NULL default '0',
  postdate int(10) unsigned NOT NULL default '0',
  subject varchar(200) NOT NULL default '',
  userip varchar(15) NOT NULL default '',
  ifsign tinyint(1) NOT NULL default '0',
  buy text NOT NULL,
  alterinfo varchar(50) NOT NULL default '',
  ipfrom varchar(30) NOT NULL default '',
  ifconvert tinyint(1) NOT NULL default '0',
  ifcheck tinyint(1) NOT NULL default '0',
  content mediumtext NOT NULL,
  ifmark varchar(255) NOT NULL default '',
  PRIMARY KEY  (pid),
  KEY fid (fid),
  KEY tid (tid),
  KEY authorid (authorid),
  KEY ifcheck (ifcheck)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_polls;
CREATE TABLE pw_polls (
  pollid int(10) unsigned NOT NULL auto_increment,
  voteopts mediumtext NOT NULL,
  PRIMARY KEY  (pollid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS pw_attachs;
CREATE TABLE pw_attachs (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  fid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  name char(80) NOT NULL default '',
  type char(30) NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  attachurl char(80) NOT NULL default '0',
  hits mediumint(8) unsigned NOT NULL default '0',
  needrvrc smallint(6) unsigned NOT NULL default '0',
  uploadtime int(10) NOT NULL default '0',
  descrip char(100) NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY fid (fid),
  KEY uid (uid),
  KEY type (type)
) TYPE=MyISAM;

INSERT INTO pw_actions VALUES('1','1.gif','比酷','摆了个ＰＯＳＥ道：你、你、你没我酷..');
INSERT INTO pw_actions VALUES('2','2.gif','生气','撅了撅嘴说：气死我了呀!呀!呀!');
INSERT INTO pw_actions VALUES('3','3.gif','狂笑','仰天狂笑：普天之下,竟然没有我的对手...');
INSERT INTO pw_actions VALUES('4','4.gif','痛哭','鼻子一酸,开始叭嗒叭嗒掉眼泪了');
INSERT INTO pw_actions VALUES('5','5.gif','唱歌','清清嗓子唱起歌来：东方红,太阳升');

INSERT INTO pw_smiles VALUES('1','smile.gif');
INSERT INTO pw_smiles VALUES('2','mrgreen.gif');
INSERT INTO pw_smiles VALUES('3','question.gif');
INSERT INTO pw_smiles VALUES('4','wink.gif');
INSERT INTO pw_smiles VALUES('5','redface.gif');
INSERT INTO pw_smiles VALUES('6','sad.gif');
INSERT INTO pw_smiles VALUES('7','cool.gif');
INSERT INTO pw_smiles VALUES('8','crazy.gif');

INSERT INTO pw_adminset VALUES('3','settings	1\n1\nupdatecache	1\n1\npostcache	1\n1\ncredit	1\n1\nsetforum	1\n1\nuniteforum	1\n1\ncreathtm	1\n1\nsetuser	1\n1\nipsearch	1\n1\nuserstats	1\n1\nupgrade	1\n1\neditgroup	1\n1\nlevel	1\n1\narticle	1\n1\nmember	1\n1\nmessage	1\n1\nbanuser	1\n1\nviewban	1\n1\nipban	1\n1\nsetbwd	1\n1\ntpccheck	1\n1\npostcheck	1\n1\nreport	1\n1\ncheckemail	1\n1\ncheckreg	1\n1\nannouncement	1\n1\nmailuser	1\n1\nsend_msg	1\n1\ngiveuser	1\n1\nattachment	1\n1\nattachstats	1\n1\nattachrenew	1\n1\nadminlog	1\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	1\n1\nsetads	1\n1\nipstates	1\n1\nshare	1\n1\nviewtody	1\n1\nc_set	1\n1\nc_forum	1\n1\nc_unite	1\n1\nc_htm	1\n1\naddatc	1\n1\nschatc	1\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	1');
INSERT INTO pw_adminset VALUES('4','settings	0\n1\nupdatecache	0\n1\npostcache	1\n1\ncredit	0\n1\nsetforum	0\n1\nuniteforum	0\n1\ncreathtm	0\n1\nsetuser	0\n1\nipsearch	1\n1\nuserstats	1\n1\nupgrade	0\n1\neditgroup	1\n1\nlevel	0\n1\narticle	0\n1\nmember	0\n1\nmessage	1\n1\nbanuser	1\n1\nviewban	1\n1\nipban	1\n1\nsetbwd	1\n1\ntpccheck	1\n1\npostcheck	1\n1\nreport	1\n1\ncheckemail	1\n1\ncheckreg	1\n1\nannouncement	1\n1\nmailuser	0\n1\nsend_msg	0\n1\ngiveuser	1\n1\nattachment	1\n1\nattachstats	1\n1\nattachrenew	1\n1\nadminlog	0\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	1\n1\nsetads	1\n1\nipstates	0\n1\nshare	1\n1\nviewtody	1\n1\nc_set	0\n1\nc_forum	0\n1\nc_unite	0\n1\nc_htm	0\n1\naddatc	0\n1\nschatc	0\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	0');
INSERT INTO pw_adminset VALUES('5','settings	0\n1\nupdatecache	0\n1\npostcache	0\n1\ncredit	0\n1\nsetforum	0\n1\nuniteforum	0\n1\ncreathtm	0\n1\nsetuser	0\n1\nipsearch	0\n1\nuserstats	0\n1\nupgrade	0\n1\neditgroup	0\n1\nlevel	0\n1\narticle	0\n1\nmember	0\n1\nmessage	0\n1\nbanuser	1\n1\nviewban	1\n1\nipban	0\n1\nsetbwd	0\n1\ntpccheck	0\n1\npostcheck	0\n1\nreport	1\n1\ncheckemail	0\n1\ncheckreg	0\n1\nannouncement	1\n1\nmailuser	0\n1\nsend_msg	0\n1\ngiveuser	0\n1\nattachment	0\n1\nattachstats	0\n1\nattachrenew	0\n1\nadminlog	0\n1\nforumlog	1\n1\ncreditlog	1\n1\nuserlog	0\n1\nsetads	0\n1\nipstates	0\n1\nshare	0\n1\nviewtody	0\n1\nc_set	0\n1\nc_forum	0\n1\nc_unite	0\n1\nc_htm	0\n1\naddatc	0\n1\nschatc	0\n1\nbakout	0\n1\nbakin	0\n1\nrepair	0\n1\nsetstyles	0');


INSERT INTO pw_recycle VALUES('2','2','1172682310','大陆仔');
INSERT INTO pw_recycle VALUES('4','2','1172682345','大陆仔');
INSERT INTO pw_recycle VALUES('5','2','1172682494','大陆仔');
INSERT INTO pw_recycle VALUES('1','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('3','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('6','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('7','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('8','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('9','2','1172729436','树型论坛');
INSERT INTO pw_recycle VALUES('10','2','1172729436','树型论坛');


INSERT INTO pw_tools VALUES('1','威望工具','可将自已负威望清零','1','1.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('2','积分工具','可将自已所有负分清零','2','2.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('3','加亮标题','可以将自己的帖子标题加亮显示','3','3.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('4','置顶I','可将自己发表的帖子在版块中置顶，置顶时间为6小时。','4','4.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('5','置顶II','可将自己发表的帖子在分类中置顶，置顶时间为6小时。','5','5.gif','0','200','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('6','置顶III','可将自己发表的帖子在整个论坛中置顶，置顶时间为6小时。','6','6.gif','0','500','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('7','提前帖子','可以把自己发表的帖子提前到帖子所在版块的第一页','7','7.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('8','更改用户名','可更改自已在论坛的用户名','8','8.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('9','精华I','可以将自己的帖子加为精华I','9','9.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('10','精华II','可以将自己的帖子加为精华II','10','10.gif','0','200','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('11','锁定帖子','可以将自己发表的帖子锁定，不让其他会员回复此帖。','11','11.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');
INSERT INTO pw_tools VALUES('12','解除锁定','可以解除自己被帖子锁定，让其他会员可以回复此帖。','12','12.gif','0','100','100','a:1:{s:6:\"credit\";a:7:{s:7:\"postnum\";i:0;s:7:\"digests\";i:0;s:4:\"rvrc\";i:0;s:5:\"money\";i:0;s:6:\"credit\";i:0;i:1;i:0;i:2;i:0;}}');


INSERT INTO pw_bbsinfo VALUES('1','树型','6','4','1172722138','1172649600','0','0','0','0','0','');

INSERT INTO pw_config VALUES('db_hour','20','');
INSERT INTO pw_config VALUES('db_http','N','');
INSERT INTO pw_config VALUES('db_autochange','0','');
INSERT INTO pw_config VALUES('db_bbsifopen','1','');
INSERT INTO pw_config VALUES('db_whybbsclose','论坛升级中... 请等候 15分钟','');
INSERT INTO pw_config VALUES('db_bbsname','金枫科技-树型论坛演示 Board','');
INSERT INTO pw_config VALUES('db_bbsurl','','');
INSERT INTO pw_config VALUES('db_wwwname','园园科技 Studio','');
INSERT INTO pw_config VALUES('db_wwwurl','http://125666.com','');
INSERT INTO pw_config VALUES('db_ceoconnect','http://www.vxbbs.com','');
INSERT INTO pw_config VALUES('db_ceoemail','[e-mail]','');
INSERT INTO pw_config VALUES('db_newtime','3600','');
INSERT INTO pw_config VALUES('db_signwindcode','1','');
INSERT INTO pw_config VALUES('db_windpic[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windpic[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_windpic[\'picwidth\']','700','');
INSERT INTO pw_config VALUES('db_windpic[\'picheight\']','200','');
INSERT INTO pw_config VALUES('db_windpic[\'size\']','3','');
INSERT INTO pw_config VALUES('db_cvtime','0','');
INSERT INTO pw_config VALUES('db_timedf','8','');
INSERT INTO pw_config VALUES('db_perpage','50','');
INSERT INTO pw_config VALUES('db_readperpage','1','');
INSERT INTO pw_config VALUES('db_replysendmail','0','');
INSERT INTO pw_config VALUES('db_postmax','50000','');
INSERT INTO pw_config VALUES('db_windpost[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windpost[\'picwidth\']','700','');
INSERT INTO pw_config VALUES('db_windpost[\'picheight\']','','');
INSERT INTO pw_config VALUES('db_windpost[\'size\']','5','');
INSERT INTO pw_config VALUES('db_windpost[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_indexnotice','1','');
INSERT INTO pw_config VALUES('db_showreplynum','5','');
INSERT INTO pw_config VALUES('db_windreply[\'pic\']','1','');
INSERT INTO pw_config VALUES('db_windreply[\'flash\']','0','');
INSERT INTO pw_config VALUES('db_dtreplyrvrc','1','');
INSERT INTO pw_config VALUES('db_refreshtime','0','');
INSERT INTO pw_config VALUES('db_onlinetime','3600','');
INSERT INTO pw_config VALUES('db_footertime','1','');
INSERT INTO pw_config VALUES('db_threadonline','0','');
INSERT INTO pw_config VALUES('db_uploadmaxsize','2048000','');
INSERT INTO pw_config VALUES('db_uploadfiletype','gif jpg rar txt zip swf jqf','');
INSERT INTO pw_config VALUES('db_attachdir','3','');
INSERT INTO pw_config VALUES('db_attachnum','4','');
INSERT INTO pw_config VALUES('db_windpost[\'mpeg\']','1','');
INSERT INTO pw_config VALUES('db_windpost[\'iframe\']','0','');
INSERT INTO pw_config VALUES('db_dtpostrvrc','10','');
INSERT INTO pw_config VALUES('db_dtpostmoney','5','');
INSERT INTO pw_config VALUES('db_dtjhrvrc','50','');
INSERT INTO pw_config VALUES('db_dtjhmoney','5','');
INSERT INTO pw_config VALUES('db_onlinelmt','0','');
INSERT INTO pw_config VALUES('db_dtdelrvrc','10','');
INSERT INTO pw_config VALUES('db_dtdelrprvrc','10','');
INSERT INTO pw_config VALUES('db_dtdelmoney','5','');
INSERT INTO pw_config VALUES('db_indexonline','0','');
INSERT INTO pw_config VALUES('db_ifjump','1','');
INSERT INTO pw_config VALUES('db_regpopup','0','');
INSERT INTO pw_config VALUES('db_ifonlinetime','0','');
INSERT INTO pw_config VALUES('db_showguest','0','');
INSERT INTO pw_config VALUES('db_recycle','3','');
INSERT INTO pw_config VALUES('db_indexshowbirth','0','');
INSERT INTO pw_config VALUES('db_obstart','1','');
INSERT INTO pw_config VALUES('db_indexlink','0','');
INSERT INTO pw_config VALUES('db_indexmqshare','0','');
INSERT INTO pw_config VALUES('db_defaultstyle','wind','');
INSERT INTO pw_config VALUES('db_ckpath','/','');
INSERT INTO pw_config VALUES('db_ckdomain','','');
INSERT INTO pw_config VALUES('db_windreadable','1','');
INSERT INTO pw_config VALUES('db_schpernum','10000','');
INSERT INTO pw_config VALUES('db_threademotion','0','');
INSERT INTO pw_config VALUES('db_todaypost','0','');
INSERT INTO pw_config VALUES('db_threadshowpost','1','');
INSERT INTO pw_config VALUES('db_indexfmlogo','2','');
INSERT INTO pw_config VALUES('db_autoimg','1','');
INSERT INTO pw_config VALUES('db_postmin','0','');
INSERT INTO pw_config VALUES('db_selcount','15','');
INSERT INTO pw_config VALUES('db_ipfrom','0','');
INSERT INTO pw_config VALUES('db_dtreplymoney','1','');
INSERT INTO pw_config VALUES('db_ipcheck','0','');
INSERT INTO pw_config VALUES('db_today','0','');
INSERT INTO pw_config VALUES('db_postallowtime','0','');
INSERT INTO pw_config VALUES('db_showonline','0','');
INSERT INTO pw_config VALUES('db_ipban','','');
INSERT INTO pw_config VALUES('db_ifcheck','1','');
INSERT INTO pw_config VALUES('db_ads','1','');
INSERT INTO pw_config VALUES('db_hithour','0','');
INSERT INTO pw_config VALUES('db_upgrade','1','');
INSERT INTO pw_config VALUES('db_lp','0','');
INSERT INTO pw_config VALUES('db_topped','1','');
INSERT INTO pw_config VALUES('db_msgsound','0','');
INSERT INTO pw_config VALUES('db_datefm','Y-m-d H:i','');
INSERT INTO pw_config VALUES('db_lgck','0','');
INSERT INTO pw_config VALUES('db_bfn','index.php','');
INSERT INTO pw_config VALUES('db_hfn','bbs','');
INSERT INTO pw_config VALUES('db_cfn','c_index.php','');
INSERT INTO pw_config VALUES('db_showgroup',',3,4,5,16,','');
INSERT INTO pw_config VALUES('db_upload','1	200	180	20480','');
INSERT INTO pw_config VALUES('db_allowupload','0','');
INSERT INTO pw_config VALUES('db_adminshow','0','');
INSERT INTO pw_config VALUES('db_maxpage','1000','');
INSERT INTO pw_config VALUES('db_maxmember','1000','');