friendsite.php

一个简单的网站管理系统,他能实现你所需要的功能,是个值得一看的系统

<?php
/*
*######################################
* PHPCMS v2.00 - Advanced Content Manage System.
* Copyright (c) 2004-2005 phpcms.cn
*
* For further information go to http://www.phpcms.cn/
* This copyright notice MUST stay intact for use.
*######################################
*/

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

$action=$action ? $action : 'manage';

switch($action){

case 'add':
     if($submit){
           if(!ereg('^[01]+$',$linktype)){
              showmessage('非法参数！请返回！'); 
           }   

           $password=md5($password);

           $query="insert into $table_friendsite(siteid,linktype,name,url,logo,introduce,master,email,password,elite,passed,addtime) values('$siteid','$linktype','$name','$url','$logo','$introduce','$master','$email','$password','$elite','$passed','$timestamp')";
           $db->query($query);
           if($db->affected_rows()>0){
                 $siteid=$db->insert_id();
                 $db->query("UPDATE $table_friendsite SET orderid='$siteid' WHERE siteid=$siteid ");
                 $referer=$passed ? "?file=html&action=friendsite&referer=".urlencode($PHP_REFERER) : '';
                 showmessage('操作成功！',$referer);
           }else{
                 showmessage('操作失败！请返回！');
           }
     }else{
           include template('friendsite_add',1);
     }
     break;

case 'edit':
     if($submit){
           if(!ereg('^[01]+$',$linktype)){
              showmessage('非法参数！请返回！'); 
           }    

           $password=$password ? md5($password) : '';
           $query=$password ? "update $table_friendsite set linktype='$linktype',name='$name',url='$url',logo='$logo',introduce='$introduce',master='$master',email='$email',password='$password',elite='$elite',passed='$passed' where siteid='$siteid'" : "update $table_friendsite set linktype='$linktype',name='$name',url='$url',logo='$logo',introduce='$introduce',master='$master',email='$email',elite='$elite',passed='$passed' where siteid='$siteid'";
           $db->query($query);
           if($db->affected_rows()>0){
                 showmessage('操作成功！',"?file=html&action=friendsite&referer=".urlencode($PHP_REFERER));
           }else{
                 showmessage('操作失败！请返回！');
           }
     }else{
           $result=$db->query("select * from $table_friendsite where siteid='$siteid'");
           if($db->num_rows($result)>0){
              $site=$db->fetch_array($result);
           }

           include template('friendsite_edit',1);
     }
     break;

case 'manage':
     $query = $db->query("SELECT * FROM $table_friendsite ORDER BY passed,orderid");
     while($friendlink=$db->fetch_array($query)) {
          $friendlink[note]=htmlspecialchars($friendlink[note]);
          $friendsites[]=$friendlink;   
     }
     include template('friendsite_manage',1);

     break;

case 'updateorderid':

      if(empty($orderid) || !is_array($orderid)){
         showmessage('非法参数！请返回！');
      }

      foreach($orderid as $key=>$val){
              $db->query("UPDATE $table_friendsite SET orderid='$val' WHERE siteid=$key ");
      }

      $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
      showmessage('操作成功！',$referer);

      break;

case 'pass':

      if(empty($siteid)){
         showmessage('非法参数！请返回！');
      }

      $siteids=is_array($siteid) ? implode(',',$siteid) : $siteid;
      $db->query("UPDATE $table_friendsite SET passed=1 WHERE siteid IN ($siteids)");
      if($db->affected_rows()>0){
         $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
         showmessage('操作成功！',$referer);
      }else{
         showmessage('操作失败！请返回！');
      }

      break;

case 'nopass':

      if(empty($siteid)){
         showmessage('非法参数！请返回！');
      }
      $siteids=is_array($siteid) ? implode(',',$siteid) : $siteid;
      $db->query("UPDATE $table_friendsite SET passed=0 WHERE siteid IN ($siteids)");
      if($db->affected_rows()>0){
          $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
          showmessage('操作成功！',$referer);
      }else{
          showmessage('操作失败！请返回！');
      }
      break;

case 'commend':
      if(empty($siteid)){
         showmessage('非法参数！请返回！');
      }
      $siteids=is_array($siteid) ? implode(',',$siteid) : $siteid;
      $db->query("UPDATE $table_friendsite SET elite=1 WHERE siteid IN ($siteids)");
      if($db->affected_rows()>0){
          $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
          showmessage('操作成功！',$referer);
      }else{
          showmessage('操作失败！请返回！');
      }
      break;

case 'nocommend':
      if(empty($siteid)){
         showmessage('非法参数！请返回！');
      }
      $siteids=is_array($siteid) ? implode(',',$siteid) : $siteid;
      $db->query("UPDATE $table_friendsite SET elite=0 WHERE siteid IN ($siteids)");
      if($db->affected_rows()>0){
          $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
          showmessage('操作成功！',$referer);
      }else{
          showmessage('操作失败！请返回！');
      }
      break;

case 'delete':

     if(empty($siteid)){
          showmessage('非法参数！请返回！');
     }
     $siteids=is_array($siteid) ? implode(',',$siteid) : $siteid;
     $db->query("DELETE FROM $table_friendsite WHERE siteid IN ($siteids)");
     if($db->affected_rows()>0){
           $referer='?file=html&action=friendsite&referer='.urlencode($PHP_REFERER);
           showmessage('操作成功！',$referer);
     }else{
           showmessage('操作失败！请返回！');
     }
     break;
}
?>