Просмотр файла katrinka.ru/admin/forum.php

Конкурс дизайнеров на 15000 рублей
Сервис интернет рекламы
Размер файла: 5.41Kb 
  1. <?php
  2.   include '../wap/guestbook/mylib.php';
  3.   include '../wap/config.php';
  4.   include 'acl.php';
  5.   $addr=$_SERVER['REMOTE_ADDR'];
  6.   list ($uid, $pl) = priv_level();
  7.   $fppp=30;
  8.   $ftpp=30;
  9.   $fnewtop='f';
  10.   if ($uid==1) $fnewtop='t';
  11. #  $pflag=0;
  12.   $lang=$_GET['lang'];
  13.   $f=htmlspecialchars(trim($_GET['f']),ENT_QUOTES);
  14.   $t=htmlspecialchars(trim($_GET['t']),ENT_QUOTES);
  15.   $p=htmlspecialchars(trim($_GET['p']),ENT_QUOTES);
  16. ?>
  17. <?php
  18.   if (!($conn=pg_connect("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass")))
  19.   {
  20. 	exit;
  21.     }
  22.   pg_query($conn,"SET CLIENT_ENCODING TO 'KOI8';");
  23.  
  24. if (($f==0)&&($t==0)) {
  25.   	header("Cache-Control: no-cache");
  26. ?>
  27. <html>
  28. <head><meta http-equiv="Cache-Control" content="no-cache"></head>
  29. <body>
  30. <?php
  31. 	print "<p align=\"center\">\n";
  32. 	
  33. 	$res=pg_query($conn,"select id,name,flag,nthemes,nrepl,note from forums order by id;");
  34. 	$rows=pg_numrows($res);
  35. 	$timex=time()-300;
  36. 	for ($i=0; $i<$rows; $i++) {
  37. 		$rid=pg_result($res,$i,0);
  38. 		$nthemes=pg_result($res,$i,3);
  39. 		$nrepl=pg_result($res,$i,4);
  40. 		$note=pg_result($res,$i,5);
  41. 		$forum='';
  42. 		$flag=pg_result($res,$i,2);
  43. 		if (($flag!=1)||(($flag==1)&&($access))) {
  44. 			if ($uid) {
  45. 				$isnew='';
  46. 				$fres=pg_query($conn,"select id from fseen_by where uid='$uid' and forum='$rid';");
  47. 				if (!pg_numrows($fres)) $isnew='*';
  48. 			}
  49.         		$forum=pg_result($res,$i,1);
  50. 			print "<a href=\"forum.php?f=".$rid."&amp;lang=".$lang."\">".$isnew." ".$forum." (".$nthemes.") [".$nrepl."]</a><br/>".$note."<br/><br/>\n";
  51. 		}
  52. 	}
  53. }
  54.  
  55. 	
  56. if (($f>0)&&(!$t)) {
  57.   	header("Cache-Control: no-cache");
  58. ?>
  59. <html>
  60. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  61. <body>
  62. <?php
  63. 	$res=pg_query($conn,"select name,flag from forums where id='$f';");
  64. 	if (!pg_numrows($res)) { pg_close($conn); exit; }
  65. 	$name=pg_result($res,0,0);
  66. 	$flag=pg_result($res,0,1);
  67. 	if ($uid) {
  68. 	$res=pg_query($conn,"select id from fseen_by where uid='$uid' and forum='$f';");
  69. 	if (!pg_numrows($res))
  70. 		pg_query($conn,"insert into fseen_by (uid,forum) values ('$uid','$f');");
  71. 	}
  72. 	print "<p>\n";
  73. 	$offset=$p*$ftpp;
  74. 	$res=pg_query($conn,"select themes.id,themes.name,themes.rdnum,themes.rplnum,themes.time,themes.uid,users.login,themes.closed,themes.sticker from themes,users where users.id=themes.uid and users.moder=0 and themes.forum='$f' order by sticker desc,themes.lastrepl desc limit '$ftpp' offset '$offset';");
  75. 	$rows=pg_numrows($res);
  76. 	for ($i=0; $i<$rows; $i++) {
  77. 		$id=pg_result($res,$i,0);
  78. 		$name=pg_result($res,$i,1);
  79. 		$rdnum=pg_result($res,$i,2);
  80. 		$rplnum=pg_result($res,$i,3);
  81. 		$time=strftime("%d/%m %H:%M", pg_result($res,$i,4));
  82. 		$fr_u=pg_result($res,$i,5);
  83. 		$login=pg_result($res,$i,6);
  84. 		$closed=pg_result($res,$i,7);
  85. 		$sticker=pg_result($res,$i,8);
  86. 		if ($closed) $isclosed='(closed)'; else $isclosed='';
  87. 		if ($sticker=='t') $issticker='(*)'; else $issticker='';
  88. 		$isnew='';
  89. 		if ($uid) {
  90. 			$fres=pg_query($conn,"select id from seen_by where uid='$uid' and theme='$id';");
  91. 			if (!pg_numrows($fres)) $isnew='(new)';
  92. 		}
  93. 		print "<a href=\"forum_del.php?t=".$id."\">[x]</a> <a href=\"forum_close.php?t=".$id."\">[c]</a> <a href=\"user_edit.php?id=".$fr_u."\">".$login." [".$rplnum."] &lt;".$rdnum."&gt;</a> ".$time."<br/>".$name."<br/><a href=\"forum.php?t=".$id."&amp;lang=".$lang."\">".$issticker.$isclosed.$isnew."&gt;&gt;&gt;&gt;</a><br/>\n";
  94. 		print "<hr>\n";
  95. 	}
  96. 	print "<br/>\n";
  97. 	if ($p) print "<a href=\"forum.php?f=".$f."&amp;p=".($p-1)."\">Prev ".$ftpp."</a><br/>";
  98. 	if ($rows==$ftpp) print "<a href=\"forum.php?f=".$f."&amp;p=".($p+1)."\">Next ".$ftpp."</a><br>";
  99. 	print "<a href=\"forum.php\">уРЙУПЛ жПТХНПЧ</a>&nbsp;&nbsp;\n";
  100. 	print "<a href=\"forum_post.php?f=".$f."\">оПЧБС ФЕНБ</a>\n";
  101. }
  102.  
  103. if ($t>0) {
  104.   	header("Cache-Control: no-cache");
  105. ?>
  106. <html>
  107. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  108. <body>
  109. <?php
  110. 	if (!$p) pg_query($conn,"update themes set rdnum=rdnum+1 where id='$t';");
  111. 	if ($uid) {
  112. 		$res=pg_query($conn,"select id from seen_by where uid='$uid' and theme='$t';");
  113. 		if (!pg_numrows($res))
  114. 			pg_query($conn,"insert into seen_by (uid,theme) values ('$uid','$t');");
  115. 	}
  116. 	$res=pg_query($conn,"select themes.forum,forums.flag from themes,forums where themes.id='$t' and forums.id=themes.forum;");
  117. 	$f=pg_result($res,0,0);
  118. 	$flag=pg_result($res,0,1);
  119. 	print "<p>\n";
  120. 	$offset=$p*$fppp;
  121. 	if ($fnewtop=='t') $rev='desc'; else $rev='';
  122. 	$res=pg_query($conn,"select threads.id,threads.message,threads.uid,threads.time,users.login where users.id=threads.uid and users.moder=0 and threads.theme='$t' order by threads.id $rev limit '$fppp' offset '$offset';");
  123. 	$rows=pg_numrows($res);
  124. 	for ($i=0; $i<$rows; $i++) {
  125. 		$id=pg_result($res,$i,0);
  126. 		$message=pg_result($res,$i,1);
  127. 		$fr_u=pg_result($res,$i,2);
  128. 		$time=strftime("%d/%m %H:%M",pg_result($res,$i,3));
  129. 		$login=pg_result($res,$i,4);
  130. 		print "<a href=\"forum_del.php?pid=".$id."\">[x]</a> <a href=\"user_edit.php?id=".$fr_u."\">".$login."</a> ".$time."<br/>".$message."<br/>\n";
  131. 		print "<hr>\n";
  132. 	}
  133. 	print "<br/>\n";
  134. 	if ($p) print "<a href=\"forum.php?t=".$t."&amp;p=".($p-1)."\">Prev ".$fppp."</a><br/>";
  135. 	if ($rows==$fppp) print "<a href=\"forum.php?t=".$t."&amp;p=".($p+1)."\">Next ".$fppp."</a>";
  136. ?>
  137. <FORM NAME="message" METHOD=POST ACTION="forum_sign.php">
  138. <input type="text" name="message" size="80">
  139. <?php print "<input type=\"hidden\" name=\"t\" value=\"".$t."\">\n"; ?>
  140. <INPUT TYPE=SUBMIT VALUE="рЕТЕУМБФШ">
  141. </FORM>
  142. <?php
  143. 	print "<a href=\"forum.php?f=".$f."\">уРЙУПЛ фЕН</a>\n";
  144. }
  145.  
  146. ?>
  147. </p>
  148. </body>
  149. </html>