<font color=ffffff>
<?php
echo $MB[MB_NAME];
?>
:: <?php
echo $MB[MB_NIC];
?>
(<?php
echo $id;
?>
) ;
<?php
echo $MB[MB_FLAG] == 1 ? '개인' : '기업';
?>
<?php
$MBTYPE = getMemberGroup();
echo $MBTYPE[$MB[MB_TYPE]];
?>
<?php
if ($MB[MB_PRICEDAY]) {
?>
- 유료회원 만기일 <?php
echo substr($MB[MB_PRICEDAY], 0, 4);
?>
-<?php
echo substr($MB[MB_PRICEDAY], 4, 2);
?>
-<?php
echo substr($MB[MB_PRICEDAY], 6, 2);
?>
<?php
$date = date("YmdHis");
$MBR_DATA = db_query("SELECT * FROM kimsmall7_members " . stripslashes($sql), $DB_CONNECT);
while ($MB = db_fetch_array($MBR_DATA)) {
$QUE = "INSERT INTO kimsmall7_point\n\t\t(CP_MB_ID,CP_POINT,CP_COMMENT,CP_DATE)\n\t\tVALUES\n\t\t('{$MB['MB_ID']}','{$cash}','{$comment}','{$date}')";
db_query($QUE, $DB_CONNECT);
db_query("UPDATE kimsmall7_members SET MB_POINT=MB_POINT+" . $cash . " WHERE MB_ID='" . $MB[MB_ID] . "'", $DB_CONNECT);
}
getLink($THIS_FILE . "?sql=" . $sql, "처리되었습니다.", $history);
}
$month = $year ? $month : '';
$day = $month ? $day : '';
$p = $p ? $p : 1;
$recnum = $recnum ? $recnum : 20;
$sort = $sort ? $sort : 'MB_UID';
$orderby = $orderby ? $orderby : 'DESC';
$MB_GROUP = getMemberGroup();
$WHEREIS = "WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' AND MB_FLAG='1'";
if (!$sql) {
if (!$query) {
$WHEREIS .= $mb_type != '' ? "AND MB_TYPE='" . $mb_type . "' " : '';
$WHEREIS .= $mb_sex != '' ? "AND MB_SEX='" . $mb_sex . "' " : '';
$WHEREIS .= $mb_age != '' ? "AND LEFT(MB_BIRTH,4) BETWEEN '" . getAgeToYear($mb_age, 1) . "' AND '" . getAgeToYear($mb_age, 2) . "'" : '';
$WHEREIS .= $mb_job != '' ? "AND MB_JOB='" . $mb_job . "' " : '';
$WHEREIS .= $mb_marr != '' ? "AND MB_MARR='" . $mb_marr . "' " : '';
$WHEREIS .= $mb_birth != '' ? "AND MB_BIRTH LIKE '%" . $mb_birth . "%' " : '';
$WHEREIS .= $mb_addr != '' ? "AND MB_ADDR1 LIKE '%" . $mb_addr . "%' " : '';
$WHEREIS .= $mb_log ? "AND MB_NOWLOG='1' " : '';
$WHEREIS .= $where != '' && $keyword != '' ? "AND " . $where . " LIKE '%" . $keyword . "%' " : '';
} else {
$WHEREIS = "WHERE " . getNewSql($del_id);
}
?>
</select>
전체 <b><font color=red><?php
echo number_format($TOT_NUM[0]);
?>
</font></b>명중
대상회원 <b><font color=blue><span id=selnum_lay>0</span></font></b>명
</td>
</tr>
<tr><td colspan=3 height=1 bgcolor=dfdfdf></td></tr>
<tr height=5>
<td bgcolor=efefef colspan=2></td>
<td width=90%></td>
</tr>
<?php
$arr = getMemberGroup();
$num = sizeof($arr);
$TOT = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' " . $WHEREIS, $DB_CONNECT));
for ($i = 0; $i < $num; $i++) {
$NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members WHERE MB_REGISDAY LIKE '" . $year . $month . $day . "%' AND MB_TYPE='" . ($i + 1) . "'" . $WHEREIS, $DB_CONNECT));
$per = @round($NUM[0] / $TOT[0] * 100, 1);
$width = (int) $per * 5;
?>
<tr height=20>
<td bgcolor=efefef><img src='./module/WebLog/image/blank.gif' width=5 height=1></td>
<td bgcolor=efefef><img src='./module/WebLog/image/blank.gif' width=95 height=1><br><a onclick="MonthChange('mb_type=<?php
echo $i + 1;
?>
')"><font class='Blink'><?php
echo $arr[$i];
?>
