<?
function topic_title_to_english($id)
{
$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");
$wynik = mysql_query("SELECT * FROM phpbb_topics WHERE topic_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$topic_id = $row['topic_id'];
	$forum_id = $row['forum_id'];
	$topic_poster = $row['topic_poster'];
	$topic_time = $row['topic_time'];
	$topic_views = $row['topic_views'];
	$topic_replies = $row['topic_replies'];
	$topic_status = $row['topic_status'];
	$topic_vote = $row['topic_vote'];
	$topic_type = $row['topic_type'];
	$topic_first_post_id = $row['topic_first_post_id'];
	$topic_last_post_id = $row['topic_last_post_id'];
	$topic_moved_id = $row['topic_moved_id'];
	$topic_attachment = $row['topic_attachment'];
	$text = $row['topic_title'];
	$text = strtolower($text);
	$lenght = strlen($text);

	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);

		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									}
									fclose($plik_polish);
									//koniec szukania
									$slowo = "";
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
						$polish .= $slowo;
						$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}
$zapisz = "INSERT INTO `eng_topics` ( `topic_id` , `forum_id` , `topic_title` , `topic_poster` , `topic_time` , `topic_views` , `topic_replies` , `topic_status` , `topic_vote` , `topic_type` , `topic_first_post_id` , `topic_last_post_id` , `topic_moved_id` , `topic_attachment` )
VALUES ('$topic_id', '$forum_id', '$polish', '$topic_poster', '$topic_time', '$topic_views', '$topic_replies', '$topic_status', '$topic_vote', '$topic_type', '$topic_first_post_id', '$topic_last_post_id', '$topic_moved_id', '$topic_attachment')";

mysql_query($zapisz);
$polish = "";
return;
}

function write_post_info($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");

//pobieranie i przepisywanie informacji o pierwszym poscie dla danego tematu - bez tego temat nie wyswietli sie na liscie tematów ;)
	
$pobierz_post = mysql_query("SELECT * FROM phpbb_posts WHERE post_id = $id");	

while($row = mysql_fetch_array($pobierz_post)) //znaleziono danego posta
	{
	$post_id = $row['post_id'];
	$topic_id = $row['topic_id'];
	$forum_id = $row['forum_id'];
	$poster_id = $row['poster_id'];
	$post_time = $row['post_time'];
	$poster_ip = $row['poster_id'];
	$post_username = $row['post_username'];
	$enable_bbcode = $row['enable_bbcode'];
	$enable_html = $row['enable_html'];
	$enable_smilies = $row['enable_smilies'];
	$enable_sig = $row['enable_sig'];
	$post_edit_time = $row['post_edit_time'];
	$post_edit_count = $row['post_edit_count'];
	$post_attachment = $row['post_attachment'];
	}

//pobralem informacje o poscie, teraz zapisuje je do tablicy eng_posts, aby byly widoczne w angielskiej czesci forum

$zapisz_post = "INSERT INTO `eng_posts` (`post_id`, `topic_id`, `forum_id`, `poster_id`, `post_time`, `poster_ip`, `post_username`, `enable_bbcode`, `enable_html`, `enable_smilies`, `enable_sig`, `post_edit_time`, `post_edit_count`, `post_attachment`) 
VALUES ('$post_id', '$topic_id', '$forum_id', '$poster_id', '$post_time', '$poster_ip', '$post_username', '$enable_bbcode', '$enable_html', '$enable_smilies', '$enable_sig', '$post_edit_time', '$post_edit_count', '$post_attachment')";

mysql_query($zapisz_post);

//mysql_close($sql);
return;
}

function post_title_to_english($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");
$wynik = mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$text = $row['post_subject'];
	
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);

		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= $slowo;
					}

				fclose($plik_english);

 				$slowo = "";
				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}

$zapisz = "UPDATE `eng_posts_text` SET `post_subject` = '$polish' WHERE `post_id` = $id";
mysql_query($zapisz);

}

function post_body_to_english($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");
$wynik = mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$post_id = $row['post_id'];
	$bbcode_uid = $row['bbcode_uid'];
	$post_subject = $row['post_subject'];
	$text = $row['post_text'];
	
	$text = str_replace("\r\n","|",$text);
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);
		
		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $literka != "|" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									//  }
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= "<i><b>[color=green:$bbcode_uid] $slowo [/color:$bbcode_uid] </b></i>";
					$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!" xor $literka == "|")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}
$polish = str_replace("|","<br>",$polish);
$polish .= "<br><br><br><br>";
$polish .= "[size=9:$bbcode_uid][color=blue:$bbcode_uid]Automatic translated from polish[/color:$bbcode_uid][/size:$bbcode_uid]";

