Changeset 6551 for branches/2.1
- Timestamp:
- Jun 17, 2010, 8:11:11 PM (14 years ago)
- Location:
- branches/2.1/admin
- Files:
-
- 9 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/admin/cat_modify.php
r6364 r6551 93 93 { 94 94 $query = ' 95 UPDATE '.CATEGORIES_TABLE.' SET image_order='.(isset($image_order) ? 'NULL': "'$image_order'").'96 WHERE uppercats LIKE "'.$cat_info['uppercats'].',%"';95 UPDATE '.CATEGORIES_TABLE.' SET image_order='.(isset($image_order) ? 'NULL':'\''.$image_order.'\'').' 96 WHERE uppercats LIKE \''.$cat_info['uppercats'].',%\''; 97 97 pwg_query($query); 98 98 } -
branches/2.1/admin/extend_for_templates.php
r6364 r6551 140 140 $tpl_extension = $replacements; 141 141 /* ecrire la nouvelle conf */ 142 $query = "143 UPDATE ".CONFIG_TABLE."144 SET value = '". $conf['extents_for_templates'] ."'145 WHERE param = 'extents_for_templates';";142 $query = ' 143 UPDATE '.CONFIG_TABLE.' 144 SET value = \''. $conf['extents_for_templates'] .'\' 145 WHERE param = \'extents_for_templates\';'; 146 146 if (pwg_query($query)) 147 147 { -
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'; -
branches/2.1/admin/include/functions_upgrade.php
r6131 r6551 88 88 FROM '.PREFIX_TABLE.'plugins 89 89 WHERE state = "active" 90 AND id NOT IN ( "' . implode('","', $standard_plugins) . '")90 AND id NOT IN (\'' . implode('\',\'', $standard_plugins) . '\') 91 91 ;'; 92 92 … … 103 103 UPDATE '.PREFIX_TABLE.'plugins 104 104 SET state="inactive" 105 WHERE id IN ( "' . implode('","', $plugins) . '")105 WHERE id IN (\'' . implode('\',\'', $plugins) . '\') 106 106 ;'; 107 107 pwg_query($query); … … 163 163 SELECT password, status 164 164 FROM '.USERS_TABLE.' 165 WHERE username = "'.$username.'"165 WHERE username = \''.$username.'\' 166 166 ;'; 167 167 } … … 173 173 INNER JOIN '.USER_INFOS_TABLE.' AS ui 174 174 ON u.'.$conf['user_fields']['id'].'=ui.user_id 175 WHERE '.$conf['user_fields']['username'].'= "'.$username.'"175 WHERE '.$conf['user_fields']['username'].'=\''.$username.'\' 176 176 ;'; 177 177 } -
branches/2.1/admin/include/languages.class.php
r6356 r6551 100 100 } 101 101 102 $query = "102 $query = ' 103 103 DELETE 104 FROM ".LANGUAGES_TABLE."105 WHERE id= '".$language_id."'106 ; ";104 FROM '.LANGUAGES_TABLE.' 105 WHERE id= \''.$language_id.'\' 106 ;'; 107 107 pwg_query($query); 108 108 break; … … 123 123 $query = ' 124 124 UPDATE '.USER_INFOS_TABLE.' 125 SET language = "'.get_default_language().'"126 WHERE language = "'.$language_id.'"125 SET language = \''.get_default_language().'\' 126 WHERE language = \''.$language_id.'\' 127 127 ;'; 128 128 pwg_query($query); … … 137 137 $query = ' 138 138 UPDATE '.USER_INFOS_TABLE.' 139 SET language = "'.$language_id.'"139 SET language = \''.$language_id.'\' 140 140 WHERE user_id = '.$conf['default_user_id'].' 141 141 ;'; -
branches/2.1/admin/include/themes.class.php
r6545 r6551 176 176 } 177 177 178 $query = "178 $query = ' 179 179 DELETE 180 FROM ".THEMES_TABLE."181 WHERE id= '".$theme_id."'182 ; ";180 FROM '.THEMES_TABLE.' 181 WHERE id= \''.$theme_id.'\' 182 ;'; 183 183 pwg_query($query); 184 184 break; … … 301 301 if (!empty($id)) 302 302 { 303 $clauses[] = "id = '".$id."'";303 $clauses[] = 'id = \''.$id.'\''; 304 304 } 305 305 if (count($clauses) > 0) -
branches/2.1/admin/languages_installed.php
r6364 r6551 115 115 $query = ' 116 116 UPDATE '.USER_INFOS_TABLE.' 117 SET language = "'.get_default_language().'"118 WHERE language = "'.$language_id.'"117 SET language = \''.get_default_language().'\' 118 WHERE language = \''.$language_id.'\' 119 119 ;'; 120 120 pwg_query($query); 121 121 122 $query = "122 $query = ' 123 123 DELETE 124 FROM ".LANGUAGES_TABLE."125 WHERE id= '".$language_id."'126 ; ";124 FROM '.LANGUAGES_TABLE.' 125 WHERE id= \''.$language_id.'\' 126 ;'; 127 127 pwg_query($query); 128 128 } -
branches/2.1/admin/permalinks.php
r6364 r6551 97 97 $query = ' 98 98 DELETE FROM '.OLD_PERMALINKS_TABLE.' 99 WHERE permalink= "'.$_GET['delete_permanent'].'"99 WHERE permalink=\''.$_GET['delete_permanent'].'\' 100 100 LIMIT 1'; 101 101 $result = pwg_query($query); -
branches/2.1/admin/thumbnail.php
r6364 r6551 184 184 $query = ' 185 185 SELECT galleries_url FROM '.SITES_TABLE.' 186 WHERE galleries_url NOT LIKE "http://%"186 WHERE galleries_url NOT LIKE \'http://%\' 187 187 ;'; 188 188 $result = pwg_query($query);
Note: See TracChangeset
for help on using the changeset viewer.