게시물 댓글(코멘트) 날짜를 내 맘대로 변경하기 (v.2.0) 정보
게시물 댓글(코멘트) 날짜를 내 맘대로 변경하기 (v.2.0)관련링크
본문
1. skin / board / basic / view_comment.skin.php 67라인 에서
<input type=hidden id='secret_comment_<?=$comment_id?>' value="<?=strstr($list[$i][wr_option],"secret")?>">
밑으로 아래 소스를 추가합니다.
<?php if ($is_admin) { ?>
<tr>
<td style="padding-left:20px; background:url(<?php echo $board_skin_path; ?>/img/co_title_bg.gif); line-height:28px;"><form name='hp_comment_update' method='post' style='padding:0;' action="<?php echo $board_skin_path; ?>/view_comment_dateupdate.php">
<input type="hidden" name="bo_table" value="<?php echo $bo_table; ?>" />
<input type="hidden" name="wr_id" value="<?php echo $wr_id; ?>" />
<input type="hidden" name="page" value="<?php echo $page; ?>" />
<input type="hidden" name="sca" value="<?php echo $sca; ?>" />
<input type="hidden" name="sfl" value="<?php echo $sfl; ?>" />
<input type="hidden" name="stx" value="<?php echo $stx; ?>" />
<input type="hidden" name="spt" value="<?php echo $spt; ?>" />
<input type="hidden" name="page" value="<?php echo $page; ?>" />
<input type="hidden" name="cwin" value="<?php echo $cwin; ?>" />
<input type="hidden" name="is_good" value="" />
<?php
//echo $comment_id;
$sql_comment = " select wr_id, wr_datetime from $write_table where wr_id = '$comment_id' ";
//echo $sql_comment;
$result_comment = sql_query($sql_comment);
while($row_comment = mysql_fetch_array($result_comment)) {
//echo $comment_id;
?>
<input type="hidden" name="cid" value="<?php echo $comment_id; ?>" />
작성일 <input required style="width:140px;" name="cdate" maxlength="19" value="<?php echo $row_comment[wr_datetime]; ?>" />
<input type="submit" name="submit" value="수정" />
<?php
}
?>
</form></td>
</tr>
<?php } ?>
2. skin / board / basic / view_comment_dateupdate.php 파일을 신규로 생성합니다.
<?php
include_once "_common.php";
include_once "../../../dbconfig.php";
if(!is_admin) {
echo 'Administrators only';
exit;
}
$dbconn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("데이터베이스 연결에 실패하였습니다.");
mysql_select_db($mysql_db, $dbconn);
$sql = "update $write_table set wr_datetime = '$_POST[cdate]' where wr_id = '$_POST[cid]' ";
$result=mysql_query($sql,$dbconn);
echo mysql_error();
mysql_close($dbconn); // MySQL에 접속종료
// 그누보드 설치경로를 확인해서 오류나면 아래 링크를 수정하세요.
echo " <script>alert('Has been modified.'); document.location.href='/bbs/board.php?bo_table={$_POST[bo_table]}&wr_id={$_POST[wr_id]}&page={$_POST[page]}&sca={$_POST[sca]}&sfl={$_POST[sfl]}&stx={$_POST[stx]}&spt={$_POST[spt]}&page={$_POST[page]}&cwin={$_POST[cwin]}&is_good={$_POST[is_good]}'; </script>";
?>
맘에 드시면 좋아요(추천) 마구 눌러주세요 ^^
<input type=hidden id='secret_comment_<?=$comment_id?>' value="<?=strstr($list[$i][wr_option],"secret")?>">
밑으로 아래 소스를 추가합니다.
<?php if ($is_admin) { ?>
<tr>
<td style="padding-left:20px; background:url(<?php echo $board_skin_path; ?>/img/co_title_bg.gif); line-height:28px;"><form name='hp_comment_update' method='post' style='padding:0;' action="<?php echo $board_skin_path; ?>/view_comment_dateupdate.php">
<input type="hidden" name="bo_table" value="<?php echo $bo_table; ?>" />
<input type="hidden" name="wr_id" value="<?php echo $wr_id; ?>" />
<input type="hidden" name="page" value="<?php echo $page; ?>" />
<input type="hidden" name="sca" value="<?php echo $sca; ?>" />
<input type="hidden" name="sfl" value="<?php echo $sfl; ?>" />
<input type="hidden" name="stx" value="<?php echo $stx; ?>" />
<input type="hidden" name="spt" value="<?php echo $spt; ?>" />
<input type="hidden" name="page" value="<?php echo $page; ?>" />
<input type="hidden" name="cwin" value="<?php echo $cwin; ?>" />
<input type="hidden" name="is_good" value="" />
<?php
//echo $comment_id;
$sql_comment = " select wr_id, wr_datetime from $write_table where wr_id = '$comment_id' ";
//echo $sql_comment;
$result_comment = sql_query($sql_comment);
while($row_comment = mysql_fetch_array($result_comment)) {
//echo $comment_id;
?>
<input type="hidden" name="cid" value="<?php echo $comment_id; ?>" />
작성일 <input required style="width:140px;" name="cdate" maxlength="19" value="<?php echo $row_comment[wr_datetime]; ?>" />
<input type="submit" name="submit" value="수정" />
<?php
}
?>
</form></td>
</tr>
<?php } ?>
2. skin / board / basic / view_comment_dateupdate.php 파일을 신규로 생성합니다.
<?php
include_once "_common.php";
include_once "../../../dbconfig.php";
if(!is_admin) {
echo 'Administrators only';
exit;
}
$dbconn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("데이터베이스 연결에 실패하였습니다.");
mysql_select_db($mysql_db, $dbconn);
$sql = "update $write_table set wr_datetime = '$_POST[cdate]' where wr_id = '$_POST[cid]' ";
$result=mysql_query($sql,$dbconn);
echo mysql_error();
mysql_close($dbconn); // MySQL에 접속종료
// 그누보드 설치경로를 확인해서 오류나면 아래 링크를 수정하세요.
echo " <script>alert('Has been modified.'); document.location.href='/bbs/board.php?bo_table={$_POST[bo_table]}&wr_id={$_POST[wr_id]}&page={$_POST[page]}&sca={$_POST[sca]}&sfl={$_POST[sfl]}&stx={$_POST[stx]}&spt={$_POST[spt]}&page={$_POST[page]}&cwin={$_POST[cwin]}&is_good={$_POST[is_good]}'; </script>";
?>
맘에 드시면 좋아요(추천) 마구 눌러주세요 ^^
추천
2
2
댓글 3개
유용한 정보 고맙습니다
코멘트 날짜 수정하는 위치 살짝 이동했습니다. ^^
저는 아래와 같은 에러가 발생하는데 어디가 문제인지 모르겠습니다.
Warning:Cannot modify header information - headers already sent by (output started at C;\inetpub\wwwroot\skin\board\abc\view_comment_dateupdate.php:1)in c:\inetub\wwwroot\common.php on line 8
Warning:Cannot modify header information - headers already sent by (output started at C;\inetpub\wwwroot\skin\board\abc\view_comment_dateupdate.php:1)in c:\inetub\wwwroot\common.php on line 8