Recent content by LaxmiSathy

Sorry for bumping the thread.. @Mike @Jake Bunce any one could help me...thanks in advance

@Jake Bunce can you help me with the below query requirement: Select the users who were active in the last week and the number of posts they contributed ONLY in the last week including those users who were active and who did not post in the last week. result to return: User_id, username...

@Mike My idea for the query is to get users who were active in the last week and the number of posts they contributed ONLY in the last week including those users who were active and who did not post in the last week.

@Mike can you help me with this query? Thanks in advance.

Hi, In the above query, it outputs users who were last active within the time frame AND the users who posted during this time frame. How to refine this query such that it also includes those users who were last active within the time frame BUT who did not post during this time frame. Thanks...

Any idea about configuring this widget?

Hello, Am looking for the below data - count of alerts unread by a user and the content_type for each of the alerts for the particular user. For the count of the unread alerts for a particular user I got it from the table - xf_user - column : alerts_unread But when I looked at the...

Hi, Am looking for the widget to show unanswered threads i.e those threads that were started in the last four weeks timeframe AND that has no replies. How do I implement it? Thanks.

Hi, If anyone looking for this query, here it is : SELECT u.username, date(FROM_UNIXTIME(u.register_date)), date(FROM_UNIXTIME(u.last_activity)), date(MAX(FROM_UNIXTIME(p.post_date))), count(p.post_id) FROM `xf_user` AS u LEFT JOIN xf_post p ON (p.user_id = u.user_id) WHERE...

Hello, Am running this query to get the list of users whose last activity is within a time frame: SELECT username, date(FROM_UNIXTIME(register_date)), date(FROM_UNIXTIME(last_activity)) FROM `xf_user` WHERE FROM_UNIXTIME(last_activity) BETWEEN '2017-10-16' AND '2017-10-24' ORDER BY...

Yeah, this is what I am looking for. But instead of it being placed at the bottom of thread page, is it possible to make it floating?

Hello, I understand that there is a share bar in the post permalink - But what am looking for is a floating share bar (as in the screen shot) in the bottom of every thread page. Let me know how to go about it. Thanks.

Hello, Noticed that in my community, few spammers are starting thread giving their phone number in the thread title like - "99147 *****" . Is there a spam management setting in Xenforo where I could disallow a specific sequence of numbers in the thread title. Thanks.

Hello, Recently we did server migration and after which noticed the issue that few posts had the same post number. Ran rebuild thread information with Rebuild position and post counters checked. Now the post number being same issue is resolved. But there is another issue wherein when I...

@Jake Bunce, you are a rock star. Just a little revision, the output to include the post count from the node id 21 as well.