Email Template shows raw data

[gdmanesis]

Since the last github update my email template shows only raw data on the fields that are database join, render as dropdown.
I need to show on the email template the Label not the value


Any ideas

Thank you in advance

 

[gdmanesis]

I have tested also the debug.php and debug_with_labels.php email templates , still getting raw data.
Any advise ???

 

[troester]

It's working on my site.

debug_with_labels.php email templates

The debug_with_labels.php email template contains an "exit;" in the last code line (I assume it should not), so it doesn't send an email but displays on the screen.
Are you sure you've got the correct GitHub branch?

 

[gdmanesis]

The debug_with_labels.php displays on the screen as u mentioned , but it shows raw data

 

[troester]

Strange.
Anything special with your settings, e.g. element hidden, readonly, in repeat group, joined group..?

 

[gdmanesis]

The elements that have the problem are databasejoins rendered as dropdown. Its a repeat group.
my code is

<?php

$busses = $this->data['join'][3]['passo_12_repeat___bus'];
$drivers = $this->data['join'][3]['passo_12_repeat___driver_name'];

$length1 = count($busses);
for ($i = 0; $i < $length1; $i++) :

$db =& JFactory::getDBO();
$qdriver = strip_tags($drivers[$i]);
$query = "SELECT `driver_natid` FROM `drivers` WHERE `driver_name` = '$qdriver'";
$db->setQuery($query);
$driver_natid = $db->loadResult();

$db =& JFactory::getDBO();
$qdriver = strip_tags($drivers[$i]);
$query = "SELECT `driver_code` FROM `drivers` WHERE `driver_name` = '$qdriver'";
$db->setQuery($query);
$driver_code = $db->loadResult();

$db =& JFactory::getDBO();
$qbus_code = strip_tags($busses[$i]);
$query = "SELECT `bus_code` FROM `busses` WHERE `plate_no` = '$qbus_code'";
$db->setQuery($query);
$bus_code = $db->loadResult();
?>
<tr>
<td><?php echo strip_tags($busses[$i]);?></td>
<td><?php echo strip_tags($bus_code);?></td>
<td><?php echo strip_tags($drivers[$i]);?></td>
<td><?php echo strip_tags($driver_natid);?></td>
<td><?php echo strip_tags($driver_code);?></td>


<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</tbody>
<?php
endfor;
?>

 

[felixkat]

As per Skype, I'll look at this later.

 

[varst]

I have the same problem. I need to show on the email template the Label but not the value in field ['majandustellimus_38_repeat___Nimetus']

My code:
<table style="width: 100%" class="style7">
<tr>
<td class="style3" style="width: 70%"><strong>Nimetus:</strong></td>
<td class="style3" style="width: 15%"><strong>?hikud:</strong></td>
<td class="style3" style="width: 15%"><strong>Kogus:</strong></td>
</tr>
</table>
<?php
$repeatcount = $this->data['fabrik_repeat_group'][38];
for($i=0; $i<$repeatcount; $i++ )
{?>
<table style="width: 100%" class="style7">
<tr>
<td class="style3" style="width: 70%"><?php echo $this->data['majandustellimus_38_repeat___Nimetus'][$i]?></td>
<td class="style3" style="width: 15%"><?php echo $this->data['majandustellimus_38_repeat___Uhikud'][$i]?></td>
<td class="style3" style="width: 15%"><?php echo $this->data['majandustellimus_38_repeat___Kogus'][$i][0]?></td>
</tr>
</table><span class="style1"><?php }?></span>