<?
function make_child($par,$ct,$nm,$link,$target,$img){
	$ret = "$par [$ct]      = new Array;\n";
	$ret .= "$par [$ct]['caption']  = \"$nm\";\n";
	if ($link != "")
	$ret .= "$par [$ct]['url']      = \"$link\";\n";
//	if ($img != "")
//		$ret .= "$par [$ct]['icon']      = \"$img\";\n";
	$ret .= "$par [$ct]['target']   = \"$target\";\n";
	return $ret;
}

function make_single($parnm,$ct,$nm,$link,$tar,$img){
	$parnm = $parnm ."['children']";
	$ret .= make_child($parnm,$ct,$nm,$link,$tar,$img);
	return $ret;
}

function tree_par($par,$nm,$link,$target,$open,$img){
	$ret = "$par      = new Array;\n";
	$ret .= $par ."['caption']  = \"$nm\";\n";
	$ret .= $par ."['url']      = \"$link\";\n";
	$ret .= $par ."['target']   = \"$target\";\n";
	$ret .= "$par ['children']    = new Array;\n";
//	if ($img != "")
//		$ret .= "$par ['icon']      = \"$img\";\n";
	if ($open=="true")
		$ret .= $par ."['isOpen']  = $open;\n";
	return $ret;
}


function tree_gpar($par,$nm,$link,$target,$open,$img){
	$ret = "$par      = new Array;\n";
	$ret .= $par ."['caption']  = \"$nm\";\n";
	if ($open=="true")
		$ret .= $par ."['isOpen']  = $open;\n";
	$ret .= $par ."['url']      = \"$link\";\n";
	$ret .= $par ."['target']   = \"$target\";\n";
//	if ($img != "")
//		$ret .= "$par ['icon']      = \"$img\";\n";
	$ret .= "$par ['children']    = new Array;\n";
	$ret .= "$par ['children'][0]    = new Array;\n";
	return $ret;
}


function tree_az($parnm,$typ,$tar,$img){
	$az = array ("ABC"=>"ABC","DEF"=>"DEF","GHI"=>"GHI","JKL"=>"JKL","MNO"=>"MNO","PQR"=>"PQR","STUV"=>"STUV","WXYZ"=>"WXYZ","0 to 9"=>"012345689");
	$ct=0;
	switch($tar){
		case "first":
			$prog = "tree.php?typ=".$typ."_alpha_";
			break;
		case "second":
			$prog = "tree2.php?act=$typ&typ=alpha&id=";
			break;
	}	
	foreach ($az as $nm =>$val){
		$ret .= make_child($parnm,$ct,$nm,"",$tar,$img);
		$ret .= "$parnm [$ct] ['children']    = new Array;\n";
		for ($i = 0; $i<strlen($val);$i++){
			$let = substr($val,$i,1);
			$ret .= make_child($parnm."[$ct] ['children']",$i,$let,$prog.$let,$tar,$img);
		}
		$ct++;
	}
	return $ret;
}

function tree_type($parnm,$from,$typ,$tar,$img){
	$SQLstr = "select  t.* from h_type t left join h_type pt on t.type_type = pt.type_id where pt.type_code ='$typ'  order by t.type_show_order";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	switch($tar){
		case "first":
			$prog = "tree.php?typ=".$from."_".$typ."_";
			break;
		case "second":
			$prog = "tree2.php?act=".$from."&typ=".$typ."&id=";
			break;
	}
	switch ($typ){
		case "affprogram":
			$ret .= make_child($parnm,$ct,"No Program",$prog."0",$tar,$img);
			$ct++;
			break;
	}

	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];		
		$id = $row["type_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,$prog.$id,$tar,$img);
			$ct++;
		}
	}
	return $ret;
}


function tree_temp($parnm,$id,$tar,$img){
include "global_template.inc";
global $types;
	$prog = "types.php?act=showtype&id=";
	$cct=1;
	$ret .= tree_par("$parnm [$cct]","Product Search Templates","","","true");
	$ct=0;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Products 1: ".$types[$temp_pub_prod]['name'],"$prog$temp_pub_prod",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Products 2: ".$types[$temp_pub_prod2]['name'],"$prog$temp_pub_prod2",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Search Extras: ".$types[$temp_pub_prod_extra]['name'],"$prog$temp_pub_prod_extra",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Recommended Searches: ".$types[$temp_pub_searches]['name'],"$prog$temp_pub_searches",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Search Summary: ".$types[$temp_additional[1]]['name'],"$prog".$temp_additional[1],$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Single Product Template: ".$types[$temp_additional[0]]['name'],"$prog".$temp_additional[0],$tar,$img);
	$ct++;
	
	$cct++;
	$ret .= tree_par("$parnm [$cct]","Advertiser Templates","","","true");
	$ct=0;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Adverts: ".$types[$temp_advert]['name'],"$prog$temp_advert",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Featured Advertiser: ".$types[$temp_listing]['name'],"$prog$temp_listing",$tar,$img);
	$ct++;
	
	$cct++;
	$ret .= tree_par("$parnm [$cct]","Domain Templates","","","true");
	$ct=0;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Page Format: ".$types[$temp_content_format]['name'],"$prog$temp_content_format",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Web Pages: ".$types[$temp_extra_pages]['name'],"$prog$temp_extra_pages",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Extra Files: ".$types[$temp_extra_files]['name'],"$prog$temp_extra_files",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Search Box: ".$types[$temp_searchbox]['name'],"$prog$temp_searchbox",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Statics: ".$types[$temp_static]['name'],"$prog$temp_static",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"Menus: ".$types[$temp_menu]['name'],"$prog$temp_menu",$tar,$img);
	$ct++;
	$ret .= make_child($parnm."[$cct]['children']",$ct,"META: ".$types[$temp_meta]['name'],"$prog$temp_meta",$tar,$img);
	$ct++;

	if ($temp_shop > 0){
		$cct++;
		$ret .= tree_par("$parnm [$cct]","Shop Templates","","","true");
		$ct=0;
		$ret .= make_child($parnm."[$cct]['children']",$ct,"Shop 1: ".$types[$temp_shop]['name'],"$prog$temp_shop",$tar,$img);
		$ct++;
		$ret .= make_child($parnm."[$cct]['children']",$ct,"Shop 2: ".$types[$temp_shop_2]['name'],"$prog$temp_shop_2",$tar,$img);
		$ct++;
		if ($types[$temp_shop]['num3'] > 0){
			$ret .= make_child($parnm."[$cct]['children']",$ct,"Single Item: ".$types[$types[$temp_shop]['num3']]['name'],"$prog".$types[$temp_shop]['num3'],$tar,$img);
			$ct++;
		}
		if ($types[$temp_shop]['num4'] > 0){
			$ret .= make_child($parnm."[$cct]['children']",$ct,"Wishlist: ".$types[$types[$temp_shop]['num4']]['name'],"$prog".$types[$temp_shop]['num4'],$tar,$img);
			$ct++;
		}
	}
	$cct++;
	$ret .= tree_par("$parnm [$cct]","Additional Templates","","","false");
	$ct=0;
	for ($i=1;$i<10;$i++){
		if ($temp_additional[$i] > 0){
			$ret .= make_child($parnm."[$cct]['children']",$ct,"Additional $i: ".$types[$temp_additional[$i]]['name'],"$prog".$temp_additional[$i],$tar,$img);
			$ct++;
		}
	}
	return $ret;
}

function tree_notes($parnm,$id,$typ,$tar,$img){
	$SQLstr = "select * from h_links, h_notes where link_primary_id = note_id and link_type='$typ' and link_secondary_id = $id order by note_upd_dt desc";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	$ret .= make_child($parnm,$ct,"Add Note","gather.php?act=addnote&typ=$typ&id=$id",$tar,$img);
	$ct++;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row['note_upd_dt']." - ".$row["note_title"];		
		$id = $row["note_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,"gather.php?act=shownote&id=$id","third",$img);
			$ct++;
		}
	}
	return $ret;
}


function tree_wc($parnm,$typ,$tar,$img){
	 $SQLstr = "select * from h_word_groups,h_word where wg_parent_id='0' and wg_word_id = word_id order by word_word";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	switch($tar){
		case "first":
			$prog = "tree.php?typ=".$typ."_wc_";
			break;
		case "second":
			$prog = "tree2.php?act=wc&id=";
			break;
	}
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["word_word"];		
		$id = $row["wg_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,$prog.$id,$tar,$img);
			$ct++;
		}
	}
	return $ret;
}

