Subversion-Projekte lars-tiefland.em_wm

<?

	class Spiele

	{

		var $g_id;

		var $g_name;

		var $g_m1;

		var $g_m2;

		var $g_g1;

		var $g_g2;

		var $g_location;

		var $g_date;

		var $g_time;

		var $g_type;

		function __construct($g_id)

		{

		  	global $db, $db_meld, $error, $meld, $user;

			$sql="SELECT * FROM games WHERE g_id=$g_id";

			$res=$db->query($sql);

			if (true == DB::isError($res))

			{

				$error=true;

				$meld="Ein Fehler ist aufgetreten!";

				$db_meld=$res->getUserInfo();

				return $error;

			}

			else

			{

				$row=$res->fetchRow(DB_FETCHMODE_ASSOC);

				$this->g_id=$row["g_id"];

				$this->g_name=$row["g_name"];

				$this->g_m1=$row["g_m1"];

				$this->g_m2=$row["g_m2"];

				$this->g_g1=$row["g_g1"];

				$this->g_g2=$row["g_g2"];

				$this->g_location=$row["g_location"];

				$this->g_date=$row["g_date"];

				$this->g_time=$row["g_time"];

				$this->g_type=$row["g_type"];

				return $this;

			}

  		}

		function Spiele()

		{

			$this->__construct();

		}

		function ListSpiele($limit, $start=0)

		{

			global $db, $db_meld, $error, $meld, $user;

			$sql="SELECT * FROM games";

//			echo $db->provides('limit');

			if ($db->provides('limit') && $limit > 0)

			{

				$res=$db->limitquery($sql, $start, $limit);

			}

			else

			{

				$res=$db->query($sql);

			}

			if (true == DB::isError($res))

			{

				$error=true;

				$meld="Ein Fehler ist aufgetreten!";

				$db_meld=$res->getUserInfo();

			}

			return $res;

		}

	}

?>