Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Saturday 2:01 pm
Add a reply View Replies (5)

Resolved Userslist with only users with articles

  1. chap
    chap
  2. Support
  3. Sunday, December 29 2019, 12:06 AM
Hi,

Is it possible to make an userslist with only users who submitted an article?

If yes, how can i do it?

Possible for articles in a specific catagory or a specific period?

Thanks for help.
References
  1. https://www.schrijverspunt.nl/
  1. userslist
Accepted Answer
admin
admin Accepted Answer
Admin
This seems a template error, have you never modified file at /modules/mod_jsnusers/tmpl/default.php?

Anyway you can solve this issue by change in file /modules/mod_jsnusers/tmpl/default.php at line 62 this 
<a href="/ <?php echo $user->getLink(array('Itemid'=>$params->get('profile_menuid', ''))); ?>">
with this 
<a href="/<?php echo $user->getLink(array('Itemid'=>$params->get('profile_menuid', ''))); ?>">
(basically you need to remove a single space)
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
this should be possible with parameter called "Custom SQL Where", try to add following code
user_id IN (SELECT created_by FROM #__content WHERE state=1)
  1. more than a month ago
  2. Support
  3. # 1
chap
chap Accepted Answer
Thanks for the fast reaction.

I believe it works but i will test it some time.

Is it possible for articles in a specific catagory or a specific period?

So i want to show only users who post minimal 8 articles in the period 1-1-2020 to 31-12-2020 in some specific categories (category x and categorie y).

Thx for help
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
you can use a Custom SQL Where like: 
user_id IN (SELECT created_by FROM (SELECT created_by,COUNT(created_by) as tot FROM #__content WHERE catid IN (2,5) AND created >= '2020-01-01' AND created <= '2020-12-31' GROUP BY created_by HAVING tot > 8) as cc)


With this query you will have users who have posted 8 articles in categories 2 and 5 in the specific period.
  1. more than a month ago
  2. Support
  3. # 3
chap
chap Accepted Answer
Hi thanks,

It looks that it works, but now i got a new problem. Using the Easy profile module when clicking on one of the userprofiles you see an error message 404 URL invalid. So the profilelink doesn't work anymore.... Profilelinks in the content are no problem, only the module profilelinks i believe.

You can test it yourself on the site.(see url)

How to solve this problem?
References
  1. https://www.schrijverspunt.nl/talentvolle-schrijvers
  1. more than a month ago
  2. Support
  3. # 4
chap
chap Accepted Answer
Thx for the fast and good service
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.