thorsten /
phpMyFAQ
| @@ 1138-1159 (lines=22) @@ | ||
| 1135 | array('faqcategory_user' => 'category_id')); |
|
| 1136 | ||
| 1137 | $result = true; |
|
| 1138 | foreach ($tables as $pair) { |
|
| 1139 | foreach ($pair as $_table => $_field) { |
|
| 1140 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = %d WHERE %s = %d", |
|
| 1141 | PMF_Db::getTablePrefix().$_table, |
|
| 1142 | $_field, |
|
| 1143 | $temp_cat, |
|
| 1144 | $_field, |
|
| 1145 | $category_id_2)); |
|
| 1146 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = %d WHERE %s = %d", |
|
| 1147 | PMF_Db::getTablePrefix().$_table, |
|
| 1148 | $_field, |
|
| 1149 | $category_id_2, |
|
| 1150 | $_field, |
|
| 1151 | $category_id_1)); |
|
| 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_1, |
|
| 1156 | $_field, |
|
| 1157 | $temp_cat)); |
|
| 1158 | } |
|
| 1159 | } |
|
| 1160 | ||
| 1161 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1162 | ||
| @@ 1163-1184 (lines=22) @@ | ||
| 1160 | ||
| 1161 | $tables2 = array(array('faqquestions' => 'category_id')); |
|
| 1162 | ||
| 1163 | foreach ($tables2 as $pair) { |
|
| 1164 | foreach ($pair as $_table => $_field) { |
|
| 1165 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1166 | PMF_Db::getTablePrefix().$_table, |
|
| 1167 | $_field, |
|
| 1168 | $temp_cat, |
|
| 1169 | $_field, |
|
| 1170 | $category_id_2)); |
|
| 1171 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1172 | PMF_Db::getTablePrefix().$_table, |
|
| 1173 | $_field, |
|
| 1174 | $category_id_2, |
|
| 1175 | $_field, |
|
| 1176 | $category_id_1)); |
|
| 1177 | $result = $result && $this->_config->getDb()->query(sprintf("UPDATE %s SET %s = '%d' WHERE %s = '%d'", |
|
| 1178 | PMF_Db::getTablePrefix().$_table, |
|
| 1179 | $_field, |
|
| 1180 | $category_id_1, |
|
| 1181 | $_field, |
|
| 1182 | $temp_cat)); |
|
| 1183 | } |
|
| 1184 | } |
|
| 1185 | ||
| 1186 | return $result; |
|
| 1187 | } |
|
