x-tools / xtools

src/AppBundle/Helper/EditCounterHelper.php

Indentation +9 added lines, -9 removed lines

@@ -390,15 +390,15 @@
         }
 
         $sql = "SELECT "
-           . "     SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6) AS `month`,"
-           . "     page_namespace,"
-           . "     COUNT(rev_id) AS `count` "
-           . " FROM ".$this->labsHelper->getTable('revision')
-           . "    JOIN " . $this->labsHelper->getTable('page')
-           . "    ON (rev_page = page_id)"
-           . " WHERE rev_user_text = :username"
-           . " GROUP BY SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6), page_namespace "
-           . " ORDER BY rev_timestamp DESC ";
+            . "     SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6) AS `month`,"
+            . "     page_namespace,"
+            . "     COUNT(rev_id) AS `count` "
+            . " FROM ".$this->labsHelper->getTable('revision')
+            . "    JOIN " . $this->labsHelper->getTable('page')
+            . "    ON (rev_page = page_id)"
+            . " WHERE rev_user_text = :username"
+            . " GROUP BY SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6), page_namespace "
+            . " ORDER BY rev_timestamp DESC ";
         $resultQuery = $this->replicas->prepare($sql);
         $resultQuery->bindParam(":username", $username);
         $resultQuery->execute();

src/AppBundle/Helper/AutomatedEditsHelper.php

Indentation +1 added lines, -1 removed lines

@@ -125,7 +125,7 @@
         /** @var LabsHelper $labsHelper */
         $labsHelper = $this->container->get('app.labs_helper');
         $sql = "SELECT rev_comment FROM ".$labsHelper->getTable('revision')
-               ." WHERE rev_user=:userId ORDER BY rev_timestamp DESC LIMIT 1000";
+                ." WHERE rev_user=:userId ORDER BY rev_timestamp DESC LIMIT 1000";
         $resultQuery = $replicas->prepare($sql);
         $resultQuery->bindParam("userId", $userId);
         $resultQuery->execute();