Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 6th, 2012  |  syntax: PHP  |  size: 19.37 KB  |  hits: 21  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <?php
  2. require 'base.php';
  3.  
  4.  
  5.  
  6. if (isset($_GET[ereig])) {
  7.                 if ($user->row[view_ereig] == '1') {
  8.         mysql_query("update ".USERS_TABLE." set view_ereig='0' where user_id='".$user->row[user_id]."'");
  9.                 } else {
  10.         mysql_query("update ".USERS_TABLE." set view_ereig='1' where user_id='".$user->row[user_id]."'");
  11. }
  12.  
  13. }
  14.  
  15.  
  16. if ($config['enable_bots'])
  17. {
  18.         $bots = $cache->get('bots');
  19. }
  20.  
  21. $online = array();
  22.  
  23. $res = $db->query('
  24.  
  25.  
  26.         SELECT handy_login,u.username, day,month,year,u.user_id, user_website,lastsekunden,icon,u.user_level, o.online_agent
  27.         FROM ' . ONLINE_TABLE . ' o
  28.                 LEFT JOIN ' . USERS_TABLE . ' u ON o.user_id > 0 AND u.user_id = o.user_id
  29.         WHERE o.online_lastvisit > ' . (time() - 300)
  30.  
  31. );
  32.  
  33.  
  34.  
  35.  
  36. while ($row = $db->fetch_array($res))
  37. {
  38.  
  39.  
  40.         if ($row['user_id'])
  41.         {
  42.  
  43.  
  44. if ($row['day'] != '' and $row['month'] != '' and $row['year'] != '')  {
  45.         $alz = 0;
  46.         $gebdt = $row['year'].$row['month'].$row['day'];
  47.         $now = date("Ymd", time());
  48. if ($gebdt > $now) {
  49.         print "";
  50. } else {
  51.         WHILE ($gebdt < $now - 9999) {
  52.         $alz++;
  53.         $gebdt = $gebdt + 10000;
  54. }
  55.         $alter = $alz;
  56. }} else {
  57.         $alter = '';
  58. }
  59.  
  60.  
  61.                 $online[strtolower($row['username'])] = array(
  62.                         'IS_BOT'        =>      false,
  63.                         'LEGEND'        =>      $user->legend($row['user_level']),
  64.                         'USERNAME'      =>      $row['username'],
  65.                         'ICON'          =>      $row['icon'],
  66.                         'HANDY'         =>      $row[handy_login],
  67.                         'LASTAKTION'    =>      $row[lastsekunden]+'150',
  68.                         'USERAGE'       =>      $alter,
  69.                         'STATUS'                =>      $row[user_level],
  70.                         'WEBSITE'               =>      $row['user_website'],
  71.                         'ID'            =>      $row['user_id']
  72.                 );
  73.         }
  74.         else if ($config['enable_bots'])
  75.         {
  76.                 foreach ($bots as $bot)
  77.                 {
  78.                         if (preg_match('/' . preg_quote($bot['bot_agent'], '/') . '/', $row['online_agent']))
  79.                         {
  80.                                 $online[strtolower($bot['bot_name'])] = array(
  81.                                         'IS_BOT'        =>      true,
  82.                                         'BOT_NAME'      =>      $bot['bot_name']
  83.                                 );
  84.  
  85.                                 break;
  86.                         }
  87.                 }
  88.         }
  89. }
  90.  
  91. $db->free_result($res);
  92.  
  93. ksort($online);
  94.  
  95. $s = '';
  96.  
  97. foreach ($online as $row)
  98. {
  99.         $row['SEPARATOR'] = $s;
  100.  
  101.         $tpl->block_assign('online', $row);
  102.  
  103.         $s = ', ';
  104. }
  105.  
  106.  
  107.  
  108.  
  109.  
  110.  
  111.  
  112. if ($_GET['limit'] == '') {
  113.         $limit = '10';
  114. } else if ($_GET['limit'] >= '50') {
  115.         $limit = '50';
  116. } else {
  117.         $limit = $_GET['limit'];
  118. }
  119.  
  120.  
  121. if ($user->row['user_id'] != '') {
  122.  
  123. if ($_GET['close'] != '') {
  124.         $ereig = mysql_fetch_array(mysql_query("select * from " . EREIG_TABLE . " where id='".$_GET[close]."'"));
  125. if ($ereig[an] == $user->row[user_id]) {
  126.         mysql_query("delete from ".EREIG_TABLE." where id='".$_GET[close]."'");
  127. }
  128. }
  129.  
  130.  
  131. if ($user->row['user_id'] != '' && isset($_GET[vote])) {
  132.         $um = mysql_fetch_array(mysql_query("select * from " . UMFRAGEN_TABLE . " where today='1'"));
  133.         $allowed = mysql_fetch_array(mysql_query("select * from " . UMFRAGE_VOTER_TABLE . " where umfrage_id='".$um[id]."' and user_id='".$user->row[user_id]."'"));
  134. if (!$allowed[id]) {
  135.  
  136.         $ants = explode("|", $um[antworten]);
  137.         $maxantwort = '0';
  138. foreach($ants as $key => $value) {
  139.         $maxantwort++;
  140. }
  141.  
  142. if ($_GET[vote] <= $maxantwort) {
  143.         $neu = '';
  144.         $ants2 = explode("|", $um[aktuvote]);
  145.         $aktuzahl = '0';
  146. foreach($ants2 as $key2 => $value2) {
  147.         $aktuzahl++;
  148. if ($aktuzahl == $_GET[vote]) {
  149.         $neu .= ($value2+1).'|';
  150. } else {
  151.         $neu .= $value2.'|';
  152. }
  153. }
  154. }
  155.  
  156.  
  157. mysql_query("update ".UMFRAGEN_TABLE." set aktuvote='".substr($neu, 0, -1)."', voter=voter+'1' where id='".$um[id]."'");
  158.  
  159. mysql_query("insert into " . UMFRAGE_VOTER_TABLE . " set umfrage_id='".$um[id]."', user_id='".$user->row[user_id]."'");
  160.  
  161. }}
  162.  
  163. if ($_POST['komment'] != '') {
  164.         $last = mysql_fetch_array(mysql_query("select * from " . SHOUTBOXKOMM_TABLE . " where user_id='".$user->row['user_id']."' and shout_id='".$_POST['shout_id']."' order by id desc limit 1"));
  165. if (($last[time]+'30') <= time()  || $last[time] == '')  {
  166.  
  167.         $shout = mysql_fetch_array(mysql_query("select * from " . SHOUTBOX_TABLE . " where id='".$_POST[shout_id]."'"));
  168. if ($shout[user_id] != $user->row[user_id]) {
  169.  
  170. if (strlen($_POST['komment']) > '20')  { $text = substr($_POST['komment'], 0, '20');   } else {
  171.         $text = $_POST[komment];
  172. }
  173.  
  174. mysql_query("insert into " . EREIG_TABLE . " set an='".$shout['user_id']."', user_id='".$user->row[user_id]."',text='<a href=\"index.php?read=".$_POST[shout_id]."\">Neuigkeiten kommentiert</a><br>".htmlspecialchars($text)."', time='".time()."'");
  175. }
  176.  
  177. mysql_query("insert into " . SHOUTBOXKOMM_TABLE . " set user_id='".$user->row['user_id']."', shout_id='".$_POST['shout_id']."',text='".$_POST['komment']."', time='".time()."'");
  178. }
  179. }
  180.  
  181. }
  182.  
  183. $nextlimit = $limit+'10';
  184. if ($user->row['user_id'] != '') {
  185.         if ($_POST[text] != '') {
  186.                 $last = mysql_fetch_array(mysql_query("select * from " . SHOUTBOX_TABLE . " where user_id='".$user->row['user_id']."' order by id desc limit 1"));
  187. if (($last[time]+'30') <= time()  || $last[time] == '') {
  188.         mysql_query("update " . USERS_TABLE . " set lasttext='".$_POST[text]."', lasttime='".time()."' where user_id='".$user->row['user_id']."'");
  189.         mysql_query("insert into " . SHOUTBOX_TABLE . " set user_id='".$user->row['user_id']."', text='".$_POST[text]."', time='".time()."'");
  190. }}
  191.  
  192.  
  193.         $mag = mysql_fetch_array(mysql_query("select * from " . SHOUTBOX_TABLE . " where id='".$_GET['like']."'"));
  194. if ($mag['id'] != '') {
  195.         $split = explode(",",$mag[likes]);
  196. foreach($split as $key => $value){
  197.         if ($value != '') {
  198.                 if ($value == $user->row['user_id']) {
  199.         $have = '1';
  200. }}}
  201.                         if ($mag['user_id'] != $user->row['user_id']) {
  202.                                 if ($have == '1') {
  203.  
  204.         $neu = str_replace($user->row['user_id'].",", "", $mag['likes']);
  205. mysql_query("update " . SHOUTBOX_TABLE . " set likes='".$neu."' where id = '".$mag['id']."'");
  206. mysql_query("update " . USERS_TABLE . " set user_likes=user_likes-'1',user_points=user_points-'1' where user_id='".$mag['user_id']."'");
  207. } else {
  208.  
  209.         $neu = $mag[likes].$user->row['user_id'].',';
  210. mysql_query("update " . SHOUTBOX_TABLE . " set likes='".$neu."' where id = '".$mag['id']."'");
  211. mysql_query("update " . USERS_TABLE . " set user_likes=user_likes+'1',user_points=user_points+'1' where user_id='".$mag['user_id']."'");
  212. }}}
  213.  
  214.  
  215.  
  216.  
  217.  
  218.  
  219.  
  220.  
  221. $mag2 = mysql_fetch_array(mysql_query("select * from " . SHOUTBOXKOMM_TABLE . " where id='".$_GET['kommlike']."'"));
  222. if ($mag2['id'] != '') {
  223. $split2 = explode(",",$mag2[likes]);
  224. foreach($split2 as $key => $value2){
  225. if ($value2 != '') {
  226. if ($value2 == $user->row['user_id']) {
  227. $have2 = '1';
  228. }}}
  229. if ($mag2['user_id'] != $user->row['user_id']) {
  230. if ($have2 == '1') {
  231.  
  232. $neu = str_replace($user->row['user_id'].",", "", $mag2['likes']);
  233. mysql_query("update " . SHOUTBOXKOMM_TABLE . " set likes='".$neu."' where id = '".$mag2['id']."'");
  234. mysql_query("update " . USERS_TABLE . " set user_likes=user_likes-'1',user_points=user_points-'1' where user_id='".$mag2['user_id']."'");
  235. } else {
  236.  
  237. $neu = $mag2[likes].$user->row['user_id'].',';
  238. mysql_query("update " . SHOUTBOXKOMM_TABLE . " set likes='".$neu."' where id = '".$mag2['id']."'");
  239. mysql_query("update " . USERS_TABLE . " set user_likes=user_likes+'1',user_points=user_points+'1' where user_id='".$mag2['user_id']."'");
  240. }}}
  241.  
  242.  
  243.  
  244. }
  245.  
  246.  
  247.  
  248.  
  249.  
  250.  
  251. if ($user->row['user_id'] != '') {
  252. if ($_GET['kommid'] != '') {
  253. $res = mysql_fetch_array(mysql_query("select * from " . SHOUTBOXKOMM_TABLE . " where id='".$_GET['kommid']."'"));
  254. if ($res['user_id'] == $user->row['user_id']) {
  255. mysql_query("delete from " . SHOUTBOXKOMM_TABLE . " where id = '".$_GET['kommid']."'");
  256. }
  257. }
  258. if ($_GET['shoutid'] != '') {
  259. $res = mysql_fetch_array(mysql_query("select * from " . SHOUTBOX_TABLE . " where id='".$_GET['shoutid']."'"));
  260. if ($res['user_id'] == $user->row['user_id'] || $user->row[user_level] == '2') {
  261. mysql_query("delete from " . SHOUTBOX_TABLE . " where id = '".$_GET['shoutid']."'");
  262. mysql_query("delete from " . SHOUTBOXKOMM_TABLE . " where shout_id='".$_GET['shoutid']."'");
  263. }
  264. }
  265. }
  266. if (isset($_GET[read])) {
  267. $res3 = $db->query("SELECT * FROM " . SHOUTBOX_TABLE . " where id='".$_GET[read]."'");
  268. } else {
  269. $res3 = $db->query("SELECT * FROM " . SHOUTBOX_TABLE . " order by id desc limit $limit");
  270. }
  271.  
  272. while ($row3 = $db->fetch_array($res3))
  273. {
  274.  
  275. $have = '0';
  276. $userlikes = '';
  277. $usera = mysql_fetch_array(mysql_query("select * from " . USERS_TABLE . " where user_id='".$row3['user_id']."'"));
  278. if ($row3['likes'] != '') {
  279. $anzahl = substr_count($row3[likes], ',');
  280.  
  281. $zahl = '0';
  282. $split = explode(",",$row3[likes]);
  283. foreach($split as $key => $value){
  284. if ($value != '') {
  285.  
  286. if ($value == $user->row['user_id']) {
  287. $have = '1';
  288. }
  289. $zahl++;
  290. if ($zahl != '1' && $anzahl != $zahl) {
  291. $userlikes .= ', ';
  292. }
  293. if ($anzahl == $zahl && $anzahl != '1') {
  294. $userlikes .= ' und ';
  295. }
  296. $member = mysql_fetch_array(mysql_query("select * from " . USERS_TABLE . " where user_id='".$value."'"));
  297. $userlikes .= '<a href="user.php?id='.$member['user_id'].'">'.$member['username'].'</a>';
  298. }}
  299. } else {
  300. $userlikes = '';
  301. }
  302.  
  303. $anzahl = substr_count($row3[likes], ',');
  304. if ($anzahl == '1') {
  305. $likey = 'mag';
  306. } else {
  307. $likey = 'm&ouml;gen';
  308. }
  309. $komments = '';
  310. $zahla = '0';
  311.  
  312.  
  313. $alle = mysql_fetch_assoc(mysql_query("select count(id) as lol from " . SHOUTBOXKOMM_TABLE . " where shout_id='".$row3['id']."'"));
  314. $start = $alle[lol]-2;
  315.  
  316. if ($start < '0') {
  317. $start = '0';
  318. }
  319. if ($start >= '1') {
  320.  
  321. $komments .= '<div id="max'.$row3[id].'" style="display:none">';
  322. $kigl = mysql_query("select * from " . SHOUTBOXKOMM_TABLE . " where shout_id='".$row3['id']."' order by time limit 0,$start");
  323. while($komm = mysql_fetch_array($kigl))
  324. {
  325. $zahla++;
  326. $usa = mysql_fetch_array(mysql_query("SELECT * FROM " . USERS_TABLE . " where user_id = '".$komm['user_id']."'"));
  327. if ($usa['user_avatar'] == '') {
  328. $avatar = $config['default_avatar'];
  329. } else {
  330. $avatar = $usa['user_avatar'];
  331. }
  332.  
  333. if ($komm['user_id'] == $user->row['user_id'] || $user->row[user_level] == '2') {
  334. if ($_GET[read]) {
  335. $del = '| <a href="index.php?read='.$_GET[read].'&kommid='.$komm[id].'">L&ouml;schen</a>';
  336. } else {
  337. $del = '| <a href="index.php?limit='.$_GET[limit].'&kommid='.$komm[id].'">L&ouml;schen</a>';
  338. }
  339. } else {
  340. $del = '';
  341. }
  342.  
  343. $komments .= '<div class="commentText"><div id="comments_16123"><div>
  344.  
  345. <table cellpadding="0"><tr><td valign="top" width="40"><a onmouseover="userBox(event, this)" href="user.php?id='.$usa[user_id].'"><img src="images/avatar/mini/'.$avatar.'" height="32" width="32"></a></td><td><a onmouseover="userBox(event, this)" href="user.php?id='.$usa[user_id].'">'.$usa[username].'</a>: '.replace2($komm[text],1,0,1).'<br><small><span>'.date("d.m.Y", $komm[time]).' '.date("H:i:s", $komm[time]).' Uhr - ';
  346. $have2 = '0';
  347. $split2 = explode(",",$komm[likes]);
  348. foreach($split2 as $key => $value2){
  349. if ($value2 != '') {
  350. if ($value2 == $user->row['user_id']) {
  351. $have2 = '1';
  352. }
  353. }}
  354. if ($have2 == '0') {
  355.  
  356. if ($_GET[read]) {
  357. $komments .= '<a href="?read='.$_GET[read].'&kommlike='.$komm[id].'">Mag ich</a> ';
  358. } else {
  359. $komments .= '<a href="?limit='.$_GET[limit].'&kommlike='.$komm[id].'">Mag ich</a> ';
  360.  }
  361. } else {
  362. if ($_GET[read]) {
  363. $komments .= '<a href="?read='.$_GET[read].'&kommlike='.$komm[id].'">Mag ich nicht</a> ';
  364. } else {
  365. $komments .= '<a href="?limit='.$_GET[limit].'&kommlike='.$komm[id].'">Mag ich nicht</a> ';
  366.  }
  367. }
  368.  
  369.  
  370. $likezahl  = substr_count($komm[likes], ',');
  371. if ($likezahl >= '1') {
  372. $komments .= '- <a onclick="userlikeshow(\''.$komm[id].'\');" href="javascript:void(0)">'.$likezahl.' '; if ($likezahl != '1') { $komments .= 'Mitglieder'; } else { $komments .= 'Mitglied'; } $komments .= '</a> <span>'; if ($likezahl != '1') { $komments .= 'm&ouml;gen'; } else { $komments .= 'mag'; } $komments .= ' das</span> ';
  373. }
  374. $komments .= $del.'</span></small></td></tr></table>
  375.  
  376. </div></div><div class="input" id="input_16123"></div></div>';
  377.  
  378. }
  379.  
  380.  
  381. $komments .= '</div>
  382. </div>';
  383.  
  384. $komments .= '<div id="min'.$row3[id].'"><div class="commentText"><div id="comments_16123"><div>
  385.  
  386. <a href="javascript:void(0)" onclick="change(\'min'.$row3[id].'\',\'max'.$row3[id].'\')">'.$start.' weitere Kommentare</a>
  387.  
  388. </div></div><div class="input" id="input_16123"></div></div></div>';
  389. }
  390.  
  391.  
  392.  
  393.  
  394.  
  395.  
  396.  
  397.  
  398.  
  399. $kigl = mysql_query("select * from " . SHOUTBOXKOMM_TABLE . " where shout_id='".$row3['id']."' order by time limit $start,2");
  400. while($komm = mysql_fetch_array($kigl))
  401. {
  402. $zahla++;
  403. $usa = mysql_fetch_array(mysql_query("SELECT * FROM " . USERS_TABLE . " where user_id = '".$komm['user_id']."'"));
  404. if ($usa['user_avatar'] == '') {
  405. $avatar = $config['default_avatar'];
  406. } else {
  407. $avatar = $usa['user_avatar'];
  408. }
  409.  
  410.  
  411. if ($komm['user_id'] == $user->row['user_id'] || $user->row[user_level] == '2') {
  412.  
  413. if ($_GET[read]) {
  414. $del = '| <a href="index.php?read='.$_GET[read].'&kommid='.$komm[id].'">L&ouml;schen</a>';
  415. } else {
  416. $del = '| <a href="index.php?limit='.$_GET[limit].'&kommid='.$komm[id].'">L&ouml;schen</a>';
  417.  }
  418. } else {
  419. $del = '';
  420. }
  421. $komments .= '<div class="commentText"><div id="comments_16123"><div>
  422.  
  423. <table cellpadding="0"><tr><td valign="top" width="40"><a onmouseover="userBox(event, this)" href="user.php?id='.$usa[user_id].'"><img src="images/avatar/mini/'.$avatar.'" height="32" width="32"></a></td><td><a onmouseover="userBox(event, this)" href="user.php?id='.$usa[user_id].'">'.$usa[username].'</a>: <br> '.replace2($komm[text],1,0,1).'<br><small><span>'.date("d.m.Y", $komm[time]).' '.date("H:i:s", $komm[time]).' Uhr - ';
  424.  
  425. $have2 = '0';
  426. $split2 = explode(",",$komm[likes]);
  427. foreach($split2 as $key => $value2){
  428. if ($value2 != '') {
  429. if ($value2 == $user->row['user_id']) {
  430. $have2 = '1';
  431. }
  432. }}
  433. if ($have2 == '0') {
  434.  
  435. if ($_GET[read]) {
  436. $komments .= '<a href="?read='.$_GET[read].'&kommlike='.$komm[id].'">Mag ich</a> ';
  437. } else {
  438. $komments .= '<a href="?limit='.$_GET[limit].'&kommlike='.$komm[id].'">Mag ich</a> ';
  439.  }
  440. } else {
  441. if ($_GET[read]) {
  442. $komments .= '<a href="?read='.$_GET[read].'&kommlike='.$komm[id].'">Mag ich nicht</a> ';
  443. } else {
  444. $komments .= '<a href="?limit='.$_GET[limit].'&kommlike='.$komm[id].'">Mag ich nicht</a> ';
  445.  }
  446. }
  447.  
  448. $likezahl  = substr_count($komm[likes], ',');
  449. if ($likezahl >= '1') {
  450. $komments .= '- <a onclick="userlikeshow(\''.$komm[id].'\');" href="javascript:void(0)">'.$likezahl.' '; if ($likezahl != '1') { $komments .= 'Mitglieder'; } else { $komments .= 'Mitglied'; } $komments .= '</a> <span>'; if ($likezahl != '1') { $komments .= 'm&ouml;gen'; } else { $komments .= 'mag'; } $komments .= ' das</span> ';
  451. }
  452. $komments .= $del.'</span></small></td></tr></table>
  453.  
  454. </div></div><div class="input" id="input_16123"></div></div>';
  455.  
  456. }
  457. if ($zahla == '0') {
  458. $komment = '';
  459. } else {
  460. $komment = $komments;
  461. }
  462.  
  463.  
  464.  
  465.                 $fansu = array_merge($row3, array(
  466.                         'USERNAME'              =>      $usera['username'],
  467.                         'ID'                    =>      $row3[id],
  468.                         'USER_ID'                       =>      $row3['user_id'],
  469.                         'AVATAR'                        =>      ($usera['user_avatar']) ? $usera['user_avatar'] : $config['default_avatar'],
  470.                         'TEXT'                  =>      replace2($row3['text'],1,0,1),
  471.                         'KOMMENT'               =>      $komment,
  472.                         'LIKES_USERNAME'                =>      $userlikes,
  473.                         'HAVE'                  =>      $have,
  474.                         'LIKES'                 =>      $likey,
  475.                         'DATUM'                 =>      date("d.m.Y", $row3[time]),
  476.                         'UHRZEIT'                       =>      date("H:i:s", $row3[time])
  477.                 ));
  478.        
  479.  
  480.         $tpl->block_assign('shoutbox', $fansu);
  481. }
  482.  
  483. $db->free_result($res3);
  484.  
  485.  
  486.  
  487. $bdays = '0';
  488. $aktumonat = date("m", time());
  489. $aktutag = date("d", time());
  490. $aktutag2 = $aktutag+'3';
  491. $aktutag3 = $aktutag-'3';
  492. if (strlen($aktutag2) == '1') {
  493. $aktutag2 = '0'.$aktutag2;
  494. }
  495. if (strlen($aktutag3) == '1') {
  496. $aktutag3 = '0'.$aktutag3;
  497. }
  498.  
  499. $res9 = $db->query("SELECT * FROM " . USERS_TABLE . " where month = '".$aktumonat."' and day >= '".$aktutag3."' and day <= '".$aktutag2."' order by day desc");
  500.  
  501. while ($row4 = $db->fetch_array($res9))
  502. {
  503.  
  504. $bdays++;
  505. if ($row4['day'] != '' and $row4['month'] != '' and $row4['year'] != '')  {
  506. $alz = 0;
  507. $gebdt = $row4['year'].$row4['month'].$row4['day'];
  508. $now = date("Ymd", time());
  509. if ($gebdt > $now) {
  510. print "";
  511. } else {
  512. WHILE ($gebdt < $now - 9999) {
  513. $alz++;
  514. $gebdt = $gebdt + 10000;
  515. }
  516. $deinalter = $alz;
  517. }
  518.  
  519.  
  520. $alter = $deinalter;
  521. } else {
  522. $alter = '';
  523. }
  524.  
  525. if ($row4[day] == ($aktutag+'3')) {
  526. $tage = 'In 3 Tagen';
  527. } else if ($row4[day] == ($aktutag+'2')) {
  528. $tage = 'In 2 Tagen';
  529. } else if ($row4[day] == ($aktutag+'1')) {
  530. $tage = 'Morgen';
  531. } else if ($row4[day] == $aktutag) {
  532. $tage = 'Heute';
  533. } else if ($row4[day] == ($aktutag-'1')) {
  534. $tage = 'Gestern';
  535. } else if ($row4[day] == ($aktutag-'2')) {
  536. $tage = 'Vor 2 Tagen';
  537. } else if ($row4[day] == ($aktutag-'3')) {
  538. $tage = 'Vor 3 Tagen';
  539. }
  540.  
  541.  
  542.  
  543.                 $fansu = array_merge($row4, array(
  544.                         'USERNAME'              =>      $row4['username'],
  545.                         'USERID'                        =>      $row4[user_id],        
  546.                         'USERAGE'               =>      $alter,
  547.                         'TAGE'                  =>      $tage
  548.  
  549.                 ));
  550.        
  551.  
  552.         $tpl->block_assign('bday', $fansu);
  553. }
  554.  
  555. $db->free_result($res9);
  556.  
  557.  
  558.  
  559.  
  560.  
  561.  
  562. $events = '0';
  563.  
  564. $res99 = $db->query("SELECT * FROM " . EVENTS_TABLE . "");
  565. while ($row4 = $db->fetch_array($res99))
  566. {
  567.  
  568.  
  569.  
  570. $vor3 = date("d.m.Y", (time()-259200));
  571. $vor2 = date("d.m.Y", (time()-172800));
  572. $vor1 = date("d.m.Y", (time()-86400));
  573. $today = date("d.m.Y");
  574. $nach1 = date("d.m.Y", (time()+86400));
  575. $nach2 = date("d.m.Y", (time()+172800));
  576. $nach3 = date("d.m.Y", (time()+259200));
  577.  
  578.  
  579. if ($row4[time] == $nach3) {
  580. $tage = 'In 3 Tagen';
  581. } else if ($row4[time] == $nach2) {
  582. $tage = 'In 2 Tagen';
  583. } else if ($row4[time] == $nach1) {
  584. $tage = 'Morgen';
  585. } else if ($row4[time] == $today) {
  586. $tage = 'Heute';
  587. } else if ($row4[time] == $vor1) {
  588. $tage = 'Gestern';
  589. } else if ($row4[time] == $vor2) {
  590. $tage = 'Vor 2 Tagen';
  591. } else if ($row4[time] == $vor3) {
  592. $tage = 'Vor 3 Tagen';
  593. } else {
  594. $tage = '';
  595. }
  596.  
  597. if ($tage != '') {
  598. $events++;
  599. }
  600.                 $fansu = array_merge($row4, array(
  601.                         'NAME'          =>      $row4['title'],
  602.                         'ID'                    =>      $row4[id],             
  603.                         'TAGE'                  =>      $tage
  604.  
  605.                 ));
  606.        
  607.  
  608.         $tpl->block_assign('event', $fansu);
  609. }
  610.  
  611. $db->free_result($res99);
  612.  
  613.  
  614.  
  615. $news = mysql_fetch_array(mysql_query("SELECT * FROM " . NEWS_TABLE . " order by id desc limit 1"));
  616. $comment = mysql_fetch_assoc(mysql_query("select count(id) as lol from " . NEWSKOMM_TABLE . " where news_id='".$news['id']."'"));
  617.  
  618.  
  619. $ereig = mysql_fetch_assoc(mysql_query("select count(id) as lol from " . EREIG_TABLE . " where an='".$user->row['user_id']."'"));
  620.  
  621.  
  622.  
  623. $resi = $db->query("SELECT * FROM " . EREIG_TABLE . " where an = '".$user->row[user_id]."' order by time desc limit 3");
  624.  
  625. while ($row3 = $db->fetch_array($resi))
  626. {
  627.  
  628. $eruser= mysql_fetch_array(mysql_query("select * from " . USERS_TABLE . " where user_id='".$row3['user_id']."'"));
  629.  
  630.                 $fansu = array_merge($row3, array(
  631.                         'USERNAME'              =>      $eruser['username'],
  632.                         'ID'                    =>      $row3[id],
  633.                         'USER_ID'                       =>      $eruser[user_id],              
  634.                         'AVATAR'                        =>      ($eruser['user_avatar']) ? $eruser['user_avatar'] : $config['default_avatar'],
  635.                         'TIME'                  =>      date("d.m.y H:i:s", $row3[time]),
  636.                         'TEXT'                  =>      $row3[text]
  637.  
  638.                 ));
  639.        
  640.        
  641.  
  642.         $tpl->block_assign('ereig', $fansu);
  643. }
  644.  
  645. $db->free_result($resi);
  646.  
  647.  
  648.  
  649. $tpl->assign(array(
  650.         'TITLE_TAG'     =>      'Startseite | ',
  651.         'USERNAME'      =>      $user->row['username'],
  652.         'USER_POINTS'   =>      number_format($user->row['user_points'], 0, '', '.'),
  653.         'USER_LIKES'    =>      number_format($user->row['user_likes'], 0, '', '.'),
  654.         'USER_POSTS'    =>      number_format($user->row['user_posts'], 0, '', '.'),
  655.         'NEWS_ID'       =>      $news['id'],
  656.         'LIMIT'         =>      $nextlimit,
  657.         'KALENDER'      =>      $kalender,
  658.         'AKTULIMIT'     =>      $limit,
  659.         'EREIG_ANZAHL'  =>      $ereig[lol],
  660.         'AKTUTIME'      =>      time(),
  661.         'READ'          =>      $_GET[read],
  662.         'BDAYZAHL'      =>      $bdays,
  663.         'EVENTZAHL'     =>      $events,
  664.         'NEWS_TITLE'    =>      $news['news_title'],
  665.         'NEWS_DATE'     =>      date("d.m.Y",$news['news_time']),
  666.         'VIEW_EREIG'    =>      $user->row[view_ereig],
  667.         'NEWS_COMMENTS' =>      $comment[lol],
  668.         'TITLE_TAG_HEADER'      =>      'Startseite',
  669.         'USER_AVATAR'   =>      ($user->row['user_avatar']) ? $user->row['user_avatar'] : $config['default_avatar'],
  670.         'USER_LEGEND'   =>      $user->legend($user->row['user_level'])
  671. ));
  672.  
  673. $tpl->display('index.tpl');
  674.  
  675. ?>
create a new version of this paste RAW Paste Data