<?php


/**
 * @author NielsB
 * @copyright 2009
 */
 
// i staat voor interger, s staat voor string. Eerst kleine letter wat de variabel is en het woord wel beginnen met hoofdletter!
$iGetal = 1;
$sWoord = "Hallo";


if(empty($iGetal) && !isset($iGetal))
{
	echo '<p>Dan gaat er mooi wat mis want de variabel $iGetal heeft een value van 1.</p>';
}
else
	echo '<p>$iGetal is ingevuld met de waarde van '. $iGetal .'<br />';
	
if($sWoord != "Hallo")
{
	echo 'Er gaat hier wat mis, de fout is dat variabel $sWoord niet gelijk is aan de inhoud van de variabel.</p>';
}
else
	echo 'De variabel $sWoord heeft een value van '. $sWoord .'</p>';


?>

/**
	 * Get the value of a field.
	 *
	 * @throws  Sprig_Exception  field does not exist
	 * @param   string  field name
	 * @return  mixed
	 */
	public function __get($name)
	{
		if ( ! $this->_init)
		{
			// The constructor must always be called first
			$this->__construct();


			// This object is about to be loaded by mysql_fetch_object() or similar
			$this->state('loading');
		}


		if ( ! isset($this->_fields[$name]))
		{
			throw new Sprig_Exception(':name model does not have a field :field',
				array(':name' => get_class($this), ':field' => $name));
		}


		if (isset($this->_related[$name]))
		{
			// Shortcut to any related object
			return $this->_related[$name];
		}


		$field = $this->_fields[$name];


		if ($this->changed($name))
		{
			$value = $this->_changed[$name];
		}
		elseif (array_key_exists($name, $this->_original))
		{
			$value = $this->_original[$name];
		}


		if ($field instanceof Sprig_Field_ForeignKey)
		{
			if ( ! isset($this->_related[$name]))
			{
				$model = Sprig::factory($field->model);


				if ($field instanceof Sprig_Field_HasMany)
				{
					if ($field instanceof Sprig_Field_ManyToMany)
					{
						if (isset($value))
						{
							if (empty($value))
							{
								return new Database_Result_Cached(array(), '');
							}
							else
							{
								$query = DB::select()
									->where($model->pk(), 'IN', $value);
							}
						}
						else
						{							
							$query = DB::select()
								->join($field->through)
									->on($model->fk($field->through, $field->foreign_field), '=', $model->pk(TRUE))
								->where($this->fk($field->through, $name), '=', $this->{$this->_primary_key});
						}
					}
					else
					{
						if (isset($value))
						{
							$query = DB::select()
								->where($model->pk(), 'IN', $value);
						}
						else
						{
							$query = DB::select()
								->where($model->fk(NULL, $field->foreign_field), '=', $this->{$this->_primary_key});
						}
					}					


					$related = $model->load($query, NULL);


					if ( ! $this->changed($name))
					{
						// We can assume this is the original value because no
						// changed value exists
						$this->_original[$name] = $field->value($related);
					}
				}
				elseif ($field instanceof Sprig_Field_BelongsTo)
				{
					$related = $model->values(array($model->pk() => $value));
				}
				elseif ($field instanceof Sprig_Field_HasOne)
				{
					$related = $model->values(array($this->_model => $this->{$this->_primary_key}));
				}


				$value = $this->_related[$name] = $related;
			}
		}


		return $value;
	}

