MadCollector Code

<?php
/* This file is part of Madcollector.
* Madcollector created by Thomas Andrieu,
* Developped by Mickael Jardet and Thomas Andrieu.
* Madcollector is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.

* Madcollector is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.
*/
require_once LIBS.('classes/issue.class.php');
require_once LIBS.('classes/series.class.php');
require_once LIBS.('classes/artist.class.php');
require_once LIBS.('classes/worker.class.php');
require_once LIBS.('classes/story.class.php');
require_once LIBS.('classes/user.class.php');


$id_series = $_GET['id_series'];
if(!is_numeric($id_series)) $id_series="";
$issue = substr(urldecode($_GET['issue']),0,15);

function get_issue_data($issue_series,$issue_num,$data_base)
{
  $requete_issue = 'SELECT * FROM mc_issues,mc_series WHERE mc_issues.id_series="'.$issue_series.'" AND mc_issues.issue="'.$issue_num.'" AND mc_issues.id_series=mc_series.id_series;';
  
  $envoi_requete = $data_base->send_query($requete_issue);
  $nb_occur = $data_base->num_rows();
  if(($nb_occur == 0)||($nb_occur == ""))
    {
      return array();
    }
  else
    {
      $table_resultats = $data_base->get_array($envoi_requete, 'NUMERIC');
      return $table_resultats;
    }
}

function get_story_data($issue_series,$issue_num,$data_base,$idStory)
{
  $requete_issue = 'SELECT * FROM mc_stories WHERE id_series="'.$issue_series.'" AND issue="'.$issue_num.'" AND id_story=\''.$idStory.'\';';
  
  $envoi_requete = $data_base->send_query($requete_issue);
  $nb_occur = $data_base->num_rows();
  if(($nb_occur == 0)||($nb_occur == ""))
    {
      return array();
    }
  else
    {
      $table_resultats = $data_base->get_array($envoi_requete, 'NUMERIC');
      return $table_resultats;
    }
}

