MadCollector Code

<?php
/* This file is part of Madcollector.
* Madcollector created by Thomas Andrieu,
* Developped by 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.

* 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/user.class.php');
require_once LIBS.('classes/publisher.class.php');
require_once LIBS.('classes/series.class.php');
require_once LIBS.('classes/issue.class.php');

if(!isset($_GET["action"]))  $_GET["action"]="";

$idUser = $_GET['id_user'];

$requete_user = 'SELECT  id_user,login,email,level,public_profile,language,allow_PM,signature,last_connexion,register_date FROM '.$cfg_table_prefix.'users where id_user=\''.$idUser.'\';';
$envoi_requete_user = mysql_query($requete_user,$DB_connexion);
if($envoi_requete_user) $nb_occur_user = mysql_num_rows($envoi_requete_user);
if(($nb_occur_user == 0)||($nb_occur_user == ""))
{
  $header_title = $locales["Msg_No_Occur"];
  require_once THEME.('header.inc.php');
  echo "<p>".$locales["Msg_No_Occur"]."</p>"; 
}
else
{
  $myUser = new User(mysql_fetch_array($envoi_requete_user, MYSQL_BOTH));
  $header_title = $locales["Profile"]." : ".$myUser->login;
  require_once THEME.('header.inc.php'); 

  //Process form
  if((isset($_POST["send_pm"]))&&(isset($_SESSION["level"])))
    {
      if($_SESSION["level"]>0)
      { 
        $mailbody = $locales["PM_From"]." : ".$_SESSION["RegUser"]."\n";
        $mailbody.= $_POST["private_mail"];
        if (mail($myUser->email, $main_title." ".$locales["PM"],$mailbody,'From:'.$cfg_site_title))
          {
	    echo "<p>". $locales["PM_Sent"]."</p>";
	  }
        else echo "<p class=\"error\">".$locales["ErrMsg_Send_Mail"]."</p>";
      }
    }
  
  //Display DATA
  echo "<h1>".$locales["Profile"]." : <a href=\"index.php?rub=profile&amp;id_user=".$idUser."\">".$myUser->login."</a></h1>";

  if($_GET["action"]=="")
    {
      if($page==1)
	{
	  echo "<blockquote>".$myUser->signature."</blockquote>";
	  echo "<p>".$locales["Member_since"]." : ".mad_date($myUser->register_date)."</p>";
	  echo "<p>".$locales["Last_Connexion"]." : ".mad_date($myUser->last_connexion)."</p>";
	}
      
    }
  
  if(($myUser->public_profile=="Y")||((isset($_SESSION["level"]))&&($_SESSION["level"]>2)))
    {
      if($_GET["action"]=="")
	{
	  if(($myUser->allow_PM=="Y")||((isset($_SESSION["level"]))&&($_SESSION["level"]>2)))
	    {
	      echo '<div><h2>'.$locales["PM"].'</h2><form method="post"><textarea style="width:100%" name="private_mail"></textarea><input type="submit" name="send_pm" value="'.$locales["Send"].'"/></form></div>';
	    }
	  //echo "<p><a href=\"mailto:".$myUser->email."\">".$myUser->email."</a></p>";
	  
	  //GENERAL PROFIL PAGE
	  echo "<h2><a href=\"index.php?rub=profile&amp;id_user=".$idUser."&amp;action=collec\">".$locales["Collection"]."</a></h2>";
	  echo "<h2><a href=\"index.php?rub=profile&amp;id_user=".$idUser."&amp;action=search\">".$locales["Searchlist"]."</a></h2>";
	  echo "<h2><a href=\"index.php?rub=profile&amp;id_user=".$idUser."&amp;action=sell\">".$locales["Selllist"]."</a></h2>";
	}
      else
	{
	  //Display n items per page
          echo '<div class="page_browsing">';
	  display_items_per_page();
	  
	  //Pagination
	  switch($_GET["action"])
	    {
	    case "collec" :
	      $requete_count = "SELECT count(distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."possess.issue) FROM  ".$cfg_table_prefix."possess, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."possess.id_user='$idUser' AND ".$cfg_table_prefix."possess.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."possess.issue+0)";
	      break;
	    case "search":
	      //Pagination
	      $requete_count = "SELECT count(distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."search.issue) FROM  ".$cfg_table_prefix."search, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."search.id_user='$idUser' AND ".$cfg_table_prefix."search.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."search.issue+0)";
	      break;
	    case "sell" :
	      //Pagination
	      $requete_count = "SELECT count(distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."forsale.issue) FROM  ".$cfg_table_prefix."forsale, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."forsale.id_user='$idUser' AND ".$cfg_table_prefix."forsale.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."forsale.issue+0)";
	      break;
	    }

	    $envoi_requete_count = mysql_query($requete_count,$DB_connexion);
	    if($envoi_requete_count) {$total = mysql_fetch_array($envoi_requete_count, MYSQL_NUM);mysql_free_result($envoi_requete_count);}
	    //pagine
	    $nbPagesPagination = ($total[0] / $nbrEnregPage);
	    $urlPagination = "index.php?rub=profile&amp;action=sell&amp;id_user=".$idUser;
	    echo pagination($page,$urlPagination,$nbPagesPagination);
            echo "</div>";

            $retour = "";

	  //SPECIFIC VIEW
	  switch($_GET["action"])
	    {
	    case "collec" :
	      echo "<h2>".$locales["Collection"]."</h2>";
	      $requete_possessions = "SELECT distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."possess.issue FROM  ".$cfg_table_prefix."possess, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."possess.id_user='$idUser' AND ".$cfg_table_prefix."possess.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."possess.issue+0) ASC LIMIT ".($page*$nbrEnregPage-$nbrEnregPage).",".$nbrEnregPage."";
	      $envoi_requete_possessions = mysql_query($requete_possessions,$DB_connexion);
	      if($envoi_requete_possessions) $nb_occur_possessions = mysql_num_rows($envoi_requete_possessions);
	      if($nb_occur_possessions > 0)
		{
		  $compteur = 0;
		  while ($table_resultats = mysql_fetch_array($envoi_requete_possessions,  MYSQL_BOTH))  
		    {
		      $newPublisher = new Publisher($table_resultats);
		      $newseries = new Series($table_resultats);
		      if((isset($oldPublisher))&&($newPublisher->id_publisher != $oldPublisher->id_publisher))
			{
			  $compteur = 0;
			}
		      if((!isset($oldPublisher->id_publisher))||($newPublisher->id_publisher != $oldPublisher->id_publisher)) $retour .= "<h2>".$newPublisher->name."</h2>\n";
		      $oldPublisher = $newPublisher;
		      $oldseries = $newseries;
		      $issue = new Issue($table_resultats);
		      $retour .= "<div";
		      if(($compteur%2)!=0) $retour .= " class=\"alternee\"";
		      $compteur++;
		      $retour .= "><a href=\"index.php?rub=series&amp;id_series=".$newseries->id_series."\">".$newseries->name."</a> vol.".$newseries->volume;
		      if($newseries->year != 0) $retour .= " (".$newseries->year.") ";
		      $retour .=" ".$locales["Issue_Number"]." #".$issue->number;
		      
		      $retour .= "</div>\n";
		    }
		}
              if($envoi_requete_possessions) mysql_free_result($envoi_requete_possessions);
	      echo $retour;		      
	      break;
	    case "search":
	      echo "<h2>".$locales["Searchlist"]."</h2>";
	      $requete_search = "SELECT distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."search.issue FROM  ".$cfg_table_prefix."search, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."search.id_user='$idUser' AND ".$cfg_table_prefix."search.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."search.issue+0) ASC LIMIT ".($page*$nbrEnregPage-$nbrEnregPage).",".$nbrEnregPage."";
	      $envoi_requete_search = mysql_query($requete_search,$DB_connexion);
	      if($envoi_requete_search) $nb_occur_search = mysql_num_rows($envoi_requete_search);
	      if($nb_occur_search > 0)
		{
		  $compteur = 0;
		  while ($table_resultats = mysql_fetch_array($envoi_requete_search,  MYSQL_BOTH)) 
		    {
		      $newPublisher = new Publisher($table_resultats);
		      $newseries = new Series($table_resultats);
		      if((isset($oldseries))&&($newseries->id_series != $oldseries->id_series))
			{
			  $compteur = 0;
			}
		      if((!isset($oldPublisher->id_publisher))||($newPublisher->id_publisher != $oldPublisher->id_publisher)) $retour .= "<h2>".$newPublisher->name."</h2>\n";
		      $oldPublisher = $newPublisher;
		      $oldseries = $newseries;
		      $issue = new Issue($table_resultats);
		      $retour .= "<div";
		      if(($compteur%2)!=0) $retour .= " class=\"alternee\"";
		      $compteur++;
		      $retour .= "><a href=\"index.php?rub=series&amp;id_series=".$newseries->id_series."\">".$newseries->name."</a> vol.".$newseries->volume;
		      if($newseries->year != 0) $retour .= " (".$newseries->year.") ";
		      $retour .=" ".$locales["Issue_Number"]." #".$issue->number;
		      
		      $retour .= "</div>\n";
		    }
		}
              if($envoi_requete_search) mysql_free_result($envoi_requete_search);
	      echo $retour;
	      break;
	    case "sell" :
	      echo "<h2>".$locales["Selllist"]."</h2>";
	      //Get currencies and conditions
	      $requete_currencies = "SELECT * FROM ".$cfg_table_prefix."currencies";
	      $envoi_requete_currencies = mysql_query($requete_currencies,$DB_connexion);
	      $table_currencies = array();
	      if($envoi_requete_currencies)
              {
                 while($temp = mysql_fetch_array($envoi_requete_currencies,  MYSQL_BOTH))
		   //     array_push($table_currencies,array($temp[0],$temp[1]));
		   $table_currencies[$temp[0]]=$temp[1];
                 mysql_free_result($envoi_requete_currencies);
              }
	      $requete_conditions = "SELECT * FROM ".$cfg_table_prefix."conditions";
	      $envoi_requete_conditions = mysql_query($requete_conditions,$DB_connexion);
	      $table_conditions = array();
	      if($envoi_requete_conditions)
              {
                while($temp = mysql_fetch_array($envoi_requete_conditions,  MYSQL_BOTH))
		  array_push($table_conditions,array($temp[0],$temp[1]));
                 mysql_free_result($envoi_requete_conditions);
              }

	      //Display
	      $requete_selling = "SELECT distinct ".$cfg_table_prefix."publishers.id_publisher,".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.id_series,".$cfg_table_prefix."series.series_volume,".$cfg_table_prefix."series.series_year, ".$cfg_table_prefix."forsale.issue, ".$cfg_table_prefix."forsale.forsale_price,".$cfg_table_prefix."forsale.forsale_currency,".$cfg_table_prefix."forsale.forsale_condition FROM ".$cfg_table_prefix."forsale, ".$cfg_table_prefix."series, ".$cfg_table_prefix."publishers WHERE ".$cfg_table_prefix."forsale.id_user='$idUser' AND ".$cfg_table_prefix."forsale.id_series=".$cfg_table_prefix."series.id_series AND ".$cfg_table_prefix."series.id_publisher=".$cfg_table_prefix."publishers.id_publisher ORDER BY ".$cfg_table_prefix."publishers.publisher_name,".$cfg_table_prefix."series.series_name,".$cfg_table_prefix."series.series_volume, (".$cfg_table_prefix."forsale.issue+0) ASC LIMIT ".($page*$nbrEnregPage-$nbrEnregPage).",".$nbrEnregPage.";";
	      $envoi_requete_selling = mysql_query($requete_selling,$DB_connexion);
	      if($envoi_requete_selling) $nb_occur_selling = mysql_num_rows($envoi_requete_selling);
	      if($nb_occur_selling > 0)
		{
		  $compteur = 0;
		  while ($table_resultats = mysql_fetch_array($envoi_requete_selling,  MYSQL_BOTH)) 
		    {
		      $newPublisher = new Publisher($table_resultats);
		      $newseries = new Series($table_resultats);
		      if((isset($oldseries))&&($newseries->id_series != $oldseries->id_series))
			{
			  $compteur = 0;
			}
		      if((!isset($oldPublisher->id_publisher))||($newPublisher->id_publisher != $oldPublisher->id_publisher)) $retour .= "<h2>".$newPublisher->name."</h2>\n";
		      $oldPublisher = $newPublisher;
		      $oldseries = $newseries;
		      $issue = new Issue($table_resultats);
		      $retour .= "<div";
		      if(($compteur%2)!=0) $retour .= " class=\"alternee\"";
		      $compteur++;
		      $retour .= "><a href=\"index.php?rub=series&amp;id_series=".$newseries->id_series."\">".$newseries->name."</a> vol.".$newseries->volume;
		      if($newseries->year != 0) $retour .= " (".$newseries->year.") ";
		      $retour .=" ".$locales["Issue_Number"]." #".$issue->number;
		      $retour .= "<br/><strong>".$locales["Issue_Condition"]." :</strong> ";
		      for($i=0;$i<sizeOf($table_conditions);$i++)
			if($table_conditions[$i][0]==$table_resultats[9])
			  $retour.= " ".$table_conditions[$i][1];
		      $retour.= " - <strong>".$locales["Issue_Price"]." :</strong> ".$table_resultats[8]." ".$table_resultats[7];
		      $retour .= "</div>\n";
		    }
		}
              if($envoi_requete_selling) mysql_free_result($envoi_requete_selling);
	      echo $retour;
	      break;
	    }
	}
    }

}
if($envoi_requete_user) mysql_free_result($envoi_requete_user);

require_once THEME.('footer.inc.php');

?>