set('box_top', box_top('Subscriptions')); $template->set('box_bottom', box_bottom()); $subscription_query = "SELECT * FROM " . DB_PREFIX . "subscription where hidden=0 and event=0 and ifc=0 and trial=0 order by the_order asc "; /*if(!$session->value('free_trial')) { $subscription_query .= " order by trial DESC, the_order asc"; } else $subscription_query .= " and trial =0 order by the_order asc";*/ $query = $db->query($subscription_query); while ($subscription_details = $db->fetch_array($query)) { $sql_query = ("SELECT * FROM " . DB_PREFIX . "subscription_details WHERE hidden=0 and sub_id=".$subscription_details['id']); $query_details = $db->query($sql_query); while ($item = $db->fetch_array($query_details)) { /*$subscription_details['text'] .= '';*/ ## set redirection for single issues if($subscription_details['single']==1) $action = 'financialbridges_archive.php'; else $action = 'members_area.php?page=home§ion=view'; ## $subscription_details['text'] .= '
'; ## set shipping YES for printed issues if($subscription_details['print']==1) $subscription_details['text'] .= ' '; ## $subscription_details['text'] .= '  
'; $subscription_details['text'] .= '
'.$item['name'].(($item['price']>0)?': £'.$item['price'] : '').'

'; } $subscription_details['image'] = $db->GetImagePath('uplimg/subscription/',$subscription_details['image'], 200); $subscription_details['description'] = $db->add_special_chars($subscription_details['description']); $subscription_template = new template('themes/' . $setts['default_theme'] . '/templates/modules/subscription/'); $subscription_template->set('item', $subscription_details); $output .= $subscription_template->process('subscription_box.tpl.php'); } $template->set('items', $output); $template_output .= $template->process('subscribe.tpl.php'); include_once ('global_footer.php'); echo $template_output; ?>