v014.php ➔ maj_legacy_v014_dist() - Code Metrics - Inspection of "Fix #3535 : initialiser le champ imessage quand on..." - spip/SPIP - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 3e6f39...ee2ef7 )

by cam

created 2021-02-18 16:35 UTC

v014.php ➔ maj_legacy_v014_dist() F

↳ Parent: Project

Complexity

Conditions	49
Paths	> 20000

Size

Total Lines

309

Duplication

Lines	92
Ratio	29.77 %

Importance

Changes

Metric	Value
cc	49
nc	4294967295
nop	2
dl	92
loc	309
rs	0
c	0
b	0
f	0

How to fix Long Method Complexity

<?php

/***************************************************************************\
 *  SPIP, Système de publication pour l'internet                           *
 *                                                                         *
 *  Copyright © avec tendresse depuis 2001                                 *
 *  Arnaud Martin, Antoine Pitrou, Philippe Rivière, Emmanuel Saint-James  *
 *                                                                         *
 *  Ce programme est un logiciel libre distribué sous licence GNU/GPL.     *
 *  Pour plus de détails voir le fichier COPYING.txt ou l'aide en ligne.   *
\***************************************************************************/

/**
 * Gestion des mises à jour de SPIP, versions 1.4*
 *
 * @package SPIP\Core\SQL\Upgrade
 **/
if (!defined('_ECRIRE_INC_VERSION')) {
	return;
}

/**
 * Mises à jour de SPIP n°014
 *
 * @param float $version_installee Version actuelle
 * @param float $version_cible Version de destination
 **/
