Completed
Push — master ( 1baec0...2c90e6 )
by cam
01:27
created
ecrire/req/mysql.php 1 patch
Spacing   +73 added lines, -73 removed lines patch added patch discarded remove patch
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
60 60
 	}
61 61
 
62 62
 	if (!$link) {
63
-		spip_log('Echec mysqli_connect. Erreur : ' . mysqli_connect_error(), 'mysql.' . _LOG_HS);
63
+		spip_log('Echec mysqli_connect. Erreur : '.mysqli_connect_error(), 'mysql.'._LOG_HS);
64 64
 
65 65
 		return false;
66 66
 	}
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
 	}
80 80
 
81 81
 	spip_log(
82
-		"Connexion MySQLi vers $host, base $db, prefixe $prefixe " . ($ok ? 'operationnelle' : 'impossible'),
82
+		"Connexion MySQLi vers $host, base $db, prefixe $prefixe ".($ok ? 'operationnelle' : 'impossible'),
83 83
 		_LOG_DEBUG
84 84
 	);
85 85
 
@@ -169,9 +169,9 @@  discard block
 block discarded – undo
169 169
  */
170 170
 function spip_mysql_set_charset($charset, $serveur = '', $requeter = true) {
171 171
 	$connexion = &$GLOBALS['connexions'][$serveur ? strtolower($serveur) : 0];
172
-	spip_log('changement de charset sql : ' . 'SET NAMES ' . _q($charset), _LOG_DEBUG);
172
+	spip_log('changement de charset sql : '.'SET NAMES '._q($charset), _LOG_DEBUG);
173 173
 
174
-	return mysqli_query($connexion['link'], $connexion['last'] = 'SET NAMES ' . _q($charset));
174
+	return mysqli_query($connexion['link'], $connexion['last'] = 'SET NAMES '._q($charset));
175 175
 }
176 176
 
177 177
 
@@ -186,7 +186,7 @@  discard block
 block discarded – undo
186 186
 function spip_mysql_get_charset($charset = [], $serveur = '', $requeter = true) {
187 187
 	$connexion = &$GLOBALS['connexions'][$serveur ? strtolower($serveur) : 0];
188 188
 	$connexion['last'] = $c = 'SHOW CHARACTER SET'
189
-		. (!$charset ? '' : (' LIKE ' . _q($charset['charset'])));
189
+		. (!$charset ? '' : (' LIKE '._q($charset['charset'])));
190 190
 
191 191
 	return spip_mysql_fetch(mysqli_query($connexion['link'], $c), null, $serveur);
192 192
 }
@@ -230,19 +230,19 @@  discard block
 block discarded – undo
230 230
 	$debug = '';
231 231
 	if (defined('_DEBUG_SLOW_QUERIES') and _DEBUG_SLOW_QUERIES) {
232 232
 		if (isset($GLOBALS['debug']['aucasou'])) {
233
-			list(, $id, , $infos) = $GLOBALS['debug']['aucasou'];
234
-			$debug .= "BOUCLE$id @ " . (isset($infos[0]) ? $infos[0] : '') . ' | ';
233
+			list(, $id,, $infos) = $GLOBALS['debug']['aucasou'];
234
+			$debug .= "BOUCLE$id @ ".(isset($infos[0]) ? $infos[0] : '').' | ';
235 235
 		}
236 236
 		if (isset($_SERVER['REQUEST_URI'])) {
237 237
 			$debug .= $_SERVER['REQUEST_URI'];
238 238
 		}
239 239
 		if (!empty($GLOBALS['ip'])) {
240
-			$debug .= ' + ' . $GLOBALS['ip'];
240
+			$debug .= ' + '.$GLOBALS['ip'];
241 241
 		}
242
-		$debug = ' /* ' . mysqli_real_escape_string($link, str_replace('*/', '@/', $debug)) . ' */';
242
+		$debug = ' /* '.mysqli_real_escape_string($link, str_replace('*/', '@/', $debug)).' */';
243 243
 	}
244 244
 
