@@ -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(); |