<?
  $dic=0;
  @include("globals.php");
  @include "google_text.php";
  @include("const.php");
  $page=0;
   connect_db();

   if (empty($_GET['idf']))  $idfraza=0;
                        else  $idfraza=$_GET['idf'];

   if (empty($_GET['fks']))  $fksource=3;
                        else  $fksource=$_GET['fks'];




   $wg1=0; $wg2=0; $wg3=0; $wg4=0; $wg5=0; $wg6=0; $wg7=0;

   $search=preg_replace("/[^\w\x7F-\xFF\s]/"," ",@$_GET['text']);
   $search=trim(ereg_replace(" +"," ",$search));

   $fk_doc=htmlspecialchars(@$_GET['idf']);


    $temp_query=$search;
    $asearch = $search;
    exec_sql("insert into Countfrz (fk_idfraza_cnt) values ($idfraza)");


    $sql="select vlfraza,  fullvalue,   vlsource from frz inner join ops on idfraza=fkfraza inner join src on idsource=fksource where idfraza=".$idfraza." and idsource=".$fksource;
   // echo $sql;

    $result= exec_sql($sql);
    $awrdcount=0;

    if($row=mssql_fetch_array($result))
      {
       $vlfraza=$row['vlfraza'];
       $fullvalue=$row['fullvalue'];
       $vlsource=$row['vlsource'];
       }


    proc_select("getWordVal");
    proc_setparam("@text_query",$vlfraza);
    $result=proc_exec();
    $awrdcount=0;

    if($row=mssql_fetch_array($result))
      {
      $aword_value= trim($row['word_value']);
      $afraza_value=$row['fraza_value'];
      $awg1=$row['wg1'];
      $awg2=$row['wg2'];
      $awg3=$row['wg3'];
      $awg4=$row['wg4'];
      $awg5=$row['wg5'];
      $awg6=$row['wg6'];
      $awg7=$row['wg7'];

      $awgh1=$row['wgh1'];
      $awgh2=$row['wgh2'];
      $awgh3=$row['wgh3'];
      $awgh4=$row['wgh4'];
      $awgh5=$row['wgh5'];
      $awgh6=$row['wgh6'];
      $awgh7=$row['wgh7'];

      $aword1=$row['word1']; $aword2=$row['word2']; $aword3=$row['word3'];
      $aword4=$row['word4']; $aword5=$row['word5']; $aword6=$row['word6'];
      $aword7=$row['word7'];

      //////////////////////////////////////////////////////////////////

      $word1=$row['word1']; $word2=$row['word2']; $word3=$row['word3'];
      $word4=$row['word4']; $word5=$row['word5']; $word6=$row['word6'];
      $word7=$row['word7'];

      $wg1=$row['wg1'];
      $wg2=$row['wg2'];
      $wg3=$row['wg3'];
      $wg4=$row['wg4'];
      $wg5=$row['wg5'];
      $wg6=$row['wg6'];
      $wg7=$row['wg7'];

      //////////////////////////////////////////////////////////////////

      $aword1_value= $row['word1_value'];
      $aword2_value=$row['word2_value'];
      $aword3_value=$row['word3_value'];
      $aword4_value=$row['word4_value'];
      $aword5_value=$row['word5_value'];

      $word1_value= $row['word1_value'];
      $word2_value=$row['word2_value'];
      $word3_value=$row['word3_value'];
      $word4_value=$row['word4_value'];
      $word5_value=$row['word5_value'];



      $awg=$row['wg'];
      if ($awg1>0) $awrdcount=$awrdcount+1;
      if ($awg2>0) $awrdcount=$awrdcount+1;
      if ($awg3>0) $awrdcount=$awrdcount+1;
      if ($awg4>0) $awrdcount=$awrdcount+1;
      if ($awg5>0) $awrdcount=$awrdcount+1;
      if ($awg6>0) $awrdcount=$awrdcount+1;
      if ($awg7>0) $awrdcount=$awrdcount+1;
      $vlsource=$row['vlsource'];
      $shortvalue=@$row['shortvalue'];
    //  $fullvalue=@$row['fullvalue'];
      $vlfraza =@$row['vlfraza'];
      $fnd=@$row['fnd'];

      $wrdcount=$awrdcount;



      $i=1;




       }








    /*
      if(!isset($shortvalue)) $shortvalue='';
      if(!isset($vlsource)) $vlsource ='';
      if (!isset($wg)) $wg=0;
      if(!isset($word_value)) $word_value=$defword;
      if(!isset($fraza_value)) $fraza_value=$deffraza;
     */






    proc_select("alphaSmartSearchDic");
    proc_setparam("@wg1",$awg1);
   	proc_setparam("@wg2",$awg2);
 	proc_setparam("@wg3",$awg3);
 	proc_setparam("@wg4",$awg4);
 	proc_setparam("@wg5",$awg5);
 	proc_setparam("@wg6",$awg6);
 	proc_setparam("@wg7",$awg7);
  	proc_setparam("@text_query", $temp_query);
  	proc_setparam("@wg", $awg);
    proc_setparam("@max",100);
   	proc_setparam("@size",4);
    proc_setparam("@cachetable",0);
    proc_setparam("@wrdcount",$awrdcount);
    proc_setparam("@page",0);
    proc_setparam("@fksource",$fksource);

    $result=proc_exec();

      $dic=" <span><strong style='color:#777777'> Найденно в словарях и справочниках</strong> </span><noindex> ";

     while ($row=mssql_fetch_array($result))
      {

     	$dic=$dic."<li style=\"color:#448FE3\"> <a style=\"text-decoration:none\" class=theme  href=search.php?text=".urlencode($temp_query)."&fk=".$row['fksource_']." title='Ограничить поиск понятия: «".
     	$temp_query."»  справочником:".$row['vlsource_']." '>";
     	$dic=$dic.$row['vlsource_']."</a><br>";


      }
      $dic=$dic."</noindex>";
  /* */

   $nm=3;


  #значение слов

   $vr="статья";

   if(!empty($temp_query))
    {
     if ($awrdcount>1) $vr="Сочинение: "; else  $vr="Школьное сочинение: ";
    $title=$vr.$temp_query." - источник: «".$vlsource."»";
    $meta_description=$vr.$temp_query." - источник: «".$vlsource."», проект: «информация on-line» Справочники, словари, энциклопедии";
    $meta_keywords=$temp_query;
    }
  else
    {
    $title="проект: «Информация on-line» Справочники, словари, энциклопедии";
    $meta_description="проект: «Информация on-line» Справочники, словари, энциклопедии";
    $meta_keywords="проект: «Информация on-line» Справочники, словари, энциклопедии";
    }

   $j=0;

