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

Конкурс дизайнеров на 15000 рублей
Сервис интернет рекламы
Размер файла: 10.93Kb 
  1. <?php
  2.   include 'guestbook/mylib.php';
  3.   include 'config.php';
  4.   if (!checkagent($_SERVER['HTTP_USER_AGENT'])) { noemul(); exit; }
  5.   list ($opname, $chatok) = check_op($_SERVER['REMOTE_ADDR']);
  6.   if (!$chatok) { unk_op(); exit; }
  7.   $fppp=3;
  8.   $ftpp=10;
  9.   $fnewtop='t';
  10. #  $pflag=0;
  11.   $lang=$_GET['lang'];
  12.   $f=htmlspecialchars(trim($_GET['f']),ENT_QUOTES);
  13.   $t=htmlspecialchars(trim($_GET['t']),ENT_QUOTES);
  14.   $p=htmlspecialchars(trim($_GET['p']),ENT_QUOTES);
  15.   if ($p=='') $p=0;
  16.   session_start();
  17. ?>
  18. <?php
  19.   if (!($conn=pg_connect("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass")))
  20.   {
  21.   	header("Cache-Control: no-cache");
  22.   	header("Content-type: text/vnd.wap.wml");
  23. ?>
  24. <?xml version="1.0" encoding="utf-8"?>
  25. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  26. <wml>
  27. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  28. <card id="ChatErr" title="&#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430;">
  29. <p align="center">
  30. &#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430; &#x043F;&#x043E;&#x0434;&#x043A;&#x043B;&#x044E;&#x0447;&#x0435;&#x043D;&#x0438;&#x044F; &#x043A; &#x0411;&#x0414<br/>
  31. <a href="/">&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;</a>
  32. </p>
  33. </card>
  34. </wml>
  35. <?php
  36. 	exit;
  37.     }
  38.  
  39. 	$uid=0;
  40. 	$access=0;
  41. 	if (isset($_SESSION['id'])) {
  42. 		$uid=$_SESSION['id'];
  43. 		if ((!isset($_SESSION['access']))||(!isset($_SESSION['ftpp']))||(!isset($_SESSION['fppp']))||(!isset($_SESSION['fnewtop']))) {
  44. 			$res=pg_query($conn,"select access,fppp,ftpp,fnewtop from users where id='$uid';");
  45. 			$_SESSION['access']=pg_result($res,0,0);
  46. 			$_SESSION['fppp']=pg_result($res,0,1);
  47. 			$_SESSION['ftpp']=pg_result($res,0,2);
  48. 			$_SESSION['fnewtop']=pg_result($res,0,3);
  49. 		}
  50. 		$access=$_SESSION['access'];
  51. 		$fppp=$_SESSION['fppp'];
  52. 		$ftpp=$_SESSION['ftpp'];
  53. 		$fnewtop=$_SESSION['fnewtop'];
  54.  
  55. 	} else {
  56.   	if ((trim($_COOKIE['Login'])!='')&&(trim($_COOKIE['Password'])!='')) {
  57. 		$login=htmlspecialchars(trim($_COOKIE['Login']),ENT_QUOTES);
  58. 		$pass=htmlspecialchars(trim($_COOKIE['Password']),ENT_QUOTES);
  59. 		$res=pg_query($conn,"select id,access,fppp,ftpp,fnewtop from users where login='$login' and passwd='$pass' and moder=0;");
  60. 		if (pg_numrows($res)==1) {
  61. 			$uid=pg_result($res,0,0);
  62. 			$access=pg_result($res,0,1);
  63. 			$fppp=pg_result($res,0,2);
  64. 			$ftpp=pg_result($res,0,3);
  65. 			$fnewtop=pg_result($res,0,4);
  66. 			$_SESSION['id']=$uid;
  67. 			$_SESSION['fppp']=$fppp;
  68. 			$_SESSION['access']=$access;
  69. 			$_SESSION['ftpp']=$ftpp;
  70. 			$_SESSION['fnewtop']=$fnewtop;
  71. 		}
  72. 	}
  73. 	}
  74.  
  75. if (($f==0)&&($t==0)) {
  76.   	header("Cache-Control: no-cache");
  77.   	header("Content-type: text/vnd.wap.wml");
  78. ?>
  79. <?xml version="1.0" encoding="utf-8"?>
  80. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  81. <wml>
  82. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  83. <?php
  84. 	print "<card id=\"Forum\" title=\"&#x0424;&#x043E;&#x0440;&#x0443;&#x043C;\">\n";
  85.  
  86. 	print "<do name=\"a1\" type=\"options\" label=\"&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;\">\n";
  87. 	print '<go href="index.php?lang='.$lang.'" />';
  88. 	print "</do>\n";
  89.  
  90. 	print "<p align=\"center\">\n";
  91. 	print "<a href=\"frules/\">&#x041F;&#x0440;&#x0430;&#x0432;&#x0438;&#x043B;&#x0430; &#x0444;&#x043E;&#x0440;&#x0443;&#x043C;&#x0430;</a><br/><br/>\n";
  92. 	
  93. 	$res=pg_query($conn,"select id,name,flag,nthemes,nrepl,note from forums order by id;");
  94. 	$rows=pg_numrows($res);
  95. 	$timex=time()-300;
  96. 	for ($i=0; $i<$rows; $i++) {
  97. 		$rid=pg_result($res,$i,0);
  98. 		$nthemes=pg_result($res,$i,3);
  99. 		$nrepl=pg_result($res,$i,4);
  100. 		$note=pg_result($res,$i,5);
  101. 		$forum='';
  102. 		$flag=pg_result($res,$i,2);
  103. 		if (($flag!=1)||(($flag==1)&&($access))) {
  104. 			$isnew='';
  105. 			if ($uid) {
  106. 				$fres=pg_query($conn,"select id from fseen_by where uid='$uid' and forum='$rid';");
  107. 				if (!pg_numrows($fres)) $isnew='*';
  108. 			}
  109.         		$forum=uconv(pg_result($res,$i,1));
  110. 			print "<a href=\"forum.php?f=".$rid."&amp;lang=".$lang."\">".$isnew." ".$forum." (".$nthemes.") [".$nrepl."]</a><br/>".$note."<br/><br/>\n";
  111. 		}
  112. 	}
  113. 	print "<br/><a href=\"user_settings.php\">&#x041D;&#x0430;&#x0441;&#x0442;&#x0440;&#x043E;&#x0439;&#x043A;&#x0438;</a><br/>\n";
  114. }
  115.  
  116. 	
  117. if (($f>0)&&(!$t)) {
  118.   	header("Cache-Control: no-cache");
  119.   	header("Content-type: text/vnd.wap.wml");
  120. ?>
  121. <?xml version="1.0" encoding="utf-8"?>
  122. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  123. <wml>
  124. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  125. <?php
  126. 	$res=pg_query($conn,"select name,flag,nthemes from forums where id='$f';");
  127. 	$name=pg_result($res,0,0);
  128. 	$flag=pg_result($res,0,1);
  129. 	$nthemes=pg_result($res,0,2);
  130. 	if (!pg_numrows($res)) { pg_close($conn); exit; }
  131. 	if ($uid) {
  132. 		$res=pg_query($conn,"select id from fseen_by where uid='$uid' and forum='$f';");
  133. 		if (!pg_numrows($res))
  134. 			pg_query($conn,"insert into fseen_by (uid,forum) values ('$uid','$f');");
  135. 	}
  136. 	print "<card id=\"Forum\" title=\"".$name."\">\n";
  137. 	if ($p) {
  138. 		print "<do name=\"a1\" type=\"options\" label=\"Prev ".$ftpp."\">\n";
  139. 		print '<go href="forum.php?lang='.$lang.'&amp;f='.$f.'&amp;p='.($p-1).'" />';
  140. 		print "</do>\n";
  141. 	}
  142. 	if ($np > $p) {
  143. 		print "<do name=\"a2\" type=\"options\" label=\"Next ".$ftpp."\">\n";
  144. 		print '<go href="forum.php?lang='.$lang.'&amp;f='.$f.'&amp;p='.($p+1).'" />';
  145. 		print "</do>\n";
  146. 	}
  147. 	print "<do name=\"a3\" type=\"options\" label=\"&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;\">\n";
  148. 	print '<go href="index.php?lang='.$lang.'" />';
  149. 	print "</do>\n";
  150. 	print "<do name=\"a4\" type=\"options\" label=\"&#x0424;&#x043E;&#x0440;&#x0443;&#x043C;&#x044B;\">\n";
  151. 	print '<go href="forum.php?lang='.$lang.'" />';
  152. 	print "</do>\n";
  153. 	print "<do name=\"a5\" type=\"options\" label=\"&#x041D;&#x043E;&#x0432;&#x0430;&#x044F; &#x0442;&#x0435;&#x043C;&#x0430;\">\n";
  154. 	print '<go href="forum_post.php?lang='.$lang.'&amp;f='.$f.'" />';
  155. 	print "</do>\n";
  156. 	print "<p>\n";
  157. 	$offset=$p*$ftpp;
  158. 	$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';");
  159. 	$rows=pg_numrows($res);
  160. 	for ($i=0; $i<$rows; $i++) {
  161. 		$id=pg_result($res,$i,0);
  162. 		$name=uconv(pg_result($res,$i,1));
  163. 		$rdnum=pg_result($res,$i,2);
  164. 		$rplnum=pg_result($res,$i,3);
  165. 		$time=strftime("%d/%m %H:%M", pg_result($res,$i,4));
  166. 		$fr_u=pg_result($res,$i,5);
  167. 		$login=uconv(pg_result($res,$i,6));
  168. 		$closed=pg_result($res,$i,7);
  169. 		$sticker=pg_result($res,$i,8);
  170. 		$isnew='';
  171. 		$isclosed='';
  172. 		if ($closed) $isclosed='(closed)'; else $isclosed='';
  173. 		if ($sticker=='t') $issticker='(*)'; else $issticker='';
  174. 		if ($uid) {
  175. 			$fres=pg_query($conn,"select id from seen_by where uid='$uid' and theme='$id';");
  176. 			if (!pg_numrows($fres)) $isnew='(new)';
  177. 		}
  178. 		print "<a href=\"user_info.php?id=".$fr_u."\">".$login." [".$rplnum."] &lt;".$rdnum."&gt;</a><br/>".$time."<br/>".$name."<br/><a href=\"forum.php?t=".$id."&amp;lang=".$lang."\">".$issticker.$isnew.$isclosed."&gt;&gt;&gt;&gt;</a><br/>\n";
  179. 	}
  180. 	$np=floor($nthemes/$ftpp);
  181. 	print "<br/>Page: ".$p."/".$np."<br/>Go to page:\n";
  182. 	print "<input name=\"p\" type=\"text\" value=\"".$p."\" maxlength=\"3\" format=\"3N\"/><br/>\n";
  183. 	print "<anchor title=\"Go\">Go<go href=\"forum.php\" method=\"get\">\n";
  184. 	print "<postfield name=\"f\" value=\"".$f."\"/>\n";
  185. 	print "<postfield name=\"p\" value=\"$(p)\"/>\n";
  186. 	print "</go></anchor>\n";
  187. }
  188.  
  189. if ($t>0) {
  190.   	header("Cache-Control: no-cache");
  191.   	header("Content-type: text/vnd.wap.wml");
  192. ?>
  193. <?xml version="1.0" encoding="utf-8"?>
  194. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  195. <wml>
  196. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  197. <?php
  198. 	if (!$p) pg_query($conn,"update themes set rdnum=rdnum+1 where id='$t';");
  199. 	if ($uid) {
  200. 		$res=pg_query($conn,"select id from seen_by where uid='$uid' and theme='$t';");
  201. 		if (!pg_numrows($res))
  202. 			pg_query($conn,"insert into seen_by (uid,theme) values ('$uid','$t');");
  203. 	}
  204. 	$res=pg_query($conn,"select themes.forum,forums.flag,themes.closed,themes.rplnum from themes,forums where themes.id='$t' and forums.id=themes.forum;");
  205. 	$f=pg_result($res,0,0);
  206. 	$flag=pg_result($res,0,1);
  207. 	$closed=pg_result($res,0,2);
  208. 	$rplnum=pg_result($res,0,3);
  209. 	$np=floor($rplnum/$fppp);
  210. 	if ($uid) {
  211. 		$res=pg_query($conn,"select id from forum_moder where uid='$uid' and forum='$f';");
  212. 		if (pg_numrows($res)) $access=3;
  213. 	}
  214. 	print "<card id=\"Theme\" title=\"Page ".$p."/".$np."\">\n";
  215. 	if (!$closed) {
  216. 		print "<do name=\"a1\" type=\"options\" label=\"&#x041E;&#x0442;&#x0432;&#x0435;&#x0442;\">\n";
  217. 		print '<go href="forum_post.php?lang='.$lang.'&amp;t='.$t.'" />';
  218. 		print "</do>\n";
  219. 	}
  220. 	if ($p) {
  221. 		print "<do name=\"a2\" type=\"options\" label=\"Prev ".$fppp."\">\n";
  222. 		print '<go href="forum.php?lang='.$lang.'&amp;t='.$t.'&amp;p='.($p-1).'" />';
  223. 		print "</do>\n";
  224. 	}
  225. 	if ($np > $p) {
  226. 		print "<do name=\"a3\" type=\"options\" label=\"Next ".$fppp."\">\n";
  227. 		print '<go href="forum.php?lang='.$lang.'&amp;t='.$t.'&amp;p='.($p+1).'" />';
  228. 		print "</do>\n";
  229. 	}
  230. 	print "<do name=\"a4\" type=\"options\" label=\"&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;\">\n";
  231. 	print '<go href="index.php?lang='.$lang.'" />';
  232. 	print "</do>\n";
  233. 	print "<do name=\"a5\" type=\"options\" label=\"&#x0424;&#x043E;&#x0440;&#x0443;&#x043C;&#x044B;\">\n";
  234. 	print '<go href="forum.php?lang='.$lang.'" />';
  235. 	print "</do>\n";
  236. 	print "<do name=\"a6\" type=\"options\" label=\"&#x0421;&#x043F;&#x0438;&#x0441;&#x043E;&#x043A; &#x0442;&#x0435;&#x043C;\">\n";
  237. 	print '<go href="forum.php?lang='.$lang.'&amp;f='.$f.'" />';
  238. 	print "</do>\n";
  239. 	if ($access > 2) {
  240. 		print "<do name=\"a7\" type=\"options\" label=\"Del\">\n";
  241. 		print '<go href="forum_del.php?lang='.$lang.'&amp;t='.$t.'" />';
  242. 		print "</do>\n";
  243. 	}
  244. 	print "<p>\n";
  245. 	$offset=$p*$fppp;
  246. 	if ($fnewtop=='t') $rev='desc'; else $rev='';
  247. 	$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';");
  248. 	$rows=pg_numrows($res);
  249. 	for ($i=0; $i<$rows; $i++) {
  250. 		$id=pg_result($res,$i,0);
  251. 		$message=uconv(pg_result($res,$i,1));
  252. 		$fr_u=pg_result($res,$i,2);
  253. 		$time=strftime("%d/%m %H:%M",pg_result($res,$i,3));
  254. 		$login=uconv(pg_result($res,$i,4));
  255. 		print "<a href=\"user_info.php?id=".$fr_u."\">".$login."</a><br/>".$time."<br/>".$message."<br/>\n";
  256. 	}
  257. 	if ($rplnum > $fppp) {
  258. 		print "<br/>Page: \n";
  259. 		print "<select name=\"p\" value=\"".$p."\">\n";
  260. 		for ($i=0; $i<($np+1); $i++)
  261. 			print "<option value=\"".$i."\">".$i."</option>\n";
  262. 		print "</select><br/>\n";
  263. 		print "<anchor title=\"Go\">Go<go href=\"forum.php\" method=\"get\">\n";
  264. 		print "<postfield name=\"t\" value=\"".$t."\"/>\n";
  265. 		print "<postfield name=\"p\" value=\"$(p)\"/>\n";
  266. 		print "</go></anchor>\n";
  267. 	}
  268.  
  269. }
  270.  
  271. ?>
  272. </p>
  273. <?php counters(); ?>
  274. </card>
  275. </wml>