m

mando 님의 새등록사이트에서..

아래는 만도님의 새등록사이트를 제 홈에 응용한 것입니다.
(화일도 올려놓았습니다.)
적용된 곳은 링크의 왼쪽부분입니다.

그런데 등록할 때에 두번째 파일에는 배너를 넣고 이것을 불러오고자 합니다.
말하자면 만도님의 소스는 첫번째이미지파일을 기준으로 작동하는데,
저는 두번째올리는 이미지화일을 기준으로 작동하게 하고 싶습니다.

이리저리 만저보아도 저로서는 두손들 수 밖에 없었습니다.
고수님들!!! 한번 손봐주세요...*^^*

-------------------------------------------------------------------
<?
//if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");

if ($hours < 1 || $hours > 24) {
$hours = 288888; //288시간내에.. 올라온 새글...
}
$li = 3; //몇개뽑을건가..

$thumbx = 170;
$thumby = 150;

// 이미지파일의 x, y 사이즈 계산하여 리턴
function mandoS_image_size($x, $y, $thumbx, $thumby) {
if($x > $thumbx) {
$overx = ($x - $thumbx) / $x;
$x = $thumbx;
$y = intval($y - ($y * $overx));
}
if($y > $thumby) {
$overy = ($y - $thumby) / $y;
$y = $thumby;
$x = intval($x - ($x * $overy));
}

return array('x'=>$x, 'y'=>$y);
}


?>

<table width=95% cellpadding=0 cellspacing=0 align="center">
<tr>
<td width='100%' valign=top align=center>

<?
$intime = date("Y-m-d H:i:s", time() - (int)(60 * 60 * $hours));
$gr_id = "Link";
$sql = " select bo_table, bo_subject from $cfg[table_board] where gr_id='$gr_id' order by bo_order_search ";
$result = sql_query($sql);

