include/classes/share.class.php 1 location
|
@@ 237-241 (lines=5) @@
|
| 234 |
|
sleep($this->config['purge']['sleep']); |
| 235 |
|
$stmt = $this->mysqli->prepare("DELETE FROM $this->table WHERE id > ? AND id <= ? ORDER BY id LIMIT " . $this->config['purge']['shares']); |
| 236 |
|
$start = microtime(true); |
| 237 |
|
if ($this->checkStmt($stmt) && $stmt->bind_param('ii', $previous_upstream, $current_upstream) && $stmt->execute()) { |
| 238 |
|
$affected = $stmt->affected_rows; |
| 239 |
|
} else { |
| 240 |
|
return $this->sqlError(); |
| 241 |
|
} |
| 242 |
|
} |
| 243 |
|
return true; |
| 244 |
|
} |
include/classes/token.class.php 1 location
|
@@ 133-137 (lines=5) @@
|
| 130 |
|
$failed = $this->deleted = 0; |
| 131 |
|
foreach ($aTokenTypes as $aTokenType) { |
| 132 |
|
$stmt = $this->mysqli->prepare("DELETE FROM $this->table WHERE (NOW() - time) > ? AND type = ?"); |
| 133 |
|
if (! ($this->checkStmt($stmt) && $stmt->bind_param('ii', $aTokenType['expiration'], $aTokenType['id']) && $stmt->execute())) { |
| 134 |
|
$failed++; |
| 135 |
|
} else { |
| 136 |
|
$this->deleted += $stmt->affected_rows; |
| 137 |
|
} |
| 138 |
|
} |
| 139 |
|
if ($failed > 0) { |
| 140 |
|
$this->setCronMessage('Failed to delete ' . $failed . ' token types from ' . $this->table . ' table'); |
include/classes/notification.class.php 1 location
|
@@ 194-198 (lines=5) @@
|
| 191 |
|
$failed = 0; |
| 192 |
|
$this->deleted = 0; |
| 193 |
|
$stmt = $this->mysqli->prepare("DELETE FROM $this->table WHERE time < (NOW() - INTERVAL ? DAY)"); |
| 194 |
|
if (! ($this->checkStmt($stmt) && $stmt->bind_param('i', $days) && $stmt->execute())) { |
| 195 |
|
$failed++; |
| 196 |
|
} else { |
| 197 |
|
$this->deleted += $stmt->affected_rows; |
| 198 |
|
} |
| 199 |
|
if ($failed > 0) { |
| 200 |
|
$this->setCronMessage('Failed to delete ' . $failed . ' notifications from ' . $this->table . ' table'); |
| 201 |
|
return false; |