<?
//가지고 올 계시판 링크 주소
$get_url="http://www.phpschool.com/bbs2/inc_view.html?id=7090&code=tnt2&start=0&mode=search&s_que=&field=body&operator=and&period=all&category_id=";
$str=join("", file($get_url));
//ID추출
$write_id=str_ext2($str,"<td bgcolor=#5485B6 align=left>글쓴이:","\n</td>");
//제목추출:
$subject=str_ext2($str,"<td bgcolor=#5485B6 align=center ><b>","</b></td>");
//내용추출
$ex_key1="<table width=100% cellspacing=1 cellpadding=0 border=0>\n<td >\n\t<table width=100% cellspacing=1 cellpadding=1 border=0>";
$ex_key2="<td height=1 width=10% background=./img/list_back.gif></td>\n</tr> \n<script language='JavaScript'> ";
$body=str_ext2($str,$ex_key1,$ex_key2);
//테이블완성하기 위해 추가함.
$body=$ex_key1.$body."</tr></table></td></tr></table>";
$body="<a href=http://www.phpschool.com target=_new>출처: PHPSCHOOL</a>\n<BR><a href=$get_url target=_new>URL: $get_url</a>\n".$body;
//내용중 그림링크를 완성함
$arr1=array("<img src=./img/comment_del.gif"," background=./img/list_back.gif>","<img src=./img/cface/","<img src='./img/linktip.gif' ","<img src='./img/mail.gif' border=o>","<img src='./img/home.gif' border=o>");
for ($i=0;$i<sizeof($arr1);$i++) {
$body=str_replace($arr1[$i],str_replace("./img/","http://www.phpschool.com/bbs2/img/",$arr1[$i]),$body);
}
//글쓴시간
$write_date=str_ext2($str,"<td bgcolor=#5485B6 align=right>글쓴시간 : "," </td>");
$write_date="20$write_date:00";
/*
echo "get_url:$get_url<BR>";
echo "subject:$subject<BR>";
echo "write_id:$write_id<BR>";
echo "write_date:$write_date<BR>";
echo "body:$body<BR>";
*/
function str_ext2($str,$start="",$end=""){
//문자(*)가 있는 위치를 알아낸다
if (!$str) return $str;
if (!$start&&!$end) return $str;
$po = strpos($str, $start);
if (!$po||$po<0) $po=0;
if (!$end) return substr($str,$po);
//echo "S:$start,E:$end,P:$po,<BR>";
$len=strlen($str);
$len2=strlen($end);
//첫번째 문자(*) 다음부터 추출하기 위해 $po를 1증가
if ($po>0) $po += strlen($start);
//마지막 문자(*) 를 만나면 while 구문을 끝낸다
$buff=substr($str,$po);
if ($end) {
$po2= strpos($buff,$end);
$buff=substr($buff,0,$po2);
//echo "$po , $po2<BR>";
}
return $buff;
}
// 아래는 실제로 DB에 저장함.자신의DB에 맞추어 수정할것.
$subject=trim($subject);
$size=strlen($body);
$subject=str_replace("'","\'",$subject);
$body=str_replace("'","\'",$body);
$code="ktip";
if (!$define_db) {
if (file_exists("../db.htm")) {
include "../db.htm";
include "../utbase.htm";
}
else {
include "db.htm";
include "utbase.htm";
}
include "/nfs/php/lib/ut.htm";
}
$connect=mysql_connect($DB_HOST,$DB_USER,$DB_PASS);
$table_name="main_$code";
$query="select max(pos) from $table_name";
$result=mysql_db_query($DB_CM,$query);
if(!$result) {echo $query,mysql_error();exit;}
$row=mysql_fetch_array($result);
$newpos=$row[0]+1;
$query = "
insert into $table_name (
pos,id,tid,name
,tcode
,title,date
,size,body,tag
,f_link1
)
values (
'$newpos','$write_id','$write_id','$write_id'
,'$code'
,'$subject','$write_date'
,'$size','$body','2'
,'$get_url'
)";
//echo($query);exit;
$result=mysql_db_query($DB_CM,$query);
if(!$result) {
echo $query,mysql_error(),mysql_errno();
exit;
}
?> |
|
|