[3.1][3.2][DEV] Referrals

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Get Involved
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
MrMoney1
Registered User
Posts: 4
Joined: Tue Dec 12, 2017 2:26 pm

Re: [DEV] Referrals

Post by MrMoney1 » Tue Feb 06, 2018 1:49 pm

dmzx wrote:
Tue Dec 12, 2017 5:23 pm

@dmzx
Now working

TheButcher2
Registered User
Posts: 422
Joined: Tue May 13, 2014 11:38 pm
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by TheButcher2 » Sat Mar 10, 2018 2:12 pm

Looks great I installed it and activated it, but I went to do a test join on my forum, there is no field on there to enter who referred you on the registration page, so how do members refer others and get credit for it.

My board url if anyone wants to check the registration page is https://www.sponsor.chat


Thanks

TheButcher2
Registered User
Posts: 422
Joined: Tue May 13, 2014 11:38 pm
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by TheButcher2 » Sun Apr 01, 2018 2:52 pm

Quick question, guests can not see the stats, only registered users and admins, is there a way for guests to sse the top referrers too.

Peace

TheButcher2
Registered User
Posts: 422
Joined: Tue May 13, 2014 11:38 pm
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by TheButcher2 » Sun May 20, 2018 11:56 pm

Is there a way to show the referral link to members when they log in to the board, without them having to go to the UCP > Referrals > link

so it shows directly in the footer of the page please.

User avatar
trandoductin
Registered User
Posts: 69
Joined: Mon Sep 26, 2016 4:11 am

Re: [3.1][3.2][DEV] Referrals

Post by trandoductin » Wed Jul 11, 2018 3:32 pm

Thank you so much for creating this extension.
I tried it yesterday (without creating contests) because basic functions would work for me an I am happy with it.

I also have Ultimate Points extension so I wanted to add 1,200 points to referrer for each referral.
I found the code that updated referral count after a user is added and simply added simple code to update/add the points there in the same SQL statement.
More details on How I added ultimate points for referrals extension

User avatar
trandoductin
Registered User
Posts: 69
Joined: Mon Sep 26, 2016 4:11 am

Re: [3.1][3.2][DEV] Referrals

Post by trandoductin » Wed Jul 11, 2018 4:17 pm

TheButcher2 wrote:
Sun Apr 01, 2018 2:52 pm
Quick question, guests can not see the stats, only registered users and admins, is there a way for guests to sse the top referrers too.

Peace
I made this change

totallybeautiful
Registered User
Posts: 60
Joined: Tue Mar 13, 2018 4:24 pm

Re: [3.1][3.2][DEV] Referrals

Post by totallybeautiful » Thu Jul 19, 2018 2:41 am

Is this extension now executable? It has been on DEV since 2016.

User avatar
dmzx
Registered User
Posts: 730
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by dmzx » Thu Jul 19, 2018 7:12 am

Still in progress
dmzx-web.net - Need a Host? - Want to Donate

scriptman
Registered User
Posts: 37
Joined: Wed Aug 30, 2017 11:16 pm

Re: [3.1][3.2][DEV] Referrals

Post by scriptman » Sun Aug 26, 2018 9:02 pm

Could you please make this compatible with Ultimate Points?

king577
Registered User
Posts: 64
Joined: Mon Mar 01, 2010 7:28 pm

Re: [3.1][3.2][DEV] Referrals

Post by king577 » Mon Aug 27, 2018 12:05 am

scriptman wrote:
Sun Aug 26, 2018 9:02 pm
Could you please make this compatible with Ultimate Points?
http://www.gimplearn.net/viewtopic.php/ ... f=5&t=1610
Sorry for the mistakes I do from time to time in English. This is not my native language. I am trying to improve my English, so please notify me about any mistakes I make. Thanks! :)

User avatar
Restless Rancor
Registered User
Posts: 184
Joined: Tue Sep 18, 2018 1:51 pm

Re: [3.1][3.2][DEV] Referrals

Post by Restless Rancor » Wed Sep 19, 2018 2:35 pm

Hi, thanks for this extension. I understand it's still in development but have a couple of questions/requests/suggestions after testing.
  • If a user is deleted the referral is not changed. Is it possible to have an option to remove referrals if a member is deleted, even if it's only an option in the ACP to delete a specific referal? For example I made a test user to refer and deleted that user once I confirmed it to be working but now I would have to go into the database to delete the referral. Another example would be if a member abuses the system an administrator can easily remove the referral in the ACP.
  • Is it possible to have the referral counts to link to a list of members that person has referred, so members can see who referred who?
  • Is it possible to have "Referred by" on the profile page, to show who referred the member who's profile you are viewing?
