function f_buildUserDataArray($db_result)
{
$arr_Subscribers = array();
if ($db_result->num_rows > 0) {
// Counter for array
$index = 0;
// output data of each row
while ($row = $db_result->mysqli_fetch_assoc()) {
$arr_Subscribers[$index] = array("ID" => $row["ID"], "AFFILIATE_NAME" => $row["AFFILIATE_NAME"], "SUBSCRIPTION_PERIOD" => $row["SUBSCRIPTION_PERIOD"], "TITLE" => $row["title"], "NAME" => $row["name"], "SURNAME" => $row["surname"], "EMAIL" => $row["email"], "NUMBER" => $row["contactnumber"], "SUBSCRIPTION_TITLE" => $row["subscription_title"], "START_DATE" => $row["start_date"], "END_DATE" => $row["end_date"], "DAYS_LEFT" => $row["days_remaining"]);
// Increment counter
$index += 1;
}
f_writeLog(implode(" ", $arr_Subscribers));
return $arr_Subscribers;
} else {
return "No subscribers up for renewal this month.";
}
}
if (!$result) {
die('Error: ' . mysqli_error($conn));
}
// Check if user is a new subscriber and save data,
// if not, redirect them to the denied page.
if (mysqli_num_rows($result) > 0) {
// Log the creation of a new subscriber
f_writeLog($messages["DUPLICATE_SUBSCRIBER"], 'Subscriber re-subscribe attempt');
// If the user already exists in the database,
// redirect the user to the denied page.
f_browserRedirect(DENIED_REDIRECT);
} else {
// Insert user details into the Database.
$sql = "INSERT INTO {$table} ({$keys}, {$x_fields})";
$sql .= "VALUES ('{$values}', '{$x_values}')";
$result = mysqli_query($conn, $sql);
if (!$result) {
die('Error: ' . mysqli_error($conn));
}
// Email informing of a new subscription request
f_emailNewSubscription($messages, mysqli_insert_id($conn), $table);
// Log the creation of a new subscriber
f_writeLog($messages["NEW_SUBSCRIBER"], 'New subscription request');
// Redirect user to subscription success page.
f_browserRedirect(SUBSCRIBED_REDIRECT);
}
// Close database connection.
mysqli_close($conn);
} else {
die('You are not allowed to submit data to this form');
}
if ($status) {
echo '<p>Actions Sports - subscriber renewals email sent successfully</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_SENT"], 'Actions Sports - subscriber renewals email sent successfully');
} else {
echo '<p>Actions Sports - subscriber renewals email failed!!!</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_ERROR"], 'Actions Sports - subscriber renewals email failed!!!');
}
$status = f_checkRenewals($messages, JLR_TABLE_NAME);
// Output status to screen
if ($status) {
echo '<p>Jaguar Land Rover - subscriber renewals email sent successfully</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_SENT"], 'Jaguar Land Rover - subscriber renewals email sent successfully');
} else {
echo '<p>Jaguar Land Rover - subscriber renewals email failed!!!</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_ERROR"], 'Jaguar Land Rover - subscriber renewals email failed!!!');
}
$status = f_checkRenewals($messages, AFFINITY_TABLE_NAME);
// Output status to screen
if ($status) {
echo '<p>Affinity - subscriber renewals email sent successfully</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_SENT"], 'Affinity - subscriber renewals email sent successfully');
} else {
echo '<p>Affinity - subscriber renewals email failed!!!</p>';
// Log the creation of a new subscriber
f_writeLog($messages["EMAIL_ERROR"], 'Affinity - subscriber renewals email failed!!!');
}
