Changeset 19775 for extensions/File_Uploader/admin/admin_upload.php

Timestamp:

Jan 4, 2013, 12:31:23 AM (11 years ago)

Author:

julien1311

Message:

some bug fixes/improvements
still buggy

File:

• extensions/File_Uploader/admin/admin_upload.php (modified) (6 diffs)

extensions/File_Uploader/admin/admin_upload.php

@@ -37 +37 @@
 
 function file_uploader_upload_file($file_uploader_file) {
-        include('static.inc.php');
+        include_once(dirname(__FILE__).'/install/config_default.inc.php');
         
         global $conf;
@@ -69 +69 @@
                 if(!mkdir($file_uploader_file_directory_full))
                         $file_uploader_errors['upload_error'] = l10n('Unable to create folder ').$file_uploader_file_directory_full;
-        //If the physical category si not in database, we add it
-        if (pwg_db_num_rows(pwg_query('SELECT id FROM '.CATEGORIES_TABLE.' WHERE name = "'.$file_uploader_file_category.'";')) == 0){
-                $next_id = pwg_db_nextval('id', CATEGORIES_TABLE);
-                $category_rank = pwg_db_fetch_assoc(pwg_query('SELECT MAX(rank) FROM '.CATEGORIES_TABLE.';'));
-                $category_rank = $category_rank['MAX(rank)'] + 1;
-                pwg_query('INSERT INTO '.CATEGORIES_TABLE.' (id, name, dir, rank, status, visible, uppercats, global_rank) VALUES ('.$next_id.', "'.$file_uploader_file_category.'", "'.$file_uploader_file_category.'", '.$category_rank.', "'.$conf['newcat_default_status'].'", "'.boolean_to_string($conf['newcat_default_visible']).'", "'.$next_id.'", '.$category_rank.');');
-        }
+                //If the physical category si not in database, we add it
+                else if (pwg_db_num_rows(pwg_query('SELECT id FROM '.CATEGORIES_TABLE.' WHERE name = "'.$file_uploader_file_category.'";')) == 0){
+                        $next_id = pwg_db_nextval('id', CATEGORIES_TABLE);
+                        $category_rank = pwg_db_fetch_assoc(pwg_query('SELECT MAX(rank) FROM '.CATEGORIES_TABLE.';'));
+                        $category_rank = $category_rank['MAX(rank)'] + 1;
+                        $file_uploader_physical_category_id = pwg_db_fetch_assoc(pwg_query('SELECT id FROM '.CATEGORIES_TABLE.' WHERE name = "'.$file_uploader_galleries_folder.'";'));
+                        pwg_query('INSERT INTO '.CATEGORIES_TABLE.' (id, name, dir, rank, status, visible, uppercats, global_rank, site_id) VALUES ('.$next_id.', "'.$file_uploader_file_category.'", "'.$file_uploader_file_category.'", '.$category_rank.', "private", "'.boolean_to_string($conf['newcat_default_visible']).'", "'.$file_uploader_physical_category_id.'", '.$category_rank.', 1);');
+                }
         
         if ($file_uploader_file['error'] !== UPLOAD_ERR_OK) {
@@ -116 +117 @@
 
 function file_uploader_upload_thumbnail($file_uploader_thumbnail, $file_uploader_file_name_wo_extension, $file_uploader_file_extension, $file_uploader_file_folder) {
-        include('static.inc.php');
+        include_once(dirname(__FILE__).'/install/config_default.inc.php');
         
         $file_uploader_thumbnail_tmp = $file_uploader_thumbnail['tmp_name'];
@@ -175 +176 @@
         //Database registration
         $file_path = pwg_db_real_escape_string($file_uploader_file['destination']);
+        $physical_category_id = pwg_db_fetch_assoc(pwg_query('SELECT id FROM '.CATEGORIES_TABLE.' WHERE name = "'.$file_uploader_file['folder'].'";'));
         $insert = array(
                 'file' => substr(strrchr($file_path, '/'), 1),
@@ -183 +185 @@
                 'representative_ext' => $file_uploader_thumbnail['extension'],
                 'filesize' => $file_uploader_file['size'],
+                'storage_category_id' => $physical_category_id,
                 'md5sum' => md5_file($file_path),
                 'added_by' => $user['id'],
@@ -195 +198 @@
                 $image_id = pwg_db_insert_id(IMAGES_TABLE);
         }
-
-        $physical_category_id = pwg_db_fetch_assoc(pwg_query('SELECT id FROM '.CATEGORIES_TABLE.' WHERE name = "'.$file_uploader_file['folder'].'";'));
         
         if(isset($file_uploader_file_properties['category']) and count($file_uploader_file_properties['category']) > 0) {