<?php
session_start();

$slovo_original = $_SESSION["slovo_original"];
$slovo_k = $_POST["slovo"];
$perevod = $_POST["perevod"];
$znachenie = $_POST["znachenie"];

for ($i = 0; $i < count($perevod); $i++)
{
	$perevod[$i] = trim($perevod[$i]);
	$perevod[$i] = preg_replace("/ {2,}/", " ", $perevod[$i]);
	$perevod[$i] = preg_replace("/'/", "\'", $perevod[$i]);
	}

for ($i = 0; $i < count($znachenie); $i++)
{
	$znachenie[$i] = trim($znachenie[$i]);
	$znachenie[$i] = preg_replace("/ {2,}/", " ", $znachenie[$i]);
	$znachenie[$i] = preg_replace("/'/", "\'", $znachenie[$i]);
	}

include ('podkluchenie.php');

if($slovo_original != $slovo_k)
{
	$proverka_nalichiya_slova = mysql_query("  
	SELECT `s` FROM `k-ts` WHERE `s` = '".$slovo_k."'
	");
	
	$n = 0;
	while ($data = mysql_fetch_array($proverka_nalichiya_slova))
	{
		$proverka_nalichiya[$n] = $data['s'];
		$n++;
		}
		
	if(!isset($proverka_nalichiya))
	{
		mysql_query("
		UPDATE `k-ts`
		SET `s` = '".$slovo_k."'
		WHERE `s` = '".$slovo_original."' 
		");
		}
		else if(isset($proverka_nalichiya))
		{
			/////////////////////////////////////////////////////////////////////
			
			$ids_original = mysql_query("
			SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_original."'
			");
			
			$n = 0;
			while ($data = mysql_fetch_array($ids_original))
			{
				$ids_orig[$n] = $data['ids'];
				$n++;
				}
			
			$ids_original = $ids_orig[0];
			
			//////////////////////////////////////////////////////////////////////
			
			$ids_ispravlennogo = mysql_query("
			SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'
			");
			
			$n = 0;
			while ($data = mysql_fetch_array($ids_ispravlennogo))
			{
				$ids_ispr[$n] = $data['ids'];
				$n++;
				}
			
			$ids_ispravlennogo = $ids_ispr[0];
			
			//////////////////////////////////////////////////////////////////////
			
			mysql_query("
			UPDATE `k-t_s`
			SET `id_s` = '".$ids_ispravlennogo."'
			WHERE `id_s` = '".$ids_original."' 
			");
			
			mysql_query("
			UPDATE `k_l`
			SET `idk` = '".$ids_ispravlennogo."'
			WHERE `idk` = '".$ids_original."' 
			");
			
			mysql_query("
			DELETE FROM `k-ts` WHERE `s` = '".$slovo_original."'
			");
			}
	}

$a = count($perevod);//print_r($a);

for($i = 0; $i < $a; $i++)
{
	mysql_query("  
	INSERT IGNORE INTO `l-ts` (`s`)
	VALUES ('".$perevod[$i]."')
	");
	mysql_query(" 
	INSERT IGNORE INTO `tz` (`z`)
	VALUES ('".$znachenie[$i]."')
	");
	mysql_query("  
	INSERT INTO `k_l` (`idk`, `idl`, `idz`)
	VALUES ((SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'),  
			(SELECT `ids` FROM `l-ts` WHERE `s` = '".$perevod[$i]."'),
			(SELECT `idz` FROM `tz` WHERE `z` = '".$znachenie[$i]."'))  
	");
	}
	
mysql_query("
UPDATE `k-ts`
SET `f` = 1
WHERE `s` = '".$slovo_k."' 
");
	
mysql_close($podkluchenie);

header("Location: http://***.php");

?>

mysql_query("  
	INSERT INTO `k_l` (`idk`, `idl`, `idz`)
	VALUES ((SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'),  
			(SELECT `ids` FROM `l-ts` WHERE `s` = '".$perevod[$i]."'),
			(SELECT `idz` FROM `tz` WHERE `z` = '".$znachenie[$i]."'))  
	");

$b = 0;
	for($i = 0; $i < count($perevod); $i++)
	{
		mysql_query("  
		INSERT IGNORE INTO `l-ts` (`s`)
		VALUES ('".$perevod[$i]."')
		");
		mysql_query(" 
		INSERT IGNORE INTO `tz` (`z`)
		VALUES ('".$znachenie[$i]."')
		");
		mysql_query("  
		INSERT INTO `k_l` (`idk`, `idl`, `idz`)
		VALUES ((SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'),  
				(SELECT `ids` FROM `l-ts` WHERE `s` = '".$perevod[$i]."'),
				(SELECT `idz` FROM `tz` WHERE `z` = '".$znachenie[$i]."'))  
		");
		$b++;
		}
	
	/////////////////////////
	$_SESSION["aaa"] = $b;
	/////////////////////////

SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'

INSERT INTO `k_l` (`idk`, `idl`, `idz`)
		VALUES ((SELECT `ids` FROM `k-ts` WHERE `s` in ('море','фон')),  
				(SELECT `ids` FROM `l-ts` WHERE `s` = '3d'),
				(SELECT `idz` FROM `tz` WHERE `z` = '3Д-графика (трёхмерная графика)'))  

$kontrol = mysql_query("  
		INSERT INTO `k_l` (`idk`, `idl`, `idz`)
		VALUES ((SELECT `ids` FROM `k-ts` WHERE `s` = '".$slovo_k."'),  
				(SELECT `ids` FROM `l-ts` WHERE `s` = '".$perevod[$i]."'),
				(SELECT `idz` FROM `tz` WHERE `z` = '".$znachenie[$i]."'))  
		");
file_put_contents('kontrol.txt',$kontrol, FILE_APPEND);