/**
* Get the value of a field.
*
* @throws  Sprig_Exception  field does not exist
* @param   string  field name
* @return  mixed
*/
public function __get($name)
{
if ( ! $this->_init)
{
// The constructor must always be called first
$this->__construct();


// This object is about to be loaded by mysql_fetch_object() or similar
$this->state('loading');
}


if ( ! isset($this->_fields[$name]))
{
throw new Sprig_Exception(':name model does not have a field :field',
array(':name' => get_class($this), ':field' => $name));
}


if (isset($this->_related[$name]))
{
// Shortcut to any related object
return $this->_related[$name];
}


$field = $this->_fields[$name];


if ($this->changed($name))
{
$value = $this->_changed[$name];
}
elseif (array_key_exists($name, $this->_original))
{
$value = $this->_original[$name];
}


if ($field instanceof Sprig_Field_ForeignKey)
{
if ( ! isset($this->_related[$name]))
{
$model = Sprig::factory($field->model);


if ($field instanceof Sprig_Field_HasMany)
{
if ($field instanceof Sprig_Field_ManyToMany)
{
if (isset($value))
{
if (empty($value))
{
	return new Database_Result_Cached(array(), '');
}
else
{
	$query = DB::select()
		->where($model->pk(), 'IN', $value);
}
}
else
{							
$query = DB::select()
	->join($field->through)
		->on($model->fk($field->through, $field->foreign_field), '=', $model->pk(TRUE))
	->where($this->fk($field->through, $name), '=', $this->{$this->_primary_key});
}
}
else
{
if (isset($value))
{
$query = DB::select()
	->where($model->pk(), 'IN', $value);
}
else
{
$query = DB::select()
	->where($model->fk(NULL, $field->foreign_field), '=', $this->{$this->_primary_key});
}
}					


$related = $model->load($query, NULL);


if ( ! $this->changed($name))
{
// We can assume this is the original value because no
// changed value exists
$this->_original[$name] = $field->value($related);
}
}
elseif ($field instanceof Sprig_Field_BelongsTo)
{
$related = $model->values(array($model->pk() => $value));
}
elseif ($field instanceof Sprig_Field_HasOne)
{
$related = $model->values(array($this->_model => $this->{$this->_primary_key}));
}


$value = $this->_related[$name] = $related;
}
}


return $value;
}

<?PHP
include_once "config.php";


logincheck();


mysql_query("UPDATE `leden` SET `online`=NOW() WHERE `login`='". $data['login'] ."'") or die (mysql_error());
?>
<html>
	<head>
		<title>Major-Crime</title>
		<link rel="stylesheet" type="text/css" href="css-v1.css" />
	</head>
	<?php
		if(isset($_GET['naam'])) {
			$dbres = mysql_query("SELECT * FROM `leden` WHERE `login`='". mysql_real_escape_string($_GET['naam']) ."'") or die (mysql_error());
			$prof = mysql_fetch_array($dbres);
			
			if(empty($prof['familie']))
			{
				$familie = "Geen familie!";
			} else 
			{
				$familie = '<a href="famprof.php?fam='. $prof['familie'] .'">'. $prof['familie'] .'</a>';
			}
			
			$rank1 = array("","Noob");
			$rank1 = $rank1[$prof['rank']];
			$famrank = array("Zoekend!","Lid","Bankbeheerder","Onderbaas","Don");
			$famrank = $famrank[$prof['famrank']];
	?>
	<table width="100%">
		<tr>
			<td>
				<h3>Profiel - <? echo $prof['login']; ?></h3>
			</td>
		</tr>
	</table>
	<table width="100%">
		<table width="50%" align="left">
			<tr>
				<td>
					<h3>Algemeen</h3>
				</td>
			</tr>
			<tr>
				<td>Gebruikersnaam</td>
				<td><? echo $prof['login']; ?></td>
			</tr>
			<tr>
				<td>Rank</td>
				<td><? echo $rank1; ?></td>
			</tr>
			<Tr>
				<td>Bank</td>
				<td>&euro;<? echo round($prof['bank']); ?></td>
			</tr>
			<tr>
				<td><h3>Familie</h3></td>
			</tr>
			<tr>
				<td>Familie</td>
				<td><? echo $familie; ?></td>
			</tr>
			<tr>
				<td>Familie rank</td>
				<td><? echo $famrank; ?></td>
			</tr>
		</table>
		<table width="50%" align="right">
			<tr>
				<td>
					<h3>Uitrusting</h3>
				</td>
			</tr>
			<tr>
				<td>Wapen</td>
				<td><? echo $prof['wapen']; ?></td>
			</tr>
			<tr>
				<td>Bescherming</td>
				<td><? echo $prof['bescherming']; ?></td>
			</tr>
			<tr>
				<td>Vliegtuig</td>
				<td><? echo $prof['vliegtuig']; ?></td>
			</tr>
			<tr>
				<td>Kogels</td>
				<td><? echo $prof['kogels']; ?></td>
			</tr>
		</table>
	</table>
		<?php
		}
		?>
</html>