383
个编辑
更改
创建页面，内容为“ $row = DB::fetch_first("SELECT remote,thumb,attachment,width FROM $table WHERE aid='$aid' AND isimage IN(-1, 1) LIMIT 1"); if ($row['attachment...”
$row = DB::fetch_first("SELECT remote,thumb,attachment,width FROM $table WHERE aid='$aid' AND isimage IN(-1, 1) LIMIT 1");
if ($row['attachment']) {
$ranklist[$index]['pic'][] = x_get_picurl($row['thumb'] ? getimgthumbname($row['attachment']) : $row['attachment'], $row['remote']);
}
}
$ranklist[$index]['avatar'] = $ranklist[$index]['pic'][0];
}
}
foreach ($ranklist as $str => $item) {
$ranklist[$str]['index'] = $str+$start_limit+1;
$ranklist[$str]['total'] = ceil($item['total']/100);
$ranklist[$str]['member'] = getuserbyuid($item['uid']);
$uids[] = $item['uid'];
}
if($uids){
$genders = DB::fetch_all('SELECT uid,gender FROM %t WHERE uid IN (%n)', array('common_member_profile', $uids), 'uid');
$users = DB::fetch_all('SELECT username,uid FROM %t WHERE uid IN (%n)', array('common_member', $uids), 'uid');
}
foreach ($ranklist as $k => $v) {
!$ranklist[$k]['username'] && $ranklist[$k]['gender'] = $genders[$v['uid']]['gender'];
!$ranklist[$k]['username'] && $ranklist[$k]['username'] = $users[$v['uid']]['username'];
!$ranklist[$k]['avatar'] && $ranklist[$k]['avatar'] = avatar($v['uid'], 'middle', TRUE);
$ranklist[$k]['str'] = "$act<b>{$v['total']}</b> ¥";
}
$html = '';
include_once template('xigua_re:rank_item');
echo $html;
exit;
}
include_once template('xigua_re:rank');[
if ($row['attachment']) {
$ranklist[$index]['pic'][] = x_get_picurl($row['thumb'] ? getimgthumbname($row['attachment']) : $row['attachment'], $row['remote']);
}
}
$ranklist[$index]['avatar'] = $ranklist[$index]['pic'][0];
}
}
foreach ($ranklist as $str => $item) {
$ranklist[$str]['index'] = $str+$start_limit+1;
$ranklist[$str]['total'] = ceil($item['total']/100);
$ranklist[$str]['member'] = getuserbyuid($item['uid']);
$uids[] = $item['uid'];
}
if($uids){
$genders = DB::fetch_all('SELECT uid,gender FROM %t WHERE uid IN (%n)', array('common_member_profile', $uids), 'uid');
$users = DB::fetch_all('SELECT username,uid FROM %t WHERE uid IN (%n)', array('common_member', $uids), 'uid');
}
foreach ($ranklist as $k => $v) {
!$ranklist[$k]['username'] && $ranklist[$k]['gender'] = $genders[$v['uid']]['gender'];
!$ranklist[$k]['username'] && $ranklist[$k]['username'] = $users[$v['uid']]['username'];
!$ranklist[$k]['avatar'] && $ranklist[$k]['avatar'] = avatar($v['uid'], 'middle', TRUE);
$ranklist[$k]['str'] = "$act<b>{$v['total']}</b> ¥";
}
$html = '';
include_once template('xigua_re:rank_item');
echo $html;
exit;
}
include_once template('xigua_re:rank');[
