include "../lib/error_path.html"; //¿¡·¯ ÆäÀÌÁö·Î À̵¿
include "../lib/dbconnect.html"; //µ¥ÀÌŸ º£À̽º ¿¬°á
class Board_Config_List {
var $c_num; ##°Ô½ÃÆÇ°³º° Á¤º¸¹øÈ£
var $c_list_tblcode; ##°Ô½ÃÆÇº° Å×À̺íÄÚµå
var $c_list_tblname; ##°Ô½ÃÆÇº° Å×À̺í À̸§
var $c_list_adminid; ##°Ô½ÃÆÇº° °ü¸®ÀÚ¾ÆÀ̵ð
var $c_list_adminpwss; ##°Ô½ÃÆÇº° °ü¸®ÀÚÆÐ½º¿öµå
var $c_list_adminemail; ##°Ô½ÃÆÇº° °ü¸®ÀÚ À̸ÞÀÏ
var $c_list_adminhomepage; ##°Ô½ÃÆÇº° °ü¸®ÀÚ È¨ÆäÀÌÁö
var $c_list_adminname; ##°Ô½ÃÆÇº° °ü¸®ÀÚ À̸§
var $c_list_tblskin; ##°Ô½ÃÆÇº° ½ºÅ²Á¤º¸
var $c_list_tbl_line_subject; ##°Ô½ÃÆÇº° Á¦ÀÏù¶óÀÎ Á¦¸ñ
var $c_list_tbl_line_comment; ##°Ô½ÃÆÇº° ù¶óÀÎ ³»¿ë
var $c_list_tbl_head_message; ##°Ô½ÃÆÇº° Çìµå ³»¿ë
var $c_list_tbl_foot_message; ##°Ô½ÃÆÇº° ¸¶Áö¸· ¸Þ¼¼Áö
var $c_list_tbl_page_count; ##°Ô½ÃÆÇº° ÆäÀÌÁö ¸µÅ©¼ö
var $c_list_tbl_block_count; ##°Ô½ÃÆÇº° ºí·° ¼ö
var $c_list_width; ##°Ô½ÃÆÇÀÇ »çÁöÁî
var $c_list_auth; ##°Ô½ÃÆÇÀÇ ±ÇÇÑ 1 : ºñȸ¿ø 2:ȸ¿øÀü¿ë 3:°ü¸®ÀÚ
var $c_list_pds_gesi; ##°Ô½ÃÆÇÀÇ ÀÚ·á½Ç ±â´É ¹Ì»ç¿ë :0 »ç¿ë : 1
var $c_list_pds_down; ##°Ô½ÃÆÇÀÇ º¸±â¿¡¼ ´Ù¿î : 1 ¸®½ºÆ®¿¡¼ ´Ù¿î : 2 µÑ´Ù:3
var $c_list_file_icon; ##°Ô½ÃÆÇ¿¡¼ ÆÄÀϱ¸ºÐ¾ÆÀÌÄÜ »ç¿ë :0 ¹Ì»ç¿ë :1
var $c_list_total_list; ##Àüü°Ô½ÃÆÇ ¸®½ºÆ® ÇØ´ç°Ô½ÃÆÇ ¿¡¼ ÀÚ·á°¡Á®¿À±â
var $c_list_html_comment;
var $c_list_one_list; ##Ȧ¼ö¶óÀÎ °Ô½Ã¹° »ö»ó
var $c_list_two_list; ##¦¼ö¶óÀÎ °Ô½Ã¹° »ö»ó
var $c_list_send_mail_check; ##1:»ç¿ëÀÚ¿¡°Ô¸¸ 2:ÇØ´ç°ü¸®ÀÚ¿¡°Ô¸¸,3:µÑ´Ù¿¡°Ô
var $c_list_send_font_color; ##4:ÇØ´ç°ü¸®ÀÚ ¹× Àüü°ü¸®ÀÚ 5:##¸ðµÎ´Ù¿¡°Ô
var $c_list_send_font_width; ##ÆùÆ®±½±â ## µðÆúÆ® 9 1
var $c_list_icon_new; ##½Å±Ô¾ÆÀÌÄÜ ¹Ì»ç¿ë : 0 »ç¿ë : 1
var $c_list_icon_hot; ##ÇÖ¾ÆÀÌÄÜ ¹Ì»ç¿ë : 0 »ç¿ë : 1
var $c_list_icon_gon; ##°øÁö ¹Ì»ç¿ë : 0 »ç¿ë :1
var $c_list_memo_check; ##¸Þ¸ð±â´É ¹Ì»ç¿ë : 0 »ç¿ë :1
var $c_list_ip_check; ##¾ÆÀÌÇÇ ¾Èº¸À̱â 0 : º¸À̱â : 1
var $c_list_avata_check; ##¾Æ¹ÙŸ ¾Èº¸À̱â 0 : º¸À̱â :1
var $c_list_memo_avata_check; ##¸Þ¸ð¿¡¼ ¾Æ¹ÙŸ ¾Èº¸À̱â:0 º¸À̱â:1
var $c_list_class_check; ##ÀÏ¹Ý°Ô½ÃÆÇ ´äº¯Çü °Ô½ÃÆÇ
var $c_list_popup_check; ##ÆË¾÷âÀ¸·Î ¶Ù¿ì±â ¾È¶Ù¿ì±â
var $board_root_form;
var $s_count; // °Ë»öµÈ ·¹ÄÚµåÀÇ °¹¼ö
var $t_count; // ÃÑ ·¹ÄÚµåÀÇ °¹¼ö
var $page_list;
var $search_field;
var $search_key;
var $total_page;
var $direct_page;
var $prev_page1;
var $next_page1;
var $prev_block;
var $next_block;
var $modify_num;
var $modify_name;
var $modify_code;
var $page_count = 10; // ¾Æ¹ÙŸ ÆäÀÌÁö Ä«¿îÆ®
var $block_count = 10; // ¾Æ¹ÙŸ ºí·° Ä«¿îÆ®
var $avata_savedir = '../avata_icon';
var $table_result;
function board_make($board_code,$board_name,$email,$homepage,$name,$c_list_adminid,$c_list_adminpwss) { // °ü¸®ÀÚ ¸ðµå ¾Æ¹ÙŸ µî·Ï¼ö
$Error_Path = new Error_Path(); // ¿¡·¯ °´Ã¼ »ý¼º
$Dbconnect = new Dbconn(); // µ¥ÀÌŸ º£À̽º °´Ã¼ »ý¼º
$table=$Dbconnect->db_table."_config"; // Å×À̺í Á¤º¸
$board_code_config = $board_code."_userconfig";
if($board_code == '' || $board_name == '') {
$Error_Path->error_page1('°Ô½ÃÆÇ ÄÚµå ¶Ç´Â °Ô½ÃÆÇ À̸§À» ÀÔ·ÂÇϼ¼¿ä.');
}
$dup_select_query = "select c_list_tblcode from $table where c_list_tbl_code='$board_code_config'";
$dup_select_result = mysql_query($dup_select_query);
$dup_result = mysql_list_tables($Dbconnect->db_database);
$i = 0;
//echo $Dbconnect->db_database;
while($i < mysql_num_rows($dup_result)) {
$tb_name[$i] = mysql_tablename($dup_result,$i);
if($board_code == $tb_name[$i]) {
$dup_check1 = '1';
}
$i++;
}
if($dup_select_result) {
$dup_select_row = mysql_num_rows($dup_select_result);
if($dup_select_row > 0) {
$dup_check2 = '1';
}
}
// echo "$board_code; $board_code_memo;";
// exit;
$create_tbl_query = "create table $board_code (
b_num int not null, ##°Ô½Ã¹°¹øÈ£
b_id char(14), ##ÀÛ¼ºÀÚ¾ÆÀ̵ð
b_name varchar(30), ##ÀÛ¼ºÀÚ À̸§
b_email varchar(60), ##ÀÛ¼ºÀÚ À̸ÞÀÏ
b_homepage varchar(70), ##ÀÛ¼ºÀÚ È¨ÆäÀÌÁö
b_avata_img varchar(30), ##¾Æ¹ÙŸ ¾ÆÀÌÄÜ
b_user_ip varchar(40), ##ÀÛ¼ºÀÚ ¾ÆÀÌÇÇ
b_regdate varchar(30), ##ÀÛ¼ºÀÚ µî·ÏÀÏ
b_modifydate varchar(30), ##ÀÛ¼ºÀÚ ¼öÁ¤ÀÏ
b_subject varchar(50), ##ÀÛ¼ºÀÚ Á¦¸ñ
b_content text, ##ÀÛ¼º ³»¿ë
b_userfile varchar(80), ##µî·ÏµÈ ÆÄÀÏ
b_userfile_size varchar(50), ##µî·Ï ÆÄÀÏ Å©±â
b_read varchar(20), ##Á¶È¸¼ö
b_pwss varchar(14), ##ºñ¹Ð¹øÈ£
b_depth1 double,
b_depth2 double,
b_depth3 double,
b_color varchar(40),
b_fontline int(1),
primary key(b_num))";
$create_tbl_result = mysql_query($create_tbl_query);
$board_code_memo = $board_code."_memo";
$make_memo_tbl_query = "create table $board_code_memo ( ##¸Þ¸ð °Ô½ÃÆÇ
m_num int auto_increment,
m_id char(14),
m_name varchar(30),
m_comment text,
m_avata varchar(50),
m_reg_date date,
m_mod_date date,
m_table varchar(40),
m_tnum int(20),
m_userip varchar(30),
m_pwss varchar(14),
num varchar(20),
primary key(m_num))";
//echo $make_memo_tbl_query;
//exit;
$make_memo_tbl_result = mysql_query($make_memo_tbl_query); ##¸Þ¸ð°Ô½ÃÆÇ »ý¼º
if(!$create_tbl_result) {
$Error_Path->error_page1('°Ô½ÃÆÇ »ý¼º¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.');
}
$insert_into_query = "insert into $table (
c_list_tblcode,
c_list_tblname,
c_list_adminid,
c_list_adminpwss,
c_list_adminemail,
c_list_adminhomepage,
c_list_adminname,
c_list_tblskin,
c_list_tbl_page_count,
c_list_tbl_block_count,
c_list_width,
c_list_auth,
c_list_pds_gesi,
c_list_pds_down,
c_list_file_icon,
c_list_total_list,
c_list_html_comment,
c_list_one_list,
c_list_two_list,
c_list_send_mail_check,
c_list_send_font_color,
c_list_send_font_width,
c_list_icon_new,
c_list_icon_hot,
c_list_new,
c_list_hot,
c_list_icon_gon,
c_list_subject_length,
c_list_memo_check,
c_list_ip_check,
c_list_avata_check,
c_list_memo_avata_check,
c_list_class_check,
c_list_popup_check,
c_list_subject_class,
c_list_delete,
c_list_tbl_head_message,
c_list_tbl_foot_message
) values
(
'$board_code',
'$board_name',
'$c_list_adminid',
'$c_list_adminpwss',
'$email',
'$homepage',
'$name',
'josskin',
'10',
'10',
'700',
'1',
'0',
'1',
'0',
'0',
'1',
'white',
'white',
'3',
'1',
'1',
'1',
'1',
'3',
'3',
'1',
'40',
'1',
'1',
'1',
'1',
'1',
'0',
'10',
'0',
'
 |
',
''
)";
$insert_into_result = mysql_query($insert_into_query);
if($insert_into_result) {
$Error_Path->error_page2('Å×ÀÌºí »ý¼ºÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù.','./admin_gesi_list_function.html?mode=c_list&admin_mode=board_list');
} else {
$Error_Path->error_page1('Å×ÀÌºí »ý¼ºÁß ¿À·ù°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù.');
}//avata_add ÇÔ¼ö ºÎºÐ
}
function board_list($page,$field,$key) { //¸®½ºÆ® º¸À̱â
if($page == '') {
$page=1;
}
$Error_Path = new Error_Path();
$Dbconnect=new Dbconn();
$db_table=$Dbconnect->db_table."_config";
$total_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table order by c_num desc";
$total_result = mysql_query($total_select);
if($total_result) {
$this->t_count = mysql_num_rows($total_result); //Àüü ·¹ÄÚµå ¼ö
}
if($key != '' && $field != '') {
$search_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table where $field like '%$key%' order by c_num desc";
$search_result = mysql_query($search_select);
if($search_result) {
$this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö
}
} else {
$search_select = "select c_num,c_list_tblcode,c_list_tblname from $db_table order by c_num desc";
$search_result = mysql_query($search_select);
if($search_result) {
$this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö
}
}
#############################ÅäÅ» °¹¼ö¿Í °Ë»öµÈ °¹¼ö¸¦ ±¸ÇÏ´Â ºÎºÐ#################
###############################################################################
$virtual_count = $this->s_count / $page; //°¡»óÀÇ ¹øÈ£ ºÎ¿©
$first_record = (int)(($page-1) * $this->page_count); //ÆäÀÌÁöº° ù·¹ÄÚµå
$last_record = $page * $this->page_count; //ÆäÀÌÁöº° ¸¶Áö¸· ·¹ÄÚµå
$next_page = $this->s_count - $last_record;
if($next_page > 0) {
$last_record -= 1;
} else {
$last_record = $this->s_count - 1;
}
$prev_button = $page-1; //ÀÌÀü ÆäÀÌÁö
$next_button = $page+1; //´ÙÀ½ÆäÀÌÁö
$this->total_page = ceil($this->s_count / $this->page_count); //Àüü ÆäÀÌÁö
$total_block = ceil($this->total_page / $this->block_count); //Àüü ºí·°
$search_page = $total_block/$this->block_count;
$now_block = ceil($page/$this->block_count);
$start_page = (int)(($now_block-1)*$this->block_count); //½ÃÀÛ ÆäÀÌÁö
$end_page = (int)($now_block*$this->block_count); //¸¶Áö¸· ÆäÀÌÁö
if($now_block >= $total_block) {
$end_page = $this->total_page;
}
if($this->s_count != 0){
if($prev_button > 0) { //ÀÌÀü ÆäÀÌÁö
$this->prev_page1 = "<-";
}
if($next_button <= $this->total_page) { //´ÙÀ½ ÆäÀÌÁö
$this->next_page1 = "->";
}
if($now_block > 1) {
$prev_button = $start_page;
$this->prev_block = "<<-";
}
if($now_block < $total_block) {
$next_button = $end_page +1;
$this->next_block = "->>";
}
for($i=$first_record; $i <= $last_record; $i++) {
$this->num=mysql_result($search_result,$i,0);
$this->code=mysql_result($search_result,$i,1);
$this->name=mysql_result($search_result,$i,2);
$this->table_result .= "
$virtual_count | $this->code | $this->name | num>¼³Á¤ | num>»èÁ¦ |
| | | |
";
$virtual_count--;
} //for
} else {//0ÀÌ ¾Æ´Ò °æ¿ì
$this->table_result = " | | °Ë»öµÈ ÀÚ·á°¡ ¾ø½À´Ï´Ù. | |
";
} //0ÀÏ °æ¿ì
if($this->s_count != 0){
for($list_page=$start_page+1; $list_page <=$end_page; $list_page++) {
if($page != $list_page) {
$this->page_list .= "[$list_page]";
} else {
$this->page_list .= "[$list_page]";
}
}
} else {
$this->page_list .= "[1]";
}
//Àüü °ü¸®ÀÚ ·Î±×ÀÎÀÌ µÇ¾úÀ» °æ¿ì
}
function admin_modify($num) {
$Error_Path = new Error_Path();
$Dbconnect = new Dbconn();
$avata_table=$Dbconnect->db_table."_avata";
$modify_select = "select * from $avata_table where a_num = $num";
$modify_result = mysql_query($modify_select);
if($modify_result) {
$modify_rows = mysql_fetch_array($modify_result);
$this->modify_num = $modify_rows[a_num];
$this->modify_name = $modify_rows[a_name];
$this->modify_code = $modify_rows[a_code];
}
}
function avata_modify($num,$name,$imgavata,$imgavata_name) {
$Error_Path = new Error_Path(); // ¿¡·¯ °´Ã¼ »ý¼º
$Dbconnect = new Dbconn(); // µ¥ÀÌŸ º£À̽º °´Ã¼ »ý¼º
$avata_table=$Dbconnect->db_table."_avata"; // ¾Æ¹ÙŸ Å×À̺í Á¤º¸
########################################################################################
#########################ÆÄÀÏ Á¤º¸¿¡ ´ëÇÑ ±ÔÄ¢À» Àû¿ë######################################
#######################################################################################
if($imgavata_name == '' || $imgavata_name == 'none') { //ÆÄÀÏÀ» ¼±ÅÃÇÏ¿´´ÂÁö üũ
$Error_Path->error_page1('ÆÄÀÏÀ» ¼±ÅÃÇÏ¿© Áֽñ⠹ٶø´Ï´Ù.');
}
if(ereg("[[:space:]]",$imgavata_name) ) { //ÆÄÀÏ¸í¿¡ °ø¹éÀÌ ÀÖ´ÂÁö üũ
$Error_Path->error_page1('ÆÄÀÏÀ̸§¿¡ °ø¹éÀÌ ÀÖ½À´Ï´Ù.');
}
$full_filename = explode(".",$imgavata_name);
$extention = $full_filename[sizeof($full_filename)-1];
$a=sizeof($full_filename);
while($a >= 2) {
$filename .=$full_filename[sizeof($full_filename)-$a];
$filename .=".";
$a--;
}
$avata_img_name = $filename.$extention;
if($extention != 'jpeg' && $extention != 'jpg' && $extention != 'gif' && $extention != 'png')
{
$Error_Path->error_page1('¿Ã¹Ù¸¥ À̹ÌÁö ÆÄÀÏÀÌ ¾Æ´Õ´Ï´Ù.');
}
if(!file_exists("$this->avata_savedir")){mkdir($this->avata_savedir,0777);}
$file_serch = file_exists("$this->avata_savedir/$avata_img_name");
$k=0;
while($file_serch) //°°Àº ÆÄÀÏÀÌ ÀÖ´Â °æ¿ì
{
$full_filename= explode(".", "$avata_img_name"); //È®ÀåÀÚ¸¦ °¡Áö°í ¿Í¼
$extention = $full_filename[sizeof($full_filename)-1];
$filename .="_1";
$avata_img_name=$filename.".".$extention ;
$file_serch = file_exists("$this->avata_savedir/$avata_img_name");
}
if(!copy($imgavata,"$this->avata_savedir/$avata_img_name"))
{
$Error_Path->error_page1('ÆÄÀÏÀ» º¹»çÇϴµ¥ ½ÇÆÐÇÏ¿´½À´Ï´Ù.');
}
if(!unlink($imgavata))
{
$Error_Path->error_page1('ÀÓ½ÃÆÄÀÏÀ» »èÁ¦Çϴµ¥ ½ÇÆÐÇÏ¿´½À´Ï´Ù.');
}
$insert_avata_query = "update $avata_table set a_code='$avata_img_name',a_name='$name' where a_num='$num'";
$insert_avata_result = mysql_query($insert_avata_query); //µ¥ÀÌŸ º£À̽º Äõ¸®¸¦ ³¯¸°´Ù.
if($insert_avata_result) {
$Error_Path->error_page2('¿Ã¹Ù¸£°Ô ¼öÁ¤µÇ¾ú½À´Ï´Ù.','./admin_avata_list_function.html?admin_mode=avata_list&mode=a_list');
}
}
function avata_delete($num) {
$Error_Path = new Error_Path();
$Dbconnect = new Dbconn();
$avata_table=$Dbconnect->db_table."_avata";
$delete_query = "delete from $avata_table where a_num = '$num'";
$delete_result = mysql_query($delete_query);
if($delete_result) {
$Error_Path->error_page2('¿Ã¹Ù¸£°Ô »èÁ¦µÇ¾ú½À´Ï´Ù.','./admin_avata_list_function.html?admin_mode=avata_list&mode=a_list');
}
}
function board_login($board_id,$board_pwss)
{
$Error_Path = new Error_Path();
$Dbconnect = new Dbconn();
$select_login_query = "select i_num from $Dbconnect->db_table where i_admin_id='$board_id' and i_admin_pwss='$board_pwss'";
$select_login_result = mysql_query($select_login_query);
if($select_login_result) {
$select_login_rows = mysql_num_rows($select_login_result);
if($select_login_rows > 0) {
$Error_Path->error_page2('°Ô½ÃÆÇ Àüü°ü¸®ÀÚ ·Î±×ÀÎÀÌ µÇ¾ú½À´Ï´Ù.',"./admin_gesi_tlogin_ok.html?id=$board_id&pwss=$board_pwss");
} else {
$Error_Path->error_page1('¾ÆÀ̵ð ¶Ç´Â ºñ¹Ð¹øÈ£°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.');
}
}
}
} //Ŭ·¡½º ¸¶Áö¸· ºí·°
$Error_Path = new Error_Path();
include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ
$Dbconnect = new Dbconn();
include "./admin_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ
$Board_Config_List = new Board_Config_List();
switch($admin_mode) { //ÇÔ¼ö¸¦ È£ÃâÇÏ´Â ºÎºÐ
case 'board_make' :
$Board_Config_List->board_make($board_code,$board_name,$email,$homepage,$name,$c_list_adminid,$c_list_adminpwss);
break;
case 'board_login' : $Board_Config_List->board_login($board_id,$board_pwss);
break;
case 'avata_add' :
$Board_Config_List->avata_add($name,$imgavata_name,$imgavata);
break;
case 'admin_modify' : $Board_Config_List->avata_modify($num,$name,$imgavata,$imgavata_name);
break;
case 'admin_delete' : $Board_Config_List->avata_delete($num);
break;
case 'board_list' :
if($board_root != '' && $board_check != '') {
$board_root_form ="
Àüü °Ô½ÃÆÇ °ü¸®ÀÚ·Î ·Î±×ÀÎ µÇ¾ú½À´Ï´Ù. |
";
}else {
$board_root_form ="";
}
$Board_Config_List->board_list($page,$field,$key);
break;
case 'admin_modify' :
$Board_Config_List->admin_modify($num);
//$modify_img=Board_Config_List->avata_savedir."/".Board_Config_List->modify_code;
break;
}
switch($mode) {
case 'a_insert' :
include "./admin_avata_add_form.html";
break;
case 'c_modify' :
include "./admin_gesi_modify_form.html";
break;
case 'c_list' :
include "./admin_gesi_list_form.html";
break;
}
?>
?>