PHP FDB::delete方法代码示例

 public function unBind()
 {
     global $_FANWE;
     if ($_FANWE['uid'] > 0) {
         FDB::delete('user_bind', "uid = " . $_FANWE['uid'] . " AND type = 'sina'");
     }
     fHeader("location: " . FU('settings/bind'));
 }

 function delete()
 {
     $online_hold = 60;
     $guest_span = 60;
     $online_hold = TIME_UTC - $online_hold;
     $guest_span = TIME_UTC - $guest_span;
     $condition = " sid='{$this->sid}' ";
     $condition .= " OR last_activity < {$online_hold} ";
     $condition .= " OR (uid='0' AND ip1='{$this->var['ip1']}' AND ip2='{$this->var['ip2']}' AND ip3='{$this->var['ip3']}' AND ip4='{$this->var['ip4']}' AND last_activity > {$guest_span}) ";
     $condition .= $this->var['uid'] ? " OR (uid='{$this->var['uid']}') " : '';
     FDB::delete('sessions', $condition);
 }

 function removeEvent($id)
 {
     $id = (int) $id;
     $event = FDB::fetchFirst("select id from " . FDB::table("event") . " where id = {$id}");
     if ($event) {
         $res = FDB::query("select share_id from " . FDB::table("event_share") . " where event_id = {$id}");
         while ($data = FDB::fetch($res)) {
             FS('Share')->deleteShare($data['share_id']);
         }
         FDB::delete("event_share", "event_id = {$id}");
         FS('Share')->deleteShare($event['share_id']);
         FDB::delete("event", "id = {$id}");
     }
 }

 public function unBind()
 {
     global $_FANWE;
     if ($_FANWE['uid'] > 0) {
         FDB::delete('user_bind', "uid = " . $_FANWE['uid'] . " AND type = 'taobao'");
         $update = array();
         $update['buyer_level'] = 0;
         $update['seller_level'] = 0;
         $update['is_buyer'] = 0;
         FDB::update('user', $update, 'uid = ' . $_FANWE['uid']);
     }
     $redirect_uri = urlencode($_FANWE['site_url'] . substr(FU('settings/bind'), 1));
     $url = "https://oauth.taobao.com/logoff?client_id=" . $this->config['app_key'] . "&redirect_uri=" . $redirect_uri;
     fHeader("location: " . $url);
 }

    public function deleteGoods($gid)
    {
        global $_FANWE;
        $gid = (int) $gid;
        $goods = FDB::fetchFirst('SELECT *
			FROM ' . FDB::table('second_goods') . ' WHERE gid = ' . $gid);
        if (empty($goods)) {
            return;
        }
        $share_id = $goods['share_id'];
        $share = FS('Share')->getShareById($share_id);
        FS('Share')->deleteShare($share_id);
        $uid = (int) $share['uid'];
        FDB::query('UPDATE ' . FDB::table('user_count') . ' SET seconds = seconds - 1 WHERE uid = ' . $uid);
        FDB::delete('second_goods', 'gid = ' . $gid);
        FS('Medal')->runAuto($uid, 'seconds');
    }

 function deleteEvent($share_id)
 {
     $share_id = (int) $share_id;
     $event_id = (int) FDB::resultFirst("select id from " . FDB::table("event") . " \r\n\t\t\twhere share_id = {$share_id}");
     if ($event_id > 0) {
         $share = FDB::fetchFirst("select share_id,uid from " . FDB::table("event_share") . " \r\n\t\t\t\twhere event_id = {$event_id} order by share_id asc limit 0,1");
         if ($share) {
             $share_id = (int) $share['share_id'];
             $uid = (int) $share['uid'];
             FDB::query("update " . FDB::table("event") . " set thread_count = thread_count - 1,share_id = {$share_id},uid = {$uid} where id = {$event_id}");
             FDB::delete('event_share', 'share_id = ' . $share_id);
         } else {
             FDB::delete('event', 'id = ' . $event_id);
         }
     } else {
         FDB::delete('event_share', 'share_id = ' . $share_id);
         FDB::query("update " . FDB::table("event") . " set thread_count = thread_count - 1 where id = {$event_id}");
     }
 }

    public function deletePost($share_id, $is_score = true)
    {
        if (intval($share_id) == 0) {
            return false;
        }
        $post = FDB::fetchFirst('SELECT * FROM ' . FDB::table('ask_post') . ' WHERE share_id = ' . $share_id);
        if (empty($post)) {
            return true;
        }
        FDB::delete('ask_post', 'share_id = ' . $share_id);
        FDB::query('UPDATE ' . FDB::table('ask_thread') . ' SET
				post_count = post_count - 1
				WHERE tid = ' . $post['tid']);
        FDB::query('UPDATE ' . FDB::table('user_count') . ' SET
				ask_posts = ask_posts - 1,
				ask_best_posts = ask_best_posts - ' . $post['is_best'] . '
				WHERE uid = ' . $post['uid']);
        FS("Share")->deleteShare($share_id, $is_score);
        FS('Medal')->runAuto($post['uid'], 'ask_posts');
    }

<?php

$sync_bind_exists = $_FANWE['cookie']['sync_bind_exists'];
$result = array();
if (empty($sync_bind_exists)) {
    $result['status'] = 0;
    outputJson($result);
}
$sync_bind_exists = unserialize(authcode($sync_bind_exists, 'DECODE'));
$is_bind = $_FANWE['request']['is_bind'];
if ($is_bind) {
    $avatar = '';
    $type = $sync_bind_exists['type'];
    $keyid = $sync_bind_exists['keyid'];
    FDB::delete('user_bind', "type = '" . $type . "' AND keyid = '" . $keyid . "'");
    require_once FANWE_ROOT . "core/class/user/" . $type . ".class.php";
    $class = ucfirst($type) . 'User';
    $class = new $class();
    $class->bindByData($sync_bind_exists);
    $result['status'] = 1;
} else {
    $result['status'] = 0;
}
fSetCookie('sync_bind_exists', '');
outputJson($result);

    /**  
     * 保存专辑标签
     * @param int $aid 专辑编号
     * @param array $tags 标签数组
     * @return void
     */
    public function saveTags($aid, $tags)
    {
        $aid = (int) $aid;
        if (!$aid) {
            return;
        }
        FDB::query('UPDATE ' . FDB::table('album_tags') . ' SET album_count = album_count - 1 
			WHERE tag_name IN (SELECT tag_name FROM ' . FDB::table('album_tags_related') . ' WHERE album_id = ' . $aid . ')');
        FDB::delete('album_tags_related', 'album_id = ' . $aid);
        foreach ($tags as $tag) {
            if (empty($tag)) {
                continue;
            }
            $related = array();
            $related['tag_name'] = $tag;
            $related['album_id'] = $aid;
            if (FDB::insert('album_tags_related', $related, false, false, true)) {
                $album_tag = FDB::fetchFirst('SELECT * FROM ' . FDB::table('album_tags') . " WHERE tag_name = '{$tag}'");
                if ($album_tag) {
                    FDB::query('UPDATE ' . FDB::table('album_tags') . " SET album_count = album_count + 1 WHERE tag_name = '{$tag}'");
                } else {
                    $album_tag = array();
                    $album_tag['tag_name'] = $tag;
                    $album_tag['album_count'] = 1;
                    $album_tag['is_new'] = 1;
                    FDB::insert('album_tags', $album_tag);
                }
            }
        }
        FDB::fetchFirst('UPDATE ' . FDB::table('album') . " SET tags = '" . implode(' ', $tags) . "' WHERE id = {$aid}");
    }

    /**
     * 删除分享评论
     * @param int $comment_id 评论编号
     * @return void
     */
    public function deleteShareComment($comment_id)
    {
        $comment = ShareService::getShareComment($comment_id);
        if (empty($comment)) {
            return;
        }
        FDB::delete('share_comment', 'comment_id = ' . $comment_id);
        $share_id = $comment['share_id'];
        //分享评论数量减1
        FDB::query('UPDATE ' . FDB::table('share') . '
			SET comment_count = comment_count - 1
			WHERE share_id = ' . $share_id . ' and comment_count >=1 ');
        //清除分享评论列表缓存
        ShareService::updateShareCache($share_id, 'comments');
    }

 /**
  * 拒绝一个勋章申请
  * @param int $id
  * @return
  */
 public function refuseApplyMedal($id)
 {
     $apply = MedalService::getApply($id);
     if (!$apply) {
         return false;
     }
     MedalService::sendRefuseNotice($apply['uid'], $apply['mid']);
     return FDB::delete('medal_apply', 'id = ' . $id);
 }