245
-	$r = mysqli_query($link, $query . $debug);
245
+	$r = mysqli_query($link, $query.$debug);
246 246
 
247 247
 	//Eviter de propager le GoneAway sur les autres requetes d'un même processus PHP
248 248
 	if ($e = spip_mysql_errno($serveur)) {  // Log d'un Gone Away
@@ -255,7 +255,7 @@  discard block
 block discarded – undo
255 255
 			$connexion = &$GLOBALS['connexions'][$serveur ? strtolower($serveur) : 0];
256 256
 			$link = $connexion['link'];
257 257
 			//On retente au cas où
258
-			$r = mysqli_query($link, $query . $debug);
258
+			$r = mysqli_query($link, $query.$debug);
259 259
 		}
260 260
 	}
261 261
 
@@ -283,7 +283,7 @@  discard block
 block discarded – undo
283 283
 	// d'utiliser ceux-ci, copie-colle de phpmyadmin
284 284
 	$query = preg_replace(',^TABLE\s*`([^`]*)`,i', "TABLE \\1", $query);
285 285
 
286
-	return spip_mysql_query('ALTER ' . $query, $serveur, $requeter); # i.e. que PG se debrouille
286
+	return spip_mysql_query('ALTER '.$query, $serveur, $requeter); # i.e. que PG se debrouille
287 287
 }
288 288
 
289 289
 
@@ -296,7 +296,7 @@  discard block
 block discarded – undo
296 296
  * @return bool            Toujours true
297 297
  */
298 298
 function spip_mysql_optimize($table, $serveur = '', $requeter = true) {
299
-	spip_mysql_query('OPTIMIZE TABLE ' . $table);
299
+	spip_mysql_query('OPTIMIZE TABLE '.$table);
300 300
 
301 301
 	return true;
302 302
 }
@@ -319,7 +319,7 @@  discard block
 block discarded – undo
319 319
 	$link = $connexion['link'];
320 320
 	$db = $connexion['db'];
321 321
 
322
-	$query = 'EXPLAIN ' . _mysql_traite_query($query, $db, $prefixe);
322
+	$query = 'EXPLAIN '._mysql_traite_query($query, $db, $prefixe);
323 323
 	$r = mysqli_query($link, $query);
324 324
 
325 325
 	return spip_mysql_fetch($r, null, $serveur);
@@ -370,7 +370,7 @@  discard block
 block discarded – undo
370 370
 		. calculer_mysql_expression('WHERE', $where)
371 371
 		. calculer_mysql_expression('GROUP BY', $groupby, ',')
372 372
 		. calculer_mysql_expression('HAVING', $having)
373
-		. ($orderby ? ("\nORDER BY " . spip_mysql_order($orderby)) : '')
373
+		. ($orderby ? ("\nORDER BY ".spip_mysql_order($orderby)) : '')
374 374
 		. ($limit ? "\nLIMIT $limit" : '');
375 375
 
376 376
 	// renvoyer la requete inerte si demandee
@@ -460,12 +460,12 @@  discard block
 block discarded – undo
460 460
 	$exp = "\n$expression ";
461 461
 
462 462
 	if (!is_array($v)) {
463
-		return $exp . $v;
463
+		return $exp.$v;
464 464
 	} else {
465 465
 		if (strtoupper($join) === 'AND') {
466
-			return $exp . join("\n\t$join ", array_map('calculer_mysql_where', $v));
466
+			return $exp.join("\n\t$join ", array_map('calculer_mysql_where', $v));
467 467
 		} else {
468
-			return $exp . join($join, $v);
468
+			return $exp.join($join, $v);
469 469
 		}
470 470
 	}
471 471
 }
@@ -483,17 +483,17 @@  discard block
 block discarded – undo
