Ignore:
Timestamp:
Nov 20, 2009, 3:17:04 PM (14 years ago)
Author:
nikrou
Message:

Feature 1244 resolved
Replace all mysql functions in core code by ones independant of database engine

Fix small php code synxtax : hash must be accessed with [ ] and not { }.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/site_update.php

    r4265 r4325  
    4444  FROM '.SITES_TABLE.'
    4545  WHERE id = '.$site_id;
    46 list($site_url) = mysql_fetch_row(pwg_query($query));
     46list($site_url) = pwg_db_fetch_row(pwg_query($query));
    4747if (!isset($site_url))
    4848{
     
    5151$site_is_remote = url_is_remote($site_url);
    5252
    53 list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
     53list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
    5454define('CURRENT_DATE', $dbnow);
    5555
     
    186186  FROM '.CATEGORIES_TABLE;
    187187  $result = pwg_query($query);
    188   while ($row = mysql_fetch_assoc($result))
     188  while ($row = pwg_db_fetch_assoc($result))
    189189  {
    190190    $next_rank[$row['id']] = 1;
     
    197197  GROUP BY id_uppercat';
    198198  $result = pwg_query($query);
    199   while ($row = mysql_fetch_assoc($result))
     199  while ($row = pwg_db_fetch_assoc($result))
    200200  {
    201201    // for the id_uppercat NULL, we write 'NULL' and not the empty string
     
    211211SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_id
    212212  FROM '.CATEGORIES_TABLE;
    213   list($next_id) = mysql_fetch_row(pwg_query($query));
     213  list($next_id) = pwg_db_fetch_row(pwg_query($query));
    214214
    215215  // retrieve sub-directories fulldirs from the site reader
     
    247247          ? 'false'
    248248          : 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']),
    251251        );
    252252
     
    255255        $parent = $db_fulldirs[dirname($fulldir)];
    256256
    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'];
    263263        if ('private' == $db_categories[$parent]['status'])
    264264        {
    265           $insert{'status'} = 'private';
     265          $insert['status'] = 'private';
    266266        }
    267267        if ('false' == $db_categories[$parent]['visible'])
    268268        {
    269           $insert{'visible'} = 'false';
     269          $insert['visible'] = 'false';
    270270        }
    271271      }
    272272      else
    273273      {
    274         $insert{'uppercats'} = $insert{'id'};
     274        $insert['uppercats'] = $insert['id'];
    275275        $insert{'rank'} = $next_rank['NULL']++;
    276         $insert{'global_rank'} = $insert{'rank'};
     276        $insert['global_rank'] = $insert['rank'];
    277277      }
    278278
     
    289289      $db_categories[$insert{'id'}] =
    290290        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']
    296296          );
    297       $db_fulldirs[$fulldir] = $insert{'id'};
     297      $db_fulldirs[$fulldir] = $insert['id'];
    298298      $next_rank[$insert{'id'}] = 1;
    299299    }
     
    387387    AND validated = \'false\'';
    388388    $result = pwg_query($query);
    389     while ($row = mysql_fetch_assoc($result))
     389    while ($row = pwg_db_fetch_assoc($result))
    390390    {
    391391      array_push(
     
    403403SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id
    404404  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));
    406406
    407407  $start = get_moment();
     
    471471        $insert_links,
    472472        array(
    473           'image_id'    => $insert{'id'},
     473          'image_id'    => $insert['id'],
    474474          'category_id' => $insert['storage_category_id'],
    475475          )
     
    479479        $infos,
    480480        array(
    481           'path' => $insert{'path'},
     481          'path' => $insert['path'],
    482482          'info' => l10n('update_research_added')
    483483          )
     
    556556    $waiting_to_delete = array();
    557557
    558     while ($row = mysql_fetch_assoc($result))
     558    while ($row = pwg_db_fetch_assoc($result))
    559559    {
    560560      $data = array();
     
    565565  WHERE storage_category_id = '.$row['storage_category_id'].'
    566566    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));
    568568
    569569      foreach ($fields['update'] as $field)
Note: See TracChangeset for help on using the changeset viewer.