"" && $_SESSION["uid"] > 0 && $_SESSION["uid"] <> $_REQUEST["addid"]){ $stmt = $pdodb->prepare("SELECT ID,username,emailis,fname,shortpitch,aboutme,country,city,accounttype,mainpic,nbookings,nrequests,nviews,pushviews,contactinfo,learnkeys,teacherkeys,teachexperience,howmuch,lookingfor,education,lastvisitor,bday,bmonth,byear,freecontacts FROM girls WHERE ID=:username LIMIT 1"); $stmt->bindParam(':username',$_REQUEST["addid"]); $stmt->execute(); while($i3=$stmt->fetch()) { $emailis = $i3["emailis"]; $city = $i3["city"]; } $stmt = $pdodb->prepare("INSERT IGNORE INTO contacts(mid,pid) VALUES(:mid,:pid)"); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->bindParam(':pid',$_REQUEST["addid"]); $stmt->execute(); if($city <> ""){ #$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET lastvote=now() WHERE ID=:mid"); #$stmt->bindParam(':mid',$_REQUEST["addid"]); #$stmt->execute(); } $stmt = $pdodb->prepare("SELECT ID FROM contacts WHERE pid=:pid"); $stmt->bindParam(':pid',$_REQUEST["addid"]); $stmt->execute(); $tfollowersu = $stmt->rowCount(); $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET tfollowers=:tfollowersu,newfollowers=newfollowers+1 WHERE ID=:pid"); $stmt->bindParam(':pid',$_REQUEST["addid"]); $stmt->bindParam(':tfollowersu',$tfollowersu); $stmt->execute(); $stmt = $pdodb->prepare("SELECT ID FROM contacts WHERE mid=:uid"); $stmt->bindParam(':uid',$_SESSION["uid"]); $stmt->execute(); $tfollowingu = $stmt->rowCount(); $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET tfollowing=:tfollowersu WHERE ID=:pid"); $stmt->bindParam(':pid',$_SESSION["uid"]); $stmt->bindParam(':tfollowersu',$tfollowingu); $stmt->execute(); #if($d_stars > 4){ $empfaenger = $emailis; $betreff = ''.$d_username.' just followed you'; $message2 = ' '.$d_username.' just followed you https://www.fazr.me/'.$d_username.' Administrator: https://www.fazr.me/healemotion '; if(strstr($emailis,"@")){ # echo $emailis; sendmail('', $emailis, $betreff, $message2); } #} } if($_REQUEST["did"] > 0){ $stmt = $pdodb->prepare("DELETE FROM contacts WHERE mid=:mid AND pid=:pid"); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->bindParam(':pid',$_REQUEST["did"]); $stmt->execute(); } ?>

Your Contacts

sorted by last verified & active
prepare("SELECT girls.ID,mainpic,username,fname,accounttype,country,shortpitch,city,nbookings,nviews,teacherkeys,learnkeys,aboutme,lookingfor,stars,verified FROM contacts LEFT JOIN girls ON contacts.pid=girls.ID WHERE contacts.mid=:mid ORDER BY verified desc, lastactionint desc LIMIT :nextgo,15"); $stmt->bindParam(':nextgo',$next,PDO::PARAM_INT); $stmt->bindParam(':mid',$_SESSION["uid"],PDO::PARAM_INT); $stmt->execute(); if($stmt->rowCount() == 0){ echo ' no more entries right now. We just started! :-) '; if($_SESSION["uid"] == ""){ echo ' Signup if you are new'; } } while($i3=$stmt->fetch()) { echo '

'; if($i3["mainpic"] <> ""){ echo '

'; }else{ echo '

'; } echo '
show profile

'.$i3["fname"].' '; if($i3["verified"] == 1){ echo '

'; } echo '

'.$i3["city"].' · '.$c_codes[$i3["country"]].'

delete
'.$i3["lookingfor"].'

'; } ?>