domainmod /
domainmod
| @@ 133-185 (lines=53) @@ | ||
| 130 | WHERE fee_fixed = '0'"); |
|
| 131 | $result = $tmpq->fetchAll(); |
|
| 132 | ||
| 133 | if ($result) { |
|
| 134 | ||
| 135 | $tmpq = $this->system->db()->prepare(" |
|
| 136 | UPDATE domains |
|
| 137 | SET fee_id = :id |
|
| 138 | WHERE registrar_id = :registrar_id |
|
| 139 | AND tld = :tld |
|
| 140 | AND fee_fixed = '0'"); |
|
| 141 | ||
| 142 | $tmpq2 = $this->system->db()->prepare(" |
|
| 143 | UPDATE domains d |
|
| 144 | JOIN fees f ON d.fee_id = f.id |
|
| 145 | SET d.fee_fixed = '1', |
|
| 146 | d.total_cost = f.renewal_fee + f.privacy_fee + f.misc_fee |
|
| 147 | WHERE d.registrar_id = :registrar_id |
|
| 148 | AND d.tld = :tld |
|
| 149 | AND d.privacy = '1'"); |
|
| 150 | ||
| 151 | $tmpq3 = $this->system->db()->prepare(" |
|
| 152 | UPDATE domains d |
|
| 153 | JOIN fees f ON d.fee_id = f.id |
|
| 154 | SET d.fee_fixed = '1', |
|
| 155 | d.total_cost = f.renewal_fee + f.misc_fee |
|
| 156 | WHERE d.registrar_id = :registrar_id |
|
| 157 | AND d.tld = :tld |
|
| 158 | AND d.privacy = '0'"); |
|
| 159 | ||
| 160 | $tmpq4 = $this->system->db()->prepare(" |
|
| 161 | UPDATE fees |
|
| 162 | SET fee_fixed = '1', |
|
| 163 | update_time = :update_time |
|
| 164 | WHERE registrar_id = :registrar_id |
|
| 165 | AND tld = :tld"); |
|
| 166 | ||
| 167 | foreach ($result as $row) { |
|
| 168 | ||
| 169 | $tmpq->execute(array( |
|
| 170 | 'id' => $row->id, |
|
| 171 | 'registrar_id' => $row->registrar_id, |
|
| 172 | 'tld' => $row->tld)); |
|
| 173 | ||
| 174 | $tmpq2->execute(array( |
|
| 175 | 'registrar_id' => $row->registrar_id, |
|
| 176 | 'tld' => $row->tld)); |
|
| 177 | ||
| 178 | $tmpq3->execute(array( |
|
| 179 | 'registrar_id' => $row->registrar_id, |
|
| 180 | 'tld' => $row->tld)); |
|
| 181 | ||
| 182 | $tmpq4->execute(array( |
|
| 183 | 'update_time' => $this->time->stamp(), |
|
| 184 | 'registrar_id' => $row->registrar_id, |
|
| 185 | 'tld' => $row->tld)); |
|
| 186 | ||
| 187 | } |
|
| 188 | ||
| @@ 236-288 (lines=53) @@ | ||
| 233 | 'tld' => $tld)); |
|
| 234 | $result = $tmpq->fetchAll(); |
|
| 235 | ||
| 236 | if ($result) { |
|
| 237 | ||
| 238 | $tmpq = $this->system->db()->prepare(" |
|
| 239 | UPDATE domains |
|
| 240 | SET fee_id = :fee_id |
|
| 241 | WHERE registrar_id = :registrar_id |
|
| 242 | AND tld = :tld |
|
| 243 | AND fee_fixed = '0'"); |
|
| 244 | ||
| 245 | $tmpq2 = $this->system->db()->prepare(" |
|
| 246 | UPDATE domains d |
|
| 247 | JOIN fees f ON d.fee_id = f.id |
|
| 248 | SET d.fee_fixed = '1', |
|
| 249 | d.total_cost = f.renewal_fee + f.privacy_fee + f.misc_fee |
|
| 250 | WHERE d.registrar_id = :registrar_id |
|
| 251 | AND d.tld = :tld |
|
| 252 | AND d.privacy = '1'"); |
|
| 253 | ||
| 254 | $tmpq3 = $this->system->db()->prepare(" |
|
| 255 | UPDATE domains d |
|
| 256 | JOIN fees f ON d.fee_id = f.id |
|
| 257 | SET d.fee_fixed = '1', |
|
| 258 | d.total_cost = f.renewal_fee + f.misc_fee |
|
| 259 | WHERE d.registrar_id = :registrar_id |
|
| 260 | AND d.tld = :tld |
|
| 261 | AND d.privacy = '0'"); |
|
| 262 | ||
| 263 | $tmpq4 = $this->system->db()->prepare(" |
|
| 264 | UPDATE fees |
|
| 265 | SET fee_fixed = '1', |
|
| 266 | update_time = :update_time |
|
| 267 | WHERE registrar_id = :registrar_id |
|
| 268 | AND tld = :tld"); |
|
| 269 | ||
| 270 | foreach ($result as $row) { |
|
| 271 | ||
| 272 | $tmpq->execute(array( |
|
| 273 | 'fee_id' => $row->id, |
|
| 274 | 'registrar_id' => $row->registrar_id, |
|
| 275 | 'tld' => $row->tld)); |
|
| 276 | ||
| 277 | $tmpq2->execute(array( |
|
| 278 | 'registrar_id' => $row->registrar_id, |
|
| 279 | 'tld' => $row->tld)); |
|
| 280 | ||
| 281 | $tmpq3->execute(array( |
|
| 282 | 'registrar_id' => $row->registrar_id, |
|
| 283 | 'tld' => $row->tld)); |
|
| 284 | ||
| 285 | $tmpq4->execute(array( |
|
| 286 | 'update_time' => $this->time->stamp(), |
|
| 287 | 'registrar_id' => $row->registrar_id, |
|
| 288 | 'tld' => $row->tld)); |
|
| 289 | ||
| 290 | } |
|
| 291 | ||
