Changeset 118 for trunk/includes/pages/hostmaster/hostmaster_dnsnameserver.php

Timestamp:

12/14/2005 07:42:28 PM (6 years ago)

Author:

Winner

Message:

Add: Extra field 'waiting' for ip_ranges, dns_zones, dns_nameservers (database schema update also).
Change: Hostmaster menu waiting submissions does not include them with deletion requests.

File:

• trunk/includes/pages/hostmaster/hostmaster_dnsnameserver.php (modified) (4 diffs)

trunk/includes/pages/hostmaster/hostmaster_dnsnameserver.php

@@ -47 +47 @@
                         LEFT JOIN regions ON areas.region_id = regions.id',
                         "dns_nameservers.id = '".get('nameserver')."'");
+                for($i=1;$i<count($table_node_info->data);$i++) {
+                        if (isset($table_node_info->data[$i])) {
+                                $table_node_info->data[$i]['nodes__name'] .= " (#".$table_node_info->data[$i]['id'].")";
+                                $table_node_info->info['EDIT'][$i] = makelink(array("page" => "mynodes", "node" => $table_node_info->data[$i]['id']));
+                        }
+                }
+                $table_node_info->info['EDIT_COLUMN'] = 'nodes__name';
+                $table_node_info->db_data_remove('id');
                 return $table_node_info;
         }
@@ -54 +62 @@
                 $table_user_info = new table(array('TABLE_NAME' => 'table_user_info'));
                 $table_user_info->db_data(
-                        'users_nodes.owner, users.username, users.surname, users.name, users.name, users.email, users.phone, users.info',
+                        'users.id, users.username, users_nodes.owner, users.surname, users.name, users.name, users.email, users.phone, users.info',
                         'dns_nameservers ' .
                         'LEFT JOIN users_nodes ON users_nodes.node_id = dns_nameservers.node_id 
@@ -61 +69 @@
                         '',
                         'users_nodes.owner ASC');
+                for($i=1;$i<count($table_user_info->data);$i++) {
+                        if (isset($table_user_info->data[$i])) {
+                                $table_user_info->info['EDIT'][$i] = makelink(array("page" => "users", "user" => $table_user_info->data[$i]['id']));
+                        }
+                }
+                $table_user_info->info['EDIT_COLUMN'] = 'username';
+                $table_user_info->db_data_remove('id');
                 $table_user_info->db_data_translate('users_nodes__owner');
                 return $table_user_info;
+        }
+
+        function table_links() {
+                global $db;
+                $table_links = new table(array('TABLE_NAME' => 'table_links', 'FORM_NAME' => 'table_links'));
+                $table_links->db_data(
+                        'links.id, links.type, "" AS peer, links.peer_node_id, n_p.name AS peer_node_name, n_c.name AS peer_ap_nodename, n_c.id AS peer_ap_nodeid, l_c.ssid AS peer_ap_ssid, links.ssid, links.status AS links__status, l_p.status AS l_p__status, l_c.status AS l_c__status',
+                        'links
+                        LEFT JOIN dns_nameservers ON dns_nameservers.node_id = links.node_id
+                        LEFT JOIN links AS l_p ON links.peer_node_id = l_p.node_id AND links.node_id = l_p.peer_node_id
+                        LEFT JOIN nodes AS n_p ON links.peer_node_id = n_p.id
+                        LEFT JOIN links AS l_c ON links.peer_ap_id = l_c.id
+                        LEFT JOIN nodes AS n_c ON l_c.node_id = n_c.id',
+                        "dns_nameservers.id = '".get('nameserver')."' AND (links.type != 'p2p' OR l_p.node_id IS NOT NULL)",
+                        "",
+                        "links.type ASC, links.date_in ASC");
+                for($i=1;$i<count($table_links->data);$i++) {
+                        if (isset($table_links->data[$i])) {
+                                if ($table_links->data[$i]['type'] == 'p2p') {
+                                        $table_links->data[$i]['peer'] = $table_links->data[$i]['peer_node_name']." (#".$table_links->data[$i]['peer_node_id'].")";
+                                        $table_links->data[$i]['links__status'] = ($table_links->data[$i]['l_p__status']=="inactive"?"inactive":$table_links->data[$i]['links__status']);
+                                }
+                                if ($table_links->data[$i]['type'] == 'client') {
+                                        $table_links->data[$i]['peer'] = $table_links->data[$i]['peer_ap_nodename']." (#".$table_links->data[$i]['peer_ap_nodeid'].")";
+                                        $table_links->data[$i]['ssid'] = $table_links->data[$i]['peer_ap_ssid'];
+                                        $table_links->data[$i]['links__status'] = ($table_links->data[$i]['l_c__status']=="inactive"?"inactive":$table_links->data[$i]['links__status']);
+                                }                               
+                        }
+                }
+                $table_links->db_data_remove('id', 'peer_node_id', 'peer_node_name', 'peer_ap_nodename', 'peer_ap_nodeid', 'peer_ap_ssid', 'l_c__status', 'l_p__status');
+                $table_links->db_data_translate('links__type', 'links__status');
+                return $table_links;
+        }
+        
+        function table_dns() {
+                global $db, $vars;
+                $table_dns = new table(array('TABLE_NAME' => 'table_dns', 'FORM_NAME' => 'table_dns'));
+                $table_dns->db_data(
+                        'dns_zones.id, dns_zones.name, dns_zones.date_in, dns_zones.status, dns_zones.delete_req, dns_zones.type',
+                        'dns_zones ' .
+                        'INNER JOIN dns_zones_nameservers ON dns_zones_nameservers.zone_id = dns_zones.id',
+                        'dns_zones_nameservers.nameserver_id = '.get('nameserver'),
+                        "",
+                        "dns_zones.type ASC, dns_zones.date_in ASC");
+                for($i=1;$i<count($table_dns->data);$i++) {
+                        if (isset($table_dns->data[$i])) {
+                                if ($table_dns->data[$i]['type'] == 'forward') $table_dns->data[$i]['name'] .= ".".$vars['dns']['root_zone'];
+                                $table_dns->info['EDIT'][$i] = makelink(array("page" => "hostmaster", "subpage" => "dnszone", "zone" => $table_dns->data[$i]['id']));
+                        }
+                }
+                $table_dns->info['EDIT_COLUMN'] = 'name';
+                $table_dns->db_data_remove('id', 'type');
+                $table_dns->db_data_translate('dns_zones__delete_req', 'dns_zones__status');
+                return $table_dns;
         }
 
@@ -71 +140 @@
                 $this->tpl['table_node_info'] = $construct->table($this->table_node_info(), __FILE__);
                 $this->tpl['table_user_info'] = $construct->table($this->table_user_info(), __FILE__);
+                $this->tpl['table_links'] = $construct->table($this->table_links(), __FILE__);
+                $this->tpl['table_dns'] = $construct->table($this->table_dns(), __FILE__);
                 return template($this->tpl, __FILE__);
         }