prepare("SELECT ID,fname,aboutme,approved,mainpic,emailis, password,username,country,views,height,bday,bmonth,byear,lastact,jobdesc,company,premium,totalviews,tfollowers,city,gender,points,zipcode,receivevisitors,lastvisitor,height,relstatus,flirtstatus FROM girls WHERE username=:sessid LIMIT 1"); $stmt->bindParam(':sessid',$pusername); $stmt->execute(); while($i3=$stmt->fetch()) { $gender = $i3["gender"]; $tname2 = $i3["fname"]; $pid = $i3["ID"]; $aboutme = $i3["aboutme"]; $dapproved = $i3["approved"]; $dmainpic = $i3["mainpic"]; $emailis2 = $i3["emailis"]; $username = $i3["username"]; $password = $i3["password"]; $country = $i3["country"]; $views = $i3["views"]; $tfollowers = $i3["tfollowers"]; $height = $i3["height"]; $bday = $i3["bday"]; $bmonth = $i3["bmonth"]; $byear = $i3["byear"]; $lastact = $i3["lastact"]; $jobdesc = $i3["jobdesc"]; $company = $i3["company"]; $premium = $i3["premium"]; $tviews = $i3["totalviews"]; $height = $i3["height"]; $city = $i3["city"]; $points = $i3["points"]; $zipcode = $i3["zipcode"]; $receivevisitors = $i3["receivevisitors"]; $lastvisitor = $i3["lastvisitor"]; $d_relstatus = $i3["relstatus"]; $d_flirtstatus = $i3["flirtstatus"]; } $_SESSION["vprofileid"] = $pid; if($_REQUEST["approve"] == 1){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET approved=2 WHERE ID=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); } if($_REQUEST["unapprove"] == 1){ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET approved=0 WHERE ID=:sessid"); $stmt->bindParam(':sessid',$pid); $stmt->execute(); } if($_SESSION["uid"] <> $pid && $_SESSION["uid"] > 0){ if($lastvisitor <> $_SESSION["uid"]){ if($receivevisitors > 0){ echo ""; #echo 'sent!'.$emailis; $betreff = ' Du hast ein neuen Besucher ('.$d_username.') '; $message2 = ' Gerade hat dich jemand besucht: http://www.emotu.com/member/'.$d_username.' ------------------------------------------------------------------------------------------------------- Möchtest du über neue Besucher nicht benachrichtigt werden kannst du das unter Profil bearbeiten ausschalten http://www.emotu.com/about.php '; if(strstr($emailis2,"@")){ sendmail('', $emailis2, $betreff, $message2); } } } //echo 'updating visitor'; $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET lastvisitor=:toid,nvisitors=nvisitors+1 WHERE ID=:pid"); $stmt->bindParam(':toid',$_SESSION["uid"]); $stmt->bindParam(':pid',$pid); $stmt->execute(); $stmt = $pdodb->prepare("SELECT pid FROM visitors WHERE pid=:pid AND mid=:mid"); $stmt->bindParam(':pid',$pid); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->execute(); if($stmt->rowCount() == 0){ $stmt = $pdodb->prepare("INSERT INTO visitors(pid,mid,visittime) VALUES(:pid,:mid,now())"); $stmt->bindParam(':pid',$pid); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->execute(); }else{ $stmt = $pdodb->prepare("UPDATE LOW_PRIORITY visitors SET visittime=now() WHERE pid=:pid AND mid=:mid"); $stmt->bindParam(':pid',$pid); $stmt->bindParam(':mid',$_SESSION["uid"]); $stmt->execute(); } } ?> '; $ddfb = "Auf EMOTU kannst du neue Leute kennenlernen. für Sport, Unternehmungen, Dating, Chatten oder einfach nur über Themen diskutieren"; include('headincludes.php'); ?>