thorsten /
phpMyFAQ
| @@ 1227-1248 (lines=22) @@ | ||
| 1224 | array('faqcategory_user' => 'category_id'), ); |
|
| 1225 | ||
| 1226 | $result = true; |
|
| 1227 | foreach ($tables as $pair) { |
|
| 1228 | foreach ($pair as $_table => $_field) { |
|
| 1229 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1230 | PMF_Db::getTablePrefix().$_table, |
|
| 1231 | $_field, |
|
| 1232 | $temp_cat, |
|
| 1233 | $_field, |
|
| 1234 | $category_id_2)); |
|
| 1235 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1236 | PMF_Db::getTablePrefix().$_table, |
|
| 1237 | $_field, |
|
| 1238 | $category_id_2, |
|
| 1239 | $_field, |
|
| 1240 | $category_id_1)); |
|
| 1241 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1242 | PMF_Db::getTablePrefix().$_table, |
|
| 1243 | $_field, |
|
| 1244 | $category_id_1, |
|
| 1245 | $_field, |
|
| 1246 | $temp_cat)); |
|
| 1247 | } |
|
| 1248 | } |
|
| 1249 | ||
| 1250 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1251 | ||
| @@ 1252-1273 (lines=22) @@ | ||
| 1249 | ||
| 1250 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1251 | ||
| 1252 | foreach ($tables2 as $pair) { |
|
| 1253 | foreach ($pair as $_table => $_field) { |
|
| 1254 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1255 | PMF_Db::getTablePrefix().$_table, |
|
| 1256 | $_field, |
|
| 1257 | $temp_cat, |
|
| 1258 | $_field, |
|
| 1259 | $category_id_2)); |
|
| 1260 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1261 | PMF_Db::getTablePrefix().$_table, |
|
| 1262 | $_field, |
|
| 1263 | $category_id_2, |
|
| 1264 | $_field, |
|
| 1265 | $category_id_1)); |
|
| 1266 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1267 | PMF_Db::getTablePrefix().$_table, |
|
| 1268 | $_field, |
|
| 1269 | $category_id_1, |
|
| 1270 | $_field, |
|
| 1271 | $temp_cat)); |
|
| 1272 | } |
|
| 1273 | } |
|
| 1274 | ||
| 1275 | return $result; |
|
| 1276 | } |
|
