webadmin.php

/home/mjc1/public_html/upgrade/upgrade_info.php

<?
session_start();
/*
Á¦Ç° Á¤º¸ Ãâ·Â ÆäÀÌÁö

*/

$position = "¾÷±×·¹ÀÌµå";
$page_title = "¾÷±×·¹ÀÌµå";
$sub_title = "Á¦Ç° ÀÚ¼¼È÷º¸±â";
$upgrade_menu = "m_b_menber_on.gif";
require "./inc/config.php";
require "./main_file/header.html";


$member_class = new member_class();
$upgrade_class = new upgrade_class();

//ÀÎÁõ ¹øÈ£
// È¸¿øÀÌ »ç¿ëÁßÀÎ Á¤Ç° Á¦Ç°ÀÇ ÀÎÁõ ¹øÈ£¸¦ °¡Á® ¿Â´Ù.
//$user_program
//


$query = "select * from $table_name where uid ='$uid'";

$result = mysql_query($query);
$row = mysql_fetch_array($result);



$header_memo = nl2br(stripslashes($a_row[board_header]));
$up_method = nl2br($row[up_method]);
$footer_memo = nl2br(stripslashes($a_row[board_footer]));

$up_info_memo = nl2br($row[up_info_memo]);


$certi_table = explode("_",$table_name);
if($user_program == $certi_table[1]){
        //¸¸ÀÏ À¯Àú Å¸ÀÔÀÌ Á¤Ç°ÀÌ°í, ¸¸±âÀÏÀÌ Áö³ªÁö ¾Ê¾Ò°í , Á¤Ç° ±ÇÇÑÀÌ Á¤»óÀÎ °æ¿ì
    if(($user_type == $member_type_value[1]) && ($user_check == "USE" && $user_up == $if_upgrade_value[0])){


        //if($user_type == $member_type_value[1] && $user_check == "USE" ){

            $field = array("cat_large","cat_middle","cat_small");
            $field_value = array($user_program,"0","0");
            $certi_result = $upgrade_class ->  select_info2("category",$field,$field_value,"Y","and");
            $certi_row = mysql_fetch_array($certi_result,MYSQL_ASSOC);
            //<--- ÀÎÁõ ¹øÈ£


            $view_Certi_num = "YES";
            $certi_msg = "Á¤Ç°ÀÎÁõ¹øÈ£";
            $certi_num = $certi_row[certi_num];
            $version = $row[version];
        //}
    }else {
        $add_file = "-";
        $version = "-";
    }


    if(($user_type == $member_type_value[2]) && ($user_check == "USE" && $user_per == $if_program_value[0])){


        //if($user_type == $member_type_value[1] && $user_check == "USE" ){

            $field = array("cat_large","cat_middle","cat_small");
            $field_value = array($user_program,"0","0");
            $certi_result = $upgrade_class ->  select_info2("category",$field,$field_value,"Y","and");
            $certi_row = mysql_fetch_array($certi_result,MYSQL_ASSOC);
            //<--- ÀÎÁõ ¹øÈ£


            $view_Certi_num = "YES";
            $certi_msg = "ÀÓ´ëÀÎÁõ¹øÈ£";
            $certi_num = $certi_row[rent_certi_num];
            $version = $row[version];
        
    }
}else {
        $add_file = "-";
        $version = "-";
}






if($row[move_file]){
    $move_file = "<A HREF='./inc/download.php?type=upgrade&s_type=move&filename=$row[move_file]'><img src='images/file.gif' border='0'>°ü·ÃÀÚ·á¹Þ±â</A>";
    } else {$add_file = "";}

if($row[w_photo]){
    $photo_file = "<A HREF='./inc/download.php?type=upgrade&s_type=photo&filename=$row[w_photo]'><img src='images/file.gif' border='0'>°ü·ÃÀÚ·á¹Þ±â</A>";
    } else {$add_file = "";}



$my_ref = $row[hit];
$t_name = explode("_",$table_name);

$tablename = $t_name[0] . $t_name[1] . "_";

$t_number = $tablename.$row[uid];
if(!eregi($t_number,$upgrade_number)){

    $real_ref = $my_ref +1;
    $hit_query ="update $table_name set hit =$real_ref where uid = $row[uid]";
    $result = mysql_query($hit_query);

}
session_register("upgrade_number");
$upgrade_number =  "$upgrade_number:$t_number";







