<?php
class phpbb_ext_example_ext extends phpbb_extension_base
{
    protected $umil_instructions = array(
        '0.7.0'     => array(
            'table_add' => array(
                array('phpbb_ads', array(
                    'COLUMNS'       => array(
                        'ad_id'         => array('UINT', NULL, 'auto_increment'),
                        'ad_name'       => array('VCHAR', ''),
                        'ad_code'       => array('TEXT_UNI', ''),
                        'ad_views'      => array('UINT', 0),
                        'ad_priority'   => array('TINT:1', 5),
                        'ad_enabled'    => array('BOOL', 1),
                        'all_forums'    => array('BOOL', 0),
                    ),
                    'PRIMARY_KEY'   => 'ad_id',
                )),

                array('phpbb_ads_forums', array(
                    'COLUMNS'       => array(
                        'ad_id'         => array('UINT', 0),
                        'forum_id'      => array('UINT', 0),
                    ),
                    'KEYS'          => array(
                        'ad_forum'      => array('INDEX', array('ad_id', 'forum_id')),
                    ),
                )),

                array('phpbb_ads_groups', array(
                    'COLUMNS'       => array(
                        'ad_id'         => array('UINT', 0),
                        'group_id'      => array('UINT', 0),
                    ),
                    'KEYS'          => array(
                        'ad_group'      => array('INDEX', array('ad_id', 'group_id')),
                    ),
                )),

                array('phpbb_ads_in_positions', array(
                    'COLUMNS'       => array(
                        'ad_id'         => array('UINT', 0),
                        'position_id'   => array('UINT', 0),
                        'ad_priority'   => array('TINT:1', 5),
                        'ad_enabled'    => array('BOOL', 1),
                        'all_forums'    => array('BOOL', 0),
                    ),
                    'KEYS'          => array(
                        'ad_position'   => array('INDEX', array('ad_id', 'position_id')),
                        'ad_priority'   => array('INDEX', 'ad_priority'),
                        'ad_enabled'    => array('INDEX', 'ad_enabled'),
                        'all_forums'    => array('INDEX', 'all_forums'),
                    ),
                )),

                array('phpbb_ads_positions', array(
                    'COLUMNS'       => array(
                        'position_id'   => array('UINT', NULL, 'auto_increment'),
                        'lang_key'      => array('TEXT_UNI', ''),
                    ),
                    'PRIMARY_KEY'   => 'position_id',
                )),
            ),

            'permission_add'    => array('a_ads'),

            'module_add'        => array(
                array('acp', 'ACP_BOARD_CONFIGURATION', array('module_basename' => 'ads')),
            ),

            'config_add'        => array(
                array('ads_enable', 1),
                array('ads_rules_forums', 1),
                array('ads_rules_groups', 1),
            ),

            'custom'            => 'ads_install',
        ),
        '1.0.0'     => array(),
        '1.0.1'     => array(
            'table_column_add'  => array(
                array('phpbb_ads', 'ad_clicks', array('UINT', 0)),
            ),

            'config_add'        => array(
                array('ads_count_clicks', 1),
                array('ads_count_views', 1),
                array('ads_accurate_views', 0),
            ),
        ),
        '1.0.2'     => array(),
        '1.0.3'     => array(),
        '1.0.4'     => array(
            'table_column_add'  => array(
                array('phpbb_ads', 'ad_note', array('MTEXT_UNI', '')),
                array('phpbb_ads', 'ad_time', array('TIMESTAMP', 0)),
                array('phpbb_ads', 'ad_time_end', array('TIMESTAMP', 0)),
            ),

            'config_add'        => array(
                array('ads_last_cron', 0, true),
            ),
        ),
        '1.0.5'     => array(),
        '1.0.6'     => array(),
        '1.0.7'     => array(),
        '1.0.8'     => array(
            'table_column_add'  => array(
                array('phpbb_ads', 'ad_view_limit', array('UINT', 0)),
                array('phpbb_ads', 'ad_click_limit', array('UINT', 0)),
            ),
        ),
        '1.0.9'     => array(
            'config_add'    => array(
                array('ads_group', 0),
            ),
            'table_column_add'  => array(
                array('phpbb_ads', 'ad_owner', array('UINT', 0)),
                array('phpbb_users', 'ad_owner', array('BOOL', 0)),
            ),
        ),
        '1.0.10'    => array(
            'table_column_update'   => array(
                array('phpbb_ads', 'ad_views', array('BINT', 0)),
                array('phpbb_ads', 'ad_view_limit', array('BINT', 0)),
                array('phpbb_ads', 'ad_clicks', array('BINT', 0)),
                array('phpbb_ads', 'ad_click_limit', array('BINT', 0)),
            ),

            'table_index_add'       => array(
                array('phpbb_ads', 'ad_priority'),
                array('phpbb_ads', 'ad_enabled'),
                array('phpbb_ads', 'ad_owner'),
            ),

            'cache_purge'   => array(
                'template',
            ),
        ),
      '1.0.11'    => array(),
      '1.0.12'    => array(),
    );

    /**
    * Single enable step that does nothing
    *
    * @param mixed $old_state State returned by previous call of this method
    * @return false Indicates no further steps are required
    */
    public function enable_step($old_state)
    {
        parent::enable_step($old_state);

        set_config('ads_enable', 1);

        return false;
    }


    /**
    * Single disable step that does nothing
    *
    * @param mixed $old_state State returned by previous call of this method
    * @return false Indicates no further steps are required
    */
    public function disable_step($old_state)
    {
        set_config('ads_enable', 0);

        return false;
    }
}

function ads_install($action, $version)
{
    global $db, $table_prefix;

    if ($action != 'install')
    {
        return;
    }

    // Insert the default positions
    $positions = array('ABOVE_HEADER', 'BELOW_HEADER', 'ABOVE_POSTS', 'BELOW_POSTS', 'AFTER_FIRST_POST', 'AFTER_EVERY_POST', 'ABOVE_FOOTER', 'BELOW_FOOTER');
    foreach ($positions as $position)
    {
        $db->sql_query('INSERT INTO ' . $table_prefix . 'ads_positions ' . $db->sql_build_array('INSERT', array('lang_key' => $position)));
    }
}