Changeset 4325 for trunk/admin/site_update.php
- Timestamp:
- Nov 20, 2009, 3:17:04 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/site_update.php
r4265 r4325 44 44 FROM '.SITES_TABLE.' 45 45 WHERE id = '.$site_id; 46 list($site_url) = mysql_fetch_row(pwg_query($query));46 list($site_url) = pwg_db_fetch_row(pwg_query($query)); 47 47 if (!isset($site_url)) 48 48 { … … 51 51 $site_is_remote = url_is_remote($site_url); 52 52 53 list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));53 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 54 54 define('CURRENT_DATE', $dbnow); 55 55 … … 186 186 FROM '.CATEGORIES_TABLE; 187 187 $result = pwg_query($query); 188 while ($row = mysql_fetch_assoc($result))188 while ($row = pwg_db_fetch_assoc($result)) 189 189 { 190 190 $next_rank[$row['id']] = 1; … … 197 197 GROUP BY id_uppercat'; 198 198 $result = pwg_query($query); 199 while ($row = mysql_fetch_assoc($result))199 while ($row = pwg_db_fetch_assoc($result)) 200 200 { 201 201 // for the id_uppercat NULL, we write 'NULL' and not the empty string … … 211 211 SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_id 212 212 FROM '.CATEGORIES_TABLE; 213 list($next_id) = mysql_fetch_row(pwg_query($query));213 list($next_id) = pwg_db_fetch_row(pwg_query($query)); 214 214 215 215 // retrieve sub-directories fulldirs from the site reader … … 247 247 ? 'false' 248 248 : boolean_to_string($conf['newcat_default_uploadable']), 249 'status' => $conf {'newcat_default_status'},250 'visible' => boolean_to_string($conf {'newcat_default_visible'}),249 'status' => $conf['newcat_default_status'], 250 'visible' => boolean_to_string($conf['newcat_default_visible']), 251 251 ); 252 252 … … 255 255 $parent = $db_fulldirs[dirname($fulldir)]; 256 256 257 $insert {'id_uppercat'}= $parent;258 $insert {'uppercats'}=259 $db_categories[$parent]['uppercats'].','.$insert {'id'};260 $insert {'rank'}= $next_rank[$parent]++;261 $insert {'global_rank'}=262 $db_categories[$parent]['global_rank'].'.'.$insert {'rank'};257 $insert['id_uppercat'] = $parent; 258 $insert['uppercats'] = 259 $db_categories[$parent]['uppercats'].','.$insert['id']; 260 $insert['rank'] = $next_rank[$parent]++; 261 $insert['global_rank'] = 262 $db_categories[$parent]['global_rank'].'.'.$insert['rank']; 263 263 if ('private' == $db_categories[$parent]['status']) 264 264 { 265 $insert {'status'}= 'private';265 $insert['status'] = 'private'; 266 266 } 267 267 if ('false' == $db_categories[$parent]['visible']) 268 268 { 269 $insert {'visible'}= 'false';269 $insert['visible'] = 'false'; 270 270 } 271 271 } 272 272 else 273 273 { 274 $insert {'uppercats'} = $insert{'id'};274 $insert['uppercats'] = $insert['id']; 275 275 $insert{'rank'} = $next_rank['NULL']++; 276 $insert {'global_rank'} = $insert{'rank'};276 $insert['global_rank'] = $insert['rank']; 277 277 } 278 278 … … 289 289 $db_categories[$insert{'id'}] = 290 290 array( 291 'id' => $insert {'id'},292 'status' => $insert {'status'},293 'visible' => $insert {'visible'},294 'uppercats' => $insert {'uppercats'},295 'global_rank' => $insert {'global_rank'}291 'id' => $insert['id'], 292 'status' => $insert['status'], 293 'visible' => $insert['visible'], 294 'uppercats' => $insert['uppercats'], 295 'global_rank' => $insert['global_rank'] 296 296 ); 297 $db_fulldirs[$fulldir] = $insert {'id'};297 $db_fulldirs[$fulldir] = $insert['id']; 298 298 $next_rank[$insert{'id'}] = 1; 299 299 } … … 387 387 AND validated = \'false\''; 388 388 $result = pwg_query($query); 389 while ($row = mysql_fetch_assoc($result))389 while ($row = pwg_db_fetch_assoc($result)) 390 390 { 391 391 array_push( … … 403 403 SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id 404 404 FROM '.IMAGES_TABLE; 405 list($next_element_id) = mysql_fetch_row(pwg_query($query));405 list($next_element_id) = pwg_db_fetch_row(pwg_query($query)); 406 406 407 407 $start = get_moment(); … … 471 471 $insert_links, 472 472 array( 473 'image_id' => $insert {'id'},473 'image_id' => $insert['id'], 474 474 'category_id' => $insert['storage_category_id'], 475 475 ) … … 479 479 $infos, 480 480 array( 481 'path' => $insert {'path'},481 'path' => $insert['path'], 482 482 'info' => l10n('update_research_added') 483 483 ) … … 556 556 $waiting_to_delete = array(); 557 557 558 while ($row = mysql_fetch_assoc($result))558 while ($row = pwg_db_fetch_assoc($result)) 559 559 { 560 560 $data = array(); … … 565 565 WHERE storage_category_id = '.$row['storage_category_id'].' 566 566 AND file = \''.$row['file'].'\''; 567 list($data['id']) = mysql_fetch_row(pwg_query($query));567 list($data['id']) = pwg_db_fetch_row(pwg_query($query)); 568 568 569 569 foreach ($fields['update'] as $field)
Note: See TracChangeset
for help on using the changeset viewer.