Hvordan legge inn tabeller fra en php fil

Alle spørsmål vedrørende phpBB 3.x stilles i dette forumet. Husk at vi IKKE gir support til uoffisielle versjoner av phpBB, det er kun versjoner lastet ned fra phpBB.com eller her fra phpBB.no som gis hjelp til. Oppdater alltid til siste versjon før du spør om hjelp.
Forumregler
Support til phpBB 3.x gis i dette forumet.
Om du har spørsmål angående oppdatering/oppgradering/konvertering, så spør i riktig underforum. Diskusjon rundt phpBB 3.x, modifikasjoner eller design gjøres i andre forum. Altså, kun vanlige supportspørsmål til phpBB i dette forumet.
Svar
Brukeravatar
pippin
PhpBB-frelst
PhpBB-frelst
Innlegg: 383
Registrert: 9. mai 2006, 19:41

Hvordan legge inn tabeller fra en php fil

Legg inn av pippin » 1. jan 2010, 18:19

Jeg får ikke til å legge inn disse da igjen etter en opprenskining da av databasen, dette skal skje da automatisk da i ACP

Kode: Velg alt

<?php
/**
 *
 * @author David Lewis (Highway of Life) http://startrekguide.com
 * @package acp
 * @version $Id: acp_donation_mod.php 8 2008-04-08 19:30:42Z Highway of Life $
 * @copyright (c) 2008 Star Trek Guide Group
 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
 *
 */

/**
 * @ignore
 */
if (!defined('IN_PHPBB'))
{
	exit;
}

/**
* @package module_install
*/
class acp_donation_mod_info
{
	protected $mod_data = array();

	function module()
	{
		return array(
			'filename'	=> 'acp_donation_mod',
			'title'		=> 'ACP_DONATION_MANAGEMENT',
			'version'	=> '1.0.B3',
			'modes'		=> array(
				'settings'		=> array('title' => 'ACP_DONATE_SETTINGS', 'auth' => 'acl_a_board', 'cat' => array('ACP_DONATION_MOD')),
				'rewards'		=> array('title' => 'ACP_DONATE_REWARDS', 'auth' => 'acl_a_board', 'cat' => array('ACP_DONATION_MOD')),
				'goals'			=> array('title' => 'ACP_DONATE_GOALS', 'auth' => 'acl_a_board', 'cat' => array('ACP_DONATION_MOD')),
				'donations'		=> array('title' => 'ACP_DONATE_DONATIONS', 'auth' => 'acl_a_board', 'cat' => array('ACP_DONATION_MOD')),
				'supporters'	=> array('title' => 'ACP_DONATE_SUPPORTERS', 'auth' => 'acl_a_board', 'cat' =>  array('ACP_DONATION_MOD')),
			),
		);
	}

