|
@@ 143-145 (lines=3) @@
|
| 140 |
|
ON b.account_id = a.id |
| 141 |
|
WHERE b.height <= ? |
| 142 |
|
ORDER BY height DESC LIMIT ?"); |
| 143 |
|
if ($this->checkStmt($stmt) && $stmt->bind_param("ii", $iHeight, $limit) && $stmt->execute() && $result = $stmt->get_result()) |
| 144 |
|
return $this->memcache->setCache(__FUNCTION__ . $iHeight . $limit, $result->fetch_all(MYSQLI_ASSOC), 5); |
| 145 |
|
return $this->sqlError(); |
| 146 |
|
} |
| 147 |
|
|
| 148 |
|
/** |
|
@@ 191-193 (lines=3) @@
|
| 188 |
|
WHERE account_id = ? AND worker_name != 'unknown' |
| 189 |
|
GROUP BY finder |
| 190 |
|
ORDER BY solvedblocks DESC LIMIT ?"); |
| 191 |
|
if ($this->checkStmt($stmt) && $stmt->bind_param("ii", $account_id, $limit) && $stmt->execute() && $result = $stmt->get_result()) |
| 192 |
|
return $this->memcache->setCache(__FUNCTION__ . $account_id . $limit, $result->fetch_all(MYSQLI_ASSOC), 5); |
| 193 |
|
return $this->sqlError(); |
| 194 |
|
} |
| 195 |
|
|
| 196 |
|
/** |