PageRenderTime 57ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/admin/kernel/article.class.php

http://xklog.googlecode.com/
PHP | 904 lines | 812 code | 48 blank | 44 comment | 103 complexity | 355cd64e57018694769a35fec4d19859 MD5 | raw file
Possible License(s): AGPL-1.0 
    

  1. <?php
    2. 

  2. 

  3. !defined('IN_NOVA') && exit('Access Denied!');
    4. 

  4. 

  5. class Article {
    6. 

  6. 

  7. 	public function start() {
    8. 

  8. 		global $db,$cache,$request;
    9. 

  9. 

  10. 		$action = $request->get( 'p' );
    11. 

  11. 		$id = $request->id;
    12. 

  12. 

  13. 		switch( $action ) {
    14. 

  14. 			case 'add':
    15. 

  15. 				$this->article_add();
    16. 

  16. 				break;
    17. 

  17. 			case 'edit':
    18. 

  18. 				$this->article_add( 'edit' );
    19. 

  19. 				break;
    20. 

  20. 			case 'saveadd':
    21. 

  21. 				// ??????
    22. 

  22. 				$article_id = $this->add();
    23. 

  23. 				if( $article_id == 0 ) {
    24. 

  24. 					break;
    25. 

  25. 				}
    26. 

  26. 				//$article_type = $request->get( 'article_type', 'P' );
    27. 

  27. 				if( $cache->config['arttype'] == '??' ){
    28. 

  28. 					page_make( $article_id, $article_type );
    29. 

  29. 				}
    30. 

  30. 				$cache->refresh( 'count', TRUE );
    31. 

  31. 				$cache->refresh( 'article_new', TRUE );
    32. 

  32. 				$cache->refresh( 'article_list', TRUE );
    33. 

  33. 				echo '<p class="warning">' . L('_ADD_ARTICLE_SUCCESS_') . '</p>';
    34. 

  34. 				break;
    35. 

  35. 			case 'saveedit':
    36. 

  36. 				// ??????
    37. 

  37. 				if( $this->edit( $id ) == 0 ) {
    38. 

  38. 					break;
    39. 

  39. 				}
    40. 

  40. 				$article_type = $request->get('article_type','P');
    41. 

  41. 				if( $cache->config['arttype'] == '??' ){
    42. 

  42. 					page_make( $article_id, $article_type );
    43. 

  43. 				}
    44. 

  44. 				$cache->refresh( 'article_hot', TRUE );
    45. 

  45. 				$cache->refresh( 'article_new', TRUE );
    46. 

  46. 				$cache->refresh( 'article_list', TRUE );
    47. 

  47. 				echo '<p class="warning">' . L('_EDIT_ARTICLE_SUCCESS_') . '</p>';
    48. 

  48. 				break;
    49. 

  49. 			case 'top':
    50. 

  50. 				// ??????
    51. 

  51. 				$db->query( "UPDATE `" . DB_PREFIX . "article` SET istop = 1 WHERE id=$id" );
    52. 

  52. 				// ????
    53. 

  53. 				$cache->refresh( 'article_list', TRUE );
    54. 

  54. 				echo '<p class="warning">' . '??????' . '</p>';
    55. 

  55. 				break;
    56. 

  56. 			case 'topcancel':
    57. 

  57. 				// ????????
    58. 

  58. 				$db->query( "UPDATE `" . DB_PREFIX . "article` SET istop = 0 WHERE id=$id" );
    59. 

  59. 				// ????
    60. 

  60. 				$cache->refresh( 'article_list', TRUE );
    61. 

  61. 				echo '<p class="warning">' . '????????' . '</p>';
    62. 

  62. 				break;
    63. 

  63. 			case 'reflash':
    64. 

  64. 				// ??????
    65. 

  65. 				/*page_make_html( $id );
    66. 

  66. 				$db->query( "UPDATE `" . DB_PREFIX . "article` SET `update`=0 WHERE id=$id" );*/
    67. 

  67. 				echo '<p class="warning">' . '??????' . '</p>';
    68. 

  68. 				break;
    69. 

  69. 			case 'del':
    70. 

  70. 				// ??????
    71. 

  71. 				$category = $db->result( "SELECT category FROM `" . DB_PREFIX . "article` WHERE id=$id AND isdel = 0" );
    72. 

  72. 				if( $category == '' ) {
    73. 

  73. 					$theme->show_message( '??????' );
    74. 

  74. 					break;
    75. 

  75. 				}
    76. 

  76. 				// ??????
    77. 

  77. 				$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum = articlenum - 1 WHERE cid=$category" );
    78. 

  78. 				// ????????
    79. 

  79. 				$db->query( "UPDATE `" . DB_PREFIX . "comment` SET isdel = 1 WHERE articleid=$id" );
    80. 

  80. 				// ??????
    81. 

  81. 				$tags = $db->result( "SELECT tag FROM `" . DB_PREFIX . "article` WHERE id=$id" );
    82. 

  82. 				$tags = str_replace( '*}{*',',',$tags );
    83. 

  83. 				$tags = str_replace( '*}','',$tags );
    84. 

  84. 				$tags = str_replace( '{*','',$tags );
    85. 

  85. 				$tags = split( ',' , $tags );
    86. 

  86. 				foreach($tags as $tag){
    87. 

  87. 					if( $tag != '' ){
    88. 

  88. 						$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num=t_num-1 WHERE t_id=$tag" );
    89. 

  89. 					}
    90. 

  90. 				}
    91. 

  91. 				// ????
    92. 

  92. 				$db->query( "UPDATE `" . DB_PREFIX . "article` SET isdel = 1 WHERE id=$id" );
    93. 

  93. 				// ????
    94. 

  94. 				$cache->article_new = NULL;
    95. 

  95. 				$cache->article_hot = NULL;
    96. 

  96. 				$cache->comment_new = NULL;
    97. 

  97. 				$cache->category = NULL;
    98. 

  98. 				$cache->count = NULL;
    99. 

  99. 				$cache->tag = NULL;
    100. 

  100. 				echo '<p class="warning">' . '??????' . '</p>';
    101. 

  101. 				break;
    102. 

  102. 			case 'addreply':
    103. 

  103. 				// ??????
    104. 

  104. 				$reply = htmlspecialchars( $request->get('commentreply','P') );
    105. 

  105. 				$reply = str_replace( array("\r\n", "\n", "\r"), '<br />', $reply );
    106. 

  106. 				$db->query( "UPDATE `" . DB_PREFIX . "comment` SET replyuser = '" . $_SESSION['user_name'] . "',reply = '$reply',replytime = " . PHP_TIME . " WHERE cid = $id" );
    107. 

  107. 				echo '<p class="warning">' . '??????' . '</p>';
    108. 

  108. 				break;
    109. 

  109. 			case 'delreply':
    110. 

  110. 				// ??????
    111. 

  111. 				$db->query( "UPDATE `" . DB_PREFIX . "comment` SET replyuser = NULL WHERE cid = $id" );
    112. 

  112. 				echo '<p class="warning">' . '??????' . '</p>';
    113. 

  113. 				break;
    114. 

  114. 			case 'delcomment':
    115. 

  115. 				// ??????
    116. 

  116. 				$aid = $db->result( "SELECT articleid FROM `" . DB_PREFIX . "comment` WHERE cid=$id AND isdel = 0" );
    117. 

  117. 				if( $aid == '' ) {
    118. 

  118. 					echo '<p class="error">' . '??????' . '</p>';
    119. 

  119. 					break;
    120. 

  120. 				}
    121. 

  121. 				$db->query( "UPDATE `" . DB_PREFIX . "article` SET comment=comment-1 WHERE id=$aid" );
    122. 

  122. 				$db->query( "UPDATE `" . DB_PREFIX . "comment` SET isdel=1 WHERE cid=$id" );
    123. 

  123. 				$cache->article_hot = NULL;
    124. 

  124. 				$cache->comment_new = NULL;
    125. 

  125. 				$cache->guestbook_new = NULL;
    126. 

  126. 				$cache->count = NULL;
    127. 

  127. 				echo '<p class="warning">' . '??????' . '</p>';
    128. 

  128. 				break;
    129. 

  129. 			case 'censor':
    130. 

  130. 				// ??????
    131. 

  131. 				$db->query( "UPDATE `" . DB_PREFIX . "comment` SET isshow = 1 WHERE cid = $id" );
    132. 

  132. 				$cache->comment_new = NULL;
    133. 

  133. 				$cache->guestbook_new = NULL;
    134. 

  134. 				echo '<p class="warning">' . '??????' . '</p>';
    135. 

  135. 				break;
    136. 

  136. 			case 'MakearticlePage':
    137. 

  137. 			    $this->make_article_page();
    138. 

  138. 				break;
    139. 

  139. 			case 'datacheckexe':
    140. 

  140. 			    $this->data_check_exe();
    141. 

  141. 				break;
    142. 

  142. 			case 'tagdatacheckexe':
    143. 

  143. 				$this->tag_data_check_exe();
    144. 

  144. 				break;
    145. 

  145. 			case 'batch':
    146. 

  146. 				$this->batch();
    147. 

  147. 				break;
    148. 

  148. 			default:
    149. 

  149. 				$this->show( $action );
    150. 

  150. 		}
    151. 

  151. 	}
    152. 

  152. 

  153. 	private function make_article_page() {
    154. 

  154. 		global $db,$_CACHE;
    155. 

  155. 		$_CACHE['count'][0]['online'] = cache_online();
    156. 

  156. 		if( count( $_CACHE['category'] ) == 0 ) {
    157. 

  157. 			show_admin_message( '??????', 'admin_article.php' );
    158. 

  158. 			exit;
    159. 

  159. 		}else{
    160. 

  160. 			foreach( $_CACHE['category'] as $category ) {
    161. 

  161. 				$file_path = XKLOG_ROOT . 'article/' . $category['alias'] . '/';
    162. 

  162. 				if ( !is_dir( $file_path ) ) {
    163. 

  163. 					@mkdir( $file_path, 0777 );
    164. 

  164. 				}
    165. 

  165. 				$article_arr = array();
    166. 

  166. 				$article_arr = $db->fetch_all( "SELECT id FROM `" . DB_PREFIX . "article` WHERE isdel=0 AND category=" . $category['cid'] . " AND type='??' ORDER BY id DESC" );
    167. 

  167. 				foreach( $article_arr as $article ) {
    168. 

  168. 					page_make_html( $article['id'] );
    169. 

  169. 					$db->query( "UPDATE `" . DB_PREFIX . "article` SET `update`=0 WHERE id=" . $article['id'] );
    170. 

  170. 				}
    171. 

  171. 			}
    172. 

  172. 		}
    173. 

  173. 		show_admin_message( '???????????', 'admin_article.php' );
    174. 

  174. 		exit;
    175. 

  175. 	}
    176. 

  176. 

  177. 	private function data_check_exe() {
    178. 

  178. 		global $db,$cache;
    179. 

  179. 		$article_arr = $db->fetch_all( "SELECT id FROM `" . DB_PREFIX . "article`" );
    180. 

  180. 		if( count( $article_arr ) == 0 ) {
    181. 

  181. 			$this->show( 'datacheck', '???????????', 'error' );
    182. 

  182. 			return;
    183. 

  183. 		}
    184. 

  184. 		foreach( $article_arr as $article ) {
    185. 

  185. 			$temp = $db->result( "SELECT COUNT(cid) FROM `" . DB_PREFIX . "comment` WHERE isdel=0 AND articleid=" . $article['id'] );
    186. 

  186. 			 $db->query( "UPDATE `" . DB_PREFIX . "article` SET comment=" . $temp . " WHERE id=" . $article['id'] );
    187. 

  187. 		}
    188. 

  188. 		$cache->refresh( 'article_hot', TRUE );
    189. 

  189. 		$this->show( 'datacheck', '????????????', 'warning' );
    190. 

  190. 	}
    191. 

  191. 

  192. 	private function tag_data_check_exe() {
    193. 

  193. 		global $db,$cache;
    194. 

  194. 		$article_arr = $db->fetch_all( "SELECT tag FROM `" . DB_PREFIX . "article` WHERE isdel=0" );
    195. 

  195. 		$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num=0" );
    196. 

  196. 		$tag_arr = $db->fetch_all( "SELECT t_id,t_name FROM `" . DB_PREFIX . "tags`" );
    197. 

  197. 		if( count( $article_arr ) == 0 ) {
    198. 

  198. 			$this->show( 'datacheck', '???????????', 'error' );
    199. 

  199. 			return;
    200. 

  200. 		}
    201. 

  201. 		foreach( $article_arr as $article ) {
    202. 

  202. 			$article['tag'] = str_replace( '*}{*',',',$article['tag'] );
    203. 

  203. 			$article['tag'] = substr( $article['tag'],2 );
    204. 

  204. 			$article['tag'] = substr( $article['tag'],0,-2 );
    205. 

  205. 			$article['tag'] = explode( ',' , $article['tag'] );
    206. 

  206. 			foreach( $article['tag'] as $tag ) {
    207. 

  207. 				foreach( $tag_arr as $tag_old ) {
    208. 

  208. 					if( $tag == $tag_old['t_id'] ) {
    209. 

  209. 						$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num=t_num+1 WHERE t_id=" . $tag_old['t_id'] );
    210. 

  210. 						break;
    211. 

  211. 					}
    212. 

  212. 				}
    213. 

  213. 			}
    214. 

  214. 		}
    215. 

  215. 		if( $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE isdel=1" ) != 0 ) {
    216. 

  216. 			$this->show( 'datacheck', '??????????????????? 0 ????????????????', 'warning' );
    217. 

  217. 		}else{
    218. 

  218. 			$db->query( "DELETE FROM `" . DB_PREFIX . "tags` WHERE t_num=0" );
    219. 

  219. 			$this->show( 'datacheck', '??????????', 'warning' );
    220. 

  220. 		}
    221. 

  221. 		$cache->refresh( 'tag', TRUE );
    222. 

  222. 	}
    223. 

  223. 

  224. 	private function batch() {
    225. 

  225. 		global $cache,$db;
    226. 

  226. 		$control = getGP( 'Control','P' );
    227. 

  227. 		$id_arr = array();
    228. 

  228. 		$id_arr = getGP( 'id_arr','P','array' );
    229. 

  229. 		$size = count( $id_arr );
    230. 

  230. 		if( $size == 0 ) {
    231. 

  231. 			echo '<p class="error">' . '?????????' . '</p>';
    232. 

  232. 			return;
    233. 

  233. 		}
    234. 

  234. 		$sql = '';
    235. 

  235. 		for( $i=0; $i<$size; $i ++ ){
    236. 

  236. 			$sql .= 'id=' . $id_arr[$i] . ' OR ';
    237. 

  237. 		}
    238. 

  238. 		$sql = substr( $sql,0,-4 );
    239. 

  239. 		if( $control == '??' ) {
    240. 

  240. 			// ????
    241. 

  241. 			$db->query( 'UPDATE `' . DB_PREFIX . 'article` SET isdel=1 WHERE (' . $sql . ')' );
    242. 

  242. 			// ??????
    243. 

  243. 			$tag_arr = $db->fetch_all( "SELECT tag FROM `" . DB_PREFIX . "article` WHERE ( $sql )" );
    244. 

  244. 			foreach( $tag_arr as $tags ) {
    245. 

  245. 				$tags['tag'] = str_replace( '*}{*',',',$tags['tag'] );
    246. 

  246. 				$tags['tag'] = str_replace( '*}','',$tags['tag'] );
    247. 

  247. 				$tags['tag'] = str_replace( '{*','',$tags['tag'] );
    248. 

  248. 				$tags['tag'] = split( ',' , $tags['tag'] );
    249. 

  249. 				foreach($tags['tag'] as $tag){
    250. 

  250. 					if( $tag != '' ){
    251. 

  251. 						$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num=t_num-1 WHERE t_id=$tag" );
    252. 

  252. 					}
    253. 

  253. 				}
    254. 

  254. 			}
    255. 

  255. 			// ??????
    256. 

  256. 			$id_arr = str_replace( 'id=','',$sql );
    257. 

  257. 			$id_arr = split( ' OR ',$id_arr );
    258. 

  258. 			$size = count( $id_arr );
    259. 

  259. 			$sql = '';
    260. 

  260. 			for( $i=0; $i<$size; $i ++ ){
    261. 

  261. 				$sql .= 'articleid=' . $id_arr[$i] . ' OR ';
    262. 

  262. 			}
    263. 

  263. 			$sql = substr( $sql,0,-4 );
    264. 

  264. 			$db->query( "UPDATE `" . DB_PREFIX . "comment` SET isdel = 1 WHERE ( $sql )" );
    265. 

  265. 			// ????????
    266. 

  266. 			foreach( $_CACHE['category'] as $category ) {
    267. 

  267. 				$cid = $category['cid'];
    268. 

  268. 				$article_num = $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE isdel=0 AND category=$cid" );
    269. 

  269. 				if( $category['articlenum'] != $article_num ) {
    270. 

  270. 					$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum=$article_num WHERE cid=$cid" );
    271. 

  271. 				}
    272. 

  272. 			}
    273. 

  273. 			// ????
    274. 

  274. 			cache_article_hot();
    275. 

  275. 			cache_article_new();
    276. 

  276. 			cache_comment_new();
    277. 

  277. 			cache_category();
    278. 

  278. 			cache_count();
    279. 

  279. 			cache_tag();
    280. 

  280. 			show_admin_message( '????????', 'admin_article.php?action=article' );
    281. 

  281. 		}elseif( $control == '??' ) {
    282. 

  282. 			$category = getGP( 'article_category','P','int' );
    283. 

  283. 			$sql = 'UPDATE `' . DB_PREFIX . 'article` SET category=' . $category . ' WHERE (' . $sql . ')';
    284. 

  284. 			$db->query( $sql );
    285. 

  285. 			// ????????
    286. 

  286. 			foreach( $_CACHE['category'] as $category ) {
    287. 

  287. 				$cid = $category['cid'];
    288. 

  288. 				$article_num = $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE isdel=0 AND category=$cid" );
    289. 

  289. 				if( $category['articlenum'] != $article_num ) {
    290. 

  290. 					$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum=$article_num WHERE cid=$cid" );
    291. 

  291. 				}
    292. 

  292. 			}
    293. 

  293. 			// ????
    294. 

  294. 			cache_article_hot();
    295. 

  295. 			cache_article_new();
    296. 

  296. 			cache_category();
    297. 

  297. 			show_admin_message( '?????????????????????', 'admin_article.php?action=article' );
    298. 

  298. 		}elseif( $control == '??' ) {
    299. 

  299. 			$type = getGP( 'article_type','P' );
    300. 

  300. 			$sql2 = "UPDATE `" . DB_PREFIX . "article` SET type='$type' WHERE ( $sql )";
    301. 

  301. 			$db->query( $sql2 );
    302. 

  302. 			// ???????????
    303. 

  303. 			if( $type != '??' ) {
    304. 

  304. 				$_CACHE['count'][0]['online'] = cache_online();
    305. 

  305. 				foreach( $_CACHE['category'] as $category ) {
    306. 

  306. 					$file_path = XKLOG_ROOT . 'article/' . $category['alias'] . '/';
    307. 

  307. 					if ( !is_dir( $file_path ) ) {
    308. 

  308. 						@mkdir( $file_path, 0777 );
    309. 

  309. 					}
    310. 

  310. 					$article_arr = array();
    311. 

  311. 					$article_arr = $db->fetch_all( "SELECT id FROM `" . DB_PREFIX . "article` WHERE ( $sql )" );
    312. 

  312. 					foreach( $article_arr as $article ) {
    313. 

  313. 						page_make( $article['id'], $type );
    314. 

  314. 						$db->query( "UPDATE `" . DB_PREFIX . "article` SET `update`=0 WHERE id=" . $article['id'] );
    315. 

  315. 					}
    316. 

  316. 				}
    317. 

  317. 			}
    318. 

  318. 			// ????
    319. 

  319. 			cache_article_hot();
    320. 

  320. 			cache_article_new();
    321. 

  321. 			show_admin_message( '????????', 'admin_article.php?action=article' );
    322. 

  322. 		}else{
    323. 

  323. 			show_admin_message( '?????', 'admin_article.php' );
    324. 

  324. 		}
    325. 

  325. 	}
    326. 

  326. 

  327. 	// ??????
    328. 

  328. 	private function add(){
    329. 

  329. 		global $cache,$db,$request;
    330. 

  330. 		$title       = $request->get('article_title','P');
    331. 

  331. 		$keywords    = $request->get('article_keywords','P');
    332. 

  332. 		$description = $request->get('article_description','P');
    333. 

  333. 		$content     = $request->get('article_content','P');
    334. 

  334. 		$summary     = $request->get('article_summary','P');
    335. 

  335. 		$address     = $request->get('article_alias','P');
    336. 

  336. 		$type        = $request->get('article_type','P');
    337. 

  337. 		if( trim( $title ) == '' || trim( $content ) == '' ){
    338. 

  338. 			echo '<p class="error">' . '??????????????' . '</p>';
    339. 

  339. 			return 0;
    340. 

  340. 		}
    341. 

  341. 		if( strlen( $content ) > $cache->config['artmaxlength'] ){
    342. 

  342. 			echo '<p class="error">' . '??????????? ' . $cache->config['artmaxlength'] . ' ???' . '</p>';
    343. 

  343. 			return 0;
    344. 

  344. 		}
    345. 

  345. 		if( strlen( $summary ) > $cache->config['artmaxlength'] ){
    346. 

  346. 			echo '<p class="error">' . '??????????? ' . $cache->config['artmaxlength'] . ' ???' . '</p>';
    347. 

  347. 			return 0;
    348. 

  348. 		}
    349. 

  349. 		// ???????????
    350. 

  350. 		// ?????????????????????? is_numeric ???????????
    351. 

  351. 		if( $address != '' ) {
    352. 

  352. 			if( is_numeric( $address ) ) {
    353. 

  353. 				echo '<p class="error">' . '???????????????' . '</p>';
    354. 

  354. 				return 0;
    355. 

  355. 			}
    356. 

  356. 			if( $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE address='$address'") ) {
    357. 

  357. 				echo '<p class="error">' . '????????????' . '</p>';
    358. 

  358. 				return 0;
    359. 

  359. 			}
    360. 

  360. 			$file_path = APP_CACHE . $address . '.html';
    361. 

  361. 			@file_put_contents( $file_path, ' ' );
    362. 

  362. 			if( file_exists( $file_path ) ) {
    363. 

  363. 				unlink( $file_path );
    364. 

  364. 			}else{
    365. 

  365. 				echo '<p class="error">' . '???????????' . '</p>';
    366. 

  366. 				return 0;
    367. 

  367. 			}
    368. 

  368. 			unset( $file_path );
    369. 

  369. 		}
    370. 

  370. 		// ????
    371. 

  371. 		$category = $request->get('article_category','P');
    372. 

  372. 		$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum = articlenum + 1 WHERE cid = '$category'");
    373. 

  373. 		$cache->refresh( 'category', TRUE );
    374. 

  374. 

  375. 		$type = $request->get('article_type','P');
    376. 

  376. 		$trackback = $request->get('article_trackback','P');
    377. 

  377. 

  378. 		// ????
    379. 

  379. 		$temp = explode( ',' , $request->get('article_tag','P') );
    380. 

  380. 		$temp = array_unique( $temp );
    381. 

  381. 		$tag = '';
    382. 

  382. 		$find = false;
    383. 

  383. 		foreach( $temp as $itag ){
    384. 

  384. 			if( $itag != '' ){
    385. 

  385. 				foreach( $cache->tag as $tag_id => $tag_arr ){
    386. 

  386. 					if( $tag_arr['t_name'] == $itag ){
    387. 

  387. 						$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num = t_num + 1 WHERE t_name = '$itag'");
    388. 

  388. 						$tag .= '{*' . $tag_id . '*}';
    389. 

  389. 						$find = true;
    390. 

  390. 						break;
    391. 

  391. 					}
    392. 

  392. 				}
    393. 

  393. 				if( $find == false ){
    394. 

  394. 					$db->query( "INSERT INTO `" . DB_PREFIX . "tags` (`t_name`,`t_num`) VALUES ('$itag',1)" );
    395. 

  395. 					$tag .= '{*' . $db->insert_id() . '*}';
    396. 

  396. 				}else{
    397. 

  397. 					$find = false;
    398. 

  398. 				}
    399. 

  399. 			}
    400. 

  400. 		}
    401. 

  401. 		$cache->refresh( 'tag', TRUE );
    402. 

  402. 

  403. 		if( !isset( $_SESSION['upfile'] ) ) $_SESSION['upfile'] = '';
    404. 

  404. 		$db->query( "INSERT INTO `" . DB_PREFIX . "article` (`title`,`keywords`,`description`,`time`,`author`,`category`,`tag`,`summary`,`content`,`read`,`comment`,`address`,`type`,`attachment`) VALUES ('$title', '$keywords', '$description', '" . PHP_TIME . "', '" . $request->get( APP_PREFIX . 'username', 'C' ) . "', $category, '$tag', '$summary', '$content',0,0,'$address','$type','" . $_SESSION['upfile'] . "')" );
    405. 

  405. 		unset($_SESSION['upfile']);
    406. 

  406. 		return $db->insert_id();
    407. 

  407. 	}
    408. 

  408. 

  409. 	// ??????
    410. 

  410. 	private function edit( $article_id ){
    411. 

  411. 		global $cache,$db,$request;
    412. 

  412. 		$title = $request->get('article_title','P');
    413. 

  413. 		$keywords = $request->get('article_keywords','P');
    414. 

  414. 		$description = $request->get('article_description','P');
    415. 

  415. 		$content = $request->get('article_content','P');
    416. 

  416. 		$summary = $request->get('article_summary','P');
    417. 

  417. 		$address = trim( $request->get('article_alias','P') );
    418. 

  418. 		$type = $request->get('article_type','P');
    419. 

  419. 		if( trim( $title ) == '' || trim( $content ) == '' ){
    420. 

  420. 			echo '<p class="error">' . '??????????????' . '</p>';
    421. 

  421. 			return 0;
    422. 

  422. 		}
    423. 

  423. 		if( strlen( $content ) > $cache->config['artmaxlength'] ){
    424. 

  424. 			echo '<p class="error">' . '??????????? ' . $cache->config['artmaxlength'] . ' ???' . '</p>';
    425. 

  425. 			return 0;
    426. 

  426. 		}
    427. 

  427. 		if( strlen( $summary ) > $cache->config['artmaxlength'] ){
    428. 

  428. 			echo '<p class="error">' . '??????????? ' . $cache->config['artmaxlength'] . ' ???' . '</p>';
    429. 

  429. 			return 0;
    430. 

  430. 		}
    431. 

  431. 		// ????????
    432. 

  432. 		if( $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE id={$article_id} AND isdel=0 AND type<3" ) == 0 ){
    433. 

  433. 			echo '<p class="error">' . '?????????????' . '</p>';
    434. 

  434. 			return 0;
    435. 

  435. 		}
    436. 

  436. 		if( $address != '' ) {
    437. 

  437. 			// ???????????
    438. 

  438. 			if( is_numeric( $address ) ) {
    439. 

  439. 				echo '<p class="error">' . '???????????????' . '</p>';
    440. 

  440. 				return 0;
    441. 

  441. 			}
    442. 

  442. 			if( $db->result( "SELECT COUNT(id) FROM `" . DB_PREFIX . "article` WHERE address='$address' AND id<>$article_id") ) {
    443. 

  443. 				echo '<p class="error">' . '??????????' . '</p>';
    444. 

  444. 				return 0;
    445. 

  445. 			}
    446. 

  446. 			$file_path = APP_CACHE . $address . '.html';
    447. 

  447. 			@file_put_contents( $file_path, ' ' );
    448. 

  448. 			if( file_exists( $file_path ) ) {
    449. 

  449. 				unlink( $file_path );
    450. 

  450. 			}else{
    451. 

  451. 				echo '<p class="error">' . '???????????' . $file_path . '</p>';
    452. 

  452. 				return 0;
    453. 

  453. 			}
    454. 

  454. 			unset( $file_path );
    455. 

  455. 		}
    456. 

  456. 		// ?????
    457. 

  457. 		$category_old = $db->result( "SELECT category FROM `" . DB_PREFIX . "article` WHERE id = $article_id" );
    458. 

  458. 		$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum = articlenum - 1 WHERE cid = $category_old");
    459. 

  459. 		// ?????
    460. 

  460. 		$category = $request->get('article_category','P');
    461. 

  461. 		$db->query( "UPDATE `" . DB_PREFIX . "category` SET articlenum = articlenum + 1 WHERE cid = $category");
    462. 

  462. 		$cache->refresh( 'category', TRUE );
    463. 

  463. 

  464. 		$type = $request->get('article_type','P');
    465. 

  465. 		$trackback = $request->get('article_trackback','P');
    466. 

  466. 

  467. 		// ?????
    468. 

  468. 		$tags_old = $db->result( "SELECT tag FROM `" . DB_PREFIX . "article` WHERE id = $article_id" );
    469. 

  469. 		$tags_old = str_replace( '*}{*',',',$tags_old);
    470. 

  470. 		$tags_old = str_replace( '*}','',$tags_old);
    471. 

  471. 		$tags_old = str_replace( '{*','',$tags_old);
    472. 

  472. 		$tags_old = explode( ',' ,$tags_old );
    473. 

  473. 		foreach( $tags_old as $i_tag ){
    474. 

  474. 			if( $i_tag != '' ){
    475. 

  475. 				$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num = t_num - 1 WHERE t_id = $i_tag" );
    476. 

  476. 			}
    477. 

  477. 		}
    478. 

  478. 

  479. 		// ?????
    480. 

  480. 		$temp = explode( ',' , $request->get('article_tag','P') );
    481. 

  481. 		$temp = array_unique( $temp );
    482. 

  482. 		$tag = '';
    483. 

  483. 		$find = false;
    484. 

  484. 		$tag_list = $db->fetch_all( 'SELECT * FROM `' . DB_PREFIX . 'tags` ORDER BY t_id Asc' );
    485. 

  485. 		foreach( $temp as $itag ){
    486. 

  486. 			if( $itag != '' ){
    487. 

  487. 				foreach( $tag_list as $tag_arr ){
    488. 

  488. 					if( $tag_arr['t_name'] == $itag ){
    489. 

  489. 						$db->query( "UPDATE `" . DB_PREFIX . "tags` SET t_num = t_num + 1 WHERE t_name = '$itag'");
    490. 

  490. 						$tag .= '{*' . $tag_arr['t_id'] . '*}';
    491. 

  491. 						$find = true;
    492. 

  492. 						break;
    493. 

  493. 					}
    494. 

  494. 				}
    495. 

  495. 				if( $find == false ){
    496. 

  496. 					$db->query( "INSERT INTO `" . DB_PREFIX . "tags` (`t_name`,`t_num`) VALUES ('$itag',1)" );
    497. 

  497. 					$tag .= '{*' . $db->insert_id() . '*}';
    498. 

  498. 				}else{
    499. 

  499. 					$find = false;
    500. 

  500. 				}
    501. 

  501. 			}
    502. 

  502. 		}
    503. 

  503. 		$cache->refresh( 'tag', TRUE );
    504. 

  504. 

  505. 		if( !isset( $_SESSION['upfile'] ) ) $_SESSION['upfile'] = '';
    506. 

  506. 		$upfile = $db->result( "SELECT attachment FROM `" . DB_PREFIX . "article` WHERE id = $article_id" );
    507. 

  507. 		$upfile .= $_SESSION['upfile'];
    508. 

  508. 		$db->query( "UPDATE `" . DB_PREFIX . "article` SET title='{$title}' ,keywords='{$keywords}' ,description='{$description}' ,category={$category} ,tag='{$tag}' ,summary='{$summary}' ,content='{$content}' ,address='{$address}' ,type='{$type}' ,attachment='{$upfile}' WHERE id={$article_id}" );
    509. 

  509. 		unset($_SESSION['upfile']);
    510. 

  510. 		return $article_id;
    511. 

  511. 	}
    512. 

  512. 

  513. 	private function show( $action ) {
    514. 

  514. 		@header("content-type: text/html; charset=utf-8");
    515. 

  515. ?>
    516. 

  516. <div class="admin_panel">
    517. 

  517. 	<?php
    518. 

  518. 		switch( $action ) {
    519. 

  519. 		case 'list':
    520. 

  520. 			$this->article_list();
    521. 

  521. 			break;
    522. 

  522. 		case 'page':
    523. 

  523. 			$this->page_control();
    524. 

  524. 			break;
    525. 

  525. 		case 'datacheck':
    526. 

  526. 			$this->data_check();
    527. 

  527. 			break;
    528. 

  528. 		default:
    529. 

  529. 			$this->main();
    530. 

  530. 		}
    531. 

  531. 	?>
    532. 

  532. </div>
    533. 

  533. <?php
    534. 

  534. 	}
    535. 

  535. 

  536. 	private function article_add( $action = '' ) {
    537. 

  537. 		global $cache;
    538. 

  538. 		if( $action == 'edit' ) {
    539. 

  539. 			global $db,$request;
    540. 

  540. 			$article = $db->fetch_one_array( 'SELECT * FROM `' . DB_PREFIX . 'article` WHERE id=' . $request->id );
    541. 

  541. 			$article['trackback'] = '';//$db->result( 'SELECT tb_url FROM `' . DB_PREFIX . 'trackback` WHERE tb_type = 0 AND tb_article_id=' . $id );
    542. 

  542. 			// ????
    543. 

  543. 			$article['attachment'] = str_replace( '*}{*',',',$article['attachment']);
    544. 

  544. 			$article['attachment'] = str_replace( '*}','',$article['attachment']);
    545. 

  545. 			$article['attachment'] = str_replace( '{*','',$article['attachment']);
    546. 

  546. 			$temp = array();
    547. 

  547. 			$temp = split( ',' , $article['attachment'] );
    548. 

  548. 			$article['attachment'] = '';
    549. 

  549. 			$blog_path = str_replace( ' ','%20',APP_PATH );
    550. 

  550. 			foreach($temp as $row){
    551. 

  551. 				if( !is_numeric( $row ) ) continue;
    552. 

  552. 				$file_info = $db->fetch_one_array( "SELECT ul_filetype,ul_filepath FROM `" . DB_PREFIX . "upload` WHERE ul_id=$row" );
    553. 

  553. 				if ( stristr( $file_info['ul_filetype'],'image' ) ) {
    554. 

  554. 					$ubb = '<img src=' . $blog_path . $file_info['ul_filepath'] . ' />';
    555. 

  555. 					$ubb2 = '<img src=' . $blog_path . 'include/attachment.php?id=' . $row . ' />';
    556. 

  556. 				} else {
    557. 

  557. 					$ubb = '<span class=download><a href=' . $blog_path . $file_info['ul_filepath'] . ' target=_blank>??????</a></span>';
    558. 

  558. 					$ubb2 = '<span class=download><a href=' . $blog_path . 'include/attachment.php?id=' . $row . ' target=_blank>??????</a></span>';
    559. 

  559. 				}
    560. 

  560. 				$article['attachment'] .= '<li><a href="javascript:;" onclick="to_editor(\''.$ubb2.'\')" title="??????">[?????]</a> <a href="#" onclick="to_editor(\''.$ubb.'\')" title="??????">[????]</a> ' . $file_info['ul_filepath'] . '</li>';
    561. 

  561. 			}
    562. 

  562. 			$article['attachment'] = '<ol>' . $article['attachment'] . '</ol>';
    563. 

  563. 			// ????
    564. 

  564. 			$article['tag'] = str_replace( '*}{*',',',$article['tag']);
    565. 

  565. 			$article['tag'] = str_replace( '*}','',$article['tag']);
    566. 

  566. 			$article['tag'] = str_replace( '{*','',$article['tag']);
    567. 

  567. 			$temp = array();
    568. 

  568. 			$temp = split( ',' , $article['tag']);
    569. 

  569. 			$article['tag'] = '';
    570. 

  570. 			foreach($temp as $row){
    571. 

  571. 				if( isset( $cache->tag[$row]['t_name'] ) ){
    572. 

  572. 					$article['tag'] .= '{*' . $cache->tag[$row]['t_name'] . '*}';
    573. 

  573. 				}
    574. 

  574. 			}
    575. 

  575. 			$article['tag'] = str_replace( '*}{*',',',$article['tag']);
    576. 

  576. 			$article['tag'] = str_replace( '*}','',$article['tag']);
    577. 

  577. 			$article['tag'] = str_replace( '{*','',$article['tag']);
    578. 

  578. 		} else {
    579. 

  579. 			$article = array();
    580. 

  580. 			$temp = array('title','content','summary','category','tag','trackback','address','keywords','description');
    581. 

  581. 			foreach ( $temp as $value ) {
    582. 

  582. 				$article[$value] = '';
    583. 

  583. 			}
    584. 

  584. 			$article['trackback'] = '???????';
    585. 

  585. 		}
    586. 

  586. 	// $article['p'], $article['extra'] );
    587. 

  587. ?>
    588. 

  588. 

  589. <style>
    590. 

  590. .input_submit { border:1px solid #a3a3a3; background-color: #e7e7e7; padding: 5px; width: 100px; font-weight:bold; }
    591. 

  591. .admin_content { margin:0px; padding:0px; margin-top:5px; }
    592. 

  592. .admin_content .input_text { border: 1px solid #c8c8c8; padding: 5px; width: 235px; font-size: 14px; }
    593. 

  593. .admin_title .tit_right { float: right; font-size: 12px; font-weight:normal; padding-top:2px; }
    594. 

  594. .admin_content select { border:1px solid #c8c8c8; padding: 5px; width: 245px; font-size: 14px; }
    595. 

  595. .admin_content .input_radio { margin:5px; }
    596. 

  596. .admin_title { cursor:pointer; }
    597. 

  597. </style>
    598. 

  598. 

  599. <script type="text/javascript">
    600. 

  600. 	KE.init({
    601. 

  601. 		id : 'article_content',
    602. 

  602. 		resizeMode : 1,
    603. 

  603. 		width : '668px',
    604. 

  604. 		allowFileManager : true,
    605. 

  605. 		newlineTag : 'p'
    606. 

  606. 	});
    607. 

  607. 	KE.init({
    608. 

  608. 		id : 'article_summary',
    609. 

  609. 		resizeMode : 1,
    610. 

  610. 		width : '668px',
    611. 

  611. 		allowFileManager : true,
    612. 

  612. 		newlineTag : 'p'
    613. 

  613. 	});
    614. 

  614. 	var flag_content=false,flag_summary=false;
    615. 

  615. </script>
    616. 

  616. 

  617. <form method="post" action="index.php?m=article&p=<?php if( $action == 'edit' ) { echo 'saveedit&id=' . $request->id; } else { echo 'saveadd'; }?>" id="ajax_form">
    618. 

  618. 

  619. <div style="float:left;width:680px;">
    620. 

  620. 

  621. 	<div class="admin_panel" onclick="if(!flag_content){flag_content=true;KE.create('article_content');KE.util.focus('article_content');}">
    622. 

  622. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_content')">????<div class="tit_right"></div></div>
    623. 

  623. 		<div class="admin_content">
    624. 

  624. 			<div id="div_article_content">
    625. 

  625. 				<textarea id="article_content" name="article_content" style="width:665px;height:400px;border:1px solid #c8c8c8;"><?php echo $article['content'] ?></textarea>
    626. 

  626. 			</div>
    627. 

  627. 		</div>
    628. 

  628. 	</div>
    629. 

  629. 

  630. 	<div class="admin_panel" onclick="if(!flag_summary){flag_summary=true;KE.create('article_summary');KE.util.focus('article_content');}">
    631. 

  631. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_summary')">????<div class="tit_right"></div></div>
    632. 

  632. 		<div class="admin_content">
    633. 

  633. 			<div id="div_article_summary" style="display:none;">
    634. 

  634. 				<textarea id="article_summary" name="article_summary" style="width:665px;height:200px;border:1px solid #c8c8c8;"><?php echo $article['summary'] ?></textarea>
    635. 

  635. 			</div>
    636. 

  636. 		</div>
    637. 

  637. 	</div>
    638. 

  638. 

  639. 	<?php if( $action == 'edit' ) { ?>
    640. 

  640. 	<div class="admin_panel" onmouseover="if(!flag_summary){flag_summary=true;KE.create('article_summary');KE.util.focus('article_content');}">
    641. 

  641. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_upfile')">????<div class="tit_right"></div></div>
    642. 

  642. 		<div class="admin_content">
    643. 

  643. 			<div id="div_article_upfile" style="text-align:left;">
    644. 

  644. 				<?php echo $article['attachment'] ?>
    645. 

  645. 			</div>
    646. 

  646. 		</div>
    647. 

  647. 		<script>
    648. 

  648. 		function to_editor(id, html){
    649. 

  649. 			KE.util.focus(id);
    650. 

  650. 			KE.util.selection(id);
    651. 

  651. 			KE.util.insertHtml(id, html);
    652. 

  652. 		}
    653. 

  653. 		</script>
    654. 

  654. 	</div>
    655. 

  655. 	<?php } ?>
    656. 

  656. 

  657. 	<div class="admin_panel">
    658. 

  658. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_upload')">????<div class="tit_right"></div></div>
    659. 

  659. 		<div class="admin_content">
    660. 

  660. 			<div id="div_article_upload" style="display:none;">
    661. 

  661. 				<iframe frameborder="0" src="../include/upload.php" width="600" height="110"></iframe>
    662. 

  662. 			</div>
    663. 

  663. 		</div>
    664. 

  664. 	</div>
    665. 

  665. 

  666. </div>
    667. 

  667. 

  668. <div style="float:right;width:260px;">
    669. 

  669. 

  670. 	<div class="admin_panel">
    671. 

  671. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_submit')">??<div class="tit_right"></div></div>
    672. 

  672. 		<div class="admin_content">
    673. 

  673. 			<div id="div_article_submit" style="padding:10px;">
    674. 

  674. 				<input type="submit" onclick="KE.util.setData('article_content');KE.util.setData('article_summary');" value=" ?  ? " class="input_submit" />
    675. 

  675. 			</div>
    676. 

  676. 		</div>
    677. 

  677. 	</div>
    678. 

  678. 

  679. 	<div class="admin_panel">
    680. 

  680. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_title')">??<div class="tit_right"></div></div>
    681. 

  681. 		<div class="admin_content">
    682. 

  682. 			<div id="div_article_title">
    683. 

  683. 				<input name="article_title" type="text" id="article_title" size="40" class="input_text" value="<?php echo $article['title'] ?>"/>
    684. 

  684. 			</div>
    685. 

  685. 		</div>
    686. 

  686. 	</div>
    687. 

  687. 

  688. 	<div class="admin_panel">
    689. 

  689. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_category')">??<div class="tit_right"></div></div>
    690. 

  690. 		<div class="admin_content">
    691. 

  691. 			<div id="div_article_category">
    692. 

  692. 				<select name="article_category" id="article_category">
    693. 

  693. 				<?php
    694. 

  694. 				global $cache;
    695. 

  695. 				foreach ( $cache->category as $value ) {
    696. 

  696. 					if( $article['category'] == $value['cid'] ){
    697. 

  697. 						echo '<option value="' . $value['cid'] . '" selected="selected">' . $value['name'] . '</option>';
    698. 

  698. 					}else{
    699. 

  699. 						echo '<option value="' . $value['cid'] . '">' . $value['name'] . '</option>';
    700. 

  700. 					}
    701. 

  701. 				}
    702. 

  702. 				?>
    703. 

  703. 				</select>
    704. 

  704. 			</div>
    705. 

  705. 		</div>
    706. 

  706. 	</div>
    707. 

  707. 

  708. 	<div class="admin_panel">
    709. 

  709. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_tag')">??<div class="tit_right">???????“,”??</div></div>
    710. 

  710. 		<div class="admin_content">
    711. 

  711. 			<div id="div_article_tag">
    712. 

  712. 				<input name="article_tag" type="text" id="article_tag" size="40" class="input_text" value="<?php echo $article['tag'] ?>" />
    713. 

  713. 			</div>
    714. 

  714. 		</div>
    715. 

  715. 	</div>
    716. 

  716. 

  717. 	<div class="admin_panel">
    718. 

  718. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_alias')">??<div class="tit_right">???????“-”??????</div></div>
    719. 

  719. 		<div class="admin_content">
    720. 

  720. 			<div id="div_article_alias" style="display:none;">
    721. 

  721. 				<input name="article_alias" type="text" id="article_alias" size="40" class="input_text" value="<?php echo $article['address'] ?>"/>
    722. 

  722. 			</div>
    723. 

  723. 		</div>
    724. 

  724. 	</div>
    725. 

  725. 

  726. 	<div class="admin_panel">
    727. 

  727. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_meta')">??<div class="tit_right">??? SEO</div></div>
    728. 

  728. 		<div class="admin_content">
    729. 

  729. 			<div id="div_article_meta" style="display:none;">
    730. 

  730. 				<p style="padding-bottom:5px;text-align:left;">????</p>
    731. 

  731. 				<input name="article_keywords" type="text" id="article_keywords" size="40" class="input_text" value="<?php echo $article['keywords'] ?>" />
    732. 

  732. 				<p style="padding-bottom:5px;padding-top:5px;text-align:left;">???</p>
    733. 

  733. 				<textarea name="article_description" type="text" id="article_description" style="padding:5px;width:235px;height:100px;font-size: 14px;border:1px solid #c8c8c8;"><?php echo $article['description'] ?></textarea>
    734. 

  734. 			</div>
    735. 

  735. 		</div>
    736. 

  736. 	</div>
    737. 

  737. 

  738. 	<div class="admin_panel">
    739. 

  739. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_type')">??<div class="tit_right"></div></div>
    740. 

  740. 		<div class="admin_content">
    741. 

  741. 			<div id="div_article_type" style="display:none;">
    742. 

  742. 				<input type="radio" value="??" name="article_type" checked="checked" class="input_radio" />??&nbsp;&nbsp;
    743. 

  743. 				<input type="radio" value="??" name="article_type" class="input_radio" />??&nbsp;&nbsp;
    744. 

  744. 				<input type="radio" value="??" name="article_type" class="input_radio" />??
    745. 

  745. 			</div>
    746. 

  746. 		</div>
    747. 

  747. 	</div>
    748. 

  748. 

  749. 	<div class="admin_panel">
    750. 

  750. 		<div class="admin_title" onclick="javascript:ShowHideDiv('div_article_trackback')">????<div class="tit_right"></div></div>
    751. 

  751. 		<div class="admin_content">
    752. 

  752. 			<div id="div_article_trackback" style="display:none;">
    753. 

  753. 				<input name="article_trackback" type="text" id="article_trackback" size="40" class="input_text" value="<?php echo $article['trackback'] ?>" />
    754. 

  754. 			</div>
    755. 

  755. 		</div>
    756. 

  756. 	</div>
    757. 

  757. 

  758. </div>
    759. 

  759. 

  760. <div class="fixed"></div>
    761. 

  761. 

  762. </form>
    763. 

  763. 

  764. <script>
    765. 

  765. 	$(document).ready(function(){
    766. 

  766. 		$('#ajax_form').ajaxForm(function(data){
    767. 

  767. 			showMessage(data);
    768. 

  768. 			$("#admin_loading").css('visibility','hidden');
    769. 

  769. 		});
    770. 

  770. 	});
    771. 

  771. </script>
    772. 

  772. 

  773. <?php
    774. 

  774. 	}
    775. 

  775. 

  776. 	private function article_list() {
    777. 

  777. 		global $db,$cache,$request;
    778. 

  778. 		$current_page = max( 1, $request->page );
    779. 

  779. 		$max_per_page = 20;
    780. 

  780. 		$offset = ($current_page - 1) * $max_per_page;
    781. 

  781. 		$article_num = $cache->count['article_num'];
    782. 

  782. 		$sql = "SELECT id,author,title,time,istop,isdel,category,`read`,comment,`type` FROM `" . DB_PREFIX . "article` WHERE isdel=0 AND `type`<3 ORDER BY istop DESC, id DESC LIMIT $offset, $max_per_page";
    783. 

  783. 		$article_array = $db->fetch_all( $sql );
    784. 

  784. ?>
    785. 

  785. <div class="admin_title"><?php echo L('_ARTICLE_LIST_'); ?></div>
    786. 

  786. <div class="admin_content">
    787. 

  787. 	<form name="smslist" action="admin_article.php?action=batch" method="post">
    788. 

  788. 		<div style="padding:5px;margin:2px;">      
    789. 

  789. 			<table class="pickme" style="table-layout: fixed;word-wrap: break-word;" width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#bbbbbb">
    790. 

  790. 				<thead>
    791. 

  791. 					<tr align="center" height="22" bgcolor="#ffffff">
    792. 

  792. 						<td width="3%"><input type="checkbox" name="allbox" onclick="CheckAll();"><input type="checkbox" id="ckbox" style="display:none;" disabled></td>
    793. 

  793. 						<td width="4%"><?php echo L('_NUM_'); ?></td>
    794. 

  794. 						<td width="10%"><?php echo L('_AUTHOR_'); ?></td>
    795. 

  795. 						<td width="32%"><?php echo L('_TITLE_'); ?></td>
    796. 

  796. 						<td width="6%"><?php echo L('_TYPE_'); ?></td>
    797. 

  797. 						<td width="14%"><?php echo L('_CATEGORY_'); ?></td>
    798. 

  798. 						<td width="7%"><?php echo L('_READ_'); ?></td>
    799. 

  799. 						<td width="7%"><?php echo L('_COMMENT_'); ?></td>
    800. 

  800. 						<td width="11%"><?php echo L('_TIME_'); ?></td>
    801. 

  801. 						<td width="6%"><?php echo L('_OPERATION_'); ?></td>
    802. 

  802. 					</tr>
    803. 

  803. 				</thead>
    804. 

  804. 				<tbody>
    805. 

  805. 					<?php
    806. 

  806. 					$i = 1;
    807. 

  807. 					foreach( $article_array as $value ) {
    808. 

  808. 					?>
    809. 

  809. 					<tr align="center" height="20" bgcolor="#ffffff">
    810. 

  810. 						<td ><input type="checkbox" id="ckbox" name="id_arr[]" value="<?php echo $value['id'] ?>" /></td>
    811. 

  811. 						<td><?php echo ( $current_page - 1 ) * $max_per_page + $i ?></td>
    812. 

  812. 						<td><?php echo $value['author'] ?></td>
    813. 

  813. 						<td style="text-align:left;padding-left:3px;"><?php if( $value['istop'] ) { echo '<span class="top_article">[??]</span>' . cut_str( $value['title'],40 ); }else{ echo cut_str( $value['title'],40 ); } ?></td>
    814. 

  814. 						<td>
    815. 

  815. 						<?php
    816. 

  816. 							if( $value['type'] == 0 ) {
    817. 

  817. 								echo '??';
    818. 

  818. 							} elseif( $value['type'] == 1 ) {
    819. 

  819. 								echo '??';
    820. 

  820. 							} elseif( $value['type'] == 3 ) {
    821. 

  821. 								echo '??';
    822. 

  822. 							} else {
    823. 

  823. 								echo 'Unknown';
    824. 

  824. 							}
    825. 

  825. 						?></td>
    826. 

  826. 						<td><?php echo $cache->category[$value['category']]['name'] ?></td>
    827. 

  827. 						<td><?php echo $value['read'] ?></td>
    828. 

  828. 						<td><?php echo $value['comment'] ?></td>
    829. 

  829. 						<td><?php echo date( 'Y-m-d', $value['time'] ) ?></td>
    830. 

  830. 						<td>
    831. 

  831. 							<span class="Control">
    832. 

  832. 							<a href="#" onclick="ajax_load('<?php echo ADMIN_PATH ?>','article','edit',null,'<?php echo $value['id'] ?>');return false;"><?php echo L('_EDIT_'); ?></a>
    833. 

  833. 							</span>
    834. 

  834. 						</td>
    835. 

  835. 					</tr>
    836. 

  836. 					<?php
    837. 

  837. 						$i ++;
    838. 

  838. 					}
    839. 

  839. 					?>
    840. 

  840. 				</tbody>
    841. 

  841. 			</table>
    842. 

  842. 		</div>
    843. 

  843. 		<?php echo Admin::get_navigator( $article_num, $max_per_page, $current_page, 'article', 'list' ); ?>
    844. 

  844. 		<div align="center" style="margin-top:10px;">
    845. 

  845. 			<?php echo L('_BATCH_ADMIN_'); ?>: 
    846. 

  846. 			<input type="radio" name="Control" value="??" checked="checked"/><?php echo L('_DELETE_'); ?> 
    847. 

  847. 			<input type="radio" name="Control" value="??" /><?php echo L('_MOVE_'); ?>
    848. 

  848. 			<select name="article_category" id="article_category">
    849. 

  849. 			<?php
    850. 

  850. 				foreach ( $cache->category as $value ) {
    851. 

  851. 					echo '<option value="' . $value['cid'] . '">' . $value['name'] . '</option>';
    852. 

  852. 				}
    853. 

  853. 			?>
    854. 

  854. 			</select> 
    855. 

  855. 			<input type="radio" name="Control" value="??" /><?php echo L('_CHANGE_'); ?> 
    856. 

  856. 			<select name="article_type" id="article_type">
    857. 

  857. 				<option value="??">??</option>
    858. 

  858. 				<option value="??">??</option>
    859. 

  859. 				<option value="??">??</option>
    860. 

  860. 			</select> 
    861. 

  861. 			<input type="submit" class="main_button" value=" <?php echo L('_TAKE_OPERATION_'); ?> " />
    862. 

  862. 		</div>
    863. 

  863. 	</form>
    864. 

  864. 	<div class="main_button"></div>
    865. 

  865. </div>
    866. 

  866. <?php
    867. 

  867. 	}
    868. 

  868. 

  869. 	private function page_control() {
    870. 

  870. ?>
    871. 

  871. <div class="admin_title"><?php echo L('_HTML_MANAGEMENT_'); ?></div>
    872. 

  872. <div class="admin_content">
    873. 

  873. 	<div style="padding:10px;">
    874. 

  874. 		<a href="admin_article.php?action=MakearticlePage"><?php echo L('_REBUILD_HTML_'); ?></a>
    875. 

  875. 	</div>
    876. 

  876. </div>
    877. 

  877. <?php
    878. 

  878. 	}
    879. 

  879. 

  880. 	private function data_check() {
    881. 

  881. ?>
    882. 

  882. <div class="admin_title"><?php echo L('_DATA_CHECK_'); ?></div>
    883. 

  883. <div class="admin_content">
    884. 

  884. 	<div style="padding:10px;">
    885. 

  885. 		<a href="index.php?m=article&p=datacheckexe"><?php echo L('_COMMENT_DATA_CHECK_'); ?></a><br />
    886. 

  886. 		<a href="index.php?m=article&p=tagdatacheckexe"><?php echo L('_TAG_DATA_CHECK_'); ?></a>
    887. 

  887. 	</div>
    888. 

  888. </div>
    889. 

  889. <?php
    890. 

  890. 	}
    891. 

  891. 

  892. 	private function main() {
    893. 

  893. ?>
    894. 

  894. <div class="admin_title"><?php echo L('_CONTENT_MANAGEMENT_'); ?></div>
    895. 

  895. <div class="admin_content">
    896. 

  896. 	<div style="padding:10px;">
    897. 

  897. 		<?php echo L('_UNDEFINED_ACTION_'); ?>
    898. 

  898. 	</div>
    899. 

  899. </div>
    900. 

  900. <?php
    901. 

  901. 	}
    902. 

  902. 

  903. }
    904. 

  904. ?>
    905. 

  905.