new_member.php

自己实现一个实用的商店应用系统

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2006.05.08
// 建站支持: http://www.shuweich.org
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
// CMS交流站点: http://www.cmscn.org
////////////////////////////////////////////////////////
// 最新注册会员 by ty919
// For 注册会员(免费会员)
////////////////////////////////////////////////////////
function b_new_member() {

  global $xoopsDB;
  // 显示最新登录的$list_num名会员
  $pprefix='new_mmb_';
  $que = "select var_value from ".$xoopsDB->prefix("ty919_argu_var")." where var_name='".$pprefix."ph_num'";
  $res = $xoopsDB->query($que);
  $row = $xoopsDB->fetchrow($res);
  $list_num=$row[0];

  $que = "select if(f.u_num<=>null,concat('<img src=".XOOPS_URL."/modules/Friendsty919/showphoto.php?pprefix=".$pprefix."&membernumber=nopic',";
  $que .="a.sex,'.png&bmcode=',a.d_rnum,' />'),concat('<img src=".XOOPS_URL."/modules/Friendsty919/showphoto.php?pprefix=".$pprefix."&membernumber=',a.u_num,";
  $que .="'&bmcode=',a.d_rnum,' />')) as img,";
  $que .="a.netname,if(a.sex<=>'1','男生','女生') as xb,b.name as mz,year(now())-year(a.csrq) as nl,c.name as prov,";
  $que .="d.name as city,g.name as work,e.dname as bm ";
  $que .=" from ".$xoopsDB->prefix("ty919_userm")." as a ";
  $que .=" left join ".$xoopsDB->prefix("ty919_xxgl")." as b on a.mz=b.flbh and b.fl_id=23 ";
  $que .=" left join ".$xoopsDB->prefix("ty919_prov_cn")." as c on a.prov=c.n_id ";
  $que .=" left join ".$xoopsDB->prefix("ty919_city_cn")." as d on d.b_id=a.city and d.n_id=a.prov ";
  $que .=" left join ".$xoopsDB->prefix("ty919_departments")." as e on e.d_rnum=a.d_rnum ";
  $que .=" left join ".$xoopsDB->prefix("ty919_album")." as f on f.u_num=a.u_num and approved='3' ";
  $que .=" left join ".$xoopsDB->prefix("ty919_xxgl")." as g on a.zy=g.flbh and g.fl_id=7 ";
  $que .=" order by e_date desc ";

  $list_n=" limit 0,".$list_num;
  $res = $xoopsDB->query($que.$list_n);
  $block = array();
  while( $rows = $xoopsDB->fetchArray($res) ) $block[] = $rows;

  return $block;

}

?>