/** * Retrieved list of objects base on a given parameters - dynamic method: list_PaForumsUsers() * * * Generated with the DalClassGenerator created by: * Zoran Hron <*****@*****.**> * * @param conditionalStatement = null * @param orderby = null * @param sort = null * @param limit = 0 * @param fetchmode = DB_FETCHMODE_OBJECT * @result array of objects: PaForumsUsers **/ public function list_PaForumsUsers($conditionalStatement = null, $orderby = null, $sort = null, $limit = 0, $fetchmode = DB_FETCHMODE_OBJECT) { // build MySQL query $sql = "SELECT * FROM { pa_forums_users } "; if ($conditionalStatement) { $sql .= "WHERE {$conditionalStatement}"; } if ($orderby) { $sql .= " ORDER BY {$orderby}"; } if ($sort) { $sql .= " {$sort}"; } if ($limit) { $sql .= " LIMIT {$limit}"; } $sql .= ";"; // execute query $res = Dal::query($sql); $objects = array(); // data found? if ($res->numRows() > 0) { // retrieve data objects while ($row = $res->fetchRow($fetchmode)) { if ($fetchmode == DB_FETCHMODE_OBJECT) { $obj = new PaForumsUsers(); $obj->populateFromObject($row); $objects[] = $obj; } else { $objects[] = $row; } } } return $objects; }
/** * Soft delete of user related data. * function to delete a user from the system. * this function uses the method of th respective api's to delete the user related data. */ public static function delete_user($user_id) { Logger::log("Enter: function User::delete_user"); // Delete user content on homepage: Call content delete. $uid = (int) $user_id; try { Content::delete_user_content($uid); // Deleting user groups. $Group = new Group(); $Group->delete_user_groups($uid); // Deleting user albums. Album::delete_user_albums($uid); // Deleting user relations. Relation::delete_user_relations($uid); // Deleting user comments. Comment::delete_user_comments($uid); PaForumsUsers::delete_PaForumsUsers($uid); UserPopularity::deleteUserPopularity($uid); } catch (PAException $e) { Logger::log('Exception occured while deleting user:'******' : ' . $e->message); throw new PAException(INVALID_ARGUMENTS, "User deletion failed for user_id = '{$uid}' due to '{$e->message}'"); } Logger::log("Exit: function User::delete_user"); }
: <?php echo PaForumPost::countPaForumPost("user_id = {$created_by->user_id}"); ?> </div> <div><?php echo __('Last login'); ?> : <?php echo PA::date($created_by->last_login, 'short'); ?> </div> <div><?php echo __('Status'); ?> : <?php echo PaForumsUsers::getStatusString($created_by->user_id); ?> </div> </div> </td> <td class="post_odd"> <div class='forum_post'> <?php echo $thread->get_content(); ?> </div> </td> </tr> <tr> <td class="post_date" width="<?php echo $avatar_size['width'];
private function buildStatistics($board) { $board_statistics = $board->getBoardStatistics(); $statistics = array(); $statistics['title'] = $board->get_title(); $statistics['description'] = $board->get_description(); $statistics['type'] = $board->get_type() . " board"; $statistics['created_at'] = $board->get_created_at(); switch ($board->get_type()) { case PaForumBoard::network_board: $net_id = $board->get_owner_id(); if ($net_id == 1) { // mother network - owner_id always is '1' ! $owner_id = 1; } else { $owner_id = Network::get_network_owner((int) $board->get_owner_id()); } break; case PaForumBoard::group_board: $owner_id = Group::get_owner_id((int) $board->get_owner_id()); break; case PaForumBoard::personal_board: $owner_id = $board->get_owner_id(); break; } $user = new User(); $user->load((int) $owner_id); $statistics['owner'] = $user; $statistics['nb_categories'] = $board_statistics['nb_categories']; $nb_forums = 0; $nb_threads = 0; $nb_posts = 0; $threads = array(); $last_posts = array(); foreach ($board_statistics['categories'] as $category) { if ($category->statistics['nb_forums'] > 0) { $nb_forums += $category->statistics['nb_forums']; foreach ($category->statistics['forums'] as $forum) { if (!empty($forum->statistics['threads']) and count($forum->statistics['threads']) > 0) { foreach ($forum->statistics['threads'] as &$thr) { $thr->forum = $forum; } $threads = array_merge($threads, $forum->statistics['threads']); $nb_threads += $forum->statistics['nb_threads']; $nb_posts += $forum->statistics['nb_posts']; if (!empty($forum->statistics['last_post'])) { $last_posts[] = $forum->statistics['last_post']; } } } } } if (count($threads) > 1) { usort($threads, "cmpThreadCreated"); } $statistics['threads'] = $threads; $statistics['nb_forums'] = $nb_forums; $statistics['nb_threads'] = $nb_threads; $statistics['nb_posts'] = $nb_posts; $statistics['last_posts'] = $last_posts; $statistics['nb_users'] = PaForumsUsers::countPaForumsUsers("board_id = " . $board->get_id()); return $statistics; }
: <?php echo $post->user->user_id != -1 ? PaForumPost::countPaForumPost("user_id = " . $post->user->user_id) : ''; ?> </div> <div><?php echo __('Last login'); ?> : <?php echo $post->user->user_id != -1 ? PA::date($post->user->last_login, 'short') : ''; ?> </div> <div><?php echo __('Status'); ?> : <?php echo $post->user->user_id != -1 ? PaForumsUsers::getStatusString($post->user->user_id) : ''; ?> </div> </div> </td> <td class="post_<?php echo $even_odd; ?> "> <div class='forum_post'> <?php echo $post->get_content(); ?> </div> </td> </tr>