| @@ 2428-2441 (lines=14) @@ | ||
| 2425 | ); |
|
| 2426 | ||
| 2427 | // ... finally the boards... |
|
| 2428 | foreach ($board_changes as $id => $changes) |
|
| 2429 | $smcFunc['db_query']('', ' |
|
| 2430 | UPDATE {db_prefix}boards |
|
| 2431 | SET num_posts = num_posts + {int:num_posts}, unapproved_posts = unapproved_posts + {int:unapproved_posts}, |
|
| 2432 | num_topics = num_topics + {int:num_topics}, unapproved_topics = unapproved_topics + {int:unapproved_topics} |
|
| 2433 | WHERE id_board = {int:id_board}', |
|
| 2434 | array( |
|
| 2435 | 'num_posts' => $changes['posts'], |
|
| 2436 | 'unapproved_posts' => $changes['unapproved_posts'], |
|
| 2437 | 'num_topics' => $changes['topics'], |
|
| 2438 | 'unapproved_topics' => $changes['unapproved_topics'], |
|
| 2439 | 'id_board' => $id, |
|
| 2440 | ) |
|
| 2441 | ); |
|
| 2442 | ||
| 2443 | // Finally, least importantly, notifications! |
|
| 2444 | if ($approve) |
|
| @@ 1604-1622 (lines=19) @@ | ||
| 1601 | } |
|
| 1602 | ||
| 1603 | // Cycle through each board... |
|
| 1604 | foreach ($boardTotals as $id_board => $stats) |
|
| 1605 | { |
|
| 1606 | $smcFunc['db_query']('', ' |
|
| 1607 | UPDATE {db_prefix}boards |
|
| 1608 | SET |
|
| 1609 | num_topics = CASE WHEN {int:topics} > num_topics THEN 0 ELSE num_topics - {int:topics} END, |
|
| 1610 | unapproved_topics = CASE WHEN {int:unapproved_topics} > unapproved_topics THEN 0 ELSE unapproved_topics - {int:unapproved_topics} END, |
|
| 1611 | num_posts = CASE WHEN {int:posts} > num_posts THEN 0 ELSE num_posts - {int:posts} END, |
|
| 1612 | unapproved_posts = CASE WHEN {int:unapproved_posts} > unapproved_posts THEN 0 ELSE unapproved_posts - {int:unapproved_posts} END |
|
| 1613 | WHERE id_board = {int:id_board}', |
|
| 1614 | array( |
|
| 1615 | 'id_board' => $id_board, |
|
| 1616 | 'topics' => $stats['topics'], |
|
| 1617 | 'unapproved_topics' => $stats['unapproved_topics'], |
|
| 1618 | 'posts' => $stats['posts'], |
|
| 1619 | 'unapproved_posts' => $stats['unapproved_posts'], |
|
| 1620 | ) |
|
| 1621 | ); |
|
| 1622 | } |
|
| 1623 | ||
| 1624 | // Determine the board the final topic resides in |
|
| 1625 | $request = $smcFunc['db_query']('', ' |
|