function get_total_instance_uploads($instance_id)
{
if (!$instance_id) {
return false;
}
$query = he_database::placeholder("SELECT COUNT(`uploads_id`) AS `total_uploads` FROM `se_he_uploads` \r\n WHERE `uploads_instance_type`='?' AND `uploads_instance_id`=?", $this->instance_type, $instance_id);
return he_database::fetch_field($query, 'total_uploads');
}
function get_wall_link($object, $object_id)
{
global $user, $url;
if (!$object || !$object_id) {
return '';
}
if ($object == 'userhome' || !$user->user_exists) {
return '';
}
if ($object == 'user' && $user->user_info['user_id'] == $object_id) {
return '';
}
if ($object == 'user') {
$sql = he_database::placeholder("SELECT `user_id`, `user_username`, `user_fname`, `user_lname` FROM `se_users` " . "WHERE `user_id`=?", $object_id);
$row = he_database::fetch_row($sql);
$wall_owner = new se_user();
$wall_owner->user_exists = 1;
$wall_owner->user_info['user_id'] = $row['user_id'];
$wall_owner->user_info['user_username'] = $row['user_username'];
$wall_owner->user_info['user_fname'] = $row['user_fname'];
$wall_owner->user_info['user_lname'] = $row['user_lname'];
$wall_owner->user_displayname();
$wall_url = $url->url_create('profile', $wall_owner->user_info['user_username']);
$wall_label = $wall_owner->user_displayname;
} elseif ($object == 'group') {
$sql = he_database::placeholder("SELECT `group_title` FROM `se_groups` " . "WHERE `group_id`=?", $object_id);
$wall_url = $url->url_create('group', null, $object_id);
$wall_label = he_database::fetch_field($sql);
} elseif ($object == 'pages') {
$sql = he_database::placeholder("SELECT `pages_title` FROM `se_pages` " . "WHERE `pages_id`=?", $object_id);
$wall_url = $url->url_create('pages', null, $object_id);
$wall_label = he_database::fetch_field($sql);
} else {
return '';
}
return SE_Language::get(690706106, array($wall_url, $wall_label));
}
function count_quizzes()
{
$query = "SELECT COUNT(*) FROM `se_he_quiz`";
return (int) he_database::fetch_field($query);
}
