ilch.de :: Forum :: Allgemein :: HTML, PHP, SQL,... :: Die Squads mit Sounds unterlegen

die teams.php

<?php # Copyright by: Manuel Staechele
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
#Hintergrundsound Anfang
$sound = '<embed src="include/sounds/'.$gid.'.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';
#Hintergrundsound Ende
function show_members ($gid,$tpl) {
global $allgAr;
# icq team bild, hier die zahl aendern.
$teams_show_icq_pic = 5;
$tpl->out(1);
$class = 'Cnorm';
$q = "SELECT b.uid, a.icq, a.avatar, a.status, a.name, c.name as posi, staat FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_groupfuncs c ON b.fid = c.id WHERE b.gid = ".$gid." ORDER BY c.pos ASC, a.name ASC";
$erg = db_query($q);
while($row = db_fetch_assoc($erg) ) {
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$row['class'] = $class;
#Hintergrundsound Anfang
$row['sound'] = '<embed src="include/sounds/'.$gid.'.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';
#Hintergrundsound Ende
if ( $row['staat'] != '' ) {
$row['staat'] = '<img src="include/images/flags/'.$row['staat'].'" alt="" border="0">';
} else {
$row['staat'] = 'n/a';
}
$row['status'] = ($row['status']? 'aktiv' : 'inaktiv' );
if(!empty($row['icq'])){
$row['icq'] = '<a href="http://www.icq.com/whitepages/cmd.php?uin='.$row['icq'].'&action=add"><img src="http://wwp.icq.com/scripts/online.dll?icq='.$row['icq'].'&img='.$teams_show_icq_pic.'" valign="bottom" border="0"></a>';
} else {
$row['icq'] = 'n/a';
}
if($allgAr['teams_show_list']==1){
if(empty($row['avatar'])){
$row['avatar'] = 'n/a';
} else {
$row['avatar'] = '<img src="'.$row['avatar'].'" alt="Avatar von '.$row['name'].'" border="0" >';
}
$tpl->set_ar_out($row,2);
} else {
$tpl->set_ar_out($row,3);
}
}
$tpl->out(4);
}
if ($menu->get(1) == 'show') {
$gid = escape($menu->get(2), 'integer');
$name = @db_result (db_query("SELECT name FROM prefix_groups WHERE zeigen = 1 AND id =".$gid));
$bild = @db_result (db_query("SELECT img FROM prefix_groups WHERE zeigen = 1 AND id =".$gid));
#Hintergrundsound Anfang
$sound = '<embed src="include/sounds/'.$gid.'.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';
#Hintergrundsound Ende
$title = $allgAr['title'].' :: Teams :: '.$name;
$hmenu = '<a class="smalfont" href="?teams">Teams</a> &raquo; '.$name;
$design = new design ($title , $hmenu );
$design->header();
$tpl = new tpl ('teams');
 
if (!empty($bild) ) {
$show = '<img src="'.$bild.'" title="'.$name.'" alt="'.$name.'" border="0"></a>';
} else {
$show = '<b>'.$name.'</b>';
}
$tpl->set_out('show', $show,0);
show_members ($gid,$tpl);
} else {
$title = $allgAr['title'].' :: Teams';
$hmenu = 'Teams';
$design = new design ( $title , $hmenu );
$design->header();
$tpl = new tpl ('teams');
#Hintergrundsound Anfang
$sound = '<embed src="include/sounds/'.$gid.'.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';
#Hintergrundsound Ende
$erg1 = db_query("SELECT name,img,id as gid FROM prefix_groups WHERE zeigen = 1 ORDER BY pos");
while ($row = db_fetch_assoc($erg1) ) {
if (!empty($row['img']) ) {
$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><img src="'.$row['img'].'" title="'.$row['name'].'" alt="'.$row['name'].'" border="0"></a>';
} else {
$row['show'] = '<a href="index.php?teams-show-'.$row['gid'].'"><b>'.$row['name'].'</b></a>';
}
$tpl->set_ar_out($row,0);
if ($allgAr['teams_show_cat'] == 0) {
show_members ($row['gid'],$tpl);
#Hintergrundsound Anfang
$sound = '<embed src="include/sounds/'.$gid.'.mp3" autostart="true" loop="false" hidden="true" height="0" width="0">';
#Hintergrundsound Ende
}
}
}
$design->footer(0);
?>

die teams.htm

<style type="text/css">
<!--
.Stil1 {color:#CC9900}
-->
</style>
<table width="100%" cellpadding="3" border="0" cellspacing="1" class="border">
<tr class="Cdark">
    <td colspan="6" valign="bottom" align="center">{show}</td>
    </tr>
</table>
 
{EXPLODE}
<table width="100%" cellpadding="3" border="0" cellspacing="1" class="border">
  {EXPLODE}
  <tr class="{class}">
      <td><div align="center"><table width="450" cellpadding="1" cellspacing="1" class="border2">
  <tr class="{class}">
    <td width="72"><span class="Stil1">Name:</span></td>
    <td width="232"><div align="center"><a href="index.php?user-details-{uid}">{name}</a></div></td>
    <td width="134" rowspan="5"><div align="center"><a href="index.php?user-details-{uid}">{avatar}</a></div></td>
  </tr>
  <tr class="{class}">
    <td><span class="Stil1">Position:</span></td>
    <td><div align="center">{posi}</div></td>
  </tr>
  <tr class="{class}">
    <td><span class="Stil1">ICQ Status:</span></td>
    <td><div align="center">{icq}</div></td>
  </tr>
  <tr class="{class}">
    <td><span class="Stil1">Nationalit&auml;t:</span></td>
    <td><div align="center">{staat}</div></td>
  </tr>
  <tr class="{class}">
    <td><span class="Stil1">Spielstatus:</span></td>
    <td><div align="center">{status}</div></td>
  </tr>
</table></div></td>
  </tr>
  {EXPLODE}
  <tr class="{class}">
    <td width="30%">{name}</td>
    <td width="10%" align="center">{icq}</td>
    <td width="25%">{posi}</td>
    <td width="5%" align="center">{staat}</td>
    <td width="20%">{status}</td>
    <td width="10%" align="center"><a href="index.php?user-details-{uid}">{_lang_more}</a></td>
  </tr>
  {EXPLODE}
</table>
<br />
{sound}

Die Sounds müssen in den Ordenr include/sounds (muss erstellt werden) und der Name des jeweilgen Sounds muss
id.mp3 sein
Wobei id immer die Nummer des Teams ist. Also z.B. 1.mp3

Geschlossen

	Zurück zu HTML, PHP, SQL,...

Beitrag zur Merkliste hinzufügen

ilch Forum » Allgemein » HTML, PHP, SQL,... » Die Squads mit Sounds unterlegen