while ($row = mysql_fetch_array($result)) {
/*
//제외게시판 ||(or) 로 구분합다
if($row[bo_table]==knowledge||$row[bo_table]==report||$row[bo_table]==movie||$row[bo_table]==eng||$row[bo_table]==notice||
$row[bo_table]==sales||$row[bo_table]==qna||$row[bo_table]==icon_appl||$row[bo_table]==winee_column||$row[bo_table]==ojay_column||
$row[bo_table]==humor||$row[bo_table]==juan||$row[bo_table]==victor||$row[bo_table]==jack||$row[bo_table]==tiptech||$row[bo_table]==news||
$row[bo_table]==free_board||$row[bo_table]==search_link||$row[bo_table]==coolsite||$row[bo_table]==knowhow||$row[bo_table]==empty_room||$row[bo_table]==add||$row[bo_table]==music
||$row[bo_table]==gallery||$row[bo_table]==appl
){}
else
*/
{


$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select wr_id,
wr_parent_id,
mb_id,
wr_name,
wr_email,
wr_homepage,
wr_num,
wr_subject,
wr_content,
wr_comment,
wr_commentcnt,
wr_datetime,
wr_file1,
wr_file2,
wr_link1,
wr_link2,
wr_hit
from $tbl
where wr_datetime >= '$intime'
and wr_comment = '0'
order by wr_id desc";
$result2 = sql_query($sql2);

for ($i = 0; $row2 = mysql_fetch_array($result2); $i++) {


/*
if ($row2[wr_comment] > 0) {
$sql3 = " select wr_subject
from $tbl
where wr_comment = 0
and wr_parent_id = '$row2[wr_parent_id]' ";
$row3 = sql_fetch($sql3);
$wr_subject = $row3[wr_subject];
} else {
$wr_subject = $row2[wr_subject];
}
$wr_subject = get_text($wr_subject);
*/
$wr_subject = get_text($row2[wr_subject]);

$key = $row2[wr_datetime] . $row[bo_table] . $row2[wr_id];
//$row[bo_table]=$bo_table;
//$qstr="bo_table=$row[bo_table]";
$list[$key]->bo_subject = $row[bo_subject];
$list[$key]->bo_table = $row[bo_table];
$list[$key]->mb_id = $row2[mb_id];
$list[$key]->mb_open = $row2[mb_open];
$list[$key]->wr_id = $row2[wr_id];
$list[$key]->wr_parent_id = $row2[wr_parent_id];
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_homepage = $row2[wr_homepage];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],18));
$list[$key]->wr_subject = get_text(cut_str($wr_subject,14,'..'));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_content = cut_str(strip_tags($row2[wr_content]),67);
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = $row2[wr_datetime];
$list[$key]->wr_hit = $row2[wr_hit];
//파일, 링크
$list[$key]->file_image1 = "./data/file/$row[bo_table]/".$row2[wr_file1];
$list[$key]->file_image2 = "./data/file/$bo_table/" . $row2[wr_file2];
$list[$key]->link1 = set_http(get_text(cut_str($row2[wr_link1], 14, '..')));
$link[$key]->link_href1 = "./?doc=bbs/gblink.php&bo_table=$row[bo_table]&wr_id=$row2[wr_id]&index=1";
$link[$key]->link_href11 = "./?doc=bbs/gnuboard.php&bo_table=$row[bo_table]";
$list[$key]->link2 = set_http(get_text(cut_str($row2[wr_link2], 14)));
$link[$key]->link_href2 = "./?doc=bbs/gblink.php&bo_table=$row[bo_table]&wr_id=$row2[wr_id]&index=2";




}
mysql_free_result($result2);

}//else
}
mysql_free_result($result);
?>
<!--<DIV style='width:100%;valign:top; height:30px;overflow:hidden;border:0;padding:0;top:-14px;'>-->
<!--<marquee id="iescroller" direction="up" width="428" height="860" scrollamount="1" scrolldelay="100" onmouseover="this.stop()" onmouseout="this.start()" > -->
<table width="100%" align="center" valign=top cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="30" valign=top align=center>
<!--<div id="divSC0" style="valign:top; width:428px; height:600px; position:absolute; left:-2px; top:0px; z-index:20; visibility:visible; ">
<div align="left">-->
<table width=100% align=center cellpadding=0 cellspacing=0 border=0>
<tr><td class=line_menu></td></tr>
<tr><td width=100% valign=middle class=bg_menu align=center><b><span style='font-size:13px; font-face:굴림;'>최근등록사이트</span></b></td></tr>
<tr><td class=line_menu></td></tr></table>
<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>
<?
if (count($list) > 0) {
$p=-1;
krsort($list);
foreach ($list as $key=>$value) {
$destfile = $value->file_image1.'mandoThumbS';
$size = @getimagesize($value->file_image1);
if(is_array($size) && !is_file($destfile)) {
switch($size[2]) {
case(1) :
if(function_exists('ImageCreateFromGif')) $im = ImageCreateFromGif($value->file_image1);
break;
case(2) :
if(function_exists('ImageCreateFromJpeg')) $im = ImageCreateFromJpeg($value->file_image1);
break;
case(3) :
if(function_exists('ImageCreateFromPng')) $im = ImageCreateFromPng($value->file_image1);
break;
}
$fixsize = mandoS_image_size($size[0], $size[1], $thumbx, $thumby);
if($im) {
if($i==0) @exec("rm ".dirname($_SERVER[SCRIPT_FILENAME])."/data/file/$bo_table/*mandoThumbS -rf");
if(function_exists('ImageCreateTrueColor')) $newim = ImageCreateTrueColor($fixsize[x],$fixsize[y]);
else $newim = ImageCreate($fixsize[x],$fixsize[y]);
if(function_exists('ImageCopyResampled')) ImageCopyResampled($newim,$im,0,0,0,0,$fixsize[x],$fixsize[y],$size[0],$size[1]);
else ImageCopyResized($newim,$im,0,0,0,0,$fixsize[x],$fixsize[y],$size[0],$size[1]);
ImageDestroy($im);
ImageJpeg($newim, $destfile, 90);
ImageDestroy($newim);
unset($im, $newim);
}
$list[$i][img][x] = $fixsize[x];
$list[$i][img][y] = $fixsize[y];
} else {
if(is_file($destfile)) {
$size = getimagesize($destfile);
$list[$i][img][x] = $size[0];
$list[$i][img][y] = $size[1];
} else {
$value->file_image1 = "$latest_skin/noimg.gif";
$size = getimagesize($value->file_image1);
$list[$i][img][x] = $size[0];
$list[$i][img][y] = $size[1];
}
}
if(is_file($destfile)) $value->file_image1 = $destfile;
if(time()-(60*60*24) <= strtotime($list[$i][wr_datetime])) $list[$i][date] = date('H:i',strtotime($list[$i][wr_datetime]));
else $list[$i][date] = date('Y.m.d',strtotime($list[$i][wr_datetime]));

$p++;
if ($p >= $li) break;
$comment = "";
$atag_comment = "";
if ($value->wr_comment > 0) {
$comment = "<span style='font-size:8pt;'>[c]</span> ";
$atag_comment = "#c{$value->wr_id}";
}

$commentcnt = "";
if ($value->wr_commentcnt > 0) {
$commentcnt = "<font size=-2>({$value->wr_commentcnt})</font>";
}

$name = gblayer($value->mb_id, cut_str($value->wr_name,12), $value->wr_email, $value->wr_homepage);

$value->bo_subject = cut_str($value->bo_subject, 20);

//$list = $i++%2;

echo "<tr align=center>";
echo "<td width=170 align=center style='padding-top:5; padding-right:3; padding-bottom:3;'><img src='{$value->file_image1}' width='{$list[$i][img][x]}' height='{$list[$i][img][y]}' style='border:1px solid #7d9438;'></td>";
echo "</tr>";
echo "<tr><td style='padding-bottom:2;'>&nbsp;
<a href='./?doc={$cfg[bbs_dir]}/gnuboard.php&bo_table={$value->bo_table}&wr_id={$value->wr_parent_id}{$atag_comment}' style='font-weight:plane;font-size:12px;color:#335495'>{$value->wr_subject}</a><br>&nbsp;
<a href='{$link[$key]->link_href1}' target='_blank' style='font-weight:plane;font-size:11px;color:#FF7800'>{$value->link1 }</a>
</td></tr>";
echo "</tr>";

}
} else
echo "<td height=100 align=center colspan=4>등록된 글이 없습니다.</td>";
?>
</table>
<!--</div>
</div> -->
</td></tr></table>
<!--</marqee>
</div>-->
</td>

