<?
require_once('/home/www/artlimited/include/i_declare.php');
require_once(AL_PATH.'/include/i_session.php');
require_once(AL_PATH.'/include/i_database.php');
require_once(AL_PATH.'/include/i_note.php');
require_once(AL_PATH.'/image/i_declare.php');
require_once(AL_PATH.'/project/i_resources_'.$_SESSION['UserLang'].'.php');

// no_cache(__FILE__);

$_GET['tabid']=intval($_GET['tabid']);

if (intval($_REQUEST['prj'])<=0) {
  require(AL_PATH.'/include/i_error_404.php');
} else {
	$ProjectId=intval($_REQUEST['prj']);
}

// ----------------------------------------------------------------------------
// ---- SITE PARAM/DESIGN DEFINITION ------------------------------------------
// ----------------------------------------------------------------------------

$DesignParam['WEB_FONT']=1;

if (intval($_SESSION['UserId'])>0 && $ProjectId>0) {
  switch ($_POST['job']) {
    case 'join':
    	if ($ProjectId>0) {
	      $SQL="INSERT IGNORE INTO projects_r_members (ProjectId,MemberId,DateIn) VALUES (".$ProjectId.",".$_SESSION['UserId'].",now())";
	      db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	      $SQL='UPDATE LOW_PRIORITY projects SET CountUser=CountUser+1 WHERE Id='.$ProjectId;
	      db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	      add_note($db_pf,MSG_JOIN_PROJECT,$_SESSION['UserId'],$ProjectId,0,'');
      }
      break;

    case 'leave':
    	if ($ProjectId>0) {
	      $SQL='DELETE FROM projects_r_members WHERE ProjectId='.$ProjectId.' AND MemberId='.$_SESSION['UserId'];
	      db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	      // ---- update user counter
	      $SQL='UPDATE projects SET CountUser=CountUser-1 WHERE Id='.$ProjectId;
	      db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	      // ---- delete picture
	      $SQL='SELECT PictureId FROM projects_r_pics
	        INNER JOIN picbase ON picbase.Id=projects_r_pics.PictureId AND picbase.Uid='.$_SESSION['UserId'].'
	        WHERE ProjectId='.$ProjectId;
	      $Result=db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	      $Count=0;
	      while ($Row=db_fetch_assoc($Result)) {
	        $SQL='DELETE FROM projects_r_pics WHERE PictureId='.$Row['PictureId'];
	        $Count++;
	      }
	      // ---- update pic counter
	      $SQL='UPDATE projects SET CountPic=CountPic+'.intval($Count).' WHERE Id='.$ProjectId.' LIMIT 1';
	      db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
	    }
      break;
  }
}

// -------------------------------------------------------------------------------------------------------------------
// -- PROJECT ROOT DISPLAY -------------------------------------------------------------------------------------------
// -------------------------------------------------------------------------------------------------------------------

// ---- get project property

$SQL='SELECT projects.*,members.FirstName,members.LastName,members.Account,members.ArtistStatus,members.NickName,
      Subscribed.ProjectId AS Subscribed
      FROM projects
      INNER JOIN members ON members.Id=projects.Uid AND members.Active=1
      LEFT
      JOIN projects_r_members Subscribed ON Subscribed.ProjectId=projects.id AND Subscribed.MemberId='.$_SESSION['UserId'].'
      WHERE projects.State=0
      AND projects.Id='.$ProjectId.'
      LIMIT 1';

// if ($_SESSION['Admin']) mail(SITE_EMAIL,'Project',$SQL);

$Result=db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
$Row=db_fetch_assoc($Result);

if (!$Row) {
  header('Location: /project/');
  exit(0);
}

// ---- Prepare urls

if ($_SESSION['UserLang']=='fr') {
	$UrlBack=$MetaLink=HTTP_WWW.SITE_DOMAIN.'/project/'.$Row['Slug'].'/fr/'.$ProjectId;
	$MetaCanonical=HTTP_WWW.SITE_DOMAIN.'/project/'.$Row['Slug'].'/en/'.$ProjectId;
	$MetaAlternate['URL']=$MetaCanonical;
	$MetaAlternate['LANG']='en';
} else {
	$UrlBack=$MetaLink=HTTP_WWW.SITE_DOMAIN.'/project/'.$Row['Slug'].'/en/'.$ProjectId;
	$MetaAlternate['URL']=HTTP_WWW.SITE_DOMAIN.'/project/'.$Row['Slug'].'/fr/'.$ProjectId;
	$MetaAlternate['LANG']='fr';
}

