thorsten /
phpMyFAQ
| @@ 1119-1140 (lines=22) @@ | ||
| 1116 | array('faqcategory_user' => 'category_id')); |
|
| 1117 | ||
| 1118 | $result = true; |
|
| 1119 | foreach ($tables as $pair) { |
|
| 1120 | foreach ($pair as $_table => $_field) { |
|
| 1121 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = %d WHERE %s = %d", |
|
| 1122 | PMF_Db::getTablePrefix().$_table, |
|
| 1123 | $_field, |
|
| 1124 | $temp_cat, |
|
| 1125 | $_field, |
|
| 1126 | $category_id_2)); |
|
| 1127 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = %d WHERE %s = %d", |
|
| 1128 | PMF_Db::getTablePrefix().$_table, |
|
| 1129 | $_field, |
|
| 1130 | $category_id_2, |
|
| 1131 | $_field, |
|
| 1132 | $category_id_1)); |
|
| 1133 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = %d WHERE %s = %d", |
|
| 1134 | PMF_Db::getTablePrefix().$_table, |
|
| 1135 | $_field, |
|
| 1136 | $category_id_1, |
|
| 1137 | $_field, |
|
| 1138 | $temp_cat)); |
|
| 1139 | } |
|
| 1140 | } |
|
| 1141 | ||
| 1142 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1143 | ||
| @@ 1144-1165 (lines=22) @@ | ||
| 1141 | ||
| 1142 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1143 | ||
| 1144 | foreach ($tables2 as $pair) { |
|
| 1145 | foreach ($pair as $_table => $_field) { |
|
| 1146 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1147 | PMF_Db::getTablePrefix().$_table, |
|
| 1148 | $_field, |
|
| 1149 | $temp_cat, |
|
| 1150 | $_field, |
|
| 1151 | $category_id_2)); |
|
| 1152 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1153 | PMF_Db::getTablePrefix().$_table, |
|
| 1154 | $_field, |
|
| 1155 | $category_id_2, |
|
| 1156 | $_field, |
|
| 1157 | $category_id_1)); |
|
| 1158 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1159 | PMF_Db::getTablePrefix().$_table, |
|
| 1160 | $_field, |
|
| 1161 | $category_id_1, |
|
| 1162 | $_field, |
|
| 1163 | $temp_cat)); |
|
| 1164 | } |
|
| 1165 | } |
|
| 1166 | ||
| 1167 | return $result; |
|
| 1168 | } |
|
