$_SESSION['PAYMENT_ERROR'] = $result["r_error"];
}
}
if ($paymentsuccessful) {
//-----------------------------Inserting artist starts here --------------------------------------------//
if (isset($_SESSION['SESS_insertQry'])) {
mysql_query($_SESSION['SESS_insertQry'][0]) or die(mysql_error());
$userid = mysql_insert_id();
$_SESSION['sess_artistid'] = $userid;
//Insert social media settings
/* $sql_socialmedia = "INSERT INTO ".$tableprefix."seller_social_media
(nSellerId,name,title,link,logo)
SELECT '".$userid."','name',title,link,logo
FROM ".$tableprefix."social_media";
mysql_query($sql_socialmedia) or die(mysql_error());*/
clsUser::setSocialMediaSettingsVendor($userid);
$_SESSION["sess_artistname"] = trim($_SESSION['SESS_insertQry'][2]['txtUserName']);
$_SESSION["sess_artistid"] = $userid;
// Ending Session for User, Affiliates
}
//------------------------------Ends here--------------------------------------------------------------//
$select_Plan = "SELECT plan_Period\n\t\t\t\t\t\t\t\t FROM " . $tableprefix . "sellerPlans\n\t\t\t\t\t\t\t\t WHERE plan_Id = " . trim($_SESSION['membership']['plan_Id']);
$result_Plan = mysql_query($select_Plan) or die(mysql_error());
$result_Plan = mysql_fetch_assoc($result_Plan);
if ($result_Plan['plan_Period'] == "M") {
$noOfDays = 30;
}
if ($result_Plan['plan_Period'] == "Y") {
$noOfDays = 365;
}
$_SESSION['SES_MEMPLAN'] = $_SESSION['membership']['plan_Id'];
$_SESSION['SESS_insertQry'][] = $_POST;
header("Location:chooseYourPlan.php");
exit;
}
//end if
mysql_query($sql_artists) or die(mysql_error());
$userid = mysql_insert_id();
$artistid = $userid;
$_SESSION["sess_artistid"] = $userid;
//Insert social media settings
/*$sql_socialmedia = "INSERT INTO ".$tableprefix."seller_social_media
(nSellerId,name,title,link,logo)
SELECT '".$artistid."','name',title,link,logo
FROM ".$tableprefix."social_media";
mysql_query($sql_socialmedia) or die(mysql_error());*/
clsUser::setSocialMediaSettingsVendor($artistid);
//$_SESSION["sess_artistid"] = $userid;
//Check for plan status and then update if user has selected free /trail plan.
$row = mysql_fetch_array(mysql_query("SELECT enable_membership FROM " . $tableprefix . "settings "));
if ($row["enable_membership"] == "Y") {
if ($res_data['plan_Period'] == "F") {
//--------------------------------------------------------------------
$sql = "UPDATE " . $tableprefix . "artists SET sellerPlanID =" . $_POST['subOption'] . " WHERE artist_id =" . $artistid;
mysql_query($sql);
$orderid = mysql_insert_id();
$noOfDays = 30;
$fromDate = date("Y-m-d");
$endDate = date("Y-m-d", strtotime("+" . $noOfDays . " day"));
$sql = "INSERT INTO " . $tableprefix . "artists_membershipDetails (artist_id, artist_memStartDate, artist_memEndDate,plan_Id,plan_SubscriptionCharge) VALUES\n\t\t\t\t\t\t(" . $artistid . ",'" . $fromDate . "','" . $endDate . "'," . $_POST['subOption'] . ",0)";
mysql_query($sql);
$orderid = mysql_insert_id();
