Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<? require_once "util.php" ?>
2 
<?
3 
	$self=basename($PHP_SELF);
4 
	$Tab="Files";
5 
	$DB=$Tab;
6 
	require_once "connect.php";
7 
	if (!$rechte[$Rubrik[content_management]] & $Buttons[Seiten])
8 
	{
9 
		exit;
10 
	}
11 
	if ($action=="update")
12 
	{
13 
		if (!$ID)
14 
		{	// insert Dummy-Entry
15 
			if ($dir)
16 
			{
17 
				$Dateiname=$dir."/".$Dateiname;
18 
				$HTTP_POST_VARS[Dateiname]=$dir."/".$HTTP_POST_VARS[Dateiname];
19 
			}
20 
			$query = "insert into $DB (erstellt_am,erstellt_von,site,Dateiname) VALUES (NOW(),'$PHP_AUTH_USER','$site','$Dateiname')";
21 
			$result = mysql_query ("$query");
22 
			if (mysql_errno()==1062)
23 
			{
24 
				?><font face="Arial, Helvetica, sans-serif" size="3" color="#FF0000"><b>Dieser
25 
      Dateiname ist bereits vergeben!</b></font><br>
26 
<a href="javascript:history.go(-1)"><font face="Arial, Helvetica, sans-serif" size="2" color="#FF0000"><b>Zurück</b></font></a>
27 
<?
28 
				exit;
29 
			}
30 
			$ID=mysql_insert_id();
31 
		}
32 
 
33 
		unset($HTTP_POST_VARS[action]);
34 
		unset($HTTP_POST_VARS[ID]);
35 
 
36 
//-------------------------------------------------------------------------------------------
37 
// save Files
38 
//-------------------------------------------------------------------------------------------
39 
		foreach(array_keys($HTTP_POST_VARS) as $elem)
40 
		{
41 
			global $elem;
42 
			if ($elem[0] == "_")
43 
			{
44 
				unset($HTTP_POST_VARS[$elem]);
45 
				$button=$$elem;
46 
				$elem=substr($elem,1);
47 
				$Pfad=$HTTP_POST_VARS[$elem."_Pfad"];
48 
				unset($HTTP_POST_VARS[$elem."_Pfad"]);
49 
				$image=$$elem;
50 
				$image_name=$elem."_name";
51 
				$image_name=urlencode($$image_name);
52 
				switch ($button)
53 
				{
54 
					case 0:
55 
						break;
56 
					case 1:
57 
						$HTTP_POST_VARS[$elem]='';
58 
	   					break;
59 
	   				case 2:
60 
						//$image_name=$ID."_".$image_name;
61 
						//$image_name=$ID.strrchr($image_name,".");
62 
						$HTTP_POST_VARS[$elem]=$image_name;
63 
						copy($image,$Pfad.$image_name);
64 
						$$elem=$image_name;
65 
				        break;
66 
				    default:
67 
						$$elem=$button;
68 
				        break;
69 
			    }
70 
			}
71 
		}
72 
//-------------------------------------------------------------------------------------------
73 
//-------------------------------------------------------------------------------------------
74 
 
75 
		$names=array();
76 
		foreach(array_keys($HTTP_POST_VARS) as $elem)
77 
		{
78 
			array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
79 
		}
80 
		$query="update $DB set ".join($names,', ');
81 
		$query=$query.", letzteAenderung_von='$PHP_AUTH_USER', letzteAenderung_am=NOW() where ID = '$ID'";
82 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
83 
		if (!$redirect)
84 
		{
85 
			if (!$externeDatei)
86 
			{
87 
				dateiname($ID);
88 
			}
89 
			else
90 
			{
91 
				Navigation();
92 
			}
93 
		}
94 
		header("Location: $self?$QUERY_STRING&ID=$ID");
95 
	}
96 
	if ($action=="delete")
97 
	{
98 
		if ($ID)
99 
		{
100 
			$condition=array();
101 
			$condition2=array();
102 
			foreach ($ID as $elem)
103 
			{
104 
				array_push($condition," ID = '$elem'");
105 
				array_push($condition2," File = '$elem'");
106 
			}
107 
			$cond=join(" or ",$condition);
108 
			$query = "DELETE FROM $DB WHERE $cond";
109 
			$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
110 
 
111 
			$cond2=join(" or ",$condition2);
112 
			$query = "DELETE FROM content WHERE $cond2";
113 
			$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
114 
			Navigation();
115 
			header("Location: ".$self);
116 
		}
117 
	}
118 
		if (!$action)
119 
		{
120 
			$action="select_edit";
121 
		}
122 
		if (!$sort)
123 
		{
124 
			$sort="Titel";
125 
		}
126 
?>