function tree_wc_dets($parnm,$prog){
	$ct=1;
	$SQLstr = "select  t.* from h_type t left join h_type pt on t.type_type = pt.type_id where pt.type_code ='catsource' and t.type_id !=67 order by t.type_show_order";
//	echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];		
		$id = $row["type_id"];	
		$ct++;
//		$ret .= tree_par("$parnm [$ct]","Edit $nm","tree.php?typ=cat_1_".$id,"","first");
		$ret .= tree_par("$parnm [$ct]","Edit $nm","tree.php?typ=cat_14_".$id,"","first");
//		$ret .= make_child($parnm."[$ct]['children']",0,"Edit Category","tree.php?typ=cat_14_".$id,"first");
//		$ret .= make_child($parnm."[$ct]['children']",1,"Add Top Level Category","gather.php?act=newcat&id=$id","third");
//		$ret .= make_child($parnm."[$ct]['children']",2,"Unlinked Categories","gather.php?act=unlinkedcats&id=$id","second");
	}
	return $ret;
}
function tree_cat($parnm,$typ,$lev,$tar,$id){

if ($lev == 1 && $typ == GENERIC) {
	$tar="third";
	$subcats = get_valid_children($id);
	$ct=0;
	foreach($subcats as $subcat){
		if ($id==$subcat['wordid']){
			$ret .= tree_par("$parnm [$ct]",$subcat['disp'],"","","true",$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",0,"Show UnAllocated Keywords","gather.php?act=showsubcatallocate&parid=$id&&id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",1,"Show Allocated Keywords","gather.php?act=showsubcatallocated&parid=$id&id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",2,"Show All Keywords","gather.php?act=showsubcatall&parid=$id&id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",3,"Show Auto Keyword Moves","gather.php?act=allocatepubgenerics&alloc=1&show=1&source_id=$id&cat_id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",4,"Move Auto Keywords","gather.php?act=allocatepubgenerics&alloc=1&show=0&source_id=$id&cat_id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
//			$ret .= make_child($parnm."[$ct]['children']",5,"Move Auto Keywords","gather.php?act=allocatepubgenerics&alloc=1&show=1&source_id=$id&cat_id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
		} else {
			$ret .= tree_par("$parnm [$ct]",$subcat['disp'],"gather.php?act=showsubcatallocated&parid=$id&id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
//			$ret .= make_child($parnm."[$ct]['children']",0,"Show Unallocated Keywords","gather.php?act=showsubcatallocate&parid=$id&id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",0,"Show Auto Keywords Moves","gather.php?act=allocatepubgenerics&alloc=1&show=1&source_id=$id&cat_id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
			$ret .= make_child($parnm."[$ct]['children']",1,"Move Auto Keywords","gather.php?act=allocatepubgenerics&alloc=1&show=0&source_id=$id&cat_id=".$subcat['wordid']."&prog=".GENERIC,$tar,$img);
		}
		$ct++;
	}
	
} else {
	$itms = "cat.cat_id as cat_id, cat.cat_source_id as catparid, cat.cat_priority as priority, cat.cat_keywords as kw, h_word.word_word as pubcatnm, cat.cat_pub_cat_id as pubcatid, par.cat_pub_cat_id as parpubcatid, cat.cat_name as catnm, par.cat_source_id as parid, par.cat_name as parnm, cat.cat_type as cattype ";
	$SQLstr = "select $itms from h_category as cat left join h_category as par on (cat.cat_par_id = par.cat_source_id and par.cat_source_type = '$typ' ) left join h_word on (cat.cat_pub_cat_id = h_word.word_id ) where cat.cat_type = $lev and cat.cat_source_type = '$typ' ";
	if ($id > 0 ){
		$SQLstr .= " and cat.cat_par_id = $id ";	
	} 
	$SQLstr .= "order by cat.cat_par_id, cat.cat_priority, catnm";
	$result=MYSQL_QUERY("$SQLstr");
//	echo $SQLstr;
	$ct=0;
	if ($result) {
		switch($lev){
			case 14:
				if ($typ == GENERIC){
					$nxtlev= 1;
				} else {
					$nxtlev= 15;
				}
				break;
			case 15:
				$nxtlev= 20;
				break;
			case 20:
				$nxtlev= 82;
				break;
			case 82:
				$nxtlev= 82;
				break;
		}
		while($row2 =  mysql_fetch_array($result, MYSQL_ASSOC))  { 	
			$parid = $row2['parid'];
			$parnam = $row2['parnm'];
			$cattype= $row2['cattype'];
			$priority = $row2['priority'];
			$keywords = $row2['kw'];
			$pubcatid = $row2['pubcatid'];
			$pubcatnm = $row2['pubcatnm'];
			$catparid = $row2['catparid'];
			$parpubcatid = $row2['parpubcatid'];
			$cat_id = $row2['cat_id'];
			$catnm = $row2['catnm'];
			$nm = "$catnm    => $pubcatnm";
			$id = $cat_id;
			$ret .= make_child($parnm,$ct,sq($nm),"tree2.php?act=cat&id=$catparid&prog=$typ&lev=$nxtlev",$tar,$img);
			$ct++;
		}
	}
}
		
return $ret;
}


function tree_types($parnm,$typ,$id,$img){
global $types;
	switch($typ){
		case "second":
			$ret .= tree_par($parnm."[0]","Add New ".$types[$id]['name'],"types.php?act=addtype&parid=$id","third"); 
			$SQLstr = "select  t.* from h_type t left join h_type pt on t.type_type = pt.type_id where pt.type_id ='$id' and t.type_disabled != 1 order by t.type_show_order";
			$uresult=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
			$ct=0;
			$prog = "types.php?act=showtype&id=";
			$ret .= tree_par($parnm."[1]","Parent Type",$prog.$id,"third","true");
			$ret .= tree_par($parnm."[2]","Visible to Live","","third","true");
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["type_name"];		
				$tid = $row["type_id"];
				$n = $row["type_n1"];
				$a = $row["type_a1"];
				$prog2 = "types.php?act=trigger&mid=$a&id=143";
				if ($nm != ""){
					$ret .= tree_par($parnm."[2]['children'][$ct]",$nm,$prog.$tid,"third");
					$cct=-1;
					if ($n == 1){
						$cct++;
						$ret .= make_child($parnm."[2]['children'][$ct]['children']",$cct,"Trigger",$prog2,"third",$img);
					}
					if (strlen($types[$id]['alpha1']) > 10 || $types[$tid]['meta']>0){
						$cct++;
						$ret .= make_child($parnm."[2]['children'][$ct]['children']",$cct,"Interpret","types.php?act=interpret&id=$tid","third",$img);
					}
					$ct++;
				}
			}
			$SQLstr = "select  t.* from h_type t left join h_type pt on t.type_type = pt.type_id where pt.type_id ='$id' and t.type_disabled = 1 order by t.type_show_order";
			$uresult=MYSQL_QUERY("$SQLstr");
//echo $SQLstr;
			$ct=0;
			$prog = "types.php?act=showtype&id=";
			$ret .= tree_par($parnm."[3]","Not Visible in Live","","third",$img);
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["type_name"];		
				$tid = $row["type_id"];
				$n = $row["type_n1"];
				$a = $row["type_a1"];
				$prog2 = "types.php?act=trigger&mid=$a&id=143";
				if ($nm != ""){
					$ret .= tree_par($parnm."[3]['children'][$ct]",$nm,$prog.$tid,"third");
					$cct=-1;
					if ($n == 1){
						$cct++;
						$ret .= make_child($parnm."[3]['children'][$ct]['children']",$cct,"Trigger",$prog2,"third",$img);
					}
					if ($types[$id]['alpha1'] != ""){
						$cct++;
						$ret .= make_child($parnm."[3]['children'][$ct]['children']",$cct,"Interpret","types.php?act=interpret&id=$tid","third",$img);
					}
					$ct++;
				}
			}

			break;
		case "top":
		default:
			$ret .= tree_par($parnm."[0]","Safe to Edit","",""); 
			$SQLstr = "SELECT t . * FROM h_type t LEFT JOIN h_type pt ON t.type_type = pt.type_id WHERE pt.type_code = 'top' AND t.type_n0 =0 ORDER BY t.type_show_order";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			$prog = "tree2.php?act=typ&id=";
			$prog2 = "tree2.php?act=typ&id=";
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["type_name"];		
				$id = $row["type_id"];
				$n1 = $row["type_n1"];
				if ($nm != ""){
					$ret .= make_child($parnm."[0]['children']",$ct,$nm,$prog.$id,"second",$img);
					$ct++;
				}
			}
			$ret .= tree_par($parnm."[1]","Unsafe to Edit","",""); 
			$SQLstr = "SELECT t . * FROM h_type t LEFT JOIN h_type pt ON t.type_type = pt.type_id WHERE pt.type_code = 'top' AND t.type_n0 =1 ORDER BY t.type_show_order";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			$prog = "tree2.php?act=typ&id=";
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["type_name"];		
				$id = $row["type_id"];
				if ($nm != ""){
					$ret .= make_child($parnm."[1]['children']",$ct,$nm,$prog.$id,"second",$img);
					$ct++;
				}
			}	
			break;
		}

	return $ret;
}

function tree_template($parnm,$typ,$tar,$img){
	$SQLstr = "select  * from h_template order by template_name asc";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	switch($tar){
		case "second":
			$prog = "tree2.php?act=".$typ."&id=";
			break;
		case "first":
			$prog = "tree.php?typ=".$typ."_temp_";
			break;
	}	
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["template_name"];		
		$id = $row["template_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,$prog.$id,$tar,$img);
			$ct++;
		}
	}
	return $ret;
}


//URLs

