Support

  1. chap
  2. Support
  3. Sunday, December 29 2019, 12:06 AM
  4.  Subscribe via email
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/
Accepted Answer
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
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 Accepted Answer
Pro
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 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 Accepted Answer
Pro
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 Accepted Answer
Pro
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.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy ProfileĀ® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.