@@ -164,7 +164,7 @@ |
||
164 | 164 | private function getRevCount() |
165 | 165 | { |
166 | 166 | $query = "SELECT COUNT(*) AS count FROM " . $this->revisionTable |
167 | - . " WHERE rev_page = '" . $this->pageInfo['id'] . "'"; |
|
167 | + . " WHERE rev_page = '" . $this->pageInfo['id'] . "'"; |
|
168 | 168 | $res = $this->conn->query($query)->fetchAll(); |
169 | 169 | return $res[0]['count']; |
170 | 170 | } |
@@ -390,15 +390,15 @@ |
||
390 | 390 | } |
391 | 391 | |
392 | 392 | $sql = "SELECT " |
393 | - . " SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6) AS `month`," |
|
394 | - . " page_namespace," |
|
395 | - . " COUNT(rev_id) AS `count` " |
|
396 | - . " FROM ".$this->labsHelper->getTable('revision') |
|
397 | - . " JOIN " . $this->labsHelper->getTable('page') |
|
398 | - . " ON (rev_page = page_id)" |
|
399 | - . " WHERE rev_user_text = :username" |
|
400 | - . " GROUP BY SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6), page_namespace " |
|
401 | - . " ORDER BY rev_timestamp DESC "; |
|
393 | + . " SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6) AS `month`," |
|
394 | + . " page_namespace," |
|
395 | + . " COUNT(rev_id) AS `count` " |
|
396 | + . " FROM ".$this->labsHelper->getTable('revision') |
|
397 | + . " JOIN " . $this->labsHelper->getTable('page') |
|
398 | + . " ON (rev_page = page_id)" |
|
399 | + . " WHERE rev_user_text = :username" |
|
400 | + . " GROUP BY SUBSTR(CAST(rev_timestamp AS CHAR(6)), 1, 6), page_namespace " |
|
401 | + . " ORDER BY rev_timestamp DESC "; |
|
402 | 402 | $resultQuery = $this->replicas->prepare($sql); |
403 | 403 | $resultQuery->bindParam(":username", $username); |
404 | 404 | $resultQuery->execute(); |
@@ -125,7 +125,7 @@ |
||
125 | 125 | /** @var LabsHelper $labsHelper */ |
126 | 126 | $labsHelper = $this->container->get('app.labs_helper'); |
127 | 127 | $sql = "SELECT rev_comment FROM ".$labsHelper->getTable('revision') |
128 | - ." WHERE rev_user=:userId ORDER BY rev_timestamp DESC LIMIT 1000"; |
|
128 | + ." WHERE rev_user=:userId ORDER BY rev_timestamp DESC LIMIT 1000"; |
|
129 | 129 | $resultQuery = $replicas->prepare($sql); |
130 | 130 | $resultQuery->bindParam("userId", $userId); |
131 | 131 | $resultQuery->execute(); |