<?php
echo "<!DOCTYPE html>
<html lang=\"utf-8\" />
<head>
<meta charset=\"ko\" />
<!--
<meta http-equiv=\"X-UA-Compatible\" content=\"IE=Edge; chrome=1\" />
<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />
-->
<style type=text/css />
@charset \"UTF-8\"; 

html { width :100%; height:100%;margin-left:0px;margin-top:0px; }
body {width:100%;height:100%;display:inline-block;overflow-y:auto; margin-left:0px;margin-top:0px;overflow-x:hidden;}
form { display:inline;}
	a { text-decoration:none;color:black;font-size:small;}
	a:hover{text-decoration:underline black solid 2px;color:black;font-size:small;}	
	a:active{text-decoration:underline black solid 2px;color:black;font-size:small;}
textarea { resize:none;outline:none;border-left:0px;border-right:0px;line-height:20px;border-bottom:1px solid black;word-break:break-all;white-space:pre-wrap;overflow-y:auto;}
input,select { border :0px;outline:none;font-size:small; }
input[type=password] {ime:disabled; text-overflow:clip;}
input[type=text] { text-overflow:clip;background-color:white;}
kbd {  background-color:#bf334d;color:white;padding-left:3px;font-weight:900;margin-left:10px;border:0px;}
fieldset,div {width:100px;display:block;margin:0px;padding:0px;border:1px solid black;}
legend {text-align:center;font-size:small;text-decoration:none;} 
</style>
<script language=javascript type=text/javascript charset=\"utf-8\">
function copy(text) {
  navigator.clipboard.writeText(text);

copy.select();  
copy.setSelectionRange(0, copy(text)); 
}


</script>
</head>
<body>";
include("conn.php");
 $cat=$_GET['site'];

  $node_sql="SELECT * FROM `depth_base` WHERE spool >=1 and depth_id = '$cat' ORDER BY `idx` DESC";
$node_result=mysqli_query($conn,$node_sql);
while($node=mysqli_fetch_assoc($node_result)){
 $t_id=stripslashes($node['depth_id']);
 $t_mode=stripslashes($node['mode']);
 $t_prv=stripslashes($node['prvid']);

if($t_mode == "block") {
	
	echo "<BR>";
echo  $head_sql="select *  from depth_state_set where prvid like '$t_prv' and mode like '$t_mode' limit 1";
$head_result=mysqli_query($conn,$head_sql);
while($class=mysqli_fetch_assoc($head_result)) {
 $c_prvtitle=stripslashes($class['prvtitle']);
 $c_subject=stripslashes($class['subject']);
 $c_prvid=stripslashes($class['prvid']);}
 
echo "<hr>";
 $stat_sql="SELECT * FROM `depth_state_set` WHERE `prvid` LIKE '$c_prvid' and calls = '$t_id' ORDER BY `spool` >= 1 DESC";
$stat_result=mysqli_query($conn,$stat_sql);
while($state=mysqli_fetch_assoc($stat_result)) {
$s_list=stripslashes($state['calls']);
$s_work=($state['spool']);
$s_prvtitle=stripslashes($state['prvtitle']);
$s_subject=stripslashes($state['subject']);
echo"$s_list $s_work $s_prvtitle $s_subject <hr>";
}

}
if($t_mode == "pre") {

echo $head_sql="select *  from depth_state_set where prvid like '$t_prv' and mode like '$t_mode' limit 1";
$head_result=mysqli_query($conn,$head_sql);
while($class=mysqli_fetch_assoc($head_result)) {
echo $c_prvtitle=stripslashes($class['prvtitle']);
echo $c_subject=stripslashes($class['subject']);
echo $c_prvid=stripslashes($class['prvid']);}
echo "<hr>"; 

echo    $stat_sql="SELECT * FROM `depth_state_set` WHERE `prvid` LIKE '$c_prvid' and calls = '$t_id' ORDER BY `spool` >= 1 DESC";
$stat_result=mysqli_query($conn,$stat_sql);
while($state=mysqli_fetch_assoc($stat_result)) {
$s_list=stripslashes($state['calls']);
$s_work=($state['spool']);
$s_prvtitle=stripslashes($state['prvtitle']);
$s_subject=stripslashes($state['subject']);
echo"$s_list $s_work $s_prvtitle $s_subject <hr>";
}

}
else{}
}










/*
$first_sql="select * from category where loadcode like '$qs_tableid' order by groupidx asc";
$first_result=mysqli_query($conn,$first_sql);
while($first=mysqli_fetch_assoc($first_result)) {
  $loadcode=stripslashes($first['loadcode']);
 $loadtitle=stripslashes($first['loadtitle']);

  $loader_sql="SELECT *  FROM `loader` WHERE `dataid` LIKE  '$loadcode' order by loaderidx desc  ,  prevloaderidx desc";

$loader_result=mysqli_query($conn,$loader_sql);
while($loader=mysqli_fetch_assoc($loader_result)) {
$dataid=stripslashes($loader['dataid']);
$block_set=stripslashes($loader['block_set']);

if($block_set == "block") {
 $blocks_sql="select * from block_set where prevloader like '$dataid' and `block_set` like 'block";
$blocks_result=mysqli_query($conn,$blocks_sql);
while($blocks=mysqli_fetch_assoc($blocks_result)) {
$loaderidx=stripslashes($blocks['loaderidx']);
print_r($loaderidx);
$linkloader=stripslashes($blocks['linkloader']);
print_r($linkloader);
$prevloader=stripslashes($blocks['prevloader']);
print_r($prevloader);
$prevloaderidx=stripslashes($blocks['prevloaderidx']);
print_r($prevloaderidx);

if(($loaderidx >=1) &&  ($prevloader == $loadcode) && (empty($prevloaderidx)) {echo "<strong>$loadtitle $prevloader</strong>";}
if(($loaderidx >=1) && ($prevloader == $loadcode) && ($prevloaderidx >=1)) {echo "<h3>$linkloader $prevloader $prevloaderidx</h3>";}

}
}
if($block_set == "pre") {
	
$blocks_sql="select * from block_set where prevloader like '$dataid' and `block_set` like 'pre'";
$blocks_result=mysqli_query($conn,$blocks_sql);
while($blocks=mysqli_fetch_assoc($blocks_result)) {
$loaderidx=stripslashes($blocks['loaderidx']);
$linkloader=stripslashes($blocks['linkloader']);
$prevloader=stripslashes($blocks['prevloader']);
$prevloaderidx=stripslashes($blocks['prevloaderidx']);


if(($loaderidx >=1) &&  ($prevloader== $loadcode)    &&(empty($prevloaderidx)) {echo "[][$loadtitle][][ $prevloader][]";}
if(($loaderidx >=1) && ($prevloader == $loadcode) && ($prevloaderidx >=1)) {echo "<pre>$linkloader $prevloader $prevloaderidx</pre>";}
}}
*/

//}

/*
elseif($qs) {
$qs_sql="select * from query_string where querytype like 'depth'";
$qs_result=mysqli_query($conn,$qs_sql);
while($qs=mysqli_fetch_assoc($qs_result)) {
$qs_tableid=stripslashes($qs['tableid']);

$first_sql="select `loadtitle`,`loadcode` from category where loadcode like '$qs_tableid' order by groupidx asc";
$first_result=mysqli_query($conn,$first_sql);
while($first=mysqli_fetch_assoc($first_result)) {
 $loadcode=stripslashes($first['loadcode']);
 $loadtitle=stripslashes($first['loadtitle']);
 $loader_sql="SELECT *  FROM `loader` WHERE `prevloader` LIKE  '$loadcode' order by loaderidx asc  ,  prevloaderidx asc";

$loader_result=mysqli_query($conn,$loader_sql);
while($loader=mysqli_fetch_assoc($loader_result)) {
$loaderidx=stripslashes($loader['loaderidx']);
 $linkloader=stripslashes($loader['linkloader']);
 $prevloader=stripslashes($loader['prevloader']);
 $currentloadertitle=stripslashes($loader['currentloadertitle']);
$prevloaderidx=stripslashes($loader['prevloaderidx']);
if(($loaderidx >=1) &&  (($prevloader && $linkloader)== $loadcode)    && ($prevloaderidx < 1)) {echo "<strong>$loadtitle";
echo"<BR>";
echo" $prevloader</strong>";}
if(($loaderidx >=1) && ($prevloader== $loadcode) && ($prevloaderidx >=1) ) {echo "<pre>$linkloader $prevloader $prevloaderidx</pre>";}
else {}
}
}
}
}

else{}
*/
?>
























