public static function run(DatabaseMysql $db, $test = false, $verbose = false, $params = null)
{
$dbname = $params['dbname'];
// Don't process the video wiki
if ($dbname == 'video151') {
return true;
}
// Get all suggestion data in this wiki
$sql = <<<SQL
select page_id, props
from page_wikia_props
where propname = 19
SQL;
if ($verbose) {
echo "Running on {$dbname}\n";
}
if (empty($test)) {
$res = $db->query($sql);
// Loop through all the data
while ($row = $db->fetchRow($res)) {
// The prop field should be a serialized array
$data = unserialize($row['props']);
if (empty($data)) {
continue;
}
if (count($data) == 0) {
continue;
}
foreach ($data as $item) {
// If this is not an array, the data is bad
if (empty($item['title'])) {
file_put_contents('/tmp/badData.log', $dbname . "\n", FILE_APPEND);
echo "\t{$dbname} - BAD DATA\n";
// Exit immediately, we don't need to run the rest
return true;
}
}
}
}
}