<?php
error_reporting(0);
include("config.php");
include("functions.php");

 // heldendaten auslesen
echo "<h2>Helden</h2>\n";
$sql = "SELECT * FROM `".$db_prefix."_heros` WHERE `id`='$user_id' AND `tot`=0 AND Gruppe != '' AND status > 0";
$result = mysql_query($sql);
// microtime();
while($daten = mysql_fetch_assoc($result)) {
/*
$aS = microtime();
 $sql_newtext = "SELECT gid
   FROM `dsa_abtextpunkte`
   WHERE gid = (
     SELECT id
     FROM dsa_gruppen
     WHERE name = '".$daten['Gruppe']."'
    )
    AND zeit > ".$daten['gesehenbis']."
   LIMIT 1";
 $query_newtext = mysql_query($sql_newtext);
$aE = microtime();
$bS = microtime();
*/
 $sql_newtext = "SELECT gid
   FROM `dsa_abtextpunkte` AS ap
   LEFT JOIN dsa_gruppen AS g
    ON ap.gid = g.id
   WHERE g.name = '".$daten['Gruppe']."'
    AND ap.zeit > ".$daten['gesehenbis']."
   LIMIT 1";
 $query_newtext = mysql_query($sql_newtext);
/*
$bE = microtime();
 echo 'WHERE SELECT : '.round($aE-$aS, 4).'<br />';
 echo 'LEFT JOIN : '.round($bE-$bS, 4).'<br />';
*/
 if (mysql_num_rows($query_newtext)>0) {
  echo "<a >{$daten['Name']} ({$daten['Gruppe']})</a><br />\n";
 }
}

 // gruppendaten auslesen
echo "<h2>Gruppen</h2>\n";
$sql = "SELECT * FROM `".$db_prefix."_gruppen` WHERE `spielleiter`='$user_name' AND abenteueraktuell!=0";
$result = mysql_query($sql);
while($daten = mysql_fetch_assoc($result)) {
 $sql_newtext = "SELECT gid 
   FROM `dsa_abtextpunkte` 
   WHERE gid = ".$daten['id']." 
    AND zeit > ".$daten['gesehenbis']." 
   LIMIT 1";
 $query_newtext = mysql_query($sql_newtext);
 if (mysql_num_rows($query_newtext)>0) {
  echo "<a >{$daten['name']}</a><br />\n";
 }
}

?>