prepare("UPDATE LOW_PRIORITY girls SET approved=1 WHERE fname=:sessid"); $stmt->bindParam(':sessid',$realname); $stmt->execute(); } $stmt = $pdodb->prepare("SELECT ID,fname,aboutme,aboutme_de,aboutme_es,aboutme_fr,aboutme_it,approved,mainpic,emailis, password,username,country,views,lastact, tviews,city,hourly, keywords,keywords_de,keywords_es,keywords_it,keywords_fr FROM girls WHERE fname=:sessid"); $stmt->bindParam(':sessid',$realname); $stmt->execute(); while($i3=$stmt->fetch()) { $tname2 = $i3["fname"]; $pid = $i3["ID"]; $aboutme = $i3["aboutme"]; $aboutme_de = $i3["aboutme_de"]; $aboutme_es = $i3["aboutme_es"]; $aboutme_fr = $i3["aboutme_fr"]; $aboutme_it = $i3["aboutme_it"]; $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"]; $hourly = $i3["hourly"]; $keywords_de = $i3["keywords_de"]; $keywords_es = $i3["keywords_es"]; $keywords_it = $i3["keywords_it"]; $keywords_fr = $i3["keywords_fr"]; $keywords = $i3["keywords"]; } 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"] == 1){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY pix SET approved=1 WHERE mid=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET newphoto=0 WHERE ID=:did "); $stmt->bindParam(':did',$pid); $stmt->execute(); $betreff = ' Photos approved'; $message2 = ' Some or all of your photos have been approved. This is your link to share with your friends so you win!: http://www.guidecontest.com/'.$_REQUEST["pl"].' username: '.$username.' password: '.$password.' '; 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/'.$i3["picis"]); unlink('pix/'.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. http://www.guidecontest.com/ username: '.$username.' password: '.$password.' '; 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) { $metaimg .= ''; } $dt = ucwords($realname).' '.gl('findguideslocal').' '.$city.' '.$c_codes[$country]; $dtfb = ucwords($realname). '- Share this & help me win the Guide Contest'; $lightbox = 1; include('meta.php'); include("header.php"); ?> '; echo '
'; echo '
'; } ?>
0){ echo 'local guide for
$'.$hourly.' / hour'; }else{ echo ''.gl('freeguide').''; } ?>
Contact Guide
edit profile]
'; } ?>
5){ $array2 = explode(",",$keywords_fr); }elseif($subd == "es" && strlen($keywords_es) > 5){ $array2 = explode(",",$keywords_es); }elseif($subd == "de" && strlen($keywords_de) > 5){ $array2 = explode(",",$keywords_de); }elseif($subd == "it" && strlen($keywords_it) > 5){ $array2 = explode(",",$keywords_it); }else{ $array2 = explode(",",$keywords); } foreach($array2 AS $i => $b){ echo ' '.trim($b).'
'; } ?>