private static function getURLFromCid($hcid, $project = false) { $prefix = $project ? 'groups_' : ''; if (!($o = Db::query(['SELECT p.to, p.pid FROM "' . $prefix . 'posts" p INNER JOIN "' . $prefix . 'comments" c ON c."hcid" = :hcid AND c.hpid = p.hpid', [':hcid' => $hcid]], Db::FETCH_OBJ))) { return System::getCurrentHostAddress(); } return System::getCurrentHostAddress() . ($project ? Utils::projectLink(Project::getName($o->to)) : Utils::userLink(User::getUsername($o->to))) . $o->pid . '#c' . $hcid; }
use NERDZ\Core\Trend; use NERDZ\Core\Utils; use NERDZ\Core\Config; use NERDZ\Core\User; use NERDZ\Core\Project; $vals = []; $vals['querystring_n'] = $q; $vals['type_n'] = !preg_match('/^#[a-z][a-z0-9]{0,33}$/i', $q) && isset($_GET['type']) ? $_GET['type'] == 'profile' ? 'profile' : 'project' : 'tag'; if ($vals['type_n'] == 'tag') { $vals['where_n'] = 'home'; $vals['toid_n'] = $vals['to_n'] = $vals['to4link_n'] = ''; } else { $prj = $vals['type_n'] == 'project'; $vals['where_n'] = isset($_GET['location']) ? $_GET['location'] == 'home' ? 'home' : ($_GET['location'] == 'profile' ? 'profile' : 'project') : 'home'; $vals['toid_n'] = isset($_GET['id']) && is_numeric($_GET['id']) ? intval($_GET['id']) : false; if ($vals['toid_n']) { if ($prj) { $vals['to_n'] = Project::getName($vals['toid_n']); $vals['to4link_n'] = Utils::projectLink($vals['to_n']); } else { $vals['to_n'] = User::getUsername($vals['toid_n']); $vals['to4link_n'] = Utils::userLink($vals['to_n']); } } else { $vals['toid_n'] = $vals['to_n'] = $vals['to4link_n'] = ''; } } require_once $_SERVER['DOCUMENT_ROOT'] . '/pages/common/trends.html.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/pages/common/vars.php'; $user->getTPL()->assign($vals); $user->getTPL()->draw('search/layout');
<?php if (!isset($id)) { die('$id required'); } require_once $_SERVER['DOCUMENT_ROOT'] . '/class/autoload.php'; use NERDZ\Core\Project; use NERDZ\Core\User; use NERDZ\Core\Db; use NERDZ\Core\Utils; $user = new User(); $prj = isset($prj); $entity = $prj ? new Project() : new User(); $limit = isset($_GET['lim']) ? NERDZ\Core\Security::limitControl($_GET['lim'], 20) : 20; $order = isset($_GET['desc']) && $_GET['desc'] == 1 ? 'DESC' : 'ASC'; $myvals = []; $myvals['me_n'] = $_SESSION['id']; $myvals['list_a'] = $entity->getInteractions($id, $limit); if ($prj) { $myvals['to_n'] = Project::getName($id); $myvals['to4link_n'] = Utils::projectLink($myvals['to_n']); } else { $myvals['to_n'] = $myvals['to4link_n'] = ''; } $validFields = ['time']; NERDZ\Core\Security::setNextAndPrevURLs($myvals, $limit, ['order' => $order, 'field' => empty($_GET['orderby']) ? '' : $_GET['orderby'], 'validFields' => $validFields]); $user->getTPL()->assign($myvals); return $user->getTPL()->draw(($prj ? 'project' : 'profile') . '/interactions', true);
private function get($params, $type) { extract($params); $post = !empty($post) ? $post : false; $row = !empty($row) ? $row : false; $ret = []; if (!$row) { return $ret; } $ret['fromid_n'] = $row->from; $ret['from_n'] = User::getUsername($row->from); $ret['from4link_n'] = Utils::userLink($ret['from_n']); $ret['type_n'] = $type; if ($post) { $ret['hpid_n'] = $row->hpid; $ret['pid_n'] = $post->pid; if ($this->isProject($type)) { $ret['to_n'] = Project::getName($post->to); $ret['to4link_n'] = Utils::projectLink($ret['to_n']) . $ret['pid_n']; } else { $ret['to_n'] = User::getUsername($post->to); $ret['to4link_n'] = Utils::userLink($ret['to_n']) . $ret['pid_n']; } } else { // followers - members $ret['toid_n'] = $row->to; if ($this->isProject($type)) { $ret['to_n'] = Project::getName($row->to); $ret['to4link_n'] = Utils::projectLink($ret['to_n']); } else { $ret['to_n'] = User::getUsername($row->to); $ret['to4link_n'] = Utils::userLink($ret['to_n']); } } $ret['datetime_n'] = $this->user->getDateTime($row->time); $ret['timestamp_n'] = $row->time; return $ret; }