<?php
include("sicherheit.php3");
include("../dbdata.php3");
include("header.php3");
include("functions.php3");


$verbindung = mysql_connect("localhost", $dbuser, $dbpass);
mysql_select_db($dbname, $verbindung);
$abfrage= "SELECT party_titel, party_ort, party_datum, party_begin, party_alarm, party_beschreibung, party_from FROM pm_parties WHERE party_id='$id' ";

$abfrage= "SELECT party_titel, party_ort, party_datum, party_begin, party_alarm, party_beschreibung, party_from, party_status FROM pm_parties WHERE party_id='$id' ";
$erg = mysql_query ($abfrage, $verbindung);  
$myrow = mysql_fetch_row($erg);

$anteil = calc_partymeter($id);

if ($anteil > ( $myrow[4] / 100) && $myrow[7] != "Party_alarm" )
	{
		party_alarm($party_id);
	}

	



?> 
<div align="center">

<P class=typobold>
<?
show_partymeter($id, $myrow[4]);
echo "<P>".$myrow[0];
?>
</P>


<P>
<table width="450" border="0" cellspacing="0" cellpadding="0" class="typotext">
	<tr>
     		<td class="typobold">Partydaten</td>
     		<td></td>
      	</tr>	
		<tr>
      		<td background="grau.jpg" height="1"></td>
      		<td background="grau.jpg" height="1"></td>
      	</tr>
            <tr valign="top"> 
              <td width="104" class="typotext">Titel der Party</td>
              <td width="249">
                <? echo $myrow[0]; ?>
              </td>
            </tr>
            <tr valign="top"> 
              <td width="104" class="typotext">Ort</td>
              <td width="249"> 
                <? echo $myrow[1]; ?>
              </td>
            </tr >

            <tr valign="top"> 
              <td width="104" class="typotext">Datum</td>
              <td width="249"> 
                <? echo $myrow[2]; ?>
              </td>
            </tr>

            <tr valign="top"> 
              <td width="104" class="typotext">Begin</td>
              <td width="249"> 
                <? echo $myrow[3]; ?>
              </td>
            </tr>
            <tr valign="top"> 
              <td width="104" class="typotext">Partyalarm bei</td>
              <td width="249"> 
                <? echo $myrow[4]; ?>%
              </td>
            </tr>
            <tr valign="top"> 
              <td width="104" class="typotext">Beschreibung</td>
              <td width="249"> 
            	<? echo $myrow[5]; ?>
              </td>
            </tr>
            <tr valign="top"> 
              <td width="104" class="typotext">Party von</td>
              <td width="249"> 
      		<? echo $myrow[6]; ?>
              </td>
		</tr>

</table>

<P>


<?
	$verbindung = mysql_connect("localhost", $dbuser, $dbpass);
	mysql_select_db($dbname, $verbindung);
	$abfrage= "SELECT count(task_id) FROM pm_tasks WHERE task_party='$id'";
	$erg = mysql_query ($abfrage, $verbindung);  
	$myrow = mysql_fetch_row($erg);
	if ($myrow[0] > 0)
	{

		print "<table width=450 border=0 cellspacing=0 cellpadding=0 class=typotext>";
		print "<tr><td class=typobold width=104>Aufgaben</td>	<td width=256></td><td></td></tr>";
		print "<tr><td background=grau.jpg height=1></td><td background=grau.jpg height=1></td><td background=grau.jpg height=1></td></tr>";

		$verbindung = mysql_connect("localhost", $dbuser, $dbpass);
		mysql_select_db($dbname, $verbindung);
		$abfrage= "SELECT task_id, task_name, task_beschreibung, task_friend  FROM pm_tasks WHERE task_party='$id'";
		$erg = mysql_query ($abfrage, $verbindung);  

		while ( $myrow = mysql_fetch_row($erg) ) 	
			{
					print "<tr><td>$myrow[1]</td><td>$myrow[2]</td><td>";
					if ($myrow[3] =="0")
						{
							print "???</td></tr>";
						}
					else
						{
							$abfrage= "SELECT friend_spitzname FROM pm_friends WHERE friend_id='$myrow[3]' ";
							$erg2= mysql_query ($abfrage, $verbindung);  
							$myrow2 = mysql_fetch_row($erg2);
							print "$myrow2[0]</td></tr>";
						}
			}
 		print "</table>";
	} // if
?>
<P>

<table width="450" border="0" cellspacing="0" cellpadding="0" class="typotext">
	<tr>
     		<td class="typobold" width="104">Freunde</td>
     		<td width="256"></td>
     		<td class="typobold">Anwesend</td>
      	</tr>	
		<tr>
      		<td background="grau.jpg" height="1" width="104"></td>
      		<td background="grau.jpg" height="1"></td>
      		<td background="grau.jpg" height="1"></td>
      	</tr>
<?


	$abfrage= "SELECT a.friend_email, a.friend_spitzname, b.status FROM pm_friends AS a, pm_friend_check AS b  WHERE  b.party_id ='$id' AND a.friend_id=b.friend_id";
	$erg = mysql_query ($abfrage, $verbindung);  

	while ( $myrow = mysql_fetch_row($erg) ) 
		{
				print "<tr><td width=104>$myrow[1]</td><td>$myrow[0]</td> <td >$myrow[2]</td></tr>";
		}

?>
</table>

</div>

<?php
mysql_close($verbindung);
include("fooder.php3");
?>
