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;
}
public function bbcode($str, $truncate = null, $type = NULL, $pid = NULL, $id = NULL)
{
//evitare il parsing del bbcode nel tag code
$codes = $this->getCodes($str);
$index = 0;
foreach ($codes as $code) {
$totalcode = $code['code'];
$lang = $code['lang'];
$str = str_ireplace("[code={$lang}]{$totalcode}[/code]", ">>>{$index}<<<", $str);
++$index;
}
$domain = System::getResourceDomain();
$str = static::hashtag($str);
$str = str_replace("\n", '<br />', $str);
$validURL = function ($m) {
$m[1] = trim($m[1]);
if (!Utils::isValidURL($m[1])) {
$m[1] = 'http://' . $m[1];
if (!Utils::isValidURL($m[1])) {
return '<b>' . $this->user->lang('INVALID_URL') . '</b>';
}
}
$url = preg_match('#^(?:https?|ftp):\\/\\/#i', $m[1]) ? $m[1] : 'http://' . $m[1];
return isset($m[2]) ? '<a href="' . Messages::stripTags($url) . '" onclick="window.open(this.href); return false">' . $m[2] . '</a>' : '<a href="' . Messages::stripTags($url) . '" onclick="window.open(this.href); return false">' . $m[1] . '</a>';
};
$str = preg_replace_callback('#\\[url="(.+?)"\\](.+?)\\[/url\\]#i', function ($m) use($validURL) {
return $validURL($m);
}, $str);
$str = preg_replace_callback('#\\[url=(.+?)\\](.+?)\\[/url\\]#i', function ($m) use($validURL) {
return $validURL($m);
}, $str);
$str = preg_replace_callback('#\\[url\\](.+?)\\[/url\\]#i', function ($m) use($validURL) {
return $validURL($m);
}, $str);
$str = preg_replace('#\\[i\\](.+?)\\[/i\\]#i', '<span style="font-style:italic">$1</span>', $str);
$str = preg_replace('#\\[cur\\](.+?)\\[/cur\\]#i', '<span style="font-style:italic">$1</span>', $str);
$str = preg_replace('#\\[gist\\]([0-9a-z]+)\\[/gist\\]#i', '<div class="gistLoad" data-id="$1" id="gist-$1">' . $this->user->lang('LOADING') . '...</div>', $str);
$str = preg_replace('#\\[b\\](.+?)\\[/b\\]#i', '<span style="font-weight:bold">$1</span>', $str);
$str = preg_replace('#\\[del\\](.+?)\\[/del\\]#i', '<del>$1</del>', $str);
$str = preg_replace('#\\[u\\](.+?)\\[/u\\]#i', '<u>$1</u>', $str);
$str = preg_replace('#\\[hr\\]#i', '<hr style="clear:both" />', $str);
$str = preg_replace('#\\[small\\](.+?)\\[/small\\]#i', '<span style="font-size:7pt">$1</span>', $str);
$str = preg_replace('#\\[big\\](.+?)\\[/big\\]#i', '<span style="font-size:14pt">$1</span>', $str);
$str = preg_replace('#\\[wat\\]#i', '<span style="font-size:22pt">WAT</span>', $str);
$str = preg_replace_callback('#\\[user\\](.+?)\\[/user\\]#i', function ($m) {
return '<a href="/' . Utils::userLink($m[1]) . "\">{$m[1]}</a>";
}, $str);
$str = preg_replace_callback('#\\[project\\](.+?)\\[/project\\]#i', function ($m) {
return '<a href="/' . Utils::projectLink($m[1]) . "\">{$m[1]}</a>";
}, $str);
$str = preg_replace_callback('#\\[wiki=([a-z]{2})\\](.+?)\\[/wiki\\]#i', function ($m) {
return '<a href="http://' . $m[1] . '.wikipedia.org/wiki/' . urlencode(str_replace(' ', '_', html_entity_decode($m[2], ENT_QUOTES, 'UTF-8'))) . "\" onclick=\"window.open(this.href); return false\">{$m[2]} @Wikipedia - {$m[1]}</a>";
}, $str);
$str = preg_replace_callback("#(\\[math\\]|\\[m\\])(.+?)(\\[/math\\]|\\[/m\\])#i", function ($m) {
return $m[1] . strip_tags($m[2]) . $m[3];
}, $str);
$str = preg_replace_callback('#\\[list\\](.+?)\\[\\/list\\]#i', function ($m) {
$arr = array_filter(explode('[*]', trim(trim($m[1]), '<br />')));
if (empty($arr)) {
return $m[0];
}
$ret = '<ul>';
foreach ($arr as $v) {
$ret .= '<li>' . trim($v) . '</li>';
}
$ret .= '</ul>';
return $ret;
}, $str, 20);
//ok
$str = preg_replace_callback('#\\[list[\\s]+type="(1|a|i)"\\](.+?)\\[\\/list\\]#i', function ($m) {
$arr = array_filter(explode('[*]', trim(trim($m[2]), '<br />')));
if (empty($arr)) {
return $m[0];
}
$ret = '<ol type="' . $m[1] . '">';
foreach ($arr as $v) {
$ret .= '<li>' . trim($v) . '</li>';
}
$ret .= '</ol>';
return $ret;
}, $str, 10);
//ok
$str = preg_replace_callback('#\\[list[\\s]+start="(\\-?\\d+)"\\](.+?)\\[\\/list\\]#i', function ($m) {
$arr = array_filter(explode('[*]', trim(trim($m[2]), '<br />')));
if (empty($arr)) {
return $m[0];
}
$ret = '<ol start="' . $m[1] . '">';
foreach ($arr as $v) {
$ret .= '<li>' . trim($v) . '</li>';
}
$ret .= '</ol>';
return $ret;
}, $str, 10);
//ok
$str = preg_replace_callback('#\\[list[\\s]+start="(\\-?\\d+)"[\\s]+type="(1|a|i)"\\](.+?)\\[\\/list\\]#i', function ($m) {
$arr = array_filter(explode('[*]', trim(trim($m[3]), '<br />')));
if (empty($arr)) {
return $m[0];
}
$ret = '<ol start="' . $m[1] . '" type="' . $m[2] . '">';
foreach ($arr as $v) {
$ret .= '<li>' . trim($v) . '</li>';
}
$ret .= '</ol>';
return $ret;
}, $str, 10);
//ok
$str = preg_replace_callback('#\\[list[\\s]+type="(1|a|i)"[\\s]+start="(\\-?\\d+)"\\](.+?)\\[\\/list\\]#i', function ($m) {
$arr = array_filter(explode('[*]', trim(trim($m[3]), '<br />')));
if (empty($arr)) {
return $m[0];
}
$ret = '<ol start="' . $m[2] . '" type="' . $m[1] . '">';
foreach ($arr as $v) {
$ret .= '<li>' . trim($v) . '</li>';
}
$ret .= '</ol>';
return $ret;
}, $str, 10);
// Quote in comments, new version
while (preg_match('#\\[commentquote=(.+?)\\](.+?)\\[/commentquote\\]#i', $str)) {
$str = preg_replace_callback('#\\[commentquote=(.+?)\\](.+?)\\[/commentquote\\]#i', function ($m) {
return '<div class="qu_main"><div class="qu_user">' . $m[1] . '</div>' . $m[2] . '</div>';
}, $str, 1);
}
while (preg_match('#\\[quote=(.+?)\\](.+?)\\[/quote\\]#i', $str)) {
$str = preg_replace_callback('#\\[quote=(.+?)\\](.+?)\\[/quote\\]#i', function ($m) use($domain) {
return '<div class="quote">
<div style="font-weight: bold">' . $m[1] . ':</div>
<span style="float: left; margin-top: 5px">
<img src="' . $domain . '/static/images/oquotes.gif" alt="quote" width="20" height="11" />
</span>
<div style="font-style:italic">
<blockquote style="margin-left: 3%">' . trim($m[2]) . '</blockquote>
</div>
<span style="float: right">
<img src="' . $domain . '/static/images/cquotes.gif" alt="cquote" width="20" height="11" />
</span>
</div>';
}, $str, 1);
}
while (preg_match('#\\[quote\\](.+?)\\[/quote\\]#i', $str)) {
$str = preg_replace_callback('#\\[quote\\](.+?)\\[/quote\\]#i', function ($m) use($domain) {
return '<div class="quote">
<span style="float: left; margin-top: 5px">
<img src="' . $domain . '/static/images/oquotes.gif" alt="quote" width="20" height="11" />
</span>
<div style="font-style:italic">
<blockquote style="margin-left: 3%">' . trim($m[1]) . '</blockquote>
</div>
<span style="float: right">
<img src="' . $domain . '/static/images/cquotes.gif" alt="cquote" width="20" height="11" />
</span>
</div>';
}, $str, 1);
}
while (preg_match('#\\[spoiler\\](.+?)\\[/spoiler\\]#i', $str)) {
$str = preg_replace('#\\[spoiler\\](.+?)\\[/spoiler]#i', '<div class="spoiler" onclick="var c = $(this).children(\'div\'); c.toggle(\'fast\'); c.on(\'click\',function(e) {e.stopPropagation();});">
<span style="font-weight: bold; cursor:pointer">SPOILER:</span>
<div style="display:none"><hr /></div>
<div style="display:none; margin-left:3%;overflow:hidden">$1</div>
</div>', $str, 1);
}
while (preg_match('#\\[spoiler=(.+?)\\](.+?)\\[/spoiler\\]#i', $str)) {
$str = preg_replace('#\\[spoiler=(.+?)\\](.+?)\\[/spoiler]#i', '<div class="spoiler" onclick="var c = $(this).children(\'div\'); c.toggle(\'fast\'); c.on(\'click\',function(e) {e.stopPropagation();});">
<span style="font-weight: bold; cursor:pointer">$1:</span>
<div style="display:none"><hr /></div>
<div style="display:none; margin-left:3%;overflow:hidden">$2</div>
</div>', $str, 1);
}
$str = preg_replace_callback('#\\[music\\]\\s*(.+?)\\s*\\[/music\\]#i', function ($m) use($truncate) {
$uri = strip_tags(html_entity_decode($m[1], ENT_QUOTES, 'UTF-8'));
if (stripos($uri, 'spotify') !== false) {
if (preg_match('#^(?:spotify:track:[\\d\\w]+)|(?:spotify:user:[\\w\\d]+:playlist:[\\w\\d]+)$#i', $uri)) {
$ID = $uri;
} else {
if (preg_match('#^https?://(?:open|play)\\.spotify\\.com/track/[\\w\\d]+$#i', $uri)) {
$ID = 'spotify:track:' . basename($uri);
} else {
if (preg_match('#^https?://(?:open|play)\\.spotify\\.com/user/([\\w\\d]+)/playlist/[\\w\\d]+#i', $uri, $matches)) {
$ID = "spotify:user:{$matches[1]}:playlist:" . basename($uri);
} else {
return $m[0];
}
}
}
return '<iframe src="https://embed.spotify.com/?uri=' . $ID . '" width="300" height="80" frameborder="0" allowtransparency="true"></iframe>';
} else {
if (preg_match('#^https?://soundcloud\\.com/\\S+/\\S+$#i', $uri)) {
return '<iframe width="100%" height="166" scrolling="no" frameborder="no" src="https://w.soundcloud.com/player/?url=' . rawurlencode($uri) . '"></iframe>';
} else {
if (preg_match('#^https?://(?:www\\.)?deezer\\.com/(track|album|playlist)/(\\d+)$#', $uri, $match)) {
$a_type = $match[1] . ($match[1] == 'track' ? 's' : '');
$a_height = $truncate ? '80' : '240';
return "<iframe src='//www.deezer.com/plugins/player?height={$a_height}&type={$a_type}&id={$match[2]}' width='100%' height='{$a_height}' scrolling='no' frameborder='no'></iframe>";
} else {
if (filter_var($uri, FILTER_VALIDATE_URL, FILTER_FLAG_PATH_REQUIRED)) {
return '<audio preload="none" controls src="' . htmlspecialchars($uri, ENT_QUOTES, 'UTF-8') . '"></audio>';
} else {
return $m[0];
}
}
}
}
}, $str, 10);
$str = preg_replace_callback('#\\[twitter\\]\\s*(.+?)\\s*\\[/twitter\\]#i', function ($m) use($truncate) {
// The reason for the 'data-uuid' attribute is in the jclass.js file, in the loadTweet function.
// with a fixed height (220px - when truncate is true - js trimmer can handle post size
if (!(is_numeric($m[1]) || Utils::isValidURL($m[1]))) {
return $m[0];
}
return '<img data-id="' . htmlspecialchars($m[1], ENT_QUOTES, 'UTF-8') . '" data-uuid="' . mt_rand() . '" src="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==" onload="N.loadTweet(this)"' . ($truncate ? ' height="220"' : '') . '>';
}, $str, 10);
if ($truncate) {
$videoCallback = function ($m) {
$v_url = html_entity_decode($m[1], ENT_QUOTES, 'UTF-8');
$output = [];
if (preg_match(static::YOUTUBE_REGEXP, $v_url, $match)) {
$output = ['youtube', $match[1], '//i1.ytimg.com/vi/' . $match[1] . '/hqdefault.jpg', 130];
} else {
if (preg_match(static::VIMEO_REGEXP, $v_url, $match)) {
$output = ['vimeo', $match[1], 'data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==', 130, 'N.vimeoThumbnail(this)'];
} else {
if (preg_match(static::DMOTION_REGEXP, $v_url, $match)) {
$output = ['dailymotion', $match[1], 'https://www.dailymotion.com/thumbnail/video/' . $match[1], 100];
} else {
if (preg_match(static::FACEBOOK_REGEXP, $v_url, $match)) {
$output = ['facebook', $match[1], 'data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==', 100, 'N.facebookThumbnail(this)'];
} else {
if (preg_match(static::NERDZCRUSH_REGEXP, $v_url, $match)) {
$output = ['nerdzcrush', $match[1], 'https://media.nerdz.eu/' . $match[1] . '.jpg', 130];
} else {
return $m[0];
}
}
}
}
}
return '<a class="yt_frame" data-vid="' . $output[1] . '" data-host="' . $output[0] . '">' . '<span>' . $this->user->lang('VIDEO') . '</span>' . '<img src="' . $output[2] . '" alt="" width="130" height="' . $output[3] . '" style="float:left;margin-right:4px"' . (isset($output[4]) ? 'onload="' . $output[4] . '"' : '') . ' />' . '</a>';
};
$str = preg_replace_callback('#\\[video\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/video\\]#i', $videoCallback, $str, 10);
// don't break older posts and preserve the [yt] and [youtube] tags.
$str = preg_replace_callback('#\\[yt\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/yt\\]#i', $videoCallback, $str, 10);
$str = preg_replace_callback('#\\[youtube\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/youtube\\]#i', $videoCallback, $str, 10);
$str = preg_replace_callback('#\\[img\\](.+?)\\[/img\\]#i', function ($m) {
$url = Utils::getValidImageURL($m[1]);
return '<a href="' . $url . '" target="_blank" class="img_frame" onclick="$(this).toggleClass(\'img_frame-extended\'); return false;">
<span>
' . $this->user->lang('IMAGES') . '
</span>
<img src="' . $url . '" alt="" onload="N.imgLoad(this)" onerror="N.imgErr(this)" />
</a>';
}, $str, 10);
} else {
$videoCallback = function ($m) {
$v_url = html_entity_decode($m[1], ENT_QUOTES, 'UTF-8');
$iframe_code = '';
if (preg_match(static::YOUTUBE_REGEXP, $v_url, $match)) {
$iframe_code = '<iframe title="YouTube video" style="width:560px; height:340px; border:0px; margin: auto;" src="//www.youtube.com/embed/' . $match[1] . '?wmode=opaque"></iframe>';
} else {
if (preg_match(static::VIMEO_REGEXP, $v_url, $match)) {
$iframe_code = '<iframe src="//player.vimeo.com/video/' . $match[1] . '?badge=0&color=ffffff" width="500" height="281" style="margin: auto" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>';
} else {
if (preg_match(static::DMOTION_REGEXP, $v_url, $match)) {
$iframe_code = '<iframe frameborder="0" style="margin: auto" width="480" height="270" src="//www.dailymotion.com/embed/video/' . $match[1] . '" allowfullscreen></iframe>';
} else {
if (preg_match(static::FACEBOOK_REGEXP, $v_url, $match)) {
$iframe_code = '<iframe style="margin: auto" src="https://www.facebook.com/video/embed?video_id=' . $match[1] . '" frameborder="0"></iframe>';
} else {
if (preg_match(static::NERDZCRUSH_REGEXP, $v_url, $match)) {
$iframe_code = '<div class="nerdzcrush" data-media="' . $match[1] . '#noautoplay,noloop"></div>';
} else {
return $m[0];
}
}
}
}
}
return '<div style="width:100%; text-align:center"><br />' . $iframe_code . '</div>';
};
$str = preg_replace_callback('#\\[video\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/video\\]#i', $videoCallback, $str, 10);
$str = preg_replace_callback('#\\[yt\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/yt\\]#i', $videoCallback, $str, 10);
$str = preg_replace_callback('#\\[youtube\\]\\s*(https?:\\/\\/[\\S]+)\\s*\\[\\/youtube\\]#i', $videoCallback, $str, 10);
$str = preg_replace_callback('#\\[img\\](.+?)\\[/img\\]#i', function ($m) {
return '<img src="' . Utils::getValidImageURL($m[1]) . '" alt="" style="max-width: 79%; max-height: 89%" onerror="N.imgErr(this)" />';
}, $str);
}
while ($index > 0) {
--$index;
$lang = $codes[$index]['lang'];
$totalcode = $codes[$index]['code'];
$tag = $codes[$index]['tag'];
$str = str_ireplace(">>>{$index}<<<", "[{$tag}={$lang}]{$totalcode}[/{$tag}]", $str);
}
return $this->parseCode($codes, $str, $type, $pid, $id);
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . '/class/autoload.php';
use NERDZ\Core\Db;
$validFields = ['name', 'description'];
$limit = isset($_GET['lim']) ? NERDZ\Core\Security::limitControl($_GET['lim'], 20) : 20;
$order = isset($_GET['desc']) && $_GET['desc'] == 1 ? 'DESC' : 'ASC';
$q = empty($_GET['q']) ? '' : htmlspecialchars($_GET['q'], ENT_QUOTES, 'UTF-8');
$orderby = isset($_GET['orderby']) ? NERDZ\Core\Security::fieldControl($_GET['orderby'], $validFields, 'name') : 'name';
$vals = [];
$query = empty($q) ? "SELECT name, description,counter\n FROM groups\n ORDER BY {$orderby} {$order} LIMIT {$limit}" : ["SELECT name,description, counter\n FROM groups WHERE CAST({$orderby} AS TEXT) ILIKE ?\n ORDER BY {$orderby} {$order} LIMIT {$limit}", ["%{$q}%"]];
$vals['list_a'] = [];
if ($r = Db::query($query, Db::FETCH_STMT)) {
$i = 0;
while ($o = $r->fetch(PDO::FETCH_OBJ)) {
$vals['list_a'][$i]['id_n'] = $o->counter;
$vals['list_a'][$i]['name_n'] = $o->name;
$vals['list_a'][$i]['description_n'] = $o->description;
$vals['list_a'][$i]['name4link_n'] = \NERDZ\Core\Utils::projectLink($o->name);
++$i;
}
}
\NERDZ\Core\Security::setNextAndPrevURLs($vals, $limit, ['order' => $order, 'query' => $q, 'field' => empty($_GET['orderby']) ? '' : $_GET['orderby'], 'validFields' => $validFields]);
require_once $_SERVER['DOCUMENT_ROOT'] . '/pages/common/vars.php';
$user->getTPL()->assign($vals);
$user->getTPL()->draw('base/projectslist');
while ($o = $r->fetch(PDO::FETCH_OBJ)) {
$vals['memberof_a'][$i]['name_n'] = $o->name;
$vals['memberof_a'][$i]['username_n'] = $o->name;
$vals['memberof_a'][$i]['name4link_n'] = Utils::projectLink($o->name);
++$i;
}
usort($vals['memberof_a'], '\\NERDZ\\Core\\Utils::sortByUsername');
if (!($r = Db::query(['SELECT "name" FROM "groups" INNER JOIN "groups_followers" ON "groups"."counter" = "groups_followers"."to" WHERE "from" = :id', $ida], Db::FETCH_STMT))) {
die($user->lang('ERROR'));
}
$vals['userof_a'] = [];
$i = 0;
while ($o = $r->fetch(PDO::FETCH_OBJ)) {
$vals['userof_a'][$i]['name_n'] = $o->name;
$vals['userof_a'][$i]['username_n'] = $o->name;
$vals['userof_a'][$i]['name4link_n'] = Utils::projectLink($o->name);
++$i;
}
usort($vals['userof_a'], '\\NERDZ\\Core\\Utils::sortByUsername');
$vals['github_n'] = $info->github;
$vals['yahoo_n'] = $vals['logged_b'] ? $info->yahoo : '';
$vals['jabber_n'] = $vals['logged_b'] ? $info->jabber : '';
$vals['skype_n'] = $vals['logged_b'] ? $info->skype : '';
$vals['steam_n'] = $vals['logged_b'] ? $info->steam : '';
$vals['facebook_n'] = $vals['logged_b'] ? $info->facebook : '';
$vals['twitter_n'] = $vals['logged_b'] ? $info->twitter : '';
$vals['id_n'] = $id;
// single post like nessuno.1
$found = false;
if ($vals['singlepost_b']) {
if ($user->hasInBlacklist($id)) {
<?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);
} else {
$mem = $project->getMembers($info->counter);
$icansee = true;
if ($vals['logged_b'] && !$info->visible) {
$icansee = $_SESSION['id'] == $project->getOwner() || in_array($_SESSION['id'], $mem);
}
if (!$icansee) {
$user->getTPL()->assign($vals);
require_once $_SERVER['DOCUMENT_ROOT'] . '/pages/common/vars.php';
$user->getTPL()->draw('project/invisible');
} else {
$vals['photo_n'] = !empty($info->photo) ? Utils::getValidImageURL($info->photo) : 'https://www.gravatar.com/avatar/';
$vals['onerrorimgurl_n'] = '/static/images/onErrorImg.php';
$vals['id_n'] = $info->counter;
$vals['name_n'] = $info->name;
$vals['name4link_n'] = \NERDZ\Core\Utils::projectLink($info->name);
if (!($o = Db::query(['SELECT EXTRACT(EPOCH FROM "creation_time") AS creation_time from "groups" WHERE "counter" = :id', [':id' => $info->counter]], Db::FETCH_OBJ))) {
die($user->lang('ERROR'));
}
$vals['creationtime_n'] = $user->getDateTime($o->creation_time);
$vals['members_n'] = count($mem);
$vals['members_a'] = [];
$i = 0;
foreach ($mem as $uid) {
if (!($uname = User::getUsername($uid))) {
continue;
}
$vals['members_a'][$i]['username_n'] = $uname;
$vals['members_a'][$i]['username4link_n'] = \NERDZ\Core\Utils::userLink($uname);
++$i;
}
public function getInteractions($id, $limit = 0)
{
if (!$this->user->isLogged()) {
return [];
}
if ($limit) {
$limit = Security::limitControl($limit, 20);
}
$objs = [];
if (!($objs = Db::query(['SELECT "type", extract(epoch from time) as time, pid, post_to
FROM group_interactions(:me, :id) AS
f("type" text, "time" timestamp with time zone, pid int8, post_to int8)
ORDER BY f.time DESC' . ($limit !== 0 ? " LIMIT {$limit}" : ''), [':me' => $_SESSION['id'], ':id' => $id]], Db::FETCH_OBJ, true))) {
return [];
}
$ret = [];
for ($i = 0, $count = count($objs); $i < $count; ++$i) {
$ret[$i]['type_n'] = $objs[$i]->type;
$ret[$i]['datetime_n'] = $this->user->getDateTime($objs[$i]->time);
$ret[$i]['pid_n'] = $objs[$i]->pid;
$ret[$i]['postto_n'] = static::getName($objs[$i]->post_to);
$ret[$i]['link_n'] = Utils::projectLink($ret[$i]['postto_n']) . $objs[$i]->pid;
}
return $ret;
}
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;
}
