Ignore:
Timestamp:
Jan 13, 2011, 4:24:18 PM (13 years ago)
Author:
plg
Message:

feature 2108 added: user upload removed from core. It will come back as a
"new generation" user upload in the Community plugin.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/site_update.php

    r8464 r8651  
    241241        'commentable' =>
    242242          boolean_to_string($conf['newcat_default_commentable']),
    243         'uploadable'  => $site_is_remote
    244           ? 'false'
    245           : boolean_to_string($conf['newcat_default_uploadable']),
    246243        'status'      => $conf['newcat_default_status'],
    247244        'visible'     => boolean_to_string($conf['newcat_default_visible']),
     
    313310      $dbfields = array(
    314311        'id','dir','name','site_id','id_uppercat','uppercats','commentable',
    315         'uploadable','visible','status','rank','global_rank'
     312        'visible','status','rank','global_rank'
    316313        );
    317314      mass_inserts(CATEGORIES_TABLE, $dbfields, $inserts);
     
    360357
    361358  $db_elements = array();
    362   $db_unvalidated = array();
    363359
    364360  if (count($cat_ids) > 0)
     
    374370        ).')';
    375371    $db_elements = simple_hash_from_query($query, 'id', 'path');
    376 
    377     // searching the unvalidated waiting elements (they must not be taken into
    378     // account)
    379     $query = '
    380 SELECT file,storage_category_id
    381   FROM '.WAITING_TABLE.'
    382   WHERE storage_category_id IN (
    383 '.wordwrap(implode(', ', $cat_ids), 80, "\n").')
    384     AND validated = \'false\'';
    385     $result = pwg_query($query);
    386     while ($row = pwg_db_fetch_assoc($result))
    387     {
    388       array_push(
    389         $db_unvalidated,
    390         array_search(
    391           $row['storage_category_id'],
    392           $db_fulldirs)
    393         .'/'.$row['file']
    394         );
    395     }
    396372  }
    397373
     
    404380  $insert_links = array();
    405381
    406   foreach (array_diff(array_keys($fs), $db_elements, $db_unvalidated) as $path)
     382  foreach (array_diff(array_keys($fs), $db_elements) as $path)
    407383  {
    408384    $insert = array();
     
    530506    . get_elapsed_time($start_files, get_moment())
    531507    . ' -->' );
    532 
    533   // retrieving informations given by uploaders
    534   if (!$simulate and count($cat_ids) > 0)
    535   {
    536     $query = '
    537 SELECT id,file,storage_category_id,infos
    538   FROM '.WAITING_TABLE.'
    539   WHERE storage_category_id IN (
    540 '.wordwrap(implode(', ', $cat_ids), 80, "\n").')
    541     AND validated = \'true\'';
    542     $result = pwg_query($query);
    543 
    544     $datas = array();
    545     $fields =
    546       array(
    547         'primary' => array('id'),
    548         'update'  => array('date_creation', 'author', 'name', 'comment')
    549         );
    550 
    551     $waiting_to_delete = array();
    552 
    553     while ($row = pwg_db_fetch_assoc($result))
    554     {
    555       $data = array();
    556 
    557       $query = '
    558 SELECT id
    559   FROM '.IMAGES_TABLE.'
    560   WHERE storage_category_id = '.$row['storage_category_id'].'
    561     AND file = \''.$row['file'].'\'';
    562       list($data['id']) = pwg_db_fetch_row(pwg_query($query));
    563 
    564       foreach ($fields['update'] as $field)
    565       {
    566         $data[$field] = addslashes( getAttribute($row['infos'], $field) );
    567       }
    568 
    569       array_push($datas, $data);
    570       array_push($waiting_to_delete, $row['id']);
    571     }
    572 
    573     if (count($datas) > 0)
    574     {
    575       mass_updates(IMAGES_TABLE, $fields, $datas);
    576 
    577       // delete now useless waiting elements
    578       $query = '
    579 DELETE
    580   FROM '.WAITING_TABLE.'
    581   WHERE id IN ('.implode(',', $waiting_to_delete).')
    582 ;';
    583       pwg_query($query);
    584     }
    585   }
    586508}
    587509
Note: See TracChangeset for help on using the changeset viewer.