{php
/* ==== 会员积分等级名（企业会员徽章显示"青铜会员"等积分组名）====
表名：数据表前缀.credit ，字段：mincredit(积分下限) / maxcredit(积分上限) / name(等级名)
如您后台的等级表名/字段名不同，请修改下方 $CREDIT_TABLE 及字段名 */
$COM_HASH_NAME = $UG['groupname'];
if(!$COM['vip'] && $COM['credit']) {
$CREDIT_TABLE = $DT_PRE.'credit';
$CREDIT_TBL_OK = $db->get_one("SHOW TABLES LIKE '".$CREDIT_TABLE."'");
if($CREDIT_TBL_OK) {
$CREDIT_COLS = array();
$CREDIT_RS = $db->query("SHOW COLUMNS FROM `".$CREDIT_TABLE."`");
while($CREDIT_R = $db->fetch_array($CREDIT_RS)) $CREDIT_COLS[strtolower($CREDIT_R['Field'])] = 1;
if(isset($CREDIT_COLS['mincredit']) && isset($CREDIT_COLS['maxcredit']) && isset($CREDIT_COLS['name'])) {
$CREDIT_ROW = $db->get_one("SELECT `name` FROM `".$CREDIT_TABLE."` WHERE `mincredit`<='".$COM['credit']."' AND `maxcredit`>='".$COM['credit']."' ORDER BY `mincredit` ASC LIMIT 1");
if($CREDIT_ROW && $CREDIT_ROW['name']) $COM_HASH_NAME = $CREDIT_ROW['name'];
}
}
}
}
分析检测项目
|
