Code Duplication - spip/SPIP - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 6-8 lines in 22 locations

ecrire/maj/v012.php 1 location


		maj_version (1.208);
	}

	if (upgrade_vers(1.209, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic ADD maj TIMESTAMP");
		spip_query("ALTER TABLE spip_syndic_articles ADD maj TIMESTAMP");
		spip_query("ALTER TABLE spip_messages ADD maj TIMESTAMP");
		maj_version (1.209);
	}

	if (upgrade_vers(1.210, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_messages DROP page");

ecrire/maj/v013.php 2 locations


		maj_version (1.302);
	}

	if (upgrade_vers(1.303, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_rubriques ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		spip_query("ALTER TABLE spip_syndic ADD date_syndic datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		spip_query("UPDATE spip_syndic SET date_syndic=date");
		maj_version (1.303);
	}

	if (upgrade_vers(1.306, $version_installee, $version_cible)) {
		spip_query("DROP TABLE spip_index_syndic_articles");

		maj_version (1.303);
	}

	if (upgrade_vers(1.306, $version_installee, $version_cible)) {
		spip_query("DROP TABLE spip_index_syndic_articles");
		spip_query("ALTER TABLE spip_syndic ADD date_index datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		spip_query("ALTER TABLE spip_syndic ADD INDEX date_index (date_index)");
		maj_version (1.306);
	}

	if (upgrade_vers(1.307, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic_articles ADD descriptif blob NOT NULL");

ecrire/maj/v014.php 8 locations


		maj_version (1.418);
	}

	if (upgrade_vers(1.419, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_auteurs ADD alea_actuel TINYTEXT DEFAULT ''");
		spip_query("ALTER TABLE spip_auteurs ADD alea_futur TINYTEXT DEFAULT ''");
		spip_query("UPDATE spip_auteurs SET alea_futur = FLOOR(32000*RAND())");
		maj_version (1.419);
	}

	if (upgrade_vers(1.420, $version_installee, $version_cible)) {
		spip_query("UPDATE spip_auteurs SET alea_actuel='' WHERE statut='nouveau'");

		maj_version (1.421);
	}

	if (upgrade_vers(1.432, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_articles DROP referers");
		spip_query("ALTER TABLE spip_articles ADD referers INTEGER DEFAULT '0' NOT NULL");
		spip_query("ALTER TABLE spip_articles ADD popularite INTEGER DEFAULT '0' NOT NULL");
		maj_version (1.432);
	}

	if (upgrade_vers(1.436, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_documents ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");

		maj_version (1.438);
	}

	if (upgrade_vers(1.439, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic ADD INDEX statut (statut, date_syndic)");
		spip_query("ALTER TABLE spip_syndic_articles ADD INDEX statut (statut)");
		spip_query("ALTER TABLE spip_syndic_articles CHANGE url url VARCHAR(255) NOT NULL");
		spip_query("ALTER TABLE spip_syndic_articles ADD INDEX url (url)");
		maj_version (1.439);
	}

	if (upgrade_vers(1.440, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_visites_temp CHANGE ip ip INTEGER UNSIGNED NOT NULL");

		maj_version (1.440);
	}

	if (upgrade_vers(1.441, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_visites_temp CHANGE date date DATE NOT NULL");
		spip_query("ALTER TABLE spip_visites CHANGE date date DATE NOT NULL");
		spip_query("ALTER TABLE spip_visites_referers CHANGE date date DATE NOT NULL");
		maj_version (1.441);
	}

	if (upgrade_vers(1.442, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_auteurs ADD prefs TINYTEXT NOT NULL");

		maj_version (1.442);
	}

	if (upgrade_vers(1.443, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_auteurs CHANGE login login VARCHAR(255) BINARY NOT NULL");
		spip_query("ALTER TABLE spip_auteurs CHANGE statut statut VARCHAR(255) NOT NULL");
		spip_query("ALTER TABLE spip_auteurs ADD INDEX login (login)");
		spip_query("ALTER TABLE spip_auteurs ADD INDEX statut (statut)");
		maj_version (1.443);
	}

	if (upgrade_vers(1.444, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic ADD moderation VARCHAR(3) NOT NULL");

		maj_version (1.444);
	}

	if (upgrade_vers(1.457, $version_installee, $version_cible)) {
		spip_query("DROP TABLE spip_visites");
		spip_query("DROP TABLE spip_visites_temp");
		spip_query("DROP TABLE spip_visites_referers");
		creer_base(); // crade, a ameliorer :-((
		maj_version (1.457);
	}

	if (upgrade_vers(1.458, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_auteurs ADD cookie_oubli TINYTEXT NOT NULL");

		maj_version (1.462);
	}

	if (upgrade_vers(1.463, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_articles CHANGE popularite popularite DOUBLE");
		spip_query("ALTER TABLE spip_visites_temp ADD maj TIMESTAMP");
		spip_query("ALTER TABLE spip_referers_temp ADD maj TIMESTAMP");
		maj_version (1.463);
	}

	// l'upgrade < 1.462 ci-dessus etait fausse, d'ou correctif
	if (upgrade_vers(1.464, $version_installee, $version_cible) AND ($version_installee >= 1.462)) {

		maj_version (1.468);
	}

	if (upgrade_vers(1.470, $version_installee, $version_cible)) {
		if ($version_installee >= 1.467) {	// annule les "listes de diff"
			spip_query("DROP TABLE spip_listes");
			spip_query("ALTER TABLE spip_auteurs DROP abonne");
			spip_query("ALTER TABLE spip_auteurs DROP abonne_pass");
		}
		maj_version (1.470);
	}

	if (upgrade_vers(1.471, $version_installee, $version_cible)) {
		if ($version_installee >= 1.470) {	// annule les "maj"

ecrire/maj/v017.php 7 locations


		maj_version (1.703);
	}

	if (upgrade_vers(1.704, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_articles ADD INDEX lang (lang)");
		spip_query("ALTER TABLE spip_auteurs ADD INDEX lang (lang)");
		spip_query("ALTER TABLE spip_rubriques ADD INDEX lang (lang)");
		maj_version (1.704);
	}

	if (upgrade_vers(1.705, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_articles ADD langue_choisie VARCHAR(3) DEFAULT 'non'");

		maj_version (1.705);
	}

	if (upgrade_vers(1.707, $version_installee, $version_cible)) {
		spip_query("UPDATE spip_articles SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''");
		spip_query("UPDATE spip_articles SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'");
		spip_query("UPDATE spip_rubriques SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''");
		spip_query("UPDATE spip_rubriques SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'");
		maj_version (1.707);
	}

	if (upgrade_vers(1.708, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_breves ADD lang VARCHAR(10) DEFAULT '' NOT NULL");

		maj_version (1.717);
	}

	if (upgrade_vers(1.718, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_referers DROP domaine");
		spip_query("ALTER TABLE spip_referers_articles DROP domaine");
		spip_query("ALTER TABLE spip_referers_temp DROP domaine");
		maj_version (1.718);
	}

	if (upgrade_vers(1.722, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_articles ADD nom_site tinytext NOT NULL");

		maj_version (1.722);
	}

	if (upgrade_vers(1.723, $version_installee, $version_cible)) {
		if ($version_installee == 1.722) {
			spip_query("ALTER TABLE spip_articles MODIFY url_site VARCHAR(255) NOT NULL");
			spip_query("ALTER TABLE spip_articles DROP INDEX url_site;");
			spip_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site);");
		}
		maj_version (1.723);
	}

	if (upgrade_vers(1.724, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_messages ADD date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");

		maj_version (1.726);
	}

	if (upgrade_vers(1.727, $version_installee, $version_cible)) {
		// occitans : oci_xx -> oc_xx
		spip_query("UPDATE spip_auteurs SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
		spip_query("UPDATE spip_rubriques SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
		spip_query("UPDATE spip_articles SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
		spip_query("UPDATE spip_breves SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
		maj_version (1.727);
	}

	// Ici version 1.7 officielle
	if (upgrade_vers(1.728, $version_installee, $version_cible)) {

		maj_version (1.730);
	}

	if (upgrade_vers(1.731, $version_installee, $version_cible)) {
		spip_query("UPDATE spip_articles SET idx='1' where lang IN ('de','vi')");
		spip_query("UPDATE spip_rubriques SET idx='1' where lang IN ('de','vi')");
		spip_query("UPDATE spip_breves SET idx='1' where lang IN ('de','vi')");
		spip_query("UPDATE spip_auteurs SET idx='1' where lang IN ('de','vi')");
		maj_version (1.731);
	}

	if (upgrade_vers(1.732, $version_installee, $version_cible)) { // en correction d'un vieux truc qui avait fait sauter le champ inclus sur les bases version 1.415
		spip_query("ALTER TABLE spip_documents ADD inclus  VARCHAR(3) DEFAULT 'non'");

		maj_version (1.732);
	}

	if (upgrade_vers(1.733, $version_installee, $version_cible)) {
		// spip_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL");
		spip_query("DROP TABLE spip_versions");
		spip_query("DROP TABLE spip_versions_fragments");
		creer_base();
		maj_version(1.733);
	}

	#if ($version_installee < 1.734) {
	#	// integrer nouvelles tables auxiliaires du compilateur ESJ

ecrire/maj/v018.php 1 location


	}

	// Conformite des noms de certains champs (0minirezo => minirezo)
	if (upgrade_vers(1.818, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 0minirezo minirezo char(3) NOT NULL");
		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 1comite comite char(3) NOT NULL");
		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 6forum forum char(3) NOT NULL");
		maj_version(1.818);
	}

	// Options de syndication : miroir + oubli
	if (upgrade_vers(1.819, $version_installee, $version_cible)) {

ecrire/maj/v019_pre193.php 3 locations


	}

	// Syndication : ajout de source, url_source, tags
	if (upgrade_vers(1.902, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic_articles ADD `url_source` TINYTEXT DEFAULT '' NOT NULL");
		spip_query("ALTER TABLE spip_syndic_articles ADD `source` TINYTEXT DEFAULT '' NOT NULL");
		spip_query("ALTER TABLE spip_syndic_articles ADD `tags` TEXT DEFAULT '' NOT NULL");
		maj_version(1.902);
	}

	// URLs propres des sites (sait-on jamais)
	// + oubli des KEY url_propre sur les auteurs si installation neuve


	// URLs propres des sites (sait-on jamais)
	// + oubli des KEY url_propre sur les auteurs si installation neuve
	if (upgrade_vers(1.903, $version_installee, $version_cible)) {
		spip_query("ALTER TABLE spip_syndic ADD `url_propre` VARCHAR(255) NOT NULL");
		spip_query("ALTER TABLE spip_syndic ADD INDEX `url_propre` (`url_propre`)");
		spip_query("ALTER TABLE spip_auteurs ADD INDEX `url_propre` (`url_propre`)");
		maj_version(1.903);
	}

	// suppression des anciennes tables temporaires des visites
	// (maintenant stockees sous forme de fichiers)

		maj_version(1.909);
	}

	if (upgrade_vers(1.910, $version_installee, $version_cible)) {
		spip_query("ALTER IGNORE TABLE spip_auteurs_articles ADD PRIMARY KEY (`id_auteur`, `id_article`)");
		spip_query("ALTER IGNORE TABLE spip_auteurs_rubriques ADD PRIMARY KEY (`id_auteur`, `id_rubrique`)");
		spip_query("ALTER IGNORE TABLE spip_auteurs_messages ADD PRIMARY KEY (`id_auteur`, `id_message`)");
		maj_version(1.910);
	}

	if (upgrade_vers(1.911, $version_installee, $version_cible)) {


		@@ 125-130 (lines=6) @@
122		maj_version (1.418);
123		}
124
125		if (upgrade_vers(1.419, $version_installee, $version_cible)) {
126		spip_query("ALTER TABLE spip_auteurs ADD alea_actuel TINYTEXT DEFAULT ''");
127		spip_query("ALTER TABLE spip_auteurs ADD alea_futur TINYTEXT DEFAULT ''");
128		spip_query("UPDATE spip_auteurs SET alea_futur = FLOOR(32000*RAND())");
129		maj_version (1.419);
130		}
131
132		if (upgrade_vers(1.420, $version_installee, $version_cible)) {
133		spip_query("UPDATE spip_auteurs SET alea_actuel='' WHERE statut='nouveau'");
		@@ 143-148 (lines=6) @@
140		maj_version (1.421);
141		}
142
143		if (upgrade_vers(1.432, $version_installee, $version_cible)) {
144		spip_query("ALTER TABLE spip_articles DROP referers");
145		spip_query("ALTER TABLE spip_articles ADD referers INTEGER DEFAULT '0' NOT NULL");
146		spip_query("ALTER TABLE spip_articles ADD popularite INTEGER DEFAULT '0' NOT NULL");
147		maj_version (1.432);
148		}
149
150		if (upgrade_vers(1.436, $version_installee, $version_cible)) {
151		spip_query("ALTER TABLE spip_documents ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		@@ 167-173 (lines=7) @@
164		maj_version (1.438);
165		}
166
167		if (upgrade_vers(1.439, $version_installee, $version_cible)) {
168		spip_query("ALTER TABLE spip_syndic ADD INDEX statut (statut, date_syndic)");
169		spip_query("ALTER TABLE spip_syndic_articles ADD INDEX statut (statut)");
170		spip_query("ALTER TABLE spip_syndic_articles CHANGE url url VARCHAR(255) NOT NULL");
171		spip_query("ALTER TABLE spip_syndic_articles ADD INDEX url (url)");
172		maj_version (1.439);
173		}
174
175		if (upgrade_vers(1.440, $version_installee, $version_cible)) {
176		spip_query("ALTER TABLE spip_visites_temp CHANGE ip ip INTEGER UNSIGNED NOT NULL");
		@@ 180-185 (lines=6) @@
177		maj_version (1.440);
178		}
179
180		if (upgrade_vers(1.441, $version_installee, $version_cible)) {
181		spip_query("ALTER TABLE spip_visites_temp CHANGE date date DATE NOT NULL");
182		spip_query("ALTER TABLE spip_visites CHANGE date date DATE NOT NULL");
183		spip_query("ALTER TABLE spip_visites_referers CHANGE date date DATE NOT NULL");
184		maj_version (1.441);
185		}
186
187		if (upgrade_vers(1.442, $version_installee, $version_cible)) {
188		spip_query("ALTER TABLE spip_auteurs ADD prefs TINYTEXT NOT NULL");
		@@ 192-198 (lines=7) @@
189		maj_version (1.442);
190		}
191
192		if (upgrade_vers(1.443, $version_installee, $version_cible)) {
193		spip_query("ALTER TABLE spip_auteurs CHANGE login login VARCHAR(255) BINARY NOT NULL");
194		spip_query("ALTER TABLE spip_auteurs CHANGE statut statut VARCHAR(255) NOT NULL");
195		spip_query("ALTER TABLE spip_auteurs ADD INDEX login (login)");
196		spip_query("ALTER TABLE spip_auteurs ADD INDEX statut (statut)");
197		maj_version (1.443);
198		}
199
200		if (upgrade_vers(1.444, $version_installee, $version_cible)) {
201		spip_query("ALTER TABLE spip_syndic ADD moderation VARCHAR(3) NOT NULL");
		@@ 205-211 (lines=7) @@
202		maj_version (1.444);
203		}
204
205		if (upgrade_vers(1.457, $version_installee, $version_cible)) {
206		spip_query("DROP TABLE spip_visites");
207		spip_query("DROP TABLE spip_visites_temp");
208		spip_query("DROP TABLE spip_visites_referers");
209		creer_base(); // crade, a ameliorer :-((
210		maj_version (1.457);
211		}
212
213		if (upgrade_vers(1.458, $version_installee, $version_cible)) {
214		spip_query("ALTER TABLE spip_auteurs ADD cookie_oubli TINYTEXT NOT NULL");
		@@ 255-260 (lines=6) @@
252		maj_version (1.462);
253		}
254
255		if (upgrade_vers(1.463, $version_installee, $version_cible)) {
256		spip_query("ALTER TABLE spip_articles CHANGE popularite popularite DOUBLE");
257		spip_query("ALTER TABLE spip_visites_temp ADD maj TIMESTAMP");
258		spip_query("ALTER TABLE spip_referers_temp ADD maj TIMESTAMP");
259		maj_version (1.463);
260		}
261
262		// l'upgrade < 1.462 ci-dessus etait fausse, d'ou correctif
263		if (upgrade_vers(1.464, $version_installee, $version_cible) AND ($version_installee >= 1.462)) {
		@@ 289-296 (lines=8) @@
286		maj_version (1.468);
287		}
288
289		if (upgrade_vers(1.470, $version_installee, $version_cible)) {
290		if ($version_installee >= 1.467) { // annule les "listes de diff"
291		spip_query("DROP TABLE spip_listes");
292		spip_query("ALTER TABLE spip_auteurs DROP abonne");
293		spip_query("ALTER TABLE spip_auteurs DROP abonne_pass");
294		}
295		maj_version (1.470);
296		}
297
298		if (upgrade_vers(1.471, $version_installee, $version_cible)) {
299		if ($version_installee >= 1.470) { // annule les "maj"

		@@ 52-57 (lines=6) @@
49		maj_version (1.703);
50		}
51
52		if (upgrade_vers(1.704, $version_installee, $version_cible)) {
53		spip_query("ALTER TABLE spip_articles ADD INDEX lang (lang)");
54		spip_query("ALTER TABLE spip_auteurs ADD INDEX lang (lang)");
55		spip_query("ALTER TABLE spip_rubriques ADD INDEX lang (lang)");
56		maj_version (1.704);
57		}
58
59		if (upgrade_vers(1.705, $version_installee, $version_cible)) {
60		spip_query("ALTER TABLE spip_articles ADD langue_choisie VARCHAR(3) DEFAULT 'non'");
		@@ 65-71 (lines=7) @@
62		maj_version (1.705);
63		}
64
65		if (upgrade_vers(1.707, $version_installee, $version_cible)) {
66		spip_query("UPDATE spip_articles SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''");
67		spip_query("UPDATE spip_articles SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'");
68		spip_query("UPDATE spip_rubriques SET langue_choisie='oui' WHERE MID(lang,1,1) != '.' AND lang != ''");
69		spip_query("UPDATE spip_rubriques SET lang=MID(lang,2,8) WHERE langue_choisie = 'non'");
70		maj_version (1.707);
71		}
72
73		if (upgrade_vers(1.708, $version_installee, $version_cible)) {
74		spip_query("ALTER TABLE spip_breves ADD lang VARCHAR(10) DEFAULT '' NOT NULL");
		@@ 90-95 (lines=6) @@
87		maj_version (1.717);
88		}
89
90		if (upgrade_vers(1.718, $version_installee, $version_cible)) {
91		spip_query("ALTER TABLE spip_referers DROP domaine");
92		spip_query("ALTER TABLE spip_referers_articles DROP domaine");
93		spip_query("ALTER TABLE spip_referers_temp DROP domaine");
94		maj_version (1.718);
95		}
96
97		if (upgrade_vers(1.722, $version_installee, $version_cible)) {
98		spip_query("ALTER TABLE spip_articles ADD nom_site tinytext NOT NULL");
		@@ 109-116 (lines=8) @@
106		maj_version (1.722);
107		}
108
109		if (upgrade_vers(1.723, $version_installee, $version_cible)) {
110		if ($version_installee == 1.722) {
111		spip_query("ALTER TABLE spip_articles MODIFY url_site VARCHAR(255) NOT NULL");
112		spip_query("ALTER TABLE spip_articles DROP INDEX url_site;");
113		spip_query("ALTER TABLE spip_articles ADD INDEX url_site (url_site);");
114		}
115		maj_version (1.723);
116		}
117
118		if (upgrade_vers(1.724, $version_installee, $version_cible)) {
119		spip_query("ALTER TABLE spip_messages ADD date_fin datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		@@ 128-135 (lines=8) @@
125		maj_version (1.726);
126		}
127
128		if (upgrade_vers(1.727, $version_installee, $version_cible)) {
129		// occitans : oci_xx -> oc_xx
130		spip_query("UPDATE spip_auteurs SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
131		spip_query("UPDATE spip_rubriques SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
132		spip_query("UPDATE spip_articles SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
133		spip_query("UPDATE spip_breves SET lang=REPLACE(lang,'oci_', 'oc_') WHERE lang LIKE 'oci_%'");
134		maj_version (1.727);
135		}
136
137		// Ici version 1.7 officielle
138		if (upgrade_vers(1.728, $version_installee, $version_cible)) {
		@@ 163-169 (lines=7) @@
160		maj_version (1.730);
161		}
162
163		if (upgrade_vers(1.731, $version_installee, $version_cible)) {
164		spip_query("UPDATE spip_articles SET idx='1' where lang IN ('de','vi')");
165		spip_query("UPDATE spip_rubriques SET idx='1' where lang IN ('de','vi')");
166		spip_query("UPDATE spip_breves SET idx='1' where lang IN ('de','vi')");
167		spip_query("UPDATE spip_auteurs SET idx='1' where lang IN ('de','vi')");
168		maj_version (1.731);
169		}
170
171		if (upgrade_vers(1.732, $version_installee, $version_cible)) { // en correction d'un vieux truc qui avait fait sauter le champ inclus sur les bases version 1.415
172		spip_query("ALTER TABLE spip_documents ADD inclus VARCHAR(3) DEFAULT 'non'");
		@@ 176-182 (lines=7) @@
173		maj_version (1.732);
174		}
175
176		if (upgrade_vers(1.733, $version_installee, $version_cible)) {
177		// spip_query("ALTER TABLE spip_articles ADD id_version int unsigned DEFAULT '0' NOT NULL");
178		spip_query("DROP TABLE spip_versions");
179		spip_query("DROP TABLE spip_versions_fragments");
180		creer_base();
181		maj_version(1.733);
182		}
183
184		#if ($version_installee < 1.734) {
185		# // integrer nouvelles tables auxiliaires du compilateur ESJ

		@@ 152-157 (lines=6) @@
149		}
150
151		// Conformite des noms de certains champs (0minirezo => minirezo)
152		if (upgrade_vers(1.818, $version_installee, $version_cible)) {
153		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 0minirezo minirezo char(3) NOT NULL");
154		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 1comite comite char(3) NOT NULL");
155		spip_query("ALTER TABLE spip_groupes_mots CHANGE COLUMN 6forum forum char(3) NOT NULL");
156		maj_version(1.818);
157		}
158
159		// Options de syndication : miroir + oubli
160		if (upgrade_vers(1.819, $version_installee, $version_cible)) {

		@@ 56-61 (lines=6) @@
53		maj_version (1.208);
54		}
55
56		if (upgrade_vers(1.209, $version_installee, $version_cible)) {
57		spip_query("ALTER TABLE spip_syndic ADD maj TIMESTAMP");
58		spip_query("ALTER TABLE spip_syndic_articles ADD maj TIMESTAMP");
59		spip_query("ALTER TABLE spip_messages ADD maj TIMESTAMP");
60		maj_version (1.209);
61		}
62
63		if (upgrade_vers(1.210, $version_installee, $version_cible)) {
64		spip_query("ALTER TABLE spip_messages DROP page");

		@@ 44-49 (lines=6) @@
41		maj_version (1.302);
42		}
43
44		if (upgrade_vers(1.303, $version_installee, $version_cible)) {
45		spip_query("ALTER TABLE spip_rubriques ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
46		spip_query("ALTER TABLE spip_syndic ADD date_syndic datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
47		spip_query("UPDATE spip_syndic SET date_syndic=date");
48		maj_version (1.303);
49		}
50
51		if (upgrade_vers(1.306, $version_installee, $version_cible)) {
52		spip_query("DROP TABLE spip_index_syndic_articles");
		@@ 51-56 (lines=6) @@
48		maj_version (1.303);
49		}
50
51		if (upgrade_vers(1.306, $version_installee, $version_cible)) {
52		spip_query("DROP TABLE spip_index_syndic_articles");
53		spip_query("ALTER TABLE spip_syndic ADD date_index datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
54		spip_query("ALTER TABLE spip_syndic ADD INDEX date_index (date_index)");
55		maj_version (1.306);
56		}
57
58		if (upgrade_vers(1.307, $version_installee, $version_cible)) {
59		spip_query("ALTER TABLE spip_syndic_articles ADD descriptif blob NOT NULL");

		@@ 25-30 (lines=6) @@
22		}
23
24		// Syndication : ajout de source, url_source, tags
25		if (upgrade_vers(1.902, $version_installee, $version_cible)) {
26		spip_query("ALTER TABLE spip_syndic_articles ADD `url_source` TINYTEXT DEFAULT '' NOT NULL");
27		spip_query("ALTER TABLE spip_syndic_articles ADD `source` TINYTEXT DEFAULT '' NOT NULL");
28		spip_query("ALTER TABLE spip_syndic_articles ADD `tags` TEXT DEFAULT '' NOT NULL");
29		maj_version(1.902);
30		}
31
32		// URLs propres des sites (sait-on jamais)
33		// + oubli des KEY url_propre sur les auteurs si installation neuve
		@@ 34-39 (lines=6) @@
31
32		// URLs propres des sites (sait-on jamais)
33		// + oubli des KEY url_propre sur les auteurs si installation neuve
34		if (upgrade_vers(1.903, $version_installee, $version_cible)) {
35		spip_query("ALTER TABLE spip_syndic ADD `url_propre` VARCHAR(255) NOT NULL");
36		spip_query("ALTER TABLE spip_syndic ADD INDEX `url_propre` (`url_propre`)");
37		spip_query("ALTER TABLE spip_auteurs ADD INDEX `url_propre` (`url_propre`)");
38		maj_version(1.903);
39		}
40
41		// suppression des anciennes tables temporaires des visites
42		// (maintenant stockees sous forme de fichiers)
		@@ 132-137 (lines=6) @@
129		maj_version(1.909);
130		}
131
132		if (upgrade_vers(1.910, $version_installee, $version_cible)) {
133		spip_query("ALTER IGNORE TABLE spip_auteurs_articles ADD PRIMARY KEY (`id_auteur`, `id_article`)");
134		spip_query("ALTER IGNORE TABLE spip_auteurs_rubriques ADD PRIMARY KEY (`id_auteur`, `id_rubrique`)");
135		spip_query("ALTER IGNORE TABLE spip_auteurs_messages ADD PRIMARY KEY (`id_auteur`, `id_message`)");
136		maj_version(1.910);
137		}
138
139		if (upgrade_vers(1.911, $version_installee, $version_cible)) {
140

spip / SPIP

Code Duplication Length = 6-8 lines in 22 locations

ecrire/maj/v012.php 1 location

ecrire/maj/v013.php 2 locations

ecrire/maj/v014.php 8 locations

ecrire/maj/v017.php 7 locations

ecrire/maj/v018.php 1 location

ecrire/maj/v019_pre193.php 3 locations