리스트에 수정하기 버튼 링크수정 알려주세요 정보
리스트에 수정하기 버튼 링크수정 알려주세요본문
아래 소스중 맨 밑에서 21번째 줄 수정링크거는 부분을 수정하면 될것같은데
잘 모르겠네요
그리고 변수는 어디에서 정의해놓은 건지 모르겠어요.
그 변수정의해놓은 곳을 찾는다면 수정이 가능할것같은데 말입니다.
스킨중에 list.skin.php
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<!--
<table width="<?=$width?>" border="0" cellpadding="0" cellspacing="0">
<tr><td height="10"></td></tr>
<tr>
<td>
<table width="<?=$width?>" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_top.gif" width="700" height="7"></td>
</tr>
<tr>
<td background="images/software/img_bg.gif">
<table width="700" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="<?=$board_skin_path?>/img/progress/img_bg.gif">
<table width="680" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><//? include "category.php"; ?>
</td>
</tr>
<tr>
<td>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_text2.gif" width="331" height="58"></td>
<td width="80" valign="top">
<table width="120" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="14"></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_bottom.gif" width="700" height="7"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table>
-->
<table width="<?=$width?>" align="center" cellpadding="0" cellspcing="0"><tr><td>
<!-- 분류 셀렉트 박스, 게시물 몇건, 관리자화면 링크 시작 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<!-- <? if ($is_category) { ?><form name="fcategory" method="get">
<td width="50%"><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>전체</option><?=$category_option?></select></td>
</form><? } ?> -->
<td height=25 align="right"><!-- <font class=w_font>게시물 <?=number_format($total_count)?>건</font> --><? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/admin_button.gif" title="관리자" width="63" height="22" border="0" align="absmiddle"></a><? } ?></td>
</tr>
</table>
<!-- 분류 셀렉트 박스, 게시물 몇건, 관리자화면 링크 끝 -->
<!-- 여백 --><table width="100%" cellspacing="0" cellpadding="0"><tr><td height="5"></td></tr></table>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<form name="fboardlist" method="post">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sfl" value="<?=$sfl?>">
<input type="hidden" name="stx" value="<?=$stx?>">
<input type="hidden" name="spt" value="<?=$spt?>">
<input type="hidden" name="page" value="<?=$page?>">
<input type="hidden" name="sw" value="">
<? if ($is_admin) { ?><tr><td height=30 colspan='<?=$board[bo_gallery_cols]?>' style='padding-left:20px;'><INPUT onclick="if (this.checked) all_checked(true); else all_checked(false);" type=checkbox> 전체선택</td></tr><? } ?>
<tr>
<?
for ($i=0; $i<count($list); $i++)
{
$homepageurl="";
//추가
if($list[$i][wr_1] >= 100)
{
$ing="[작업완료]";
//$homepageurl=$list[wr_link1];
if($list[$i][wr_link1]) $homepageurl="<a href='".$list[$i][wr_link1]."' target=_blank>";
}
else $ing="";
$_datetime=$list[$i][datetime2];
$_hit=$list[$i][wr_hit];
$title = "클릭하시면 해당 사이트로 이동합니다.";
$content = cut_str(get_text($list[$i][wr_content]), 80);
$img = "$g4[path]/data/file/$bo_table/".urlencode($list[$i][file][0][file]);
if (!file_exists($img) || !$list[$i][file][0][file])
$img = "$board_skin_path/img/progress/no_image.gif";
$href = "$g4[bbs_path]/board.php?bo_table=$bo_table&wr_id={$list[$i][wr_id]}&no=1";
//$view_href = "";
//if ($is_admin)
$view_href = "<a href='$g4[bbs_path]/board.php?bo_table=$bo_table&wr_id={$list[$i][wr_id]}'>";
$checkbox = "";
if ($is_checkbox)
$checkbox = "<input type=checkbox name=chk_wr_id[] value='{$list[$i][wr_id]}'>";
$link = cut_str($list[$i][wr_link1], 70);
$homepageurl="<a href='{$list[$i][wr_link1]}' target=_blank>{$link}</a>";
$homepageurl2="<a href='{$list[$i][wr_link1]}' target=_blank>";
$wr_guide = nl2br(cut_str($list[$i][wr_3],250));
$tr = "";
if ($i && $i%$board[bo_gallery_cols]==0)
$tr = "</tr><tr>";
echo "$tr";
echo <<<HEREDOC
<td width="{$td_width}%" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="210" valign="top">
<table border="0" cellpadding="0" cellspacing="0" valign="top">
<tr>
<td height="9" colspan="3"><img src="{$board_skin_path}/img/progress/skin_top.gif" width="210" height="9"></td>
</tr>
<tr>
<td width="9" background="{$board_skin_path}/img/progress/skin_left.gif" > </td>
<td width="170" height="128"><img src="{$img}" width="192" height="128" border="0" ></td>
<td width="9" valign="top" background="{$board_skin_path}/img/progress/skin_right.gif"><img src="{$board_skin_path}/img/progress/skin_right_img.gif" width="9" height="5"></td>
</tr>
<tr>
<td colspan="3"><img src="{$board_skin_path}/img/progress/skin_down.gif" width="210" height="9"></td>
</tr>
</table>
</td>
<td width="600" valign="top">
<table width="98%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr><td height=2 bgcolor=#B0ADF5></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 명
: {$checkbox}{$view_href}{$list[$i][subject]} [{$list[$i][ca_name]}] </a></td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28>{$list[$i][content]} <img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 정 별
: {$list[$i][wr_5]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 정 일
: {$list[$i][wr_6]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 소 재 지
: {$list[$i][wr_4]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 기타사항: [단체이용:{$list[$i][wr_1]}][주차시설:{$list[$i][wr_2]}][문의전화:{$list[$i][wr_3]}]교통안내 :{$list[$i][wr_7]} 강진경:{$list[$i][wr_8]}설명ㅋ:{$list[$i][wr_9]}
</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
</tr>
<tr>
<td height="10" ></td>
</tr>
<!-- <tr>
<td>
{$view_href}{$wr_guide}</a>
</td>
</tr> -->
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</td>
HEREDOC;
}
// 나머지 td 를 채운다.
if (($cnt = $i%$list_mod) != 0)
for ($k=$cnt; $k<$list_mod; $k++)
echo "<td> </td>\n";
if ($i == 0)
echo "<td colspan='$board[bo_gallery_cols]' height=50 align=center>게시물이 없습니다.</td>";
?>
</form>
</tr>
</table>
<!-- <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td height="1" width="100%" bgcolor="#CCCCCC"></td></tr></table> -->
<!-- 페이지 표시 시작 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="20" align="center" valign="middle">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center">
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' width=50 height=20 border=0 align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<font style=\"font-family:돋움; font-size:9pt; color:#797979\">$1</font>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<font style=\"font-family:돋움; font-size:9pt; color:orange;\">$1</font>", $write_pages);
?>
<strong><?=$write_pages?></strong>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' width=50 height=20 border=0 align=absmiddle title='다음검색'></a>"; } ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- 페이지 표시 끝 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr align="left" valign="middle">
<td width="50%" height="40">
<? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0" align="absmiddle"></a><? } ?>
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0" align="absmiddle"></a><? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_update();"><img src="<?=$board_skin_path?>/img/btn_update.gif" border="0" align="absmiddle"></a>
<? } ?>
</td>
<form name=fsearch method=get>
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<td width="50%" align="right">
<select name=sfl>
<option value='wr_subject'>제목</option>
</select>
<INPUT maxLength=15 size=10 name=stx itemname="검색어" required value="<?=$stx?>">
<SELECT name=sop>
<OPTION value=and>And</OPTION>
<OPTION value=or>Or</OPTION>
</SELECT>
</td>
<td width="10%" align="center"> <INPUT type=image src="<?=$board_skin_path?>/img/homepagemake_bt.gif" border=0></td>
</form>
</tr>
</table>
</td></tr></table>
<script language="JavaScript">
//if ("<?=$sca?>") document.fcategory.sca.value = "<?=$sca?>";
if ("<?=$stx?>") {
document.fsearch.sfl.value = "<?=$sfl?>";
document.fsearch.sop.value = "<?=$sop?>";
}
</script>
<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw)
{
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str)
{
var f = document.fboardlist;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete()
{
var f = document.fboardlist;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./delete_all.php";
f.submit();
}
//수정
function select_update()
{
var f = document.fboardlist;
str = "수정";
if (!check_confirm(str))
return;
f.action = "./write.php?w=u&bo_table=$bo_table&wr_id=$wr_id&page=$page" ;
f.submit();
}
// 선택한 게시물 복사 및 이동
function select_copy(sw)
{
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
if (!check_confirm(str))
return;
var sub_win = window.open("", "move", "left=50, top=50, width=396, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<? } ?>
엑스엠엘 08-07-19 10:14 211.♡.158.244
목록에서
<a href="write.php?w=u&wr_id=<?=$list[ $i]['wr_id']?>" >수정</a>
목록에서
<a href="write.php?w=u&wr_id=<?=$list[ $i]['wr_id']?>" >수정</a>
살라맨 08-07-21 00:45 220.♡.17.147
테이블값도 넘겨줘야 될것 같아요
테이블값도 넘겨줘야 될것 같아요
콩콩 08-07-21 10:10 123.♡.0.218
알려주셔서 너무 감사합니다.
근데 엑스엠엘님이 알려주신대로 했더니 테이블값을 넣으라고해서
<a href="./write.php?bo_table=$bo_table&w=u&wr_id=<?=$list[ $i]['wr_id']?>"><img src="<?=$board_skin_path?>/img/btn_update.gif" border="0" align="absmiddle"></a>
이렇게 넣었는데
select count(*) as cnt from where wr_reply like '%' and wr_id <> '' and wr_num = '' and wr_is_comment = 0
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_reply like '%' and wr_id <> ''
error file : /gnu4/bbs/write.php
이런 에러가 나네요 뭘 고쳐야 하나요?
잘 모르겠네요
그리고 변수는 어디에서 정의해놓은 건지 모르겠어요.
그 변수정의해놓은 곳을 찾는다면 수정이 가능할것같은데 말입니다.
스킨중에 list.skin.php
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<!--
<table width="<?=$width?>" border="0" cellpadding="0" cellspacing="0">
<tr><td height="10"></td></tr>
<tr>
<td>
<table width="<?=$width?>" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_top.gif" width="700" height="7"></td>
</tr>
<tr>
<td background="images/software/img_bg.gif">
<table width="700" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="<?=$board_skin_path?>/img/progress/img_bg.gif">
<table width="680" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><//? include "category.php"; ?>
</td>
</tr>
<tr>
<td>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_text2.gif" width="331" height="58"></td>
<td width="80" valign="top">
<table width="120" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="14"></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td><img src="<?=$board_skin_path?>/img/progress/img_bottom.gif" width="700" height="7"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table>
-->
<table width="<?=$width?>" align="center" cellpadding="0" cellspcing="0"><tr><td>
<!-- 분류 셀렉트 박스, 게시물 몇건, 관리자화면 링크 시작 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<!-- <? if ($is_category) { ?><form name="fcategory" method="get">
<td width="50%"><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>전체</option><?=$category_option?></select></td>
</form><? } ?> -->
<td height=25 align="right"><!-- <font class=w_font>게시물 <?=number_format($total_count)?>건</font> --><? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/admin_button.gif" title="관리자" width="63" height="22" border="0" align="absmiddle"></a><? } ?></td>
</tr>
</table>
<!-- 분류 셀렉트 박스, 게시물 몇건, 관리자화면 링크 끝 -->
<!-- 여백 --><table width="100%" cellspacing="0" cellpadding="0"><tr><td height="5"></td></tr></table>
<table width="100%" cellspacing="0" cellpadding="0" border=0>
<form name="fboardlist" method="post">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sfl" value="<?=$sfl?>">
<input type="hidden" name="stx" value="<?=$stx?>">
<input type="hidden" name="spt" value="<?=$spt?>">
<input type="hidden" name="page" value="<?=$page?>">
<input type="hidden" name="sw" value="">
<? if ($is_admin) { ?><tr><td height=30 colspan='<?=$board[bo_gallery_cols]?>' style='padding-left:20px;'><INPUT onclick="if (this.checked) all_checked(true); else all_checked(false);" type=checkbox> 전체선택</td></tr><? } ?>
<tr>
<?
for ($i=0; $i<count($list); $i++)
{
$homepageurl="";
//추가
if($list[$i][wr_1] >= 100)
{
$ing="[작업완료]";
//$homepageurl=$list[wr_link1];
if($list[$i][wr_link1]) $homepageurl="<a href='".$list[$i][wr_link1]."' target=_blank>";
}
else $ing="";
$_datetime=$list[$i][datetime2];
$_hit=$list[$i][wr_hit];
$title = "클릭하시면 해당 사이트로 이동합니다.";
$content = cut_str(get_text($list[$i][wr_content]), 80);
$img = "$g4[path]/data/file/$bo_table/".urlencode($list[$i][file][0][file]);
if (!file_exists($img) || !$list[$i][file][0][file])
$img = "$board_skin_path/img/progress/no_image.gif";
$href = "$g4[bbs_path]/board.php?bo_table=$bo_table&wr_id={$list[$i][wr_id]}&no=1";
//$view_href = "";
//if ($is_admin)
$view_href = "<a href='$g4[bbs_path]/board.php?bo_table=$bo_table&wr_id={$list[$i][wr_id]}'>";
$checkbox = "";
if ($is_checkbox)
$checkbox = "<input type=checkbox name=chk_wr_id[] value='{$list[$i][wr_id]}'>";
$link = cut_str($list[$i][wr_link1], 70);
$homepageurl="<a href='{$list[$i][wr_link1]}' target=_blank>{$link}</a>";
$homepageurl2="<a href='{$list[$i][wr_link1]}' target=_blank>";
$wr_guide = nl2br(cut_str($list[$i][wr_3],250));
$tr = "";
if ($i && $i%$board[bo_gallery_cols]==0)
$tr = "</tr><tr>";
echo "$tr";
echo <<<HEREDOC
<td width="{$td_width}%" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="210" valign="top">
<table border="0" cellpadding="0" cellspacing="0" valign="top">
<tr>
<td height="9" colspan="3"><img src="{$board_skin_path}/img/progress/skin_top.gif" width="210" height="9"></td>
</tr>
<tr>
<td width="9" background="{$board_skin_path}/img/progress/skin_left.gif" > </td>
<td width="170" height="128"><img src="{$img}" width="192" height="128" border="0" ></td>
<td width="9" valign="top" background="{$board_skin_path}/img/progress/skin_right.gif"><img src="{$board_skin_path}/img/progress/skin_right_img.gif" width="9" height="5"></td>
</tr>
<tr>
<td colspan="3"><img src="{$board_skin_path}/img/progress/skin_down.gif" width="210" height="9"></td>
</tr>
</table>
</td>
<td width="600" valign="top">
<table width="98%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr><td height=2 bgcolor=#B0ADF5></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 명
: {$checkbox}{$view_href}{$list[$i][subject]} [{$list[$i][ca_name]}] </a></td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28>{$list[$i][content]} <img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 정 별
: {$list[$i][wr_5]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 지 정 일
: {$list[$i][wr_6]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 소 재 지
: {$list[$i][wr_4]}</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
<tr><td height=28><img src="{$board_skin_path}/img/homepagemake_icon.gif" width="9" height="9"> 기타사항: [단체이용:{$list[$i][wr_1]}][주차시설:{$list[$i][wr_2]}][문의전화:{$list[$i][wr_3]}]교통안내 :{$list[$i][wr_7]} 강진경:{$list[$i][wr_8]}설명ㅋ:{$list[$i][wr_9]}
</td></tr>
<tr><td height=1 bgcolor=#E7E7E7></td></tr>
</tr>
<tr>
<td height="10" ></td>
</tr>
<!-- <tr>
<td>
{$view_href}{$wr_guide}</a>
</td>
</tr> -->
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
</td>
HEREDOC;
}
// 나머지 td 를 채운다.
if (($cnt = $i%$list_mod) != 0)
for ($k=$cnt; $k<$list_mod; $k++)
echo "<td> </td>\n";
if ($i == 0)
echo "<td colspan='$board[bo_gallery_cols]' height=50 align=center>게시물이 없습니다.</td>";
?>
</form>
</tr>
</table>
<!-- <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td height="1" width="100%" bgcolor="#CCCCCC"></td></tr></table> -->
<!-- 페이지 표시 시작 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="20" align="center" valign="middle">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center">
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' width=50 height=20 border=0 align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<font style=\"font-family:돋움; font-size:9pt; color:#797979\">$1</font>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<font style=\"font-family:돋움; font-size:9pt; color:orange;\">$1</font>", $write_pages);
?>
<strong><?=$write_pages?></strong>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' width=50 height=20 border=0 align=absmiddle title='다음검색'></a>"; } ?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- 페이지 표시 끝 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr align="left" valign="middle">
<td width="50%" height="40">
<? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0" align="absmiddle"></a><? } ?>
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0" align="absmiddle"></a><? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0" align="absmiddle"></a>
<a href="javascript:select_update();"><img src="<?=$board_skin_path?>/img/btn_update.gif" border="0" align="absmiddle"></a>
<? } ?>
</td>
<form name=fsearch method=get>
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<td width="50%" align="right">
<select name=sfl>
<option value='wr_subject'>제목</option>
</select>
<INPUT maxLength=15 size=10 name=stx itemname="검색어" required value="<?=$stx?>">
<SELECT name=sop>
<OPTION value=and>And</OPTION>
<OPTION value=or>Or</OPTION>
</SELECT>
</td>
<td width="10%" align="center"> <INPUT type=image src="<?=$board_skin_path?>/img/homepagemake_bt.gif" border=0></td>
</form>
</tr>
</table>
</td></tr></table>
<script language="JavaScript">
//if ("<?=$sca?>") document.fcategory.sca.value = "<?=$sca?>";
if ("<?=$stx?>") {
document.fsearch.sfl.value = "<?=$sfl?>";
document.fsearch.sop.value = "<?=$sop?>";
}
</script>
<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw)
{
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str)
{
var f = document.fboardlist;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete()
{
var f = document.fboardlist;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./delete_all.php";
f.submit();
}
//수정
function select_update()
{
var f = document.fboardlist;
str = "수정";
if (!check_confirm(str))
return;
f.action = "./write.php?w=u&bo_table=$bo_table&wr_id=$wr_id&page=$page" ;
f.submit();
}
// 선택한 게시물 복사 및 이동
function select_copy(sw)
{
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
if (!check_confirm(str))
return;
var sub_win = window.open("", "move", "left=50, top=50, width=396, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<? } ?>
엑스엠엘 08-07-19 10:14 211.♡.158.244
목록에서
<a href="write.php?w=u&wr_id=<?=$list[ $i]['wr_id']?>" >수정</a>
목록에서
<a href="write.php?w=u&wr_id=<?=$list[ $i]['wr_id']?>" >수정</a>
살라맨 08-07-21 00:45 220.♡.17.147
테이블값도 넘겨줘야 될것 같아요
테이블값도 넘겨줘야 될것 같아요
콩콩 08-07-21 10:10 123.♡.0.218
알려주셔서 너무 감사합니다.
근데 엑스엠엘님이 알려주신대로 했더니 테이블값을 넣으라고해서
<a href="./write.php?bo_table=$bo_table&w=u&wr_id=<?=$list[ $i]['wr_id']?>"><img src="<?=$board_skin_path?>/img/btn_update.gif" border="0" align="absmiddle"></a>
이렇게 넣었는데
select count(*) as cnt from where wr_reply like '%' and wr_id <> '' and wr_num = '' and wr_is_comment = 0
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where wr_reply like '%' and wr_id <> ''
error file : /gnu4/bbs/write.php
이런 에러가 나네요 뭘 고쳐야 하나요?
댓글 전체
<a href="./write.php?bo_table=<?=$bo_table?>&w=u&wr_id=<?=$list[ $i]['wr_id']?>"><img src="<?=$board_skin_path?>/img/btn_update.gif" border="0" align="absmiddle"></a>
$bo_table 에는 에코가 안들어갔네요
$bo_table 에는 에코가 안들어갔네요