Changeset 520
- Timestamp:
- Sep 11, 2004, 12:36:03 PM (20 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 1 deleted
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/update.php
r498 r520 26 26 // +-----------------------------------------------------------------------+ 27 27 28 if( !defined("PHPWG_ROOT_PATH") ) 29 { 30 die ("Hacking attempt!"); 31 } 28 32 include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php'); 29 33 -
trunk/admin/waiting.php
r362 r520 25 25 // | USA. | 26 26 // +-----------------------------------------------------------------------+ 27 include_once( './admin/include/isadmin.inc.php' ); 27 if( !defined("PHPWG_ROOT_PATH") ) 28 { 29 die ("Hacking attempt!"); 30 } 31 include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php'); 28 32 //--------------------------------------------------------------------- updates 29 33 if ( isset( $_POST['submit'] ) ) 30 34 { 31 $query = 'SELECT id,storage_category_id,file,tn_ext'; 32 $query.= ' FROM '.PREFIX_TABLE.'waiting'; 33 $query.= " WHERE validated = 'false'"; 34 $query.= ';'; 35 $query = 'SELECT * FROM '.WAITING_TABLE; 36 $query.= " WHERE validated = 'false';"; 35 37 $result = mysql_query( $query ); 36 38 while ( $row = mysql_fetch_array( $result ) ) … … 43 45 // The uploaded element was validated, we have to set the 44 46 // "validated" field to "true" 45 $query = 'UPDATE '. PREFIX_TABLE.'waiting';47 $query = 'UPDATE '.WAITING_TABLE; 46 48 $query.= " SET validated = 'true'"; 47 49 $query.= ' WHERE id = '.$row['id']; … … 55 57 // The uploaded element was refused, we have to delete its reference 56 58 // in the database and to delete the element as well. 57 $query = 'DELETE FROM '. PREFIX_TABLE.'waiting';59 $query = 'DELETE FROM '.WAITING_TABLE; 58 60 $query.= ' WHERE id = '.$row['id']; 59 61 $query.= ';'; … … 67 69 $thumbnail.= get_filename_wo_extension( $row['file'] ); 68 70 $thumbnail.= '.'.$row['tn_ext']; 69 $url = '.'.$dir.'thumbnail/'.$thumbnail;71 $url = PHPWG_ROOT_PATH.$dir.'thumbnail/'.$thumbnail; 70 72 unlink( $url ); 71 73 } … … 74 76 } 75 77 } 78 76 79 //----------------------------------------------------- template initialization 77 $sub = $vtp->Open( './template/'.$user['template'].'/admin/waiting.vtp' ); 78 $tpl = array( 'category','date','author','thumbnail','file','delete', 79 'submit','waiting_update' ); 80 templatize_array( $tpl, 'lang', $sub ); 80 $template->set_filenames(array('waiting'=>'admin/waiting.tpl')); 81 $template->assign_vars(array( 82 'L_WAITING_CONFIRMATION'=>$lang['waiting_update'], 83 'L_AUTHOR'=>$lang['author'], 84 'L_THUMBNAIL'=>$lang['thumbnail'], 85 'L_DATE'=>$lang['date'], 86 'L_FILE'=>$lang['file'], 87 'L_CATEGORY'=>$lang['category'], 88 'L_SUBMIT'=>$lang['submit'], 89 'L_DELETE'=>$lang['delete'], 90 91 'F_ACTION'=>add_session_id(str_replace( '&', '&', $_SERVER['REQUEST_URI'] )) 92 )); 93 81 94 //-------------------------------------------------------- confirmation message 82 if ( isset( $_POST['submit'] ))95 if (isset($_POST['submit'])) 83 96 { 84 $vtp->addSession( $sub, 'confirmation' ); 85 $vtp->closeSession( $sub, 'confirmation' ); 97 $template->assign_block_vars('confirmation' ,array()); 86 98 } 87 99 //---------------------------------------------------------------- form display 88 100 $cat_names = array(); 89 $query = 'SELECT id,storage_category_id,file,username,mail_address'; 90 $query.= ',date,tn_ext'; 91 $query.= ' FROM '.PREFIX_TABLE.'waiting'; 101 $query = 'SELECT * FROM '.WAITING_TABLE; 92 102 $query.= " WHERE validated = 'false'"; 93 103 $query.= ' ORDER BY storage_category_id'; … … 97 107 while ( $row = mysql_fetch_array( $result ) ) 98 108 { 99 $vtp->addSession( $sub, 'picture' );100 $vtp->setVar( $sub, 'picture.id', $row['id'] );101 if ( $i++ % 2 == 0 )102 {103 $vtp->setVar( $sub, 'picture.class', 'row2' );104 }105 109 if ( !isset( $cat_names[$row['storage_category_id']] ) ) 106 110 { … … 108 112 $cat_names[$row['storage_category_id']] = array(); 109 113 $cat_names[$row['storage_category_id']]['dir'] = 110 '.'.get_complete_dir( $row['storage_category_id'] );114 PHPWG_ROOT_PATH.get_complete_dir( $row['storage_category_id'] ); 111 115 $cat_names[$row['storage_category_id']]['display_name'] = 112 116 get_cat_display_name( $cat['name'], ' > ', 'font-weight:bold;' ); 113 117 } 114 // category name 115 $vtp->setVar( $sub, 'picture.cat_name', 116 $cat_names[$row['storage_category_id']]['display_name'] ); 117 // date displayed like this (in English ) : 118 // Sunday 15 June 2003 21:29 119 $date = format_date( $row['date'], 'unix', true ); 120 $vtp->setVar( $sub, 'picture.date', $date ); 121 // file preview link 122 $url = $cat_names[$row['storage_category_id']]['dir'].$row['file']; 123 $vtp->setVar( $sub, 'picture.preview_url', $url ); 124 // file name 125 $vtp->setVar( $sub, 'picture.file', $row['file'] ); 118 $preview_url = PHPWG_ROOT_PATH.$cat_names[$row['storage_category_id']]['dir'].$row['file']; 119 $class='row1'; 120 if ( $i++ % 2== 0 ) $class='row2'; 121 122 $template->assign_block_vars('picture' ,array( 123 'WAITING_CLASS'=>$class, 124 'CATEGORY_IMG'=>$cat_names[$row['storage_category_id']]['display_name'], 125 'ID_IMG'=>$row['id'], 126 'DATE_IMG'=>format_date( $row['date'], 'unix', true ), 127 'FILE_IMG'=>$row['file'], 128 'PREVIEW_URL_IMG'=>$preview_url, 129 'UPLOAD_EMAIL'=>$row['mail_address'], 130 'UPLOAD_USERNAME'=>$row['username'] 131 )); 132 126 133 // is there an existing associated thumnail ? 127 if ( isset( $row['tn_ext'] ) and $row['tn_ext'] != '')134 if ( !empty( $row['tn_ext'] )) 128 135 { 129 $vtp->addSession( $sub, 'thumbnail' );130 136 $thumbnail = $conf['prefix_thumbnail']; 131 137 $thumbnail.= get_filename_wo_extension( $row['file'] ); 132 138 $thumbnail.= '.'.$row['tn_ext']; 133 139 $url = $cat_names[$row['storage_category_id']]['dir']; 134 140 $url.= 'thumbnail/'.$thumbnail; 135 $vtp->setVar( $sub, 'thumbnail.preview_url', $url ); 136 $vtp->setVar( $sub, 'thumbnail.file', $thumbnail ); 137 $vtp->closeSession( $sub, 'thumbnail' ); 141 142 $template->assign_block_vars('picture.thumbnail' ,array( 143 'PREVIEW_URL_TN_IMG'=>$url, 144 'FILE_TN_IMG'=>$thumbnail 145 )); 138 146 } 139 else140 {141 $vtp->addSession( $sub, 'no_thumbnail' );142 $vtp->closeSession( $sub, 'no_thumbnail' );143 }144 // username and associated mail address145 $vtp->setVar( $sub, 'picture.mail_address', $row['mail_address'] );146 $vtp->setVar( $sub, 'picture.username', $row['username'] );147 148 $vtp->closeSession( $sub, 'picture' );149 147 } 150 148 //----------------------------------------------------------- sending html code 151 $ vtp->Parse( $handle , 'sub', $sub);149 $template->assign_var_from_handle('ADMIN_CONTENT', 'waiting'); 152 150 ?> -
trunk/template/default/upload.tpl
r369 r520 1 <table style="width:100%;height:100%"> 2 <tr align="center" valign="middle"> 3 <td> 4 {T_START}1px{T_BEGIN} 5 <div class="titrePage">{L_TITLE}</div> 6 {T_END} 7 <div style="margin-bottom:5px;"> </div> 8 {T_START}50%{T_BEGIN} 9 <!-- BEGIN upload_not_successful --> 10 <form enctype="multipart/form-data" method="post" action="{F_ACTION}"> 11 <table style="width:80%;margin-left:auto;margin-right:auto;"> 12 <!-- BEGIN errors --> 13 <tr> 14 <td colspan="2"> 15 <div class="errors"> 16 <ul> 17 <!-- BEGIN error --> 18 <li>{upload_not_successful.errors.error.ERROR}</li> 19 <!-- END error --> 20 </ul> 21 </div> 22 </td> 23 </tr> 24 <!-- END errors --> 25 <tr> 26 <td colspan="2" class="menu"> 27 <div style="text-align:center;">{ADVISE_TITLE}</div> 28 <ul> 29 <!-- BEGIN advise --> 30 <li>{upload_not_successful.advise.ADVISE}</li> 31 <!-- END advise --> 32 </ul> 33 </td> 34 </tr> 35 <tr> 36 <td colspan="2" align="center" style="padding:10px;"> 37 <input name="picture" type="file" value="" /> 38 </td> 39 </tr> 40 <!-- BEGIN fields --> 41 <!-- username --> 42 <tr> 43 <td class="menu">{L_USERNAME} <span style="color:red;">*</span></td> 44 <td align="center" style="padding:10px;"> 45 <input name="username" type="text" value="{NAME}" /> 46 </td> 47 </tr> 48 <!-- mail address --> 49 <tr> 50 <td class="menu">{L_EMAIL} <span style="color:red;">*</span></td> 51 <td align="center" style="padding:10px;"> 52 <input name="mail_address" type="text" value="{EMAIL}" /> 53 </td> 54 </tr> 55 <!-- name of the picture --> 56 <tr> 57 <td class="menu">{L_NAME_IMG}</td> 58 <td align="center" style="padding:10px;"> 59 <input name="name" type="text" value="{NAME_IMG}" /> 60 </td> 61 </tr> 62 <!-- author --> 63 <tr> 64 <td class="menu">{L_AUTHOR}</td> 65 <td align="center" style="padding:10px;"> 66 <input name="author" type="text" value="{AUTHOR_IMG}" /> 67 </td> 68 </tr> 69 <!-- date of creation --> 70 <tr> 71 <td class="menu">{L_CREATION_DATE}</td> 72 <td align="center" style="padding:10px;"> 73 <input name="date_creation" type="text" value="{DATE_IMG}" /> 74 </td> 75 </tr> 76 <!-- comment --> 77 <tr> 78 <td class="menu">{L_COMMENT}</td> 79 <td align="center" style="padding:10px;"> 80 <textarea name="comment" rows="3" cols="40" style="overflow:auto">{COMMENT_IMG}</textarea> 81 </td> 82 </tr> 83 <!-- END fields --> 84 <tr> 85 <td colspan="2" align="center"> 86 <input name="submit" type="submit" value="{L_SUBMIT}" /> 87 </td> 88 </tr> 89 </table> 90 </form> 91 <!-- END upload_not_successful --> 92 <!-- BEGIN upload_successful --> 93 {L_UPLOAD_DONE}<br /> 94 <!-- END upload_successful --> 95 <div style="text-align:center;"> 96 <a href="{U_RETURN}">[ {L_RETURN} ]</a> 97 </div> 98 <!-- BEGIN note --> 99 <div style="text-align:left;"><span style="color:red;">*</span> : {L_MANDATORY}</div> 100 <!-- END note --> 101 {T_END} 102 </td> 103 </tr> 104 </table> 1 <div class="titrePage">{L_TITLE}</div> 2 <!-- BEGIN upload_not_successful --> 3 <form enctype="multipart/form-data" method="post" action="{F_ACTION}"> 4 <table style="width:80%;margin-left:auto;margin-right:auto;"> 5 <!-- BEGIN errors --> 6 <tr> 7 <td colspan="2"> 8 <div class="errors"> 9 <ul> 10 <!-- BEGIN error --> 11 <li>{upload_not_successful.errors.error.ERROR}</li> 12 <!-- END error --> 13 </ul> 14 </div> 15 </td> 16 </tr> 17 <!-- END errors --> 18 <tr> 19 <td colspan="2" class="menu"> 20 <div style="text-align:center;">{ADVISE_TITLE}</div> 21 <ul> 22 <!-- BEGIN advise --> 23 <li>{upload_not_successful.advise.ADVISE}</li> 24 <!-- END advise --> 25 </ul> 26 </td> 27 </tr> 28 <tr> 29 <td colspan="2" align="center" style="padding:10px;"> 30 <input name="picture" type="file" value="" /> 31 </td> 32 </tr> 33 <!-- BEGIN fields --> 34 <!-- username --> 35 <tr> 36 <td class="menu">{L_USERNAME} <span style="color:red;">*</span></td> 37 <td align="center" style="padding:10px;"> 38 <input name="username" type="text" value="{NAME}" /> 39 </td> 40 </tr> 41 <!-- mail address --> 42 <tr> 43 <td class="menu">{L_EMAIL} <span style="color:red;">*</span></td> 44 <td align="center" style="padding:10px;"> 45 <input name="mail_address" type="text" value="{EMAIL}" /> 46 </td> 47 </tr> 48 <!-- name of the picture --> 49 <tr> 50 <td class="menu">{L_NAME_IMG}</td> 51 <td align="center" style="padding:10px;"> 52 <input name="name" type="text" value="{NAME_IMG}" /> 53 </td> 54 </tr> 55 <!-- author --> 56 <tr> 57 <td class="menu">{L_AUTHOR}</td> 58 <td align="center" style="padding:10px;"> 59 <input name="author" type="text" value="{AUTHOR_IMG}" /> 60 </td> 61 </tr> 62 <!-- date of creation --> 63 <tr> 64 <td class="menu">{L_CREATION_DATE}</td> 65 <td align="center" style="padding:10px;"> 66 <input name="date_creation" type="text" value="{DATE_IMG}" /> 67 </td> 68 </tr> 69 <!-- comment --> 70 <tr> 71 <td class="menu">{L_COMMENT}</td> 72 <td align="center" style="padding:10px;"> 73 <textarea name="comment" rows="3" cols="40" style="overflow:auto">{COMMENT_IMG}</textarea> 74 </td> 75 </tr> 76 <!-- END fields --> 77 <tr> 78 <td colspan="2" align="center"> 79 <input name="submit" type="submit" value="{L_SUBMIT}" class="bouton" /> 80 </td> 81 </tr> 82 </table> 83 </form> 84 <!-- END upload_not_successful --> 85 <!-- BEGIN upload_successful --> 86 {L_UPLOAD_DONE}<br /> 87 <!-- END upload_successful --> 88 <div style="text-align:center;"> 89 <a href="{U_RETURN}">[ {L_RETURN} ]</a> 90 </div> 91 <!-- BEGIN note --> 92 <div style="text-align:left;"><span style="color:red;">*</span> : {L_MANDATORY}</div> 93 <!-- END note --> -
trunk/upload.php
r488 r520 261 261 include(PHPWG_ROOT_PATH.'include/page_header.php'); 262 262 $template->set_filenames(array('upload'=>'upload.tpl')); 263 initialize_template(); 264 265 $u_form = PHPWG_ROOT_PATH.'upload.php?cat='.$page['cat'].'&expand='.$_GET['expand']; 263 264 $u_form = PHPWG_ROOT_PATH.'upload.php?cat='.$page['cat']; 266 265 if ( isset( $page['waiting_id'] ) ) 267 266 {
Note: See TracChangeset
for help on using the changeset viewer.