www.gusucode.com > Destoon B2B仿淘宝电子商务网站 UTF8 v6.0源码程序 > destoon/api/ajax/select.inc.php
<?php defined('IN_DESTOON') or exit('Access Denied'); login(); if($job == 'item') { $mid > 3 or dheader('DT_PATH'); $from = isset($from) ? trim($from) : 'item'; isset($username) or $username = ''; $condition = $mid == 4 ? 'groupid>5' : 'status=3'; if($keyword) $condition .= " AND keyword LIKE '%$keyword%'"; if($from == 'relate' && $mid == 16) { check_name($username) or exit; $condition .= " AND username='$username'"; } else { if($_groupid == 1) { if($from == 'member') $condition .= " AND username='$_username'"; } else { $condition .= " AND username='$_username'"; } } if($itemid) $condition .= $mid == 4 ? " AND userid=$itemid" : " AND itemid=$itemid"; $order = $mid == 4 ? 'userid DESC' : 'addtime DESC'; $table = get_table($mid); $r = $db->get_one("SELECT COUNT(*) AS num FROM {$table} WHERE $condition"); $items = $r['num']; $pages = pages($items, $page, $pagesize); $lists = array(); $result = $db->query("SELECT * FROM {$table} WHERE $condition ORDER BY $order LIMIT $offset,$pagesize"); while($r = $db->fetch_array($result)) { if($mid == 4) { $r['itemid'] = $r['userid']; $r['alt'] = $r['title'] = $r['company']; $r['adddate'] = $r['editdate'] = timetodate(0, 5); $r['level'] = 0; $r['style'] = ''; } else { $r['adddate'] = timetodate($r['addtime'], 5); $r['editdate'] = timetodate($r['edittime'], 5); $r['alt'] = $r['title']; $r['title'] = set_style($r['title'], $r['style']); if(strpos($r['linkurl'], '://') === false) $r['linkurl'] = $MODULE[$mid]['linkurl'].$r['linkurl']; } $lists[] = $r; } $head_title = '选择信息'; } else { isset($from) or $from = ''; if($DT['uploadlog']) { $table = $DT_PRE.'upload_'.($_userid%10); $condition = "username='$_username' AND width>90"; $condition .= $from == 'album' ? " AND (upfrom='album' OR upfrom='photo')" : " AND upfrom<>'thumb'"; $r = $db->get_one("SELECT COUNT(*) AS num FROM {$table} WHERE {$condition}"); $items = $r['num']; $pages = pages($items, $page, $pagesize); $lists = array(); $result = $db->query("SELECT * FROM {$table} WHERE {$condition} ORDER BY pid DESC LIMIT $offset,$pagesize"); while($r = $db->fetch_array($result)) { $r['introduce'] = timetodate($r['addtime'], 6).' '.$r['width'].'px * '.$r['height'].'px '; $r['ext'] = file_ext($r['fileurl']); $r['thumb'] = $r['fileurl']; $r['middle'] = str_replace('.thumb.'.$r['ext'], '.middle.'.$r['ext'], $r['thumb']); $r['large'] = str_replace('.thumb.'.$r['ext'], '', $r['thumb']); $lists[] = $r; } } else { foreach($MODULE as $M) { if($M['module'] == 'photo') { $mid = $M['moduleid']; break; } } $mid or message('系统未开启图库功能'); $from = isset($from) ? trim($from) : ''; $fid = isset($fid) ? trim($fid) : ''; if($itemid) { $item = $db->get_one("SELECT username,title FROM {$DT_PRE}photo_{$mid} WHERE itemid=$itemid"); if(!$item || ($item['username'] != $_username && $_groupid > 1)) dheader(DT_PATH); $r = $db->get_one("SELECT COUNT(*) AS num FROM {$DT_PRE}photo_item_{$mid} WHERE item=$itemid"); $items = $r['num']; $pages = pages($items, $page, $pagesize); $lists = array(); $result = $db->query("SELECT * FROM {$DT_PRE}photo_item_{$mid} WHERE item=$itemid ORDER BY listorder ASC,itemid ASC LIMIT $offset,$pagesize"); while($r = $db->fetch_array($result)) { $r['ext'] = file_ext($r['thumb']); $r['middle'] = str_replace('.thumb.'.$r['ext'], '.middle.'.$r['ext'], $r['thumb']); $r['large'] = str_replace('.thumb.'.$r['ext'], '', $r['thumb']); $lists[] = $r; } } else { $condition = "status=3 AND items>0 AND username='$_username'"; if($keyword) $condition .= " AND keyword LIKE '%$keyword%'"; $r = $db->get_one("SELECT COUNT(*) AS num FROM {$DT_PRE}photo_{$mid} WHERE $condition"); $items = $r['num']; $pages = pages($items, $page, $pagesize); $lists = array(); $result = $db->query("SELECT * FROM {$DT_PRE}photo_{$mid} WHERE $condition ORDER BY addtime LIMIT $offset,$pagesize"); while($r = $db->fetch_array($result)) { $lists[] = $r; } } } $head_title = '选择图片'; } include template('select', 'member'); ?>