Completed
Push — master ( 6d7580...98d900 )
by cam
01:11
created
ecrire/req/mysql.php 1 patch
Spacing   +78 added lines, -78 removed lines patch added patch discarded remove patch
@@ -58,12 +58,12 @@  discard block
 block discarded – undo
58 58
 			$link = @mysqli_connect($host, $login, $pass);
59 59
 		}
60 60
 	} catch (\mysqli_sql_exception $e) {
61
-		spip_log('mysqli_sql_exception: ' . $e->getMessage(), 'mysql.' . _LOG_DEBUG);
61
+		spip_log('mysqli_sql_exception: '.$e->getMessage(), 'mysql.'._LOG_DEBUG);
62 62
 		$link = false;
63 63
 	}
64 64
 
65 65
 	if (!$link) {
66
-		spip_log('Echec mysqli_connect. Erreur : ' . mysqli_connect_error(), 'mysql.' . _LOG_HS);
66
+		spip_log('Echec mysqli_connect. Erreur : '.mysqli_connect_error(), 'mysql.'._LOG_HS);
67 67
 
68 68
 		return false;
69 69
 	}
@@ -82,7 +82,7 @@  discard block
 block discarded – undo
82 82
 	}
83 83
 
84 84
 	spip_log(
85
-		"Connexion MySQLi vers $host, base $db, prefixe $prefixe " . ($ok ? 'operationnelle' : 'impossible'),
85
+		"Connexion MySQLi vers $host, base $db, prefixe $prefixe ".($ok ? 'operationnelle' : 'impossible'),
86 86
 		_LOG_DEBUG
87 87
 	);
88 88
 
@@ -173,9 +173,9 @@  discard block
 block discarded – undo
173 173
  */
174 174
 function spip_mysql_set_charset($charset, $serveur = '', $requeter = true) {
175 175
 	$connexion = &$GLOBALS['connexions'][$serveur ? strtolower($serveur) : 0];
176
-	spip_log('changement de charset sql : ' . 'SET NAMES ' . _q($charset), _LOG_DEBUG);
176
+	spip_log('changement de charset sql : '.'SET NAMES '._q($charset), _LOG_DEBUG);
177 177
 
178
-	return mysqli_query($connexion['link'], $connexion['last'] = 'SET NAMES ' . _q($charset));
178
+	return mysqli_query($connexion['link'], $connexion['last'] = 'SET NAMES '._q($charset));
179 179
 }
180 180
 
181 181
 
@@ -190,7 +190,7 @@  discard block
 block discarded – undo
190 190
 function spip_mysql_get_charset($charset = [], $serveur = '', $requeter = true) {
191 191
 	$connexion = &$GLOBALS['connexions'][$serveur ? strtolower($serveur) : 0];
192 192
 	$connexion['last'] = $c = 'SHOW CHARACTER SET'
193
-		. (!$charset ? '' : (' LIKE ' . _q($charset['charset'])));
193
+		. (!$charset ? '' : (' LIKE '._q($charset['charset'])));
194 194
 
195 195
 	return spip_mysql_fetch(mysqli_query($connexion['link'], $c), null, $serveur);
196 196
 }
@@ -234,21 +234,21 @@  discard block
 block discarded – undo
234 234
 	$debug = '';
235 235
 	if (defined('_DEBUG_SLOW_QUERIES') and _DEBUG_SLOW_QUERIES) {
236 236
 		if (isset($GLOBALS['debug']['aucasou'])) {
237
-			[, $id, , $infos] = $GLOBALS['debug']['aucasou'];
238
-			$debug .= "BOUCLE$id @ " . ($infos[0] ?? '') . ' | ';
237
+			[, $id,, $infos] = $GLOBALS['debug']['aucasou'];
238
+			$debug .= "BOUCLE$id @ ".($infos[0] ?? '').' | ';
239 239
 		}
240 240
 		if (isset($_SERVER['REQUEST_URI'])) {
241 241
 			$debug .= $_SERVER['REQUEST_URI'];
242 242
 		}
243 243
 		if (!empty($GLOBALS['ip'])) {
244
-			$debug .= ' + ' . $GLOBALS['ip'];
244
+			$debug .= ' + '.$GLOBALS['ip'];
245 245
 		}
246
-		$debug = ' /* ' . mysqli_real_escape_string($link, str_replace('*/', '@/', $debug)) . ' */';
246
+		$debug = ' /* '.mysqli_real_escape_string($link, str_replace('*/', '@/', $debug)).' */';
247 247
 	}
