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;
}
