<?

include("shared.php");
  connect();

$fp = "deck.txt";

$sql4 = "select * from draften_picliste where Spieler = 'DDogg'";
$res4 = send_sql($sql4);
$anzahl4=mysql_numrows($res4);
if ($anzahl4)
  {
    for ($d=0;$d<$anzahl4;$d++)
    {
    $CID=mysql_result($res4, $d, CID);
    $Edition=mysql_result($res4, $d, Edition);

    $Pic1 = '1 [$Editon] $CID'

}}

$inhalt = "$Pic1, $Pic2, $Pic3";
$f = fopen($fp,"w+");
fwrite($f,$inhalt);
fclose($f);

?>

<?
/* Zugangsdaten zum mySQL-Datenbankserver */
$MySQL_Host="XX";
$MySQL_DB="XX";
$MySQL_User="XX";
$MySQL_Passw="XX";

function connect()
{
  global $MySQL_Host, $MySQL_User, $MySQL_Passw, $MySQL_DB, $error;
  if (! $linkid = mysql_connect("$MySQL_Host","$MySQL_User","$MySQL_Passw") )
  {
    $error = "Die Verbindung zu $MySQL_Host konnte nicht hergestellt werden";
    exit;
  }
  return $linkid;
}

function send_sql($sql)
{
  global $MySQL_Host, $MySQL_User, $MySQL_Passw, $MySQL_DB, $error;
  if (! $res = mysql_db_query($MySQL_DB, $sql))
  {
    echo mysql_error();
    exit;
  }
  return $res;
}

function logged_in()
{
    $sql="SELECT UserId
    FROM users
    WHERE UserSession='".session_id()."'
    LIMIT 1";
    $result= mysql_query($sql);
      return ( mysql_num_rows($result)==1);
}

?>