$zapisz = "INSERT INTO `eng_posts_text` ( `post_id` , `bbcode_uid` , `post_subject` , `post_text`)
VALUES ('$post_id', '$bbcode_uid', '$post_subject', '$polish')";
mysql_query($zapisz);

post_title_to_english($post_id);

}


function write_attachments_info($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");

//pobieranie i przepisywanie informacji o pierwszym poscie dla danego tematu - bez tego temat nie wyswietli sie na liscie tematów ;)

$pobierz_post = mysql_query("SELECT attach_id FROM phpbb_attachments WHERE post_id = $id");	

while($row = mysql_fetch_array($pobierz_post)) //znaleziono danego posta
	{
	$attach_id = $row['attach_id'];
	
	$pobierz_zalacznik = mysql_query("SELECT * FROM phpbb_attachments_desc WHERE attach_id = $attach_id");
	
	while($row2 = mysql_fetch_array($pobierz_zalacznik))
		{
	$polish = "";
		$attach_id = $row2['attach_id'];
		$physical_filename = $row2['physical_filename'];
		$real_filename = $row2['real_filename'];
		$download_count = $row2['download_count'];
		$text = $row2['comment'];
		$extension = $row2['extension'];
		$mimetype = $row2['mimetype'];
		$filesize = $row2['filesize'];
		$filetime = $row2['filetime'];
		$thumbnail = $row2['thumbnail'];
		
	$text = str_replace("\r\n","|",$text);
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);
		
		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $literka != "|" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									//  }
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= "$slowo";
					$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!" xor $literka == "|")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
		
	
		$zapisz = "INSERT INTO `eng_attachments_desc` ( `attach_id` , `physical_filename` , `real_filename` , `download_count`, `comment`, `extension`, `mimetype`, `filesize`, `filetime`, `thumbnail`)
VALUES ('$attach_id', '$physical_filename', '$real_filename', '$download_count', '$polish', '$extension', '$mimetype', '$filesize', '$filetime', '$thumbnail');";
		mysql_query($zapisz);
		
		}
	
	}

}

//----------------------------------------------------------------------------------------------------
function priv_title_to_english($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");
$wynik = mysql_query("SELECT * FROM phpbb_privmsgs WHERE privmsgs_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$privmsgs_id = $row['privmsgs_id'];
	$privmsgs_type = $row['privmsgs_type'];
	$text = $row['privmsgs_subject'];
	$privmsgs_from_userid = $row['privmsgs_from_userid'];
	$privmsgs_to_userid = $row['privmsgs_to_userid'];
	$privmsgs_date = $row['privmsgs_date'];
	$privmsgs_ip = $row['privmsgs_ip'];
	$privmsgs_enable_bbcode = $row['privmsgs_enable_bbcode'];
	$privmsgs_enable_html = $row['privmsgs_enable_html'];
	$privmsgs_enable_smilies = $row['privmsgs_enable_smilies'];
	$privmsgs_attach_sig = $row['privmsgs_attach_sig'];
	$privmsgs_attachment = $row['privmsgs_attachment'];
	
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);

		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= $slowo;
					}

				fclose($plik_english);

 				$slowo = "";
				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}

