phpbb.com profile link for phpBB3

Discuss the development of future releases of phpBB (phpBB 3.x minor releases) and MODing/Coding related questions.
Post Reply
User avatar
Stoker
Member
Member
Posts: 198
Joined: 14 May 2011, 20:54
Contact:

phpbb.com profile link for phpBB3

Post by Stoker »

Hello,

I was wondering if the phpbb.com profile link mod used here is available for the public?
Regards Stoker
PhpBB3 BBCodes
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpbb.com profile link for phpBB3

Post by RMcGirr83 »

I'll make it an release it as a mod if Evil <3 allows me as it was originally his mod. Igor, if you don't mind me taking it over could you forward to me, if you still have it, the zip for the mod? If not no biggie I'll just write it up. A sql and editing to three, or so, files should do it.
User avatar
Obsidian
Supporter
Supporter
Posts: 736
Joined: 13 May 2008, 15:20
Real name: Damian
Contact:

Re: phpbb.com profile link for phpBB3

Post by Obsidian »

I can try digging through the archives and see if I can find it...gimme a moment here.

EDIT: Got it.

Code: Select all

    ##############################################################
    ## MOD Title: phpBB.com Profile Link
    ## MOD Author: eviL<3 < [email protected] > (Igor Wiedler) http://phpbbmodders.net
    ## MOD Description: This MOD allows users to enter their phpBB.com user id, or username, wich will then link to their profile. It is very easy to change the boards url, so it can also be used for other boards than phpBB.com.
    ## MOD Version: 0.1.2
    ##
    ## Installation Level: Easy
    ## Installation Time: 30 minutes
    ## Files To Edit: memberlist.php
    ## viewtopic.php
    ## adm/style/acp_users_profile.html
    ## includes/functions.php
    ## includes/acp/acp_language.php
    ## includes/acp/acp_styles.php
    ## includes/acp/acp_users.php
    ## includes/ucp/ucp_profile.php
    ## language/en/common.php
    ## language/en/acp/styles.php
    ## styles/prosilver/imageset/imageset.cfg
    ## styles/prosilver/template/memberlist_view.html
    ## styles/prosilver/template/ucp_profile_profile_info.html
    ## styles/prosilver/template/viewtopic_body.html
    ## styles/prosilver/theme/buttons.css
    ## styles/prosilver/theme/colours.css
    ## styles/subsilver2/imageset/en/imageset.cfg
    ## styles/subsilver2/template/memberlist_view.html
    ## styles/subsilver2/template/ucp_profile_profile_info.html
    ## styles/subsilver2/template/viewtopic_body.html
    ## Included Files:
    ## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
    ## Generator: Phpbb.ModTeam.Tools (php)
    ##############################################################
    ## For security purposes, please check: http://www.phpbb.com/mods/
    ## for the latest version of this MOD. Although MODs are checked
    ## before being allowed in the MODs Database there is no guarantee
    ## that there are no security problems within the MOD. No support
    ## will be given for MODs not found within the MODs Database which
    ## can be found at http://www.phpbb.com/mods/
    ##############################################################
    ## Author Notes: This is really useful for phpBB-related Boards, as lots of the members will also be members at phpBB.com, possibly with an other name.
    ##
    ## I originally made this MOD for phpBB2, but also decided to make a phpBB3 version.
    ##
    ## There is an upgrade script from phpBB2 and an alternative image in the /contrib/ folder.
    ##
    ## Thanks once again to Highway of Life for the beautiful images!
    ##
    ## This MOD may take a while to install, and there may also be simpler ways of doing it, but this way you have full control over ther data (no custom profile fields), and it is also url- encoded correctly, because that could cause problems with special usernames (such as mine), if it isn't escaped.
    ##
    ## Don't forget to refresh the imagesets in the ACP after installation, and the theme for prosilver.
    ##
    ## TODO:
    ## - Upgrade from phpBB2
    ##############################################################
    ## MOD History:
    ##
    ## 2007-03-29 - Version 0.1.0
    ## -Initial release
    ##
    ## 2007-04-10 - Version 0.1.1
    ## -Hello prosilver
    ## -Changed some things around
    ##
    ## 2007-04-27 - Version 0.1.2
    ## -Updated image handling
    ##
    ##############################################################
    ## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
    ##############################################################

    #
    #-----[ SQL ]------------------------------------------
    #
    ALTER TABLE phpbb_users ADD user_phpbbcom VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
    #
    #-----[ OPEN ]------------------------------------------
    #
    memberlist.php
    #
    #-----[ FIND ]------------------------------------------
    #
    'SEARCH_IMG' => $user->img('icon_user_search', $user->lang['SEARCH']),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'PHPBBCOM_IMG' => $user->img('icon_contact_phpbbcom', 'PHPBBCOM'),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'LOCATION' => ($data['user_from']) ? $data['user_from'] : '',
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'U_PHPBBCOM' => (!empty($data['user_phpbbcom'])) ? phpbbcom_profile_url(htmlspecialchars_decode($data['user_phpbbcom'])) : '',
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    viewtopic.php
    #
    #-----[ FIND ]------------------------------------------
    #
    'WARN_IMG' => $user->img('icon_user_warn', 'WARN_USER'),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'PHPBBCOM_IMG' => $user->img('icon_contact_phpbbcom', 'PHPBBCOM'),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'foe' => $row['foe'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => $row['user_phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'www' => '',
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => '',
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'www' => $row['user_website'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => $row['user_phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'U_WWW' => $user_cache[$poster_id]['www'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'U_PHPBBCOM' => (!empty($user_cache[$poster_id]['phpbbcom'])) ? phpbbcom_profile_url(htmlspecialchars_decode($user_cache[$poster_id]['phpbbcom'])) : '',
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    adm/style/acp_users_profile.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <dl>
    <dt><label for="location">{L_LOCATION}:</label></dt>
    <dd><input type="text" id="location" name="location" value="{LOCATION}" /></dd>
    </dl>
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- mod : phpBB.com Profile Link -->
    <dl>
    <dt><label for="phpbbcom">{L_PHPBBCOM}:</label><br /><span>{L_PHPBBCOM_EXPLAIN}</span></dt>
    <dd><input type="text" id="phpbbcom" name="phpbbcom" value="{PHPBBCOM}" /></dd>
    </dl>
    <!-- fin mod : phpBB.com Profile Link -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    includes/functions.php
    #
    #-----[ FIND ]------------------------------------------
    #
    ?>
    #
    #-----[ BEFORE, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    /**
    * Returns the URL to a users phpBB profile
    * User id is either the users id, or his username
    *
    * @author eviL3 <[email protected]>
    * @version 0.1.1
    * @param mixed $user_id
    * @return string URL to profile
    */
    function phpbbcom_profile_url ($user_id)
    {
    //return 'http://www.phpbb.com/phpBB/profile.php?mode=viewprofile&amp;' . POST_USERS_URL . '=' . urlencode($user_id);
    return 'http://www.phpbb.com/community/memberlist.php?mode=viewprofile&amp;' . ((is_numeric($user_id)) ? 'u' : 'un') . '=' . urlencode($user_id);
    }
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    includes/acp/acp_language.php
    #
    #-----[ FIND ]------------------------------------------
    #
    , 'icon_contact_www'
    #
    #-----[ IN-LINE FIND ]------------------------------------------
    #
    , 'icon_contact_www'
    #
    #-----[ IN-LINE AFTER, ADD ]------------------------------------------
    #
    , 'icon_contact_phpbbcom'
    #
    #-----[ OPEN ]------------------------------------------
    #
    includes/acp/acp_styles.php
    #
    #-----[ FIND ]------------------------------------------
    #
    , 'icon_contact_www'
    #
    #-----[ IN-LINE FIND ]------------------------------------------
    #
    , 'icon_contact_www'
    #
    #-----[ IN-LINE AFTER, ADD ]------------------------------------------
    #
    , 'icon_contact_phpbbcom'
    #
    #-----[ OPEN ]------------------------------------------
    #
    includes/acp/acp_users.php
    #
    #-----[ FIND ]------------------------------------------
    #
    'location' => utf8_normalize_nfc(request_var('location', $user_row['user_from'], true)),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => request_var('phpbbcom', $user_row['user_phpbbcom']),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'location' => array('string', true, 2, 255),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => array('string', true, 0, 255),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'user_from' => $data['location'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'user_phpbbcom' => $data['phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'LOCATION' => $data['location'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'PHPBBCOM' => $data['phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    includes/ucp/ucp_profile.php
    #
    #-----[ FIND ]------------------------------------------
    #
    'location' => utf8_normalize_nfc(request_var('location', $user->data['user_from'], true)),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => request_var('phpbbcom', $user->data['user_phpbbcom']),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'location' => array('string', true, 2, 255),
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'phpbbcom' => array('string', true, 0, 255),
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'user_from' => $data['location'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'user_phpbbcom' => $data['phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ FIND ]------------------------------------------
    #
    'LOCATION' => $data['location'],
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    'PHPBBCOM' => $data['phpbbcom'],
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    language/en/common.php
    #
    #-----[ FIND ]------------------------------------------
    #
    ?>
    #
    #-----[ BEFORE, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    $lang = array_merge($lang, array(
    'PHPBBCOM' => 'phpBB.com Profile',
    'PHPBBCOM_EXPLAIN' => 'Enter your user id or your username from phpBB.com',
    ));
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    language/en/acp/styles.php
    #
    #-----[ FIND ]------------------------------------------
    #
    ?>
    #
    #-----[ BEFORE, ADD ]------------------------------------------
    #
    //-- mod : phpBB.com Profile Link ------------------------------------------------------------
    //-- add
    $lang = array_merge($lang, array(
    'IMG_ICON_CONTACT_PHPBBCOM' => 'phpBB.com Profile',
    ));
    //-- fin mod : phpBB.com Profile Link --------------------------------------------------------
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/imageset/imageset.cfg
    #
    #-----[ FIND ]------------------------------------------
    #
    img_icon_contact_www = icon_contact_www.gif*20*20
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    img_icon_contact_phpbbcom = icon_contact_phpbbcom.gif*20*49
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/template/memberlist_view.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <!-- IF U_WWW --><dt>{L_WEBSITE}:</dt> <dd><a href="{U_WWW}" title="{L_VISIT_WEBSITE}: {U_WWW}">{U_WWW}</a></dd><!-- ENDIF -->
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- IF U_PHPBBCOM --><dt>{L_PHPBBCOM}:</dt> <dd><a href="{U_PHPBBCOM}">{L_PHPBBCOM}</a></dd><!-- ENDIF -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/template/ucp_profile_profile_info.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <dd><input type="text" name="location" id="location" maxlength="255" value="{LOCATION}" class="inputbox" /></dd>
    </dl>
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- mod : phpBB.com Profile Link -->
    <dl>
    <dt><label for="phpbbcom">{L_PHPBBCOM}:</label><br /><span>{L_PHPBBCOM_EXPLAIN}</span></dt>
    <dd><input type="text" name="phpbbcom" id="phpbbcom" maxlength="255" value="{PHPBBCOM}" class="inputbox" /></dd>
    </dl>
    <!-- fin mod : phpBB.com Profile Link -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/template/viewtopic_body.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <!-- IF postrow.U_PM or postrow.U_EMAIL
    #
    #-----[ IN-LINE FIND ]------------------------------------------
    #
    -->
    #
    #-----[ IN-LINE BEFORE, ADD ]------------------------------------------
    #
    or postrow.U_PHPBBCOM
    #
    #-----[ FIND ]------------------------------------------
    #
    <!-- IF postrow.U_WWW --><li class="web-icon"><a href="{postrow.U_WWW}" title="{L_VISIT_WEBSITE}: {postrow.U_WWW}"><span>{L_WEBSITE}</span></a></li><!-- ENDIF -->
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- IF postrow.U_PHPBBCOM --><li class="phpbbcom-icon"><a href="{postrow.U_PHPBBCOM}" title="{L_PHPBBCOM}"><span>{L_PHPBBCOM}</span></a></li><!-- ENDIF -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/theme/buttons.css
    #
    #-----[ FIND ]------------------------------------------
    #
    .web-icon, .web-icon a { background: none top left no-repeat; }
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    .phpbbcom-icon, .phpbbcom-icon a { background: none top left no-repeat; }
    #
    #-----[ FIND ]------------------------------------------
    #
    ul.profile-icons li.web-icon { width: {IMG_ICON_CONTACT_WWW_WIDTH}px; height: {IMG_ICON_CONTACT_WWW_HEIGHT}px; }
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    ul.profile-icons li.phpbbcom-icon { width: {IMG_ICON_CONTACT_PHPBBCOM_WIDTH}px; height: {IMG_ICON_CONTACT_PHPBBCOM_HEIGHT}px; }
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/prosilver/theme/colours.css
    #
    #-----[ FIND ]------------------------------------------
    #
    .web-icon, .web-icon a { background-image: url("{IMG_ICON_CONTACT_WWW_SRC}"); }
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    .phpbbcom-icon, .phpbbcom-icon a { background-image: url("{IMG_ICON_CONTACT_PHPBBCOM_SRC}"); }
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/subsilver2/imageset/en/imageset.cfg
    #
    #-----[ FIND ]------------------------------------------
    #
    img_icon_contact_www = icon_contact_www.gif
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    img_icon_contact_phpbbcom = icon_contact_phpbbcom.gif
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/subsilver2/template/memberlist_view.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <tr>
    <td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_WEBSITE}: </td>
    <td><!-- IF U_WWW --><b><a class="genmed" href="{U_WWW}">{U_WWW}</a></b><!-- ENDIF --></td>
    </tr>
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- mod : phpBB.com Profile Link -->
    <!-- IF U_PHPBBCOM -->
    <tr>
    <td class="gen" align="{S_CONTENT_FLOW_END}" nowrap="nowrap">{L_PHPBBCOM}: </td>
    <td><b><a class="genmed" href="{U_PHPBBCOM}">{PHPBBCOM_IMG}</a></b></td>
    </tr>
    <!-- ENDIF -->
    <!-- fin mod : phpBB.com Profile Link -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/subsilver2/template/ucp_profile_profile_info.html
    #
    #-----[ FIND ]------------------------------------------
    #
    <td class="row2"><input class="post" type="text" name="location" size="30" maxlength="100" value="{LOCATION}" /></td>
    </tr>
    #
    #-----[ AFTER, ADD ]------------------------------------------
    #
    <!-- mod : phpBB.com Profile Link -->
    <tr>
    <td class="row1" width="35%"><b class="genmed">{L_PHPBBCOM}: </b><br /><span class="gensmall">{L_PHPBBCOM_EXPLAIN}</span></td>
    <td class="row2"><input class="post" type="text" name="phpbbcom" size="30" maxlength="100" value="{PHPBBCOM}" /></td>
    </tr>
    <!-- fin mod : phpBB.com Profile Link -->
    #
    #-----[ OPEN ]------------------------------------------
    #
    styles/subsilver2/template/viewtopic_body.html
    #
    #-----[ FIND ]------------------------------------------
    #
    {EMAIL_IMG}</a> <!-- ENDIF -->
    #
    #-----[ IN-LINE FIND ]------------------------------------------
    #
    {EMAIL_IMG}</a> <!-- ENDIF -->
    #
    #-----[ IN-LINE AFTER, ADD ]------------------------------------------
    #
    <!-- IF postrow.U_PHPBBCOM --><a href="{postrow.U_PHPBBCOM}">{PHPBBCOM_IMG}</a> <!-- ENDIF -->
    #
    #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
    #


I think the SQL may need updated though, as it needs a default value.
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpbb.com profile link for phpBB3

Post by RMcGirr83 »

Awesome!!

Got the image too?
User avatar
Obsidian
Supporter
Supporter
Posts: 736
Joined: 13 May 2008, 15:20
Real name: Damian
Contact:

Re: phpbb.com profile link for phpBB3

Post by Obsidian »

Uhhhm...no, might have to rip that from 'modders.

[img]http://phpbbmodders.net/board/styles/revolution/imageset/icon_contact_phpbbcom.gif[/img]
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpbb.com profile link for phpBB3

Post by RMcGirr83 »

Danke!!
User avatar
Obsidian
Supporter
Supporter
Posts: 736
Joined: 13 May 2008, 15:20
Real name: Damian
Contact:

Re: phpbb.com profile link for phpBB3

Post by Obsidian »

Remember to fix the SQL bug though, it needs a default value.
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpbb.com profile link for phpBB3

Post by RMcGirr83 »

I think I might have that covered ;)
User avatar
Mr. Bond
Member
Member
Posts: 89
Joined: 30 Mar 2008, 20:34
Real name: Bobby
Location: 127.0.0.1

Re: phpbb.com profile link for phpBB3

Post by Mr. Bond »

http://svn2.assembla.com/svn/evilmods/3 ... file_link/

Though I'm not sure if it's any different than the one Obsidian posted :?
Twitter • Ohloh • GitHub
User avatar
Stoker
Member
Member
Posts: 198
Joined: 14 May 2011, 20:54
Contact:

Re: phpbb.com profile link for phpBB3

Post by Stoker »

Obsidian wrote:Remember to fix the SQL bug though, it needs a default value.

How should the SQL look like with a default value?
Regards Stoker
PhpBB3 BBCodes
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6243
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpbb.com profile link for phpBB3

Post by RMcGirr83 »

Code: Select all

ALTER TABLE phpbb_users ADD user_phpbbcom VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''
User avatar
Stoker
Member
Member
Posts: 198
Joined: 14 May 2011, 20:54
Contact:

Re: phpbb.com profile link for phpBB3

Post by Stoker »

Thanks ;)
Regards Stoker
PhpBB3 BBCodes
User avatar
Stoker
Member
Member
Posts: 198
Joined: 14 May 2011, 20:54
Contact:

Re: phpbb.com profile link for phpBB3

Post by Stoker »

Moderator edit: The below information (according to the MOD author) is not correct.


I have installed it, but there are two bugs

First one in memberlist.php
This code that is added:

Code: Select all

//-- mod : phpBB.com Profile Link ------------------------------------------------------------
//-- add
         'PHPBBCOM_IMG'   => $user->img('icon_contact_phpbbcom', 'PHPBBCOM'),
//-- fin mod : phpBB.com Profile Link --------------------------------------------------------

must instead be:

Code: Select all

         //-- mod : phpBB.com Profile Link ------------------------------------------------------------
//-- add
         'PHPBBCOM_IMG'   => $user->img('icon_contact_phpbbcom', $user->lang['PHPBBCOM']),
//-- fin mod : phpBB.com Profile Link --------------------------------------------------------



and the biggie is in includes/ucp/ucp_profile.php
This code that is added:

Code: Select all

//-- mod : phpBB.com Profile Link ------------------------------------------------------------
//-- add
               'PHPBBCOM'   => $data['phpbbcom'],
//-- fin mod : phpBB.com Profile Link --------------------------------------------------------

must instead be:

Code: Select all

//-- mod : phpBB.com Profile Link ------------------------------------------------------------
//-- add
               'user_phpbbcom'   => $data['phpbbcom'],
//-- fin mod : phpBB.com Profile Link --------------------------------------------------------



The last bug I havent found a solution for. But it is not vital.
If you go to your profile and edit it after you have inserted your phpbb.com profile, the field is empty. It doesnt show the value you have set.
Last edited by Stoker on 13 Jan 2015, 00:00, edited 2 times in total.
Reason: Information is not correct
Regards Stoker
PhpBB3 BBCodes
Dicky
New member
New member
Posts: 1
Joined: 22 Sep 2006, 04:07

Re: phpbb.com profile link for phpBB3

Post by Dicky »

The username doesn't work very well.

D¡cky stores as D??cky
User avatar
Stoker
Member
Member
Posts: 198
Joined: 14 May 2011, 20:54
Contact:

Re: phpbb.com profile link for phpBB3

Post by Stoker »

Dicky, try this:
Open: includes/ucp/ucp_profile.php
Find:

Code: Select all

'phpbbcom'      => request_var('phpbbcom', $user->data['user_phpbbcom']),

Replace with:

Code: Select all

'phpbbcom'      => utf8_normalize_nfc(request_var('phpbbcom', $user->data['user_phpbbcom'], true)),

It works for me ;)
Regards Stoker
PhpBB3 BBCodes
Post Reply