Hi Leutz!
Ist es möglich, das in der user random box nicht die User sondern die Squads angezeigt werden?
Thx schon mal.
verwendete ilchClan Version: 1.1
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | <?php # Copyright by: Manuel Staechele # Support: www.ilch.de # Rendom Member Box Scroller # by OloX THX @ Mairu ;) defined ( 'main' ) or die ( 'no direct access' ); $limit = $allgAr [ 'rmbox_limit' ]; $teamid = $allgAr [ 'rmbox_teamid' ]; $bgcolor = $allgAr [ 'rmbox_bgcolor' ]; $bodercolor = $allgAr [ 'rmbox_bodercolor' ]; $width = $allgAr [ 'rmbox_width' ]; $height = $allgAr [ 'rmbox_height' ]; echo '<script src="include/includes/js/member_scroller.js" type="text/javascript"></script>' ; echo '<style type= "text/css" > #marqueecontainer { position: relative; width: '.$width.' ; height: '.$height.' ; background-color: '.$bgcolor.' ; overflow: hidden; border: 1px solid '.$bodercolor.' ; padding: 2px; } </style>'; echo '<div id= "marqueecontainer" onMouseover= "copyspeed=pausespeed" onMouseout= "copyspeed=marqueespeed" > <div id= "vmarquee" style= "position: absolute; width: 98%;" >'; if ( $allgAr [ 'rmbox_teamid' ] == 0) { $sql = db_query( "SELECT id as userid,name,avatar,staat,gebdatum,wohnort FROM prefix_user WHERE 1 ORDER BY rand() LIMIT $limit" ); } else { $sql = db_query( "SELECT b.uid as userid,a.name,a.avatar,a.staat,a.gebdatum,a.wohnort FROM prefix_groupusers b INNER JOIN prefix_user a ON b.uid = a.id WHERE b.gid = $teamid ORDER BY rand() LIMIT $limit" ); } while ( $r = db_fetch_object( $sql )) { if (! empty ( $r ->wohnort)){ $wohnort = $r ->wohnort; } else { $wohnort = 'n/a' ; } if (! empty ( $r ->staat)){ $staat = '<img src="include/images/flags/' . $r ->staat. '" border="0" alt="' . $r ->staat. '" title="' . $r ->staat. '" />' ; } else { $staat = 'n/a' ; } $avatar = '' ; if ( file_exists ( $r ->avatar)) { $avatar = '<img src="' . $r ->avatar. '" border="0" alt="' . $r ->name. '" title="' . $r ->name. '" />' ; } else { $avatar = '<img src="include/images/avatars/wurstegal.jpg" border="0" alt="' . $r ->name. '" title="' . $r ->name. '" />' ; } if ( $r ->gebdatum !== "0000-00-00" ){ $gebdatum = date ( 'd.m.Y' , strtotime ( $r ->gebdatum)); $tag = date ( 'd' , strtotime ( $r ->gebdatum)); $monat = date ( 'm' , strtotime ( $r ->gebdatum)); $jahr = date ( 'Y' , strtotime ( $r ->gebdatum)); $jetzt = mktime (0,0,0, date ( "m" ), date ( "d" ), date ( "Y" )); $geburtstag = mktime (0,0,0, $monat , $tag , $jahr ); $alter = "(" . intval (( $jetzt - $geburtstag ) / (3600 * 24 * 365)). ")" ; } else { $gebdatum = '' ; $alter = '' ; } echo '<div align="center">' . $avatar . '</div><div align="center">' . $staat . ' <a href="index.php?user-details-' . $r ->userid. '">' . $r ->name. '</a> ' . $alter . ' ' . $wohnort . '</a></div><br></br>' ; } echo '</div></div>' ; ?> |
1 2 3 4 5 6 7 8 9 10 | das: if($allgAr['rmbox_teamid'] == 0) { $sql = db_query("SELECT id as userid,name,avatar,staat,gebdatum,wohnort FROM prefix_user WHERE 1 ORDER BY rand() LIMIT $limit"); } else { $sql = db_query("SELECT b.uid as userid,a.name,a.avatar,a.staat,a.gebdatum,a.wohnort FROM prefix_groupusers b INNER JOIN prefix_user a ON b.uid = a.id WHERE b.gid = $teamid ORDER BY rand() LIMIT $limit"); } hiermit ersetzen: $sql = db_query("SELECT id as userid,name,avatar,staat,gebdatum,wohnort FROM prefix_user WHERE TEAM = 1 ORDER BY rand() LIMIT $limit"); |
Geschlossen | ||
![]() |
Zurück zu Module und Modifikationen |