AlexJ

This natively would be helpful. 3rd party images disappear over the period and making it content available natively, would preserve the topic/post flow.

Have few consistently slow performing queries but not sure from where it's generated. Any thoughts for making it faster would be helpful. Running MySQL 5.7.x with Redis. # Time: 2024-04-22T07:56:51.886625Z # User@Host: ips_user[ips_user] @ localhost [] Id: 32607188 # Query_time: 6.290145 Lock_time: 0.000050 Rows_sent: 1 Rows_examined: 1126912 SET timestamp=1713772611; /*test_table::ips_user::IPS\Content\Search\_Results::count:769*/ SELECT COUNT(*) FROM `ipb_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\cms\\Pages\\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) OR ( index_class IN('IPS\\communitymap\\Markers','IPS\\communitymap\\Markers\\Comment','IPS\\communitymap\\Markers\\Review') ) ) AND ( index_content LIKE '%{query}\'and(select+1)>0waitfor/**/delay\'0:0:0%' or index_title LIKE '%{query}\'and(select+1)>0waitfor/**/delay\'0:0:0%' ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0; # Time: 2024-04-22T07:56:59.448524Z # User@Host: ips_user[ips_user] @ localhost [] Id: 32608155 # Query_time: 6.962464 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 1126912 SET timestamp=1713772619; /*test_table::ips_user::IPS\Content\Search\Mysql\_Query::search:761*/ SELECT main.*, ((( index_title LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' ) AND MATCH(index_title) AGAINST ('' IN BOOLEAN MODE)*5)+(( index_content LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' or index_title LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' ) AND MATCH(index_content,index_title) AGAINST ('' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ipb_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\cms\\Pages\\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) OR ( index_class IN('IPS\\communitymap\\Markers','IPS\\communitymap\\Markers\\Comment','IPS\\communitymap\\Markers\\Review') ) ) AND ( index_content LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' or index_title LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25; # Time: 2024-04-22T07:57:06.499082Z # User@Host: ips_user[ips_user] @ localhost [] Id: 32608155 # Query_time: 7.050252 Lock_time: 0.000051 Rows_sent: 1 Rows_examined: 1126912 SET timestamp=1713772626; /*test_table::ips_user::IPS\Content\Search\_Results::count:769*/ SELECT COUNT(*) FROM `ipb_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\cms\\Pages\\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR index_class='IPS\\forums\\Topic\\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) OR ( index_class IN('IPS\\communitymap\\Markers','IPS\\communitymap\\Markers\\Comment','IPS\\communitymap\\Markers\\Review') ) ) AND ( index_content LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' or index_title LIKE '%{query}\'/**/and/**/DBMS_PIPE.RECEIVE_MESSAGE(\'c\',0)=\'c%' ) AND ( index_permissions = '*' OR ( FIND_IN_SET(2,index_permissions) ) ) AND index_hidden=0; # Time: 2024-04-24T21:41:37.196599Z # User@Host: ips_user[ips_user] @ localhost [] Id: 34042420 # Query_time: 5.170450 Lock_time: 0.000017 Rows_sent: 500 Rows_examined: 1926224 SET timestamp=1713994897; /*test_table::ips_user::IPS\core\modules\front\discover\_popular::leaderboard:70*/ SELECT class_type_id_hash, total_rep FROM ( SELECT class_type_id_hash, SUM(rep_rating) as total_rep FROM `ipb_core_reputation_index` AS `x` WHERE rep_date BETWEEN 1253102970 AND 1713994892 AND rep_class='IPS\\forums\\Topic\\Post' GROUP BY `class_type_id_hash` ) AS `x` ORDER BY x.total_rep desc LIMIT 0,500; # Time: 2024-06-03T12:52:20.369823Z # User@Host: ips_user[ips_user] @ localhost [] Id: 57314593 # Query_time: 5.582759 Lock_time: 0.000205 Rows_sent: 25 Rows_examined: 56926 SET timestamp=1717419140; /*test_table::ips_user::IPS\Helpers\Table\_Content::getRows:504*/ SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ipb_forums_topics` AS `forums_topics` LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `ipb_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums;',forums_topics.tid)) LEFT JOIN `ipb_core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `ipb_core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_forums.can_view_others=1 AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND forums_topics.is_future_entry=0 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(124,125,133,134,135,210) ORDER BY forums_topics.pinned DESC, forums_topics.last_post desc LIMIT 4125,25; # Time: 2024-06-03T13:24:03.947946Z # User@Host: ips_user[ips_user] @ localhost [] Id: 57385357 # Query_time: 5.179081 Lock_time: 0.000166 Rows_sent: 25 Rows_examined: 55576 SET timestamp=1717421043; /*test_table::ips_user::IPS\Helpers\Table\_Content::getRows:504*/ SELECT forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ipb_forums_topics` AS `forums_topics` LEFT JOIN `ipb_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id LEFT JOIN `ipb_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT('forums;forums;',forums_topics.tid)) LEFT JOIN `ipb_core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `ipb_core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE forums_forums.can_view_others=1 AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND forums_topics.is_future_entry=0 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_topics.forum_id IN(124,125,133,134,135,210) ORDER BY forums_topics.pinned DESC, forums_topics.last_post desc LIMIT 2775,25;

Hi @Marc Stridgen - I see your point but let me share few things from other side. 1. User requesting for help, doesn't often indicate their installed version. So may be an option to indicate their installed version would be great. 2. Conversations in reference to infrastructure set up / optimization, monitoring, monetizing, DDoS, spam, etc. is mostly general across all versions. Today, even though I am using IPS forums, some/many times, I have to look at Xenforo forum because they have wide variety of infra conversations available. I would prefer to use IPS forum for having a conversation with fellow IPS forum admins. I normally contribute what I am using and at same time interested what other's are doing as well. 3. Also current IPS customers can ask for help on other non-IPS forum. Based on that my suggestion would be - general conversation category for admins to talk on and if they need IPS team support, IPS specific category. - Thanks

