CiviCRM Community Forums (archive)

Finally, here is the complete code I needed in Contemplate (Content Template, in the Body), to:

A.  Pull in CiviCRM address info for contacts
B.  Remove the node links to CiviCRM to prevent anonymous users from clicking over there
C.  ALSO get the State information from "Constant"

<?php

if ( ! civicrm_initialize( ) ) {
 
       return;
}

require_once 'api/api.php';

$xcoach_id = $node->field_headcoach[0]['contact_id'];
$xcoach = civicrm_api("Contact","get", array ('version' =>'3', 'contact_id' => $xcoach_id));

?>

<div class="field field-type-nodereference field-field-prac-sport">
   <h3 class="field-label" style="margin-bottom:0px; padding-bottom: 0px;">
      Sport</h3>
   <div class="field-items">
      <div class="field-item style="font-size: 13px;">
         <?php print $node->field_prac_sport[0]['view'] ?></div>
   </div>
</div>
<div class="field">
   <h3 class="field-label" style="margin-bottom:0px; padding-bottom: 0px;">
      Head Coach</h3>
   <div class="field-items">
      <div class="field-item style="font-size: 13px;">
         <?php print $xcoach['values'][$xcoach_id]['display_name']; ?></div>
   </div>
</div>
<div class="field">
   <h3 class="field-label" style="margin-bottom:0px; padding-bottom: 0px;">
      Practice Location</h3>
   <div class="field-items">
      
<div class="field-item style="font-size: 13px;">

<?php

$contid = $node->field_prac_location[0]['contact_id'];

$xloc_contact = civicrm_api("Contact","get", array ('version' =>'3', 'contact_id' => $contid));

print $xloc_contact['values'][$contid]['display_name'];
?>

<br>

<?php

$results=civicrm_api("Address","get", array ('version' =>'3', 'contact_id' => $contid));

$temp_id=$results['id'];

$tmp_state = civicrm_api('constant','get', array('version' => '3', 'name' => 'stateProvinceAbbreviation'));

$xstate_abbrev = $tmp_state['values'][$results['values'][$temp_id]['state_province_id']];

print $results['values'][$temp_id]['street_address']."\n";

if ($results['values'][$temp_id]['supplemental_address_1']) { print $results['values'][$temp_id]['supplemental_address_1'];};

?>
<br />
<?php print $results['values'][$temp_id]['city'].", ".$xstate_abbrev." ".$results['values'][$temp_id]['postal_code']."\n"; ?>
</div>
   </div>
</div>

<div class="field field-type-date field-field-prac-dates">
   <h3 class="field-label style="margin-bottom:0px; padding-bottom: 0px;">
      Dates</h3>
   <div class="field-items">
      <?php
                   
                  foreach ((array)$node->field_prac_dates as $item) {
?>

<div class="field-item">

<?php print $item['view'] ?></div>

<?php } ?>
      </div>
      
</div>