등급별 쪽지 보내기.. db업데이트 안되는데요? 함수가 틀린건지?
본문
1) /admin.menu200.php
아래 코드 추가
<?php
$menu['menu200'] = array (
array('200000', '회원관리', G5_ADMIN_URL.'/member_list.php', 'member'),
array('200100', '회원관리', G5_ADMIN_URL.'/member_list.php', 'mb_list'),
array('200300', '회원메일발송', G5_ADMIN_URL.'/mail_list.php', 'mb_mail'),
array('200400', '회원쪽지발송', G5_ADMIN_URL.'/memo_list.php'),
array('200800', '접속자집계', G5_ADMIN_URL.'/visit_list.php', 'mb_visit', 1),
array('200810', '접속자검색', G5_ADMIN_URL.'/visit_search.php', 'mb_search', 1),
array('200820', '접속자로그삭제', G5_ADMIN_URL.'/visit_delete.php', 'mb_delete', 1),
array('200200', '포인트관리', G5_ADMIN_URL.'/point_list.php', 'mb_point'),
array('200900', '투표관리', G5_ADMIN_URL.'/poll_list.php', 'mb_poll')
);
?>
2) memo_list.php
등급별 설정
<?
$sub_menu = "200400";
include_once("./_common.php");
$g5[title] = "회원쪽지발송";
include_once("./admin.head.php");
?>
<script>
function check(f){
f.action="memo_update.php";
f.submit();
}
</script>
<form name="memo" method="post">
<table>
<Tr><Td width=100 bgcolor="#f2f2f2"> · 받는사람 권한</td><td><input type="checkbox" name="level" value=1> 모두발송 <input type="checkbox" name="level2" value=2> 2 <input type="checkbox" name="level3" value=1> 3 <input type="checkbox" name="level4" value=1> 4 <input type="checkbox" name="level5" value=1> 5 <input type="checkbox" name="level6" value=1> 6 <input type="checkbox" name="level7" value=1> 7 <input type="checkbox" name="level8" value=1> 8 <input type="checkbox" name="level9" value=1> 9 <input type="checkbox" name="level10" value=1> 10</td></tr>
<Tr><Td width=100 bgcolor="#f2f2f2"> · 내용 </td><td><textarea name="content" rows=15 cols=80>
</textarea></td></tr>
<Tr><Td colspan=2><input type="button" value="보내기" onclick="check(document.memo)"><input type="reset" value="취소"></td></tr>
</table>
</form>
<?
include_once ("./admin.tail.php");
?>
3) memo_update.php
쪽지를 등급회원 추출 후, 개별 db insert ==> 현재 db 쪽지 내용이 insert 안되는 거 같습니다.
mysql_fetch_row --> sql_fetch_row 하여도 안되네요
<?
$whendate="150"; //¸îÀÏÀü±îÁö Á¢¼ÓÇÑ È¸¿ø¿¡°Ô ÂÊÁö¸¦ º¸³¾±î¿ä?
$sub_menu = "200400";
include_once("./_common.php");
$g5[title] = "회원쪽지발송";
include_once("./admin.head.php");
$memocon=mysql_escape_string($_POST['content']);
$level=array();
$level[1]=$_POST['level'];
$level[2]=$_POST['level2'];
$level[3]=$_POST['level3'];
$level[4]=$_POST['level4'];
$level[5]=$_POST['level5'];
$level[6]=$_POST['level6'];
$level[7]=$_POST['level7'];
$level[8]=$_POST['level8'];
$level[9]=$_POST['level9'];
$level[10]=$_POST['level10'];
if($level[1]){
$sql_who="AND mb_level in ('2','3','4','5','6','7','8','9','10')";
}else{
$first=1;
$sql_who="AND mb_level in (";
for($i=2;$i<11;$i++){
if($level[$i]){
if(!$first) $sql_who.=",";
else $first=0;
$sql_who.="'".$i."'";
}
}
$sql_who.=")";
}
$sql="SELECT mb_id FROM g5_member WHERE 1 $sql_who AND date_format(mb_today_login,'%Y%m')>=".date("Ym",(time()-86400*$whendate))."";
$result=sql_query($sql);
for($i=0;$row=mysql_fetch_row($result);$i++){
echo $row[0]."<br>";
sql_query("INSERT INTO g5_memo (me_recv_mb_id,me_send_mb_id,me_send_datetime,me_memo) values('".$row[0]."','$member[mb_id]',now(),'$memocon')");
}
?>
전송 성공
<?
include_once ("./admin.tail.php");
?>