483 483
 		if (substr($k, -1) == '@') {
484 484
 			// c'est une jointure qui se refere au from precedent
485 485
 			// pas de virgule
486
-			$res .= '  ' . $v;
486
+			$res .= '  '.$v;
487 487
 		} else {
488 488
 			if (!is_numeric($k)) {
489 489
 				$p = strpos($v, ' ');
490 490
 				if ($p) {
491
-					$v = substr($v, 0, $p) . " AS `$k`" . substr($v, $p);
491
+					$v = substr($v, 0, $p)." AS `$k`".substr($v, $p);
492 492
 				} else {
493 493
 					$v .= " AS `$k`";
494 494
 				}
495 495
 			}
496
-			$res .= ', ' . $v;
496
+			$res .= ', '.$v;
497 497
 		}
498 498
 	}
499 499
 
@@ -522,13 +522,13 @@  discard block
 block discarded – undo
522 522
 function _mysql_traite_query($query, $db = '', $prefixe = '') {
523 523
 
524 524
 	if ($GLOBALS['mysql_rappel_nom_base'] and $db) {
525
-		$pref = '`' . $db . '`.';
525
+		$pref = '`'.$db.'`.';
526 526
 	} else {
527 527
 		$pref = '';
528 528
 	}
529 529
 
530 530
 	if ($prefixe) {
531
-		$pref .= $prefixe . '_';
531
+		$pref .= $prefixe.'_';
532 532
 	}
533 533
 
534 534
 	if (!preg_match('/\s(SET|VALUES|WHERE|DATABASE)\s/i', $query, $regs)) {
@@ -542,12 +542,12 @@  discard block
 block discarded – undo
542 542
 		if (stripos($suite, 'SELECT') !== false) {
543 543
 			list($suite_echap, $textes) = query_echappe_textes($suite);
544 544
 			if (preg_match('/^(.*?)([(]\s*SELECT\b.*)$/si', $suite_echap, $r)) {
545
-				$suite_echap = $r[1] . _mysql_traite_query($r[2], $db, $prefixe);
545
+				$suite_echap = $r[1]._mysql_traite_query($r[2], $db, $prefixe);
546 546
 				$suite = query_reinjecte_textes($suite_echap, $textes);
547 547
 			}
548 548
 		}
549 549
 	}
550
-	$r = preg_replace(_SQL_PREFIXE_TABLE_MYSQL, '\1' . $pref, $query) . $suite;
550
+	$r = preg_replace(_SQL_PREFIXE_TABLE_MYSQL, '\1'.$pref, $query).$suite;
551 551
 
552 552
 	// en option, remplacer les emoji (que mysql ne sait pas gérer) en 💩
553 553
 	// remplacer les emoji (que mysql ne sait pas gérer) en 💩
@@ -583,7 +583,7 @@  discard block
 block discarded – undo
583 583
 	$link = _mysql_link($serveur);
584 584
 	$ok = mysqli_select_db($link, $db);
585 585
 	if (!$ok) {
586
-		spip_log('Echec mysqli_selectdb. Erreur : ' . mysqli_error($link), 'mysql.' . _LOG_CRITIQUE);
586
+		spip_log('Echec mysqli_selectdb. Erreur : '.mysqli_error($link), 'mysql.'._LOG_CRITIQUE);
587 587
 	}
588 588
 
589 589
 	return $ok;
@@ -673,10 +673,10 @@  discard block
 block discarded – undo
673 673
 
674 674
 	$character_set = '';
675 675
 	if (@$GLOBALS['meta']['charset_sql_base']) {
676
-		$character_set .= ' CHARACTER SET ' . $GLOBALS['meta']['charset_sql_base'];
676
+		$character_set .= ' CHARACTER SET '.$GLOBALS['meta']['charset_sql_base'];
677 677
 	}
678 678
 	if (@$GLOBALS['meta']['charset_collation_sql_base']) {
679
-		$character_set .= ' COLLATE ' . $GLOBALS['meta']['charset_collation_sql_base'];
679
+		$character_set .= ' COLLATE '.$GLOBALS['meta']['charset_collation_sql_base'];
680 680
 	}
681 681
 
682 682
 	foreach ($champs as $k => $v) {
@@ -686,7 +686,7 @@  discard block
 block discarded – undo
686 686
 				preg_match(',(char|text),i', $defs[1])
687 687
 				and !preg_match(',(binary|CHARACTER|COLLATE),i', $v)
688 688
 			) {
689
-				$v = $defs[1] . $character_set . ' ' . substr($v, strlen($defs[1]));
689
+				$v = $defs[1].$character_set.' '.substr($v, strlen($defs[1]));
690 690
 			}
691 691
 		}
