$installer = new Install(); if (isset($_POST['op']) && $_POST['op'] == 'process') { switch ($_POST['type']) { case 'activate': $query = "UPDATE `" . $roster->db->table('topics', $addon['basename']) . "` SET `active` = '1' WHERE `topic_id` = '" . $_POST['id'] . "';"; $roster->db->query($query); break; case 'deactivate': $query = "UPDATE `" . $roster->db->table('topics', $addon['basename']) . "` SET `active` = '0' WHERE `topic_id` = '" . $_POST['id'] . "';"; $roster->db->query($query); break; case 'delete': processTopic(); break; case 'lock': $functions->processLock($_POST['id'], 1); break; case 'unlock': $functions->processLock($_POST['id'], 0); break; default: break; } } $queryb = "SELECT `topics`.*, `posts`.`poster_id`, `posts`.`post_subject` as t_title," . "COUNT(`posts`.`post_id`) as topic_count " . "FROM `" . $roster->db->table('topics', $addon['basename']) . "` topics " . "LEFT JOIN `" . $roster->db->table('posts', $addon['basename']) . "` posts USING (`topic_id`) " . "GROUP BY `topics`.`topic_id` " . "ORDER BY `topics`.`topic_id` DESC; "; $resultsb = $roster->db->query($queryb); $num = 1; $total = $roster->db->num_rows($resultsb); while ($rowb = $roster->db->fetch($resultsb)) { $roster->tpl->assign_block_vars('topic', array('ROW_CLASS' => $roster->switch_row_class(), 'T_NAME' => $rowb['title'], 'T_POSTER' => $rowb['author'], 'L_ACTIVEU' => $rowb['locked'] == 1 ? 'locked' : 'unlocked', 'L_ACTIVET' => $rowb['locked'] == 1 ? $roster->locale->act['lock'] : $roster->locale->act['unlock'], 'L_ACTIVEOP' => $rowb['locked'] == 1 ? 'unlock' : 'lock', 'B_ACTIVEI' => $rowb['active'] == 1 ? 'green' : 'red', 'B_ACTIVET' => $rowb['active'] == 1 ? 'Active' : 'Inactive', 'B_ACTIVEOP' => $rowb['active'] == 1 ? 'deactivate' : 'activate', 'FORUM_ID' => $rowb['topic_id'], 'T_POSTS' => $rowb['topic_count'])); }