prepare("SELECT ID,fname,aboutme,approved,mainpic,emailis, password,username,country,views,lastact,titleen, tviews,city,phone,address,urlen,paying,stateen,dblat,dblon,fburl,keysen FROM girls WHERE username=:sessid"); $stmt->bindParam(':sessid',$realname); $stmt->execute(); while($i3=$stmt->fetch()) { $tname2 = $i3["fname"]; $pid = $i3["ID"]; $aboutme = $i3["aboutme"]; $dapproved = $i3["approved"]; $dmainpic = $i3["mainpic"]; $emailis = $i3["emailis"]; $username = $i3["username"]; $password = $i3["password"]; $country = $i3["country"]; $views = $i3["views"]; $lastact = $i3["lastact"]; $tviews = $i3["tviews"]; $city = $i3["city"]; $phone = $i3["phone"]; $address = $i3["address"]; $urlen = $i3["urlen"]; $titleen = $i3["titleen"]; $paying = $i3["paying"]; $stateen = $i3["stateen"]; $dblat = $i3["dblat"]; $dblon = $i3["dblon"]; $fburl = $i3["fburl"]; $keysen = $i3["keysen"]; } if($city <> "" || $country <> ""){ if($dblat == 0 ){ $loc = $address.' '.$city.' '.$c_codes2[$country]; $geo = getGeoCode($loc); if($geo["lon"] <> "" && $geo["lon"] <> 0){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET dblat=:dblat,dblon=:dblon WHERE ID=:pid LIMIT 1"); $stmt->bindParam(':pid',$pid); $stmt->bindParam(':dblon',$geo["lon"]); $stmt->bindParam(':dblat',$geo["lat"]); $stmt->execute(); echo 'updated'; } } } $dt = 'Book Massage '.$city.' '.$c_codes2[$country].' - '.$titleen.' '.ucwords($tname2).''; $fbtitle = 'Book a massage '.$city.' '.$c_codes2[$country].' with '.ucwords($tname2).' '.$titleen.''; $fbdesc = strip_tags($aboutme); $metaimg .= ''; include('metas.php'); if($_REQUEST["del2"] == 1){ echo "deleting"; $stmt = $pdodb->prepare("DELETE FROM girls WHERE ID=:did LIMIT 1 "); $stmt->bindParam(':did',$pid); $stmt->execute(); } if($_REQUEST["approve"] > 0){ if($_REQUEST["approve"] == 1){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY pix SET approved=1 WHERE mid=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); } if($_REQUEST["approve"] == 2){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY pix SET approved=2 WHERE mid=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); } $stmt = $pdodb->prepare("SELECT ID,picis FROM pix WHERE mid=:sessid ORDER BY RAND() LIMIT 1"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); while($i3=$stmt->fetch()) { $picis2 = trim((string)$i3["picis"]); } echo 'picis: '.$picis2."
"; #echo 'pid:'.$pid; $stmt2 = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET newphoto=0,mainpic=:newpic,approved=1 WHERE ID=:mid LIMIT 1"); $stmt2->bindParam(':mid',$pid); $stmt2->bindParam(':newpic',$picis2); $stmt2->execute(); $betreff = 'Profile or Photos approved'; $message2 = ' Your profile or some or all of your photos have been approved. its time to upgrade to increase your visibility for only $12 per year :-) https://www.getmassage.co/upgrade.php This is your link to share with your friends so you win!: https://www.getmassage.co/therapist/'.$username.' username: '.$username.' '; if(strstr($emailis,"@")){ sendmail('', $emailis, $betreff, $message2); } } if($_REQUEST["unapprove"] == 1){ $stmt = $pdodb->prepare("SELECT ID,picis FROM pix WHERE approved=0 AND mid=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); while($i3=$stmt->fetch()) { unlink('pix/large/'.$i3["picis"]); unlink('pix/small/'.str_replace("s","",$i3["picis"])); $stmt = $pdodb->prepare("DELETE FROM pix WHERE ID=:did "); $stmt->bindParam(':did',$i3["ID"]); $stmt->execute(); } $betreff = ' Photos not approved'; $message2 = ' Some or all of your photos have not been approved. Please improve the quality of photos. https://www.getmassage.co/ username: '.$username.' '; if(strstr($emailis,"@")){ sendmail('', $emailis, $betreff, $message2); } echo 'update unapprove'; $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET approved=0 WHERE ID=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); } $stmt = $pdodb->prepare("SELECT ID,picis,approved FROM pix WHERE mid=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); $images = $stmt->fetchAll(); foreach($images as $i3) { } ?>
0 && $paying==0){ ?>

0){ echo 'this is a paying member'; }else{ echo 'this is a regular member'; } ?>