function __construct()
{
$this->initConnection();
$decks = $this->dbquery('SELECT * FROM deck WHERE language IS NULL OR language="" OR language="-"');
echo 'decks:' . count($decks);
foreach ($decks as $task) {
$deck = new Deck();
$deck->deck_id = $task['id'];
$deck->createFromID($deck->getLastRevisionID());
$language = $deck->detectLanguage();
$deck->setLanguageFull($language);
}
$slides = $this->dbquery('SELECT * FROM slide WHERE language IS NULL OR language="" OR language="-"');
echo 'slides:' . count($slides);
$decks = array();
foreach ($slides as $task) {
$slide = new Slide();
$slide->slide_id = $task['id'];
$id = $slide->getLastRevisionID();
$decks_array = $this->dbGetOne('SELECT deck_revision_id FROM deck_content WHERE item_id =:id AND item_type="slide" LIMIT 1', array('id' => $id));
if ($decks_array) {
if (!in_array($decks_array, $decks)) {
$decks[] = $decks_array;
}
}
}
echo 'decks:' . count($decks) . '<br>';
foreach ($decks as $task) {
echo $task;
$deck = new Deck();
$deck->createFromID($task);
$language = $deck->detectLanguage();
$deck->setLanguageFull($language);
echo ' done ';
}
}
