Location: PHPKode > projects > MGB OpenSource Guestbook > mgb-0.6.9.1/install/upgrade/0691.php
<?php
	/*
	MGB 0.6.x - OpenSource PHP and MySql Guestbook
	Copyright (C) 2004 - 2011 Juergen Grueneisl - http://www.m-gb.org/

	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.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
	*/

	// ======== //
	// 0691.php //
	// ======== //
	//
	// ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //

$sql = array();

$sql[1] = "ALTER TABLE `".$db['prefix']."settings` ADD `allow_img_tag` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `bbcode`";
$sqldescription[1] = "- Adding SQL-field allow_img_tag...";
$sql[2] = "ALTER TABLE `".$db['prefix']."settings`ADD `max_img_width` INT( 4 ) NOT NULL DEFAULT '400' AFTER `allow_img_tag`";
$sqldescription[2] = "- Adding SQL-field max_img_width...";
$sql[3] = "ALTER TABLE `".$db['prefix']."settings` ADD `max_img_height` INT( 4 ) NOT NULL DEFAULT '400' AFTER `max_img_width`";
$sqldescription[3] = "- Adding SQL-field max_img_height...";
$sql[4] = "ALTER TABLE `".$db['prefix']."settings` ADD `center_img` TINYINT( 1 ) NOT NULL DEFAULT '1' AFTER `max_img_height`";
$sqldescription[4] = "- Adding SQL-field center_img...";
$sql[5] = "ALTER TABLE `".$db['prefix']."settings` ADD `allow_flash_tag` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `center_img`";
$sqldescription[5] = "- Adding SQL-field allow_flash_tag...";
$sql[6] = "ALTER TABLE `".$db['prefix']."settings` ADD `max_flash_width` INT( 4 ) NOT NULL DEFAULT '400' AFTER `allow_flash_tag`";
$sqldescription[6] = "- Adding SQL-field max_flash_width...";
$sql[7] = "ALTER TABLE `".$db['prefix']."settings` ADD `max_flash_height` INT( 4 ) NOT NULL DEFAULT '400' AFTER `max_flash_width`";
$sqldescription[7] = "- Adding SQL-field max_flash_height...";
$sql[8] = "ALTER TABLE `".$db['prefix']."settings` ADD `center_flash` TINYINT( 1 ) NOT NULL DEFAULT '1' AFTER `max_flash_height`";
$sqldescription[8] = "- Adding SQL-field center_flash...";
$sql[9] = "ALTER TABLE `".$db['prefix']."settings` ADD `captcha_coords_x` INT( 3 ) NOT NULL DEFAULT '20' AFTER `captcha_method`";
$sqldescription[9] = "- Adding SQL-field captcha_coords_x...";
$sql[10] = "ALTER TABLE `".$db['prefix']."settings` ADD `captcha_coords_y` INT( 3 ) NOT NULL DEFAULT '25' AFTER `captcha_coords_x`";
$sqldescription[10] = "- Adding SQL-field captcha_coords_y...";
$sql[11] = "ALTER TABLE `".$db['prefix']."settings` ADD `captcha_color` VARCHAR( 6 ) NOT NULL DEFAULT '505050' AFTER `captcha_coords_y`";
$sqldescription[11] = "- Adding SQL-field captcha_color...";
$sql[12] = "ALTER TABLE `".$db['prefix']."settings` ADD `captcha_angle_1` INT( 4 ) NOT NULL DEFAULT '-10' AFTER `captcha_color`";
$sqldescription[12] = "- Adding SQL-field captcha_angle_1...";
$sql[13] = "ALTER TABLE `".$db['prefix']."settings` ADD `captcha_angle_2` INT( 4 ) NOT NULL DEFAULT '5' AFTER `captcha_angle_1`";
$sqldescription[13] = "- Adding SQL-field captcha_angle_2...";

$to = 13;
?>
Return current item: MGB OpenSource Guestbook