?>




  <?
  //  echo $temp_query."<hr>";

    $words=explode(" ",$temp_query);
    $r=0;
    $words_str="";
    while($r<count($words))
      {
      $result_w=exec_sql("select * from WordAndForms('".$words[$r]."')");
      while($row_w=mssql_fetch_array($result_w))
        {
        if(strlen($row_w[0])>1) $words_str.="|".$row_w[0];
        }
      $r++;
      }
    $words_str=substr($words_str,1);


    $words=str_replace('.','',$words);
    $words=str_replace(',','',$words);
    $words=str_replace('-','',$words);

  //  print_r ($awords);
      $search = str_replace('quot','',$search);
      $temp_query = str_replace('quot','',$temp_query);
      $title = str_replace('quot','',$title);
  ?>
</head>

 <html>
   <head>
   <title></title>
    <link href="http://www.surbor.ru/style.css" rel=stylesheet type=text/css>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <meta name="description" content="">
    <meta name="keywords" content="">
    <style>
     a {color:; text-decoration:none}

    a.theme
		{
			color: ;
		}

	a.theme:hover
		{
			color:#CC0000;
		}



     body   {
			 font-family:Tahoma;
			 font-size: 8pt;
			}
	 table {
	 	     font-family:Tahoma;
			 font-size: 8pt;
	       }
    </style>

   </head>
   <body>

     <index>
     <center>
     <table width=100% bgcolor= class=rtline>
      <tr>
       <td>


       Поисковый запрос:
       <a class=theme href=search.php?text=>
        <? echo $search; ?> </a> <br>
        <font color=#CC0000>  </font>&nbsp;&nbsp; &nbsp;
          источник статьи: 

         <?
         //
         ?>
       </td>
       <td>
        &nbsp;
       </td>
       <td>
        &nbsp;
       </td>
       <td>
       </td>
        <td align=right>
          <?//=$baseURL?>
       </td>
       <td>
       </td>
      </tr>
     </table>
     </center>
     <br>

     <?
        flush();
        include ("forseo.php");
        include ("fortorMain.php");
     ?>


     <table border=0 align=left width=66%  style="clear:left; float:left">
     <tr><td class=" right top bottom" style="background-color: rgb(255, 255, 221);">
        <?
         if (!$rek) //include ("E:\\www\\surbor.ru\\prm\\tisersH2.htm");
                   //else
                  include ("e:\\www\\surbor.ru\\novoteka_h2_b.ru");
        ?>
        </tr></td>
     <tr>
     <td valign=top class="righttop bottom" height=1400px>

       <?
        $dm=$temp_query;
        $dm = substr($dm,0,1).".";

       echo "<table width=100%  style='background-color:#FFFFFF; padding:20'  class=rtline>";
       echo "<tr><td><h2> ".$vr." ".$temp_query."  </h2> ";

        $fullvalue=str_replace($dm,$temp_query,$fullvalue);
        $fullvalue=preg_replace("/[\w]*($words_str)[\w]*/i","<font color=#CC0000>\\0</font>",$fullvalue);

        // дополнительная реклама
        $doprek=false;
        if (strlen ($fullvalue)>6000) $doprek=true;
        //var_dump($doprek);
        //если длина строеи большая - рекламу показываем
       	echo "<p>".nl2br($fullvalue);

     ?>
     <br /><br /><br />
     <p align=right style="margin-right:10">
    <?
        echo "<a target=_blank class=theme href='print.php?idf=".$idfraza."&fks=".$fksource."&text=".urlencode($search)."'>  Версия для печати </a> ";
        ?>
      </p>
     <br /><br /><br />
         <div style="padding:12" class="lefttop rightbottom">
      <h2> <a href="../../" class=theme style="text-decoration:none">  Рекомендуемые сочинения:  </a> </h2>

     <?
    // echo "<hr>".$asearch."<hr>";
    $st=0;
    proc_select("surborru.dbo.visualQuery");
    proc_setparam("@word1",$aword1);
    proc_setparam("@word2",$aword2);
  	proc_setparam("@word3",$aword3);
  	proc_setparam("@word4",$aword4);
  	proc_setparam("@word5",$aword5);
  	proc_setparam("@word6",$aword6);
  	proc_setparam("@word7",$aword7);
    proc_setparam("@fk_w1",$awg1);
    proc_setparam("@fk_w2",$awg2);
  	proc_setparam("@fk_w3",$awg3);
  	proc_setparam("@fk_w4",$awg4);
  	proc_setparam("@fk_w5",$awg5);
  	proc_setparam("@fk_w6",$awg6);
  	proc_setparam("@fk_w7",$awg7);
  	proc_setparam("@text_query", $asearch);
    proc_setparam("@wrdcount",$awrdcount);
    proc_setparam("@page",0);
    $result=proc_exec();
            while($row=mssql_fetch_array($result))
            {
     	echo "<li style=\"color:$color;\"> <font color=#000000>
     	  <span style='color:#777777;'> [".$row['vlsource']."]</span>";
     	?>
     	 <a target=_blank class=theme href="shows.php?idf=&fks=&text=">
          <br>
        </a>

     	<?
     	  $rtext=substr($row['fullvalue'], $st,600-($st));
     	  $rtext="... ".strip_tags($rtext,'<font> <strong>'." ...");
     	 // $rtext=substr($row['cache'], 1, 100);
     	  $rtext=preg_replace("/[\w]*($words_str)[\w]*/i","<strong><font color=#CC0000>\\0</font></strong>",$rtext)."</li><br>";
          echo $rtext;
          $st=$st+50;
            }
         ?>
          <br />
          <br />

       </td></tr></table>
       </td>
       </tr>


     <tr>
     <td valign=top  style="padding:30" class="righttop bottom left">
      <?
       /*
         if ($rek) include ("E:\\www\\surbor.ru\\sc-h.html");
            else
       !!!!!!!!!!!!!!!!!!!!!!!!! реклама !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
      */
      $nm=7;
      //include('e:\\www\\surbor.ru\\kino\\search_kinobros.ru')
       // if ( !$rek) include ("E:\\www\\surbor.ru\\prm\\tisersH2.htm");
      ?>
     </td>
    </tr>




      </table>
       </td></tr>

       </table>
      <? include ("rblockShow.php"); ?>
       <table border=0  width=100%   bgcolor= style="clear:left;" class=rightline>
        <tr>
         <td style="padding:5">
         <div>
          <div style="float:left" >

           Запрос <strong style="color:#CC0000">&laquo;<? echo $search ?>&raquo;</strong>
         </div>
         <div style="float:left; margin-left:30">

              <? if ($awrdcount>=1)  { ?> <a class=theme  href="/data/"> Значение слов:  &laquo;&raquo;</a>    <? } ?>
              <? if ($awrdcount>=2)  { ?><a class=theme  href="/data/"></a>    <? } ?>
              <? if ($awrdcount>=3)  { ?><a class=theme  href="/data/"></a>    <? } ?>
              <? if ($awrdcount>=4)  { ?><a class=theme  href="/data/"></a>    <? } ?>
              <? if ($awrdcount>=5)  { ?><a class=theme  href="/data/"></a>    <? } ?>
              - во всех доступных словарях и справочниках
         </div>
         <div align=right>
          <? include ("footer.php")?>
         </div>
         </td>
        </tr>
       </table>
</body>
<? close_db()?>
</html>