include "../lib/error_path.html"; //¿¡·¯ ÆäÀÌÁö·Î À̵¿
include "../lib/dbconnect.html"; //µ¥ÀÌŸ º£À̽º ¿¬°á
class Avata_Memo_list {
var $a_num; // ¾Æ¹ÙŸ ·¹ÄÚµå ³Ñ¹ö
var $a_code; // ¾Æ¹ÙŸ ·¹ÄÚµå ÄÚµå
var $a_name; // ¾Æ¹ÙŸ ·¹ÄÚµå À̸§
var $a_page; // ¾Æ¹ÙŸ ÇöÀç ÆäÀÌÁö À̵¿
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 = 18; // ¾Æ¹ÙŸ ÆäÀÌÁö Ä«¿îÆ®
var $block_count = 10; // ¾Æ¹ÙŸ ºí·° Ä«¿îÆ®
var $avata_savedir = '../avata_memo_icon';
var $table_result;
function avata_add($name,$imgavata_name,$imgavata) { // °ü¸®ÀÚ ¸ðµå ¾Æ¹ÙŸ µî·Ï¼ö
$Error_Path = new Error_Path(); // ¿¡·¯ °´Ã¼ »ý¼º
$Dbconnect = new Dbconn(); // µ¥ÀÌŸ º£À̽º °´Ã¼ »ý¼º
$avata_table=$Dbconnect->db_table."_memo_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 = "insert into $avata_table (a_code,a_name) values ('$avata_img_name','$name')";
$insert_avata_result = mysql_query($insert_avata_query); //µ¥ÀÌŸ º£À̽º Äõ¸®¸¦ ³¯¸°´Ù.
if($insert_avata_result) {
$Error_Path->error_page2('¿Ã¹Ù¸£°Ô µî·ÏµÇ¾ú½À´Ï´Ù.','./admin_avata_memo_list_function.html?admin_mode=avata_list&mode=a_list');
}
} //avata_add ÇÔ¼ö ºÎºÐ
function avata_list1($page,$field,$key) { //¸®½ºÆ® º¸À̱â
if($page == '') {
$page=1;
}
$Error_Path = new Error_Path();
$Dbconnect=new Dbconn();
$avata_table=$Dbconnect->db_table."_memo_avata";
$total_select = "select * from $avata_table order by a_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 * from $avata_table where $field like $key order by a_num desc";
$search_result = mysql_query($search_select);
if($search_result) {
$this->s_count = mysql_num_rows($search_result); //°Ë»öµÈ ·¹ÄÚµå ¼ö
}
} else {
$search_select = "select * from $avata_table";
$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->name=mysql_result($search_result,$i,1);
$this->code=mysql_result($search_result,$i,2);
if($i%6 == 0) {
if($i != 0) {
$this->table_result .= "";
} else {
$this->table_result .= "
";
}
$this->table_result .= " | ";
} else {
$this->table_result .= " | ";
}
$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."_memo_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."_memo_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_memo_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."_memo_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_memo_list_function.html?admin_mode=avata_list&mode=a_list');
}
}
} //Ŭ·¡½º ¸¶Áö¸· ºí·°
$Error_Path = new Error_Path();;
//include "../lib/user_cookie_check.html"; //·Î±×ÀÎ µÈ »ç¿ëÀÚÀÎÁö È®ÀÎ
$Dbconnect = new Dbconn();
$Avata_list = new Avata_Memo_list();
$Avata_list->avata_list1($page,$field,$key);
include "../skin/josskin/user_avata_memo_list.html";
?>