</tr>
</table>

첨부파일

newsite_link.php (9.5 KB) 1회 2005-06-16 23:47
|

댓글 1개

맞는지 모르겠어요.
아무튼 다음과 같이 하니 됩니다.
고수님들이 손좀 봐주시면 좋은데....
---------------------------------------------------------------------------
<?
//if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");

if ($hours < 1 || $hours > 24) {
$hours = 288888; //288시간내에.. 올라온 새글...
}
$li = 8; //몇개뽑을건가..

$thumbx = 150;
$thumby = 130;

// 이미지파일의 x, y 사이즈 계산하여 리턴
function mandoS_image_size($x, $y, $thumbx, $thumby) {
if($x > $thumbx) {
$overx = ($x - $thumbx) / $x;
$x = $thumbx;
$y = intval($y - ($y * $overx));
}
if($y > $thumby) {
$overy = ($y - $thumby) / $y;
$y = $thumby;
$x = intval($x - ($x * $overy));
}

return array('x'=>$x, 'y'=>$y);
}


?>

<table width=95% cellpadding=0 cellspacing=0 align="center">
<tr>
<td width='100%' valign=top align=center>

<?
$intime = date("Y-m-d H:i:s", time() - (int)(60 * 60 * $hours));
$gr_id = "Link";
$sql = " select bo_table, bo_subject from $cfg[table_board] where gr_id='$gr_id' order by bo_order_search ";
$result = sql_query($sql);

