Changeset 520 for trunk/admin
- Timestamp:
- Sep 11, 2004, 12:36:03 PM (20 years ago)
- Location:
- trunk/admin
- Files:
-
- 2 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 ?>
Note: See TracChangeset
for help on using the changeset viewer.