function install_etape_sup1_dist() { $adresse_db = _request('adresse_db'); if (!$adresse_db AND defined('_INSTALL_HOST_DB')) $adresse_db =_INSTALL_HOST_DB; $login_db = _request('login_db'); if (!$login_db AND defined('_INSTALL_USER_DB')) $login_db = _INSTALL_USER_DB; $pass_db = _request('pass_db'); if (!$pass_db AND defined('_INSTALL_PASS_DB')) $pass_db = _INSTALL_PASS_DB; $server_db =_request('server_db'); if (!$server_db AND defined('_INSTALL_SERVER_DB')) $server_db = _INSTALL_SERVER_DB; // Ceci indique la base principale (passe en hidden) // pour qu'on la refuse comme choix de base secondaire $sel_db =_request('sel_db'); if (!$sel_db AND defined('_INSTALL_NAME_DB')) $sel_db = _INSTALL_NAME_DB; echo install_debut_html(_T('config_titre_base_sup')); $link = spip_connect_db($adresse_db, 0, $login_db, $pass_db, '', $server_db); $GLOBALS['connexions'][$server_db][$GLOBALS['spip_sql_version']] = $GLOBALS['spip_' . $server_db .'_functions_' . $GLOBALS['spip_sql_version']]; if ($link) { $GLOBALS['connexions'][$server_db] = $link; echo '<div style="background-color: #eeeeee">'; echo "\n<!--\n", join(', ', $link), " $login_db "; echo join(', ', $GLOBALS['connexions'][$server_db]); echo "\n-->\n<p class='resultat'><b>"; echo _T('info_connexion_ok'),"</b></p>\n"; echo '<!-- ', sql_version($server_db), ' -->' ; $l = bases_referencees(); array_push($l, $sel_db); list(, $res) = install_etape_liste_bases($server_db, $login_db, $l); $hidden = predef_ou_cache($adresse_db,$login_db,$pass_db, $server_db) . (defined('_INSTALL_NAME_DB') ? '' : ("\n<input type='hidden' name='sel_db' value='$sel_db' />\n")); echo install_etape_sup1_form($hidden, '', $res, 'sup2'); echo '</div>'; } else { echo info_etape(_T('info_connexion_base')); echo "<p class='resultat'><b>", _T('avis_connexion_echec_1'), "</b></p>"; } echo install_fin_html(); }
function exec_admin_repair_dist() { $ok = false; if (!spip_connect()) $message = _T('titre_probleme_technique'); else { $version_sql = sql_version(); if (!$version_sql) $message = _T('avis_erreur_connexion_mysql'); else { $s = $GLOBALS['connexions'][0]['type']; if ($s == 'mysql' AND version_compare($version_sql,'3.23.14','<')) $message = _T('avis_version_mysql', array('version_mysql' => " MySQL $version_sql")); else { $message = _T('texte_requetes_echouent'); $ok = true; } } $action = _T('texte_tenter_reparation'); } if ($ok) { $admin = charger_fonction('admin', 'inc'); echo $admin('admin_repair', $action, $message, true); } else { include_spip('inc/minipres'); echo minipres(_T('titre_reparation'), "<p>$message</p>"); } }
function install_etape_2_dist() { $adresse_db = defined('_INSTALL_HOST_DB') ? _INSTALL_HOST_DB : _request('adresse_db'); if (preg_match(',(.*):(.*),', $adresse_db, $r)) { list(, $adresse_db, $port) = $r; } else { $port = ''; } $login_db = defined('_INSTALL_USER_DB') ? _INSTALL_USER_DB : _request('login_db'); $pass_db = defined('_INSTALL_PASS_DB') ? _INSTALL_PASS_DB : _request('pass_db'); $server_db = defined('_INSTALL_SERVER_DB') ? _INSTALL_SERVER_DB : _request('server_db'); $name_db = defined('_INSTALL_NAME_DB') ? _INSTALL_NAME_DB : ''; $chmod = _request('chmod'); $link = spip_connect_db($adresse_db, $port, $login_db, $pass_db, $name_db, $server_db); $GLOBALS['connexions'][$server_db] = $link; $GLOBALS['connexions'][$server_db][$GLOBALS['spip_sql_version']] = $GLOBALS['spip_' . $server_db . '_functions_' . $GLOBALS['spip_sql_version']]; echo install_debut_html(); // prenons toutes les dispositions possibles pour que rien ne s'affiche ! /* * /!\ sqlite3/PDO : erreur sur join(', ', $link) * L'objet PDO ne peut pas etre transformee en chaine * Un echo $link ne fonctionne pas non plus * Il faut utiliser par exemple print_r($link) */ //echo "\n<!--\n", join(', ', $link), " $login_db "; $db_connect = 0; // revoirfunction_exists($ferrno) ? $ferrno() : 0; //echo join(', ', $GLOBALS['connexions'][$server_db]); //echo "\n-->\n"; if ($db_connect == "0" && $link) { echo "<div class='success'><b>" . _T('info_connexion_ok') . "</b></div>"; echo info_progression_etape(2, 'etape_', 'install/'); echo info_etape(_T('menu_aide_installation_choix_base') . aide("install2", true)); echo "\n", '<!-- ', sql_version($server_db), ' -->'; list($checked, $res) = install_etape_2_bases($login_db, $server_db); $hidden = (defined('_SPIP_CHMOD') ? '' : "\n<input type='hidden' name='chmod' value='" . spip_htmlspecialchars($chmod) . "' />") . predef_ou_cache($adresse_db . ($port ? ':' . $port : ''), $login_db, $pass_db, $server_db); echo install_etape_2_form($hidden, $checked, $res, 3); } else { echo info_progression_etape(1, 'etape_', 'install/', true); echo "<div class='error'>"; echo info_etape(_T('info_connexion_base')); echo "<h3>" . _T('avis_connexion_echec_1') . "</h3>"; echo "<p>" . _T('avis_connexion_echec_2') . "</p>"; echo "<p style='font-size: small;'>", _T('avis_connexion_echec_3'), "</p></div>"; } echo install_fin_html(); }
/** * Reparer la base de donnees */ function exec_base_repair_dist() { $ok = false; if (!spip_connect()) { $message = _T('titre_probleme_technique'); } else { $version_sql = sql_version(); if (!$version_sql) { $message = _T('avis_erreur_connexion_mysql'); } else { $message = _T('texte_requetes_echouent'); $ok = true; } $action = _T('texte_tenter_reparation'); } if ($ok) { $admin = charger_fonction('admin', 'inc'); echo $admin('repair', $action, $message, true); } else { include_spip('inc/minipres'); echo minipres(_T('titre_reparation'), "<p>{$message}</p>"); } }
<?php // $Id: help.php 2338 2012-07-18 10:54:42Z cimorrison $ require "defaultincludes.inc"; require_once "version.inc"; // Check the user is authorised for this page checkAuthorised(); print_header($day, $month, $year, $area, isset($room) ? $room : ""); echo "<h3>" . get_vocab("about_mrbs") . "</h3>\n"; echo "<table id=\"version_info\">\n"; echo "<tr><td><a href=\"http://mrbs.sourceforge.net\">" . get_vocab("mrbs") . "</a>:</td><td>" . get_mrbs_version() . "</td></tr>\n"; echo "<tr><td>" . get_vocab("database") . ":</td><td>" . sql_version() . "</td></tr>\n"; echo "<tr><td>" . get_vocab("system") . ":</td><td>" . php_uname() . "</td></tr>\n"; echo "<tr><td>" . get_vocab("servertime") . ":</td><td>" . utf8_strftime($strftime_format['datetime'], time()) . "</td></tr>\n"; echo "<tr><td>PHP:</td><td>" . phpversion() . "</td></tr>\n"; echo "</table>\n"; echo "<p>\n" . get_vocab("browserlang") . ":\n"; echo implode(", ", array_keys($langs)); echo "\n</p>\n"; echo "<h3>" . get_vocab("help") . "</h3>\n"; echo "<p>\n"; echo get_vocab("please_contact") . '<a href="mailto:' . htmlspecialchars($mrbs_admin_email) . '">' . htmlspecialchars($mrbs_admin) . "</a> " . get_vocab("for_any_questions") . "\n"; echo "</p>\n"; require_once "site_faq" . $faqfilelang . ".html"; output_trailer();
<?php # $Id: help.php,v 1.1 2007/06/22 23:45:27 amagrace Exp $ require_once "grab_globals.inc.php"; include "config.inc.php"; include "{$dbsys}.inc"; include "functions.inc"; include "version.inc"; #If we dont know the right date then make it up if (!isset($day) or !isset($month) or !isset($year)) { $day = date("d"); $month = date("m"); $year = date("Y"); } if (empty($area)) { $area = get_default_area(); } print_header($day, $month, $year, $area); echo "<H3>" . get_vocab("about_mrbs") . "</H3>\n"; echo "<P><a href=\"http://mrbs.sourceforge.net\">" . get_vocab("mrbs") . "</a> - " . get_mrbs_version() . "\n"; echo "<BR>" . get_vocab("database") . sql_version() . "\n"; echo "<BR>" . get_vocab("system") . php_uname() . "\n"; echo "<BR>PHP: " . phpversion() . "\n"; echo "<H3>" . get_vocab("help") . "</H3>\n"; echo get_vocab("please_contact") . '<a href="mailto:' . $mrbs_admin_email . '">' . $mrbs_admin . "</a> " . get_vocab("for_any_questions") . "\n"; include "site_faq" . $faqfilelang . ".html"; include "trailer.inc";
<?php # $Id$ require_once "grab_globals.inc.php"; include "config.inc"; include "{$dbsys}.inc"; include "functions.inc"; $mrbs_version = "MRBS 1.1"; #If we dont know the right date then make it up if (!isset($day) or !isset($month) or !isset($year)) { $day = date("d"); $month = date("m"); $year = date("Y"); } if (empty($area)) { $area = get_default_area(); } print_header($day, $month, $year, $area); echo "<H3>" . $vocab['about_mrbs'] . "</H3>\n"; echo "<P><a href=\"http://mrbs.sourceforge.net\">{$vocab['mrbs']}</a> - {$mrbs_version}\n"; echo "<BR>" . $vocab['database'] . sql_version() . "\n"; echo "<BR>" . $vocab['system'] . php_uname() . "\n"; echo "<BR>PHP: " . phpversion() . "\n"; echo "<H3>" . $vocab['help'] . "</H3>\n"; echo $vocab['please_contact'] . '<a href="mailto:' . $mrbs_admin_email . '">' . $mrbs_admin . "</a> " . $vocab['for_any_questions'] . "\n"; include "site_faq" . $faqfilelang . ".html"; include "trailer.inc";
<form method="post" action="convert_db_to_utf8.php"> Encoding to convert from:<br> <select name="encoding"> <option value="iso-8859-1">Latin 1 (English/French/German/Italian/Norwegian etc.)</option> <option value="iso-8859-2">Latin 2 (Czech)</option> <option value="iso-8859-7">ISO-8859-7 (Greek)</option> <option value="iso-8859-15">Latin 9 (European)</option> <option value="Big-5">Big 5 (Chinese Traditional)</option> <option value="Shift-JIS">Shift-JIS (Japanese)</option> <option value="utf-8">UTF-8 (No conversion)</option> </select> <?php if ($dbsys == 'mysql' || $dbsys == 'mysqli') { $ver = sql_version(); // Sanitise the output to contain just the version number, hopefully $ver = preg_replace('/[^0-9.]/', '', $ver); // Pull out the floating point version number sscanf($ver, "%f", $version); if ($version >= 4.1) { $not_unicode = FALSE; $res = sql_query("SHOW FULL COLUMNS FROM {$tbl_entry}"); for ($i = 0; $row = sql_row_keyed($res, $i); $i++) { if (!is_null($row['Collation']) && !preg_match('/utf8/', $row['Collation'])) { $not_unicode = TRUE; } } if ($not_unicode) { ?> <div style="margin-top: 1em; padding: 0.5em; border: solid 2px; background-color: #FFF1A3">
$mrbs_version = "MRBS 1.0-pre2"; #If we dont know the right date then make it up if(!isset($day) or !isset($month) or !isset($year)) { $day = date("d"); $month = date("m"); $year = date("Y"); } if(empty($area)) $area = get_default_area(); print_header($day, $month, $year, $area); echo "<H3>About MRBS</H3>\n"; echo "<P><a href=\"http://mrbs.sourceforge.net\">$lang[mrbs]</a> - $mrbs_version\n"; echo "<BR>Database: " . sql_version() . "\n"; $uname = posix_uname(); echo "<BR>System: $uname[sysname] $uname[release] $uname[machine]\n"; echo "<BR>PHP: " . phpversion() . "\n"; echo "<H3>Help</H3>\n"; echo 'Please contact <a href="mailto:' . $mrbs_admin_email . '">' . $mrbs_admin . "</a> for any questions that aren't answered here.\n"; include "site_faq.html"; include "trailer.inc"; ?>
include "version.php"; global $USER; if ($CFG->forcelogin) { require_login(); } $day = optional_param('day', 0, PARAM_INT); $month = optional_param('month', 0, PARAM_INT); $year = optional_param('year', 0, PARAM_INT); $area = optional_param('area', get_default_area(), PARAM_INT); #If we dont know the right date then make it up if ($day == 0 or $month == 0 or $year == 0) { $day = date("d"); $month = date("m"); $year = date("Y"); } //if(empty($area)) - using optional_param -ab // $area = get_default_area(); print_header_mrbs($day, $month, $year, $area); echo "<H3>" . get_string('about_mrbs', 'block_mrbs') . "</H3>\n"; echo "<P><a href=\"http://mrbs.sourceforge.net\">" . get_string('mrbs', 'block_mrbs') . "</a> - " . get_mrbs_version() . "\n"; echo "<BR>" . get_string('database', 'block_mrbs') . sql_version() . "\n"; echo "<BR>" . get_string('system', 'block_mrbs') . php_uname() . "\n"; echo "<BR>PHP: " . phpversion() . "\n"; echo "<H3>" . get_string('help') . "</H3>\n"; echo get_string('please_contact', 'block_mrbs') . '<a href="mailto:' . $mrbs_admin_email . '">' . $mrbs_admin . "</a> " . get_string('for_any_questions', 'block_mrbs') . "\n"; if (file_exists($CFG->wwwroot . 'blocks/mrbs/lang/' . $USER->lang . '/help/site_faq.html')) { include $CFG->wwwroot . 'blocks/mrbs/lang/' . $USER->lang . '/help/site_faq.html'; } else { include $CFG->wwwroot . 'blocks/mrbs/lang/en_utf8/help/site_faq.html'; } include "trailer.php";
function exec_admin_tech_args($tables) { $commencer_page = charger_fonction('commencer_page', 'inc'); echo $commencer_page(_T('titre_admin_tech'), "configuration", "base"); echo "<br /><br />"; echo "<div style='text-align: center'>", gros_titre(_T('titre_admin_tech'),'',false), '</div>'; if ($GLOBALS['connect_toutes_rubriques']) { echo barre_onglets("administration", "sauver") . "<br />"; echo debut_gauche('',true); echo debut_boite_info(true); echo _T('info_gauche_admin_tech'); echo fin_boite_info(true); $repertoire = _DIR_DUMP; if (!@file_exists($repertoire) AND !$repertoire = sous_repertoire(_DIR_DUMP,'',false,true) ) { $repertoire = preg_replace(','._DIR_TMP.',', '', _DIR_DUMP); $repertoire = sous_repertoire(_DIR_TMP, $repertoire); } $dir_dump = $repertoire; } else { echo debut_gauche('', true); $dir_dump = determine_upload(); } echo debut_droite('',true); // // Sauvegarde de la base // // a passer en fonction if (substr(_DIR_IMG, 0, strlen(_DIR_RACINE)) === _DIR_RACINE) $dir_img = substr(_DIR_IMG,strlen(_DIR_RACINE)); else $dir_img = _DIR_IMG; $dir_dump = joli_repertoire($dir_dump); $res = "\n<p>" . http_img_pack('warning.gif', _T('info_avertissement'), "style='width: 48px; height: 48px; float: right;margin: 10px;'") . _T('texte_admin_tech_01', array('dossier' => '<i>'.$dir_dump.'</i>', 'img'=>'<i>'.$dir_img.'</i>')) . ' ' . _T('texte_admin_tech_02', array('spipnet' => $GLOBALS['home_server'] . '/' . $GLOBALS['spip_lang'] . '_article1489.html' )) . "</p>"; $file = nom_fichier_dump(); $chercher_rubrique = charger_fonction('chercher_rubrique', 'inc'); $form = $chercher_rubrique(0, $GLOBALS['connect_id_rubrique'] ? 'breve' : 'rubrique', $GLOBALS['connect_id_rubrique'], 0, 'admin_tech'); if ($form) { if (preg_match('@^<select([^>]*)>(\s*<option[^>]*)>([^[<]+)(.*)$@s', $form, $r)) { if (!strpos($r[2], 'selected=')) $r[2] .= " selected='selected'"; $form = "<select onchange='x=this.options[this.options.selectedIndex].firstChild.data.match(/\w+/); findObj_forcer(\"znom_sauvegarde\").value=x[0]; findObj_forcer(\"nom_sauvegarde\").value=x[0];'" . $r[1] . '>' . $r[2] . '>' . $r[3] . $r[4]; if ($GLOBALS['connect_id_rubrique']) $file = trim($r[3]); } elseif (preg_match('@^<input[^>]*>([^[<]+)@', $form, $r)) if ($GLOBALS['connect_id_rubrique']) $file = trim($r[1]); $res .= "\n<label for='id_parent'>" . _T('texte_admin_tech_04') . "</label><br /><br />\n" . $form . '<br /><br />'; } $nom = "\n<input name='nom_sauvegarde' id='nom_sauvegarde' size='40' value='$file' />"; $znom = "\n<input name='znom_sauvegarde' id='znom_sauvegarde' size='40' value='$file' />"; $res .= _T('texte_admin_tech_03') . "\n<ul>" . "\n<li style='list-style:none;'><input type='radio' name='gz' value='1' id='gz_on' checked='checked' /><label for='gz_on'> " . _T('bouton_radio_sauvegarde_compressee', array('fichier'=>'')) . " </label><br />\n" . '<b>' . $dir_dump . "</b>" . $znom . "<b>.xml.gz</b></li>" . "\n<li style='list-style:none;'><input type='radio' name='gz' value='0' id='gz_off' /><label for='gz_off'>" . _T('bouton_radio_sauvegarde_non_compressee', array('fichier'=>'')) . '</label><br /><b>' . $dir_dump . "</b>$nom<b>.xml</b></li></ul>\n" . "\n<input type='hidden' name='reinstall' value='non' />"; if (!$GLOBALS['connect_toutes_rubriques']) foreach($tables as $k => $v) if (!strpos($v, 'checked')) unset($tables[$k]); $bloc = "<h3>"._T('install_tables_base')."</h3>" . "\n<ol style='spip'><li>\n" . join("</li>\n<li>", $tables) . "</li></ol>\n"; $bloc = block_parfois_visible('export_tables', _T('info_options_avancees'), $bloc, '', false); echo debut_cadre_trait_couleur('',true,'',_T('texte_sauvegarde'),'sauvegarder'), generer_form_ecrire('export_all', $res . $bloc, '', _T('texte_sauvegarde_base')), fin_cadre_trait_couleur(true); // // Restauration de la base // // restaurer est equivalent a detruire, ou pas (cas des restaurations partielles, a affiner ?) if (autoriser('detruire')) { echo debut_cadre_trait_couleur('',true,'', _T('texte_restaurer_base'),'restaurer'); echo admin_sauvegardes($dir_dump, _request('tri')); echo fin_cadre_trait_couleur(true); // // Lien vers la reparation // if (!_request('reinstall') AND version_compare(sql_version(),'3.23.14','>=')) { $res = "\n<p style='text-align: justify;'>". _T('texte_crash_base') . "\n</p>"; echo debut_cadre_trait_couleur('',true,'',_T('texte_recuperer_base'),'reparer'), generer_form_ecrire('admin_repair', $res, '', _T('bouton_tenter_recuperation')), fin_cadre_trait_couleur(true); } } echo "<br />"; echo fin_gauche(), fin_page(); }
/** * Si la migration a echouee, peut on revenir a une base que l'on avait sauvegarde ? * (cas sqlite uniquement) * * @return bool */ function migration_restore_base_si_possible(){ $res = false; spip_log("tentative de restauration de la base",'migration'); // si jamais la base est sqlite, et qu'on a un backup // le restaurer include_spip('base/abstract_sql'); sql_version(); if (strncmp($GLOBALS['connexions'][0]['type'],'sqlite',6)==0){ if ($db =$GLOBALS['connexions'][0]['db'] AND is_file($f = _DIR_DB . $db . '.sqlite')) { $s = lire_migration_depuis_status(); spip_log("base SQLITE, le status indique backup=".$s['backup'],'migration'); if ($g = $s['backup'] AND @file_exists(_DIR_DB.$g)){ spip_log("base $g restauree dans $f suite a l'echec de la migration",'migration'); @copy(_DIR_DB.$g,$f); $res = true; } } } // securite, dans tous les cas sql_update('spip_auteurs', array('id_auteur'=>'-id_auteur'), "id_auteur<0"); if ($GLOBALS['visiteur_session']['id_auteur']<0){ $id_old = $GLOBALS['visiteur_session']['id_auteur']; $auteur = sql_fetsel('*','spip_auteurs','id_auteur='.intval(-$id_old)); $session = charger_fonction('session','inc'); $session($auteur); // creer la nouvelle session avec -id_auteur $session(); // la charger dans $GLOBALS['visiteur_session'] $session($id_old); // supprimer l'ancienne session } return $res; }