eclass.unmer.ac.id

<?php

session_start();

require '../includes/conexao/funcao.inc.php';
require '../includes/conexao/config.php';
require '../includes/conexao/conn.php';
require '../includes/conexao/function.php';

$id  = $_REQUEST['id'];
/*$row = $_REQUEST['row'];
$limite = $row-10; 
*/

$queryc = "SELECT * FROM cw_chat WHERE flw_chat='$id'";
$linkc   = DBConnect();
$resultc = @mysqli_query($linkc, $queryc) or die(mysqli_error($linkc));

while($resc = mysqli_fetch_assoc($resultc)){

$queryuser = "SELECT nome_user, sobrenome_user, img_user FROM cw_user WHERE id_user='$resc[usuario_chat]'";
$resultuser = DBExecute($queryuser);
$resuser = mysqli_fetch_assoc($resultuser);
$nome_user      = $resuser['nome_user'];
$sobrenome_user = $resuser['sobrenome_user'];
$img_user       = $resuser['img_user'];

if($resc['usuario_chat']==$_SESSION['IDCLI']){$lado = "pull-right";}else{$lado = "pull-left";}
?> 
 <div class="feed-element" style="padding:10px 20px; color:#000; margin:3px">
                                                    
        <div class="media-body" style="margin-bottom:-14px; margin-top:-18px">
            
            <?php if($resc['tipo_chat']==0){ ?>
            
            <div class="well <?php echo $lado; ?> conversas" style="background-color:#FFF; color:#000; max-width:60%; min-width:30%; padding-top:5px; padding-left:10px; padding-right:7px; padding-bottom:-5px" id="<?php echo $resc['id_chat']; ?>">
            
            <a href="#" class="<?php echo $lado; ?>">
            <img alt="image" style="margin-right:3px; margin-left:3px" class="img-circle" src="../img-perfil/img/perfil/<?php if($img_user==''){echo"img/profile_small.jpg";}else{echo $img_user;} ?>">
            </a>
            <strong><?php echo $nome_user; ?> <?php echo $sobrenome_user; ?></strong> 
            <small class="text-muted "> <?php echo dbDateToDate2($resc['data_chat']); ?> às <?php echo $resc['hora_chat']; ?></small> 
            <span class="fav_<?php echo $resc['id_chat']; ?>" style="cursor:pointer; display:none">
            <?php
            $queryf     = "SELECT id_favoritos FROM cw_favoritos 
            WHERE chat_favoritos='$resc[id_chat]' AND user_favoritos='$_SESSION[IDCLI]'";
            $linkf      = DBConnect();
            $resultf    = @mysqli_query($linkf, $queryf) or die(mysqli_error($linkf));
            $rowsf      =  mysqli_num_rows($resultf);
            if($rowsf==0){ ?>
            &nbsp; <i class="fa fa-star-o star" id="<?php echo $resc['id_chat']; ?>" title="Adicionar aos favoritos" style="float:right; font-size:16px"></i> 
            <?php }else{ ?>
            &nbsp; <i class="fa fa-star star2" id="<?php echo $resc['id_chat']; ?>" title="Adicionado aos favoritos" style="float:right; font-size:16px"></i> 
            <?php } ?>
            </span><br />  
               
               
             <span style="margin-top:8px; font-size:12px; text-align:justify">   <?php echo nl2br($resc['texto_chat']); ?>
             </span> 
                
            </div>

<?php }elseif(($resc['tipo_chat']==99)OR($resc['tipo_chat']==98)){ ?>
            
            <div class="well <?php echo $lado; ?> conversas" style="background-color:#FF9; color:#000; max-width:60%; min-width:30%; padding-top:5px; padding-left:10px; padding-right:7px; padding-bottom:-5px" id="<?php echo $resc['id_chat']; ?>">
            
            <?php if($resc['destino_chat']==0){ ?>
            <a href="#" class="<?php echo $lado; ?>">
            
            </a>
            <?php } ?>

<?php if($resc['status_chat']==1){ ?>
            <div id="lido" style="border-bottom: 1px solid #CCC; width: 85%">
            <i class="fa fa-check" style="color: blue"></i> <small class="text-muted ">
            <?php echo $resc['lidopor_chat']; ?><br />
            Em: <?php echo dbDateToDate2($resc['dtlido_chat']); ?> às <?php echo $resc['hrlido_chat']; ?></small><br />
            </div>
            <?php } ?>

<small class="text-muted "> <?php echo dbDateToDate2($resc['data_chat']); ?> às <?php echo $resc['hora_chat']; ?></small> 
            <span class="fav_<?php echo $resc['id_chat']; ?>" style="cursor:pointer; display:none">
            <?php
            $queryf     = "SELECT id_favoritos FROM cw_favoritos 
            WHERE chat_favoritos='$resc[id_chat]' AND user_favoritos='$_SESSION[IDCLI]'";
            $linkf      = DBConnect();
            $resultf    = @mysqli_query($linkf, $queryf) or die(mysqli_error($linkf));
            $rowsf      =  mysqli_num_rows($resultf);
            if($rowsf==0){ ?>
            &nbsp; <i class="fa fa-star-o star" id="<?php echo $resc['id_chat']; ?>" title="Adicionar aos favoritos" style="float:right; font-size:16px"></i> 
            <?php }else{ ?>
            &nbsp; <i class="fa fa-star star2" id="<?php echo $resc['id_chat']; ?>" title="Adicionado aos favoritos" style="float:right; font-size:16px"></i> 
            <?php } ?>
            </span><br />  
               
               
             <span style="margin-top:8px; font-size:12px; text-align:justify">   <?php echo nl2br($resc['texto_chat']); ?>
             </span> 
                
            </div>
            
            <?php }
            
            
            
            
            
            
            
            
            
            
            
            elseif($resc['tipo_chat']==1){ ?>
            
            
            <div class="text-center well" style="padding:10px; border:0; background: transparent">
            
            <span style="background-color:#E1F3FB; margin-top:8px; font-size:12px; text-align:justify; padding:7px; -webkit-box-shadow: 1px 1px 0px #ccc; border-radius:5px; color:#202020">   <?php echo nl2br($resc['texto_chat']); ?>
             </span> 
                
            </div>

<?php }elseif($resc['tipo_chat']==2){ ?>
            
            
            <div class="text-center well" style="padding:10px; border:0; background: transparent">
            
            <span style="background-color:#F00; margin-top:8px; font-size:12px; text-align:justify; padding:7px; -webkit-box-shadow: 1px 2px 0px #ccc; border-radius:5px; color:#FFF; font-weight:bold">   <?php echo nl2br($resc['texto_chat']); ?>
             </span> 
                
            </div>
                
            
            <?php }elseif($resc['tipo_chat']==3){ ?>
            
            
            <div class="text-center well" style="padding:10px; border:0; background: transparent">
            
           <span style="background-color:#E1F3FB; margin-top:8px; font-size:12px; text-align:justify; padding:7px; -webkit-box-shadow: 1px 1px 0px #ccc; border-radius:5px; color:#202020; font-weight:bold">   <?php echo nl2br($resc['texto_chat']); ?>
             </span> 
                
            </div>
                
                
            <?php }elseif($resc['tipo_chat']==5) { ?>
            
            <div class="well <?php echo $lado; ?> conversas" style="background-color:#FFF; color:#000; max-width:60%; min-width:30%; padding-top:5px; padding-left:10px; padding-right:7px; padding-bottom:-5px" id="<?php echo $resc['id_chat']; ?>">
            
            <a href="#" class="<?php echo $lado; ?>">
            <img alt="image" style="margin-right:3px; margin-left:3px" class="img-circle" src="../img-perfil/img/perfil/<?php if($img_user==''){echo"img/profile_small.jpg";}else{echo $img_user;} ?>">
            </a>
            <strong><?php echo $nome_user; ?> <?php echo $sobrenome_user; ?></strong>
            <small class="text-muted "> <?php echo dbDateToDate2($resc['data_chat']); ?> às <?php echo $resc['hora_chat']; ?></small>
            <span class="fav_<?php echo $resc['id_chat']; ?>" style="cursor:pointer; display:none">
            <?php
            $queryf     = "SELECT id_favoritos FROM cw_favoritos 
            WHERE chat_favoritos='$resc[id_chat]' AND user_favoritos='$_SESSION[IDCLI]'";
            $linkf      = DBConnect();
            $resultf    = @mysqli_query($linkf, $queryf) or die(mysqli_error($linkf));
            $rowsf      =  mysqli_num_rows($resultf);
            if($rowsf==0){ ?>
            &nbsp; <i class="fa fa-star-o star" id="<?php echo $resc['id_chat']; ?>" title="Adicionar aos favoritos" style="float:right; font-size:16px"></i> 
            <?php }else{ ?>
            &nbsp; <i class="fa fa-star" title="Adicionado aos favoritos" style="float:right; font-size:16px"></i> 
            <?php } ?>
            </span>     
            <br />  
               
               
             <span style="margin-top:8px; font-size:12px; text-align:justify">   
             <a href="javascript: void(0)" onclick="popup('galeria.php?id=<?php echo $res['chave_flw']; ?>&img=<?php echo $resc['caminho_anexo_chat']; ?>&flw=<?php echo $resc['flw_chat']; ?>')">
             <?php echo nl2br($resc['texto_chat']); ?>
             </a>
             </span> 
                
            </div>
            
            <?php } ?>
            
         </div>
  </div>
 <?php }

/*
$query2  = "UPDATE cw_chat SET status_chat = '1', dtlido_chat = '$data_atual', hrlido_chat = '$hora', lidopor_chat = '$nome' WHERE flw_chat = '$id' AND usuario_chat != '$_SESSION[IDCLI]' AND tipo_chat = '98' AND status_chat = '0' OR flw_chat = '$id' AND usuario_chat != '$_SESSION[IDCLI]' AND tipo_chat = '99' AND status_chat = '0'";
$link2   = DBConnect();
$result2 = @mysqli_query($link2, $query2) or die(mysqli_error($link2));
*/

$query = "UPDATE cw_relaciona_fw SET msg_relaciona_flw = '0' WHERE fw_relaciona_fw = '$id' AND user_relaciona_fw='$_SESSION[IDCLI]'";
$result = DBExecute($query);