I'm looking forward to tracking the development of this extension!

Thanks
These aren't the droids you're looking for...
My Extensions and Snippets (Ref link)

User avatar
dmzx
Registered User
Posts: 730
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by dmzx » Mon Oct 01, 2018 7:14 am

Restless Rancor wrote:
Wed Sep 19, 2018 2:35 pm
Hi, thanks for this extension. I understand it's still in development but have a couple of questions/requests/suggestions after testing.
  • If a user is deleted the referral is not changed. Is it possible to have an option to remove referrals if a member is deleted, even if it's only an option in the ACP to delete a specific referal? For example I made a test user to refer and deleted that user once I confirmed it to be working but now I would have to go into the database to delete the referral. Another example would be if a member abuses the system an administrator can easily remove the referral in the ACP.
  • Is it possible to have the referral counts to link to a list of members that person has referred, so members can see who referred who?
  • Is it possible to have "Referred by" on the profile page, to show who referred the member who's profile you are viewing?
I'm looking forward to tracking the development of this extension!

Thanks
Will look into these requests.
dmzx-web.net - Need a Host? - Want to Donate

User avatar
Restless Rancor
Registered User
Posts: 184
Joined: Tue Sep 18, 2018 1:51 pm

Re: [3.1][3.2][DEV] Referrals

Post by Restless Rancor » Mon Oct 01, 2018 7:23 am

Thanks! 8-)
These aren't the droids you're looking for...
My Extensions and Snippets (Ref link)

User avatar
3Di
Registered User
Posts: 13120
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by 3Di » Sat Oct 06, 2018 11:11 pm

Not compatible with ONLY_FULL_GROUP_BY, to reproduce go viewing stats in contests (ACP).
General Error
SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bb.phpbb_referrals.referral_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT * , COUNT(referrer_username) AS referrals_count FROM phpbb_referrals LEFT JOIN phpbb_users ON referral_username=username WHERE referral_since BETWEEN 1538867101 AND 1541718318 AND user_posts >= 2 GROUP BY referrer_username ORDER BY referrals_count DESC
Admin controller

Code: Select all

			case 'stats':

				$this->template->assign_vars(array(
					'VIEW_STATS'	=> true,
				));

				$sql = 'SELECT * ,
					COUNT(referrer_username) AS referrals_count
					FROM ' . $this->referral_table . '
						LEFT JOIN ' . USERS_TABLE . '
						ON referral_username=username
					WHERE referral_since
					BETWEEN ' . $start_date . ' AND ' . $end_date . '
						AND user_posts >= ' . $ref_min_posts . '
					GROUP BY referrer_username
					ORDER BY referrals_count DESC';
				$result = $this->db->sql_query($sql);
Changing this line

Code: Select all

GROUP BY referrer_username
to

Code: Select all

GROUP BY user_id, referral_id, referrer_username
seems to do the trick, have a look.
:game_die: The new Dice Roller extension for phpBB 3.2 is out! :game_die:

Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
dmzx
Registered User
Posts: 730
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands
Contact:

Re: [3.1][3.2][DEV] Referrals

Post by dmzx » Sun Oct 07, 2018 5:00 am

3Di wrote:
Sat Oct 06, 2018 11:11 pm
Not compatible with ONLY_FULL_GROUP_BY, to reproduce go viewing stats in contests (ACP).
General Error
SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bb.phpbb_referrals.referral_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT * , COUNT(referrer_username) AS referrals_count FROM phpbb_referrals LEFT JOIN phpbb_users ON referral_username=username WHERE referral_since BETWEEN 1538867101 AND 1541718318 AND user_posts >= 2 GROUP BY referrer_username ORDER BY referrals_count DESC
Admin controller

Code: Select all

			case 'stats':

				$this->template->assign_vars(array(
					'VIEW_STATS'	=> true,
				));

				$sql = 'SELECT * ,
					COUNT(referrer_username) AS referrals_count
					FROM ' . $this->referral_table . '
						LEFT JOIN ' . USERS_TABLE . '
						ON referral_username=username
					WHERE referral_since
					BETWEEN ' . $start_date . ' AND ' . $end_date . '
						AND user_posts >= ' . $ref_min_posts . '
					GROUP BY referrer_username
					ORDER BY referrals_count DESC';
				$result = $this->db->sql_query($sql);
Changing this line

Code: Select all

GROUP BY referrer_username
to

Code: Select all

GROUP BY user_id, referral_id, referrer_username
seems to do the trick, have a look.
Will check it.
dmzx-web.net - Need a Host? - Want to Donate

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: davidyin, Gubkin, mastnacek and 33 guests