function maj_legacy_v014_dist($version_installee, $version_cible) {
	if (upgrade_vers(1.404, $version_installee, $version_cible)) {

		sql_query("UPDATE spip_mots SET type='Mots sans groupe...' WHERE type=''");

		$result = sql_query("SELECT * FROM spip_mots GROUP BY type");
		while ($row = sql_fetch($result)) {
			$type = addslashes($row['type']);
			// Old style, doit echouer
			spip_log('ne pas tenir compte de l erreur spip_groupes_mots ci-dessous:', 'mysql');
			sql_query("INSERT INTO spip_groupes_mots 					(titre, unseul, obligatoire, articles, breves, rubriques, syndic, 0minirezo, 1comite, 6forum)					VALUES (\"$type\", 'non', 'non', 'oui', 'oui', 'non', 'oui', 'oui', 'oui', 'non')");
			// New style, devrait marcher
			sql_query("INSERT INTO spip_groupes_mots 					(titre, unseul, obligatoire, articles, breves, rubriques, syndic, minirezo, comite, forum)					VALUES (\"$type\", 'non', 'non', 'oui', 'oui', 'non', 'oui', 'oui', 'oui', 'non')");
		}
		sql_delete("spip_mots", "titre='kawax'");
		maj_version(1.404);

	}

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

		sql_query("ALTER TABLE spip_mots ADD id_groupe bigint(21) NOT NULL");

		$result = sql_query("SELECT * FROM spip_groupes_mots");
		while ($row = sql_fetch($result)) {
			$id_groupe = addslashes($row['id_groupe']);
			$type = addslashes($row['titre']);
			sql_query("UPDATE spip_mots SET id_groupe = '$id_groupe' WHERE type='$type'");
		}
		maj_version(1.405);

	}

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

		// Images articles passent dans spip_documents
		$result = sql_query("SELECT id_article, images FROM spip_articles WHERE LENGTH(images) > 0");


		$types = array('jpg' => 1, 'png' => 2, 'gif' => 3);

		while ($row = @sql_fetch($result)) {
			$id_article = $row['id_article'];
			$images = $row['images'];
			$images = explode(",", $images);
			reset($images);
			$replace = '_orig_';
			foreach ($images as $val) {
				$image = explode("|", $val);
				$fichier = $image[0];
				$largeur = $image[1];
				$hauteur = $image[2];
				preg_match(",-([0-9]+)\.(gif|jpg|png)$,i", $fichier, $match);
				$id_type = intval($types[$match[2]]);
				$num_img = $match[1];
				$fichier = _DIR_IMG . $fichier;
				$taille = @filesize($fichier);
				// ici on n'a pas les fonctions absctract !
				sql_query("INSERT INTO spip_documents (titre, id_type, fichier, mode, largeur, hauteur, taille) VALUES ('image $largeur x $hauteur', $id_type, '$fichier', 'vignette', '$largeur', '$hauteur', '$taille')");
				$id_document = mysqli_insert_id(_mysql_link());
				if ($id_document > 0) {
					sql_query("INSERT INTO spip_documents_articles (id_document, id_article) VALUES ($id_document, $id_article)");
					$replace = "REPLACE($replace, '<IMG$num_img|', '<IM_$id_document|')";
				} else {
					echo _T('texte_erreur_mise_niveau_base', array('fichier' => $fichier, 'id_article' => $id_article));
					exit;
				}
			}
			$replace = "REPLACE($replace, '<IM_', '<IMG')";
			$replace_chapo = str_replace('_orig_', 'chapo', $replace);
			$replace_descriptif = str_replace('_orig_', 'descriptif', $replace);
			$replace_texte = str_replace('_orig_', 'texte', $replace);
			$replace_ps = str_replace('_orig_', 'ps', $replace);
			sql_query("UPDATE spip_articles SET chapo=$replace_chapo, descriptif=$replace_descriptif, texte=$replace_texte, ps=$replace_ps WHERE id_article=$id_article");

		}
		sql_query("ALTER TABLE spip_articles DROP images");
		maj_version(1.408);

	}

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

		// Forum par defaut "en dur" dans les spip_articles
		// -> non, prio (priori), pos (posteriori), abo (abonnement)
		$accepter_forum = substr($GLOBALS['meta']["forums_publics"], 0, 3);
		$result = sql_query("ALTER TABLE spip_articles CHANGE accepter_forum accepter_forum CHAR(3) NOT NULL");
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

		$result = sql_query("UPDATE spip_articles SET accepter_forum='$accepter_forum' WHERE accepter_forum != 'non'");
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

		maj_version(1.414);

	}

	/*
	if ($version_installee == 1.415) {
		sql_query("ALTER TABLE spip_documents DROP inclus");
		maj_version (1.415);
	}
	*/

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

		sql_query("ALTER TABLE spip_syndic_articles DROP date_index");
		maj_version(1.417);

	}

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

		$result = sql_query("SELECT * FROM spip_auteurs WHERE statut = '0minirezo' AND email != '' ORDER BY id_auteur LIMIT 1");

		if ($webmaster = sql_fetch($result)) {
			ecrire_meta('email_webmaster', $webmaster['email']);
		}
		maj_version(1.418);

	}

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

		sql_query("ALTER TABLE spip_auteurs ADD alea_actuel TINYTEXT DEFAULT ''");
		sql_query("ALTER TABLE spip_auteurs ADD alea_futur TINYTEXT DEFAULT ''");
		sql_query("UPDATE spip_auteurs SET alea_futur = FLOOR(32000*RAND())");
		maj_version(1.419);

	}

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

		sql_query("UPDATE spip_auteurs SET alea_actuel='' WHERE statut='nouveau'");
		maj_version(1.420);

	}

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

		sql_query("ALTER TABLE spip_articles ADD auteur_modif bigint(21) DEFAULT '0' NOT NULL");
		sql_query("ALTER TABLE spip_articles ADD date_modif datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		maj_version(1.421);

	}

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

		sql_query("ALTER TABLE spip_articles DROP referers");
		sql_query("ALTER TABLE spip_articles ADD referers INTEGER DEFAULT '0' NOT NULL");
		sql_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)) {

		sql_query("ALTER TABLE spip_documents ADD date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");
		maj_version(1.436);

	}

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

		sql_query("ALTER TABLE spip_visites ADD maj TIMESTAMP");
		sql_query("ALTER TABLE spip_visites_referers ADD maj TIMESTAMP");
		maj_version(1.437);

	}

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

		sql_query("ALTER TABLE spip_articles ADD INDEX id_secteur (id_secteur)");
		sql_query("ALTER TABLE spip_articles ADD INDEX statut (statut, date)");
		maj_version(1.438);

	}

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

		sql_query("ALTER TABLE spip_syndic ADD INDEX statut (statut, date_syndic)");
		sql_query("ALTER TABLE spip_syndic_articles ADD INDEX statut (statut)");
		sql_query("ALTER TABLE spip_syndic_articles CHANGE url url VARCHAR(255) NOT NULL");
		sql_query("ALTER TABLE spip_syndic_articles ADD INDEX url (url)");
		maj_version(1.439);

	}

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

		sql_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)) {

		sql_query("ALTER TABLE spip_visites_temp CHANGE date date DATE NOT NULL");
		sql_query("ALTER TABLE spip_visites CHANGE date date DATE NOT NULL");
		sql_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)) {

		sql_query("ALTER TABLE spip_auteurs ADD prefs TINYTEXT NOT NULL");
		maj_version(1.442);

	}

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

		sql_query("ALTER TABLE spip_auteurs CHANGE login login VARCHAR(255) BINARY NOT NULL");
		sql_query("ALTER TABLE spip_auteurs CHANGE statut statut VARCHAR(255) NOT NULL");
		sql_query("ALTER TABLE spip_auteurs ADD INDEX login (login)");
		sql_query("ALTER TABLE spip_auteurs ADD INDEX statut (statut)");
		maj_version(1.443);

	}

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

		sql_query("ALTER TABLE spip_syndic ADD moderation VARCHAR(3) NOT NULL");
		maj_version(1.444);

	}

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

		sql_query("DROP TABLE spip_visites");
		sql_query("DROP TABLE spip_visites_temp");
		sql_query("DROP TABLE spip_visites_referers");
		creer_base(); // crade, a ameliorer :-((
		maj_version(1.457);

	}

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

		sql_query("ALTER TABLE spip_auteurs ADD cookie_oubli TINYTEXT NOT NULL");
		maj_version(1.458);

	}

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

		$result = sql_query("SELECT type FROM spip_mots GROUP BY type");
		while ($row = sql_fetch($result)) {
			$type = addslashes($row['type']);
			$res = sql_query("SELECT * FROM spip_groupes_mots WHERE titre='$type'");
			if (sql_count($res) == 0) {
				sql_query("INSERT INTO spip_groupes_mots (titre, unseul, obligatoire, articles, breves, rubriques, syndic, minirezo, comite, forum) VALUES ('$type', 'non', 'non', 'oui', 'oui', 'non', 'oui', 'oui', 'oui', 'non')");
				if ($id_groupe = mysqli_insert_id(_mysql_link())) {
					sql_query("UPDATE spip_mots SET id_groupe = '$id_groupe' WHERE type='$type'");
				}
			}
		}
		sql_query("UPDATE spip_articles SET popularite=0");
		maj_version(1.459);

	}

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

		// remettre les mots dans les groupes dupliques par erreur
		// dans la precedente version du paragraphe de maj 1.459
		// et supprimer ceux-ci
		$result = sql_query("SELECT * FROM spip_groupes_mots ORDER BY id_groupe");
		while ($row = sql_fetch($result)) {
			$titre = addslashes($row['titre']);
			if (!$vu[$titre]) {
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
				$vu[$titre] = true;
foreach ($collection as $item) {
    $myArray['foo'] = $item->getFoo();

    if ($item->hasBar()) {
        $myArray['bar'] = $item->getBar();
    }

    // do something with $myArray
}
				$id_groupe = $row['id_groupe'];
				sql_query("UPDATE spip_mots SET id_groupe=$id_groupe WHERE type='$titre'");
				sql_delete("spip_groupes_mots", "titre='$titre' AND id_groupe<>$id_groupe");
			}
		}
		maj_version(1.460);

	}

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

		sql_query("UPDATE spip_types_documents SET inclus='embed' WHERE inclus!='non' AND extension IN ('aiff', 'asf', 'avi', 'mid', 'mov', 'mp3', 'mpg', 'ogg', 'qt', 'ra', 'ram', 'rm', 'swf', 'wav', 'wmv')");
		maj_version(1.462);

	}

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

		sql_query("ALTER TABLE spip_articles CHANGE popularite popularite DOUBLE");
		sql_query("ALTER TABLE spip_visites_temp ADD maj TIMESTAMP");
		sql_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)) {

		$res = sql_query("SELECT id_type, extension FROM spip_types_documents WHERE id_type NOT IN (1,2,3)");
		while ($row = sql_fetch($res)) {
			$extension = $row['extension'];
			$id_type = $row['id_type'];
			sql_query("UPDATE spip_documents SET id_type=$id_type	WHERE fichier like '%.$extension'");
		}
		maj_version(1.464);

	}

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

		sql_query("ALTER TABLE spip_articles CHANGE popularite popularite DOUBLE NOT NULL");
		maj_version(1.465);

	}

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

		sql_query("ALTER TABLE spip_auteurs ADD source VARCHAR(10) DEFAULT 'spip' NOT NULL");
		maj_version(1.466);

	}

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

		sql_query("ALTER TABLE spip_auteurs ADD INDEX en_ligne (en_ligne)");
		sql_query("ALTER TABLE spip_forum ADD INDEX statut (statut, date_heure)");
		maj_version(1.468);

	}

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

		if ($version_installee >= 1.467) {  // annule les "listes de diff"
			sql_query("DROP TABLE spip_listes");
			sql_query("ALTER TABLE spip_auteurs DROP abonne");
			sql_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"

			sql_query("ALTER TABLE spip_auteurs_articles DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_auteurs_rubriques DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_auteurs_messages DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_documents_articles DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_documents_rubriques DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_documents_breves DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_mots_articles DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_mots_breves DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_mots_rubriques DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_mots_syndic DROP maj TIMESTAMP");
			sql_query("ALTER TABLE spip_mots_forum DROP maj TIMESTAMP");
		}
		maj_version(1.471);

	}

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

		sql_query("ALTER TABLE spip_referers ADD visites_jour INTEGER UNSIGNED NOT NULL");
		maj_version(1.472);

	}

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

		sql_query("UPDATE spip_syndic_articles SET url = REPLACE(url, '&amp;', '&')");
		sql_query("UPDATE spip_syndic SET url_site = REPLACE(url_site, '&amp;', '&')");
		maj_version(1.473);

	}
}