	function install()
	{
		global $config, $db, $user;

		$this->mod_data = $this->module();

		// this is the first version, so we install only.
		if (!isset($config['paypal_donation_mod']))
		{
			$sql_layer = '';
			switch ($db->sql_layer)
			{
				case 'mysql':
					$sql_layer = 'mysql_40';
				break;

				case 'mysql4':
					$sql_layer = 'mysql_40';

					if (version_compare($db->mysql_version, '4.1.3', '>='))
					{
						$sql_layer = 'mysql_41';
					}
				break;

				case 'mysqli':
					$sql_layer = 'mysql_41';
				break;

				case 'mssql':
				case 'mssql_odbc':
					$sql_layer = 'mssql';
				break;

				default:
					$sql_layer = $db->sql_layer;
				break;
			}

			switch ($sql_layer)
			{
				case 'mysql_41':
					$sql = 'CREATE TABLE ' . DONATION_DATA_TABLE . " (
								transaction_id mediumint(8) unsigned NOT NULL auto_increment,
								txn_id varchar(18) collate utf8_bin NOT NULL,
								txn_type varchar(32) collate utf8_bin NOT NULL,
								confirmed tinyint(1) unsigned NOT NULL default '0',
								user_id mediumint(8) unsigned NOT NULL default '0',
								item_name varchar(128) collate utf8_bin NOT NULL,
								item_number varchar(128) collate utf8_bin NOT NULL,
								payment_time int(11) unsigned NOT NULL default '0',
								business varchar(128) collate utf8_bin NOT NULL,
								payment_status varchar(32) collate utf8_bin NOT NULL,
								payment_gross decimal(8,2) NOT NULL,
								payment_fee decimal(8,2) NOT NULL,
								payment_type varchar(16) collate utf8_bin NOT NULL,
								mc_currency varchar(16) collate utf8_bin NOT NULL,
								payment_date varchar(32) collate utf8_bin NOT NULL,
								payer_id varchar(16) collate utf8_bin NOT NULL,
								payer_email varchar(128) collate utf8_bin NOT NULL,
								payer_status varchar(16) collate utf8_bin NOT NULL,
								first_name varchar(64) collate utf8_bin NOT NULL,
								last_name varchar(64) collate utf8_bin NOT NULL,
								memo varchar(255) collate utf8_bin NOT NULL,
								PRIMARY KEY  (transaction_id),
								KEY user_id (user_id),
								KEY txn_id (txn_id)
							)";
					$db->sql_query($sql);

					$sql = 'CREATE TABLE ' . DONATION_PERKS_TABLE . " (
								perk_id mediumint(8) unsigned NOT NULL auto_increment,
								perk_title varchar(100) collate utf8_bin NOT NULL,
								perk_text mediumtext collate utf8_bin NOT NULL,
								perk_desc_bitfield varchar(255) collate utf8_bin NOT NULL default '',
								perk_desc_options int(11) unsigned NOT NULL default '7',
								perk_desc_uid varchar(8) collate utf8_bin NOT NULL default '',
								perk_order tinyint(3) unsigned NOT NULL default '0',
								perk_active_date int(11) unsigned NOT NULL default '0',
								perk_expire_date int(11) unsigned NOT NULL default '0',
								PRIMARY KEY (perk_id),
								KEY perk_active_date (perk_active_date),
								KEY perk_expire_date (perk_expire_date)
							)";
					$db->sql_query($sql);
				break;

				case 'mysql_40':
					$sql = 'CREATE TABLE ' . DONATION_DATA_TABLE . " (
								transaction_id mediumint(8) unsigned NOT NULL auto_increment,
								txn_id varchar(18) NOT NULL,
								txn_type varchar(32) NOT NULL,
								confirmed tinyint(1) unsigned NOT NULL default '0',
								user_id mediumint(8) unsigned NOT NULL default '0',
								item_name varchar(128) NOT NULL,
								item_number varchar(128) NOT NULL,
								payment_time int(11) unsigned NOT NULL default '0',
								business varchar(128) NOT NULL,
								payment_status varchar(32) NOT NULL,
								payment_gross decimal(8,2) NOT NULL,
								payment_fee decimal(8,2) NOT NULL,
								payment_type varchar(16) NOT NULL,
								mc_currency varchar(16) NOT NULL,
								payment_date varchar(32) NOT NULL,
								payer_id varchar(16) NOT NULL,
								payer_email varchar(128) NOT NULL,
								payer_status varchar(16) NOT NULL,
								first_name varchar(64) NOT NULL,
								last_name varchar(64) NOT NULL,
								memo varchar(255) NOT NULL,
								PRIMARY KEY  (transaction_id),
								KEY user_id (user_id),
								KEY txn_id (txn_id)
							)";
					$db->sql_query($sql);

