+// Generator (somewhat getter) for a list of network types for given network id
+function generateAdminNetworkTypeList ($networkId) {
+ // Init content
+ $content = '';
+
+ // Query all types of this network
+ $result = SQL_QUERY_ESC("SELECT
+ `network_type_id`, `network_type_handle`
+FROM
+ `{?_MYSQL_PREFIX?}_network_types`
+WHERE
+ `network_id`=%s
+ORDER BY
+ `network_type_handle` ASC",
+ array(
+ bigintval($networkId)
+ ), __FUNCTION__, __LINE__);
+
+ // Do we have entries?
+ if (!SQL_HASZERONUMS($result)) {
+ // List all entries
+ $rows = array();
+ while ($row = SQL_FETCHARRAY($result)) {
+ // Is this valid, then add it
+ if ((is_array($row)) && (isset($row['network_type_id']))) {
+ // Add entry
+ $rows[$row['network_type_id']] = $row;
+ } // END - if
+ } // END - while
+
+ // Generate the selection box
+ $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id');
+ } else {
+ // Nothing selected
+ $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
+ }
+
+ // Free the result
+ SQL_FREERESULT($result);
+
+ // Return content
+ return $content;
+}
+
+// Generator (somewhat getter) for a list of network types for all types
+function generateAdminDistinctNetworkTypeList () {
+ // Init content
+ $content = '';
+
+ // Query all types of this network
+ $result = SQL_QUERY('SELECT
+ t.`network_type_id`, t.`network_type_handle`, d.`network_title`
+FROM
+ `{?_MYSQL_PREFIX?}_network_types` AS t
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_network_data` AS d
+ON
+ t.`network_id`=d.`network_id`
+ORDER BY
+ d.`network_short_name` ASC,
+ t.`network_type_handle` ASC', __FUNCTION__, __LINE__);
+
+ // Do we have entries?
+ if (!SQL_HASZERONUMS($result)) {
+ // List all entries
+ $rows = array();
+ while ($row = SQL_FETCHARRAY($result)) {
+ // Is this valid, then add it
+ if ((is_array($row)) && (isset($row['network_type_id']))) {
+ // Add entry
+ $rows[$row['network_type_id']] = $row;
+ } // END - if
+ } // END - while
+
+ // Generate the selection box
+ $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id', '', '_title');
+ } else {
+ // Nothing selected
+ $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
+ }
+
+ // Free the result
+ SQL_FREERESULT($result);
+ //* DEBUG: */ die('<pre>'.encodeEntities($content).'</pre>');
+
+ // Return content
+ return $content;
+}
+