/**
* Create Country options
*
* Get a given file, check if it is swf movie an renders it with the selected parameters
*
* @param string $posted Selected $_POST value
* @param string $rowed Selected $dbrow value
* @param string $type Switch output type value (select|text))
*
* @uses available_posted_rowed()
* @uses is_selected_option()
* @uses alt_text()
*
* @return string Returns a country select element or a country Name related to the given output $type selection
*/
function create_country_options($posted, $rowed, $type)
{
//Initialize var
settype($return_string, "string");
switch ($type) {
case 'select':
$query = "SELECT\n `iso`,\n `lang1`,\n `lang2`,\n `lang3`,\n `lang4`,\n `lang5`,\n `lang6`,\n `lang7`,\n `lang8`,\n `lang9`,\n `lang10`,\n `lang11`,\n `lang12`,\n `lang13`,\n `lang14`,\n `lang15`\n FROM `" . DBT_PREFIX . "location_countries`\n ORDER BY `lang" . CURRENT_LANGUAGE . "`";
sql_select($query, $results);
$return_string = "\n <option value=\"\" style=\"font-weight:bold;\">" . translate("select_country") . "</option>";
while ($row = mysql_fetch_array($results)) {
$return_string .= "\n <option value=\"" . $row['iso'] . "\" " . is_selected_option($row['iso'], available_posted_rowed($posted, $rowed)) . " >" . alt_text($row['lang' . CURRENT_LANGUAGE] ? $row['lang' . CURRENT_LANGUAGE] : $row['lang' . DEFAULT_LANGUAGE]) . "</option>";
}
break;
case 'text':
$query = "SELECT\n `iso`,\n `lang1`,\n `lang2`,\n `lang3`,\n `lang4`,\n `lang5`,\n `lang6`,\n `lang7`,\n `lang8`,\n `lang9`,\n `lang10`,\n `lang11`,\n `lang12`,\n `lang13`,\n `lang14`,\n `lang15`\n FROM `" . DBT_PREFIX . "location_countries`\n WHERE `iso` ='" . available_posted_rowed($posted, $rowed) . "'";
sql_select($query, $results);
while ($row = mysql_fetch_array($results)) {
$return_string .= alt_text($row['lang' . CURRENT_LANGUAGE] ? $row['lang' . CURRENT_LANGUAGE] : $row['lang' . DEFAULT_LANGUAGE]);
}
break;
}
return $return_string;
}
function enum_values_to_options($table, $field, $select_name, $posted, $rowed, $add_null, $o_type, $add_onchange_submit = false)
{
$query = "SHOW COLUMNS FROM `" . DBT_PREFIX . str_replace("`", "", $table) . "` LIKE '" . $field . "'";
sql_select($query, $results);
settype($options, "string");
while ($line = mysql_fetch_array($results)) {
$open = strpos($line['Type'], '(');
$close = strrpos($line['Type'], ')');
// check if there are a string with () and if it conttains "enum" string at first
if (!$open || !$close || !preg_match("#^enum#", $line['Type'])) {
return FALSE;
}
$options_array = substr($line['Type'], $open + 2, $close - $open - 3);
$options_array = explode("','", $options_array);
sort($options_array);
$available_value = available_posted_rowed($posted, $rowed);
if (count($options_array) > 1) {
if ($add_null == 1) {
$options = "\n<option value=\"\">" . ucfirst(translate("select")) . "</option>";
$selected_value = $available_value;
} else {
$selected_value = $available_value ? $available_value : $line['Default'];
}
switch ($o_type) {
/////// YES - NO
case 'yn':
foreach ($options_array as $key => $val) {
$options .= "\n<option value=\"" . $val . "\" " . is_selected_option($val, $selected_value);
if ($val == 0) {
$options .= " style=\"background-color:#CC0000; font-weight: bold; color:#FFFFFF; \">" . translate("no");
} else {
$options .= " style=\"background-color:#399D2F; font-weight: bold; color:#FFFFFF; \">" . translate("yes");
}
$options .= "</option>";
}
//end foreach
return "\n<select name=\"" . $select_name . "\">" . $options . "\n</select>";
break;
/////// ONLINE STATUS
/////// ONLINE STATUS
case 'o_status':
foreach ($options_array as $key => $val) {
$options .= "\n<option value=\"" . $val . "\" " . is_selected_option($val, $selected_value);
if ($val == 0) {
$options .= " style=\"background-color:#CC0000; font-weight: bold; color:#FFFFFF; \">" . translate("offline");
} else {
$options .= " style=\"background-color:#399D2F; font-weight: bold; color:#FFFFFF; \">" . translate("online");
}
$options .= "</option>";
}
//end foreach
return "\n<select name=\"" . $select_name . "\">" . $options . "\n</select>";
break;
/////// RADIO
/////// RADIO
case 'radio':
foreach ($options_array as $key => $val) {
$options .= "<input type=\"radio\" name=\"" . $select_name . "\" value=\"" . $val . "\" " . is_checked_option($val, $selected_value) . "><" . ($selected_value == $val ? "strong class=\"red\"" : "span") . "> " . (!is_numeric($val) ? translate($val) : $val) . " </" . ($selected_value == $val ? "strong" : "span") . "><br>";
}
//end foreach
return "\n" . $options;
break;
/////// SELECT
/////// SELECT
default:
foreach ($options_array as $key => $val) {
$options .= "\n<option value=\"" . $val . "\" " . is_selected_option($val, $selected_value);
if (!is_numeric($val)) {
$options .= " >" . translate($val);
} else {
$options .= " >" . $val;
}
$options .= "</option>";
}
//end foreach
return "\n<select name=\"" . $select_name . "\" " . ($add_onchange_submit === true ? "onChange=\"submit();\"" : "") . ">" . $options . "\n</select>";
break;
}
$options = "";
}
//end if($count)
}
//end while
}
