princeton

I have Part of Leaderboard selected. When I go to the leaderboard and click on "Top Groups" I get the following error:
Sorry, there is a problem
Something went wrong. Please try again.
Error code: EX1064
This error was probably caused by application [GT] Members | Group Enhancements.
If the issue persists, disable it and contact the author for further assistance.
SELECT * FROM `core_members` WHERE completed=1 AND last_activity>=1597043560 ORDER BY `last_activity`  desc LIMIT 0,-1
IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1 (1064)
#0 /var/www/html/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Helpers\\T...', Array, true)
#1 /var/www/html/system/Db/Select.php(436): IPS\Db\_Select->runQuery()
#2 /var/www/html/system/Helpers/Table/Db.php(397): IPS\Db\_Select->rewind()
#3 /var/www/html/init.php(820) : eval()'d code(56): IPS\Helpers\Table\_Db->getRows(NULL)
#4 /var/www/html/applications/membergroupenhancements/modules/front/groups/directory.php(197): IPS\Helpers\Table\membergroupenhancements_hook_table_db->getRows(NULL)
#5 /var/www/html/system/Dispatcher/Controller.php(96): IPS\membergroupenhancements\modules\front\groups\_directory->manage()
#6 /var/www/html/system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute()
#7 /var/www/html/index.php(13): IPS\_Dispatcher->run()
#8 {main}

Where is the Standalone Directory? I can't find it on the front end or menu options in admin. What I was hoping I could do was create a page and have groups as a block option to choose which groups to show along with their description on the page. Is this possible?

