One Hat Cyber Team

View File Name : edit_revision_update.php

<?php
//require("header.php");
require_once("../auth/auth.php");
require("functions_admin.php");

$lang = take_variable("lang");

mysql_query("SET NAMES '$_charset'", $db_handle);

echo "<HTML><BODY>";

please_wait();

//setlocale(LC_TIME, "C");
$id_selected = take_variable('id_selected');
$revision_id = take_variable('revision_id');
$what = take_variable('what');

$res = mysql_query("SELECT * FROM Articles WHERE id='".$id_selected."' ORDER BY id");
$res_revs=  mysql_query("SELECT * FROM Revisions  WHERE article_id='$id_selected' and id='"
			.$revision_id."' ORDER BY revision_received,id"); 

if (!$res) 
  die(mysql_error()); 
if (!$res_revs) 
  die(mysql_error()); 

$entry = mysql_fetch_array($res);
$rev= mysql_fetch_array($res_revs);

$referee_entry_id = take_variable('referee_entry_id');
$back=revision_edit_page($revision_id);

if ($label = take_variable('label',"POST")) 
  $back = $back."#".$label;     

if  ($rev['id'] && $entry['id'])
  {//do
    $cmd = "";
    
    switch($what)
      {
	
      case "revision_received":
	
	if (!trim($_POST['revision_received'])) 
	  {	
	    $revision_received_val="0000-00-00";
	  }
	else 
	  { 
	    //$revision_received = date("Y-m-d",strtotime($_POST['revision_received']));
	    //	    	  tell($_POST['revision_received']);      
	    $revision_received_val = //date("Y-m-d","123123234234");
	      date("Y-m-d",DmY_to_time($_POST['revision_received'],"."));
	  }
	
	$cmd = "revision_received='".$revision_received_val."'"; 
	
	break;  
	
      case "revision_is_electronic":
	
	$cmd = "revision_is_electronic='".take_variable('revision_is_electronic','POST')."'"; 
	break;
	
	//---------------------------------------------------------------
      
    case "referee":
      
      $cmd = "referee_id='".$_POST["referee".$referee_entry_id]."'"; 
      break;
      
    case "status":
      
      $cmd = "status='".$_POST["status"]."'"; 
      break;
      
    case "requested":
      
      if (!trim($_POST['requested'.$referee_entry_id])) 
      	$requested="0000-00-00";
      else 
	{ 
	  $requested = date("Y-m-d",DmY_to_time($_POST['requested'.$referee_entry_id]));
	}
      $cmd = "requested='".$requested."'"; break;  
      
    case "replied":
      
      if (!trim($_POST['replied'.$referee_entry_id])) 
	$replied="0000-00-00";
      else
	{
	  $replied = date("Y-m-d",DmY_to_time($_POST['replied'.$referee_entry_id]));
	}
      $cmd = "replied='".$replied."'"; break;  

    case "agrees":

      $agrees = $_POST['agrees'.$referee_entry_id];
      $cmd = "agrees='".$agrees."'"; 

      break;
     
    case "revision_sent_to_referee":

      if (!trim($_POST['revision_sent_to_referee'.$referee_entry_id])) 
	$revision_sent_to_referee="0000-00-00";
      else
	{
	  $revision_sent_to_referee 
	    = date("Y-m-d",DmY_to_time($_POST['revision_sent_to_referee'.$referee_entry_id]));
	}

      $cmd = "revision_sent_to_referee='".$revision_sent_to_referee."'";
      break;    
      
    case "report_received":
      
      if (!trim($_POST['report_received'.$referee_entry_id])) 
	$report_received="0000-00-00";
      else
	{
	  $report_received = date("Y-m-d",DmY_to_time($_POST['report_received'.$referee_entry_id]));
	}
      $cmd = "report_received='".$report_received."'"; break;      
      
    case "report_sent_to_author":
      
      if (!trim($_POST['report_sent_to_author'.$referee_entry_id])) 
	$report_sent_to_author="0000-00-00";
      else 
	{
	  $report_sent_to_author=date("Y-m-d",
				      DmY_to_time($_POST['report_sent_to_author'.$referee_entry_id]));
	}  
      $cmd = "report_sent_to_author='".$report_sent_to_author."'"; break;  
 
    default:
      break; 
    }//switch

  switch($what)
    {
    case "revision_received":
    case "revision_is_electronic":
      //echo "<pre>update Revisions set ".$cmd."  where id='".$_POST['revision_id']."' 
      //</pre>";
      mysql_db_query($_db, "update Revisions SET ".$cmd." where id=".$_POST['revision_id']." ");
      
      break;

    case "status":
      mysql_db_query($_db, "update Revisions set ".$cmd." where id='".$_POST['revision_id']."' ");
      if (article_status_meaning($_POST["status"]) =="published")
	tell(enruua("You have changed this article status to 'published'. 
Do not forget to specify the complete reference",
"Вы отметили эту статью как опубликованную. Не забудьте указать правильные том, номер и страницы",
"Вы відмітили цю статтю як опубліковану. На забудьте вказати точну інформацію про том, номер та сторінки")."!");
      
      break;

    case "publication_data":

      $msg = check_publication_data($_POST['published_volume'],$_POST['published_number'],
				    $_POST['published_page_start'], $_POST['published_page_end']);

      if (!$msg)
	{
	  mysql_query("update Articles set published_volume='".$_POST['published_volume']."',
published_number='".$_POST['published_number']."',
published_page_start='".$_POST['published_page_start']."', published_page_end='".$_POST['published_page_end']."' where id='".$_POST['id_selected']."' ");
	}
      else
	{
	  $pm = ""; $num = count($msg);
	  foreach ($msg as $k => $m)
	    {
	      if ($k) 
		{
		  if ($num>2) 
		    $pm = $pm. ", ";
		  else
		    $pm = $pm. " ".enruua("and","и","та")." ";
		}
 
	      // $pm = $pm. strtolower(utf8_substr($m,0,1))
	      //	. utf8_substr($m,1,utf8_strlen($m))."";
	      $pm = $pm. $m ;
	    }
	  
	  tell(enruua("Your changes have been rejected because",
		      "Ваши изменения отвергнуты, поскольку",
		      "Ваші виправлення відкинуто, оскільки")." ".$pm."!");

	}
	  break;
      
    default: 
      mysql_db_query($_db, "update Referees set ".$cmd. "where id='".$_POST['referee_entry_id']."' ");
    }

  /*  if (in_array($what, array("revision_received","revision_is_electronic","status"))) 
    {
mysql_db_query($_db, "update Revisions set ".$cmd." where id='".$_POST['revision_id']."' ");
    }
  else 
      mysql_db_query($_db, "update Referees set ".$cmd. "where id='".$_POST['referee_entry_id']."' ");
  */
}//do

else
{ 
tell("Error");
}



go("edit_revision.php#".$label,array("revision_id","lang"),array($revision_id,$lang));


//require("footer.php");
?>