function tree_url_settings($parnm,$typ,$tar,$id){
include "global_url.inc";
include "global_template.inc";
global $types;
	get_template($template);
	$ret .= make_child($parnm,0,"<b>Status:</b> ".$types[$url_status]['name']);
	$ret .= make_child($parnm,1,"<b>Release Date:</b> ".$reldt);
	$ret .= make_child($parnm,2,"<b>Web Type:</b> ".$types[$type]['name']);
	$ret .= make_child($parnm,3,"<b>Template:</b> ".$temp_name);
	if ($visible){
		$ret .= make_child($parnm,4,"<b>ENABLED</b>");
	} else {
		$ret .= make_child($parnm,4,"<b>DISABLED</b>");
	}
	
	return $ret;
}
function tree_url_wc($parnm,$typ,$tar,$id,$img){
	include "global_url.inc";
	include "global_cat.inc";
	get_url($id);
	get_wg_info($word_group);
	if ($cat_name != "")
		$ret .= make_child($parnm,0,$cat_name,"","",$img);
	get_wg_info($word_group2);
	if ($cat_name != "")
		$ret .= make_child($parnm,1,$cat_name,"","",$img);
	
	return $ret;
}
function tree_url_images($parnm,$typ,$tar,$id,$img){
	$ret .= make_child($parnm,0,"Create Banner Image","gather.php?act=makebanner&url_id=$id","third",$img);
	$ret .= make_child($parnm,1,"Upload Banner Image","upload2.php?url_id=$id&etype=dombig","third",$img);
	$ret .= make_child($parnm,2,"Upload Logo Image","upload2.php?url_id=$id&etype=domsmall","third",$img);
	return $ret;
}


function tree_url_keywords($parnm,$typ,$tar,$id,$img){
global $url_singular;
	$SQLstr = "select * from h_links, h_keywords  where link_primary_id = kw_id and link_type='kwu' and link_secondary_id = $id ";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["kw_phrase"];		
		$kid = $row["kw_id"];
		$lid = $row["link_id"];
		if ($nm != ""){
			$ret .= tree_par($parnm."[$ct]",$nm,"","second");
			$ret .= make_child($parnm."[$ct]['children']",0,"Edit Keyword","gather.php?act=updkw&id=$kid","third");
			$ret .= make_child($parnm."[$ct]['children']",1,"Delink Keyword","gather.php?act=remlink&id=$lid","third");
//			$ret .= make_child($parnm,$ct,$nm,"","");
			$ct++;
		}
	}
	 if ($ct==0){
		$ret .= tree_par($parnm."[$ct]","Link Keyword","gather.php?act=linkkw&frmtyp=url&id=$id","third");
		$ct++;
		$ret .= tree_par($parnm."[$ct]","Add New Keyword","gather.php?act=newkw&frmtyp=kwu&id=$id&txt=".urlencode($url_singular),"third");
	}
	return $ret;
}


function tree_url_featured($parnm,$typ,$tar,$id,$img){
	$SQLstr = "select * from h_links, h_advertiser  where link_primary_id = $id and link_type='adv' and link_secondary_id = adv_id ";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["adv_name"];		
		$id = $row["adv_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,"","");
			$ct++;
		}
	}
	return $ret;
}

function tree_url_pages($parnm,$typ,$tar,$id,$img){
	$ret .= make_child($parnm,0,"Add New Page","gather.php?act=newpage&url_id=$id","third");
	$SQLstr = "select * from h_links, h_page where link_primary_id = $id and link_type='upg' and link_secondary_id = page_id order by page_priority ";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=1;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["page_priority"]." - ".str_replace(" $id","",$row['page_name']);;		
		$pid = $row["page_id"];
		$lid = $row["link_id"];
        get_page($pid);
        get_url($id);
		if ($nm != ""){
			if ($ct < 3){
				$ret .= tree_par($parnm."[$ct]",$nm,"","second","true");
			} else {
				$ret .= tree_par($parnm."[$ct]",$nm,"","second");
			}
			$ret .= make_child($parnm."[$ct]['children']",0,"Edit Page","gather.php?act=updpage&url_id=$id&page_id=$pid","third");
			$ret .= make_child($parnm."[$ct]['children']",1,"View Page","generate.php?act=viewpage&url_id=$id&page_id=$pid","third");
			$ret .= tree_page_wc($parnm."[$ct]['children'][2]",$id,"third",$pid);
			$ret .= tree_page($parnm."[$ct]['children']",$id,"third",$pid);
			$ret .= tree_par($parnm."[$ct]['children'][5]","Featured Advertisers","gather.php?act=showpageadv&page_id=$pid","third","true");
			$ret .= tree_page_adv($parnm."[$ct]['children'][5]['children']","page","third",$pid);         
			$ret .= tree_par($parnm."[$ct]['children'][6]","Images","","","");
			$ret .= tree_page_images($parnm."[$ct]['children'][6]['children']","page","third",$pid); 			
			$ret .= make_child($parnm."[$ct]['children']",6,"Delete Page","gather.php?act=rempage&url_id=$id&link_id=$lid","third");
			$ct++;
		}
	}
	return $ret;
}


//ADV
function tree_adv_details($parnm,$typ,$tar,$id,$img){
include "global_adv.inc";
global $types,$newnum;

	$ret .= make_child($parnm,0,"<b>Name:</b> $adv_nm");
	$ret .= make_child($parnm,1,"<b>Program:</b> ".$types[$adv_program]['name']);
	if ($adv_visible){
		$ret .= make_child($parnm,2,"<b>ENABLED</b>");
	} else {
		$ret .= make_child($parnm,2,"<b>DISABLED</b>");
	}
	$ret .= make_child($parnm,3,"<b>Priority:</b> $adv_priority");
	$ct = 3;
	if ($adv_link_display != ""){
//		$ct++;
//		$ret .= make_child($parnm,$ct,"<b>Link Display:</b> $adv_link_display");
	}
	if ($adv_link != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Override Link:</b> $adv_link");
	}
	if ($adv_my_ref != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 1:</b> $adv_my_ref");
	}
	if ($adv_my_ref2 != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 2:</b> $adv_my_ref2");
	}
	if ($adv_my_ref3 != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 3:</b> $adv_my_ref3");
	}
	if ($adv_my_ref4 != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 4:</b> $adv_my_ref4");
	}
	if ($adv_my_ref5 != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 5:</b> $adv_my_ref5");
	}
	$newnum=$ct;
	return $ret;
}
function tree_adv_wc($parnm,$typ,$tar,$id,$img){
include "global_adv.inc";

	switch ($adv_type){
		case ADVERTISER:
			$SQLstr = "select * from h_links,h_word where link_primary_id = $id and link_type='asc' and link_secondary_id= word_id";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["word_word"];
				$pid = $row["word_id"];
				if ($nm != ""){
					$ret .= make_child($parnm,$ct,$nm,"","",$img);
					$ct++;
				}
			}	
			break;
		case ADVERT:	
			$SQLstr = "select * from h_links,h_word where link_primary_id = $id and link_type='ac1' and link_secondary_id= word_id";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["word_word"];
				$pid = $row["word_id"];
				$wid = $row["link_secondary_id"];
				$ret .= tree_par($parnm."[$ct]",$nm,"","","true",$img);
				$SQLstr = "select * from h_links,h_wg_words, h_word where link_primary_id = $id and link_type='awc' and link_secondary_id= wgw_id AND wgw_word_id = word_id and wgw_wg_id = $wid";
				$result=MYSQL_QUERY("$SQLstr");
				$cct=0;
				while($row2 =  mysql_fetch_array($result, MYSQL_ASSOC))  { 		
					$nm = $row2["word_word"];
					$pid = $row2["word_id"];
					if ($nm != ""){
						$ret .= make_child($parnm."[$ct]['children']",$cct,$nm,"","",$img);
						$cct++;
					}
				}	
				$ct++;
			}
			break;
	}

	return $ret;
}
function tree_adv_images($parnm,$typ,$tar,$id,$img){
	$ret .= make_child($parnm,0,"Upload Image 1","upload.php?adv_id=$id&etype=adv","third",$img);
	$ret .= make_child($parnm,1,"Upload Image 2","upload.php?adv_id=$id&etype=adv2","third",$img);
	$ret .= make_child($parnm,2,"Upload Image 3","upload.php?adv_id=$id&etype=adv3","third",$img);
	return $ret;
}


function tree_adv_mer($parnm,$typ,$tar,$id,$img){
global $types,$newnum,$merprogs;
	$SQLstr = "select * from h_affiliate, h_links, h_advertiser where link_primary_id = $id and link_primary_id = adv_id and aff_id = link_secondary_id and link_type='adm' order by aff_name";		
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	$merprogs="";
	$newnum=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["aff_name"]."(".$types[$row['aff_program']]['name'].")";	
		if($row['aff_block_prods'] == 1){
			$en =	"DISABLED";
		} else {
			$en =	"ENABLED";
		}
		$uid = $row["aff_id"];	
		$aff_program = $row["aff_program"];	
		$aff_program_id = $row["aff_program_id"];	
		$aff_txt_id = $row["aff_text_id"];	
		$aff_lst_upd = $row["aff_lst_upd"];	
		$aff_pub_cat = $row["aff_pub_cat"];	
		$merprogs[]=$aff_program;
		$cct=0;
		$ret .= tree_par($parnm."[$ct]","$nm","gather.php?act=chgmer&mid=$uid&prog=$aff_program","third","true",$img);
		$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Program:</b> ".$types[$aff_program]['name']);
		$cct++;
		$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Program ID:</b> $aff_program_id");
		if ($aff_text_id != ""){
			$cct++;
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Program Text ID:</b> $aff_text_id");
		}
		if ($aff_pub_cat >0){
			$cct++;
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Default Category</b> $aff_pub_cat");
		}
		$cct++;
		$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Last Feed Update:</b> $aff_lst_upd");
		if ($row['aff_block_prods'] == 1){
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Feed Download: DISABLED</b>");
			$cct++;
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>ENABLE FEED</b>","gather.php?act=enablefeed&id=$uid","third");
		} else {
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Feed Download: ACTIVE</b>");
			$cct++;
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>DISABLE FEED</b>","gather.php?act=disablefeed&id=$uid","third");
		}
		if ($adv_my_ref != ""){
			$cct++;
			$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>Ref 1:</b> $adv_my_ref");
		}
		$cct++;
		$ret .= make_child($parnm."[$ct]['children']",$cct,"<b>TEST Feed</b>","gather.php?act=testfeed&id=$uid&prog=$aff_program","third",$img);

		$ct++;
	}
	
	$newnum=$ct;
	return $ret;
}

