dip / viewcont.php

<?


include("minc.php");

$file=fopen("title.html","r");
$data=fread($file,2000);
print($data);

$file=fopen("top.html","r");
$data=fread($file,2000);
print($data);

//--------------------------Списки записей в портфеле
$sql="delete from T_CONTEXTQ1 where OWNRID='$rid'";
mysql_query($sql);
echo mysql_error();

//------------------------------
$sql="select * from T_CONTEXTQ WHERE RID='$rid'";
$result=mysql_query($sql);
echo mysql_error();
$row=mysql_fetch_array($result);
$conlink=$row["CONLINK"];

$conlink=round($conlink/5);

//--------------------------Подзаписи записи в портфеле
$sql= "INSERT INTO T_CONTEXTQ1 ".
      "select count(*) AS CONLINK,D.DATEIN,D.RID,D.AID,A.RID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
      " from TWORDLINK A, TWORDLINK B, T_RECQUERY D ".
      " WHERE A.NWORD=B.NWORD AND ".
      " D.RID=B.RID AND ".
      " A.RID='$rid' ".
      " GROUP BY D.DATEIN,D.RID,D.AID,D.OWNRID,D.TEXTF,D.DATEF,D.INTF,D.ATYPE ".
      " HAVING COUNT(*)>'$conlink' ORDER BY CONLINK DESC, D.RID desc, D.AID";

mysql_query($sql);
echo mysql_error();



$sql="select * from T_CONTEXTQ1 WHERE OWNRID='$rid' order by CONLINK desc, RID,AID";

$result=mysql_query($sql);
echo mysql_error();

$row=mysql_fetch_array($result);
$aidf=$row["AID"];
$ridf=$row["RID"];

print('<table border="1" width="100%" >');
$result=mysql_query($sql);
print('<tr>');

$i1=0;
while (($row=mysql_fetch_array($result)) && ($i1<50))
   {
   if ($row["RID"]!=$ridf)
      {
      print('</tr><tr><td width="60"><font size=-1><B>'.$row["CONLINK"].'</b> &&& '.$row["DATEIN"].
      '</FONT></td><TD bgcolor="#E0E0E0">'.
      $row["RTTEXT"].
      '%%% <a href="viewcont.php?rid='.$row["RID"].'">Контекст</a> </TD>');

      //---------------- автор записи
      $rstr="openWin2('author.php?rid=".$row["OWNRID"]."')";

      print('<td>'.
            '<img src="inf1.gif" border="0" onclick="'.
             $rstr.'" style="border: none;" alt="Автор записи"></TD>');

      $ridf=$row["RID"];
      $aidf=$row["AID"];
      $i1++;
      }
   else
      if ($row["AID"]==$aidf)
         {
         print('</tr><tr><td width="60"><font size=-1><B>'.$row["CONLINK"].'</b> &&& '.$row["DATEIN"].
         '</FONT></td><TD bgcolor="#E0E0E0">'.
         $row["RTTEXT"].
         '%%% <a href="viewcont.php?rid='.$row["RID"].'">Контекст</a> </TD>');

         //---------------- автор записи
         $rstr="openWin2('author.php?rid=".$row["OWNRID"]."')";

         print('<td>'.
               '<img src="inf1.gif" border="0" onclick="'.
               $rstr.'" style="border: none;" alt="Автор записи"></TD>');
         $i1++;
         }
      //endif
   //endif

   if ($row["ATYPE"]==1) $inform=$row["TEXTF"];
   if ($row["ATYPE"]==2) $inform=$row["TEXTF"];
   if ($row["ATYPE"]==3) $inform=$row["DATEF"];
   if ($row["ATYPE"]==4) $inform=$row["INTF"];
   if ($row["ATYPE"]==5) $inform=$row["TEXTF"];
   if ($row["ATYPE"]==6)
      if (strrchr($row["TEXTF"],"."))
         $inform=$hrefdir.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
      else
         $inform='';
      //endif
   //endif

   if ($row["ATYPE"]==7)
       {
       $iid=$row["IID"];
       $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть</a>';
       }
   //endif

   //------------------------
   print('<td bgcolor="#FFFDF4">');
   print('<font size=3>');
   print($inform);
   print('</font>');
   print('</td>');
   //-------------------------
   }
//wend
print('</table>');

?>