continue;
}
$didresult .= "OR IB_UID='" . $did_exp[$i] . "' ";
}
return $didresult;
}
if ($action == 'delete_mail') {
db_query("DELETE FROM kimsmall7_inbox WHERE IB_UID <> '' " . getNewSql($del_id), $DB_CONNECT);
getLink($THIS_FILE . "?query=list&ib_type=" . $ib_type, $alert, $history);
}
if ($action == 'temp_mail') {
db_query("UPDATE kimsmall7_inbox SET IB_TYPE='4' WHERE IB_UID <> '' " . getNewSql($del_id), $DB_CONNECT);
getLink($THIS_FILE . "?query=list&ib_type=4", $alert, $history);
}
if ($action == 'move_mail') {
db_query("UPDATE kimsmall7_inbox SET IB_TYPE='" . $ib_type . "' WHERE IB_UID <> '' " . getNewSql($del_id), $DB_CONNECT);
getLink($THIS_FILE . "?query=list&ib_type=" . $ib_type, $alert, $history);
}
if ($action == 'send_mail') {
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<title>메일발송중..</title>
<style>
body,table,td,input,select,textarea
{
font-family : 굴림;
font-size : 9pt;
line-height : 140%;
}
$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);
}
} else {
$WHEREIS = urldecode(stripslashes($sql));
}
$MBR_QUE = "SELECT * FROM kimsmall7_members " . $WHEREIS . " ORDER BY " . $sort . " " . $orderby . " LIMIT " . ($p - 1) * $recnum . ", " . $recnum;
$MBR_DATA = db_query($MBR_QUE, $DB_CONNECT);
$DATA_NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members " . $WHEREIS, $DB_CONNECT));
$TOT_PAGE = intval(($DATA_NUM[0] - 1) / $recnum) + 1;
include './inc/header.php';
?>
<script language=javascript>
function select_que(n)
{
var i;
{
$did_exp = explode(',', $did);
for ($i = 0; $i < sizeof($did_exp); $i++) {
if (!trim($did_exp[$i])) {
continue;
}
$didresult .= "AND MB_ID<>'" . $did_exp[$i] . "' ";
}
return $didresult;
}
$p = $p ? $p : 1;
$recnum = $recnum ? $recnum : 20;
$sort = $sort ? $sort : 'MB_UID';
$orderby = $orderby ? $orderby : 'DESC';
$WHEREIS = urldecode(stripslashes($sql));
$WHEREIS .= $del_id ? getNewSql($del_id) : '';
$MBR_QUE = "SELECT * FROM kimsmall7_members " . $WHEREIS . " ORDER BY " . $sort . " " . $orderby . " LIMIT " . ($p - 1) * $recnum . ", " . $recnum;
$MBR_DATA = db_query($MBR_QUE, $DB_CONNECT);
$DATA_NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_members " . $WHEREIS, $DB_CONNECT));
$TOT_PAGE = intval(($DATA_NUM[0] - 1) / $recnum) + 1;
?>
<html>
<head>
<title>회원리스트</title>
<META HTTP-EQUIV="MSThemeCompatible" Content="No">
<meta http-equiv="content-type" content="text/html; charset=euc-kr">
<script language=javascript src='./member.js'></script>
<link rel='stylesheet' type='text/css' href='./member.css'>
</head>
