root/branches/download/install.php

<?php
/***********************************************************************

        FluxBB extension
        Portal
        Daris <daris91@gmail.com>

************************************************************************/


// Make sure no one attempts to run this script "directly"
if (!defined('FORUM'))
        exit;

function install()
{
        global $forum_db;

        // it's an upgrade
        if (defined('EXT_CUR_VERSION'))
        {
                // do upgrade...
                if (EXT_CUR_VERSION == '1.0')
                {
                        $forum_db->add_field('downloads', 'file', 'VARCHAR(255)', false);

                        $query = array(
                                'SELECT'        => 'name, version, id',
                                'FROM'          => 'downloads',
                        );
                        $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
                        
                        while ($cur_download = $forum_db->fetch_assoc($result))
                        {
                                $version = ($cur_download['version'] != '' ? '_'.$cur_download['version'] : '');
                                $filename = $cur_download['name'].$version.'.zip';
                                $filename = str_replace(' ', '_', strtolower($filename));
                                $filename = preg_replace('/[^0-9a-z\._]/', '', $filename);
        
                                $query2 = array(
                                        'UPDATE'        => 'downloads',
                                        'SET'           => 'file=\''.$forum_db->escape($filename).'\'',
                                        'WHERE'         => 'id=\''.$cur_download['id'].'\'',
                                );
                                $result2 = $forum_db->query_build($query2) or error(__FILE__, __LINE__);
                                
                                rename(FORUM_ROOT.'extensions/download/files/'.$cur_download['id'].'.zip', FORUM_ROOT.'extensions/download/files/'.$filename);
                        }

                }

        }
        // it's a fresh install
        else
        {

                // Table panels
                $schema = array(
                        'FIELDS'                => array(
                                'id'                    => array(
                                        'datatype'              => 'SERIAL',
                                        'allow_null'    => false
                                ),
                                'name'                  => array(
                                        'datatype'              => 'VARCHAR(255)',
                                        'allow_null'    => true
                                ),
                                'description'           => array(
                                        'datatype'              => 'text',
                                        'allow_null'    => true
                                ),
                        ),
                        'PRIMARY KEY'   => array('id')
                );
                
                $forum_db->create_table('downloads_cats', $schema);
                $forum_db->query('INSERT INTO '.$forum_db->prefix.'downloads_cats (name) VALUES (\'Rozszerzenia\')') or error(__FILE__, __LINE__);
                $cat_id = $forum_db->insert_id();
                $forum_db->query('INSERT INTO '.$forum_db->prefix.'downloads_cats (name) VALUES (\'Style\')') or error(__FILE__, __LINE__);


                // Table panels
                $schema = array(
                        'FIELDS'                => array(
                                'id'                    => array(
                                        'datatype'              => 'SERIAL',
                                        'allow_null'    => false
                                ),
                                'cat'                   => array(
                                        'datatype'              => 'INT(10) UNSIGNED',
                                        'allow_null'    => true,
                                        'default'               => $cat_id
                                ),
                                'name'                  => array(
                                        'datatype'              => 'VARCHAR(255)',
                                        'allow_null'    => true
                                ),
                                'description'           => array(
                                        'datatype'              => 'text',
                                        'allow_null'    => true
                                ),
                                'version'                       => array(
                                        'datatype'              => 'VARCHAR(255)',
                                        'allow_null'    => true,
                                        'default'       => '1.0'
                                ),
                                'author'                        => array(
                                        'datatype'              => 'VARCHAR(255)',
                                        'allow_null'    => true,
                                ),
/*                              'file'                  => array(
                                        'datatype'              => 'VARCHAR(255)',
                                        'allow_null'    => true
                                ),*/
                                'downloads'                     => array(
                                        'datatype'              => 'INT(10) UNSIGNED',
                                        'allow_null'    => true,
                                        'default'       => 0
                                ),
                                'approved'                      => array(
                                        'datatype'              => 'INT(1) UNSIGNED',
                                        'allow_null'    => true,
                                        'default'       => 0
                                ),
                                'user_id'                       => array(
                                        'datatype'              => 'INT(10) UNSIGNED',
                                        'allow_null'    => true,
                                ),
                                'added'                 => array(
                                        'datatype'              => 'INT(10) UNSIGNED',
                                        'allow_null'    => true,
                                ),
                        ),
                        'PRIMARY KEY'   => array('id')
                );
                
                $forum_db->create_table('downloads', $schema);
                $forum_db->query('INSERT INTO '.$forum_db->prefix.'downloads (name, description, approved) VALUES (\'Geshi highlight\', \'test\', 1)') or error(__FILE__, __LINE__);
                
/*              for ($i = 1; $i < 20; $i++)
                        $forum_db->query('INSERT INTO '.$forum_db->prefix.'downloads (name, description, approved) VALUES (\'Extension '.$i.'\', \'test\', 1)') or error(__FILE__, __LINE__);*/

        }
}


function uninstall()
{
        global $forum_db;

        $forum_db->drop_table('downloads_cats');
        $forum_db->drop_table('downloads');
}