I have a script that handles multiple functions. The first function for the user subscribing to the newsletter works great, the unsubscribe I cant get to work. The page is called up as with the template 'gsrnewsletter_unsub' but when the page is submitted it just refreshes itself and i get nothing.. Please I know its alot of code, but what is it that I'm missing.. PLEASE HELP.
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'newsletter');
// ################### PRE-CACHE TEMPLATES AND DATA ######################
$globaltemplates = array('gsrnewsletter',
'gsrnewsletter_unsub');
// ######################### REQUIRE BACK-END ############################
chdir('/home/MINE/public_html/forums/');//path to your vbulletin directory
require('./global.php');
// ######################### Main Script ############################
if (empty($_REQUEST['get']))
{
$_REQUEST['get'] = 'subscribe';
}
// ######################### NAVIGATION ############################
if ($_REQUEST['get'] == 'subscribe')
{
if ($vboptions['wordwrap'] != 0)
{
$threadinfo['title'] = fetch_word_wrapped_string($threadinfo['title']);
}
$currentpage = urlencode("/oth/newsletter.php?get=subscribe&t=$threadinfo[threadid]");
eval('$usernamecode = "' . fetch_template('newpost_usernamecode') . '";');
$navbits = array();
$parentlist = array_reverse(explode(',', substr($foruminfo['parentlist'], 0, -3)));
foreach ($parentlist AS $forumID)
{
$forumTitle = &$forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}
$navbits["/oth/newsletter.php?$session[sessionurl]t=$threadid"] = $threadinfo['title'];
$navbits[''] = $vbphrase['gsr_newsletter_subscribe'];
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
}
if ($_REQUEST['get'] == 'subscribe'){
eval('print_output("' . fetch_template('gsrnewsletter') . '");');
}
// #####################################################
// #####################################################
// ######################### START MAIN SCRIPT #########
// #####################################################
if ($_POST['get'] == 'dosubscribe'){
globalize($_POST, array('emailaddress'));
$check=$DB_site->query("SELECT EmailAddress from Newsletter WHERE EmailAddress='$emailaddress'");
if(mysql_num_rows($check) == 1){
mail($emailaddress,"G-Spot Racing Newsletter","
You have received this email because you or someone else has tried to subscribe
to the (G-Spot Racing Newsletter). Our records show that the following email
address is already SUBSCRIBED in our database: $emailaddress
To unsubscribe: [url]http://www.gspotracing.com/forums/newsletter.php?emailaddress=[/url]$emailaddress",
"From: [email]test@test.com[/email]\r\n".
"Reply-To: [email]test@test.com[/email]\r\n".
"Return-Path: [email]test@test.com[/email]\r\n");
eval(print_standard_redirect('nwsletter_error'));
} else {
$DB_site->query("INSERT INTO Newsletter (EmailAddress) VALUES ('$emailaddress')");
////////mail////////////////
$to = "$emailaddress";
$subject = "G-Spot Racing Newsletter";
$message = '
<html>
<head>
<title>G-Spot Racing Newsletter</title>
</head>
<body>
<p>Welcome to the G-Spot Racing Team..</p>
<p>Your email address has been SUCCESSFULLY added to
our newsletter database. As long as you are subscribed to our newsletter
you will receive up-to-date event schedules, and the latest specials on
products being offered at our online 4x4 store.</p>
<p>
Sincerely, <br>
G-Spot Racing Team <br>
"Its Not Over Until You Hit It" <br>
[url]www.gspotracing.com[/url]<br></p><br>
<P>----------------------------------------------------------------------------------------------<br>
To unsubscribe:<a href="http://www.gspotracing.com/forums/oth/newsletter.php?get=unsubscribe">Remove Me</a></p>
</body>
</html>
';
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: G-Spot Racing Team <test@test.com>\r\n";
$headers .= "Reply-To: G-Spot Racing Team <test@test.com>\r\n";
$headers .= "Return-Path: G-Spot Racing Team <test@test.com>\r\n";
mail($to, $subject, $message, $headers);
mail("test@test.com","New G-Spot Newsletter Subscriber","
Attention: G-Spot Racing Team:\r\n\r\n
You have a new g-spot racing newsletter subscriber. The person at the following
Email address has been added to the newsletter database:
$emailaddress.
Thanks,
G-Spot Racing
[url]www.gspotracing.com[/url]
(It's not over until you hit it!)",
"From: [email]test@test.com[/email]\r\n".
"Reply-To: [email]test@test.com[/email]\r\n".
"Return-Path: [email]test@test.com[/email]\r\n");
eval(print_standard_redirect('nwsletter_success'));
}
}
///////////////////////////////////////////////////////////
/////////////// Unsubscribe Script ////////////////////////
///////////////////////////////////////////////////////////
if ($_REQUEST['get'] == 'dounsubscribe')
{
if ($vboptions['wordwrap'] != 0)
{
$threadinfo['title'] = fetch_word_wrapped_string($threadinfo['title']);
}
$currentpage = urlencode("/oth/newsletter.php?get=unsubscribe&t=$threadinfo[threadid]");
eval('$usernamecode = "' . fetch_template('newpost_usernamecode') . '";');
$navbits = array();
$parentlist = array_reverse(explode(',', substr($foruminfo['parentlist'], 0, -3)));
foreach ($parentlist AS $forumID)
{
$forumTitle = &$forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}
$navbits["/oth/newsletter.php?$session[sessionurl]t=$threadid"] = $threadinfo['title'];
$navbits[''] = $vbphrase['gsr_newsletter_unsubscribe'];
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
}
if ($_REQUEST['get'] == 'dounsubscribe'){
eval('print_output("' . fetch_template('gsrnewsletter_unsub') . '");');
}
///////////////Main Removal Script/////////////////////
if ($_POST['get'] == 'dounsubscribe'){
globalize($_POST, array('emailaddress1'));
//eval(print_standard_redirect('nwsletter_error1'));
//} else {
$DB_site->query("DELETE FROM Newsletter WHERE EmailAddress='$emailaddress'");
mail($emailaddress,"G-Spot Newsletter Removal","
The following email address has SUCCESSFULLY been removed from our
newsletter database: $emailaddress
*We do not sell, trade, or share any of our members information with anyone*
Sorry to see u go!
Sincerely,
G-Spot Racing Team
'Its Not Over Until You Hit It'
[url]www.gspotracing.com[/url]",
"From: [email]test@test.com[/email]\r\n".
"Reply-To: [email]test@test.com[/email]\r\n".
"Return-Path: [email]test@test.com[/email]\r\n");
eval(print_standard_redirect('nwsletter_remove'));
}
?>
