[parasy commit] r56 - trunk/upload
codesite...@google.com
Date: Sun Jun 15 21:19:53 2008
New Revision: 56
Added:
trunk/upload/parasy_my.php
Removed:
trunk/upload/my.php
Log:
New "My" Page
Added: trunk/upload/parasy_my.php
==============================================================================
--- (empty file)
+++ trunk/upload/parasy_my.php Sun Jun 15 21:19:53 2008
@@ -0,0 +1,461 @@
+<?php
+
+/*
+ [Discuz!] (C)2001-2007 Comsenz Inc.
+ This is NOT a freeware, use is subject to license terms
+
+ $RCSfile: my.php,v $
+ $Revision: 1.68.2.9 $
+ $Date: 2007/07/24 13:11:52 $
+*/
+
+define('NOROBOT', TRUE);
+require_once './include/common.inc.php';
+require_once DISCUZ_ROOT.'./forumdata/cache/cache_forums.php';
+
+$discuz_action = 8;
+if(!$discuz_uid) {
+ showmessage('not_loggedin', NULL, 'NOPERM');
+}
+
+$page = max(1, intval($page));
+$start_limit = ($page - 1) * $tpp;
+$app_hide_sidebar = array('buddy','fav');
+$threadlist = $postlist = array();
+
+$tids = $comma = $threadadd = $postadd = $forumname = $extrafid =
$extra = '';
+
+if($srchfid = intval($srchfid)) {
+ $threadadd = "AND t.fid='$srchfid'";
+ $postadd = "AND p.fid='$srchfid'";
+ $forumname = $_DCACHE['forums'][$srchfid]['name'];
+ $extrafid = '/fid/'.$srchfid;
+}
+
+$item = isset($item) ? trim($item) : '';
+if(empty($item)) {
+
+ $query = $db->query("SELECT m.*, t.subject, t.fid, t.displayorder,
t.lastposter, t.lastpost, t.closed FROM {$tablepre}mythreads m,
{$tablepre}threads t
+ WHERE m.uid='$discuz_uid' AND m.tid=t.tid $threadadd ORDER BY
m.dateline DESC LIMIT 5");
+ while($thread = $db->fetch_array($query)) {
+ $thread['lastpost'] = gmdate("$dateformat $timeformat",
$thread['lastpost'] + $timeoffset * 3600);
+ $thread['forumname'] = $_DCACHE['forums'][$thread['fid']]['name'];
+ $thread['lastposterenc'] = rawurlencode($thread['lastposter']);
+ $threadlist[] = $thread;
+ }
+
+ $query = $db->query("SELECT m.*, p.fid, p.invisible FROM
{$tablepre}myposts m
+ INNER JOIN {$tablepre}posts p ON p.pid=m.pid $postadd
+ INNER JOIN {$tablepre}threads t ON t.tid=m.tid
+ WHERE m.uid = '$discuz_uid' ORDER BY m.dateline DESC LIMIT 5");
+ while($post = $db->fetch_array($query)) {
+ $post['forumname'] = $_DCACHE['forums'][$post['fid']]['name'];
+ $postlist[$post['tid']] = $post;
+ $tids .= $comma.$post['tid'];
+ $comma = ', ';
+ }
+
+ if($tids) {
+ $query = $db->query("SELECT tid, subject, lastposter, lastpost FROM
{$tablepre}threads WHERE tid IN ($tids)");
+ while($thread = $db->fetch_array($query)) {
+ $postlist[$thread['tid']]['subject'] = $thread['subject'];
+ $postlist[$thread['tid']]['lastposter'] = $thread['lastposter'];
+ $postlist[$thread['tid']]['lastpost'] = gmdate("$dateformat
$timeformat", $thread['lastpost'] + $timeoffset * 3600);
+ $postlist[$thread['tid']]['lastposterenc'] = rawurlencode($thread['lastposter']);
+ }
+ }
+
+} elseif($item == 'threads') {
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}mythreads m,
{$tablepre}threads t WHERE m.uid='$discuz_uid' $threadadd AND m.tid=t.tid");
+ $num = $db->result($query, 0);
+ $multipage =now_multi($num, $tpp, $page, $bbsdir.'/my/threads'.$extrafid.'/page/');
+
+ $query = $db->query("SELECT m.*, t.subject, t.fid, t.displayorder,
t.closed, t.lastposter, t.lastpost FROM {$tablepre}mythreads m,
{$tablepre}threads t
+ WHERE m.uid = '$discuz_uid' $threadadd AND m.tid=t.tid ORDER BY
m.dateline DESC LIMIT $start_limit, $tpp");
+ while($thread = $db->fetch_array($query)) {
+ $thread['lastpost'] = gmdate("$dateformat $timeformat",
$thread['lastpost'] + $timeoffset * 3600);
+ $thread['forumname'] = $_DCACHE['forums'][$thread['fid']]['name'];
+ $thread['lastposterenc'] = rawurlencode($thread['lastposter']);
+ $threadlist[] = $thread;
+ }
+
+} elseif($item == 'posts') {
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}myposts m
+ INNER JOIN {$tablepre}posts p ON p.pid=m.pid $postadd
+ INNER JOIN {$tablepre}threads t ON t.tid=m.tid
+ WHERE m.uid = '$discuz_uid'");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp,
$page, 'my.php?item=posts'.($srchfid ? "&srchfid=$srchfid" : NULL).$extrafid);
+
+ $query = $db->query("SELECT m.uid, m.tid, m.pid, p.fid, p.invisible,
p.dateline FROM {$tablepre}myposts m
+ INNER JOIN {$tablepre}posts p ON p.pid=m.pid $postadd
+ INNER JOIN {$tablepre}threads t ON t.tid=m.tid
+ WHERE m.uid = '$discuz_uid' ORDER BY m.dateline DESC LIMIT
$start_limit, $tpp");
+ while($post = $db->fetch_array($query)) {
+ $post['forumname'] = $_DCACHE['forums'][$post['fid']]['name'];
+ $postlist[$post['tid']] = $post;
+ $tids .= $comma.$post['tid'];
+ $comma = ', ';
+ }
+
+ if($tids) {
+ $query = $db->query("SELECT tid, subject AS tsubject, lastposter,
lastpost FROM {$tablepre}threads WHERE tid IN ($tids)");
+ while($thread = $db->fetch_array($query)) {
+ $postlist[$thread['tid']]['tsubject'] = $thread['tsubject'];
+ $postlist[$thread['tid']]['lastposter'] = $thread['lastposter'];
+ $postlist[$thread['tid']]['lastpost'] = gmdate("$dateformat
$timeformat", $thread['lastpost'] + $timeoffset * 3600);
+ $postlist[$thread['tid']]['lastposterenc'] = rawurlencode($thread['lastposter']);
+ }
+ }
+
+} elseif(in_array($item, array('favorites', 'subscriptions'))) {
+
+ if($fid && empty($forum['allowview'])) {
+ if(!$forum['viewperm'] && !$readaccess) {
+ showmessage('group_nopermission', NULL, 'NOPERM');
+ } elseif($forum['viewperm'] && !forumperm($forum['viewperm'])) {
+ showmessage('forum_nopermission', NULL, 'NOPERM');
+ }
+ }
+
+ if($item == 'favorites') {
+
+ $ftid = $type == 'thread' || $tid ? 'tid' : 'fid';
+ $type = $type == 'thread' || $tid ? 'thread' : 'forum';
+ $extra .= $srchfid ? '&type='.$type : '';
+
+ if(($fid || $tid) && !submitcheck('favsubmit')) {
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}favorites
WHERE uid='$discuz_uid' AND $ftid>'0'");
+ if($db->result($query, 0) >= $maxfavorites) {
+ showmessage('favorite_is_full', 'my.php?item=favorites&type='.$type);
+ }
+
+ $query = $db->query("SELECT $ftid FROM {$tablepre}favorites WHERE
uid='$discuz_uid' AND $ftid='${$ftid}' LIMIT 1");
+ if($db->result($query, 0)) {
+ showmessage('favorite_exists');
+ } else {
+ $db->query("INSERT INTO {$tablepre}favorites (uid, $ftid,dateline)
VALUES ('$discuz_uid', '${$ftid}','{$timestamp}')");
+ fav_update($discuz_uid);
+ require DISCUZ_ROOT.'./include/cache.func.php';
+ updatecache('fav');
+ showmessage('favorite_add_succeed', dreferer());
+ }
+
+ } elseif(!$fid && !$tid) {
+
+ if(!submitcheck('favsubmit')) {
+
+ $favlist = array();
+ if($type == 'forum') {
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}favorites
fav, {$tablepre}forums f
+ WHERE fav.uid = '$discuz_uid' AND fav.fid=f.fid");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=favorites&type=forum$extrafid");
+
+ $query = $db->query("SELECT f.fid, f.name, f.threads, f.posts,
f.todayposts, f.lastpost
+ FROM {$tablepre}favorites fav, {$tablepre}forums f
+ WHERE fav.fid=f.fid AND fav.uid='$discuz_uid' ORDER BY
f.lastpost DESC LIMIT $start_limit, $tpp");
+
+ while($fav = $db->fetch_array($query)) {
+ $fav['lastposterenc'] = rawurlencode($fav['lastposter']);
+ $fav['lastpost'] = gmdate("$dateformat $timeformat",
$fav['lastpost'] + $timeoffset * 3600);
+ $favlist[] = $fav;
+ }
+ } else {
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}favorites
fav, {$tablepre}threads t
+ WHERE fav.uid = '$discuz_uid' AND fav.tid=t.tid AND
t.displayorder>='0' $threadadd");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=favorites&type=thread$extrafid");
+
+ $query = $db->query("SELECT t.tid, t.fid, t.subject, t.replies,
t.lastpost, t.lastposter, f.name
+ FROM {$tablepre}favorites fav, {$tablepre}threads t,
{$tablepre}forums f
+ WHERE fav.tid=t.tid AND t.displayorder>='0' AND
fav.uid='$discuz_uid' AND t.fid=f.fid $threadadd
+ ORDER BY t.lastpost DESC LIMIT $start_limit, $tpp");
+
+ while($fav = $db->fetch_array($query)) {
+ $fav['lastposterenc'] = rawurlencode($fav['lastposter']);
+ $fav['lastpost'] = gmdate("$dateformat $timeformat",
$fav['lastpost'] + $timeoffset * 3600);
+ $favlist[] = $fav;
+ }
+ }
+
+ } else {
+
+ if($ids = implodeids($delete)) {
+ $db->query("DELETE FROM {$tablepre}favorites WHERE
uid='$discuz_uid' AND $ftid IN ($ids)", 'UNBUFFERED');
+ fav_update($discuz_uid);
+ require DISCUZ_ROOT.'./include/cache.func.php';
+ updatecache('fav');
+ }
+ showmessage('favorite_update_succeed', $bbsdir.'/my/favs/'.$type);
+ }
+
+ }
+ } else {
+
+ if(isset($subadd) && !submitcheck('subsubmit')) {
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}subscriptions
WHERE uid='$discuz_uid'");
+ if($db->result($query, 0) >= $maxsubscriptions) {
+ showmessage('subscription_is_full', 'my.php?item=subscriptions');
+ }
+
+ $query = $db->query("SELECT tid FROM {$tablepre}subscriptions WHERE
tid='$subadd' AND uid='$discuz_uid' LIMIT 1");
+ if($db->result($query, 0)) {
+ showmessage('subscription_exists');
+ } else {
+ $db->query("INSERT INTO {$tablepre}subscriptions (uid, tid,
lastnotify) VALUES ('$discuz_uid', '$subadd', '')");
+ showmessage('subscription_add_succeed', dreferer());
+ }
+
+ } elseif(empty($subadd)) {
+
+ if(!submitcheck('subsubmit')) {
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}subscriptions
s, {$tablepre}threads t
+ WHERE s.uid = '$discuz_uid' AND s.tid=t.tid $threadadd");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=subscriptions$extrafid");
+
+ $subslist = array();
+ $query = $db->query("SELECT t.tid, t.fid, t.subject, t.replies,
t.lastpost, t.lastposter, f.name
+ FROM {$tablepre}subscriptions s, {$tablepre}threads t,
{$tablepre}forums f
+ WHERE t.tid=s.tid AND t.displayorder>='0' AND f.fid=t.fid AND
s.uid='$discuz_uid' $threadadd
+ ORDER BY t.lastpost DESC LIMIT $start_limit, $tpp");
+
+ while($subs = $db->fetch_array($query)) {
+ $subs['lastposterenc'] = rawurlencode($subs['lastposter']);
+ $subs['lastpost'] = gmdate("$dateformat $timeformat",
$subs['lastpost'] + $timeoffset * 3600);
+ $subslist[] = $subs;
+ }
+ } else {
+
+ if($ids = implodeids($delete)) {
+ $db->query("DELETE FROM {$tablepre}subscriptions WHERE
uid='$discuz_uid' AND tid IN ($ids)", 'UNBUFFERED');
+ }
+ showmessage('subscription_update_succeed', dreferer());
+
+ }
+ }
+ }
+} elseif($item == 'selltrades' || $item == 'buytrades') {
+
+ if(empty($ec_id)) {
+ showmessage('undefined_action', NULL, 'HALTED');
+ }
+
+ require_once DISCUZ_ROOT.'./api/tradeapi.php';
+ include_once language('misc');
+
+ $sqlfield = $item == 'selltrades' ? 'sellerid' : 'buyerid';
+ switch($filter) {
+ case 'attention': $typestatus = $item; break;
+ case 'trading' : $typestatus = 'tradingtrades'; break;
+ case 'success' : $typestatus = 'successtrades'; break;
+ case 'closed' : $typestatus = 'closedtrades'; break;
+ case 'refund' : $typestatus = 'refundtrades'; break;
+ case 'unstart' : $typestatus = 'unstarttrades'; break;
+ default : $typestatus = '';
+ }
+
+ $sqlfilter = $typestatus ? 'AND tl.status IN (\''.trade_typestatus($typestatus).'\')' : '';
+
+ $sqltid = $tid ? 'AND tl.tid ='.$tid : '';
+ $extra .= $srchfid ? '&filter='.$filter : '';
+ $extratid = $tid ? "&tid=$tid" : '';
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog tl,
{$tablepre}threads t WHERE tl.tid = t.tid AND
tl.$sqlfield='$discuz_uid' $threadadd $sqltid $sqlfilter");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=$item$extratid$extrafid".($filter ? "&filter=$filter" : '').$extrafid);
+ $query = $db->query("SELECT tl.*, t.subject AS threadsubject FROM
{$tablepre}tradelog tl, {$tablepre}threads t
+ WHERE tl.tid = t.tid AND tl.$sqlfield = '$discuz_uid' $threadadd
$sqltid $sqlfilter ORDER BY lastupdate DESC LIMIT $start_limit, $tpp");
+
+ $tradeloglist = array();
+ while($tradelog = $db->fetch_array($query)) {
+ $tradelog['lastupdate'] = gmdate("$dateformat $timeformat",
$tradelog['lastupdate'] + $timeoffset * 3600);
+ $tradelog['attend'] = trade_typestatus($item, $tradelog['status']);
+ $tradelog['status'] = trade_getstatus($tradelog['status']);
+ $tradeloglist[] = $tradelog;
+ }
+} elseif($item == 'tradestats') {
+
+ if(empty($ec_id)) {
+ showmessage('undefined_action', NULL, 'HALTED');
+ }
+
+ require_once DISCUZ_ROOT.'./api/tradeapi.php';
+
+ $buyerattends = trade_typestatus('buytrades');
+ $sellerattends = trade_typestatus('selltrades');
+
+ $query = $db->query("SELECT COUNT(*) AS totalitems, SUM(price) AS
tradesum FROM {$tablepre}tradelog WHERE buyerid='$discuz_uid' and
status in ('".trade_typestatus('successtrades')."')");
+ $buystats = $db->fetch_array($query);
+ $query = $db->query("SELECT COUNT(*) AS totalitems, SUM(price) AS
tradesum FROM {$tablepre}tradelog WHERE sellerid='$discuz_uid' and
status in ('".trade_typestatus('successtrades')."')");
+ $sellstats = $db->fetch_array($query);
+ $currentcredit = $_DSESSION['extcredits'.$creditstrans];
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE
buyerid='$discuz_uid' AND status in ('$buyerattends')");
+ $buyerattend = $db->result($query, 0);
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE
sellerid='$discuz_uid' AND status in ('$sellerattends')");
+ $sellerattend = $db->result($query, 0);
+} elseif($item == 'tradethreads') {
+
+ if(empty($ec_id)) {
+ showmessage('undefined_action', NULL, 'HALTED');
+ }
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}threads t INNER
JOIN {$tablepre}trades USING(tid) WHERE t.authorid='$discuz_uid' AND
t.special='2' $threadadd");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=tradethreads$extrafid");
+
+ $query = $db->query("SELECT t.*, tr.amount, tr.totalitems,
tr.tradesum, tr.lastbuyer, tr.lastupdate FROM {$tablepre}threads t
INNER JOIN {$tablepre}trades tr using(tid) WHERE
t.authorid='$discuz_uid' AND t.special='2' $threadadd ORDER BY
tr.tradesum DESC, tr.totalitems DESC LIMIT $start_limit, $tpp");
+ while($tradethread = $db->fetch_array($query)) {
+ $tradethread['lastupdate'] = gmdate("$dateformat $timeformat",
$tradethread['lastupdate'] + $timeoffset * 3600);
+ $tradethread['lastbuyer'] = rawurlencode($tradethread['lastbuyer']);
+ $threadlist[] = $tradethread;
+ }
+} elseif($item == 'reward') {
+
+ $rewardloglist = Array();
+ $multipage = '';
+
+ if($type == 'stats') {
+
+ $query = $db->query("SELECT COUNT(*) AS total, SUM(ABS(netamount))
AS totalprice FROM {$tablepre}rewardlog WHERE authorid='$discuz_uid'");
+ $questions = $db->fetch_array($query);
+ $questions['total'] = $questions['total'] ? $questions['total'] : 0;
+ $questions['totalprice'] = $questions['totalprice'] ?
$questions['totalprice'] : 0;
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}rewardlog WHERE
authorid='$discuz_uid' and answererid>0");
+ $questions['solved'] = $db->result($query, 0);
+ $questions['percent'] = number_format(($questions['total'] != 0) ?
round($questions['solved'] / $questions['total'] * 100, 2) : 0, 2, '.', '');
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}rewardlog WHERE answererid='$discuz_uid'");
+ $answers['total'] = $db->result($query, 0);
+ $query = $db->query("SELECT COUNT(*) AS tids, SUM(ABS(t.price)) AS totalprice
+ FROM {$tablepre}rewardlog r
+ LEFT JOIN {$tablepre}threads t USING(tid)
+ WHERE r.authorid>0 and r.answererid='$discuz_uid'");
+ $answeradopted = $db->fetch_array($query);
+ $answers['adopted'] = $answeradopted['tids'];
+ $answers['totalprice'] = $answeradopted['totalprice'] ?
$answeradopted['totalprice'] : 0;
+ $answers['percent'] = number_format(($answers['total'] != 0) ?
round($answers['adopted'] / $answers['total'] * 100, 2) : 0, 2, '.', '');
+
+ } elseif($type == 'answer') {
+
+ $extra .= $srchfid ? '&type=answer' : '';
+ $filter = isset($filter) && in_array($filter,
array('adopted', 'unadopted')) ? $filter : '';
+ $sqlfilter = empty($filter) ? '' : ($filter == 'adopted' ? 'AND
r.authorid>0' : 'AND r.authorid=0');
+
+ $page = max(1, intval($page));
+ $start_limit = ($page - 1) * $tpp;
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}rewardlog r
WHERE answererid='$discuz_uid'");
+ $multipage = multi($db->result($query, 0), $tpp, $page, "my.php?item=reward&type=answer$extrafid");
+
+ $query = $db->query("SELECT r.*, t.subject, t.price, m.uid,
m.username, f.fid, f.name
+ FROM {$tablepre}rewardlog r
+ LEFT JOIN {$tablepre}threads t ON t.tid=r.tid
+ LEFT JOIN {$tablepre}forums f ON f.fid=t.fid
+ LEFT JOIN {$tablepre}members m ON m.uid=t.authorid
+ WHERE r.answererid='$discuz_uid' $threadadd $sqlfilter
+ ORDER BY r.dateline DESC
+ LIMIT $start_limit, $tpp");
+
+ while($rewardlog = $db->fetch_array($query)) {
+ $rewardlog['dateline'] = gmdate("$dateformat $timeformat",
$rewardlog['dateline'] + $timeoffset * 3600);
+ $rewardlog['price'] = abs($rewardlog['price']);
+ $rewardloglist[] = $rewardlog;
+ }
+
+ } elseif($type == 'question') {
+
+ $extra .= $srchfid ? '&type=question' : '';
+ $filter = in_array($filter, array('solved', 'unsolved')) ? $filter : '';
+ $sqlfilter = empty($filter) ? '' : ($filter == 'solved' ? 'AND
r.answererid>0' : 'AND r.answererid=0');
+
+ $page = max(1, intval($page));
+ $start_limit = ($page - 1) * $tpp;
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}rewardlog r
WHERE authorid='$discuz_uid' $sqlfilter");
+ $multipage = multi($db->result($query, 0), $tpp, $page, "my.php?item=reward&type=question&filter=$filter$extrafid");
+
+ $query = $db->query("SELECT r.*, t.subject, t.price, m.uid,
m.username, f.fid, f.name
+ FROM {$tablepre}rewardlog r
+ LEFT JOIN {$tablepre}threads t ON t.tid=r.tid
+ LEFT JOIN {$tablepre}forums f ON f.fid=t.fid
+ LEFT JOIN {$tablepre}members m ON m.uid=r.answererid
+ WHERE r.authorid='$discuz_uid' $threadadd $sqlfilter
+ ORDER BY r.dateline DESC
+ LIMIT $start_limit, $tpp");
+
+ while($rewardlog = $db->fetch_array($query)) {
+ $rewardlog['dateline'] = gmdate("$dateformat $timeformat",
$rewardlog['dateline'] + $timeoffset * 3600);
+ $rewardlog['price'] = abs($rewardlog['price']);
+ $rewardloglist[] = $rewardlog;
+ }
+
+ } else {
+ showmessage('undefined_action');
+ }
+
+} elseif($item == 'activities') {
+
+ $ended = isset($ended) && in_array($ended, array('yes', 'no')) ? $ended : '';
+ $sign = $ascadd = '';
+ $activity = array();
+
+ if($ended == 'yes') {
+ $sign = " AND starttimefrom<'$timestamp'";
+ $ascadd = 'DESC';
+ } elseif($ended == 'no') {
+ $sign = " AND starttimefrom>='$timestamp'";
+ }
+
+ if($type == 'orig') {
+
+ $extra .= $srchfid ? '&type=orig' : '';
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}activities a
LEFT JOIN {$tablepre}threads t USING(tid) WHERE a.uid='$discuz_uid' AND
t.special='4' $threadadd $sign");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=activities&type=orig&ended=$ended$extrafid");
+
+ $query = $db->query("SELECT a.*, t.subject FROM
{$tablepre}activities a LEFT JOIN {$tablepre}threads t USING(tid) WHERE
a.uid='$discuz_uid' AND t.special='4' $threadadd $sign ORDER BY
starttimefrom $ascadd LIMIT $start_limit, $tpp");
+ while($tempact = $db->fetch_array($query)) {
+ $tempact['starttimefrom'] = gmdate("$dateformat $timeformat",
$tempact['starttimefrom'] + $timeoffset * 3600);
+ $activity[] = $tempact;
+ }
+ } else {
+ $extra .= $srchfid ? '&type='.$type : '';
+
+ $query = $db->query("SELECT COUNT(*) FROM {$tablepre}activityapplies
aa LEFT JOIN {$tablepre}activities a USING(tid) LEFT JOIN
{$tablepre}threads t USING(tid) WHERE a.uid='$discuz_uid' $threadadd$sign");
+ $num = $db->result($query, 0);
+ $multipage = multi($num, $tpp, $page, "my.php?item=activities&type=apply&ended=$ended$extrafid");
+
+ $query = $db->query("SELECT aa.verified, aa.tid, starttimefrom,
a.place, a.cost, t.subject FROM {$tablepre}activityapplies aa LEFT JOIN
{$tablepre}activities a USING(tid) LEFT JOIN {$tablepre}threads t
USING(tid) WHERE aa.uid='$discuz_uid' $threadadd$sign ORDER BY
starttimefrom $ascadd LIMIT $start_limit, $tpp");
+ while($tempact = $db->fetch_array($query)) {
+ $tempact['starttimefrom'] = gmdate("$dateformat $timeformat",
$tempact['starttimefrom'] + $timeoffset * 3600);
+ $activity[] = $tempact;
+ }
+ }
+
+} elseif($item == 'promotion' && ($creditspolicy['promotion_visit'] ||
$creditspolicy['promotion_register'])) {
+
+ $promotion_visit = $promotion_register = $val = $space = '';
+ foreach(array('promotion_visit', 'promotion_register') as $val) {
+ if(!empty($creditspolicy[$val]) && is_array($creditspolicy[$val])) {
+ foreach($creditspolicy[$val] as $id => $policy) {
+ $$val .= $space.$extcredits[$id]['title'].' +'.$policy;
+ $space = ' ';
+ }
+ }
+ }
+
+} else {
+
+ showmessage('undefined_action', NULL, 'HALTED');
+
+}
+
+include template('my');
+
+?>
\ No newline at end of file