categories/scripts/webinars.php

<?php
	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");

	function webinars($catIDs) {
		$App = new App();
		ob_start();
		?>
		<div class="webinars">
		<table cellspacing=0 cellpadding=0 width="100%">
		<tr class="header">
			<td width="70%">Title</td>
			<td width="15%">Format</td>
			<td width="15%">Date</td>
		</tr>
		<?
		$sql = "SELECT DISTINCT cn.nid, n.title, nn.title as format, ncr.field_abstract_value as abstract, e.event_start from category_node as cn
				INNER JOIN node as n on n.nid = cn.nid
				INNER JOIN category_node as cat_node on cat_node.nid = cn.nid
				INNER JOIN node as nn on nn.nid = cat_node.cid
	      		INNER JOIN node_content_resource as ncr on ncr.nid = cn.nid
	      		INNER JOIN event as e on e.nid = cn.nid
				WHERE cn.cid IN ($catIDs) AND cat_node.cid IN (18, 19, 20) AND ncr.field_reminder_value = 0 AND ncr.field_status_value = 1 ORDER by e.event_start desc";
		$result = $App->live_sql($sql);
		
		while ($rr = mysql_fetch_array($result))
		{
			$title = $rr['title'];
			$format = $rr['format'];
			$id = $rr['nid'];
			$abstract = $rr['abstract'];
			$date = $rr['event_start'];
			$url = 'http://live.eclipse.org/node/'. $id;
			?>		<tr>
						<td>
							<div id="<?=$id;?>" class="invisible">
								<a class="norgie" onclick="t('<?=$id;?>', '<?=$id;?>a');" name='<?=$name?>'></a>
							</div>
							<a href="<?=$url;?>"><?=$title;?></a>
						</td>
						<td><?=$format;?></td>
						<td><?=date("M j, Y", $date);?></td>
					</tr>
					<tr>
						<td colspan="2" class="hidden">
							<div class="invisible" id="<?=$id;?>a">
								<div class="item_contents"><?=$abstract;?></div>
							</div>
						</td>
					</tr>
			<?
		}
		?></table></div><?
		$retVal = ob_get_clean();
		return $retVal;
	}
?>