Code: Alles auswählen
#-----[ SQL ]------------------------------------------
# If you do not know how to do the below SQL dump, than you will need to download, install & use:
# MySQL: phpMyAdmin ( http://www.phpmyadmin.net/ )
# PostgreSQL: PostgreSQL Manager ( http://ems-hitech.com/pgmanager/ )
CREATE TABLE phpbb_referral (
referral_id mediumint(8) unsigned NOT NULL auto_increment,
ruid mediumint(8) unsigned NOT NULL default '0',
nuid mediumint(8) unsigned NOT NULL default '0',
referral_time varchar(10) NOT NULL default '',
KEY referraler_id (referral_id)
) TYPE=MyISAM;
INSERT INTO phpbb_referral VALUES (1, 2, 2, '1023594440');
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'referral_id', '2' );
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'referral_enable', '1' );