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

Конкурс дизайнеров на 15000 рублей
Автопокупка рекламы
Размер файла: 12.44Kb 
  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.   $ppp=9;
  8.   $showpics=1;
  9.   $pflag=0;
  10.   $lang=$_GET['lang'];
  11.   $refresh=300;
  12.   $p=htmlspecialchars(trim($_GET['p']),ENT_QUOTES);
  13.   $r=htmlspecialchars(trim($_GET['r']),ENT_QUOTES);
  14.   $n=$_GET['n']+1;
  15.   session_start();
  16. ?>
  17. <?php
  18.   if (!($conn=pg_connect("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass")))
  19.   {
  20.   	header("Cache-Control: no-cache");
  21.   	header("Content-type: text/vnd.wap.wml");
  22. ?>
  23. <?xml version="1.0" encoding="utf-8"?>
  24. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  25. <wml>
  26. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  27. <card id="ChatErr" title="&#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430;">
  28. <p align="center">
  29. &#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430; &#x043F;&#x043E;&#x0434;&#x043A;&#x043B;&#x044E;&#x0447;&#x0435;&#x043D;&#x0438;&#x044F; &#x043A; &#x0411;&#x0414<br/>
  30. <a href="/">&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;</a>
  31. </p>
  32. </card>
  33. </wml>
  34. <?php
  35. 	exit;
  36.     }
  37.  
  38. 	$uid=0;
  39. 	$access=0;
  40. 	if (isset($_SESSION['id'])) {
  41. 		$uid=$_SESSION['id'];
  42. 		if ((!isset($_SESSION['access']))||(!isset($_SESSION['ppp']))||(!isset($_SESSION['refresh']))||(!isset($_SESSION['showpics']))) {
  43. 			$res=pg_query($conn,"select access,ppp,refresh,showpics from users where id='$uid';");
  44. 			$_SESSION['access']=pg_result($res,0,0);
  45. 			$_SESSION['ppp']=pg_result($res,0,1);
  46. 			$_SESSION['refresh']=pg_result($res,0,2);
  47. 			$_SESSION['showpics']=pg_result($res,0,3);
  48. 		}
  49. 		$access=$_SESSION['access'];
  50. 		$ppp=$_SESSION['ppp'];
  51. 		$refresh=$_SESSION['refresh'];
  52. 		$showpics=$_SESSION['showpics'];
  53.  
  54. 	} else {
  55.   	if ((trim($_COOKIE['Login'])!='')&&(trim($_COOKIE['Password'])!='')) {
  56. 		$login=htmlspecialchars(trim($_COOKIE['Login']),ENT_QUOTES);
  57. 		$pass=htmlspecialchars(trim($_COOKIE['Password']),ENT_QUOTES);
  58. 		$res=pg_query($conn,"select id,access,ppp,refresh,showpics from users where login='$login' and passwd='$pass' and moder=0;");
  59. 		if (pg_numrows($res)==1) {
  60. 			$uid=pg_result($res,0,0);
  61. 			$access=pg_result($res,0,1);
  62. 			$ppp=pg_result($res,0,2);
  63. 			$refresh=pg_result($res,0,3);
  64. 			$showpics=pg_result($res,0,4);
  65. 			$_SESSION['id']=$uid;
  66. 			$_SESSION['ppp']=$ppp;
  67. 			$_SESSION['access']=$access;
  68. 			$_SESSION['refresh']=$refresh;
  69. 			$_SESSION['showpics']=$showpics;
  70. 		}
  71. 	}
  72. 	}
  73.  
  74. #if ($r==18) {
  75. #	if ($access==3) $access=2;
  76. #	if ($uid==1) $access=1;
  77. #	if ($uid==18172) $access=4;
  78. #}
  79.  
  80. if ($r==0) {
  81.   	header("Cache-Control: no-cache");
  82.   	header("Content-type: text/vnd.wap.wml");
  83. ?>
  84. <?xml version="1.0" encoding="utf-8"?>
  85. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  86. <wml>
  87. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  88. <?php
  89. 	if ($lang=='eng') {
  90. 		print "<card id=\"Chat\" title=\"Rooms\">\n";
  91. 		print "<do name=\"a1\" type=\"options\" label=\"Who's where\">\n";
  92. 	} else {
  93. 		print "<card id=\"Chat\" title=\"&#x041A;&#x043E;&#x043C;&#x043D;&#x0430;&#x0442;&#x044B;\">\n";
  94. 		print "<do name=\"a1\" type=\"options\" label=\"&#x041A;&#x0442;&#x043E; &#x0433;&#x0434;&#x0435;\">\n";
  95. 	}
  96. 	print '<go href="chat_who.php?lang='.$lang.'" />';
  97. 	print "</do>\n";
  98. 	print "<p align=\"center\">\n";
  99. 	if ($lang!='eng') {
  100. 		print "<a href=\"/rules/\">&#x0423;&#x0433;&#x043E;&#x043B;&#x043E;&#x0432;&#x043D;&#x044B;&#x0439; &#x041A;&#x043E;&#x0434;&#x0435;&#x043A;&#x0441; &#x0447;&#x0430;&#x0442;&#x0430;</a><br/>\n";
  101. 		print "<a href=\"chat_smiley.php\">&#x0421;&#x043C;&#x0430;&#x0439;&#x043B;&#x0438;&#x043A;&#x0438;</a><br/>\n";
  102. 		print "<a href=\"chat_pictures.php\">&#x041A;&#x0430;&#x0440;&#x0442;&#x0438;&#x043D;&#x043A;&#x0438;</a><br/>\n";
  103. 		print "<a href=\"tags.php\">&#x0422;&#x044D;&#x0433;&#x0438;</a><br/><br/>\n";
  104. 	}
  105. 	
  106. 	$res=pg_query($conn,"select id,name_eng,name_rus,flag from chat_rooms order by id;");
  107. 	$rows=pg_numrows($res);
  108. 	$timex=time()-300;
  109. 	for ($i=0; $i<$rows; $i++) {
  110. 		$rid=pg_result($res,$i,0);
  111. #		if (($rid==13)&&($uid!=1)&&($uid!=18172)&&($uid!=3)) continue;
  112. 		$room='';
  113. 		$flag=pg_result($res,$i,3);
  114. 		if (($flag!=1)||(($flag==1)&&($access))) {
  115. 			if ($lang!='eng') $room=uconv(pg_result($res,$i,2));
  116. 			if ($room=='') $room=uconv(pg_result($res,$i,1));
  117. 			if ($rid==18) {
  118. 				$res_cnt=pg_query($conn,"select distinct chat_tet.fr_u from chat_tet where chat_tet.time > '$timex';");
  119. 			} else {
  120. 				$res_cnt=pg_query($conn,"select distinct chat.fr_u from chat,users where chat.time > '$timex' and chat.room='$rid' and chat.fr_u=users.id and users.access<4;");
  121. 			}
  122. 			$rows_cnt=pg_numrows($res_cnt);
  123. 			print "<a href=\"chat.php?r=".$rid."&amp;lang=".$lang."\">".$room." (".$rows_cnt.")</a><br/>\n";
  124. 		}
  125. 	}
  126. 	if ($lang=='eng') {
  127. 		if ($uid) {
  128. 			print "<br/><a href=\"user_settings.php?lang=eng\">Chat settings</a><br/>\n";
  129. 		}
  130. 		print "<a href=\"index.php?lang=eng\">Main page</a>\n";
  131. 	} else {
  132. 		if ($uid) {
  133. 			print "<br/><a href=\"user_settings.php\">&#x041D;&#x0430;&#x0441;&#x0442;&#x0440;&#x043E;&#x0439;&#x043A;&#x0438; &#x0447;&#x0430;&#x0442;&#x0430;</a><br/>\n";
  134. 		}
  135. 		print "<a href=\"/\">&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;</a>\n";
  136. 	}
  137. ?>
  138. <br/><br/>
  139. <a href="http://pslink.ru/i.php?id=614">
  140. <img src="http://pslink.ru/b.php?id=614" alt="PSLink rating" />
  141. </a>
  142. <?php
  143. }
  144.  
  145. 	
  146. if ($r>0) {
  147. 	if (($uid)&&(!$n)) {
  148. 		setcookie("Login", $login, time()+864000, "/");
  149. 		setcookie("Password", $pass, time()+864000, "/"); 
  150. 	}
  151.   	header("Cache-Control: no-cache");
  152.   	header("Content-type: text/vnd.wap.wml");
  153. ?>
  154. <?xml version="1.0" encoding="utf-8"?>
  155. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  156. <wml>
  157. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  158. <?php
  159. 	$res=pg_query($conn,"select name_eng,name_rus,flag from chat_rooms where id='$r';");
  160. 	if (!pg_numrows($res)) { pg_close($conn); exit; }
  161. #	if (($r==13)&&($uid!=1)&&($uid!=18172)&&($uid!=3)) { pg_close($conn); exit; }
  162. 	$timex=time()-300;
  163. 	if ($r==18) {
  164. 		$res_cnt=pg_query($conn,"select distinct chat_tet.fr_u from chat_tet where chat_tet.time > '$timex';");
  165. 	} else {
  166. 		$res_cnt=pg_query($conn,"select distinct chat.fr_u from chat,users where chat.time > '$timex' and chat.room='$r' and chat.fr_u=users.id and users.access<4;");
  167. 	}
  168. 	$rows_cnt=pg_numrows($res_cnt);
  169. 	$flag=pg_result($res,0,2);
  170. 	if (($flag==1)&&(!$access)) { pg_close($conn); exit; }
  171. 	if ($lang!='eng') $room=uconv(pg_result($res,0,1));
  172. 	if ($room=='') $room=uconv(pg_result($res,0,0));
  173. 	if (!$p) { 
  174. 		print "<card id=\"Room\" title=\"".$room." (".$rows_cnt.")\" ontimer=\"http://wap.katrinka.ru/chat.php?lang=".$lang."&amp;r=".$r."&amp;n=".$n."&amp;".SID."\">\n";
  175. 		print "<timer value=\"".$refresh."\"/>\n";
  176. 	} else {
  177. 		 print "<card id=\"Room\" title=\"".$room."\">\n";
  178. 	}
  179. 	if ($lang=='eng')
  180. 		print "<do name=\"a1\" type=\"options\" label=\"Sign\">\n";
  181. 	else
  182. 		print "<do name=\"a1\" type=\"options\" label=\"&#x041D;&#x0430;&#x043F;&#x0438;&#x0441;&#x0430;&#x0442;&#x044C;\">\n";
  183. 	print '<go href="chat_add.php?lang='.$lang.'&amp;r='.$r.'" />';
  184. 	print "</do>\n";
  185. 	if ($lang=='eng')
  186. 		print "<do name=\"a2\" type=\"options\" label=\"Refresh\">\n";
  187. 	else
  188. 		print "<do name=\"a2\" type=\"options\" label=\"&#x041E;&#x0431;&#x043D;&#x043E;&#x0432;&#x0438;&#x0442;&#x044C;\">\n";
  189. 	print '<go href="chat.php?lang='.$lang.'&amp;r='.$r.'&amp;n='.$n.'" />';
  190. 	print "</do>\n";
  191. 	if ($lang=='eng')
  192. 		print "<do name=\"a3\" type=\"options\" label=\"Who's where\">\n";
  193. 	else
  194. 		print "<do name=\"a3\" type=\"options\" label=\"&#x041A;&#x0442;&#x043E; &#x0433;&#x0434;&#x0435;\">\n";
  195. 	print '<go href="chat_who.php?lang='.$lang.'" />';
  196. 	print "</do>\n";
  197. 	if ($lang=='eng')
  198. 		print "<do name=\"a4\" type=\"options\" label=\"Who's there\">\n";
  199. 	else
  200. 		print "<do name=\"a4\" type=\"options\" label=\"&#x041A;&#x0442;&#x043E; &#x0437;&#x0434;&#x0435;&#x0441;&#x044C;\">\n";
  201. 	print '<go href="chat_who.php?lang='.$lang.'&amp;r='.$r.'" />';
  202. 	print "</do>\n";
  203. 	if ($lang=='eng')
  204. 		print "<do name=\"a5\" type=\"options\" label=\"Leave room\">\n";
  205. 	else
  206. 		print "<do name=\"a5\" type=\"options\" label=\"&#x041F;&#x043E;&#x043A;&#x0438;&#x043D;&#x0443;&#x0442;&#x044C; &#x043A;&#x043E;&#x043C;&#x043D;&#x0430;&#x0442;&#x0443;\">\n";
  207. 	print '<go href="chat.php?lang='.$lang.'" />';
  208. 	print "</do>\n";
  209. 	if ($lang=='eng')
  210. 		print "<do name=\"a6\" type=\"options\" label=\"Main page\">\n";
  211. 	else
  212. 		print "<do name=\"a6\" type=\"options\" label=\"&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;\">\n";
  213. 	print '<go href="index.php?lang='.$lang.'" />';
  214. 	print "</do>\n";
  215. 		
  216. 	print "<p>\n";
  217. 	$timex=time()-1800;
  218. 	if ($r==13) $timex=time()-86400;
  219. 	if ($r==18) $timex=time()-259200;
  220.  
  221. 	$offset=$p*$ppp;
  222. 	if ($uid) {
  223. 		if ($r==18) {
  224. 			if ($access == 4) {
  225. 				$res=pg_query($conn,"select chat_tet.fr_u,chat_tet.to_u,chat_tet.message,chat_tet.time,users.login,users.posts,users.access,chat_tet.id from chat_tet,users where chat_tet.fr_u=users.id and chat_tet.time > '$timex' order by chat_tet.id desc limit $ppp offset $offset;");
  226. 			} else {
  227. 				$res=pg_query($conn,"select chat_tet.fr_u,chat_tet.to_u,chat_tet.message,chat_tet.time,users.login,users.posts,users.access,chat_tet.id from chat_tet,users where chat_tet.fr_u=users.id and (chat_tet.to_u=0 or chat_tet.to_u='$uid' or chat_tet.fr_u='$uid') and chat_tet.time > '$timex' order by chat_tet.id desc limit $ppp offset $offset;");
  228. 				$res_ign=pg_query($conn,"select who from users_ignore where uid='$uid';");
  229. 			}
  230. 		} else {
  231. 			if ($access > 3) {
  232. 				$res=pg_query($conn,"select chat.fr_u,chat.to_u,chat.message,chat.time,users.login,users.posts,users.access,chat.id,chat.flag from chat,users where chat.fr_u=users.id and chat.room='$r' and chat.time > '$timex' order by chat.id desc limit $ppp offset $offset;");
  233. 			} else {
  234. 				$res=pg_query($conn,"select chat.fr_u,chat.to_u,chat.message,chat.time,users.login,users.posts,users.access,chat.id,chat.flag from chat,users where chat.fr_u=users.id and chat.room='$r' and (chat.to_u=0 or chat.to_u='$uid' or chat.fr_u='$uid') and chat.time > '$timex' order by chat.id desc limit $ppp offset $offset;");
  235. 				$res_ign=pg_query($conn,"select who from users_ignore where uid='$uid';");
  236. 			}
  237. 		}
  238. 	} else {
  239. 		$res=pg_query($conn,"select chat.fr_u,chat.to_u,chat.message,chat.time,users.login,users.posts,users.access,chat.id,chat.flag from chat,users where chat.fr_u=users.id and chat.room='$r' and chat.to_u=0 and chat.time > '$timex' order by chat.id desc limit $ppp offset $offset;");
  240. 	}
  241. 	$rows=pg_numrows($res);
  242. 	$np=$p+1; $pp=$p-1;
  243. # $mp=floor($numrec/$ppp);
  244.  
  245. 	for ($i=0;$i<$rows;$i++) {
  246. 		$posts=pg_result($res,$i,5);
  247. 		$uacc=pg_result($res,$i,6);
  248. 		if ($access==4) $pid=pg_result($res,$i,7);
  249. 		$fr_u=pg_result($res,$i,0);
  250. 		if ($r!=18) $pflag=pg_result($res,$i,8);
  251.     	if (($posts > 100)&&($showpics)) {
  252. 			$message=smileys(uconv(pg_result($res,$i,2)));
  253. 			if ($uacc > 1) $message=msmileys($message);
  254. 			if ($fr_u==549) $message=o_smileys($message);
  255. 			if ($uacc > 1) $message=psmileys($message);
  256. 			if (($fr_u==1)||($fr_u==2)) $message=ksmileys($message);
  257. 		} else {
  258. 			$message=uconv(pg_result($res,$i,2));
  259. 		}
  260. 		$name=uconv(pg_result($res,$i,4));
  261. #		if ($access==3) $name = sprintf("<b><i>%s</i></b>", uconv(pg_result($res,$i,4)));
  262. #		if ($access==2) $name = sprintf("<b>%s</b>", uconv(pg_result($res,$i,4)));
  263. 		$mtime=strftime("%H:%M", pg_result($res,$i,3));
  264. 		$to_u=pg_result($res,$i,1);
  265. 		if (($uid)&&($access < 2)) {
  266. 			$ign_rows=pg_numrows($res_ign);
  267. 			if ($ign_rows) {
  268. 				for ($k=0; $k<$ign_rows; $k++) {
  269. 					if (pg_result($res_ign,$k,0)==pg_result($res,$i,0))
  270. 						$message='Ignored';
  271. 				}
  272. 			}
  273. 		
  274. 		}
  275. 		if ($to_u) {
  276. 				$res_to_u=pg_query($conn,"select login from users where id='$to_u';");
  277. 				$name_to=uconv(pg_result($res_to_u,0,0));
  278. 				print "<a href=\"user_info.php?id=".pg_result($res,$i,0)."&amp;r=".$r."&amp;pid=".$pid."\">". $name." -&gt; ".$name_to." ".$mtime."&gt;</a> ".$message."<br/>";
  279. 		} else {
  280. 			if ($pflag) {
  281. 				print "<a href=\"user_info.php?id=".pg_result($res,$i,0)."&amp;r=".$r."&amp;pid=".$pid."\">* [".$mtime."]</a> ". $name." ".$message."<br/>";
  282. 			} else {
  283. 				print "<a href=\"user_info.php?id=".pg_result($res,$i,0)."&amp;r=".$r."&amp;pid=".$pid."\">". $name." ".$mtime."&gt;</a> ".$message."<br/>";
  284. 			}
  285. 		}
  286.   	}
  287.  
  288. 	if ($rows>=$ppp) print("<a href=\"chat.php?p=".$np."&amp;r=".$r."&amp;lang=".$lang."\">Next ".$ppp."</a><br/>");
  289. 	if ($p>0) print("<a href=\"chat.php?p=".$pp."&amp;r=".$r."&amp;lang=".$lang."\">Prev ".$ppp."</a><br/>"); 
  290. }
  291.   pg_close($conn);
  292. ?>
  293. </p>
  294. </card>
  295. </wml>