Add-On Releases - vBulletin-Glossary

What is vBulletin-Glossary:

A professional glossary with features like :

• crosslinking
• attachments in entries
• edit-history
• synonyms
• optional entryfields
• vb-SEO compatible
• etc.

Installation:

- Upload all files in 'upload' to your server

- set 777-permission for the following directories:

• /vbglossar
• /vbglossar/backup
• /vbglossar/temp

- Import 'product-vbglossar.xml' in AdminCP as Add-On.

Right after the import of the productfile, go and set the usergroups. Afterwards edit the setting in AdminCP (Settings and Crosslinking). Now go to 'manage categories' and create the wanted cats.

Now the glossary should be configured and ready to use.

Update from version 1.0.0 to version 1.0.1/version 1.0.1 to version 1.1.x:

Follow the instruction of a new installation, also check the file permissions. After importing the product (overwrite: yes), check the grouprights and the settings of the glossary as there are some new features. In case the entries won't show up, please rebuild the datastore in the tools-section of the glossarin in admincp.

General:

This addon has been developed by the follwing people (a-z): Andreas, Captainslater, G?rome, Surviver and me. We spent every free minute for this project (coding, translation, tests, etc). Also MrD and Ragtek have tested during the time when this addon got developed.

In directory '/tools' you might find a usefull Script by G?rome. User of vBCMS will find a module for their portal in directory 'vbcms' which shows a random entry of the glossary.

History:

• 1.0.0 - First version
• 1.0.0 PL 1 - Fixed Version by G?rome, users can't write unwnated entries anymore.
• 1.0.1 - overwork of the code, now working with datastore and datamanager. Also we included some small new features into the addon (e. g. revert entries, inlinemod, etc).
• 1.0.2 - overwork of the code, bugs removed, a lot of new features
• 1.0.3 - fixed more small bugs and added new functions (create threads for discussions, more options for crosslinking, better options for mods/admins, etc).
• 1.0.4 - bugfix-release.
• 1.1.0 - added more main-features (synonyms can be used now, optional use of entryfields within categories, PDF-functions included, vB-SEO kompatible, TOC-list, etc)

Languages:

By default you will find the complete germany and english phrases in the product (look at ZIP-file), done by Captainslater. The turkish translation has been done by t?rkg?rc?.

More translations are welcome and it would be nice if those will be published here.

[g0rdy]

Originally Posted by byalik

There is a problem with the mod for version 4. Does anyone have a fix?

You're in the wrong thread. Go here: https://vborg.vbsupport.ru/showthread.php?t=258898

[G0F0RBR0KE]

<font face="Georgia">When using this modification. For some reason. I cannot have a paragraph.

Example what I want

Test
Test
Test

But, what I get is
Test Test Test. How do I fix this?

Version: 3.7.1</font>

[Digital Jedi]

Supposedly there's a syntax error when trying to access a category.

Invalid SQL:

			SELECT SQL_CALC_FOUND_ROWS *
			FROM vb_vbglossar_entry AS entry
			
			WHERE categoryid = 3
				AND status IN (0,1)
				
				
			ORDER BY entry.name ASC
			LIMIT 0,;

MySQL Error   : 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 '' at line 9
Error Number  : 1064

I'm not familiar with this error, but these seem to be the offending lines in vbglossar.php:

PHP Code:

    do
    {
        if (!$page)
        {
            $page = 1;
        }

        $limitlower = ($page - 1) * $perpage;

        // fetch all entries of defined category
        $hook_query_fields = $hook_query_joins = $hook_query_where = '';

        ($hook = vBulletinHook::fetch_hook('vbglossar_query_allentriesofcat')) ? eval($hook) : false;

        $entrylist = $db->query_read_slave("
            SELECT SQL_CALC_FOUND_ROWS *
            FROM " . TABLE_PREFIX . "vbglossar_entry AS entry
            $hook_query_joins
            WHERE categoryid = " . intval($catid) . "
                AND status IN (" . (($permissions['groupvbglossar'] & $vbulletin->bf_ugp['groupvbglossar']['canadminvbglossar']) ? "0,1" : "1") . ")
                $condition
                $hook_query_where
            ORDER BY " . $sqlsortfield . " " . $sortorder . "
            LIMIT $limitlower, $perpage
        ");

        $entriestotal = $db->found_rows();
        if ($limitlower >= $entriestotal)
        {
            $page = ceil($entriestotal / $perpage);
        }
    } 


But it seems to check out. Unless there's a deprecated function in here somewhere, I can't find it.