<?php require_once('../Connections/BE2.php'); ?>
<? 
$scode=isset($_GET['menu'])?$_GET['menu']:'8888888';
$webimagepath = "/products/";

if($scode==''){ $scode='8888888';}
  
mysql_select_db($database_BE2, $BE2);
$query_Rtt = sprintf("SELECT * FROM member WHERE scode='%s'", $scode);
$Rtt = mysql_query($query_Rtt, $BE2) or die(mysql_error());
$row_Rtt = mysql_fetch_assoc($Rtt);
$mem_auto=$row_Rtt['mem_auto'];   

//global $webtitle;
$webtitle=$row_Rtt['mem_user2'];
 
mysql_select_db($database_BE2, $BE2);
//$query_Rt3 = sprintf("SELECT * FROM ecardshop WHERE coid= 1 OR coid='%s' order by windex",$mem_auto) ; 
$query_Rt3 = sprintf("SELECT * FROM ecardshop WHERE coid= 1 OR coid='%s' order by coid,windex",$mem_auto) ;
$Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error());
$row_Rt3 = mysql_fetch_assoc($Rt3);
$totalRows_Rt3 = mysql_num_rows($Rt3);
$arr1=array();
$i=0;

mysql_select_db($database_BE2, $BE2);
$query_Rt4 = sprintf("SELECT * FROM ecardext WHERE wflag=1 and wkid=1 and wuid='%s' order by windex",$mem_auto) ; 
$Rt4 = mysql_query($query_Rt4, $BE2) or die(mysql_error());
$row_Rt4 = mysql_fetch_assoc($Rt4);
$totalRows_Rt4 = mysql_num_rows($Rt4);
$homebaneer=true; 

$bimg="/ecard/reimg/user_".sprintf("%07d",$row_Rtt['mem_auto']).'.'.$row_Rtt['mem_logo2'] ;  // no
$bimg2="/ecard/img/user_".sprintf("%07d",$row_Rtt['mem_auto']).'.'.$row_Rtt['mem_logo2'] ;  // no
do {   
    $sel='Y';
	
	if(($row_Rt3['coid']>1 )&& ($row_Rt3['wflag']>0)){ $i=$row_Rt3['windex']-1; $sel='Y';}
	else if($row_Rt3['windex']==5) { $i=$row_Rt3['windex']-1; $sel='Y';}
	
    $arr1[$i][0]=$row_Rt3['wid']; 
	$arr1[$i][1]=$row_Rt3['coid'];
    $arr1[$i][2]=($sel=='Y')?$row_Rt3['wtitle']:"";
	$arr1[$i][3]=($sel=='Y')?$row_Rt3['wimg'].'.'.$row_Rt3['wimgext']:"blank.jpg";
	$arr1[$i][4]=($sel=='Y')?$row_Rt3['wlink']:'#' ;//   $row_Rt3['wlink']:"";"./".$scode.'-'.($i+1)
	$arr1[$i][5]=$sel;
	$i++;
 }  while ($row_Rt3 = mysql_fetch_assoc($Rt3));
 
  $show_banner=false;
  
  $totalRows_Rtp =0;
 
 if($show_banner){
   mysql_select_db($database_BE2, $BE2);
   $query_Rtp =sprintf("SELECT a.*,b.*,c.* FROM adpage as a left join ap2 as b on a.pid=b.webid  AND b.raflag='Y' left join adpic as c on  b.adid=c.xid and c.flag ='Y' and c.edate > '%s' WHERE a.plink='%s' order by raindex,xid,ind",date('Y-m-d'),"VVVV");  //雲端異業互聯.ht
   $Rtp = mysql_query($query_Rtp, $BE2) or die(mysql_error());
   $row_Rtp = mysql_fetch_assoc($Rtp);
   $totalRows_Rtp = mysql_num_rows($Rtp);
   
   if($totalRows_Rtp>0) {
    $i=0;
    $c=0; 
    $x=0;
    $webpage=array();	
    do { 
  if($x <> $row_Rtp['xid']) { 
    $xidcount[$c]=$i ;
    $xidmark[$c]=$row_Rtp['ramark'] ;
    $xidtitle[$c]=$row_Rtp['radoc'] ;
	$xidshowtitle[$c]=$row_Rtp['ratshow'] ;
    $webxid[$c]=$row_Rtp['xid'] ;
	$webpage[$c] = $row_Rtp['raid'];
	$raicon[$c] = $row_Rtp['raicon']; 
	$x=$row_Rtp['xid'];
	$c++;}
 // if($x <> $row_Rtp['raid']) { $webpage[$c] = $row_Rtp['raid']; $x=$row_Rtp['raid'];$c++;}
 
  $raid[$i]=$row_Rtp['raid'];
  $id[$i]=$row_Rtp['id'];
  $xid[$i]=$row_Rtp['xid'];
 // $web[$i]=$row_Rtp['raid'];
  $link[$i]=$row_Rtp['link'];
  $linktag[$i]=$row_Rtp['linktag'];
  $doc[$i]=$row_Rtp['doc'];
  $radoc[$i]=$row_Rtp['radoc'];
  
  $img[$i]=$row_Rtp['img'];
  $imgext[$i]=$row_Rtp['imgext'];
  $imgtxt[$i]=$row_Rtp['imgtxt'];
  $ratxt[$i]=$row_Rtp['ratxt'];
  $i++; 
  } while ($row_Rtp = mysql_fetch_assoc($Rtp)); 
     }

 }

