/**
* Return all blacklists.
*
* @param bool $activeOnly Only display active blacklists ?
*
* @return array
*/
public function getBlacklist($activeOnly = true)
{
return $this->_pdo->query(sprintf('
SELECT
binaryblacklist.id, binaryblacklist.optype, binaryblacklist.status, binaryblacklist.description,
binaryblacklist.groupname AS groupname, binaryblacklist.regex, groups.id AS group_id, binaryblacklist.msgcol
FROM binaryblacklist
LEFT OUTER JOIN groups ON groups.name = binaryblacklist.groupname %s
ORDER BY coalesce(groupname,\'zzz\')', $activeOnly ? ' WHERE binaryblacklist.status = 1 ' : ''));
}
<?php
//This script will update all records in the gamesinfo table
require_once dirname(__FILE__) . '/../../../www/config.php';
$pdo = new nzedb\db\Settings();
$game = new Games(['Echo' => true, 'Settings' => $pdo]);
$res = $pdo->query(sprintf("SELECT searchname FROM releases WHERE gamesinfo_id IS NULL AND categoryid = 4050 ORDER BY id DESC LIMIT 100"));
$total = count($res);
if ($total > 0) {
echo $pdo->log->header("Updating game info for " . number_format($total) . " releases.");
foreach ($res as $arr) {
$starttime = microtime(true);
$gameInfo = $game->parseTitle($arr['searchname']);
if ($gameInfo !== false) {
$gameData = $game->updateGamesInfo($gameInfo);
if ($gameData === false) {
echo $pdo->log->primary($gameInfo['release'] . ' not found');
}
}
// amazon limits are 1 per 1 sec
$diff = floor((microtime(true) - $starttime) * 1000000);
if (1000000 - $diff > 0) {
echo $pdo->log->alternate("Sleeping");
usleep(1000000 - $diff);
}
}
}
