Kleine Frage nur.. kann ich die Anzahl der Comments eines Users in seinem Profil anzeigen lassen und wenn ja, wie?
Zuletzt modifiziert von LittleBIGFan am 04.05.2010 - 15:08:04
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
$row['koms'] = db_count_query("SELECT COUNT(id) FROM `prefix_koms` WHERE uid = ".$uid."");
$row['koms'] = db_count_query('SELECT COUNT(id) FROM `prefix_koms` WHERE name="'.$row['name'].'"');
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de function get_last_user_wars($userid,$game){ $s = ''; $q = db_query("SELECT `wid` FROM `prefix_warmember` WHERE uid = '".$userid."' AND aktion = '1' ORDER BY wid DESC LIMIT 20"); if (db_num_rows($q) > 0 ) { $wids = array(); while ($row = db_fetch_object($q)) { $wids[] = $row->wid; } $wids = implode(', ',$wids); } if( !empty($wids) ) { $erg = db_query("SELECT id, gegner, tag, wlp, land, owp, opp FROM prefix_wars WHERE id IN ($wids) AND status = '3' AND game = '".$game."'"); if (db_num_rows($erg) > 0 ) { while ($r = db_fetch_assoc($erg)) { if ($class == 'Cmite') { $class = 'Cnorm'; } else { $class = 'Cmite'; } $r['tag'] = ( empty($r['tag']) ? $r['gegner'] : $r['tag'] ); if ($r['wlp'] == 1) { $bild = 'include/images/icons/win.gif'; $color = '#558e3d'; } elseif ($r['wlp'] == 2) { $bild = 'include/images/icons/los.gif'; $color = '#a91d1d'; } elseif ($r['wlp'] == 3) { $bild = 'include/images/icons/pad.gif'; $color = '#f0770d'; } $s .= '<td class="'.$class.'" width="1%"><img src="'.$bild.'" alt="" / ></td><td class="'.$class.'" width="99%"><div style="width:80%; float:left"><img src="include/images/flags/'.$r['land'].'" alt="'.$r['land'].'"/> <a href="index.php?wars-more-'.$r['id'].'">'.$r['tag'].'</a></div><div style="float:left; text-align:right; color:'.$color.'; width:20%;">'.$r['owp'].':'.$r['opp'].'</div></td></tr>'; } } else { $s .= '<td class="Cmite" width="10%">Keine Wars</td>'; } } else { $s .= '<td class="Cmite" width="10%">Keine Wars</td>'; } return ($s); } $uid = $menu->get(2); $abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"'; $erg = db_query($abf); $row = db_fetch_assoc($erg); $avatar = ''; if ( file_exists($row['avatar'])) { $avatar = '<img src="'.$row['avatar'].'" border="0">'; } $row['koms'] = db_count_query('SELECT COUNT(id) FROM `prefix_koms` WHERE name="'.$row['name'].'"'); $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row['regist']; $regday = round($regsek / 86400); $postpday = ( $regday == 0 ? 0 : round($row['posts'] / $regday, 2 ) ); if(empty($row['xfire'])) {$xfire_online = ''; $xfire_onlinet = '';}else{ if($allgAr['xfire_online'] == '1'){ $xfire_online = '<img src="http://de.miniprofile.xfire.com/bg/co/type/3/'.$row['xfire'].'.png" />'; }else{ $xfire_online = ''; } if($allgAr['xfire_online'] == '1'){ $xfire_onlinet = 'X-Fire'; }else{ $xfire_onlinet = ''; } } $ar = array ( 'NAME' => $row['name'], 'JOINED' => date('d M Y',$row['regist']), 'LASTAK' => date('d M Y - H:i',$row['llogin']), 'POSTS' => $row['posts'], 'postpday' => $postpday, 'RANG' => userrang ($row['posts'],$uid), 'AVATA' => $avatar, 'UID' => $uid, 'XFIRE' => $xfire_online, 'XFIREt' => $xfire_onlinet, ); $title = $allgAr['title'].' :: Users :: Details von '.$row['name']; $hmenu = $extented_forum_menu.'<a class="smalfont" href="index.php?user">Users</a><b> » </b> Details von '.$row['name'].$extented_forum_menu_sufix; $design = new design ( $title , $hmenu, 1); $design->header(); $tpl = new tpl ( 'user/userdetails' ); $l = profilefields_show ( $uid ); $ar['rowspan'] = 4 + substr_count($l, '<tr><td class="'); $ar['profilefields'] = $l; $tpl->set_ar_out($ar,0); $tpl->set_out('BF2', get_last_user_wars($uid,'BF2'),1); $tpl->set_out('BFBC2', get_last_user_wars($uid,'BFBC2'),2); $tpl->set_out('CoD4', get_last_user_wars($uid,'CoD4'),3); $tpl->set_out('MW2', get_last_user_wars($uid,'MW2'),4); $tpl->set_out('MoH', get_last_user_wars($uid,'MoH'),5); $design->footer(); ?>
<a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a> <br /> <br /> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="3"><b>{_lang_detailsfrom} {NAME}</b></th> </tr><tr> <td class="Cmite" width="30%">{_lang_nickname}</td> <td class="Cnorm" width="40%">{NAME}</td> <td class="Cnorm" width="30%" rowspan="{rowspan}" valign="top" align="center"> <br /> {AVATA} <br /> <br /> {XFIREt} <br /> {XFIRE} <br /> <br /> <font class="smalfont">{RANG}</font> <br /> <br /><a href="javascript:void(0)" onclick="javascript:chatWith({UID},'{NAME}')">Messenger</a> </td> </tr><tr> <td class="Cmite">{_lang_lastactivity}</td> <td class="Cnorm">{LASTAK}</td> </tr><tr> <td class="Cmite">{_lang_comments}</td> <td class="Cnorm">{koms}</td> </tr><tr> <td class="Cmite">{_lang_posts2}</td> <td class="Cnorm">{POSTS}, {_lang_perday}: {postpday}</td> {profilefields} </table> <br /> {EXPLODE} <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="2"> Battlefield2 Wars von {NAME}</b></th></tr><tr> {BF2} </tr></table> {EXPLODE} <br /> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="2"> Battlefield Bad Company 2 Wars von {NAME}</b></th></tr><tr> {BFBC2} </tr></table> {EXPLODE} <br /> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="2"> Call of Duyt 4 Wars von {NAME}</b></th></tr><tr> {CoD4} </tr></table> {EXPLODE} <br /> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="2"> Modern Warefare 2 Wars von {NAME}</b></th></tr><tr> {MW2} </tr></table> {EXPLODE} <br /> <table width="100%" cellpadding="3" cellspacing="1" class="border"> <tr class="Chead"> <th colspan="2"> Medal of Honor Wars von {NAME}</b></th></tr><tr> {MoH} </tr></table> <br /> <a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a>
$ar = array ( 'koms' => $row['koms'], );
Geschlossen | ||
![]() |
Zurück zu Allgemein |