thorsten /
phpMyFAQ
| @@ 1250-1271 (lines=22) @@ | ||
| 1247 | array('faqcategory_user' => 'category_id'), ); |
|
| 1248 | ||
| 1249 | $result = true; |
|
| 1250 | foreach ($tables as $pair) { |
|
| 1251 | foreach ($pair as $_table => $_field) { |
|
| 1252 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1253 | PMF_Db::getTablePrefix().$_table, |
|
| 1254 | $_field, |
|
| 1255 | $temp_cat, |
|
| 1256 | $_field, |
|
| 1257 | $category_id_2)); |
|
| 1258 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1259 | PMF_Db::getTablePrefix().$_table, |
|
| 1260 | $_field, |
|
| 1261 | $category_id_2, |
|
| 1262 | $_field, |
|
| 1263 | $category_id_1)); |
|
| 1264 | $result = $result && $this->_config->getDb()->query(sprintf('UPDATE %s SET %s = %d WHERE %s = %d', |
|
| 1265 | PMF_Db::getTablePrefix().$_table, |
|
| 1266 | $_field, |
|
| 1267 | $category_id_1, |
|
| 1268 | $_field, |
|
| 1269 | $temp_cat)); |
|
| 1270 | } |
|
| 1271 | } |
|
| 1272 | ||
| 1273 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1274 | ||
| @@ 1275-1296 (lines=22) @@ | ||
| 1272 | ||
| 1273 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1274 | ||
| 1275 | foreach ($tables2 as $pair) { |
|
| 1276 | foreach ($pair as $_table => $_field) { |
|
| 1277 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1278 | PMF_Db::getTablePrefix().$_table, |
|
| 1279 | $_field, |
|
| 1280 | $temp_cat, |
|
| 1281 | $_field, |
|
| 1282 | $category_id_2)); |
|
| 1283 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1284 | PMF_Db::getTablePrefix().$_table, |
|
| 1285 | $_field, |
|
| 1286 | $category_id_2, |
|
| 1287 | $_field, |
|
| 1288 | $category_id_1)); |
|
| 1289 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1290 | PMF_Db::getTablePrefix().$_table, |
|
| 1291 | $_field, |
|
| 1292 | $category_id_1, |
|
| 1293 | $_field, |
|
| 1294 | $temp_cat)); |
|
| 1295 | } |
|
| 1296 | } |
|
| 1297 | ||
| 1298 | return $result; |
|
| 1299 | } |
|
