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);
}
