API tools faq
paste
Guest User

Untitled

a guest
Oct 7th, 2013
211
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.07 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. function get_constants()
  3. {
  4. global $database;
  5. $q = "select * from constants";
  6. if (!$r = $database->query($q))
  7. exit('<h1>Constants Error</h1>');
  8. return mysql_fetch_assoc($r);
  9. }
  10. function initialize()
  11. {
  12. global $constants, $database;
  13. if (isset($_GET['lngg']))
  14. $lngg = $_GET['lngg'];
  15. elseif (isset($_SESSION['lngg']))
  16. $lngg = $_SESSION['lngg'];
  17. else
  18. $lngg = $constants['prefix'];
  19. if ($lngg == 'ar_' || $lngg == 'en_') {
  20. $_SESSION['lngg'] = $lngg;
  21. define('PRE', $lngg);
  22. } else
  23. exit('<h1>Invalid Language</h1>');
  24. $q = "select file,direction from language where prefix='" . PRE . "'";
  25. if (!$r = $database->query($q))
  26. exit('<h1>Error Select Language</h1>');
  27. require_once($constants['lnggpth'] . mysql_result($r, 0, 'file'));
  28. define('ALIGN', mysql_result($r, 0, 'direction'));
  29. if (!defined('DFRE756GHTH34VCSADFEW3SD4SD2'))
  30. exit();
  31. if (isset($_GET['stylid']))
  32. $stylid = $_GET['stylid'];
  33. elseif (isset($_SESSION['stylid']) && !empty($_SESSION['stylid']))
  34. $stylid = $_SESSION['stylid'];
  35. else {
  36. $q = "select stylid from style where current='y'";
  37. if (!$r = $database->query($q))
  38. exit('<h1>Error Select Style</h1>');
  39. $stylid = mysql_result($r, 0, 'stylid');
  40. }
  41. if (filter_digit($stylid))
  42. $_SESSION['stylid'] = $stylid;
  43. else
  44. exit('<h1>Invalid Style</h1>');
  45. date_default_timezone_set('Asia/Damascus');
  46. }
  47. function get_settings()
  48. {
  49. global $database;
  50. $q = "select * from " . PRE . "settings";
  51. if (!$r = $database->query($q))
  52. exit('<h1>Settings Error</h1>');
  53. $ar = mysql_fetch_assoc($r);
  54. return $ar;
  55. }
  56. function filter_digit($var)
  57. {
  58. return ctype_digit($var);
  59. }
  60. function filter_alpha($var)
  61. {
  62. return ctype_alpha($var);
  63. }
  64. function filter($var)
  65. {
  66. $var = trim(strip_tags($var, '<p><br>'));
  67. $var = str_ireplace("'", '', $var);
  68. $var = str_ireplace('"', '', $var);
  69. $var = str_ireplace('..', '', $var);
  70. $var = str_ireplace('+', '', $var);
  71. $var = str_ireplace('/', '', $var);
  72. $var = str_ireplace('%', '', $var);
  73. $var = str_ireplace('0x', '', $var);
  74. $var = str_ireplace(')', '', $var);
  75. $var = str_ireplace('(', '', $var);
  76. $var = str_ireplace('}', '', $var);
  77. $var = str_ireplace('{', '', $var);
  78. $var = str_ireplace('ini', '', $var);
  79. $var = str_ireplace('base64', '', $var);
  80. $var = str_ireplace('eval', '', $var);
  81. return $var;
  82. }
  83. function filter_text($var)
  84. {
  85. $var = str_ireplace('<script', '', $var);
  86. $var = str_ireplace('base64', '', $var);
  87. $var = str_ireplace('eval', '', $var);
  88. return $var;
  89. }
  90. function filter_stretch($var)
  91. {
  92. return str_ireplace('Ü', '', $var);
  93. }
  94. function escape($var)
  95. {
  96. return trim(htmlspecialchars($var));
  97. }
  98. function escape2($var)
  99. {
  100. return trim(addslashes($var));
  101. }
  102. function strip_new_line($text)
  103. {
  104. $text = str_ireplace('<p', ' <span', $text);
  105. $text = str_ireplace('<p>', ' <span>', $text);
  106. $text = str_ireplace('</p>', '</span>', $text);
  107. $text = str_ireplace('<br>', ' ', $text);
  108. $text = str_ireplace('<div', ' <span', $text);
  109. $text = str_ireplace('<div>', ' <span>', $text);
  110. $text = str_ireplace('</div>', '</span>', $text);
  111. $text = str_ireplace('<h1', ' <span', $text);
  112. $text = str_ireplace('<h1>', ' <span>', $text);
  113. $text = str_ireplace('</h1>', '</span>', $text);
  114. $text = str_ireplace('<h2', ' <span', $text);
  115. $text = str_ireplace('<h2>', ' <span>', $text);
  116. $text = str_ireplace('</h2>', '</span>', $text);
  117. $text = str_ireplace('<h3', ' <span', $text);
  118. $text = str_ireplace('<h3>', ' <span>', $text);
  119. $text = str_ireplace('</h3>', '</span>', $text);
  120. $text = str_ireplace('<h4', ' <span', $text);
  121. $text = str_ireplace('<h4', ' <span>', $text);
  122. $text = str_ireplace('</h4>', '</span>', $text);
  123. $text = str_ireplace('<h5', ' <span', $text);
  124. $text = str_ireplace('<h5>', ' <span>', $text);
  125. $text = str_ireplace('</h5>', '</span>', $text);
  126. $text = str_ireplace('<h6', ' <span', $text);
  127. $text = str_ireplace('<h6>', ' <span>', $text);
  128. $text = str_ireplace('</h6>', '</span>', $text);
  129. return $text;
  130. }
  131. function refill($var)
  132. {
  133. if (isset($_POST[$var]))
  134. return escape($_POST[$var]);
  135. if (isset($_GET[$var]))
  136. return escape($_GET[$var]);
  137. }
  138. function encodeurl($var)
  139. {
  140. return htmlentities(urlencode($var));
  141. }
  142. function filter_some_text($text)
  143. {
  144. $text = strip_new_line($text);
  145. $text = str_replace(chr(10), ' ', $text);
  146. $text = str_replace(chr(13), ' ', $text);
  147. return $text;
  148. }
  149. function get_script_time($styl = '$Y-$m-$d $H:$i:$s', $pls = 0)
  150. {
  151. global $constants;
  152. $ar = explode('#', $constants['dttm']);
  153. $timedate = time() + $pls;
  154. if (isset($ar[0]))
  155. $timedate += $ar[0] * 60;
  156. if (isset($ar[1]))
  157. $timedate += $ar[1] * 60 * 60;
  158. if (isset($ar[2]))
  159. $timedate += $ar[2] * 24 * 60 * 60;
  160. if (isset($ar[3]))
  161. $timedate += $ar[3] * 30 * 24 * 60 * 60;
  162. if (isset($ar[4]))
  163. $timedate += $ar[4] * 365 * 30 * 24 * 60 * 60;
  164. if ($styl == 'unix_timestamp')
  165. return $timedate;
  166. $Y = date('Y', $timedate);
  167. $m = date('m', $timedate);
  168. $d = date('d', $timedate);
  169. $H = date('H', $timedate);
  170. $i = date('i', $timedate);
  171. $s = date('s', $timedate);
  172. eval("\$styl=\"$styl\";");
  173. return $styl;
  174. }
  175. function go_link()
  176. {
  177. global $database, $language, $pg;
  178. if (!filter_digit($_GET['id']))
  179. return;
  180. if (!filter_alpha($_GET['kind']))
  181. return;
  182. switch ($_GET['kind']) {
  183. case 'advrtsmntlnk':
  184. $table = 'advertisement';
  185. $field = 'clicks';
  186. $id = 'advrid';
  187. break;
  188. case 'imprtntstlnk':
  189. $table = 'importantsite';
  190. $field = 'clicks';
  191. $id = 'imprtntid';
  192. break;
  193. case 'frndlystlnk':
  194. $table = 'friendlysite';
  195. $field = 'clicks';
  196. $id = 'frndstid';
  197. break;
  198. default:
  199. return;
  200. }
  201. $q = "update " . PRE . "$table set $field=($field+1) where $id=" . $_GET['id'];
  202. if (!$r = $database->query($q))
  203. return;
  204. if (!isset($_SESSION[$_GET['kind']][$_GET['id']]))
  205. return;
  206. $link = escape($_SESSION[$_GET['kind']][$_GET['id']]);
  207. $pg->letter($language['NOTICEREDIRECT'] . '<p><a href="http://' . $link . '">' . $link . '</a><script language="javascript" type="text/javascript">location.href="http://' . $link . '"</script>');
  208. }
  209. function alert($message)
  210. {
  211. echo '<script language="javascript" type="text/javascript">alert("' . $message . '");</script>';
  212. return false;
  213. }
  214. function is_banned()
  215. {
  216. global $database, $pg, $language;
  217. $q = "select 1 from " . PRE . "banned where ip='{$_SERVER['REMOTE_ADDR']}'";
  218. if (!$r = $database->query($q))
  219. return;
  220. if (!mysql_num_rows($r))
  221. return;
  222. echo '<h1 style="height:200px">' . $language['YOUAREBANNED'] . '</h1>';
  223. $pg->show('Footer2');
  224. exit;
  225. }
  226. function page_sound()
  227. {
  228. global $constants, $settings;
  229. if (empty($settings['sndfl']))
  230. return;
  231. $loop = $settings['sndfllp'];
  232. $src = $constants['cntntflpth'] . $settings['sndfl'];
  233. $extnsn = substr(strtolower(strrchr($settings['sndfl'], '.')), 1);
  234. if ($extnsn == 'rm' || $extnsn == 'ram')
  235. return '<object width=0 height=0 classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA"><param name="autostart" value="true" /><param name="loop" value="' . $loop . '" /><param name="src" value="' . $src . '" /><embed width=0 height=0 src="' . $src . '" autostart="true" loop="' . $loop . '" hidden="true" type="audio/x-pn-realaudio-plugin"></object>';
  236. return '<object width=0 height=0 classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95"><param name="autostart" value="true" /><param name="loop" value="' . $loop . '" /><param name="src" value="' . $src . '" /><embed width=0 height=0 src="' . $src . '" autostart="true" loop="' . $loop . '" hidden="true"></object>';
  237. }
  238. function online_now($sub = 0)
  239. {
  240. global $language, $settings, $pg, $database;
  241. $page = basename($_SERVER['PHP_SELF']);
  242. $q = "select count(ip) count,guest from " . PRE . "online" . ($sub ? " where file='$page'" : '') . " group by guest";
  243. if (!$r = $database->query($q))
  244. return;
  245. $guests = $users = 0;
  246. for (; $row = mysql_fetch_assoc($r);)
  247. $row['guest'] == 'y' ? $guests = $row['count'] : $users = $row['count'];
  248. $out = "<table cellpadding=1 celspacing=0><tr><td><span class=gray>{$language['USERS']} &nbsp;<span class=bold>$users</span>";
  249. $q = "select u.user,g.name,g.color from " . PRE . "online o," . PRE . "user u," . PRE . "usergroup g where o.guest='n' and o.userid=u.userid and g.grpid=u.grpid" . ($sub ? " and o.file='$page'" : '') . " order by g.name";
  250. if ($r = $database->query($q)) {
  251. $out .= "<div style='padding:5px 25px'>";
  252. while ($row = mysql_fetch_assoc($r))
  253. $out .= "<span style='color:{$row['color']}' title='{$row['name']}'>{$row['user']}</span> &nbsp; ";
  254. $out .= '</div>';
  255. } else
  256. $out .= '<br>';
  257. mysql_free_result($r);
  258. $out .= "{$language['VISITORS']} &nbsp;<span class=bold>$guests</span>";
  259. if ($settings['flgonln'] == 'y') {
  260. $q = "select ip from " . PRE . "online where guest='y'" . ($sub ? " and file='$page'" : '');
  261. if ($r = $database->query($q)) {
  262. $guestflags = array();
  263. while ($row = mysql_fetch_assoc($r)) {
  264. $ipnumber = sprintf("%u", ip2long($row['ip']));
  265. $q = "select code from ips where ipfrom<=$ipnumber and ipto>=$ipnumber";
  266. if ($rr = $database->query($q))
  267. if (mysql_num_rows($rr))
  268. $guestflags[] = mysql_result($rr, 0, 'code');
  269. }
  270. $guestflags = array_count_values($guestflags);
  271. $out .= "<div style='padding:5px 25px'>";
  272. foreach ($guestflags as $key => $val) {
  273. $q = "select * from countries where code='$key'";
  274. if ($r = $database->query($q))
  275. if (mysql_num_rows($r) > 0)
  276. $out .= "<span style='padding:2px' id=small>$val <img src='{$pg->flagspath}" . mysql_result($r, 0, 'code') . ".png' title='" . mysql_result($r, 0, 'cntry') . "'></span> ";
  277. }
  278. $out .= '</div>';
  279. }
  280. mysql_free_result($r);
  281. } else
  282. $out .= '<br>';
  283. $out .= "<img src='{$pg->imagespath}separator.gif'><br>{$language['ONLINETOTAL']}</span> &nbsp;<span class=bold>" . ($guests + $users) . "</span>";
  284. if (!$sub) {
  285. $out .= "<table cellpadding=1 cellspacing=0><tr><td colspan=2><img src='{$pg->imagespath}separator.gif'></td></tr><tr><td colspan=2>{$language['VISITORSCOUNT']} &nbsp;<span class=bold>{$settings['nmvstor']}</span></td></tr>";
  286. $q = "select count(*) from " . PRE . "user where state='y'";
  287. if ($r = $database->query($q))
  288. $out .= "<tr><td valign=top>{$language['COOUNT']} {$language['USERS']} &nbsp;<span class=bold>" . mysql_result($r, 0, 0) . '</span></td><td align=' . $pg->reverse . '><img src="' . $pg->generalpath . 'visitors.png"></td></tr>';
  289. $out .= '</table>';
  290. }
  291. $out .= '</td></tr></table>';
  292. return $out;
  293. }
  294. function show_countries($cntry = '', $name = 'cntry')
  295. {
  296. global $pg, $language, $database;
  297. if (empty($cntry))
  298. if (isset($_POST['cntry']))
  299. $cntry = escape($_POST['cntry']);
  300. else {
  301. $ipnumber = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
  302. $q = "select code from ips where ipfrom<=$ipnumber and ipto>=$ipnumber";
  303. if ($r = $database->query($q))
  304. if (mysql_num_rows($r))
  305. $cntry = mysql_result($r, 0, 'code');
  306. }
  307. $out = "<select name='$name' onchange=update_flag(this,'flagimage$name');><option value=''>---<option value='sa'" . ($cntry == 'sa' ? ' selected' : '') . ">{$language['CNTRY1']}<option value='kw'" . ($cntry == 'kw' ? ' selected' : '') . ">{$language['CNTRY2']}<option value='bh'" . ($cntry == 'bh' ? ' selected' : '') . ">{$language['CNTRY3']}<option value='qa'" . ($cntry == 'qa' ? ' selected' : '') . ">{$language['CNTRY4']}<option value='ae'" . ($cntry == 'ae' ? ' selected' : '') . ">{$language['CNTRY5']}<option value='om'" . ($cntry == 'om' ? ' selected' : '') . ">{$language['CNTRY6']}<option value='ye'" . ($cntry == 'ye' ? ' selected' : '') . ">{$language['CNTRY7']}<option value='sy'" . ($cntry == 'sy' ? ' selected' : '') . ">{$language['CNTRY8']}<option value='lb'" . ($cntry == 'lb' ? ' selected' : '') . ">{$language['CNTRY9']}<option value='jo'" . ($cntry == 'jo' ? ' selected' : '') . ">{$language['CNTRY10']}<option value='ps'" . ($cntry == 'ps' ? ' selected' : '') . ">{$language['CNTRY11']}<option value='iq'" . ($cntry == 'iq' ? ' selected' : '') . ">{$language['CNTRY12']}<option value='eg'" . ($cntry == 'eg' ? ' selected' : '') . ">{$language['CNTRY13']}<option value='sd'" . ($cntry == 'sd' ? ' selected' : '') . ">{$language['CNTRY14']}<option value='ly'" . ($cntry == 'ly' ? ' selected' : '') . ">{$language['CNTRY15']}<option value='tn'" . ($cntry == 'tn' ? ' selected' : '') . ">{$language['CNTRY16']}<option value='dz'" . ($cntry == 'dz' ? ' selected' : '') . ">{$language['CNTRY17']}<option value='ma'" . ($cntry == 'ma' ? ' selected' : '') . ">{$language['CNTRY18']}<option value='mr'" . ($cntry == 'mr' ? ' selected' : '') . ">{$language['CNTRY19']}<option value='km'" . ($cntry == 'km' ? ' selected' : '') . ">{$language['CNTRY20']}<option value='dj'" . ($cntry == 'dj' ? ' selected' : '') . ">{$language['CNTRY21']}<option value='so'" . ($cntry == 'so' ? ' selected' : '') . ">{$language['CNTRY22']}<option value='bla'" . ($cntry == 'bla' ? ' selected' : '') . ">{$language['CNTRY23']}</select> <img id='flagimage$name' src='{$pg->flagspath}" . ($cntry ? $cntry : 'bla') . ".png'>";
  308. return $out;
  309. }
  310. function show_countries_without_select($cntry = '')
  311. {
  312. global $pg, $language;
  313. $out = '';
  314. switch ($cntry) {
  315. case 'sa':
  316. $out = $language['CNTRY1'];
  317. break;
  318. case 'kw':
  319. $out = $language['CNTRY2'];
  320. break;
  321. case 'bh':
  322. $out = $language['CNTRY3'];
  323. break;
  324. case 'qa':
  325. $out = $language['CNTRY4'];
  326. break;
  327. case 'ae':
  328. $out = $language['CNTRY5'];
  329. break;
  330. case 'om':
  331. $out = $language['CNTRY6'];
  332. break;
  333. case 'ye':
  334. $out = $language['CNTRY7'];
  335. break;
  336. case 'sy':
  337. $out = $language['CNTRY8'];
  338. break;
  339. case 'lb':
  340. $out = $language['CNTRY9'];
  341. break;
  342. case 'jo':
  343. $out = $language['CNTRY10'];
  344. break;
  345. case 'ps':
  346. $out = $language['CNTRY11'];
  347. break;
  348. case 'iq':
  349. $out = $language['CNTRY12'];
  350. break;
  351. case 'eg':
  352. $out = $language['CNTRY13'];
  353. break;
  354. case 'sd':
  355. $out = $language['CNTRY14'];
  356. break;
  357. case 'ly':
  358. $out = $language['CNTRY15'];
  359. break;
  360. case 'tn':
  361. $out = $language['CNTRY16'];
  362. break;
  363. case 'dz':
  364. $out = $language['CNTRY17'];
  365. break;
  366. case 'ma':
  367. $out = $language['CNTRY18'];
  368. break;
  369. case 'mr':
  370. $out = $language['CNTRY19'];
  371. break;
  372. case 'km':
  373. $out = $language['CNTRY20'];
  374. break;
  375. case 'dj':
  376. $out = $language['CNTRY21'];
  377. break;
  378. case 'so':
  379. $out = $language['CNTRY22'];
  380. break;
  381. case 'bla':
  382. $out = $language['CNTRY23'];
  383. }
  384. ;
  385. $out .= " <img src='{$pg->url}{$pg->flagspath}" . ($cntry ? $cntry : 'bla') . ".png'>";
  386. return $out;
  387. }
  388. function send_email($subject, $from, $fromalias, $to, $letter, $error = '', $success = '', $headers = '', $mailer = DOMAIN, $priority = 3)
  389. {
  390. global $settings, $language, $pg;
  391. if (empty($error))
  392. $error = $language['ERRORSENDEMAIL'];
  393. if (empty($success))
  394. $success = $language['SUCCESSSENDEMAIL'];
  395. if ($_SESSION['lngg'] == 'ar_') {
  396. $subject = '=?windows-1256?B?' . base64_encode($subject) . '?=';
  397. $fromalias = '=?windows-1256?B?' . base64_encode($fromalias) . '?=';
  398. }
  399. if ($settings['emlknd'] == 'html') {
  400. $letter = $settings['preemail'] . $letter . '</body></html>';
  401. if (empty($headers))
  402. $headers = "MIME-Version: 1.0\r\n" . "Content-Type: text/html; charset=windows-1256\r\n" . "From: $fromalias <$from>\r\n" . "Reply-To: $from\r\n" . "To: $to\r\n" . "Return-Path: $from\r\n" . "X-Priority: $priority\r\n" . "X-Sender: Horizon Script\r\n" . "X-Mailer: $mailer PHP\r\n";
  403. if (!mail('', $subject, $letter, $headers))
  404. return $pg->letter($error, 'red');
  405. } else {
  406. $letter = str_ireplace('</tr>', "\n", $letter);
  407. $letter = str_replace('</td>', ' ', $letter);
  408. $letter = str_replace('<br>', "\n", $letter);
  409. $letter = strip_tags($letter);
  410. if (empty($headers))
  411. $headers = "From: $fromalias <$from>";
  412. if (!mail($to, $subject, $letter, $headers))
  413. return $pg->letter($error, 'red');
  414. }
  415. $pg->letter($success);
  416. return true;
  417. }
  418. function cookies()
  419. {
  420. global $user;
  421. if (isset($_POST['saveme']) && $_POST['saveme'] == 'on') {
  422. $usercookie = $user->filter_user();
  423. setcookie('hrzncks02', $usercookie, time() + 2592000, '', '.' . DOMAIN);
  424. }
  425. if (isset($_POST['votenow']))
  426. setcookie('hrzncks022', 'Ok', time() + 3600, '', '.' . DOMAIN);
  427. if (isset($_POST['addsgntr']))
  428. setcookie('hrzncks023', 'Ok', time() + 3600, '', '.' . DOMAIN);
  429. if (isset($_POST['rank']))
  430. setcookie('hrzncks024', 'Ok', time() + 3600, '', '.' . DOMAIN);
  431. }
  432. function tell_friend()
  433. {
  434. if (!isset($_GET['site']) || !isset($_GET['link']))
  435. return;
  436. $site = escape($_GET['site']);
  437. $link = escape($_GET['link']);
  438. $site = filter($site);
  439. $link = filter($link);
  440. $link = str_ireplace('http:', '', $link);
  441. return '<input type=hidden name=site value="' . $site . '"><input type=hidden name=link value="' . $link . '"><tr height=30><td></td><td>' . $site . '</td></tr>';
  442. }
  443. function send_to_friend()
  444. {
  445. global $settings, $language, $pg;
  446. $email = filter($_POST['email']);
  447. $letter = $settings['frndlttr'] . '<p>----------------------</p>' . escape2(nl2br($_POST['text'])) . $settings['sgntr'];
  448. eval("\$letter=\"$letter\";");
  449. send_email($language['EMAILFROMFRIEND'], $settings['email1'], $pg->sitename, $email, $letter);
  450. echo '<script language="javascript" type="text/javascript">setTimeout("close_portal_frame()",5000);</script>';
  451. }
  452. function prayer_now()
  453. {
  454. global $database, $pg, $language;
  455. $usercode = '';
  456. if (isset($_POST['pryrcntry']))
  457. $usercode = substr($_POST['pryrcntry'], 0, 3);
  458. else {
  459. $ipnumber = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
  460. $q = "select code from ips where ipfrom<=$ipnumber and ipto>=$ipnumber";
  461. if ($r = $database->query($q))
  462. if (mysql_num_rows($r))
  463. $usercode = mysql_result($r, 0, 'code');
  464. }
  465. $out = '<form action="' . $pg->pagename . '" method=post><table cellpadding=1 cellspacing=1><tr><td colspan=2>' . $language['COUNTRY'] . ' ' . show_countries($usercode, 'pryrcntry') . ' <input type=image name=pryr src="' . $pg->generalpath . 'view2.png" class=radio></td></tr><tr><tr><td colspan=2 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  466. switch ($usercode) {
  467. case 'sa':
  468. $out .= get_prayer('country=saudi_arabia&city=makkah&latitude=21.4200&longitude=39.8300&timezone=3&pmethod=4&dayLight=0', $language['MECCA']);
  469. $out .= get_prayer('country=saudi_arabia&city=madina&latitude=24.4527&longitude=39.6667&timezone=3&pmethod=4&dayLight=0', $language['MEDINA']);
  470. break;
  471. case 'kw':
  472. $out .= get_prayer('country=kuwait&city=kuwait00&latitude=29.3697&longitude=47.9783&timezone=3&pmethod=4&dayLight=0', $language['KUWAIT']);
  473. break;
  474. case 'bh':
  475. $out .= get_prayer('country=bahrain&city=manama02&latitude=26.2361&longitude=50.5831&timezone=3&pmethod=4&dayLight=0', $language['ALMANAMA']);
  476. break;
  477. case 'qa':
  478. $out .= get_prayer('country=qatar&city=doha01&latitude=25.2867&longitude=51.5333&timezone=3&pmethod=4&dayLight=0', $language['DOHA']);
  479. break;
  480. case 'ae':
  481. $out .= get_prayer('country=united_arab_emirates&city=dubai03&latitude=25.2522&longitude=55.2800&timezone=4&pmethod=4&dayLight=0', $language['DUBAI']);
  482. break;
  483. case 'om':
  484. $out .= get_prayer('country=oman&city=muscat&latitude=23.6133&longitude=58.5933&timezone=4&pmethod=4&dayLight=0', $language['MUSCAT']);
  485. break;
  486. case 'ye':
  487. $out .= get_prayer('country=yemen&city=sanaa16&latitude=15.3547&longitude=44.2067&timezone=3&pmethod=4&dayLight=0', $language['SANAA']);
  488. break;
  489. case 'sy':
  490. $out .= get_prayer('country=syria&city=damascus13&latitude=33.5000&longitude=36.3000&timezone=2&pmethod=4&dayLight=1', $language['DAMASCUS']);
  491. break;
  492. case 'lb':
  493. $out .= get_prayer('country=lebanon&city=beirut04&latitude=33.8719&longitude=35.5097&timezone=2&pmethod=1&dayLight=1', $language['BEIRUT']);
  494. break;
  495. case 'jo':
  496. $out .= get_prayer('country=jordan&city=amman11&latitude=31.9500&longitude=35.9333&timezone=2&pmethod=4&dayLight=1', $language['AMMAN']);
  497. break;
  498. case 'ps':
  499. $out .= get_prayer('country=palestine&city=jerusalem_region&latitude=31.7500&longitude=35.0000&timezone=2&pmethod=1&dayLight=1', $language['JERUSALEM']);
  500. break;
  501. case 'iq':
  502. $out .= get_prayer('country=iraq&city=baghdad07&latitude=33.3386&longitude=44.3939&timezone=3&pmethod=1&dayLight=0', $language['BAGHDAD']);
  503. break;
  504. case 'eg':
  505. $out .= get_prayer('country=egypt&city=cairo&latitude=30.0500&longitude=31.2500&timezone=2&pmethod=2&dayLight=0', $language['CAIRO']);
  506. break;
  507. case 'sd':
  508. $out .= get_prayer('country=sudan&city=khartoum29&latitude=15.5881&longitude=32.5342&timezone=3&pmethod=2&dayLight=0', $language['KHARTOUM']);
  509. break;
  510. case 'ly':
  511. $out .= get_prayer('country=libya&city=tripoli61&latitude=32.8925&longitude=13.1800&timezone=2&pmethod=2&dayLight=0', $language['TRIPOLI']);
  512. break;
  513. case 'tn':
  514. $out .= get_prayer('country=tunisia&city=tunis26&latitude=36.8028&longitude=10.1797&timezone=1&pmethod=1&dayLight=0', $language['TUNIS']);
  515. break;
  516. case 'dz':
  517. $out .= get_prayer('country=algeria&city=algiers01&latitude=36.7631&longitude=3.0506&timezone=1&pmethod=2&dayLight=0', $language['ALGIERS']);
  518. break;
  519. case 'ma':
  520. $out .= get_prayer('country=morocco&city=rabat24&latitude=34.0253&longitude=-6.8361&timezone=0&pmethod=1&dayLight=1', $language['RABAT']);
  521. break;
  522. case 'mr':
  523. $out .= get_prayer('country=mauritania&city=nouakchott&latitude=18.0864&longitude=-15.9753&timezone=0&pmethod=1&dayLight=0', $language['NOUAKCHOTT']);
  524. break;
  525. case 'so':
  526. $out .= get_prayer('country=somalia&city=mogadishu02&latitude=2.0667&longitude=45.3667&timezone=3&pmethod=1&dayLight=0', $language['MOGADISHU']);
  527. break;
  528. }
  529. ;
  530. $out .= '</table></form>';
  531. echo $out;
  532. }
  533. function get_prayer($url, $city)
  534. {
  535. global $language, $pg;
  536. $url = 'http://www.islamicfinder.org/prayer_service.php?simpleFormat=xml&dhuhrInterval=1&maghribInterval=1&ishaTwilight=10&ishaInterval=30&fajrTwilight1=10&fajrTwilight2=10&state=&zipcode=&HanfiShafi=1&' . $url;
  537. $content = file_get_contents($url);
  538. if (empty($content))
  539. return;
  540. $out = '<tr><td colspan=2 class=c id=green>' . $city . '</td></tr>';
  541. $start = strpos($content, '<hijri>') + 7;
  542. $end = strpos($content, '</hijri>', $start);
  543. $var = substr($content, $start, $end - $start);
  544. $out .= '<tr><td colspan=2 class=c id=gray>' . $var . '</td></tr>';
  545. $start = strpos($content, '<fajr>') + 6;
  546. $end = strpos($content, '</fajr>', $start);
  547. $var = substr($content, $start, $end - $start);
  548. $out .= '<tr><td width=65 id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['FAJR'] . '</td><td id=bold>' . $var . '</td></tr>';
  549. $start = strpos($content, '<sunrise>') + 9;
  550. $end = strpos($content, '</sunrise>', $start);
  551. $var = substr($content, $start, $end - $start);
  552. $out .= '<tr><td id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['SUNRISE'] . '</td><td id=bold>' . $var . '</td></tr>';
  553. $start = strpos($content, '<dhuhr>') + 7;
  554. $end = strpos($content, '</dhuhr>', $start);
  555. $var = substr($content, $start, $end - $start);
  556. $out .= '<tr><td id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['DHUHR'] . '</td><td id=bold>' . $var . '</td></tr>';
  557. $start = strpos($content, '<asr>') + 5;
  558. $end = strpos($content, '</asr>', $start);
  559. $var = substr($content, $start, $end - $start);
  560. $out .= '<tr><td id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['ASR'] . '</td><td id=bold>' . $var . '</td></tr>';
  561. $start = strpos($content, '<maghrib>') + 9;
  562. $end = strpos($content, '</maghrib>', $start);
  563. $var = substr($content, $start, $end - $start);
  564. $out .= '<tr><td id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['MAGHRIB'] . '</td><td id=bold>' . $var . '</td></tr>';
  565. $start = strpos($content, '<isha>') + 6;
  566. $end = strpos($content, '</isha>', $start);
  567. $var = substr($content, $start, $end - $start);
  568. $out .= '<tr><td id=gray><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['ISHA'] . '</td><td id=bold>' . $var . '</td></tr>';
  569. return $out;
  570. }
  571. function temperature_now()
  572. {
  573. global $database, $pg, $language;
  574. $usercode = '';
  575. if (isset($_POST['tmprtrcntry']))
  576. $usercode = substr($_POST['tmprtrcntry'], 0, 3);
  577. else {
  578. $ipnumber = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
  579. $q = "select code from ips where ipfrom<=$ipnumber and ipto>=$ipnumber";
  580. if ($r = $database->query($q))
  581. if (mysql_num_rows($r))
  582. $usercode = mysql_result($r, 0, 'code');
  583. }
  584. $out = '<form action="' . $pg->pagename . '" method=post><table cellpadding=1 cellspacing=1><tr><td>' . $language['COUNTRY'] . ' ' . show_countries($usercode, 'tmprtrcntry') . ' <input type=image name=tmprtr src="' . $pg->generalpath . 'view2.png" class=radio></td></tr><tr><tr><td class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  585. switch ($usercode) {
  586. case 'sa':
  587. $out .= get_temperature('SAXX0013', $language['MECCA']);
  588. $out .= get_temperature('SAXX0014', $language['MEDINA']);
  589. $out .= get_temperature('SAXX0017', $language['RIYADH']);
  590. break;
  591. case 'kw':
  592. $out .= get_temperature('KUXX0003', $language['KUWAIT']);
  593. break;
  594. case 'bh':
  595. $out .= get_temperature('BAXX0001', $language['ALMANAMA']);
  596. break;
  597. case 'qa':
  598. $out .= get_temperature('QAXX0003', $language['DOHA']);
  599. break;
  600. case 'ae':
  601. $out .= get_temperature('AEXX0004', $language['DUBAI']);
  602. break;
  603. case 'om':
  604. $out .= get_temperature('MUXX0003', $language['MUSCAT']);
  605. break;
  606. case 'ye':
  607. $out .= get_temperature('YMXX0005', $language['SANAA']);
  608. break;
  609. case 'sy':
  610. $out .= get_temperature('SYXX0004', $language['DAMASCUS']);
  611. break;
  612. case 'lb':
  613. $out .= get_temperature('LEXX0003', $language['BEIRUT']);
  614. break;
  615. case 'jo':
  616. $out .= get_temperature('JOXX0002', $language['AMMAN']);
  617. break;
  618. case 'ps':
  619. $out .= get_temperature('ISXX0010', $language['JERUSALEM']);
  620. break;
  621. case 'iq':
  622. $out .= get_temperature('IZXX0008', $language['BAGHDAD']);
  623. break;
  624. case 'eg':
  625. $out .= get_temperature('EGXX0004', $language['CAIRO']);
  626. break;
  627. case 'sd':
  628. $out .= get_temperature('SUXX0002', $language['KHARTOUM']);
  629. break;
  630. case 'ly':
  631. $out .= get_temperature('LYXX0009', $language['TRIPOLI']);
  632. break;
  633. case 'tn':
  634. $out .= get_temperature('TSXX0010', $language['TUNIS']);
  635. break;
  636. case 'dz':
  637. $out .= get_temperature('AGXX0001', $language['ALGIERS']);
  638. break;
  639. case 'ma':
  640. $out .= get_temperature('MOXX0007', $language['RABAT']);
  641. break;
  642. case 'mr':
  643. $out .= get_temperature('MRXX0004', $language['NOUAKCHOTT']);
  644. break;
  645. case 'so':
  646. $out .= get_temperature('SOXX0002', $language['MOGADISHU']);
  647. break;
  648. }
  649. ;
  650. $out .= '</table></form>';
  651. echo $out;
  652. }
  653. function get_temperature($url, $city)
  654. {
  655. global $language, $pg;
  656. $url = 'http://weather.yahooapis.com/forecastrss?u=c&p=' . $url;
  657. $content = file_get_contents($url);
  658. if (empty($content))
  659. return;
  660. $start = strpos($content, 'yweather:condition text="') + 26;
  661. $end = strpos($content, '"', $start);
  662. $cndtn = ($end > $start ? substr($content, $start, $end - $start) : '-');
  663. $start = strpos($content, 'code="') + 6;
  664. $end = strpos($content, '"', $start);
  665. $pctr = ($end > $start ? substr($content, $start, $end - $start) : 'blank');
  666. $out = '<tr><td class=c><img src="' . $pg->weatherpath . $pctr . '.gif" title="' . $cndtn . '"></td></tr>';
  667. $start = strpos($content, 'yweather:wind chill="') + 21;
  668. $end = strpos($content, '"', $start);
  669. $tmprtr = ($end > $start ? substr($content, $start, $end - $start) : '-');
  670. $out .= '<tr><td class=c>' . $city . ' : <span id=gray>' . $tmprtr . '</span> ' . $language['PERCENT'] . '</td></tr>';
  671. return $out;
  672. }
  673. function moderator_options()
  674. {
  675. global $language, $cntnt;
  676. $out = $language['CONTENTS'] . ' <select name=id>';
  677. $cntnt->set_all_contents();
  678. foreach ($cntnt->allcontents as $content)
  679. $out .= '<option value="' . $content['cntntid'] . '"' . ($content['state'] == 'n' ? ' id=red' : '') . '>' . $content['address'] . ($content['state'] == 'y' ? '' : ' | ' . $language['INACTIVATED']) . '</option>';
  680. $out .= '</select>';
  681. return $out;
  682. }
  683. function uploading()
  684. {
  685. global $language, $pg;
  686. return '<table cellpadding=4 cellspacing=2 height=100 id=uploadimage style="display:none"><tr><td class=c id=gray valign=bottom>' . $language['UPLOADING'] . '</td></tr><tr><td class=c><img src="' . $pg->generalpath . 'uploading.gif" name="uploadimage"></td></tr></table>';
  687. }
  688. function statistics()
  689. {
  690. global $database;
  691. $arr = array();
  692. $arr['content'] = '';
  693. $q = "select count(*) count,cc.name from " . PRE . "content c," . PRE . "category cc where c.ctgryid=cc.ctgryid and cc.state='y' and c.state='y' group by c.ctgryid";
  694. if (!$r = $database->query($q))
  695. return;
  696. while ($row = mysql_fetch_assoc($r))
  697. $arr['content'][] = $row;
  698. $q = "select count(*) from " . PRE . "contentreply where state='y'";
  699. if (!$r = $database->query($q))
  700. return;
  701. $arr['contentreply'] = mysql_result($r, 0, 0);
  702. $q = "select count(*) from " . PRE . "presentation where state='y'";
  703. if (!$r = $database->query($q))
  704. return;
  705. $arr['presentation'] = mysql_result($r, 0, 0);
  706. $q = "select count(*) from " . PRE . "guestbook where state='y'";
  707. if (!$r = $database->query($q))
  708. return;
  709. $arr['guestbook'] = mysql_result($r, 0, 0);
  710. $q = "select sum(download) from " . PRE . "content";
  711. if (!$r = $database->query($q))
  712. return;
  713. $arr['totaldownload'] = mysql_result($r, 0, 0) == null ? 0 : mysql_result($r, 0, 0);
  714. $q = "select sum(dwnldtdy) from " . PRE . "content where today='" . get_script_time('$Y-$m-$d') . "'";
  715. if (!$r = $database->query($q))
  716. return;
  717. $arr['todaydownload'] = mysql_result($r, 0, 0) == null ? 0 : mysql_result($r, 0, 0);
  718. $q = "select count(*) from maillist";
  719. if (!$r = $database->query($q))
  720. return;
  721. $arr['email'] = mysql_result($r, 0, 0);
  722. global $language, $pg;
  723. $out = '<table cellpadding=0 celspacing=0><tr><td colspan=2 align=' . $pg->reverse . '><img src="' . $pg->generalpath . 'statistics.png"></td></tr>';
  724. if (is_array($arr['content']))
  725. foreach ($arr['content'] as $content)
  726. $out .= '<tr><td id=gray>' . $content['name'] . '</td><td id=bold>' . $content['count'] . '</td></tr>';
  727. $out .= '<tr><td id=gray>' . $language['REPLIESCOUNT'] . '</td><td id=bold>' . $arr['contentreply'] . '</td></tr><tr><td id=gray>' . $language['PRESENTATIONCOUNT'] . '</td><td id=bold>' . $arr['presentation'] . '</td></tr><tr><td id=gray>' . $language['GUESTBOOKCOUNT'] . '</td><td id=bold>' . $arr['guestbook'] . '</td></tr><tr><td id=gray>' . $language['TOTALDOWNLOAD'] . '</td><td id=bold>' . $arr['totaldownload'] . '</td></tr><tr><td id=gray>' . $language['TODAYDOWNLOAD'] . '</td><td id=bold>' . $arr['todaydownload'] . '</td></tr><tr><td id=gray>' . $language['EMAILCOUNT'] . '</td><td id=bold>' . $arr['email'] . '</td></tr></table>';
  728. echo $out;
  729. }
  730. function map()
  731. {
  732. global $pg, $language, $database, $indxcntnt;
  733. echo '<div align=' . $pg->reverse . '><img src="' . $pg->generalpath . 'map.png"></div><table cellpadding=0 cellspacing=0><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['MAINLIST'] . '</td></tr><tr><td style="padding-' . $pg->align . ':15px">';
  734. foreach ($pg->links as $link)
  735. if ($link['prntlnk'] == 0)
  736. $pg->show_main_list1($link, -18, '', 2);
  737. echo '</td></tr><tr height=30><td><img src="' . $pg->imagespath . 'separator.gif"></td></tr><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['CONTENTS'] . '</td></tr><tr><td>';
  738. if (!$indxcntnt instanceof indexcontent)
  739. $indxcntnt = new indexcontent();
  740. $indxcntnt->categories = array();
  741. $indxcntnt->set_categories();
  742. foreach ($indxcntnt->categories as $ctgry)
  743. if (!$ctgry['prntctgry'])
  744. $indxcntnt->show_categories($ctgry, -18, '', 2);
  745. echo '</td></tr><tr height=30><td><img src="' . $pg->imagespath . 'separator.gif"></td></tr><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['USERLINKS'] . '</td></tr>';
  746. foreach ($pg->userlinks as $link)
  747. echo '<tr><td> &nbsp; &nbsp; <img src="' . $pg->imagespath . 'arrow2.gif"> <a href="' . $link['link'] . '">' . $link['address'] . '</a></td></tr>';
  748. echo '<tr><td> &nbsp; &nbsp; <img src="' . $pg->imagespath . 'arrow2.gif"> <a href="' . $_SERVER['REQUEST_URI'] . (strpos($_SERVER['REQUEST_URI'], '?') === false ? '?' : '&') . 'logout=">' . $language['EXITNOW'] . '</a></td></tr><tr height=30><td><img src="' . $pg->imagespath . 'separator.gif"></td></tr><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['VARIOUSLINKS'] . '</td></tr><tr><td> &nbsp; &nbsp;<img src="' . $pg->imagespath . 'arrow2.gif"> <a href="javascript:" onClick="open_portal_frame(\'tellfriend.php?link=' . $pg->url2 . '&site=' . $pg->sitename . '\',\'600\',\'450\',event)">' . $language['TELLFRIENDABOUTSITE'] . '</a></td></tr><tr><td> &nbsp; &nbsp;<img src="' . $pg->imagespath . 'arrow2.gif"> <a href="javascript:" onClick="if(navigator.appName==\'Microsoft Internet Explorer\') window.external.AddFavorite(\'' . $pg->url . '\',\'' . $pg->sitename . '\'); else window.sidebar.addPanel(\'' . $pg->sitename . '\',\'' . $pg->url . '\',\'\');">' . $language['ADDTOFAVORITES'] . '</a></td></tr><tr><td> &nbsp; &nbsp;<img src="' . $pg->imagespath . 'arrow2.gif"> <a href="javascript:" onClick="this.style.behavior=\'url(#default#homepage)\'; this.setHomePage(\'' . $pg->url . '\');">' . $language['MAKEUSHOMEPAGE'] . '</a></td></tr><tr height=30><td><img src="' . $pg->imagespath . 'separator.gif"></td></tr><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['STYLE'] . '</td></tr>';
  749. $q = "select * from style";
  750. if ($r = $database->query($q))
  751. if (mysql_num_rows($r))
  752. while ($styl = mysql_fetch_assoc($r))
  753. echo '<tr><td> &nbsp; &nbsp;<img src="' . $pg->imagespath . 'arrow2.gif"> <a href="index.php?stylid=' . $styl['stylid'] . '">' . escape($styl['name']) . '</a></td></tr>';
  754. echo '<tr height=30><td><img src="' . $pg->imagespath . 'separator.gif"></td></tr><tr height=30><td id=gray valign=top><img src="' . $pg->imagespath . 'arrow.gif"> ' . $language['LANGUAGE'] . '</td></tr>';
  755. $q = "select name,prefix from language";
  756. if ($r = $database->query($q))
  757. if (mysql_num_rows($r))
  758. while ($lngg = mysql_fetch_assoc($r))
  759. echo '<tr><td> &nbsp; &nbsp;<img src="' . $pg->imagespath . 'arrow2.gif"> <a href="index.php?lngg=' . $lngg['prefix'] . '">' . $lngg['name'] . '</a></td></tr>';
  760. echo '</table><br>';
  761. }
  762. function show_categories_for_search()
  763. {
  764. global $language, $pg;
  765. $cntnt = new content();
  766. $cntnt->set_categories();
  767. if (!is_array($cntnt->categories))
  768. return;
  769. $out = '<tr><td></td><td><select name=ctgryid><option value="">-- ' . $language['ALL'] . ' --';
  770. foreach ($cntnt->categories as $ctgry)
  771. if (!$ctgry['prntctgry'])
  772. $out .= $cntnt->show_tree_for_select($ctgry, '');
  773. $out .= '</select></td></tr>';
  774. return $out;
  775. }
  776. function search_results()
  777. {
  778. global $pg, $language, $database;
  779. $srch = isset($_POST['searchtext2']) ? filter($_POST['searchtext2']) : filter($_POST['searchtext']);
  780. $arrysrch = explode(' ', $srch);
  781. if (!is_array($arrysrch))
  782. return;
  783. $rltnshp = filter($_POST['relationship']);
  784. $var = $var2 = $var3 = $var4 = '';
  785. if ($rltnshp == 'or' || $rltnshp == 'and') {
  786. $rltnshp = ($rltnshp == 'or' ? '||' : '&&');
  787. foreach ($arrysrch as $srch) {
  788. $var .= "(c.address REGEXP '$srch' || c.text REGEXP '$srch' || g.name REGEXP '$srch' || u.user REGEXP '$srch' || c.guest REGEXP '$srch') $rltnshp ";
  789. $var2 .= "(name REGEXP '$srch' || text REGEXP '$srch') $rltnshp ";
  790. $var3 .= "(u.user REGEXP '$srch' || u.name REGEXP '$srch' || u.name2 REGEXP '$srch' || ug.name REGEXP '$srch') $rltnshp ";
  791. $var4 .= "(r.address REGEXP '$srch' || r.text REGEXP '$srch' || c.address REGEXP '$srch' || u.user REGEXP '$srch' || r.guest REGEXP '$srch') $rltnshp ";
  792. }
  793. $var = substr($var, 0, -4);
  794. $var = '(' . $var . ')';
  795. $var2 = substr($var2, 0, -4);
  796. $var2 = '(' . $var2 . ')';
  797. $var3 = substr($var3, 0, -4);
  798. $var3 = '(' . $var3 . ')';
  799. $var4 = substr($var4, 0, -4);
  800. $var4 = '(' . $var4 . ')';
  801. } else {
  802. $var = "(c.address REGEXP '$srch' || c.text REGEXP '$srch' || g.name REGEXP '$srch' || u.user REGEXP '$srch' || c.guest REGEXP '$srch')";
  803. $var2 = "(name REGEXP '$srch' || text REGEXP '$srch')";
  804. $var3 = "(u.user REGEXP '$srch' || u.name REGEXP '$srch' || u.name2 REGEXP '$srch' || ug.name REGEXP '$srch')";
  805. $var4 = "(r.address REGEXP '$srch' || r.text REGEXP '$srch' || c.address REGEXP '$srch' || u.user REGEXP '$srch' || r.guest REGEXP '$srch')";
  806. }
  807. if (filter_digit($_POST['ctgryid']))
  808. $var .= " && c.ctgryid=" . $_POST['ctgryid'];
  809. $nmbr = 0;
  810. $out = '';
  811. if (isset($_POST['contents'])) {
  812. $q = "select c.cntntid,c.address,c.text,c.guest,date_format(c.adddt,'%d/%m/%Y') adddt2,g.name,g.ctgryid,u.user from " . PRE . "content c left join " . PRE . "user u using(userid)," . PRE . "category g where c.ctgryid=g.ctgryid && $var" . (isset($_POST['day']) ? " && c.adddt between '{$_POST['year']}-{$_POST['month']}-{$_POST['day']} 00:00:00' and '{$_POST['year2']}-{$_POST['month2']}-{$_POST['day2']} 23:59:59'" : '') . " && c.state='y' and g.state='y' order by c.adddt desc";
  813. if ($r = $database->query($q))
  814. if (mysql_num_rows($r))
  815. while ($row = mysql_fetch_assoc($r)) {
  816. $nmbr++;
  817. $row['text'] = filter($row['text']);
  818. foreach ($arrysrch as $srch) {
  819. $row['address'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['address']);
  820. $row['name'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['name']);
  821. $row['user'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['user']);
  822. $row['guest'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['guest']);
  823. $row['text'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['text']);
  824. }
  825. $out .= '<tr><td width=3% rowspan=2 id=small valign=top>' . $nmbr . '.</td><td><img src="' . $pg->imagespath . 'arrow.gif"> <a href="content.php?id=' . $row['cntntid'] . '" target=_blank title="' . $language['SHOWWHOLE'] . '">' . $row['address'] . '</a></td><td align=' . $pg->reverse . '><img src="' . $pg->imagespath . 'arrow2.gif"> <a href="content.php?ctgryid=' . $row['ctgryid'] . '" target=_blank>' . $row['name'] . '</a></td></tr><tr><td colspan=2>' . substr($row['text'], 0, 400) . ' ... <a href="content.php?id=' . $row['cntntid'] . '" target=_blank title="' . $language['SHOWWHOLE'] . '" id=green>' . $language['MORE'] . '</a></td></tr><tr><td colspan=3 class=c id=gray>' . $language['ENTERDATE'] . ' <span id=small>' . $row['adddt2'] . '</span> &nbsp; ' . $language['OWNER'] . ' <span id=small>' . (empty($row['user']) ? $row['guest'] : $row['user']) . '</span></td></tr><tr><td colspan=3 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  826. }
  827. }
  828. if (isset($_POST['guestbook'])) {
  829. $q = "select gstid,name,text,cntry,date_format(adddt,'%d/%m/%Y') adddt2 from " . PRE . "guestbook where $var2" . (isset($_POST['day']) ? " && adddt between '{$_POST['year']}-{$_POST['month']}-{$_POST['day']} 00:00:00' and '{$_POST['year2']}-{$_POST['month2']}-{$_POST['day2']} 23:59:59'" : '') . " && state='y' order by adddt desc";
  830. if ($r = $database->query($q))
  831. if (mysql_num_rows($r))
  832. while ($row = mysql_fetch_assoc($r)) {
  833. $nmbr++;
  834. $row['text'] = filter($row['text']);
  835. foreach ($arrysrch as $srch) {
  836. $row['name'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['name']);
  837. $row['text'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['text']);
  838. }
  839. $out .= '<tr><td width=3% rowspan=2 id=small valign=top>' . $nmbr . '.</td><td><img src="' . $pg->imagespath . 'arrow.gif"> <a href="guestbook.php" target=_blank title="' . $language['SHOWWHOLE'] . '">' . $row['name'] . '</a></td><td align=' . $pg->reverse . '>' . show_countries_without_select($row['cntry']) . '</td></tr><tr><td colspan=2>' . substr($row['text'], 0, 400) . ' ... <a href="guestbook.php" target=_blank title="' . $language['SHOWWHOLE'] . '" id=green>' . $language['MORE'] . '</a></td></tr><tr><td colspan=3 class=c id=gray>' . $language['ENTERDATE'] . ' <span id=small>' . $row['adddt2'] . '</span></td></tr><tr><td colspan=3 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  840. }
  841. }
  842. if (isset($_POST['users'])) {
  843. $q = "select u.userid,u.user,u.name,u.name2,u.cntry,date_format(u.dtrgstr,'%d/%m/%Y') dtrgstr2,ug.name gname from " . PRE . "user u," . PRE . "usergroup ug where ug.grpid=u.grpid && $var3" . (isset($_POST['day']) ? " && dtrgstr between '{$_POST['year']}-{$_POST['month']}-{$_POST['day']} 00:00:00' and '{$_POST['year2']}-{$_POST['month2']}-{$_POST['day2']} 23:59:59'" : '') . " && u.state='y' order by u.dtrgstr desc";
  844. if ($r = $database->query($q))
  845. if (mysql_num_rows($r))
  846. while ($row = mysql_fetch_assoc($r)) {
  847. $nmbr++;
  848. foreach ($arrysrch as $srch) {
  849. $row['user'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['user']);
  850. $row['name'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['name']);
  851. $row['name2'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['name2']);
  852. $row['gname'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['gname']);
  853. }
  854. $out .= '<tr><td width=3% rowspan=2 id=small valign=top>' . $nmbr . '.</td><td><img src="' . $pg->imagespath . 'arrow.gif"> <a href="users.php" target=_blank title="' . $language['SHOWWHOLE'] . '">' . $row['user'] . '</a></td><td align=' . $pg->reverse . '><img src="' . $pg->imagespath . 'arrow2.gif"> <a href="users.php" target=_blank title="' . $language['SHOWWHOLE'] . '">' . $row['gname'] . '</a></td></tr><tr><td colspan=2>' . $row['name'] . ' ' . $row['name2'] . '</td></tr><tr><td colspan=3 class=c id=gray>' . $language['REGISTERDATE'] . ' <span id=small>' . $row['dtrgstr2'] . '</span> &nbsp; ' . $language['COUNTRY'] . ' <span id=small>' . show_countries_without_select($row['cntry']) . '</span></td></tr><tr><td colspan=3 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  855. }
  856. }
  857. if (isset($_POST['replies'])) {
  858. $q = "select r.cntntid,r.address,r.text,r.guest,date_format(r.adddt,'%d/%m/%Y') adddt2,c.address caddress,u.user from " . PRE . "contentreply r left join " . PRE . "user u using(userid)," . PRE . "content c where c.cntntid=r.cntntid && $var4" . (isset($_POST['day']) ? " && r.adddt between '{$_POST['year']}-{$_POST['month']}-{$_POST['day']} 00:00:00' and '{$_POST['year2']}-{$_POST['month2']}-{$_POST['day2']} 23:59:59'" : '') . " && r.state='y' and c.state='y' order by r.adddt desc";
  859. if ($r = $database->query($q))
  860. if (mysql_num_rows($r))
  861. while ($row = mysql_fetch_assoc($r)) {
  862. $nmbr++;
  863. $row['text'] = filter($row['text']);
  864. foreach ($arrysrch as $srch) {
  865. $row['address'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['address']);
  866. $row['caddress'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['caddress']);
  867. $row['user'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['user']);
  868. $row['guest'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['guest']);
  869. $row['text'] = str_ireplace($srch, '<span id=red>' . $srch . '</span>', $row['text']);
  870. }
  871. $out .= '<tr><td width=3% rowspan=2 id=small valign=top>' . $nmbr . '.</td><td><img src="' . $pg->imagespath . 'arrow.gif"> <a href="content.php?id=' . $row['cntntid'] . '" target=_blank title="' . $language['SHOWWHOLE'] . '">' . $row['address'] . '</a></td><td align=' . $pg->reverse . '><img src="' . $pg->imagespath . 'arrow2.gif"> <a href="content.php?id=' . $row['cntntid'] . '" target=_blank>' . $row['caddress'] . '</a></td></tr><tr><td colspan=2>' . substr($row['text'], 0, 400) . ' ... <a href="content.php?id=' . $row['cntntid'] . '" target=_blank title="' . $language['SHOWWHOLE'] . '" id=green>' . $language['MORE'] . '</a></td></tr><tr><td colspan=3 class=c id=gray>' . $language['ENTERDATE'] . ' <span id=small>' . $row['adddt2'] . '</span> &nbsp; ' . $language['OWNER'] . ' <span id=small>' . (empty($row['user']) ? $row['guest'] : $row['user']) . '</span></td></tr><tr><td colspan=3 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>';
  872. }
  873. }
  874. $out = '<table cellpadding=2 cellspacing=2><tr><td colspan=3 class=c id=blue>' . $language['SEARCHRESULTS'] . ' <span id=bold>' . $nmbr . '</span></td></tr><tr><td colspan=3 class=c><img src="' . $pg->imagespath . 'separator.gif"></td></tr>' . $out . '</table>';
  875. echo ($nmbr ? $out : '<center><p><span id=red>' . $language['DONTTHERESEARCHRESULTS'] . '</span></p><button id=button onClick="location.href=\'search.php\'">' . $language['RETURNTOSEARCH'] . '</button>');
  876. }
  877. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!