This section is still in mySQL... Because it was hand-coded, it can't be updated by the extension:
<?php
if ($master1events->TotalRows>0) {
$nested_query_detail2eventsDate = str_replace("123456789", $master1events->getColumnVal('events_ID'), $query_detail2eventsDate);
mysql_select_db($database_clarion);
$detail2eventsDate = mysql_query($nested_query_detail2eventsDate, $clarion) or die(mysql_error());
$row_detail2eventsDate = mysql_fetch_assoc($detail2eventsDate);
$detail2eventsDate->TotalRows = mysql_num_rows($detail2eventsDate);
$nested_sw = false;
if (isset($row_detail2eventsDate) && is_array($row_detail2eventsDate)) {
do { //Nested repeat
?>
<tr>
<td><p class="event-para"><strong><?php echo $detail2eventsDate->getColumnVal('location'); ?></strong>: <?php echo $detail2eventsDate->getColumnVal('dateDisplay'); ?>
<?php
// Show IF Conditional region1
if (@$detail2eventsDate->getColumnVal('link') != null) {
?>
<a href="<?php echo $detail2eventsDate->getColumnVal('link'); ?>">Read more</a>
<?php
// Show IF Conditional region1
if (@$detail2eventsDate->getColumnVal('regLink') != null) {
?>
| <a href="<?php echo $detail2eventsDate->getColumnVal('regLink'); ?>">Register</a>
<?php }
// endif Conditional region1
?>
<?php
// Show IF Conditional region5
if (@$detail2eventsDate->getColumnVal('online') == 1) {
?>
<em>(Online or In-person)</em>
<?php }
// endif Conditional region5
?>
</p>
<?php }
// endif Conditional region1
?></td>
</tr>
<?php
} while ($row_detail2eventsDate = mysql_fetch_assoc($detail2eventsDate)); //Nested move next
}
}
?>
I think it should be something like:
<?php
if ($master1events->TotalRows>0) {
$nested_query_detail2eventsDate = str_replace("123456789", $master1events->getColumnVal('events_ID'), $query_detail2eventsDate);
?>
<?php
$detail2eventsDate = new WA_MySQLi_RS("detail2eventsDate",$clarion_i,1);
$detail2eventsDate->setQuery($nested_query_detail2eventsDate);
$detail2eventsDate->execute();
?>
<?php
$nested_sw = false;
?>
<?php
while (!$detail2eventsDate->atEnd()) {
?>
<tr>
<td><p class="event-para"><strong><?php echo $detail2eventsDate->getColumnVal('location'); ?></strong>: <?php echo $detail2eventsDate->getColumnVal('dateDisplay'); ?>
<?php
// Show IF Conditional region1
if ($detail2eventsDate->getColumnVal('link')) {
?>
<a href="<?php echo $detail2eventsDate->getColumnVal('link'); ?>">Read more</a>
<?php
// Show IF Conditional region1
if ($detail2eventsDate->getColumnVal('regLink')) {
?>
| <a href="<?php echo $detail2eventsDate->getColumnVal('regLink'); ?>">Register</a>
<?php }
// endif Conditional region1
?>
<?php
// Show IF Conditional region5
if ($detail2eventsDate->getColumnVal('online') == 1) {
?>
<em>(Online or In-person)</em>
<?php }
// endif Conditional region5
?>
</p>
<?php }
// endif Conditional region1
?></td>
</tr>
<?php
$detail2eventsDate->moveNext();
}
?>
<?php
}
?>