@@ 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 | /** |