Changeset 587 for trunk/admin/update.php


Ignore:
Timestamp:
Oct 30, 2004, 5:42:29 PM (20 years ago)
Author:
z0rglub
Message:
  • function mysql_query replaced by pwg_query : the same with debugging features
  • by default, DEBUG is set to 0 (off)
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/update.php

    r581 r587  
    5454  ORDER BY id_uppercat,rank,name
    5555;';
    56   $result = mysql_query($query);
     56  $result = pwg_query($query);
    5757  while ($row = mysql_fetch_array($result))
    5858  {
     
    6767  WHERE id = '.$row['id'].'
    6868;';
    69     mysql_query($query);
     69    pwg_query($query);
    7070  }
    7171}
     
    8585    $query.= ' WHERE id = '.$id_uppercat;
    8686    $query.= ';';
    87     $row = mysql_fetch_array( mysql_query( $query));
     87    $row = mysql_fetch_array( pwg_query( $query));
    8888    $uppercats = $row['uppercats'];
    8989    $name      = $row['name'];
     
    9999  WHERE id IN ('.$uppercats.')
    100100;';
    101     $result = mysql_query( $query);
     101    $result = pwg_query( $query);
    102102    while ($row = mysql_fetch_array($result))
    103103    {
     
    144144  $query.= '
    145145;';
    146   $result = mysql_query($query);
     146  $result = pwg_query($query);
    147147  while ($row = mysql_fetch_array($result))
    148148  {
     
    209209    $query.= '
    210210;';
    211     mysql_query($query);
     211    pwg_query($query);
    212212
    213213    $counts['new_categories']+= count($inserts);
     
    236236    $query.= '
    237237;';
    238     mysql_query($query);
     238    pwg_query($query);
    239239  }
    240240
     
    257257  $query.= '
    258258;';
    259   $result = mysql_query($query);
     259  $result = pwg_query($query);
    260260  while ($row = mysql_fetch_array($result))
    261261  {
     
    292292  WHERE storage_category_id = '.$category_id.'
    293293;';
    294   $result = mysql_query($query);
     294  $result = pwg_query($query);
    295295  while ($row = mysql_fetch_array($result))
    296296  {
     
    314314                     , $conf['picture_ext'])).')
    315315;';
    316   $result = mysql_query($query);
     316  $result = pwg_query($query);
    317317  while ($row = mysql_fetch_array($result))
    318318  {
     
    340340   WHERE storage_category_id = '.$category_id.'
    341341;';
    342   $result = mysql_query($query);
     342  $result = pwg_query($query);
    343343  while ($row = mysql_fetch_array($result))
    344344  {
     
    356356    AND validated = \'false\'
    357357;';
    358   $result = mysql_query($query);
     358  $result = pwg_query($query);
    359359  while ($row = mysql_fetch_array($result))
    360360  {
     
    505505;';
    506506
    507     mysql_query($query);
     507    pwg_query($query);
    508508
    509509    // what are the ids of the pictures in the $category_id ?
     
    515515  WHERE storage_category_id = '.$category_id.'
    516516;';
    517     $result = mysql_query($query);
     517    $result = pwg_query($query);
    518518    while ($row = mysql_fetch_array($result))
    519519    {
     
    528528    AND image_id IN ('.implode(',', $ids).')
    529529;';
    530     mysql_query($query);
     530    pwg_query($query);
    531531
    532532    foreach ($ids as $num => $image_id)
     
    539539  '.implode(',', $ids).'
    540540;';
    541     mysql_query($query);
     541    pwg_query($query);
    542542  }
    543543  return $output;
Note: See TracChangeset for help on using the changeset viewer.