692 692
 
@@ -698,7 +698,7 @@  discard block
 block discarded – undo
698 698
 		$s = ',';
699 699
 	}
700 700
 	$temporary = $temporary ? 'TEMPORARY' : '';
701
-	$q = "CREATE $temporary TABLE IF NOT EXISTS $nom ($query" . ($keys ? ",$keys" : '') . ')'
701
+	$q = "CREATE $temporary TABLE IF NOT EXISTS $nom ($query".($keys ? ",$keys" : '').')'
702 702
 		. ' ENGINE=MyISAM'
703 703
 		. ($character_set ? " DEFAULT $character_set" : '')
704 704
 		. "\n";
@@ -778,7 +778,7 @@  discard block
 block discarded – undo
778 778
 		return false;
779 779
 	}
780 780
 
781
-	$query = "CREATE VIEW $nom AS " . $query_select;
781
+	$query = "CREATE VIEW $nom AS ".$query_select;
782 782
 
783 783
 	return spip_mysql_query($query, $serveur, $requeter);
784 784
 }
@@ -836,7 +836,7 @@  discard block
 block discarded – undo
836 836
  *     Ressource à utiliser avec sql_fetch()
837 837
  **/
838 838
 function spip_mysql_showbase($match, $serveur = '', $requeter = true) {
839
-	return spip_mysql_query('SHOW TABLES LIKE ' . _q($match), $serveur, $requeter);
839
+	return spip_mysql_query('SHOW TABLES LIKE '._q($match), $serveur, $requeter);
840 840
 }
841 841
 
