$type = intval($type);
if (!$type) {
$raterid = 'buyerid';
$ratee = 'seller';
$rateeid = 'sellerid';
} else {
$raterid = 'sellerid';
$ratee = 'buyer';
$rateeid = 'buyerid';
}
$order = $db->fetch_first("SELECT * FROM {$tablepre}tradelog WHERE orderid='{$orderid}' AND {$raterid}='{$discuz_uid}'");
if (!$order) {
showmessage('eccredit_order_notfound');
} elseif ($order['ratestatus'] == 3 || $type == 0 && $order['ratestatus'] == 1 || $type == 1 && $order['ratestatus'] == 2) {
showmessage('eccredit_rate_repeat');
} elseif (!trade_typestatus('successtrades', $order['status']) && !trade_typestatus('refundsuccess', $order['status'])) {
showmessage('eccredit_nofound');
}
$uid = $discuz_uid == $order['buyerid'] ? $order['sellerid'] : $order['buyerid'];
if (!submitcheck('ratesubmit')) {
include template('ec_rate');
} else {
$score = intval($score);
$message = cutstr(dhtmlspecialchars($message), 200);
$level = $score == 1 ? 'good' : ($score == 0 ? 'soso' : 'bad');
$pid = intval($order['pid']);
$order = daddslashes($order, 1);
$db->query("INSERT INTO {$tablepre}tradecomments (pid, orderid, type, raterid, rater, ratee, rateeid, score, message, dateline) VALUES ('{$pid}', '{$orderid}', '{$type}', '{$discuz_uid}', '{$discuz_user}', '{$order[$ratee]}', '{$order[$rateeid]}', '{$score}', '{$message}', '{$timestamp}')");
if (!$order['offline']) {
if ($db->result_first("SELECT COUNT(score) FROM {$tablepre}tradecomments WHERE raterid='{$discuz_uid}' AND type='{$type}'") < $ec_credit['maxcreditspermonth']) {
updateusercredit($uid, $type ? 'sellercredit' : 'buyercredit', $level);
$attendstatus = array();
while ($status = $db->fetch_array($query)) {
@$attendstatus[$status['status']]++;
}
$query = $db->query("SELECT status FROM {$tablepre}tradelog WHERE sellerid='{$discuz_uid}' AND status IN ('" . trade_typestatus('selltrades') . "')");
$sellerattend = $db->num_rows($query);
while ($status = $db->fetch_array($query)) {
@$attendstatus[$status['status']]++;
}
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE buyerid='{$discuz_uid}' AND status IN ('" . trade_typestatus('tradingtrades') . "')");
$goodsbuyer = $db->result($query, 0);
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}trades WHERE sellerid='{$discuz_uid}' AND closed='0'");
$goodsseller = $db->result($query, 0);
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE status IN ('" . trade_typestatus('eccredittrades') . "') AND buyerid='{$discuz_uid}' AND (ratestatus=0 OR ratestatus=2)");
$eccreditbuyer = $db->result($query, 0);
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE status IN ('" . trade_typestatus('eccredittrades') . "') AND sellerid='{$discuz_uid}' AND (ratestatus=0 OR ratestatus=1)");
$eccreditseller = $db->result($query, 0);
} elseif ($item == 'tradethreads') {
if (!empty($srchkey)) {
$sqlkey = 'AND subject like \'%' . str_replace('*', '%', addcslashes($srchkey, '%_')) . '%\'';
$extrasrchkey = '&srchkey=' . rawurlencode($srchkey);
$srchkey = dhtmlspecialchars($srchkey);
} else {
$sqlkey = $extrasrchkey = $srchkey = '';
}
$sqltid = $tid ? 'AND tid =' . $tid : '';
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}trades WHERE sellerid='{$discuz_uid}' {$sqltid} {$sqlkey}");
$num = $db->result($query, 0);
$extratid = $tid ? "&tid={$tid}" : '';
$multipage = multi($num, $tpp, $page, "my.php?item=tradethreads{$extratid}{$extrafid}{$extrasrchkey}");
$tradelist = array();
$srchkey = dhtmlspecialchars($srchkey);
} else {
$sqlkey = $extrasrchkey = $srchkey = '';
}
$tid = intval($_GET['tid']);
$pid = intval($_GET['pid']);
$sqltid = $tid ? 'tl.tid=\'' . $tid . '\' AND ' . ($pid ? 'tl.pid=\'' . $pid . '\' AND ' : '') : '';
$extra .= $srchfid ? '&filter=' . $filter : '';
$extratid = $tid ? "&tid={$tid}" . ($pid ? "&pid={$pid}" : '') : '';
$num = DB::result(DB::query("SELECT COUNT(*) FROM " . DB::table('forum_tradelog') . " tl, " . DB::table('forum_thread') . " t WHERE {$sqltid} tl.{$sqlfield}='{$_G['uid']}' {$sqlfilter} {$sqlkey} AND tl.tid=t.tid"), 0);
$multi = multi($num, $perpage, $page, $theurl);
$query = DB::query("SELECT tl.*, tr.aid, t.subject AS threadsubject\r\n\t\t\tFROM " . DB::table('forum_tradelog') . " tl, " . DB::table('forum_thread') . " t, " . DB::table('forum_trade') . " tr\r\n\t\t\tWHERE {$sqltid} tl.{$sqlfield}='{$_G['uid']}' {$sqlfilter} {$sqlkey}\r\n\t\t\tAND tl.tid=t.tid AND tr.pid=tl.pid AND tr.tid=tl.tid\r\n\t\t\tORDER BY tl.lastupdate DESC LIMIT {$start},{$perpage}");
$tradeloglist = array();
while ($tradelog = DB::fetch($query)) {
$tradelog['lastupdate'] = dgmdate($tradelog['lastupdate'], 'u', 1);
$tradelog['attend'] = trade_typestatus($item, $tradelog['status']);
$tradelog['status'] = trade_getstatus($tradelog['status']);
$tradeloglist[] = $tradelog;
}
$creditid = 0;
if ($_G['setting']['creditstransextra'][5]) {
$creditid = intval($_G['setting']['creditstransextra'][5]);
} elseif ($_G['setting']['creditstrans']) {
$creditid = intval($_G['setting']['creditstrans']);
}
$extcredits = $_G['setting']['extcredits'];
$orderactives = array($viewtype => ' class="a"');
$need_count = false;
} elseif ($_GET['view'] == 'eccredit') {
require_once libfile('function/ec_credit');
$uid = !empty($_G['gp_uid']) ? intval($_G['gp_uid']) : $_G['uid'];
$buyerattend = $db->num_rows($query);
$attendstatus = array();
while($status = $db->fetch_array($query)) {
@$attendstatus[$status['status']]++;
}
$query = $db->query("SELECT status FROM {$tablepre}tradelog WHERE sellerid='$discuz_uid' AND status IN ('".trade_typestatus('selltrades')."')");
$sellerattend = $db->num_rows($query);
while($status = $db->fetch_array($query)) {
@$attendstatus[$status['status']]++;
}
$goodsbuyer = $db->result_first("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE buyerid='$discuz_uid' AND status IN ('".trade_typestatus('tradingtrades')."')");
$goodsseller = $db->result_first("SELECT COUNT(*) FROM {$tablepre}trades WHERE sellerid='$discuz_uid' AND closed='0'");
$eccreditbuyer = $db->result_first("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE status IN ('".trade_typestatus('eccredittrades')."') AND buyerid='$discuz_uid' AND (ratestatus=0 OR ratestatus=2)");
$eccreditseller = $db->result_first("SELECT COUNT(*) FROM {$tablepre}tradelog WHERE status IN ('".trade_typestatus('eccredittrades')."') AND sellerid='$discuz_uid' AND (ratestatus=0 OR ratestatus=1)");
} elseif($item == 'tradethreads') {
if(!empty($srchkey)) {
$sqlkey = 'AND subject like \'%'.str_replace('*', '%', addcslashes($srchkey, '%_')).'%\'';
$extrasrchkey = '&srchkey='.rawurlencode($srchkey);
$srchkey = dhtmlspecialchars($srchkey);
} else {
$sqlkey = $extrasrchkey = $srchkey = '';
}
$sqltid = $tid ? 'AND tid ='.$tid : '';
$num = $db->result_first("SELECT COUNT(*) FROM {$tablepre}trades WHERE sellerid='$discuz_uid' $sqltid $sqlkey");
$extratid = $tid ? "&tid=$tid" : '';
$multipage = multi($num, $tpp, $page, "my.php?item=tradethreads$extratid$extrafid$extrasrchkey");
