</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";