| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 5 online users.
» 0 Member(s) | 5 Guest(s)
|
|
|
| MyGallery: a responsive image gallery for MyBB |
|
Posted by: Laird - 2022-02-07, 12:47 PM - Forum: MyGallery
- Replies (2)
|
 |
MyGallery is a responsive image gallery plugin for MyBB, battle-tested on a high-traffic board with many thousands of gallery images.
Price:
$50 AUD per site (note the Australian dollars; discounts for multiple sites are negotiable).
Payment methods:
PayPal or bank transfer.
Contact methods:
See here. When contacting me, mention your intended use and your contractual commitment to non-objectionable use (see below).
Licence:
The standard EULA.
Conditions of purchase:
Non-objectionable intended use and commitment to ongoing non-objectionable use. Examples of objectionable use: - Non-consensual sexual imagery.
- Images glorifying violence or crime.
- Images promoting animal exploitation including animal agriculture.
Copyright:
All code copyright me and non-distributable, with all rights reserved, except for that of the bundled Highslide library, which is MIT-licensed.
Technical requirements / compatibility:- MyBB 1.8.x (untested for smaller values of x).
- PHP 7 or 8 (potentially untested on very early versions of PHP 7; might work with PHP 5).
- MySQL/MariaDB (PostgreSQL and SQLite not supported).
Will refund if MyGallery unexpectedly does not work on your setup.
Additional functionality:
Ask if you want me to add functionality for a fee (I can provide a detailed, free, no-obligation quote for more extensive work).
Paradigmatic use case:
A community of artists sharing their images with one another in collectively-curated image galleries and ❤ing and commenting on one another's images.
Demo:
Gallery of all images
Gallery screenshot:
Features:- Responsive design (to best test the responsive design, select the Roundo Light theme bottom of page).
- Multi-gallery support:
- Authorised admins can create/edit galleries and their settings in the ACP at Configuration » Gallery Management.
- A galleries index, at galleries.php (bare-bones but customisable page listing all galleries the member is authorised to view).
- Per-gallery options:
- Separate usergroup permissions for:
- Posting images.
- Viewing images.
- Posting comments.
- Optional auto-blurring (for unauthorised usergroups). Alternatively, an error message can be displayed.
- Optional auto-watermarking:
- Customisable watermark image.
- Customisable vertical location of watermark: top, middle, or bottom.
- Customisable codename, for user-friendly URLs (the special codename "main" shows images from all (authorised/blurred) galleries).
- Categories list (so as to tag images in one or more categories on upload).
- Optional pop-up of gallery images using the Highslide library on clicking an image, otherwise, clicking an image leads to its own page.
- Auto-import settings:
- Forums list. When a new thread is posted in one of those forums (so long as the forum wasn't also specified in an earlier gallery), all images (enclosed in `img` MyCode tags) in the first post in that thread (if any) are auto-imported into the gallery, unless the posting member unchecks the "Import Image" checkbox (to test this feature on this board for the default gallery, post a new thread in the Sandbox forum).
- Domain blacklist: prevents images from matching domains from being auto-imported.
- Optionally, use original thread for comments.
- Optionally, hide first post when doing so (useful when imported images are blurred for unauthorised viewing members, and the comments should not reveal those imported images).
- Thank You/Like System plugin (TYL) integration: optionally, use the TYLs of the first post in the original thread for the image's likes.
- Gallery display (see above screenshot):
- Accessible at gallery.php?codename=[codename] (see, e.g., this board's default gallery at gallery.php?codename=default).
- Paginated at 12 images per page.
- Filterable by categories.
- Per-image features:
- Title.
- Optional caption.
- "Liking" of images, with optional Thank You/Like System plugin (TYL) integration (see per-gallery settings above).
- Image page (see below screenshot):
- Supports commenting by authorised usergroups.
- Supports comment editing and deleting by author and admins.
- Member profile:
- Image upload count ("Show all" links to gallery view of all images posted by that member in all galleries authorised for viewing by the viewing member).
- Image auto-import features:
- Multi-image display (i.e., when the first post of an auto-import thread contains multiple images):
- Gallery view: shows only the first image, but with an image count icon; clicking the icon leads to the image page.
- Image page: shows the first image full size, with thumbnails for the remaining images (example here). Clicking on a thumbnail pops up the full-sized image in the Highslide viewer.
- Auto-categorisation: based on (case-sensitive) matching of words in the import thread.
- Auto-import admin tool: auto-imports all images that haven't yet been imported in the stipulated forum(s).
- Visual configurability:
- Fully templated.
- Templates are customisable per gallery.
- Customisable stylesheet.
- A sensibly designed breadcrumb system which shows when filtering by category and/or posting member.
![[Image: mygallery-image-page-with-comments-scree...-02-07.png]](https://creativeandcritical.net/mybb/images/mygallery-image-page-with-comments-screenshot-2022-02-07.png)
Current limitations:- Animation in GIFs/PNGs is not supported when watermarking and when generating thumbnails: those images become static.
- No listing of categories on each gallery page from which to choose to filter by; can only filter by clicking on the category of an existing image.
- Alerts and email notifications not supported, neither for (1) notification of new images posted to a gallery, nor (2) notification of new comments on a gallery image, nor for any other event.
- Etc.
|
|
|
| An error with Conversations |
|
Posted by: birdfeedr - 2021-10-20, 10:26 AM - Forum: MyConversations
- Replies (12)
|
|
db is MySQLi, maybe other variables apply, but this is my current SQL Mode setting
sql mode ![[Image: dot.gif]](https://cpanel.ho-lee-fooks.com/cpsess2600878778/3rdparty/phpMyAdmin/themes/dot.gif)
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Since I am not a database wizard, I am not sure of the pros/cons of ONLY_FULL_GROUP_BY directive.
I'd appreciate your scrutiny and suggestion for resolution.
Larry
Code: Your copy of MyBB has experienced an error. Details of the error include:
---
Type: 20
File: (Line no. 0)
Message
SQL Error: 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1
Back Trace: #0 errorHandler->email_error(20, SQL Error: 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1, , 0) called at [/home/hlf/public_html/forum/inc/class_error.php:195]
#1 errorHandler->error(20, Array ([error_no] => 1055,[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by,[query] =>
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1)) called at [/home/hlf/public_html/forum/inc/db_mysqli.php:597]
#2 DB_MySQLi->error(
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1) called at [/home/hlf/public_html/forum/inc/db_mysqli.php:337]
#3 DB_MySQLi->query(
SELECT * FROM (
SELECT c.cid,
c.uid,
GROUP_CONCAT(p.uid) AS puids,
c.subject
FROM mybb_cnv_conversations c
LEFT OUTER JOIN mybb_cnv_participants p
ON p.cid = c.cid
WHERE c.subject = 'New Reply to 6 years ago'
AND
c.uid IS NULL
GROUP BY p.cid
) innerqry
WHERE puids = '98'
ORDER BY cid DESC
LIMIT 1) called at [/home/hlf/public_html/forum/inc/plugins/converse/converse-pm-datahandler-override.php:149]
#4 PMDataHandler->insert_pm() called at [/home/hlf/public_html/forum/inc/functions.php:8816]
#5 send_pm(Array ([subject] => New Reply to 6 years ago,[message] => dingo,
WiMStang has just replied to a thread which you have subscribed to. This thread is titled 6 years ago.
|
|
|
|
| MyConversations: releases and other announcements |
|
Posted by: Laird - 2020-06-06, 09:05 AM - Forum: MyConversations
- Replies (13)
|
|
MyConversations is a conversation plugin for MyBB. Information about this plugin can be read on its current homepage, MyConversations: a conversation plugin for MyBB.
This thread is for release and other announcements regarding MyConversations.
MyConversations is installed on this forum, and you are welcome to create a free account (or two or three) with which to test it. To facilitate testing of conversations with multiple participants, you may use the same registration email address for multiple accounts.
Four test accounts have been set up to be included in any test conversations/groups that you want to start: Willow, Xavier, Yasmine, and Zane. Be aware though that I will be the ultimate recipient of any messages you send those accounts, so don't write anything that you don't want me to see.
Due to the nature of this thread, it is closed to replies from anyone but me. If you wish to ask questions, report bugs, offer suggestions, criticise, or otherwise discuss this plugin, then please create a new thread in this forum for your topic.
|
|
|
|
|
![[Image: 2011-12-21_14-13-00-north-easterly-view-...medium.jpg]](https://creativeandcritical.net/images/photography/2011-12-21_14-13-00-north-easterly-view-of-Darwin-Dam-from-western-edge-of-the-wall.medium.jpg)
![[Image: mygallery-screenshot-2022-02-07.png]](https://creativeandcritical.net/mybb/images/mygallery-screenshot-2022-02-07.png)