mysql_select_db($database_BE2, $BE2);
$query_Rt5 = sprintf("SELECT * FROM ecardshop WHERE coid='%s' AND windex=0",$mem_auto) ; 
$Rt5 = mysql_query($query_Rt5, $BE2) or die(mysql_error());
$row_Rt5 = mysql_fetch_assoc($Rt5);
$totalRows_Rt5 = mysql_num_rows($Rt5);

  ?>

<div class="container">
  <div class="clearfix"> </div>
  <? 
   $img='/products/000830284715.jpg';
      //$img='/products/000830284715.jpg';
  // $img=$arr1[4][3];
   if(($totalRows_Rt5>0) && ($row_Rt5['wimgext']<>'')){
             $img="/ecard/img/".$row_Rt5['wimg'].'.'.$row_Rt5['wimgext'];
		   }
  $ilink='';;
   if($row_Rt5['wlink']<>''){$ilink=$row_Rt5['wlink']; } ;	    
   ?>        
  <row class="thumbnail" ><?= ($ilink=='')?'':'<a href="'.$ilink.'">' ; ?><img name="" src="<?= $bimg2 ?>" width="100%" alt="<?= isset($row_Rt5['wtitle'])?$row_Rt5['wtitle']:'' ?>" /> <?= ($ilink=='')?'':'</a>' ;?> 
   <div style="text-align:center"><?= isset($row_Rt5['wtitle'])?$row_Rt5['wtitle']:'' ?></div> 
  </row>
  <div class="clearfix"> </div>
<row>
<? // style="margin-right:50;margin-left:50" ?>
<div class="container">
<div class="container-fluid  g-py-10 g-bg-white" >
      <div class="row no-gutters align-items-center">
       
           <? /*  mobile mode */ ?>
        	<span class="col-9">
			<span class="g-font-size-18">
			<?= $row_Rtt['mem_title'] ; ?></span>
            </span>
           <span class="col-3 g-font-size-12" >
        		<span style="float:right;vertical-align:bottom;">會員編號：</span>  
           </span>
          
        
     
         <div class="col-9 ">
        	<span class="g-font-size-18">
             <? /* $row_Rt2['mem_user'].' '.$row_Rt2['scode']; ?> &nbsp;<?= $row_Rt2['mem_name_en'] ; */
        		echo $row_Rtt['mem_user'].' '.$row_Rtt['mem_user2']; ?> &nbsp;<?= $row_Rtt['mem_name_en'] ; ?> 
        	</span>
         </div>
    
    
 
        <div class="col-3 ">
        	<span class="g-font-size-12">
        		<span style="float:right"><?= $row_Rtt['scode']; ?>&nbsp;&nbsp;&nbsp;</span>  
        	</span>
        </div>
      </div>
