/** * Delete Domain Service * * Delete DomainServiceDBO from database */ function delete_domain_service() { $DB = DBConnection::getDBConnection(); $tld = $DB->quote_smart($this->get['dservice']->getTLD()); // Delete Domain Service DBO delete_DomainServiceDBO($this->get['dservice']); // Success - go back to web domain services page $this->setMessage(array("type" => "[DOMAIN_SERVICE_DELETED]", "args" => array($this->session['domain_service_dbo']->getTLD()))); $this->gotoPage("services_domain_services"); }
/** * Install cPanel Module Database Tables */ public function createTables() { $DB = DBConnection::getDBConnection(); // Wipe out old tables $sql = "DROP TABLE IF EXISTS `cpanelserver`"; if (!mysql_query($sql, $DB->handle())) { return false; } // Create new ones $sql = "CREATE TABLE `cpanelserver` (" . "`serverid` int(10) unsigned NOT NULL default '0'," . "`username` varchar(255) NOT NULL default ''," . "`accesshash` text NOT NULL," . "PRIMARY KEY (`serverid`)" . ") TYPE=MyISAM;"; return mysql_query($sql, $DB->handle()); }
/** * Load multiple CPanelServerDBO's from database * * @param string $filter A WHERE clause * @param string $sortby Field name to sort results by * @param string $sortdir Direction to sort in (ASEC or DESC) * @param int $limit Limit the number of results * @param int $start Record number to start the results at * @return array Array of HostingServiceDBO's */ function &load_array_CPanelServerDBO($filter = null, $sortby = null, $sortdir = null, $limit = null, $start = null) { $DB = DBConnection::getDBConnection(); // Build query $sql = $DB->build_select_sql("cpanelserver", "*", $filter, $sortby, $sortdir, $limit, $start); // Run query if (!($result = @mysql_query($sql, $DB->handle()))) { // Query error throw new DBException(mysql_error($DB->handle())); } if (mysql_num_rows($result) == 0) { // No services found throw new DBNoRowsFoundException(); } // Build an array of HostingServiceDBOs from the result set $server_dbo_array = array(); while ($data = mysql_fetch_array($result)) { // Create and initialize a new ServerDBO with the data from the DB $dbo = new CPanelServerDBO(); $dbo->load($data); // Add ServerDBO to array $server_dbo_array[] = $dbo; } return $server_dbo_array; }
/** * Count OrderHostingDBO's * * Same as load_array_OrderHostingDBO, except this function just COUNTs the number * of rows in the database. * * @param string $filter A WHERE clause * @param string $sortby Field name to sort results by * @param string $sortdir Direction to sort in (ASEC or DESC) * @param int $limit Limit the number of results * @param int $start Record number to start the results at * @return array Array of OrderDBO's */ function count_all_OrderHostingDBO($filter = null) { $DB = DBConnection::getDBConnection(); // Build query $sql = "SELECT COUNT(*) FROM orderhosting"; // Run query if (!($result = @mysql_query($sql, $DB->handle()))) { // SQL error throw new DBException(mysql_error($DB->handle())); } // Make sure the number of rows returned is exactly 1 if (mysql_num_rows($result) != 1) { // This must return 1 row throw new DBException("Expected exactly one row from count query"); } $data = mysql_fetch_array($result); return $data[0]; }
<?php require_once 'ConfigParser.php'; require_once 'DBConnection.php'; new ConfigParser(); // Get the configuation details and store them as environment variables if (isset($_REQUEST['userName']) && isset($_REQUEST['password'])) { $DBConnection = new DBConnection(mysqlServerIP2, dbname, dbuser, dbpassword); // Check to see if userName Already exist $results = $DBConnection->queryDB("Select id from users Where username='******'userName'] . "'"); if ($results->num_rows > 0) { // Username already exists echo "Username already exists"; } else { $DBConnection->queryDB("Insert into users (username,password) VALUES ('" . $_REQUEST['userName'] . "','" . $_REQUEST['password'] . "')"); if ($DBConnection->getDBConnection()->errno) { echo "Error creating account for user"; } else { echo "success"; } } } else { echo "usernam and password required"; }
/** * Count ProductPurchaseDBO's * * Same as load_array_ProductPurchaseDBO, except this function just COUNTs the * number of rows in the database. * * @param string $filter A WHERE clause * @return integer Number of ProductPurchase records */ function count_all_ProductPurchaseDBO($filter = null) { $DB = DBConnection::getDBConnection(); // Build query $sql = $DB->build_select_sql("productpurchase", "COUNT(*)", $filter, null, null, null, null); // Run query if (!($result = @mysql_query($sql, $DB->handle()))) { // SQL error throw new DBException(mysql_error($DB->handle())); } // Make sure the number of rows returned is exactly 1 if (mysql_num_rows($result) != 1) { // This must return 1 row throw new DBException("Expected exactly one row from count query"); } $data = mysql_fetch_array($result); return $data[0]; }
/** * Save Transaction * * @param string $transactionID Authorize.net transaction ID * @param string $lastDigits Last 4 digits of the card * @return boolean True for success */ function saveTransaction($transactionID, $lastDigits) { $DB = DBConnection::getDBConnection(); if ($this->loadTransaction($transactionID)) { // Update $sql = $DB->build_update_sql("authorizeaim", "transid = " . $transactionID, array("lastdigits" => $lastDigits)); } else { // Insert $sql = $DB->build_insert_sql("authorizeaim", array("transid" => $transactionID, "lastdigits" => $lastDigits)); } return mysql_query($sql, $DB->handle()); }
/** * Save Module Setting * * @param string $name Setting name * @param string $val Setting value * @return boolean True on success */ function saveSetting($name, $value) { $DB = DBConnection::getDBConnection(); if (null == $this->loadSetting($name)) { // Initialize setting in DB $sql = $DB->build_insert_sql("modulesetting", array("name" => $name, "value" => $value, "modulename" => $this->getName())); } else { // Update setting in DB $sql = $DB->build_update_sql("modulesetting", sprintf("name=%s AND modulename=%s", $DB->quote_smart($name), $DB->quote_smart($this->getName())), array("value" => $value)); } if (!mysql_query($sql, $DB->handle())) { throw new DBException("Could not insert/update module setting " . $name . ": " . mysql_error()); } return true; }
/** * Delete UserDBO from Database * * @param UserDBO &$dbo UserDBO to be deleted * @return boolean True on success */ function delete_UserDBO(&$dbo) { $DB = DBConnection::getDBConnection(); // Build DELETE query $sql = $DB->build_delete_sql("user", "username = " . $DB->quote_smart($dbo->getUsername())); // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } }
/** * Update ContactDBO in database * * @param ContactDBO &$dbo ContactDBO to update */ function ContactDBO_update(&$dbo) { $DB = DBConnection::getDBConnection(); // Build SQL $sql = $DB->build_update_sql("contact", "id = " . intval($dbo->getID()), array("name" => $dbo->getName(), "businessname" => $dbo->getBusinessName(), "email" => $dbo->getEmail(), "address1" => $dbo->getAddress1(), "address2" => $dbo->getAddress2(), "address3" => $dbo->getAddress3(), "city" => $dbo->getCity(), "state" => $dbo->getState(), "country" => $dbo->getCountry(), "postalcode" => $dbo->getPostalCode(), "phone" => $dbo->getPhone(), "mobilephone" => $dbo->getMobilePhone(), "fax" => $dbo->getFax())); // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } }
/** * Get Tax Rules * * @return array An array of tax rules that apply to this purchase */ protected function getTaxRules() { $DB = DBConnection::getDBConnection(); $filter = "country=" . $DB->quote_smart($this->accountdbo->getCountry()) . " AND (" . "allstates=" . $DB->quote_smart("YES") . " OR " . "state=" . $DB->quote_smart($this->accountdbo->getState()) . ")"; try { return load_array_TaxRuleDBO($filter); } catch (DBNoRowsFoundException $e) { return array(); } }
/** * Calculate Taxes for all OrderItems */ public function calculateTaxes() { $DB = DBConnection::getDBConnection(); if (!isset($this->orderitems)) { // No items to tax return; } // Load the tax rules that apply to the country and state provided $taxQuery = sprintf("country=%s AND (allstates=%s OR state=%s)", $DB->quote_smart($this->getCountry()), $DB->quote_smart("YES"), $DB->quote_smart($this->getState())); try { $taxRuleDBOArray = load_array_TaxRuleDBO($taxQuery); foreach ($this->orderitems as $orderItemDBO) { $orderItemDBO->setTaxRules($taxRuleDBOArray); } } catch (DBNoRowsFoundException $e) { } }
/** * Update Setting * * Updates a single setting record * * @param string $key Key * @param string $value New value */ function update_setting($key, $value) { $DB = DBConnection::getDBConnection(); $sql = $DB->build_select_sql("settings", null, "setting = '" . $key . "'"); if (!($result = mysql_query($sql, $DB->handle()))) { throw new DBException(mysql_error($DB->handle())); } if (!mysql_fetch_row($result)) { // Insert $sql = $DB->build_insert_sql("settings", array("setting" => $key, "value" => $value)); } else { // Update $sql = $DB->build_update_sql("settings", "setting = " . $DB->quote_smart($key), array("value" => $value)); } // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } }
/** * Load a Paypal Payment DBO * * Searches the database for a Paypal transaction by TX id (transaction1 field) * * @param string $tx Paypal's TX ID */ function loadPaypalPaymentDBO($tx) { $DB = DBConnection::getDBConnection(); try { $paymentDBOArray = load_array_PaymentDBO(sprintf("transaction1=%s AND module=%s", $DB->quote_smart($tx), $DB->quote_smart($this->getName()))); } catch (DBNoRowsFoundException $e) { } if (count($paymentDBOArray) > 1) { fatal_error("PaypalWPS::loadPaypalPaymentDBO", "Found duplicate Paypal transactions in the database. TX = " . $tx); } return $paymentDBOArray[0]; }