function tree_adv_url($parnm,$typ,$tar,$id,$img){
global $types,$newnum,$merprogs;
	$SQLstr = "select * from h_url, h_links, h_advertiser where link_secondary_id = $id and link_primary_id = url_id and adv_id = link_secondary_id and link_type='adv' order by adv_name";		
//echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	$merprogs="";
	$newnum=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["url_domain"];	
		$uid = $row["url_id"];	
		$aid = $row["adv_id"];	
		$cct=0;
		$ret .= tree_par($parnm."[$ct]","$nm","gather.php?act=chgmer&mid=$uid&prog=$aff_program","third","true",$img);
		$ct++;
	}
	
	$newnum=$ct;
	return $ret;
}

/*
function tree_adv_none($parnm,$typ,$tar,$id,$img){
global $types;
	$SQLstr = "SELECT adv_id, adv_name, count(*)  AS ct FROM h_advertiser lEFT  JOIN h_links ON link_primary_id = adv_id WHERE adv_type =33 AND link_type =  'ada'  and adv_visible = 1 GROUP  BY adv_id HAVING ct =1;";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["adv_name"];	
		$uid = $row["adv_id"];	
		$ret .= make_child($parnm,$ct,$nm,"","",$img);
		$ct++;
	}
	return $ret;
}

*/

function tree_adv_adv($parnm,$typ,$tar,$id,$img){
include "global_adv.inc";
global $newnum;

	switch ($adv_type){
		case ADVERTISER:
			$ret .= make_child($parnm,0,"Add New Advert","gather.php?act=cloadv&adv_id=$id&par_id=$id","third",$img);
			$SQLstr = "select * from h_links,h_advertiser where link_primary_id = $id and link_type='ada' and link_secondary_id= adv_id";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=1;
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["adv_name"];
				$pid = $row["adv_id"];
				load_adv($row);
				if ($nm != ""){
					if ($adv_visible == 0){ 
						$xt = "DISABLED";
					} else {
						$xt = "";
					}
					$ret .= tree_par($parnm."[$ct]","$nm $xt","gather.php?act=updadv&adv_id=$pid","third",$img);

					$ret .= tree_adv_details($parnm."[$ct]['children']","adv","third",$pid,$img);

					$num=$newnum;
					$ret .= tree_par($parnm."[$ct]['children'][$num]","Word Categories","gather.php?act=getadvwc&adv_id=$pid","third","true");
		
					$ret .=  tree_adv_wc($parnm."[$ct]['children'][$num]['children']","adv","third",$pid); 
					$num++;
					$ret .= tree_par($parnm."[$ct]['children'][$num]","Images","","","true");
					$ret .= tree_adv_images($parnm."[$ct]['children'][$num]['children']","adv","third",$pid); 
					$num++;
					$ret .= tree_par($parnm."[$ct]['children'][$num]","Statistics","gather.php?act=advstats&id=$pid","third","true");
					$num++;
					$ret .= tree_par($parnm."[$ct]['children'][$num]","Test Jump Page",$adv_full_jump,"third");
					$num++;
					$ret .= tree_par($parnm."[$ct]['children'][$num]","Clone","gather.php?act=cloadv&adv_id=$pid&par_id=$id","third");
/*	*/



					$num++;

//					$ret .= make_child($parnm."[$ct]['children']",0,"Clone","gather.php?act=cloadv&adv_id=$pid&par_id=$id","third",$img);
					$ret .= make_child($parnm."[$ct]['children']",$num,"Delete","gather.php?act=deladv&adv_id=$pid&par=$id","third",$img);
					$ct++;
				}
			}
			break;
		case ADVERT:
			$SQLstr = "select * from h_links,h_advertiser where link_secondary_id = $id and link_type='ada' and link_primary_id= adv_id";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["adv_name"];
				$pid = $row["adv_id"];
				if ($nm != ""){
					$ret .= tree_par($parnm."[$ct]","Parent","tree2.php?act=adv&id=$pid","second",$img);
					$ct++;
				}
			}
			break;
		}
	return $ret;
}

//SEARCH
function tree_sres($parnm,$typ,$tar,$id,$img){
include "global_search.inc";
global $types;

	$ret .= make_child($parnm,0,"<b>Name:</b> $search_title",$img);
	$ret .= make_child($parnm,1,"<b>Condition:</b> $search_cond",$img);
	$ret .= make_child($parnm,2,"<b>Text Display:</b> $search_display",$img);
	return $ret;
}

function tree_search($parnm,$typ,$tar,$id,$img){
include "global_search.inc";
	$ret .= make_child($parnm,0,"<b>Name:</b> $search_title",$img);
	if ($search_table < 1){
		$ret .= make_child($parnm,1,"<b>Searches:</b> Product Database",$img);
	} else {
		$ret .= make_child($parnm,1,"<b>Searches:</b> Own Product Database",$img);
	}
	$ret .= make_child($parnm,2,"<b>Condition:</b> $search_cond",$img);
	$ret .= make_child($parnm,3,"<b>Text Display:</b> $search_display",$img);
	$ret .= make_child($parnm,4,"<b>Refresh:</b> $search_refresh_dt",$img);
	$ret .= make_child($parnm,5,"<b>Add Date:</b> $search_add_dt",$img);
	if ($search_keywords['id'] > 0 ){
		$ret .= make_child($parnm,6,"<b>Keyword:</b> ".$search_keywords['phrase'],"gather.php?act=updkw&id=".$search_keywords['id'],"third");
		$ret .= make_child($parnm,7,"Delink Keyword: ".$search_keywords['phrase'],"gather.php?act=remlink&id=".$search_keywords['linkid'],"third");
	} else {
		$ret .= make_child($parnm,6,"Link Keyword","gather.php?act=linkkw&frmtyp=ser&id=$search_id","third");	
		$ret .= make_child($parnm,7,"Add New Keyword","gather.php?act=newkw&frmtyp=kws&id=$search_id&txt=".urlencode($search_title),"third");	
	}
	return $ret;
}

function tree_ser_wc($parnm,$typ,$tar,$id,$img){
	include "global_search.inc";
	include "global_adv.inc";
	include "global_cat.inc";
global $types;
//	get_search($id);
	$SQLstr = "select * from h_search_res where sres_search_id = $id";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		load_search_res($row);
		switch($sres_cat){
			case 0:
				$cat_name = "ALL";
				break;
			case 99999:
				$cat_name = "Merged";
				break;
			default:
				get_wg_info($sres_cat);
		}
		$ret .= tree_par($parnm."[$ct]",$cat_name,"","","true",$img);
		$ret .= make_child($parnm."[$ct]['children']",0,"<b>Total Returned:</b> $sres_total");
		$ret .= make_child($parnm."[$ct]['children']",1,"<b>Refresh:</b> $sres_refresh_dt");
		$ret .= make_child($parnm."[$ct]['children']",2,"<b>Seconds to Search:</b> $sres_time");
		$ret .= make_child($parnm."[$ct]['children']",3,"First Results", "gather.php?act=viewsres&id=$sres_id","third");
		$ret .= make_child($parnm."[$ct]['children']",4,"Full Results", "gather.php?act=viewfullsres&id=$sres_id","third");
		$ret .= tree_par($parnm."[$ct]['children'][5]","Analysis","tree2.php?act=showanalysis&id=$sres_id","third","");
		$ret .= tree_par($parnm."[$ct]['children'][6]","Link Image","gather.php?act=viewsresimg&id=$sres_id","third","");

		$ret .= tree_par($parnm."[$ct]['children'][7]","Linked Domains","","","");
        $ret .= tree_ser_wc3($parnm."[$ct]['children'][7]['children']","src","first",$id); 
		$ret .= make_child($parnm."[$ct]['children']",8,"Delete Results", "gather.php?act=delsres&id=$sres_id","third");
		
		$ct++;

	}
	return $ret;
}

