ob_start();
session_start();
include("includes/dbconfig.php");
//echo $_SESSION['membership_period'];exit;
$day=date(D);
//echo $day;exit;
$sid = session_id();
$date =date("Y-m-d");//echo $date;exit;
$timeStampCurr = strtotime($date);
$duration = 30 * $_SESSION['membership_period'];
//echo $duration;exit;
$timeStamp = $timeStampCurr + (24 * 60 * 60 * $duration); // (add 7 days)
$enddate = date("Y-m-d", $timeStamp);
//echo $enddate;exit;
if(isset($_GET['sid']) && $_GET['sid'] == $sid)
{
if(isset($_GET['pro']) && $_GET['pro'] == 1)
{
//echo "Update pro_users set product=1,paid_status=1,enddate='$enddate' where user_id='".$_SESSION['user_id']."'";exit;
$update_product=mysql_query("Update pro_users set product=1,paid_status=1,upgrades='hotpro',paid_upgrade_status=1,enddate='$enddate' where user_id='".$_SESSION['user_id']."'");
$seluser_detail=mysql_query("select * from pro_users where user_id='$_SESSION[user_id]'");
$seluser_data=mysql_fetch_array($seluser_detail);
$sitename=$seluser_data['fname']." ".$seluser_data['lname'];
mkdir($sitename,0777);
$url1=$sitename;
//////////////// files coping into folder///////////
$files=array ("index.php","professional_details.php","header.php","footer.php","menu.js");
foreach($files as $file) {
$source = "professionalurl/".$file;
$destination = $url1."/".$file;
copy($source, $destination);
}
////////////////// end ////////////////////////////
header("location:myprofolio.php?success=product");
exit;
}elseif(isset($_GET['upgrade']) && $_GET['upgrade'] =='hotpro')
{
$update_product=mysql_query("Update pro_users set upgrades='hotpro',paid_upgrade_status=1,paid_status=0,product=0,enddate='$enddate' where user_id='".$_SESSION['user_id']."'");
$seluser_detail=mysql_query("select * from pro_users where user_id='$_SESSION[user_id]'");
$seluser_data=mysql_fetch_array($seluser_detail);
$sitename=$seluser_data['fname']." ".$seluser_data['lname'];
mkdir($sitename,0777);
$url1=$sitename;
//////////////// files coping into folder///////////
$files=array ("index.php","professional_details.php","header.php","footer.php","menu.js");
foreach($files as $file) {
$source = "professionalurl/".$file;
$destination = $url1."/".$file;
copy($source, $destination);
}
header("location:myprofolio.php?success=hotpro");
exit;
}
}
$qGetblogdetails= "select * from pro_blog order by blog_id desc LIMIT 0,8";
$resblog=getSqlQuery($qGetblogdetails);
?>
HotProfolio-Your Online Portfolio community for freelancers and businesses
$qry_settings=mysql_query("select * from pro_settings");
$ret_settings=mysql_fetch_array($qry_settings);
//echo $ret_settings['metadesp'];exit;
?>
////////////////////////////check for enddate for classifieds////////////////////////
$currentdate=date("Y-m-d");
//echo $currentdate;
$qry_selclassi=mysql_query("select * from pro_classifiedsposted where paid_status=1");
$count_classi_paid=mysql_num_rows($qry_selclassi);
if($count_classi_paid > 0)
{
while($qry_retclassi=mysql_fetch_array($qry_selclassi))
{
if($qry_retclassi['enddate']<$currentdate)
{
$qry_updateclassifieds=mysql_query("Update pro_classifiedsposted set paid_status=0 where auto_id=$qry_retclassi[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retclassi[user_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailformat_mem_exp.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Classified posted From HotProfolios";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
///////////////////////////////end//////////////////////////////////////////////////////
////////////////////////////check for enddate for projects////////////////////////
$qry_selprojects=mysql_query("select * from pro_projectsposted where paid_status=1");
$count_projects_paid=mysql_num_rows($qry_selprojects);
if($count_projects_paid > 0)
{
while($qry_retprojects=mysql_fetch_array($qry_selprojects))
{
if($qry_retprojects['enddate']<$currentdate)
{
$qry_updateprojects=mysql_query("Update pro_projectsposted set paid_status=0 where auto_id=$qry_retprojects[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retprojects[user_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_projects.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Projects posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for events////////////////////////
$qry_selevents=mysql_query("select * from pro_events where paid_status=1");
$count_events_paid=mysql_num_rows($qry_selevents);
if($count_events_paid > 0)
{
while($qry_retevents=mysql_fetch_array($qry_selevents))
{
if($qry_retevents['enddate']<$currentdate)
{
$qry_updateevents=mysql_query("Update pro_events set paid_status=0 where event_id=$qry_retevents[event_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retevents[posted_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_events.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Events posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for jobs////////////////////////
$qry_seljobs=mysql_query("select * from pro_jobsposted where paid_status=1");
$count_jobs_paid=mysql_num_rows($qry_seljobs);
if($count_jobs_paid > 0)
{
while($qry_retjobs=mysql_fetch_array($qry_seljobs))
{
if($qry_retjobs['enddate']<$currentdate)
{
//echo "Update pro_jobsposted set paid_status=0 where auto_id=$qry_retevents[auto_id]";
$qry_updatejobs=mysql_query("Update pro_jobsposted set paid_status=0 where auto_id=$qry_retjobs[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_jobs.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Job posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for platinum members////////////////////////
$qry_selpl_mem=mysql_query("select * from pro_users where product=1 and paid_status=1");
$count_pl_mem=mysql_num_rows($qry_selpl_mem);
//echo $count_pl_mem;
if($count_pl_mem > 0)
{
//echo "yes";
while($qry_retpl_mem=mysql_fetch_array($qry_selpl_mem))
{
if($qry_retpl_mem['enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set paid_status=0,product=0,paid_upgrade_status=0,upgrades='' where user_id=$qry_retpl_mem[user_id]";
$qry_updatepl_mem=mysql_query("Update pro_users set paid_status=0,product=0,paid_upgrade_status=0,upgrades='' where user_id=$qry_retpl_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_retpl_mem['fname'].''.$qry_retpl_mem['lname'];
$email=$qry_retpl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_platinum.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Platinum Membership from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for hotpro lounge members////////////////////////
$qry_selhl_mem=mysql_query("select * from pro_users where upgrades='hotpro' and paid_upgrade_status=1");
$count_hl_mem=mysql_num_rows($qry_selhl_mem);
//echo $count_hl_mem;
if($count_hl_mem > 0)
{
//echo "yes";
while($qry_rethl_mem=mysql_fetch_array($qry_selhl_mem))
{
if($qry_rethl_mem['enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set upgrades='' and paid_upgrade_status=0 where user_id=$qry_rethl_mem[user_id]";
$qry_updatepl_mem=mysql_query("Update pro_users set upgrades='',paid_upgrade_status=0 where user_id=$qry_rethl_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_rethl_mem['fname'].''.$qry_rethl_mem['lname'];
$email=$qry_rethl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_lounge.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of HotPro Lounge Membership from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for Boost upgrade members////////////////////////
$qry_selboost_mem=mysql_query("select * from pro_users where boost_upgrades=1 and paid_boost_status=1");
$count_boost_mem=mysql_num_rows($qry_selboost_mem);
//echo $count_hl_mem;
if($count_boost_mem > 0)
{
//echo "yes";
while($qry_boost_mem=mysql_fetch_array($qry_selboost_mem))
{
if($qry_boost_mem['boost_enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set boost_upgrades=0,paid_boost_status=0 where user_id=$qry_boost_mem[user_id]";
$qry_updateboost_mem=mysql_query("Update pro_users set boost_upgrades=0,paid_boost_status=0 where user_id=$qry_boost_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_rethl_mem['fname'].''.$qry_rethl_mem['lname'];
$email=$qry_rethl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_boost.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Boost Upgrade from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
if(isset($_SESSION['us_id']))
{
//echo "Select * from pro_users where user_id = $_SESSION[us_id]";
$qry_usertype=mysql_query("Select * from pro_users where user_id = $_SESSION[us_id]");
$retusertype=mysql_fetch_array($qry_usertype);
}
?>