while ($row = mysql_fetch_array($result)) {
/*
//제외게시판 ||(or) 로 구분합다
if($row[bo_table]==knowledge||$row[bo_table]==report||$row[bo_table]==movie||$row[bo_table]==eng||$row[bo_table]==notice||
$row[bo_table]==sales||$row[bo_table]==qna||$row[bo_table]==icon_appl||$row[bo_table]==winee_column||$row[bo_table]==ojay_column||
$row[bo_table]==humor||$row[bo_table]==juan||$row[bo_table]==victor||$row[bo_table]==jack||$row[bo_table]==tiptech||$row[bo_table]==news||
$row[bo_table]==free_board||$row[bo_table]==search_link||$row[bo_table]==coolsite||$row[bo_table]==knowhow||$row[bo_table]==empty_room||$row[bo_table]==add||$row[bo_table]==music
||$row[bo_table]==gallery||$row[bo_table]==appl
){}
else
*/
{


$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select wr_id,
wr_parent_id,
mb_id,
wr_name,
wr_email,
wr_homepage,
wr_num,
wr_subject,
wr_content,
wr_comment,
wr_commentcnt,
wr_datetime,
wr_file1,
wr_file2,
wr_link1,
wr_link2,
wr_hit
from $tbl
where wr_datetime >= '$intime'
and wr_comment = '0'
order by wr_id desc";
$result2 = sql_query($sql2);

for ($i = 2; $row2 = mysql_fetch_array($result2); $i++) {


/*
if ($row2[wr_comment] > 0) {
$sql3 = " select wr_subject
from $tbl
where wr_comment = 0
and wr_parent_id = '$row2[wr_parent_id]' ";
$row3 = sql_fetch($sql3);
$wr_subject = $row3[wr_subject];
} else {
$wr_subject = $row2[wr_subject];
}
$wr_subject = get_text($wr_subject);
*/
$wr_subject = get_text($row2[wr_subject]);

$key = $row2[wr_datetime] . $row[bo_table] . $row2[wr_id];
//$row[bo_table]=$bo_table;
//$qstr="bo_table=$row[bo_table]";
$list[$key]->bo_subject = $row[bo_subject];
$list[$key]->bo_table = $row[bo_table];
$list[$key]->mb_id = $row2[mb_id];
$list[$key]->mb_open = $row2[mb_open];
$list[$key]->wr_id = $row2[wr_id];
$list[$key]->wr_parent_id = $row2[wr_parent_id];
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_homepage = $row2[wr_homepage];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],18));
$list[$key]->wr_subject = get_text(cut_str($wr_subject,22,'..'));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_content = cut_str(strip_tags($row2[wr_content]),67);
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = $row2[wr_datetime];
$list[$key]->wr_hit = $row2[wr_hit];
//파일, 링크
$list[$key]->file_image1 = "./data/file/$row[bo_table]/".$row2[wr_file1];
$list[$key]->file_image2 = "./data/file/$row[bo_table]/" . $row2[wr_file2];
$list[$key]->link1 = set_http(get_text(cut_str($row2[wr_link1], 24, '..')));
$link[$key]->link_href1 = "./?doc=bbs/gblink.php&bo_table=$row[bo_table]&wr_id=$row2[wr_id]&index=1";
$link[$key]->link_href11 = "./?doc=bbs/gnuboard.php&bo_table=$row[bo_table]";
$list[$key]->link2 = set_http(get_text(cut_str($row2[wr_link2], 24)));
$link[$key]->link_href2 = "./?doc=bbs/gblink.php&bo_table=$row[bo_table]&wr_id=$row2[wr_id]&index=2";




}
mysql_free_result($result2);

}//else
}
mysql_free_result($result);
?>
<!--<DIV style='width:100%;valign:top; height:30px;overflow:hidden;border:0;padding:0;top:-14px;'>-->
<!--<marquee id="iescroller" direction="up" width="428" height="860" scrollamount="1" scrolldelay="100" onmouseover="this.stop()" onmouseout="this.start()" > -->
<table width="100%" align="center" valign=top cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="30" valign=top align=center>
<!--<div id="divSC0" style="valign:top; width:428px; height:600px; position:absolute; left:-2px; top:0px; z-index:20; visibility:visible; ">
<div align="left">-->
<table width=100% align=center cellpadding=0 cellspacing=0 border=0>
<tr><td class=line_menu></td></tr>
<tr><td width=100% valign=middle class=bg_menu align=center><b><span style='font-size:13px; font-face:굴림;'>최근등록사이트</span></b></td></tr>
<tr><td class=line_menu></td></tr></table>
<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>
<?
if (count($list) > 0) {
$p=-1;
krsort($list);
foreach ($list as $key=>$value) {
$destfile = $value->file_image2.'mandoThumbS';
$size = @getimagesize($value->file_image2);
if(is_array($size) && !is_file($destfile)) {
switch($size[2]) {
case(1) :
if(function_exists('ImageCreateFromGif')) $im = ImageCreateFromGif($value->file_image2);
break;
case(2) :
if(function_exists('ImageCreateFromJpeg')) $im = ImageCreateFromJpeg($value->file_image2);
break;
case(3) :
if(function_exists('ImageCreateFromPng')) $im = ImageCreateFromPng($value->file_image2);
break;
}
$fixsize = mandoS_image_size($size[0], $size[1], $thumbx, $thumby);
if($im) {
if($i==2) @exec("rm ".dirname($_SERVER[SCRIPT_FILENAME])."/data/file/$bo_table/*mandoThumbS -rf");
if(function_exists('ImageCreateTrueColor')) $newim = ImageCreateTrueColor($fixsize[x],$fixsize[y]);
else $newim = ImageCreate($fixsize[x],$fixsize[y]);
if(function_exists('ImageCopyResampled')) ImageCopyResampled($newim,$im,0,0,0,0,$fixsize[x],$fixsize[y],$size[0],$size[1]);
else ImageCopyResized($newim,$im,0,0,0,0,$fixsize[x],$fixsize[y],$size[0],$size[1]);
ImageDestroy($im);
ImageJpeg($newim, $destfile, 90);
ImageDestroy($newim);
unset($im, $newim);
}
$list[$i][img][x] = $fixsize[x];
$list[$i][img][y] = $fixsize[y];
} else {
if(is_file($destfile)) {
$size = getimagesize($destfile);
$list[$i][img][x] = $size[0];
$list[$i][img][y] = $size[1];
} else {
$value->file_image2 = "$latest_skin/noimg.gif";
$size = getimagesize($value->file_image2);
$list[$i][img][x] = $size[0];
$list[$i][img][y] = $size[1];
}
}
if(is_file($destfile)) $value->file_image2 = $destfile;
if(time()-(60*60*24) <= strtotime($list[$i][wr_datetime])) $list[$i][date] = date('H:i',strtotime($list[$i][wr_datetime]));
else $list[$i][date] = date('Y.m.d',strtotime($list[$i][wr_datetime]));

$p++;
if ($p >= $li) break;
$comment = "";
$atag_comment = "";
if ($value->wr_comment > 0) {
$comment = "<span style='font-size:8pt;'>[c]</span> ";
$atag_comment = "#c{$value->wr_id}";
}

$commentcnt = "";
if ($value->wr_commentcnt > 0) {
$commentcnt = "<font size=-2>({$value->wr_commentcnt})</font>";
}

$name = gblayer($value->mb_id, cut_str($value->wr_name,22), $value->wr_email, $value->wr_homepage);

$value->bo_subject = cut_str($value->bo_subject, 30);

//$list = $i++%2;

echo "<tr align=center>";
echo "<td width=170 align=center style='padding-top:5; padding-right:3; padding-bottom:3;'><img src='{$value->file_image2}' width='{$list[$i][img][x]}' height='{$list[$i][img][y]}' style='border:1px solid #7d9438;'></td>";
echo "</tr>";
echo "<tr><td style='padding-bottom:2;'>&nbsp;
<a href='./?doc={$cfg[bbs_dir]}/gnuboard.php&bo_table={$value->bo_table}&wr_id={$value->wr_parent_id}{$atag_comment}' style='font-weight:plane;font-size:12px;color:#335495'>{$value->wr_subject}</a><br>&nbsp;
<a href='{$link[$key]->link_href1}' target='_blank' style='font-weight:plane;font-size:11px;color:#FF7800'>{$value->link1 }</a>
</td></tr>";
echo "</tr>";

}
} else
echo "<td height=100 align=center colspan=4>등록된 글이 없습니다.</td>";
?>
</table>
<!--</div>
</div> -->
</td></tr></table>
<!--</marqee>
</div>-->
</td>

</tr>
</table>
댓글을 작성하시려면 로그인이 필요합니다. 로그인

그누3질답

+
제목 글쓴이 날짜 조회
20년 전 조회 1,016
20년 전 조회 1,133
20년 전 조회 1,474
20년 전 조회 2,650
20년 전 조회 1,353
20년 전 조회 1,380
20년 전 조회 1,037
20년 전 조회 1,230
20년 전 조회 1,036
20년 전 조회 1,114
20년 전 조회 1,038
20년 전 조회 1,024
20년 전 조회 1,234
20년 전 조회 1,091
20년 전 조회 957
20년 전 조회 1,217
20년 전 조회 1,084
20년 전 조회 1,156
20년 전 조회 1,096
20년 전 조회 1,314
🐛 버그신고