// ---- Good url ?

$Found=strpos(HTTP_WWW.SITE_DOMAIN.$_SERVER['REQUEST_URI'],$MetaLink);
if ($Found!=0 || $Found===FALSE) {
	header('HTTP/1.1 301 Moved Permanently',TRUE,301);
	header('location: '.$MetaLink);
	exit();
}

// ---- Prepare mosaic data

$MetaImage[0]=HTTP_WWW.SITE_DOMAIN.'/project/grp/mosaic/'.AL_IMG_TAG.'-project-'.$ProjectId.'-'.($_SESSION['UserId']>0 ? 'open':'protected').'.jpg';

// ---- prepare tabs

$TabName=array(
	0 => $RSPrj[34],
	1 => ($Row['CountUser']>0 ? $RSPrj[35]:''),
	2 => ($Row['CountPic']>0 ? $RSPrj[36]:''),
	3 => ($Row['CountPic']>0 ? $RSPrj[37]:''),
	4 => ($Row['Discussion']<=0 ? '':$RSPrj[38]),
);

$MetaTitle=sprintf($RSPrj[33].', '.$TabName[$_GET['tabid']],ucwords(strtolower($Row['Name'])));
$MetaDescription=$Row['ShortDesc'];
$MetaKeywords=$Row['KeyTags'];

require_once(AL_PATH.'/include/i_library.php');
require(AL_PATH.'/include/i_page_header.php');

if ($_SESSION['UserId']!=$Row['Uid']) {
  $SQL='UPDATE LOW_PRIORITY projects SET Seen=Seen+1 WHERE Id='.$ProjectId.' LIMIT 1';
  db_query(__FILE__,__LINE__,$SQL,$db_pf,1);
}

echo '<div class="DisFX" style="justify-content:space-between;">';

echo '<div class="Oswald" style="margin:20px;">';
echo '<h1 style="font-weight:400;font-size:30px;color:#666;margin:0;padding:0;">'.$Row['Name'].'</h1>';
echo '<h2 style="font-weight:200;font-size:20px;color:#888;margin:0;padding:5px 0 20px 0;">'.$Row['ShortDesc'].'</h2>';
echo '</div>';

echo '<div style="text-align:right;margin:auto 20px auto 0;">';
echo '<form action="?prj='.$ProjectId.'#data" method="POST">';
echo '<input type="hidden" name="prj" value="'.$Row['Id'].'">';
if ($Row['Subscribed']!=$Row['Id']) {
	if ($_SESSION['UserId']>0) {
	  if ($Row['Type']==0) {
	    echo '<input type="hidden" name="job" value="join">';
	    create_button('submit',$RSPrj[1],"onClick=\"return confirm('".sprintf($RSPrj[3],$Row['Name'])."');\"");
	  }
	} else {
		create_button('button',$RSPrj[1],'onClick=\'location.href="'.URL_USER_ACCOUNT_SIGNUP.'";\'');
	}
} else {
  echo '<input type="hidden" name="job" value="leave">';
  create_button('submit',$RSPrj[2],"onClick=\"return confirm('".sprintf($RSPrj[4],$Row['Name'])."');\" style='background-color: $ColorErrorMsg'");
}
echo '</form>';
echo '</div>';

echo '</div>';

display_tabs(intval($_REQUEST['tabid']),$TabName,'','bypass','tabid',HTTP_WWW.SITE_DOMAIN.'/project/'.$Row['Slug'].'/'.$_SESSION['UserLang'].'/'.$ProjectId,0);
switch (intval($_GET['tabid'])) {
	case 0:
		require_once('main/index.php');
		break;
	case 1:
		require_once('member/index.php');
		break;
	case 2:
		require_once('image/index.php');
		break;
	case 3:
		require_once('appreciation/index.php');
		break;
	case 4:
		require_once('discussion/index.php');
		break;
}
display_tabs_end($TabName);
require(AL_PATH.'/include/i_page_footer.php');
?>