inventar.php

Ga naar de documentatie van deze file.

<?php
/***************************************************************************
 *   Copyright (C) 2007 by Damian Bodde and Peter Wessels                  *
 *   damian@elsw.de  peter1wessels@gmail.com                               *
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 *   This program is distributed in the hope that it will be useful,       *
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
 *   GNU General Public License for more details.                          *
 *                                                                         *
 *   You should have received a copy of the GNU General Public License     *
 *   along with this program; if not, write to the                         *
 *   Free Software Foundation, Inc.,                                       *
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
 ***************************************************************************/
?>

<?php

if(isset($_GET['action']))
{
                $action = $_GET['action'];
}
else
{
                $action = "main";
}

$userid = $_SESSION['userid'];

if($action == "main")
{
                $sql = ("SELECT itemid,stueck FROM inventar WHERE userid='$userid' AND sort='deamon' ORDER BY sort");
                $result = mysql_query($sql) or die(mysql_error());
                while($row = mysql_fetch_array($result))
                {
                                $ide = $row['itemid'];
                                $stuck = $row['stueck'];
                                
                                $sql = ("SELECT id,titel FROM items WHERE id='$ide'");
                                $result = mysql_query($sql) or die(mysql_error());
                                $row = mysql_fetch_array($result);
                                $id    = $row['id'];
                                $titel = $row['titel'];
                                
                                $sql = ("SELECT stueck FROM inventar WHERE userid='$userid' AND sort='patrone'");
                                $result = mysql_query($sql) or die(mysql_error());
                                $row = mysql_fetch_array($result);
                                $pat = $row['stueck'];
                                
                                
                                echo "$titel $stuck PATRONEN: $pat";
                }
}

---