</div>
</div>
<?  
 
 if($totalRows_Rtp>0) {
   	  $runscript= count($webpage);
	  $rcount=0;
	  $rstop=1;
	  $rstop2=0;
    	while ($runscript>0 ){
		
		 if($rstop==1){	
		   $rstop=0;
		   $this_xid= $webxid[$rcount];
	       $web ="../banner_".$webpage[$rcount].".php"; 
	       include $web;
 		   $rcount ++;
		   $runscript --;
	        }
		 $rstop2++;
		 if($rstop2>100000){$runscript=-1;}	
		  	
		 }  
      } ?>

 <? 
   $cl=0;
   for($i=0;$i<9;$i++){ ?>
       <div class="col-md-4 col-xs-4 col-sm-4">
       <div class="thumbnail">
         <? if($i==4){?>
           <a href="/ecard/<?= $scode ?>" target="_self"><img src="<?= $bimg ?>" alt="<?= $arr1[$i][2];?>" title="<?= $arr1[$i][2];?>" width="100%"/></a>
         <? }else{ ?>
          <a href="<?= ($arr1[$i][4]=="")?"#":$arr1[$i][4] ; ?>" target="_blank"><img src="/ecard/reimg/<?= $arr1[$i][3]?>" alt="<?= $arr1[$i][2];?>" title="<?= $arr1[$i][2];?>"/></a>
          <? } ?>
            
       </div>
            <div style="text-align:center"><?=  $arr1[$i][2] ;?></div> 
       </div>
       
    <? $cl++;  
	    if(( $cl% 3)==0 ){ ?> <div class="clearfix"> </div> <? }  ?>  
       
    <? } ?>     
    <div class="clearfix"> </div>
     
 <? 
 if($totalRows_Rt4>0){
   $cl=0;	   
   do { 
     $wtitle= $row_Rt4['wtitle'] ;
	 $wimg= $row_Rt4['wimgext']==''?"blank.jpg": $row_Rt4['wimg'].'.'.$row_Rt4['wimgext'];
	 $wlink=($row_Rt4['wlink']=='')?'#':$row_Rt4['wlink'] ;//   $row_Rt3['wlink']:"";"./".$scode.'-'.($i+1)
    ?>
    <div class="col-md-4 col-xs-4 col-sm-4">
       <div class="thumbnail">
        <a href="<?= $wlink;?>" target="_self"><img src="/ecard/reimg/<?= $wimg ?>" title="<?= $wtitle;?>" width="100%"/></a>
       </div>
            <div style="text-align:center"><?=  $wtitle ;?></div> 
  </div>
         <? $cl++;  
	    if(( $cl% 3)==0 ){ ?> <div class="clearfix"> </div> <? }  ?>  
 
  <? }  while ($row_Rt4 = mysql_fetch_assoc($Rt4));
  
 } // end $totalRows_Rt4
 
  ?>  
