<?php
	   
		$path = $_POST["path"];
		$id = (int)$_POST["id"];
		$service = $_POST["service"];
		$name_en = $_POST["name"];
		require "db.php";
		$st='';
		if(strlen($path)>0){
			$temp = explode("\\",$path);
			$n =count($temp);
			$st = $temp[$n-1];
		}
		if(strcmp($service,"add")==0){
			$sql = "SELECT * FROM shareholder WHERE id = $id";
			$result = mysql_query($sql);
			if(mysql_num_rows($result)>0){
				$sql = "UPDATE shareholder set filename = '$st', title = '$name_en' WHERE id = $id";
			}
			else{
				$sql = "INSERT INTO shareholder (title,filename) VALUES ('$name_en','$st')";
			}
			if ($_FILES["file"]["error"] > 0)
 			{
  				echo "Error: " . $_FILES["file"]["error"] . "<br />";
  			}
			else
  			{
				if(!file_exists("../files/" . $_FILES["file"]["name"]))
      			{
     				 move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
					 
     
      			}
				if(!file_exists("../cze/files/".$_FILES["file"]["name"]))
				{
					move_uploaded_file($_FILES["file"]["tmp_name"],"../cze/files/" . $_FILES["file"]["name"]);
				}
    		}
		}
		else if(strcmp($service,"edit")==0){
			if(strlen($path)>0){
				if ($_FILES["file"]["error"] > 0)
 			 	{
  					echo "Error: " . $_FILES["file"]["error"] . "<br />";
  				}
				else
  				{
					if(!file_exists("../files/" . $_FILES["file"]["name"]))
      				{
     					 move_uploaded_file($_FILES["file"]["tmp_name"],"../files/" . $_FILES["file"]["name"]);
					}
					if(!file_exists("../cze/files/".$_FILES["file"]["name"]))
					{
						move_uploaded_file($_FILES["file"]["tmp_name"],"../cze/files/" . $_FILES["file"]["name"]);
					}
    			}
				$sql = "UPDATE shareholder  SET filename = '$st',title = '$name_en' WHERE id = $id";
			 }
			 else{
			 	$sql = "UPDATE shareholder  SET title = '$name_en' WHERE id = $id";
			 }
			 
		}
		else{
			$sql = "DELETE FROM shareholder  WHERE id = $id";
		}
		
		mysql_query($sql);
	
	header("Location: index.php?page=shareholder"); 
?>