$s_q = "select * from header_info";
    
    $s_result = mysql_query($s_q);
    $s_row = mysql_fetch_array($s_result,MYSQL_ASSOC);
$board_header = nl2br($s_row[board_header]);
$board_footer = nl2br($s_row[board_footer]);
// Å×ÀÌºí Á¤º¸
switch ($table_name) {
          
        case ("upgrade_1"):
        $up_method = nl2br($s_row[up_metood_1]);
        break;
        case ("upgrade_2"):
        $up_method = nl2br($s_row[up_metood_2]);
        break;
        case ("upgrade_3"):
            $up_method = nl2br($s_row[up_metood_3]);
        break;
        case ("upgrade_5"):
            $up_method = nl2br($s_row[up_metood_5]);
        break;
        case ("upgrade_4"):
            $up_method = nl2br($s_row[up_metood_4]);
        break;
        case ("upgrade_7"):
            $up_method = nl2br($s_row[up_metood_7]);

        break;
        case ("upgrade_10"):
            $up_method = nl2br($s_row[up_metood_10]);
        break;
        case ("upgrade_11"):
            $up_method = nl2br($s_row[up_metood_11]);
        break;
        case ("upgrade_12"):
            $up_method = nl2br($s_row[up_metood_12]);
        break;
        case ("upgrade_6"):
            $up_method = nl2br($s_row[up_metood_6]);
        break;
        case ("upgrade_14"):
            $up_method = nl2br($s_row[up_metood_14]);
        break;

        case ("upgrade_8"):
            $up_method = nl2br($s_row[up_metood_8]);
        break;

        case ("upgrade_13"):
            $up_method = nl2br($s_row[up_metood_13]);
        break;
        case ("upgrade_9"):
            $up_method = nl2br($s_row[up_metood_9]);
        break;
        
        default;
        $m_query = "select * from upgrade_table_list where table_name = '$table_name'";
            //echo$m_query;
            $method_msg = mysql_query($m_query);
            $srow = mysql_fetch_array($method_msg,MYSQL_ASSOC);
            $up_method = nl2br($srow[up_method]);
        //$up_method = nl2br($s_row[up_metood_9]);
}







?>
<TABLE height=18 cellSpacing=0 cellPadding=0 width=630 align=center border=0>
<TBODY>
 <TR>
    <TD width=7><IMG height=18 src="images/q&amp;a_td_1.gif" 
            width=7></TD>
    <TD vAlign=bottom width=623 
            background=images/q&amp;a_td_2.gif>&nbsp;<IMG height=9 
            src="images/bar1_2.gif" width=5>&nbsp;<FONT 
            color=#ffffff><?=$page_title?></FONT>
    </TD>
    </TR>
</TBODY>
</TABLE>
<BR>

<table cellspacing="1" cellpadding="0" width="630" border="0" bgcolor="#9B9B9B" align="center">
    <tr><td>
    <table cellspacing="0" cellpadding="0" width="630" border="0" height="22" bgcolor="#E0E3E5" align="center">
        <tr>
        <td width="15%" align="center"><font color="#173771">&nbsp;¹øÈ£ : <b><?=$row[uid]?></b></font></td>
        <td align="center"><font color="#173771">Á¦¸ñ : <b><?=$row[subject]?></b></font></td>
        <td width="15%" align="center"><font color="#173771">Á¶È¸ : <b><?=$row[hit]?></b></font>&nbsp;&nbsp;</td>
        </tr>
    </table>
    </td></tr>
