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

Конкурс дизайнеров на 15000 рублей
Сервис интернет рекламы
Размер файла: 12.27Kb 
  1. <?php
  2.   include 'config.php';
  3.   include 'guestbook/mylib.php';
  4.   $ppp=20;
  5.   session_start();
  6.  
  7.    $lang=$_GET['lang'];
  8.    $p=htmlspecialchars(trim($_GET['p']),ENT_QUOTES);
  9.    $cat=htmlspecialchars(trim($_GET['cat']),ENT_QUOTES);
  10.    $action=htmlspecialchars(trim($_GET['action']),ENT_QUOTES);
  11. #   if ($_POST['id']!=0) $id=$_POST['id'];
  12. #   else $id=$_GET['id'];
  13.   $id=htmlspecialchars(trim($_GET['id']),ENT_QUOTES);
  14.   $agent=$_SERVER['HTTP_USER_AGENT'];
  15.   $addr=$_SERVER['REMOTE_ADDR'];
  16.   list ($opname, $chatok) = check_op($_SERVER['REMOTE_ADDR']);
  17.   $dayx=date("Y-m-d", mktime(0,0,0,date("m"), date("d")-3, date("Y")));
  18.  
  19. #  if (midi_access($agent)) $access=1;
  20. #  else $access=0;
  21.   $access=1;
  22.   $getpath='/sorry.wml';
  23. ?>
  24. <?php
  25.   if (!($conn=pg_connect("host=$dbhost port=$dbport dbname=$dbname user=$dbuser password=$dbpass")))
  26.   {
  27. 	header("Content-type: text/vnd.wap.wml");
  28. ?>
  29. <?xml version="1.0" encoding="utf-8"?>
  30. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  31. <wml>
  32. <card id="CatalogErr" title="&#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430;">
  33. <p align="center">
  34. &#x041E;&#x0448;&#x0438;&#x0431;&#x043A;&#x0430; &#x043F;&#x043E;&#x0434;&#x043A;&#x043B;&#x044E;&#x0447;&#x0435;&#x043D;&#x0438;&#x044F; &#x043A; &#x0411;&#x0414<br/>
  35. <a href="/">&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;</a>
  36. </p>
  37. </card>
  38. </wml>
  39. <?php
  40. 	exit;
  41.     }
  42. if (($cat==0)&&($action=='')&&($id==0)) {
  43. 	header("Content-type: text/vnd.wap.wml"); ?>
  44. <?xml version="1.0" encoding="utf-8"?>
  45. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  46. <wml> <?php
  47. 	print "<card id=\"Catalog\" title=\"Polyphony\">\n";
  48. 	print "<p align=\"center\">**********<br/>\n";
  49. 	$res=pg_query($conn,"select count(*) from midi,cat where midi.adate > '$dayx' and midi.enabled=1 and midi.category=cat.id and cat.content=1;");
  50. 	if ($lang=='eng') { 
  51. 		print "<a href=\"midi.php?lang=eng&amp;action=news\">What's New (".pg_result($res,0,0).")</a><br/>\n";
  52. 		print "<a href=\"midi.php?lang=eng&amp;action=top\">Top 10</a><br/><br/>\n";
  53. 	
  54. 	} else { 
  55. 		print "<a href=\"midi.php?action=news\">&#x0427;&#x0442;&#x043E; &#x041D;&#x043E;&#x0432;&#x0435;&#x043D;&#x044C;&#x043A;&#x043E;&#x0433;&#x043E; (".pg_result($res,0,0).")</a><br/>\n";
  56. 		print "<a href=\"midi.php?action=top\">Top 10</a><br/><br/>\n";
  57. 	}
  58. 	$res=pg_query($conn,"select id,name_eng,name_rus from cat where enabled=1 and content=1 order by id;");
  59. 	$rows=pg_numrows($res);
  60.  
  61.   for ($i=0;$i<$rows;$i++) {
  62. 	$cid=pg_result($res,$i,0);
  63. 	$res_cnt=pg_query($conn,"select count(*) from midi where category='$cid' and enabled=1;");
  64. 	if ($lang=='eng') { 
  65. 		$catname=pg_result($res,$i,1);
  66. 		print "<a href=\"midi.php?lang=eng&amp;cat=".pg_result($res,$i,0)."\">".$catname." (".pg_result($res_cnt,0,0).")</a><br/>\n";
  67. 	} else { 
  68. 		$catname=uconv(pg_result($res,$i,2));
  69. 		if ($catname=='') $catname=pg_result($res,$i,1);
  70. 		print "<a href=\"midi.php?cat=".pg_result($res,$i,0)."\">".$catname." (".pg_result($res_cnt,0,0).")</a><br/>\n";
  71. 	}
  72.   }
  73.  
  74.   pg_close($conn);
  75. print "*******<br/>\n";
  76. if ($lang=='eng') print "<a href=\"/index.php?lang=eng\">Main page</a><br/>\n";
  77. else print "<a href=\"/\">&#x041D;&#x0430; &#x0433;&#x043B;&#x0430;&#x0432;&#x043D;&#x0443;&#x044E;</a><br/>\n";
  78. }
  79. if (($cat>0)&&($action=='')&&($id==0)) {
  80. 	if ($access) setcookie("Sweetty", "21895", time()+864000, "/");
  81. 	header("Content-type: text/vnd.wap.wml"); ?>
  82. <?xml version="1.0" encoding="utf-8"?>
  83. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  84. <wml> <?php
  85. 	$res=pg_query($conn,"select name_eng,name_rus from cat where id=$cat;");
  86. 	if ($lang=='eng') $catname=pg_result($res,0,0);
  87. 	else {
  88. 		$catname=uconv(pg_result($res,0,1));
  89. 		if ($catname=='') $catname=pg_result($res,0,0);
  90. 	}
  91. 	print "<card id=\"Links\" title=\"".$catname."\">\n";
  92. 	print "<p align=\"center\">**************<br/>\n";
  93. 	$offset=$p*$ppp;
  94. 	$res=pg_query($conn,"select count(id) from midi where enabled=1 and category='$cat';");
  95. 	$numrec=pg_result($res,0,0);
  96. 	$res=pg_query($conn,"select id,name_eng,name_rus from midi where enabled=1 and category=$cat order by name_eng limit $ppp offset $offset;");
  97. 	$rows=pg_numrows($res);
  98. 	$np=$p+1; $pp=$p-1; $mp=floor(($numrec-1)/$ppp);
  99.  
  100. 	for ($i=0;$i<$rows;$i++) {
  101. 		if ($lang=='eng') $midiname=uconv(pg_result($res,$i,1));
  102. 		else { 
  103. 			$midiname=uconv(pg_result($res,$i,2));
  104. 			if ($midiname=='') $midiname=uconv(pg_result($res,$i,1));
  105. 		}
  106. 		if ($access) $getpath=sprintf("midi.php?id=%d", pg_result($res,$i,0));
  107. 		else $getpath='/sorry.wml';
  108. 		print "<a href=\"".$getpath."\">".$midiname."</a><br/>\n";
  109. 	}
  110. 	$res=pg_query($conn, "select rdate from cat where id=$cat and enabled=1;");
  111. 	ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", pg_result($res,0,0), $regs);
  112. 	pg_close($conn);
  113.  
  114. 	print "*******<br/><br/>\n";
  115. 	if ($lang=='eng') { 
  116. 		if ($numrec > $ppp) {
  117. 			if ($p<$mp) print("<a href=\"midi.php?lang=eng&amp;p=".$np."&amp;cat=".$cat."\">Next ".$ppp."</a><br/>\n");
  118. 			if ($p>0) print("<a href=\"midi.php?lang=eng&amp;p=".$pp."&amp;cat=".$cat."\">Prev ".$ppp."</a><br/>\n"); 
  119. 		}
  120. 		print "<a href=\"midi.php?lang=eng\">Back</a><br/>\n";
  121. 		print "<b>Last update: ".$regs[1]."-".$regs[2]."-".$regs[3]."</b>";
  122. 	} else { 
  123. 		if ($numrec > $ppp) {
  124. 			if ($p<$mp) print("<a href=\"midi.php?p=".$np."&amp;cat=".$cat."\">&#x0421;&#x043B;&#x0435;&#x0434;&#x0443;&#x044E;&#x0449;&#x0438;&#x0435; ".$ppp."</a><br/>\n");
  125. 			if ($p>0) print("<a href=\"midi.php?p=".$pp."&amp;cat=".$cat."\">&#x041F;&#x0440;&#x0435;&#x0434;&#x044B;&#x0434;&#x0443;&#x0449;&#x0438;&#x0435; ".$ppp."</a><br/>\n"); 
  126. 		}
  127. 		print "<a href=\"midi.php\">&#x041D;&#x0430;&#x0437;&#x0430;&#x0434;</a><br/>\n";
  128. 		print "<b>&#x041F;&#x043E;&#x0441;&#x043B;&#x0435;&#x0434;&#x043D;&#x0435;&#x0435; &#x043E;&#x0431;&#x043D;&#x043E;&#x0432;&#x043B;&#x0435;&#x043D;&#x0438;&#x0435;: ".$regs[3].".".$regs[2].".".$regs[1]."</b>";
  129. 	}
  130. }
  131.  
  132. if (($action=='top')&&($cat==0)&&($id==0)) {
  133. 	if ($access) setcookie("Sweetty", "21895", time()+864000, "/");
  134. 	header("Content-type: text/vnd.wap.wml"); ?>
  135. <?xml version="1.0" encoding="utf-8"?>
  136. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  137. <wml>
  138. <card id="Top10" title="Top10">
  139. <p align="center">
  140. ***********<br/>
  141. <?php
  142. 	$res=pg_query($conn,"select midi.id,midi.name_eng,midi.name_rus,midi.dlcount from midi,cat where midi.enabled=1 and midi.dlcount > 0and midi.category=cat.id and cat.content=1 order by midi.dlcount desc limit 10;");
  143. 	$rows=pg_numrows($res);
  144. 	for ($i=0; $i<$rows; $i++) {
  145. 		$fname=uconv(pg_result($res,$i,2));
  146. 		$pos=$i+1;
  147. 		if (($lang=='eng')||($fname=='')) $fname=uconv(pg_result($res,$i,1));
  148. 		if ($access) $getpath=sprintf("midi.php?id=%d", pg_result($res,$i,0));
  149. 		print $pos.".<a href=\"".$getpath."\">".$fname."</a><br/>\n";
  150. 	}
  151. 	print "<br/>\n";
  152. 	if ($lang=='eng')
  153. 		print "<a href=\"midi.php?lang=eng\">Back</a><br/>\n";	
  154. 	else
  155. 		print "<a href=\"midi.php\">&#x041D;&#x0430;&#x0437;&#x0430;&#x0434;</a><br/>\n";	
  156. print "*******\n";
  157. pg_close($conn);
  158. }
  159.  
  160. if (($action=='news')&&($id==0)) {
  161. 	if ($cat=='') $cat=1;
  162. 	if ($access) setcookie("Sweetty", "21895", time()+864000, "/");
  163. 	header("Content-type: text/vnd.wap.wml"); ?>
  164. <?xml version="1.0" encoding="utf-8"?>
  165. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  166. <wml> <?php
  167. 	$fl=0;
  168. 	$res=pg_query($conn,"select max(rdate) from cat where enabled=1;");
  169. 	ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", pg_result($res,0,0), $regs);
  170. 	if ($lang=='eng') {
  171. 		print "<card id=\"News\" title=\"What's New\">\n";
  172. 		print "<p align=\"center\">\n";
  173. 		print "***********<br/>\n";
  174. 		print "<b>Last update: ".$regs[1]."-".$regs[2]."-".$regs[3]."</b><br/><br/>";
  175. 	} else {
  176. 		print "<card id=\"News\" title=\"&#x0427;&#x0442;&#x043E; &#x043D;&#x043E;&#x0432;&#x0435;&#x043D;&#x044C;&#x043A;&#x043E;&#x0433;&#x043E;\">\n";
  177. 		print "<p align=\"center\">\n";
  178. 		print "***********<br/>\n";
  179. 		print "<b>&#x041F;&#x043E;&#x0441;&#x043B;&#x0435;&#x0434;&#x043D;&#x0435;&#x0435; &#x043E;&#x0431;&#x043D;&#x043E;&#x0432;&#x043B;&#x0435;&#x043D;&#x0438;&#x0435;: ".$regs[3].".".$regs[2].".".$regs[1]."</b><br/><br/>";
  180. 	}
  181. 	$res=pg_query($conn, "select id,name_eng,name_rus from cat where enabled=1 and content=1 order by id;");
  182. 	$rows=pg_numrows($res);
  183. 	for ($i=0; $i<$rows; $i++)
  184. 	{
  185. 		$cid=pg_result($res,$i,0);	
  186. 		$fres=pg_query($conn, "select id,name_eng,name_rus from midi where enabled=1 and category ='$cid' and adate > '$dayx' order by name_eng;");
  187. 		$frows=pg_numrows($fres);
  188. 		if ($frows > 0) {
  189. 			$fl++;
  190. 			if ($lang=='eng') {
  191. 				$catname=pg_result($res,$i,1);
  192. 				print "<a href=\"midi.php?cat=".pg_result($res,$i,0)."&amp;lang=eng&amp;action=news\">".
  193. 				$catname." (".$frows."):</a><br/>----------------<br/>\n";
  194. 				if (pg_result($res,$i,0)==$cat) {
  195. 					for ($f=0; $f<$frows; $f++) {
  196. 						$fname=uconv(pg_result($fres,$f,1));
  197. 						if ($access) $getpath=sprintf("midi.php?id=%d", pg_result($fres,$f,0));
  198. 						print "<a href=\"".$getpath."\">".$fname."</a><br/>\n";
  199. 					}
  200. 					print "<br/>\n";
  201. 				}
  202. 				
  203. 			} else {
  204. 				$catname=uconv(pg_result($res,$i,2));
  205. 				if ($catname=='') $catname=pg_result($res,$i,1);
  206. 				print "<a href=\"midi.php?cat=".pg_result($res,$i,0)."&amp;action=news\">".
  207. 				$catname." (".$frows."):</a><br/>----------------<br/>\n";
  208. 				if (pg_result($res,$i,0)==$cat) {
  209. 					for ($f=0; $f<$frows; $f++) {
  210. 						$fname=uconv(pg_result($fres,$f,2));
  211. 						if ($fname=='') $fname=uconv(pg_result($fres,$f,1));
  212. 						if ($access) $getpath=sprintf("midi.php?id=%d", pg_result($fres,$f,0));
  213. 						print "<a href=\"".$getpath."\">".$fname."</a><br/>\n";
  214. 					}
  215. 					print "<br/>\n";
  216. 				}
  217. 			}
  218. 		}
  219. 	}
  220.  
  221. 	if ($lang=='eng') {
  222. 		if (!$fl) print "Sorry, nothing new at this moment.<br/>\n";
  223. 		print "<a href=\"midi.php?lang=eng\">Back</a><br/>\n";	
  224. 	} else {
  225. 		if (!$fl) print "&#x0418;&#x0437;&#x0432;&#x0438;&#x043D;&#x0438;&#x0442;&#x0435;, &#x043D;&#x0438;&#x0447;&#x0435;&#x0433;&#x043E; &#x043D;&#x043E;&#x0432;&#x0435;&#x043D;&#x044C;&#x043A;&#x043E;&#x0433;&#x043E; &#x043D;&#x0435;&#x0442;.<br/>\n";
  226. 		print "<a href=\"midi.php\">&#x041D;&#x0430;&#x0437;&#x0430;&#x0434;</a><br/>\n";	
  227. 	}
  228. print "*******\n";
  229. pg_close($conn);
  230. }
  231.  
  232. if (($id>0)&&($cat==0)&&($action=='')) {
  233. 	$uid=0;
  234.   if (isset($_SESSION['id'])) {
  235. 	$uid=$_SESSION['id'];
  236.   } else {
  237.   if ((trim($_COOKIE['Login'])!='')&&(trim($_COOKIE['Password'])!='')) {
  238. 	$login=htmlspecialchars(trim($_COOKIE['Login']),ENT_QUOTES);
  239. 	$pass=htmlspecialchars(trim($_COOKIE['Password']),ENT_QUOTES);
  240.   } else {
  241. 	$login=htmlspecialchars(trim($_GET['login']),ENT_QUOTES);
  242. 	$pass=htmlspecialchars(trim($_GET['pass']),ENT_QUOTES);
  243.   }
  244. 	$res=pg_query($conn, "select id from users where login='$login' and passwd='$pass' and moder=0;");
  245. 	if (pg_numrows($res)==1) $uid=pg_result($res,0,0);
  246. 	$_SESSION['id']=$uid;
  247.   }
  248. 	if ($uid) {
  249. 		pg_query($conn, "begin;");
  250. 		pg_query($conn, "update midi set dlcount=dlcount+1,dltotal=dltotal+1 where id='$id';");
  251. 		$dltime=time();
  252. 		pg_query($conn, "update users set lastact='$dltime' where id='$uid';");
  253. #		pg_query($conn, "insert into downloads (uid,midi,ip,agent,time) values ('$uid','$id','$addr','$agent','$dltime');");
  254. 		$res=pg_query($conn,"select path from midi where id='$id';");	
  255. 		pg_query($conn, "end;");
  256. #		if (($_COOKIE['Sweetty']!='21895')&&(!$chatok)) $access=0;
  257. 		if ($access) $getfile = sprintf("Location: http://katrinka.ru%s", pg_result($res,0,0));
  258. 		else $getfile = sprintf("Location: /sorry.wml");
  259. 		header($getfile);
  260. 	} else {
  261.   		header("Cache-Control: no-cache");
  262. 		header("Content-type: text/vnd.wap.wml");
  263. ?>
  264. <?xml version="1.0" encoding="utf-8"?>
  265. <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.2//EN" "http://www.wapforum.org/DTD/wml_1.2.dtd">
  266. <wml>
  267. <head><meta http-equiv="Cache-Control" content="no-cache" forua="true"/></head>
  268. <card id="Login" title="Login">
  269. <p align="center">
  270. Login: 
  271. <input type="text" name="login" title="Login" maxlength="15"/><br/>
  272. Password:
  273. <input type="password" name="pass" title="Password" maxlength="15"/><br/>
  274. <anchor title="Download">Download<go href="midi.php" method="get">
  275. <postfield name="login" value="$(login)"/>
  276. <postfield name="pass" value="$(pass)"/>
  277. <postfield name="nc" value="1"/>
  278. <?php print "<postfield name=\"lang\" value=\"".$_GET['lang']."\"/>\n";
  279. print "<postfield name=\"id\" value=\"".$id."\"/>\n";
  280. print "<postfield name=\"PHPSESSID\" value=\"".session_id()."\"/>\n"; ?>
  281. </go></anchor>
  282. </p>
  283. </card>
  284. </wml>
  285. <?php }
  286. 	pg_close($conn);
  287. } else {
  288. print "</p>\n";
  289. counters();
  290. print "</card>\n";
  291. print "</wml>\n";
  292. }
  293. ?>