prepare("UPDATE LOW_PRIORITY girls SET nvisitors=0 WHERE ID=:pid"); $stmt->bindParam(':pid', $_SESSION["uid"]); $stmt->execute(); $stmt = $pdodb->prepare("SELECT girls.mainpic,girls.username,girls.country,girls.kinaddress, profilevisitors.visited FROM profilevisitors LEFT JOIN girls ON profilevisitors.mid=girls.ID WHERE profilevisitors.pid=:mid ORDER BY profilevisitors.visited desc LIMIT 50"); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->execute(); while($i3=$stmt->fetch()) { $g++; echo '
""){ echo 'background-color: #cbd18b;'; }else{ echo 'background-color:white;'; } echo 'margin:0px 4px 4px 0px; border-radius:10px; text-align:center; padding:0px;">'; if($i3["mainpic"] <> ""){ echo ''; }else{ echo ''; } echo ' '.$i3["username"].'
'.$c_codes[$i3["country"]].'
'; if($i3["kinaddress"] <> ""){ echo 'con carpeta code'; }else{ echo 'sin carpeta code'; } echo '
'.get_time_ago(strtotime($i3["visited"])).''; echo '
'; } ?>