842 842
 /**
@@ -930,22 +930,22 @@  discard block
 block discarded – undo
930 930
 			}
931 931
 			if ($val['Default'] === '0' || $val['Default']) {
932 932
 				if (preg_match('/[A-Z_]/', $val['Default'])) {
933
-					$nfields[$val['Field']] .= ' DEFAULT ' . $val['Default'];
933
+					$nfields[$val['Field']] .= ' DEFAULT '.$val['Default'];
934 934
 				} else {
935
-					$nfields[$val['Field']] .= " DEFAULT '" . $val['Default'] . "'";
935
+					$nfields[$val['Field']] .= " DEFAULT '".$val['Default']."'";
936 936
 				}
937 937
 			}
938 938
 			if ($val['Extra']) {
939
-				$nfields[$val['Field']] .= ' ' . $val['Extra'];
939
+				$nfields[$val['Field']] .= ' '.$val['Extra'];
940 940
 			}
941 941
 			if ($val['Key'] == 'PRI') {
942 942
 				$nkeys['PRIMARY KEY'] = $val['Field'];
943 943
 			} else {
944 944
 				if ($val['Key'] == 'MUL') {
945
-					$nkeys['KEY ' . $val['Field']] = $val['Field'];
945
+					$nkeys['KEY '.$val['Field']] = $val['Field'];
946 946
 				} else {
947 947
 					if ($val['Key'] == 'UNI') {
948
-						$nkeys['UNIQUE KEY ' . $val['Field']] = $val['Field'];
948
+						$nkeys['UNIQUE KEY '.$val['Field']] = $val['Field'];
949 949
 					}
950 950
 				}
951 951
 			}
@@ -1016,7 +1016,7 @@  discard block
 block discarded – undo
1016 1016
 	$serveur = '',
1017 1017
 	$requeter = true
1018 1018
 ) {
1019
-	$c = !$groupby ? '*' : ('DISTINCT ' . (is_string($groupby) ? $groupby : join(',', $groupby)));
1019
+	$c = !$groupby ? '*' : ('DISTINCT '.(is_string($groupby) ? $groupby : join(',', $groupby)));
1020 1020
 
1021 1021
 	$r = spip_mysql_select("COUNT($c)", $from, $where, '', '', '', $having, $serveur, $requeter);
1022 1022
 	if (!$requeter) {
@@ -1056,7 +1056,7 @@  discard block
 block discarded – undo
1056 1056
 	if ($s) {
1057 1057
 		$trace = debug_backtrace();
1058 1058
 		if ($trace[0]['function'] != 'spip_mysql_error') {
1059
-			spip_log("$s - $query - " . sql_error_backtrace(), 'mysql.' . _LOG_ERREUR);
1059
+			spip_log("$s - $query - ".sql_error_backtrace(), 'mysql.'._LOG_ERREUR);
1060 1060
 		}
1061 1061
 	}
1062 1062
 
@@ -1227,8 +1227,8 @@  discard block
 block discarded – undo
1227 1227
 
1228 1228
 	return spip_mysql_insert(
1229 1229
 		$table,
1230
-		'(' . join(',', array_keys($couples)) . ')',
1231
-		'(' . join(',', $couples) . ')',
1230
+		'('.join(',', array_keys($couples)).')',
1231
+		'('.join(',', $couples).')',
1232 1232
 		$desc,
1233 1233
 		$serveur,
1234 1234
 		$requeter
@@ -1265,7 +1265,7 @@  discard block
 block discarded – undo
1265 1265
 	}
1266 1266
 	$fields = isset($desc['field']) ? $desc['field'] : [];
1267 1267
 
1268
-	$cles = '(' . join(',', array_keys(reset($tab_couples))) . ')';
1268
+	$cles = '('.join(',', array_keys(reset($tab_couples))).')';
1269 1269
 	$valeurs = [];
1270 1270
 	$r = false;
1271 1271
 
@@ -1274,7 +1274,7 @@  discard block
 block discarded – undo
1274 1274
 		foreach ($couples as $champ => $val) {
1275 1275
 			$couples[$champ] = spip_mysql_cite($val, $fields[$champ]);
1276 1276
 		}
1277
-		$valeurs[] = '(' . join(',', $couples) . ')';
1277
+		$valeurs[] = '('.join(',', $couples).')';
1278 1278
 		if (count($valeurs) >= 100) {
1279 1279
 			$r = spip_mysql_insert($table, $cles, join(', ', $valeurs), $desc, $serveur, $requeter);
1280 1280
 			$valeurs = [];
@@ -1311,7 +1311,7 @@  discard block
 block discarded – undo
1311 1311
 function spip_mysql_update($table, $champs, $where = '', $desc = [], $serveur = '', $requeter = true) {
1312 1312
 	$set = [];
1313 1313
 	foreach ($champs as $champ => $val) {
1314
-		$set[] = $champ . "=$val";
1314
+		$set[] = $champ."=$val";
1315 1315
 	}
1316 1316
 	if (!empty($set)) {
1317 1317
 		return spip_mysql_query(
@@ -1367,7 +1367,7 @@  discard block
 block discarded – undo
1367 1367
 	}
1368 1368
 	$set = [];
1369 1369
 	foreach ($champs as $champ => $val) {
1370
-		$set[] = $champ . '=' . spip_mysql_cite($val, @$fields[$champ]);
1370
+		$set[] = $champ.'='.spip_mysql_cite($val, @$fields[$champ]);
1371 1371
 	}
1372 1372
 
1373 1373
 	return spip_mysql_query(
@@ -1436,10 +1436,10 @@  discard block
 block discarded – undo
1436 1436
  *     - False en cas d'erreur.
1437 1437
  **/
1438 1438
 function spip_mysql_replace($table, $couples, $desc = [], $serveur = '', $requeter = true) {
1439
-	return spip_mysql_query("REPLACE $table (" . join(',', array_keys($couples)) . ') VALUES (' . join(
1439
+	return spip_mysql_query("REPLACE $table (".join(',', array_keys($couples)).') VALUES ('.join(
1440 1440
 		',',
1441 1441
 		array_map('_q', $couples)
1442
-	) . ')', $serveur, $requeter);
1442
+	).')', $serveur, $requeter);
1443 1443
 }
