function rad_add_mac($mac_addr, $password, $expiredate, $configValues)
{
// add a mac address authentication entry to radius radcheck table
// mac address authentication requires no password from users for auto login
// $password is value used in coova-chilli config option HS_MACPASSWD=macpass
// $mac_addr format example 00:11:22:33:44:55 or 00-11-22-33-44-55
// $expiredate is in timestamp format seconds since Jan 01 1970 like seen from time()
// $configValues is from config.php $configValues array values
// returns values the same as rad_update_users
$new_mac = preg_replace("/:/", "-", $mac_addr);
writelog("new_mac = " . $new_mac . "\n");
rad_update_user($new_mac, $password, $expiredate, $configValues);
}
function update_account($customers_email, $mysql, $configValues)
{
writelog("update_account starte \n");
//$mysql = new_mysql($username,$password,$database,"localhost");
$query = "SELECT * FROM customers WHERE customers_email_address='{$customers_email}'";
$result = get_query($query, $mysql);
if ($result == 0) {
//echo "<br> Failed Freenet customers_email not found <br>";
mysql_close();
writelog("customers_email not found \n");
return 0;
}
$expire = mysql_result($result, 0, "customers_date_account_expires");
$password = mysql_result($result, 0, "customers_password");
$timenow = time();
$expire = strtotime($expire);
$newexpire = $expire;
if ($timenow > $expire) {
$newexpire = $timenow;
}
// check account for pending orders status
$query = "SELECT * FROM orders WHERE customers_email_address='{$customers_email}' AND orders_status = 1";
$result = get_query($query, $mysql);
if ($result == 0) {
// check for promotion package before we give up
$query = "SELECT * FROM customers WHERE customers_email_address='{$customers_email}' AND customers_promotion_received IS NULL";
$result = get_query($query, $mysql);
//$result =mysql_query($query);
// $num =mysql_numrows($result);
if ($result == 0) {
//echo "<b><center> Sorry $first your account has expired. Please go to the Freenet store to correct</center></b><br>";
mysql_close();
//$_SESSION['code']= -2;
writelog(" expired with no promotion \n");
return $expire;
}
// they just stared a new account so give them the 1 day free package 24 hours = 86400 secounds
$newexpire = time() + 86400;
$query = "UPDATE customers SET customers_date_account_expires=FROM_UNIXTIME({$newexpire}) WHERE customers_email_address='{$customers_email}'";
get_query($query, $mysql);
//mysql_query($query);
$query = "UPDATE customers SET customers_promotion_received=NOW() WHERE customers_email_address='{$customers_email}'";
get_query($query, $mysql);
//mysql_query($query);
$_SESSION['expire'] = date("F j, Y, g:i a", $newexpire);
$_SESSION['promotion'] = 1;
//echo "Two day promotion package has now been credited to your account<br> Your account now expires: $newexpire<br>";
$_SESSION['code'] = 1;
$_SESSION['loggedin'] = 1;
mysql_close();
rad_update_user($customers_email, $password, $newexpire, $configValues);
writelog("update_account completed \n");
return $newexpire;
}
// process new orders
$num = mysql_numrows($result);
// echo "<br>num = $num <br>";
// echo "<br> Processing new orders <br>";
$i = 0;
// products bytes expire order process not implemented yet but commented bellow might work
//$new_bytes = 0;
while ($i < $num) {
//$date_purchased=mysql_result($result,$i,"date_purchased");
//echo "date of purchased = $date_purchased <br>";
$orders_id = mysql_result($result, $i, "orders_id");
//echo "orders_id = $orders_id <br>";
$query = "SELECT * FROM orders_products WHERE orders_id='{$orders_id}'";
//echo $query ;
$result2 = get_query($query, $mysql);
$products_id = mysql_result($result2, 0, "products_id");
//echo "products_id = $products_id <br>";
$products_quantity = mysql_result($result2, 0, "products_quantity");
$query = "SELECT * FROM products WHERE products_id='{$products_id}'";
$result2 = get_query($query, $mysql);
$products_hours_to_expire = mysql_result($result2, 0, "products_hours_to_expire");
//$products_bytes_to_expire=mysql_result($result2,0,"products_bytes_to_expire");
//$new_bytes = $new_bytes + $products_bytes_to_expire;
$newexpire = $newexpire + $products_hours_to_expire * $products_quantity * 60 * 60;
//echo "products_hours_to_expire = $products_hours_to_expire <br>";
$query = "UPDATE orders SET orders_status=2 WHERE customers_email_address='{$customers_email}' AND orders_status = 1 AND orders_id ='{$orders_id}'";
get_query($query, $mysql);
$i++;
}
if ($newexpire > $expire) {
//echo "newexpire = $newexpire <br>";
$query = "UPDATE customers SET customers_date_account_expires=FROM_UNIXTIME({$newexpire}) WHERE customers_email_address='{$customers_email}'";
get_query($query, $mysql);
//mysql_query($query);
$query = "UPDATE customers SET customers_promotion_received=NOW() WHERE customers_email_address='{$customers_email}'";
get_query($query, $mysql);
//$query = "UPDATE customers SET customers_bytes_ordered=customers_bytes_ordered+$new_bytes WHERE customers_email_address='$customers_email'";
mysql_close();
rad_update_user($customers_email, $password, $newexpire, $configValues);
return $newexpire;
}
mysql_close();
return $expire;
}
