use Friendica\Core\Config;
use Friendica\Core\PConfig;
use Friendica\Core\System;
+use Friendica\Database\DBM;
require_once('include/contact_widgets.php');
require_once('include/redir.php');
$which = htmlspecialchars($a->argv[1]);
else {
$r = q("select nickname from user where blocked = 0 and account_expired = 0 and account_removed = 0 and verified = 1 order by rand() limit 1");
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
goaway(System::baseUrl() . '/profile/' . $r[0]['nickname']);
}
else {
$category = ((x($_GET,'category')) ? $_GET['category'] : '');
}
+ $hashtags = (x($_GET, 'tag') ? $_GET['tag'] : '');
+
if (Config::get('system','block_public') && (! local_user()) && (! remote_user())) {
return login();
}
intval($contact_id),
intval($a->profile['profile_uid'])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$contact = $r[0];
$remote_contact = true;
}
$a->page['aside'] .= posted_date_widget(System::baseUrl(true) . '/profile/' . $a->profile['nickname'],$a->profile['profile_uid'],true);
$a->page['aside'] .= categories_widget(System::baseUrl(true) . '/profile/' . $a->profile['nickname'],(x($category) ? xmlify($category) : ''));
+ $a->page['aside'] .= tagcloud_wall_widget();
if (can_write_wall($a,$a->profile['profile_uid'])) {
intval($a->profile['profile_uid'])
);
- if (!dbm::is_result($r)) {
+ if (!DBM::is_result($r)) {
return '';
}
//$sql_extra .= protect_sprintf(file_tag_file_query('item',$category,'category'));
}
+ if (x($hashtags)) {
+ $sql_post_table .= sprintf("INNER JOIN (SELECT `oid` FROM `term` WHERE `term` = '%s' AND `otype` = %d AND `type` = %d AND `uid` = %d ORDER BY `tid` DESC) AS `term` ON `item`.`id` = `term`.`oid` ",
+ dbesc(protect_sprintf($hashtags)), intval(TERM_OBJ_POST), intval(TERM_HASHTAG), intval($a->profile['profile_uid']));
+ }
+
if ($datequery) {
$sql_extra2 .= protect_sprintf(sprintf(" AND `thread`.`created` <= '%s' ", dbesc(datetime_convert(date_default_timezone_get(),'',$datequery))));
}
intval(PAGE_COMMUNITY),
intval(PAGE_PRVGROUP));
- if (!dbm::is_result($r)) {
+ if (!DBM::is_result($r)) {
$sql_extra3 = sprintf(" AND `thread`.`contact-id` = %d ", intval(intval($a->profile['contact_id'])));
}
// search for new items (update routine)
$_SESSION['last_updated'][$last_updated_key] = time();
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
foreach($r as $rr)
$parents_arr[] = $rr['item_id'];
$parents_str = implode(', ', $parents_arr);