248 248
 	try {
249
-		$r = mysqli_query($link, $query . $debug);
249
+		$r = mysqli_query($link, $query.$debug);
250 250
 	} catch (\mysqli_sql_exception $e) {
251
-		spip_log('mysqli_sql_exception: ' . $e->getMessage(), 'mysql.' . _LOG_DEBUG);
251
+		spip_log('mysqli_sql_exception: '.$e->getMessage(), 'mysql.'._LOG_DEBUG);
252 252
 		$r = false;
253 253
 		// TODO: utiliser l’exception ensuite plutôt que les appels à spip_mysql_errno()
254 254
 		// mais il faut pour php < 8.1 forcer les exeptions via mysqli_report().
@@ -266,9 +266,9 @@  discard block
 block discarded – undo
266 266
 			$link = $connexion['link'];
267 267
 			//On retente au cas où
268 268
 			try {
269
-				$r = mysqli_query($link, $query . $debug);
269
+				$r = mysqli_query($link, $query.$debug);
270 270
 			} catch (\mysqli_sql_exception $e) {
271
-				spip_log('mysqli_sql_exception: ' . $e->getMessage(), 'mysql.' . _LOG_DEBUG);
271
+				spip_log('mysqli_sql_exception: '.$e->getMessage(), 'mysql.'._LOG_DEBUG);
272 272
 				$r = false;
273 273
 				// TODO: utiliser l’exception ensuite plutôt que les appels à spip_mysql_errno()
274 274
 				// mais il faut pour php < 8.1 forcer les exeptions via mysqli_report().
@@ -301,7 +301,7 @@  discard block
 block discarded – undo
301 301
 	// d'utiliser ceux-ci, copie-colle de phpmyadmin
302 302
 	$query = preg_replace(',^TABLE\s*`([^`]*)`,i', "TABLE \\1", $query);
303 303
 
304
-	return spip_mysql_query('ALTER ' . $query, $serveur, $requeter); # i.e. que PG se debrouille
304
+	return spip_mysql_query('ALTER '.$query, $serveur, $requeter); # i.e. que PG se debrouille
305 305
 }
306 306
 
307 307
 
@@ -314,7 +314,7 @@  discard block
 block discarded – undo
314 314
  * @return bool            Toujours true
315 315
  */
316 316
 function spip_mysql_optimize($table, $serveur = '', $requeter = true) {
317
-	spip_mysql_query('OPTIMIZE TABLE ' . $table);
317
+	spip_mysql_query('OPTIMIZE TABLE '.$table);
318 318
 
319 319
 	return true;
320 320
 }
@@ -337,7 +337,7 @@  discard block
 block discarded – undo
337 337
 	$link = $connexion['link'];
338 338
 	$db = $connexion['db'];
339 339
 
340
-	$query = 'EXPLAIN ' . _mysql_traite_query($query, $db, $prefixe);
340
+	$query = 'EXPLAIN '._mysql_traite_query($query, $db, $prefixe);
341 341
 	$r = mysqli_query($link, $query);
342 342
 
343 343
 	return spip_mysql_fetch($r, null, $serveur);
@@ -388,7 +388,7 @@  discard block
 block discarded – undo
388 388
 		. calculer_mysql_expression('WHERE', $where)
389 389
 		. calculer_mysql_expression('GROUP BY', $groupby, ',')
390 390
 		. calculer_mysql_expression('HAVING', $having)
391
-		. ($orderby ? ("\nORDER BY " . spip_mysql_order($orderby)) : '')
391
+		. ($orderby ? ("\nORDER BY ".spip_mysql_order($orderby)) : '')
392 392
 		. ($limit ? "\nLIMIT $limit" : '');
393 393
 
394 394
 	// renvoyer la requete inerte si demandee
@@ -478,12 +478,12 @@  discard block
 block discarded – undo
478 478
 	$exp = "\n$expression ";
479 479
 
480 480
 	if (!is_array($v)) {
481
-		return $exp . $v;
481
+		return $exp.$v;
482 482
 	} else {
483 483
 		if (strtoupper($join) === 'AND') {
484
-			return $exp . join("\n\t$join ", array_map('calculer_mysql_where', $v));
484
+			return $exp.join("\n\t$join ", array_map('calculer_mysql_where', $v));
485 485
 		} else {
486
-			return $exp . join($join, $v);
486
+			return $exp.join($join, $v);
487 487
 		}
488 488
 	}
489 489
 }
@@ -501,17 +501,17 @@  discard block
 block discarded – undo
501 501
 		if (substr($k, -1) == '@') {
502 502
 			// c'est une jointure qui se refere au from precedent
503 503
 			// pas de virgule
504
-			$res .= '  ' . $v;
504
+			$res .= '  '.$v;
505 505
 		} else {
506 506
 			if (!is_numeric($k)) {
507 507
 				$p = strpos($v, ' ');
508 508
 				if ($p) {
509
-					$v = substr($v, 0, $p) . " AS `$k`" . substr($v, $p);
509
+					$v = substr($v, 0, $p)." AS `$k`".substr($v, $p);
510 510
 				} else {
511 511
 					$v .= " AS `$k`";
512 512
 				}
513 513
 			}
514
-			$res .= ', ' . $v;
514
+			$res .= ', '.$v;
515 515
 		}
516 516
 	}
517 517
 
@@ -541,13 +541,13 @@  discard block
 block discarded – undo
541 541
 function _mysql_traite_query($query, $db = '', $prefixe = '', $echappe_textes = true) {
542 542
 
543 543
 	if ($GLOBALS['mysql_rappel_nom_base'] and $db) {
544
-		$pref = '`' . $db . '`.';
544
+		$pref = '`'.$db.'`.';
545 545
 	} else {
546 546
 		$pref = '';
547 547
 	}
548 548
 
549 549
 	if ($prefixe) {
550
-		$pref .= $prefixe . '_';
550
+		$pref .= $prefixe.'_';
551 551
 	}
552 552
 
553 553
 	if (!preg_match('/\s(SET|VALUES|WHERE|DATABASE)\s/i', $query, $regs)) {
@@ -566,7 +566,7 @@  discard block
 block discarded – undo
566 566
 				$suite_echap = $suite;
567 567
 			}
568 568
 			if (preg_match('/^(.*?)([(]\s*SELECT\b.*)$/si', $suite_echap, $r)) {
569
-				$suite_echap = $r[1] . _mysql_traite_query($r[2], $db, $prefixe, false);
569
+				$suite_echap = $r[1]._mysql_traite_query($r[2], $db, $prefixe, false);
570 570
 				if ($echappe_textes) {
571 571
 					$suite = query_reinjecte_textes($suite_echap, $textes);
572 572
 				}
@@ -576,7 +576,7 @@  discard block
 block discarded – undo
576 576
 			}
577 577
 		}
578 578
 	}
579
-	$r = preg_replace(_SQL_PREFIXE_TABLE_MYSQL, '\1' . $pref, $query) . $suite;
579
+	$r = preg_replace(_SQL_PREFIXE_TABLE_MYSQL, '\1'.$pref, $query).$suite;
580 580
 
581 581
 	// en option, remplacer les emoji (que mysql ne sait pas gérer) en &#128169;
582 582
 	// remplacer les emoji (que mysql ne sait pas gérer) en &#128169;
@@ -612,7 +612,7 @@  discard block
 block discarded – undo
612 612
 	$link = _mysql_link($serveur);
613 613
 	$ok = mysqli_select_db($link, $db);
614 614
 	if (!$ok) {
615
-		spip_log('Echec mysqli_selectdb. Erreur : ' . mysqli_error($link), 'mysql.' . _LOG_CRITIQUE);
615
+		spip_log('Echec mysqli_selectdb. Erreur : '.mysqli_error($link), 'mysql.'._LOG_CRITIQUE);
616 616
 	}
617 617
 
618 618
 	return $ok;
@@ -702,10 +702,10 @@  discard block
 block discarded – undo
702 702
 
703 703
 	$character_set = '';
704 704
 	if (@$GLOBALS['meta']['charset_sql_base']) {
705
-		$character_set .= ' CHARACTER SET ' . $GLOBALS['meta']['charset_sql_base'];
705
+		$character_set .= ' CHARACTER SET '.$GLOBALS['meta']['charset_sql_base'];
706 706
 	}
707 707
 	if (@$GLOBALS['meta']['charset_collation_sql_base']) {
708
-		$character_set .= ' COLLATE ' . $GLOBALS['meta']['charset_collation_sql_base'];
708
+		$character_set .= ' COLLATE '.$GLOBALS['meta']['charset_collation_sql_base'];
709 709
 	}
710 710
 
711 711
 	foreach ($champs as $k => $v) {
@@ -715,7 +715,7 @@  discard block
 block discarded – undo
715 715
 				preg_match(',(char|text),i', $defs[1])
716 716
 				and !preg_match(',(binary|CHARACTER|COLLATE),i', $v)
717 717
 			) {
718
-				$v = $defs[1] . $character_set . ' ' . substr($v, strlen($defs[1]));
718
+				$v = $defs[1].$character_set.' '.substr($v, strlen($defs[1]));
719 719
 			}
720 720
 		}
721 721
 
@@ -727,7 +727,7 @@  discard block
 block discarded – undo
727 727
 		$s = ',';
728 728
 	}
729 729
 	$temporary = $temporary ? 'TEMPORARY' : '';
730
-	$q = "CREATE $temporary TABLE IF NOT EXISTS $nom ($query" . ($keys ? ",$keys" : '') . ')'
730
+	$q = "CREATE $temporary TABLE IF NOT EXISTS $nom ($query".($keys ? ",$keys" : '').')'
731 731
 		. ' ENGINE=MyISAM'
732 732
 		. ($character_set ? " DEFAULT $character_set" : '')
733 733
 		. "\n";
@@ -807,7 +807,7 @@  discard block
 block discarded – undo
807 807
 		return false;
808 808
 	}
809 809
 
810
-	$query = "CREATE VIEW $nom AS " . $query_select;
810
+	$query = "CREATE VIEW $nom AS ".$query_select;
811 811
 
812 812
 	return spip_mysql_query($query, $serveur, $requeter);
813 813
 }
@@ -865,7 +865,7 @@  discard block
 block discarded – undo
865 865
  *     Ressource à utiliser avec sql_fetch()
866 866
  **/
867 867
 function spip_mysql_showbase($match, $serveur = '', $requeter = true) {
868
-	return spip_mysql_query('SHOW TABLES LIKE ' . _q($match), $serveur, $requeter);
868
+	return spip_mysql_query('SHOW TABLES LIKE '._q($match), $serveur, $requeter);
869 869
 }
870 870
 
871 871
 /**
@@ -899,7 +899,7 @@  discard block
 block discarded – undo
899 899
  *     - string : requete sql, si $requeter = true
900 900
  **/
901 901
 function spip_mysql_table_exists(string $table, $serveur = '', $requeter = true) {
902
-	$r = spip_mysql_query('SHOW TABLES LIKE ' . _q($table), $serveur, $requeter);
902
+	$r = spip_mysql_query('SHOW TABLES LIKE '._q($table), $serveur, $requeter);
903 903
 	if (!$requeter) {
904 904
 		return $r;
905 905
 	}
@@ -981,22 +981,22 @@  discard block
 block discarded – undo
981 981
 			}
982 982
 			if ($val['Default'] === '0' || $val['Default']) {
983 983
 				if (preg_match('/[A-Z_]/', $val['Default'])) {
984
-					$nfields[$val['Field']] .= ' DEFAULT ' . $val['Default'];
984
+					$nfields[$val['Field']] .= ' DEFAULT '.$val['Default'];
985 985
 				} else {
986
-					$nfields[$val['Field']] .= " DEFAULT '" . $val['Default'] . "'";
986
+					$nfields[$val['Field']] .= " DEFAULT '".$val['Default']."'";
987 987
 				}
988 988
 			}
989 989
 			if ($val['Extra']) {
990
-				$nfields[$val['Field']] .= ' ' . $val['Extra'];
990
+				$nfields[$val['Field']] .= ' '.$val['Extra'];
991 991
 			}
992 992
 			if ($val['Key'] == 'PRI') {
993 993
 				$nkeys['PRIMARY KEY'] = $val['Field'];
994 994
 			} else {
995 995
 				if ($val['Key'] == 'MUL') {
996
-					$nkeys['KEY ' . $val['Field']] = $val['Field'];
996
+					$nkeys['KEY '.$val['Field']] = $val['Field'];
997 997
 				} else {
998 998
 					if ($val['Key'] == 'UNI') {
999
-						$nkeys['UNIQUE KEY ' . $val['Field']] = $val['Field'];
999
+						$nkeys['UNIQUE KEY '.$val['Field']] = $val['Field'];
1000 1000
 					}
1001 1001
 				}
1002 1002
 			}
@@ -1067,7 +1067,7 @@  discard block
 block discarded – undo
1067 1067
 	$serveur = '',
1068 1068
 	$requeter = true
