[산이]님이 남기신 글:
>[duri]님이 남기신 글:
>
>>도움을 주셔서 항상 감사합니다^^
>>
>>이번 문제는 뭔가하믄....
>>
>>예전에 php3를 사용하다가 이번에 서버 이전하믄서 php4로
바꿨습니다.
>>그런데 그 이후로 오류는 없는데 웹에서 안 보이는 페이지가
있는데....
>>
>>3과 4의 소스상 조심해줘야 하는 것이 있나요??
>
>========================================
>
>
>전 PHP에 대해서 전문가가 아니라서
>딱 잘라 말하기 어렵군요..
>
>다만 테스트하고
>에러난 부분에 대해서 골똘히 생각하고
>해당 함수를 참조할 뿐이지요..
>
>포스팅한 소스에는 이상없습니다.
>
>다만
>
>PeopleList()
>BannerOut()
>
>함수가 없기 때문에
>
>테스트가 안됩니다.
>어떻게 구성되어 있는지 포스팅해 주세요..
========================================
배너는 보이거든요... people 파일만 올릴께요...
<?
include "./connect/peopleconf.php3";
$connect=mysql_connect("$host_name","$user_name","$user_pas
swd") or die('DB Server connect failed');
mysql_select_db("$db_name") or die("DB connect failed");
/* ====================================================================== */
/* 에러메세지 출력 함수
*/
/* void ErrorMsg ( string $msg ) */
/* Return void */
/* ---------------------------------------------------------------------- */
function Error_Msg( $msg )
{
echo "<script>\n";
echo "window.alert( '$msg' );";
echo "history.go(-1);";
echo "</script>";
exit;
}
function PeopleList($title,$board,$maxnum)
{
global $connect;
$today=date("Y-m-d"); // 오늘 날짜를 구해옵니다.
if($board=="whobbs")
{
$query="SELECT
id,name,find,age,subject,DATE_FORMAT(reg_date,'Y-m-d') FROM $board ORDER
BY reg_date DESC LIMIT $maxnum";
$result = mysql_query($query,$connect);
$total = mysql_affected_rows();
echo "<table width='544' border=0 cellpadding=5
cellspacing=0>\n";
echo " <tr>\n";
echo " <td><p>\n";
echo "
<fieldset style='padding:5;
border-width:1;border-color:black;border-style:solide;'>
<legend>
<font color=magenta
size=3>♥ <b>$title</b></font> - <a
href='./people/bbs.php3?board=$board'>[전체보기]</a>
</legend>";
echo "<table width=100%>\n";
for($i=0;$i<$total;$i++)
{
$rows = mysql_fetch_array($result); //레코드를 빼옵니다.
$name = stripslashes($rows[1]); //다음표와 홑따음표에 붙었던 \를
제거
$fine = stripslashes($rows[2]); //다음표와 홑따음표에 붙었던 \를
제거
$age = stripslashes($rows[3]); //다음표와 홑따음표에 붙었던 \를
제거
$subject = stripslashes($rows[4]); //다음표와 홑따음표에 붙었던
\를 제거
$time = stripslashes($rows[5]); //다음표와 홑따음표에 붙었던 \를
제거
echo "<tr>";
echo " <td nowrap valign=middle><font size=2
color=#6363FF> ▶</font> [$name]->";
echo " [$fine]</td>";
echo " <td width=1024 valign=middle><a href='#'
onClick='window.open(\"notice_view.php3?board=$board&id=$rows[0]\",\&
quot;\",\"scrollbars=yes,width=500,height=400\")'> $subject
</a></td>";
if($rows[1] == $today)
echo "<td nowrap valign=middle align=center><span
class=hard>$time</span><br>\n</td>";
else
echo "<td nowrap valign=middle
align=center>$time<br>\n</td>";
echo "</tr>";
}
echo "</table>\n";
echo "</td>";
echo "</tr>";
echo "</fielsset>\n";
echo "</table>\n";
}
/*
elseif($board=="notice")
{
$query="SELECT id,name,subject,DATE_FORMAT(reg_date,'Y-m-d') FROM
$board ORDER BY reg_date DESC LIMIT $maxnum";
$result = mysql_query($query,$connect);
$total = mysql_affected_rows();
echo "<table width='544' border=0 cellpadding=4 cellspacing=5
>\n";
echo " <tr>\n";
echo " <td align=center><img
src='$image_path/line/l-001.gif' width=540 height=23
border=0></td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td bgcolor='#FF9565'><p>\n";
echo " <font color=white>★</font>
<b>$title-</b><a
href='./people/bbs.php3?board=$board'>[전체보기]</a>
";
echo " </td></tr>\n";
echo "</table>\n";
echo "<table width='544' border=0 cellpadding=4
cellspacing=0>\n";
echo " <tr><td>\n";
if
echo " <fieldset style='padding:5;
border-width:1;border-color:blue;border-style:solide;'>";
echo "<table width=100%>\n";
for($i=0;$i<$total;$i++)
{
$rows = mysql_fetch_array($result); //레코드를 빼옵니다.
$name = stripslashes($rows[1]); //다음표와 홑따음표에 붙었던 \를
제거
$subject = stripslashes($rows[2]); //다음표와 홑따음표에 붙었던
\를 제거
$time = stripslashes($rows[3]); //다음표와 홑따음표에 붙었던 \를
제거
echo "<tr>";
echo " <td width=1024 valign=middle>
<font size=2 color=#6363FF> ▶</font>
<font size=2 color=#63639C>
<a href='#'
onClick='window.open(\"notice_view.php3?board=$board&id=$rows[0]\",\&
quot;\",\"scrollbars=yes,width=500,height=500\")'>
$subject </a></font></td>";
if($board != "notice")
echo " <td nowrap valign=middle> [$name] ";
if($rows[1] == $today)
echo "<td nowrap valign=middle align=center><span
class=hard>$time</span><br>\n</td>";
else
echo "<td nowrap valign=middle
align=center>$time<br>\n</td>";
echo "</tr>";
}
echo "</table>\n";
echo "</fielsset>\n";
echo "</td>";
echo "</tr>";
echo "</table>\n";
}
*/
else
{
$query="SELECT id,name,subject,DATE_FORMAT(reg_date,'Y-m-d') FROM
$board ORDER BY reg_date DESC LIMIT $maxnum";
$result = mysql_query($query,$connect);
$total = mysql_affected_rows();
echo "<table width='544' border=0 cellpadding=5
cellspacing=0>\n";
echo " <tr>\n";
echo " <td><p>\n";
if($board=="notice")
echo " <fieldset style='padding:5;
border-width:2;border-color:cyan;border-style:solide;'> <legend> <font
color=blue size=3>★ <b>$title</b></font> - <a
href='./people/bbs.php3?board=$board'>[전체보기]</a>
</legend>";
elseif($board=="anabada")
echo " <fieldset style='padding:5;
border-width:2;border-color:balck;border-style:solide;'> <legend> <font
color=magenta size=3>★ <b>$title</b></font> - <a
href='./people/bbs.php3?board=$board'>[전체보기]</a>
</legend>";
else
echo " <fieldset style='padding:5;
border-width:1;border-color:black;border-style:solide;'> <legend> <font
color=green size=3>★ <b>$title</b></font> - <a
href='./people/bbs.php3?board=$board'>[전체보기]</a>
</legend>";
echo "<table width=100%>\n";
for($i=0;$i<$total;$i++)
{
$rows = mysql_fetch_array($result); //레코드를 빼옵니다.
$name = stripslashes($rows[1]); //다음표와 홑따음표에 붙었던 \를
제거
$subject = stripslashes($rows[2]); //다음표와 홑따음표에 붙었던
\를 제거
$time = stripslashes($rows[3]); //다음표와 홑따음표에 붙었던 \를
제거
echo "<tr>";
echo " <td width=1024 valign=middle>
<font size=2 color=#6363FF> ▶</font>
<font size=2 color=#63639C>
<a href='#'
onClick='window.open(\"./notice/notice_view.php3?board=$board&id=$rows[0]\
",\"\",\"scrollbars=yes,width=550,height=400\")'>
$subject </a></font></td>";
if($board != "notice")
echo " <td nowrap valign=middle> [$name] ";
if($rows[1] == $today)
echo "<td nowrap valign=middle align=center><span
class=hard>$time</span><br>\n</td>";
else
echo "<td nowrap valign=middle
align=center>$time<br>\n</td>";
echo "</tr>";
}
echo "</table>\n";
echo "</fielsset>\n";
echo "</td>";
echo "</tr>";
echo "</table>\n";
}
}
function Calender()
{
$date=01;
$day=01;
$off=0;
if(!$year) {$year=date('Y');}
if(!$month) {$month=date('m');}
$toyear = date('Y');
$tomonth = date('m');
$today = date('d');
while(checkdate($month,$date,$year)):
$date++;
endwhile;
echo "<table width=140 board=0 cellspacing=1 cellpadding=2>";
echo "<tr align = center valign=middle>
<td colspan=7 class=title>
$year/$month
</td>
</tr>";
echo "<tr align=center valign=middle class=semi>
<td bgcolor=#FFCCFF>일</td>
<td>월</td>
<td>화</td>
<td>수</td>
<td>목</td>
<td>금</td>
<td bgcolor=#CCFFCC>토</td>
</tr>";
echo "<tr>";
while($day<$date):
if($day==$today && $year == $toyear && $month == $tomonth)
{$day_color="blue";}
else {$day_color="black";}
if($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Sunday')
{ echo "<td><font color=$day_color>$day</font></td>";
$off='01'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Monday')
{ echo "<td> </td><td><font
color=$day_color>$day</font></td>"; $off='02'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Tuesday')
{ echo "<td> </td><td> </td><td><font
color=$day_color>$day</font></td>";
$off='03'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Wednesday')
{ echo
"<td> </td><td> </td><td> </td><td><font
color=$day_color>$day</font></td>"; $off='04'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Thursday')
{ echo
"<td> </td><td> </td><td> </td><td> </t
d><td><font color=$day_color>$day</font></td>";
$off='05'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Friday')
{ echo
"<td> </td><td> </td><td> </td><td> </t
d><td> </td><td><font color=$day_color>$day</font></td>";
$off='06'; }
elseif($day == '01' and
date('1',mktime(0,0,0,$month,$day,$year)) == 'Saturday')
{ echo
"<td> </td><td> </td><td> </td><td> </t
d><td> </td><td> </td><td><font
color=$day_color>$day</font></td>"; $off='07'; }
else{ echo "<td><font color=$day_color>$day</font></td>";
}
$day++;
$off++;
if($off > 7) { echo "</tr><tr>"; $off='01';}
else { echo ""; }
endwhile;
for($i=$off ; $i<=7 ; $i++) { echo "<td> </td>";}
echo "</tr>";
echo "</table>";
}
/* ErrorMsg End --------------------------------------------------------- */
/* ====================================================================== */
/* 메세지 출력함수 */
/* function Msg($msg) */
/* Return void */
/* ====================================================================== */
function Msg($msg) {
echo("<script>
window.alert('$msg')
history.go(-1)
</script>");
exit;
}
/* ====================================================================== */
/* 최종 쓰레드값 검색 함수
*/
/* void MaxThred( void ) */
/* Return int Max Thred Value */
/* ---------------------------------------------------------------------- */
function MaxThred()
{
global $board, $connect;
$query = "SELECT MAX(thred) FROM $board";
$result = mysql_query( $query , $connect ) or ErrorMsg("최종값
검색에 실패했습니다.");
if($rows = mysql_fetch_array( $result ))
$max_thred = $rows[0] + 1;
else
$max_thred = 0;
return $max_thred;
}
/* MaxThred End --------------------------------------------------------- */
/*
·‥…¨〃―∥\∼‘’“”′″〔〕〈〉《》「」『』【】
※
¶
℃Å¢£¥°。‰℉∀∃∏∂∇∮§
±×÷≠≤≥∞∴≡≒√∽∝∵∫∬∈∋⊆⊇⊂⊃∪∩∧∨∑∠⊥
→←↑↓↔⇒⇔↕↗↙↖↘♭♩♪♬♂♀†‡
☆
★
○●◎◇◆□■△▲▽▼¤♨☏☎
☜
☞
㉿
㈜
◁
◀
▷
▶
♤♠♡
♥
♧¡¿~ˇ˘⌒˚♣⊙◈▣◐◑▒▤▥▨▧▦▩
ⅰⅱⅲⅳⅴⅵⅶⅷⅸⅹⅠⅡⅢⅣⅤⅥⅦⅧⅨⅩ
æΔΦΨΩαβγδεζηθικλμνξοπρστυφχψω
㎕㎖㎗ℓ㎘㏄㎣㎤㎥㎦㎛㎟㎠㎡㎢㏊㎍㏈㎧㎨㎰㎶Ω㎮㎯㏆
㉠㉡㉢㉣㉤㉥㉦㉧㉨㉩㉪㉫㉬㉭㉮㉯㉰㉱㉲㉳㉴㉵㉶㉷㉸㉹㉺㉻
ⓐⓑⓒⓓⓔⓕⓖⓗⓘⓙⓚⓛⓜⓝⓞⓟⓠⓡⓢⓣⓤⓥⓦⓧⓨⓩ
①②③④⑤⑥⑦⑧⑨⑩⑪⑫⑬⑭⑮
½⅓⅔¼¾⅛⅜⅝⅞¹²³⁴ⁿ₁₂₃
*/
?>
|