/** * @Author: Taymoor Qanadilou * @Date created: 27/05/2013 * @Description: get all comments have bad words * @Param: * none * @Updated History: * none */ function disapproved_users_report() { $db_function_obj = new DbFunctions(); $user_obj = new User(); $helper_obj = new Helper(); $output = ""; //$approved_images = number_of_approved_images_report(STATUS_APPROVED); $disapproved_images = $db_function_obj->number_of_approved_images_report(STATUS_DISAPPROVED); //$approved_posts = number_of_approved_posts_report(STATUS_APPROVED); $disapproved_posts = $db_function_obj->number_of_approved_posts_report(STATUS_DISAPPROVED); while ($row = $this->conn->db_fetch_object($disapproved_images)) { $disapproved[$row->uid]['count_disapproved_image'] = $row->count; } while ($row = $this->conn->db_fetch_object($disapproved_posts)) { $disapproved[$row->uid]['count_disapproved_post'] = $row->count; } $output .= "<table border='1'>\n <tr><td colspan='3'>Disapproved Users Posts/Images</td></tr>\n <tr>\n <th>User Name</th>\n <th>Disapproved images</th>\n <th>Disapproved posts</th>\n </tr>\n "; if (is_array($disapproved)) { foreach ($disapproved as $key => $value) { $class = $helper_obj->table_row_class($i); $output .= "<tr class='{$class}'>\n <td>" . $user_obj->user_load($key)->name . "</td>\n <td>" . (@$value['count_disapproved_image'] + 0) . "</td>\n <td>" . (@$value["count_disapproved_post"] + 0) . "</td>\n </tr>"; } } $output .= "</table>"; return $output; }