[3.2][3.3][DEV] phpBB friends online - extended

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!
Anti-Spam Guide
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)
Post Reply
User avatar
Steve
Registered User
Posts: 1089
Joined: Tue Apr 07, 2009 7:48 pm
Location: UK ,up north!!
Name: Steven Clark
Contact:

[3.2][3.3][DEV] phpBB friends online - extended

Post by Steve »

Extension Name: phpBB friends online - extended
Author: Steve
Extension Version: 0.8.0-dev

Features:
  • You can now:
    • be mutual friends.
    • Receive notification of friend added.
    • Receive notification of friends new topics.
    • List your friends, your friend requests and friend requests on index page and profile.
    • Highlight friends online.
    • Add friends from view topic/private message.
Requirements:
  • phpBB 3.2.0 >
  • Zebra/Friends modules enabled
  • php 7.1 >
Download: This extension is still in development! Click
Screenshots:.............

User options:
Notification options board: ucp > board preferences > Edit notification options.
Notification option friend: visit friends profile or view one of there topics.
Last edited by Steve on Thu Feb 20, 2020 4:47 pm, edited 1 time in total.

User avatar
eunaumtenhoid
Registered User
Posts: 941
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by eunaumtenhoid »

what would be Zebra / Friends modules enabled?
when i update my board to 3.3 i will be happy to test it!

when making a friend request, is it automatically accepted or will they only be friends if the user accepts the request? (like facebook)
the notification option is for each friend ??

notifications could stay in the profile in global notifications would be more organized

nice work ty dude!
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes

User avatar
Steve
Registered User
Posts: 1089
Joined: Tue Apr 07, 2009 7:48 pm
Location: UK ,up north!!
Name: Steven Clark
Contact:

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by Steve »

Standard phpBB modules ;)
User Control Panel.png

Midway
Registered User
Posts: 32
Joined: Tue Dec 09, 2014 8:02 pm

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by Midway »

Hi steve,

In language/en/common.php
I see tthis

Code: Select all

Firends Online
correct language is

Code: Select all

Friends Online
In language/en/info_ucp_friendsonline.php
I see tthis

Code: Select all

A freind creates a new topic
correct language is

Code: Select all

A friend creates a new topic
in ext/steve/friendsonline/styles/all/template/friends_online.html
I see

Code: Select all

<h3>{{ lang('FRIENDS') }}</h3>
you don't have language key for FRIENDS

;)

User avatar
eunaumtenhoid
Registered User
Posts: 941
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by eunaumtenhoid »

I did a quick test and the ext proposal is excellent!
BUT
a detail that would make the system of friends fantastic would be a FRIENDSHIP REQUEST!
currently the system works like this: I add you as a friend and that's it!

but this could be a request and only when the other user accepts the friend then yes the 2 would be friends (basically as with facebook)

understood? no more nice work!
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes

User avatar
Steve
Registered User
Posts: 1089
Joined: Tue Apr 07, 2009 7:48 pm
Location: UK ,up north!!
Name: Steven Clark
Contact:

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by Steve »

I will be adding requests in next release.

User avatar
Hero.73
Registered User
Posts: 62
Joined: Fri Feb 14, 2020 8:27 pm
Location: Germany

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by Hero.73 »

ups not work

Code: Select all

SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'phpbb.u.username_clean' which is not in SELECT list; this is incompatible with DISTINCT [3065]

SQL

SELECT DISTINCT z.*, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline, u.user_id, u.username, u.user_colour, u.user_lastvisit, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height FROM (phpbb_3users u CROSS JOIN phpbb_3zebra z) LEFT JOIN phpbb_3sessions s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = 2 AND u.user_id = z.zebra_id AND z.friend = 1 AND u.user_id <> 1 GROUP BY z.zebra_id, u.user_id, u.username_clean, u.user_colour, u.username ORDER BY u.username_clean ASC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/steve/friendsonline/core/functions.php
LINE: 251
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/steve/friendsonline/event/main_listener.php
LINE: 66
CALL: steve\friendsonline\core\functions->mutual_friends()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: steve\friendsonline\event\main_listener->friends_online()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 243
CALL: phpbb\event\dispatcher->trigger_event()

User avatar
warmweer
Jr. Extension Validator
Posts: 4281
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by warmweer »

Hero.73 wrote: ↑
Thu Feb 20, 2020 10:36 pm
ups not work
@Hero.73
You are a relatively new user of phpBB. I suggest you stick to tried and tested validated extensions and stay clear of extensions in development until you know how to recover your board if something seriously goes wrong. If you do need to experiment, do it on a separate copy which you can discard and replace any time if necessary.
We should embrace problems, without which there wouldn't be any solutions.

User avatar
Steve
Registered User
Posts: 1089
Joined: Tue Apr 07, 2009 7:48 pm
Location: UK ,up north!!
Name: Steven Clark
Contact:

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by Steve »

Hero.73 wrote: ↑
Thu Feb 20, 2020 10:36 pm
ups not work

Code: Select all

SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'phpbb.u.username_clean' which is not in SELECT list; this is incompatible with DISTINCT [3065]

SQL

SELECT DISTINCT z.*, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline, u.user_id, u.username, u.user_colour, u.user_lastvisit, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height FROM (phpbb_3users u CROSS JOIN phpbb_3zebra z) LEFT JOIN phpbb_3sessions s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = 2 AND u.user_id = z.zebra_id AND z.friend = 1 AND u.user_id <> 1 GROUP BY z.zebra_id, u.user_id, u.username_clean, u.user_colour, u.username ORDER BY u.username_clean ASC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/steve/friendsonline/core/functions.php
LINE: 251
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/steve/friendsonline/event/main_listener.php
LINE: 66
CALL: steve\friendsonline\core\functions->mutual_friends()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: steve\friendsonline\event\main_listener->friends_online()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 243
CALL: phpbb\event\dispatcher->trigger_event()
This has been fixed in next release.

User avatar
eunaumtenhoid
Registered User
Posts: 941
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][3.3][DEV] phpBB friends online - extended

Post by eunaumtenhoid »

Steve wrote: ↑
Tue Feb 18, 2020 8:05 am
I will be adding requests in next release.
nice, it would be great if the ext gave an UPGRADE to the phpbb friends system which has always been very simple.
with:
the list of friends showing with nick and avatar
buttons to add as friend or foe
setting to block profile to be shown only to friends
PM block system too


these would be just some examples for an advanced profile friends

ty for work
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes

Post Reply

Return to β€œExtensions in Development”