1		<?php
2
3		/***************************************************************************\
4		* SPIP, Système de publication pour l'internet *
5		* *
6		* Copyright © avec tendresse depuis 2001 *
7		* Arnaud Martin, Antoine Pitrou, Philippe Rivière, Emmanuel Saint-James *
8		* *
9		* Ce programme est un logiciel libre distribué sous licence GNU/GPL. *
10		* Pour plus de détails voir le fichier COPYING.txt ou l'aide en ligne. *
11		\***************************************************************************/
12
13		/**
14		* Gestion des mises à jour de SPIP, versions 1.4*
15		*
16		* @package SPIP\Core\SQL\Upgrade
17		**/
18		if (!defined('_ECRIRE_INC_VERSION')) {
19		return;
20		}
21
22		/**
23		* Mises à jour de SPIP n°014
24		*
25		* @param float $version_installee Version actuelle
26		* @param float $version_cible Version de destination
27		**/
28		function maj_legacy_v014_dist($version_installee, $version_cible) {
29	View Code Duplication	if (upgrade_vers(1.404, $version_installee, $version_cible)) {
		0 ignored issues – show Deprecated Code introduced 2016-04-05 12:13 UTC by Report Bug Copy Issue Report The function `upgrade_vers()` has been deprecated with message: Utiliser `maj_plugin()` ou la globale `maj` pour le core. This function has been deprecated. The supplier of the file has supplied an explanatory message. The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead. Loading history... Duplication introduced 2016-04-05 12:02 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
30		sql_query("UPDATE spip_mots SET type='Mots sans groupe...' WHERE type=''");
31
32		$result = sql_query("SELECT * FROM spip_mots GROUP BY type");
33		while ($row = sql_fetch($result)) {
34		$type = addslashes($row['type']);
35		// Old style, doit echouer
36		spip_log('ne pas tenir compte de l erreur spip_groupes_mots ci-dessous:', 'mysql');
37		sql_query("INSERT INTO spip_groupes_mots (titre, unseul, obligatoire, articles, breves, rubriques, syndic, 0minirezo, 1comite, 6forum) VALUES (\"$type\", 'non', 'non', 'oui', 'oui', 'non', 'oui', 'oui', 'oui', 'non')");
38		// New style, devrait marcher
39		sql_query("INSERT INTO spip_groupes_mots (titre, unseul, obligatoire, articles, breves, rubriques, syndic, minirezo, comite, forum) VALUES (\"$type\", 'non', 'non', 'oui', 'oui', 'non', 'oui', 'oui', 'oui', 'non')");

spip / SPIP

Push — master ( 3e6f39...ee2ef7 )

v014.php ➔ maj_legacy_v014_dist() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Available Fixes

Duplication Side-by-Side

Filter issues like