renewenewsmemberf_1.php 4.21 KB
<?php
@include("../../inc/header.php");

/*
		SoftName : EmpireBak
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

E_D("DROP TABLE IF EXISTS `renewenewsmemberf`;");
E_C("CREATE TABLE `renewenewsmemberf` (
  `fid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `f` varchar(30) NOT NULL DEFAULT '',
  `fname` varchar(30) NOT NULL DEFAULT '',
  `fform` varchar(20) NOT NULL DEFAULT '',
  `fhtml` mediumtext NOT NULL,
  `fzs` varchar(255) NOT NULL DEFAULT '',
  `myorder` smallint(6) NOT NULL DEFAULT '0',
  `ftype` varchar(30) NOT NULL DEFAULT '',
  `flen` varchar(20) NOT NULL DEFAULT '',
  `fvalue` text NOT NULL,
  `fformsize` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8");
E_D("replace into `renewenewsmemberf` values('1','truename','真實姓名','text','\r\n<input name=\"truename\" type=\"text\" id=\"truename\" value=\"<?=\$ecmsfirstpost==1?\"\":htmlspecialchars(stripSlashes(\$addr[truename]))?>\">\r\n','','1','VARCHAR','20','','');");
E_D("replace into `renewenewsmemberf` values('2','oicq','QQ號碼','text','<input name=\\\\\"oicq\\\\\" type=\\\\\"text\\\\\" id=\\\\\"oicq\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[oicq]))?>\\\\\">\r\n','','5','VARCHAR','25','','');");
E_D("replace into `renewenewsmemberf` values('3','msn','MSN','text','<input name=\\\\\"msn\\\\\" type=\\\\\"text\\\\\" id=\\\\\"msn\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[msn]))?>\\\\\">\r\n','','6','VARCHAR','120','','');");
E_D("replace into `renewenewsmemberf` values('4','mycall','聯繫電話','text','<input name=\\\\\"mycall\\\\\" type=\\\\\"text\\\\\" id=\\\\\"mycall\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[mycall]))?>\\\\\">\r\n','','2','VARCHAR','30','','');");
E_D("replace into `renewenewsmemberf` values('5','phone','手機','text','<input name=\\\\\"phone\\\\\" type=\\\\\"text\\\\\" id=\\\\\"phone\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[phone]))?>\\\\\">\r\n','','4','VARCHAR','30','','');");
E_D("replace into `renewenewsmemberf` values('6','address','聯繫地址','text','<input name=\\\\\"address\\\\\" type=\\\\\"text\\\\\" id=\\\\\"address\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[address]))?>\\\\\" size=\\\\\"50\\\\\">\r\n','','9','VARCHAR','255','','');");
E_D("replace into `renewenewsmemberf` values('7','zip','郵編','text','<input name=\\\\\"zip\\\\\" type=\\\\\"text\\\\\" id=\\\\\"zip\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[zip]))?>\\\\\" size=\\\\\"8\\\\\">\r\n','','10','VARCHAR','8','','');");
E_D("replace into `renewenewsmemberf` values('9','homepage','網址','text','\r\n<input name=\"homepage\" type=\"text\" id=\"homepage\" value=\"<?=\$ecmsfirstpost==1?\"\":htmlspecialchars(stripSlashes(\$addr[homepage]))?>\">\r\n','','7','VARCHAR','200','','');");
E_D("replace into `renewenewsmemberf` values('10','saytext','簡介','textarea','<textarea name=\\\\\"saytext\\\\\" cols=\\\\\"65\\\\\" rows=\\\\\"10\\\\\" id=\\\\\"saytext\\\\\"><?=\$ecmsfirstpost==1?\\\\\"\\\\\":stripSlashes(\$addr[saytext])?></textarea>\r\n','','11','TEXT','','','');");
E_D("replace into `renewenewsmemberf` values('11','company','公司名稱','text','<input name=\\\\\"company\\\\\" type=\\\\\"text\\\\\" id=\\\\\"company\\\\\" value=\\\\\"<?=\$ecmsfirstpost==1?\\\\\"\\\\\":htmlspecialchars(stripSlashes(\$addr[company]))?>\\\\\" size=\\\\\"38\\\\\">\r\n','','0','VARCHAR','255','','');");
E_D("replace into `renewenewsmemberf` values('12','fax','傳真','text','\r\n<input name=\"fax\" type=\"text\" id=\"fax\" value=\"<?=\$ecmsfirstpost==1?\"\":htmlspecialchars(stripSlashes(\$addr[fax]))?>\">\r\n','','3','VARCHAR','30','','');");
E_D("replace into `renewenewsmemberf` values('13','userpic','會員頭像','img','<input type=\\\\\"file\\\\\" name=\\\\\"userpicfile\\\\\">&nbsp;&nbsp;\r\n<?=empty(\$addr[userpic])?\\\\\"\\\\\":\\\\\"<img src=\\\\''\\\\\".htmlspecialchars(stripSlashes(\$addr[userpic])).\\\\\"\\\\'' border=0>\\\\\"?>','','8','VARCHAR','200','','');");

@include("../../inc/footer.php");
?>