/** * Add a new user to the database. This user is just able to give referrals. * * @return int */ function new_invite() { global $Conf, $User; // referralData is Full Name, Phone, and Email stored in an array. $fields = array("`UserID`" => "'{$User->ID}'", "`Email`" => "'{$this->Email}'", "`message`" => "'{$this->Message}'", "`dateAdded`" => "NOW()"); myDBC::insert_Record($Conf['data']->Invites, $fields); }
/** * Add a new user to the database. This user is just able to give referrals. * * @return int */ function new_Note($id) { global $Conf, $User; $this->dateAdded = date('Y-m-d H:i:s'); $fields = array("`ReferralID`" => "'{$id}'", "`UserID`" => "'{$User->ID}'", "`notes`" => "'{$this->Notes}'", "`dateAdded`" => "'{$this->dateAdded}'"); // dispute_level | 1= admin, 2= referrer, 3= customer return myDBC::insert_Record($Conf['data']->ReferralNotes, $fields); }
function process_transactions($uid, $vid) { global $Conf, $referral; // transaction data will enter the funds into the creators account and the Passing Green admin. $fields = array("`user_id`" => "'{$uid}'", "`referral_id`" => "'{$referral->ID}'", "`amount`" => "'{$referral->Commission}'", "`created`" => "NOW()"); myDBC::insert_Record($Conf['data']->Transactions, $fields); $fields = array("`user_id`" => "2809", "`referral_id`" => "'{$referral->ID}'", "`amount`" => "'{$referral->Commission}'", "`created`" => "NOW()"); myDBC::insert_Record($Conf['data']->Transactions, $fields); $fields = array("`user_id`" => "'{$vid}'", "`referral_id`" => "'{$referral->ID}'", "`amount`" => "'{$referral->Fee}'", '`is_billable`' => "'1'", "`created`" => "NOW()"); myDBC::insert_Record($Conf['data']->Transactions, $fields); }
/** * Add a new comment to the Comments table in the database. * * @return int */ function add_Comments() { global $Conf; // $birthday = $this->Birthday['Y'].'-'.$this->Birthday['F'].'-01'; // $anniversary = $this->Anniversary['Y'].'-'.$this->Anniversary['F'].'-01'; if ($this->State < '253') { $country = '13'; } else { $country = '92'; } $fields = array("`useremail`" => "'{$this->Email}'", "`userFirstname`" => "'{$this->Firstname}'", "`userLastname`" => "'{$this->Lastname}'", "`userAddr1`" => "'{$this->Address1}'", "`userCity`" => "'{$this->City}'", "`userState`" => "'{$this->State}'", "`userCountry`" => "'{$country}'", "`userZip`" => "'{$this->ZIP}'", "`userPhone`" => "'{$this->PhoneNumber}'", "`brochure`" => "'{$this->Brochure}'", "`news`" => "'{$this->News}'", "`hearaboutus`" => "'{$this->HearAboutUs2}'", "`vehicle`" => "'{$this->Vehicle}'", "`comments`" => "'{$this->Comments}'", "`date_added`" => "NOW()", "`last_ip`" => "'{$this->Ip}'"); return myDBC::insert_Record($Conf["data"]->Comments, $fields); }
/** * Add a new user to the database. This user is just able to give and receive referrals. * * @return int */ function add_member() { global $Conf, $order, $User; // Process and store payment information $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)); $fields = array("`userFirstname`" => "'{$this->Firstname}'", "`userLastname`" => "'{$this->Lastname}'", "`useremail`" => "'{$this->Email}'", "`passwd`" => "'{$this->password}'", "`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'"); myDBC::insert_Record($Conf['data']->UserTable, $fields); $ID = myDBC::last_insert_id(); capture_cc($ID, '', $privateKey); // Create private key }
/** * Save Information about user to database. * * @return unknown */ public function saveUserInformation() { global $Conf; $user_id = $this->ID; $r = mysqli_result; $tA = $Conf["data"]->UserTable; myDBC::new_andWhere(); myDBC::andWhere("{$tA}.AutoID = '{$user_id}'"); $fields = array("`useremail`" => "'{$this->username}'", "`userfirstname`" => "'{$this->Firstname}'", "`userlastname`" => "'{$this->Lastname}'", "`phone_number`" => "'{$this->PhoneNumber}'"); // Are we entering a new crypt for a plaintext password? if ($this->isCryptedPW == false) { $fields["`password`"] = "'" . sha1($this->password) . "'"; } // Check to see if the record exists. // If it does, simply update otherwise insert new. $q = "SELECT * FROM {$tA} " . myDBC::get_andWhere() . " LIMIT 1"; myDBC::stdQuery($q, $r); if ($r->num_rows == 1) { myDBC::update_Record($tA, $fields, myDBC::get_andWhere(), " LIMIT 1"); } else { myDBC::insert_Record($tA, $fields); } return true; }
/** * Add Order entry into the Orders table (for future tracking). * * @param int $id * @param int $order_id * @param float $saleprice * @return int */ function add_db_item($id, $saleprice = 0.0) { global $Conf; # Verify sale price. if ($saleprice == 0.0 || empty($saleprice)) { $saleprice = $this->items[$id]->quantity * $this->items[$id]->price; } $fields = array("`UID`" => $this->UID > 0 ? "'{$this->UID}'" : "NULL", "`CartID`" => "'{$this->CartID}'", "`Price`" => "'{$this->items[$id]->price}'", "`PriceSold`" => "'{$saleprice}'", "`DateTime`" => "NOW()", "`IP`" => "'{$this->IP}'", "`Quantity`" => "'{$this->items[$id]->quantity}'", "`ProductID`" => "'{$id}'"); return myDBC::insert_Record($Conf["data"]->OrdersTable, $fields); }