Com_registration> Sending Extra fields values in admin notifications

[yiannisK]

Hi there, long time to see 

I am trying to do the following but i am doing something wrong

I put an extra field in User named for example: Preferred Colour
This field is required from the registration form.
The users are activated manually.

So when Elxis sends me the email for unable the new user, gives me the following data

   A new user has registered at EXAMPLE.com.
   This email contains their details:
   
   Name - yiannis kottaropoulos
   e-mail - test@test.com
   Username - yiannis

   Please do not respond to this message as it is automatically generated and is for information purposes only.

I checked the core files and i found that there are 2 files implemented for this notification email

components/ com_registration/ registration.php
language/ english/ english.pref.php

In language file i added the following in line 46

Name - %s
e-mail - %s
Username - %s
Favorite colour - %s

In registration.php i think that i have to add in line 394 the value from the database
In database this value is in elx_users_extra table with extraid=1

How can i call this value, something like this  ?!

         $message2 = sprintf($prlang->lng->_ASEND_MSG, $adminName2, $mainframe->getCfg('sitename'), $row->name, $email, $username, $extraid1);

The sent mail is configured but the extra field value is missing

Name - yiannis kottaropoulos
e-mail - test@test.com
Username - yiannis
Favorite colour - 

[yiannisK]

Anyone

[datahell]

See how extra fields are retrieved from the database and displayed to the visitor at component users (task profile).
This should be your guide.

[yiannisK]

Ok got it 
Thanks