<?php

namespace Aowow;

if (!defined('AOWOW_REVISION'))
    die('illegal access');

if (!CLI)
    die('not in cli mode');


CLISetup::registerSetup("sql", new class extends SetupScript
{
    protected $info = array(
        'events' => [[], CLISetup::ARGV_PARAM, 'Compiles data for type: Event from world db.']
    );

    protected $worldDependency = ['game_event', 'game_event_prerequisite'];

    public function generate() : bool
    {
        DB::Aowow()->qry('TRUNCATE ::events');

        $events = DB::World()->selectAssoc(
           'SELECT    ge.eventEntry,
                      holiday,
                      0,                                    -- cuFlags
                      IFNULL(UNIX_TIMESTAMP(start_time), 0),
                      IFNULL(UNIX_TIMESTAMP(end_time), 0),
                      occurence * 60,
                      length * 60,
                      IF (gep.eventEntry IS NOT NULL, GROUP_CONCAT(prerequisite_event SEPARATOR " "), NULL),
                      description
            FROM      game_event ge
            LEFT JOIN game_event_prerequisite gep ON gep.eventEntry = ge.eventEntry
            GROUP BY  ge.eventEntry',
        );

        foreach ($events as $e)
            DB::Aowow()->qry('INSERT INTO ::events VALUES %l', $e);

        $this->reapplyCCFlags('events', Type::WORLDEVENT);

        return true;
    }
});

?>