3 /***************************************************************************\
4 * SPIP, Systeme de publication pour l'internet *
6 * Copyright (c) 2001-2019 *
7 * Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James *
9 * Ce programme est un logiciel libre distribue sous licence GNU/GPL. *
10 * Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. *
11 \***************************************************************************/
14 * Gestion des mises à jour de SPIP, versions 0.9*
16 * @package SPIP\Core\SQL\Upgrade
18 if (!defined('_ECRIRE_INC_VERSION')) {
23 * Mises à jour de SPIP n°009
25 * @param float $version_installee Version actuelle
26 * @param float $version_cible Version de destination
28 function maj_v009_dist($version_installee, $version_cible) {
29 if (upgrade_vers(0.98, $version_installee, $version_cible)) {
31 spip_query("ALTER TABLE spip_articles ADD maj TIMESTAMP");
32 spip_query("ALTER TABLE spip_articles ADD export VARCHAR(10) DEFAULT 'oui'");
33 spip_query("ALTER TABLE spip_articles ADD images TEXT DEFAULT ''");
34 spip_query("ALTER TABLE spip_articles ADD date_redac datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
35 spip_query("ALTER TABLE spip_articles DROP INDEX id_article");
36 spip_query("ALTER TABLE spip_articles ADD INDEX id_rubrique (id_rubrique)");
37 spip_query("ALTER TABLE spip_articles ADD visites INTEGER DEFAULT '0' NOT NULL");
38 spip_query("ALTER TABLE spip_articles ADD referers BLOB NOT NULL");
40 spip_query("ALTER TABLE spip_auteurs ADD maj TIMESTAMP");
41 spip_query("ALTER TABLE spip_auteurs ADD pgp BLOB NOT NULL");
43 spip_query("ALTER TABLE spip_auteurs_articles ADD INDEX id_auteur (id_auteur), ADD INDEX id_article (id_article)");
45 spip_query("ALTER TABLE spip_rubriques ADD maj TIMESTAMP");
46 spip_query("ALTER TABLE spip_rubriques ADD export VARCHAR(10) DEFAULT 'oui', ADD id_import BIGINT DEFAULT '0'");
48 spip_query("ALTER TABLE spip_breves ADD maj TIMESTAMP");
49 spip_query("ALTER TABLE spip_breves DROP INDEX id_breve");
50 spip_query("ALTER TABLE spip_breves DROP INDEX id_breve_2");
51 spip_query("ALTER TABLE spip_breves ADD INDEX id_rubrique (id_rubrique)");
53 spip_query("ALTER TABLE spip_forum ADD ip VARCHAR(16)");
54 spip_query("ALTER TABLE spip_forum ADD maj TIMESTAMP");
55 spip_query("ALTER TABLE spip_forum DROP INDEX id_forum");
56 spip_query("ALTER TABLE spip_forum ADD INDEX id_parent (id_parent), ADD INDEX id_rubrique (id_rubrique), ADD INDEX id_article(id_article), ADD INDEX id_breve(id_breve)");
60 if (upgrade_vers(0.99, $version_installee, $version_cible)) {
62 $result = spip_query("SELECT DISTINCT id_article FROM spip_forum WHERE id_article!=0 AND id_parent=0");
64 while ($row = sql_fetch($result)) {
65 unset($forums_article);
66 $id_article = $row['id_article'];
67 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_article=$id_article");
70 while ($row2 = sql_fetch($result2)) {
71 $forums[] = $row2['id_forum'];
76 $forums = join(',', $forums);
77 $forums_article[] = $forums;
78 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_parent IN ($forums)");
80 $forums_article = join(',', $forums_article);
81 spip_query("UPDATE spip_forum SET id_article=$id_article WHERE id_forum IN ($forums_article)");
84 $result = spip_query("SELECT DISTINCT id_breve FROM spip_forum WHERE id_breve!=0 AND id_parent=0");
86 while ($row = sql_fetch($result)) {
88 $id_breve = $row['id_breve'];
89 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_breve=$id_breve");
92 while ($row2 = sql_fetch($result2)) {
93 $forums[] = $row2['id_forum'];
98 $forums = join(',', $forums);
99 $forums_breve[] = $forums;
100 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_parent IN ($forums)");
102 $forums_breve = join(',', $forums_breve);
103 spip_query("UPDATE spip_forum SET id_breve=$id_breve WHERE id_forum IN ($forums_breve)");
106 $result = spip_query("SELECT DISTINCT id_rubrique FROM spip_forum WHERE id_rubrique!=0 AND id_parent=0");
108 while ($row = sql_fetch($result)) {
109 unset($forums_rubrique);
110 $id_rubrique = $row['id_rubrique'];
111 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_rubrique=$id_rubrique");
115 while ($row2 = sql_fetch($result2)) {
116 $forums[] = $row2['id_forum'];
121 $forums = join(',', $forums);
122 $forums_rubrique[] = $forums;
123 $result2 = spip_query("SELECT id_forum FROM spip_forum WHERE id_parent IN ($forums)");
125 $forums_rubrique = join(',', $forums_rubrique);
126 spip_query("UPDATE spip_forum SET id_rubrique=$id_rubrique WHERE id_forum IN ($forums_rubrique)");
132 if (upgrade_vers(0.997, $version_installee, $version_cible)) {
133 spip_query("DROP TABLE spip_index");
137 if (upgrade_vers(0.999, $version_installee, $version_cible)) {
139 spip_query("ALTER TABLE spip_auteurs CHANGE pass pass tinyblob NOT NULL");
140 spip_query("ALTER TABLE spip_auteurs ADD htpass tinyblob NOT NULL");
141 $result = spip_query("SELECT id_auteur, pass FROM spip_auteurs WHERE pass!=''");
143 while ($r = sql_fetch($result)) {
144 $htpass = generer_htpass($r['pass']);
146 spip_query("UPDATE spip_auteurs SET pass='$pass', htpass='$htpass' WHERE id_auteur=" . $r['id_auteur']);