news.php

来自「全新且完善的强大网上商店系统」· PHP 代码 · 共 171 行

<?php
/*
  [SOOBIC!] admin/zones.php 

	Version: 1.5
	Author: soolan ([e-mail])
	Copyright: soolan (www.soobic.com)
	Last Modified: 2005/4/3 10:00

*/

if(!defined('IN_SOOBIC')) {
        exit('Access Denied');
}

cpheader();


if ($action) {
    switch ($action) {
      case 'save':
        
				if($id){
            $sql_data_array = array('subject' => $subject,
                                   'last_edit' => $timestamp,
                                   'text' => $text);   
						
						tep_db_perform($table_news, $sql_data_array,'update',"id='".$id."'");
            $messageStack->add_session('admin','新闻已更新');   
            tep_redirect(tep_href_link('admincp.php', 'act=news'));
				}else{
				    $sql_data_array = array('subject' => $subject,
                                   'date_add' => $timestamp,
																	 'text' => $text);   
						tep_db_perform($table_news, $sql_data_array);
						$messageStack->add_session('admin','新闻已添加');
						tep_redirect(tep_href_link('admincp.php', 'act=news'));
				}
				break;
      case 'delete':
        $db->query("delete from $table_news where id = '" . (int)$id . "'");
        $messageStack->add_session('admin','新闻已删除');
				tep_redirect(tep_href_link('admincp.php', 'act=news&page='.$page));
        break;
    }
}elseif($type){
    switch ($type) {
      case 'delete':
        cpmsg("本操作不可恢复，您确定要删除该新闻？", tep_href_link('admincp.php', 'act=news&page=' . $page.'&id='.$id.'&action=delete', 'NONSSL'), "form");
      break;
      case 'edit':
      case 'add':
        if($type=='edit'){
				    $query = $db->query("select id, subject, text from $table_news where id='$id'");
		        $news = $db->fetch_array($query); 
		    }
?>
<script language="Javascript1.2">
<!-- // load htmlarea
_editor_url = "./htmlarea/";                     // URL to htmlarea files
var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]);
if (navigator.userAgent.indexOf('Mac')        >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; }
if (navigator.userAgent.indexOf('Opera')      >= 0) { win_ie_ver = 0; }
if (win_ie_ver >= 5.5) {
 document.write('<scr' + 'ipt src="' +_editor_url+ 'editor.js"');
 document.write(' language="Javascript1.2"></scr' + 'ipt>');
} else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); }
// -->
</script>

<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object

config.width = "500";
config.height = "300";

config.debug = 0;

editor_generate('text',config);

</script>
<form method="post" action="<?=tep_href_link('admincp.php','act=news')?>">
<input type="hidden" name="action" value="save">
<input type="hidden" name="id" value="<?=$id?>">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td colspan="7">添加商城新闻</td></tr>

<tr align="center" bgcolor="<?=ALTBG1?>"><td width="40%" align="right">新闻标题</td>
<td align="left"><input type="text" size="50" name="subject" value="<?=$news['subject']?>"></td>
</tr>
<tr align="center" bgcolor="<?=ALTBG2?>"><td align="right">新闻正文</td>
<td align="left"><textarea  name="text" wrap="soft" cols="70" rows="10"><?=$news['text']?></textarea></td>
</tr>
</table></td></tr></table><br><center>
<input type="submit" name="submit" value="提   交">&nbsp;
</center></form><br><br>


<?
      break;
      
    }

}else{
    if($page) {
	      	$start_limit = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS ;
    } else {
	        $start_limit = 0;
	        $page = 1;
    }
    
    $query = $db->query("SELECT COUNT(*) from $table_news");
    $multipage = multi($db->result($query, 0), MAX_DISPLAY_SEARCH_RESULTS, $page, tep_href_link('admincp.php','act=news'));
    $query = $db->query("select id, subject, date_add from $table_news order by date_add LIMIT $start_limit, ".MAX_DISPLAY_SEARCH_RESULTS);
		$altbg1 = ALTBG1;
	  $altbg2 = ALTBG2;
	  $productcount = 0;
if ($messageStack->size('admin') > 0) {
   $message_all=$messageStack->output('admin');
}

if (is_array($message_all)) {
?>
<br>
<table border="0" cellspacing="0" cellpadding="0" width="95%"  align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>"><table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr bgcolor="<?=ALTBG1?>"><td><table border="0" cellspacing="0" cellpadding="0" width="<?=TABLEWIDTH?>"  align="center">
<?
foreach($message_all as $key=>$value){
?>
<tr><td style="color:red"><?=$value['text']?></td></tr>
<?php
  }
?>
</table></td></tr></table></td></tr></table>
<?	
	}
?>
<br>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr bgcolor="<?=ALTBG2?>"><td align="right"><a href="<?=tep_href_link('admincp.php', 'act=news&page=' . $page. '&type=add&id=' . $news['id'])?>">添加新闻</a></td></tr>
</table></td></tr></table>
<br><br>
<?=$multipage?> 
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center" style="word-break:break-all;">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td>标题</td><td width="25%" align="center">添加日期</td><td width="20%" align="center">操作</td></tr>
<?
    
		while ($news = $db->fetch_array($query)) {
         $bgno = $productcount++ % 2 + 1;
?>
<tr bgcolor="<?=${'altbg'.$bgno}?>"><td><?=$news['subject']?></td><td><?=date('Y-m-d h:i:s',$news['date_add'])?></td><td align="center"><a href="<?=tep_href_link('admincp.php', 'act=news&page=' . $page. '&type=edit&id=' . $news['id'])?>">详情</a>&nbsp;&nbsp;&nbsp;<a href="<?=tep_href_link('admincp.php', 'act=news&page=' . $page . '&type=delete&id=' .$news['id'])?>">删除</a></td></tr>
<?
    }
?>
</table></td></tr></table>   
<?=$multipage?>      
<br><br>
    
<?    
}
?>