phpBB.de

Code: Alles auswählen

<?

if (!eregi("modules.php", $PHP_SELF)) {
    die ("You can't access this file directly...");
}

require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
require_once("modules/$module_name/config.php");
$index=1;

include("header.php");

OpenTable();

// Quelltext
@mysql_select_db ($dbase) or  die ("Kann Datenbank nicht finden");

$result1 = mysql_query("SELECT * FROM config", $conn);
list($tab) = sql_fetch_row($result1, $conn);

if ($tab==0) {
    $tableborder = "<TABLE BORDER=1 cellspacing=0 rules=none bordercolor=#000000>";
} else {
    $tableborder = "<TABLE BORDER=0 cellspacing=0>";
    $tableunten = "<tr bgcolor=#595959><td height=1 colspan=18></td></tr>";
//    $tableseiten = "<TD width=1% bgcolor=#595959 rowspan=18></td>";
}


if(!isset($sort)) {
    $result = mysql_query("SELECT * FROM $table ORDER by punkte DESC, tordiff DESC", $conn);
} else {
    $sortdir = ($sort=='team') ? 'ASC' : 'DESC';
    $result = mysql_query("SELECT * FROM $table ORDER BY $sort $sortdir", $conn);
}
//
if($sort=='platz') {
    $colorplatz = 'red';
} else {
    $colorplatz = '#000000';
}
//
if($sort=='team') {
    $colorverein = 'red';
} else {
    $colorverein = '#000000';
}

if($sort=='punkte') {
    $colorpunkte = 'red';
} else {
    $colorpunkte = '#000000';
}

if($sort=='gtore') {
    $coloret = 'red';
} else {
    $coloret = '#000000';
}

if($sort=='btore') {
    $colorgt = 'red';
} else {
    $colorgt = '#000000';
}

if($sort=='tordiff') {
    $colordiff = 'red';
} else {
    $colordiff = '#000000';
}

   $number = mysql_num_rows($result);
   echo "<P>Es sind $number Datensätze gelesen worden.</P>";
   echo $tableborder;
   echo $tableunten;
   echo "<TR style='background-color:#d9ecec'>";
   echo $tableseiten;
   echo "<TD width=10%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=platz'><FONT COLOR='$colorplatz'>Platz</A></FONT></TD>";
   echo "<TD width=35%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=team'><FONT COLOR='$colorverein'>Verein</A></FONT></TD>";
   echo "<TD width=10%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=punkte'><FONT COLOR='$colorpunkte'>Punkte</A></FONT></TD>";
   echo "<TD width=10%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=gtore'><FONT COLOR='$coloret'>ET</A></FONT></TD>";
   echo "<TD width=10%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=btore'><FONT COLOR='$colorgt'>GT</A></FONT></TD>";
   echo "<TD width=10%><P ALIGN =CENTER><A HREF='$PHP_SELF?name=Tabellesort&sort=tordiff'><FONT COLOR='$colordiff'>Diff</A></FONT></TD>";
   echo $tableseiten;
   echo "</TR>";
   echo $tableunten;
   
   
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {


$sql2 = "UPDATE tabelle SET platz='$platz'";
$result2 = mysql_query($sql2, $conn);



      $farben++;
      $color = ($farben%2 == 0) ? '#f5f5f5' : '#ffffff';
      echo '<TR style="background-color:' . $color . '">';
      echo "<TD><P ALIGN =CENTER>";
      echo $row['platz'];
      echo "</TD>";
      echo "<TD>";
      echo $row['team'];
      echo "</TD>";
      echo "<TD><P ALIGN =CENTER>";
      echo $row['punkte'];
      echo "</TD>";
      echo "<TD><P ALIGN =CENTER>";
      echo $row['gtore'];
      echo "</TD>";
      echo "<TD><P ALIGN =CENTER>";
      echo $row['btore'];
      echo "</TD>";
      echo "<TD><P ALIGN =CENTER>";
      echo $row['tordiff'];
      echo "</TD>";
      echo "</TR>";
     
}

echo $tableunten;
echo "</TABLE>";

CloseTable();
include("footer.php");
?>

Code: Alles auswählen

$table = array();
$i = 0;

Code: Alles auswählen

if(!isset($sort)) {
    $result = mysql_query("SELECT * FROM $table ORDER by punkte DESC, tordiff DESC", $conn);