1444 1444
 
1445 1445
 
@@ -1468,10 +1468,10 @@  discard block
 block discarded – undo
1468 1468
  *     - False en cas d'erreur.
1469 1469
  **/
1470 1470
 function spip_mysql_replace_multi($table, $tab_couples, $desc = [], $serveur = '', $requeter = true) {
1471
-	$cles = '(' . join(',', array_keys($tab_couples[0])) . ')';
1471
+	$cles = '('.join(',', array_keys($tab_couples[0])).')';
1472 1472
 	$valeurs = [];
1473 1473
 	foreach ($tab_couples as $couples) {
1474
-		$valeurs[] = '(' . join(',', array_map('_q', $couples)) . ')';
1474
+		$valeurs[] = '('.join(',', array_map('_q', $couples)).')';
1475 1475
 	}
1476 1476
 	$valeurs = implode(', ', $valeurs);
1477 1477
 
@@ -1491,28 +1491,28 @@  discard block
 block discarded – undo
1491 1491
  */
1492 1492
 function spip_mysql_multi($objet, $lang) {
1493 1493
 	$lengthlang = strlen("[$lang]");
1494
-	$posmulti = 'INSTR(' . $objet . ", '<multi>')";
1495
-	$posfinmulti = 'INSTR(' . $objet . ", '</multi>')";
1496
-	$debutchaine = 'LEFT(' . $objet . ", $posmulti-1)";
1497
-	$finchaine = 'RIGHT(' . $objet . ', CHAR_LENGTH(' . $objet . ") -(7+$posfinmulti))";
1498
-	$chainemulti = 'TRIM(SUBSTRING(' . $objet . ", $posmulti+7, $posfinmulti -(7+$posmulti)))";
1499
-	$poslang = "INSTR($chainemulti,'[" . $lang . "]')";
1494
+	$posmulti = 'INSTR('.$objet.", '<multi>')";
1495
+	$posfinmulti = 'INSTR('.$objet.", '</multi>')";
1496
+	$debutchaine = 'LEFT('.$objet.", $posmulti-1)";
1497
+	$finchaine = 'RIGHT('.$objet.', CHAR_LENGTH('.$objet.") -(7+$posfinmulti))";
1498
+	$chainemulti = 'TRIM(SUBSTRING('.$objet.", $posmulti+7, $posfinmulti -(7+$posmulti)))";
1499
+	$poslang = "INSTR($chainemulti,'[".$lang."]')";
1500 1500
 	$poslang = "IF($poslang=0,INSTR($chainemulti,']')+1,$poslang+$lengthlang)";
1501
-	$chainelang = 'TRIM(SUBSTRING(' . $objet . ", $posmulti+7+$poslang-1,$posfinmulti -($posmulti+7+$poslang-1) ))";
1502
-	$posfinlang = 'INSTR(' . $chainelang . ", '[')";
1501
+	$chainelang = 'TRIM(SUBSTRING('.$objet.", $posmulti+7+$poslang-1,$posfinmulti -($posmulti+7+$poslang-1) ))";
1502
+	$posfinlang = 'INSTR('.$chainelang.", '[')";
1503 1503
 	$chainelang = "IF($posfinlang>0,LEFT($chainelang,$posfinlang-1),$chainelang)";
1504 1504
 	//$chainelang = "LEFT($chainelang,$posfinlang-1)";
1505
-	$retour = "(TRIM(IF($posmulti = 0 , " .
1506
-		'     TRIM(' . $objet . '), ' .
1507
-		'     CONCAT( ' .
1508
-		"          $debutchaine, " .
1509
-		'          IF( ' .
1510
-		"               $poslang = 0, " .
1511
-		"                     $chainemulti, " .
1512
-		"               $chainelang" .
1513
-		'          ), ' .
1514
-		"          $finchaine" .
1515
-		'     ) ' .
1505
+	$retour = "(TRIM(IF($posmulti = 0 , ".
1506
+		'     TRIM('.$objet.'), '.
1507
+		'     CONCAT( '.
1508
+		"          $debutchaine, ".
1509
+		'          IF( '.
1510
+		"               $poslang = 0, ".
1511
+		"                     $chainemulti, ".
1512
+		"               $chainelang".
1513
+		'          ), '.
1514
+		"          $finchaine".
1515
+		'     ) '.
1516 1516
 		'))) AS multi';
1517 1517
 
1518 1518
 	return $retour;
@@ -1529,7 +1529,7 @@  discard block
 block discarded – undo
1529 1529
  *     Valeur hexadécimale pour MySQL
1530 1530
  **/
1531 1531
 function spip_mysql_hex($v) {
1532
-	return '0x' . $v;
1532
+	return '0x'.$v;
1533 1533
 }
1534 1534
 
1535 1535
 /**
@@ -1569,7 +1569,7 @@  discard block
 block discarded – undo
1569 1569
  *     Expression SQL
1570 1570
  **/
1571 1571
 function spip_mysql_date_proche($champ, $interval, $unite) {
1572
-	$use_now = ( ($champ === 'maj' or strpos($champ, '.maj')) ? true : false );
1572
+	$use_now = (($champ === 'maj' or strpos($champ, '.maj')) ? true : false);
1573 1573
 	return '('
1574 1574
 	. $champ
1575 1575
 	. (($interval <= 0) ? '>' : '<')
@@ -1623,7 +1623,7 @@  discard block
 block discarded – undo
1623 1623
 		elseif (is_numeric($v)) {
1624 1624
 			return strval($v);
1625 1625
 		}
1626
-		return "'" . addslashes($v) . "'";
1626
+		return "'".addslashes($v)."'";
1627 1627
 	}
1628 1628
 
1629 1629
 	if (
@@ -1647,7 +1647,7 @@  discard block
 block discarded – undo
1647 1647
 		}
1648 1648
 	}
1649 1649
 
1650
-	return ("'" . addslashes($v) . "'");
1650
+	return ("'".addslashes($v)."'");
1651 1651
 }