					$sql = 'CREATE TABLE ' . DONATION_PERKS_TABLE . " (
								perk_id mediumint(8) unsigned NOT NULL auto_increment,
								perk_title varchar(100) NOT NULL,
								perk_text mediumtext NOT NULL,
								perk_desc_bitfield varchar(255) NOT NULL default '',
								perk_desc_options int(11) unsigned NOT NULL default '7',
								perk_desc_uid varchar(8) NOT NULL default '',
								perk_order tinyint(3) unsigned NOT NULL default '0',
								perk_active_date int(11) unsigned NOT NULL default '0',
								perk_expire_date int(11) unsigned NOT NULL default '0',
								PRIMARY KEY (perk_id),
								KEY perk_active_date (perk_active_date),
								KEY perk_expire_date (perk_expire_date)
							)";
					$db->sql_query($sql);
				break;

				case 'sqlite':
					$sql = 'BEGIN TRANSACTION;

						CREATE TABLE ' . DONATION_DATA_TABLE . " (
							transaction_id INTEGER PRIMARY KEY NOT NULL ,
							txn_id varchar(18) NOT NULL DEFAULT '',
							txn_type varchar(32) NOT NULL DEFAULT '',
							confirmed INTEGER UNSIGNED NOT NULL DEFAULT '0',
							user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',
							item_name varchar(128) NOT NULL DEFAULT '',
							item_number varchar(128) NOT NULL DEFAULT '',
							payment_time INTEGER UNSIGNED NOT NULL DEFAULT '0',
							business varchar(128) NOT NULL DEFAULT '',
							payment_status varchar(32) NOT NULL DEFAULT '',
							payment_gross decimal(8,2) NOT NULL DEFAULT '',
							payment_fee decimal(8,2) NOT NULL DEFAULT '',
							payment_type varchar(16) NOT NULL DEFAULT '',
							mc_currency varchar(16) NOT NULL DEFAULT '',
							payment_date varchar(32) NOT NULL DEFAULT '',
							payer_id varchar(16) NOT NULL DEFAULT '',
							payer_email varchar(128) NOT NULL DEFAULT '',
							payer_status varchar(16) NOT NULL DEFAULT '',
							first_name varchar(64) NOT NULL DEFAULT '',
							last_name varchar(64) NOT NULL DEFAULT '',
							memo varchar(255) NOT NULL DEFAULT ''
						);

						CREATE INDEX " . DONATION_DATA_TABLE . '_user_id ON ' . DONATION_DATA_TABLE . ' (user_id);
						CREATE INDEX ' . DONATION_DATA_TABLE . '_txn_id ON ' . DONATION_DATA_TABLE . ' (txn_id);

						CREATE TABLE ' . DONATION_PERKS_TABLE . " (
							perk_id INTEGER PRIMARY KEY NOT NULL ,
							perk_title varchar(100) NOT NULL DEFAULT '',
							perk_text mediumtext(16777215) NOT NULL DEFAULT '',
							perk_desc_bitfield varchar(255) NOT NULL DEFAULT '',
							perk_desc_options INTEGER UNSIGNED NOT NULL DEFAULT '7',
							perk_desc_uid varchar(8) NOT NULL DEFAULT '',
							perk_order tinyint(3) NOT NULL DEFAULT '0',
							perk_active_date INTEGER UNSIGNED NOT NULL DEFAULT '0',
							perk_expire_date INTEGER UNSIGNED NOT NULL DEFAULT '0'
						);

						CREATE INDEX " . DONATION_PERKS_TABLE . '_perk_active_date ON ' . DONATION_PERKS_TABLE . ' (perk_active_date);
						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_expire_date ON ' . DONATION_PERKS_TABLE . ' (perk_expire_date);

						COMMIT;';
					$db->sql_query($sql);
				break;

				case 'postgres':
					$sql = 'BEGIN;

						CREATE SEQUENCE ' . DONATION_DATA_TABLE . '_seq;

						CREATE TABLE ' . DONATION_DATA_TABLE . " (
							transaction_id INT4 DEFAULT nextval('" . DONATION_DATA_TABLE . "_seq'),
							txn_id varchar(18) DEFAULT '' NOT NULL,
							txn_type varchar(32) DEFAULT '' NOT NULL,
							confirmed boolean DEFAULT '0' NOT NULL CHECK (confirmed >= 0),
							user_id INT4 DEFAULT '0' NOT NULL CHECK (user_id >= 0),
							item_name varchar(128) DEFAULT '' NOT NULL,
							item_number varchar(128) DEFAULT '' NOT NULL,
							payment_time INT4 DEFAULT '0' NOT NULL CHECK (payment_time >= 0),
							business varchar(128) DEFAULT '' NOT NULL,
							payment_status varchar(32) DEFAULT '' NOT NULL,
							payment_gross decimal(8,2) DEFAULT '' NOT NULL,
							payment_fee decimal(8,2) DEFAULT '' NOT NULL,
							payment_type varchar(16) DEFAULT '' NOT NULL,
							mc_currency varchar(16) DEFAULT '' NOT NULL,
							payment_date varchar(32) DEFAULT '' NOT NULL,
							payer_id varchar(16) DEFAULT '' NOT NULL,
							payer_email varchar(128) DEFAULT '' NOT NULL,
							payer_status varchar(16) DEFAULT '' NOT NULL,
							first_name varchar(64) DEFAULT '' NOT NULL,
							last_name varchar(64) DEFAULT '' NOT NULL,
							memo varchar(255) DEFAULT '' NOT NULL,
							PRIMARY KEY (transaction_id)
						);

						CREATE INDEX " . DONATION_DATA_TABLE . '_user_id ON ' . DONATION_DATA_TABLE . ' (user_id);
						CREATE INDEX ' . DONATION_DATA_TABLE . '_txn_id ON ' . DONATION_DATA_TABLE . ' (txn_id);

						CREATE SEQUENCE ' . DONATION_PERKS_TABLE . '_seq;

						CREATE TABLE ' . DONATION_PERKS_TABLE . " (
							perk_id INT4 DEFAULT nextval('" . DONATION_PERKS_TABLE . "_seq'),
							perk_title varchar(100) DEFAULT '' NOT NULL,
							perk_text TEXT DEFAULT '' NOT NULL,
							perk_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
							perk_desc_options INT4 DEFAULT '7' NOT NULL CHECK (perk_desc_options >= 0),
							perk_desc_uid varchar(8) DEFAULT '' NOT NULL,
							perk_order INT2 DEFAULT '0' NOT NULL,
							perk_active_date INT4 DEFAULT '0' NOT NULL CHECK (perk_active_date >= 0),
							perk_expire_date INT4 DEFAULT '0' NOT NULL CHECK (perk_expire_date >= 0),
							PRIMARY KEY (perk_id)
						);

						CREATE INDEX " . DONATION_PERKS_TABLE . '_perk_active_date ON ' . DONATION_PERKS_TABLE . ' (perk_active_date);
						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_expire_date ON ' . DONATION_PERKS_TABLE . ' (perk_expire_date);

						COMMIT;';
						$db->sql_query($sql);
				break;

				case 'oracle':
					$sql = 'CREATE TABLE ' . DONATION_DATA_TABLE . " (
							transaction_id number(8) NOT NULL,
							txn_id varchar2(18 char) DEFAULT '' ,
							txn_type varchar2(32 char) DEFAULT '' ,
							confirmed number(1) DEFAULT '0' NOT NULL,
							user_id number(8) DEFAULT '0' NOT NULL,
							item_name varchar2(128 char) DEFAULT '' ,
							item_number varchar2(128 char) DEFAULT '' ,
							payment_time number(11) DEFAULT '0' NOT NULL,
							business varchar2(128 char) DEFAULT '' ,
							payment_status varchar2(32 char) DEFAULT '' ,
							payment_gross number(8, 2) DEFAULT '' ,
							payment_fee number(8, 2) DEFAULT '' ,
							payment_type varchar2(16 char) DEFAULT '' ,
							mc_currency varchar2(16 char) DEFAULT '' ,
							payment_date varchar2(32 char) DEFAULT '' ,
							payer_id varchar2(16 char) DEFAULT '' ,
							payer_email varchar2(128 char) DEFAULT '' ,
							payer_status varchar2(16 char) DEFAULT '' ,
							first_name varchar2(64 char) DEFAULT '' ,
							last_name varchar2(64 char) DEFAULT '' ,
							memo varchar2(255 char) DEFAULT '' ,
							CONSTRAINT pk_" . DONATION_DATA_TABLE . ' PRIMARY KEY (transaction_id)
						)
						/

						CREATE INDEX ' . DONATION_DATA_TABLE . '_user_id ON ' . DONATION_DATA_TABLE . ' (user_id)
						/
						CREATE INDEX ' . DONATION_DATA_TABLE . '_txn_id ON ' . DONATION_DATA_TABLE . ' (txn_id)
						/

						CREATE SEQUENCE ' . DONATION_DATA_TABLE . '_seq
						/

						CREATE OR REPLACE TRIGGER t_' . DONATION_DATA_TABLE . '
						BEFORE INSERT ON ' . DONATION_DATA_TABLE . '
						FOR EACH ROW WHEN (
							new.transaction_id IS NULL OR new.transaction_id = 0
						)
						BEGIN
							SELECT ' . DONATION_DATA_TABLE . '_seq.nextval
							INTO :new.transaction_id
							FROM dual;
						END;
						/

						CREATE TABLE ' . DONATION_PERKS_TABLE . " (
							perk_id number(8) NOT NULL,
							perk_title varchar2(100 char) DEFAULT '' ,
							perk_text clob DEFAULT '' ,
							perk_desc_bitfield varchar2(255 char) DEFAULT '' ,
							perk_desc_options number(11) DEFAULT '7' NOT NULL,
							perk_desc_uid varchar2(8 char) DEFAULT '' ,
							perk_order number(3) DEFAULT '0' NOT NULL,
							perk_active_date number(11) DEFAULT '0' NOT NULL,
							perk_expire_date number(11) DEFAULT '0' NOT NULL,
							CONSTRAINT pk_" . DONATION_PERKS_TABLE . ' PRIMARY KEY (perk_id)
						)
						/

						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_active_date ON ' . DONATION_PERKS_TABLE . ' (perk_active_date)
						/
						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_expire_date ON ' . DONATION_PERKS_TABLE . ' (perk_expire_date)
						/

						CREATE SEQUENCE ' . DONATION_PERKS_TABLE . '_seq
						/

						CREATE OR REPLACE TRIGGER t_' . DONATION_PERKS_TABLE . '
						BEFORE INSERT ON ' . DONATION_PERKS_TABLE . '
						FOR EACH ROW WHEN (
							new.perk_id IS NULL OR new.perk_id = 0
						)
						BEGIN
							SELECT ' . DONATION_PERKS_TABLE . '_seq.nextval
							INTO :new.perk_id
							FROM dual;
						END;
						/
						';
					$db->sql_query($sql);
				break;

				case 'mssql':
					$sql = 'CREATE TABLE ' . DONATION_DATA_TABLE . " (
								transaction_id mediumint(8) UNSIGNED NOT NULL auto_increment,
								txn_id varchar(18) DEFAULT '' NOT NULL,
								txn_type varchar(32) DEFAULT '' NOT NULL,
								confirmed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
								user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
								item_name varchar(128) DEFAULT '' NOT NULL,
								item_number varchar(128) DEFAULT '' NOT NULL,
								payment_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
								business varchar(128) DEFAULT '' NOT NULL,
								payment_status varchar(32) DEFAULT '' NOT NULL,
								payment_gross decimal(8,2) DEFAULT '' NOT NULL,
								payment_fee decimal(8,2) DEFAULT '' NOT NULL,
								payment_type varchar(16) DEFAULT '' NOT NULL,
								mc_currency varchar(16) DEFAULT '' NOT NULL,
								payment_date varchar(32) DEFAULT '' NOT NULL,
								payer_id varchar(16) DEFAULT '' NOT NULL,
								payer_email varchar(128) DEFAULT '' NOT NULL,
								payer_status varchar(16) DEFAULT '' NOT NULL,
								first_name varchar(64) DEFAULT '' NOT NULL,
								last_name varchar(64) DEFAULT '' NOT NULL,
								memo varchar(255) DEFAULT '' NOT NULL,
								PRIMARY KEY (transaction_id),
								KEY user_id (user_id),
								KEY txn_id (txn_id)
							) CHARACTER SET utf8 COLLATE utf8_bin;";
					$db->sql_query($sql);

					$sql = 'CREATE TABLE ' . DONATION_PERKS_TABLE . " (
								perk_id mediumint(8) UNSIGNED NOT NULL auto_increment,
								perk_title varchar(100) DEFAULT '' NOT NULL,
								perk_text mediumtext NOT NULL,
								perk_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
								perk_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
								perk_desc_uid varchar(8) DEFAULT '' NOT NULL,
								perk_order tinyint(3) DEFAULT '0' NOT NULL,
								perk_active_date int(11) UNSIGNED DEFAULT '0' NOT NULL,
								perk_expire_date int(11) UNSIGNED DEFAULT '0' NOT NULL,
								PRIMARY KEY (perk_id),
								KEY perk_active_date (perk_active_date),
								KEY perk_expire_date (perk_expire_date)
							) CHARACTER SET utf8 COLLATE utf8_bin;";
					$db->sql_query($sql);
				break;

				case 'firebird':
					$sql = 'CREATE TABLE ' . DONATION_DATA_TABLE . " (
							transaction_id INTEGER NOT NULL,
							txn_id VARCHAR(18) CHARACTER SET NONE DEFAULT '' NOT NULL,
							txn_type VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
							confirmed INTEGER DEFAULT 0 NOT NULL,
							user_id INTEGER DEFAULT 0 NOT NULL,
							item_name VARCHAR(128) CHARACTER SET NONE DEFAULT '' NOT NULL,
							item_number VARCHAR(128) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payment_time INTEGER DEFAULT 0 NOT NULL,
							business VARCHAR(128) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payment_status VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payment_gross DOUBLE PRECISION DEFAULT '' NOT NULL,
							payment_fee DOUBLE PRECISION DEFAULT '' NOT NULL,
							payment_type VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
							mc_currency VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payment_date VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payer_id VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payer_email VARCHAR(128) CHARACTER SET NONE DEFAULT '' NOT NULL,
							payer_status VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
							first_name VARCHAR(64) CHARACTER SET NONE DEFAULT '' NOT NULL,
							last_name VARCHAR(64) CHARACTER SET NONE DEFAULT '' NOT NULL,
							memo VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
						);;

						ALTER TABLE " . DONATION_DATA_TABLE . ' ADD PRIMARY KEY (transaction_id);;

						CREATE INDEX ' . DONATION_DATA_TABLE . '_user_id ON ' . DONATION_DATA_TABLE . '(user_id);;
						CREATE INDEX ' . DONATION_DATA_TABLE . '_txn_id ON ' . DONATION_DATA_TABLE . '(txn_id);;

						CREATE GENERATOR ' . DONATION_DATA_TABLE . '_gen;;
						SET GENERATOR ' . DONATION_DATA_TABLE . '_gen TO 0;;

						CREATE TRIGGER t_' . DONATION_DATA_TABLE . ' FOR ' . DONATION_DATA_TABLE . '
						BEFORE INSERT
						AS
						BEGIN
							NEW.transaction_id = GEN_ID(' . DONATION_DATA_TABLE . '_gen, 1);
						END;;

						CREATE TABLE ' . DONATION_PERKS_TABLE . " (
							perk_id INTEGER NOT NULL,
							perk_title VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
							perk_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
							perk_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
							perk_desc_options INTEGER DEFAULT 7 NOT NULL,
							perk_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
							perk_order INTEGER DEFAULT 0 NOT NULL,
							perk_active_date INTEGER DEFAULT 0 NOT NULL,
							perk_expire_date INTEGER DEFAULT 0 NOT NULL
						);;

						ALTER TABLE " . DONATION_PERKS_TABLE . ' ADD PRIMARY KEY (perk_id);;

						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_active_date ON ' . DONATION_PERKS_TABLE . '(perk_active_date);;
						CREATE INDEX ' . DONATION_PERKS_TABLE . '_perk_expire_date ON ' . DONATION_PERKS_TABLE . '(perk_expire_date);;

						CREATE GENERATOR ' . DONATION_PERKS_TABLE . '_gen;;
						SET GENERATOR ' . DONATION_PERKS_TABLE . '_gen TO 0;;

						CREATE TRIGGER t_' . DONATION_PERKS_TABLE . ' FOR ' . DONATION_PERKS_TABLE . '
						BEFORE INSERT
						AS
						BEGIN
							NEW.perk_id = GEN_ID(' . DONATION_PERKS_TABLE . '_gen, 1);
						END;;
						';
					$db->sql_query($sql);
				break;
			}

			$this->config_list();

			trigger_error(sprintf($user->lang['MOD_INSTALLED_SUCCESSFULLY'], $this->mod_data['version']));
		}
		else if (version_compare($this->mod_data['version'], $config['paypal_donation_mod'], '>'))
		{
			$this->config_list();

			trigger_error(sprintf($user->lang['MOD_UPDATED_SUCCESSFULLY'], $this->mod_data['version']));
		}

		return false;
	}

	function config_list()
	{
		global $config;

		// set some initial values, modified by the ACP Module
		$config_ary = array(
			array('paypal_send_pm', 1),
			array('paypal_address', $config['board_contact']),
			array('paypal_sandbox', 1),
			array('paypal_supporters_group_id', 1),
			array('paypal_supporters_group', 'Select Group'),
			array('paypal_style', 'prosilver'),
			array('paypal_default_currency', 'USD'),
			array('paypal_donate_minimum', 5),
			array('paypal_convert_percentage', 0.025),
			array('paypal_default_country', 'US'),
			array('paypal_sandbox_address', $config['board_contact']),
			array('paypal_debug', 0),
			array('paypal_logging', 1),
			array('paypal_founder_manage', 1),
		);

		foreach ($config_ary as $value)
		{
			if (!isset($config[$value[0]]))
			{
				set_config($value[0], $value[1]);
			}
		}

		set_config('paypal_donation_mod', $this->mod_data['version']);
	}

	function uninstall()
	{
	}
}

?>

Svar