function tree_ser_analysis($parnm,$typ,$tar,$id,$img){
	include "global_search.inc";
	include "global_adv.inc";
	include "global_cat.inc";
global $types;
//	get_search($id);
	$SQLstr = "select * from h_search_res where sres_id = $id";
//echo $SQLstr;	
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		load_search_res($row);
		switch($sres_cat){
			case 0:
				$cat_name = "ALL";
				break;
			case 99999:
				$cat_name = "Merged";
				break;
			default:
				get_wg_info($sres_cat);
		}
		$ret .= tree_par($parnm."[$ct]","Prices","","","true");
		$ret .= make_child($parnm."[$ct]['children']",0,"<b>Count:</b> ".$sres_analysis['count']);
		$ret .= make_child($parnm."[$ct]['children']",1,"<b>High Price:</b> ".$sres_analysis['hi']);
		$ret .= make_child($parnm."[$ct]['children']",2,"<b>Low Price:</b> ".$sres_analysis['lo']);
		$ret .= make_child($parnm."[$ct]['children']",3,"<b>Average Price:</b> ".$sres_analysis['avg']);
		$ret .= make_child($parnm."[$ct]['children']",4,"<b>Price Increment:</b> ".$sres_analysis['incr']);

		$ret .= tree_par($parnm."[$ct]['children'][5]","Categories","","","true");
		$rct = 0;
		foreach ($sres_analysis['cats'] as $k){
			if ($k != ""){
				$res = explode(":",$k);
				get_wg_info($res[0]);
				$ret .= make_child($parnm."[$ct]['children'][5]['children']",$rct,"$cat_name ".$res[1]);
				$rct++;
			}
		}
		
		$ret .= tree_par($parnm."[$ct]['children'][6]","Brands","","","");
		$rct = 0;
		foreach ($sres_analysis['brands'] as $k){
			if ($k != ""){
				$ret .= make_child($parnm."[$ct]['children'][6]['children']",$rct,"$k");
				$rct++;
			}
		}
		$ret .= tree_par($parnm."[$ct]['children'][7]","Advertisers","","","");
		$rct = 0;
		foreach ($sres_analysis['advs'] as $k){
			if ($k != ""){
				$res = explode(":",$k);
				get_adv($res[0]);
				$ret .= make_child($parnm."[$ct]['children'][7]['children']",$rct,"$adv_nm ".$res[1]);
				$rct++;
			}
		}
		$ret .= tree_par($parnm."[$ct]['children'][8]","Titles","","","");
		$rct = 0;
		foreach ($sres_analysis['titles'] as $k){
			if ($k != ""){
				$res = explode(":",$k);
				$ret .= make_child($parnm."[$ct]['children'][8]['children']",$rct,$res[1]." - ".$res[0]);
				$rct++;
			}
		}
		$ret .= tree_par($parnm."[$ct]['children'][9]","Programs","","","true");
		$rct = 0;
		foreach ($sres_analysis['program'] as $k){
			if ($k != ""){
				$res = explode(":",$k);
				$ret .= make_child($parnm."[$ct]['children'][9]['children']",$rct,$res[1]." - ".$types[$res[0]]['name']);
				$rct++;
			}
		}		

	}
	return $ret;
}

function tree_ser_wc2($parnm,$typ,$tar,$id,$img){
	$SQLstr = "select * from h_links,h_word where link_primary_id = $id and link_type='swc' and link_secondary_id= word_id";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["word_word"];
		$pid = $row["sres_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,"","third",$img);
			$ct++;
		}
	}
	return $ret;
}


function tree_ser_wc3($parnm,$typ,$tar,$id,$img){
	$SQLstr = "select * from h_links as p,h_links as s,h_url where url_id=p.link_primary_id  and s.link_primary_id = p.link_secondary_id and s.link_type='pgs' and p.link_type='upg' and s.link_secondary_id=$id ";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["url_name"];
		$pid = $row["sres_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,"","third",$img);
			$ct++;
		}
	}
	return $ret;
}

// CONTENT
function tree_content($parnm,$typ,$tar,$id,$img){
global $title;
	$title .= "Content ";
	switch ($typ){
		case "alpha":
			$title .= "Starting '$id'";
			$sql = " cont_title like '$id%' and ";
			break;
		case "authors":
			$title .= "by Author";
			$sql = " cont_author = '$id' and ";
			break;
		case "content":
			$title .= "by Content Template";
			$sql = " cont_type = '$id' and ";
			break;
		case "cntstatus":
			$title .= "by Content Template";
			$sql = " cont_status = '$id' and ";
			break;				
	}	
	$SQLstr = "select * from h_content $join where $sql true order by cont_title";		
//		echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["cont_title"];	
		$uid = $row["cont_id"];	
		$ret .=make_single($parnm,$ct,$nm,"content.php?act=chg&cont_id=$uid",$tar,$img);
		$ct++;
	}
	return $ret;
}

//PICTURES

function tree_pic($parnm,$typ,$tar,$id,$img){
global $title;
			$title .= "Pictures ";
			switch ($typ){
				case "alpha":
					$title .= "Starting '$id'";
					$sql = " pic_desc like '$id%' and ";
					break;
			}	
			$SQLstr = "select * from h_pictures $join where $sql true order by pic_desc";		
		//	echo $SQLstr;
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			$tree = tree_gpar("a[$nxt]",$title,"","second","true",$img);
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["pic_desc"];	
				$uid = $row["pic_id"];	
				$tree .=make_single("a[$nxt]",$ct,$nm,"tree2.php?act=pic&id=$uid",$tar,$img);
				$ct++;
			}
	return $ret;
}

//PAGE			

function tree_page($parnm,$typ,$tar,$id,$img){
global $sub;
//	$ret .= make_child($parnm,1,"Link New Searches","gather.php?act=pagelinksearches&url_id=$id","third");
	$SQLstr = "select * from h_links, h_search where link_primary_id = $id and link_type='pse' and link_secondary_id = search_id order by link_tag";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=3;
	$cct=0;
	$ret .= tree_par($parnm."[$ct]","Searches","gather.php?act=pagelinksearches&page_id=$id","third","true",$img);
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["search_title"];		
		$pid = $row["search_id"];
		$lid = $row["link_id"];
		if ($nm != ""){
			$ret .= tree_par($parnm."[$ct]['children'][$cct]",$nm,"tree2.php?act=ser&id=$pid","third",$img);
			$ret .= make_child($parnm."[$ct]['children'][$cct]['children']",0,"View Page","generate.php?act=viewpage&url_id=$typ&search_id=$pid&page_id=$id","third",$img);
			$cct++;
		}
	}
	$SQLstr = "select * from h_links, h_content where link_primary_id = $id and link_type='pgc' and link_secondary_id = cont_id order by link_tag";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct++;
	$cct=0;
	$ret .= tree_par($parnm."[$ct]","Content Units","gather.php?act=showpgcont&page_id=$id","third","true",$img);
	$ret .= make_child($parnm."[$ct]['children']",$cct,"Link New Content","content.php?act=link&page_id=$id&url_id=$sub","third",$img);
	$cct ++;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["cont_title"];		
		$pid = $row["cont_id"];
		$lid = $row["link_id"];
		if ($nm != ""){
			$ret .= tree_par($parnm."[$ct]['children'][$cct]",$nm,"content.php?act=chg&cont_id=$pid","third","",$img);
			$ret .= make_child($parnm."[$ct]['children'][$cct]['children']",0,"Delink Content","content.php?act=delink&link_id=$lid&page_id=$id&url_id=$sub","third",$img);
			$cct++;
		}
	}
	return $ret;
}

function tree_page_wc($parnm,$typ,$tar,$id,$img){
include "global_page.inc";
include "global_cat.inc";
global $sub;
	$ret .= tree_par($parnm,"Categories","gather.php?act=showpgwc&page_id=$id&url_id=$sub","third","true",$img);
	
	$ct=0;

	$SQLstr = "select * from h_links,h_wg_words, h_word where link_primary_id = $id and link_type='pwc' and link_secondary_id= wgw_id AND wgw_word_id = word_id ";
	$result=MYSQL_QUERY("$SQLstr");
	$cct=0;
	while($row2 =  mysql_fetch_array($result, MYSQL_ASSOC))  { 		
		$nm = $row2["word_word"];
		$pid = $row2["word_id"];
		$wg = $row2["link_secondary_id"];
		get_wg_info($wg);

		$ret .= tree_par($parnm."['children'][$ct]",$cat_name,"","","true",$img);
		$SQLstr = "select * from h_links,h_wg_words, h_word where link_primary_id = $id and link_type='wcp' and link_secondary_id= wgw_id AND wgw_word_id = word_id and wgw_wg_id = $wg";
		$result3=MYSQL_QUERY("$SQLstr");
		$cct=0;
		while($row3 =  mysql_fetch_array($result3, MYSQL_ASSOC))  { 		
			$nm = $row3["word_word"];
			$pid = $row3["word_id"];
			if ($nm != ""){
				$ret .= make_child($parnm."['children'][$ct]['children']",$cct,$nm,$img);
				$cct++;
			}
		}	
		$ct++;
	}
/*
	get_wg_info($page_wordgroup2);
	if ($cat_name != ""){
		$ret .= tree_par($parnm."['children'][$ct]",$cat_name,"","","true",$img);
	
		$SQLstr = "select * from h_links,h_wg_words, h_word where link_primary_id = $id and link_type='wcp' and link_secondary_id= wgw_id AND wgw_word_id = word_id and wgw_wg_id = $page_wordgroup2";
		$result=MYSQL_QUERY("$SQLstr");
		$cct=0;
		while($row2 =  mysql_fetch_array($result, MYSQL_ASSOC))  { 		
			$nm = $row2["word_word"];
			$pid = $row2["word_id"];
			if ($nm != ""){
				$ret .= make_child($parnm."['children'][$ct]['children']",$cct,$nm,$img);
				$cct++;
			}
		}	
		$ct++;
	}
*/
	return $ret;
}

function tree_page_adv($parnm,$typ,$tar,$id,$img){

	$SQLstr = "select * from h_links, h_advertiser  where link_primary_id = $id and link_type='pad' and link_secondary_id = adv_id ";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["adv_name"];		
		$id = $row["adv_id"];
		if ($nm != ""){
			$ret .= make_child($parnm,$ct,$nm,"","");
			$ct++;
		}
	}
	return $ret;
}


