급질문드립니다 ........급해요 ㅡㅜ 정보
급질문드립니다 ........급해요 ㅡㅜ
본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 :
<?php
include_once("_common.php");
/*
* 한페이지에 보여질 Thumbnail 이미지 개수
*/
@define(PAGE_LIMIT1, 12);
/* page navigation 최대 노출 숫자 ex) 1 2 3 4 > 이렇게 노출 */
@define(PAGE_LIMIT2, 4);
/* Thumbnail 이미지 Width */
@define(IMAGE_WIDTH, 130);
/* Thumbnail 이미지 Height */
@define(IMAGE_HEIGHT, 80);
/* 노출 라인 수 주의사항. 위에 PAGE_LIMIT1과 딱 나눠떨어져야 합니다. (나머지가 0이어야 함) */
@define(LINE, 2);
$page += 1;
$result = modifyGalleryImages($bo_table, $page, PAGE_LIMIT1);
$count = modifyGalleryImagesCount($bo_table);
$__paging = pagingSetting($count, $page, PAGE_LIMIT1, PAGE_LIMIT2, "");
$root = $_SERVER['DOCUMENT_ROOT'];
function modifyGalleryImagesCount($bo_table) {
$sql = "SELECT count(*) AS cnt
FROM g4_board_file
WHERE bo_table = '$bo_table'";
$result = sql_fetch($sql);
return $result['cnt'];
}
function modifyGalleryImages($bo_table, $page, $limit) {
$limit_query = sprintf("%s, %s", ($page - 1) * $limit, $limit);
$sql = "SELECT bf_file, wr_id
FROM g4_board_file
WHERE bo_table = '$bo_table'
ORDER BY bf_datetime DESC
LIMIT $limit_query";
$result = sql_query($sql);
if(!is_dir("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb") && !file_exists("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb"))
@mkdir("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb", 0777);
while($row = mysql_fetch_assoc($result)) {
$thumbfile = md5($row['bf_file']).".jpg";
if(!file_exists(sprintf("%s/data/file/%s/thumb/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $thumbfile))) {
$origin = sprintf("%s/data/file/%s/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $row['bf_file']);
$thumbnail = sprintf("%s/data/file/%s/thumb/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $thumbfile);
list($width, $height, $type) = getimagesize($origin);
if($type == IMAGETYPE_GIF)
$src = imagecreatefromgif($origin);
else if($type == IMAGETYPE_JPEG)
$src = imagecreatefromjpeg($origin);
else if($type == IMAGETYPE_PNG)
$src = imagecreatefrompng($origin);
$dst = imagecreatetruecolor(IMAGE_WIDTH, IMAGE_HEIGHT);
imagecopyresampled($dst, $src, 0, 0, 0, 0, IMAGE_WIDTH, IMAGE_HEIGHT, $width, $height);
imagejpeg($dst, $thumbnail, 80);
@chmod($thumbnail, 0777);
}
$row['thumbfile'] = $thumbfile;
$array[] = $row;
}
return $array;
}
function pagingSetting($count, $paging, $limit1, $limit2, $url) {
$divide_page = (int)((int)($count - 1) / (int)$limit1);
if($divide_page >= 0)
$page['depth1'] = $divide_page + 1;
else
$page['depth1'] = $divide_page;
$page['depth2'] = (int)((int)($page['depth1']) / (int)$limit2);
$page['now'] = $paging;
$page['max'] = $count;
$page['limit'] = $limit2;
$page['depth1_begin'] = (int)(($paging - 1) / $limit2) * $limit2;
$page['url'] = $url;
$paging_max = ((int)(($paging - 1) / $limit2) + 1) * $limit2;
if($paging_max == $limit2)
$page['prev'] = -1;
else
$page['prev'] = $page['depth1_begin'];
if($paging_max >= $page['depth1']) {
$page['depth1_max'] = $page['depth1'] ;
$page['next'] = -1;
} else {
$page['depth1_max'] = $paging_max;
$page['next'] = $paging_max + 1;
}
return $page;
}
?>
<style>
.modifys-gallery-main .modifys-gallery-left table tr td { width: <?=IMAGE_WIDTH + 5?>px; height: <?=IMAGE_HEIGHT + 5?>px; text-align: center; }
.modifys-gallery-main .modifys-gallery-left .gallery-box { <?= ($_SESSION['ss_mb_id'] == "admin")?"cursor: pointer;":""?> }
.modifys-gallery-main .modifys-gallery-left .gallery-box .gallery-image { width: <?=IMAGE_WIDTH?>px; height: <?=IMAGE_HEIGHT?>px;}
.page-footer { width: 100%; margin: 0 auto; text-align: center; padding-top: 10px; padding-bottom: 10px; }
.page-footer .tab { padding: 2px 5px 2px 5px; border: 1px solid #e2e2e2; }
.page-footer img { border: 0px; margin-bottom: -2px;}
.selected { color: red; }
</style>
<? if($_SESSION['ss_mb_id'] == "admin") {?>
<script>
$(function() {
$(".gallery-box").click(function() {
var imageObject = $(this).find("img");
if($(imageObject).attr("noimage") == "NO") {
if($(this).attr("delete") == "true") {
$(imageObject).attr("style", "border: 1px solid #dedede;");
$(this).removeAttr("delete");
} else {
$(imageObject).attr("style", "border: 3px solid skyblue;");
$(this).attr("delete", "true");
}
}
});
$(".tab").hover(function() {
$(this).attr("style", "background-color: skyblue;");
}, function() {
$(this).attr("style", "background-color: #ffffff;");
});
});
$.deleteImage = function() {
var nonSelected = true;
var postData = "";
$(".gallery-box").each(function(index, object) {
var wr_id = $(this).find("[name=wr_id]").val();
if($(this).attr("delete") == "true") {
nonSelected = false;
postData += "&wr_id[]=" + wr_id;
}
});
if(nonSelected) {
window.alert("삭제할 이미지를 선택해주세요");
return;
}
if(confirm("이미지를 정말로 삭제하시겠습니까?")) {
$.ajax({
url: "/bbs/modify_gallery/delete.php",
data: "bo_table=<?=$bo_table?>" + postData,
type: "post",
dataType: "json",
timeout: 50000,
error: function() { window.alert("서버와의 통신이 실패하였습니다."); return false; },
success: function(json) {
window.alert(json['msg']);
location.href = "/bbs/board.php?bo_table=<?=$bo_table?>&page=<?=$page?>";
}
});
}
}
</script>
<? } ?>
<table width="<?=(IMAGE_WIDTH + 10) * LINE?>px" cellpadding="0" cellspacing="0">
<? for($rows = 0; $rows < PAGE_LIMIT1; $rows++) { ?>
<? if(!($rows % LINE)) { ?>
<tr>
<? } ?>
<td>
<div class="gallery-box" style="display: none;">
<? if($_SESSION['ss_mb_id'] == "admin") { ?>
<input type="hidden" name="wr_id" value="<?=$result[$rows]['wr_id']?>" />
<? } ?>
<a href="/bbs/board.php?bo_table=<?=$bo_table?>&wr_id=<?=$result[$rows]['wr_id']?>"><img class="gallery-image" src="<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"):"$g4[path]/img/tp-co1.png"; ?>" origin="<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']):"$g4[path]/img/tp-co.png";?>" noimage="<?= $result[$rows]?"NO":"YES";?>" />
</div>
</td>
<? if(($rows % LINE) == LINE - 1) { ?>
</tr>
<? } ?>
<? } ?>
</table>
----------------------------------------------------------------------------------------------
소스를 보시면 하단부분에
<a href="/bbs/board.php?bo_table=<?=$bo_table?>&wr_id=<?=$result[$rows]['wr_id']?>"><img class="gallery-image" src="<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"):"$g4[path]/img/tp-co1.png"; ?>" origin="<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']):"$g4[path]/img/tp-co.png";?>" noimage="<?= $result[$rows]?"NO":"YES";?>" />
이내용이 있습니다.
<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"
이부분은 첫번째 이미지를 썸네일시킨것을 불러오는코드이고
<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']
이건 첫번째 원본을 불러오는 코드입니다.
여기서 첫번째 원본을 불러오는 코드에 첫번째 원본이 아닌 두번째 원본을 불러오고 싶습니다...
방법을 모르겟어요 ㅡㅜ 늦어도 10시까지 해결을 해야하는데 ........
좀 봐주세요...부탁드려요~
오류 주소 :
<?php
include_once("_common.php");
/*
* 한페이지에 보여질 Thumbnail 이미지 개수
*/
@define(PAGE_LIMIT1, 12);
/* page navigation 최대 노출 숫자 ex) 1 2 3 4 > 이렇게 노출 */
@define(PAGE_LIMIT2, 4);
/* Thumbnail 이미지 Width */
@define(IMAGE_WIDTH, 130);
/* Thumbnail 이미지 Height */
@define(IMAGE_HEIGHT, 80);
/* 노출 라인 수 주의사항. 위에 PAGE_LIMIT1과 딱 나눠떨어져야 합니다. (나머지가 0이어야 함) */
@define(LINE, 2);
$page += 1;
$result = modifyGalleryImages($bo_table, $page, PAGE_LIMIT1);
$count = modifyGalleryImagesCount($bo_table);
$__paging = pagingSetting($count, $page, PAGE_LIMIT1, PAGE_LIMIT2, "");
$root = $_SERVER['DOCUMENT_ROOT'];
function modifyGalleryImagesCount($bo_table) {
$sql = "SELECT count(*) AS cnt
FROM g4_board_file
WHERE bo_table = '$bo_table'";
$result = sql_fetch($sql);
return $result['cnt'];
}
function modifyGalleryImages($bo_table, $page, $limit) {
$limit_query = sprintf("%s, %s", ($page - 1) * $limit, $limit);
$sql = "SELECT bf_file, wr_id
FROM g4_board_file
WHERE bo_table = '$bo_table'
ORDER BY bf_datetime DESC
LIMIT $limit_query";
$result = sql_query($sql);
if(!is_dir("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb") && !file_exists("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb"))
@mkdir("$_SERVER[DOCUMENT_ROOT]/data/file/$bo_table/thumb", 0777);
while($row = mysql_fetch_assoc($result)) {
$thumbfile = md5($row['bf_file']).".jpg";
if(!file_exists(sprintf("%s/data/file/%s/thumb/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $thumbfile))) {
$origin = sprintf("%s/data/file/%s/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $row['bf_file']);
$thumbnail = sprintf("%s/data/file/%s/thumb/%s", $_SERVER['DOCUMENT_ROOT'], $bo_table, $thumbfile);
list($width, $height, $type) = getimagesize($origin);
if($type == IMAGETYPE_GIF)
$src = imagecreatefromgif($origin);
else if($type == IMAGETYPE_JPEG)
$src = imagecreatefromjpeg($origin);
else if($type == IMAGETYPE_PNG)
$src = imagecreatefrompng($origin);
$dst = imagecreatetruecolor(IMAGE_WIDTH, IMAGE_HEIGHT);
imagecopyresampled($dst, $src, 0, 0, 0, 0, IMAGE_WIDTH, IMAGE_HEIGHT, $width, $height);
imagejpeg($dst, $thumbnail, 80);
@chmod($thumbnail, 0777);
}
$row['thumbfile'] = $thumbfile;
$array[] = $row;
}
return $array;
}
function pagingSetting($count, $paging, $limit1, $limit2, $url) {
$divide_page = (int)((int)($count - 1) / (int)$limit1);
if($divide_page >= 0)
$page['depth1'] = $divide_page + 1;
else
$page['depth1'] = $divide_page;
$page['depth2'] = (int)((int)($page['depth1']) / (int)$limit2);
$page['now'] = $paging;
$page['max'] = $count;
$page['limit'] = $limit2;
$page['depth1_begin'] = (int)(($paging - 1) / $limit2) * $limit2;
$page['url'] = $url;
$paging_max = ((int)(($paging - 1) / $limit2) + 1) * $limit2;
if($paging_max == $limit2)
$page['prev'] = -1;
else
$page['prev'] = $page['depth1_begin'];
if($paging_max >= $page['depth1']) {
$page['depth1_max'] = $page['depth1'] ;
$page['next'] = -1;
} else {
$page['depth1_max'] = $paging_max;
$page['next'] = $paging_max + 1;
}
return $page;
}
?>
<style>
.modifys-gallery-main .modifys-gallery-left table tr td { width: <?=IMAGE_WIDTH + 5?>px; height: <?=IMAGE_HEIGHT + 5?>px; text-align: center; }
.modifys-gallery-main .modifys-gallery-left .gallery-box { <?= ($_SESSION['ss_mb_id'] == "admin")?"cursor: pointer;":""?> }
.modifys-gallery-main .modifys-gallery-left .gallery-box .gallery-image { width: <?=IMAGE_WIDTH?>px; height: <?=IMAGE_HEIGHT?>px;}
.page-footer { width: 100%; margin: 0 auto; text-align: center; padding-top: 10px; padding-bottom: 10px; }
.page-footer .tab { padding: 2px 5px 2px 5px; border: 1px solid #e2e2e2; }
.page-footer img { border: 0px; margin-bottom: -2px;}
.selected { color: red; }
</style>
<? if($_SESSION['ss_mb_id'] == "admin") {?>
<script>
$(function() {
$(".gallery-box").click(function() {
var imageObject = $(this).find("img");
if($(imageObject).attr("noimage") == "NO") {
if($(this).attr("delete") == "true") {
$(imageObject).attr("style", "border: 1px solid #dedede;");
$(this).removeAttr("delete");
} else {
$(imageObject).attr("style", "border: 3px solid skyblue;");
$(this).attr("delete", "true");
}
}
});
$(".tab").hover(function() {
$(this).attr("style", "background-color: skyblue;");
}, function() {
$(this).attr("style", "background-color: #ffffff;");
});
});
$.deleteImage = function() {
var nonSelected = true;
var postData = "";
$(".gallery-box").each(function(index, object) {
var wr_id = $(this).find("[name=wr_id]").val();
if($(this).attr("delete") == "true") {
nonSelected = false;
postData += "&wr_id[]=" + wr_id;
}
});
if(nonSelected) {
window.alert("삭제할 이미지를 선택해주세요");
return;
}
if(confirm("이미지를 정말로 삭제하시겠습니까?")) {
$.ajax({
url: "/bbs/modify_gallery/delete.php",
data: "bo_table=<?=$bo_table?>" + postData,
type: "post",
dataType: "json",
timeout: 50000,
error: function() { window.alert("서버와의 통신이 실패하였습니다."); return false; },
success: function(json) {
window.alert(json['msg']);
location.href = "/bbs/board.php?bo_table=<?=$bo_table?>&page=<?=$page?>";
}
});
}
}
</script>
<? } ?>
<table width="<?=(IMAGE_WIDTH + 10) * LINE?>px" cellpadding="0" cellspacing="0">
<? for($rows = 0; $rows < PAGE_LIMIT1; $rows++) { ?>
<? if(!($rows % LINE)) { ?>
<tr>
<? } ?>
<td>
<div class="gallery-box" style="display: none;">
<? if($_SESSION['ss_mb_id'] == "admin") { ?>
<input type="hidden" name="wr_id" value="<?=$result[$rows]['wr_id']?>" />
<? } ?>
<a href="/bbs/board.php?bo_table=<?=$bo_table?>&wr_id=<?=$result[$rows]['wr_id']?>"><img class="gallery-image" src="<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"):"$g4[path]/img/tp-co1.png"; ?>" origin="<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']):"$g4[path]/img/tp-co.png";?>" noimage="<?= $result[$rows]?"NO":"YES";?>" />
</div>
</td>
<? if(($rows % LINE) == LINE - 1) { ?>
</tr>
<? } ?>
<? } ?>
</table>
----------------------------------------------------------------------------------------------
소스를 보시면 하단부분에
<a href="/bbs/board.php?bo_table=<?=$bo_table?>&wr_id=<?=$result[$rows]['wr_id']?>"><img class="gallery-image" src="<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"):"$g4[path]/img/tp-co1.png"; ?>" origin="<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']):"$g4[path]/img/tp-co.png";?>" noimage="<?= $result[$rows]?"NO":"YES";?>" />
이내용이 있습니다.
<?= $result[$rows]?sprintf("/data/file/{$bo_table}/thumbnail3/{$result[$rows][wr_id]}"
이부분은 첫번째 이미지를 썸네일시킨것을 불러오는코드이고
<?= $result[$rows]?sprintf("/data/file/%s/%s", $bo_table, $result[$rows]['bf_file']
이건 첫번째 원본을 불러오는 코드입니다.
여기서 첫번째 원본을 불러오는 코드에 첫번째 원본이 아닌 두번째 원본을 불러오고 싶습니다...
방법을 모르겟어요 ㅡㅜ 늦어도 10시까지 해결을 해야하는데 ........
좀 봐주세요...부탁드려요~
댓글 전체
$result[$rows]['bf_file']-->$result[1]['bf_file']
$rows를 1 로 바꾸면 됩니다
$rows를 1 로 바꾸면 됩니다
안되요;;;;; 1로 바꾸니 작은 썸네일을 오버해도 하나의 엉뚱한 이미지만 나옵니다......