Changeset 6551 for branches/2.1/admin/include/functions_permalinks.php
- Timestamp:
- Jun 17, 2010, 8:11:11 PM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/admin/include/functions_permalinks.php
r5207 r6551 29 29 $query =' 30 30 SELECT id FROM '.CATEGORIES_TABLE.' 31 WHERE permalink= "'.$permalink.'"';31 WHERE permalink=\''.$permalink.'\''; 32 32 $ids = array_from_query($query, 'id'); 33 33 if (!empty($ids)) … … 70 70 SELECT permalink 71 71 FROM '.CATEGORIES_TABLE.' 72 WHERE id= "'.$cat_id.'"72 WHERE id=\''.$cat_id.'\' 73 73 ;'; 74 74 $result = pwg_query($query); … … 109 109 UPDATE '.OLD_PERMALINKS_TABLE.' 110 110 SET date_deleted=NOW() 111 WHERE cat_id='.$cat_id.' AND permalink= "'.$permalink.'"';111 WHERE cat_id='.$cat_id.' AND permalink=\''.$permalink.'\''; 112 112 } 113 113 else … … 117 117 (permalink, cat_id, date_deleted) 118 118 VALUES 119 ( "'.$permalink.'",'.$cat_id.',NOW() )';119 ( \''.$permalink.'\','.$cat_id.',NOW() )'; 120 120 } 121 121 pwg_query( $query ); … … 186 186 $query = ' 187 187 DELETE FROM '.OLD_PERMALINKS_TABLE.' 188 WHERE cat_id='.$old_cat_id.' AND permalink= "'.$permalink.'"';188 WHERE cat_id='.$old_cat_id.' AND permalink=\''.$permalink.'\''; 189 189 pwg_query($query); 190 190 } … … 192 192 $query = ' 193 193 UPDATE '.CATEGORIES_TABLE.' 194 SET permalink= "'.$permalink.'"194 SET permalink=\''.$permalink.'\' 195 195 WHERE id='.$cat_id; 196 196 // LIMIT 1';
Note: See TracChangeset
for help on using the changeset viewer.