$zapisz = "INSERT INTO `eng_privmsgs` ( `privmsgs_id` , `privmsgs_type` , `privmsgs_subject` , `privmsgs_from_userid`, `privmsgs_to_userid`, `privmsgs_date`, `privmsgs_ip`, `privmsgs_enable_bbcode`, `privmsgs_enable_html`, `privmsgs_enable_smilies`, `privmsgs_attach_sig`, `privmsgs_attachment`)
VALUES ('$privmsgs_id', '$privmsgs_type', '$polish', '$privmsgs_from_userid', '$privmsgs_to_userid', '$privmsgs_date', '$privmsgs_ip', '$privmsgs_enable_bbcode', '$privmsgs_enable_html', '$privmsgs_enable_smilies', '$privmsgs_attach_sig', '$privmsgs_attachment');";
mysql_query($zapisz);
}
//---------------------------------------------------------------------------------------------------
function privmsgs_body_to_english($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("ioh_ioh");
$wynik = mysql_query("SELECT * FROM phpbb_privmsgs_text WHERE privmsgs_text_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$privmsgs_text_id = $row['privmsgs_text_id'];
	$privmsgs_bbcode_uid = $row['privmsgs_bbcode_uid'];
	$text = $row['privmsgs_text'];
	
	$text = str_replace("\r\n","|",$text);
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);
		
		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $literka != "|" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									//  }
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= "$slowo";
					$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!" xor $literka == "|")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}
$polish = str_replace("|","<br>",$polish);
$polish .= "<br><br><br><br>";
$polish .= "Automatic translated from polish";

$zapisz = "INSERT INTO `eng_privmsgs_text` ( `privmsgs_text_id` , `privmsgs_bbcode_uid` , `privmsgs_text`)
VALUES ('$privmsgs_text_id', '$privmsgs_bbcode_uid', '$polish');";
mysql_query($zapisz);

priv_title_to_english($id);
}
//----------------------------------------------------------------------------------------------------------
?><?
function topic_title_to_english_edit($id)
{
$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("obliczahistorii");
$wynik = mysql_query("SELECT * FROM phpbb_topics WHERE topic_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$topic_id = $row['topic_id'];
	$forum_id = $row['forum_id'];
	$topic_poster = $row['topic_poster'];
	$topic_time = $row['topic_time'];
	$topic_views = $row['topic_views'];
	$topic_replies = $row['topic_replies'];
	$topic_status = $row['topic_status'];
	$topic_vote = $row['topic_vote'];
	$topic_type = $row['topic_type'];
	$topic_first_post_id = $row['topic_first_post_id'];
	$topic_last_post_id = $row['topic_last_post_id'];
	$topic_moved_id = $row['topic_moved_id'];
	$topic_attachment = $row['topic_attachment'];
	$text = $row['topic_title'];
	$text = strtolower($text);
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);

		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									}
									fclose($plik_polish);
									//koniec szukania
									$slowo = "";
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
						$polish .= $slowo;
						$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}
$zapisz = "UPDATE eng_topics SET topic_title = '$polish', topic_type = $topic_type, forum_id = $forum_id, topic_poster = $topic_poster, topic_time = $topic_time, topic_views = $topic_views, topic_replies = $topic_replies, topic_status = $topic_status, topic_vote = $topic_vote, $topic_attachment = $topic_attachment WHERE topic_id = $topic_id";

mysql_query($zapisz);
$polish = "";
}

function write_post_info_edit($id) {

$sql = mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("obliczahistorii");

//pobieranie i przepisywanie informacji o pierwszym poscie dla danego tematu - bez tego temat nie wyswietli sie na liscie tematów ;)
	
$pobierz_post = mysql_query("SELECT * FROM phpbb_posts WHERE post_id = $id");	

while($row = mysql_fetch_array($pobierz_post)) //znaleziono danego posta
	{
	$post_id = $row['post_id'];
	$topic_id = $row['topic_id'];
	$forum_id = $row['forum_id'];
	$poster_id = $row['poster_id'];
	$post_time = $row['post_time'];
	$poster_ip = $row['poster_id'];
	$post_username = $row['post_username'];
	$enable_bbcode = $row['enable_bbcode'];
	$enable_html = $row['enable_html'];
	$enable_smilies = $row['enable_smilies'];
	$enable_sig = $row['enable_sig'];
	$post_edit_time = $row['post_edit_time'];
	$post_edit_count = $row['post_edit_count'];
	$post_attachment = $row['post_attachment'];
	}

//pobralem informacje o poscie, teraz zapisuje je do tablicy eng_posts, aby byly widoczne w angielskiej czesci forum

$zapisz_post = "UPDATE eng_posts SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig WHERE post_id = $post_id";

mysql_query($zapisz_post);

//mysql_close($sql);
return;
}

function post_title_to_english_edit($id) {

mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("obliczahistorii");
$wynik = mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$text = $row['post_subject'];
	
	$text = strtolower($text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);

		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= $slowo;
					}

				fclose($plik_english);

 				$slowo = "";
				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}

$zapisz = "UPDATE `eng_posts_text` SET `post_subject` = '$polish' WHERE `post_id` = $id";
mysql_query($zapisz);

}

