PageRenderTime 71ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 1ms

/e/class/moddofun.php

https://github.com/westeast/xwdede
PHP | 2271 lines | 2008 code | 50 blank | 213 comment | 246 complexity | c240a5afacc357851f0d41e3947c6c44 MD5 | raw file
    

  1. <?php

    2. 

  2. //************************************ 数据表 ************************************

    3. 

  3. 

    4. 

  4. //建立初始表

    5. 

  5. function AddTableDefault($tbname,$tid){

    6. 

  6. 	global $empire,$dbtbpre,$phome_db_dbchar;

    7. 

  7. 	include("db/DefaultTable.php");

    8. 

  8. 	//复制存档表

    9. 

  9. 	$otb=$dbtbpre."ecms_".$tbname;

    10. 

  10. 	$tb=$otb."_doc";

    11. 

  11. 	CopyEcmsTb($otb,$tb);

    12. 

  12. 	$odtb=$dbtbpre."ecms_".$tbname."_data_1";

    13. 

  13. 	$dtb=$tb."_data";

    14. 

  14. 	CopyEcmsTb($odtb,$dtb);

    15. 

  15. }

    16. 

  16. 

    17. 

  17. //复制数据表

    18. 

  18. function CopyNewTable($add,$userid,$username){

    19. 

  19. 	global $empire,$dbtbpre;

    20. 

  20. 	$tid=(int)$add['tid'];

    21. 

  21. 	$newtbname=strtolower(trim($add[newtbname]));

    22. 

  22. 	if(!$tid||empty($newtbname)||!$add[tname])

    23. 

  23. 	{

    24. 

  24. 		printerror("EmptyTbname","");

    25. 

  25. 	}

    26. 

  26. 	CheckLevel($userid,$username,$classid,"table");//操作权限

    27. 

  27. 	$add[yhid]=(int)$add[yhid];

    28. 

  28. 	$tr=$empire->fetch1("select tbname from {$dbtbpre}enewstable where tid=$tid");

    29. 

  29. 	if(!$tr[tbname])

    30. 

  30. 	{

    31. 

  31. 		printerror("EmptyTbname","");

    32. 

  32. 	}

    33. 

  33. 	$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewstable where tbname='$newtbname' limit 1");

    34. 

  34. 	if($num)

    35. 

  35. 	{

    36. 

  36. 		printerror("ReTbname","history.go(-1)");

    37. 

  37. 	}

    38. 

  38. 	$sql=$empire->query("insert into {$dbtbpre}enewstable(tbname,tname,tsay,isdefault,datatbs,deftb,yhid) values('$newtbname','$add[tname]','$add[tsay]',0,',1,','1','$add[yhid]');");

    39. 

  39. 	$newtid=$empire->lastid();

    40. 

  40. 	//复制表

    41. 

  41. 	CopyEcmsTb($dbtbpre."ecms_".$tr['tbname'],$dbtbpre."ecms_".$newtbname);	//内容表

    42. 

  42. 	CopyEcmsTb($dbtbpre."ecms_".$tr['tbname']."_data_1",$dbtbpre."ecms_".$newtbname."_data_1");	//内容副表

    43. 

  43. 	CopyEcmsTb($dbtbpre."ecms_".$tr['tbname']."_doc",$dbtbpre."ecms_".$newtbname."_doc");	//归档表

    44. 

  44. 	CopyEcmsTb($dbtbpre."ecms_".$tr['tbname']."_doc_data",$dbtbpre."ecms_".$newtbname."_doc_data");	//归档副表

    45. 

  45. 	CopyEcmsTb($dbtbpre."ecms_infoclass_".$tr['tbname'],$dbtbpre."ecms_infoclass_".$newtbname);	//采集节点附加表

    46. 

  46. 	CopyEcmsTb($dbtbpre."ecms_infotmp_".$tr['tbname'],$dbtbpre."ecms_infotmp_".$newtbname);	//采集数据临时表

    47. 

  47. 	//字段数据

    48. 

  48. 	$fsql=$empire->query("select * from {$dbtbpre}enewsf where tid=$tid order by fid");

    49. 

  49. 	while($fr=$empire->fetch($fsql))

    50. 

  50. 	{

    51. 

  51. 		$usql=$empire->query("insert into {$dbtbpre}enewsf(f,fname,fform,fhtml,fzs,isadd,isshow,iscj,cjhtml,myorder,ftype,flen,dotemp,tid,tbname,savetxt,fvalue,iskey,tobr,dohtml,qfhtml,isonly,linkfieldval,samedata,fformsize,tbdataf,ispage,adddofun,editdofun,qadddofun,qeditdofun,linkfieldtb,linkfieldshow,editorys) values('$fr[f]','$fr[fname]','$fr[fform]','".addslashes(addslashes(stripSlashes($fr['fhtml'])))."','".addslashes(stripSlashes($fr[fzs]))."',$fr[isadd],$fr[isshow],$fr[iscj],'".addslashes(addslashes(stripSlashes($fr[cjhtml])))."',$fr[myorder],'$fr[ftype]','$fr[flen]',$fr[dotemp],$newtid,'$newtbname',$fr[savetxt],'".addslashes(addslashes(stripSlashes($fr[fvalue])))."',$fr[iskey],$fr[tobr],$fr[dohtml],'".addslashes(addslashes(stripSlashes($fr[qfhtml])))."','$fr[isonly]','".addslashes(stripSlashes($fr[linkfieldval]))."','$fr[samedata]','".addslashes(stripSlashes($fr[fformsize]))."','$fr[tbdataf]','$fr[ispage]','".addslashes(stripSlashes($fr[adddofun]))."','".addslashes(stripSlashes($fr[editdofun]))."','".addslashes(stripSlashes($fr[qadddofun]))."','".addslashes(stripSlashes($fr[qeditdofun]))."','".addslashes(stripSlashes($fr[linkfieldtb]))."','".addslashes(stripSlashes($fr[linkfieldshow]))."','$fr[editorys]');");

    52. 

  52. 	}

    53. 

  53. 	TogSaveTxtF(1);//公共变量

    54. 

  54. 	GetConfig(1);//更新缓存

    55. 

  55. 	if($sql)

    56. 

  56. 	{

    57. 

  57. 		//操作日志

    58. 

  58. 		insert_dolog("tid=".$tid."<br>tb=".$tr[tbname]."<br>newtid=".$newtid."<br>newtb=".$newtbname);

    59. 

  59. 		printerror("CopyTbSuccess","db/ListTable.php");

    60. 

  60. 	}

    61. 

  61. 	else

    62. 

  62. 	{

    63. 

  63. 		printerror("DbError","");

    64. 

  64. 	}

    65. 

  65. }

    66. 

  66. 

    67. 

  67. //建立数据表

    68. 

  68. function AddTable($add,$userid,$username){

    69. 

  69. 	global $empire,$dbtbpre;

    70. 

  70. 	$add[tbname]=strtolower(trim($add[tbname]));

    71. 

  71. 	if(!$add[tbname]||!$add[tname])

    72. 

  72. 	{

    73. 

  73. 		printerror("EmptyTbname","history.go(-1)");

    74. 

  74.     }

    75. 

  75. 	//操作权限

    76. 

  76. 	CheckLevel($userid,$username,$classid,"table");

    77. 

  77. 	$add[yhid]=(int)$add[yhid];

    78. 

  78. 	$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewstable where tbname='$add[tbname]' limit 1");

    79. 

  79. 	if($num)

    80. 

  80. 	{

    81. 

  81. 		printerror("ReTbname","history.go(-1)");

    82. 

  82. 	}

    83. 

  83. 	$sql=$empire->query("insert into {$dbtbpre}enewstable(tbname,tname,tsay,isdefault,datatbs,deftb,yhid) values('$add[tbname]','$add[tname]','$add[tsay]',0,',1,','1','$add[yhid]');");

    84. 

  84. 	$tid=$empire->lastid();

    85. 

  85. 	//初使化表

    86. 

  86. 	AddTableDefault($add[tbname],$tid);

    87. 

  87. 	GetConfig(1);//更新缓存

    88. 

  88. 	if($sql)

    89. 

  89. 	{

    90. 

  90. 		//操作日志

    91. 

  91. 		insert_dolog("tid=".$tid."<br>tbname=".$add[tbname]);

    92. 

  92. 		printerror("AddTbSuccess","db/AddTable.php?enews=AddTable");

    93. 

  93. 	}

    94. 

  94. 	else

    95. 

  95. 	{

    96. 

  96. 		printerror("DbError","history.go(-1)");

    97. 

  97. 	}

    98. 

  98. }

    99. 

  99. 

    100. 

  100. //修改数据表

    101. 

  101. function EditTable($add,$userid,$username){

    102. 

  102. 	global $empire,$dbtbpre;

    103. 

  103. 	$add[tbname]=strtolower(trim($add[tbname]));

    104. 

  104. 	$tid=(int)$add[tid];

    105. 

  105. 	if(!$add[tbname]||!$add[tname]||!$tid)

    106. 

  106. 	{

    107. 

  107. 		printerror("EmptyTbname","history.go(-1)");

    108. 

  108.     }

    109. 

  109. 	//操作权限

    110. 

  110. 	CheckLevel($userid,$username,$classid,"table");

    111. 

  111. 	$add[yhid]=(int)$add[yhid];

    112. 

  112. 	//改变数据表名

    113. 

  113. 	if($add[tbname]!=$add[oldtbname])

    114. 

  114. 	{

    115. 

  115. 		$tbnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewstable where tbname='$add[tbname]' and tid<>$tid limit 1");

    116. 

  116. 		if($tbnum)

    117. 

  117. 		{

    118. 

  118. 			printerror("ReTbname","history.go(-1)");

    119. 

  119. 		}

    120. 

  120. 		$tbr=$empire->fetch1("select tid,isdefault,datatbs,deftb from {$dbtbpre}enewstable where tid='$tid' limit 1");

    121. 

  121. 		if(!$tbr['tid'])

    122. 

  122. 		{

    123. 

  123. 			printerror("EmptyTbname","history.go(-1)");

    124. 

  124. 		}

    125. 

  125. 		//主表

    126. 

  126. 		$empire->query("ALTER TABLE `{$dbtbpre}ecms_".$add[oldtbname]."` RENAME `{$dbtbpre}ecms_".$add[tbname]."`;");

    127. 

  127. 		//副表

    128. 

  128. 		if($tbr['datatbs'])

    129. 

  129. 		{

    130. 

  130. 			$dtbr=explode(',',$tbr['datatbs']);

    131. 

  131. 			$count=count($dtbr);

    132. 

  132. 			for($i=1;$i<$count-1;$i++)

    133. 

  133. 			{

    134. 

  134. 				$empire->query("ALTER TABLE `{$dbtbpre}ecms_".$add[oldtbname]."_data_".$dtbr[$i]."` RENAME `{$dbtbpre}ecms_".$add[tbname]."_data_".$dtbr[$i]."`;");

    135. 

  135. 			}

    136. 

  136. 		}

    137. 

  137. 		//归档表

    138. 

  138. 		$empire->query("ALTER TABLE `{$dbtbpre}ecms_".$add[oldtbname]."_doc` RENAME `{$dbtbpre}ecms_".$add[tbname]."_doc`;");

    139. 

  139. 		$empire->query("ALTER TABLE `{$dbtbpre}ecms_".$add[oldtbname]."_doc_data` RENAME `{$dbtbpre}ecms_".$add[tbname]."_doc_data`;");

    140. 

  140. 		//采集

    141. 

  141. 	    $empire->query("ALTER TABLE `{$dbtbpre}ecms_infoclass_".$add[oldtbname]."` RENAME `{$dbtbpre}ecms_infoclass_".$add[tbname]."`;");

    142. 

  142. 		$empire->query("ALTER TABLE `{$dbtbpre}ecms_infotmp_".$add[oldtbname]."` RENAME `{$dbtbpre}ecms_infotmp_".$add[tbname]."`;");

    143. 

  143. 		//字段

    144. 

  144. 		$empire->query("update {$dbtbpre}enewsf set tbname='$add[tbname]' where tid='$tid'");

    145. 

  145. 		//栏目

    146. 

  146. 		$empire->query("update {$dbtbpre}enewsclass set tbname='$add[tbname]' where tid='$tid'");

    147. 

  147. 		$empire->query("update {$dbtbpre}enewszt set tbname='$add[tbname]' where tid='$tid'");

    148. 

  148. 		$empire->query("update {$dbtbpre}enewsinfoclass set tbname='$add[tbname]' where tid='$tid'");

    149. 

  149. 		$empire->query("update {$dbtbpre}enewsmod set tbname='$add[tbname]' where tid='$tid'");

    150. 

  150. 		//搜索

    151. 

  151. 		$empire->query("update {$dbtbpre}enewssearch set tbname='$add[tbname]' where tbname='$add[oldtbname]'");

    152. 

  152. 		$empire->query("update {$dbtbpre}enewssearchall_load set tbname='$add[tbname]' where tbname='$add[oldtbname]'");

    153. 

  153. 		//默认表

    154. 

  154. 		if($tbr['isdefault'])

    155. 

  155. 		{

    156. 

  156. 			$empire->query("update {$dbtbpre}enewspublic set tbname='$add[tbname]',tid='$tid'");

    157. 

  157. 		}

    158. 

  158. 		//文本型

    159. 

  159. 		TogSaveTxtF(1);

    160. 

  160. 	}

    161. 

  161. 	$sql=$empire->query("update {$dbtbpre}enewstable set tbname='$add[tbname]',tname='$add[tname]',tsay='$add[tsay]',yhid='$add[yhid]' where tid='$tid'");

    162. 

  162. 	GetConfig(1);//更新缓存

    163. 

  163. 	if($sql)

    164. 

  164. 	{

    165. 

  165. 		//操作日志

    166. 

  166. 		insert_dolog("tid=".$tid."<br>tbname=".$add[tbname]);

    167. 

  167. 		printerror("EditTbSuccess","db/ListTable.php");

    168. 

  168. 	}

    169. 

  169. 	else

    170. 

  170. 	{

    171. 

  171. 		printerror("DbError","history.go(-1)");

    172. 

  172. 	}

    173. 

  173. }

    174. 

  174. 

    175. 

  175. //删除数据表

    176. 

  176. function DelTable($tid,$userid,$username){

    177. 

  177. 	global $empire,$dbtbpre;

    178. 

  178. 	$tid=(int)$tid;

    179. 

  179. 	if(!$tid)

    180. 

  180. 	{

    181. 

  181. 		printerror("NotChangeTb","");

    182. 

  182.     }

    183. 

  183. 	//操作权限

    184. 

  184. 	CheckLevel($userid,$username,$classid,"table");

    185. 

  185. 	$r=$empire->fetch1("select tid,tbname,isdefault,datatbs,deftb from {$dbtbpre}enewstable where tid='$tid'");

    186. 

  186. 	if(empty($r[tid]))

    187. 

  187. 	{

    188. 

  188. 		printerror("NotChangeTb","");

    189. 

  189. 	}

    190. 

  190. 	//默认表

    191. 

  191. 	if($r['isdefault'])

    192. 

  192. 	{

    193. 

  193. 		printerror("NotDelDefaultTb","");

    194. 

  194. 	}

    195. 

  195. 	$sql=$empire->query("delete from {$dbtbpre}enewstable where tid='$tid'");

    196. 

  196. 	//删除数据表

    197. 

  197. 	$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_".$r[tbname].";");

    198. 

  198. 	if($r['datatbs'])

    199. 

  199. 	{

    200. 

  200. 		$dtbr=explode(',',$r['datatbs']);

    201. 

  201. 		$count=count($dtbr);

    202. 

  202. 		for($i=1;$i<$count-1;$i++)

    203. 

  203. 		{

    204. 

  204. 			$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_".$r[tbname]."_data_".$dtbr[$i].";");

    205. 

  205. 		}

    206. 

  206. 	}

    207. 

  207. 	$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_infoclass_".$r[tbname].";");

    208. 

  208. 	$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_infotmp_".$r[tbname].";");

    209. 

  209. 	$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_".$r[tbname]."_doc;");

    210. 

  210. 	$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_".$r[tbname]."_doc_data;");

    211. 

  211. 	//删除数据

    212. 

  212. 	$empire->query("delete from {$dbtbpre}enewsf where tid='$tid'");

    213. 

  213. 	$empire->query("delete from {$dbtbpre}enewsmod where tid='$tid'");

    214. 

  214. 	$empire->query("delete from {$dbtbpre}enewsinfoclass where tid='$tid'");

    215. 

  215. 	//文本型

    216. 

  216. 	TogSaveTxtF(1);

    217. 

  217. 	GetConfig(1);//更新缓存

    218. 

  218. 	if($sql)

    219. 

  219. 	{

    220. 

  220. 		//操作日志

    221. 

  221. 		insert_dolog("tid=".$tid."<br>tbname=".$r[tbname]);

    222. 

  222. 		printerror("DelTbSuccess","db/ListTable.php");

    223. 

  223. 	}

    224. 

  224. 	else

    225. 

  225. 	{

    226. 

  226. 		printerror("DbError","history.go(-1)");

    227. 

  227. 	}

    228. 

  228. }

    229. 

  229. 

    230. 

  230. //默认数据表

    231. 

  231. function DefaultTable($tid,$userid,$username){

    232. 

  232. 	global $empire,$dbtbpre;

    233. 

  233. 	$tid=(int)$tid;

    234. 

  234. 	if(!$tid)

    235. 

  235. 	{

    236. 

  236. 		printerror("NotChangeDefaultTb","history.go(-1)");

    237. 

  237.     }

    238. 

  238. 	//操作权限

    239. 

  239. 	CheckLevel($userid,$username,$classid,"table");

    240. 

  240. 	$r=$empire->fetch1("select tid,tbname from {$dbtbpre}enewstable where tid='$tid'");

    241. 

  241. 	if(empty($r[tid]))

    242. 

  242. 	{

    243. 

  243. 		printerror("NotChangeDefaultTb","history.go(-1)");

    244. 

  244. 	}

    245. 

  245. 	$usql=$empire->query("update {$dbtbpre}enewstable set isdefault=0");

    246. 

  246. 	$sql=$empire->query("update {$dbtbpre}enewstable set isdefault=1 where tid='$tid'");

    247. 

  247. 	$upsql=$empire->query("update {$dbtbpre}enewspublic set tbname='$r[tbname]',tid='$tid'");

    248. 

  248. 	GetConfig(1);//更新缓存

    249. 

  249. 	if($sql&&$usql&&$upsql)

    250. 

  250. 	{

    251. 

  251. 		//操作日志

    252. 

  252. 		insert_dolog("tid=".$tid."<br>tbname=".$r[tbname]);

    253. 

  253. 		printerror("DefaultTableSuccess","db/ListTable.php");

    254. 

  254. 	}

    255. 

  255. 	else

    256. 

  256. 	{

    257. 

  257. 		printerror("DbError","history.go(-1)");

    258. 

  258. 	}

    259. 

  259. }

    260. 

  260. 

    261. 

  261. //增加副表分表

    262. 

  262. function AddDataTable($add,$userid,$username){

    263. 

  263. 	global $empire,$dbtbpre;

    264. 

  264. 	//操作权限

    265. 

  265. 	CheckLevel($userid,$username,$classid,"table");

    266. 

  266. 	$tid=(int)$add['tid'];

    267. 

  267. 	$tbname=RepPostVar($add['tbname']);

    268. 

  268. 	$datatb=(int)$add['datatb'];

    269. 

  269. 	if(!$tid||!$tbname||!$datatb)

    270. 

  270. 	{

    271. 

  271. 		printerror("EmptyDataTable","history.go(-1)");

    272. 

  272. 	}

    273. 

  273. 	$tr=$empire->fetch1("select tid,datatbs from {$dbtbpre}enewstable where tid='$tid'");

    274. 

  274. 	if(!$tr['tid'])

    275. 

  275. 	{

    276. 

  276. 		printerror("EmptyDataTable","history.go(-1)");

    277. 

  277. 	}

    278. 

  278. 	if(strstr($tr['datatbs'],','.$datatb.','))

    279. 

  279. 	{

    280. 

  280. 		printerror("ReDataTable","history.go(-1)");

    281. 

  281. 	}

    282. 

  282. 	if(empty($tr['datatbs']))

    283. 

  283. 	{

    284. 

  284. 		$tr['datatbs']=',';

    285. 

  285. 	}

    286. 

  286. 	$newdatatbs=$tr['datatbs'].$datatb.',';

    287. 

  287. 	//建表

    288. 

  288. 	$odtb=$dbtbpre."ecms_".$tbname."_data_1";

    289. 

  289. 	$dtb=$dbtbpre."ecms_".$tbname."_data_".$datatb;

    290. 

  290. 	CopyEcmsTb($odtb,$dtb);

    291. 

  291. 	$sql=$empire->query("update {$dbtbpre}enewstable set datatbs='$newdatatbs' where tid='$tid'");

    292. 

  292. 	GetConfig(1);//更新缓存

    293. 

  293. 	if($sql)

    294. 

  294. 	{

    295. 

  295. 		//操作日志

    296. 

  296. 		insert_dolog("tid=".$tid."<br>tbname=".$tbname."&datatb=$datatb");

    297. 

  297. 		printerror("AddDataTableSuccess","db/ListDataTable.php?tid=$tid&tbname=$tbname");

    298. 

  298. 	}

    299. 

  299. 	else

    300. 

  300. 	{

    301. 

  301. 		printerror("DbError","history.go(-1)");

    302. 

  302. 	}

    303. 

  303. }

    304. 

  304. 

    305. 

  305. //默认副表存放表

    306. 

  306. function DefDataTable($add,$userid,$username){

    307. 

  307. 	global $empire,$dbtbpre;

    308. 

  308. 	//操作权限

    309. 

  309. 	CheckLevel($userid,$username,$classid,"table");

    310. 

  310. 	$tid=(int)$add['tid'];

    311. 

  311. 	$tbname=RepPostVar($add['tbname']);

    312. 

  312. 	$datatb=(int)$add['datatb'];

    313. 

  313. 	if(!$tid||!$tbname||!$datatb)

    314. 

  314. 	{

    315. 

  315. 		printerror("NotChangeDataTable","history.go(-1)");

    316. 

  316. 	}

    317. 

  317. 	$tr=$empire->fetch1("select tid,datatbs from {$dbtbpre}enewstable where tid='$tid'");

    318. 

  318. 	if(!$tr['tid'])

    319. 

  319. 	{

    320. 

  320. 		printerror("NotChangeDataTable","history.go(-1)");

    321. 

  321. 	}

    322. 

  322. 	if(!strstr($tr['datatbs'],','.$datatb.','))

    323. 

  323. 	{

    324. 

  324. 		printerror("NotChangeDataTable","history.go(-1)");

    325. 

  325. 	}

    326. 

  326. 	$sql=$empire->query("update {$dbtbpre}enewstable set deftb='$datatb' where tid='$tid'");

    327. 

  327. 	GetConfig(1);//更新缓存

    328. 

  328. 	if($sql)

    329. 

  329. 	{

    330. 

  330. 		//操作日志

    331. 

  331. 		insert_dolog("tid=".$tid."<br>tbname=".$tbname."&datatb=$datatb");

    332. 

  332. 		printerror("DefDataTableSuccess","db/ListDataTable.php?tid=$tid&tbname=$tbname");

    333. 

  333. 	}

    334. 

  334. 	else

    335. 

  335. 	{

    336. 

  336. 		printerror("DbError","history.go(-1)");

    337. 

  337. 	}

    338. 

  338. }

    339. 

  339. 

    340. 

  340. //删除副表分表

    341. 

  341. function DelDataTable($add,$userid,$username){

    342. 

  342. 	global $empire,$dbtbpre,$emod_r,$class_r;

    343. 

  343. 	//操作权限

    344. 

  344. 	CheckLevel($userid,$username,$classid,"table");

    345. 

  345. 	$tid=(int)$add['tid'];

    346. 

  346. 	$tbname=RepPostVar($add['tbname']);

    347. 

  347. 	$datatb=(int)$add['datatb'];

    348. 

  348. 	if(!$tid||!$tbname||!$datatb)

    349. 

  349. 	{

    350. 

  350. 		printerror("NotChangeDataTable","history.go(-1)");

    351. 

  351. 	}

    352. 

  352. 	$tr=$empire->fetch1("select tid,tbname,datatbs,deftb from {$dbtbpre}enewstable where tid='$tid'");

    353. 

  353. 	if(!$tr['tid'])

    354. 

  354. 	{

    355. 

  355. 		printerror("NotChangeDataTable","history.go(-1)");

    356. 

  356. 	}

    357. 

  357. 	if(!strstr($tr['datatbs'],','.$datatb.','))

    358. 

  358. 	{

    359. 

  359. 		printerror("NotChangeDataTable","history.go(-1)");

    360. 

  360. 	}

    361. 

  361. 	if($tr['deftb']==$datatb||$datatb==1)

    362. 

  362. 	{

    363. 

  363. 		printerror("NotDelDefDataTable","history.go(-1)");

    364. 

  364. 	}

    365. 

  365. 	$newdatatbs=str_replace(','.$datatb.',',',',$tr['datatbs']);

    366. 

  366. 	$sql=$empire->query("update {$dbtbpre}enewstable set datatbs='$newdatatbs' where tid='$tid'");

    367. 

  367. 	//删除信息

    368. 

  368. 	$infosql=$empire->query("select * from {$dbtbpre}ecms_".$tr[tbname]." where stb='$datatb'");

    369. 

  369. 	while($infor=$empire->fetch($infosql))

    370. 

  370. 	{

    371. 

  371. 		$mid=$class_r[$infor[classid]]['modid'];

    372. 

  372. 		$pf=$emod_r[$mid]['pagef'];

    373. 

  373. 		$stf=$emod_r[$mid]['savetxtf'];

    374. 

  374. 		//分页字段

    375. 

  375. 		if($pf)

    376. 

  376. 		{

    377. 

  377. 			if(strstr($emod_r[$mid]['tbdataf'],','.$pf.','))

    378. 

  378. 			{

    379. 

  379. 				$finfor=$empire->fetch1("select ".$pf." from {$dbtbpre}ecms_".$tr[tbname]."_data_".$datatb." where id='$infor[id]'");

    380. 

  380. 				$infor[$pf]=$finfor[$pf];

    381. 

  381. 			}

    382. 

  382. 		}

    383. 

  383. 		//存文本

    384. 

  384. 		if($stf)

    385. 

  385. 		{

    386. 

  386. 			$newstextfile=$infor[$stf];

    387. 

  387. 			$infor[$stf]=GetTxtFieldText($infor[$stf]);

    388. 

  388. 			DelTxtFieldText($newstextfile);//删除文件

    389. 

  389. 		}

    390. 

  390. 		//删除信息文件

    391. 

  391. 		DelNewsFile($infor[filename],$infor[newspath],$infor[classid],$infor[$pf],$infor[groupid]);

    392. 

  392. 		//删除其它表记录

    393. 

  393. 		$empire->query("delete from {$dbtbpre}enewswfinfo where id='$infor[id]' and classid='$infor[classid]'");

    394. 

  394. 		$empire->query("delete from {$dbtbpre}enewswfinfolog where id='$infor[id]' and classid='$infor[classid]'");

    395. 

  395. 		$empire->query("delete from {$dbtbpre}enewsinfovote where id='$infor[id]' and classid='$infor[classid]'");

    396. 

  396. 		$empire->query("delete from {$dbtbpre}enewsdiggips where id='$infor[id]' and classid='$infor[classid]'");

    397. 

  397. 		//删除附件

    398. 

  398. 		DelNewsTheFile($infor['id'],$infor['classid']);

    399. 

  399. 	}

    400. 

  400. 	$deltb=$empire->query("delete from {$dbtbpre}ecms_".$tr[tbname]." where stb='$datatb'");

    401. 

  401. 	//删除表

    402. 

  402. 	$deltb=$empire->query("DROP TABLE IF EXISTS {$dbtbpre}ecms_".$tr[tbname]."_data_".$datatb.";");

    403. 

  403. 	GetConfig(1);//更新缓存

    404. 

  404. 	if($sql)

    405. 

  405. 	{

    406. 

  406. 		//操作日志

    407. 

  407. 		insert_dolog("tid=".$tid."<br>tbname=".$tr[tbname]."&datatb=$datatb");

    408. 

  408. 		printerror("DelDataTableSuccess","db/ListDataTable.php?tid=$tid&tbname=$tr[tbname]");

    409. 

  409. 	}

    410. 

  410. 	else

    411. 

  411. 	{

    412. 

  412. 		printerror("DbError","history.go(-1)");

    413. 

  413. 	}

    414. 

  414. }

    415. 

  415. 

    416. 

  416. 

    417. 

  417. //************************************ 字段 ************************************

    418. 

  418. 

    419. 

  419. //返回字段值

    420. 

  420. function ReturnFvalue($value){

    421. 

  421. 	$value=str_replace("\r\n","|",$value);

    422. 

  422. 	return $value;

    423. 

  423. }

    424. 

  424. 

    425. 

  425. //取得表单元素html代码

    426. 

  426. function GetFform($type,$f,$fvalue,$linkfieldval,$fformsize='',$add){

    427. 

  427. 	if($type=="select"||$type=="radio"||$type=="checkbox")

    428. 

  428. 	{

    429. 

  429. 		return GetFformSelect($type,$f,$fvalue,$fformsize);

    430. 

  430. 	}

    431. 

  431. 	$file="../data/html/fhtml.txt";

    432. 

  432. 	$data=ReadFiletext($file);

    433. 

  433. 	//特殊字段

    434. 

  434. 	if($f=="newstext"||$f=="writer"||$f=="befrom"||$f=="downpath"||$f=="onlinepath"||$f=="morepic"||$f=="playerid")

    435. 

  435. 	{

    436. 

  436. 		$type=$f;

    437. 

  437. 	}

    438. 

  438. 	$exp="[!--".$type."--]";

    439. 

  439. 	$r=explode($exp,$data);

    440. 

  440. 	$string=str_replace("[!--enews.var--]",$f,$r[1]);

    441. 

  441. 	$string=str_replace("[!--enews.def.val--]",$fvalue,$string);

    442. 

  442. 	if($type=='linkfield')//选择外表关联字段

    443. 

  443. 	{

    444. 

  444. 		$string=str_replace("[!--enews.cfield.var--]",$add[linkfieldval],$string);

    445. 

  445. 		$string=str_replace("[!--enews.vfield.var--]",$add[linkfieldshow],$string);

    446. 

  446. 		$string=str_replace("[!--enews.ctbname--]",$add[linkfieldtb],$string);

    447. 

  447. 	}

    448. 

  448. 	elseif($type=='linkfieldselect')//下拉外表关联字段

    449. 

  449. 	{

    450. 

  450. 		$selectf=$add[linkfieldval]==$add[linkfieldshow]?$add[linkfieldval]:$add[linkfieldval].','.$add[linkfieldshow];

    451. 

  451. 		$string=str_replace("[!--enews.cfield.var--]",$add[linkfieldval],$string);

    452. 

  452. 		$string=str_replace("[!--enews.vfield.var--]",$add[linkfieldshow],$string);

    453. 

  453. 		$string=str_replace("[!--enews.ctbname--]",$add[linkfieldtb],$string);

    454. 

  454. 		$string=str_replace("[!--enews.selectf--]",$selectf,$string);

    455. 

  455. 	}

    456. 

  456. 	elseif($type=='editor'||$type=='newstext')//编辑器

    457. 

  457. 	{

    458. 

  458. 		$editortype=$add[editorys]==0?'Default':'Basic';

    459. 

  459. 		$string=str_replace("[!--editor.type--]",$editortype,$string);

    460. 

  460. 		$string=str_replace("[!--editor.basepath--]",'',$string);

    461. 

  461. 	}

    462. 

  462. 	$string=RepFformSize($f,$string,$type,$fformsize);

    463. 

  463. 	return addslashes($string);

    464. 

  464. }

    465. 

  465. 

    466. 

  466. //取得采集表单元素html代码

    467. 

  467. function GetCjform($type,$f){

    468. 

  468. 	$file="../data/html/cjhtml.txt";

    469. 

  469. 	$data=ReadFiletext($file);

    470. 

  470. 	//特殊字段

    471. 

  471. 	if($f=="downpath"||$f=="onlinepath"||$f=="morepic"||$f=="playerid")

    472. 

  472. 	{

    473. 

  473. 		$type=$f;

    474. 

  474. 	}

    475. 

  475. 	if($type=="password"||$type=="select"||$type=="radio"||$type=="checkbox"||$type=="date"||$type=="color"||$type=="linkfield"||$type=="editor"||$type=="ubbeditor"||$type=="linkfieldselect")

    476. 

  476. 	{

    477. 

  477. 		$type="text";

    478. 

  478. 	}

    479. 

  479. 	$exp="[!--".$type."--]";

    480. 

  480. 	$r=explode($exp,$data);

    481. 

  481. 	$string=str_replace("[!--enews.var--]",$f,$r[1]);

    482. 

  482. 	return addslashes($string);

    483. 

  483. }

    484. 

  484. 

    485. 

  485. //取得投稿表单元素html代码

    486. 

  486. function GetQFform($type,$f,$fvalue,$fformsize='',$add){

    487. 

  487. 	if($type=="select"||$type=="radio"||$type=="checkbox")

    488. 

  488. 	{

    489. 

  489. 		return GetFformSelect($type,$f,$fvalue,$fformsize);

    490. 

  490. 	}

    491. 

  491. 	$file="../data/html/qfhtml.txt";

    492. 

  492. 	$data=ReadFiletext($file);

    493. 

  493. 	//特殊字段

    494. 

  494. 	if($f=="newstext"||$f=="downpath"||$f=="onlinepath"||$f=="morepic"||$f=="playerid")

    495. 

  495. 	{

    496. 

  496. 		$type=$f;

    497. 

  497. 	}

    498. 

  498. 	$exp="[!--".$type."--]";

    499. 

  499. 	$r=explode($exp,$data);

    500. 

  500. 	$string=str_replace("[!--enews.var--]",$f,$r[1]);

    501. 

  501. 	$string=str_replace("[!--enews.def.val--]",$fvalue,$string);

    502. 

  502. 	if($type=='linkfield')//选择外表关联字段

    503. 

  503. 	{

    504. 

  504. 		$string=str_replace("[!--enews.cfield.var--]",$add[linkfieldval],$string);

    505. 

  505. 		$string=str_replace("[!--enews.vfield.var--]",$add[linkfieldshow],$string);

    506. 

  506. 		$string=str_replace("[!--enews.ctbname--]",$add[linkfieldtb],$string);

    507. 

  507. 	}

    508. 

  508. 	elseif($type=='linkfieldselect')//下拉外表关联字段

    509. 

  509. 	{

    510. 

  510. 		$selectf=$add[linkfieldval]==$add[linkfieldshow]?$add[linkfieldval]:$add[linkfieldval].','.$add[linkfieldshow];

    511. 

  511. 		$string=str_replace("[!--enews.cfield.var--]",$add[linkfieldval],$string);

    512. 

  512. 		$string=str_replace("[!--enews.vfield.var--]",$add[linkfieldshow],$string);

    513. 

  513. 		$string=str_replace("[!--enews.ctbname--]",$add[linkfieldtb],$string);

    514. 

  514. 		$string=str_replace("[!--enews.selectf--]",$selectf,$string);

    515. 

  515. 	}

    516. 

  516. 	elseif($type=='editor'||$type=='newstext')//编辑器

    517. 

  517. 	{

    518. 

  518. 		$editortype=$add[editorys]==0?'Default':'Basic';

    519. 

  519. 		$string=str_replace("[!--editor.type--]",$editortype,$string);

    520. 

  520. 		$string=str_replace("[!--editor.basepath--]",'',$string);

    521. 

  521. 	}

    522. 

  522. 	$string=RepFformSize($f,$string,$type,$fformsize);

    523. 

  523. 	return addslashes($string);

    524. 

  524. }

    525. 

  525. 

    526. 

  526. //取得select/radio元素代码

    527. 

  527. function GetFformSelect($type,$f,$fvalue,$fformsize=''){

    528. 

  528. 	$vr=explode("|",$fvalue);

    529. 

  529. 	$count=count($vr);

    530. 

  530. 	$change="";

    531. 

  531. 	$def=':default';

    532. 

  532. 	for($i=0;$i<$count;$i++)

    533. 

  533. 	{

    534. 

  534. 		$val=$vr[$i];

    535. 

  535. 		$isdef="";

    536. 

  536. 		if(strstr($val,$def))

    537. 

  537. 		{

    538. 

  538. 			$dr=explode($def,$val);

    539. 

  539. 			$val=$dr[0];

    540. 

  540. 			$isdef="||\$ecmsfirstpost==1";

    541. 

  541. 		}

    542. 

  542. 		if($type=='select')

    543. 

  543. 		{

    544. 

  544. 			$change.="<option value=\"".$val."\"<?=\$r[".$f."]==\"".$val."\"".$isdef."?' selected':''?>>".$val."</option>";

    545. 

  545. 		}

    546. 

  546. 		elseif($type=='checkbox')

    547. 

  547. 		{

    548. 

  548. 			$change.="<input name=\"".$f."[]\" type=\"checkbox\" value=\"".$val."\"<?=strstr(\$r[".$f."],\"|".$val."|\")".$isdef."?' checked':''?>>".$val;

    549. 

  549. 		}

    550. 

  550. 		else

    551. 

  551. 		{

    552. 

  552. 			$change.="<input name=\"".$f."\" type=\"radio\" value=\"".$val."\"<?=\$r[".$f."]==\"".$val."\"".$isdef."?' checked':''?>>".$val;

    553. 

  553. 		}

    554. 

  554. 	}

    555. 

  555. 	if($type=="select")

    556. 

  556. 	{

    557. 

  557. 		if($fformsize)

    558. 

  558. 		{

    559. 

  559. 			$addsize=' style="width:'.$fformsize.'"';

    560. 

  560. 		}

    561. 

  561. 		$change="<select name=\"".$f."\" id=\"".$f."\"".$addsize.">".$change."</select>";

    562. 

  562. 	}

    563. 

  563. 	return $change;

    564. 

  564. }

    565. 

  565. 

    566. 

  566. //替换表单元素长度

    567. 

  567. function RepFformSize($f,$string,$type,$fformsize=''){

    568. 

  568. 	$fformsize=ReturnDefFformSize($f,$type,$fformsize);

    569. 

  569. 	if($type=='textarea'||$type=='editor'||$type=='ubbeditor'||$type=='newstext')

    570. 

  570. 	{

    571. 

  571. 		$r=explode(',',$fformsize);

    572. 

  572. 		$string=str_replace('[!--fsize.w--]',$r[0],$string);

    573. 

  573. 		$string=str_replace('[!--fsize.h--]',$r[1],$string);

    574. 

  574. 	}

    575. 

  575. 	else

    576. 

  576. 	{

    577. 

  577. 		$string=str_replace('[!--fsize.w--]',$fformsize,$string);

    578. 

  578. 	}

    579. 

  579. 	return $string;

    580. 

  580. }

    581. 

  581. 

    582. 

  582. //返回默认长度

    583. 

  583. function ReturnDefFformSize($f,$type,$fformsize){

    584. 

  584. 	if(empty($fformsize))

    585. 

  585. 	{

    586. 

  586. 		if($type=='textarea')

    587. 

  587. 		{

    588. 

  588. 			$fformsize='60,10';

    589. 

  589. 		}

    590. 

  590. 		elseif($type=='img')

    591. 

  591. 		{

    592. 

  592. 			$fformsize='45';

    593. 

  593. 		}

    594. 

  594. 		elseif($type=='file')

    595. 

  595. 		{

    596. 

  596. 			$fformsize='45';

    597. 

  597. 		}

    598. 

  598. 		elseif($type=='flash')

    599. 

  599. 		{

    600. 

  600. 			$fformsize='45';

    601. 

  601. 		}

    602. 

  602. 		elseif($type=='date')

    603. 

  603. 		{

    604. 

  604. 			$fformsize='12';

    605. 

  605. 		}

    606. 

  606. 		elseif($type=='color')

    607. 

  607. 		{

    608. 

  608. 			$fformsize='10';

    609. 

  609. 		}

    610. 

  610. 		elseif($type=='linkfield')

    611. 

  611. 		{

    612. 

  612. 			$fformsize='45';

    613. 

  613. 		}

    614. 

  614. 		elseif($type=='downpath')

    615. 

  615. 		{

    616. 

  616. 			$fformsize='45';

    617. 

  617. 		}

    618. 

  618. 		elseif($type=='onlinepath')

    619. 

  619. 		{

    620. 

  620. 			$fformsize='45';

    621. 

  621. 		}

    622. 

  622. 		elseif($type=='editor'||$type=='newstext')

    623. 

  623. 		{

    624. 

  624. 			$fformsize='100%,300';

    625. 

  625. 		}

    626. 

  626. 		elseif($type=='ubbeditor')

    627. 

  627. 		{

    628. 

  628. 			$fformsize='60,10';

    629. 

  629. 		}

    630. 

  630. 	}

    631. 

  631. 	return $fformsize;

    632. 

  632. }

    633. 

  633. 

    634. 

  634. //返回字段变量

    635. 

  635. function DoPostFVar($add){

    636. 

  636. 	$add['tid']=(int)$add['tid'];

    637. 

  637. 	$add['tbname']=RepPostVar($add['tbname']);

    638. 

  638. 	$add['f']=RepPostVar($add['f']);

    639. 

  639. 	//处理变量

    640. 

  640. 	$add[iscj]=(int)$add[iscj];

    641. 

  641. 	$add[myorder]=(int)$add[myorder];

    642. 

  642. 	$add[savetxt]=(int)$add[savetxt];

    643. 

  643. 	$add[iskey]=(int)$add[iskey];

    644. 

  644. 	$add[tobr]=(int)$add[tobr];

    645. 

  645. 	$add[dohtml]=(int)$add[dohtml];

    646. 

  646. 	$add[isonly]=(int)$add[isonly];

    647. 

  647. 	$add[samedata]=(int)$add[samedata];

    648. 

  648. 	$add[tbdataf]=(int)$add[tbdataf];

    649. 

  649. 	$add[ispage]=(int)$add[ispage];

    650. 

  650. 	$add[editorys]=(int)$add[editorys];

    651. 

  651. 	$add[issmalltext]=(int)$add[issmalltext];

    652. 

  652. 	if($add[fform]=='textarea'||$add[fform]=='editor')

    653. 

  653. 	{

    654. 

  654. 		if($add[fformwidth]||$add[fformheight])

    655. 

  655. 		{

    656. 

  656. 			$add['fformsize']=$add[fformwidth].','.$add[fformheight];

    657. 

  657. 		}

    658. 

  658. 	}

    659. 

  659. 	return $add;

    660. 

  660. }

    661. 

  661. 

    662. 

  662. //验证字段是否重复

    663. 

  663. function CheckReTbF($add,$ecms=0){

    664. 

  664. 	global $empire,$dbtbpre;

    665. 

  665. 	$specialf=',oldurl,tmptime,smallurl,newsurl,titlepicl,';

    666. 

  666. 	if(stristr($specialf,','.$add[f].','))

    667. 

  667. 	{

    668. 

  668. 		printerror("ReF","history.go(-1)");

    669. 

  669. 	}

    670. 

  670. 	//修改

    671. 

  671. 	if($ecms==1&&$add[f]==$add[oldf])

    672. 

  672. 	{

    673. 

  673. 		return '';

    674. 

  674. 	}

    675. 

  675. 	//主表

    676. 

  676. 	$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}ecms_".$add[tbname]);

    677. 

  677. 	$b=0;

    678. 

  678. 	while($r=$empire->fetch($s))

    679. 

  679. 	{

    680. 

  680. 		if($r[Field]==$add[f])

    681. 

  681. 		{

    682. 

  682. 			$b=1;

    683. 

  683. 			break;

    684. 

  684. 		}

    685. 

  685.     }

    686. 

  686. 	if($b)

    687. 

  687. 	{

    688. 

  688. 		printerror("ReF","history.go(-1)");

    689. 

  689. 	}

    690. 

  690. 	//副表

    691. 

  691. 	$s=$empire->query("SHOW FIELDS FROM {$dbtbpre}ecms_".$add[tbname]."_data_1");

    692. 

  692. 	$b=0;

    693. 

  693. 	while($r=$empire->fetch($s))

    694. 

  694. 	{

    695. 

  695. 		if($r[Field]==$add[f])

    696. 

  696. 		{

    697. 

  697. 			$b=1;

    698. 

  698. 			break;

    699. 

  699. 		}

    700. 

  700.     }

    701. 

  701. 	if($b)

    702. 

  702. 	{

    703. 

  703. 		printerror("ReF","history.go(-1)");

    704. 

  704. 	}

    705. 

  705. }

    706. 

  706. 

    707. 

  707. //返回字段类型

    708. 

  708. function ReturnTbFtype($add){

    709. 

  709. 	if($add[ftype]=="TINYINT"||$add[ftype]=="SMALLINT"||$add[ftype]=="INT"||$add[ftype]=="BIGINT"||$add[ftype]=="FLOAT"||$add[ftype]=="DOUBLE")

    710. 

  710. 	{

    711. 

  711. 		$def=" default '0'";

    712. 

  712. 	}

    713. 

  713. 	elseif($add[ftype]=="VARCHAR"||$add[ftype]=="CHAR")

    714. 

  714. 	{

    715. 

  715. 		$def=" default ''";

    716. 

  716. 	}

    717. 

  717. 	elseif($add[ftype]=="DATE")

    718. 

  718. 	{

    719. 

  719. 		$def=" default '0000-00-00'";

    720. 

  720. 	}

    721. 

  721. 	elseif($add[ftype]=="DATETIME")

    722. 

  722. 	{

    723. 

  723. 		$def=" default '0000-00-00 00:00:00'";

    724. 

  724. 	}

    725. 

  725. 	else

    726. 

  726. 	{

    727. 

  727. 		$def='';

    728. 

  728. 	}

    729. 

  729. 	$type=$add[ftype];

    730. 

  730. 	//VARCHAR

    731. 

  731. 	if(($add[ftype]=='VARCHAR'||$add[ftype]=='CHAR')&&empty($add[flen]))

    732. 

  732. 	{

    733. 

  733. 		$add[flen]='255';

    734. 

  734. 	}

    735. 

  735. 	//字段长度

    736. 

  736. 	if($add[flen])

    737. 

  737. 	{

    738. 

  738. 		if($add[ftype]!="TEXT"&&$add[ftype]!="MEDIUMTEXT"&&$add[ftype]!="LONGTEXT"&&$add[ftype]!="DATE"&&$add[ftype]!="DATETIME")

    739. 

  739. 		{

    740. 

  740. 			$type.="(".$add[flen].")";

    741. 

  741. 		}

    742. 

  742. 	}

    743. 

  743. 	$field=$add[f]." ".$type." NOT NULL".$def;

    744. 

  744. 	return $field;

    745. 

  745. }

    746. 

  746. 

    747. 

  747. //增加字段

    748. 

  748. function AddF($add,$userid,$username){

    749. 

  749. 	global $empire,$dbtbpre;

    750. 

  750. 	$add=DoPostFVar($add);

    751. 

  751. 	$tid=$add[tid];

    752. 

  752. 	$tbname=$add[tbname];

    753. 

  753. 	if(empty($add[f])||empty($add[fname])||!$add[tid]||!$add[tbname])

    754. 

  754. 	{

    755. 

  755. 		printerror("EmptyF","history.go(-1)");

    756. 

  756. 	}

    757. 

  757. 	CheckLevel($userid,$username,$classid,"f");//验证权限

    758. 

  758. 	CheckReTbF($add,0);//字段是否重复

    759. 

  759. 	//存文本

    760. 

  760. 	if($add[savetxt]==1)

    761. 

  761. 	{

    762. 

  762. 		$txtnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsf where savetxt=1 and tid='$tid'");

    763. 

  763. 		if($txtnum)

    764. 

  764. 		{

    765. 

  765. 			printerror('ReTxtF','');

    766. 

  766. 		}

    767. 

  767. 	}

    768. 

  768. 	//分页

    769. 

  769. 	if($add['ispage']==1)

    770. 

  770. 	{

    771. 

  771. 		$pagenum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsf where ispage=1 and tid='$tid'");

    772. 

  772. 		if($pagenum)

    773. 

  773. 		{

    774. 

  774. 			printerror('RePageF','');

    775. 

  775. 		}

    776. 

  776. 	}

    777. 

  777. 	$add[fvalue]=ReturnFvalue($add[fvalue]);//初始化值

    778. 

  778. 	$field=ReturnTbFtype($add);//返回字段

    779. 

  779. 	//信息表新增字段

    780. 

  780. 	if($add[tbdataf]==1)//附加表

    781. 

  781. 	{

    782. 

  782. 		$tbr=$empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='$tid'");

    783. 

  783. 		if($tbr['datatbs'])

    784. 

  784. 		{

    785. 

  785. 			$dtbr=explode(',',$tbr['datatbs']);

    786. 

  786. 			$count=count($dtbr);

    787. 

  787. 			for($i=1;$i<$count-1;$i++)

    788. 

  788. 			{

    789. 

  789. 				$empire->query("alter table {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." add ".$field);

    790. 

  790. 				if($add[iskey]==1)//索引

    791. 

  791. 				{

    792. 

  792. 					$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." ADD INDEX(".$add[f].")");

    793. 

  793. 				}

    794. 

  794. 			}

    795. 

  795. 		}

    796. 

  796. 		//归档副表

    797. 

  797. 		$asql=$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc_data add ".$field);

    798. 

  798. 		if($add[iskey]==1)//索引

    799. 

  799. 		{

    800. 

  800. 			$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc_data ADD INDEX(".$add[f].")");

    801. 

  801. 		}

    802. 

  802. 	}

    803. 

  803. 	else//主表

    804. 

  804. 	{

    805. 

  805. 		$asql=$empire->query("alter table {$dbtbpre}ecms_".$tbname." add ".$field);

    806. 

  806. 		if($add[iskey]==1)//索引

    807. 

  807. 		{

    808. 

  808. 			$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." ADD INDEX(".$add[f].")");

    809. 

  809. 		}

    810. 

  810. 		//归档主表

    811. 

  811. 		$asql=$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc add ".$field);

    812. 

  812. 		if($add[iskey]==1)//索引

    813. 

  813. 		{

    814. 

  814. 			$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc ADD INDEX(".$add[f].")");

    815. 

  815. 		}

    816. 

  816. 	}

    817. 

  817. 	//采集表新增字段

    818. 

  818. 	if($add[iscj]==1)

    819. 

  819. 	{

    820. 

  820. 		$asql=$empire->query("alter table {$dbtbpre}ecms_infoclass_".$tbname." add zz_".$add[f]." text not null,add z_".$add[f]." varchar(255) not null,add qz_".$add[f]." varchar(255) not null,add save_".$add[f]." varchar(10) not null;");

    821. 

  821. 		$asql=$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." add ".$field);

    822. 

  822. 	}

    823. 

  823. 	//替换代码

    824. 

  824. 	$fhtml=GetFform($add[fform],$add[f],$add[fvalue],$add[linkfieldval],$add[fformsize],$add);

    825. 

  825. 	$cjhtml=GetCjform($add[fform],$add[f]);

    826. 

  826. 	$qfhtml=GetQFform($add[fform],$add[f],$add[fvalue],$add[fformsize],$add);

    827. 

  827. 	$sql=$empire->query("insert into {$dbtbpre}enewsf(f,fname,fform,fhtml,fzs,isadd,isshow,iscj,cjhtml,myorder,ftype,flen,dotemp,tid,tbname,savetxt,fvalue,iskey,tobr,dohtml,qfhtml,isonly,linkfieldval,samedata,fformsize,tbdataf,ispage,adddofun,editdofun,qadddofun,qeditdofun,linkfieldtb,linkfieldshow,editorys,issmalltext) values('$add[f]','$add[fname]','$add[fform]','".addslashes($fhtml)."','".addslashes($add[fzs])."',1,1,$add[iscj],'".addslashes($cjhtml)."',$add[myorder],'$add[ftype]','$add[flen]',1,$tid,'$tbname',$add[savetxt],'".addslashes($add[fvalue])."',$add[iskey],$add[tobr],$add[dohtml],'".addslashes($qfhtml)."','$add[isonly]','".addslashes($add[linkfieldval])."','$add[samedata]','$add[fformsize]','$add[tbdataf]','$add[ispage]','$add[adddofun]','$add[editdofun]','$add[qadddofun]','$add[qeditdofun]','$add[linkfieldtb]','$add[linkfieldshow]','$add[editorys]','$add[issmalltext]');");

    828. 

  828. 	$lastid=$empire->lastid();

    829. 

  829. 	TogSaveTxtF(1);//公共变量

    830. 

  830. 	if($add[savetxt]==1&&$add[iscj]==1)//存放文本

    831. 

  831. 	{

    832. 

  832. 		$tmpsql=$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." change ".$add[f]." ".$add[f]." mediumtext not null;");

    833. 

  833. 	}

    834. 

  834. 	GetConfig(1);//更新缓存

    835. 

  835. 	if($sql)

    836. 

  836. 	{

    837. 

  837. 		insert_dolog("fid=".$lastid."<br>f=".$add[f]);//操作日志

    838. 

  838. 		printerror("AddFSuccess","db/AddF.php?enews=AddF&tid=$tid&tbname=$tbname");

    839. 

  839. 	}

    840. 

  840. 	else

    841. 

  841. 	{

    842. 

  842. 		printerror("DbError","history.go(-1)");

    843. 

  843. 	}

    844. 

  844. }

    845. 

  845. 

    846. 

  846. //修改数据库字段

    847. 

  847. function EditF($add,$userid,$username){

    848. 

  848. 	global $empire,$dbtbpre;

    849. 

  849. 	$add=DoPostFVar($add);

    850. 

  850. 	$tid=$add[tid];

    851. 

  851. 	$tbname=$add[tbname];

    852. 

  852. 	$add[fid]=(int)$add['fid'];

    853. 

  853. 	if(empty($add[f])||empty($add[fname])||empty($add[fid])||!$tid||!$tbname)

    854. 

  854. 	{

    855. 

  855. 		printerror("EmptyF","history.go(-1)");

    856. 

  856. 	}

    857. 

  857. 	CheckLevel($userid,$username,$classid,"f");//验证权限

    858. 

  858. 	//是否系统内部字段

    859. 

  859. 	$cr=$empire->fetch1("select * from {$dbtbpre}enewsf where fid='$add[fid]'");

    860. 

  860. 	if(empty($cr[isadd]))

    861. 

  861. 	{

    862. 

  862. 		printerror("NotIsAdd","history.go(-1)");

    863. 

  863. 	}

    864. 

  864. 	CheckReTbF($add,1);//字段是否重复

    865. 

  865. 	//存文本

    866. 

  866. 	if($add[savetxt]==1&&!$cr[savetxt])

    867. 

  867. 	{

    868. 

  868. 		$txtnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsf where savetxt=1 and fid<>".$add[fid]." and tid='$tid'");

    869. 

  869. 		if($txtnum)

    870. 

  870. 		{

    871. 

  871. 			printerror('ReTxtF','');

    872. 

  872. 		}

    873. 

  873. 	}

    874. 

  874. 	//分页

    875. 

  875. 	if($add['ispage']==1&&!$cr[ispage])

    876. 

  876. 	{

    877. 

  877. 		$pagenum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsf where ispage=1 and fid<>".$add[fid]." and tid='$tid'");

    878. 

  878. 		if($pagenum)

    879. 

  879. 		{

    880. 

  880. 			printerror('RePageF','');

    881. 

  881. 		}

    882. 

  882. 	}

    883. 

  883. 	$add[fvalue]=ReturnFvalue($add[fvalue]);//初始化值

    884. 

  884. 	//改变字段

    885. 

  885. 	if($cr[f]<>$add[f]||$add[iskey]<>$cr[iskey]||$cr[iscj]<>$add[iscj]||$cr[ftype]<>$add[ftype]||$cr[flen]<>$add[flen])

    886. 

  886. 	{

    887. 

  887. 		$field=ReturnTbFtype($add);//返回字段

    888. 

  888. 		//信息表

    889. 

  889. 		if($cr[tbdataf]==1)//附加表

    890. 

  890. 		{

    891. 

  891. 			$tbr=$empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='$tid'");

    892. 

  892. 			if($tbr['datatbs'])

    893. 

  893. 			{

    894. 

  894. 				$dtbr=explode(',',$tbr['datatbs']);

    895. 

  895. 				$count=count($dtbr);

    896. 

  896. 				for($i=1;$i<$count-1;$i++)

    897. 

  897. 				{

    898. 

  898. 					$empire->query("alter table {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." change ".$add[oldf]." ".$field);

    899. 

  899. 					if($add[iskey]==1)//索引

    900. 

  900. 					{

    901. 

  901. 						if($cr[iskey]==0)

    902. 

  902. 						{

    903. 

  903. 							$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." ADD INDEX(".$add[f].")");

    904. 

  904. 						}

    905. 

  905. 					}

    906. 

  906. 					elseif($cr[iskey]==1&&$add[iskey]==0)//删除索引

    907. 

  907. 					{

    908. 

  908. 						$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." DROP INDEX ".$add[oldf]);

    909. 

  909. 					}

    910. 

  910. 				}

    911. 

  911. 			}

    912. 

  912. 			//归档副表

    913. 

  913. 			$usql=$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc_data change ".$add[oldf]." ".$field);

    914. 

  914. 			if($add[iskey]==1)//索引

    915. 

  915. 			{

    916. 

  916. 				if($cr[iskey]==0)

    917. 

  917. 				{

    918. 

  918. 					$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc_data ADD INDEX(".$add[f].")");

    919. 

  919. 				}

    920. 

  920. 			}

    921. 

  921. 			elseif($cr[iskey]==1&&$add[iskey]==0)//删除索引

    922. 

  922. 			{

    923. 

  923. 				$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc_data DROP INDEX ".$add[oldf]);

    924. 

  924. 			}

    925. 

  925. 		}

    926. 

  926. 		else//主表

    927. 

  927. 		{

    928. 

  928. 			$usql=$empire->query("alter table {$dbtbpre}ecms_".$tbname." change ".$add[oldf]." ".$field);

    929. 

  929. 			if($add[iskey]==1)//索引

    930. 

  930. 			{

    931. 

  931. 				if($cr[iskey]==0)

    932. 

  932. 				{

    933. 

  933. 					$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." ADD INDEX(".$add[f].")");

    934. 

  934. 				}

    935. 

  935. 			}

    936. 

  936. 			elseif($cr[iskey]==1&&$add[iskey]==0)//删除索引

    937. 

  937. 			{

    938. 

  938. 				$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." DROP INDEX ".$add[oldf]);

    939. 

  939. 			}

    940. 

  940. 			//归档主表

    941. 

  941. 			$usql=$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc change ".$add[oldf]." ".$field);

    942. 

  942. 			if($add[iskey]==1)//索引

    943. 

  943. 			{

    944. 

  944. 				if($cr[iskey]==0)

    945. 

  945. 				{

    946. 

  946. 					$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc ADD INDEX(".$add[f].")");

    947. 

  947. 				}

    948. 

  948. 			}

    949. 

  949. 			elseif($cr[iskey]==1&&$add[iskey]==0)//删除索引

    950. 

  950. 			{

    951. 

  951. 				$keysql=$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc DROP INDEX ".$add[oldf]);

    952. 

  952. 			}

    953. 

  953. 		}

    954. 

  954. 		//采集表

    955. 

  955. 		if($add[iscj]==1)

    956. 

  956. 		{

    957. 

  957. 			if($cr[iscj]==1)

    958. 

  958. 			{

    959. 

  959. 				$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." change ".$add[oldf]." ".$field);

    960. 

  960. 				$empire->query("alter table {$dbtbpre}ecms_infoclass_".$tbname." change zz_".$add[oldf]." zz_".$add[f]." text not null,change z_".$add[oldf]." z_".$add[f]." varchar(255) not null,change qz_".$add[oldf]." qz_".$add[f]." varchar(255) not null,change save_".$add[oldf]." save_".$add[f]." varchar(10) not null;");

    961. 

  961. 			}

    962. 

  962. 			else

    963. 

  963. 			{

    964. 

  964. 				$empire->query("alter table {$dbtbpre}ecms_infoclass_".$tbname." add zz_".$add[f]." text not null,add z_".$add[f]." varchar(255) not null,add qz_".$add[f]." varchar(255) not null,add save_".$add[f]." varchar(10) not null;");

    965. 

  965. 				$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." add ".$field);

    966. 

  966. 			}

    967. 

  967. 		}

    968. 

  968. 		elseif($add[iscj]==0&&$cr[iscj]==1)

    969. 

  969. 		{

    970. 

  970. 			$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." drop COLUMN ".$cr[f]);

    971. 

  971. 			$empire->query("alter table {$dbtbpre}ecms_infoclass_".$tbname." drop COLUMN zz_".$cr[f].",drop COLUMN z_".$cr[f].",drop COLUMN qz_".$cr[f].",drop COLUMN save_".$cr[f]);

    972. 

  972. 		}

    973. 

  973. 	}

    974. 

  974. 	//替换代码

    975. 

  975. 	if($add[f]<>$cr[f]||$add[fform]<>$cr[fform]||$add[fvalue]<>$add[oldfvalue]||$cr[linkfieldtb]<>$add[linkfieldtb]||$cr[linkfieldshow]<>$add[linkfieldshow]||$cr[editorys]<>$add[editorys]||$add[linkfieldval]<>$cr[linkfieldval]||$add[fformsize]<>$cr[fformsize])

    976. 

  976. 	{

    977. 

  977. 		$fhtml=GetFform($add[fform],$add[f],$add[fvalue],$add[linkfieldval],$add[fformsize],$add);

    978. 

  978. 	}

    979. 

  979. 	else

    980. 

  980. 	{

    981. 

  981. 		$fhtml=AddAddsData($add[fhtml]);

    982. 

  982. 	}

    983. 

  983. 	$cjhtml=GetCjform($add[fform],$add[f]);

    984. 

  984. 	if($add[f]<>$cr[f]||$add[fform]<>$cr[fform]||$add[fvalue]<>$add[oldfvalue]||$cr[linkfieldtb]<>$add[linkfieldtb]||$cr[linkfieldshow]<>$add[linkfieldshow]||$cr[editorys]<>$add[editorys]||$add[linkfieldval]<>$cr[linkfieldval]||$add[fformsize]<>$cr[fformsize])

    985. 

  985. 	{

    986. 

  986. 		$qfhtml=GetQFform($add[fform],$add[f],$add[fvalue],$add[fformsize],$add);

    987. 

  987. 	}

    988. 

  988. 	else

    989. 

  989. 	{

    990. 

  990. 		$qfhtml=AddAddsData($add[qfhtml]);

    991. 

  991. 	}

    992. 

  992. 	$sql=$empire->query("update {$dbtbpre}enewsf set f='$add[f]',fname='$add[fname]',fform='$add[fform]',fhtml='".addslashes($fhtml)."',fzs='".addslashes($add[fzs])."',iscj=$add[iscj],cjhtml='".addslashes($cjhtml)."',myorder=$add[myorder],ftype='$add[ftype]',flen='$add[flen]',fvalue='".addslashes($add[fvalue])."',iskey=$add[iskey],tobr=$add[tobr],dohtml=$add[dohtml],qfhtml='".addslashes($qfhtml)."',isonly='$add[isonly]',linkfieldval='$add[linkfieldval]',samedata='$add[samedata]',fformsize='$add[fformsize]',ispage='$add[ispage]',adddofun='$add[adddofun]',editdofun='$add[editdofun]',qadddofun='$add[qadddofun]',qeditdofun='$add[qeditdofun]',linkfieldtb='$add[linkfieldtb]',linkfieldshow='$add[linkfieldshow]',editorys='$add[editorys]',issmalltext='$add[issmalltext]' where fid='$add[fid]'");

    993. 

  993. 	TogSaveTxtF(1);//公共变量

    994. 

  994. 	if($add[savetxt]==1&&$add[iscj]==1)

    995. 

  995. 	{

    996. 

  996. 		$tmpsql=$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." change ".$add[f]." ".$add[f]." mediumtext not null;");

    997. 

  997. 	}

    998. 

  998. 	//更新表单

    999. 

  999. 	$record="<!--record-->";

    1000. 

  1000.     $field="<!--field--->";

    1001. 

  1001. 	$like=$field.$add[oldf].$record;

    1002. 

  1002. 	$newlike=$field.$add[f].$record;

    1003. 

  1003. 	$slike=",".$add[oldf].",";

    1004. 

  1004. 	$newslike=",".$add[f].",";

    1005. 

  1005. 	$fsql=$empire->query("select mid,mtemp,cj,enter,tempvar,searchvar,tid,qenter,mustqenterf,qmtemp,listandf,listtempvar,canaddf,caneditf,orderf from {$dbtbpre}enewsmod where tid='$tid'");

    1006. 

  1006. 	while($fr=$empire->fetch($fsql))

    1007. 

  1007. 	{

    1008. 

  1008. 		$and="";

    1009. 

  1009. 		$enter=$fr['enter'];

    1010. 

  1010. 		if($add[f]<>$add[oldf])

    1011. 

  1011. 		{

    1012. 

  1012. 			//采集项

    1013. 

  1013. 			if(strstr($fr[cj],$like))

    1014. 

  1014. 			{

    1015. 

  1015. 				$cj=str_replace($like,$newlike,$fr[cj]);

    1016. 

  1016. 				$and=",cj='$cj'";

    1017. 

  1017. 				ChangeMCj($fr[mid],$fr[tid],$cj);

    1018. 

  1018. 			}

    1019. 

  1019. 			//录入项

    1020. 

  1020. 			if(strstr($fr[enter],$like))

    1021. 

  1021. 			{

    1022. 

  1022. 				$enter=str_replace($like,$newlike,$fr[enter]);

    1023. 

  1023. 				$and.=",enter='$enter'";

    1024. 

  1024. 			}

    1025. 

  1025. 			//投稿项

    1026. 

  1026. 			if(strstr($fr[qenter],$like))

    1027. 

  1027. 			{

    1028. 

  1028. 				$qenter=str_replace($like,$newlike,$fr[qenter]);

    1029. 

  1029. 				$and.=",qenter='$qenter'";

    1030. 

  1030. 			}

    1031. 

  1031. 			//内容模板项

    1032. 

  1032. 			if(strstr($fr[tempvar],$like))

    1033. 

  1033. 			{

    1034. 

  1034. 				$tempvar=str_replace($like,$newlike,$fr[tempvar]);

    1035. 

  1035. 				$and.=",tempvar='$tempvar'";

    1036. 

  1036. 			}

    1037. 

  1037. 			//列表模板项

    1038. 

  1038. 			if(strstr($fr[listtempvar],$like))

    1039. 

  1039. 			{

    1040. 

  1040. 				$listtempvar=str_replace($like,$newlike,$fr[listtempvar]);

    1041. 

  1041. 				$and.=",listtempvar='$listtempvar'";

    1042. 

  1042. 			}

    1043. 

  1043. 			//搜索项

    1044. 

  1044. 			if(strstr($fr[searchvar],$slike))

    1045. 

  1045. 			{

    1046. 

  1046. 				$searchvar=str_replace($slike,$newslike,$fr[searchvar]);

    1047. 

  1047. 				$and.=",searchvar='$searchvar'";

    1048. 

  1048. 			}

    1049. 

  1049. 			//必填项

    1050. 

  1050. 			if(strstr($fr[mustqenterf],$slike))

    1051. 

  1051. 			{

    1052. 

  1052. 				$mustqenterf=str_replace($slike,$newslike,$fr[mustqenterf]);

    1053. 

  1053. 				$and.=",mustqenterf='$mustqenterf'";

    1054. 

  1054. 			}

    1055. 

  1055. 			//结合项

    1056. 

  1056. 			if(strstr($fr[listandf],$slike))

    1057. 

  1057. 			{

    1058. 

  1058. 				$listandf=str_replace($slike,$newslike,$fr[listandf]);

    1059. 

  1059. 				$and.=",listandf='$listandf'";

    1060. 

  1060. 			}

    1061. 

  1061. 			//排序项

    1062. 

  1062. 			if(strstr($fr[orderf],$slike))

    1063. 

  1063. 			{

    1064. 

  1064. 				$orderf=str_replace($slike,$newslike,$fr[orderf]);

    1065. 

  1065. 				$and.=",orderf='$orderf'";

    1066. 

  1066. 			}

    1067. 

  1067. 			//可修改

    1068. 

  1068. 			if(strstr($fr[caneditf],$slike))

    1069. 

  1069. 			{

    1070. 

  1070. 				$caneditf=str_replace($slike,$newslike,$fr[caneditf]);

    1071. 

  1071. 				$and.=",caneditf='$caneditf'";

    1072. 

  1072. 			}

    1073. 

  1073. 			//可增加

    1074. 

  1074. 			if(strstr($fr[canaddf],$slike))

    1075. 

  1075. 			{

    1076. 

  1076. 				$canaddf=str_replace($slike,$newslike,$fr[canaddf]);

    1077. 

  1077. 				$and.=",canaddf='$canaddf'";

    1078. 

  1078. 			}

    1079. 

  1079. 			//表单模板

    1080. 

  1080. 			if(strstr($fr[mtemp],'[!--'.$add[oldf].'--]'))

    1081. 

  1081. 			{

    1082. 

  1082. 				$fr[mtemp]=str_replace('[!--'.$add[oldf].'--]','[!--'.$add[f].'--]',$fr[mtemp]);

    1083. 

  1083. 				$and.=",mtemp='".addslashes(stripSlashes($fr[mtemp]))."'";

    1084. 

  1084. 			}

    1085. 

  1085. 			//投稿表单模板

    1086. 

  1086. 			if(strstr($fr[qmtemp],'[!--'.$add[oldf].'--]'))

    1087. 

  1087. 			{

    1088. 

  1088. 				$fr[qmtemp]=str_replace('[!--'.$add[oldf].'--]','[!--'.$add[f].'--]',$fr[qmtemp]);

    1089. 

  1089. 				$and.=",qmtemp='".addslashes(stripSlashes($fr[qmtemp]))."'";

    1090. 

  1090. 			}

    1091. 

  1091. 			if($and)

    1092. 

  1092. 			{

    1093. 

  1093. 				$empire->query("update {$dbtbpre}enewsmod set mid='$fr[mid]'".$and." where mid='$fr[mid]'");

    1094. 

  1094. 			}

    1095. 

  1095. 		}

    1096. 

  1096. 		ChangeMForm($fr[mid],$fr[tid],$fr[mtemp]);

    1097. 

  1097. 		ChangeQmForm($fr[mid],$fr[tid],$fr[qmtemp]);

    1098. 

  1098. 	}

    1099. 

  1099. 	GetConfig(1);//更新缓存

    1100. 

  1100. 	if($sql)

    1101. 

  1101. 	{

    1102. 

  1102. 		insert_dolog("fid=".$add[fid]."<br>f=".$add[f]);//操作日志

    1103. 

  1103. 		printerror("EditFSuccess","db/ListF.php?tid=$tid&tbname=$tbname");

    1104. 

  1104. 	}

    1105. 

  1105. 	else

    1106. 

  1106. 	{printerror("DbError","history.go(-1)");}

    1107. 

  1107. }

    1108. 

  1108. 

    1109. 

  1109. //修改数据表系统字段

    1110. 

  1110. function EditSysF($add,$userid,$username){

    1111. 

  1111. 	global $empire,$dbtbpre;

    1112. 

  1112. 	$tid=(int)$add['tid'];

    1113. 

  1113. 	$tbname=RepPostVar($add['tbname']);

    1114. 

  1114. 	$fid=(int)$add['fid'];

    1115. 

  1115. 	$f=RepPostVar($add['f']);

    1116. 

  1116. 	if(!$fid||!$tid||!$tbname||!$f||!$add[fname])

    1117. 

  1117. 	{

    1118. 

  1118. 		printerror("EmptyF","history.go(-1)");

    1119. 

  1119. 	}

    1120. 

  1120. 	CheckLevel($userid,$username,$classid,"f");//验证权限

    1121. 

  1121. 	//字段

    1122. 

  1122. 	$addupdate='';

    1123. 

  1123. 	if($f=='title'||$f=='titlepic')

    1124. 

  1124. 	{

    1125. 

  1125. 		if(!empty($add['flen']))

    1126. 

  1126. 		{

    1127. 

  1127. 			$field=$f." ".$add['ftype']."(".$add['flen'].") NOT NULL default ''";

    1128. 

  1128. 			//信息表

    1129. 

  1129. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname." change ".$f." ".$field);

    1130. 

  1130. 			//归档表

    1131. 

  1131. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc change ".$f." ".$field);

    1132. 

  1132. 			//采集临时表

    1133. 

  1133. 			$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." change ".$f." ".$field);

    1134. 

  1134. 		}

    1135. 

  1135. 		$addupdate=",ftype='$add[ftype]'";

    1136. 

  1136. 	}

    1137. 

  1137. 	//索引

    1138. 

  1138. 	$iskey=(int)$add['iskey'];

    1139. 

  1139. 	if($f=='title'||$f=='titlepic'||$f=='newstime')

    1140. 

  1140. 	{

    1141. 

  1141. 		if($iskey==1)//索引

    1142. 

  1142. 		{

    1143. 

  1143. 			if($add['oldiskey']==0)

    1144. 

  1144. 			{

    1145. 

  1145. 				$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." ADD INDEX(".$f.")");

    1146. 

  1146. 				$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc ADD INDEX(".$f.")");

    1147. 

  1147. 			}

    1148. 

  1148. 		}

    1149. 

  1149. 		elseif($add['oldiskey']==1&&$iskey==0)//删除索引

    1150. 

  1150. 		{

    1151. 

  1151. 			$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." DROP INDEX ".$f);

    1152. 

  1152. 			$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc DROP INDEX ".$f);

    1153. 

  1153. 		}

    1154. 

  1154. 	}

    1155. 

  1155. 	//处理变量

    1156. 

  1156. 	$add[isonly]=(int)$add[isonly];

    1157. 

  1157. 	$add[myorder]=(int)$add[myorder];

    1158. 

  1158. 	//替换代码

    1159. 

  1159. 	if($add[fform]<>$add[oldfform]||$add[fvalue]<>$add[oldfvalue]||$add[oldlinkfieldtb]<>$add[linkfieldtb]||$add[oldlinkfieldshow]<>$add[linkfieldshow]||$add[linkfieldval]<>$add[oldlinkfieldval]||$add[fformsize]<>$add[oldfformsize])

    1160. 

  1160. 	{

    1161. 

  1161. 		$fhtml=GetFform($add[fform],$add[f],$add[fvalue],$add[linkfieldval],$add[fformsize],$add);

    1162. 

  1162. 	}

    1163. 

  1163. 	else

    1164. 

  1164. 	{

    1165. 

  1165. 		$fhtml=AddAddsData($add[fhtml]);

    1166. 

  1166. 	}

    1167. 

  1167. 	if($add[fform]<>$add[oldfform]||$add[fvalue]<>$add[oldfvalue]||$add[oldlinkfieldtb]<>$add[linkfieldtb]||$add[oldlinkfieldshow]<>$add[linkfieldshow]||$add[linkfieldval]<>$add[oldlinkfieldval]||$add[fformsize]<>$add[oldfformsize])

    1168. 

  1168. 	{

    1169. 

  1169. 		$qfhtml=GetQFform($add[fform],$add[f],$add[fvalue],$add[fformsize],$add);

    1170. 

  1170. 	}

    1171. 

  1171. 	else

    1172. 

  1172. 	{

    1173. 

  1173. 		$qfhtml=AddAddsData($add[qfhtml]);

    1174. 

  1174. 	}

    1175. 

  1175. 	$sql=$empire->query("update {$dbtbpre}enewsf set fname='$add[fname]',fform='$add[fform]',fhtml='".addslashes($fhtml)."',fzs='".addslashes($add[fzs])."',myorder=$add[myorder],flen='$add[flen]',fvalue='".addslashes($add[fvalue])."',iskey=$iskey,qfhtml='".addslashes($qfhtml)."',isonly='$add[isonly]',linkfieldval='$add[linkfieldval]',samedata='$add[samedata]',fformsize='$add[fformsize]',adddofun='$add[adddofun]',editdofun='$add[editdofun]',qadddofun='$add[qadddofun]',qeditdofun='$add[qeditdofun]',linkfieldtb='$add[linkfieldtb]',linkfieldshow='$add[linkfieldshow]'".$addupdate." where fid='$fid'");

    1176. 

  1176. 	TogSaveTxtF(1);//公共变量

    1177. 

  1177. 	//更新表单

    1178. 

  1178. 	$fsql=$empire->query("select mid,mtemp,tid,qmtemp from {$dbtbpre}enewsmod where tid='$tid'");

    1179. 

  1179. 	while($fr=$empire->fetch($fsql))

    1180. 

  1180. 	{

    1181. 

  1181. 		ChangeMForm($fr[mid],$fr[tid],$fr[mtemp]);

    1182. 

  1182. 		ChangeQmForm($fr[mid],$fr[tid],$fr[qmtemp]);

    1183. 

  1183. 	}

    1184. 

  1184. 	GetConfig(1);//更新缓存

    1185. 

  1185. 	if($sql)

    1186. 

  1186. 	{

    1187. 

  1187. 		insert_dolog("fid=".$fid."<br>f=".$f);//操作日志

    1188. 

  1188. 		printerror("EditFSuccess","db/EditSysF.php?tid=$tid&tbname=$tbname&fid=$fid");

    1189. 

  1189. 	}

    1190. 

  1190. 	else

    1191. 

  1191. 	{

    1192. 

  1192. 		printerror("DbError","history.go(-1)");

    1193. 

  1193. 	}

    1194. 

  1194. }

    1195. 

  1195. 

    1196. 

  1196. //删除数据库字段

    1197. 

  1197. function DelF($fid,$tid,$tbname,$userid,$username){

    1198. 

  1198. 	global $empire,$dbtbpre;

    1199. 

  1199. 	$tid=(int)$tid;

    1200. 

  1200. 	$tbname=RepPostVar($tbname);

    1201. 

  1201. 	$fid=(int)$fid;

    1202. 

  1202. 	if(empty($fid)||!$tid||!$tbname)

    1203. 

  1203. 	{

    1204. 

  1204. 		printerror("EmptyFid","history.go(-1)");

    1205. 

  1205. 	}

    1206. 

  1206. 	CheckLevel($userid,$username,$classid,"f");//验证权限

    1207. 

  1207. 	//是否系统内部字段

    1208. 

  1208. 	$cr=$empire->fetch1("select isadd,f,tbdataf,iscj from {$dbtbpre}enewsf where fid='$fid'");

    1209. 

  1209. 	if(empty($cr[isadd]))

    1210. 

  1210. 	{

    1211. 

  1211. 		printerror("NotIsAdd","history.go(-1)");

    1212. 

  1212. 	}

    1213. 

  1213. 	//删除表字段

    1214. 

  1214. 	if($cr['tbdataf']==1)

    1215. 

  1215. 	{

    1216. 

  1216. 		$tbr=$empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='$tid'");

    1217. 

  1217. 		if($tbr['datatbs'])

    1218. 

  1218. 		{

    1219. 

  1219. 			$dtbr=explode(',',$tbr['datatbs']);

    1220. 

  1220. 			$count=count($dtbr);

    1221. 

  1221. 			for($i=1;$i<$count-1;$i++)

    1222. 

  1222. 			{

    1223. 

  1223. 				$empire->query("alter table {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." drop COLUMN ".$cr[f]);

    1224. 

  1224. 			}

    1225. 

  1225. 		}

    1226. 

  1226. 		//归档副表

    1227. 

  1227. 		$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc_data drop COLUMN ".$cr[f]);

    1228. 

  1228. 	}

    1229. 

  1229. 	else

    1230. 

  1230. 	{

    1231. 

  1231. 		$usql=$empire->query("alter table {$dbtbpre}ecms_".$tbname." drop COLUMN ".$cr[f]);

    1232. 

  1232. 		$usql=$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc drop COLUMN ".$cr[f]);

    1233. 

  1233. 	}

    1234. 

  1234. 	//采集表字段

    1235. 

  1235. 	if($cr[iscj]==1)

    1236. 

  1236. 	{

    1237. 

  1237. 		$usql=$empire->query("alter table {$dbtbpre}ecms_infotmp_".$tbname." drop COLUMN ".$cr[f]);

    1238. 

  1238. 		$usql=$empire->query("alter table {$dbtbpre}ecms_infoclass_".$tbname." drop COLUMN zz_".$cr[f].",drop COLUMN z_".$cr[f].",drop COLUMN qz_".$cr[f].",drop COLUMN save_".$cr[f]);

    1239. 

  1239. 	}

    1240. 

  1240. 	$sql=$empire->query("delete from {$dbtbpre}enewsf where fid='$fid'");

    1241. 

  1241. 	TogSaveTxtF(1);//公共变量

    1242. 

  1242. 	//删除模型中字段项

    1243. 

  1243. 	$record="<!--record-->";

    1244. 

  1244. 	$field="<!--field--->";

    1245. 

  1245. 	$like=$field.$cr[f].$record;

    1246. 

  1246. 	$slike=",".$cr[f].",";

    1247. 

  1247. 	$dsql=$empire->query("select mid,cj,enter,tempvar,searchvar,tid,qenter,mustqenterf,listandf,listtempvar,canaddf,caneditf,orderf from {$dbtbpre}enewsmod where tid='$tid' and (cj like '%".$like."%' or enter like '%".$like."%' or searchvar like '%".$slike."%' or tempvar like '%".$like."%' or listtempvar like '%".$like."%' or qenter like '%".$like."%' or mustqenterf like '%".$slike."%' or listandf like '%".$slike."%' or canaddf like '%".$slike."%' or caneditf like '%".$slike."%' or orderf like '%".$slike."%')");

    1248. 

  1248. 	while($r=$empire->fetch($dsql))

    1249. 

  1249. 	{

    1250. 

  1250. 		$cj="";

    1251. 

  1251. 		$enter="";

    1252. 

  1252. 		$tempvar="";

    1253. 

  1253. 		$listtempvar="";

    1254. 

  1254. 		$searchvar="";

    1255. 

  1255. 		$qenter="";

    1256. 

  1256. 		$mustqenterf="";

    1257. 

  1257. 		$listandf="";

    1258. 

  1258. 		$orderf="";

    1259. 

  1259. 		$canaddf="";

    1260. 

  1260. 		$caneditf="";

    1261. 

  1261. 		$re="";

    1262. 

  1262. 		$re1="";

    1263. 

  1263. 		$and="";

    1264. 

  1264. 		$dh="";

    1265. 

  1265. 		//采集

    1266. 

  1266. 		if(strstr($r[cj],$like))

    1267. 

  1267. 		{

    1268. 

  1268. 			$re=explode($record,$r[cj]);

    1269. 

  1269. 			for($i=0;$i<count($re)-1;$i++)

    1270. 

  1270. 			{

    1271. 

  1271. 				if(strstr($re[$i].$record,$like))

    1272. 

  1272. 				{continue;}

    1273. 

  1273. 				$cj.=$re[$i].$record;

    1274. 

  1274. 			}

    1275. 

  1275. 			//更新采集表单

    1276. 

  1276. 			ChangeMCj($r[mid],$r[tid],$cj);

    1277. 

  1277. 			$and="cj='$cj'";

    1278. 

  1278. 		}

    1279. 

  1279. 		$dh="";

    1280. 

  1280. 		//录入表单

    1281. 

  1281. 		if(strstr($r[enter],$like))

    1282. 

  1282. 		{

    1283. 

  1283. 			$re1=explode($record,$r[enter]);

    1284. 

  1284. 			for($i=0;$i<count($re1)-1;$i++)

    1285. 

  1285. 			{

    1286. 

  1286. 				if(strstr($re1[$i].$record,$like))

    1287. 

  1287. 				{continue;}

    1288. 

  1288. 				$enter.=$re1[$i].$record;

    1289. 

  1289. 			}

    1290. 

  1290. 			if(!empty($and))

    1291. 

  1291. 			{$dh=",";}

    1292. 

  1292. 			$and.=$dh."enter='$enter'";

    1293. 

  1293. 	    }

    1294. 

  1294. 		$dh="";

    1295. 

  1295. 		//投稿表单

    1296. 

  1296. 		if(strstr($r[qenter],$like))

    1297. 

  1297. 		{

    1298. 

  1298. 			$re1=explode($record,$r[qenter]);

    1299. 

  1299. 			for($i=0;$i<count($re1)-1;$i++)

    1300. 

  1300. 			{

    1301. 

  1301. 				if(strstr($re1[$i].$record,$like))

    1302. 

  1302. 				{continue;}

    1303. 

  1303. 				$qenter.=$re1[$i].$record;

    1304. 

  1304. 			}

    1305. 

  1305. 			if(!empty($and))

    1306. 

  1306. 			{$dh=",";}

    1307. 

  1307. 			$and.=$dh."qenter='$qenter'";

    1308. 

  1308. 	    }

    1309. 

  1309. 		$dh="";

    1310. 

  1310. 		//内容模板变量

    1311. 

  1311. 		if(strstr($r[tempvar],$like))

    1312. 

  1312. 		{

    1313. 

  1313. 			$re1=explode($record,$r[tempvar]);

    1314. 

  1314. 			for($i=0;$i<count($re1)-1;$i++)

    1315. 

  1315. 			{

    1316. 

  1316. 				if(strstr($re1[$i].$record,$like))

    1317. 

  1317. 				{continue;}

    1318. 

  1318. 				$tempvar.=$re1[$i].$record;

    1319. 

  1319. 			}

    1320. 

  1320. 			if(!empty($and))

    1321. 

  1321. 			{$dh=",";}

    1322. 

  1322. 			$and.=$dh."tempvar='$tempvar'";

    1323. 

  1323. 	    }

    1324. 

  1324. 		$dh="";

    1325. 

  1325. 		//列表模板变量

    1326. 

  1326. 		if(strstr($r[listtempvar],$like))

    1327. 

  1327. 		{

    1328. 

  1328. 			$re1=explode($record,$r[listtempvar]);

    1329. 

  1329. 			for($i=0;$i<count($re1)-1;$i++)

    1330. 

  1330. 			{

    1331. 

  1331. 				if(strstr($re1[$i].$record,$like))

    1332. 

  1332. 				{continue;}

    1333. 

  1333. 				$listtempvar.=$re1[$i].$record;

    1334. 

  1334. 			}

    1335. 

  1335. 			if(!empty($and))

    1336. 

  1336. 			{$dh=",";}

    1337. 

  1337. 			$and.=$dh."listtempvar='$listtempvar'";

    1338. 

  1338. 	    }

    1339. 

  1339. 		$dh="";

    1340. 

  1340. 		//搜索变量

    1341. 

  1341. 		if(strstr($r[searchvar],$slike))

    1342. 

  1342. 		{

    1343. 

  1343. 			if(!empty($and))

    1344. 

  1344. 			{$dh=",";}

    1345. 

  1345. 			$searchvar=str_replace($slike,",",$r[searchvar]);

    1346. 

  1346. 		    $and.=$dh."searchvar='$searchvar'";

    1347. 

  1347. 		}

    1348. 

  1348. 		//必填项

    1349. 

  1349. 		$dh="";

    1350. 

  1350. 		if(strstr($r[mustqenterf],$slike))

    1351. 

  1351. 		{

    1352. 

  1352. 			if(!empty($and))

    1353. 

  1353. 			{$dh=",";}

    1354. 

  1354. 			$mustqenterf=str_replace($slike,",",$r[mustqenterf]);

    1355. 

  1355. 		    $and.=$dh."mustqenterf='$mustqenterf'";

    1356. 

  1356. 		}

    1357. 

  1357. 		//可增可修改项

    1358. 

  1358. 		$dh="";

    1359. 

  1359. 		if(strstr($r[canaddf],$slike))

    1360. 

  1360. 		{

    1361. 

  1361. 			if(!empty($and))

    1362. 

  1362. 			{$dh=",";}

    1363. 

  1363. 			$canaddf=str_replace($slike,",",$r[canaddf]);

    1364. 

  1364. 		    $and.=$dh."canaddf='$canaddf'";

    1365. 

  1365. 		}

    1366. 

  1366. 		$dh="";

    1367. 

  1367. 		if(strstr($r[caneditf],$slike))

    1368. 

  1368. 		{

    1369. 

  1369. 			if(!empty($and))

    1370. 

  1370. 			{$dh=",";}

    1371. 

  1371. 			$caneditf=str_replace($slike,",",$r[caneditf]);

    1372. 

  1372. 		    $and.=$dh."caneditf='$caneditf'";

    1373. 

  1373. 		}

    1374. 

  1374. 		//结合项

    1375. 

  1375. 		$dh="";

    1376. 

  1376. 		if(strstr($r[listandf],$slike))

    1377. 

  1377. 		{

    1378. 

  1378. 			if(!empty($and))

    1379. 

  1379. 			{$dh=",";}

    1380. 

  1380. 			$listandf=str_replace($slike,",",$r[listandf]);

    1381. 

  1381. 		    $and.=$dh."listandf='$listandf'";

    1382. 

  1382. 		}

    1383. 

  1383. 		//排序项

    1384. 

  1384. 		$dh="";

    1385. 

  1385. 		if(strstr($r[orderf],$slike))

    1386. 

  1386. 		{

    1387. 

  1387. 			if(!empty($and))

    1388. 

  1388. 			{$dh=",";}

    1389. 

  1389. 			$orderf=str_replace($slike,",",$r[orderf]);

    1390. 

  1390. 		    $and.=$dh."orderf='$orderf'";

    1391. 

  1391. 		}

    1392. 

  1392. 		if($and)

    1393. 

  1393. 		{

    1394. 

  1394. 			$empire->query("update {$dbtbpre}enewsmod set ".$and." where mid='$r[mid]'");

    1395. 

  1395. 		}

    1396. 

  1396.     }

    1397. 

  1397. 	GetConfig(1);//更新缓存

    1398. 

  1398.     if($sql)

    1399. 

  1399. 	{

    1400. 

  1400. 		//操作日志

    1401. 

  1401. 		insert_dolog("fid=".$fid."<br>f=".$cr[f]);

    1402. 

  1402. 		printerror("DelFSuccess","db/ListF.php?tid=$tid&tbname=$tbname");

    1403. 

  1403. 	}

    1404. 

  1404. 	else

    1405. 

  1405. 	{printerror("DbError","history.go(-1)");}

    1406. 

  1406. }

    1407. 

  1407. 

    1408. 

  1408. //修改字段顺序

    1409. 

  1409. function EditFOrder($fid,$myorder,$tid,$tbname,$userid,$username){

    1410. 

  1410. 	global $empire,$dbtbpre;

    1411. 

  1411. 	$tid=(int)$tid;

    1412. 

  1412. 	$tbname=RepPostVar($tbname);

    1413. 

  1413. 	//验证权限

    1414. 

  1414. 	CheckLevel($userid,$username,$classid,"f");

    1415. 

  1415. 	for($i=0;$i<count($myorder);$i++)

    1416. 

  1416. 	{

    1417. 

  1417. 		$newmyorder=(int)$myorder[$i];

    1418. 

  1418. 		$usql=$empire->query("update {$dbtbpre}enewsf set myorder=$newmyorder where fid='$fid[$i]'");

    1419. 

  1419.     }

    1420. 

  1420. 	printerror("EditFOrderSuccess","db/ListF.php?tid=$tid&tbname=$tbname");

    1421. 

  1421. }

    1422. 

  1422. 

    1423. 

  1423. //转移字段

    1424. 

  1424. function ChangeDataTableF($add,$userid,$username){

    1425. 

  1425. 	global $empire,$dbtbpre,$public_r,$fun_r;

    1426. 

  1426. 	//验证权限

    1427. 

  1427. 	CheckLevel($userid,$username,$classid,"f");

    1428. 

  1428. 	$fid=(int)$add[fid];

    1429. 

  1429. 	$tid=(int)$add[tid];

    1430. 

  1430. 	$tbname=RepPostVar($add[tbname]);

    1431. 

  1431. 	$line=(int)$add[line];

    1432. 

  1432. 	$start=(int)$add[start];

    1433. 

  1433. 	if(!$fid||!$tid||!$tbname)

    1434. 

  1434. 	{

    1435. 

  1435. 		printerror("ErrorUrl","history.go(-1)");

    1436. 

  1436. 	}

    1437. 

  1437. 	if(empty($line))

    1438. 

  1438. 	{

    1439. 

  1439. 		$line=200;

    1440. 

  1440. 	}

    1441. 

  1441. 	$fr=$empire->fetch1("select * from {$dbtbpre}enewsf where fid='$fid'");

    1442. 

  1442. 	if(!$fr[fid])

    1443. 

  1443. 	{

    1444. 

  1444. 		printerror("ErrorUrl","history.go(-1)");

    1445. 

  1445. 	}

    1446. 

  1446. 	if(empty($fr[isadd]))

    1447. 

  1447. 	{

    1448. 

  1448. 		printerror("NotIsAdd","history.go(-1)");

    1449. 

  1449. 	}

    1450. 

  1450. 	$tid=$fr[tid];

    1451. 

  1451. 	$tbname=$fr[tbname];

    1452. 

  1452. 	$f=$fr[f];

    1453. 

  1453. 	//建字段

    1454. 

  1454. 	if(empty($start))

    1455. 

  1455. 	{

    1456. 

  1456. 		$field=ReturnTbFtype($fr);//返回字段

    1457. 

  1457. 		if($fr[tbdataf])//转移到主表

    1458. 

  1458. 		{

    1459. 

  1459. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname." add ".$field);

    1460. 

  1460. 			if($fr[iskey]==1)//索引

    1461. 

  1461. 			{

    1462. 

  1462. 				$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname." ADD INDEX(".$fr[f].")");

    1463. 

  1463. 			}

    1464. 

  1464. 			//归档主表

    1465. 

  1465. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc add ".$field);

    1466. 

  1466. 			if($fr[iskey]==1)//索引

    1467. 

  1467. 			{

    1468. 

  1468. 				$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc ADD INDEX(".$fr[f].")");

    1469. 

  1469. 			}

    1470. 

  1470. 		}

    1471. 

  1471. 		else//转移到副表

    1472. 

  1472. 		{

    1473. 

  1473. 			$tbr=$empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='$tid'");

    1474. 

  1474. 			if($tbr['datatbs'])

    1475. 

  1475. 			{

    1476. 

  1476. 				$dtbr=explode(',',$tbr['datatbs']);

    1477. 

  1477. 				$count=count($dtbr);

    1478. 

  1478. 				for($i=1;$i<$count-1;$i++)

    1479. 

  1479. 				{

    1480. 

  1480. 					$empire->query("alter table {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." add ".$field);

    1481. 

  1481. 					if($fr[iskey]==1)//索引

    1482. 

  1482. 					{

    1483. 

  1483. 						$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." ADD INDEX(".$fr[f].")");

    1484. 

  1484. 					}

    1485. 

  1485. 				}

    1486. 

  1486. 			}

    1487. 

  1487. 			//归档副表

    1488. 

  1488. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc_data add ".$field);

    1489. 

  1489. 			if($fr[iskey]==1)//索引

    1490. 

  1490. 			{

    1491. 

  1491. 				$empire->query("ALTER TABLE {$dbtbpre}ecms_".$tbname."_doc_data ADD INDEX(".$fr[f].")");

    1492. 

  1492. 			}

    1493. 

  1493. 		}

    1494. 

  1494. 	}

    1495. 

  1495. 	$selectf='';

    1496. 

  1496. 	if(empty($fr[tbdataf]))

    1497. 

  1497. 	{

    1498. 

  1498. 		$selectf=','.$fr[f];

    1499. 

  1499. 	}

    1500. 

  1500. 	$b=0;

    1501. 

  1501. 	$sql=$empire->query("select id,stb".$selectf." from {$dbtbpre}ecms_".$tbname." where id>$start order by id limit ".$line);

    1502. 

  1502. 	while($r=$empire->fetch($sql))

    1503. 

  1503. 	{

    1504. 

  1504. 		$b=1;

    1505. 

  1505. 		$newstart=$r['id'];

    1506. 

  1506. 		if($fr[tbdataf])//副表

    1507. 

  1507. 		{

    1508. 

  1508. 			$finfor=$empire->fetch1("select ".$f." from {$dbtbpre}ecms_".$tbname."_data_".$r[stb]." where id='$r[id]'");

    1509. 

  1509. 			$value=$finfor[$f];

    1510. 

  1510. 			$empire->query("update {$dbtbpre}ecms_".$tbname." set ".$f."='".StripAddsData($value)."' where id='$r[id]'");

    1511. 

  1511. 		}

    1512. 

  1512. 		else//主表

    1513. 

  1513. 		{

    1514. 

  1514. 			$value=$r[$f];

    1515. 

  1515. 			$empire->query("update {$dbtbpre}ecms_".$tbname."_data_".$r[stb]." set ".$f."='".StripAddsData($value)."' where id='$r[id]'");

    1516. 

  1516. 		}

    1517. 

  1517. 	}

    1518. 

  1518. 	if(empty($b))

    1519. 

  1519. 	{

    1520. 

  1520. 		echo"<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><meta http-equiv=\"refresh\" content=\"".$public_r['realltime'].";url=ecmsmod.php?enews=ChangeDocDataTableF&tid=$tid&tbname=$tbname&fid=$fid&line=$line\">".$fun_r[AllChangeDataTableFSuccess];

    1521. 

  1521. 		exit();

    1522. 

  1522. 	}

    1523. 

  1523. 	echo"<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><meta http-equiv=\"refresh\" content=\"".$public_r['realltime'].";url=ecmsmod.php?enews=ChangeDataTableF&tid=$tid&tbname=$tbname&fid=$fid&line=$line&start=$newstart\">".$fun_r[OneChangeDataTableFSuccess]."(ID:<font color=red><b>".$newstart."</b></font>)";

    1524. 

  1524. 	exit();

    1525. 

  1525. }

    1526. 

  1526. 

    1527. 

  1527. //转移字段(归档)

    1528. 

  1528. function ChangeDocDataTableF($add,$userid,$username){

    1529. 

  1529. 	global $empire,$dbtbpre,$public_r,$fun_r;

    1530. 

  1530. 	//验证权限

    1531. 

  1531. 	CheckLevel($userid,$username,$classid,"f");

    1532. 

  1532. 	$fid=(int)$add[fid];

    1533. 

  1533. 	$tid=(int)$add[tid];

    1534. 

  1534. 	$tbname=RepPostVar($add[tbname]);

    1535. 

  1535. 	$line=(int)$add[line];

    1536. 

  1536. 	$start=(int)$add[start];

    1537. 

  1537. 	if(!$fid||!$tid||!$tbname)

    1538. 

  1538. 	{

    1539. 

  1539. 		printerror("ErrorUrl","history.go(-1)");

    1540. 

  1540. 	}

    1541. 

  1541. 	if(empty($line))

    1542. 

  1542. 	{

    1543. 

  1543. 		$line=200;

    1544. 

  1544. 	}

    1545. 

  1545. 	$fr=$empire->fetch1("select * from {$dbtbpre}enewsf where fid='$fid'");

    1546. 

  1546. 	if(!$fr[fid])

    1547. 

  1547. 	{

    1548. 

  1548. 		printerror("ErrorUrl","history.go(-1)");

    1549. 

  1549. 	}

    1550. 

  1550. 	if(empty($fr[isadd]))

    1551. 

  1551. 	{

    1552. 

  1552. 		printerror("NotIsAdd","history.go(-1)");

    1553. 

  1553. 	}

    1554. 

  1554. 	$tid=$fr[tid];

    1555. 

  1555. 	$tbname=$fr[tbname];

    1556. 

  1556. 	$f=$fr[f];

    1557. 

  1557. 	$selectf='';

    1558. 

  1558. 	if(empty($fr[tbdataf]))

    1559. 

  1559. 	{

    1560. 

  1560. 		$selectf=','.$fr[f];

    1561. 

  1561. 	}

    1562. 

  1562. 	$b=0;

    1563. 

  1563. 	$sql=$empire->query("select id,stb".$selectf." from {$dbtbpre}ecms_".$tbname."_doc where id>$start order by id limit ".$line);

    1564. 

  1564. 	while($r=$empire->fetch($sql))

    1565. 

  1565. 	{

    1566. 

  1566. 		$b=1;

    1567. 

  1567. 		$newstart=$r['id'];

    1568. 

  1568. 		if($fr[tbdataf])//副表

    1569. 

  1569. 		{

    1570. 

  1570. 			$finfor=$empire->fetch1("select ".$f." from {$dbtbpre}ecms_".$tbname."_doc_data where id='$r[id]'");

    1571. 

  1571. 			$value=$finfor[$f];

    1572. 

  1572. 			$empire->query("update {$dbtbpre}ecms_".$tbname."_doc set ".$f."='".StripAddsData($value)."' where id='$r[id]'");

    1573. 

  1573. 		}

    1574. 

  1574. 		else//主表

    1575. 

  1575. 		{

    1576. 

  1576. 			$value=$r[$f];

    1577. 

  1577. 			$empire->query("update {$dbtbpre}ecms_".$tbname."_doc_data set ".$f."='".StripAddsData($value)."' where id='$r[id]'");

    1578. 

  1578. 		}

    1579. 

  1579. 	}

    1580. 

  1580. 	if(empty($b))

    1581. 

  1581. 	{

    1582. 

  1582. 		//删除字段

    1583. 

  1583. 		if($fr[tbdataf])//转移到主表

    1584. 

  1584. 		{

    1585. 

  1585. 			$tbr=$empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='$tid'");

    1586. 

  1586. 			if($tbr['datatbs'])

    1587. 

  1587. 			{

    1588. 

  1588. 				$dtbr=explode(',',$tbr['datatbs']);

    1589. 

  1589. 				$count=count($dtbr);

    1590. 

  1590. 				for($i=1;$i<$count-1;$i++)

    1591. 

  1591. 				{

    1592. 

  1592. 					$empire->query("alter table {$dbtbpre}ecms_".$tbname."_data_".$dtbr[$i]." drop COLUMN ".$fr[f]);

    1593. 

  1593. 				}

    1594. 

  1594. 			}

    1595. 

  1595. 			//归档副表

    1596. 

  1596. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc_data drop COLUMN ".$fr[f]);

    1597. 

  1597. 		}

    1598. 

  1598. 		else//转移到副表

    1599. 

  1599. 		{

    1600. 

  1600. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname." drop COLUMN ".$fr[f]);

    1601. 

  1601. 			$empire->query("alter table {$dbtbpre}ecms_".$tbname."_doc drop COLUMN ".$fr[f]);

    1602. 

  1602. 		}

    1603. 

  1603. 		$newtbdataf=$fr[tbdataf]?0:1;

    1604. 

  1604. 		$empire->query("update {$dbtbpre}enewsf set tbdataf='$newtbdataf' where fid='$fid'");

    1605. 

  1605. 		//删除模型中字段项

    1606. 

  1606. 		if(empty($tbr['datatbs']))

    1607. 

  1607. 		{

    1608. 

  1608. 			$record="<!--record-->";

    1609. 

  1609. 			$field="<!--field--->";

    1610. 

  1610. 			$like=$field.$fr[f].$record;

    1611. 

  1611. 			$slike=",".$fr[f].",";

    1612. 

  1612. 			$dsql=$empire->query("select mid,searchvar,listandf,listtempvar,orderf from {$dbtbpre}enewsmod where tid='$tid' and (searchvar like '%".$slike."%' or listtempvar like '%".$like."%' or listandf like '%".$slike."%' or orderf like '%".$slike."%')");

    1613. 

  1613. 			while($r=$empire->fetch($dsql))

    1614. 

  1614. 			{

    1615. 

  1615. 				$listtempvar="";

    1616. 

  1616. 				$searchvar="";

    1617. 

  1617. 				$listandf="";

    1618. 

  1618. 				$orderf="";

    1619. 

  1619. 				$re="";

    1620. 

  1620. 				$re1="";

    1621. 

  1621. 				$and="";

    1622. 

  1622. 				$dh="";

    1623. 

  1623. 				//列表模板变量

    1624. 

  1624. 				if(strstr($r[listtempvar],$like))

    1625. 

  1625. 				{

    1626. 

  1626. 					$re1=explode($record,$r[listtempvar]);

    1627. 

  1627. 					for($i=0;$i<count($re1)-1;$i++)

    1628. 

  1628. 					{

    1629. 

  1629. 						if(strstr($re1[$i].$record,$like))

    1630. 

  1630. 						{continue;}

    1631. 

  1631. 						$listtempvar.=$re1[$i].$record;

    1632. 

  1632. 					}

    1633. 

  1633. 					$and.=$dh."listtempvar='$listtempvar'";

    1634. 

  1634. 				}

    1635. 

  1635. 				$dh="";

    1636. 

  1636. 				//搜索变量

    1637. 

  1637. 				if(strstr($r[searchvar],$slike))

    1638. 

  1638. 				{

    1639. 

  1639. 					if(!empty($and))

    1640. 

  1640. 					{$dh=",";}

    1641. 

  1641. 					$searchvar=str_replace($slike,",",$r[searchvar]);

    1642. 

  1642. 					$and.=$dh."searchvar='$searchvar'";

    1643. 

  1643. 				}

    1644. 

  1644. 				//结合项

    1645. 

  1645. 				$dh="";

    1646. 

  1646. 				if(strstr($r[listandf],$slike))

    1647. 

  1647. 				{

    1648. 

  1648. 					if(!empty($and))

    1649. 

  1649. 					{$dh=",";}

    1650. 

  1650. 					$listandf=str_replace($slike,",",$r[listandf]);

    1651. 

  1651. 					$and.=$dh."listandf='$listandf'";

    1652. 

  1652. 				}

    1653. 

  1653. 				//排序项

    1654. 

  1654. 				$dh="";

    1655. 

  1655. 				if(strstr($r[orderf],$slike))

    1656. 

  1656. 				{

    1657. 

  1657. 					if(!empty($and))

    1658. 

  1658. 					{$dh=",";}

    1659. 

  1659. 					$orderf=str_replace($slike,",",$r[orderf]);

    1660. 

  1660. 					$and.=$dh."orderf='$orderf'";

    1661. 

  1661. 				}

    1662. 

  1662. 				if($and)

    1663. 

  1663. 				{

    1664. 

  1664. 					$empire->query("update {$dbtbpre}enewsmod set ".$and." where mid='$r[mid]'");

    1665. 

  1665. 				}

    1666. 

  1666. 			}

    1667. 

  1667. 		}

    1668. 

  1668. 		GetConfig(1);//更新缓存

    1669. 

  1669. 		insert_dolog("tid=$tid&tbname=$tbname<br>fid=$fid&field=$f&tbdataf=".$newtbdataf);//操作日志

    1670. 

  1670. 		printerror("ChangeDataTableFSuccess","db/ListF.php?tid=$tid&tbname=$tbname");

    1671. 

  1671. 	}

    1672. 

  1672. 	echo"<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><meta http-equiv=\"refresh\" content=\"".$public_r['realltime'].";url=ecmsmod.php?enews=ChangeDocDataTableF&tid=$tid&tbname=$tbname&fid=$fid&line=$line&start=$newstart\">".$fun_r[OneChangeDocDataTableFSuccess]."(ID:<font color=red><b>".$newstart."</b></font>)";

    1673. 

  1673. 	exit();

    1674. 

  1674. }

    1675. 

  1675. 

    1676. 

  1676. 

    1677. 

  1677. //************************** 模型 **************************

    1678. 

  1678. 

    1679. 

  1679. //更新默认系统模型

    1680. 

  1680. function UpdateTbDefMod($tid,$tbname,$mid){

    1681. 

  1681. 	global $empire,$dbtbpre;

    1682. 

  1682. 	$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsmod where tid='$tid'");

    1683. 

  1683. 	if($num==1)

    1684. 

  1684. 	{

    1685. 

  1685. 		$empire->query("update {$dbtbpre}enewstable set mid='$mid' where tid='$tid'");

    1686. 

  1686. 		$empire->query("update {$dbtbpre}enewsmod set isdefault=1 where mid='$mid'");

    1687. 

  1687. 	}

    1688. 

  1688. }

    1689. 

  1689. 

    1690. 

  1690. //更新模型表单

    1691. 

  1691. function ChangeMForm($mid,$tid,$mtemp){

    1692. 

  1692. 	global $empire,$dbtbpre;

    1693. 

  1693. 	$file="../data/html/".$mid.".php";

    1694. 

  1694. 	$sql=$empire->query("select f,fhtml from {$dbtbpre}enewsf where tid='$tid'");

    1695. 

  1695. 	while($r=$empire->fetch($sql))

    1696. 

  1696. 	{

    1697. 

  1697. 		$mtemp=str_replace("[!--".$r[f]."--]",$r[fhtml],$mtemp);

    1698. 

  1698.     }

    1699. 

  1699. 	$mtemp=AddCheckViewTempCode().$mtemp;

    1700. 

  1700. 	WriteFiletext($file,$mtemp);

    1701. 

  1701. }

    1702. 

  1702. 

    1703. 

  1703. //更新投稿表单

    1704. 

  1704. function ChangeQmForm($mid,$tid,$mtemp){

    1705. 

  1705. 	global $empire,$dbtbpre;

    1706. 

  1706. 	$file="../data/html/q".$mid.".php";

    1707. 

  1707. 	$sql=$empire->query("select f,qfhtml from {$dbtbpre}enewsf where tid='$tid'");

    1708. 

  1708. 	while($r=$empire->fetch($sql))

    1709. 

  1709. 	{

    1710. 

  1710. 		$mtemp=str_replace("[!--".$r[f]."--]",$r[qfhtml],$mtemp);

    1711. 

  1711.     }

    1712. 

  1712. 	$mtemp=AddCheckViewTempCode().$mtemp;

    1713. 

  1713. 	WriteFiletext($file,$mtemp);

    1714. 

  1714. }

    1715. 

  1715. 

    1716. 

  1716. //更新采集

    1717. 

  1717. function ChangeMCj($mid,$tid,$cj){

    1718. 

  1718. 	global $empire,$dbtbpre;

    1719. 

  1719. 	$record="<!--record-->";

    1720. 

  1720. 	$field="<!--field--->";

    1721. 

  1721. 	//读取修改采集表单

    1722. 

  1722. 	$data="<tr><td bgcolor=ffffff>[!--enews.name--]</td><td bgcolor=ffffff>[!--enews.var--]</td></tr>";

    1723. 

  1723. 	$file1="../data/html/editcj".$mid.".php";

    1724. 

  1724. 	$file="../data/html/cj".$mid.".php";

    1725. 

  1725. 	$r=explode($record,$cj);

    1726. 

  1726. 	for($i=0;$i<count($r)-1;$i++)

    1727. 

  1727. 	{

    1728. 

  1728. 		$r1=explode($field,$r[$i]);

    1729. 

  1729. 		$fr=$empire->fetch1("select cjhtml,fhtml from {$dbtbpre}enewsf where f='$r1[1]' and tid='$tid' limit 1");

    1730. 

  1730. 		$cjtemp=str_replace("[!--enews.name--]",$r1[0],$fr[cjhtml]);

    1731. 

  1731. 		$str.=$cjtemp;

    1732. 

  1732. 		$editcjtemp=str_replace("[!--enews.name--]",$r1[0],$data);

    1733. 

  1733. 		$editcjtemp=str_replace("[!--enews.var--]",$fr[fhtml],$editcjtemp);

    1734. 

  1734. 		$editcj.=$editcjtemp;

    1735. 

  1735. 	}

    1736. 

  1736. 	WriteFiletext($file,AddCheckViewTempCode().$str);

    1737. 

  1737. 	WriteFiletext($file1,AddCheckViewTempCode().$editcj);

    1738. 

  1738. }

    1739. 

  1739. 

    1740. 

  1740. //组合采集项

    1741. 

  1741. function TogMCj($cname,$cchange){

    1742. 

  1742. 	$record="<!--record-->";

    1743. 

  1743. 	$field="<!--field--->";

    1744. 

  1744. 	$c="";

    1745. 

  1745. 	for($i=0;$i<count($cchange);$i++)

    1746. 

  1746. 	{

    1747. 

  1747. 		$v=$cchange[$i];

    1748. 

  1748. 		$name=str_replace($field,"",$cname[$v]);

    1749. 

  1749. 		$name=str_replace($record,"",$name);

    1750. 

  1750. 		$c.=$name.$field.$v.$record;

    1751. 

  1751. 	}

    1752. 

  1752. 	return $c;

    1753. 

  1753. }

    1754. 

  1754. 

    1755. 

  1755. //组合投稿项

    1756. 

  1756. function TogMqenter($cname,$cqenter){

    1757. 

  1757. 	$record="<!--record-->";

    1758. 

  1758. 	$field="<!--field--->";

    1759. 

  1759. 	$c="";

    1760. 

  1760. 	for($i=0;$i<count($cqenter);$i++)

    1761. 

  1761. 	{

    1762. 

  1762. 		$v=$cqenter[$i];

    1763. 

  1763. 		$name=str_replace($field,"",$cname[$v]);

    1764. 

  1764. 		$name=str_replace($record,"",$name);

    1765. 

  1765. 		$c.=$name.$field.$v.$record;

    1766. 

  1766. 	}

    1767. 

  1767. 	return $c;

    1768. 

  1768. }

    1769. 

  1769. 

    1770. 

  1770. //组合搜索项

    1771. 

  1771. function TogMSearch($cname,$schange){

    1772. 

  1772. 	$c="";

    1773. 

  1773. 	for($i=0;$i<count($schange);$i++)

    1774. 

  1774. 	{

    1775. 

  1775. 		$v=$schange[$i];

    1776. 

  1776. 		$c.=$v.",";

    1777. 

  1777. 	}

    1778. 

  1778. 	if($c)

    1779. 

  1779. 	{

    1780. 

  1780. 		$c=",".$c;

    1781. 

  1781. 	}

    1782. 

  1782. 	return $c;

    1783. 

  1783. }

    1784. 

  1784. 

    1785. 

  1785. //组合必填项

    1786. 

  1786. function TogMustf($cname,$menter){

    1787. 

  1787. 	$c="";

    1788. 

  1788. 	for($i=0;$i<count($menter);$i++)

    1789. 

  1789. 	{

    1790. 

  1790. 		$v=$menter[$i];

    1791. 

  1791. 		$c.=$v.",";

    1792. 

  1792. 	}

    1793. 

  1793. 	if($c)

    1794. 

  1794. 	{

    1795. 

  1795. 		$c=",".$c;

    1796. 

  1796. 	}

    1797. 

  1797. 	return $c;

    1798. 

  1798. }

    1799. 

  1799. 

    1800. 

  1800. //组合录入项

    1801. 

  1801. function TogMEnter($cname,$center,$ltempf,$ptempf,$tid){

    1802. 

  1802. 	global $empire;

    1803. 

  1803. 	$f=1;

    1804. 

  1804. 	$record="<!--record-->";

    1805. 

  1805. 	$field="<!--field--->";

    1806. 

  1806. 	$c="";

    1807. 

  1807. 	$lt="";

    1808. 

  1808. 	$pt="";

    1809. 

  1809. 	for($i=0;$i<count($center);$i++)

    1810. 

  1810. 	{

    1811. 

  1811. 		$v=$center[$i];

    1812. 

  1812. 		$name=str_replace($field,"",$cname[$v]);

    1813. 

  1813. 		$name=str_replace($record,"",$name);

    1814. 

  1814. 		$c.=$name.$field.$v.$record;

    1815. 

  1815. 	}

    1816. 

  1816. 	for($i=0;$i<count($ltempf);$i++)

    1817. 

  1817. 	{

    1818. 

  1818. 		$v=$ltempf[$i];

    1819. 

  1819. 		$name=str_replace($field,"",$cname[$v]);

    1820. 

  1820. 		$name=str_replace($record,"",$name);

    1821. 

  1821. 		$lt.=$name.$field.$v.$record;

    1822. 

  1822. 	}

    1823. 

  1823. 	for($i=0;$i<count($ptempf);$i++)

    1824. 

  1824. 	{

    1825. 

  1825. 		$v=$ptempf[$i];

    1826. 

  1826. 		$name=str_replace($field,"",$cname[$v]);

    1827. 

  1827. 		$name=str_replace($record,"",$name);

    1828. 

  1828. 		$pt.=$name.$field.$v.$record;

    1829. 

  1829. 	}

    1830. 

  1830. 	$r[0]=$c;

    1831. 

  1831. 	$r[1]=$lt;

    1832. 

  1832. 	$r[2]=$pt;

    1833. 

  1833. 	return $r;

    1834. 

  1834. }

    1835. 

  1835. 

    1836. 

  1836. //返回自动生成录入表单模板

    1837. 

  1837. function ReturnMtemp($cname,$center){

    1838. 

  1838. 	$temp="<tr><td width='16%' height=25 bgcolor='ffffff'>enews.name</td><td bgcolor='ffffff'>[!--enews.var--]</td></tr>";

    1839. 

  1839. 	$ntemp="<tr><td height=25 colspan=2 bgcolor='ffffff'><div align=left>enews.name</div></td></tr></table><div style='background-color:#D0D0D0'>[!--enews.var--]</div><table width='100%' align=center cellpadding=3 cellspacing=1 bgcolor='#DBEAF5'>";

    1840. 

  1840. 	for($i=0;$i<count($center);$i++)

    1841. 

  1841. 	{

    1842. 

  1842. 		$v=$center[$i];

    1843. 

  1843. 		if($v=="newstext")

    1844. 

  1844. 		{

    1845. 

  1845. 			$data.=str_replace("enews.var",$v,str_replace("enews.name",$cname[$v],$ntemp));

    1846. 

  1846. 			continue;

    1847. 

  1847. 		}

    1848. 

  1848. 		$data.=str_replace("enews.var",$v,str_replace("enews.name",$cname[$v],$temp));

    1849. 

  1849.     }

    1850. 

  1850. 	return "<table width='100%' align=center cellpadding=3 cellspacing=1 bgcolor='#DBEAF5'>".$data."</table>";

    1851. 

  1851. }

    1852. 

  1852. 

    1853. 

  1853. //返回自动生成投稿表单模板

    1854. 

  1854. function ReturnQmtemp($cname,$cqenter){

    1855. 

  1855. 	$temp="<tr><td width='16%' height=25 bgcolor='ffffff'>enews.name</td><td bgcolor='ffffff'>[!--enews.var--]</td></tr>";

    1856. 

  1856. 	$ntemp="<tr><td height=25 colspan=2 bgcolor='ffffff'><div align=left>enews.name</div></td></tr></table><div style='background-color:#D0D0D0'>[!--enews.var--]</div><table width='100%' align=center cellpadding=3 cellspacing=1 bgcolor='#DBEAF5'>";

    1857. 

  1857. 	for($i=0;$i<count($cqenter);$i++)

    1858. 

  1858. 	{

    1859. 

  1859. 		$v=$cqenter[$i];

    1860. 

  1860. 		if($v=="newstext")

    1861. 

  1861. 		{

    1862. 

  1862. 			$data.=str_replace("enews.var",$v,str_replace("enews.name",$cname[$v],$ntemp));

    1863. 

  1863. 			continue;

    1864. 

  1864. 		}

    1865. 

  1865. 		$data.=str_replace("enews.var",$v,str_replace("enews.name",$cname[$v],$temp));

    1866. 

  1866.     }

    1867. 

  1867. 	return "<table width=100% align=center cellpadding=3 cellspacing=1 bgcolor=#DBEAF5>".$data."</table>";

    1868. 

  1868. }

    1869. 

  1869. 

    1870. 

  1870. //返回br项

    1871. 

  1871. function ReturnMTobrF($enter,$tid,$dof="tobr"){

    1872. 

  1872. 	global $empire,$dbtbpre;

    1873. 

  1873. 	$record="<!--record-->";

    1874. 

  1874. 	$field="<!--field--->";

    1875. 

  1875. 	$f=",";

    1876. 

  1876. 	$sql=$empire->query("select f from {$dbtbpre}enewsf where ".$dof."=0 and tid='$tid'");

    1877. 

  1877. 	while($r=$empire->fetch($sql))

    1878. 

  1878. 	{

    1879. 

  1879. 		if(strstr($enter,$field.$r[f].$record))

    1880. 

  1880. 		{

    1881. 

  1881. 			$f.=$r[f].",";

    1882. 

  1882. 		}

    1883. 

  1883. 	}

    1884. 

  1884. 	return $f;

    1885. 

  1885. }

    1886. 

  1886. 

    1887. 

  1887. //增加模型

    1888. 

  1888. function AddM($add,$cname,$cchange,$schange,$center,$cqenter,$menter,$listand,$ltempf,$ptempf,$canadd,$canedit,$listorder,$userid,$username){

    1889. 

  1889. 	global $empire,$dbtbpre;

    1890. 

  1890. 	$tid=(int)$add['tid'];

    1891. 

  1891. 	$tbname=RepPostVar($add['tbname']);

    1892. 

  1892. 	if(empty($add[mname])||!$tid||!$tbname)

    1893. 

  1893. 	{

    1894. 

  1894. 		printerror("EmptyM","history.go(-1)");

    1895. 

  1895. 	}

    1896. 

  1896. 	$listfile=eReturnCPath(str_replace('.','',$add[listfile]),'');

    1897. 

  1897. 	CheckLevel($userid,$username,$classid,"m");//验证权限

    1898. 

  1898. 	//组合采集项

    1899. 

  1899. 	$cj=TogMCj($cname,$cchange);

    1900. 

  1900. 	//组合搜索项

    1901. 

  1901.     $searchvar=TogMSearch($cname,$schange);

    1902. 

  1902. 	//组合必填项

    1903. 

  1903. 	$mustqenterf=TogMustf($cname,$menter);

    1904. 

  1904. 	//组合结合项

    1905. 

  1905. 	$listandf=TogMustf($cname,$listand);

    1906. 

  1906. 	//组合排序项

    1907. 

  1907. 	$orderf=TogMustf($cname,$listorder);

    1908. 

  1908. 	//组合投稿项

    1909. 

  1909. 	$qenter=TogMqenter($cname,$cqenter);

    1910. 

  1910. 	//组合可增加项

    1911. 

  1911. 	$canaddf=TogMustf($cname,$canadd);

    1912. 

  1912. 	//组合可修改项

    1913. 

  1913. 	$caneditf=TogMustf($cname,$canedit);

    1914. 

  1914. 	//组合录入项

    1915. 

  1915.     $er=TogMEnter($cname,$center,$ltempf,$ptempf,$tid);

    1916. 

  1916.     $enter=$er[0];	//录入项

    1917. 

  1917. 	$listtempvar=$er[1];	//列表模板项

    1918. 

  1918. 	$tempvar=$er[2];	//内容模板项

    1919. 

  1919. 	//自动生成表单

    1920. 

  1920. 	if($add[mtype])

    1921. 

  1921. 	{

    1922. 

  1922. 		$add[mtemp]=ReturnMtemp($cname,$center);

    1923. 

  1923. 	}

    1924. 

  1924. 	if($add[qmtype])

    1925. 

  1925. 	{

    1926. 

  1926. 		$add[qmtemp]=ReturnQmtemp($cname,$cqenter);

    1927. 

  1927. 	}

    1928. 

  1928. 	$setandf=(int)$add['setandf'];

    1929. 

  1929. 	$add[definfovoteid]=(int)$add[definfovoteid];

    1930. 

  1930. 	$showmod=(int)$add['showmod'];

    1931. 

  1931. 	$usemod=(int)$add['usemod'];

    1932. 

  1932. 	$myorder=(int)$add['myorder'];

    1933. 

  1933. 	$add[printtempid]=(int)$add[printtempid];

    1934. 

  1934. 	$sql=$empire->query("insert into {$dbtbpre}enewsmod(mname,mtemp,mzs,cj,enter,tempvar,sonclass,searchvar,tid,tbname,qenter,mustqenterf,qmtemp,listandf,setandf,listtempvar,qmname,canaddf,caneditf,definfovoteid,showmod,usemod,myorder,orderf,isdefault,listfile,printtempid) values('$add[mname]','".addslashes($add[mtemp])."','$add[mzs]','$cj','$enter','$tempvar','','$searchvar',$tid,'$tbname','$qenter','$mustqenterf','".addslashes($add[qmtemp])."','".addslashes($listandf)."','$setandf','$listtempvar','$add[qmname]','$canaddf','$caneditf',$add[definfovoteid],'$showmod','$usemod','$myorder','$orderf',0,'$listfile','$add[printtempid]');");

    1935. 

  1935. 	$mid=$empire->lastid();

    1936. 

  1936. 	UpdateTbDefMod($tid,$tbname,$mid);

    1937. 

  1937. 	//更新表单

    1938. 

  1938. 	ChangeMForm($mid,$tid,$add[mtemp]);

    1939. 

  1939. 	ChangeQmForm($mid,$tid,$add[qmtemp]);

    1940. 

  1940. 	//采集文件

    1941. 

  1941. 	ChangeMCj($mid,$tid,$cj);

    1942. 

  1942. 	GetConfig(1);//更新缓存

    1943. 

  1943.     if($sql)

    1944. 

  1944. 	{

    1945. 

  1945. 	    insert_dolog("mid=".$mid."<br>m=".$add[mname]);//操作日志

    1946. 

  1946. 		printerror("AddMSuccess","db/ListM.php?tid=$tid&tbname=$tbname");

    1947. 

  1947. 	}

    1948. 

  1948. 	else

    1949. 

  1949. 	{

    1950. 

  1950. 		printerror("DbError","history.go(-1)");

    1951. 

  1951. 	}

    1952. 

  1952. }

    1953. 

  1953. 

    1954. 

  1954. //修改模型

    1955. 

  1955. function EditM($add,$cname,$cchange,$schange,$center,$cqenter,$menter,$listand,$ltempf,$ptempf,$canadd,$canedit,$listorder,$userid,$username){

    1956. 

  1956. 	global $empire,$dbtbpre;

    1957. 

  1957. 	$tid=(int)$add['tid'];

    1958. 

  1958. 	$tbname=RepPostVar($add['tbname']);

    1959. 

  1959. 	$add[mid]=(int)$add[mid];

    1960. 

  1960. 	if(empty($add[mname])||empty($add[mid])||!$tid||!$tbname)

    1961. 

  1961. 	{

    1962. 

  1962. 		printerror("EmptyM","history.go(-1)");

    1963. 

  1963. 	}

    1964. 

  1964. 	$listfile=eReturnCPath(str_replace('.','',$add[listfile]),'');

    1965. 

  1965. 	//验证权限

    1966. 

  1966. 	CheckLevel($userid,$username,$classid,"m");

    1967. 

  1967. 	//组合采集项

    1968. 

  1968. 	$cj=TogMCj($cname,$cchange);

    1969. 

  1969. 	//组合搜索项

    1970. 

  1970.     $searchvar=TogMSearch($cname,$schange);

    1971. 

  1971. 	//组合必填项

    1972. 

  1972. 	$mustqenterf=TogMustf($cname,$menter);

    1973. 

  1973. 	//组合结合项

    1974. 

  1974. 	$listandf=TogMustf($cname,$listand);

    1975. 

  1975. 	//组合排序项

    1976. 

  1976. 	$orderf=TogMustf($cname,$listorder);

    1977. 

  1977. 	//组合投稿项

    1978. 

  1978. 	$qenter=TogMqenter($cname,$cqenter);

    1979. 

  1979. 	//组合可增加项

    1980. 

  1980. 	$canaddf=TogMustf($cname,$canadd);

    1981. 

  1981. 	//组合可修改项

    1982. 

  1982. 	$caneditf=TogMustf($cname,$canedit);

    1983. 

  1983. 	//组合录入项

    1984. 

  1984. 	$er=TogMEnter($cname,$center,$ltempf,$ptempf,$tid);

    1985. 

  1985.     $enter=$er[0];	//录入项

    1986. 

  1986. 	$listtempvar=$er[1];	//列表模板项

    1987. 

  1987. 	$tempvar=$er[2];	//内容模板项

    1988. 

  1988. 	//自动生成表单

    1989. 

  1989. 	if($add[mtype])

    1990. 

  1990. 	{

    1991. 

  1991. 		$add[mtemp]=ReturnMtemp($cname,$center);

    1992. 

  1992. 	}

    1993. 

  1993. 	if($add[qmtype])

    1994. 

  1994. 	{

    1995. 

  1995. 		$add[qmtemp]=ReturnQmtemp($cname,$cqenter);

    1996. 

  1996. 	}

    1997. 

  1997. 	$setandf=(int)$add['setandf'];

    1998. 

  1998. 	$add[definfovoteid]=(int)$add[definfovoteid];

    1999. 

  1999. 	$showmod=(int)$add['showmod'];

    2000. 

  2000. 	$usemod=(int)$add['usemod'];

    2001. 

  2001. 	$myorder=(int)$add['myorder'];

    2002. 

  2002. 	$add[printtempid]=(int)$add[printtempid];

    2003. 

  2003. 	$sql=$empire->query("update {$dbtbpre}enewsmod set mname='$add[mname]',mtemp='".addslashes($add[mtemp])."',mzs='$add[mzs]',cj='$cj',enter='$enter',tempvar='$tempvar',searchvar='$searchvar',qenter='$qenter',mustqenterf='$mustqenterf',qmtemp='".addslashes($add[qmtemp])."',listandf='".addslashes($listandf)."',setandf=$setandf,listtempvar='$listtempvar',qmname='$add[qmname]',canaddf='$canaddf',caneditf='$caneditf',definfovoteid=$add[definfovoteid],showmod='$showmod',usemod='$usemod',myorder='$myorder',orderf='$orderf',listfile='$listfile',printtempid='$add[printtempid]' where mid='$add[mid]'");

    2004. 

  2004. 	//更新表单

    2005. 

  2005. 	ChangeMForm($add[mid],$tid,$add[mtemp]);

    2006. 

  2006. 	ChangeQmForm($add[mid],$tid,$add[qmtemp]);

    2007. 

  2007. 	//采集文件

    2008. 

  2008. 	ChangeMCj($add[mid],$tid,$cj);

    2009. 

  2009. 	GetConfig(1);//更新缓存

    2010. 

  2010.     if($sql)

    2011. 

  2011. 	{

    2012. 

  2012. 		//操作日志

    2013. 

  2013. 	    insert_dolog("mid=".$add[mid]."<br>m=".$add[mname]);

    2014. 

  2014. 		printerror("EditMSuccess","db/ListM.php?tid=$tid&tbname=$tbname");

    2015. 

  2015. 	}

    2016. 

  2016. 	else

    2017. 

  2017. 	{

    2018. 

  2018. 		printerror("DbError","history.go(-1)");

    2019. 

  2019. 	}

    2020. 

  2020. }

    2021. 

  2021. 

    2022. 

  2022. //删除模型

    2023. 

  2023. function DelM($mid,$tid,$tbname,$userid,$username){

    2024. 

  2024. 	global $empire,$dbtbpre;

    2025. 

  2025. 	$tid=(int)$tid;

    2026. 

  2026. 	$tbname=RepPostVar($tbname);

    2027. 

  2027. 	$mid=(int)$mid;

    2028. 

  2028. 	if(empty($mid)||!$tid||!$tbname)

    2029. 

  2029. 	{

    2030. 

  2030. 		printerror("EmptyMid","history.go(-1)");

    2031. 

  2031. 	}

    2032. 

  2032. 	//验证权限

    2033. 

  2033. 	CheckLevel($userid,$username,$classid,"m");

    2034. 

  2034. 	$r=$empire->fetch1("select mname,isdefault from {$dbtbpre}enewsmod where mid='$mid'");

    2035. 

  2035. 	$sql=$empire->query("delete from {$dbtbpre}enewsmod where mid='$mid'");

    2036. 

  2036. 	$empire->query("delete from {$dbtbpre}enewsinfotype where mid='$mid'");//删除主题分类

    2037. 

  2037. 	DelFiletext("../data/html/".$mid.".php");

    2038. 

  2038. 	DelFiletext("../data/html/q".$mid.".php");

    2039. 

  2039. 	DelFiletext("../data/html/cj".$mid.".php");

    2040. 

  2040. 	DelFiletext("../data/html/editcj".$mid.".php");

    2041. 

  2041. 	//表默认模型

    2042. 

  2042. 	if($r[isdefault])

    2043. 

  2043. 	{

    2044. 

  2044. 		$modr=$empire->fetch1("select mid from {$dbtbpre}enewsmod where tid='$tid' order by mid");

    2045. 

  2045. 		if($modr[mid])

    2046. 

  2046. 		{

    2047. 

  2047. 			$empire->query("update {$dbtbpre}enewstable set mid='$modr[mid]' where tid='$tid'");

    2048. 

  2048. 			$empire->query("update {$dbtbpre}enewsmod set isdefault=1 where mid='$modr[mid]'");

    2049. 

  2049. 		}

    2050. 

  2050. 	}

    2051. 

  2051. 	GetConfig(1);//更新缓存

    2052. 

  2052.     if($sql)

    2053. 

  2053. 	{

    2054. 

  2054. 	    insert_dolog("mid=".$mid."<br>m=".$r[mname]);//操作日志

    2055. 

  2055. 		printerror("DelMSuccess","db/ListM.php?tid=$tid&tbname=$tbname");

    2056. 

  2056. 	}

    2057. 

  2057. 	else

    2058. 

  2058. 	{

    2059. 

  2059. 		printerror("DbError","history.go(-1)");

    2060. 

  2060. 	}

    2061. 

  2061. }

    2062. 

  2062. 

    2063. 

  2063. //默认模型

    2064. 

  2064. function DefM($mid,$tid,$tbname,$userid,$username){

    2065. 

  2065. 	global $empire,$dbtbpre;

    2066. 

  2066. 	$tid=(int)$tid;

    2067. 

  2067. 	$tbname=RepPostVar($tbname);

    2068. 

  2068. 	$mid=(int)$mid;

    2069. 

  2069. 	if(empty($mid)||!$tid||!$tbname)

    2070. 

  2070. 	{

    2071. 

  2071. 		printerror("EmptyDefMid","history.go(-1)");

    2072. 

  2072. 	}

    2073. 

  2073. 	//验证权限

    2074. 

  2074. 	CheckLevel($userid,$username,$classid,"m");

    2075. 

  2075. 	$r=$empire->fetch1("select mname from {$dbtbpre}enewsmod where mid='$mid'");

    2076. 

  2076. 	$empire->query("update {$dbtbpre}enewsmod set isdefault=0 where tid='$tid'");

    2077. 

  2077. 	$sql=$empire->query("update {$dbtbpre}enewsmod set isdefault=1 where mid='$mid'");

    2078. 

  2078. 	$empire->query("update {$dbtbpre}enewstable set mid='$mid' where tid='$tid'");

    2079. 

  2079. 	GetConfig(1);//更新缓存

    2080. 

  2080. 	if($sql)

    2081. 

  2081. 	{

    2082. 

  2082. 	    insert_dolog("mid=".$mid."<br>m=".$r[mname]);//操作日志

    2083. 

  2083. 		printerror("DefMSuccess","db/ListM.php?tid=$tid&tbname=$tbname");

    2084. 

  2084. 	}

    2085. 

  2085. 	else

    2086. 

  2086. 	{

    2087. 

  2087. 		printerror("DbError","history.go(-1)");

    2088. 

  2088. 	}

    2089. 

  2089. }

    2090. 

  2090. 

    2091. 

  2091. //更新模型表单文件

    2092. 

  2092. function ChangeAllModForm($add,$userid,$username){

    2093. 

  2093. 	global $empire,$dbtbpre;

    2094. 

  2094. 	//验证权限

    2095. 

  2095. 	CheckLevel($userid,$username,$classid,"changedata");

    2096. 

  2096. 	$sql=$empire->query("select mid,tid,mtemp,qmtemp,cj from {$dbtbpre}enewsmod");

    2097. 

  2097. 	while($r=$empire->fetch($sql))

    2098. 

  2098. 	{

    2099. 

  2099. 		ChangeMForm($r[mid],$r[tid],$r[mtemp]);//更新表单

    2100. 

  2100. 		ChangeQmForm($r[mid],$r[tid],$r[qmtemp]);//更新前台表单

    2101. 

  2101. 		ChangeMCj($r[mid],$r[tid],$r[cj]);//采集表单

    2102. 

  2102. 		//更新栏目导航

    2103. 

  2103. 		if($add['ChangeClass']==1)

    2104. 

  2104. 		{

    2105. 

  2105. 			GetSearch($r[mid]);

    2106. 

  2106. 		}

    2107. 

  2107. 	}

    2108. 

  2108. 	//操作日志

    2109. 

  2109. 	insert_dolog("ChangeClass=$add[ChangeClass]");

    2110. 

  2110. 	printerror("ChangeAllModFormSuccess","history.go(-1)");

    2111. 

  2111. }

    2112. 

  2112. 

    2113. 

  2113. //导入系统模型

    2114. 

  2114. function LoadInMod($add,$file,$file_name,$file_type,$file_size,$userid,$username){

    2115. 

  2115. 	global $empire,$dbtbpre,$phome_db_dbchar;

    2116. 

  2116. 	//验证权限

    2117. 

  2117. 	CheckLevel($userid,$username,$classid,"table");

    2118. 

  2118. 	$tbname=RepPostVar(trim($add['tbname']));

    2119. 

  2119. 	if(!$file_name||!$file_size||!$tbname)

    2120. 

  2120. 	{

    2121. 

  2121. 		printerror("EmptyLoadInMod","");

    2122. 

  2122. 	}

    2123. 

  2123. 	//扩展名

    2124. 

  2124. 	$filetype=GetFiletype($file_name);

    2125. 

  2125. 	if($filetype!=".mod")

    2126. 

  2126. 	{

    2127. 

  2127. 		printerror("LoadInModMustmod","");

    2128. 

  2128. 	}

    2129. 

  2129. 	//表名是否已存在

    2130. 

  2130. 	$num=$empire->gettotal("select count(*) as total from {$dbtbpre}enewstable where tbname='$tbname' limit 1");

    2131. 

  2131. 	if($num)

    2132. 

  2132. 	{

    2133. 

  2133. 		printerror("HaveLoadInTb","");

    2134. 

  2134. 	}

    2135. 

  2135. 	//上传文件

    2136. 

  2136. 	$path=ECMS_PATH."e/data/tmp/mod/uploadm".time().make_password(10).".php";

    2137. 

  2137. 	$cp=@move_uploaded_file($file,$path);

    2138. 

  2138. 	if(!$cp)

    2139. 

  2139. 	{

    2140. 

  2140. 		printerror("EmptyLoadInMod","");

    2141. 

  2141. 	}

    2142. 

  2142. 	DoChmodFile($path);

    2143. 

  2143. 	@include($path);

    2144. 

  2144. 	UpdateTbDefMod($tid,$tbname,$mid);

    2145. 

  2145. 	//公共变量

    2146. 

  2146. 	TogSaveTxtF(1);

    2147. 

  2147. 	GetConfig(1);//更新缓存

    2148. 

  2148. 	//生成模型表单文件

    2149. 

  2149. 	$modr=$empire->fetch1("select mtemp,qmtemp,cj from {$dbtbpre}enewsmod where mid='$mid'");

    2150. 

  2150. 	ChangeMForm($mid,$tid,$modr[mtemp]);//更新表单

    2151. 

  2151. 	ChangeQmForm($mid,$tid,$modr[qmtemp]);//更新前台表单

    2152. 

  2152. 	ChangeMCj($mid,$tid,$modr[cj]);//采集表单

    2153. 

  2153. 	//删除文件

    2154. 

  2154. 	DelFiletext($path);

    2155. 

  2155. 	//操作日志

    2156. 

  2156. 	insert_dolog("tid=$tid&tb=$tbname<br>mid=$mid");

    2157. 

  2157. 	printerror("LoadInModSuccess","db/ListTable.php");

    2158. 

  2158. }

    2159. 

  2159. 

    2160. 

  2160. //导出系统模型

    2161. 

  2161. function LoadOutMod($add,$userid,$username){

    2162. 

  2162. 	global $empire,$dbtbpre;

    2163. 

  2163. 	$tid=(int)$add['tid'];

    2164. 

  2164. 	$tbname=RepPostVar($add['tbname']);

    2165. 

  2165. 	$mid=(int)$add['mid'];

    2166. 

  2166. 	if(!$tid||!$tbname||!$mid)

    2167. 

  2167. 	{

    2168. 

  2168. 		printerror("EmptyLoadMod","");

    2169. 

  2169. 	}

    2170. 

  2170. 	$mr=$empire->fetch1("select * from {$dbtbpre}enewsmod where mid=$mid and tid=$tid");

    2171. 

  2171. 	if(!$mr['mid'])

    2172. 

  2172. 	{

    2173. 

  2173. 		printerror("EmptyLoadMod","");

    2174. 

  2174. 	}

    2175. 

  2175. 	$tr=$empire->fetch1("select tbname,tname,tsay from {$dbtbpre}enewstable where tid=$tid");

    2176. 

  2176. 	if(!$tr['tbname'])

    2177. 

  2177. 	{

    2178. 

  2178. 		printerror("EmptyLoadMod","");

    2179. 

  2179. 	}

    2180. 

  2180. 	//数据表结构

    2181. 

  2181. 	$loadmod="<?php

    2182. 

  2182. ".LoadModReturnstru($dbtbpre."ecms_".$mr['tbname'],$mr['tbname'],0)."\r\n";

    2183. 

  2183. 	$loadmod.=LoadModReturnstru($dbtbpre."ecms_".$mr['tbname']."_data_1",$mr['tbname'],5)."\r\n";

    2184. 

  2184. 	$loadmod.=LoadModReturnstru($dbtbpre."ecms_".$mr['tbname']."_doc",$mr['tbname'],1)."\r\n";

    2185. 

  2185. 	$loadmod.=LoadModReturnstru($dbtbpre."ecms_".$mr['tbname']."_doc_data",$mr['tbname'],4)."\r\n";

    2186. 

  2186. 	$loadmod.=LoadModReturnstru($dbtbpre."ecms_infoclass_".$mr['tbname'],$mr['tbname'],2)."\r\n";

    2187. 

  2187. 	$loadmod.=LoadModReturnstru($dbtbpre."ecms_infotmp_".$mr['tbname'],$mr['tbname'],3)."\r\n";

    2188. 

  2188. 	//数据表

    2189. 

  2189. 	$loadmod.="\$empire->query(\"insert into \".\$dbtbpre.\"enewstable(tbname,tname,tsay,isdefault,datatbs,deftb,yhid,mid) values('\$tbname','".$tr[tname]."','".LMEscape_str($tr[tsay])."',0,',1,','1',0,0);\");

    2190. 

  2190. \$tid=\$empire->lastid();

    2191. 

  2191. ";

    2192. 

  2192. 	//字段

    2193. 

  2193. 	$fsql=$empire->query("select * from {$dbtbpre}enewsf where tid=$tid order by fid");

    2194. 

  2194. 	while($fr=$empire->fetch($fsql))

    2195. 

  2195. 	{

    2196. 

  2196. 		$loadmod.="\$empire->query(\"insert into \".\$dbtbpre.\"enewsf(f,fname,fform,fhtml,fzs,isadd,isshow,iscj,cjhtml,myorder,ftype,flen,dotemp,tid,tbname,savetxt,fvalue,iskey,tobr,dohtml,qfhtml,isonly,linkfieldval,samedata,fformsize,tbdataf,ispage,adddofun,editdofun,qadddofun,qeditdofun,linkfieldtb,linkfieldshow,editorys,issmalltext) values('$fr[f]','$fr[fname]','$fr[fform]','".LMEscape_str($fr['fhtml'])."','".LMEscape_str($fr[fzs])."',$fr[isadd],$fr[isshow],$fr[iscj],'".LMEscape_str($fr[cjhtml])."',$fr[myorder],'$fr[ftype]','$fr[flen]',$fr[dotemp],\$tid,'\$tbname',$fr[savetxt],'".LMEscape_str($fr[fvalue])."',$fr[iskey],$fr[tobr],$fr[dohtml],'".LMEscape_str($fr[qfhtml])."',$fr[isonly],'".LMEscape_str($fr[linkfieldval])."',$fr[samedata],'$fr[fformsize]','$fr[tbdataf]','$fr[ispage]','".LMEscape_str($fr[adddofun])."','".LMEscape_str($fr[editdofun])."','".LMEscape_str($fr[qadddofun])."','".LMEscape_str($fr[qeditdofun])."','".LMEscape_str($fr[linkfieldtb])."','".LMEscape_str($fr[linkfieldshow])."','$fr[editorys]','$fr[issmalltext]');\");

    2197. 

  2197. ";

    2198. 

  2198. 	}

    2199. 

  2199. 	//模型

    2200. 

  2200. 	$loadmod.="\$empire->query(\"insert into \".\$dbtbpre.\"enewsmod(mname,mtemp,mzs,cj,enter,tempvar,sonclass,searchvar,tid,tbname,qenter,mustqenterf,qmtemp,listandf,setandf,listtempvar,qmname,canaddf,caneditf,definfovoteid,showmod,usemod,myorder,orderf,isdefault,listfile,printtempid) values('$mr[mname]','".LMEscape_str($mr[mtemp])."','".LMEscape_str($mr[mzs])."','".LMEscape_str($mr[cj])."','".LMEscape_str($mr[enter])."','".LMEscape_str($mr[tempvar])."','','".LMEscape_str($mr[searchvar])."',\$tid,'\$tbname','".LMEscape_str($mr[qenter])."','".LMEscape_str($mr[mustqenterf])."','".LMEscape_str($mr[qmtemp])."','".LMEscape_str($mr[listandf])."',$mr[setandf],'".LMEscape_str($mr[listtempvar])."','".LMEscape_str($mr[qmname])."','".LMEscape_str($mr[canaddf])."','".LMEscape_str($mr[caneditf])."',0,0,0,0,'".LMEscape_str($mr[orderf])."',0,'',0);\");

    2201. 

  2201. \$mid=\$empire->lastid();

    2202. 

  2202. ?>";

    2203. 

  2203. 	$file=$tr['tbname'].time().".mod";

    2204. 

  2204. 	$filepath=ECMS_PATH."e/data/tmp/mod/".$file;

    2205. 

  2205. 	WriteFiletext_n($filepath,AddCheckViewTempCode().$loadmod);

    2206. 

  2206. 	DownLoadFile($file,$filepath,1);

    2207. 

  2207. 	//操作日志

    2208. 

  2208. 	insert_dolog("tid=$tid&tb=$tr[tbname]<br>mid=$mid&m=$mr[mname]");

    2209. 

  2209. 	exit();

    2210. 

  2210. }

    2211. 

  2211. 

    2212. 

  2212. //返回数据表结构

    2213. 

  2213. function LoadModReturnstru($table,$tb,$ecms=0){

    2214. 

  2214. 	global $empire;

    2215. 

  2215. 	$usql=$empire->query("SET SQL_QUOTE_SHOW_CREATE=1;");//设置引号

    2216. 

  2216. 	$r=$empire->fetch1("SHOW CREATE TABLE `$table`;");//数据表结构

    2217. 

  2217. 	$create=str_replace("\"","\\\"",$r[1]);

    2218. 

  2218. 	$create=LoadModToMysqlFour($create);

    2219. 

  2219. 	//替换表

    2220. 

  2220. 	if($ecms==1)

    2221. 

  2221. 	{

    2222. 

  2222. 		$reptb="\$dbtbpre.\"ecms_\".\$tbname.\"_doc\"";

    2223. 

  2223. 	}

    2224. 

  2224. 	elseif($ecms==2)

    2225. 

  2225. 	{

    2226. 

  2226. 		$reptb="\$dbtbpre.\"ecms_infoclass_\".\$tbname";

    2227. 

  2227. 	}

    2228. 

  2228. 	elseif($ecms==3)

    2229. 

  2229. 	{

    2230. 

  2230. 		$reptb="\$dbtbpre.\"ecms_infotmp_\".\$tbname";

    2231. 

  2231. 	}

    2232. 

  2232. 	elseif($ecms==4)

    2233. 

  2233. 	{

    2234. 

  2234. 		$reptb="\$dbtbpre.\"ecms_\".\$tbname.\"_doc_data\"";

    2235. 

  2235. 	}

    2236. 

  2236. 	elseif($ecms==5)

    2237. 

  2237. 	{

    2238. 

  2238. 		$reptb="\$dbtbpre.\"ecms_\".\$tbname.\"_data_1\"";

    2239. 

  2239. 	}

    2240. 

  2240. 	else

    2241. 

  2241. 	{

    2242. 

  2242. 		$reptb="\$dbtbpre.\"ecms_\".\$tbname";

    2243. 

  2243. 	}

    2244. 

  2244. 	$dumpsql.="\$empire->query(str_replace(\"".$table."\",$reptb,SetCreateTable(\"".$create."\",\$phome_db_dbchar)));\r\n";

    2245. 

  2245. 	return $dumpsql;

    2246. 

  2246. }

    2247. 

  2247. 

    2248. 

  2248. //转为Mysql4.0格式

    2249. 

  2249. function LoadModToMysqlFour($query){

    2250. 

  2250. 	$exp="ENGINE=";

    2251. 

  2251. 	if(!strstr($query,$exp))

    2252. 

  2252. 	{

    2253. 

  2253. 		return $query;

    2254. 

  2254. 	}

    2255. 

  2255. 	$exp1=" ";

    2256. 

  2256. 	$r=explode($exp,$query);

    2257. 

  2257. 	//取得表类型

    2258. 

  2258. 	$r1=explode($exp1,$r[1]);

    2259. 

  2259. 	$returnquery=$r[0]."TYPE=".$r1[0];

    2260. 

  2260. 	return $returnquery;

    2261. 

  2261. }

    2262. 

  2262. 

    2263. 

  2263. //字符过虑

    2264. 

  2264. function LMEscape_str($str){

    2265. 

  2265. 	$str=mysql_escape_string($str);

    2266. 

  2266. 	$str=str_replace('\\\'','\'\'',$str);

    2267. 

  2267. 	$str=str_replace("\\\\","\\\\\\\\",$str);

    2268. 

  2268. 	$str=str_replace('$','\$',$str);

    2269. 

  2269. 	return $str;

    2270. 

  2270. }

    2271. 

  2271. ?>
    2272.