steve8675537 wrote:How could i go about having a referral system on my phpbb board? so my current members can reccomend other users and get credit for referring them like an affiliate of any site would.
I'm just looking for a few ideas?
thanks
steve
Code: Select all
#
#-----[ SQL ]------------------------------------------
# If you have another Pre-Fix, please change it.
# If a translation exists for your language use the lang_yourlang_install.txt to install the SQL
#
CREATE TABLE phpbb_refer_plus (
rp_id mediumint(8) unsigned NOT NULL auto_increment,
refer_id varchar(7) NOT NULL default '0',
refer_new varchar(7) NOT NULL default '0',
rp_time varchar(10) NOT NULL default '',
PRIMARY KEY (rp_id)
) TYPE=MyISAM;
INSERT INTO phpbb_refer_plus VALUES (1, 2, 2, '1115859081');
CREATE TABLE phpbb_refer_top (
rp_id mediumint(8) unsigned NOT NULL auto_increment,
refer_id varchar(7) NOT NULL default '0',
refer_new varchar(7) NOT NULL default '0',
rp_time varchar(10) NOT NULL default '',
PRIMARY KEY (rp_id)
) TYPE=MyISAM;
INSERT INTO phpbb_refer_top VALUES (1, 2, 2, '1105474506');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_default_id', '0' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_enable', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_rtop_enable', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_rewards_enable', '0' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_refer_new_posts', '5' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_posts_allowed', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_gold', '1000' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_top', '10' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_time', 'Current Referrals' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_timem', 'Life Time Referrals' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_reward', 'user_gold' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_top10_list', 'Top 10 Referrals' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_top10_list_explain', 'All Time Top 10 List of Members Who Have Referred New Members.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_life_time', '= the Number of Friends You have Referred. To Invite a Friend and Get Credits on Your Account, Please visit the:' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_now_time', '= the Total Number of Friends You have Referred During our Current Promotion.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_top_list_enabled', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_header', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_invite', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_email', 'We are removing members from our database that are no longer active on our forum. If you wish to keep your account active, please visit our site and your account will not be de-activated.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_board', 'About forum.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_invite_header', 'Invite a Friend' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_invite_friend', 'Send Emails to Invite Friends to Join this Forum.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_top_now_list', 'Current Referrals Top 10 List of Members Who Have Referred New Members to our forum .' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_admin_id', '2' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_life_time_rc', '= the Total Number of Friends You have Referred to our forum.' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_rewards', 'Current Rewards' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_rewards_explain', '= Your Rewards Total for Referring New Members!' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_referc_header', 'Referral Center' );