<?
require("global.php");
$filename="radio.php";
$action=$_REQUEST['action'];
switch ($action){
case "radio_listen":
	$radio_id=$_GET['radio_id'];
	$mode=$_GET['radio_mode'];
	$radio_url=$db->QUERY_FIRST("SELECT radio_stationname, radio_".$mode."url AS url FROM bb".$n."_rstations WHERE radio_id=$radio_id");
	If (!$radio_url OR $mode!="rp" AND $mode!="wmp") access_error();
	eval("\$tpl->output(\"".$tpl->get("radio_listen$mode")."\");");
break;
case "radiostation_suggest":
	if (isset($_POST['send'])){
		$db->QUERY("INSERT INTO bb".$n."_rstations (radio_stationname, radio_wmpurl, radio_rpurl, radio_winampurl, radio_catid,radio_activated) VALUES ('".addslashes($_POST['radio_stationname'])."','".addslashes($_POST['radio_wmpurl'])."','".addslashes($_POST['radio_rpurl'])."','".addslashes($_POST['radio_winampurl'])."', '".$_POST['radio_catid']."',0)");
  		header("Location: radio.php?action=view&sid=$session[hash]");
	}
	$sqlradio_cats=$db->QUERY("SELECT * FROM bb".$n."_rcats");
	while($row=$db->fetch_array($sqlradio_cats)){
		$radio_cat_options.=makeoption($row[radio_catid],$row[radio_catname],$radio['radio_catid']);
	}
	eval("\$tpl->output(\"".$tpl->get("radio_suggest")."\");");
break;
default:
	htmlspecialchars($_GET['radio_search']);
	$sortby=$_GET['sortby'];
	$orderby=$_GET['orderby'];
	switch ($sortby){
	case "radio_catname":
	break;
	default:
		$sortby="radio_stationname";
	break;
	}
	switch ($orderby){
		case "ASC":
		break;
		default:
			$orderby="DESC";
		break;
	}
	$sel[$orderby]="selected";
	$sel[$sortby]="selected";
	$where="WHERE radio_stationname LIKE '%".htmlspecialchars($_GET['radio_search'])."%'";
	if (trim($_GET['radio_cat'])!="" AND $_GET['radio_cat']!="*") $where.=" AND rs.radio_catid=".$_GET['radio_cat'];
	$result=$db->QUERY("SELECT * FROM bb".$n."_rstations rs LEFT JOIN bb".$n."_rcats USING (radio_catid) $where ORDER BY $sortby $orderby");
	while($row=$db->fetch_array($result)){
		$stil=getone($counter++,"id=\"tablea\" bgcolor=\"{tablecolora}\"", "id=\"tableb\" bgcolor=\"{tablecolorb}\"");
		if ($row[radio_rpurl]!="") eval ("\$rp= \"".$tpl->get("radio_viewbitrp")."\";"); else eval ("\$rp= \"".$tpl->get("radio_viewbitnodeclaration")."\";"); 
		if ($row[radio_wmpurl]!="") eval ("\$wmp= \"".$tpl->get("radio_viewbitwmp")."\";"); else eval ("\$wmp= \"".$tpl->get("radio_viewbitnodeclaration")."\";"); 
		if ($row[radio_winampurl]!="") eval ("\$winamp= \"".$tpl->get("radio_viewbitwinamp")."\";"); else eval ("\$winamp= \"".$tpl->get("radio_viewbitnodeclaration")."\";"); 
		if ($row[radio_link]!="") $row[radio_stationname]=makehreftag($row[radio_link],$row[radio_stationname],"_blank");
		eval ("\$radio_viewbit.= \"".$tpl->get("radio_viewbit")."\";");
	}
	$result=$db->QUERY("SELECT * FROM bb".$n."_rcats");
	while($row=$db->fetch_array($result)){
		$radio_catoptions.=makeoption($row[radio_catid],$row[radio_catname],$_GET[radio_cat]);
	}
	eval("\$tpl->output(\"".$tpl->get("radio_view")."\");");
break;
}
?>