<?
ob_start();
require_once('includes/config.php');
require_once('includes/funclib.php');
require_once('includes/logger.php');
require_once('includes/database.php');

$bandishid = get_param('R P', 'id');
if($bandishid!='' && is_numeric($bandishid))
{
	
	$database = new database();
	
	$database->setQuery("SELECT BANDISHBASE.*, TAALABASE.ID as taal_id, TAALABASE.TAAL_NAME, RAAGABASE.ID as raag_id, RAAGABASE.RAAG_NAME, RAAGABASE.VERIFIED AS RAAG_VERIFIED, CODES.DESCRIPTION AS TEMPO, CODES2.DESCRIPTION AS TYPE, USERS.FNAME, USERS.LNAME, USERS.UNAME, ARTISTS.NAME AS ARTIST_NAME, GHARANAS.NAME AS GHARANA FROM BANDISHBASE INNER JOIN TAALABASE ON BANDISHBASE.TAAL_ID = TAALABASE.ID INNER JOIN RAAGABASE ON BANDISHBASE.RAAG_ID = RAAGABASE.ID INNER JOIN CODES ON BANDISHBASE.TEMPO_ID = CODES.code INNER JOIN CODES AS CODES2 ON BANDISHBASE.TYPE = CODES2.code INNER JOIN USERS ON BANDISHBASE.ADDED_BY = USERS.ID LEFT JOIN ARTISTS ON BANDISHBASE.CREATOR_ID = ARTISTS.ID LEFT JOIN GHARANAS ON BANDISHBASE.GHARANA_ID = GHARANAS.ID LEFT JOIN CODES GCODE ON GHARANAS.TYPE_ID = GCODE.CODE AND GCODE.TYPE='GHARANA_TYPE' WHERE CODES2.type='BANDISH_TYPE' AND CODES.type='TEMPO' AND BANDISHBASE.ID = ".$bandishid);

	$result = $database->loadAssocList();
	
	$icm="true";
	
	$titleimage="<img src=\"images/titles/bandishbasetitle.png\" alt=\"Bandish Details\" border=\"0\"/>";
	
	$title = "Bandish - ".$result[0]['RAAG_NAME']." - ".$result[0]['TITLE'];
	
	require_once('includes/header.php');
	$session = new session();

	if(get_param('R P', 'unlock')!='' && get_param('R P', 'iid')!='')
	{
		if(!UnlockItem(get_param('R P', 'unlock'), get_param('R P', 'iid')))
			echo "<div class='error' style='font-size:16px;'>You cannot unlock this item at the moment, you already have activated the maximum number of items allowed as per your subscription. Please click <a href='"._SGDOMAIN."subscriptions.php'>here</a> to upgrade to the next level.</div>";
		else
			header("Location:"._SGDOMAIN."bandish_details.php?id=$bandishid");
	}
	
	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_ASSETS.*, CODES.DESCRIPTION as TYPE, CODES1.DESCRIPTION as SCALE FROM BANDISHBASE_ASSETS INNER JOIN CODES ON BANDISHBASE_ASSETS.TYPE_ID = CODES.CODE AND CODES.TYPE='ASSET_TYPE' LEFT JOIN CODES CODES1 ON BANDISHBASE_ASSETS.SCALE = CODES1.CODE AND CODES1.TYPE='SCALE' WHERE  BANDISHBASE_ASSETS.BANDISH_ID=".$bandishid);
	else
		$database->setQuery("SELECT BANDISHBASE_ASSETS.*, CODES.DESCRIPTION as TYPE, CODES1.DESCRIPTION as SCALE FROM BANDISHBASE_ASSETS INNER JOIN CODES ON BANDISHBASE_ASSETS.TYPE_ID = CODES.CODE AND CODES.TYPE='ASSET_TYPE' LEFT JOIN CODES CODES1 ON BANDISHBASE_ASSETS.SCALE = CODES1.CODE AND CODES1.TYPE='SCALE' WHERE (BANDISHBASE_ASSETS.VERIFIED = 1 OR BANDISHBASE_ASSETS.ADDED_BY = ".$session->get('uid',0).") AND BANDISHBASE_ASSETS.BANDISH_ID=".$bandishid);
	$assets = $database->loadAssocList();

	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_ASSETS.*, CODES.DESCRIPTION as TYPE, CODES1.DESCRIPTION as SCALE FROM BANDISHBASE_ASSETS INNER JOIN CODES ON BANDISHBASE_ASSETS.TYPE_ID = CODES.CODE AND CODES.TYPE='ASSET_TYPE' LEFT JOIN CODES CODES1 ON BANDISHBASE_ASSETS.SCALE = CODES1.CODE AND CODES1.TYPE='SCALE' WHERE CODES.DESCRIPTION='Audio' AND BANDISHBASE_ASSETS.FILE_TYPE ='mp3'  AND BANDISHBASE_ASSETS.BANDISH_ID=".$bandishid);
	else
		$database->setQuery("SELECT BANDISHBASE_ASSETS.*, CODES.DESCRIPTION as TYPE, CODES1.DESCRIPTION as SCALE FROM BANDISHBASE_ASSETS INNER JOIN CODES ON BANDISHBASE_ASSETS.TYPE_ID = CODES.CODE AND CODES.TYPE='ASSET_TYPE' LEFT JOIN CODES CODES1 ON BANDISHBASE_ASSETS.SCALE = CODES1.CODE AND CODES1.TYPE='SCALE' WHERE CODES.DESCRIPTION='Audio' AND BANDISHBASE_ASSETS.FILE_TYPE ='mp3' AND (BANDISHBASE_ASSETS.VERIFIED = 1 OR BANDISHBASE_ASSETS.ADDED_BY = ".$session->get('uid',0).")  AND BANDISHBASE_ASSETS.BANDISH_ID=".$bandishid);
	$audio = $database->loadAssocList();

	
	$database->setQuery("SELECT sum(CREDITS_REMAINING) FROM USER_CREDITS WHERE USER_ID= (SELECT ID FROM USERS WHERE UNAME='".$session->get('aajuname','')."') GROUP BY USER_ID ");
	$usercredits = $database->loadResult();
	
	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_MEANINGS.*, USERS.FNAME, USERS.LNAME FROM BANDISHBASE_MEANINGS INNER JOIN USERS ON BANDISHBASE_MEANINGS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid);
	else
		$database->setQuery("SELECT BANDISHBASE_MEANINGS.*, USERS.FNAME, USERS.LNAME FROM BANDISHBASE_MEANINGS INNER JOIN USERS ON BANDISHBASE_MEANINGS.ADDED_BY = USERS.ID WHERE BANDISHBASE_MEANINGS.BANDISH_ID = ".$bandishid." AND (BANDISHBASE_MEANINGS.VERIFIED = 1 OR BANDISHBASE_MEANINGS.ADDED_BY = ".$session->get('uid',0).") ");
		
	$meanings = $database->loadAssocList();

	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_LINKS.*, USERS.FNAME, USERS.LNAME, ARTISTS.NAME AS ARTIST FROM BANDISHBASE_LINKS INNER JOIN USERS ON BANDISHBASE_LINKS.ADDED_BY = USERS.ID INNER JOIN ARTISTS ON BANDISHBASE_LINKS.ARTIST_ID = ARTISTS.ID WHERE BANDISH_ID = ".$bandishid." ORDER BY TYPE_ID DESC");
	else
		$database->setQuery("SELECT BANDISHBASE_LINKS.*, USERS.FNAME, USERS.LNAME, ARTISTS.NAME AS ARTIST FROM BANDISHBASE_LINKS INNER JOIN USERS ON BANDISHBASE_LINKS.ADDED_BY = USERS.ID INNER JOIN ARTISTS ON BANDISHBASE_LINKS.ARTIST_ID = ARTISTS.ID WHERE BANDISH_ID = ".$bandishid." AND BANDISHBASE_LINKS.VERIFIED=1 ORDER BY TYPE_ID DESC");
	$links = $database->loadAssocList();
	
	
	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_NOTATIONS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_NOTATIONS INNER JOIN USERS ON BANDISHBASE_NOTATIONS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." ORDER BY ADDED DESC");
	else
		$database->setQuery("SELECT BANDISHBASE_NOTATIONS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_NOTATIONS INNER JOIN USERS ON BANDISHBASE_NOTATIONS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." AND BANDISHBASE_NOTATIONS.VERIFIED=1 ORDER BY ADDED DESC");
		
		
	$notations = $database->loadAssocList();
	
	
	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_TAANS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_TAANS INNER JOIN USERS ON BANDISHBASE_TAANS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." ORDER BY ID");
	else
		$database->setQuery("SELECT BANDISHBASE_TAANS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_TAANS INNER JOIN USERS ON BANDISHBASE_TAANS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." AND  BANDISHBASE_TAANS.VERIFIED=1 ORDER BY ID");
	$taans = $database->loadAssocList();
	
	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_ALAAPS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_ALAAPS INNER JOIN USERS ON BANDISHBASE_ALAAPS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." ORDER BY ID");
	else
		$database->setQuery("SELECT BANDISHBASE_ALAAPS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_ALAAPS INNER JOIN USERS ON BANDISHBASE_ALAAPS.ADDED_BY = USERS.ID WHERE BANDISH_ID = ".$bandishid." AND  BANDISHBASE_ALAAPS.VERIFIED=1 ORDER BY ID");
	$alaaps = $database->loadAssocList();

	if($session->get('access')>=5)
		$database->setQuery("SELECT BANDISHBASE_TAANS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_TAANS
INNER JOIN USERS ON BANDISHBASE_TAANS.ADDED_BY = USERS.ID
INNER JOIN BANDISHBASE_NOTATIONS ON BANDISHBASE_NOTATIONS.STARTING_BEAT = (BANDISHBASE_TAANS.ENDING_BEAT + 1)
INNER JOIN BANDISHBASE ON BANDISHBASE_NOTATIONS.BANDISH_ID = BANDISHBASE.ID
INNER JOIN BANDISHBASE BB ON BANDISHBASE.RAAG_ID = BB.RAAG_ID AND BANDISHBASE.TAAL_ID = BB.TAAL_ID AND BANDISHBASE_TAANS.BANDISH_ID = BB.ID WHERE BANDISHBASE.ID = ".$bandishid." AND BANDISHBASE_TAANS.VERIFIED = 1 ORDER BY ID");
	else
		$database->setQuery("SELECT BANDISHBASE_TAANS.*, USERS.FNAME, USERS.LNAME, USERS.UNAME FROM BANDISHBASE_TAANS
INNER JOIN USERS ON BANDISHBASE_TAANS.ADDED_BY = USERS.ID
INNER JOIN BANDISHBASE_NOTATIONS ON BANDISHBASE_NOTATIONS.STARTING_BEAT = (BANDISHBASE_TAANS.ENDING_BEAT + 1)
INNER JOIN BANDISHBASE ON BANDISHBASE_NOTATIONS.BANDISH_ID = BANDISHBASE.ID
INNER JOIN BANDISHBASE BB ON BANDISHBASE.RAAG_ID = BB.RAAG_ID AND BANDISHBASE.TAAL_ID = BB.TAAL_ID AND BANDISHBASE_TAANS.BANDISH_ID = BB.ID WHERE BANDISHBASE.ID = ".$bandishid." ORDER BY ID");
	$alttaans = $database->loadAssocList();

	if($result[0]['VERIFIED'] || $session->get('access')>=5 || ($result[0]['ADDED_BY'] == $session->get('uid')) )
    {
		$returns = explode("\r\n",$result[0]['BANDISH']);

		$rows = round(count($returns)*1.25,0);
	

		echo "<table class=\"details\" style=\"width:95%\">";
		
		if((($session->get('access')>=3) || ($result[0]['UNAME']==$session->get('aajuname',null))) && $popup!=1)
		{
			echo "<a href=\"admin/bandishbaseadmin.php?id=".$result[0]['ID']."\">Edit this bandish <IMG SRC=\"images/edit.gif\" BORDER=\"0\"></a>";
		}
		if ((($session->get('access')>=5) || ($result[0]['UNAME']==$session->get('aajuname',null))) && $popup!=1)
		{
			echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"admin/bandishbaseadmin.php?oper=delete&id=".$result[0]['ID']."\">Delete this bandish <IMG SRC=\"images/delete.gif\" BORDER=\"0\"></a>";
		}
		
		
		if($session->get('access')>=4 || GetSubscriptionLevel()>=4)
		{
		?>
		<a href='<?echo $fullurl?>&popup=1'><img src="