function oos_draw_products_pull_down($name, $parameters = '', $exclude = '') { global $currencies; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) { $select_string .= ' ' . $parameters; } $select_string .= '>'; // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $productsstable = $oostable['products']; $products_descriptionstable = $oostable['products_description']; $query = "SELECT p.products_id, pd.products_name, p.products_price\n FROM {$productsstable} p,\n {$products_descriptionstable} pd\n WHERE p.products_status >= '1' AND\n p.products_id = pd.products_id AND\n pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'\n ORDER BY products_name"; $result =& $dbconn->Execute($query); while ($products = $result->fields) { if (!oos_in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; } // Move that ADOdb pointer! $result->MoveNext(); } // Close result set $result->Close(); $select_string .= '</select>'; return $select_string; }
function oos_get_all_get_params($exclude_array = '') { if ($exclude_array == '') $exclude_array = array(); $get_url = ''; reset($_GET); while (list($key, $value) = each($_GET)) { if (($key != oos_session_name()) && ($key != 'error') && (!oos_in_array($key, $exclude_array))) $get_url .= $key . '=' . $value . '&'; } return $get_url; }