[3.2.9-3.3.x][RC] Glossary 3.0.20

[pierredu]

Extension Name: LMDI Glossary
Author: Pierre Duhem

Extension Description: Glossary for phpBB 3.2.9-3.3.x
Extension Version: 3.0.20


Features:

• * Glossary static page displaying the content of the phpbb3_glossary table

• * Glossary edition page reserved for administrator, to edit entries, create new ones, etc.

• * Glossary term tagging in topics

Extension Download: https://github.com/pierrdu/lmdi_gloss/a ... master.zip

History: this extension was ported from a MOD called Lexicon/Acronym, whose roots are pretty impenetrables. See in particular:
viewtopic.php?f=70&t=584656
viewtopic.php?f=70&t=584656&start=240
In the headers of some files, il seems that the acronym part was a project of the phpBB team, but I could not ascertain anything.

Installation:
1. Download the latest release.
2. Unzip the downloaded release, and change the name of the folder to `gloss`.
3. In the `ext` directory of your phpBB board, create a new directory named `lmdi` (if it does not already exist).
4. Copy the `gloss` folder to `/ext/lmdi/`.
5. Navigate in the ACP to `Customise -> Manage extensions`.
6. Look for `LMDI Glossary` under the Disabled Extensions list, and click its `Enable` link.

Enable the feature in the ACP (Extension tab).
Some users dislike the tagging of terms in the posts. Therefore, there is an option
to disable it individually in the UCP.

Glossary entry edition
By default, only administrators have this permission set in their group. If you want to give the permission to moderators, you should set this permission to Yes in their group. You may also want to create a special group of glossary editors.

Uninstall
1. Navigate in the ACP to `Customise -> Extension Management -> Extensions`.
2. Look for `LMDI Glossary` under the Enabled Extensions list, and click its `Disable` link.
3. To permanently uninstall, click `Delete Data` and then delete the `/ext/lmdi/gloss` folder.
Just drop the extension files in the folder ext/lmdi/gloss, then activate the extension in the ACP.

Testing
Write a topic on a test forum with the terms appearing in the variants column. This column can contain singular and plural forms, etc.

Downloading link:
https://github.com/pierrdu

[John45]

This is awesome, I'll bump the topic for ya.

[nya]

You awesome man. Nice ext. Very usable.

[nya]

Oh. Did anyone try it with non-latin letters?

[pierredu]

The table is coded as UTF-8.
This should work.
I have some greek words in the definitions, but not in the terms themselves.

[Holger]

Nice!
Demo? Screenshots?

[pierredu]

You can download the current version from github. See the link in the first post.
With the two dummy entries, you can see what happens.

[nya]

Table '1111_forum.phpbb_glossary' doesn't exist [1146]

SQL

SELECT DISTINCT UPPER(LEFT(TRIM(term),1)) AS a FROM phpbb_glossary ORDER BY a

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/lmdi/gloss/glossaire.php
LINE: 54
CALL: phpbb\db\driver\factory->sql_query()

[mrgoldy]

He's posted table information in the Readme:
https://github.com/pierrdu/lmdi_gloss/b ... /README.md

@pierredu,
You can add tables and 'dummy files' through you migration file(s) aswell.
You can read more about it here

[nya]

Thank you for answer, but i didnt realize how to do this:

CREATE TABLE phpbb3_glossary ( term_id mediumint(9) NOT NULL AUTO_INCREMENT, variants varchar(80) NOT NULL DEFAULT '', term varchar(80) DEFAULT NULL, description varchar(512) NOT NULL DEFAULT '', picture varchar(80) DEFAULT NULL, lang varchar(15) NOT NULL DEFAULT 'fr', PRIMARY KEY (term_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I havent migration files.

[pierredu]

This is a SQL command. Use it in phpMyAdmin or in Adminer.
But I'll write a migration file for that.

[Jessica]

Can you post screenshots please?

[pierredu]

Here are two screenshots from the extenson running on my development server:



This show the static display page of the glossary (feature 1 in the presentation post above).



This shows how terms are tagged in the posts. In this sample, tagged terms are 'tergite', 'tergites', 'sternites' and 'agglomerat'. Note that the singular and plural forms (tergite(s)) is a single entry in the glossary.

When hovering above the terms, the cursor becomes the question mark (not visible on the screenshot). If one clicks on the 'agglomérat' term, one gets the popup on the right, with the term, the explanation and a picture. A classical close box is present. If there is no picture, we use a single white pixel file.

On the other hand, I added the creation of the table and of the dummy entries in the migration file.

[Holger]

Very nice!
So, when a term is used in a forum-post there will be a link to the item in the glossary?

[pierredu]

It is not exactly a link to the item. The content of the item is displayed in a popup window within the topic. The link to the glossary is at the top of the page, in the tool bar.

[Edition: spell checking]