if (is_array($_REQUEST["entity_restrict"]) && count($_REQUEST["entity_restrict"]) > 1) { $multi = true; } } else { $where .= getEntitiesRestrictRequest(" AND ", $table, $field); if (count($_SESSION['glpiactiveentities']) > 1) { $multi = true; } } } $field = "name"; if ($_REQUEST['searchText'] != $CFG_GLPI["ajax_wildcard"]) { $where .= " AND {$field} " . Search::makeTextSearch($_REQUEST['searchText']); } $where .= " AND `" . $table . "`.`id` NOT IN (0"; $where .= $PluginRacksRack_Item->findItems($DB, $_REQUEST['modeltable']); $where .= ") "; $query = "SELECT `" . $table . "`.`name` AS name,\n `" . $table . "`.`entities_id` AS entities_id,\n `" . $table . "`.`id`, \n `glpi_plugin_racks_itemspecifications`.`id` AS spec \n FROM `glpi_plugin_racks_itemspecifications`,`" . $table . "` \n {$where} \n AND `glpi_plugin_racks_itemspecifications`.`model_id` = `" . $table . "`.`" . $_REQUEST['modelfield'] . "` \n AND `glpi_plugin_racks_itemspecifications`.`itemtype` = '" . $_REQUEST['modeltable'] . "' \n ORDER BY {$add_order} `" . $table . "`.`name` \n {$LIMIT}"; $result = $DB->query($query); } else { $multi = false; $query = "SELECT `glpi_plugin_racks_othermodels`.`id`,\n `glpi_plugin_racks_othermodels`.`name`,\n `glpi_plugin_racks_othermodels`.`comment`, \n `glpi_plugin_racks_itemspecifications`.`id` AS spec\n FROM `glpi_plugin_racks_othermodels`, \n `glpi_plugin_racks_itemspecifications` \n WHERE `glpi_plugin_racks_itemspecifications`.`model_id` = `glpi_plugin_racks_othermodels`.`id` \n AND `glpi_plugin_racks_itemspecifications`.`itemtype` = '" . $_REQUEST['modeltable'] . "' \n ORDER BY `glpi_plugin_racks_othermodels`.`name` {$LIMIT}"; $result = $DB->query($query); } $return = array('results' => array(array('id' => null, 'text' => '-----'))); $results =& $return['results']; if ($count = $DB->numrows($result)) { $prev = -1; $tmp_results = array(); while ($data = $DB->fetch_array($result)) { $entities_id = 0;