<?php require_once('../Connections/BE2.php'); ?>
<? 
$scode=isset($_GET['menu'])?$_GET['menu']:'8888888';
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'];   
 
mysql_select_db($database_BE2, $BE2);
$query_Rt3 = sprintf("SELECT * FROM ecardshop WHERE coid= 1 OR coid='%s' order by 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);
 

$bimg="/ecard/reimg/user_".sprintf("%07d",$row_Rtt['mem_auto']).'.'.$row_Rtt['mem_logo2'] ;  // no

do {   
    $sel='N';
	
	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)); ?>
 
 

<div class="container">
<?  
   $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 class="clearfix"> </div>
</div>         
        	
 <div class="clearfix"> </div>            
             
          
 
<?php
  mysql_free_result($Rt4);
  mysql_free_result($Rt3);
  mysql_free_result($Rtt);
?>
      