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.

[t?rkg?rc?]

Originally Posted by WildSoftCat

Problem with popup showing in different coding (seems as unknown language ) fixed.

Edit functions_vbglossar.php in include folder :

1. Find

PHP Code:

function fetch_glossar_items()
{
    global $vbulletin; 


Replace with :

PHP Code:

function fetch_glossar_items()
{
    global $vbulletin, $stylevar; 


2. Find :

PHP Code:

$item['description'] = htmlentities($item['description']); 


Replace with :

PHP Code:

$item['description'] = htmlentities($item['description'], ENT_COMPAT,  "$stylevar[charset]" ); 


Done

incompatible with version 1.1.0

[i156]

Originally Posted by t?rkg?rc?

@i156
I'm getting the same error

I have talked with someone that said they can probably fix it but I was hoping to hear from the person that actually made this module instead of paying for someone to fix it. Oh well.

[Chadi]

Crosslinking css area in styles > main css is not working at all.

As a matter of fact, the mod is over-riding other css for another mod that works globally (logos.com pop-up scripture tool) that automatically highlights Scripture verses in hyperlink css. Even that is getting over-ridden by this glossary mod.




hover, orange link not showing



no hover, no css




The above problem happens inside the glossary itself only, not forum posts.


Another problem is that the "Display of x characters in preview popup for crosslink" is void, not doing anything. I even changed it to 1000 characters and it still displays about 250-300 chacters max on words that have over even 30k characters total. Yes, I also increased max width to 350 from default 250. The width changed, not max characters.

[i156]

Vossi, I see you have logged in since I posted the errors that I'm constantly getting everyday. I've moved to a new server so didn't get someone to fix it yet. Can you possibly tell me why I'm getting these errors before I have to pay for someone to fix it? I'm also trying to figure out if it is worth paying to get fixed or just remove the modules from my site and just deal with losing all that content.

My latest error, few minutes ago:

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbglossar_entry AS entry
LEFT JOIN vbglossar_category AS cat ON(cat.id = entry.categoryid)

WHERE entry.status IN (1)
AND cat.status IN(1)
AND userid = 1259
AND name LIKE("F%");

MySQL Error : Column 'name' in where clause is ambiguous
Error Number : 1052
Request Date : Tuesday, February 17th 2009 @ 10:42:07 PM
Error Date : Tuesday, February 17th 2009 @ 10:42:07 PM
Script : http://www.usacarry.com/forums/vbglo...name&order=ASC
Referrer :
IP Address : 82.99.30.47
Username : Unregistered
Classname : vB_Database
MySQL Version :

[alehawk]

i156 I got to different forums running and I got that error in one of them, is not the server, maybe this error is because some other product.
I read about this and it is said that is a google spider issue and you must disalow vbglossar.php in robots.txt
I havent tested yet.
Maybe you can give it a try.

[ragtek]

Originally Posted by i156

Vossi, I see you have logged in since I posted the errors that I'm constantly getting everyday. I've moved to a new server so didn't get someone to fix it yet. Can you possibly tell me why I'm getting these errors before I have to pay for someone to fix it? I'm also trying to figure out if it is worth paying to get fixed or just remove the modules from my site and just deal with losing all that content.

My latest error, few minutes ago:

edit the vbglossar.php

search
- line 2887

PHP Code:

$condition = ' AND name NOT REGEXP("^[a-zA-Z]")'; 


replace with

PHP Code:

$condition = ' AND entry.name NOT REGEXP("^[a-zA-Z]")'; 


- line 2892

PHP Code:

$condition = ' AND name LIKE("' . $db->escape_string_like($ltr) . '%")'; 


replace with

PHP Code:

$condition = ' AND entry.name LIKE("' . $db->escape_string_like($ltr) . '%")'; 


- in line 2947

PHP Code:

AND userid = " . intval($userid) . " 


replace with

PHP Code:

AND entry.userid = " . intval($userid) . " 


[i156]

Thanks. I've just made these changes. Hopefully that fixed my problem!

[alehawk]

Yes, yesterday I made the same changes and I didnt get any error email since then.

[i156]

Same here, no errors since.

[ragtek]

fine fine