@@ -60,7 +60,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 | } |
@@ -18,7 +18,7 @@ discard block |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 |
||
| 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 | } |