';
$usr_id= $user->get('id');
// echo "
User Id: ",$usr_id;
if(empty($usr_id) OR $usr_id == "0") { // echo "
User Empty";
// $usr_id = htmlspecialchars($_GET["userid"]);
if(isset($_GET["userid"])) {
$usr_id = htmlspecialchars($_GET["userid"]);
// Check User's Group
$query = "SELECT * FROM gtks0_user_usergroup_map WHERE user_id='$usr_id'";
$result = mysqli_query($link, $query);
while ($row = mysqli_fetch_assoc($result)) {
$groupid = $row['group_id'];
}
}
}
// echo "
GID=",$groupid;
// $document = JFactory::getDocument();
// $document->setTitle('Your Assessment');
$jobs = $db->getQuery(true);
?>
All
select('*')
->from($db->quoteName('gtks0_content'))
->where($db->quoteName('state') .' = '.$db->quote('1'))
->where($db->quoteName('catid') .' = '.$db->quote('17'))
->where($db->quoteName('asset_id') .' != '.$db->quote('0'));
// echo "
Jobs: ",$jobs;
$db->setQuery($jobs);
$results= $db->loadAssocList();
foreach ($results as $crow) {
$id= $crow['id'];
$title = $crow['title'];
$alias = $crow['alias'];
// $image = $crow['image'];
$intro = $crow['introtext'];
$tags = new TagsHelper;
$tags->getItemTags('com_content.article', $id);
// echo "Art. Id :",$id," - Title : ",$title," Tags : "; print_r($tags);
foreach($tags AS $tag) {
if(is_array($tag)) {
$ct = COUNT($tag); $tagalias=""; $tagwork=""; $tagtitle="";
for ($c = 0; $c < $ct; $c++) {
if(empty($tagalias)) $tagalias = $tag[$c]->alias; else $tagalias = $tagalias.",".$tag[$c]->alias;
// echo "
Tag Alias: ", $tagalias;
$tagwork = $tagwork." ".$tag[$c]->alias;
// echo "
Tag Work: ", $tagwork;
// $tagtitle = $tag[$c]->title;
if(empty($tagtitle)) $tagtitle = $tag[$c]->title; else $tagtitle = $tagtitle.", ".$tag[$c]->title;
// echo "
Tag Title: ", $tagtitle;
}
}
}
?>