//Si aucune serie n'a été sélectionnée, on affiche la liste des series
//No series selected, displaying a list of series
if(($id_series == "")||($issue=="")||(!isset($id_series))||(!isset($issue)))
{
  $header_title = $lc_Msg_No_Occu;
  require_once THEME.('header.inc.php');

  echo "<div id=\"warning1\">".$lc_Msg_No_Occur."</div>\n";
  if($id_series=="")
      echo "<div id=\"goback1\"><a href=\"index.php?rub=publisher\">".$lc_Msg_Ret_List."</a></div>\n";
  else
    echo "<div id=\"goback2\"><a href=\"index.php?rub=series&amp;id_series=".$id_series."\">".$lc_Msg_Ret_List."</a></div>\n";
}
else
{
  //////////////////////////////////////////////////////////
  //-------------  PROCESS PHASE   -------------------------
  //////////////////////////////////////////////////////////
  //Issue main data
  if(($_SESSION["level"]>1)&&($_POST["main_form_submit"]!=""))
    {
      $_POST["cover_price_text"] = ereg_replace (",",".",$_POST["cover_price_text"]);//Non anglo-saxon price
      
      $requete_update_issue = "UPDATE mc_issues SET cover_price='".mad_strip($_POST["cover_price_text"])."', currency='".$_POST["currency_select"]."',month='".$_POST["publication_month"]."',year='".$_POST["publication_year"]."',last_access='".$_SESSION["id_user"]."',last_date=now() WHERE id_series='".$id_series."' AND issue='".$issue."'";
      $envoi_requete = $myDB->send_query($requete_update_issue);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Issue." : ".$myDB->return_error());
    }
  //main story data
  if(($_SESSION["level"]>1)&&($_POST["main_story_submit"]!=""))
    {
      if($_POST["main_story_isBlackNWhite"]=="on")
	$newBNW = 1;
      else $newBNW = 0;
      if(!is_numeric($_POST["main_story_page_number"])) $_POST["main_story_page_number"]==0;
      $table_resultats = get_issue_data($id_series,$issue,$myDB);  
      if(sizeOf($table_resultats)>0)
	{
	  $oldIssue = new Issue(array_slice($table_resultats,0,23));
	  $old_summary = $oldIssue->summary;
	}
      $new_summary = addXML_content($old_summary,"summary","summaries",mad_strip($_POST["main_story_summary_text"]));
      $requete_update_issue = "UPDATE mc_issues SET title='".addslashes(mad_strip($_POST["main_story_title"]))."', summary='".addslashes($new_summary)."', black_white='".$newBNW."',nb_pages='".$_POST["main_story_page_number"]."', genre='".$_POST["main_story_genre"]."',last_access='".$_SESSION["id_user"]."',last_date=now() WHERE id_series='".$id_series."' AND issue='".$issue."'";
      $envoi_requete = $myDB->send_query($requete_update_issue);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Issue." : ".$myDB->return_error());
    }

  //Update story data
  if(($_SESSION["level"]>1)&&($_POST["submit_story"]!="")&&($_POST["updated_story"])!="")
    {
      $idStory = $_POST["updated_story"];
      if($_POST["story".$idStory."_isBlackNWhite"]=="on")
	$newBNW = 1;
      else $newBNW = 0;
      if(!is_numeric($_POST["story".$idStory."_page_number"])) $_POST["story".$idStory."_page_number"]==0;
      $table_resultats = get_story_data($id_series,$issue,$myDB,$idStory);  
      if(sizeOf($table_resultats)>0)
	{
	  $old_summary = $table_resultats[4];
	}
      $new_summary = addXML_content($old_summary,"comment","comments",mad_strip($_POST["story_summary".$idStory."_text"]));
      $requete_update_story = "UPDATE mc_stories SET title='".addslashes(mad_strip($_POST["story".$idStory."_title"]))."', comments='".addslashes($new_summary)."', black_white='".$newBNW."',nb_pages='".$_POST["story".$idStory."_page_number"]."', genre='".$_POST["story".$idStory."_genre"]."',last_access='".$_SESSION["id_user"]."',last_date=now() WHERE id_series='".$id_series."' AND issue='".$issue."' AND id_story='".$idStory."'";
      $envoi_requete = $myDB->send_query($requete_update_story);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Story." : ".$myDB->return_error()); 
    }

  //new story data
  if(($_SESSION["level"]>1)&&($_POST["add_story_submit"]!=""))
    {
      if($_POST["add_story_black_n_white"]=="on")
	$newBNW = 1;
      else $newBNW = 0;
      if(!is_numeric($_POST["add_story_pages"])) $_POST["add_story_pages"]==0;

      $requete_insert_story = "INSERT INTO mc_stories(id_series,issue,title,black_white,nb_pages,genre,last_access,last_date) VALUES('".$id_series."','".$issue."','".addslashes(mad_strip($_POST["add_story_title"]))."','".$newBNW."','".$_POST["add_story_pages"]."','".$_POST["add_story_genre"]."','".$_SESSION["id_user"]."',now())";
      $envoi_requete = $myDB->send_query($requete_insert_story);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Story." : ".$myDB->return_error()); 
    }
  //Story Casting
  if(($_SESSION["level"]>1)&&($_POST["update_story_cast_submit"]!=""))
    {
      $story_number = $_POST["id_story"];
      $remove_artists = array();
      for($i=0;$i<sizeOf($_POST["remove_artist_story"]);$i++)
	{
	  array_push($remove_artists,$_POST["remove_artist_story"][$i]);
	}
      
      for($i=0;$i<sizeOf($remove_artists);$i++)
	{
	  $requete_delete_work = "DELETE FROM mc_works WHERE id_artist='".$remove_artists[$i]."' AND id_series='".$id_series."' and issue='".$issue."' and id_story='".$story_number."' AND role='".$_POST["select_artist_role".$remove_artists[$i]]."'; ";
	  $envoi_requete = $myDB->send_query($requete_delete_work);
	  $nb_occur = $myDB->num_rows();
	  if($nb_occur == -1)
	    array_push($error_messages,$lc_ErrMsg_SQL_Update_Casting." : ".$myDB->return_error()); 
	}
      for($i=0;$i<sizeOf($_POST["cast_artist_ids"]);$i++)
	{
	  $idArtist = $_POST["cast_artist_ids"][$i];
	  if(!in_array($idArtist,$remove_artists))
	    {
	      $requete_update_work = "UPDATE mc_works SET role='".$_POST["select_artist_role".$idArtist]."',pages='".addslashes(mad_strip($_POST["artist_pages".$idArtist]))."',last_access='".$_SESSION["id_user"]."',last_date=now()  WHERE id_artist='".$idArtist."' AND id_series='".$id_series."' and issue='".$issue."' and id_story='".$story_number."'; ";
	      $envoi_requete = $myDB->send_query($requete_update_work);
	      $nb_occur = $myDB->num_rows();
	      if($nb_occur == -1)
		array_push($error_messages,$lc_ErrMsg_SQL_Update_Casting." : ".$myDB->return_error()); 
	    }
	}
      if($_POST["new_artist_id"]!="")
	{
	  $requete_insert_work = "INSERT INTO mc_works (id_series,issue,id_artist,id_story,role,pages) VALUES ('".$id_series."','".$issue."','".$_POST["new_artist_id"]."','".$story_number."','".$_POST["select_new_artist_role"]."','".addslashes(mad_strip($_POST["new_artist_pages"]))."');";
	  $envoi_requete = $myDB->send_query($requete_insert_work);
	  $nb_occur = $myDB->num_rows();
	  if($nb_occur == -1)
	    array_push($error_messages,$lc_ErrMsg_SQL_Insert_Artist." : ".$myDB->return_error()); 	
	}
    }
  //Add a new story arc
  if(($_SESSION["level"]>1)&&($_POST["new_story_arc_submit"]!=""))
    {
      $requete_delete_work = "UPDATE mc_issues SET id_arc='".$_POST["new_story_arc_id"]."', reading_order='".$_POST["reading_order_select"]."', last_access='".$_SESSION["id_user"]."', last_date=now() WHERE issue='".$issue."' and id_series='".$id_series."'; ";
      $envoi_requete = $myDB->send_query($requete_delete_work);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Issue." : ".$myDB->return_error()); 	
    }
  //Remove a story arc
  if(($_SESSION["level"]>1)&&($_POST["delete_story_arc"]!=""))
    {
      $requete_delete_work = "UPDATE mc_issues SET id_arc='0', last_access='".$_SESSION["id_user"]."', last_date=now() WHERE issue='".$issue."' and id_series='".$id_series."'; ";
      $envoi_requete = $myDB->send_query($requete_delete_work);
      $nb_occur = $myDB->num_rows();
      if($nb_occur == -1)
	array_push($error_messages,$lc_ErrMsg_SQL_Update_Issue." : ".$myDB->return_error());    
    }
  //Add a new link
  if(($_SESSION["level"]>1)&&($_POST["new_link_submit"]!=""))
    {
      if($_POST["new_link_label"]=="")
	array_push($error_messages,$lc_ErrMsg_No_Link_Label); 
      if($_POST["new_link_url"]!="")
	{
	  $requete_insert_link = "INSERT into mc_issue_links(id_series,issue,link_url,link_type,label,last_access) VALUES('".$id_series."','".$issue."','".mad_strip($_POST["new_link_url"])."','".$_POST["new_link_type"]."','".addslashes(mad_strip($_POST["new_link_label"]))."','".$_SESSION["id_user"]."'); ";
	  $envoi_requete = $myDB->send_query($requete_insert_link);
	  $nb_occur = $myDB->num_rows();
	  if($nb_occur == -1)
	    array_push($error_messages,$lc_ErrMsg_SQL_Insert_Link." : ".$myDB->return_error());   
	}  
    }
  //Remove links
  if(($_SESSION["level"]>1)&&($_POST["remove_links_submit"]!=""))
    {
      for($i=0;$i<sizeOf($_POST["check_Links_Remove"]);$i++)
	{
	  $requete_delete_link = "DELETE FROM mc_issue_links WHERE id_link='".$_POST["check_Links_Remove"][$i]."'; ";
	  $envoi_requete = $myDB->send_query($requete_delete_link);
	  $nb_occur = $myDB->num_rows();
	  if($nb_occur == -1)
	    array_push($error_messages,$lc_ErrMsg_SQL_Delete_Link." : ".$myDB->return_error());    
	}
    }
  //Cover
  if((isset($_POST['upload_cover']))&&($_POST['upload_cover']!="")) 
    {
      $tmp_file = $_FILES['fichier_cover']['tmp_name'];
      if( !is_uploaded_file($tmp_file) )
	{
	  array_push($error_messages,$lc_ErrMsg_NoFile_Uploaded);
	  return;
	}
      $type_file = $_FILES['fichier_cover']['type'];
      if( !strstr($type_file, 'jpg') && !strstr($type_file, 'jpeg') && !strstr($type_file, 'bmp') && !strstr($type_file, 'gif') )
	{
	  array_push($error_messages,$lc_ErrMsg_NoImage_File);
	  return;
	}
      // on copie le fichier dans le dossier de destination
      $name_file = $_FILES['fichier_cover']['name'];
      $destination = $id_series."_".$issue.".jpg";
      $check_extensions = get_loaded_extensions();
      if(in_array("gd",$check_extensions))
	{
	  switch($type_file)
	    {
	    case "image/gif" :
	      $new_im=imagecreatefromgif($tmp_file);
	      break;
	    case "image/jpeg" :
	      $new_im=imagecreatefromjpeg($tmp_file);
	      break;
	    }
	  $nouvelle_image=imagecreatetruecolor(imagesx($new_im),imagesy($new_im));
	  imagecopyresized($nouvelle_image,$new_im,0,0,0,0,imagesx($new_im),imagesy($new_im),imagesx($new_im),imagesy($new_im));
	  imagejpeg($nouvelle_image,COVER.$destination);
	  // Start the thumbnail generation
	  $n_width=80; // Fix the width of the thumb nail image
	  $n_height=120; // Fix the height of the thumb nail image
	  $im=imagecreatefromjpeg(COVER.$destination);
	  $width=imagesx($im);
	  $height=imagesy($im);
	  $newimage=imagecreatetruecolor($n_width,$n_height);
	  imagecopyresized($newimage,$im,0,0,0,0,$n_width,$n_height,$width,$height);
	  imagejpeg($newimage,PREVIEWCOVER.$id_series."_".$issue.".jpg");
	}
      // End of JPG thumbnail creation
    }
  //////////////////////////////////////////////////////////
  //-------------   DISPLAY PHASE  -------------------------
  //////////////////////////////////////////////////////////

  //Displaying updates
  $table_resultats = get_issue_data($id_series,$issue,$myDB);  
  if(sizeOf($table_resultats)==0)
    {
      $header_title = $lc_Msg_No_Occur;
      require_once THEME.('header.inc.php');
      
      echo "<div id=\"warning2\">".$lc_Msg_No_Occur."</div>\n";
      echo "<div id=\"goback3\"><a href=\"index.php?rub=series&amp;id_series=".$id_series."\">".$lc_Msg_Ret_List."</a></div>\n";
    }
  else
    {
      $myIssue = new Issue(array_slice($table_resultats,0,23));
      $mySeries = new Series(array_slice($table_resultats,22));
      $header_title = $mySeries->name." vol.".$mySeries->volume;
      if(($mySeries->year != 0)&&($mySeries->year != ""))
    $header_title .= " (".$mySeries->year.")";
      $header_title .= " #".$myIssue->number;
      require_once THEME.('header.inc.php');

      for($i=0;$i<sizeOf($error_messages);$i++)
	{
	  echo "<div class=\"error\">".$error_messages[$i]."</div>\n";
	}


      echo "<div id=\"series_title\"><h1><a href=\"index.php?rub=series&amp;id_series=".$mySeries->id_series."&amp;page=".$page."\">".$mySeries->name." vol.".$mySeries->volume."</a></h1></div>\n";
      echo "<div id=\"issue_number\"><h2>".$lc_Issue_Number." #".$myIssue->number."</h2></div>\n";

      echo "<div id=\"cover_div\">";
      if(is_file (COVER.$id_series."_".$issue.".jpg"))
	     {	 
	       echo "<a href=\"".COVER.$id_series."_".$issue.".jpg\" title=\"".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."\" class=\"thickbox\">"; 
		 if(is_file (PREVIEWCOVER.$id_series."_".$issue.".jpg"))
		    echo "<img src=\"".PREVIEWCOVER.$id_series."_".$issue.".jpg\" alt=\"".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."\"/></a>";
	     else echo "<img src=\"images/no_thumb.jpg\" alt=\"".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."\"/></a>";
		 }
	  $check_extensions = get_loaded_extensions();
      echo "</div>\n";
      if(($_SESSION["level"]>1)&&(in_array("gd",$check_extensions)))
	{
	  echo '<div style="display:none;" id="formPostCover"><form method="post" enctype="multipart/form-data">
                <input type="file" name="fichier_cover" size="10">
                <input type="submit" name="upload_cover" value="Upload">
                </form></div>
';
	  echo '<div class="parag"><a href="#TB_inline?height=155&amp;width=300&amp;inlineId=formPostCover" class="thickbox">'.$lc_Upload_Cover.'</a></div>
';
	}
      //MAIN FORM
      if($_SESSION["level"]>1)
	{	  
	  echo "<div id=\"main_issue_form\" style=\"display:none;\"><form method=\"post\" >\n";
	  echo '     <table><tr><td>'.$lc_Issue_Publication_Date.'</td><td><select name="publication_month">'.select_month($myIssue->month).'</select></td><td><select name="publication_year">'.select_year($myIssue->year).'</select></td></tr>';
	  
	  echo '<tr><td>'.$lc_Issue_Cover_Price.'</td><td><select name="currency_select">';
	  //Get currencies 
	  $requete_currencies = "SELECT * FROM mc_currencies";
	  $envoi_requete_currencies = $myDB->send_query($requete_currencies);
	  $table_currencies = array();
	  while($temp = $myDB->get_array($envoi_requete_currencies, 'NUMERIC'))
	    $table_currencies[$temp[0]]=$temp[1];
	  echo  '<option value=""></option>\n';
	  foreach ($table_currencies as $key => $value){
	    echo '<option value="'.$key.'"';
	    if($myIssue->cover_currency==$key) echo ' selected="selected"';
	    echo  '>'.$value.'</option>\n';}
	  echo '</select></td><td><input type="text" name="cover_price_text" value="'.$myIssue->cover_price.'"/></td></tr>';
	  echo '<tr><td><input type="submit" value="'.$lc_Update.'" name="main_form_submit"/></td><td></td></tr></table>';
	  echo "\n</form></div>\n\n";
	}
      //Publication date      
      echo '<div class="parag">';
      echo '  <div id="publication">';
      if($myIssue->year==0) $myIssue->year="";
      if(($myIssue->year!="")||($_SESSION["level"]>1))
	echo $lc_Issue_Publication_Date." : ".$lc_months[$myIssue->month]." ".$myIssue->year;
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_issue_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo "</div>\n";
      
      //Cover Price   
      if($myIssue->cover_price==0) $myIssue->cover_price="";
      echo '<div id="cover_price">';
      if(($myIssue->cover_price!="")||($_SESSION["level"]>1))
	echo $lc_Issue_Cover_Price.' : '.$myIssue->cover_currency." ".$myIssue->cover_price;
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_issue_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo "</div>\n";
      echo "</div>\n\n";
      
      //MAIN STORY
      if($myIssue->nb_pages==0) $myIssue->nb_pages="";
      //form
      $mySummary = parse_content($myIssue->summary,"summary");
      if($_SESSION["level"]>1)	  
	{
	  echo "<div id=\"main_story_form\" style=\"display:none\"><form method=\"post\">\n";
	  echo '<table><tr><td>'.$lc_Issue_Title.'</td><td><input name="main_story_title" value="'.$myIssue->title.'"/></td></tr>';
	  echo '<tr><td>'.$lc_Pages.'</td><td><input type="text" name="main_story_page_number" size="3" value="'.$myIssue->nb_pages.'"/></td></tr>';
	  echo '<tr><td>'.$lc_Issue_Black_White.'</td><td><input type="checkbox" name="main_story_isBlackNWhite"';
	  if($myIssue->black_n_white == 1)
	    echo ' checked="checked"';
	  echo '/></td></tr>';
	  echo '<tr><td>'.$lc_Issue_Genre.'</td><td><select name="main_story_genre"><option value=""></option>';
	  foreach ($lc_genres as $key => $value){
	    echo '<option value="'.$key.'"';
	    if($myIssue->genre==$key) echo ' selected="selected"';
	    echo  '>'.$value.'</option>\n';}
	  echo '</select></td></tr>';
	  echo '<tr><td colspan=2><textarea name="main_story_summary_text" rows=10 COLS=40>'.$mySummary.'</textarea></td></tr>';
	  echo '<tr><td><input type="submit" value="'.$lc_Update.'" name="main_story_submit"/></td><td></td></tr></table>';
	  echo "</form></div>\n\n";
	}
      //display
      echo "<div id=\"main_story\" class=\"parag\"><h3>".$lc_Issue_Main_Story."</h3></div>\n";
      
      echo "<div class=\"parag\">\n";
      echo '<div id="main_title"><h3>';
      if(($myIssue->title!="")||($_SESSION["level"]>1))
	echo $lc_Issue_Title.' : '.$myIssue->title;
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo "</h3></div>\n";
      //Page number
      echo '<div id="main_story_page_number"><p>';
      if(($myIssue->nb_pages!="")||($_SESSION["level"]>1))
      echo $lc_Pages." : ".$myIssue->nb_pages;
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo '</p></div>';
      //Color     
      echo '<div id="main_story_black_n_white"><p>';
      if($myIssue->black_n_white == 1)
	echo $lc_Issue_Black_White;
      else echo $lc_Issue_Color;
       if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo "</p></div>\n";
      //Genre
      echo '<div id="main_story_genre"><p>';
      if(($myIssue->genre!="")||($_SESSION["level"]>1))
	echo $lc_Issue_Genre." : ".$lc_genres[$myIssue->genre];
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=300&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      echo "</p></div>\n";
      //summary   
      echo '<div id="main_story_summary">';
      if(($mySummary!="")||($_SESSION["level"]>1))
	echo "<h3>".$lc_Issue_Summary;
      if($_SESSION["level"]>1)
	echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
      if(($mySummary!="")||($_SESSION["level"]>1))
	echo "</h3>";
      echo "<div>".$mySummary."</div>";
      echo "</div>\n";
      echo "</div>\n\n";
      
      $requete_issue_workers = 'SELECT mc_works.role,mc_works.pages, mc_works.id_story, mc_artists.id_artist, mc_artists.first_name, mc_artists.middle_name, mc_artists.last_name FROM mc_works,mc_artists WHERE mc_works.id_series="'.$myIssue->id_series.'" AND mc_works.issue="'.$myIssue->number.'" AND mc_works.id_artist=mc_artists.id_artist AND mc_works.id_story="0" ORDER BY mc_artists.last_name ASC, mc_artists.first_name ASC, mc_artists.middle_name ASC;';
      
      $envoi_requete_workers = $myDB->send_query($requete_issue_workers);
      $table_workers = array();
      while($table_requete_workers = $myDB->get_array($envoi_requete_workers, 'NUMERIC'))
	{
	  $myArtist = new Artist(array_splice($table_requete_workers,3));
	  $myWorker = new Worker($myArtist,$table_requete_workers[0],$table_requete_workers[1]);
	  array_push($table_workers,$myWorker);
	}
      $myIssue->fill_Issue_Workers($table_workers);
      $compteur_stories = 0;

      $requete_all_artists = 'SELECT * FROM mc_artists ORDER BY mc_artists.last_name ASC, mc_artists.first_name ASC, mc_artists.middle_name ASC;';
      $envoi_requete_all_artists = $myDB->send_query($requete_all_artists);
      $artists_list = array();
      while($table_all_artists = $myDB->get_array($envoi_requete_all_artists, 'NUMERIC'))
	{
	  $myArtist = new Artist($table_all_artists);
	  array_push($artists_list,$myArtist);
	}
      
      display_story_artists($table_workers,$compteur_stories,$artists_list);
      $compteur_stories++;

      //---- BACKSTORIES ---
      //Reste à afficher les histoires secondaires
      $requete_list_stories = 'SELECT * FROM mc_stories WHERE id_series="'.$id_series.'" AND issue="'.$issue.'"';
      $envoi_requete_stories = $myDB->send_query($requete_list_stories);
      $nb_occur = $myDB->num_rows();
      if($nb_occur != 0)
	{
	  while($table_requete_stories = $myDB->get_array($envoi_requete_stories, 'NUMERIC'))
	    {
	      $myStory = new Story($table_requete_stories);
	      echo '<div class="parag">';
	      echo "<div id=\"story".$compteur_stories."\" class=\"story\"><h3>".$lc_BackStory ." :</h3></div>\n";
	      if($myStory->nb_pages==0) $myStory->nb_pages="";
	      $mySummary = parse_content($myStory->comment,"comment");
	      if($_SESSION["level"]>1)
		{
		  
		  echo '     <div id="story_'.$compteur_stories.'_form" style="display:none"><form method="post"><input type="hidden" name="updated_story" value="'.$compteur_stories.'"/>
  <table>
     <tr><td>'.$lc_Issue_Title.'</td><td><input name="story'.$compteur_stories.'_title" value="'.$myStory->title.'"/></td></tr>
     <tr><td>'.$lc_Issue_Pages.'</td><td><input type="text" name="story'.$compteur_stories.'_page_number" size="3" value="'.$myStory->nb_pages.'"/></td></tr>
     <tr><td>'.$lc_Issue_Black_White.'</td><td><input type="checkbox" name="story'.$compteur_stories.'_isBlackNWhite"';
		  if($myStory->black_n_white == 1)
		    echo ' checked="checked"';
		  echo '/></td></tr>
     <tr><td>'.$lc_Issue_Genre.'</td><td><select name="story'.$compteur_stories.'_genre"><option value=""></option>';
		  foreach ($lc_genres as $key => $value){
		    echo '<option value="'.$key.'"';
		    if($myStory->genre==$key) echo ' selected="selected"';
		    echo  '>'.$value.'</option>';
		  }
echo '</select></td></tr>
     <tr><td colspan=2><textarea name="story_summary'.$compteur_stories.'_text"  rows=10 COLS=40>'.$mySummary.'</textarea></td></tr>
     <tr><td colspan=2><input type="submit" value="'.$lc_Update.'" name="submit_story"/></td></tr>
</table>';
		  echo "</form></div>\n\n";
		  	}
	      
	      echo "<div id=\"story_title".$compteur_stories."\">\n";
	      if(($myStory->title!="")||($_SESSION["level"]>1))
		{
		  echo '<h3>'.$lc_Issue_Title." : ".$myStory->title;
		  if($_SESSION["level"]>1)
		    echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=story_'.$compteur_stories.'_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
		  echo "</h3>\n";
		}
	      echo "</div>\n";
	      //Page number
	      echo '<div id="story_page_number'.$compteur_stories.'">
   <p>';
	      if(($myStory->nb_pages!="")||($_SESSION["level"]>1))
		echo $lc_Pages." : ".$myStory->nb_pages;
	      if($_SESSION["level"]>1)
		echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=story_'.$compteur_stories.'_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
	      echo '</p></div>';
	      //Color     
	      echo '<div id="story_black_n_white'.$compteur_stories.'">
   <p>';
	      if($myStory->black_n_white == 1)
		echo $lc_Issue_Black_White;
	      else echo $lc_Issue_Color;
	      if($_SESSION["level"]>1)
		echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=story_'.$compteur_stories.'_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
	      echo '</p></div>';
		 //Genre
	      echo '<div id="story_genre'.$compteur_stories.'"><p>';
	      if(($myStory->genre!="")||($_SESSION["level"]>1))
		echo $lc_Issue_Genre." : ".$lc_genres[$myStory->genre];
	      if($_SESSION["level"]>1)
		echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=story_'.$compteur_stories.'_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
	      echo '</p></div>';
	      //summary      
	      echo '<div id="story_summary'.$compteur_stories.'">';
	      if(($mySummary!="")||($_SESSION["level"]>1))
		echo "<h3>".$lc_Issue_Summary;
	      if($_SESSION["level"]>1)
		echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=main_story_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
	      if(($mySummary!="")||($_SESSION["level"]>1))
		echo "</h3>";
	      echo "<div>".$mySummary."</div>\n";
	      echo "</div>\n"; 
	      
	      echo "</div>\n\n";
	      
	      $table_workers_story = array();
	      
	      $requete_story_workers = 'SELECT mc_works.role, mc_works.pages, mc_works.id_story, mc_artists.id_artist, mc_artists.first_name, mc_artists.middle_name, mc_artists.last_name FROM mc_works,mc_artists WHERE mc_works.id_series="'.$myIssue->id_series.'" AND mc_works.issue="'.$myIssue->number.'" AND mc_works.id_artist=mc_artists.id_artist AND mc_works.id_story="'.$myStory->id_story.'" ORDER BY mc_artists.last_name ASC, mc_artists.first_name ASC, mc_artists.middle_name ASC;';
	      $envoi_requete_stories_workers = $myDB->send_query($requete_story_workers);
	      $nb_occur_stories = $myDB->num_rows();
	      if($nb_occur_stories != 0)
		{
		  while($table_requete_workers_story = $myDB->get_array($envoi_requete_stories_workers, 'NUMERIC'))
		    {
		      $myArtist = new Artist(array_splice($table_requete_workers_story,3));
		      $myWorker = new Worker($myArtist,$table_requete_workers_story[0], $table_requete_workers_story[1]);
		      array_push($table_workers_story,$myWorker);
		    }
		}
	      
	      display_story_artists($table_workers_story,$compteur_stories,$artists_list);

	      $compteur_stories++;
	    }
	  
	}

      //Add a new story
       //form
      if($_SESSION["level"]>1)	  
	{
	  echo '<p class="parag"><a href="#TB_inline?height=155&amp;width=300&amp;inlineId=add_story_form&amp;modal=false" class="thickbox">'.$lc_Add_Backup_Story.'</a></p>';
	  
	  echo '<div id="add_story_form" style="display:none"><form method="post"><p>'.$lc_Issue_Title.' : <input type="text" name="add_story_title"/></p>';
	  echo '<p>'.$lc_Issue_Genre.' : <select name="add_story_genre">';
	  echo  '<option value=""></option>\n';
	  foreach ($lc_genres as $key => $value){
	    echo '<option value="'.$key.'">'.$value.'</option>\n';}
	  
	  echo '</select>'.$lc_Pages.' : <input type="text" name="add_story_pages" size="3"/></p>';	  
	  echo '<p>'.$lc_Issue_Black_White.' <input type="checkbox" name="add_story_black_n_white"/><input type="submit" value="'.$lc_Update.'" name="add_story_submit"/></p></form></div>';
	}      
      
      
      if(($myIssue->id_arc!=0)&&($myIssue->id_arc!=""))
	{
	  echo "<div class=\"parag\">";
	  $requete_issue_arc = 'SELECT * FROM mc_arcs WHERE id_arc="'.$myIssue->id_arc.'";';
	  $envoi_requete_arc = $myDB->send_query($requete_issue_arc);
	  $nb_occur = $myDB->num_rows();
	  if(($nb_occur != 0)&&($nb_occur != ""))
	    if($lignObj = $myDB->get_object($envoi_requete_arc))
	      {
		if($lignObj->id_series != 0)
		  echo "<div id=\"crossover\"><h3>".$lc_Story_Arc." :</h3></div>\n";
		else
		  if($lignObj->id_publisher != 0)
		    echo "<div id=\"crossover\"><h3>".$lc_Crossover." :</h3></div>\n";
		  else echo "<div id=\"crossover\"><h3>".$lc_InterCompany_Crossover." :</h3></div>\n";
		echo "<div id=\"crossover_title\"><a href=\"index.php?rub=arc&amp;id_arc=".$myIssue->id_arc."\">".$lignObj->label."</a></div>\n";
		if(($myIssue->reading_order!=0)&&($myIssue->reading_order!=""))
		  {
		    echo '<div id="crossover_order_main"><p>'.$lc_Issue_Reading_Order." : ".$myIssue->reading_order;
		    if($_SESSION["level"]>1)
		      echo ' <a href="#TB_inline?height=155&amp;width=400&amp;inlineId=crossover_order_form&amp;modal=false" class="thickbox"><img alt="'.$lc_Update.'" src="'.THEME.'images/edit.gif"/></a>';
		    echo '</p></div>';
		    if($_SESSION["level"]>1)
		      {
			echo '<div id="crossover_order_form" style="display:none"><form method="post"><input type="hidden" name="new_story_arc_id" value="'.$myIssue->id_arc.'"/>'.$lc_Issue_Reading_Order.' : <select name="reading_order_select">';
			for($i=0;$i<200;$i++)
			  {
			    echo '<option value="'.$i.'"';
			    if($i==$myIssue->reading_order) echo ' selected="selected"';
			    echo '>';
			    if($i!=0) echo $i;
			    echo '</option>';
			  }
			echo '</select>';
			echo '<input type="submit" value="'.$lc_Update.'" name="new_story_arc_submit"/></form></div>';
		      }
		  }

		if($_SESSION["level"]>1)
		  echo '<p><form method="post"><input type="hidden" name="story_arc_id" value="'.$myIssue->id_arc.'"/><input type="submit" value="'.$lc_Delete.'" name="delete_story_arc"/></form></p>';
		
	      }
	  echo "</div>\n\n";
	}
      else 
	{
	  if($_SESSION["level"]>1)
	    {
	      echo '<div class="parag"><a href="#TB_inline?height=155&amp;width=400&amp;inlineId=new_crossover&amp;modal=false" class="thickbox"><p>'.$lc_Add_StoryArc."</a></p></div>";
	      echo '<div id="new_crossover" style="display:none"><form method="post">
<table><tr><td></td><td><select id="arcchooser" name="arcchooser"  \'index.php?rub=arc&format=xml&id_publisher='.$mySeries->publisher.'&id_series='.$id_series.'\', this);" >
<option value=""></option>
<option value="arc">'.$lc_Story_Arc.'</option>
<option value="xover">'.$lc_Crossover.'</option>
<option value="icc">'.$lc_InterCompany_Crossover.'</option></select></td></tr>
<tr><td></td><td><select name="new_story_arc_id" id="new_story_arc_id" style="display:none">';
	      echo '</select></td></tr>
<tr><td>'.$lc_Issue_Reading_Order.'</td><td><select name="reading_order_select">';
	      for($i=0;$i<200;$i++)
		{
		  echo '<option value="'.$i.'">';
		  if($i!=0) echo $i;
		  echo '</option>';
		}
	      echo '</select></td></tr>
<tr><td colspan=2><input type="submit" value="'.$lc_Update.'" name="new_story_arc_submit"/></td></tr></table></form></div>';
	    }
	}


      
      //links
      function print_link($array_link,$category_link,$compteur_link,$category_label)
	{
	  global $lc_Internal_Links;
	  $inner_counter=0;
	  for($i=0;$i<sizeOf($array_link);$i++)
	    {
	      if(($inner_counter==0)&&($array_link[$i][4]==$category_link))
		echo "<h4>".$category_label."</h4>";
	      if($array_link[$i][4]==$category_link)
		{
		  echo '<div id="links_url'.$compteur_link.'">';
		  if($_SESSION["level"]>1)
		    echo '<input type="checkbox" name="check_Links_Remove[]" value="'.$array_link[$i][0].'"/>';
		  echo '<a href="'.$array_link[$i][3].'">'.$array_link[$i][5].'</a></div>';
		  $inner_counter++;
		}
	      $compteur_link++;
	    }
	}
      
      $requete_issue_links = 'SELECT * FROM mc_issue_links WHERE id_series="'.$myIssue->id_series.'" AND issue="'.$myIssue->number.'" ORDER BY link_type ASC ;';
      $envoi_requete_links = $myDB->send_query($requete_issue_links);
      $nb_occur = $myDB->num_rows();
      if(($nb_occur != 0)&&($nb_occur != ""))
	{
	  $array_links = array();
	  while($tableLigne = $myDB->get_array($envoi_requete_links,'NUMERIC'))
	    {
	      array_push($array_links,$tableLigne);
	    }
	  
	  if(sizeOf($array_links)>0)
	    {
	      echo "<div id=\"links\" class=\"parag\"><h3>".$lc_Links."</h3></div>\n";
	      $compteur_links = 1;
	      if($_SESSION["level"]>1)
		echo '<div id="links_form_div"><form method="post">';
	      print_link($array_links, "MDC", $compteur_links,$lc_Internal_Links);
	      print_link($array_links, "AMZ", $compteur_links,$lc_Amazon_Links);
	      print_link($array_links, "OCL", $compteur_links,$lc_Commercial_Links);
	      print_link($array_links, "OEL", $compteur_links,$lc_Other_Links);
	      if($_SESSION["level"]>1)
		echo '<input type="submit" name="remove_links_submit" value="'.$lc_Delete.'"/></form></div>';
	      
	    }
	}


	  if($_SESSION["level"]>1)
	    {
	      if($_SESSION["level"]>1)
		echo '<p class="parag"><a href="#TB_inline?height=155&amp;width=400&amp;inlineId=add_link_form&amp;modal=false" class="thickbox">'.$lc_Add_Link."</a></p>";
	      echo '<div id="add_link_form" style="display:none"><form method="post">
<table><tr><td>'.$lc_Issue_Title.'</td><td><input type="text" name="new_link_label"/></td></tr>
<tr><td>URL</td><td><input type="text" name="new_link_url"/></td></tr>
<tr><td colspan=2><select name="new_link_type"/>';
	      echo '<option value="MDC">'.$lc_Internal_Links.'</option>';
	      echo '<option value="AMZ">'.$lc_Amazon_Links.'</option>';
	      echo '<option value="OCL">'.$lc_Commercial_Links.'</option>';
	      echo '<option value="OEL">'.$lc_Other_Links.'</option>';
	      echo '</select></td></tr>
<tr><td colspan=2><input type="submit" name="new_link_submit" value="'.$lc_Update.'"/></td></tr></table></form></div>';
	      
	    }

      //Get currencies and conditions
      $requete = "SELECT * FROM mc_currencies";
      $envoi_requete = $myDB->send_query($requete);
      $table_currencies = array();
      while($temp = $myDB->get_array($envoi_requete, 'NUMERIC'))
	//     array_push($table_currencies,array($temp[0],$temp[1]));
	$table_currencies[$temp[0]]=$temp[1];
      $requete = "SELECT * FROM mc_conditions";
      $envoi_requete = $myDB->send_query($requete);
      $table_conditions = array();
      while($temp = $myDB->get_array($envoi_requete, 'NUMERIC'))
	array_push($table_conditions,array($temp[0],$temp[1]));


      
      //selling users
      $requete_issue_sellers = 'SELECT * FROM mc_forsale, mc_users WHERE mc_forsale.id_series="'.$myIssue->id_series.'" AND mc_forsale.issue="'.$myIssue->number.'" AND mc_forsale.id_user=mc_users.id_user AND mc_users.allow="yes" ORDER BY mc_users.login ASC ;';
      $envoi_requete_sellers = $myDB->send_query($requete_issue_sellers);
      $nb_occur = $myDB->num_rows();
      if(($nb_occur != 0)&&($nb_occur != ""))
	{
	  echo "<div id=\"sellers\" class=\"parag\"><h3>".$lc_Sellers." :</h3></div>\n ";
	  $compteur_sellers = 1;
	  while($table_sellers = $myDB->get_array($envoi_requete_sellers,'NUMERIC'))
	    {
	      $myUser = new User(array_slice($table_sellers,6));
	      echo "<div id=\"seller".$compteur_sellers."\"><a href=\"index.php?rub=profile&amp;id_user=".$myUser->id_user."\">".$myUser->login."</a>";
	      if(($table_sellers[3]!=0)&&($table_sellers[4]!=""))
		echo " - ".$table_sellers[4]." ".$table_sellers[3];
	      if($table_sellers[5]!="")
		for($i=0;$i<sizeOf($table_conditions);$i++)
		  if($table_conditions[$i][0]==$table_sellers[5])
		     echo " - ".$table_conditions[$i][1];
	      echo "</div>\n";
	      $compteur_sellers++;
	    }
	}
      
    }
}
 require_once THEME.('footer.inc.php');

?>