1 | <?php |
---|
2 | /*************************************************************************** |
---|
3 | * waiting.php is a part of PhpWebGallery * |
---|
4 | * ------------------- * |
---|
5 | * last update : Monday, October 28, 2002 * |
---|
6 | * email : pierrick@z0rglub.com * |
---|
7 | * * |
---|
8 | ***************************************************************************/ |
---|
9 | |
---|
10 | /*************************************************************************** |
---|
11 | * * |
---|
12 | * This program is free software; you can redistribute it and/or modify * |
---|
13 | * it under the terms of the GNU General Public License as published by * |
---|
14 | * the Free Software Foundation; * |
---|
15 | * * |
---|
16 | ***************************************************************************/ |
---|
17 | include_once( "./include/isadmin.inc.php" ); |
---|
18 | //-------------------------------------------------------------- mise à jour |
---|
19 | if ( isset( $HTTP_POST_VARS['submit'] ) ) |
---|
20 | { |
---|
21 | $query = "select id,cat_id,file,tn_ext"; |
---|
22 | $query.= " from $prefixeTable"."waiting"; |
---|
23 | $query.= ";"; |
---|
24 | $result = mysql_query( $query ); |
---|
25 | while ( $row = mysql_fetch_array( $result ) ) |
---|
26 | { |
---|
27 | $key = "validate-".$row['id']; |
---|
28 | if ( isset( $HTTP_POST_VARS[$key] ) ) |
---|
29 | { |
---|
30 | $query = "delete from $prefixeTable"."waiting"; |
---|
31 | $query.= " where id = ".$row['id']; |
---|
32 | $query.= ";"; |
---|
33 | mysql_query( $query ); |
---|
34 | if ( $HTTP_POST_VARS[$key] == "false" ) |
---|
35 | { |
---|
36 | // we have to delete the picture and the thumbnail if it exists |
---|
37 | $cat = get_cat_info( $row['cat_id'] ); |
---|
38 | unlink( ".".$cat['dir'].$row['file'] ); |
---|
39 | if ( $row['tn_ext'] != "" ) |
---|
40 | { |
---|
41 | $file = substr ( $row['file'], 0, strrpos ( $row['file'], ".") ); |
---|
42 | unlink( ".".$cat['dir']."thumbnail/".$conf['prefixe_thumbnail'].$file.".".$row['tn_ext'] ); |
---|
43 | } |
---|
44 | } |
---|
45 | } |
---|
46 | } |
---|
47 | } |
---|
48 | //--------------------------------------------------------------- formulaire |
---|
49 | $cat_names = array(); |
---|
50 | echo " |
---|
51 | <form action=\"".add_session_id_to_url( "./admin.php?page=waiting" )."\" method=\"post\"> |
---|
52 | <table style=\"width:100%;\"> |
---|
53 | <tr> |
---|
54 | <th style=\"width:20%;\">".$lang['category']."</th> |
---|
55 | <th style=\"width:20%;\">".$lang['date']."</th> |
---|
56 | <th style=\"width:20%;\">".$lang['file']."</th> |
---|
57 | <th style=\"width:20%;\">".$lang['thumbnail']."</th> |
---|
58 | <th style=\"width:20%;\">".$lang['author']."</th> |
---|
59 | <th style=\"width:1px;\"> </th> |
---|
60 | </tr>"; |
---|
61 | $query = "select id,cat_id,file,username,mail_address,date,tn_ext"; |
---|
62 | $query.= " from $prefixeTable"."waiting"; |
---|
63 | $query.= " order by cat_id"; |
---|
64 | $query.= ";"; |
---|
65 | $result = mysql_query( $query ); |
---|
66 | $i = 0; |
---|
67 | while ( $row = mysql_fetch_array( $result ) ) |
---|
68 | { |
---|
69 | $style = ""; |
---|
70 | if ( $i%2 == 0 ) |
---|
71 | { |
---|
72 | $style = "class=\"row2\""; |
---|
73 | } |
---|
74 | if ( !isset( $cat_names[$row['cat_id']] ) ) |
---|
75 | { |
---|
76 | $cat = get_cat_info( $row['cat_id'] ); |
---|
77 | $cat_names[$row['cat_id']] = array(); |
---|
78 | $cat_names[$row['cat_id']]['dir'] = ".".$cat['dir']; |
---|
79 | $cat_names[$row['cat_id']]['display_name'] = get_cat_display_name( $cat['name'], " - ", "font-style:italic;" ); |
---|
80 | } |
---|
81 | echo " |
---|
82 | <tr> |
---|
83 | <td $style style=\"white-space:nowrap;\">".$cat_names[$row['cat_id']]['display_name']."</td> |
---|
84 | <td $style style=\"white-space:nowrap;\">".$lang['day'][date( "w", $row['date'] )].date( " j ", $row['date'] ).$lang['month'][date( "n", $row['date'] )].date( " Y G:i", $row['date'] )."</td> |
---|
85 | <td $style style=\"white-space:nowrap;\"> |
---|
86 | <a target=\"_blank\" href=\"".$cat_names[$row['cat_id']]['dir'].$row['file']."\">".$row['file']."</td> |
---|
87 | </td> |
---|
88 | <td $style style=\"white-space:nowrap;\">"; |
---|
89 | if ( $row['tn_ext'] != "" ) |
---|
90 | { |
---|
91 | $file = substr ( $row['file'], 0, strrpos ( $row['file'], ".") ); |
---|
92 | echo "<a target=\"_blank\" href=\"".$cat_names[$row['cat_id']]['dir']."thumbnail/".$conf['prefixe_thumbnail'].$file.".".$row['tn_ext']."\">".$conf['prefixe_thumbnail'].$file.".".$row['tn_ext']; |
---|
93 | } |
---|
94 | else |
---|
95 | { |
---|
96 | echo " "; |
---|
97 | } |
---|
98 | echo " |
---|
99 | </td> |
---|
100 | <td $style style=\"white-space:nowrap;\"> |
---|
101 | <a href=\"mailto:".$row['mail_address']."\">".$row['username']."</a> |
---|
102 | </td> |
---|
103 | <td $style style=\"white-space:nowrap;\"> |
---|
104 | <input type=\"radio\" name=\"validate-".$row['id']."\" value=\"true\" />".$lang['submit']." |
---|
105 | <input type=\"radio\" name=\"validate-".$row['id']."\" value=\"false\" />".$lang['delete']." |
---|
106 | </td> |
---|
107 | </tr>"; |
---|
108 | $i++; |
---|
109 | } |
---|
110 | echo " |
---|
111 | <tr> |
---|
112 | <td colspan=\"5\" align=\"center\"><input type=\"submit\" name=\"submit\" value=\"".$lang['submit']."\" style=\"margin:5px;\" /></td> |
---|
113 | </tr>"; |
---|
114 | echo " |
---|
115 | </table> |
---|
116 | </form>"; |
---|
117 | ?> |
---|