We are mirroring the actual breadcrumb and not including the URL to the current page. We can investigate to see if the URL to the current page should be added.
i.e. at the example URL you started with, you see this in the breadcrumb and you'll note the last entry isn't a URL (so it's not included):

Can you give me some examples of how you'd like to use Pages in clubs?

What sort of functionality would you need?

We don't (out of the box) use cross-domain requests so the reported issue is sort of moot.
That said, no it's not as simple as dropping in jQuery 3. Upgrading jQuery is something we're investigating for a future release, however.

Fixed

Version 6 Released!
Allow/disallow based on primary member group. As requested @princeton
Tested but yell if there are problems.

you may need to look into ckeditor config.allowedContent (just do a search on the Web for it)
basically, you will have to edit your ckeditor config file

The setting lets you specify additional allowed data controllers (e.g. values that can be used in data-controller).
You will need to create a plugin on \IPS\Text\Parser against the _htmlPurifierModifyHtmlDefinition() method to allow any new attributes. You'll probably be looking at something like
/** * Customize HTML Purifier HTML Definition * * @param HTMLPurifier_HTMLDefinition $def The definition * @return void */ protected function _htmlPurifierModifyHtmlDefinition( \HTMLPurifier_HTMLDefinition $def ) { parent::_htmlPurifierModifyHtmlDefinition( $def ); /* Allow the data-ipstooltip attribute on 'a' tags */ $def->addAttribute( 'a', 'data-ipstooltip', 'Bool' ); }  

Hey Folks.
Not sure when core will support Youtube and Vimeo in Galleries?
So in the meantime I've added rudimentary, but working support, for both. A few cosmetics to tidy up, but it works great and requires very little effort to achieve. Works in Club galleries too. 
Let me know what you think. Is this worth developing further? Is core going to support YouTube galleries anytime soon? etc.

Topics are already optional. Just don't select a  forum, and no topic will be created.
No, sorry. Filters are only by member group.

Agree Joel,
I think it's more about an increase in mobile usage / mobile devices. 
Splitting content into it's own "silos" is just poor experience these days. Basically, you are forcing users to go here ... go there ... now, go ever here. It's easy on desktop but mobile is just horrible.
People are changing habits.
Mobile is the new Desktop.

Already present. You can "View Subscribers" for each newsletter. You can also "Manage Issues" for each newsletter, which shows distribution total. Please read the documentation that is provided with the modification; this is included.
This has been requested before, but I'm not going to be doing this any time in the near future. It's going to make an already complicated mod a lot more complex, and I don't have the availability right now to support all the issues that will come along with it. I'd rather not build something I can't support properly.
I like this suggestion. I'll add it to my list.
Again, please read the documentation. Some of these issues are explained and documented. Many of these others are due to the way that different email clients render your template. Not all clients support all HTML properties. This is just something you'll have to play with via trial and error. I don't provide support for the templates themselves; there are just too many variables at work. I suggest you start with this link: https://www.campaignmonitor.com/css/. This is from Campaign Monitor, and they provide a good guide for what is commonly supported.
Not at this time. If you integrated with SendGrid or SparkPost, they take care of that for you.
Thanks. I'll take a look.

I mean, I think this is a valid suggestion but one that can be evolved for practical application. 
There are two areas where I struggle with the suite:
1. Cross integration and double posting of content.  I have image boards and gallery albums, and users will double post.  I'd love if certain content items like gallery albums, files, calendar events , or products could be "attached" to things like posts or comments.  Right now everything is in it's own silo, and you literally have to visit another app to interact with the item.  
2. A more fluid approach to content.  The rise of social media is changing user's expectations with UIX design.  You can post a status update, album, video, etc.  You shouldnt have to go one app to post a topic, then another app to post an album, then another app to post a video.  The entrance to user content needs to be more expansive.  

Agree ... Store / Downloads disjointed ... not user friendly.
The normal way of selling (standard across the web) is to add all products into a Store. One UI - one central location for all sales.
With IPS...
If it requires a download (files, ebooks, magazine, etc) - use Downloads.
If it requires shipping (tshirts, posters, etc) - use Store.
Imagine explaining that to members. 😕 
(Make a right up ahead, then turn left, walk 10ft, turn right, when you see a tree - do a little dance, than crawl into the dark tunnel, once you get to the other side ... grab the ebook ... to get out jump over the hog that is eating the bacon, jump into the water - ignore the mermaids - swim about 3ft, make a left into the tunnel ... say hello to the unicorn, you are now home)
Of course, they don't care.
The onus is on us to provide a streamlined experience to purchase and manage orders. If confusing sales are stagnant. If easy sales increase.
UGH 😞

Agree ... Store / Downloads disjointed ... not user friendly.
The normal way of selling (standard across the web) is to add all products into a Store. One UI - one central location for all sales.
With IPS...
If it requires a download (files, ebooks, magazine, etc) - use Downloads.
If it requires shipping (tshirts, posters, etc) - use Store.
Imagine explaining that to members. 😕 
(Make a right up ahead, then turn left, walk 10ft, turn right, when you see a tree - do a little dance, than crawl into the dark tunnel, once you get to the other side ... grab the ebook ... to get out jump over the hog that is eating the bacon, jump into the water - ignore the mermaids - swim about 3ft, make a left into the tunnel ... say hello to the unicorn, you are now home)
Of course, they don't care.
The onus is on us to provide a streamlined experience to purchase and manage orders. If confusing sales are stagnant. If easy sales increase.
UGH 😞

Agree ... Store / Downloads disjointed ... not user friendly.
The normal way of selling (standard across the web) is to add all products into a Store. One UI - one central location for all sales.
With IPS...
If it requires a download (files, ebooks, magazine, etc) - use Downloads.
If it requires shipping (tshirts, posters, etc) - use Store.
Imagine explaining that to members. 😕 
(Make a right up ahead, then turn left, walk 10ft, turn right, when you see a tree - do a little dance, than crawl into the dark tunnel, once you get to the other side ... grab the ebook ... to get out jump over the hog that is eating the bacon, jump into the water - ignore the mermaids - swim about 3ft, make a left into the tunnel ... say hello to the unicorn, you are now home)
Of course, they don't care.
The onus is on us to provide a streamlined experience to purchase and manage orders. If confusing sales are stagnant. If easy sales increase.
UGH 😞

Agree ... Store / Downloads disjointed ... not user friendly.
The normal way of selling (standard across the web) is to add all products into a Store. One UI - one central location for all sales.
With IPS...
If it requires a download (files, ebooks, magazine, etc) - use Downloads.
If it requires shipping (tshirts, posters, etc) - use Store.
Imagine explaining that to members. 😕 
(Make a right up ahead, then turn left, walk 10ft, turn right, when you see a tree - do a little dance, than crawl into the dark tunnel, once you get to the other side ... grab the ebook ... to get out jump over the hog that is eating the bacon, jump into the water - ignore the mermaids - swim about 3ft, make a left into the tunnel ... say hello to the unicorn, you are now home)
Of course, they don't care.
The onus is on us to provide a streamlined experience to purchase and manage orders. If confusing sales are stagnant. If easy sales increase.
UGH 😞

I would argue that this is not specific to downloads, but more about custom items in general. I've done a LOT of custom development for commerce, probably more than most of the other contributors here. There is a big feature gap between commerce products and custom (and for the purposes of this conversation, downloads is custom. It's built the same way, after all). 
1. No coupons. 
2. No ability to add multiple items to the cart ( @Aiwa it actually is possible to handle multiple sellers; I know because I've done it).
3.no cart at all, we go straight to checkout. 
4. Checkout looks different. There is no easy way for me to use an icon or default image to make it look nice, everything just gets this plain black box. 
5. I can't put custom details on the invoices because they are limited to package fields. I have to write code that creates a dummy custom field and then magically populate it. 
And these are just the things I can think of off the top of my head. I'm sure I can find more if I put some effort in. 

Hi Thank you,
There is no reason that an integration would have to interfere with file repository functionality. (It is downloads after all) It would be the same as now; simply not engage any of the "selling" features of the app.
For the rest of us that use it (as it's used on this site) for selling, it's currently like the red headed step child of the IPS suite with regard to commerce. Since it's not integrated with the rest of the commerce features it feels very disjointed.
ALL of the fantastic control of commerce (both current and future) does not work with items selling in downloads.  Why shouldn't a product in downloads be treated like a proper product?
Why isn't the market place treated like a store? Consider all the upcoming store filters and other commerce updates that will not work for products sold in downloads. (sadly disjointed and not working for downloads)
The customer thinks of paid downloads as a product! That much I can assure you. So why isn't the suite allowing me to manage it like a product?
Here are some specific missing things from downloads when used for commerce (as requested).
Can't add a downloads product to cart (as you can with any other product) - I get asked for this VERY OFTEN Can't apply coupons to specific  downloads products (as you can with any other product) Don't get a nice clean store layout with downloads (as you can with other products) Can't set stock levels for downloads (as you can with other products) Many mods in the third party market designed to work with products fail on downloads products Upcoming filters for products will not work with downloads products. I run ALL the commerce on my site through downloads and as a result I miss out on the neat stuff mentioned above. (and more,as that was only off the top of my head)
 
 
exactly, and right now those settings feel weak, and disjointed. They should be the same as any product in commerce but download products aren't.

I use downloads to sell stuff and It just doesn't work the same as products setup in commerce. There is less control over coupons, promotions and no shopping cart.
Would be so great if downloads was brought in and merged with commerce so all functionality was native to one another.

Good idea.
I think the "member inactivity" (=last visit or real last visit) should get more attention
f.e.
only award reaction points if member's last visit isn't older than x days only award response posts points if member's last visit isn't older than x days only award weekly/monthly/yearly points if…. only award bank interest if ... There are many cases where it would make sense, if we could exclude inactive members from receiving points, if they are offline for a longer time. If my members would know, that they won't receive anymore points after day x, they would login more often and it would drive up the community engagement.
Similar to the "inactivity rule" it would also be great to do the same with f.e. "bulk email opt-ins", so we as admins can choose to not award members, that are currently not subscribed for bulk email. That would help the email marketing a lot.

I wonder if you can do daily points, but make them negative.  For example, for every day you're a member -2?

I edited my post above.
- Random password:
$password = \IPS\Login::generateRandomString( 8 ); $member->setLocalPassword( $password ); Or you can use:
$member->setLocalPassword( $values['password'] ); Or even a hardcoded value:
$member->setLocalPassword( '123456' ); - Secondary groups:
$member->mgroup_others = implode( ',', $groupsArray ); - Confirmation email:
$member->members_bitoptions['validating'] = TRUE; This will put the new member under validation and will (probably) send the email.
Is that what you asked regarding confirmation email?

No, it doesn’t work this way in mode 2 and 3. You turn the review system off, so there shouldn’t be a review button under the entry. The users will instead go to the separate review database and add a new record there – just like they would add a new article to a Pages article database. Feel free to add a link to this function to your menu, so users can find that more easily.