function tree_page_images($parnm,$typ,$tar,$id,$img){
global $sub;
	$ret .= make_child($parnm,0,"Upload Image 1","upload2.php?page_id=$id&url_id=$sub&etype=page","$tar",$img);
	return $ret;
}

//MAINT


function tree_maint($parnm,$typ,$id,$img){
	switch($typ){
	default:
			$ret .= tree_par($parnm."[0]","Maintenance","","","",$img); 
			$SQLstr = "SELECT t . * FROM h_type t WHERE t.type_type = 143 AND t.type_n1 =1 ORDER BY t.type_show_order";
			$uresult=MYSQL_QUERY("$SQLstr");
			$ct=0;
			$prog = "tree2.php?act=maint&id=";
			while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
				$nm = $row["type_name"];		
				$id = $row["type_id"];
				$n = $row["type_n1"];
				if ($nm != ""){
					if ($n == 1){
						$ret .= tree_par($parnm."[0]['children']",$ct,$nm,$prog.$id,"second","",$img);
						$ret .= make_child($parnm."[0]['children'][$ct]['children']",0,"Trigger",$prog2.$id,"second",$img);
					} else {				
						$ret .= make_child($parnm."[0]['children']",$ct,$nm,$prog.$id,"second",$img);
					}
					$ct++;
				}
			}
			break;
		}

//	return $ret;
}

//CLICKS
function tree_robots($parnm,$typ,$id,$img){

	$ret .= tree_par($parnm."[0]","Defined Robots","","","true",$img); 
	$SQLstr = "SELECT * FROM `h_robots` order by robot_name";
	$result=MYSQL_QUERY("$SQLstr");
	$ct = 0;
	if ($result) {
		while($row =  mysql_fetch_array($result, MYSQL_ASSOC))  { 
			$nm= $row['robot_name'];
			$txt= $row['robot_text'];
			$block= $row['robot_block'];
			$ret .= make_child($parnm."[0]['children']",$ct,"$nm - $txt","","","true",$img);
			$ct++;
		}
	}
	return $ret;
}
// MERCHANTS

function tree_aff($parnm,$typ,$tar,$id,$img){
include "global_affiliate.inc";
global $types;

	$ret .= make_child($parnm,0,$aff_name,"gather.php?act=chgmer&mid=$aff_id&prog=$aff_program","third");
	$ret .= make_child($parnm,1,"<b>Program:</b> ".$types[$aff_program]['name']);
	$ret .= make_child($parnm,2,"<b>Program ID:</b> $aff_program_id");
	$ret .= make_child($parnm,3,"<b>Program Text ID:</b> $aff_text_id");
	$ret .= make_child($parnm,4,"<b>Default Category</b> $aff_pub_cat");
	$ret .= make_child($parnm,5,"<b>Last Feed Update:</b> $aff_lst_upd");
	$ret .= make_child($parnm,6,"<b>TEST Feed</b>","gather.php?act=testfeed&id=$aff_id&prog=$aff_program","third");
	$ct = 6;
	if ($aff_block_prods == 1){
		$ret .= make_child($parnm,$ct,"<b>Feed Download: DISABLED</b>");
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>ENABLE FEED</b>","gather.php?act=enablefeed&id=$aff_id","third");
	} else {
		$ret .= make_child($parnm,$ct,"<b>Feed Download: ACTIVE</b>");
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>DISABLE FEED</b>","gather.php?act=disablefeed&id=$aff_id","third");
	}
	if ($adv_my_ref != ""){
		$ct++;
		$ret .= make_child($parnm,$ct,"<b>Ref 1:</b> $adv_my_ref");
	}
//	$ct++;
//	$ret .= make_child($parnm,$ct,"Mark Products for Refresh","gather.php?act=getmerfeed&mid=$aff_id","third");	
	return $ret;
}

function tree_aff_link($parnm,$typ,$tar,$id,$img){
include "global_affiliate.inc";
include "global_adv.inc";
global $types, $posttree;

	$lj = " left join h_links on (link_secondary_id = aff_id and link_type = 'adm' ) left join h_advertiser on (link_primary_id = adv_id  and adv_type != ".ADVERT." )";
	$SQLstr = "select * from h_affiliate $lj where aff_id = $id";		
//echo $SQLstr;
	$result=MYSQL_QUERY("$SQLstr");
	if ($result) {
		while($row2 =  mysql_fetch_array($result, MYSQL_ASSOC))  { 
			load_aff($row2);
			load_adv($row2);
			$adv_id = $row2['link_primary_id'];
			$link_id = $row2['link_id'];
			if ($adv_id > 0){
				$ret .= make_child($parnm,0,"$adv_nm","gather.php?act=updadv&adv_id=$adv_id","third");
				$ret .= make_child($parnm,1,"Delink Advertiser","gather.php?act=delafflink&link_id=$link_id&aff_id=$aff_id","second");
			} else {
				$posttree = "<form method=post action=\"gather.php?act=linkaff&aff_id=$aff_id&$sql\">".nonalloc_merch_list()."<input type=submit value=\"Link Advertiser\"></form>";
				$ret .= make_child($parnm,0,"Add Merchant As New Advertiser","gather.php?act=addmeradv&mid=$aff_id","third");
			}
		}
	}

	return $ret;
}

// KEYWORDS

function tree_kw_list($parnm,$id,$typ,$code,$tar,$img){
include "global_keywords.inc";
global $sub;
global $out,$wg_word, $types;


	$gct=0;
	$ret .= tree_par($parnm."[$gct]","Edit Keywords","gather.php?act=updkw&id=$id","third","");			
	$gct++;
	$ret .= tree_par($parnm."[$gct]","Link Keywords","gather.php?act=linkkw&id=$id","third","");			
	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Domains","","","true");			
	$cct=0;
	$SQLstr2 = "select * from h_url,h_links where link_primary_id = $id and link_secondary_id = url_id and link_type = 'kwu'";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['url_id'];
		$word= $row2['url_domain'];
		$lid = $row2['link_id'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,"Delink $word","gather.php?act=remlink&id=$lid","third");
		$cct++;			
	}

	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Searches","","","true");	
	$cct=0;
	$SQLstr2 = "select * from h_search,h_links where link_primary_id = $id and link_secondary_id = search_id and link_type = 'kws'";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['search_id'];
		$word= $row2['search_title'];
		$lid = $row2['link_id'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,"Delink $word","gather.php?act=remlink&id=$lid","third");
		
		$cct++;			
	}

	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Advertisers","","","true");	
	$cct=0;
	$SQLstr2 = "select * from h_advertiser,h_links where link_primary_id = $id and link_secondary_id = adv_id and link_type = 'kwa'";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['adv_id'];
		$word= $row2['adv_name'];
		$lid = $row2['link_id'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,"Delink $word","gather.php?act=remlink&id=$lid","third");
		
		$cct++;			
	}	
	
/*	

	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Pages","","","true");	
	$cct=0;
	$SQLstr2 = "select * from h_page,h_links where link_primary_id = $id and link_secondary_id = page_id and link_type = 'kwp'";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['page_id'];
		$word= $row2['page_name'];
		$lid = $row2['link_id'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,"Delink $word","gather.php?act=remlink&id=$lid","third");
		$cct++;			
		
	}


	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Categories","","","true");	
	$cct=0;
	$SQLstr2 = "select * from h_category,h_links where link_primary_id = $id and link_secondary_id = cat_id and link_type = 'kwc'";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['cat_id'];
		$word= $row2['cat_name'];
		$lid = $row2['link_id'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,"Delink $word","gather.php?act=remlink&id=$lid","third");
		$cct++;			
		
	}
*/	
	return $ret;
}

// WORD CATEGORIES

function tree_wc_list($parnm,$id,$typ,$code,$tar,$img){
include "global_page.inc";
include "global_cat.inc";
global $sub;
global $out,$wg_word, $types;
include "global_wc.inc";

	$SQLstr = "select * from h_word, h_word_groups,  h_wg_words where wg_id = $id and wg_word_id = word_id AND wgw_word_id =  wg_word_id ";		
	$result=MYSQL_QUERY("$SQLstr");
	$row =  mysql_fetch_array($result);
	$wg_word = $row['word_word'];
	$par = $row['wgw_id'];

	$gct=0;
	$ret .= tree_par($parnm."[$gct]","Add Sub Category","gather.php?act=newsubcat&id=$id","third","");			
	$gct++;
	$ret .= tree_par($parnm."[$gct]","Generate Related Domains","gather.php?act=gencat&wg=$id","third","");			

	$gct++;
	$ret .= tree_par($parnm."[$gct]","Product Analysis","gather.php?act=prodanal&wc=$id","third","");	

	//	$gct++;
//	$ret .= tree_par($parnm."[$gct]","Images","","","");	
//	$ret .= make_child($parnm."[$gct]['children']",0,"Upload Page Image","upload2.php?wg_id=$id&etype=wgpage","third");
//	$ret .= make_child($parnm."[$gct]['children']",1,"Upload Banner Image","upload2.php?wg_id=$id&etype=wgbg","third");
	
// S E A R C H E S

	$gct++;
	$ret .= tree_par($parnm."[$gct]","Linked Searches","","","open");	

	$ct++;
//	$ret .= tree_par($parnm."[$gct]['children'][$ct]","Searches","","","open");			
	$cct=0;
	$SQLstr2 = "select * from h_search where search_cat = $id or search_cat2 = $id";
	$result2=MYSQL_QUERY("$SQLstr2");
	while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
		$aid= $row2['search_id'];
		$word= $row2['search_title'];
		$ret .= make_child($parnm."[$gct]['children']",$cct,$word,$img);
		$cct++;				
	}			
	$ret .= tree_par($parnm."[$gct]","Searches $cct","","","open");	

