쪽지가 이상해요!~ 정보
쪽지가 이상해요!~
본문
쪽지를 사용하고 있는데 보낸 쪽지와 받은 쪽지 내용이 똑같습니다.
skin/member 스킨을 지우고 다른 것으로 교체를 해도 똑같은 현상이 일어납니다.
뭐가 잘 못 된 것일까요?
bbs/memo.php 가 잘 못 된 듯 한데....
소스를 봐도 잘 모르겠습니다. ㅠㅠ
<?
include_once("./_common.php");
include_once("./memo_confc.php");
if (!$member[mb_id])
alert_close("회원만 이용하실 수 있습니다.");
if ($g4memo_admin_update =="admin_ok") {
if ($is_admin != "super") {
alert_clos("최고관리자만 접근 가능합니다.");
}
$g4memoup ="ALTER TABLE $g4[memo_table] ADD memo_datec TINYINT(4) DEFAULT '0' NOT NULL";
$g4memoup .=", ADD memopoint TINYINT(4) DEFAULT '0' NOT NULL";
$g4memoup .=", ADD bmemos VARCHAR(255) NOT NULL";
$g4memoup .=", ADD memofile VARCHAR(255) NOT NULL";
$g4memoup .=", ADD memosub VARCHAR(255) NOT NULL";
$resultup = @mysql_query($g4memoup) or mysql_error();
$memo_fd ="CREATE TABLE g4_memo_friend (
no int(11) NOT NULL auto_increment,
my_id varchar(255) NOT NULL default '',
mf_id varchar(255) NOT NULL default '',
mf_name varchar(255) NOT NULL default '',
PRIMARY KEY (no)
) TYPE=MyISAM;";
$resultd = @mysql_query($memo_fd) or mysql_error();
alert("요청하신 SQL 설치및 업데이트 작업을 모두완료 하였습니다.", "./memo.php?mkind=recv");
exit;
}
if ($g4memo_admin_update =="mode_admin") {
if ($is_admin != "super") {
alert_clos("최고관리자만 접근 가능합니다.");
}
$g4memoupmod ="ALTER TABLE `$g4[memo_table]` CHANGE `bmemos` `bmemos` VARCHAR(255) NOT NULL";
$resultupod = @mysql_query($g4memoupmod) or mysql_error();
alert("요청하신 SQL 필드의 형식 변경을 완료 하였습니다.", "./memo.php?mkind=recv");
exit;
}
$g4[title] = "내 쪽지함";
include_once("$g4[path]/head.sub.php");
// 설정일이 지난 일반 메모에서 첨부파일이 있으면 파일삭제
$sql3 = " select * from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '0'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $config[cf_memo_del]))."' ";
$resultm = sql_query($sql3);
while ($rowm = sql_fetch_array($resultm))
{
if ($rowm[memofile])
{
@unlink("$g4[path]/data/file/memo_data/$rowm[memofile]");
}
// 설정일이 지난 메모 삭제
/*
// for ($im=0; $rowm=sql_fetch_array($resultm); $i++)
$sql5 = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memodate = '0'
and me_id ='$rowm[me_id]' ";
sql_query($sql5);
*/
}
// 설정일이 지난 메모 이면서 저장한 메모가 아닌것은 내꺼만 전부삭제
$sqld = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '0'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $config[cf_memo_del]))."' ";
sql_query($sqld);
// 저장된 메모에서 설정된 기간이후 첨부파일이 있다면 파일삭제후 필드비우기
$sql4 = " select * from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '1'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $memo_membodc_25))."' ";
$results = sql_query($sql4);
while ($rows = sql_fetch_array($results))
{
if ($rows[memofile])
{
@unlink("$g4[path]/data/file/memo_data/$rows[memofile]");
}
$sqlc = " update $g4[memo_table]
set memofile = ''
where me_id = '$rows[me_id]' ";
sql_query($sqlc);
}
// 설정일이 지난 메모 이면서 저장한 메모이고 내꺼만 전부삭제
$sqld = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '1'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $memo_membodc_26))."' ";
sql_query($sqld);
if (!$mkind) {
$mkind = "recv";
}
if ($mkind == "recv") {
$kindm_bs = "and memo_datec = '0' ";
$kindm_bsm = "memo_datec = '0' and ";
$kind = "recv";
$unkind = "send";
}
else if($mkind == "send")
{
$kindm_bs = "and memo_datec = '0' ";
$kindm_bsm = "memo_datec = '0' and ";
$kind = "send";
$unkind = "recv";
}
else if($mkind == "sendad")
{
$kindm_bs = "and memo_datec = '1' ";
$kindm_bsm = "memo_datec = '1' and ";
$kind = "recv";
$unkind = "send";
}
else
{
alert("\$mkind 값을 넘겨주세요.");
}
$sql2 = " select count(*) as cnt from $g4[memo_table] where {$kindm_bsm}me_{$kind}_mb_id = '$member[mb_id]' ";
$row2 = sql_fetch($sql2);
$total_count = number_format($row2[cnt]);
$rows = $config[cf_write_pages];
$total_page = ceil($total_count / $rows);
if (!$page) { $page = 1; }
$from_record = ($page - 1) * $rows;
if ($mkind == "recv")
{
$kind_title = "받은";
$recv_img = "on";
$send_img = "off";
$send_imgc = "off";
}
else if ($mkind == "send")
{
$kind_title = "보낸";
$recv_img = "off";
$send_img = "on";
$send_imgc = "off";
}
else if ($mkind == "sendad")
{
$kind_title = "저장된";
$recv_img = "off";
$send_img = "off";
$send_imgc = "on";
}
$list = array();
$member_skin_path = "$g4[path]/skin/member/$config[cf_member_skin]";
$sql = " select a.*, b.mb_id, b.mb_nick, b.mb_email, b.mb_homepage
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_{$unkind}_mb_id = b.mb_id)
where a.me_{$kind}_mb_id = '$member[mb_id]'
{$kindm_bs}order by a.me_id desc limit $from_record, $rows";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list[$i] = $row;
$mb_id = $row["me_{$unkind}_mb_id"];
if ($row[mb_nick])
$mb_nick = $row[mb_nick];
else
$mb_nick = "<font color=silver>정보없음</font>";
$name = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
$msub = $row[memosub];
if ($msub)
{
$memosub = cut_str($msub, $memo_membodc_24);
}
else
{
$memosub = cut_str($row[me_memo], $memo_membodc_24);
}
if (substr($row[me_read_datetime],0,1) == '0')
{
$read_datetime = "아직 읽지 않음";
$read_datetime2 = "<img src='$member_skin_path/img/gmemo_clos.gif' width='16' height='14' border='0'>";
}
else
{
$read_datetime = substr($row[me_read_datetime],2,14);
$read_datetime2 = "<img src='$member_skin_path/img/gmemo_open.gif' width='16' height='19' border='0'>";
}
$send_datetime = substr($row[me_send_datetime],2,14);
$send_datetime2 = "<img src='$member_skin_path/img/gmemo_open2.gif' width='19' height='20' border='0'>";
if ($list[$i][memo_datec]==1){
$list[$i][memo_date] ="<img src='$member_skin_path/img/gmemo_add.gif' width='14' height='15' border='0' title='저장한메모'>";
}
else
{
$list[$i][memo_date] ="";
}
if ($list[$i][memofile]){
$list[$i][memo_file] ="<img src='$member_skin_path/img/gmemo_file.gif' width='14' height='14' border='0' title='파일첨부'>";
}
else
{
$list[$i][memo_file] ="";
}
if ($list[$i][memopoint]){
$list[$i][memo_point] ="<img src='$member_skin_path/img/gmemo_point.gif' width='13' height='16' border='0' title='포인트선물'>";
}
else
{
$list[$i][memo_point] ="";
}
if (!$list[$i][memo_datec] and !$list[$i][memofile] and !$list[$i][memopoint]) {
$list[$i][memo_memo] ="<img src='$member_skin_path/img/gmemo_memo.gif' width='10' height='16' border='0' title='일반메모'>";
}
else
{
$list[$i][memo_memo] ="";
}
$list[$i][name] = $name;
$list[$i][memo_sub] = $memosub;
$list[$i][send_datetime] = $send_datetime;
$list[$i][read_datetime] = $read_datetime;
$list[$i][send_datetime2] = $send_datetime2;
$list[$i][read_datetime2] = $read_datetime2;
$list[$i][view_href] = "./memo_view.php?me_id=$row[me_id]&mkind=$mkind&page=$page";
$list[$i][del_href] = "./memo_delete.php?me_id=$row[me_id]&mkind=$mkind&page=$page";
}
$page = get_paging($config[cf_write_pages], $page, $total_page, "?mkind=$mkind&page=");
echo "<script language='javascript' src='$g4[path]/js/sideview.js'></script>";
//$nextm_link ="<br> 요건 그냥 찍어보는 것이므로 무시할것: $member[mb_name] 님이 현재까지 업로드한 총파일갯수: $total_countsm 개";
$mb = get_member($memo["me_{$unkind}_mb_id"]);
//echo " $nextm_link";
include_once("$member_skin_path/memo.skin.php");
include_once("$g4[path]/tail.sub.php");
?>
skin/member 스킨을 지우고 다른 것으로 교체를 해도 똑같은 현상이 일어납니다.
뭐가 잘 못 된 것일까요?
bbs/memo.php 가 잘 못 된 듯 한데....
소스를 봐도 잘 모르겠습니다. ㅠㅠ
<?
include_once("./_common.php");
include_once("./memo_confc.php");
if (!$member[mb_id])
alert_close("회원만 이용하실 수 있습니다.");
if ($g4memo_admin_update =="admin_ok") {
if ($is_admin != "super") {
alert_clos("최고관리자만 접근 가능합니다.");
}
$g4memoup ="ALTER TABLE $g4[memo_table] ADD memo_datec TINYINT(4) DEFAULT '0' NOT NULL";
$g4memoup .=", ADD memopoint TINYINT(4) DEFAULT '0' NOT NULL";
$g4memoup .=", ADD bmemos VARCHAR(255) NOT NULL";
$g4memoup .=", ADD memofile VARCHAR(255) NOT NULL";
$g4memoup .=", ADD memosub VARCHAR(255) NOT NULL";
$resultup = @mysql_query($g4memoup) or mysql_error();
$memo_fd ="CREATE TABLE g4_memo_friend (
no int(11) NOT NULL auto_increment,
my_id varchar(255) NOT NULL default '',
mf_id varchar(255) NOT NULL default '',
mf_name varchar(255) NOT NULL default '',
PRIMARY KEY (no)
) TYPE=MyISAM;";
$resultd = @mysql_query($memo_fd) or mysql_error();
alert("요청하신 SQL 설치및 업데이트 작업을 모두완료 하였습니다.", "./memo.php?mkind=recv");
exit;
}
if ($g4memo_admin_update =="mode_admin") {
if ($is_admin != "super") {
alert_clos("최고관리자만 접근 가능합니다.");
}
$g4memoupmod ="ALTER TABLE `$g4[memo_table]` CHANGE `bmemos` `bmemos` VARCHAR(255) NOT NULL";
$resultupod = @mysql_query($g4memoupmod) or mysql_error();
alert("요청하신 SQL 필드의 형식 변경을 완료 하였습니다.", "./memo.php?mkind=recv");
exit;
}
$g4[title] = "내 쪽지함";
include_once("$g4[path]/head.sub.php");
// 설정일이 지난 일반 메모에서 첨부파일이 있으면 파일삭제
$sql3 = " select * from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '0'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $config[cf_memo_del]))."' ";
$resultm = sql_query($sql3);
while ($rowm = sql_fetch_array($resultm))
{
if ($rowm[memofile])
{
@unlink("$g4[path]/data/file/memo_data/$rowm[memofile]");
}
// 설정일이 지난 메모 삭제
/*
// for ($im=0; $rowm=sql_fetch_array($resultm); $i++)
$sql5 = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memodate = '0'
and me_id ='$rowm[me_id]' ";
sql_query($sql5);
*/
}
// 설정일이 지난 메모 이면서 저장한 메모가 아닌것은 내꺼만 전부삭제
$sqld = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '0'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $config[cf_memo_del]))."' ";
sql_query($sqld);
// 저장된 메모에서 설정된 기간이후 첨부파일이 있다면 파일삭제후 필드비우기
$sql4 = " select * from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '1'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $memo_membodc_25))."' ";
$results = sql_query($sql4);
while ($rows = sql_fetch_array($results))
{
if ($rows[memofile])
{
@unlink("$g4[path]/data/file/memo_data/$rows[memofile]");
}
$sqlc = " update $g4[memo_table]
set memofile = ''
where me_id = '$rows[me_id]' ";
sql_query($sqlc);
}
// 설정일이 지난 메모 이면서 저장한 메모이고 내꺼만 전부삭제
$sqld = " delete from $g4[memo_table]
where me_recv_mb_id = '$member[mb_id]'
and memo_datec = '1'
and me_send_datetime < '".date("Y-m-d H:i:s", $g4[server_time] - (86400 * $memo_membodc_26))."' ";
sql_query($sqld);
if (!$mkind) {
$mkind = "recv";
}
if ($mkind == "recv") {
$kindm_bs = "and memo_datec = '0' ";
$kindm_bsm = "memo_datec = '0' and ";
$kind = "recv";
$unkind = "send";
}
else if($mkind == "send")
{
$kindm_bs = "and memo_datec = '0' ";
$kindm_bsm = "memo_datec = '0' and ";
$kind = "send";
$unkind = "recv";
}
else if($mkind == "sendad")
{
$kindm_bs = "and memo_datec = '1' ";
$kindm_bsm = "memo_datec = '1' and ";
$kind = "recv";
$unkind = "send";
}
else
{
alert("\$mkind 값을 넘겨주세요.");
}
$sql2 = " select count(*) as cnt from $g4[memo_table] where {$kindm_bsm}me_{$kind}_mb_id = '$member[mb_id]' ";
$row2 = sql_fetch($sql2);
$total_count = number_format($row2[cnt]);
$rows = $config[cf_write_pages];
$total_page = ceil($total_count / $rows);
if (!$page) { $page = 1; }
$from_record = ($page - 1) * $rows;
if ($mkind == "recv")
{
$kind_title = "받은";
$recv_img = "on";
$send_img = "off";
$send_imgc = "off";
}
else if ($mkind == "send")
{
$kind_title = "보낸";
$recv_img = "off";
$send_img = "on";
$send_imgc = "off";
}
else if ($mkind == "sendad")
{
$kind_title = "저장된";
$recv_img = "off";
$send_img = "off";
$send_imgc = "on";
}
$list = array();
$member_skin_path = "$g4[path]/skin/member/$config[cf_member_skin]";
$sql = " select a.*, b.mb_id, b.mb_nick, b.mb_email, b.mb_homepage
from $g4[memo_table] a
left join $g4[member_table] b on (a.me_{$unkind}_mb_id = b.mb_id)
where a.me_{$kind}_mb_id = '$member[mb_id]'
{$kindm_bs}order by a.me_id desc limit $from_record, $rows";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$list[$i] = $row;
$mb_id = $row["me_{$unkind}_mb_id"];
if ($row[mb_nick])
$mb_nick = $row[mb_nick];
else
$mb_nick = "<font color=silver>정보없음</font>";
$name = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
$msub = $row[memosub];
if ($msub)
{
$memosub = cut_str($msub, $memo_membodc_24);
}
else
{
$memosub = cut_str($row[me_memo], $memo_membodc_24);
}
if (substr($row[me_read_datetime],0,1) == '0')
{
$read_datetime = "아직 읽지 않음";
$read_datetime2 = "<img src='$member_skin_path/img/gmemo_clos.gif' width='16' height='14' border='0'>";
}
else
{
$read_datetime = substr($row[me_read_datetime],2,14);
$read_datetime2 = "<img src='$member_skin_path/img/gmemo_open.gif' width='16' height='19' border='0'>";
}
$send_datetime = substr($row[me_send_datetime],2,14);
$send_datetime2 = "<img src='$member_skin_path/img/gmemo_open2.gif' width='19' height='20' border='0'>";
if ($list[$i][memo_datec]==1){
$list[$i][memo_date] ="<img src='$member_skin_path/img/gmemo_add.gif' width='14' height='15' border='0' title='저장한메모'>";
}
else
{
$list[$i][memo_date] ="";
}
if ($list[$i][memofile]){
$list[$i][memo_file] ="<img src='$member_skin_path/img/gmemo_file.gif' width='14' height='14' border='0' title='파일첨부'>";
}
else
{
$list[$i][memo_file] ="";
}
if ($list[$i][memopoint]){
$list[$i][memo_point] ="<img src='$member_skin_path/img/gmemo_point.gif' width='13' height='16' border='0' title='포인트선물'>";
}
else
{
$list[$i][memo_point] ="";
}
if (!$list[$i][memo_datec] and !$list[$i][memofile] and !$list[$i][memopoint]) {
$list[$i][memo_memo] ="<img src='$member_skin_path/img/gmemo_memo.gif' width='10' height='16' border='0' title='일반메모'>";
}
else
{
$list[$i][memo_memo] ="";
}
$list[$i][name] = $name;
$list[$i][memo_sub] = $memosub;
$list[$i][send_datetime] = $send_datetime;
$list[$i][read_datetime] = $read_datetime;
$list[$i][send_datetime2] = $send_datetime2;
$list[$i][read_datetime2] = $read_datetime2;
$list[$i][view_href] = "./memo_view.php?me_id=$row[me_id]&mkind=$mkind&page=$page";
$list[$i][del_href] = "./memo_delete.php?me_id=$row[me_id]&mkind=$mkind&page=$page";
}
$page = get_paging($config[cf_write_pages], $page, $total_page, "?mkind=$mkind&page=");
echo "<script language='javascript' src='$g4[path]/js/sideview.js'></script>";
//$nextm_link ="<br> 요건 그냥 찍어보는 것이므로 무시할것: $member[mb_name] 님이 현재까지 업로드한 총파일갯수: $total_countsm 개";
$mb = get_member($memo["me_{$unkind}_mb_id"]);
//echo " $nextm_link";
include_once("$member_skin_path/memo.skin.php");
include_once("$g4[path]/tail.sub.php");
?>
댓글 전체