Changeset 8651 for trunk/admin/site_update.php
- Timestamp:
- Jan 13, 2011, 4:24:18 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/site_update.php
r8464 r8651 241 241 'commentable' => 242 242 boolean_to_string($conf['newcat_default_commentable']), 243 'uploadable' => $site_is_remote244 ? 'false'245 : boolean_to_string($conf['newcat_default_uploadable']),246 243 'status' => $conf['newcat_default_status'], 247 244 'visible' => boolean_to_string($conf['newcat_default_visible']), … … 313 310 $dbfields = array( 314 311 'id','dir','name','site_id','id_uppercat','uppercats','commentable', 315 ' uploadable','visible','status','rank','global_rank'312 'visible','status','rank','global_rank' 316 313 ); 317 314 mass_inserts(CATEGORIES_TABLE, $dbfields, $inserts); … … 360 357 361 358 $db_elements = array(); 362 $db_unvalidated = array();363 359 364 360 if (count($cat_ids) > 0) … … 374 370 ).')'; 375 371 $db_elements = simple_hash_from_query($query, 'id', 'path'); 376 377 // searching the unvalidated waiting elements (they must not be taken into378 // account)379 $query = '380 SELECT file,storage_category_id381 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 }396 372 } 397 373 … … 404 380 $insert_links = array(); 405 381 406 foreach (array_diff(array_keys($fs), $db_elements , $db_unvalidated) as $path)382 foreach (array_diff(array_keys($fs), $db_elements) as $path) 407 383 { 408 384 $insert = array(); … … 530 506 . get_elapsed_time($start_files, get_moment()) 531 507 . ' -->' ); 532 533 // retrieving informations given by uploaders534 if (!$simulate and count($cat_ids) > 0)535 {536 $query = '537 SELECT id,file,storage_category_id,infos538 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 id559 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 elements578 $query = '579 DELETE580 FROM '.WAITING_TABLE.'581 WHERE id IN ('.implode(',', $waiting_to_delete).')582 ;';583 pwg_query($query);584 }585 }586 508 } 587 509
Note: See TracChangeset
for help on using the changeset viewer.