'; /*## scroll $styles .= '';*/ ## jquery $styles .= ''. ''; $styles .= ''. ''; $styles .= ' '; include_once ('global_header.php'); /*$template->set('box_top', box_top('FinCast® Live')); $template->set('box_issue_top', box_top('Newest FinCast® Live Episodes')); $template->set('box_bottom', box_bottom());*/ $id = (int)$_REQUEST['issue']; $query = "SELECT * FROM " . DB_PREFIX . "fincast WHERE deleted=0"; if(is_numeric($id) && $id>0) { $query .= " AND id='" . $id . "'"; ## addthis $addthis_link = $setts['site_path'].'fincast.php?id='.$id; ## } else $addthis_link = $setts['site_path'].'fincast.php'; $query .= " ORDER BY id DESC LIMIT 1"; $sql_select_issue = $db->get_sql_row($query); ## fincast live $template->set('box_top',box_top('FinCast Live!', '', 345)); if($sql_select_issue['image']) { //$image = ''; $image = 'thumb.php?pic=uplimg/fincast/'.$sql_select_issue['image'].'&w=360'; $image_source = 'uplimg/fincast/'.$sql_select_issue['image']; } else { //$image = ''; if($sql_select_issue['type']=='video') $src = 'fincast_video.jpg'; else $src = 'fincast_audio.jpg'; $image = "thumb.php?pic=fincast/images/".$src."&w=360"; $image_source = 'fincast/images/'.$src; } //&logo='.$setts['site_path'].'fincast/fincast-logo.png $fincast = '

'; $template->set('box_bottom', box_bottom()); $template->set('fincast', $fincast); ############################################### $template->set('name', $sql_select_issue['name']); // issue name $template->set('description', $sql_select_issue['description']); // issue name if($sql_select_issue['image']) $image = ''; else $image = ''; $template->set('issue_image', $image); // issue image #### right boxes $sql_select_section = $db->query("SELECT fc.* FROM " . DB_PREFIX . "fincast_cat fc INNER JOIN " . DB_PREFIX . "fincast_podcast fp ON fp.category=fc.id ORDER BY fc.name ASC"); (string) $browse_issue_content = ''; ## lates podacst $query = "SELECT * FROM " . DB_PREFIX . "fincast"; $query .= " WHERE deleted=0 and category=".$sql_select_issue['category']." ORDER BY id ASC"; $sql_issue = $db->query($query); $archive_issue_content = null; //g while ($issue_details = $db->fetch_array($sql_issue)) { if($issue_details['image']) $image = ''; else $image = ''; $archive_issue_content .= '
'.$image.'
'.$issue_details['name'].'
'; } //end WHILE ## ## addthis button $addthis = ' Bookmark and Share '; ## $template->set('archive_issue_content', $archive_issue_content); //$template->set('browse_issue_content', $browse_issue_content); $template->set('addthis', $addthis); $browse_issue_content = "
".$browse_issue_content."
"; $right_boxes .= "
".box_top_notitle('Podcast Video', false).$browse_issue_content.box_bottom_notitle().'
'; /*$right_boxes .= "
Financial Places
"; $right_boxes .= "
Financial Places
"; $right_boxes .= "
Financial Places
"; */ $template->set('right_boxes', $right_boxes); $template_output .= $template->process('fincast.tpl.php'); include_once ('global_footer.php'); echo $template_output; ?>