Keyword

top commenters function per category

  • George Nasis
  • George Nasis's Avatar Topic Author
  • Offline
  • Elite Member
More
10 years 4 hours ago #132616 by George Nasis
top commenters function per category was created by George Nasis
hallo there!

i need help with something!i want the top commenters of the mod_comments to function like latest comments. why there is not the opportunity to filter per category?how can that been changed?

thank you

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #132617 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: top commenters function per category
At this point only via a custom SQL query.

You can ask this as feature request for the upcoming version.
github.com/joomlaworks/k2-v3-dev-build

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • George Nasis
  • George Nasis's Avatar Topic Author
  • Offline
  • Elite Member
More
9 years 11 months ago #132618 by George Nasis
Replied by George Nasis on topic Re: top commenters function per category
thank you krikor!

ok i will propose that!

at this point can you help with this sql query? :)

thank you!

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #132619 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: top commenters function per category
The main query is located in line 224 in the /modules/mod_k2_comments/helper.php file.

You can change the query from there.

If you want to add this as an option, you need to either hack the module or create a new module based on mod_k2_comments. The latter is my suggestion.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • George Nasis
  • George Nasis's Avatar Topic Author
  • Offline
  • Elite Member
More
9 years 11 months ago #132620 by George Nasis
Replied by George Nasis on topic Re: top commenters function per category
hallo Krikor, thank you for that!

i searched the tables of k2_comments and k2_items trying to connect the parameters.

in the k2_comments i have the itemID of the comment. then in k2_items obviously i have the catid.

so i imagine in the query i want something that at first see the category (as input from the backend) and then run the query as the query run for latest comments?
Log in  or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #132621 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: top commenters function per category
You should modify the xml as well to make it more manageable.
I think at this point you should create a new module.

An upgrade can turn into a potential disaster.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • George Nasis
  • George Nasis's Avatar Topic Author
  • Offline
  • Elite Member
More
9 years 11 months ago #132622 by George Nasis
Replied by George Nasis on topic Re: top commenters function per category
ok krikor!

thank you for that!

best regards!

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 11 months ago #132623 by Krikor Boghossian
Replied by Krikor Boghossian on topic Re: top commenters function per category
You 're welcome George.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.