// C A T E G O R I E S 
	$gct++;
//	$ret .= tree_par($parnm."[$gct]","Linked Merchant Categories","","","open");	

	$ct =0;
	$SQLstr = "select * from h_category where cat_pub_cat_id = $id order by cat_name";		
//echo $SQLstr;

	$result=MYSQL_QUERY("$SQLstr");
	while($row =  mysql_fetch_array($result, MYSQL_ASSOC))  { 
		$cid = $row['cat_id'];
		$cat_name = sq($row['cat_name']);
		$cat_program = $row['cat_source_type'];
		$progname = $types[$cat_program]['display'];
//		$ret .= tree_par($parnm."[$gct]['children'][$ct]","$cid $progname - $cat_name ","","","open");			
		$ct++;
	}
	$ret .= tree_par($parnm."[$gct]","Merchant Categories $ct","","","open");	


	$gct++;
	$ret .= tree_par($parnm."[$gct]","Sub Categories","","","true");			
	$parnm = $parnm."[$gct]['children']";
	$gct =-1;
	
	$SQLstr = "select * from h_word, h_word_groups, h_wg_words where wg_id = $id and word_id = wgw_word_id and wg_id = wgw_wg_id order by word_word";		
//echo $SQLstr;



// W O R D   S U M M A R Y
	$result=MYSQL_QUERY("$SQLstr");
	if ($result) {
// W O R D S 
		while($row =  mysql_fetch_array($result, MYSQL_ASSOC))  { 
			$nothing=0;
			$word= $row['word_word'];
			$origword= $row['word_word'];
			$wordid= $row['word_id'];
			$wgwid = $row['wgw_id'];
//echo $SQLstr2;
			$result2=MYSQL_QUERY("$SQLstr2");
			
			$gct++;
			$ret .= tree_par($parnm."[$gct]","$word","","","open");			
			if ($word == $wg_word){
				$global = true;
			} else {
				$global = false;
			}

	
			$ct =0;
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Sub Category Details","gather.php?act=updwc&cattyp=sub&wg_word_id=$wordid&id=$wgwid","third","");			


// W O R M H O L E S 		
			$ct++;
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Wormholes","","","true");			
			$SQLstr2 = "select * from h_word, h_word_groups, h_wg_words where wgw_word_id = $wordid and wg_id != $id and word_id = wg_word_id and wg_id = wgw_wg_id order by word_word";		
			$cct=0;

			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$word= $row2['word_word'];
				$typ = " Type A ";
				if ($word == $origword || $origword == $wg_word)
					$typ = " Type B ";
				$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,$word.$typ,$img);
				$cct++;				
			}



// D O M A I N S 		
			$ct++;
//			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Domains","","","open");			
			$SQLstr2 = "select * from h_links, h_url where link_primary_id = url_id and link_secondary_id = $wgwid and link_type = 'wc2'";
			$cct=0;

			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$word= $row2['url_domain'];
//				$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,$word,$img);
				$cct++;				
			}
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Domains $cct","gather.php?act=showwclinks&typ=dom&id=$wgwid&par=$par","third","open");			
			$nothing += $cct;

			

// P A G E S 		
			$ct++;
//			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Domains","","","open");			
			$SQLstr2 = "select * from h_links, h_page where link_primary_id = page_id and link_secondary_id = $wgwid and link_type = 'wcp'";
			$cct=0;

			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$word= $row2['url_domain'];
//				$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,$word,$img);
				$cct++;				
			}
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Pages $cct","","","open");			
			$nothing += $cct;			

			$ct++;
		//	$ret .= tree_par($parnm."[$gct]['children'][$ct]","Searches","","","open");			
			$cct=0;
			$SQLstr2 = "select * from h_links, h_search where link_primary_id = search_id and link_secondary_id = $wordid and link_type = 'swc'";
			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$aid= $row2['search_id'];
				$word= $row2['search_title'];
		//		$ret .= make_child($parnm."[$gct]['children']",$cct,$word,$img);
				$cct++;				
			}			
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Searches $cct","gather.php?act=showwclinks&typ=ser&id=$wordid&par=$id","third","open");	;				
/*
// A D V E R T I S E R


			$ct++;
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Advertisers","","","open");			
			$cct=0;
			$typ = ADVERTISER;
			$ltyp = $types[$typ]['alpha2'];
			$outd = "";
//			$outgd ="<td>";
			$SQLstr2 = "select * from h_links, h_advertiser where link_primary_id = adv_id and link_secondary_id = ".$row['wgw_id']."  and adv_type = $typ and  link_type = '$ltyp'";
//echo $SQLstr2;
			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$linkid= $row2['link_id'];
				$aid= $row2['adv_id'];
				$word= $row2['adv_name'];
//				$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,$word,$img);
				$cct++;		
			}
*/			
// A D V E R T S


			$ct++;
//			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Adverts","","","open");			
			$nothing += $cct;
			$cct=0;
			$typ = ADVERT;
			$ltyp = $types[$typ]['alpha2'];

			$SQLstr2 = "select * from h_links, h_advertiser where link_primary_id = adv_id and link_secondary_id = $wgwid and adv_type = $typ and link_type = '$ltyp'";
			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$linkid= $row2['link_id'];
				$aid= $row2['adv_id'];
				$word= $row2['adv_name'];
//				$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,$word,$img);
				$cct++;				
			}
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Adverts $cct","gather.php?act=showwclinks&typ=adv&id=$wgwid&par=$par","third","open");			
			$nothing += $cct;

			$ct++;
// LINKED MERCHANT CATS
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Merchant Categories","","","");			
			$cct=0;
	
			$SQLstr2 = "select * from h_category where cat_pub_cat_id = $wordid order by cat_name";		
			$result2=MYSQL_QUERY("$SQLstr2");
			while($row2 =  mysql_fetch_array($result2, MYSQL_ASSOC))  { 
				$cid = $row2['cat_id'];
				$cat_name = sq($row2['cat_name']);
				$cat_program = $row2['cat_source_type'];
				$progname = $types[$cat_program]['display'];
		//		$ret .= make_child($parnm."[$gct]['children'][$ct]['children']",$cct,"$cid $progname - $cat_name ",$img);
				$cct++;
			}
			$ret .= tree_par($parnm."[$gct]['children'][$ct]","Merchant Categories $cct","","","");			
			
			
			
			
			
			if ($nothing==0){
				$ct++;
				$ret .= tree_par($parnm."[$gct]['children'][$ct]","Delete Sub Category","gather.php?act=delwc&cattyp=sub&wg_word_id=$wordid&id=$wgwid","third","");			
			} else {
		//		$ct++;
		//		$ret .= tree_par($parnm."[$gct]['children'][$ct]","More Detail","tree2.php?act=swc&cattyp=sub&wg_word_id=$wordid&id=$wgwid","second","");			
			
			}

	}



	}
	return $ret;
}


//


function tree_maint_list($parnm,$typ,$tar,$id,$img){
include "global_maint.inc";
include "maint.inc";
global $types;
	switch ($typ){
		case "pending":
			$whr = " and maint_check < 999";
		case "today":
			$dt = "(maint_dt > '".date('Y-m-d')."' or maint_dt = '0000-00-00')";
			break;
		case "yest":
			$dt = "maint_dt > '".date("Y-m-d",strtotime("-1 Days"))."' and maint_dt < '".date("Y-m-d")."'";
			break;
	
	}

	$SQLstr = "select * from h_maint where $dt $whr order by maint_st_time";
//echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	$cct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		load_maint($row);
		$ret .= tree_par($parnm."[$ct]",$maint_st_time.": $maint_status","gather.php?act=showmaint&id=$maint_id","third","",$img);
		$ret .= make_child($parnm."[$ct]['children']",0,"<b>Status:</b> ".$maint_check,"","third",$img);
		$ret .= make_child($parnm."[$ct]['children']",1,"<b>Update Time:</b> ".$maint_dt,"","third",$img);
		$ret .= make_child($parnm."[$ct]['children']",2,"<b>Start Time:</b> ".$maint_st_time,"","third",$img);
		$ret .= make_child($parnm."[$ct]['children']",3,"<b>End Time:</b> ".$maint_end_time,"","third",$img);
		$ret .= make_child($parnm."[$ct]['children']",4,"<b>Tag:</b> ".$maint_tag,"","third",$img);
		$ret .= make_child($parnm."[$ct]['children']",5,"<b>Program ID:</b> ".$maint_pid,"","third",$img);
	//	$ret .= make_child($parnm."[$ct]['children']",6,"<b>Text:</b> ".substr($maint_text,0,255),"","third",$img);
		$ct++;
	}
	

	return $ret;

}


