problem with calling exfra field value

[vojodi]

Hi, I am a new user in Elxis and many thanks from Elxis team, Datahell, all members and dear Farhad Sakhaei for persian translation.
I Have a problem…
I can call the user details to content from this script:
<?php
global $my;
if ($my->name != '') return $my->name;
?>
And it works fine.
But I have created some extra field as (phone, address and etc.).
I don’t know how I can call these field values to my content or forms.
This is the form named your details, in user menu.
<td><input class="inputbox" type="text" name="name" value="vojodi" size="40"
……..
<td colspan="2"><span style="width:130px;">tel*: </span><input type="text" name="efield[2]" value="" maxlength="50" id="req2">
……..
There is a difference between main registration form and extra field.
Extra field name is (efield[2]) not problem. But I will call this value and can not.

[datahell]

See function profile in component user.
File: components/com_user/user.php

I paste here the relative lines:

Code: (php) [Select]

<?php 
$usrfields = explode("|", $row->extrafields);

    if (( count($usrfields) > 0) && (trim($usrfields) != &#39;&#39; ) ) {
//$ufields is an array having as key the extraid and value the extra field value for the selected user
$ufields = array();
foreach ($usrfields as $usrfield) {
$uf = preg_split("/[\=]/", $usrfield, 2);
$ufid = intval($uf[0]); //if invalid then extraid=0
        $ufval = preg_split(&#39;/[\/]+/&#39;, $uf[1], -1, PREG_SPLIT_NO_EMPTY);
        if ( count($ufval) < 1 ) { $ufval = array(&#39;&#39;); }

if (($ufid != 0) && ($ufid != &#39;&#39;)) {
$ufields[$ufid] = $ufval;
}
}

    $query = "SELECT extraid, name FROM #__users_extra WHERE published=&#39;1&#39;"
    ."\n AND profile=&#39;1&#39; AND etype<>&#39;hidden&#39; ORDER BY ordering ASC";
$database->setQuery( $query );
$exxs = $database->loadObjectList();

     for ($i = 0; $i<count($exxs); $i++) {
     $exx = &$exxs[$i];
$eid = $exx->extraid;
     if ( isset($ufields[$eid]) && eUTF::utf8_trim($ufields[$eid][0]) != &#39;&#39; ) {
     $lists[&#39;extra&#39;] .= &#39;<tr><td><strong>&#39;.$exx->name.&#39;:</strong></td><td>&#39;.implode(&#39;, &#39;, $ufields[$eid]).&#39;</td></tr>&#39;._LEND;
     }
}
}
?>

[datahell]

User's extra fields is a string that contains user's extra fileds values in this format:

$row->extrafields = 'extrafield_id1=extrafield_value1|extrafield_id2=extrafield_value2|extrafield_id3=extrafield_value3|......';

As you see different Extra fields are separated by "|".

Now, If the extra field is a checkbox it might have more than one values. So the extrafield_value could have multiple values separated by "/".
Example contents of extrafield_value: "blue/red/pink"

Here is a sample real string:

$row->extrafields = '1=Athens|3=red/green|6=180|......';

Where the first field could be: City (id =1, value: Athens)
the second: Favorite colors: (id = 3, values: red and green)
and the third: height in cm: (id = 6, value: 180)

The names of the extra fields should be taken from the #__users_extra database table.

[Farhad Sakhaei]

Hi Mr. Vojoodi ,
Nice to see u here in Elxis world ...
I'll reply to your email soon 

[vojodi]

Thank you for the trouble and your reply.
Your intelligence was benefic and helpful.
But I have problem to understand.
Please pay attention, simply when I write:

<?php
global $my; return $my->name;?>

It shows the name of user, like (vojodi).
But when I Write:
<?php
global $my; return $my->efield2;?>

Doesn’t show my extrafield value.

[Farhad Sakhaei]

datahell
اشاره به یك جزء در
Elxis 2008
كرد كه درواقع وظیفه نمایش نیمرخی از كاربر (صفحه شخصی كاربر) داره
كدی كه ارائه كرد مربوط به این جزء هست

آقای وجودی عزیز ، اگر می تونید امشب با من تماس بگیرید ، من منتظر هستم

[datahell]

You can not access extra user fields from within the $my object! You can not even access them directly by a simple SQL query. You need to manipulate the contents of the "extrafields" database column located in #__users table the way I show you.

[vojodi]

I am grateful for your helps.
I will try this way and tell you results.