ALTER TABLE `nuke_bbtopics` ADD `topic_color` VARCHAR( 6 ) ;

CREATE TABLE nuke_board_message (
  msg_id mediumint(8) NOT NULL auto_increment,
  title varchar(25) NOT NULL default '(empty)',
  message text NOT NULL,
  showpage smallint(5) NOT NULL default '0',
  auth tinyint(2) NOT NULL default '5',
  width smallint(3) NOT NULL default '75',
  starttime int(11) NOT NULL default '0',
  endtime int(11) NOT NULL default '0',
  startdate int(11) NOT NULL default '0',
  enddate int(11) NOT NULL default '0',
  users_timezone tinyint(1) NOT NULL default '0',
  bbcode_uid varchar(10) NOT NULL default '',
  days varchar(7) NOT NULL default '0000000',
  images varchar(100) default NULL,
  ordr smallint(3) NOT NULL default '0',
  PRIMARY KEY  (msg_id) );

INSERT INTO nuke_board_message (msg_id, title, message, showpage, auth, width, starttime, endtime, startdate, enddate, users_timezone, bbcode_uid, days, images, ordr) VALUES (1, 'All Pages', 'This message will be shown on all pages. It can be view by all visitors. The width of the table = 80%. It als display a gif file. Order 10', 9999, 0, 80, 946681200, 946681200, 988581600, 1293750000, 0, '', '1111111', '/images/default.gif', 10),
(3, 'Index Only', 'The message will be showed only on the index. Only for registered people. On all days. Order 20', 0, 1, 50, 946681200, 946681200, 1009839600, 1293750000, 0, '', '1111111', '', 20);

ALTER TABLE `nuke_bbforums` ADD `sponsor` TEXT NOT NULL;

Complete_bannerads_db_update_php

#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. Rød
## Nickname: Niels Chr. Denmark
## Email: [ Register or login to view links on this board. ]
##
## Ver 1.0.9
##
## phpBB2 database update script for mods
## this file is intended to use with phpBB2, when installing mods
## after so you may delete this file, but only admin can use so it really doesen't matter
## The script will look what prefix you are using, and use the existing DB defined by congig.php
## The execution of this script's included SQL is harmless, so you can run it as meny times you like
## note, though that the users last visit, will be set back to his/her last login,
## but that is a minor cosmetic isue, that will correct it self next time the use  logs in
##
## the following example are from my mods, and you can add some self, for other mods if you like
## you will after execution get a list over those commands that are run with succes and those with warnings !
## delete the sample lines if you are using it only for other mods
##
#########################################################

if (!eregi("modules.php", $PHP_SELF)) {
    die ("You can't access this file directly...");
}
if ($popup != "1"){
    $module_name = basename(dirname(__FILE__));
    require("modules/".$module_name."/nukebb.php");
}
else
{
    $phpbb_root_path = 'modules/Forums/';
}

define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include('includes/functions_selects.php');
global $prefix;
define('BANNERS_TABLE', $prefix.'_banneradds');
define('BANNER_STATS_TABLE', $prefix.'_banneradds_stats');

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################

$sql=array(
'CREATE TABLE '.BANNERS_TABLE.' (
banner_id MEDIUMINT(8) UNSIGNED NOT NULL,
banner_name TEXT NOT NULL,
banner_spot SMALLINT(1) UNSIGNED NOT NULL,
banner_forum MEDIUMINT(8) UNSIGNED NOT NULL,
banner_description VARCHAR(30) NOT NULL,
banner_url VARCHAR(90) NOT NULL,
banner_owner MEDIUMINT(8) NOT NULL,
banner_click MEDIUMINT(8) UNSIGNED NOT NULL,
banner_view MEDIUMINT(8) UNSIGNED NOT NULL,
banner_weigth TINYINT(1) UNSIGNED DEFAULT "50" NOT NULL,
banner_active TINYINT(1) NOT NULL,
banner_timetype TINYINT(1) NOT NULL,
time_begin INT(11) NOT NULL,
time_end INT(11) NOT NULL,
date_begin INT(11) NOT NULL,
date_end INT(11) NOT NULL,
banner_level TINYINT(1) NOT NULL,
banner_level_type TINYINT(1) NOT NULL,
banner_comment VARCHAR(50) NOT NULL,
banner_type MEDIUMINT(5) NOT NULL,
banner_width MEDIUMINT(5) UNSIGNED NOT NULL,
banner_height MEDIUMINT(5) NOT NULL,
banner_filter TINYINT(1) NOT NULL,
banner_filter_time MEDIUMINT(5) DEFAULT "600" NOT NULL,
INDEX (banner_id))',

'CREATE TABLE '.BANNER_STATS_TABLE.' (
banner_id MEDIUMINT(8) UNSIGNED NOT NULL,
click_date int (11) NOT NULL,
click_ip char(8) NOT NULL,
click_user MEDIUMINT(8) NOT NULL,
user_duration int (11) NOT NULL)');

$mods = array (
'Banner mod', 'Banner mod'
);

############################################### Do not change anything below this line #######################################

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX, $nukeuser);
init_userprefs($userdata);
//
// End session management
//


$n=0;
$message="<b>This list is a result of the SQL queries needed for mod</b><br/><br/>";
while($sql[$n])
{
   $message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
   if(!$result = $db->sql_query($sql[$n]))
   $message .= '<b><font color=#FF0000>[Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
   else $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
   $n++;
}
message_die(GENERAL_MESSAGE, $message);
?>

ALTER TABLE nuke_users ADD user_rank2 INT(11) AFTER user_rank;
UPDATE nuke_users SET user_rank2 = "0";

