Hellooo
Gib es ein Modul bzw. eine möglichkeit das die Awards auch im Porfil und im Forum Post ( Unter dem Rank ) angezeigt werden können?
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
$awards = ''; $sql = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = $uid ORDER BY `time` DESC"); while($row = db_fetch_assoc($sql)) { $awards .= '<div align="center">'.(!empty($row['bild']) ? '<img src="'.$row['bild'].'" alt="'.$row['wofur'].'" title="'.$row['wofur'].'"/>' : $row['wofur']).'<br /><font class="smalfont">'.$row['time'].'</font></div>'; } $awards = '<div style="float:left; margin: 0px 2px;">'.$awards.'</div>';
#Award Ausgabe $awards = ''; $ax = 0; $sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$row['erstid']." ORDER BY `time` ASC"); while($rowA = db_fetch_assoc($sqlA)) { $ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;} $awards .= (!empty($rowA['bild']) ? '<img style="padding:1px;border:0px;" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']); } $row['awards'] = '<b>Auszeichnungen<b><br><div style="text-align:center;">'.$awards.'</div>';
#Award Ausgabe $awards = ''; $ax = 0; $sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$uid." ORDER BY `time` ASC"); while($rowA = db_fetch_assoc($sqlA)) { $ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;} $awards .= (!empty($rowA['bild']) ? '<img style="padding:1px;border:0px;" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']); } $awards = '<b>Auszeichnungen<b><br><div style="text-align:center;">'.$awards.'</div>';
'AWARDS' => $awards,
{EXPLODE} <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <center> <th colspan="2"><center>Die Awards von {NAME} </center></b></th></tr><tr> </tr></table> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <th colspan="2">{AWARDS}</b></th> </table> <br />
MySQL Error: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `time` ASC' at line 1 in Query: SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `ic1_awards` a INNER JOIN ic1_user b ON a.team = b.name WHERE b.id = ORDER BY `time` ASC Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ show_posts.php:139 -- db_query(...) @ forum.php:130 -- require_once(...) @ index.php:36 -- require_once(...) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/htdocs/w00cd1ed/include/includes/func/db/mysql.php on line 58
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de defined ('main') or die ( 'no direct access' ); # check ob ein fehler aufgetreten ist. check_forum_failure($forum_failure); # toipc als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); $title = $allgAr['title'].' :: Forum :: '.$aktTopicRow['name'].' :: Beiträge zeigen'; $hmenu = $extented_forum_menu.'<a class="smalfont" href="index.php?forum">Forum</a><b> » </b>'.aktForumCats($aktForumRow['kat']).'<b> » </b><a class="smalfont" href="index.php?forum-showtopics-'.$fid.'">'.$aktForumRow['name'].'</a><b> » </b>'; $hmenu .= $aktTopicRow['name'].$extented_forum_menu_sufix; $design = new design ( $title , $hmenu, 1); $design->header(); # Topic Hits werden eins hochgesetzt. db_query('UPDATE `prefix_topics` SET hit = hit + 1 WHERE id = "'.$tid.'"'); $erg = db_query("SELECT fid FROM `prefix_posts` WHERE tid = ".$tid); $row = db_fetch_assoc($erg); $newth = '<a href="index.php?forum-newtopic-'.$row['fid'].'"><img src="include/images/forum/newth.png" border="0"></a>'; # mehrere seiten fals gefordert $limit = $allgAr['Fpanz']; // Limit $page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 ); $MPL = db_make_sites ($page , "WHERE tid = ".$tid , $limit , 'index.php?forum-showposts-'.$tid , 'posts' ); $anfang = ($page - 1) * $limit; $antworten = ''; if (($aktTopicRow['stat'] == 1 AND $forum_rights['reply'] == TRUE) OR ($_SESSION['authright'] <= '-7' OR $forum_rights['mods'] == TRUE)) { $antworten = '<a href="index.php?forum-newpost-'.$tid.'"><img src="include/images/forum/antw.png" border="0"></a>'; } $class = 'Cmite'; $tpl = new tpl ( 'forum/showpost' ); $ar = array ( 'SITELINK' => $MPL, 'tid' => $tid, 'ANTWORTEN' => $antworten, 'TOPICNAME' => $aktTopicRow['name'], 'HMENU' => $hmenu, 'NEWTH' => $newth ); $tpl->set_ar_out($ar,0); $i = $anfang +1; $ges_ar = array ('wurstegal', 'maennlich', 'weiblich'); ################################## #Forenmod by www.irvd-website.de - Vorlage von Benjamin Rau & matthias-schlich.de #Posts $erg = db_query("SELECT geschlecht, prefix_posts.id,txt,time,erstid,erst,sig,icq,avatar,posts FROM `prefix_posts` LEFT JOIN prefix_user ON prefix_posts.erstid = prefix_user.id WHERE tid = ".$tid." ORDER BY time LIMIT ".$anfang.",".$limit); while($row = db_fetch_assoc($erg)) { $class = ( $class == 'Cnorm' ? 'Cmite' : 'Cnorm' ); $icq1 = str_replace("-","",$row['icq']); $icq2 = str_replace(" ","",$icq1); // icq abfrage // 0 - keine ICQ abfrage // 1 - ICQ standartbilder bei &design= kann man zwischen den 26 verschiedenen icq bildern wechseln // 2 - für eigne ICQ Statsubilder $own_pics = "1"; $icqdesign = "25"; if ($own_pics == "1") { if (is_numeric($icq2) ){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?web='.$icq2.'&img='.$icqdesign.'" border="0"></a>'; } else {$row['icq'] = '';} } elseif ($own_pics == "0"){ $row['icq'] = '';} else{ if (is_numeric($icq2) ){ // Eigene ICQ-Bilder $status = (icq_status($icq2)); if ($status == "1"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqonline.png" border="0"></a>'; }elseif ($status == "0"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqoffline.png" border="0"></a>'; }elseif ($status == "2"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqinactive.png" border="0"></a>'; }else {$row['icq'] = '';} }else {$row['icq'] = '';} } # define some vars. $row['sig'] = ( empty($row['sig']) ? '' : '<br /><hr style="width: 80%;" align="left">'.bbcode($row['sig']) ); $row['TID'] = $tid; $row['class'] = $class; $row['date'] = date ('d.M.Y - H:i:s', $row['time'] ); $row['delete'] = ''; $row['change'] = ''; $row['erst'] = forum_farbname($row['erst']); if (file_exists($row['avatar'])) { $row['avatar'] = '<br /><img src="'.$row['avatar'].'" alt="User Pic" border="0" width="100" height="100" /><br />'; } elseif ($allgAr['forum_default_avatar']) { $row['avatar'] = '<br /><img src="include/images/avatars/'.$ges_ar[$row['geschlecht']].'.jpg" alt="User Pic" border="0" /><br />'; } else { $row['avatar'] = ''; } $row['rang2'] = userrang ($row['posts'],$row['erstid']); $rank_name = $row['rang2']; $row['txt'] = (isset($_GET['such']) ? markword(bbcode ($row['txt']),$_GET['such']) : bbcode ($row['txt']) ); $row['i'] = $i; if ( $row['erstid'] != '' ) { $user_row = db_fetch_assoc(db_query("SELECT posts,regist FROM prefix_user WHERE id = ".$row['erstid'])); $posts = $row['posts']; $row['posts'] = '<font style="font-weight:bold">Beiträge:</font> '.$row['posts'].'<br />'; if ( $posts == '' ) { $row['posts'] = '<br>Nicht registriert';} #Ranking Balken #Grafiken definieren #Grafiken definieren $rank_0 = '<img src="include/images/forum/rank/rank00.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>20</b> Posts</span><br>'; $rank_1 = '<img src="include/images/forum/rank/rank01.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>40</b> Posts</span><br>'; $rank_2 = '<img src="include/images/forum/rank/rank02.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>60</b> Posts</span><br>'; $rank_3 = '<img src="include/images/forum/rank/rank03.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>80</b> Posts</span><br>'; $rank_4 = '<img src="include/images/forum/rank/rank0.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>100</b> Posts</span><br>'; $rank_5 = '<img src="include/images/forum/rank/rank05.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>120</b> Posts</span><br>'; $rank_6 = '<img src="include/images/forum/rank/rank06.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>140</b> Posts</span><br>'; $rank_7 = '<img src="include/images/forum/rank/rank07.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>160</b> Posts</span><br>'; $rank_8 = '<img src="include/images/forum/rank/rank08.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>180</b> Posts</span><br>'; $rank_9 = '<img src="include/images/forum/rank/rank09.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>200</b> Posts</span><br>'; $rank_10 = '<img src="include/images/forum/rank/complete.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>220</b> Posts</span><br>'; $rank_11 = '<img src="include/images/forum/rank/11.png" alt="" border="0"><br>'; $rank_12 = '<img src="include/images/forum/rank/12.png" alt="" border="0"><br>'; $rank_13 = '<img src="include/images/forum/rank/13.png" alt="" border="0"><br>'; $rank_14 = '<img src="include/images/forum/rank/14.png" alt="" border="0"><br>'; $rank_15 = '<img src="include/images/forum/rank/15.png" alt="" border="0"><br>'; $rank_16 = '<img src="include/images/forum/rank/16.png" alt="" border="0"><br>'; $rank_17 = '<img src="include/images/forum/rank/17.png" alt="" border="0"><br>'; $rank_18 = '<img src="include/images/forum/rank/18.png" alt="" border="0"><br>'; $rank_19 = '<img src="include/images/forum/rank/19.png" alt="" border="0"><br>'; $rank_20 = '<img src="include/images/forum/rank/20.png" alt="" border="0"><br>'; $rank_21 = '<img src="include/images/forum/rank/21.png" alt="" border="0"><br>'; $rank_22 = '<img src="include/images/forum/rank/22.png" alt="" border="0"><br>'; $rank_23 = '<img src="include/images/forum/rank/23.png" alt="" border="0"><br>'; $rank_24 = '<img src="include/images/forum/rank/24.png" alt="" border="0"><br>'; $rank_25 = '<img src="include/images/forum/rank/25.png" alt="" border="0"><br>'; $rank_26 = '<img src="include/images/forum/rank/26.png" alt="" border="0"><br>'; $rank_27 = '<img src="include/images/forum/rank/27.png" alt="" border="0"><br>'; $rank_28 = '<img src="include/images/forum/rank/28.png" alt="" border="0"><br>'; $rank_29 = '<img src="include/images/forum/rank/29.png" alt="" border="0"><br>'; $rank_30 = '<img src="include/images/forum/rank/30.png" alt="" border="0"><br>'; $rank_31 = '<img src="include/images/forum/rank/31.png" alt="" border="0"><br>'; $rank_32 = '<img src="include/images/forum/rank/32.png" alt="" border="0"><br>'; $rank_33 = '<img src="include/images/forum/rank/33.png" alt="" border="0"><br>'; $rank_34 = '<img src="include/images/forum/rank/34.png" alt="" border="0"><br>'; $rank_35 = '<img src="include/images/forum/rank/35.png" alt="" border="0"><br>'; $rank_36 = '<img src="include/images/forum/rank/36.png" alt="" border="0"><br>'; $rank_37 = '<img src="include/images/forum/rank/37.png" alt="" border="0"><br>'; $rank_38 = '<img src="include/images/forum/rank/38.png" alt="" border="0"><br>'; #Bezugnehmen auf das Ranking des users if ( $row['posts'] != '' ) { $row['rang'] = $rank_name.'<br>'; if ($posts <= '4') { $row['rang'] .= $rank_0; } elseif ($posts <= '20') { $row['rang'] .= $rank_1;} elseif ($posts <= '40') { $row['rang'] .= $rank_2; } elseif ($posts <= '60') { $row['rang'] .= $rank_3; } elseif ($posts <= '80') { $row['rang'] .= $rank_4; } elseif ($posts <= '100') { $row['rang'] .= $rank_5; } elseif ($posts <= '120') { $row['rang'] .= $rank_6; } elseif ($posts <= '140') { $row['rang'] .= $rank_7; } elseif ($posts <= '160') { $row['rang'] .= $rank_8; } elseif ($posts <= '180') { $row['rang'] .= $rank_9; } elseif ($posts <= '200') { $row['rang'] .= $rank_10; } elseif ($posts <= '210') { $row['rang'] .= $rank_11; } elseif ($posts <= '220') { $row['rang'] .= $rank_12; } elseif ($posts <= '240') { $row['rang'] .= $rank_13; } elseif ($posts <= '260') { $row['rang'] .= $rank_14; } elseif ($posts <= '280') { $row['rang'] .= $rank_15; } elseif ($posts <= '300') { $row['rang'] .= $rank_16; } elseif ($posts <= '320') { $row['rang'] .= $rank_17; } elseif ($posts <= '340') { $row['rang'] .= $rank_18; } elseif ($posts <= '360') { $row['rang'] .= $rank_19; } elseif ($posts <= '380') { $row['rang'] .= $rank_20; } elseif ($posts <= '400') { $row['rang'] .= $rank_21; } elseif ($posts <= '420') { $row['rang'] .= $rank_22; } elseif ($posts <= '440') { $row['rang'] .= $rank_23; } elseif ($posts <= '460') { $row['rang'] .= $rank_24; } elseif ($posts <= '480') { $row['rang'] .= $rank_25; } elseif ($posts <= '500') { $row['rang'] .= $rank_26; } elseif ($posts <= '520') { $row['rang'] .= $rank_27; } elseif ($posts <= '540') { $row['rang'] .= $rank_28; } elseif ($posts <= '560') { $row['rang'] .= $rank_29; } elseif ($posts <= '580') { $row['rang'] .= $rank_30; } elseif ($posts <= '600') { $row['rang'] .= $rank_31; } elseif ($posts <= '620') { $row['rang'] .= $rank_32; } elseif ($posts <= '640') { $row['rang'] .= $rank_33; } elseif ($posts <= '660') { $row['rang'] .= $rank_34; } elseif ($posts <= '680') { $row['rang'] .= $rank_35; } elseif ($posts <= '700') { $row['rang'] .= $rank_36; } elseif ($posts < '720') { $row['rang'] .= $rank_37; } elseif ($posts >= '740') { $row['rang'] .= $rank_38; } } else {$row['rang'] .= ""; } } #User Details if ( $posts != '' ) { $abf1 = 'SELECT * FROM prefix_user where id = '.$row["erstid"]; $erg1 = db_query($abf1); $user = db_fetch_object($erg1); $zeit = date('d. M Y',$user->regist); $llogin = date('d. M Y',$user->llogin); $ort = $user->wohnort; $www = $user->homepage; $email = $user->opt_mail; $pm = $user->opt_pm; $land = $user->staat; #Flagge if ($land != '') {$row['land'] = '<img src="include/images/flags/'.$land.'" >';} else{$row['land'] = '';} #Dabei seit $row['details'] = "<font style=\"font-weight:bold; color:#A67303\">Dabei seit:</font> ".$zeit."<br>"; #Wohnort if ($ort != ''){$row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Wohnort:</font> ".$ort."<br>";} #Homepage if ($www != ''){$row['www'] = '<a href="'.$www.'" target="_blank"><img src="include/images/forum/www.png" border="0" alt="Website des Users besuchen"></a>';} else{$row['www'] = '';} #Letzter Login $row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Letzter Login:</font> ".$llogin."<br>"; #PM if ($pm == '1'){ $row['pm'] = "<a href='?forum-privmsg-new=0&empfid=".$row['erstid']."'><img src='include/images/forum/pm.png' border='0' alt='Private Nachricht an den User senden'></a>"; }else{$row['pm'] = '';} #email if ($email == '1'){ $row['email'] = "<a href='?user-mail-".$row['erstid']."'><img src='include/images/forum/email.png' border='0' alt='E-Mail an den User senden'></a>"; }else{$row['email'] = '';} } else { $row['details'] = ""; $row['land'] = ''; $row['pm'] = ''; $row['email'] = ''; $row['www'] = ''; } if ( $posts != '' ) { #User Online o Offline $abf1 = "SELECT * FROM prefix_online where uid = ".$row['erstid']; $erg1 = db_query($abf1); $status = db_fetch_object($erg1); if ($status->uid == $row['erstid']) { $row['online'] = ' <img src="include/images/forum/uonline.png" border="0">'; } else { $row['online'] = ' <img src="include/images/forum/uoffline.png" border="0">'; } } else {$row['online'] = '';} # #Edit Ende ################################## $row['page'] = $page; if ( $row['posts'] != 0 ) { $row['erst'] = '<a href="index.php?user-details-'.$row['erstid'].'"><b>'.forum_farbname($row['erst']).'</b></a>'; } elseif ( $row['erstid'] == 0 ) { $row['rang'] = 'gelöschter User'; } if ($forum_rights['mods'] == TRUE AND $i>1) { $row['delete'] = '<a class="forum" href="index.php?forum-delpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/delete.png" width="16" height="16" alt="delete" align="absmiddle" title="löschen"/> löschen</a>'; } if ( $forum_rights['reply'] == TRUE AND loggedin() ) { $row['change'] = ' <a class="forum" href="index.php?forum-editpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/change.png" width="16" height="16" alt="change" align="absmiddle" title="ändern"/> ändern</a>'; } $row['posts'] = ($row['posts']?'<br />'.$row['posts']:'').'<br />'; $tpl->set_ar_out($row,1); $i++; } $tpl->set_ar_out( array ( 'SITELINK' => $MPL, 'ANTWORTEN' => $antworten ) , 2 ); // anfang qpost if (loggedin()) { $dppk_time = time(); $time = time(); if (!isset($_SESSION['klicktime'])) { $_SESSION['klicktime'] = 0; } $topic = ''; $txt = ''; $xnn = ''; if (isset($_POST['txt_qp'])) { $txt = trim(escape($_POST['txt_qp'], 'textarea')); } $tpl = new tpl ('forum/qpost'); $ar = array ( 'txt_qp' => escape_for_fields(unescape($txt)), 'tid' => $tid, ); $tpl->set_ar_out($ar,1); if (($_SESSION['klicktime'] + 150) > $dppk_time OR empty($txt) OR !empty($_POST['priview']) OR (empty($_POST['Gname']) AND !loggedin())) { } else { # save qpost $_SESSION['klicktime'] = $dppk_time; $design = new design ( $title , $hmenu, 1); $design->header(); if (loggedin()) { $uid = $_SESSION['authid']; $erst = escape($_SESSION['authname'],'string'); db_query("UPDATE `prefix_user` set posts = posts+1 WHERE id = ".$uid); } else { $erst = $xnn; $uid = 0; } db_query ("INSERT INTO `prefix_posts` (tid,fid,erst,erstid,time,txt) VALUES ( ".$tid.", ".$fid.", '".$erst."', ".$uid.", ".$time.", '".$txt."')"); $pid = db_last_id(); db_query("UPDATE `prefix_topics` SET last_post_id = ".$pid.", rep = rep + 1 WHERE id = ".$tid); db_query("UPDATE `prefix_forums` SET posts = posts + 1, last_post_id = ".$pid." WHERE id = ".$fid ); $page = ceil ( ($aktTopicRow['rep']+1) / $allgAr['Fpanz'] ); # topic als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); wd ( array ( $lang['backtotopic'] => 'index.php?forum-showposts-'.$tid.'-p'.$page.'#'.$pid, $lang['backtotopicoverview'] => 'index.php?forum-showtopics-'.$fid ) , $lang['createpostsuccessful'] , 3 ); } } $tpl = new tpl ( 'forum/showpost' ); // end qpost if (loggedin()) { if ($menu->get(3) == 'topicalert') { if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { db_query("DELETE FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid); } else { db_query("INSERT INTO prefix_topic_alerts (tid,uid) VALUES (".$tid.", ".$_SESSION['authid'].")"); } } echo 'Optionen:'; if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['nomailonreply'].'</a><br />'; } else { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['mailonreply'].'</a><br />'; } } if ( $forum_rights['mods'] == TRUE ) { $tpl->set ( 'status', ($aktTopicRow['stat'] == 1 ? $lang['close'] : $lang['open'] ) ); $tpl->set ( 'festnorm', ($aktTopicRow['art'] == 0 ? $lang['fixedtopic'] : $lang['normaltopic'] ) ); $tpl->set('tid',$tid); $tpl->out(3); } $design->footer(); ?>
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de defined ('main') or die ( 'no direct access' ); # check ob ein fehler aufgetreten ist. check_forum_failure($forum_failure); # toipc als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); $title = $allgAr['title'].' :: Forum :: '.$aktTopicRow['name'].' :: Beiträge zeigen'; $hmenu = $extented_forum_menu.'<a class="smalfont" href="index.php?forum">Forum</a><b> » </b>'.aktForumCats($aktForumRow['kat']).'<b> » </b><a class="smalfont" href="index.php?forum-showtopics-'.$fid.'">'.$aktForumRow['name'].'</a><b> » </b>'; $hmenu .= $aktTopicRow['name'].$extented_forum_menu_sufix; $design = new design ( $title , $hmenu, 1); $design->header(); # Topic Hits werden eins hochgesetzt. db_query('UPDATE `prefix_topics` SET hit = hit + 1 WHERE id = "'.$tid.'"'); $erg = db_query("SELECT fid FROM `prefix_posts` WHERE tid = ".$tid); $row = db_fetch_assoc($erg); $newth = '<a href="index.php?forum-newtopic-'.$row['fid'].'"><img src="include/images/forum/newth.png" border="0"></a>'; # mehrere seiten fals gefordert $limit = $allgAr['Fpanz']; // Limit $page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 ); $MPL = db_make_sites ($page , "WHERE tid = ".$tid , $limit , 'index.php?forum-showposts-'.$tid , 'posts' ); $anfang = ($page - 1) * $limit; $antworten = ''; if (($aktTopicRow['stat'] == 1 AND $forum_rights['reply'] == TRUE) OR ($_SESSION['authright'] <= '-7' OR $forum_rights['mods'] == TRUE)) { $antworten = '<a href="index.php?forum-newpost-'.$tid.'"><img src="include/images/forum/antw.png" border="0"></a>'; } $class = 'Cmite'; $tpl = new tpl ( 'forum/showpost' ); $ar = array ( 'SITELINK' => $MPL, 'tid' => $tid, 'ANTWORTEN' => $antworten, 'TOPICNAME' => $aktTopicRow['name'], 'HMENU' => $hmenu, 'NEWTH' => $newth ); $tpl->set_ar_out($ar,0); $i = $anfang +1; $ges_ar = array ('wurstegal', 'maennlich', 'weiblich'); ################################## #Forenmod by www.irvd-website.de - Vorlage von Benjamin Rau & matthias-schlich.de #Posts $erg = db_query("SELECT geschlecht, prefix_posts.id,txt,time,erstid,erst,sig,icq,avatar,posts FROM `prefix_posts` LEFT JOIN prefix_user ON prefix_posts.erstid = prefix_user.id WHERE tid = ".$tid." ORDER BY time LIMIT ".$anfang.",".$limit); while($row = db_fetch_assoc($erg)) { $class = ( $class == 'Cnorm' ? 'Cmite' : 'Cnorm' ); $icq1 = str_replace("-","",$row['icq']); $icq2 = str_replace(" ","",$icq1); // icq abfrage // 0 - keine ICQ abfrage // 1 - ICQ standartbilder bei &design= kann man zwischen den 26 verschiedenen icq bildern wechseln // 2 - für eigne ICQ Statsubilder $own_pics = "1"; $icqdesign = "25"; if ($own_pics == "1") { if (is_numeric($icq2) ){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?web='.$icq2.'&img='.$icqdesign.'" border="0"></a>'; } else {$row['icq'] = '';} } elseif ($own_pics == "0"){ $row['icq'] = '';} else{ if (is_numeric($icq2) ){ // Eigene ICQ-Bilder $status = (icq_status($icq2)); if ($status == "1"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqonline.png" border="0"></a>'; }elseif ($status == "0"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqoffline.png" border="0"></a>'; }elseif ($status == "2"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqinactive.png" border="0"></a>'; }else {$row['icq'] = '';} }else {$row['icq'] = '';} } #Award Ausgabe $awards = ''; $ax = 0; $sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$row['erstid']." ORDER BY `time` ASC"); while($rowA = db_fetch_assoc($sqlA)) { $ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;} $awards .= (!empty($rowA['bild']) ? '<img style="padding:2px;border:0px;"width="10%" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']); } $row['awards'] = '<b>Auszeichnungen<b><br><div style="text-align:center;">'.$awards.'</div>'; # define some vars. $row['sig'] = ( empty($row['sig']) ? '' : '<br /><hr style="width: 80%;" align="left">'.bbcode($row['sig']) ); $row['TID'] = $tid; $row['class'] = $class; $row['date'] = date ('d.M.Y - H:i:s', $row['time'] ); $row['delete'] = ''; $row['change'] = ''; $row['erst'] = forum_farbname($row['erst']); if (file_exists($row['avatar'])) { $row['avatar'] = '<br /><img src="'.$row['avatar'].'" alt="User Pic" border="0" width="100" height="100" /><br />'; } elseif ($allgAr['forum_default_avatar']) { $row['avatar'] = '<br /><img src="include/images/avatars/'.$ges_ar[$row['geschlecht']].'.jpg" alt="User Pic" border="0" /><br />'; } else { $row['avatar'] = ''; } $row['rang2'] = userrang ($row['posts'],$row['erstid']); $rank_name = $row['rang2']; $row['txt'] = (isset($_GET['such']) ? markword(bbcode ($row['txt']),$_GET['such']) : bbcode ($row['txt']) ); $row['i'] = $i; if ( $row['erstid'] != '' ) { $user_row = db_fetch_assoc(db_query("SELECT posts,regist FROM prefix_user WHERE id = ".$row['erstid'])); $posts = $row['posts']; $row['posts'] = '<font style="font-weight:bold">Beiträge:</font> '.$row['posts'].'<br />'; if ( $posts == '' ) { $row['posts'] = '<br>Nicht registriert';} #Ranking Balken #Grafiken definieren #Grafiken definieren $rank_0 = '<img src="include/images/forum/rank/rank00.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>20</b> Posts</span><br>'; $rank_1 = '<img src="include/images/forum/rank/rank01.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>40</b> Posts</span><br>'; $rank_2 = '<img src="include/images/forum/rank/rank02.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>60</b> Posts</span><br>'; $rank_3 = '<img src="include/images/forum/rank/rank03.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>80</b> Posts</span><br>'; $rank_4 = '<img src="include/images/forum/rank/rank0.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>100</b> Posts</span><br>'; $rank_5 = '<img src="include/images/forum/rank/rank05.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>120</b> Posts</span><br>'; $rank_6 = '<img src="include/images/forum/rank/rank06.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>140</b> Posts</span><br>'; $rank_7 = '<img src="include/images/forum/rank/rank07.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>160</b> Posts</span><br>'; $rank_8 = '<img src="include/images/forum/rank/rank08.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>180</b> Posts</span><br>'; $rank_9 = '<img src="include/images/forum/rank/rank09.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>200</b> Posts</span><br>'; $rank_10 = '<img src="include/images/forum/rank/complete.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>220</b> Posts</span><br>'; $rank_11 = '<img src="include/images/forum/rank/11.png" alt="" border="0"><br>'; $rank_12 = '<img src="include/images/forum/rank/12.png" alt="" border="0"><br>'; $rank_13 = '<img src="include/images/forum/rank/13.png" alt="" border="0"><br>'; $rank_14 = '<img src="include/images/forum/rank/14.png" alt="" border="0"><br>'; $rank_15 = '<img src="include/images/forum/rank/15.png" alt="" border="0"><br>'; $rank_16 = '<img src="include/images/forum/rank/16.png" alt="" border="0"><br>'; $rank_17 = '<img src="include/images/forum/rank/17.png" alt="" border="0"><br>'; $rank_18 = '<img src="include/images/forum/rank/18.png" alt="" border="0"><br>'; $rank_19 = '<img src="include/images/forum/rank/19.png" alt="" border="0"><br>'; $rank_20 = '<img src="include/images/forum/rank/20.png" alt="" border="0"><br>'; $rank_21 = '<img src="include/images/forum/rank/21.png" alt="" border="0"><br>'; $rank_22 = '<img src="include/images/forum/rank/22.png" alt="" border="0"><br>'; $rank_23 = '<img src="include/images/forum/rank/23.png" alt="" border="0"><br>'; $rank_24 = '<img src="include/images/forum/rank/24.png" alt="" border="0"><br>'; $rank_25 = '<img src="include/images/forum/rank/25.png" alt="" border="0"><br>'; $rank_26 = '<img src="include/images/forum/rank/26.png" alt="" border="0"><br>'; $rank_27 = '<img src="include/images/forum/rank/27.png" alt="" border="0"><br>'; $rank_28 = '<img src="include/images/forum/rank/28.png" alt="" border="0"><br>'; $rank_29 = '<img src="include/images/forum/rank/29.png" alt="" border="0"><br>'; $rank_30 = '<img src="include/images/forum/rank/30.png" alt="" border="0"><br>'; $rank_31 = '<img src="include/images/forum/rank/31.png" alt="" border="0"><br>'; $rank_32 = '<img src="include/images/forum/rank/32.png" alt="" border="0"><br>'; $rank_33 = '<img src="include/images/forum/rank/33.png" alt="" border="0"><br>'; $rank_34 = '<img src="include/images/forum/rank/34.png" alt="" border="0"><br>'; $rank_35 = '<img src="include/images/forum/rank/35.png" alt="" border="0"><br>'; $rank_36 = '<img src="include/images/forum/rank/36.png" alt="" border="0"><br>'; $rank_37 = '<img src="include/images/forum/rank/37.png" alt="" border="0"><br>'; $rank_38 = '<img src="include/images/forum/rank/38.png" alt="" border="0"><br>'; #Bezugnehmen auf das Ranking des users if ( $row['posts'] != '' ) { $row['rang'] = $rank_name.'<br>'; if ($posts <= '4') { $row['rang'] .= $rank_0; } elseif ($posts <= '20') { $row['rang'] .= $rank_1;} elseif ($posts <= '40') { $row['rang'] .= $rank_2; } elseif ($posts <= '60') { $row['rang'] .= $rank_3; } elseif ($posts <= '80') { $row['rang'] .= $rank_4; } elseif ($posts <= '100') { $row['rang'] .= $rank_5; } elseif ($posts <= '120') { $row['rang'] .= $rank_6; } elseif ($posts <= '140') { $row['rang'] .= $rank_7; } elseif ($posts <= '160') { $row['rang'] .= $rank_8; } elseif ($posts <= '180') { $row['rang'] .= $rank_9; } elseif ($posts <= '200') { $row['rang'] .= $rank_10; } elseif ($posts <= '210') { $row['rang'] .= $rank_11; } elseif ($posts <= '220') { $row['rang'] .= $rank_12; } elseif ($posts <= '240') { $row['rang'] .= $rank_13; } elseif ($posts <= '260') { $row['rang'] .= $rank_14; } elseif ($posts <= '280') { $row['rang'] .= $rank_15; } elseif ($posts <= '300') { $row['rang'] .= $rank_16; } elseif ($posts <= '320') { $row['rang'] .= $rank_17; } elseif ($posts <= '340') { $row['rang'] .= $rank_18; } elseif ($posts <= '360') { $row['rang'] .= $rank_19; } elseif ($posts <= '380') { $row['rang'] .= $rank_20; } elseif ($posts <= '400') { $row['rang'] .= $rank_21; } elseif ($posts <= '420') { $row['rang'] .= $rank_22; } elseif ($posts <= '440') { $row['rang'] .= $rank_23; } elseif ($posts <= '460') { $row['rang'] .= $rank_24; } elseif ($posts <= '480') { $row['rang'] .= $rank_25; } elseif ($posts <= '500') { $row['rang'] .= $rank_26; } elseif ($posts <= '520') { $row['rang'] .= $rank_27; } elseif ($posts <= '540') { $row['rang'] .= $rank_28; } elseif ($posts <= '560') { $row['rang'] .= $rank_29; } elseif ($posts <= '580') { $row['rang'] .= $rank_30; } elseif ($posts <= '600') { $row['rang'] .= $rank_31; } elseif ($posts <= '620') { $row['rang'] .= $rank_32; } elseif ($posts <= '640') { $row['rang'] .= $rank_33; } elseif ($posts <= '660') { $row['rang'] .= $rank_34; } elseif ($posts <= '680') { $row['rang'] .= $rank_35; } elseif ($posts <= '700') { $row['rang'] .= $rank_36; } elseif ($posts < '720') { $row['rang'] .= $rank_37; } elseif ($posts >= '740') { $row['rang'] .= $rank_38; } } else {$row['rang'] .= ""; } } #User Details if ( $posts != '' ) { $abf1 = 'SELECT * FROM prefix_user where id = '.$row["erstid"]; $erg1 = db_query($abf1); $user = db_fetch_object($erg1); $zeit = date('d. M Y',$user->regist); $llogin = date('d. M Y',$user->llogin); $ort = $user->wohnort; $www = $user->homepage; $email = $user->opt_mail; $pm = $user->opt_pm; $land = $user->staat; #Flagge if ($land != '') {$row['land'] = '<img src="include/images/flags/'.$land.'" >';} else{$row['land'] = '';} #Dabei seit $row['details'] = "<font style=\"font-weight:bold; color:#A67303\">Dabei seit:</font> ".$zeit."<br>"; #Wohnort if ($ort != ''){$row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Wohnort:</font> ".$ort."<br>";} #Homepage if ($www != ''){$row['www'] = '<a href="'.$www.'" target="_blank"><img src="include/images/forum/www.png" border="0" alt="Website des Users besuchen"></a>';} else{$row['www'] = '';} #Letzter Login $row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Letzter Login:</font> ".$llogin."<br>"; #PM if ($pm == '1'){ $row['pm'] = "<a href='?forum-privmsg-new=0&empfid=".$row['erstid']."'><img src='include/images/forum/pm.png' border='0' alt='Private Nachricht an den User senden'></a>"; }else{$row['pm'] = '';} #email if ($email == '1'){ $row['email'] = "<a href='?user-mail-".$row['erstid']."'><img src='include/images/forum/email.png' border='0' alt='E-Mail an den User senden'></a>"; }else{$row['email'] = '';} } else { $row['details'] = ""; $row['land'] = ''; $row['pm'] = ''; $row['email'] = ''; $row['www'] = ''; } if ( $posts != '' ) { #User Online o Offline $abf1 = "SELECT * FROM prefix_online where uid = ".$row['erstid']; $erg1 = db_query($abf1); $status = db_fetch_object($erg1); if ($status->uid == $row['erstid']) { $row['online'] = ' <img src="include/images/forum/uonline.png" border="0">'; } else { $row['online'] = ' <img src="include/images/forum/uoffline.png" border="0">'; } } else {$row['online'] = '';} # #Edit Ende ################################## $row['page'] = $page; if ( $row['posts'] != 0 ) { $row['erst'] = '<a href="index.php?user-details-'.$row['erstid'].'"><b>'.forum_farbname($row['erst']).'</b></a>'; } elseif ( $row['erstid'] == 0 ) { $row['rang'] = 'gelöschter User'; } if ($forum_rights['mods'] == TRUE AND $i>1) { $row['delete'] = '<a class="forum" href="index.php?forum-delpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/delete.png" width="16" height="16" alt="delete" align="absmiddle" title="löschen"/> löschen</a>'; } if ( $forum_rights['reply'] == TRUE AND loggedin() ) { $row['change'] = ' <a class="forum" href="index.php?forum-editpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/change.png" width="16" height="16" alt="change" align="absmiddle" title="ändern"/> ändern</a>'; } $row['posts'] = ($row['posts']?'<br />'.$row['posts']:'').'<br />'; $tpl->set_ar_out($row,1); $i++; } $tpl->set_ar_out( array ( 'SITELINK' => $MPL, 'ANTWORTEN' => $antworten ) , 2 ); // anfang qpost if (loggedin()) { $dppk_time = time(); $time = time(); if (!isset($_SESSION['klicktime'])) { $_SESSION['klicktime'] = 0; } $topic = ''; $txt = ''; $xnn = ''; if (isset($_POST['txt_qp'])) { $txt = trim(escape($_POST['txt_qp'], 'textarea')); } $tpl = new tpl ('forum/qpost'); $ar = array ( 'txt_qp' => escape_for_fields(unescape($txt)), 'tid' => $tid, ); $tpl->set_ar_out($ar,1); if (($_SESSION['klicktime'] + 150) > $dppk_time OR empty($txt) OR !empty($_POST['priview']) OR (empty($_POST['Gname']) AND !loggedin())) { } else { # save qpost $_SESSION['klicktime'] = $dppk_time; $design = new design ( $title , $hmenu, 1); $design->header(); if (loggedin()) { $uid = $_SESSION['authid']; $erst = escape($_SESSION['authname'],'string'); db_query("UPDATE `prefix_user` set posts = posts+1 WHERE id = ".$uid); } else { $erst = $xnn; $uid = 0; } db_query ("INSERT INTO `prefix_posts` (tid,fid,erst,erstid,time,txt) VALUES ( ".$tid.", ".$fid.", '".$erst."', ".$uid.", ".$time.", '".$txt."')"); $pid = db_last_id(); db_query("UPDATE `prefix_topics` SET last_post_id = ".$pid.", rep = rep + 1 WHERE id = ".$tid); db_query("UPDATE `prefix_forums` SET posts = posts + 1, last_post_id = ".$pid." WHERE id = ".$fid ); $page = ceil ( ($aktTopicRow['rep']+1) / $allgAr['Fpanz'] ); # topic als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); wd ( array ( $lang['backtotopic'] => 'index.php?forum-showposts-'.$tid.'-p'.$page.'#'.$pid, $lang['backtotopicoverview'] => 'index.php?forum-showtopics-'.$fid ) , $lang['createpostsuccessful'] , 3 ); } } $tpl = new tpl ( 'forum/showpost' ); // end qpost if (loggedin()) { if ($menu->get(3) == 'topicalert') { if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { db_query("DELETE FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid); } else { db_query("INSERT INTO prefix_topic_alerts (tid,uid) VALUES (".$tid.", ".$_SESSION['authid'].")"); } } echo 'Optionen:'; if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['nomailonreply'].'</a><br />'; } else { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['mailonreply'].'</a><br />'; } } if ( $forum_rights['mods'] == TRUE ) { $tpl->set ( 'status', ($aktTopicRow['stat'] == 1 ? $lang['close'] : $lang['open'] ) ); $tpl->set ( 'festnorm', ($aktTopicRow['art'] == 0 ? $lang['fixedtopic'] : $lang['normaltopic'] ) ); $tpl->set('tid',$tid); $tpl->out(3); } $design->footer(); ?>
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de defined ('main') or die ( 'no direct access' ); # check ob ein fehler aufgetreten ist. check_forum_failure($forum_failure); # toipc als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); $title = $allgAr['title'].' :: Forum :: '.$aktTopicRow['name'].' :: Beiträge zeigen'; $hmenu = $extented_forum_menu.'<a class="smalfont" href="index.php?forum">Forum</a><b> » </b>'.aktForumCats($aktForumRow['kat']).'<b> » </b><a class="smalfont" href="index.php?forum-showtopics-'.$fid.'">'.$aktForumRow['name'].'</a><b> » </b>'; $hmenu .= $aktTopicRow['name'].$extented_forum_menu_sufix; $design = new design ( $title , $hmenu, 1); $design->header(); # Topic Hits werden eins hochgesetzt. db_query('UPDATE `prefix_topics` SET hit = hit + 1 WHERE id = "'.$tid.'"'); $erg = db_query("SELECT fid FROM `prefix_posts` WHERE tid = ".$tid); $row = db_fetch_assoc($erg); $newth = '<a href="index.php?forum-newtopic-'.$row['fid'].'"><img src="include/images/forum/newth.png" border="0"></a>'; # mehrere seiten fals gefordert $limit = $allgAr['Fpanz']; // Limit $page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 ); $MPL = db_make_sites ($page , "WHERE tid = ".$tid , $limit , 'index.php?forum-showposts-'.$tid , 'posts' ); $anfang = ($page - 1) * $limit; $antworten = ''; if (($aktTopicRow['stat'] == 1 AND $forum_rights['reply'] == TRUE) OR ($_SESSION['authright'] <= '-7' OR $forum_rights['mods'] == TRUE)) { $antworten = '<a href="index.php?forum-newpost-'.$tid.'"><img src="include/images/forum/antw.png" border="0"></a>'; } $class = 'Cmite'; $tpl = new tpl ( 'forum/showpost' ); $ar = array ( 'SITELINK' => $MPL, 'tid' => $tid, 'ANTWORTEN' => $antworten, 'TOPICNAME' => $aktTopicRow['name'], 'HMENU' => $hmenu, 'NEWTH' => $newth, 'AUSZEICHNUNG' => $auszeichnung, ); $tpl->set_ar_out($ar,0); $i = $anfang +1; $ges_ar = array ('wurstegal', 'maennlich', 'weiblich'); ################################## #Forenmod by www.irvd-website.de - Vorlage von Benjamin Rau & matthias-schlich.de #Posts $erg = db_query("SELECT geschlecht, prefix_posts.id,txt,time,erstid,erst,sig,icq,avatar,posts FROM `prefix_posts` LEFT JOIN prefix_user ON prefix_posts.erstid = prefix_user.id WHERE tid = ".$tid." ORDER BY time LIMIT ".$anfang.",".$limit); while($row = db_fetch_assoc($erg)) { $class = ( $class == 'Cnorm' ? 'Cmite' : 'Cnorm' ); $icq1 = str_replace("-","",$row['icq']); $icq2 = str_replace(" ","",$icq1); // icq abfrage // 0 - keine ICQ abfrage // 1 - ICQ standartbilder bei &design= kann man zwischen den 26 verschiedenen icq bildern wechseln // 2 - für eigne ICQ Statsubilder $own_pics = "1"; $icqdesign = "25"; if ($own_pics == "1") { if (is_numeric($icq2) ){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="http://web.icq.com/whitepages/online?web='.$icq2.'&img='.$icqdesign.'" border="0"></a>'; } else {$row['icq'] = '';} } elseif ($own_pics == "0"){ $row['icq'] = '';} else{ if (is_numeric($icq2) ){ ############### Auszeichnung Ausgabe ####################### $ausgaben = ''; $str = @db_result ( db_query ("SELECT `auszeichnung` FROM prefix_user WHERE id = ".$uid) , 0 ); $auszeichnungarr = explode("#", $str); $style = 'float:left;width:px;height:100px;border:1px;border-bottom-left-radius: 5px; border-top-left-radius: 5px; border-bottom-right-radius: 5px; border-top-right-radius: 5px;padding: 1px;-moz-box-shadow: 0px 2px 3px #000; -webkit-box-shadow: 0px 1px 3px #000; box-shadow: 0px 1px 3px #000;margin:1px;padding:0'; foreach($auszeichnungarr as $value) { if (file_exists('include/images/profilmod/auszeichnung/'.$value) and !empty($value) ) { $ausgaben .= '<img style="'.$style.'" onmouseover="Tip(\'<div align="center"><img style="width:180px;height:px;border:none" src="include/images/profilmod/auszeichnung/'.$value.'"><br>'.substr($value,0,-4).'</div>\')" onmouseout="UnTip()" src="include/images/profilmod/auszeichnung/'.$value.'" alt="'.substr($value,0,-4).'" /> '; } else { $ausgaben .= ''; } } ################################################## include('user_infos.php'); $abf8 = "SELECT * FROM prefix_online WHERE uid = '".$uid."'"; $erg8 = db_query($abf8); $row8 = db_fetch_assoc($erg8); if(isset($row8['uid'])){ $online = '<font color="#009900">online</font>'; }else{ $online = '<b>offline</b>'; } // Eigene ICQ-Bilder $status = (icq_status($icq2)); if ($status == "1"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqonline.png" border="0"></a>'; }elseif ($status == "0"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqoffline.png" border="0"></a>'; }elseif ($status == "2"){ $row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icq2.'&action=add"><img src="include/images/forum/icqinactive.png" border="0"></a>'; }else {$row['icq'] = '';} }else {$row['icq'] = '';} } # define some vars. $row['sig'] = ( empty($row['sig']) ? '' : '<br /><hr style="width: 80%;" align="left">'.bbcode($row['sig']) ); $row['TID'] = $tid; $row['class'] = $class; $row['date'] = date ('d.M.Y - H:i:s', $row['time'] ); $row['delete'] = ''; $row['change'] = ''; $row['erst'] = forum_farbname($row['erst']); if (file_exists($row['avatar'])) { $row['avatar'] = '<br /><img src="'.$row['avatar'].'" alt="User Pic" border="0" width="100" height="100" /><br />'; } elseif ($allgAr['forum_default_avatar']) { $row['avatar'] = '<br /><img src="include/images/avatars/'.$ges_ar[$row['geschlecht']].'.jpg" alt="User Pic" border="0" /><br />'; } else { $row['avatar'] = ''; } $row['rang2'] = userrang ($row['posts'],$row['erstid']); $rank_name = $row['rang2']; $row['txt'] = (isset($_GET['such']) ? markword(bbcode ($row['txt']),$_GET['such']) : bbcode ($row['txt']) ); $row['i'] = $i; if ( $row['erstid'] != '' ) { $user_row = db_fetch_assoc(db_query("SELECT posts,regist FROM prefix_user WHERE id = ".$row['erstid'])); $posts = $row['posts']; $row['posts'] = '<font style="font-weight:bold">Beiträge:</font> '.$row['posts'].'<br />'; if ( $posts == '' ) { $row['posts'] = '<br>Nicht registriert';} #Ranking Balken #Grafiken definieren #Grafiken definieren $rank_0 = '<img src="include/images/forum/rank/rank00.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>20</b> Posts</span><br>'; $rank_1 = '<img src="include/images/forum/rank/rank01.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>40</b> Posts</span><br>'; $rank_2 = '<img src="include/images/forum/rank/rank02.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>60</b> Posts</span><br>'; $rank_3 = '<img src="include/images/forum/rank/rank03.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>80</b> Posts</span><br>'; $rank_4 = '<img src="include/images/forum/rank/rank0.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>100</b> Posts</span><br>'; $rank_5 = '<img src="include/images/forum/rank/rank05.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>120</b> Posts</span><br>'; $rank_6 = '<img src="include/images/forum/rank/rank06.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>140</b> Posts</span><br>'; $rank_7 = '<img src="include/images/forum/rank/rank07.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>160</b> Posts</span><br>'; $rank_8 = '<img src="include/images/forum/rank/rank08.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>180</b> Posts</span><br>'; $rank_9 = '<img src="include/images/forum/rank/rank09.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>200</b> Posts</span><br>'; $rank_10 = '<img src="include/images/forum/rank/complete.png" alt="" border="0"><br><span class="smalfont">Next Level bei <b>220</b> Posts</span><br>'; $rank_11 = '<img src="include/images/forum/rank/11.png" alt="" border="0"><br>'; $rank_12 = '<img src="include/images/forum/rank/12.png" alt="" border="0"><br>'; $rank_13 = '<img src="include/images/forum/rank/13.png" alt="" border="0"><br>'; $rank_14 = '<img src="include/images/forum/rank/14.png" alt="" border="0"><br>'; $rank_15 = '<img src="include/images/forum/rank/15.png" alt="" border="0"><br>'; $rank_16 = '<img src="include/images/forum/rank/16.png" alt="" border="0"><br>'; $rank_17 = '<img src="include/images/forum/rank/17.png" alt="" border="0"><br>'; $rank_18 = '<img src="include/images/forum/rank/18.png" alt="" border="0"><br>'; $rank_19 = '<img src="include/images/forum/rank/19.png" alt="" border="0"><br>'; $rank_20 = '<img src="include/images/forum/rank/20.png" alt="" border="0"><br>'; $rank_21 = '<img src="include/images/forum/rank/21.png" alt="" border="0"><br>'; $rank_22 = '<img src="include/images/forum/rank/22.png" alt="" border="0"><br>'; $rank_23 = '<img src="include/images/forum/rank/23.png" alt="" border="0"><br>'; $rank_24 = '<img src="include/images/forum/rank/24.png" alt="" border="0"><br>'; $rank_25 = '<img src="include/images/forum/rank/25.png" alt="" border="0"><br>'; $rank_26 = '<img src="include/images/forum/rank/26.png" alt="" border="0"><br>'; $rank_27 = '<img src="include/images/forum/rank/27.png" alt="" border="0"><br>'; $rank_28 = '<img src="include/images/forum/rank/28.png" alt="" border="0"><br>'; $rank_29 = '<img src="include/images/forum/rank/29.png" alt="" border="0"><br>'; $rank_30 = '<img src="include/images/forum/rank/30.png" alt="" border="0"><br>'; $rank_31 = '<img src="include/images/forum/rank/31.png" alt="" border="0"><br>'; $rank_32 = '<img src="include/images/forum/rank/32.png" alt="" border="0"><br>'; $rank_33 = '<img src="include/images/forum/rank/33.png" alt="" border="0"><br>'; $rank_34 = '<img src="include/images/forum/rank/34.png" alt="" border="0"><br>'; $rank_35 = '<img src="include/images/forum/rank/35.png" alt="" border="0"><br>'; $rank_36 = '<img src="include/images/forum/rank/36.png" alt="" border="0"><br>'; $rank_37 = '<img src="include/images/forum/rank/37.png" alt="" border="0"><br>'; $rank_38 = '<img src="include/images/forum/rank/38.png" alt="" border="0"><br>'; #Bezugnehmen auf das Ranking des users if ( $row['posts'] != '' ) { $row['rang'] = $rank_name.'<br>'; if ($posts <= '4') { $row['rang'] .= $rank_0; } elseif ($posts <= '20') { $row['rang'] .= $rank_1;} elseif ($posts <= '40') { $row['rang'] .= $rank_2; } elseif ($posts <= '60') { $row['rang'] .= $rank_3; } elseif ($posts <= '80') { $row['rang'] .= $rank_4; } elseif ($posts <= '100') { $row['rang'] .= $rank_5; } elseif ($posts <= '120') { $row['rang'] .= $rank_6; } elseif ($posts <= '140') { $row['rang'] .= $rank_7; } elseif ($posts <= '160') { $row['rang'] .= $rank_8; } elseif ($posts <= '180') { $row['rang'] .= $rank_9; } elseif ($posts <= '200') { $row['rang'] .= $rank_10; } elseif ($posts <= '210') { $row['rang'] .= $rank_11; } elseif ($posts <= '220') { $row['rang'] .= $rank_12; } elseif ($posts <= '240') { $row['rang'] .= $rank_13; } elseif ($posts <= '260') { $row['rang'] .= $rank_14; } elseif ($posts <= '280') { $row['rang'] .= $rank_15; } elseif ($posts <= '300') { $row['rang'] .= $rank_16; } elseif ($posts <= '320') { $row['rang'] .= $rank_17; } elseif ($posts <= '340') { $row['rang'] .= $rank_18; } elseif ($posts <= '360') { $row['rang'] .= $rank_19; } elseif ($posts <= '380') { $row['rang'] .= $rank_20; } elseif ($posts <= '400') { $row['rang'] .= $rank_21; } elseif ($posts <= '420') { $row['rang'] .= $rank_22; } elseif ($posts <= '440') { $row['rang'] .= $rank_23; } elseif ($posts <= '460') { $row['rang'] .= $rank_24; } elseif ($posts <= '480') { $row['rang'] .= $rank_25; } elseif ($posts <= '500') { $row['rang'] .= $rank_26; } elseif ($posts <= '520') { $row['rang'] .= $rank_27; } elseif ($posts <= '540') { $row['rang'] .= $rank_28; } elseif ($posts <= '560') { $row['rang'] .= $rank_29; } elseif ($posts <= '580') { $row['rang'] .= $rank_30; } elseif ($posts <= '600') { $row['rang'] .= $rank_31; } elseif ($posts <= '620') { $row['rang'] .= $rank_32; } elseif ($posts <= '640') { $row['rang'] .= $rank_33; } elseif ($posts <= '660') { $row['rang'] .= $rank_34; } elseif ($posts <= '680') { $row['rang'] .= $rank_35; } elseif ($posts <= '700') { $row['rang'] .= $rank_36; } elseif ($posts < '720') { $row['rang'] .= $rank_37; } elseif ($posts >= '740') { $row['rang'] .= $rank_38; } } else {$row['rang'] .= ""; } } #User Details if ( $posts != '' ) { $abf1 = 'SELECT * FROM prefix_user where id = '.$row["erstid"]; $erg1 = db_query($abf1); $user = db_fetch_object($erg1); $zeit = date('d. M Y',$user->regist); $llogin = date('d. M Y',$user->llogin); $ort = $user->wohnort; $www = $user->homepage; $email = $user->opt_mail; $pm = $user->opt_pm; $land = $user->staat; #Flagge if ($land != '') {$row['land'] = '<img src="include/images/flags/'.$land.'" >';} else{$row['land'] = '';} #Dabei seit $row['details'] = "<font style=\"font-weight:bold; color:#A67303\">Dabei seit:</font> ".$zeit."<br>"; #Wohnort if ($ort != ''){$row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Wohnort:</font> ".$ort."<br>";} #Homepage if ($www != ''){$row['www'] = '<a href="'.$www.'" target="_blank"><img src="include/images/forum/www.png" border="0" alt="Website des Users besuchen"></a>';} else{$row['www'] = '';} #Letzter Login $row['details'] .= "<font style=\"font-weight:bold; color:#A67303\">Letzter Login:</font> ".$llogin."<br>"; #PM if ($pm == '1'){ $row['pm'] = "<a href='?forum-privmsg-new=0&empfid=".$row['erstid']."'><img src='include/images/forum/pm.png' border='0' alt='Private Nachricht an den User senden'></a>"; }else{$row['pm'] = '';} #email if ($email == '1'){ $row['email'] = "<a href='?user-mail-".$row['erstid']."'><img src='include/images/forum/email.png' border='0' alt='E-Mail an den User senden'></a>"; }else{$row['email'] = '';} } else { $row['details'] = ""; $row['land'] = ''; $row['pm'] = ''; $row['email'] = ''; $row['www'] = ''; } if ( $posts != '' ) { #User Online o Offline $abf1 = "SELECT * FROM prefix_online where uid = ".$row['erstid']; $erg1 = db_query($abf1); $status = db_fetch_object($erg1); if ($status->uid == $row['erstid']) { $row['online'] = ' <img src="include/images/forum/uonline.png" border="0">'; } else { $row['online'] = ' <img src="include/images/forum/uoffline.png" border="0">'; } } else {$row['online'] = '';} # #Edit Ende ################################## $row['page'] = $page; if ( $row['posts'] != 0 ) { $row['erst'] = '<a href="index.php?user-details-'.$row['erstid'].'"><b>'.forum_farbname($row['erst']).'</b></a>'; } elseif ( $row['erstid'] == 0 ) { $row['rang'] = 'gelöschter User'; } if ($forum_rights['mods'] == TRUE AND $i>1) { $row['delete'] = '<a class="forum" href="index.php?forum-delpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/delete.png" width="16" height="16" alt="delete" align="absmiddle" title="löschen"/> löschen</a>'; } if ( $forum_rights['reply'] == TRUE AND loggedin() ) { $row['change'] = ' <a class="forum" href="index.php?forum-editpost-'.$tid.'-'.$row['id'].'"><img src="include/images/forum/showpost/change.png" width="16" height="16" alt="change" align="absmiddle" title="ändern"/> ändern</a>'; } $row['posts'] = ($row['posts']?'<br />'.$row['posts']:'').'<br />'; $tpl->set_ar_out($row,1); $i++; } $tpl->set_ar_out( array ( 'SITELINK' => $MPL, 'ANTWORTEN' => $antworten ) , 2 ); // anfang qpost if (loggedin()) { $dppk_time = time(); $time = time(); if (!isset($_SESSION['klicktime'])) { $_SESSION['klicktime'] = 0; } $topic = ''; $txt = ''; $xnn = ''; if (isset($_POST['txt_qp'])) { $txt = trim(escape($_POST['txt_qp'], 'textarea')); } $tpl = new tpl ('forum/qpost'); $ar = array ( 'txt_qp' => escape_for_fields(unescape($txt)), 'tid' => $tid, ); $tpl->set_ar_out($ar,1); if (($_SESSION['klicktime'] + 150) > $dppk_time OR empty($txt) OR !empty($_POST['priview']) OR (empty($_POST['Gname']) AND !loggedin())) { } else { # save qpost $_SESSION['klicktime'] = $dppk_time; $design = new design ( $title , $hmenu, 1); $design->header(); if (loggedin()) { $uid = $_SESSION['authid']; $erst = escape($_SESSION['authname'],'string'); db_query("UPDATE `prefix_user` set posts = posts+1 WHERE id = ".$uid); } else { $erst = $xnn; $uid = 0; } db_query ("INSERT INTO `prefix_posts` (tid,fid,erst,erstid,time,txt) VALUES ( ".$tid.", ".$fid.", '".$erst."', ".$uid.", ".$time.", '".$txt."')"); $pid = db_last_id(); db_query("UPDATE `prefix_topics` SET last_post_id = ".$pid.", rep = rep + 1 WHERE id = ".$tid); db_query("UPDATE `prefix_forums` SET posts = posts + 1, last_post_id = ".$pid." WHERE id = ".$fid ); $page = ceil ( ($aktTopicRow['rep']+1) / $allgAr['Fpanz'] ); # topic als gelesen markieren $_SESSION['forumSEE'][$fid][$tid] = time(); wd ( array ( $lang['backtotopic'] => 'index.php?forum-showposts-'.$tid.'-p'.$page.'#'.$pid, $lang['backtotopicoverview'] => 'index.php?forum-showtopics-'.$fid ) , $lang['createpostsuccessful'] , 3 ); } } $tpl = new tpl ( 'forum/showpost' ); // end qpost if (loggedin()) { if ($menu->get(3) == 'topicalert') { if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { db_query("DELETE FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid); } else { db_query("INSERT INTO prefix_topic_alerts (tid,uid) VALUES (".$tid.", ".$_SESSION['authid'].")"); } } echo 'Optionen:'; if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['nomailonreply'].'</a><br />'; } else { echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['mailonreply'].'</a><br />'; } } if ( $forum_rights['mods'] == TRUE ) { $tpl->set ( 'status', ($aktTopicRow['stat'] == 1 ? $lang['close'] : $lang['open'] ) ); $tpl->set ( 'festnorm', ($aktTopicRow['art'] == 0 ? $lang['fixedtopic'] : $lang['normaltopic'] ) ); $tpl->set('tid',$tid); $tpl->out(3); } $design->footer(); ?>
Geschlossen | ||
Zurück zu Module und Modifikationen |