dip / listrecs.php

<?
//----------------------------------------------
//       Просмотр данных одной вирт. таблицы
//----------------------------------------------

//--------------входной параметр rtid (rupid)

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 = "select * from TRECTYPE where RTID='$rtid'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);


if ($row["RTIDT"]!='COMMON')
   print('<h3>Данная категория записей запрещена для просмотра в списке!</h3>');
//endif

//----------------------------Данная категория записей разрешена для общего просмотра
if ($row["RTIDT"]=='COMMON'):
//------------------------------------


print('<h3>'.$row["RTTEXT"].'</h3>');



//---------------Надраздел
if ($ownrid!='')
   {
   $sql = "select A.ATYPE,TEXTF,DATEF,INTF,IID,R.RTID from TRECORDS R, TRECTYPE T, TINFO I, TATTR A ".
       "where R.RTID=T.RTID and A.AID=I.AID and I.RID=R.RID and A.ACC=1 and R.RID='$ownrid'";

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

   print('<table border="0" bordercolor="White">');//--------------------2
   while ($row=mysql_fetch_array($result))
      {
      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='<a href="/user/'.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
         else
            $inform='';
         //endif

      if ($row["ATYPE"]==7)
         {
         $iid=$row["IID"];
         $sql1="select * from TTEXT where IID='$iid'";
         $result1=mysql_query($sql1);
         $row1=mysql_fetch_array($result1);

         $inform=$row1["COMMENT"];
         $inform='';
         }
      //endif

      //------------------------
      //print('<tr><td bgcolor="#545454"><font color="white">');
      //print('&nbsp;&nbsp;&nbsp;'.$row["ATEXT"].'&nbsp;&nbsp;&nbsp;');
      //print('</font></td>');
      print('<tr><td bgcolor="#E4E4E4">');
      print('&nbsp;&nbsp;&nbsp;<font size=3>'.$inform.'</font>&nbsp;&nbsp;&nbsp;');
      print('</td></tr>');
      $rtidbk=$row["RTID"];
      }
   //WEND
   print('</table><br>');//--------------------2

   print('<a href="listrecs.php?rtid='.$rtidbk.'">Вернуться к списку</a><br>');
   }
//endif

//--------------------------------
if ($ownrid=='')
   //------------------------------------------------
   $sql = "select I.IID, I.TEXTF,I.DATEF,I.INTF,A.AID,A.ATEXT,I.ATYPE,R.RID from ".
       "TRECORDS R, TINFO I, TATTR A WHERE I.RID=R.RID AND ".
       "A.AID=I.AID AND R.RTID='$rtid' and A.ACC=1 order by I.RID desc, I.AID";
else
   //------------------------------------------------
   $sql = "select I.IID, I.TEXTF,I.DATEF,I.INTF,A.AID,A.ATEXT,I.ATYPE,R.RID from ".
       "TRECORDS R, TINFO I, TATTR A WHERE I.RID=R.RID AND ".
       "A.AID=I.AID AND R.RTID='$rtid' and R.OWNRID='$ownrid' and A.ACC=1 order by I.RID desc, I.AID";
//endif

$result=mysql_query($sql);

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

print('<table width="90%" border="0" cellspacing="0" cellpadding="0" bgcolor="#C4D0E6"><tr><td>');//--2
print('<table width="100%" cellpadding="0" cellspacing="1" border="0">');

print('<tr><td bgcolor="#f4f4f4" align=center>'.
'Информация</td>');



$atext=$row["ATEXT"];
print('<td bgcolor="f0f0f0"><font face="Arial" color="#000080" size=3>&nbsp;&nbsp;');
print($atext);
print('</font></td>');

$row=mysql_fetch_array($result);


$i=0;
//---------------------------------------------заголовки
while (( $row["AID"]!=$aidf ) && ($i<10))
   {

   $atext=$row["ATEXT"];

   //------------------------
   print('<td bgcolor="f0f0f0"><font face="Arial" color="#000080" size=3>&nbsp;&nbsp;');
   print($atext);
   print('</font></td>');
   //-------------------------
   $row=mysql_fetch_array($result);
   $i++;
   }
//wend
print('</tr>');

//---------------------------------------------данные
$result=mysql_query($sql);
print('<tr>');
while ($row=mysql_fetch_array($result))
   {
   $rid_old=$row["RID"];
   if ($row["AID"]==$aidf)
      {
      print('</tr><tr>');


      if ($ownrid==0)
         print('<td align="center">Смотреть<a href="listrecs.php?ownrid='.$row["RID"].
         '&rtid=19"><img src="2.gif" border="0"></a></td>');
      else
         print('<td></td>');
      //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"].'" target=blank>'.$row["TEXTF"].'</a>';
      else
         $inform='';

   if ($row["ATYPE"]==7)
      {
      $iid=$row["IID"];
      //$sql1="select * from TTEXT where IID='$iid'";
      //$result1=mysql_query($sql1);
      //$row1=mysql_fetch_array($result1);

      $inform='<a href="vieww.php?iid='.$iid.'" target=blank>смотреть текст</a>';
      //$inform=$row1["COMMENT"];
      }
   //endif


   //------------------------
   print('<td bgcolor="#f9f9f9" valign="top"><br><font size="3">&nbsp;&nbsp;');
   print($inform);
   print('&nbsp;&nbsp;</font></td>');
   //-------------------------

   }
//wend


print('</table></td></tr></table>');
print('<br>');

endif;


?>