/**
* Add a new user to the database. This user is just able to give and receive referrals.
*
* @return int
*/
function update_member()
{
global $Conf, $order, $User;
// Process and store payment information
$privateKey = decrypt_data($this->ID, true);
// Return the stored encrypted key
if (!$privateKey) {
// No key exists create a new one.
$privateKey = genPrivateKey();
//Generate a private key - This will made into a static value after generating it once
}
$data = array('status' => $this->ccStatus, 'details' => $this->ccDetails, 'error' => $this->ccError, 'tcode' => $this->ccTCode, 'name' => $order->name, 'ccType' => $order->cardtype, 'ccNum' => $order->cardnumber, 'MM' => $order->cardexpmonth, 'YY' => $order->cardexpyear, 'ccCODE' => $order->cvmvalue);
$data = encrypt(serialize($data), $privateKey);
//Catches the ciphertext from the encrypt function
// Convert the string value users enter and update it to and numeric string, autoid
$state = $User->get_province_by_name(strtoupper($order->state));
$tA = $Conf["data"]->UserTable;
myDBC::new_andWhere();
myDBC::andWhere("{$tA}.AutoID = '{$this->ID}'");
$fields = array("`shipAddr1`" => "'{$order->address1}'", "`shipCity`" => "'{$order->city}'", "`shipState`" => "'{$state->autoid}'", "`shipZip`" => "'{$order->zip}'", "`cc`" => "'{$data}'", "`level`" => "'member'", "`is_enabled`" => "'yes'", "`date_added`" => "NOW()", "`paymentType`" => "'Credit Card'");
capture_cc($this->ID, '', $privateKey);
myDBC::update_Record($tA, $fields, myDBC::get_andWhere(), " LIMIT 1");
}
/**
* Get information about a Country.
*
* @param int $country_id
* @return object
*/
function get_country_by_id($country_id)
{
global $Conf, $dbconn;
myDBC::new_andWhere();
myDBC::andWhere("`AutoID` = {$country_id}");
$q = "SELECT * FROM " . $Conf["data"]->CountryTable . myDBC::get_andWhere() . " LIMIT 1";
$r = mysqli_query($dbconn, $q);
$row = mysqli_fetch_object($r);
return $row;
}
/**
* Retrieve all information about a specific item.
*
* @param int $model_id
* @return array
*/
public function user_comments($id)
{
global $Conf, $dbconn;
myDBC::new_andWhere();
myDBC::andWhere("`AutoID` = '{$id}';");
$tA = $Conf["data"]->UserTable;
$q = "SELECT userfirstname, userlastname, comments FROM {$tA}" . myDBC::get_andWhere();
$r = mysqli_query($dbconn, $q);
while ($row = mysqli_fetch_object($r)) {
$rows[] = $row;
}
return $rows;
}
/**
* Get the order's discount amount.
*
* @param int $CartID
* @return float
*/
static function get_OrderDiscount($CartID)
{
global $Conf;
myDBC::new_andWhere();
myDBC::andWhere("`CartID` = {$CartID}");
$query = "SELECT `promoDiscount` FROM {$Conf["data"]->ShipTable} " . myDBC::get_andWhere() . " LIMIT 1";
myDBC::stdQuery($query, $result);
$row = mysqli_fetch_object($result);
return $row->promoDiscount;
}