function post_body_to_english_edit($id) {

mysql_connect("localhost","iohuser","adamuSS");
mysql_select_db("obliczahistorii");
$wynik = mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id = $id");

$wyraz = "";
$word = "";
$slowo = "";
$znaleziono = 0;
$polish = "";
while($row = mysql_fetch_array($wynik))
	{
	$post_id = $row['post_id'];
	$bbcode_uid = $row['bbcode_uid'];
	$post_subject = $row['post_subject'];
	$text = $row['post_text'];
	
	$text = strtolower($text);
	
	$text = str_replace("\r\n","|",$text);
	
	$lenght = strlen($text);
	for($a = 0; $a <= $lenght; $a++)
		{
		$literka = substr($text,$a,1);
		
		if($literka != " " && $literka != "," && $literka != "." && $literka != "!" && $literka != "|" && $a != strlen($text))
			{
			$slowo .= $literka;
			}
		else
			{
			if($slowo != "") //jezeli mamy pelny wyraz...
				{
				$linia = 0;
				$line = 1;
				$plik_english = fopen("polish.txt","r");
				$rozmiar_english = filesize("polish.txt");
				$czytaj_english = fread($plik_english, $rozmiar_english);
				
				$czytaj_english = str_replace("\n","|",$czytaj_english);
				
				$czytaj_lenght = strlen($czytaj_english);

				for($b = 0; $b < $czytaj_lenght; $b++) //szukam wyrazu w slowniku
						{
						$litera2 = substr($czytaj_english,$b,1);

						if($litera2 != "|") //szukaj konca linii
							{
							$wyraz .= $litera2;
							}
						else //znaleziono koniec linii - mamy cale haslo
							{
							$linia = $linia + 1; //która linie aktualnie czytamy
							$wyraz = substr($wyraz,0,strlen($wyraz)-1);
							if($slowo == $wyraz) //sprawdzenie czy slowo z bazy odpowiada temu ze slownika
								{
								$znaleziono = "True";
									//szukam odpowiednika w slowniku angielskim
									$plik_polish = fopen("english.txt","r");
									$rozmiar_polish = filesize("english.txt");
									$czytaj_polish = fread($plik_polish,$rozmiar_polish);
									
									$czytaj_polish = str_replace("\n","|",$czytaj_polish);
									$czytaj_polish_lenght = strlen($czytaj_polish);
									for($c = 0; $c < $czytaj_polish_lenght; $c++)
									{
									  $znak = substr($czytaj_polish,$c,1);
									  
											if($znak == "|")
												{
												if($line == $linia)
													{
													$word = substr($word,0,strlen($word)-1);
													$polish .= $word;
													break;
													}
												else
													{
													$line = $line + 1;															
													$word = "";
													}
												}											
											else
												{
												$word .= $znak;
												}
									//  }
									}
									fclose($plik_polish);
									$slowo = "";
									//koniec szukania
								break; //jezeli znaleziono slowo w slowniku to mozna zakonczyc petle :)
								}
							else
								{
								$znaleziono = "False";
								}
							$wyraz = "";
							}
						}
				if($znaleziono == "False")
					{ //slowa nie znaleziono w slowniku, nalezy zachowac slowo oryginalne
					$polish .= "<i><b>[color=green:$bbcode_uid] $slowo [/color:$bbcode_uid] </b></i>";
					$slowo = "";
					}

				fclose($plik_english);

				}
			}
			
		if($literka == "," xor $literka == "." xor $literka == "!" xor $literka == "|")
				{
				$polish .= $literka;
				}
		$polish .= " ";
		}
	}
$polish = str_replace("|","<br>",$polish);
$polish .= "<br><br><br><br>";
$polish .= "[size=9:$bbcode_uid][color=blue:$bbcode_uid]Automatic translated from polish[/color:$bbcode_uid][/size:$bbcode_uid]";

$zapisz = "UPDATE eng_posts_text SET post_text = '$polish',  bbcode_uid = '$bbcode_uid', post_subject = '$post_subject' WHERE post_id = $post_id";

mysql_query($zapisz);

post_title_to_english_edit($post_id);

}

?><!-- DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" -->
<!-- <html xmlns="https://www.w3.org/1999/xhtml"> -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2"  >
<meta http-equiv="Content-Style-Type" content="text/css" >
<style type="text/css">
<!--
-->
</style>
<title>Inne Oblicza Historii :: PrzeglÄ…d tematu - ID blaszka</title>
<link rel="stylesheet" href="templates/mediaworkx/mediaworkx.css" type="text/css" >
<style type="text/css">
<!--
/* Specifiy background images for selected styles
   This can't be done within the external style sheet as NS4 sees image paths relative to
   the page which called the style sheet (i.e. this page in the root phpBB directory)
   whereas all other browsers see image paths relative to the style sheet. Stupid NS again!
*/
TH			{ background-image: url(templates/mediaworkx/images/cellpic3.gif) }
TD.cat		{ background-image: url(templates/mediaworkx/images/cellpic1.gif) }
TD.rowpic	{ background-image: url(templates/mediaworkx/images/cellpic2.jpg); background-repeat: repeat-y }
td.icqback	{ background-image: url(templates/mediaworkx/images/icon_icq_add.gif); background-repeat: no-repeat }
TD.catHead,TD.catSides,TD.catLeft,TD.catRight,TD.catBottom { background-image: url(templates/mediaworkx/images/cellpic1.gif) }


/* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */
@import url("templates/mediaworkx/formIE.css"); 
-->
</style>
</head>

<body bgcolor="#" text="#2B2E23" link="#C99661" vlink="#C99661">
<span class="gen"><a name="top"></a></span>
<table width="100%" height="100%" border="0" cellpadding="3" cellspacing="1" class="forumline">
	<tr>
		<th class="thCornerL" width="22%" height="26">Autor</th>
		<th class="thCornerR">WiadomoĹ›Ä‡</th>
	</tr>
		<tr>
		<td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b><a href="profile.php?mode=viewprofile&amp;u=9789&amp;sid=48051109ff13ff7b54d4dbd87381d1e4">Byku</a></b></span></td>
		<td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr> 
				<td width="100%"><img src="templates/mediaworkx/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" ><span class="postdetails">WysĹ‚any: Sob 11 Lip, 2015 17:53<span class="gen">&nbsp;</span>&nbsp;&nbsp;&nbsp;Temat postu: </span></td>
			</tr>
			<tr> 
				<td colspan="2"><hr ></td>
			</tr>
			<tr> 
				<td colspan="2"><span class="postbody">DziÄ™kujÄ™  <img src="images/smiles/piwko2.gif" alt="Piwo" border="0" ></span></td>
			</tr>
		</table></td>
	</tr>
	<tr> 
		<td colspan="2" height="1" class="spaceRow"><img src="templates/mediaworkx/images/spacer.gif" alt="" width="1" height="1" ></td>
	</tr>
	 	<tr>
		<td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b><a href="profile.php?mode=viewprofile&amp;u=8561&amp;sid=48051109ff13ff7b54d4dbd87381d1e4">Nazir</a></b></span></td>
		<td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr> 
				<td width="100%"><img src="templates/mediaworkx/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" ><span class="postdetails">WysĹ‚any: Sob 11 Lip, 2015 17:24<span class="gen">&nbsp;</span>&nbsp;&nbsp;&nbsp;Temat postu: </span></td>
			</tr>
			<tr> 
				<td colspan="2"><hr ></td>
			</tr>
			<tr> 
				<td colspan="2"><span class="postbody">Witam!<br>12 kompania 132 puĹ‚ku piechoty.<br>Pozdrawiam<br>Przemek</span></td>
			</tr>
		</table></td>
	</tr>
	<tr> 
		<td colspan="2" height="1" class="spaceRow"><img src="templates/mediaworkx/images/spacer.gif" alt="" width="1" height="1" ></td>
	</tr>
	 	<tr>
		<td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b><a href="profile.php?mode=viewprofile&amp;u=9789&amp;sid=48051109ff13ff7b54d4dbd87381d1e4">Byku</a></b></span></td>
		<td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
			<tr> 
				<td width="100%"><img src="templates/mediaworkx/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" ><span class="postdetails">WysĹ‚any: Sob 11 Lip, 2015 17:00<span class="gen">&nbsp;</span>&nbsp;&nbsp;&nbsp;Temat postu: ID blaszka</span></td>
			</tr>
			<tr> 
				<td colspan="2"><hr ></td>
			</tr>
			<tr> 
				<td colspan="2"><span class="postbody">ProszÄ™ o pomoc czy dobrze rozszyfrowaĹ‚em <img src="images/smiles/icon_smile.gif" alt="UĹ›miech" border="0" ><br><br> 12./ J.R .132<br><br>12 dywizja piechoty 132 puĹ‚k ?</span></td>
			</tr>
		</table></td>
	</tr>
	<tr> 
		<td colspan="2" height="1" class="spaceRow"><img src="templates/mediaworkx/images/spacer.gif" alt="" width="1" height="1" ></td>
	</tr>
	 </table>
<div align="center"><span class="copyright"><br>
<!--
	We request you retain the full copyright notice below including the link to www.phpbb.com.
	This not only gives respect to the large amount of time given freely by the developers
	but also helps build interest, traffic and use of phpBB 2.0. If you cannot (for good
	reason) retain the full copyright we request you at least leave in place the 
	Powered by phpBB  line, with phpBB linked to www.phpbb.com. If you refuse
	to include even this then support on our forums may be affected. 

	The phpBB Group : 2002
// -->
Powered by <a href="https://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> &copy; 2001, 2005 phpBB Group</span></div>
		</td>
	</tr>
</table>

</body>
</html>