Ãʺ¸ÀÚµµ ¼öÁ¤Çϱ⠽±°Ô ´Ù½Ã Á¤¸®Çß¾î¿ä.
My°Ô»çÆÇÀº ÇÑ È¸¿ø°ú °ü¸®ÀÚ¸¸ ±ÛÀÛ¼ºÀÌ °¡´ÉÇÑ °Ô½ÃÆÇÀÔ´Ï´Ù.
Áï 1:1°Ô½ÃÆÇ(»ó´ã°Ô½ÃÆÇ)À» ¸»ÇÕ´Ï´Ù.
ÀÛµ¿¿ø¸®´Â ÇØ´ç °Ô»çÆÇ¿¡ ÇʵåÇϳª Ãß°¡ÇÏ¿© ±× Çʵ忡 ±Û ÀÛ¼ºÀÚ È¸¿ø¹øÈ£¸¦ ÀúÀåÇÏ°í ±× ¹øÈ£¸¦ ±âÁØÀ¸·Î °Ô½Ã¹°À» °¡Á®¿É´Ï´Ù. ´ä±ÛÀÎ °æ¿ì¿¡´Â ¿øº»±Û ÀÛ¼ºÀÚÀÇ È¸¿ø¹øÈ£°¡ ÀÌ Çʵ忡 ÀúÀåµË´Ï´Ù.
Å×½ºÆ®ÆäÀÌÁö : http://www.yongnan.net/yb
(°Ô½ÃÆÇ ƯÁ¤»ó ȸ¿ø¸¸ Å×½ºÆ®°¡ °¡´ÉÇÕ´Ï´Ù.)
My°Ô½ÃÆÇ¿¡ Çʵå Çϳª Ãß°¡ÇÕ´Ï´Ù. ¾Æ·¡¼Ò½º¸¦ ÆÄÀÏ(my_add.php)·Î ¸¸µé¾î Á¦·Îº¸µå¿¡ ³Ö°í ½ÇÇàÇÕ´Ï´Ù.
¿¹ : http://ȨÁÖ¼Ò/bbs/my_add.php
<?
$file=file("config.php");
$size=sizeof($file);
for($i=1;$i<=4;$i++){$file[$i]=trim(str_replace("\n","",$file[$i]));}
$conn=mysql_connect($file[1], $file[2], $file[3]);
$mysql=mysql_select_db($file[4], $conn); //db¼±ÅÃ
$id="myboard";//My°Ô»çÆÇ ¾ÆÀ̵ð ÀÔ·Â
$query="alter table zetyx_board_$id add (ismember2 int(20) not null default '0')";
$da=mysql_query($query, $conn);
if($da){echo "<p align=center>°Ô½ÃÆÇ Ä®·³Ãß°¡ ¼º°ø";}
else{echo "<p align=center>°Ô½ÃÆÇ Ä®·³Ãß°¡ ½ÇÆÐ";}
?>
----------------------------------------------------
_head.php ÆÄÀÏ ¼Ò½º Ãß°¡ À§Ä¡
else $s_que.= " ( ".$t_s_que." ) ";
$keyword=stripslashes($keyword);
}
//¸¶ÀÌÆäÀÌÁö ¼³Á¤ ½ÃÀÛ
if(!$is_admin $id=="myboard"){
$s_que="ismember2='$member[no]' || headnum<='-2000000000'";
}
//¸¶ÀÌÆäÀÌÁö ¼³Á¤ ³¡
// °Ë»ö Á¶°ÇÀÌ ÀÖÀ»¶§ ¾Õ¿¡ where ¹® Ãß°¡
if($s_que) $s_que=" where ".$s_que;
--------------------------------------------------
view.php ÆÄÀÏ ¼Ò½º Ãß°¡ À§Ä¡
// ÇöÀç ¼±ÅÃµÈ µ¥ÀÌŸ°¡ ÀÖÀ»¶§, Áï $no °¡ ÀÖÀ»¶§ µ¥ÀÌŸ °¡Á®¿È
unset($data);
$_dbTimeStart = getmicrotime();
$data=mysql_fetch_array(mysql_query("select * from $t_board"."_$id where no='$no'"));
$_dbTime += getmicrotime()-$_dbTimeStart;
//¸¶ÀÌÆäÀÌÁö ¼³Á¤ ½ÃÀÛ
if(!$is_admin $id=="myboard"){
$data=mysql_fetch_array(mysql_query("select * from $t_board"."_$id where ismember2='$member[no]' || headnum<='-2000000000'"));
}
//¸¶ÀÌÆäÀÌÁö ¼³Á¤ ³¡
if(!$data[no]) Error("¼±ÅÃÇϽŠ°Ô½Ã¹°ÀÌ Á¸ÀçÇÏÁö ¾Ê½À´Ï´Ù","zboard.php?$href$sort");
---------------------------------------------------
write_ok.php ÆÄÀÏ ¼Ò½º Ãß°¡ À§Ä¡
/****************************************************
* °Ô½ÃÆÇ ¼³Á¤ üũ
****************************************************/
//¸¶ÀÌ°Ô½ÃÆÇ ¼³Á¤ ½ÃÀÛ
if($id=="myboard"){
$me=",ismember2";
$me2=",'$member[no]'";
$me_re=",'$s_data[ismember2]'";
}
//¸¶ÀÌ°Ô½ÃÆÇ ¼³Á¤ ³¡
// Æí¹ýÀ» ÀÌ¿ëÇÑ ±Û¾²±â ¹æÁö
(±× ´ÙÀ½Àº ¾Æ·¡·Î Âß ³»·Á°¡¼ ´äº¯±Û¾²±âºÎºÐ¿¡¼ $me, $me_re ¹®ÀÚ¸¦ Ãß°¡ÇÏ°í ½Å±Ô±Û¾²±âºÎºÐ¿¡¼ $me, $me2 ¹®ÀÚ¸¦ Ãß°¡ÇÏ½Ã¸é µË´Ï´Ù.)
// ´ä±Û µ¥ÀÌŸ ÀÔ·Â;;
mysql_query("insert into $t_board"."_$id (division,headnum,arrangenum,depth,prev_no,next_no,father,child,ismember,memo,ip,password,name,homepage,email,subject,use_html,reply_mail,category,is_secret,sitelink1,sitelink2,file_name1,file_name2,s_file_name1,s_file_name2,x,y,reg_date,islevel $me) values ('$division','$headnum','$arrangenum','$depth','$prev_no','$next_no','$father','$child','$member[no]','$memo','$ip','$password','$name','$homepage','$email','$subject','$use_html','$reply_mail','$category','$is_secret','$sitelink1','$sitelink2','$file_name1','$file_name2','$s_file_name1','$s_file_name2','$x','$y','$reg_date','$member[is_admin]' $me_re)") or error(mysql_error());
// ¿øº»±Û°ú ¿øº»±ÛÀÇ ¾Æ·¡±ÛÀÇ ¼Ó¼º º¯°æ;;
(¾Æ·¡´Â ½Å±Ô±Û¾²±âºÎºÐ)
$next_no=$next_data[no];
$child="0";
$depth="0";
$arrangenum="0";
$father="0";
$division=add_division();
mysql_query("insert into $t_board"."_$id (division,headnum,arrangenum,depth,prev_no,next_no,father,child,ismember,memo,ip,password,name,homepage,email,subject,use_html,reply_mail,category,is_secret,sitelink1,sitelink2,file_name1,file_name2,s_file_name1,s_file_name2,x,y,reg_date,islevel $me) values ('$division','$headnum','$arrangenum','$depth','$prev_no','$next_no','$father','$child','$member[no]','$memo','$ip','$password','$name','$homepage','$email','$subject','$use_html','$reply_mail','$category','$is_secret','$sitelink1','$sitelink2','$file_name1','$file_name2','$s_file_name1','$s_file_name2','$x','$y','$reg_date','$member[is_admin]' $me2)") or error(mysql_error());
$no=mysql_insert_id();
// ÇöÀç±ÛÀÇ Á¶È¸¼ö¸¦ ¿Ã¸±¼ö ¾ø°Ô ¼¼¼Ç µî·Ï |
|