</div>
 
 <div class="fixed d-block d-md-none" >
    <div class="container-fluid  g-py-10 g-bg-white" >
      <div class="row no-gutters align-items-center">
       
           <? /*  mobile mode */ ?>
  
        <? 
		 $_GET['scode']=$row_Rtt['scode'];
		 $_GET['mem_mail']=$row_Rtt['mem_mail'];
		//include "block6.php"; ?>
        
        <!-- block6 -->
              <div class="col g-mr-10">
			<a href="<?= $row_Rtt['mem_line'] ?>" target="_self"><img class="img-fluid" src="/images/line.png" alt="Image"></a>
        </div>
        <div class="col g-mr-10">

        	<a href="https://maps.google.com.tw/maps/place/104<?= $row_Rtt['mem_google'] ?>" target="_self"><img class="img-fluid" src="/images/4326_10.png" alt="Image"></a>
         </div>
        <div class="col g-mr-10">
			<a href="mailto:<?= $row_Rtt['mem_mail'] ?>"><img class="img-fluid" src="/images/email.png" alt="Image"></a>
        </div>
        <div class="col g-mr-10">
 
           <? /* <a href="/vipecard/<?= $row_Rtt['scode']; ?>"><img class="img-fluid" src="/images/vipmember.png" alt="Image"></a> */ ?>
            <a href="tel:<?= $row_Rtt['mem_mobile2'] ?>"><img class="img-fluid" src="/images/mobile.png" alt="Image"></a>

        </div>
        <div class="col g-mr-10">
          <a href="/registerform.html?recom=<?= $row_Rtt['scode']; ?>" target="_self"><img class="img-fluid w-100" src="/qrcode.php?qr=https://www.skybni.com/registerform.html?recom=<?= $row_Rtt['scode']; ?>" alt="<?= $row_Rt2['mem_user']; ?>"></a>
 
                 </div>
        <div class="col">
          <a href="/registerform.html?recom=<?= $row_Rtt['scode']; ?>" target="_self">
          <img class="img-fluid" src="/images/signup.png" alt="Image" > </a> 
			<? /* <img class="img-fluid" src="/images/signup.png" alt="Image" onClick="register_me()"> */ ?>
        </div>
        <!-- block6 -->
      </div>
</div>

     <?  // include "../footer_for_other.php";  ?>
 
    <div class="container-fluid g-py-15   g-bg-blue">
      <div class="row no-gutters align-items-center">
        <div class="col text-center">
          <a href="<?= $_SESSION['login_memid']==''?'/login.html':'/guest/'; ?>" class="g-font-size-14 g-color-white">
          	<i class="fa fa-user-circle-o g-font-size-20 g-color-white"></i><br><?= $_SESSION['login_memid']==''?'登入':'管理'; ?>
          </a>
        </div>
        <div class="col text-center">
          <a href="/registerform.html?recom=<?= $scode ?>" class="g-font-size-14 g-color-white">
          	<i class="fa fa-vcard g-font-size-20 g-color-white"></i><br>註冊
          </a>
        </div>
         <? 
		 $REQUEST_URI=$_SERVER['REQUEST_URI']; 
         $pos = strpos($REQUEST_URI, '/',1);
         if($pos>0){
        	 $REQUEST_URI=substr($REQUEST_URI,0,$pos+1);
          }else{ $REQUEST_URI='/' ;}
		  
		 if($REQUEST_URI=='/ecard/'){
			// $arrtitle=array("增加頁面","廣告會員","刊登廣告"); 會員網 旅遊網 購物網 員網 旅遊網  購物網 
			 $arrtitle=array("會員網","旅遊網","購物網");  
			 //$arrlink=array("/categoryDetail-4154.html","/categoryDetail-4115.html","/刊登廣告.html");
			 $arrlink=array("/adkind/","/travel/","/shopmap/");
		 }else{ 
		     $arrtitle=array("會員網","互聯網","旅遊網"); 
		     $arrlink=array("/adkind/","/shopmap/","/travel/");
		   } 
       ?>
        <div class="col text-center"> 
          <a href="<?=$arrlink[0]; ?>" class="g-font-size-14 g-color-white">
          	<i class="fa fa-cart-plus g-font-size-20 g-color-white"></i><br><?=$arrtitle[0] ;?>
          </a>
        </div>
       
        <div class="col text-center">
          <a href="<?=$arrlink[1]; ?>" class="g-font-size-14 g-color-white">
          	<i class="fa fa-globe g-font-size-20 g-color-white"></i><br><?=$arrtitle[1] ;?>
          </a>
        </div>
        <div class="col text-center">
          <a href="<?=$arrlink[2]; ?>" class="g-font-size-14 g-color-white">
          	<i class="fa fa-bus g-font-size-20 g-color-white"></i><br><?=$arrtitle[2] ;?>
          </a>
        </div>
      </div>
</div>  
 
</div>
 
</div>         
        	
 <div class="clearfix"> </div>            
             
          
 
<?php
  mysql_free_result($Rt5);
  mysql_free_result($Rt4);
  mysql_free_result($Rt3);
  mysql_free_result($Rtt);
?>
      