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;
    }
}

$error_messages = array();

//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 DATA.('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&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"]."',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"]))."', comment='".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 DATA.('header.inc.php');
      
      echo "<div id=\"warning2\">".$lc_Msg_No_Occur."</div>\n";
      echo "<div id=\"goback3\"><a href=\"index.php?rub=series&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 DATA.('header.inc.php');

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


      echo "<div id=\"series_title\"><h1><a href=\"index.php?rub=series&id_series=".$mySeries->id_series."&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"))
	     {
	     if(is_file (PREVIEWCOVER.$id_series."_".$issue.".jpg"))
		    echo "<a href=\"javascript:display_image('".COVER.$id_series."_".$issue.".jpg','".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."')\"><img src=\"".PREVIEWCOVER.$id_series."_".$issue.".jpg\" alt=\"".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."\"/></a>";
	     else echo "<a href=\"".COVER.$id_series."_".$issue.".jpg\"><img src=\"images/no_thumb.jpg\" alt=\"".$mySeries->name." vol.".$mySeries->volume." #".$myIssue->number."\"/></a>";
		 }
	  $check_extensions = get_loaded_extensions();
      if(($_SESSION["level"]>1)&&(in_array("gd",$check_extensions)))
           echo '<form method="post" enctype="multipart/form-data">
                <input type="file" name="fichier_cover" size="10">
                <input type="submit" name="upload_cover" value="Upload">
                </form>';
      echo '<div id="div_kingsize" style="position:absolute;top:0px;left:0px;height:100%;width:100%;visibility:hidden;background-color:black;text-align:center;padding-top : 20px;" >;
      echo "</div>\n";
      //MAIN FORM
      if($_SESSION["level"]>1)	  
	echo "<form method=\"POST\" id=\"main_issue_form\" class=\"borderform\">";
      //Publication date      
      echo '<div id="publication"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div ';
      if($_SESSION["level"]>1)
	echo 'class="updatable"';
      echo '>'.$lc_Issue_Publication_Date." : ".$lc_months[$myIssue->month]." ".$myIssue->year.'</div>';
      if($_SESSION["level"]>1)
	{
	  echo '     <div id="publication_form" style="display:none">'.$lc_Issue_Publication_Date.' <select name="publication_month">'.select_month($myIssue->month).'</select><select name="publication_year">'.select_year($myIssue->year).'</select></div>';
	}
      echo '</div>';      
      //Cover Price   
      if($myIssue->cover_price==0) $myIssue->cover_price="";
      echo '<div id="cover_price"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div ';
      if($_SESSION["level"]>1)
	echo 'class="updatable"';
      echo '>'.$lc_Issue_Cover_Price.' : '.$myIssue->cover_currency." ".$myIssue->cover_price.'</div>';
      if($_SESSION["level"]>1)
	{
	  echo '     <div id="cover_price_form" style="display:none">'.$lc_Issue_Cover_Price.' : <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><input type="text" name="cover_price_text" value="'.$myIssue->cover_price.'"/></div>';
	}
      echo '</div>';      
      //end main form
      if($_SESSION["level"]>1)
	{
	  echo '<input type="submit" value="'.$lc_Update.'" name="main_form_submit"/></form>';
	}

      //MAIN STORY
      echo "<hr/>\n";
      echo "<div id=\"main_story\" class=\"story\"><h3>".$lc_Issue_Main_Story."</h3></div>\n";
      
      if($_SESSION["level"]>1)	  
	echo "<form method=\"POST\" id=\"main_story_form\" class=\"borderform\">";
      
      echo '<div id="main_title"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div';
      if($_SESSION["level"]>1)
	echo ' class="updatable"';
      echo '><h3>'.$myIssue->title.'</h3></div>';
      if($_SESSION["level"]>1)
	{
	  if($myIssue->title=="")
	    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Title."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Title.".";	
	  echo '     <div id="main_title_form" style="display:none"><input name="main_story_title" value="'.$myIssue->title.'"/></div>';
	}
      echo '</div>'; 
      //Page number
      if($myIssue->nb_pages==0) $myIssue->nb_pages="";
      echo '<div id="main_story_page_number"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div';
      if($_SESSION["level"]>1)
	echo ' class="updatable"';
      echo '><p>';
      if($myIssue->nb_pages!="")
	echo $lc_Pages." : ".$myIssue->nb_pages;
      echo '</p></div>';
      if($_SESSION["level"]>1)
	{
	  if($myIssue->nb_pages=="")
	    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_NbPages."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_NbPages.".";
	  echo '     <div id="main_story_page_number_form" style="display:none">'.$lc_Pages.' : <input type="text" name="main_story_page_number" size="3" value="'.$myIssue->nb_pages.'"/>';
	  echo '</div>';
	}
      echo '</div>';
      //Color     
      echo '<div id="main_story_black_n_white"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div';
      if($_SESSION["level"]>1)
	echo ' class="updatable"';
      echo '><p>';
      if($myIssue->black_n_white == 1)
	echo $lc_Issue_Black_White;
      else echo $lc_Issue_Color;
      echo '</p></div>';
      if($_SESSION["level"]>1)
	{
	  echo '     <div id="main_story_black_n_white_form" style="display:none">'.$lc_Issue_Black_White.'<input type="checkbox" name="main_story_isBlackNWhite"';
	  if($myIssue->black_n_white == 1)
	    echo ' checked="checked"';
	  echo '/></div>';
	}
      echo '</div>'; 
      //Genre
      echo '<div id="main_story_genre"';
      if($_SESSION["level"]>1)
	echo ' >;
      echo '><div';
      if($_SESSION["level"]>1)
	echo ' class="updatable"';
      echo '><p>';
      if($myIssue->genre!="")
	echo $lc_Issue_Genre." : ".$lc_genres[$myIssue->genre];
      echo '</p></div>';
      if($_SESSION["level"]>1)
	{
	  if($myIssue->genre=="")
	    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Genre."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Genre.".";
	  echo '     <div id="main_story_genre_form" style="display:none"><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></div>';
	}
      echo '</div>';
      
      //summary      
      echo '<div id="main_story_summary"';
      if($_SESSION["level"]>1)
	echo ' >;
      $mySummary = parse_content($myIssue->summary,"summary");
      echo '><div';
      if($_SESSION["level"]>1)
	echo ' class="updatable"';
      echo '>'.$mySummary.'</div>';
      if($_SESSION["level"]>1)
	{
	  if($mySummary=="")
	    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Summary."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Summary.".";	
	  echo '     <div id="main_story_summary_form" style="display:none"><textarea name="main_story_summary_text" style="width:100%">'.$mySummary.'</textarea></div>';
	}
      echo '</div>'; 
      //End main story form
      if($_SESSION["level"]>1)
	{
	  echo '<input type="submit" value="'.$lc_Update.'" name="main_story_submit"/></form>';
	}      
      
      $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'))
	    {
	      echo "<hr/>\n";
	      $myStory = new Story($table_requete_stories);
	      echo "<div id=\"story".$compteur_stories."\" class=\"story\"><h3>".$lc_BackStory ." :</h3></div>\n";
	      if($_SESSION["level"]>1)
		echo '<form method="POST" class="borderform"><input type="hidden" name="updated_story" value="'.$compteur_stories.'"/>
';
	      echo "<div id=\"story_title".$compteur_stories."\"";
	      if($_SESSION["level"]>1)
		echo ' >.$compteur_stories.'\')"';
	      echo '><div';
	      if($_SESSION["level"]>1)echo ' class="updatable"';
	      echo '><h3>'.$myStory->title.'</h3></div>';
	      if($_SESSION["level"]>1)
		{
		  if($myStory->title=="")
		    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Title."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Title.".";	
		  echo '     <div id="story_title'.$compteur_stories.'_form" style="display:none"><input name="story'.$compteur_stories.'_title" value="'.$myStory->title.'"/></div>';
		}
	      echo '</div>'; 
	      //Page number
	      if($myStory->nb_pages==0) $myStory->nb_pages="";
	      echo '<div id="story_page_number'.$compteur_stories.'"';
	      if($_SESSION["level"]>1)
		echo ' >.$compteur_stories.'\')"';
	      echo '><div';
	      if($_SESSION["level"]>1) echo ' class="updatable"';
	      echo '><p>';
	      if($myStory->nb_pages!="")
		echo $lc_Pages." : ".$myStory->nb_pages;
	      echo '</p></div>';
	      if($_SESSION["level"]>1)
		{
		  if($myStory->nb_pages=="")
		    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_NbPages."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_NbPages.".";
		  echo '     <div id="story_page_number'.$compteur_stories.'_form" style="display:none">Pages : <input type="text" name="story'.$compteur_stories.'_page_number" size="3" value="'.$myStory->nb_pages.'"/>';
		  echo '</div>';
		}
	      echo '</div>';
	      //Color     
	      echo '<div id="story_black_n_white'.$compteur_stories.'"';
	      if($_SESSION["level"]>1)
		echo ' >.$compteur_stories.'\')"';
	      echo '><div';
	      if($_SESSION["level"]>1)echo' class="updatable"';
	      echo   '><p>';
	      if($myStory->black_n_white == 1)
		echo $lc_Issue_Black_White;
	      else echo $lc_Issue_Color;
	      echo '</p></div>';
	      if($_SESSION["level"]>1)
		{
		  echo '     <div id="story_black_n_white'.$compteur_stories.'_form" style="display:none">'.$lc_Issue_Black_White.'<input type="checkbox" name="story'.$compteur_stories.'_isBlackNWhite"';
		  if($myStory->black_n_white == 1)
		    echo ' checked="checked"';
		  echo '/></div>';
		}
	      echo '</div>'; 
	      //Genre
	      echo '<div id="story_genre'.$compteur_stories.'"';
	      if($_SESSION["level"]>1)
		echo ' >.$compteur_stories.'\')"';
	      echo '><div';
	      if($_SESSION["level"]>1) echo ' class="updatable"';
	      echo '><p>';
	      if($myStory->genre!="")
		echo $lc_Issue_Genre." : ".$lc_genres[$myStory->genre];
	      echo '</p></div>';
	      if($_SESSION["level"]>1)
		{
		  if($myStory->genre=="")
		    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Genre."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Genre.".";
		  echo '     <div id="story_genre'.$compteur_stories.'_form" style="display:none"><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>\n';}
		  echo '</select></div>';
		}
	      echo '</div>';
	      //summary      
	      echo '<div id="story_summary'.$compteur_stories.'"';
	      if($_SESSION["level"]>1)
		echo ' >.$compteur_stories.'\')"';
	      $mySummary = parse_content($myStory->comment,"comment");
	      echo '><div';
	      if($_SESSION["level"]>1) echo' class="updatable"';
	      echo '>'.$mySummary.'</div>';
	      if($_SESSION["level"]>1)
		{
		  if($mySummary=="")
		    echo "<img src=\"images/add.gif\" alt=\"".$lc_Click_Update_Summary."\" style=\"cursor:pointer;\"/>".$lc_Click_Update_Summary.".";	
		  echo '     <div id="story_summary'.$compteur_stories.'_form" style="display:none"><textarea name="story_summary'.$compteur_stories.'_text" style="width:100%">'.$mySummary.'</textarea></div>';
		}
	      echo '</div>'; 
	      if($_SESSION["level"]>1) echo '<input type="submit" value="'.$lc_Update.'" name="submit_story"/></form>';	      
	      
	      $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
      if($_SESSION["level"]>1)
	{
	  echo '<hr/>
 <p>'.$lc_Add_Backup_Story.' :</p>
<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>';
	}      
      
      
      if(($myIssue->id_arc!=0)&&($myIssue->id_arc!=""))
	{
	  echo "<hr/>\n";
	  $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&id_arc=".$myIssue->id_arc."\">".$lignObj->label."</a></div>\n";
		if(($myIssue->reading_order!=0)&&($myIssue->reading_order!=""))
		  {
		    echo '<div id="crossover_order_main" class="borderform"';
		    if($_SESSION["level"]>1)
		      echo ' >;
		    echo '><div id="crossover_order"';
		    if($_SESSION["level"]>1) echo' class="updatable"';
		    echo '><p>'.$lc_Issue_Reading_Order." : ".$myIssue->reading_order.'</p></div>';
		    if($_SESSION["level"]>1)
		      {
			echo '<form method="POST"><div id="crossover_order_form" style="display:none">';
			echo '<input type="hidden" name="new_story_arc_id" value="'.$myIssue->id_arc.'"/>';
			echo $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"/></div></form>';
		      }
		    echo '</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>';
		
	      }
	}
      else 
	{
	  if($_SESSION["level"]>1)
	    {
	      echo "<hr/>";
	      echo "<p>".$lc_Add_StoryArc."</p>";
	      $crossover_type = $_GET["crossover_type"];
	      switch($crossover_type)
		{
		case "arc":
		  $request_series=$id_series;
		  $request_company=$mySeries->publisher;
		  break;
		case "xover":
		  $request_series=0;
		  $request_company=$mySeries->publisher;
		  break;
		case "icc":
		  $request_company=0;
		  $request_series=0;
		  break;
		}
	      if($crossover_type!="")
		{
		  $requete_arcs_list = "SELECT * FROM mc_arcs where id_series='".$request_series."' AND id_publisher='".$request_company."' ORDER BY label ASC;";
		  $envoi_requete_arcs_list = $myDB->send_query($requete_arcs_list);
		  $nb_occur = $myDB->num_rows();
		  if(($nb_occur != 0)&&($nb_occur != ""))
		    {
		      echo '<p><form method="POST"><select name="new_story_arc_id">';
		      while($lignObj = $myDB->get_object($envoi_requete_arcs_list))
			{
			  echo '<option value="'.$lignObj->id_arc.'">'.$lignObj->label.'</option>"';
			}
		      echo '</select> '.$lc_Issue_Reading_Order.' : <select name="reading_order_select">';
		      for($i=0;$i<200;$i++)
			{
			  echo '<option value="'.$i.'">';
			  if($i!=0) echo $i;
			  echo '</option>';
			}
		      echo '</select><input type="submit" value="'.$lc_Update.'" name="new_story_arc_submit"/></form></p>';
		    }			
		  echo '<p><a href="index.php?rub=issue&issue='.$issue.'&id_series='.$id_series.'">'.$lc_Cancel.'</a></p>';
		}
	      else
		{
		  echo '<p><a href="'.$_SERVER['REQUEST_URI'].'&crossover_type=arc'.'">'.$lc_Story_Arc.'</a></p>';
		  echo '<p><a href="'.$_SERVER['REQUEST_URI'].'&crossover_type=xover'.'">'.$lc_Crossover.'</a></p>';
		  echo '<p><a href="'.$_SERVER['REQUEST_URI'].'&crossover_type=icc'.'">'.$lc_InterCompany_Crossover.'</a></p>';
		}
	    }
	}


      
      //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 "<hr/>";
	      echo "<div id=\"links\"><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)
	    {
	      echo "<hr/>";
	      echo "<p>".$lc_Add_Link."</p>";
	      echo '<form method="POST"><p>'.$lc_Issue_Title.' : <input type="text" name="new_link_label"/>';	      echo '<p>URL : <input type="text" name="new_link_url"/>';
	      echo '<p><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></p>';

	      echo '<p><input type="submit" name="new_link_submit" value="'.$lc_Update.'"/></p></form>';
	      
	    }

      //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 "<hr/>";
	  echo "<div id=\"sellers\"><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&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++;
	    }
	}
      
    }
}

?>