</td><td class="field">
<select class="select2" name="n_grotto_treasurer" id="n_grotto_treasurer">
<?php
$selected = $treasurer;
echo groupOptions(getOptions($sql, $msg, $selected, $comparedCol, $countryCol, $textCol), $countryCol);
?>
</select>
</td></tr><tr><td width="170" class="label">
<label for="n_grotto_secretary">
<convert>#label=152<convert><!--Secrétaire-->
</label>
</td><td class="field">
<select class="select2" name="n_grotto_secretary" id="n_grotto_secretary">
<?php
$selected = $secretary;
echo groupOptions(getOptions($sql, $msg, $selected, $comparedCol, $countryCol, $textCol), $countryCol);
?>
</select>
</td></tr><tr><td width="170" class="label">
<label for="n_grotto_message">
<convert>#label=541<convert><!--Message perso./liens--><span class="new_feature"><convert>#label=537<convert><!--Nouveau !--></span>
</label>
</td><td class="field">
<textarea class="input1" id="n_grotto_message" name="n_grotto_message" style="width:100%" rows="3" cols="" wrap="soft"><?php
echo $custom_message;
?>
</textarea>
</td></tr><tr><td class="label" colspan="2" style="text-align:left;">
<label for="e_myList">
<b><convert>#label=153<convert><!--Les entrées découvertes par ce club--> :</b>
</label>
$selected = "";
$Obj_name_sql = "SELECT * ";
$Obj_name_sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_" . $category . "` ";
$Obj_name_sql .= "WHERE Id = " . $id;
$object_source_name = getDataFromSQL($Obj_name_sql, __FILE__, $frame, __FUNCTION__);
if ($category == "caver") {
$object_source_name = $object_source_name[0]['Nickname'];
} else {
$object_source_name = $object_source_name[0]['Name'];
}
$rnd_div_id = "list_entry_div_" . rand();
$innerHTML = "<div id=\"" . $rnd_div_id . "\" class=\"menu\">";
$innerHTML .= getTopMenu(getCloseBtn("JavaScript:resetListDiv('" . $rnd_div_id . "');", "<convert>#label=371<convert>") . "<div class=\"frame_title\">" . setTitle("JavaScript:openMe(" . $id . ", '" . $category . "', false);", "list", "<convert>#label=384<convert> <convert>#label=540<convert> " . $object_source_name, 1) . "</div>");
//Entrées en lien avec//Fermer
$innerHTML .= "<select onclick=\"JavaScript:selectOnClick(this);\" size=\"5\" class=\"entry\">\n";
$innerHTML .= groupOptions(getOptions($sql, "", $selected, $comparedCol, $countryCol, $idCol, $categoryCol, $textCol), $countryCol) . "\n";
$innerHTML .= "</select>" . getBotMenu() . "</div>\n";
break;
case "list_contribution":
$id = isset($_GET['id']) ? $_GET['id'] : '';
$category = isset($_GET['category']) ? $_GET['category'] : '';
$sql = "SELECT DISTINCT IF(cat.Category = 'T_entry',cat.Id,cat.Id_entry) AS objectId, 'entry' AS category, IF(cat.Category = 'T_entry',cat.Id,cat.Id_entry) AS value, cat.Title AS NName ";
$sql .= "FROM `" . $_SESSION['Application_host'] . "`.`V_contributions` cat ";
$sql .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`T_caver` usr ON (usr.Id = cat.Id_author OR usr.Id = cat.Id_reviewer) ";
$sql .= "WHERE usr.Id = " . $id . " AND NOT cat.Id_entry = 0 AND cat.Id_entry IS NOT NULL ";
if (USER_IS_CONNECTED) {
} else {
$sql .= "AND cat.Is_public = 'YES' ";
}
$sql .= "ORDER BY NName ";
$comparedCol = "value";
