dip / minc_2.php

<?

//---------------------------------------------------
function add_to_words($ins,$rid)
{
  $ins1=strip_tags($ins,'');
  //-------------------------------------Разобрать текст по словам
  $ins1=str_replace('-',' ',$ins1);
  $ins1=str_replace('/',' ',$ins1);
  $ins1=str_replace('"',' ',$ins1);
  $ins1=str_replace(',',' ',$ins1);
  $ins1=str_replace('.',' ',$ins1);
  $ins1=str_replace(';',' ',$ins1);
  $ins1=str_replace(':',' ',$ins1);

  $curwords=explode(' ',$ins1);
  $curwords=array_count_values($curwords);
  while (list($tword)=each($curwords))
  {
  if (strlen($tword)>3)
     {
     $nword=0;

     $sql="SELECT * FROM TWORDS WHERE TEXTWORD='$tword'";
     $result=mysql_query($sql);

     if (mysql_num_rows($result)==0)
        {
        $sql1="INSERT INTO TWORDS VALUES(NULL,'$tword')";
        mysql_query($sql1);
        echo mysql_error();

        $sql1="SELECT * FROM TWORDS WHERE TEXTWORD='$tword'";
        $result1=mysql_query($sql1);
        $row=mysql_fetch_array($result1);
        $nword=$row["NWORD"];
        }
     else
        {
        $row=mysql_fetch_array($result);
        $nword=$row["NWORD"];
        }
     //endif

     $sql="INSERT INTO TWORDLINK VALUES(NULL,$nword,$rid)";
     mysql_query($sql);
     echo mysql_error();
     }
  //endif
  }
  //wend
}


//----------------------------------------------------------------------------------------------------
//                           Добавление куска текста в виде привязанной записи
//----------------------------------------------------------------------------------------------------
function add_text_part($rupid,$rtid,$ins)
{

   $today=date("Y-m-d");

   if ($rupid=='')
      $rupid=0;
   //endif
   //--------------------------------------------------------Создание текущей записи
   $sql = "INSERT INTO TRECORDS VALUES(NULL,'$rtid','$today',0,'$rupid')";
   $result=mysql_query($sql);
   echo mysql_error();

   $sql="SELECT MAX(RID) as RID1 FROM TRECORDS";
   $result=mysql_query($sql);
   $row=mysql_fetch_array($result);
   $rid1=$row["RID1"];

   //-------------------------------------------------------создание связи для тек. записи
   $sql = "SELECT GID FROM TGROUP where RID='$rupid' and GDID='$gdid'";
   $result=mysql_query($sql);
   if (mysql_num_rows($result)==0)
      {
      $sql = "INSERT INTO TGROUP VALUES(NULL,'$rupid','TEST','$gdid')";
      $result=mysql_query($sql);
      echo mysql_error();

      $sql="SELECT MAX(GID) as GID1 FROM TGROUP";
      $result=mysql_query($sql);
      $row=mysql_fetch_array($result);
      $gid1=$row["GID1"];

      }
   else
      {
      $row=mysql_fetch_array($result);
      $gid1=$row["GID"];
      }
   //endif

   //-----------------------------------------------------
   $sql = "UPDATE TRECORDS SET HAVEGR=1 WHERE RID='$rupid'";
   $result=mysql_query($sql);
   echo mysql_error();

   $sql="SELECT * FROM TLINK where RID='$rid1' and GID='$gid1'";
   $result=mysql_query($sql);

   if  (mysql_num_rows($result)==0)
      {
      $sql = "INSERT INTO TLINK VALUES(NULL,'$rid1','$gid1',0)";
      $result=mysql_query($sql);
      echo mysql_error();
      }
   //endif

  //-------------------------------------------------------------
  //      Поиск типов полей для -->Раздел/Текст
  //-------------------------------------------------------------
  $sql = "select R.RTID,R.RTTEXT, A.AID, A.ATEXT, A.ATYPE from TRECTYPE R, TATTR A, TTYPEATTR RA ".
       "where RA.AID=A.AID and RA.RTID=R.RTID and R.RTID=47";
  $result=mysql_query($sql);
  echo mysql_error();

  $row=mysql_fetch_array($result);
  $aid1=$row["AID"];
  $row=mysql_fetch_array($result);
  $aid2=$row["AID"];
  $row=mysql_fetch_array($result);
  $aid3=$row["AID"];

  //--------------------------------------------------Запись полей
  print('связь создана');

  //-------------------------Добавить записи в таблицу слов
  add_to_words($ins,$rid1);
  //----------------------------------------

  $ins100=strip_tags($ins,"");
  //------------------------------------------------------------
  $sql = "INSERT INTO TINFO VALUES(NULL,'$ins100',0,0,1,'$rid1','$aid1',1)";
  $result=mysql_query($sql);
  echo mysql_error();

  $sql = "INSERT INTO TINFO VALUES(NULL,'HF',0,0,1,'$rid1','$aid2',6)";
  $result=mysql_query($sql);
  echo mysql_error();

  $sql = "INSERT INTO TINFO VALUES(NULL,'-',0,0,1,'$rid1','$aid3',7)";
  $result=mysql_query($sql);
  echo mysql_error();

  //----------------------------------------------------------
  $sql="SELECT MAX(IID) as IID1 FROM TINFO";
  $result=mysql_query($sql);
  $row=mysql_fetch_array($result);
  $iid1=$row["IID1"];

  $sql="INSERT INTO TTEXT VALUES(NULL,'$iid1','$ins')";
  $result=mysql_query($sql);
  echo mysql_error();

  print($ins.'<br>');
}

//-----------------------------------------------------------------------------------------------
//                                  Расчленение длинного текста на куски
//-----------------------------------------------------------------------------------------------
function rid_explod($rupid,$rtid,$ins)
{
  //-------------------------------------Разобрать текст по кускам

  $curwords=explode('<br>',$ins);
  $curwords=array_count_values($curwords);
  while (list($tword)=each($curwords))
  {
  if (strlen($tword)>3)
     {
     add_text_part($rupid,$rtid,$tword);
     }
  //endif
  }
  //wend
}


?>