function liste_bases($server_db)
{
if (is_null($server_db) or !($result = sql_listdbs($server_db))) {
return '';
}
$noms = array();
// si sqlite : result est deja un tableau
if (is_array($result)) {
$noms = $result;
} else {
while ($row = sql_fetch($result, $server_db)) {
$noms[] = reset($row);
}
}
return $noms;
}
function install_etape_liste_bases($server_db, $login_db, $disabled = array())
{
$bases = $checked = array();
$noms = sql_listdbs($server_db);
if (!$noms) {
return '';
}
foreach ($noms as $nom) {
$id = spip_htmlspecialchars($nom);
$dis = in_array($nom, $disabled) ? " disabled='disabled'" : '';
$base = " name=\"choix_db\" value=\"" . $nom . '"' . $dis . " type='radio' id='{$id}'";
$label = "<label for='{$id}'>" . ($dis ? "<i>{$nom}</i>" : $nom) . "</label>";
if (!$checked and !$dis and ($nom == $login_db or $GLOBALS['table_prefix'] == $nom)) {
$checked = "<input{$base} checked='checked' />\n{$label}";
} else {
$bases[] = "<input{$base} />\n{$label}";
}
}
if (!$bases && !$checked) {
return false;
}
if ($checked) {
array_unshift($bases, $checked);
$checked = true;
}
return array($checked, $bases);
}
function install_etape_liste_bases($server_db, $login_db, $disabled=array())
{
$result = sql_listdbs($server_db);
if (!$result) return '';
$bases = $checked = $noms = array();
// si sqlite : result est deja un tableau
if (is_array($result)){
$noms = $result;
} else {
while ($row = sql_fetch($result, $server_db)) {
$noms[] = array_shift($row);
}
}
foreach ($noms as $nom){
$id = htmlspecialchars($nom);
$dis = in_array($nom, $disabled) ? " disabled='disabled'" : '';
$base = " name=\"choix_db\" value=\""
. $nom
. '"'
. $dis
. " type='radio' id='$id'";
$label = "<label for='$id'>"
. ($dis ? "<i>$nom</i>" : $nom)
. "</label>";
if (!$checked AND !$dis AND
(($nom == $login_db) OR
($GLOBALS['table_prefix'] == $nom))) {
$checked = "<input$base checked='checked' />\n$label";
} else {
$bases[]= "<input$base />\n$label";
}
}
if (!$bases && !$checked) return false;
if ($checked) {array_unshift($bases, $checked); $checked = true;}
return array($checked, $bases);
}
