<? 
session_start();
#error_reporting(E_ALL);
#ini_set('display_errors', '1');

header('Content-Type: text/html; charset=utf-8');
include("../db.php");

$regmodal = 1;


$stmt = $pdodb->prepare("SELECT forum.id as fid, forum.titleis,forum.descis,girls.emailis, forum.seox,girls.city,girls.country,girls.mainpic,girls.username,girls.ID as pid,
forum.timeposted,girls.jobdesc,forum.forumseo,forum.likes,forum.forum as forumid,girls.ffooter,girls.fname,
girls.paying,girls.credits,forum.votepoints,forum.nreplies,forum.views,forum.lastaccessed,forum.kin,forum.langis,
girls.publickey,girls.banned,forum.votes,forum.mainpic as postpic,forum.urlis,forum.postprice,forum.teaser,forum.percentageShare,girls.kinaddress,girls.position,girls.company, forum.reward FROM forum  LEFT JOIN girls ON  forum.mid=girls.ID WHERE seox=:seox LIMIT 1");
$stmt->bindParam(':seox',$_REQUEST["pl"]);
$stmt->execute();


while($i3=$stmt->fetch()) { 
	$pid = $i3["pid"];
	$emailis = $i3["emailis"];
	$fid = $i3["fid"];
	$title = strip_tags($i3["titleis"]);
	$descis = strip_tags($i3["descis"]);
	$timeposted = $i3["timeposted"];
	$mainpic = $i3["mainpic"];
	$username = $i3["username"];
	$city = $i3["city"];
	$country = $i3["country"];
	$private = $i3["private"];
	$datecost = $i3["datecost"];
	$jobdesc = $i3["jobdesc"];
	$forumseo = $i3["forumseo"];
	$cat = $i3["forumseo"];
	$forumid = $i3["forumid"];
	$ffooter = $i3["ffooter"];
	$fname = $i3["fname"];	
	$paying = $i3["paying"];	
	$credits = $i3["credits"];	

	$votepoints = $i3["votepoints"];	
	$views = $i3["views"];	
	$nreplies = $i3["nreplies"];	
	$lastaccessed = $i3["lastaccessed"];	
	$kin = $i3["kin"];
	$langis = $i3["langis"];
	$publickey = $i3["publickey"];
	$banned = $i3["banned"];
	$votes = $i3["votes"];
	$postpic = $i3["postpic"];	
	$urlis = $i3["urlis"];	
	$likes = $i3["likes"];
	
	$teaser = $i3["teaser"];	
	$postprice = $i3["postprice"];	
	$percentageShare = $i3["percentageShare"];
	$mkinaddress = $i3["kinaddress"];
	
	$company = $i3["company"];	
	$position = $i3["position"];	
	$reward = $i3["reward"];	
}
if($_SESSION["uid"] == ""){
	$la = $langis;
}else{

}

if(strstr($_SERVER['HTTP_REFERER'],'google') || strstr($_SERVER['HTTP_REFERER'],'bing')){
	$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forum SET lastaccessed=now() WHERE ID=:fid");
	$stmt->bindParam('fid',$fid);
	$stmt->execute();
}

$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forum SET views=views+1 WHERE ID=:forumid");
$stmt->bindParam('forumid',$fid);
$stmt->execute();

if(trim($_REQUEST["replyis"]) <> "" && $_SESSION["uid"] > 0){
	$reply = 1;
	$stmt = $pdodb->prepare("INSERT INTO forumreplies (mid,fid,message,whenpost) VALUES(:mid,:fid,:msg,now())");
	$stmt->bindParam('mid',$_SESSION["uid"]);
	$stmt->bindParam('fid',$fid);
	$stmt->bindParam('msg',strip_tags($_REQUEST["replyis"]));
	$stmt->execute();

	$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forum SET nreplies=nreplies+1 WHERE ID=:fid");
	$stmt->bindParam('fid',$fid);
	$stmt->execute();
	

	$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY forum SET nreplies=nreplies+1 WHERE ID=:fid");
	$stmt->bindParam('fid',$fid);
	$stmt->execute();

	$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET karma=karma+1 WHERE ID=:pid");
	$stmt->bindParam(':pid',$pid);
	$stmt->execute();

	$msg = "You have a new Forum Reply
	https://www.budu.com".$_SERVER["REQUEST_URI"]."";

	insert_notify($pid,$msg,''.$_SERVER["REQUEST_URI"]);

	/*
	$stmt = $pdodb->prepare("INSERT INTO messages(toid,fromid,messageis,dateis) VALUES(:rid,:mid,:msg,now())");
	$stmt->bindParam(':rid',$pid);
	$stmt->bindParam(':mid',$_SESSION["uid"]);
	$stmt->bindParam(':msg',$msg);
	$stmt->execute();
   
		$stmt = $pdodb->prepare("UPDATE LOW_PRIORITY girls SET newmessages=newmessages+1 WHERE ID=:rid");
		$stmt->bindParam(':rid',$pid);
		$stmt->execute();	
*/


	if(strstr($emailis,"@")){
		mandrill('',$emailis,"New Forum Reply for you from ".$d_username,'
	
		https://www.budu.com'.$_SERVER["REQUEST_URI"].'

		TIP:
		to receive less replies you can set your minimum to contact you higher in edit profile

		https://www.budu.com
		');
	}
}


$dt = $title." in ".str_replace("-"," ",$forumseo)."";
$dd = $descis;
$dmainpic = $mainpic;

include("../metas.php");

?>


<?
include("../header2.php");
?>


<?
if($_SESSION["uid"] == ""){
echo '<a href="/signup.php" class="btn btn-success" style="margin:6px 0px;">'.gl('signup').'</A><br>';
}
?>
<a href="/club/">&#8612; back