1 | <?php
|
---|
2 | include '../includes/Global.php';
|
---|
3 |
|
---|
4 | TestLicence('3');
|
---|
5 |
|
---|
6 | $UploadDirPictures = '../'.$UploadDirPictures;
|
---|
7 |
|
---|
8 | // echo $UploadDirPictures;
|
---|
9 |
|
---|
10 | if (array_key_exists('Mode', $_GET)) {
|
---|
11 | $Mode = $_GET['Mode'];
|
---|
12 | } else {
|
---|
13 | $Mode = '';
|
---|
14 | }
|
---|
15 |
|
---|
16 |
|
---|
17 |
|
---|
18 | If ($Mode == 'Picture') { // formuláø pøidání obrázku
|
---|
19 | $NumberPicture = $_GET['NumberPicture'];
|
---|
20 | ?>
|
---|
21 | <h4>Pøidání obrázku</h4>
|
---|
22 | <form enctype="multipart/form-data" action="AddPicture.php?Mode=AddPicture" method="post">
|
---|
23 | <input type="hidden" name="NumberPicture" value="<?php echo $NumberPicture; ?>">
|
---|
24 | <table border="0">
|
---|
25 | <?php
|
---|
26 | for ($i=0; $i<$NumberPicture; ++$i) {
|
---|
27 | echo '<tr><td>Obrázek:</td><td><input size="80" type="file" name="userfile'.$i.'"></td></tr>';
|
---|
28 | }
|
---|
29 | ?>
|
---|
30 | <tr><td>Album: </td><td>
|
---|
31 | <?php
|
---|
32 |
|
---|
33 | $sql = "SELECT * FROM picturealbums";
|
---|
34 | $ID = $db->SQLCommand($sql);
|
---|
35 | echo '<select name="Album" size="1">';
|
---|
36 | while($Line = mysql_fetch_array($ID)) {
|
---|
37 | echo '<option value="',$Line['ID'],'">',$Line['Name'],'</option>';
|
---|
38 | // echo $Line['Description'];
|
---|
39 | } // konec while
|
---|
40 | echo '</select>';
|
---|
41 |
|
---|
42 |
|
---|
43 | ?> </td></tr>
|
---|
44 | <tr><td><input type="submit" value="Odeslat" name="Picture"></td></tr>
|
---|
45 | </table>
|
---|
46 | </form>
|
---|
47 |
|
---|
48 | <?php
|
---|
49 | }
|
---|
50 | If ($Mode == '') { // formuláø pøidání alba
|
---|
51 | ?>
|
---|
52 | <h4>Pøidání alba</h4>
|
---|
53 | <form enctype="multipart/form-data" action="AddPicture.php?Mode=AddAlbum" method="post">
|
---|
54 | <table border="0">
|
---|
55 | <tr><td>Jméno:</td><td><input type="text" name="Name"></td></tr>
|
---|
56 | <tr><td>Popis:</td><td><input type="text" name="Description"></td></tr>
|
---|
57 | <tr><td>Obrázek alba:</td><td><input type="file" name="userfile"></td></tr>
|
---|
58 | <tr><td><input type="submit" value="Odeslat" name="Album"></td></tr>
|
---|
59 | </table>
|
---|
60 | </form>
|
---|
61 |
|
---|
62 | <?php
|
---|
63 |
|
---|
64 | }
|
---|
65 |
|
---|
66 | //TODO: testovat pøi updatování zda je to img $fileatt_type = $_FILES['fileatt']['type']; pozn. zatím jenom jpg
|
---|
67 | if ($Mode == 'AddAlbum') { //pøidání albumu
|
---|
68 | $Name = mysql_escape_string($_POST['Name']);
|
---|
69 | $Description = mysql_escape_string($_POST['Description']);
|
---|
70 | echo('Jméno: '.$Name.'<br>');
|
---|
71 | echo('Popis: '.$Description.'<br>');
|
---|
72 |
|
---|
73 | $sql = "SELECT max(ID) FROM picturealbums";
|
---|
74 | $ID = $db->SQLCommand($sql);
|
---|
75 | $Line = mysql_fetch_row($ID);
|
---|
76 | $ID = $Line[0]+1;
|
---|
77 |
|
---|
78 | $FileName = $_FILES['userfile']['name'];
|
---|
79 | // echo $ID;
|
---|
80 | mkdir($UploadDirPictures.'/'.$ID); // vytvoøení sloky
|
---|
81 | mkdir($UploadDirPictures.'/'.$ID.'/View'); // vytvoøení sloky
|
---|
82 |
|
---|
83 | if (move_uploaded_file($_FILES['userfile']['tmp_name'], $UploadDirPictures.'/ViewAlbums/'.$FileName)) {
|
---|
84 | if ($_FILES['userfile']['type'] <> 'image/jpeg') {
|
---|
85 | echo 'Soubor musí být jpg. Soubor type: '.$_FILES['userfile'.$i]['type'];
|
---|
86 | } else {
|
---|
87 | //vytváøení náhledu
|
---|
88 | $img = imagecreatefromjpeg($UploadDirPictures.'/ViewAlbums/'.$FileName);
|
---|
89 | imagejpeg ($img, $UploadDirPictures.'/ViewAlbums/'.$FileName , $QualityView );
|
---|
90 | echo '<br />Obrázek alba byl vloen<br />';
|
---|
91 |
|
---|
92 | $sql = "INSERT picturealbums VALUE('$ID','".$Name."','$Description',now(), 'ViewAlbums/$FileName')";
|
---|
93 | $db->SQLCommand($sql);
|
---|
94 | echo 'Album '.$Name.' bylo uloeno';
|
---|
95 | WriteLog('Album bylo uloeno: '.$Name.' ID: '.$ID.' Popis: '.$Description,'2');
|
---|
96 | }
|
---|
97 | } else {
|
---|
98 | echo '<br />Nepodaøilo se uloit obrázek alba na server ('.$UploadDirPictures.'/ViewAlbums/'.$FileName.')';
|
---|
99 | }
|
---|
100 |
|
---|
101 | }
|
---|
102 |
|
---|
103 | if ($Mode == 'AddPicture') { //pøidání fotky
|
---|
104 |
|
---|
105 | $NumberPicture = mysql_escape_string($_POST['NumberPicture']);
|
---|
106 | $Album = mysql_escape_string($_POST['Album']);
|
---|
107 |
|
---|
108 | $sql = "SELECT max(ID) FROM pictures";
|
---|
109 | $ID = $db->SQLCommand($sql);
|
---|
110 | $Line = mysql_fetch_row($ID);
|
---|
111 |
|
---|
112 | $ID = $Line[0]+1;
|
---|
113 |
|
---|
114 | for ($i=0; $i<$NumberPicture; ++$i) {
|
---|
115 | $FileName = $_FILES['userfile'.$i]['name'];
|
---|
116 |
|
---|
117 | $ID = $ID+$i;
|
---|
118 |
|
---|
119 | if (move_uploaded_file($_FILES['userfile'.$i]['tmp_name'], $UploadDirPictures.'/'.$Album.'/'.$FileName)) {
|
---|
120 |
|
---|
121 | if ($_FILES['userfile'.$i]['type'] <> 'image/jpeg') {
|
---|
122 | echo 'Soubor musí být jpg. Soubor type: '.$_FILES['userfile'.$i]['type'];
|
---|
123 | } else {
|
---|
124 |
|
---|
125 | $sql = "INSERT pictures VALUE('$ID','$Album','$Album/$FileName','$Album/View/$FileName',now())";
|
---|
126 | $db->SQLCommand($sql);
|
---|
127 |
|
---|
128 | //vytváøení náhledu
|
---|
129 | $img = imagecreatefromjpeg($UploadDirPictures.'/'.$Album.'/'.$FileName);
|
---|
130 | imagejpeg ($img, $UploadDirPictures.'/'.$Album.'/View/'.$FileName , $QualityView );
|
---|
131 |
|
---|
132 | echo '<br /><b>Obrázek '.$FileName.' byl uloen</b><br />';
|
---|
133 | echo('Cesta: '.$UploadDirPictures.'/'.$Album.'/'.$FileName.'<br/>');
|
---|
134 | WriteLog('Fotka byla uloena: '.$FileName.' ID: '.$ID,'2');
|
---|
135 | }
|
---|
136 |
|
---|
137 | } else {
|
---|
138 | echo('Cesta: '.$UploadDirPictures.'/'.$Album.'/'.$FileName.'<br/>');
|
---|
139 | echo 'Nepodaøilo se uloit obrázek alba na server<br />';
|
---|
140 | }
|
---|
141 |
|
---|
142 | }
|
---|
143 | echo '<br />';
|
---|
144 | $Mode = ''; // nastavení pro zobrazení formuláøe, pøidání fotky\ poètu
|
---|
145 | }
|
---|
146 |
|
---|
147 | if ($Mode == '') {
|
---|
148 | ?>
|
---|
149 | <h4>Pøidání obrázkù</h4>
|
---|
150 | <form enctype="multipart/form-data" action="AddPicture.php" method="get">
|
---|
151 | <input type="hidden" name="Mode" value="Picture">
|
---|
152 | <table border="0">
|
---|
153 | <tr><td>Poèet Fotek k pøidání: </td>
|
---|
154 | <td><input type="text" value="1" name="NumberPicture"></td>
|
---|
155 | <td><input type="submit" value="Zobrazit"></td></tr>
|
---|
156 | </table>
|
---|
157 | </form>
|
---|
158 | <?php
|
---|
159 | }
|
---|
160 |
|
---|
161 |
|
---|
162 | if ($Mode == '') { //formuláø mazání obrázkù
|
---|
163 | TestLicence('4');
|
---|
164 | ?>
|
---|
165 | <h4>Smazání obrázku</h4>
|
---|
166 | <form enctype="multipart/form-data" action="AddPicture.php" method="get">
|
---|
167 | <input type="hidden" name="Mode" value="DelPicture">
|
---|
168 | <table border="0">
|
---|
169 | <tr><td>ID Fotky k vymazání: </td>
|
---|
170 | <td><input type="text" name="Picture" size="5"></td>
|
---|
171 | <td><input type="submit" value="Vymazat"></td></tr>
|
---|
172 | </table>
|
---|
173 | </form>
|
---|
174 | <?php
|
---|
175 | }
|
---|
176 |
|
---|
177 | If ($Mode == '') { // formuláø smazání alba
|
---|
178 | TestLicence('4');
|
---|
179 | ?>
|
---|
180 | <h4>Smazání alba</h4>
|
---|
181 | <form enctype="multipart/form-data" action="AddPicture.php" method="get">
|
---|
182 | <input type="hidden" name="Mode" value="DelAlbums">
|
---|
183 | <table border="0">
|
---|
184 | <tr><td>Album: </td><td>
|
---|
185 | <?php
|
---|
186 |
|
---|
187 | $sql = "SELECT * FROM picturealbums";
|
---|
188 | $ID = $db->SQLCommand($sql);
|
---|
189 | echo '<select name="Album" size="10">';
|
---|
190 | while($Line = mysql_fetch_array($ID)) {
|
---|
191 | echo '<option value="',$Line['ID'],'">',$Line['Name'],'</option>';
|
---|
192 | // echo $Line['Description'];
|
---|
193 | } // konec while
|
---|
194 | echo '</select>';
|
---|
195 |
|
---|
196 |
|
---|
197 | ?> </td></tr>
|
---|
198 | <tr><td><input type="submit" value="Vymazat"></td></tr>
|
---|
199 | </table>
|
---|
200 | </form>
|
---|
201 |
|
---|
202 | <?php
|
---|
203 |
|
---|
204 | }
|
---|
205 |
|
---|
206 |
|
---|
207 | if ($Mode == 'DelAlbums') { //smazání albumu
|
---|
208 | TestLicence('4');
|
---|
209 | //http://obec.zdechov.net/AddPicture.php?Mode=DelAlbums&Album=6
|
---|
210 | $IDAlbum = mysql_escape_string($_GET['Album']);
|
---|
211 | echo 'Mazání Albumu: <b>'.$IDAlbum.'</b><br />';
|
---|
212 |
|
---|
213 | // mazání souborù
|
---|
214 | $sql = "SELECT * FROM picturealbums WHERE ID = $IDAlbum";
|
---|
215 | $ID = $db->SQLCommand($sql);
|
---|
216 | while($Line = mysql_fetch_array($ID)) {
|
---|
217 | // echo $Line['FileImg'];
|
---|
218 | echo 'Soubor: '.$UploadDirPictures.'/'.$Line['FileImg'].'<b>';
|
---|
219 | if (unlink ($UploadDirPictures.'/'.$Line['FileImg'])) {
|
---|
220 | echo ' Smazán</b><br />';
|
---|
221 | } else {
|
---|
222 | echo ' Nepodaøilo se smazat</b><br />';
|
---|
223 | }
|
---|
224 | }
|
---|
225 |
|
---|
226 | $sql = "SELECT * FROM pictures WHERE IDAlbum = '$IDAlbum'";
|
---|
227 | $ID = $db->SQLCommand($sql);
|
---|
228 |
|
---|
229 | while($Line = mysql_fetch_array($ID)) {
|
---|
230 | echo 'Soubor: '.$UploadDirPictures.'/'.$Line['FileName'].'<b>';
|
---|
231 | if (unlink ($UploadDirPictures.'/'.$Line['FileName']))
|
---|
232 | echo ' Smazán</b><br />';
|
---|
233 | else
|
---|
234 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
235 |
|
---|
236 | echo 'Soubor: '.$UploadDirPictures.'/'.$Line['ViewFileName'].'<b>';
|
---|
237 | if (unlink ($UploadDirPictures.'/'.$Line['ViewFileName']))
|
---|
238 | echo ' Smazán</b><br />';
|
---|
239 | else
|
---|
240 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
241 | }
|
---|
242 |
|
---|
243 | // smazání adresáøù
|
---|
244 | echo 'Adresáø: '.$UploadDirPictures.'/'.$IDAlbum.'/View <b>';
|
---|
245 | if (rmdir($UploadDirPictures.'/'.$IDAlbum.'/View'))
|
---|
246 | echo ' Smazán</b><br />';
|
---|
247 | else
|
---|
248 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
249 |
|
---|
250 | echo 'Adresáø: '.$UploadDirPictures.'/'.$IDAlbum.' <b>';
|
---|
251 | if (rmdir($UploadDirPictures.'/'.$IDAlbum))
|
---|
252 | echo ' Smazán</b><br />';
|
---|
253 | else
|
---|
254 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
255 | //smazání z databáze
|
---|
256 |
|
---|
257 | $sql = "DELETE FROM picturealbums WHERE ID = '$IDAlbum'";
|
---|
258 | $db->SQLCommand($sql);
|
---|
259 | $sql = "DELETE FROM pictures WHERE IDAlbum = '$IDAlbum'";
|
---|
260 | $db->SQLCommand($sql);
|
---|
261 | // unlink('Files\Pictures\ViewAlbums\maron.jpg');
|
---|
262 |
|
---|
263 | Echo '<b>Vymazáno z databáze</b>';
|
---|
264 | WriteLog('Album smazáno: '.$IDAlbum,'4');
|
---|
265 | }
|
---|
266 |
|
---|
267 | if ($Mode == 'DelPicture') { //smazání fotky
|
---|
268 | TestLicence('4');
|
---|
269 | //http://obec.zdechov.net/AddPicture.php?Mode=DelAlbums&Album=6
|
---|
270 | $IDPicture = mysql_escape_string($_GET['Picture']);
|
---|
271 | echo 'Mazání Fotky: <b>'.$IDPicture.'</b><br />';
|
---|
272 |
|
---|
273 | $sql = "SELECT * FROM pictures WHERE ID = '$IDPicture'";
|
---|
274 | $ID = $db->SQLCommand($sql);
|
---|
275 | $Line = mysql_fetch_array($ID);
|
---|
276 |
|
---|
277 | echo 'Soubor: '.$UploadDirPictures.'/'.$Line['ViewFileName'].'<b>';
|
---|
278 | if (unlink ($UploadDirPictures.'/'.$Line['ViewFileName']))
|
---|
279 | echo ' Smazán</b><br />';
|
---|
280 | else
|
---|
281 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
282 |
|
---|
283 | echo 'Soubor: '.$UploadDirPictures.'/'.$Line['FileName'].'<b>';
|
---|
284 | if (unlink ($UploadDirPictures.'/'.$Line['FileName']))
|
---|
285 | echo ' Smazán</b><br />';
|
---|
286 | else
|
---|
287 | echo ' Nepodaøilo se vymazat!</b><br />';
|
---|
288 |
|
---|
289 | $sql = "DELETE FROM pictures WHERE ID = '$IDPicture' LIMIT 1";
|
---|
290 | $db->SQLCommand($sql);
|
---|
291 |
|
---|
292 | Echo '<b>Vymazáno z databáze</b>';
|
---|
293 | WriteLog('Album smazáno: '.$IDPicture,'4');
|
---|
294 | }
|
---|
295 |
|
---|
296 |
|
---|
297 | ShowFooter()
|
---|
298 | ?>
|
---|