adding profile fields

I can't speak to the query since I haven't dealt with the core profile module, but I suggest not putting it in the .tpl file. It's better to put that sort of thing in _phptemplate_variables and create a variable to use in your .tpl file.

Michelle

Nothing further since my answer... Marking fixed.

Michelle

I believe that user_stats module holds promise for helping to provide user stats/profile/etc information. The module is clean and simple and should be able to be dropped right into advanced_forum.

http://drupal.org/project/user_stats

I've already looked at that module and it duplicates a lot of what I already do.

Michelle

Is it possible to post an example of this, placed into the _phptemplate_variables function? Is this the same one that you add to the theme to get it to call advanced forum in the first place?

Many thanks,
Gareth

When replying to closed issues, please set them active again. If I didn't get these by email, I never would have seen this.

Yes, that's the same function where the advforum call is. That's the function that prepares variables for the templates. In that example, you'd set $vars['location'] = $location.

Michelle

Again, thanks for the quick response (you must be sick of me by now) and sorry I didn't set this to active - I kind of figured the system did it automatically without giving it a thought.

However, I can't quite get this to work, and am sure something is adrift.

in template.php

   function _phptemplate_variables($hook, $variables = array()) {
  if (module_exists('advanced_forum')) {
    $variables = advanced_forum_addvars($hook, $variables);
      $sql = "SELECT value FROM profile_values WHERE (uid = %d) AND (fid = 6)"; 
      $result = db_query($sql,$node->uid);
      $location = db_fetch_object($result);
      $variables['location'] = $location;
   return $variables;  
}

Is set. I'm not sure that I'm setting the %d or $node-> uid corretly though - are these sent through by default, or globally available to the system? I have checked, and 6 is the correct fid, and is populated for at least 1 user.

In forum-thread.tpl.php I have:

     <?php if (isset($location)) { ?> 
         <div class="author-points">
            <?php print t('Location:') . ' ' . $location ?>
        </div>
        <?php } ?>

Which was cannibalised from another variable. Something is working somehow as "Location:" is printed for all users (even those who have not entered a location), but nothing follows it; which leads me to believe the SQL is not returning what I think it is.

Do you have any further suggestions as to what could be coming adrift here?

Many thanks,
Gareth

OK, I have a fix ~ish, but I can't explain it. Derived from knowing far too much perl and having a lucky guess.

When doing the above SQL query directly from the template, "Object" is produced. Mapping that Object to value gives the location. Note that this only works when doing the mapping in the forum-thread.tpl.php file; in the function _phptemplate_variables section of the template I cannot get it to return anything, suggesting that the uid is not being set properly.

My fix is

       <?php // BEGIN AUTHOR LOCATION DISPLAY ?>
            <div class="author-points">
            <?php
            $sql = "SELECT value FROM profile_values WHERE (uid = %d) AND (fid = 6)";
            $result = db_query($sql,$userid);
            $location = db_fetch_object($result);
            print t('Location:') . ' ' . $location->value;
            ?>
        </div>
        <?php // END AUTHOR LOCATION DISPLAY ?>

I'd still like to know the proper syntax to do this in the proper function, but for now it's working, and I'll take working over elegant and proper any day.

Gareth

Sorry, I hadn't looked that close at his SQL. You need to change $node->uid to $vars['node']->uid. You get $node in the .tpl when $vars['node'] is processed.

Michelle

The code in my template.php file now reads

<?php 

  function _phptemplate_variables($hook, $variables = array()) {
  if (module_exists('advanced_forum')) {
    $variables = advanced_forum_addvars($hook, $variables);
      $sql = "SELECT value FROM profile_values WHERE (uid = %d) AND (fid = 6)"; 
      $result = db_query($sql,$variables['node']->uid);
      $location = db_fetch_object($result);
      $variables['location'] = $location;
   return $variables;  

?>

Have I got this right?

The template uses $variables instead of $vars (is this confusing things?), but this still returns nothing :(

Thanks again,
Gareth

Well, I don't know that much about using SQL in Drupal so I'm just assuming his SQL works. Unless the OP comes back, I'm not sure there's anythign else I can do. This isn't an advforum issue...

Michelle

I guess the OP never came back. At any rate, you can access the user's profile fields from the .tpl file through the variable I added a while back.

Michelle

$profile - Profile object from core profile. Usage: $profile->fieldname

this doesn't work for me neither

That doesn't work for me either, but I figured it out by doing an array dump of the $profile array. You can access it like this:

print $profile["Personal Information"]["profile_name"]["value"];

(Personal Information is the "profile group" of the field)

The documentation should be updated to say this.

once again, doesn't work for me

First, sorry for my bad english ;).
The Code of Advanced Forum is very buggy.

I have the same Problem with profile fields.
But i have a Workaround.

Place the Code in "themes/advforum/advf-forum-user.tpl.php

<?php global $user;
$acc = user_load(array('uid' => $accountid));
?>

Then you can access the user Profile Fields with

<?php print $acc-><your_profile-field>;?>

It works for me.
I hope it helps.

I have had this same problem, even through trying all of the following:
1) Enabled the Core profile package, added a new field called profile_name, and completed this value
2) Edited advf-forum-user.tpl.php and added Name: print $profile->profile_name;
At this point, all that displayed was Name:, the actual name did not display

3) I verified that the profile_name field had 'Public field, content shown on profile page but not used on member list pages.' and also tried it with, 'Public field, content shown on profile page and on member list pages.' In both cases I got the same result

4) Added the following code per a prior post to advf-forum-user.tpl.php file. Still did not display the actual name

 global $user;
$acc = user_load(array('uid' => $accountid));

Name: print $acc->profile_name;

I am sure I am missing something, but I cannot figure out what. Can anyone provide a pointer?

- Steve

You don't need to load the user object as it's already loaded. Just use the existing $profile variable. It works but it wasn't documented correctly in the .tpl. I've updated it with the proper information.

$profile - Profile object from core profile. Usage: $profile['category']['field_name']['value']
  Example: Real name: <?php print $profile['Personal info']['profile_name']['value']; ?>

Michelle

still not working for me on alpha2.. dumps of both $profile and $account are giving NULL.

ozon's solution is returning profile fields of the _currently logged in user_ : (

I've confirmed that this works in the current 6.x.

Michelle