MentalMaze wrote:psprofi wrote:is there an german translation for the mod?
No, no one has offered and I am not able to do so. Would you be interested?
i don't think so.
chattalk wrote: i just realised that for guests that post.. theres still a refer link for them in the post.. how does that work tho ? .. mayb make it so that thrs no link for guests
bbus3r wrote: just want to report that it's not easymod compatible.
bbus3r wrote: just want to report that it's not easymod compatible.
Code: Select all
#-----[ SQL ]------------------------------------------
# If you have another Pre-Fix, please change it.
#
CREATE TABLE phpbb_refer_plus (
rp_id mediumint(8) unsigned NOT NULL auto_increment,
ruid varchar(7) NOT NULL default '0',
nuid 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,
ruid varchar(7) NOT NULL default '0',
nuid 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', '-1' );
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', '1' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_nuid_posts', '0' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_posts_allowed', '9' );
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 Referrers:' );
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, use this url:' );
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ( 'rp_now_time', '= the 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_url', 'http://yourdomain.com/forum' );
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 board. If you do not wish to have your account deleted, 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.' );
miraclemagic wrote: I need a little help on the first step of installing this; the SQL (my weakness).
I really have no Idea how to do this with PhpMyAdmin. Can anyone explain this step by step? It would be GREATLY appreciated. Thanks.
Code: Select all
Could Not Update User Gold
DEBUG MODE
SQL Error : 1054 Unknown column 'user_gold' in 'field list'
UPDATE phpbb_users SET user_gold = user_gold + 1000 WHERE user_id = ''
Line : 792
File : usercp_register.php
miraclemagic wrote: Help, this error comes up when registering as a new user:
What should I do? Also, how can I change what the links at the top (view profile, contact admin) say? I want to change the view profile link to say Referral Center.Code: Select all
Could Not Update User Gold DEBUG MODE SQL Error : 1054 Unknown column 'user_gold' in 'field list' UPDATE phpbb_users SET user_gold = user_gold + 1000 WHERE user_id = '' Line : 792 File : usercp_register.php
MentalMaze wrote: For the user_gold error if you do no have cash mod, disable rewards, this will solve the error.
I have not set it to change what the links say so you would need to do that manually in overall_header and page_header.
miraclemagic wrote:MentalMaze wrote: For the user_gold error if you do no have cash mod, disable rewards, this will solve the error.
Thanks, it works!
I have not set it to change what the links say so you would need to do that manually in overall_header and page_header.
What do I have to edit in those pages to change it?
Thanks again.
Code: Select all
<tr>
<td height="25" align="center" valign="top" nowrap="nowrap">
<span class="mainmenu">
<!-- BEGIN switch_user_rp_invite -->
<a href="{U_INVITE}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{L_INVITE}" hspace="3" />{L_INVITE}</a>
<!-- END switch_user_rp_invite -->
<!-- BEGIN switch_user_rp_header -->
<a href="{U_REWARD}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_TOP}" hspace="3" />{L_TOP}</a> <a href="{U_VPROF}{PROFILE_ID}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_VPROF}" hspace="3" />{L_VPROF}</a> <a href="{U_CONTADM}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{L_CONTADM}" hspace="3" />{L_CONTADM}</a> </span>
<!-- END switch_user_rp_header -->
</td>
</tr>
Code: Select all
<tr>
<td height="25" align="center" valign="top" nowrap="nowrap">
<span class="mainmenu">
<!-- BEGIN switch_user_rp_invite -->
<a href="{U_INVITE}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{L_INVITE}" hspace="3" />{L_INVITE}</a>
<!-- END switch_user_rp_invite -->
<!-- BEGIN switch_user_rp_header -->
<a href="{U_REWARD}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_TOP}" hspace="3" />{L_TOP}</a> <a href="{U_VPROF}{PROFILE_ID}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="Referral Center" hspace="3" />Referral Center</a> <a href="{U_CONTADM}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{L_CONTADM}" hspace="3" />{L_CONTADM}</a> </span>
<!-- END switch_user_rp_header -->
</td>
</tr>