[Released] Use Custom Profile Fields anywhere

[Gonculator]

MOD Title: Use Custom Profile Fields anywhere
MOD Author: King Rhyono
MOD Description: Allows the use of custom profile fields anywhere.

Format:
CUSTOM_(field identification)_VALUE
CUSTOM_(field name)_NAME
If there are spaces in your identification/name, remove them.

In: includes/functions.php

Find

Code: Select all

        'A_COOKIE_SETTINGS'        => addslashes('; path=' . $config['cookie_path'] . ((!$config['cookie_domain'] || $config['cookie_domain'] == 'localhost' || $config['cookie_domain'] == '127.0.0.1') ? '' : '; domain=' . $config['cookie_domain']) . ((!$config['cookie_secure']) ? '' : '; secure')),
    )); 

After, add

Code: Select all


    // Begin CPFs Anywhere MOD - King Rhyono
    $user_id = $user->data['user_id'];
    $sql = 'SELECT * 
        FROM phpbb_profile_fields_data
        WHERE user_id ='.$user_id;
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    if (!empty($row)) {
        foreach($row as $key => $field) {
            $template->assign_vars(array("CUSTOM".str_replace(" ", "", ltrim(strtoupper($key), "PF"))."_VALUE" => $row[$key]));
        }                
    }
    $db->sql_freeresult($result);
    $sql = 'SELECT lang_name FROM phpbb_profile_lang';
    $result = $db->sql_query($sql);
    while($row = $db->sql_fetchrow($result)){
        $template->assign_vars(array("CUSTOM_".str_replace(" ", "", strtoupper($row['lang_name']))."_NAME" => $row['lang_name']));
    }
    $db->sql_freeresult($result);
    // End CPFs Anywhere MOD
 

MOD Version: 1.0.00
MOD Status: Released

Tested on phpBB version: 3.0.8
Released: 03 Jan 2011

Installation Level: easy
Installation Time: ~ 2 Minutes

This is an automated message posted by STG’s MOD Manager version 0.2.0

[duesmandella]

What do you mean display them anywheres? any pics or idea's?

[King Rhyono]

Displaying them anywhere has limited uses, using them anywhere is quite a bit more useful. You can fetch the name and/or value of any custom field. One person wanted to give his users the option to choose the logo they see. By making logo a select type and then using {CUSTOM_LOGO_VALUE} in place of a logo, it will dynamically change per user's preferences.

[duesmandella]

so if i wanted to do a mouseover on someones username, it could show up on the mouse over as their real name(custom profile field)
i dont know im confused lol

[King Rhyono]

In most places you'd want to do that (i.e. profile, topics, memberlist) you can already do that. If you don't understand the application of this, then you probably don't need it.

[duesmandella]

In most places you'd want to do that (i.e. profile, topics, memberlist) you can already do that. If you don't understand the application of this, then you probably don't need it.

You never need half these things going on, but if its cool and improves a forum, then its worth looking into

[Mess]

Neat, thanks.

[jdrechsler]

Isn't there a way to chose the table, instead of hard coding the table name like in the code above?

[King Rhyono]

This is a mod for custom profile fields. There is only one custom profile fields table. There isn't any good reason not to hard code it.

[Sniper_E]

May I add... custom profile fields are setup by default to show in the user profile, viewtopic and memberlist.
If you want custom profile fields to show up anywhere else, they have to be hard codded in somewhere.