Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- //----------------------------------------------
- // Просмотр данных по записи
- //----------------------------------------------
- //--------------входной параметр rid
- include("minc.php");
- //--------------------------------------record info
- // информация непосредственно о текущей записи
- //-------------------------------------------------
- $sql = "select * 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='$rid'";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- print("<h3>Автор последней модификации записи - ".$row["RTTEXT"]."</h3>");
- $result=mysql_query($sql);
- 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) $inform='<a href="/user/'.$row["TEXTF"].'">'.$row["TEXTF"].'</a>';
- 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(' '.$row["ATEXT"].' ');
- print('</font></td>');
- print('<td bgcolor="#E4E4E4">');
- print(' '.$inform.' ');
- print('</td></tr>');
- }
- //WEND
- print('</table>');//--------------------2
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement