/** * Get Data * * @return array value => description */ function getData() { // Query IPDBO's $ips = array(); try { // Convery to an array: hosting ID => hosting service name $ipDBOs = load_array_IPAddressDBO(); foreach ($ipDBOs as $ipDBO) { $ips[$ipDBO->getIP()] = $ipDBO->getHostnameIP(); } } catch (DBNoRowsFoundException $e) { } return $ips; }
/** * Initialize the Table * * @param array $params Parameters from the {form_table} tag */ public function init($params) { parent::init($params); // Build a where clause $where = isset($this->serverID) ? sprintf("serverid='%d'", $this->serverID) : null; // Load the IP Address pool try { // Build the table $IPAddresses = load_array_IPAddressDBO($where); foreach ($IPAddresses as $dbo) { // Put the row into the table $this->data[] = array("ipaddress" => $dbo->getIP(), "ipaddressstring" => $dbo->getIPString(), "server" => $dbo->getServerID(), "hostname" => $dbo->getHostName(), "isAvailable" => $dbo->isAvailable(), "accountname" => $dbo->getAccountName(), "service" => $dbo->getServiceTitle()); } } catch (DBNoRowsFoundException $e) { } }
/** * Delete HostingServicePurchaseDBO from database * * @param HostingServicePurchaseDBO &$dbo HostingServicePurchaseDBO to delete * @return True on success */ function delete_HostingServicePurchaseDBO(&$dbo) { $DB = DBConnection::getDBConnection(); // Release any IP Addresses assigned to this purchase try { $ip_dbo_array = load_array_IPAddressDBO("purchaseid = " . $dbo->getID()); foreach ($ip_dbo_array as $ip_dbo) { // Remove IP address from this purchase $ip_dbo->setPurchaseID(0); update_IPAddressDBO($ip_dbo); } } catch (DBNoRowsFoundException $e) { } // Build DELETE query $sql = $DB->build_delete_sql("hostingservicepurchase", "id = " . $dbo->getID()); // Run query if (!mysql_query($sql, $DB->handle())) { throw new DBException(mysql_error($DB->handle())); } }
/** * Get IP Addresses * * Returns an array of IPAddressDBO's assigned to this server * * @return array Array of IPAddressDBO's */ function getIPAddresses() { try { load_array_IPAddressDBO("serverid=" . $this->getID()); } catch (DBNoRowsFoundException $e) { return array(); } }