summaryrefslogtreecommitdiff
path: root/includes/funktion_schichtplan_aray.php
blob: 2f7f4b36c9c2d2b3e05a35a4558e088298595f89 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php

/*#######################################################
#       Aufbau von Standart Feldern                     #
#######################################################*/

// erstellt ein Array der Reume
	$sql = "SELECT `RID`, `Name` FROM `Room` ".
		"WHERE `Show`='Y'". 
		"ORDER BY `Number`, `Name`;";
	
	$Erg = mysql_query($sql, $con);
	$rowcount = mysql_num_rows($Erg);

	for ($i=0; $i<$rowcount; $i++)
	{
		$Room[$i]["RID"]  = mysql_result($Erg, $i, "RID");
		$Room[$i]["Name"] = mysql_result($Erg, $i, "Name");
	
		$RoomID[ mysql_result($Erg, $i, "RID") ] =  mysql_result($Erg, $i, "Name");
	}

// erstellt ein Aray der Engeltypen
	$sql = "SELECT `TID`, `Name` FROM `EngelType` ORDER BY `Name`";
	$Erg = mysql_query($sql, $con);
	$rowcount = mysql_num_rows($Erg);
	for ($i=0; $i<$rowcount; $i++)
	{
		$EngelType[$i]["TID"]  = mysql_result($Erg, $i, "TID");
		$EngelType[$i]["Name"]  = mysql_result($Erg, $i, "Name").Get_Text("inc_schicht_engel");

		$EngelTypeID[ mysql_result($Erg, $i, "TID") ] = 
			mysql_result($Erg, $i, "Name").Get_Text("inc_schicht_engel");
		$TID2Name[ mysql_result($Erg, $i, "TID") ] = mysql_result($Erg, $i, "Name");
	}												

include ("funktion_schichtplan_Tage.php");
?>