</table>
<table cellspacing="0" cellpadding="0" border="0" width="630" bgcolor="#9B9B9B" align="center">
    <tr><td>
        <table cellspacing="1" cellpadding="10" border="0" width="630" align="center">
        <!-- <tr><td colspan='2'><?=$upgrade_number?> </td></tr> -->
        <tr height="25">
        <td width="100%" align="center" bgcolor="#FFFFFF" colspan='2'><font color="#173771">&nbsp;<?=$board_header?> &nbsp;</font></td>
        </tr>
        <?
        if($row[move_file]){
        ?>
        <tr height="25">
        <td width="120" align="right" bgcolor="#ECEAEA"><font color="#173771">&nbsp;µ¿¿µ»ó &nbsp;</font></td>
        <td  width="500" bgcolor="white">&nbsp;<?=$move_file?>
        <!-- ÇØ´ç µ¿¿µ»óÀÌ ¾ø½À´Ï´Ù. -->
        &nbsp;&nbsp;
        </td></tr>
        <?}?>
        
        <tr height="25">    
        <td width="120" align="right" bgcolor="#ECEAEA"><font color="#173771">¾÷±×·¹ÀÌµå ÆÄÀÏ &nbsp;</font></td>
        <td   width="500" bgcolor="white">
        <?
        //Á¤Ç°ÀÇ ÀÎÁõ±ÇÇÑÀÌ Çã°¡ ÀÎ È¸¿øÀÏ °æ¿ì 
        //±¸¸Å Á¦Ç°ÀÇ ¾÷±×·¹ÀÌµå ÆÄÀÏÀ» ¹ÞÀ»¼ö ÀÖµµ·Ï ÇÑ´Ù.
        //
        if($view_Certi_num == "YES"){
            // È¸¿øÀÌ »ç¿ë ÁßÀÎ Á¦Ç°ÀÇ ÀÎÁõ ¹øÈ£¸¦ °¡Á® ¿Â´Ù.    
            echo("
            <TABLE width=320>
            <TR>
                
                <TD>  <A HREF='./inc/download.php?type=upgrade&s_type=file&filename=$row[add_file]'><img src='images/file.gif' border='0'>ÆÄÀÏ¹Þ±â</A>&nbsp;&nbsp;&nbsp;$certi_msg  :<INPUT TYPE=\"text\" NAME='' size='12' value='$certi_num' class='noline' readonly></TD>
            </TR>
            </TABLE>
            ");
        
        }else if(!$user_id) {
            echo("
             <TABLE width=320>
            <TR>
                
                <TD>·Î±×ÀÎÈÄ ¾÷±×·¹ÀÌµå¸¦ ¹ÞÀ¸½Ã±â ¹Ù¶ø´Ï´Ù.
                </TD>
            </TR>
            </TABLE>
            ");
        }else {
            echo("
            <TABLE width=320>
            
                <TD>
            ¾÷±×·¹ÀÌµå Áö¿ø °í°´ÀÌ ¾Æ´Õ´Ï´Ù. <br>¹®ÀÇ [1566-8680]
            </TD>
            </TR>
            </TABLE>
            ");
        }



        ?>
        <!-- ¿ùÁ¤È¸¿ø¸¸ »ç¿ë °¡´ÉÇÕ´Ï´Ù. <br>°í°´Áö¿øºÎ Àü±¹ 1544-8680À¸·Î ¿¬¶ô¹Ù¶ø´Ï´Ù. 
        &nbsp;&nbsp;<?=$add_file?>&nbsp;&nbsp; -->
        </td>
        </tr>

        <?
        if($row[w_photo]){
        ?>
        <tr height="25">    
        <td width="120" align="right" bgcolor="#ECEAEA"><font color="#173771">&nbsp;ÀÌ¹ÌÁö &nbsp;</font></td>
        <td   width="500" bgcolor="white">
        <!-- ÇØ´ç ÀÌ¹ÌÁö°¡ ¾ø½À´Ï´Ù. -->&nbsp;&nbsp;<?=$photo_file?>
        </td>
        </tr>
        <?}?>

        <tr>
        <td width="120" align="right" bgcolor="#ECEAEA"><font color="#173771">¾÷±×·¹ÀÌµå ¹æ¹ý </font>&nbsp;</td>
        <td   width="500" align="left" bgcolor="white">
            <?=$up_method?>
            <br>
        </td>
        </tr><tr>
        <td width="120" align="right" bgcolor="#ECEAEA"><font color="#173771">¾÷±×·¹ÀÌµå ³»¿ë </font>&nbsp;</td>
        <td   width="500" align="left" bgcolor="white">
        <?=$up_info_memo?>
        <BR>
        </td>
        </tr><tr height="25">
        <td width="100%" align="center" bgcolor="#FFFFFF" colspan='2'><font color="#173771">&nbsp;<?=$board_footer?> &nbsp;</font></td>
        </tr>
        </table>
    </td></tr>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="579">
     <tr>
         <td align="center" width="100%" height="30" bgcolor="#ffffff"><a href="upgrade.php?table_name=<?=$table_name?>"><img SRC="images/list.gif" border="0" WIDTH="54" HEIGHT="21"></a></td>
     </tr>
</table><br>

<?require "./main_file/footer.html"; ?>