Le $type $filename n'éxiste pas.
$comment";
exit ();
} else {
echo "$type $filename trouvé.
";
}
}
/**
* Lit les paramètres de base de données depuis un fichier de configuration
*/
function read_db_parameters ($filename) {
$res = array();
$txt = file($filename);
foreach ($txt as $line) {
foreach (array('hostname', 'username', 'password', 'database') as $field) {
if (preg_match("/.*($field)(.*)=\s.(.*)(';)/", $line, $matches)) {
$res[$field] = $matches[3];
}
}
}
if (isset($_GET['HOSTNAME'])) $res['hostname'] = $_GET['HOSTNAME'];
if (isset($_GET['USERNAME'])) $res['username'] = $_GET['USERNAME'];
if (isset($_GET['PASSWORD'])) $res['password'] = $_GET['PASSWORD'];
if (isset($_GET['DATABASE'])) $res['database'] = $_GET['DATABASE'];
return $res;
}
/**
* Calcul l'URL du site
*/
function site_url () {
$protocol = strpos(strtolower($_SERVER['REQUEST_SCHEME']),'https')
=== FALSE ? 'http' : 'https';
$host = $_SERVER['HTTP_HOST'];
$script = $_SERVER['SCRIPT_NAME'];
$params = $_SERVER['QUERY_STRING'];
$currentUrl = $protocol . '://' . $host . $script . '?' . $params;
$lst = preg_split ("/\//", $script);
array_pop($lst);
array_pop($lst);
$script = join ("/", $lst);
$url = $protocol . '://' . $host . $script;
return $url;
}
echo "Réinitialisation de GVV
";
echo "Ce script efface toutes les tables afin de pouvoir relancer l'installation
";
echo "Verification de l'installation
";
/*
* Verification de l'import de l'arborescence de GVV
*
*/
echo "Verification de l'arborescence
";
checkfile("../application", "Réimportez l'arborescence.
", "dossier");
checkfile("../system", "Réimportez l'arborescence.
", "dossier");
checkfile("../install", "Réimportez l'arborescence.
", "dossier");
checkfile("../assets", "Réimportez l'arborescence.
", "dossier");
/*
* Verification de la structure de la base de donn�es
*/
echo "Verification de la base de données
";
$configbase = "../application/config/database.php";
$db_params = read_db_parameters ($configbase);
$serveur = $db_params['hostname'];
$nom = $db_params['username'];
$password = $db_params['password'];
$base = $db_params['database'];
/*
$serveur = "localhost";
$nom = "gvv_user";
$password = "lfoyfgbj";
$base = "gvv2";
*/
function fatal_db() {
global $serveur, $nom, $password, $base, $configbase;
$msg = "
";
$msg .= "Connexion à la base de données impossible.
";
$msg .= "vos paramètres:";
$msg .= "serveur=$serveur";
$msg .= "nom=$nom";
$msg .= "mot de passe=$password";
$msg .= "base=$base";
$msg .= "adapter le fichier $configbase ou modifiez votre base de données";
die($msg);
}
// Verification connexion BDD
$db = mysqli_connect($serveur, $nom, $password, $base) or fatal_db();
//Verification structure BDD
$sql = "SHOW TABLES FROM $base";
$req = mysqli_query($db, $sql) or die('erreur sql !
' . $sql . '
' . mysqli_error($db));
echo "La connection à la base de données est correcte.
";
echo '
Detection des Tables:
';
$sql = "SET FOREIGN_KEY_CHECKS=0;";
mysqli_query($db, $sql) or die('erreur sql !
' . $sql . '
' . mysql_error());
while ($data = mysqli_fetch_row($req)) {
echo '
';
$sql = "drop table " . $data[0] . ";";
echo "$sql";
mysqli_query($db, $sql) or die('erreur sql !
' . $sql . '
' . mysql_error());
}
$sql = "SET FOREIGN_KEY_CHECKS=1;";
mysqli_query($db, $sql) or die('erreur sql !
' . $sql . '
' . mysql_error());
function mysql_import($filename) {
$file_content = file($filename);
$query = "";
foreach ($file_content as $sql_line) {
if (trim($sql_line) != "" && strpos($sql_line, "--") === false) {
$query .= $sql_line;
if (substr(rtrim($query), -1) == ';') {
// echo $query;
$result = mysql_query($query) or die(mysql_error());
$query = "";
}
}
}
}
mysqli_close($db);
echo '
';
/*
* Suppression des images
*/
echo "Suppression des images générées
";
foreach (glob("../assets/images/*.png") as $filename) {
try {
if (chmod($filename, 755)) {
} else {
// echo "changement de droits impossible sur $filename";
}
if (unlink($filename)) {
echo "$filename supprimé" . "\n";
} else {
echo "suppression de $filename impossible" . "\n";
}
} catch (Exception $e) {
echo "Erreur pendant la suppression de $filename. Essayez de le détruire vous-même." . "\n";
}
}
$dir = opendir("../assets/images");
while (false !== ($entry = readdir($dir))) {
echo "Fichier dans le répèrtoire assets/images: $entry";
}
closedir($dir);
$url = site_url() . "/install";
echo 'Installation: ' . $url .'';
?>