g4용으로 바꿀려면 정보
g4용으로 바꿀려면
본문
아래와 같은 소스로 g3에서 사용중인데 아무리 해도 G4용으로는 바뀌질 안는군요.
화면이 백색에 소스도 없이 나와서 어디서 잘못 되었는지도 알 수가 없고요.
혹여 아시는 분 계시다면 변환좀 부탁드립니다.
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "DESIGN");
// 접근 권한 검사
if (!$member[mb_id]) {
alert("최고관리자로 로그인 하십시오.", "./?doc=bbs/mblogin.php&url=" . urlencode("./?doc=$doc"));
} else if (_GNUADMIN_ == "DEFAULT" && $is_admin != "default") {
alert("최고관리자만 접근 가능합니다.", "./");
} else {
if ($is_admin != "default") {
$sql = " select count(*) from $cfg[table_group] where gr_admin = '$member[mb_id]' ";
$row = sql_fetch($sql);
if ($row[0]) {
$is_admin = "group";
}
}
if (!($is_admin == "default" || $is_admin == "group")) {
alert("그룹관리자 이상 접근 가능합니다.", "./?doc=new_hit.php");
}
}
mysql_query("DROP TABLE IF EXISTS gb_write_2004hit");
mysql_query("CREATE TABLE gb_write_2004hit (
wr_num int(11) NOT NULL auto_increment,
ca_id int(11) NOT NULL default '0',
wr_id int(11) NOT NULL default '0',
wr_reply varchar(10) NOT NULL default '',
wr_parent_id int(11) NOT NULL default '0',
wr_comment int(11) NOT NULL default '0',
wr_commentcnt int(11) NOT NULL default '0',
wr_subject varchar(255) NOT NULL default '',
wr_content text NOT NULL,
wr_hit int(11) NOT NULL default '0',
wr_good int(11) NOT NULL default '0',
wr_nogood int(11) NOT NULL default '0',
mb_id varchar(20) NOT NULL default '',
wr_name varchar(20) NOT NULL default '',
wr_email varchar(255) NOT NULL default '',
wr_homepage varchar(255) NOT NULL default '',
wr_datetime datetime NOT NULL default '0000-00-00 00:00:00',
wr_ip varchar(15) NOT NULL default '',
bo_subject varchar(255) NOT NULL default '',
bo_table varchar(255) NOT NULL default '',
PRIMARY KEY (wr_num),
KEY index1 (wr_id,wr_parent_id),
KEY index2 (wr_hit),
KEY index3 (wr_datetime)
)");
?>
<br>
<table width=100% cellpadding=3 cellspacing=0>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
<tr><td class='subject subjectbg ht'> <?=$html_title?></td></tr>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
</table>
<p>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width='' valign=top>
<?
$intime = date("2004-01-01 00:00:00");
$fromtime = date("2004-12-31 00:00:00");
$sql = " select bo_subject, bo_table
from $cfg[table_board]
where bo_use_search = '1'
order by bo_order_search ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select wr_id,
ca_id,
wr_num,
wr_reply,
wr_parent_id,
wr_comment,
wr_commentcnt,
mb_id,
wr_name,
wr_subject,
wr_content,
wr_good,
wr_nogood,
wr_email,
wr_homepage,
wr_datetime,
wr_ip,
wr_hit
from $tbl
where wr_datetime >= '$intime' and wr_datetime <= '$fromtime'
order by wr_hit desc limit 30";
$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);
$key = $row2[wr_hit] . $row[bo_table] . $row2[wr_id];
$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_reply = $row2[wr_reply];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],12));
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_homepage = $row2[wr_homepage];
$list[$key]->wr_subject = get_text(cut_str($wr_subject,80,'…'));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = $row2[wr_datetime];
$list[$key]->wr_hit = $row2[wr_hit];
$list[$key]->wr_good = $row2[wr_good];
$list[$key]->wr_nogood = $row2[wr_nogood];
}
mysql_free_result($result2);
}
mysql_free_result($result);
?>
<?
if (count($list) > 0) {
krsort($list);
foreach ($list as $key=>$value) {
$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);
$sql = "insert into gb_write_2004hit
set
bo_subject = '$value->bo_subject',
bo_table = '$value->bo_table',
wr_id = '$value->wr_id',
wr_parent_id = '$value->wr_parent_id',
wr_comment = '$value->wr_comment',
wr_commentcnt = '$value->wr_commentcnt',
wr_reply = '$value->wr_reply',
wr_email = '$value->wr_email',
wr_homepage = '$value->wr_homepage',
wr_subject = '$value->wr_subject',
wr_hit = '$value->wr_hit',
wr_good = '$value->wr_good',
wr_nogood = '$value->wr_nogood',
mb_id = '$value->mb_id',
wr_name = '$value->wr_name',
wr_datetime= '$value->wr_datetime'";
sql_query($sql);
}
echo "저장하였습니다.";
gotourl("./?doc=new_2004hit.php");
} else
echo "등록된 글이 없습니다.";
?>
</td></tr></table>
화면이 백색에 소스도 없이 나와서 어디서 잘못 되었는지도 알 수가 없고요.
혹여 아시는 분 계시다면 변환좀 부탁드립니다.
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "DESIGN");
// 접근 권한 검사
if (!$member[mb_id]) {
alert("최고관리자로 로그인 하십시오.", "./?doc=bbs/mblogin.php&url=" . urlencode("./?doc=$doc"));
} else if (_GNUADMIN_ == "DEFAULT" && $is_admin != "default") {
alert("최고관리자만 접근 가능합니다.", "./");
} else {
if ($is_admin != "default") {
$sql = " select count(*) from $cfg[table_group] where gr_admin = '$member[mb_id]' ";
$row = sql_fetch($sql);
if ($row[0]) {
$is_admin = "group";
}
}
if (!($is_admin == "default" || $is_admin == "group")) {
alert("그룹관리자 이상 접근 가능합니다.", "./?doc=new_hit.php");
}
}
mysql_query("DROP TABLE IF EXISTS gb_write_2004hit");
mysql_query("CREATE TABLE gb_write_2004hit (
wr_num int(11) NOT NULL auto_increment,
ca_id int(11) NOT NULL default '0',
wr_id int(11) NOT NULL default '0',
wr_reply varchar(10) NOT NULL default '',
wr_parent_id int(11) NOT NULL default '0',
wr_comment int(11) NOT NULL default '0',
wr_commentcnt int(11) NOT NULL default '0',
wr_subject varchar(255) NOT NULL default '',
wr_content text NOT NULL,
wr_hit int(11) NOT NULL default '0',
wr_good int(11) NOT NULL default '0',
wr_nogood int(11) NOT NULL default '0',
mb_id varchar(20) NOT NULL default '',
wr_name varchar(20) NOT NULL default '',
wr_email varchar(255) NOT NULL default '',
wr_homepage varchar(255) NOT NULL default '',
wr_datetime datetime NOT NULL default '0000-00-00 00:00:00',
wr_ip varchar(15) NOT NULL default '',
bo_subject varchar(255) NOT NULL default '',
bo_table varchar(255) NOT NULL default '',
PRIMARY KEY (wr_num),
KEY index1 (wr_id,wr_parent_id),
KEY index2 (wr_hit),
KEY index3 (wr_datetime)
)");
?>
<br>
<table width=100% cellpadding=3 cellspacing=0>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
<tr><td class='subject subjectbg ht'> <?=$html_title?></td></tr>
<tr><td height=1 background='./<?=$cfg[bbs_dir]?>/line.gif'></td></tr>
</table>
<p>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width='' valign=top>
<?
$intime = date("2004-01-01 00:00:00");
$fromtime = date("2004-12-31 00:00:00");
$sql = " select bo_subject, bo_table
from $cfg[table_board]
where bo_use_search = '1'
order by bo_order_search ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
$tbl = "{$cfg[write_table_prefix]}{$row[bo_table]}";
$sql2 = " select wr_id,
ca_id,
wr_num,
wr_reply,
wr_parent_id,
wr_comment,
wr_commentcnt,
mb_id,
wr_name,
wr_subject,
wr_content,
wr_good,
wr_nogood,
wr_email,
wr_homepage,
wr_datetime,
wr_ip,
wr_hit
from $tbl
where wr_datetime >= '$intime' and wr_datetime <= '$fromtime'
order by wr_hit desc limit 30";
$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);
$key = $row2[wr_hit] . $row[bo_table] . $row2[wr_id];
$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_reply = $row2[wr_reply];
$list[$key]->wr_name = get_text(cut_str($row2[wr_name],12));
$list[$key]->wr_email = $row2[wr_email];
$list[$key]->wr_homepage = $row2[wr_homepage];
$list[$key]->wr_subject = get_text(cut_str($wr_subject,80,'…'));
$list[$key]->wr_comment = $row2[wr_comment];
$list[$key]->wr_commentcnt = $row2[wr_commentcnt];
$list[$key]->wr_datetime = $row2[wr_datetime];
$list[$key]->wr_hit = $row2[wr_hit];
$list[$key]->wr_good = $row2[wr_good];
$list[$key]->wr_nogood = $row2[wr_nogood];
}
mysql_free_result($result2);
}
mysql_free_result($result);
?>
<?
if (count($list) > 0) {
krsort($list);
foreach ($list as $key=>$value) {
$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);
$sql = "insert into gb_write_2004hit
set
bo_subject = '$value->bo_subject',
bo_table = '$value->bo_table',
wr_id = '$value->wr_id',
wr_parent_id = '$value->wr_parent_id',
wr_comment = '$value->wr_comment',
wr_commentcnt = '$value->wr_commentcnt',
wr_reply = '$value->wr_reply',
wr_email = '$value->wr_email',
wr_homepage = '$value->wr_homepage',
wr_subject = '$value->wr_subject',
wr_hit = '$value->wr_hit',
wr_good = '$value->wr_good',
wr_nogood = '$value->wr_nogood',
mb_id = '$value->mb_id',
wr_name = '$value->wr_name',
wr_datetime= '$value->wr_datetime'";
sql_query($sql);
}
echo "저장하였습니다.";
gotourl("./?doc=new_2004hit.php");
} else
echo "등록된 글이 없습니다.";
?>
</td></tr></table>
댓글 전체