public function __construct($url) { global $_FANWE; FanweService::instance()->cache->loadCache('business'); $rs = preg_match("/^(http:\\/\\/|https:\\/\\/)/", $url, $match); if (intval($rs) == 0) { $url = "http://" . $url; } $rs = parse_url($url); $scheme = isset($rs['scheme']) ? $rs['scheme'] . "://" : "http://"; $host = isset($rs['host']) ? $rs['host'] : "none"; $host = explode('.', $host); $host = array_slice($host, -2, 2); $domain = implode('.', $host); $class = FDB::fetchFirst("select `class` from " . FDB::table('sharegoods_module') . " where domain like '%" . $domain . "%' and status = 1 limit 1"); $class = $class['class']; $file = FANWE_ROOT . "core/class/sharegoods/" . $class . "_sharegoods.class.php"; require_once FANWE_ROOT . "core/class/sharegoods/sharegoods.php"; require_once FANWE_ROOT . "core/class/string.class.php"; if (file_exists($file) && isset($_FANWE['cache']['business'][$class])) { require_once $file; $class_name = $class . "_sharegoods"; if (class_exists($class_name)) { $this->share_module = new $class_name(); } } $this->url = $url; }
public function run() { global $_FANWE; $root = array(); $root['return'] = 1; $root['act'] = 'delcomment'; if ($_FANWE['uid'] == 0) { exit; } $comment_id = intval($_FANWE['requestData']['id']); if ($comment_id == 0) { exit; } $share = FDB::fetchFirst('SELECT s.uid,s.share_id FROM ' . FDB::table('share_comment') . ' AS sc INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = sc.share_id WHERE sc.comment_id = ' . $comment_id); if (empty($share)) { exit; } $uid = intval($share['uid']); if ($uid != $_FANWE['uid']) { exit; } FS('Share')->deleteShareComment($comment_id); $root['return'] = 1; m_display($root); }
public function getUserByTypeKeyId($type, $key_id) { $sql = 'SELECT u.uid,u.password,u.status FROM ' . FDB::table('user_bind') . ' as ub INNER JOIN ' . FDB::table('user') . ' as u ON u.uid = ub.uid WHERE ub.type = \'' . $type . '\' AND ub.keyid = \'' . $key_id . '\''; return FDB::fetchFirst($sql); }
/** * 读取Session * @access public * @param string $session_id * @return string */ public function read($session_id) { $sql = "SELECT session_data AS data FROM " . $this->sessionTable . " WHERE session_id = '{$session_id}' AND session_expire >" . time(); $res = FDB::fetchFirst($sql); if ($res) { return $res['data']; } return ""; }
/** * 获取统计信息 * @param int $uid 会员编号 * @param string $type 类型 * @return */ public function get($uid, $type) { $uid = (int) $uid; $type = StatisticsService::getTypeByKey($type); if (!$type || !$uid) { return array(); } return FDB::fetchFirst('SELECT * FROM ' . FDB::table('user_statistics') . ' WHERE uid = ' . $uid . ' AND type = ' . $type); }
public function detail() { global $_FANWE; $id = intval($_FANWE['request']['id']); if ($id == 0) { fHeader("location: " . FU('index/index')); } include fimport('dynamic/u'); //获取相关的分享ID $eventinfo = FDB::fetchFirst("select * from " . FDB::table("event") . " where id=" . $id); if (intval($eventinfo['share_id']) == 0) { fHeader("location: " . FU('index/index')); } $eventinfo['share'] = FS('Share')->getShareDetail($eventinfo['share_id']); if ($share_detail === false) { fHeader("location: " . FU('index')); } $user_share_collect = FS('Share')->getShareCollectUser($eventinfo['share_id']); $page_title = preg_replace("/\\[[^\\]]+\\]/i", "", $eventinfo['title']); $_FANWE['nav_title'] = $page_title . ' - ' . lang('common', 'event'); $_FANWE['seo_description'] = $page_title; $_FANWE['setting']['site_description'] = ''; //分享评论 $page_args = array('id' => $id); $count = $eventinfo['thread_count']; $post_list = array(); if ($count > 0) { $pager = buildPage('event/' . ACTION_NAME, $page_args, $count, $_FANWE['page'], 10); $sql = 'SELECT share_id FROM ' . FDB::table('event_share') . ' WHERE event_id = ' . $id . ' ORDER BY share_id DESC LIMIT ' . $pager['limit']; $ids = array(); $res = FDB::query($sql); while ($data = FDB::fetch($res)) { $ids[] = $data['share_id']; } $ids = implode(',', $ids); $sql = 'SELECT * from ' . FDB::table('share') . ' where share_id IN (' . $ids . ') ORDER BY share_id'; $list = FDB::fetchAll($sql); $post_list = FS('Share')->getShareDetailList($list, true, true, true); } $args = array('share_list' => &$post_list, 'pager' => &$pager, 'current_share_id' => $eventinfo['share_id']); $post_html = tplFetch("inc/share/post_share_list", $args); //热门话题 $hot_event_list = FS("event")->getHotEvent(10); if (intval($_FANWE['uid']) > 0) { //我发布的 $me_event_list = FS("event")->getUserEvent($_FANWE['uid'], 5); //我参与的 $me_join_event_list = FS("event")->getUserJoinevent($_FANWE['uid'], 5); } if (intval($_FANWE['page']) == 1) { FDB::query('UPDATE ' . FDB::table('share') . ' SET click_count = click_count + 1 WHERE share_id = ' . $eventinfo['share_id']); } include template('page/event/event_detail'); display(); }
public function edit() { vendor("common"); $name = $this->getActionName(); $vo = M($name)->getByGoodsId($_REQUEST['goods_id']); $this->assign('vo', $vo); //$category = FDB::fetchAll("select cate_id,cate_name from ".FDB::table("goods_category")." where parent_id = 0"); //$this->assign ( 'category', $category ); $shop = FDB::fetchFirst("select shop_name,shop_id from " . FDB::table("shop") . " where shop_id = " . $vo['shop_id']); $this->assign('shop', $shop); $this->display(); }
public function ajaxLogin() { global $_FANWE; $user_name_or_email = addslashes($_FANWE['request']['email_name']); $password = md5(trim($_FANWE['request']['pass'])); $life = isset($_FANWE['request']['remember']) ? intval($_FANWE['request']['remember']) : 0; $rhash = $_FANWE['request']['rhash']; if (empty($rhash) || $rhash != FORM_HASH) { exit('Access Denied'); } $return = array(); $user_field = $_FANWE['setting']['integrate_field_id']; $sql = "SELECT uid,status,{$user_field} FROM " . FDB::table('user') . " WHERE (email = '{$user_name_or_email}' OR user_name = '{$user_name_or_email}') AND password = '******'"; $user_info = FDB::fetchFirst($sql); $uid = intval($user_info['uid']); $integrate_id = intval($user_info[$user_field]); //===========add by chenfq 2011-10-14========================== if ($uid <= 0) { $uid = FS("Integrate")->addUserToLoacl($user_name_or_email, $password, 1); //重新取一下当前数据库的用户数据 $sql = "SELECT uid,{$user_field} FROM " . FDB::table('user') . " WHERE uid = '{$uid}'"; $user_info = FDB::fetchFirst($sql); $uid = intval($user_info['uid']); $integrate_id = intval($user_info[$user_field]); } //===========add by chenfq 2011-10-14========================== if ($uid > 0) { if ($user_info['status'] == 0) { $return['status'] = 2; outputJson($return); exit; } $user = array('uid' => $uid, 'password' => $password); fSetCookie('last_request', authcode(TIME_UTC - 10, 'ENCODE'), TIME_UTC + 816400, 1, true); FS('User')->setSession($user, $life); $syslogin_js = FS("Integrate")->synLogin($integrate_id); //js 需要在前台执行 add by chenfq 2011-10-15 //$return['syslogin_js'] = $syslogin_js; if (!empty($syslogin_js)) { fSetCookie("dynamic_script", $syslogin_js); } $return['status'] = 1; $return['uid'] = $uid; if (getCookie('redir_url')) { //判断采集图片回调地址,cookie中保持的地址,只使用一次 unset($_FANWE['cookie']['redir_url']); } } else { $return['status'] = 0; } outputJson($return); }
public function collectCates() { setTimeLimit(3600); $ccate = FDB::fetchFirst('SELECT * FROM ' . FDB::table('goods_cate_collect') . ' LIMIT 0,1'); if (!$ccate) { return false; } FDB::query('DELETE FROM ' . FDB::table('goods_cate_collect') . " WHERE id = '{$ccate['id']}'"); global $_FANWE; Cache::getInstance()->loadCache('business'); //QQ号 define('PAIPAI_API_UIN', trim($_FANWE['cache']['business']['paipai']['uin'])); //令牌 define('PAIPAI_API_APPOAUTHID', trim($_FANWE['cache']['business']['paipai']['appoauthid'])); //APP_KEY define('PAIPAI_API_APPOAUTHKEY', trim($_FANWE['cache']['business']['paipai']['appoauthkey'])); define('PAIPAI_API_ACCESSTOKEN', trim($_FANWE['cache']['business']['paipai']['accesstoken'])); define('PAIPAI_API_USERID', trim($_FANWE['cache']['business']['paipai']['userid'])); $sdk = new PaiPaiOpenApiOauth(PAIPAI_API_APPOAUTHID, PAIPAI_API_APPOAUTHKEY, PAIPAI_API_ACCESSTOKEN, PAIPAI_API_UIN); $sdk->setApiPath("/attr/getNavigationChildList.xhtml"); $sdk->setMethod("get"); $sdk->setCharset("utf-8"); $sdk->setFormat("json"); $params =& $sdk->getParams(); $params["navigationId"] = $ccate['cid']; //请求数据 $json = $sdk->invoke(); $json = preg_replace("/[\r\n]/", '', $json); preg_match("/getNavigationChildListSuccess\\((.+?)\\);\\}catch\\(/", $json, $list); $list = json_decode($list[1], true); $sort_file = FANWE_ROOT . '/public/records/cate.sort.php'; $sort = (int) @file_get_contents($sort_file); if (isset($list['childList'])) { foreach ($list['childList'] as $item) { $cate = array(); $cate['type'] = 'paipai'; $cate['id'] = (int) $item['navigationId']; if ($cate['id'] > 0) { $cate['pid'] = $ccate['cid'] == 0 ? '' : $ccate['cid']; $cate['name'] = (string) $item['navigationName']; $cate['pids'] = empty($ccate['pids']) ? $cate['pid'] : $ccate['pids'] . ',' . $cate['pid']; $cate['sort'] = ++$sort; FDB::insert('goods_cates', $cate, false, true); if ((int) $item['isClass'] == 0) { FDB::insert('goods_cate_collect', array('id' => 'NULL', 'cid' => $cate['id'], 'pids' => $cate['pids'])); } } } @file_put_contents($sort_file, $sort); } return true; }
function init($sid, $ip, $uid) { $this->old = array('sid' => $sid, 'ip' => $ip, 'uid' => $uid); $session = array(); if ($sid) { $session = FDB::fetchFirst("SELECT * FROM " . FDB::table('sessions') . " WHERE sid='{$sid}' AND CONCAT_WS('.', ip1,ip2,ip3,ip4)='{$ip}'"); } if (empty($session) || $session['uid'] != $uid) { $session = $this->create($ip, $uid); } $this->var = $session; $this->sid = $session['sid']; }
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 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); FDB::query('UPDATE ' . FDB::table('user') . ' SET seconds = seconds - 1 WHERE uid = ' . $share['uid']); FS('Medal')->runAuto($share['uid'], 'seconds'); }
public function show() { global $_FANWE; $adv_id = intval($_FANWE['request']['id']); $adv = FDB::fetchFirst('SELECT url FROM ' . FDB::table('adv') . ' WHERE id = ' . $adv_id . ' AND status = 1'); if ($adv) { if (!empty($adv['url'])) { fHeader('Location:' . $adv['url']); } else { fHeader('Location:./'); } } else { fHeader('Location:./'); } }
public function run() { global $_FANWE; $root = array(); $root['return'] = 0; //print_r($_FANWE['requestData']); $user_name_or_email = addslashes($_FANWE['requestData']['email']); $password = md5(trim($_FANWE['requestData']['pwd'])); if ($user_name_or_email == '') { $root['info'] = '登陆帐户不能为空'; m_display($root); } $user_field = $_FANWE['setting']['integrate_field_id']; $sql = "SELECT uid,status,{$user_field},server_code FROM " . FDB::table('user') . " WHERE (email = '{$user_name_or_email}' OR user_name = '{$user_name_or_email}') AND password = '******'"; //echo $sql; $user_info = FDB::fetchFirst($sql); //print_r($user_info);exit; $uid = intval($user_info['uid']); $integrate_id = intval($user_info[$user_field]); //===========add by chenfq 2011-10-14========================== if ($uid <= 0) { $uid = FS("Integrate")->addUserToLoacl($user_name_or_email, $password, 1); //重新取一下当前数据库的用户数据 $sql = "SELECT uid,{$user_field},status,server_code FROM " . FDB::table('user') . " WHERE uid = '{$uid}'"; $user_info = FDB::fetchFirst($sql); $uid = intval($user_info['uid']); $integrate_id = intval($user_info[$user_field]); } //===========add by chenfq 2011-10-14========================== //echo $uid; exit; if ($uid > 0) { if ($user_info['status'] == 0) { m_display($root); } $root['uid'] = $uid; $root['user_avatar'] = avatar($uid, 'b', $user_info['server_code'], 1, true); $root['home_user'] = FS("User")->getUserById($uid); $root['return'] = 1; $deviceuid = addslashes(trim($_FANWE['requestData']['deviceuid'])); $sql = "update " . FDB::table('apns_devices') . " set clientid = " . $uid . " where clientid = 0 and deviceuid = '" . $deviceuid . "'"; FDB::query($sql); } else { $root['info'] = '帐户不存在或密码错误'; } m_display($root); }
public function show() { global $_FANWE; $id = (int) $_FANWE['request']['id']; if (!$id) { exit; } $shop = FDB::fetchFirst('SELECT * FROM ' . FDB::table('shop') . ' WHERE shop_id = ' . $id); if (!$shop) { fHeader("location: " . FU('shop/index')); } $_FANWE['nav_title'] = $shop['shop_name'] . ' - ' . $_FANWE['nav_title']; $cache_data = fStripslashes(unserialize($shop['data'])); $shop['tags'] = $cache_data['tags']; if (empty($shop['taoke_url'])) { $shop['to_url'] = FU('tgo', array('url' => $shop['shop_url'])); } else { $shop['to_url'] = FU('tgo', array('url' => $shop['taoke_url'])); } $page_args['id'] = $id; $sql = 'SELECT COUNT(DISTINCT sg.share_id) FROM ' . FDB::table('share_goods') . ' AS sg INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = sg.share_id WHERE s.status = 1 AND sg.shop_id = ' . $id; $share_count = FDB::resultFirst($sql); $page_size = 20; $pager = buildPage('shop/show', $page_args, $share_count, $_FANWE['page'], $page_size); $share_ids = array(); $sql = 'SELECT DISTINCT sg.share_id FROM ' . FDB::table('share_goods') . ' AS sg INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = sg.share_id WHERE s.status = 1 AND sg.shop_id = ' . $id . ' ORDER BY sg.share_id DESC LIMIT ' . $pager['limit']; $res = FDB::query($sql); while ($data = FDB::fetch($res)) { $share_ids[] = $data['share_id']; } $share_list = array(); if (count($share_ids) > 0) { $share_ids = implode(',', $share_ids); $sql = 'SELECT * FROM ' . FDB::table('share') . ' WHERE share_id IN (' . $share_ids . ') ORDER BY share_id DESC'; $share_list = FDB::fetchAll($sql); $share_list = FS('Share')->getShareDetailList($share_list, false, true, true, false, 0, 10); } $shops_tags = FS('Shop')->getUserOtherShopAndTags($id); include template('page/shop/shop_show'); display(); }
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 collectCates() { setTimeLimit(3600); $ccate = FDB::fetchFirst('SELECT * FROM ' . FDB::table('goods_cate_collect') . ' LIMIT 0,1'); if (!$ccate) { return false; } FDB::query('DELETE FROM ' . FDB::table('goods_cate_collect') . " WHERE id = '{$ccate['id']}'"); global $_FANWE; Cache::getInstance()->loadCache('business'); $yiqifa = new YiqifaOpen(trim($_FANWE['cache']['business']['yiqifa']['app_key']), trim($_FANWE['cache']['business']['yiqifa']['app_secret'])); if ($ccate['cid'] == '0') { $list = $yiqifa->getCategoryList(); } else { $list = $yiqifa->getSubCategory($ccate['cid'], 1, 10000); } $sort_file = FANWE_ROOT . '/public/records/cate.sort.php'; $sort = (int) @file_get_contents($sort_file); if (isset($list['categorys'])) { foreach ($list['categorys'] as $item) { $cate = array(); $cate['type'] = 'yiqifa'; if ($ccate['cid'] == '0') { $cate['id'] = $item['catName']; $cate['name'] = $item['catName']; } else { $cate['id'] = $item['subCatName']; $cate['name'] = $item['subCatName']; } $cate['pid'] = $ccate['cid'] == '0' ? '' : $ccate['cid']; $cate['pids'] = empty($ccate['pids']) ? $cate['pid'] : $ccate['pids'] . ',' . $cate['pid']; $cate['sort'] = ++$sort; FDB::insert('goods_cates', $cate, false, true); if ($ccate['cid'] == '0') { FDB::insert('goods_cate_collect', array('id' => 'NULL', 'cid' => $item['catName'], 'pids' => $cate['pids'])); } } @file_put_contents($sort_file, $sort); } return true; }
public function collectCates() { setTimeLimit(3600); $ccate = FDB::fetchFirst('SELECT * FROM ' . FDB::table('goods_cate_collect') . ' LIMIT 0,1'); if (!$ccate) { return false; } FDB::query('DELETE FROM ' . FDB::table('goods_cate_collect') . " WHERE id = '{$ccate['id']}'"); global $_FANWE; include_once FANWE_ROOT . 'sdks/taobao/TopClient.php'; include_once FANWE_ROOT . 'sdks/taobao/request/ItemcatsGetRequest.php'; Cache::getInstance()->loadCache('business'); $sort_file = FANWE_ROOT . '/public/records/cate.sort.php'; $sort = (int) @file_get_contents($sort_file); $client = new TopClient(); $client->appkey = trim($_FANWE['cache']['business']['taobao']['app_key']); $client->secretKey = trim($_FANWE['cache']['business']['taobao']['app_secret']); $req = new ItemcatsGetRequest(); $req->setFields("cid,parent_cid,name,is_parent"); $req->setParentCid($ccate['cid']); $resp = $client->execute($req); if (isset($resp->item_cats) && isset($resp->item_cats->item_cat)) { foreach ($resp->item_cats->item_cat as $item) { $item = (array) $item; $cate = array(); $cate['type'] = 'taobao'; $cate['id'] = $item['cid']; $cate['pid'] = $item['parent_cid'] == 0 ? '' : $item['parent_cid']; $cate['name'] = $item['name']; $cate['pids'] = empty($ccate['pids']) ? $cate['pid'] : $ccate['pids'] . ',' . $cate['pid']; $cate['sort'] = ++$sort; FDB::insert('goods_cates', $cate, false, true); if ($item['is_parent'] == 'true') { FDB::insert('goods_cate_collect', array('id' => 'NULL', 'cid' => $item['cid'], 'pids' => $cate['pids'])); } } @file_put_contents($sort_file, $sort); } return true; }
public function index() { global $_FANWE; $where = ' WHERE status = 1 AND (begin_time <= ' . TIME_UTC . ' OR begin_time = 0) AND (end_time >= ' . TIME_UTC . ' OR end_time = 0)'; $order = ' ORDER BY sort ASC,end_time ASC,id DESC'; $best_list = array(); $best_ids = array(); $sql = 'SELECT * FROM ' . FDB::table('exchange_goods') . $where . ' AND is_best = 1 ' . $order . ' LIMIT 0,4'; $res = FDB::query($sql); while ($data = FDB::fetch($res)) { $data['num'] = $data['stock'] - $data['buy_count']; $data['url'] = FU('exchange/show', array('id' => $data['id'])); $best_list[] = $data; $best_ids[] = $data['id']; } if (count($best_ids) > 0) { $best_ids = implode(',', $best_ids); $where .= ' AND id NOT IN (' . $best_ids . ')'; } $sql = 'SELECT COUNT(id) FROM ' . FDB::table('exchange_goods') . $where; $goods_count = FDB::resultFirst($sql); $page_size = 10; $pager = buildPage('exchange/index', array(), $goods_count, $_FANWE['page'], $page_size); $sql = 'SELECT * FROM ' . FDB::table('exchange_goods') . $where . $order . ' LIMIT ' . $pager['limit']; $goods_list = array(); $res = FDB::query($sql); while ($data = FDB::fetch($res)) { $data['num'] = $data['stock'] - $data['buy_count']; $data['url'] = FU('exchange/show', array('id' => $data['id'])); $goods_list[] = $data; } $order_list = FS("Exchange")->getOrderTop(); $score_list = FS("Exchange")->getScoreTop(); $exchange_list = FS("Exchange")->getExchangeTop(); if ($_FANWE['uid'] > 0) { $consignee = FDB::fetchFirst('SELECT * FROM ' . FDB::table('user_consignee') . ' WHERE uid = ' . $_FANWE['uid']); } include template('page/exchange/exchange_index'); display(); }
public function reply() { define("ACTION_NAME", "reply"); if (intval($GLOBALS['fanwe']->var['uid']) == 0) { fHeader("location: " . FU('user/login')); } global $_FANWE; $mid = intval($_REQUEST['mid']); $sql = "select m.mid,m.title,m.content,m.create_time,au.uid as auid,au.user_name as auser_name,u.uid,u.user_name from " . FDB::table("user_msg") . " as m left join " . FDB::table("user_msg_rel") . " as ml on ml.mid = m.mid left join " . FDB::table("user") . " as u on u.uid = ml.uid left join " . FDB::table("user") . " as au on au.uid = m.author_id " . " where m.mid = " . $mid . " and m.status = 1 and ml.uid = " . intval($GLOBALS['fanwe']->var['uid']); $msg = FDB::fetchFirst($sql); if ($msg) { include template('page/message_reply'); display(); } else { showError("非法的私信", "非法的私信"); } }
<?php $comment_id = intval($_FANWE['request']['comment_id']); if ($comment_id == 0) { exit; } $share = FDB::fetchFirst('SELECT s.uid,s.share_id FROM ' . FDB::table('share_comment') . ' AS sc INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = sc.share_id WHERE sc.comment_id = ' . $comment_id); if (empty($share)) { exit; } $uid = intval($share['uid']); if ($uid != $_FANWE['uid']) { exit; } FS('Share')->deleteShareComment($comment_id); $result = array(); $result['status'] = 1; outputJson($result);
public function show() { global $_FANWE; $id = (int) $_FANWE['request']['id']; if (!$id) { exit; } $album_url = FU('album/show', array('id' => $id)); $album = FS("Album")->getAlbumById($id); $is_follow_album = FS('album')->getIsFollow($id, $_FANWE['uid']); if (empty($album)) { fHeader("location: " . FU('album')); } $home_uid = $album['uid']; $home_user = FS("User")->getUserById($home_uid); $is_show_follow = false; if ($home_uid != $_FANWE['uid']) { if (!FS('User')->getIsFollowUId($home_uid)) { $is_show_follow = true; } } $is_manage_album = false; if ($_FANWE['uid'] == $album['uid']) { $is_manage_album = true; } $sql = 'SELECT * FROM ' . FDB::table('album') . ' WHERE uid = ' . $home_uid . ' and id <> ' . $id . ' ORDER BY id DESC '; $res = FDB::query($sql); while ($data = FDB::fetch($res)) { $data['imgs'] = array(); if (!empty($data['cache_data'])) { $cache_data = unserialize($data['cache_data']); $data['imgs'] = $cache_data['imgs']; unset($data['cache_data']); } $data['img_count'] = count($data['imgs']); $data['url'] = FU('album/show', array('id' => $data['id'])); $album_list[] = $data; } $page_num = intval($_FANWE['setting']['share_self_page']) ? intval($_FANWE['setting']['share_self_page']) : 30; $is_root = false; $img_width = 190; $limit = $page_num; $share_ids = array(); $res = FDB::query('SELECT share_id FROM ' . FDB::table('album_share') . ' WHERE album_id = ' . $id . ' ORDER BY share_id DESC '); while ($data = FDB::fetch($res)) { $share_ids[] = $data['share_id']; } $share_ids = implode(',', $share_ids); if ($share_ids) { $sql = 'SELECT * FROM ' . FDB::table("share") . ' WHERE share_data <> ' . " 'default' and share_id IN (" . $share_ids . ") \r\n\t\t\tORDER BY share_id DESC LIMIT " . $limit; $share_list = FDB::fetchAll($sql); } if ($share_list) { $share_list = FS('Share')->getShareDetailList($share_list, false, false, false, true, 2); $list = array(); $current_user = array(); $current_user['u_url'] = FU('u/index', array('uid' => $_FANWE['uid'])); $current_user['avt'] = avatar($_FANWE['uid'], 's', $is_src = 1); $i = 0; foreach ($share_list as $k => $v) { $list[$i] = $v; $img_info = FDB::fetchFirst("select img,img_width,img_height,is_animate,video from " . FDB::table("share_photo") . " where share_id = " . $v['share_id'] . " and img <> '' "); if ($img_info['is_animate']) { $img = $img_info['img']; } else { $img = getImgName($img_info['img'], $img_width, 999); } $is_video = 0; $vedio_url = ''; if (!empty($img_info['video'])) { $is_video = 1; $vedio_url = $img_info['video']; } $list[$i]['is_video'] = $is_video; $list[$i]['video'] = $vedio_url; $list[$i]['share_img'] = $img; $list[$i]['avt'] = avatar($v['uid'], 's', $is_src = 1); $list[$i]['height'] = $img_info['img_height'] * ($img_width / $img_info['img_width']); /*获取play图标的位置*/ $list[$i]['video_style_top'] = ($list[$i]['height'] - 33) / 2; $list[$i]['video_style_right'] = (254 - 33) / 2; $list[$i]['width'] = $img_width; $list[$i]['share_img_org'] = $img_info['img']; $parent_id = FDB::resultFirst("select parent_id from " . FDB::table("share") . " where share_id = " . $v['share_id']); if ($parent_id == 0) { $list[$i]['isOriginal'] = 1; } else { $list[$i]['isOriginal'] = 0; } $list[$i]['likeStatus'] = FS('Share')->getIsCollectByUid($v['share_id'], $_FANWE['uid']) ? 1 : 0; $list[$i]['isMe'] = $v['uid'] == $_FANWE['uid'] ? 1 : 0; //分享评论 $share_comments = FS('Share')->getShareCommentList($v['share_id'], '0,2'); if ($share_comments) { $share_comments_data = array(); $idxj = 0; foreach ($share_comments as $vv) { $share_comments_data[$idxj]['comment_id'] = $vv['comment_id']; $share_comments_data[$idxj]['parent_id'] = $vv['parent_id']; $share_comments_data[$idxj]['user_url'] = FU('u/index', array('uid' => $vv['user']['uid'])); $share_comments_data[$idxj]['user_name'] = $vv['user']['user_name']; $share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1); $share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20); $idxj++; } $list[$i]['comments'] = $share_comments_data; } $list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id'])); $list[$i]['u_url'] = FU('u/index', array('uid' => $v['uid'])); $list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']); $album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id']; $album = FDB::fetchFirst($album_sql); if ($album) { $list[$i]['album_title'] = $album['title']; $list[$i]['is_album'] = 1; $list[$i]['album_url'] = FU("album/show", array('id' => $album['id'])); } else { $list[$i]['album_title'] = ""; $list[$i]['is_album'] = 0; $list[$i]['album_url'] = ""; } $list[$i]['user_name'] = FDB::resultFirst("select user_name from " . FDB::table('user') . " where uid =" . $v['uid']); $i++; } } if ($list) { $share_detail = $list[0]; } $link_url = $_FANWE['site_url'] . "services/service.php?m=user&a=album_share&width=190&p=2&home_uid=" . $home_uid . "&album_id=" . $id; $json_url = $_FANWE['site_url'] . "services/service.php?m=user&a=album_share&width=190&home_uid=" . $home_uid . "&album_id=" . $id; include template('page/album/album_show'); display(); }
public function fans() { global $_FANWE; $home_uid = $_FANWE['home_uid']; $home_user = FS('User')->getUserById($home_uid); if ($_FANWE['uid'] == $home_uid) { //将我的粉丝信息统计设置为0 FDB::query("update " . FDB::table("user_notice") . " set num=0 where `type`=1 and uid=" . intval($_FANWE['uid'])); } $page_args = array('uid' => $home_uid); Cache::getInstance()->loadCache('citys'); $reside_province = $_FANWE['cache']['citys']['all'][$home_user['reside_province']]['name']; $reside_city = $_FANWE['cache']['citys']['all'][$home_user['reside_city']]['name']; $count = FDB::resultFirst('SELECT COUNT(uid) FROM ' . FDB::table('user_follow') . ' WHERE uid = ' . $home_uid); $pager = buildPage('u/' . ACTION_NAME, $page_args, $count, $_FANWE['page'], 20); $user_list = array(); $res = FDB::query('SELECT u.uid,u.user_name,u.server_code,uc.fans,up.reside_province,up.reside_city FROM ' . FDB::table('user_follow') . ' AS uf INNER JOIN ' . FDB::table('user') . ' AS u ON u.uid = uf.f_uid INNER JOIN ' . FDB::table('user_count') . ' AS uc ON uc.uid = uf.f_uid INNER JOIN ' . FDB::table('user_profile') . ' AS up ON up.uid = uf.f_uid WHERE uf.uid = ' . $home_uid . ' ORDER BY uf.create_time DESC LIMIT ' . $pager['limit']); while ($data = FDB::fetch($res)) { $data['is_follow'] = FS('User')->getIsFollowUId($data['uid']); $data['reside_province'] = $_FANWE['cache']['citys']['all'][$data['reside_province']]['name']; $data['reside_city'] = $_FANWE['cache']['citys']['all'][$data['reside_city']]['name']; $data['share'] = FDB::fetchFirst('SELECT share_id,create_time,content FROM ' . FDB::table('share') . ' WHERE uid = ' . $data['uid'] . ' ORDER BY share_id DESC LIMIT 0,1'); if ($data['share']) { $data['share']['url'] = FU('note/index', array('sid' => $data['share']['share_id'])); $data['share']['time'] = getBeforeTimelag($data['share']['create_time']); } $user_list[] = $data; } include template('page/u/u_fans'); display(); }
public function deletePost($share_id, $is_score = true) { if (intval($share_id) == 0) { return false; } $post = FDB::fetchFirst('SELECT * FROM ' . FDB::table('forum_post') . ' WHERE share_id = ' . $share_id); if (empty($post)) { return true; } FDB::delete('forum_post', 'share_id = ' . $share_id); FDB::query('UPDATE ' . FDB::table('forum_thread') . ' SET post_count = post_count - 1 WHERE tid = ' . $post['tid']); FDB::query('UPDATE ' . FDB::table('user_count') . ' SET forum_posts = forum_posts - 1 WHERE uid = ' . $post['uid']); FS('Share')->deleteShare($share_id, $is_score); FS('Medal')->runAuto($post['uid'], 'ask_posts'); }
<?php $id = (int) $_REQUEST['id']; if ($id == 0) { exit; } else { define('GOODS_ID', $id); } require "init.php"; $goods = FDB::fetchFirst('SELECT sg.*,s.cache_data FROM ' . FDB::table('second_goods') . ' AS sg INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = sg.share_id WHERE sg.gid = ' . GOODS_ID); if ($goods) { header('Content-type: text/xml; charset=utf-8'); $goods['cache_data'] = fStripslashes(unserialize($goods['cache_data'])); FS('Share')->shareImageFormat($goods); unset($goods['cache_data']); $xml = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n"; $xml .= "<goods>\r\n"; $xml .= "<ID>" . GOODS_ID . "</ID>\r\n"; $xml .= "<title><![CDATA[{$goods['name']}]]></title>\r\n"; $xml .= "<description><![CDATA[{$goods['content']}]]></description>\r\n"; $xml .= "<price>{$goods['price']}</price>\r\n"; $xml .= "<totalNumber>{$goods['num']}</totalNumber>\r\n"; $valid_time = fToDate($goods['valid_time'], 'Ymd') . '000000'; $xml .= "<validTime>{$valid_time}</validTime>\r\n"; $xml .= "<transportFee>{$goods['transport_fee']}</transportFee>\r\n"; $xml .= "<picPath>\r\n"; foreach ($goods['imgs'] as $img) { $xml .= "<path>" . str_replace('./', $_FANWE['site_url'], $img['img']) . "</path>\r\n"; }
public function updateUserTodayScore($uid, $score) { $uid = (int) $uid; $score = (int) $score; $statistic = FDB::fetchFirst('SELECT * FROM ' . FDB::table('user_statistics') . ' WHERE uid = ' . $uid . ' AND type = 7'); $today_time = getTodayTime(); if (!$statistic) { $data['uid'] = $uid; $data['num'] = $score; $data['last_time'] = $today_time; $data['type'] = 7; FDB::insert('user_statistics', $data); } else { $data['last_time'] = $today_time; if ($statistic['last_time'] < $today_time) { $data['num'] = $score; } else { $data['num'] = (int) $statistic['num'] + $score; } FDB::update('user_statistics', $data, 'uid = ' . $uid . ' AND type = 7'); } }
/** * 分享列表详细数据 * @param array $list 分享列表 * @param bool $is_parent 是否获取转发信息 * @param bool $is_collect 是否获取喜欢的会员 * @param bool $is_parent 是否获取分享标签 * @return array */ function mGetShareDetailList($list, $is_parent = false, $img_width = 160, $img_height = 160) { global $_FANWE; $shares = array(); $share_ids = array(); $rec_shares_ids = array(); $share_users = array(); foreach ($list as $item) { $share_id = $item['share_id']; if ($item['share_data'] == 'default') { continue; } $share_ids[] = $share_id; $item['cache_data'] = fStripslashes(unserialize($item['cache_data'])); $item['time'] = getBeforeTimelag($item['create_time']); $item['url'] = FU('note/index', array('sid' => $share_id), true); if ($item['source'] == 'web') { $item['source'] = $_FANWE['setting']['site_name'] . '网站'; } $item['imgs'] = array(); $img = array(); $img_sql = 'select photo_id,img,img_width,img_height from ' . FDB::table('share_photo') . ' where share_id = ' . $share_id; $img_data = FDB::fetchFirst($img_sql); $img['share_id'] = $share_id; $img['id'] = $img_data['photo_id']; $img['name'] = ''; $img['type'] = ''; $img['price'] = ''; $img['goods_url'] = ''; $img['taoke_url'] = ''; $img['price_format'] = ''; $img['server_code'] = ''; $img['img_width'] = $img_data['img_width']; $img['img'] = FS("Image")->getImageUrl($img_data['img'], 2); $img['img_height'] = $img_data['img_height']; $img['width'] = 160; $img['small_img'] = FS("Image")->getImageUrl(getImgName($img_data['img'], 160, 160, 0, true), 2); $item['imgs'][] = $img; m_express(&$item, $item['content']); $shares[$share_id] = $item; unset($shares[$share_id]['cache_data']); $shares[$share_id]['user'] =& $share_users[$item['uid']]; $shares[$share_id]['is_relay'] = false; $shares[$share_id]['is_parent'] = false; if ($is_parent) { if ($item['base_id'] > 0) { $shares[$share_id]['is_relay'] = true; $rec_shares_ids[$item['base_id']] = false; $shares[$share_id]['relay_share'] =& $rec_shares_ids[$item['base_id']]; } elseif ($item['parent_id'] > 0 && $item['parent_id'] != $item['base_id']) { $shares[$share_id]['is_parent'] = true; $rec_shares_ids[$item['parent_id']] = false; $shares[$share_id]['parent_share'] =& $rec_shares_ids[$item['parent_id']]; } } } $rec_ids = array_keys($rec_shares_ids); if (count($rec_ids) > 0) { $intersects = array_intersect($share_ids, $rec_ids); $temp_ids = array(); foreach ($intersects as $share_id) { $rec_shares_ids[$share_id] = $shares[$share_id]; $temp_ids[] = $share_id; } $diffs = array_diff($rec_ids, $temp_ids); if (count($diffs) > 0) { $res = FDB::query('SELECT * FROM ' . FDB::table('share') . ' WHERE share_id IN (' . implode(',', $diffs) . ')'); while ($item = FDB::fetch($res)) { $share_id = $item['share_id']; $share_ids[] = $share_id; $item['cache_data'] = fStripslashes(unserialize($item['cache_data'])); $item['time'] = getBeforeTimelag($item['create_time']); $item['url'] = FU('note/index', array('sid' => $share_id), true); if ($item['source'] == 'web') { $item['source'] = $_FANWE['setting']['site_name'] . '网站'; } m_express(&$item, $item['content']); $item['imgs'] = array(); $img = array(); $img_sql = 'select photo_id,img,img_width,img_height from ' . FDB::table('share_photo') . ' where share_id = ' . $share_id; $img_data = FDB::fetchFirst($img_sql); $img['share_id'] = $share_id; $img['id'] = $img_data['photo_id']; $img['name'] = ''; $img['type'] = ''; $img['price'] = ''; $img['goods_url'] = ''; $img['taoke_url'] = ''; $img['price_format'] = ''; $img['server_code'] = ''; $img['img_width'] = $img_data['img_width']; $img['img'] = FS("Image")->getImageUrl($img_data['img'], 2); $img['img_height'] = $img_data['img_height']; $img['width'] = 160; $img['small_img'] = FS("Image")->getImageUrl(getImgName($img_data['img'], 160, 160, 0, true), 2); $item['imgs'][] = $img; $rec_shares_ids[$share_id] = $item; unset($rec_shares_ids[$share_id]['cache_data']); $rec_shares_ids[$share_id]['user'] =& $share_users[$item['uid']]; } } } $user_ids = array_keys($share_users); if (count($user_ids) > 0) { $res = FDB::query("SELECT uid,user_name,server_code FROM " . FDB::table('user') . ' WHERE uid IN (' . implode(',', $user_ids) . ')'); while ($item = FDB::fetch($res)) { $item['user_avatar'] = FS("Image")->getImageUrl('.' . avatar($item['uid'], 'm', 1), 2); $share_users[$item['uid']] = $item; } } return $shares; }
private function show($current_type = '') { global $_FANWE; $share_id = intval($_FANWE['request']['sid']); $id = intval($_FANWE['request']['id']); $share_detail = FS('Share')->getShareDetail($share_id); include fimport('dynamic/u'); if ($share_detail === false) { fHeader("location: " . FU('index')); } $page_title = preg_replace("/\\[[^\\]]+\\]/i", "", $share_detail['content']); $_FANWE['nav_title'] = $page_title . ' - ' . lang('common', 'share'); $_FANWE['seo_description'] = $page_title; $_FANWE['setting']['site_description'] = ''; $current_img = FDB::resultFirst("select img from " . FDB::table("share_photo") . " where share_id = " . $share_id . " and img <> '' "); if ($current_img['img_width'] > 468) { $current_img['img_width'] = 468; } $current_img_arr = FDB::fetchFirst("select * from " . FDB::table("share_photo") . " where share_id = " . $share_id . " and img <> '' "); //var_dump($current_img_arr); FDB::query('UPDATE ' . FDB::table('share') . ' SET click_count = click_count + 1 WHERE share_id = ' . $share_id); //上一个,下一个分享 $pns = FS('Share')->getSameAlbumNextShares($share_detail['uid'], $share_id); $other_album_share = FS('share')->getSameAlbumShares($share_id); $current_location = $other_album_share['location']; unset($other_album_share['location']); $same_album_count = $other_album_share['count']; unset($other_album_share['count']); $aid = FDB::resultFirst("select album_id from " . FDB::table('album_share') . " where share_id = " . $share_id); $album_sql = 'select al.id as id,al.title as title from ' . FDB::table('album') . ' as al left join ' . FDB::table('album_share') . ' as als on al.id = als.album_id where als.share_id = ' . $share_id; $album_data = FDB::fetchFirst($album_sql); $is_follow_album = FS('album')->getIsFollow($aid, $_FANWE['uid']); //发布分享的会员 $share_user = FS('User')->getUserById($share_detail['uid']); //喜欢分享的会员 $share_detail['collects'] = FS('Share')->getShareCollectUser($share_id); if (!isset($share_detail['collects'][$_FANWE['uid']])) { if (FS('Share')->getIsCollectByUid($share_id, $_FANWE['uid'])) { $share_detail['collects'][$_FANWE['uid']] = $_FANWE['uid']; } } //会员显示名称 $user_show_name = FS('User')->getUserShowName($share_detail['uid']); //会员勋章 $user_medals = FS('User')->getUserMedal($share_detail['uid']); //分享标签 $share_tags = $share_detail['cache_data']['tags']['user']; FS('Share')->tagsFormat($share_tags); foreach ($share_tags as $seo_tag) { $_FANWE['seo_keywords'] .= $seo_tag['tag_name'] . ','; } //是否可编辑标签 $is_eidt_tag = FS('Share')->getIsEditTag($share_detail); //喜欢分享的会员还喜欢 $fav_user_fav_share = FS('Share')->getCollectShareByShare($share_id); //发布分享的会员喜欢的分享 $user_collect_share = FS('Share')->getCollectShareByUser($share_user['uid']); //是否可删除标签 $is_remove_comment = FS('Share')->getIsRemoveComment($share_detail); //分享评论 $share_detail['comments'] = FS('Share')->getShareCommentList($share_id, '0,10'); //分享评论分页 $pager = buildPage('', array(), $share_detail['comment_count'], $_FANWE['page'], 10); unset($share_detail['cache_data']); $current_obj = NULL; if ($current_type == '' || $id == 0) { if (!empty($share_detail['imgs'])) { $current_obj = current($share_detail['imgs']); if ($current_obj['type'] == 'g') { $current_type = 'bao'; } else { $current_type = 'photo'; } } } else { switch ($current_type) { case 'bao': foreach ($share_detail['imgs'] as $img) { $current_obj = $img; if ($img['type'] == 'g' && $img['id'] == $id) { break; } } break; case 'photo': foreach ($share_detail['imgs'] as $img) { $current_obj = $img; if ($img['type'] == 'm' && $img['id'] == $id) { break; } } break; } } if (!empty($current_obj['name'])) { $_FANWE['nav_title'] = $current_obj['name'] . ' - ' . lang('common', 'share'); } $current_img_id = FDB::resultFirst("select photo_id from " . FDB::table("share_photo") . " where share_id = " . $share_id); //会员最被喜欢的照片 $best_photo_share = FS('Share')->getBestCollectPhotoShareByUser($share_user['uid']); $current_type = FDB::resultFirst("select type from " . FDB::table("share_photo") . " where share_id = " . $share_id); if ($current_type == 'video') { $current_video = FDB::resultFirst("select video from " . FDB::table("share_photo") . " where share_id = " . $share_id); } //会员喜欢的照片 $user_fav_photo = FS('Share')->getUserFavPhotoShare($share_user['uid']); $is_follow = FS('Share')->getIsCollectByUid($share_id, $_FANWE['uid']); include template('page/note/note_index'); display(); }
/** * 显示指定ID的广告位ID * @param string $id 广告位 * @param int $count 显示数量 * @param string $target 关键字 * @return array */ function getAdvPosition($id, $count = '', $target = '') { global $_FANWE; $ap = FDB::fetchFirst('SELECT * FROM ' . FDB::table('adv_position') . ' WHERE id =' . $id); if (!$ap) { return ''; } if ($target != '') { $target = explode(',', $target); } $where = "status = 1 AND position_id = '{$id}'"; if ($target != '') { $where .= ' AND target_key' . FDB::createIN($target); } $sql = 'SELECT * FROM ' . FDB::table('adv') . ' WHERE ' . $where . ' ORDER BY sort ASC,id DESC'; if ($count > 0) { $sql .= ' LIMIT 0,' . $count; } $adv_res = FDB::query($sql); $adv_list = array(); while ($adv = FDB::fetch($adv_res)) { $adv['html'] = getAdvHTML($adv, $ap); $adv['durl'] = FU("adv/show", array("id" => $adv['id'])); $adv['turl'] = $adv['url']; $adv['url'] = urlencode(FU("adv/show", array("id" => $adv['id']))); $adv_list[] = $adv; } $ap['adv_list'] = $adv_list; return $ap; }
foreach ($share_comments as $vv) { $share_comments_data[$idxj]['comment_id'] = $vv['comment_id']; $share_comments_data[$idxj]['parent_id'] = $vv['parent_id']; $share_comments_data[$idxj]['user_url'] = FU('u/index', array('uid' => $vv['user']['uid'])); $share_comments_data[$idxj]['user_name'] = $vv['user']['user_name']; $share_comments_data[$idxj]['avt'] = avatar($vv['uid'], 's', $is_src = 1); $share_comments_data[$idxj]['comment'] = cutStr($vv['content'], 20); $idxj++; } $list[$i]['comments'] = $share_comments_data; } $list[$i]['share_url'] = FU('note/index', array('sid' => $v['share_id'])); $list[$i]['u_url'] = FU('u/index', array('uid' => $v['uid'])); $list[$i]['relay_count'] = FDB::resultFirst("select relay_count from " . FDB::table("share") . " where share_id = " . $v['share_id']); $album_sql = "select a.id,a.title from " . FDB::table('album_share') . " as ah left join " . FDB::table('album') . " as a on ah.album_id = a.id where ah.share_id = " . $v['share_id']; $album = FDB::fetchFirst($album_sql); if ($album) { $list[$i]['album_title'] = $album['title']; $list[$i]['is_album'] = 1; $list[$i]['album_url'] = FU("album/show", array('id' => $album['id'])); } else { $list[$i]['album_title'] = ""; $list[$i]['is_album'] = 0; $list[$i]['album_url'] = ""; } $list[$i]['zf_count'] = 10; $list[$i]['xh_count'] = 20; $list[$i]['user_name'] = FDB::resultFirst("select user_name from " . FDB::table('user') . " where uid =" . $v['uid']); $i++; } outputJson(array('result' => $list, 'current_user' => $current_user, 'status' => 1, 'hasNextPage' => $is_next));