다운로드 확인방법 정보
다운로드 확인방법본문
관리자 페이지에 보면 다운로드 리스트 나오는데
일반회원 자신이 다운받은 자료 확인할수 있게 할려면 어떻게 하면 되나요
<?
$sub_menu = "300401";
include_once("./_common.php");
auth_check($auth[$sub_menu], "r");
$listall = "<a href='$_SERVER[PHP_SELF]'>처음</a>";
$g4[title] = "다운로드 목록";
include_once("$g4[admin_path]/admin.head.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
$sql_common = " from $g4[member_download_table] ";
$sql_search = " where (1) ";
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "mb_name" :
$sql_search .= " ($sfl like '%$stx') ";
break;
}
$sql_search .= " ) ";
}
if (!$sst) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$date_row = sql_fetch($sql);
$total_count = $date_row[cnt];
$colspan = 9;
$rows = "15"; // 한페이지당 몇개 출력할것인지 숫자로 기입
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<div style="clear:both; height:5px;">
<div style="float:left;"><span style='font:normal 12px tahoma; color:#BABABA;'>Total : <?=$total_count?> EA</span></div>
<div style="float:right;"><a href="javascript:window.print();">프린트하기</a></div>
</div>
<div style="border:1px solid #ddd; height:34px; color:#505050; background-Color:#FBF8EE;">
<table width=100% border=0 cellpadding=0 cellspacing=0>
<form name="list" method="post" style="margin:0px;">
<input type=hidden name=sst value='<?=$sst?>'>
<input type=hidden name=sod value='<?=$sod?>'>
<input type=hidden name=sfl value='<?=$sfl?>'>
<input type=hidden name=stx value='<?=$stx?>'>
<input type=hidden name=page value="<?=$page?>">
<tr height=34 align="center" style="font-weight:bold;">
<td width=40><input name="chk_all" type="checkbox" onclick="if (this.checked) all_checked(true); else all_checked(false);" title="전체선택/해제" /></td>
<td width=50>번호</td>
<td width=110>그룹명</td>
<td width=140>게시판명</td>
<td width=140>자료명</td>
<td width=60>이름</td>
<td width=70>포인트</td>
<td width=70>날짜</td>
<td width=40>삭제</td>
</tr>
</table>
</div>
<table width=100% border=0 cellpadding=0 cellspacing=0>
<!-- 목록 -->
<?
for ($i=1; $row=sql_fetch_array($result); $i++) {
$mb_datetime = date("m-d H:i", strtotime($row[mb_datetime]));
$del = "<a href=\"javascript:del('./download_del.php?$qstr&del=d&mb_no=$row[mb_no]&mb_id=$row[mb_id]');\"><img src=\"./img/co_btn_delete.gif\" align=absmiddle></a>";
?>
<tr height=25 align=center>
<td width=40> <input name="mb_no[]" type="checkbox" value="<?=$row[mb_no]?>" /></td>
<td width=50><span style='font:normal 11px tahoma; color:#BABABA;'><?=$i?></span></td>
<td width=110><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[gr_subject]?></span></td>
<td width=140><span style='font:normal 11px tahoma; color:#BABABA;' title="<?=$row[mb_subject]?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row[bo_table]?>&wr_id=<?=$row[wr_id]?>" target=_blank><?=$row[mb_subject]?></a></span></td>
<td width=140><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[bf_source]?></span></td>
<td width=60><span style='font:normal 11px tahoma; solid color:#BABABA;'><?=get_sideview($row[mb_id], $row[mb_name], $row[mb_nick], $row[mb_email], $row[mb_homepage])?></span></td>
<td width=70><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[mb_point]?> Point</span></td>
<td width=70><span style='font:normal 11px tahoma; color:#BABABA;'><?=$mb_datetime?></span></td>
<td width=40><span style='font:normal 11px tahoma; color:#BABABA;'><?=$del?></span></td>
</tr>
<tr><td colspan=<?=$colspan?> height=1 bgcolor=#eeeeee></td></tr>
<?} ?>
</form>
<? if ($total_count == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>다운로드 받은 회원내역이 없습니다</td></tr>"; } ?>
<tr><td colspan=<?=$colspan?> height=2 bgcolor=#eeeeee></td></tr>
<td colspan='<?=$colspan?>' height=40 align=center>
<div style="clear:both; margin-top:7px; height:31px;">
<div style="float:left;">
<a href="javascript:select_delete();"><img src="./img/btn_select_delete.gif" align=absmiddle></a> <? if ($sfl) { ?><a href="./download_list.php"><img src="./img/btn_list.gif" align=absmiddle></a><? } ?>
</div>
<div style="float:right;">
<form name=fsearch method=get>
<span style='font:11px tahoma; color:#7f9db9;'><input type=radio name=sfl value=mb_name checked>회원 이름 <input type=text style="background-color:#f6f6f6; border:1px solid #7f9db9; height:21px;" name=stx required itemname='검색어' value='<? echo $stx ?>'><input type=image src='./img/btn_search.gif' align=absmiddle>
</form>
</div>
</div>
<tr><td colspan='<?=$colspan?>' height=30 align=center>
<?
$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "$page";
?>
</td></tr>
</table>
<script language="Javascript">
function all_checked(sw) {
var f = document.list;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "mb_no[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str) {
var f = document.list;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "mb_no[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete() {
var f = document.list;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 회원들의 내역을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./download_alldel.php";
f.submit();
}
</script>
<?
include_once("$g4[admin_path]/admin.tail.php");
?>
일반회원 자신이 다운받은 자료 확인할수 있게 할려면 어떻게 하면 되나요
<?
$sub_menu = "300401";
include_once("./_common.php");
auth_check($auth[$sub_menu], "r");
$listall = "<a href='$_SERVER[PHP_SELF]'>처음</a>";
$g4[title] = "다운로드 목록";
include_once("$g4[admin_path]/admin.head.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
$sql_common = " from $g4[member_download_table] ";
$sql_search = " where (1) ";
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case "mb_name" :
$sql_search .= " ($sfl like '%$stx') ";
break;
}
$sql_search .= " ) ";
}
if (!$sst) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$date_row = sql_fetch($sql);
$total_count = $date_row[cnt];
$colspan = 9;
$rows = "15"; // 한페이지당 몇개 출력할것인지 숫자로 기입
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<div style="clear:both; height:5px;">
<div style="float:left;"><span style='font:normal 12px tahoma; color:#BABABA;'>Total : <?=$total_count?> EA</span></div>
<div style="float:right;"><a href="javascript:window.print();">프린트하기</a></div>
</div>
<div style="border:1px solid #ddd; height:34px; color:#505050; background-Color:#FBF8EE;">
<table width=100% border=0 cellpadding=0 cellspacing=0>
<form name="list" method="post" style="margin:0px;">
<input type=hidden name=sst value='<?=$sst?>'>
<input type=hidden name=sod value='<?=$sod?>'>
<input type=hidden name=sfl value='<?=$sfl?>'>
<input type=hidden name=stx value='<?=$stx?>'>
<input type=hidden name=page value="<?=$page?>">
<tr height=34 align="center" style="font-weight:bold;">
<td width=40><input name="chk_all" type="checkbox" onclick="if (this.checked) all_checked(true); else all_checked(false);" title="전체선택/해제" /></td>
<td width=50>번호</td>
<td width=110>그룹명</td>
<td width=140>게시판명</td>
<td width=140>자료명</td>
<td width=60>이름</td>
<td width=70>포인트</td>
<td width=70>날짜</td>
<td width=40>삭제</td>
</tr>
</table>
</div>
<table width=100% border=0 cellpadding=0 cellspacing=0>
<!-- 목록 -->
<?
for ($i=1; $row=sql_fetch_array($result); $i++) {
$mb_datetime = date("m-d H:i", strtotime($row[mb_datetime]));
$del = "<a href=\"javascript:del('./download_del.php?$qstr&del=d&mb_no=$row[mb_no]&mb_id=$row[mb_id]');\"><img src=\"./img/co_btn_delete.gif\" align=absmiddle></a>";
?>
<tr height=25 align=center>
<td width=40> <input name="mb_no[]" type="checkbox" value="<?=$row[mb_no]?>" /></td>
<td width=50><span style='font:normal 11px tahoma; color:#BABABA;'><?=$i?></span></td>
<td width=110><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[gr_subject]?></span></td>
<td width=140><span style='font:normal 11px tahoma; color:#BABABA;' title="<?=$row[mb_subject]?>"><a href="<?=$g4[bbs_path]?>/board.php?bo_table=<?=$row[bo_table]?>&wr_id=<?=$row[wr_id]?>" target=_blank><?=$row[mb_subject]?></a></span></td>
<td width=140><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[bf_source]?></span></td>
<td width=60><span style='font:normal 11px tahoma; solid color:#BABABA;'><?=get_sideview($row[mb_id], $row[mb_name], $row[mb_nick], $row[mb_email], $row[mb_homepage])?></span></td>
<td width=70><span style='font:normal 11px tahoma; color:#BABABA;'><?=$row[mb_point]?> Point</span></td>
<td width=70><span style='font:normal 11px tahoma; color:#BABABA;'><?=$mb_datetime?></span></td>
<td width=40><span style='font:normal 11px tahoma; color:#BABABA;'><?=$del?></span></td>
</tr>
<tr><td colspan=<?=$colspan?> height=1 bgcolor=#eeeeee></td></tr>
<?} ?>
</form>
<? if ($total_count == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>다운로드 받은 회원내역이 없습니다</td></tr>"; } ?>
<tr><td colspan=<?=$colspan?> height=2 bgcolor=#eeeeee></td></tr>
<td colspan='<?=$colspan?>' height=40 align=center>
<div style="clear:both; margin-top:7px; height:31px;">
<div style="float:left;">
<a href="javascript:select_delete();"><img src="./img/btn_select_delete.gif" align=absmiddle></a> <? if ($sfl) { ?><a href="./download_list.php"><img src="./img/btn_list.gif" align=absmiddle></a><? } ?>
</div>
<div style="float:right;">
<form name=fsearch method=get>
<span style='font:11px tahoma; color:#7f9db9;'><input type=radio name=sfl value=mb_name checked>회원 이름 <input type=text style="background-color:#f6f6f6; border:1px solid #7f9db9; height:21px;" name=stx required itemname='검색어' value='<? echo $stx ?>'><input type=image src='./img/btn_search.gif' align=absmiddle>
</form>
</div>
</div>
<tr><td colspan='<?=$colspan?>' height=30 align=center>
<?
$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "$page";
?>
</td></tr>
</table>
<script language="Javascript">
function all_checked(sw) {
var f = document.list;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "mb_no[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str) {
var f = document.list;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "mb_no[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete() {
var f = document.list;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 회원들의 내역을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./download_alldel.php";
f.submit();
}
</script>
<?
include_once("$g4[admin_path]/admin.tail.php");
?>
댓글 전체