1652 1652
 
1653 1653
 /**
@@ -1681,7 +1681,7 @@  discard block
 block discarded – undo
1681 1681
 	} else {
1682 1682
 		$GLOBALS['mysql_rappel_nom_base'] = false;
1683 1683
 
1684
-		return "\$GLOBALS['mysql_rappel_nom_base'] = false; " .
1684
+		return "\$GLOBALS['mysql_rappel_nom_base'] = false; ".
1685 1685
 		"/* echec de test_rappel_nom_base_mysql a l'installation. */\n";
1686 1686
 	}
1687 1687
 }
Please login to merge, or discard this patch.
ecrire/base/connect_sql.php 1 patch
Spacing   +12 added lines, -13 removed lines patch added patch discarded remove patch
@@ -18,7 +18,7 @@  discard block
 block discarded – undo
18 18
 if (!defined('_ECRIRE_INC_VERSION')) {
19 19
 	return;
20 20
 }
21
-require_once _ROOT_RESTREINT . 'base/objets.php';
21
+require_once _ROOT_RESTREINT.'base/objets.php';
22 22
 
23 23
 
24 24
 /**
@@ -59,7 +59,7 @@  discard block
 block discarded – undo
59 59
 		$f = (!preg_match('/^[\w\.]*$/', $serveur))
60 60
 			? '' // nom de serveur mal ecrit
61 61
 			: ($serveur ?
62
-				(_DIR_CONNECT . $serveur . '.php') // serveur externe
62
+				(_DIR_CONNECT.$serveur.'.php') // serveur externe
63 63
 				: (_FILE_CONNECT ? _FILE_CONNECT // serveur principal ok
64 64
 					: ($install ? _FILE_CONNECT_TMP // init du serveur principal
65 65
 						: ''))); // installation pas faite
@@ -102,9 +102,9 @@  discard block
 block discarded – undo
102 102
 	// chargement de la version du jeu de fonctions
103 103
 	// si pas dans le fichier par defaut
104 104
 	$type = $GLOBALS['db_ok']['type'];
105
-	$jeu = 'spip_' . $type . '_functions_' . $version;
105
+	$jeu = 'spip_'.$type.'_functions_'.$version;
106 106
 	if (!isset($GLOBALS[$jeu])) {
107
-		if (!find_in_path($type . '_' . $version . '.php', 'req/', true)) {
107
+		if (!find_in_path($type.'_'.$version.'.php', 'req/', true)) {
108 108
 			spip_log("spip_connect: serveur $index version '$version' non defini pour '$type'", _LOG_HS);
109 109
 
110 110
 			// ne plus reessayer
@@ -166,9 +166,9 @@  discard block
 block discarded – undo
166 166
 	$connexion = spip_connect($serveur);
167 167
 	$e = sql_errno($serveur);
168 168
 	$t = (isset($connexion['type']) ? $connexion['type'] : 'sql');
169
-	$m = "Erreur $e de $t: " . sql_error($serveur) . "\nin " . sql_error_backtrace() . "\n" . trim($connexion['last']);
170
-	$f = $t . $serveur;
171
-	spip_log($m, $f . '.' . _LOG_ERREUR);
169
+	$m = "Erreur $e de $t: ".sql_error($serveur)."\nin ".sql_error_backtrace()."\n".trim($connexion['last']);
170
+	$f = $t.$serveur;
171
+	spip_log($m, $f.'.'._LOG_ERREUR);
172 172
 }
173 173
 
174 174
 /**
@@ -250,7 +250,7 @@  discard block
 block discarded – undo
250 250
 	// si en cours d'installation ou si db=@test@ on ne pose rien
251 251
 	// car c'est un test de connexion
252 252
 	if (!defined('_ECRIRE_INSTALL') and $db !== '@test@') {
253
-		$f = _DIR_TMP . $type . '.' . substr(md5($host . $port . $db), 0, 8) . '.out';
253
+		$f = _DIR_TMP.$type.'.'.substr(md5($host.$port.$db), 0, 8).'.out';
254 254
 	} elseif ($db == '@test@') {
255 255
 		$db = '';
256 256
 	}
@@ -290,7 +290,7 @@  discard block
 block discarded – undo
290 290
 	// En cas d'indisponibilite du serveur, eviter de le bombarder
291 291
 	if ($f) {
292 292
 		@touch($f);
293
-		spip_log("Echec connexion serveur $type : host[$host] port[$port] login[$login] base[$db]", $type . '.' . _LOG_HS);
293
+		spip_log("Echec connexion serveur $type : host[$host] port[$port] login[$login] base[$db]", $type.'.'._LOG_HS);
294 294
 	}
295 295
 }
296 296
 
@@ -382,8 +382,7 @@  discard block
 block discarded – undo
382 382
  * @return string Valeur échappée.
383 383
  **/
384 384
 function _q($a) {
385
-	return (is_numeric($a)) ? strval($a) :
386
-		(!is_array($a) ? ("'" . addslashes($a) . "'")
385
+	return (is_numeric($a)) ? strval($a) : (!is_array($a) ? ("'".addslashes($a)."'")
387 386
 			: join(',', array_map('_q', $a)));
388 387
 }
389 388
 
@@ -399,7 +398,7 @@  discard block
 block discarded – undo
399 398
  * @param string $query
400 399
  * @return array
401 400
  */
402
-function query_echappe_textes($query, $uniqid=null) {
401
+function query_echappe_textes($query, $uniqid = null) {
403 402
 	static $codeEchappements = null;
404 403
 	if (is_null($codeEchappements) or $uniqid) {
405 404
 		if (is_null($uniqid)) {
@@ -444,7 +443,7 @@  discard block
 block discarded – undo
444 443
 				break;
445 444
 			default:
446 445
 				$replace = range(1, count($textes));
447
-				$replace = '%' . implode('$s,%', $replace) . '$s';
446
+				$replace = '%'.implode('$s,%', $replace).'$s';
448 447
 				$replace = explode(',', $replace);
449 448
 				break;
450 449
 		}
Please login to merge, or discard this patch.