1069 1069
 ) {
1070
-	$c = !$groupby ? '*' : ('DISTINCT ' . (is_string($groupby) ? $groupby : join(',', $groupby)));
1070
+	$c = !$groupby ? '*' : ('DISTINCT '.(is_string($groupby) ? $groupby : join(',', $groupby)));
1071 1071
 
1072 1072
 	$r = spip_mysql_select("COUNT($c)", $from, $where, '', '', '', $having, $serveur, $requeter);
1073 1073
 	if (!$requeter) {
@@ -1107,7 +1107,7 @@  discard block
 block discarded – undo
1107 1107
 	if ($s) {
1108 1108
 		$trace = debug_backtrace();
1109 1109
 		if ($trace[0]['function'] != 'spip_mysql_error') {
1110
-			spip_log("$s - $query - " . sql_error_backtrace(), 'mysql.' . _LOG_ERREUR);
1110
+			spip_log("$s - $query - ".sql_error_backtrace(), 'mysql.'._LOG_ERREUR);
1111 1111
 		}
1112 1112
 	}
1113 1113
 
@@ -1233,7 +1233,7 @@  discard block
 block discarded – undo
1233 1233
 	try {
1234 1234
 		$insert = mysqli_query($link, $query);
1235 1235
 	} catch (\mysqli_sql_exception $e) {
1236
-		spip_log('mysqli_sql_exception: ' . $e->getMessage(), 'mysql.' . _LOG_DEBUG);
1236
+		spip_log('mysqli_sql_exception: '.$e->getMessage(), 'mysql.'._LOG_DEBUG);
1237 1237
 		// TODO: utiliser l’exception ensuite plutôt que les appels à spip_mysql_errno()
1238 1238
 		// mais il faut pour php < 8.1 forcer les exeptions via mysqli_report().
1239 1239
 	}
@@ -1288,8 +1288,8 @@  discard block
 block discarded – undo
1288 1288
 
1289 1289
 	return spip_mysql_insert(
1290 1290
 		$table,
1291
-		'(' . join(',', array_keys($couples)) . ')',
1292
-		'(' . join(',', $couples) . ')',
1291
+		'('.join(',', array_keys($couples)).')',
1292
+		'('.join(',', $couples).')',
1293 1293
 		$desc,
1294 1294
 		$serveur,
1295 1295
 		$requeter
@@ -1326,7 +1326,7 @@  discard block
 block discarded – undo
1326 1326
 	}
1327 1327
 	$fields = $desc['field'] ?? [];
1328 1328
 
1329
-	$cles = '(' . join(',', array_keys(reset($tab_couples))) . ')';
1329
+	$cles = '('.join(',', array_keys(reset($tab_couples))).')';
1330 1330
 	$valeurs = [];
1331 1331
 	$r = false;
1332 1332
 
@@ -1335,7 +1335,7 @@  discard block
 block discarded – undo
1335 1335
 		foreach ($couples as $champ => $val) {
1336 1336
 			$couples[$champ] = spip_mysql_cite($val, $fields[$champ]);
1337 1337
 		}
1338
-		$valeurs[] = '(' . join(',', $couples) . ')';
1338
+		$valeurs[] = '('.join(',', $couples).')';
1339 1339
 		if (count($valeurs) >= 100) {
1340 1340
 			$r = spip_mysql_insert($table, $cles, join(', ', $valeurs), $desc, $serveur, $requeter);
1341 1341
 			$valeurs = [];
@@ -1372,7 +1372,7 @@  discard block
 block discarded – undo
1372 1372
 function spip_mysql_update($table, $champs, $where = '', $desc = [], $serveur = '', $requeter = true) {
1373 1373
 	$set = [];
1374 1374
 	foreach ($champs as $champ => $val) {
1375
-		$set[] = $champ . "=$val";
1375
+		$set[] = $champ."=$val";
1376 1376
 	}
1377 1377
 	if (!empty($set)) {
1378 1378
 		return spip_mysql_query(
@@ -1428,7 +1428,7 @@  discard block
 block discarded – undo
1428 1428
 	}
1429 1429
 	$set = [];
1430 1430
 	foreach ($champs as $champ => $val) {
1431
-		$set[] = $champ . '=' . spip_mysql_cite($val, @$fields[$champ]);
1431
+		$set[] = $champ.'='.spip_mysql_cite($val, @$fields[$champ]);
1432 1432
 	}
1433 1433
 
1434 1434
 	return spip_mysql_query(
@@ -1497,10 +1497,10 @@  discard block
 block discarded – undo
1497 1497
  *     - False en cas d'erreur.
1498 1498
  **/
1499 1499
 function spip_mysql_replace($table, $couples, $desc = [], $serveur = '', $requeter = true) {
1500
-	return spip_mysql_query("REPLACE $table (" . join(',', array_keys($couples)) . ') VALUES (' . join(
1500
+	return spip_mysql_query("REPLACE $table (".join(',', array_keys($couples)).') VALUES ('.join(
1501 1501
 		',',
1502 1502
 		array_map('_q', $couples)
1503
-	) . ')', $serveur, $requeter);
1503
+	).')', $serveur, $requeter);
1504 1504
 }
1505 1505
 
1506 1506
 
@@ -1529,10 +1529,10 @@  discard block
 block discarded – undo
1529 1529
  *     - False en cas d'erreur.
1530 1530
  **/
1531 1531
 function spip_mysql_replace_multi($table, $tab_couples, $desc = [], $serveur = '', $requeter = true) {
1532
-	$cles = '(' . join(',', array_keys($tab_couples[0])) . ')';
1532
+	$cles = '('.join(',', array_keys($tab_couples[0])).')';
1533 1533
 	$valeurs = [];
1534 1534
 	foreach ($tab_couples as $couples) {
1535
-		$valeurs[] = '(' . join(',', array_map('_q', $couples)) . ')';
1535
+		$valeurs[] = '('.join(',', array_map('_q', $couples)).')';
1536 1536
 	}
1537 1537
 	$valeurs = implode(', ', $valeurs);
1538 1538
 
@@ -1552,28 +1552,28 @@  discard block
 block discarded – undo
1552 1552
  */
1553 1553
 function spip_mysql_multi($objet, $lang) {
1554 1554
 	$lengthlang = strlen("[$lang]");
1555
-	$posmulti = 'INSTR(' . $objet . ", '<multi>')";
1556
-	$posfinmulti = 'INSTR(' . $objet . ", '</multi>')";
1557
-	$debutchaine = 'LEFT(' . $objet . ", $posmulti-1)";
1558
-	$finchaine = 'RIGHT(' . $objet . ', CHAR_LENGTH(' . $objet . ") -(7+$posfinmulti))";
1559
-	$chainemulti = 'TRIM(SUBSTRING(' . $objet . ", $posmulti+7, $posfinmulti -(7+$posmulti)))";
1560
-	$poslang = "INSTR($chainemulti,'[" . $lang . "]')";
1555
+	$posmulti = 'INSTR('.$objet.", '<multi>')";
1556
+	$posfinmulti = 'INSTR('.$objet.", '</multi>')";
1557
+	$debutchaine = 'LEFT('.$objet.", $posmulti-1)";
1558
+	$finchaine = 'RIGHT('.$objet.', CHAR_LENGTH('.$objet.") -(7+$posfinmulti))";
1559
+	$chainemulti = 'TRIM(SUBSTRING('.$objet.", $posmulti+7, $posfinmulti -(7+$posmulti)))";
1560
+	$poslang = "INSTR($chainemulti,'[".$lang."]')";
1561 1561
 	$poslang = "IF($poslang=0,INSTR($chainemulti,']')+1,$poslang+$lengthlang)";
1562
-	$chainelang = 'TRIM(SUBSTRING(' . $objet . ", $posmulti+7+$poslang-1,$posfinmulti -($posmulti+7+$poslang-1) ))";
1563
-	$posfinlang = 'INSTR(' . $chainelang . ", '[')";
1562
+	$chainelang = 'TRIM(SUBSTRING('.$objet.", $posmulti+7+$poslang-1,$posfinmulti -($posmulti+7+$poslang-1) ))";
1563
+	$posfinlang = 'INSTR('.$chainelang.", '[')";
1564 1564
 	$chainelang = "IF($posfinlang>0,LEFT($chainelang,$posfinlang-1),$chainelang)";
1565 1565
 	//$chainelang = "LEFT($chainelang,$posfinlang-1)";
1566
-	$retour = "(TRIM(IF($posmulti = 0 , " .
1567
-		'     TRIM(' . $objet . '), ' .
1568
-		'     CONCAT( ' .
1569
-		"          $debutchaine, " .
1570
-		'          IF( ' .
1571
-		"               $poslang = 0, " .
1572
-		"                     $chainemulti, " .
1573
-		"               $chainelang" .
1574
-		'          ), ' .
1575
-		"          $finchaine" .
1576
-		'     ) ' .
1566
+	$retour = "(TRIM(IF($posmulti = 0 , ".
1567
+		'     TRIM('.$objet.'), '.
1568
+		'     CONCAT( '.
1569
+		"          $debutchaine, ".
1570
+		'          IF( '.
1571
+		"               $poslang = 0, ".
1572
+		"                     $chainemulti, ".
1573
+		"               $chainelang".
1574
+		'          ), '.
1575
+		"          $finchaine".
1576
+		'     ) '.
1577 1577
 		'))) AS multi';
1578 1578
 
1579 1579
 	return $retour;
@@ -1590,7 +1590,7 @@  discard block
 block discarded – undo
1590 1590
  *     Valeur hexadécimale pour MySQL
1591 1591
  **/
1592 1592
 function spip_mysql_hex($v) {
1593
-	return '0x' . $v;
1593
+	return '0x'.$v;
1594 1594
 }
1595 1595
 
1596 1596
 /**
@@ -1630,7 +1630,7 @@  discard block
 block discarded – undo
1630 1630
  *     Expression SQL
1631 1631
  **/
1632 1632
 function spip_mysql_date_proche($champ, $interval, $unite) {
1633
-	$use_now = ( ($champ === 'maj' or strpos($champ, '.maj')) ? true : false );
1633
+	$use_now = (($champ === 'maj' or strpos($champ, '.maj')) ? true : false);
1634 1634
 	return '('
1635 1635
 	. $champ
1636 1636
 	. (($interval <= 0) ? '>' : '<')
@@ -1685,7 +1685,7 @@  discard block
 block discarded – undo
1685 1685
 		} elseif ($v === null) {
1686 1686
 			return "''";
1687 1687
 		}
1688
-		return "'" . addslashes($v) . "'";
1688
+		return "'".addslashes($v)."'";
1689 1689
 	}
1690 1690
 
1691 1691
 	if ($v === null) {
@@ -1709,7 +1709,7 @@  discard block
 block discarded – undo
1709 1709
 		}
1710 1710
 	}
1711 1711
 
1712
-	return ("'" . addslashes($v) . "'");
1712
+	return ("'".addslashes($v)."'");
1713 1713
 }
1714 1714
 
1715 1715
 /**
@@ -1743,7 +1743,7 @@  discard block
 block discarded – undo
1743 1743
 	} else {
1744 1744
 		$GLOBALS['mysql_rappel_nom_base'] = false;
1745 1745
 
1746
-		return "\$GLOBALS['mysql_rappel_nom_base'] = false; " .
1746
+		return "\$GLOBALS['mysql_rappel_nom_base'] = false; ".
1747 1747
 		"/* echec de test_rappel_nom_base_mysql a l'installation. */\n";
1748 1748
 	}
1749 1749
 }
Please login to merge, or discard this patch.
ecrire/base/upgrade.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -56,7 +56,7 @@  discard block
 block discarded – undo
56 56
 	if ($GLOBALS['spip_version_base'] != $GLOBALS['meta']['version_installee']) {
57 57
 		if (!is_numeric(_request('reinstall'))) {
58 58
 			include_spip('base/create');
59
-			spip_log('recree les tables eventuellement disparues', 'maj.' . _LOG_INFO_IMPORTANTE);
59
+			spip_log('recree les tables eventuellement disparues', 'maj.'._LOG_INFO_IMPORTANTE);
60 60
 			creer_base();
61 61
 		}
62 62
 
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
 			exit;
70 70
 		}
71 71
 	}
72
-	spip_log('Fin de mise a jour SQL. Debut m-a-j acces et config', 'maj.' . _LOG_INFO_IMPORTANTE);
72
+	spip_log('Fin de mise a jour SQL. Debut m-a-j acces et config', 'maj.'._LOG_INFO_IMPORTANTE);
73 73
 
74 74
 	// supprimer quelques fichiers temporaires qui peuvent se retrouver invalides
75 75
 	@spip_unlink(_CACHE_RUBRIQUES);
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 	@spip_unlink(_CACHE_PLUGINS_OPT);
79 79
 	@spip_unlink(_CACHE_PLUGINS_FCT);
80 80
 	@spip_unlink(_CACHE_CHEMIN);
81
-	@spip_unlink(_DIR_TMP . 'plugin_xml_cache.gz');
81
+	@spip_unlink(_DIR_TMP.'plugin_xml_cache.gz');
82 82
 
83 83
 	include_spip('inc/auth');
84 84
 	auth_synchroniser_distant();
@@ -117,8 +117,8 @@  discard block
 block discarded – undo
117 117
 	$version_installee = $GLOBALS['meta']['version_installee'] ?? null;
118 118
 
119 119
 	spip_log(
120
-		"Version anterieure: $version_installee. Courante: " . $GLOBALS['spip_version_base'],
121
-		'maj.' . _LOG_INFO_IMPORTANTE
120
+		"Version anterieure: $version_installee. Courante: ".$GLOBALS['spip_version_base'],
121
+		'maj.'._LOG_INFO_IMPORTANTE
122 122
 	);
123 123
 	if (!$version_installee or ($GLOBALS['spip_version_base'] < $version_installee)) {
124 124
 		sql_replace(
@@ -151,9 +151,9 @@  discard block
 block discarded – undo
151 151
 	$res = maj_while($version_installee, $cible, $GLOBALS['maj'], 'version_installee', 'meta', $redirect, $debut_page);
152 152
 	if ($res) {
153 153
 		if (!is_array($res)) {
154
-			spip_log("Pb d'acces SQL a la mise a jour", 'maj.' . _LOG_ERREUR);
154
+			spip_log("Pb d'acces SQL a la mise a jour", 'maj.'._LOG_ERREUR);
155 155
 		} else {
156
-			echo _T('avis_operation_echec') . ' ' . join(' ', $res);
156
+			echo _T('avis_operation_echec').' '.join(' ', $res);
157 157
 			echo install_fin_html();
158 158
 		}
159 159
 	}
@@ -241,9 +241,9 @@  discard block
 block discarded – undo
241 241
 		$res = maj_while($current_version, $version_cible, $maj, $nom_meta_base_version, $table_meta, $redirect);
242 242
 		if ($res) {
243 243
 			if (!is_array($res)) {
244
-				spip_log("Pb d'acces SQL a la mise a jour", 'maj.' . _LOG_ERREUR);
244
+				spip_log("Pb d'acces SQL a la mise a jour", 'maj.'._LOG_ERREUR);
245 245
 			} else {
246
-				echo '<p>' . _T('avis_operation_echec') . ' ' . join(' ', $res) . '</p>';
246
+				echo '<p>'._T('avis_operation_echec').' '.join(' ', $res).'</p>';
247 247
 			}
248 248
 		}
249 249
 	}
@@ -299,7 +299,7 @@  discard block
 block discarded – undo
299 299
 	echo(install_debut_html($titre));
300 300
 	// script de rechargement auto sur timeout
301 301
 	$redirect = generer_url_ecrire('upgrade', "reinstall=$installee&meta=$meta&table=$table", true);
302
-	echo http_script("window.setTimeout('location.href=\"" . $redirect . "\";'," . ($timeout * 1000) . ')');
302
+	echo http_script("window.setTimeout('location.href=\"".$redirect."\";',".($timeout * 1000).')');
303 303
 	echo "<div style='text-align: left'>\n";
304 304
 	if (ob_get_level()) {
305 305
 		ob_flush();
@@ -388,7 +388,7 @@  discard block
 block discarded – undo
388 388
 				return [$v, $etape];
389 389
 			}
390 390
 			$n = time() - $time;
391
-			spip_log("$table $meta: $v en $n secondes", 'maj.' . _LOG_INFO_IMPORTANTE);
391
+			spip_log("$table $meta: $v en $n secondes", 'maj.'._LOG_INFO_IMPORTANTE);
392 392
 			if ($meta) {
393 393
 				ecrire_meta($meta, $installee = $v, 'oui', $table);
394 394
 			}
@@ -404,7 +404,7 @@  discard block
 block discarded – undo
404 404
 	if ($meta) {
405 405
 		ecrire_meta($meta, $cible, 'oui', $table);
406 406
 	}
407
-	spip_log("MAJ terminee. $meta: $installee", 'maj.' . _LOG_INFO_IMPORTANTE);
407
+	spip_log("MAJ terminee. $meta: $installee", 'maj.'._LOG_INFO_IMPORTANTE);
408 408
 
409 409
 	return [];
410 410
 }
@@ -429,7 +429,7 @@  discard block
 block discarded – undo
429 429
  * @return int
430 430
  */
431 431
 function serie_alter($serie, $q = [], $meta = '', $table = 'meta', $redirect = '') {
432
-	$meta2 = $meta . '_maj_' . $serie;
432
+	$meta2 = $meta.'_maj_'.$serie;
433 433
 	$etape = 0;
434 434
 	if (isset($GLOBALS[$table][$meta2])) {
435 435
 		$etape = intval($GLOBALS[$table][$meta2]);
@@ -442,7 +442,7 @@  discard block
 block discarded – undo
442 442
 				and function_exists($f = array_shift($r))
443 443
 			) {
444 444
 				// note: $r (arguments de la fonction $f) peut avoir des données tabulaires
445
-				spip_log("$msg: $f " . @join(',', $r), 'maj.' . _LOG_INFO_IMPORTANTE);
445
+				spip_log("$msg: $f ".@join(',', $r), 'maj.'._LOG_INFO_IMPORTANTE);
446 446
 				// pour les fonctions atomiques sql_xx
447 447
 				// on enregistre le meta avant de lancer la fonction,
448 448
 				// de maniere a eviter de boucler sur timeout
@@ -460,12 +460,12 @@  discard block
 block discarded – undo
460 460
 					relance_maj($meta, $table, $redirect);
461 461
 				}
462 462
 				ecrire_meta($meta2, $i + 1, 'non', $table);
463
-				spip_log("$meta2: ok", 'maj.' . _LOG_INFO_IMPORTANTE);
463
+				spip_log("$meta2: ok", 'maj.'._LOG_INFO_IMPORTANTE);
464 464
 			} else {
465 465
 				if (!is_array($r)) {
466
-					spip_log("maj $i format incorrect", 'maj.' . _LOG_ERREUR);
466
+					spip_log("maj $i format incorrect", 'maj.'._LOG_ERREUR);
467 467
 				} else {
468
-					spip_log("maj $i fonction $f non definie", 'maj.' . _LOG_ERREUR);
468
+					spip_log("maj $i fonction $f non definie", 'maj.'._LOG_ERREUR);
469 469
 				}
470 470
 				// en cas d'erreur serieuse, on s'arrete
471 471
 				// mais on permet de passer par dessus en rechargeant la page.
Please login to merge, or discard this patch.
ecrire/balise/menu_lang_ecrire.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -99,9 +99,9 @@  discard block
 block discarded – undo
99 99
 	include_spip('inc/lang');
100 100
 
101 101
 	if ($GLOBALS['spip_lang'] <> $default) {
102
-		$opt = lang_select($default);  # et remplace
102
+		$opt = lang_select($default); # et remplace
103 103
 		if ($GLOBALS['spip_lang'] <> $default) {
104
-			$default = '';  # annule tout choix par defaut
104
+			$default = ''; # annule tout choix par defaut
105 105
 			if ($opt) {
106 106
 				lang_select();
107 107
 			}
@@ -110,7 +110,7 @@  discard block
 block discarded – undo
110 110
 
111 111
 	# lien a partir de /
112 112
 	$cible = parametre_url(self(), 'lang', '', '&');
113
-	$post = generer_url_action('converser', 'redirect=' . rawurlencode($cible), true);
113
+	$post = generer_url_action('converser', 'redirect='.rawurlencode($cible), true);
114 114
 
115 115
 	return [
116 116
 		'formulaires/menu_lang',
Please login to merge, or discard this patch.