Ignore:
Timestamp:
Jun 17, 2010, 8:11:11 PM (14 years ago)
Author:
nikrou
Message:

Bug 1733 fixed : merge from trunk
single quotes in queries

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.1/admin/include/functions_permalinks.php

    r5207 r6551  
    2929  $query ='
    3030SELECT id FROM '.CATEGORIES_TABLE.'
    31   WHERE permalink="'.$permalink.'"';
     31  WHERE permalink=\''.$permalink.'\'';
    3232  $ids = array_from_query($query, 'id');
    3333  if (!empty($ids))
     
    7070SELECT permalink
    7171  FROM '.CATEGORIES_TABLE.'
    72   WHERE id="'.$cat_id.'"
     72  WHERE id=\''.$cat_id.'\'
    7373;';
    7474  $result = pwg_query($query);
     
    109109UPDATE '.OLD_PERMALINKS_TABLE.'
    110110  SET date_deleted=NOW()
    111   WHERE cat_id='.$cat_id.' AND permalink="'.$permalink.'"';
     111  WHERE cat_id='.$cat_id.' AND permalink=\''.$permalink.'\'';
    112112    }
    113113    else
     
    117117  (permalink, cat_id, date_deleted)
    118118VALUES
    119   ( "'.$permalink.'",'.$cat_id.',NOW() )';
     119  ( \''.$permalink.'\','.$cat_id.',NOW() )';
    120120    }
    121121    pwg_query( $query );
     
    186186    $query = '
    187187DELETE FROM '.OLD_PERMALINKS_TABLE.'
    188   WHERE cat_id='.$old_cat_id.' AND permalink="'.$permalink.'"';
     188  WHERE cat_id='.$old_cat_id.' AND permalink=\''.$permalink.'\'';
    189189    pwg_query($query);
    190190  }
     
    192192  $query = '
    193193UPDATE '.CATEGORIES_TABLE.'
    194   SET permalink="'.$permalink.'"
     194  SET permalink=\''.$permalink.'\'
    195195  WHERE id='.$cat_id;
    196196  //  LIMIT 1';
Note: See TracChangeset for help on using the changeset viewer.