require $Root_Path . "includes/siteconfig.php";
require $Root_Path . "includes/language.php";
/**********************************************************************
* TrimRSlash
*
*/
function TrimRSlash($URL)
{
$nLength = strlen($URL);
return $URL[$nLength - 1] == '/' ? substr($URL, 0, $nLength - 1) : $URL;
}
// Posted variables
$txtSubject = $_POST['txtSubject'];
$elm2 = $_POST['elm2'];
// Set the body of the news letter
$bodyp1 = "<html><head><title>" . $txtSubject . "</title></head><body>" . stripslashes($elm2) . "<br><br>" . GetStringFromStringTable("IDS_NEWSLETTER_MAILER_TXT_1", $config) . "<br><a href='" . TrimRSlash($conf['site_url']) . "/chess_close.php'>" . TrimRSlash($conf['site_url']) . "/chess_close.php</a></body></html>";
$From = $conf['registration_email'];
$Name = $conf['site_name'];
//Instantiate theCR3DCQuery Class
$oR3DCQuery = new CR3DCQuery($config);
$aEmail = $oR3DCQuery->ListAvailablePlayersEmail($config);
$nCount = count($aEmail);
$i = 0;
while ($i < $nCount) {
$To = $aEmail[$i];
$oR3DCQuery->SendEmail($To, $From, $Name, $txtSubject, $bodyp1);
$i++;
}
$oR3DCQuery->Close();
unset($oR3DCQuery);
header('Location: ./create_newsletter.php');
for ($i = 0; $i < count($_POST['lstTplayers']); $i++) {
if (trim($_POST['lstTplayers'][$i]) != "") {
$oR3DCQuery->AddTournamentPlayer($config, $TID, trim($_POST['lstTplayers'][$i]));
}
}
}
if ($oR3DCQuery->NewTournamentRequiresApproval() == false) {
$oR3DCQuery->AcceptTournamentproposal($config, $TID);
}
// Email admin about tournament
include $config;
$subject = str_replace("['site_name']", $conf['site_name'], GetStringFromStringTable("IDS_TOURNAMENTPROPOSAL_EMAIL_SUBJECT", $config));
$aFindTag = array("['txttname']", "['slctsDateMonth']", "['slctsDateDay']", "['slctsDateYear']", "['txtstime']", "['slctcpDateMonth']", "['slctcpDateDay']", "['slctcpDateYear']", "['txtcptime']");
$aReplaceTag = array($txttname, $slctsDateMonth, $slctsDateDay, $slctsDateYear, $txtstime, $slctcpDateMonth, $slctcpDateDay, $slctcpDateYear, $txtcptime);
$body = str_replace($aFindTag, $aReplaceTag, GetStringFromStringTable("IDS_TOURNAMENTPROPOSAL_EMAIL_BODY", $config));
$oR3DCQuery->SendEmail($conf['registration_email'], $conf['registration_email'], $conf['site_name'], $subject, $body);
}
// Get current time
$todaystime = date("H:i:s");
?>
<html>
<head>
<title><?php
echo GetStringFromStringTable("IDS_PAGETITLES_14", $config);
?>
</title>
<META NAME="keywords" CONTENT="">
<META NAME="DESCRIPTION" CONTENT="">
<META NAME="OWNER" CONTENT="Christian">
function CheckPlayerBillingTerm($config)
{
include $config;
$db = mysql_connect($conf['database_host'], $conf['database_login'], $conf['database_pass']) or die("Couldn't connect to the database.");
mysql_select_db($conf['database_name']) or die("Couldn't select the database");
/************/
//$result = mysql_query("SELECT * FROM c4m_playerorders WHERE o_orderstatus = 'p' AND DATE_FORMAT('2005-05-07 18:18:18','%Y-%m-%d') >= DATE_FORMAT(o_datedue,'%Y-%m-%d')") or die("Couldn't Check The End Dates.");
$result = mysql_query("SELECT * FROM c4m_playerorders WHERE o_orderstatus = 'p' AND DATE_FORMAT(NOW(),'%Y-%m-%d') >= DATE_FORMAT(o_datedue,'%Y-%m-%d')") or die("Couldn't Check The End Dates.");
/***********/
$num = mysql_numrows($result);
$i = 0;
while ($i < $num) {
$o_id = mysql_result($result, $i, "o_id");
$o_username = mysql_result($result, $i, "o_username");
$o_firstname = mysql_result($result, $i, "o_firstname");
$o_lastname = mysql_result($result, $i, "o_lastname");
$o_address = mysql_result($result, $i, "o_address");
$o_citytown = mysql_result($result, $i, "o_citytown");
$o_country = mysql_result($result, $i, "o_country");
$o_provincestatearea = mysql_result($result, $i, "o_provincestatearea");
$o_postalcode = mysql_result($result, $i, "o_postalcode");
$o_email = mysql_result($result, $i, "o_email");
$o_phonea = mysql_result($result, $i, "o_phonea");
$o_phoneb = mysql_result($result, $i, "o_phoneb");
$o_phonec = mysql_result($result, $i, "o_phonec");
$o_redemptioncode = mysql_result($result, $i, "o_redemptioncode");
$o_dateoforder = mysql_result($result, $i, "o_dateoforder");
$o_paymentterm = mysql_result($result, $i, "o_paymentterm");
$o_datepaid = mysql_result($result, $i, "o_datepaid");
$o_datedue = mysql_result($result, $i, "o_datedue");
$o_orderstatus = mysql_result($result, $i, "o_orderstatus");
//echo "[".$o_id."] ".$o_username." - ".$o_datedue." - ".$o_orderstatus."<br>";
// set order to finished
$update = "UPDATE c4m_playerorders SET o_orderstatus = 'f' WHERE o_id=" . $o_id;
mysql_query($update, $db) or die(mysql_error());
// create new order
$insert = "INSERT INTO c4m_playerorders VALUES(NULL, '" . $o_username . "', '" . $o_firstname . "', '" . $o_lastname . "', '" . $o_address . "', '" . $o_citytown . "', '" . $o_country . "', '" . $o_provincestatearea . "', '" . $o_postalcode . "', '" . $o_email . "', '" . $o_phonea . "', '" . $o_phoneb . "', '" . $o_phonec . "', '', NOW(), '" . $o_paymentterm . "', NULL, NULL, 'u')";
mysql_query($insert, $db) or die(mysql_error());
//Select the new Order ID
$query1 = "SELECT o_id FROM c4m_playerorders WHERE o_username = '******' AND o_orderstatus='u' ORDER BY o_id DESC LIMIT 1";
$return1 = mysql_query($query1, $db) or die(mysql_error());
$num1 = mysql_numrows($return1);
$orderid = 0;
if ($num1 != 0) {
$orderid = mysql_result($return1, 0, 0);
}
// Send email
$query2 = "SELECT * FROM c4m_emailmessageconfig";
$return2 = mysql_query($query2, $db) or die(mysql_error());
$num2 = mysql_numrows($return2);
if ($num2 != 0) {
$o_regover = mysql_result($return2, 0, "o_regover");
$subject = "Chess Membership Renewal";
// configure message body
$body = $o_regover;
$body = str_replace("[NAME]", $o_firstname . " " . $o_lastname, $body);
$body = str_replace("[OID]", $orderid, $body);
$body = str_replace("[UNAME]", $o_username, $body);
//Instantiate theCR3DCQuery Class
$oR3DCQuery = new CR3DCQuery($config);
$oR3DCQuery->SendEmail($o_email, $conf['registration_email'], $conf['site_name'], $subject, $body);
$oR3DCQuery->Close();
unset($oR3DCQuery);
}
$i++;
}
}