Hi @Jim M - I don't have PayPal specific rules. Does MaxMind rules also apply to apply?

Currently only active customers can comment. Before majority of IPS customers, used to ask question through IPS ticket system. Now it's through forum first. Can you enable commenting on existing topic/post, so even though I am not 'active' license holder but I still hold 6 licenses and hence allowed to comment. This way, I can help others because certain times in last few weeks, I thought, I can help but wasn't able to. It's understandable I can't create a topic but disallowing other users to help your existing customers, seems counter productive. Just a minor feedback. Thanks.

Hello, Credit card transactions through PayPal goes in manual approval status. Is their anyway, it can be auto approve? I can't find the setting for it and in past PayPal has IPN set up or something? Any help appreciated. - Thanks.

Not really. I work daily on BI tools from Microsoft, Google, Tibco, etc. and I can tell you from visualization perspective, it's bad idea. No one can click on donut slice of more then 10. Here is live example: https://fearless-assassins.com/donate/ @Matt Happy to hear, it's added. Have you considered users using donation app can be moved successfully from app to commerce? I really have long standing request i.e. in commerce it accepts credit card as a payment while donation app doesn't. So now, i am forced to use 2 applications because commerce can't create donation goals and show who donated when. In today's world, I and many like me would prefer to provide transparency to end users i.e. when, how much and for what goals, users are donating. 2 major issues in donation app is only PayPal support and no subscriptions. I would prefer to have all in one app i.e. commerce or donation.

It would be nice if Commerce can get some traction in donation tracking perspective. We have limited subscription option but bills are due every month/year. So having donation goals and who donated against that goal, provides more transparency.

I hope they improve this crazy mess of donations/subscription which works across the spectrum and not just some forums/customers.

I use in one of my less used sites for testing purposes. I haven't done before/after monitoring. Off topic: I was setting up zero trust and that's when I noticed it. It would be interesting to know if you are using CF Email service with AWS.. trying to set up auto move, to validating for bounced emails. If you have experience in that, will PM you.

I am still having an issue when posting profile comments on our site. Do you guys have any solution planned? This bug is open since months now.

UI update has Ehren written all over it. Using your themes for past 10 years 🙂 Well done.

Is it possible to disable in wild card search in admin CP? It seems, through moderator logs, topic titles can be exposed to the members, who don't have access to categories.

Marketplace was really good option to find everything in one spot. Now i need to register on 20 different sites and half I don't even remember. It's like Apple telling to it's customer, here take iPhone. You want apps? Go on developers site and install from their. Jeez, what a nightmare. Take care of your health. Rest everything will go on. PS I am one of the customers who is unhappy because support/ticket system is gone and have to deal with broken donation system in store.

I think we are saying the same thing for AI and that's what i mean by training AI models i.e. to provide better/accurate results. Same thing happening in banks as well, where AI results are used to check anomaly. I think it's industry wide adaptation ongoing at present. Also, Microsoft is pushing hard with their co-pilot program or bing chat. So Google is improving as well since their major revenue of 50-60% is from adds. Competition is always good for consumers.

Google is taking seriously because of all the rush to get good data for AI models/search display and competition is getting spicy with Bing.

I normally check using https://www.ipqualityscore.com/ - it is accurate overall, especially this M27 or datacenter related IP's. We normally mention on site, users should remove Proxy if they face the issue.

@Adriano Faria @teraßyte (Tks for checking already) @DawPi

Block them at Cloudflare / Firewall level. I have blocked bunch of IP's and ASN's and it took care of the issue. Just make sure you check - if the IP is from Data Center / Proxy and based on that update the rules, so no real users would get impacted. It also takes care off useless search bot who just aggressively scan for WordPress links. Ex:

Is this done? Checking if i need to register on 50 different websites for find new apps .. Thanks to Dev's for coming together.

Dream come true 🙂 Nice work @Ehren

Thanks! Is that going away or it will stay? Also any thoughts on how to download the applications?

How app renewals / paid $$ will be tracked? I don't have track of what applications, i have purchased over the year. I really had liked the idea of install apps through ACP (marketplace). Easy, less worry and headache. Can I please get the list of paid apps? So on next renewal, I can talk to app owner? Thanks. I can't even download files today. Can you please tell me how can i download the files/apps which I paid for? I would like to save the local copy. - Thanks.

Ok thanks for quick response. Just a general question: How it impacts IPS team? From business standpoint Apple store makes 30% appx. I am guessing, to support developers through IPS Marketplace, IPS was charging fees on each transaction. Now does that mean, no marketplace = less revenue OR since 70% sales decline, it wasn't worth the hassle for IPS? Does this mean, customers will be charged different way, to make up for this revenue loss? Just curious. Is their anyway, I can have the 'local copy' of addons which I purchased through IPS? Currently it's all through ACP -Marketplace. I never asked so far because never needed it but with marketplace shutting down, I might need in future.

So for normal users like me, can i still do 'application upgrade' check? OR That process is changing as well? If i understand - rather then purchasing renewals from IPS, i will be purchasing through developer site? So 10 developers, 10 sits for renewals? I am fine with it, as long as I can use add-ons on IPS forum. Current IPS functionality doesn't cover all my needs and for us, stand alone forum would be non usable without developers fixing the gap/bridge.