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 | |