function tree_order($parnm,$typ,$tar,$id,$img){

global $types;

	$SQLstr = "select * from h_orders where order_id = $id";
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	$cct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$tm = $row['order_time'];
		$inf = explode(":",$row['order_info']);
		$ret .= make_child($parnm,0,"$tm","gather.php?act=showorder&id=$id","third");
		switch ($row['order_type']){
			case 0:
				$stat= "New";
				break;
			case 1:
				$stat= "Pending";
				break;
			case 2:
				$stat= "Paid";
				break;
			case 3:
				$stat= "Dispatched";
				break;
			case 4:
				$stat= "Returned";
				break;
			case 5:
				$stat= "Received";
				break;
			case 9:
				$stat= "Closed";
				break;
		}
		$ret .= tree_par($parnm."[1]","Status: $stat","","third");
		$ret .= make_child($parnm."[1]['children']",0,"Mark as New","gather.php?act=markorder&id=$id&sub=0","third");
		$ret .= make_child($parnm."[1]['children']",1,"Mark as Pending","gather.php?act=markorder&id=$id&sub=1","third");
		$ret .= make_child($parnm."[1]['children']",2,"Mark as Paid","gather.php?act=markorder&id=$id&sub=2","third");
		$ret .= make_child($parnm."[1]['children']",3,"Mark as Dispatched","gather.php?act=markorder&id=$id&sub=3","third");
		$ret .= make_child($parnm."[1]['children']",4,"Mark as Returned","gather.php?act=markorder&id=$id&sub=4","third");
		$ret .= make_child($parnm."[1]['children']",5,"Mark as Received","gather.php?act=markorder&id=$id&sub=5","third");
		$ret .= make_child($parnm."[1]['children']",6,"Mark as Closed","gather.php?act=markorder&id=$id&sub=9","third");

		$ret .= tree_par($parnm."[2]","Retrokitty informaton","","third","true");
		foreach ($inf as $ritm){
			if ($ritm > 0){
				$cct++;
				$ret .= make_child($parnm."[2]['children']",$cct-1,"Retrokitty Item $cct: $ritm","http://www.retrokitty.co.uk/ebay/item.php?act=upd&id=$ritm","third");
			}
		}
		$ret .= tree_par($parnm."[3]","Actions","","third","true");
		for ($i = 1; $i < 10;$i++){
			if ($types[SHOPMAILS]['alpha'.$i] != ""){
				$dets = explode(":::",$types[SHOPMAILS]['alpha'.$i]);
				$ret .= make_child($parnm."[3]['children']",$i-1,$dets[0],"email.php?act=$i&id=$id","third");
			}
		}
		$ct++;
	}
	

	return $ret;

}


// PRODUCT CATEGORIES
function tree_pcat($parnm,$typ,$tar,$id,$img){
global $types;
global $pt_nm,$pt_disp,$pt_id,$pt_desc;
	$SQLstr = "select * from h_type where type_type = 264 order by type_name";		
//		echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];	
		$uid = $row["type_id"];	
		$ret .= tree_par($parnm."['children'][$ct]",$nm,"","","true",$img);
//		$ret .= make_child($parnm."[$ct]['children']",0,"Edit $nm","gather.php?act=updpcat&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",0,"Edit $nm","gather.php?act=updpcat&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",1,"Edit Raw Type","types.php?act=showtype&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",2,"Link New Type","gather.php?act=linkpcattype&id=$uid","third");
		$cct= 3;
		$ret .= tree_par($parnm."['children'][$ct]['children'][$cct]","Types of $nm","","");
		$SQLstr = "select * from h_links,h_type where link_primary_id = $uid and link_type='c2t' and link_secondary_id= type_id ";
		$result3=MYSQL_QUERY("$SQLstr");
		$ccct=0;
		while($row3 =  mysql_fetch_array($result3, MYSQL_ASSOC))  { 		
			$tid = $row3["type_id"];
			get_ptyp($tid);
			if ($nm != ""){
				$ret .= make_child($parnm."['children'][$ct]['children'][$cct]['children']",$ccct,"$pt_nm","","");
			}
			$ccct++;
		}
		$ct++;
	}
	return $ret;
}

// PRODUCT TYPES
function tree_ptyp($parnm,$typ,$tar,$id,$img){
global $types;
global $pt_nm,$pt_disp,$pt_id,$pt_desc;
global $pi_nm,$pi_disp,$pi_id,$pi_desc;
	$SQLstr = "select * from h_type where type_type = 265 order by type_name";		
//		echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];	
		$uid = $row["type_id"];	
		$ret .= tree_par($parnm."['children'][$ct]",$nm,"","","",$img);
		$ret .= make_child($parnm."['children'][$ct]['children']",0,"Edit $nm","gather.php?act=updptyp&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",1,"Edit Raw Type","types.php?act=showtype&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",2,"Link New Item","gather.php?act=linkptypitem&id=$uid","third");
		$cct= 3;
		$ret .= tree_par($parnm."['children'][$ct]['children'][$cct]","Items of $nm","","");
		$SQLstr = "select * from h_links,h_type where link_primary_id = $uid and link_type='t2i' and link_secondary_id= type_id ";
		$result3=MYSQL_QUERY("$SQLstr");
		$ccct=0;
		while($row3 =  mysql_fetch_array($result3, MYSQL_ASSOC))  { 		
			$tid = $row3["type_id"];
			get_pitm($tid);
			if ($nm != ""){
				$ret .= make_child($parnm."['children'][$ct]['children'][$cct]['children']",$ccct,"$pi_nm","","");
			}
			$ccct++;
		}
		$ct++;
	}
	return $ret;
}


// PRODUCT ITEMS
function tree_pitm($parnm,$typ,$tar,$id,$img){
global $types;
global $pc_nm,$pc_id,$pc_neg,$pc_pos,$pc_neg_raw,$pc_pos_raw;
global $pi_nm,$pi_disp,$pi_id,$pi_desc,$pi_pos,$pi_neg,$pi_cri;
	$SQLstr = "select * from h_type where type_type = 266 order by type_name";		
//		echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];	
		$uid = $row["type_id"];	
		$ret .= tree_par($parnm."['children'][$ct]",$nm,"","","",$img);
		$ret .= make_child($parnm."['children'][$ct]['children']",0,"Edit $nm","gather.php?act=updpitm&id=$uid","third");
	//	$ret .= make_child($parnm."['children'][$ct]['children']",1,"Edit Raw Type","types.php?act=showtype&id=$uid","third");
	//	$ret .= make_child($parnm."['children'][$ct]['children']",2,"Link New Criteria","gather.php?act=linkpitmcri&id=$uid","third");
		$cct= 1;
		$ret .= tree_par($parnm."['children'][$ct]['children'][$cct]","Criteria","gather.php?act=linkpitmcri&id=$uid","third","true");
		$cri = explode(":::",$types[$uid]['alpha5']);
//echo "cri $cri $uid ";		
		$ccct=0;
		foreach ($cri as $c){
			$z  = explode(";;;",$c);
			$d = explode(":::",$types[$z[0]]['alpha'.$z[1]]);
			$ret .= make_child($parnm."['children'][$ct]['children'][$cct]['children']",$ccct,$d[0],"","");
			$ccct++;
		}
		$ct++;
	}
	return $ret;
}
// PRODUCT ITEMS
function tree_pcri($parnm,$typ,$tar,$id,$img){
global $types;
global $pc_nm,$pc_id,$pc_neg,$pc_pos,$pc_neg_raw,$pc_pos_raw;
global $pi_nm,$pi_disp,$pi_id,$pi_desc,$pi_pos,$pi_neg,$pi_cri;
	$SQLstr = "select * from h_type where type_type = 267 order by type_name";		
//		echo $SQLstr;
	$uresult=MYSQL_QUERY("$SQLstr");
	$ct=0;
	while($row =  mysql_fetch_array($uresult, MYSQL_ASSOC))  { 		
		$nm = $row["type_name"];	
		$uid = $row["type_id"];	
		$ret .= tree_par($parnm."['children'][$ct]",$nm,"","","true",$img);
//		$ret .= make_child($parnm."['children'][$ct]['children']",0,"Edit $nm","gather.php?act=updpcri&id=$uid","third");
		$ret .= make_child($parnm."['children'][$ct]['children']",0,"Edit Raw Type","types.php?act=showtype&id=$uid","third");
/*		$ret .= make_child($parnm."['children'][$ct]['children']",2,"Link New Criteria","gather.php?act=linkpitmcri&id=$uid","third");
		$cct= 3;
		$ret .= tree_par($parnm."['children'][$ct]['children'][$cct]","$nm Criteria","gather.php?act=linkpitmcri&id=$uid","third");
		$cri = explode(":::",$types[$uid]['alpha5']);
//echo "cri $cri $uid ";		
		$ccct=0;
		foreach ($cri as $c){
			$z  = explode(";;;",$c);
			$d = explode(":::",$types[$z[0]]['alpha'.$z[1]]);
			$ret .= make_child($parnm."['children'][$ct]['children'][$cct]['children']",$ccct,$d[0],"","");
			$ccct++;
		}
*/
		$ct++;
	}
	return $ret;
}

// OFFERS
function tree_offers($parnm,$typ,$tar,$id,$img){
global $types;
	$ret .= make_child($parnm."['children']",0,"Get Offers","gather.php?act=testoffers","third");
	$ret .= make_child($parnm."['children']",1,"Show Live Offers","gather.php?act=showliveoffers","third");
	$ret .= make_child($parnm."['children']",2,"Show Avaiable Offers","gather.php?act=showoffers","third");
	return $ret;
}

//QUERIES


function tree_queries($parnm,$typ,$tar,$id,$img){
global $types;
	$ret .= make_child($parnm,0,"Enter Query Direct","gather.php?act=query","third");
	$ret .= make_child($parnm,1,"Stored Queries","gather.php?act=storedqueries","third");
	$ret .= make_child($parnm,2,"Stored Query Definitions","tree2.php?act=typ&id=334","second");
	return $ret;
}
?>