<?php
        /***************************************************************************
                                   topsmilies_install.php
                                     -------------------
            begin                : Tue February 26 2002
            copyright            : (C) 2002 Nivisec.com
            email                : [ Register or login to view links on this board. ]
         
            $Id: topsmilies_install.php,v 1.2.2 2002/04/18 02:43:12 nivisec Exp $
         
         ***************************************************************************/
         
        /***************************************************************************
         *                                                                                         
         *   This program is free software; you can redistribute it and/or modify       
         *   it under the terms of the GNU General Public License as published by   
         *   the Free Software Foundation; either version 2 of the License, or             
         *   (at your option) any later version.
         *
         ***************************************************************************/

if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
    die ("You can't access this file directly...");
}
if ($popup != "1"){
    $module_name = basename(dirname(__FILE__));
    require("modules/".$module_name."/nukebb.php");
}
else
{
    $phpbb_root_path = 'modules/Forums/';
}

define('IN_PHPBB', true);
ini_set('ignore_user_abort', "1");
ini_set('max_execution_time', "120120");

include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

function top_smilies($message)
{
    global $db, $board_config;

    $sql = "SELECT code, smilies_id, smile_stat
    FROM " . SMILIES_TABLE;

    if( !$result = $db->sql_query($sql) )
    {
        message_die(GENERAL_ERROR, "Couldn't obtain smilies data", "", __LINE__, __FILE__, $sql);
    }
    $smile = $db->sql_fetchrowset($result);

    for ($i = 0; $i < count($smile); $i++)
    {
        if ($count_smile = preg_match_all ("/(?<=.\\W|\\W.|^\\W)" . phpbb_preg_quote($smile[$i]['code'], "/") . "(?=.\\W|\\W.|\\W$)/", ' ' . $message . ' ', $tmp_smile))
        {
            $smilie_usage = $smile[$i]['smile_stat'] + $count_smile;
            $sql = 'UPDATE ' . SMILIES_TABLE . '
            SET smile_stat = ' . $smilie_usage . '
            WHERE smilies_id = ' . $smile[$i]['smilies_id'];

            if( !$result = $db->sql_query($sql) )
            {
                message_die(GENERAL_ERROR, "Couldn't update smilies data", "", __LINE__, __FILE__, $sql);
            }
        }
    }
}

if(isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']))
{
    $mode = (isset($HTTP_POST_VARS['mode'])) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
}

$userdata = session_pagestart($user_ip, PAGE_INDEX, $board_config['session_length'], $nukeuser);
init_userprefs($userdata);

if ($userdata['user_level'] != ADMIN)
{
    die('Please log into an administrator enabled account before running this script');
}

print '<html><body>Please make sure to delete this file after you install/uninstall the new table addition to prevent security problems!';
print '<br /><a href="modules.php?name=Forums&file=topsmilies_install&mode=change">Install the new database field</a><br />';
print '<br /><a href="topsmilies_install&mode=uninstall">Un-install the new database field</a><br />';
print '<br /><a href="modules.php?name=Forums&file=topsmilies_install&mode=import">Import your old smilies into the new database field.  Do this only after you have created it!<font color="red"> This WILL take some time if you have a lot of posts</font></a><br />';

if ($mode == 'change')
{
    $sql = "ALTER TABLE " . SMILIES_TABLE . "
    ADD smile_stat MEDIUMINT UNSIGNED DEFAULT 0 NOT NULL";

    if (!$db->sql_query($sql))
    {
        print '<br><br><font color="red">Unable to insert smile_stat field<br>Maybe it is already inserted?</font><br>SQL Used: ' . $sql;
    }
    else
    {
        print '<br><br><font color="blue">Inserted smile_stat field...</font><br>SQL Used: ' . $sql;
    }
    print '<hr>Checking Values, make sure they contain data!  You should see the smilie code and a number after each, probably the number 0.<br>If you do not see these values, you will have to add this table field manually to get smilies to work!<br><br>';
    $sql = "SELECT code, smile_stat FROM " . SMILIES_TABLE;
    $result = $db->sql_query($sql);
    print '<br><br>';
    while ($row = $db->sql_fetchrow($result))
    {
        print '<br>Smilie Code: ' . $row['code'] . '</td><td>Smilie Uses: ' . $row['smile_stat'];
    }
}
else if ($mode == 'uninstall')
{
    $sql = "ALTER TABLE " . SMILIES_TABLE . "
    DROP smile_stat";
    if (!$db->sql_query($sql))
    {
        print '<br><br><font color="red">Unable to DROP smile_stat field.  Perhaps it is already dropped?</font><br>SQL Used: ' . $sql;
    }
    else
    {
        print '<br><br><font color="blue">Dropped smile_stat field.</font><br>SQL Used: ' . $sql;
    }
}
else if ($mode == 'import')
{
    $sql = "SELECT MAX(post_id) as max, MIN(post_id) as min
    FROM " . POSTS_TABLE;

    $result = $db->sql_query($sql);

    $postrow = $db->sql_fetchrow($result);

    print '<br />Starting ID = ' .$postrow['min'];
    print '<br />Ending ID = ' .$postrow['max'];
     
    for ($i = $postrow['min']; $i <= $postrow['max']; $i++)
    {
        $sql = "SELECT post_id, post_text
        FROM " . POSTS_TEXT_TABLE . "
        WHERE post_id = " . $i;
        $result = $db->sql_query($sql);

        $row = $db->sql_fetchrow($result);

        top_smilies($row['post_text']);
        print '<br>Post: ' . $i . ' Done.';
    }
}
?>
</body></html>