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.

[Chadi]

Originally Posted by 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.

Would appreciate help on the above.

[exportforce]

Initialisiere Datastore/initialize datastore ...
Warnung: require_once([path]/includes/adminfunctions_vbglossar.php) [function.require-once]: failed to open stream: No such file or directory in [path]/admincp/plugin.php(1985) : eval()'d code (Zeile 22)

Fatal error: require_once() [function.require]: Failed opening required '/var/www/web10/html/forum/includes/adminfunctions_vbglossar.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web10/html/forum/admincp/plugin.php(1985) : eval()'d code on line 22

VBulletin 3.7.3
Won't get it to run.
Help please.

[ragtek]

Is this by trying to install the glossary?
if yes:

You've read the readme.txt??

Copy all files and directories of '/upload' into your forumroot.
The following directories need 0777 FTP-permissions:

/vbglossar
/vbglossar/backup
/vbglossar/temp

Afterwards import the product file in AdminCP.

You must upload the files befor you import the productfile!

[PitchouneN64ngc]

As I'm translating your mod into French, i will report any bug I can found.

- When you're using MySQLi database connection, when you export a backup, you can see 2 lines of error code. It comes from includes/class_vbcsv_vbglossar.php at line 345. Change:

PHP Code:

while ($tablefields = mysql_fetch_row($headerresult)) 


To

PHP Code:

while ($tablefields = $this->registry->db->fetch_row($headerresult)) 


- In vBulletin Options, the values in dropdown menus for external addons are hardcoded into the options.

- In admin_vbglossar.php at line 701, you have some hardcoded text:

PHP Code:

$cell[] = "<b>$date, $time Uhr</b>"; 


- The phrases 'setting_vbglossar_tagbadwordsvbglossar_taggoodwor ds_desc' and 'setting_vbglossar_tagbadwordsvbglossar_taggoodwor ds_title' are not used. You can delete them.

Anyway, when I finish this translation, i'll PM you to upload it with the mod as default

[PitchouneN64ngc]

An other thing:
- Before 1.1.0, the attachment datamanager file seems named class_attachment_vbglossar.php. and when you manage attachments to be in database (for example), it tells you the file didn't exist. The file is now named class_dm_attachment_vbglossar.php.

Edit line 296 of admincp/attachment_vbglossar.php in consequence.

And I see the attachment system is buggy with me. When I'm logged in, it tells me I'm userid 0 (line 529 of includes/class_dm_attachment_vbglossar.php). This is due because $entryinfo['userid'] is not defined from vbglossar_newattachment.php (and in this way, defined to be 0).

According to this bug report, you can do the same.

PS: in this same file (vbglossar_newattachment.php), "$entryinfo = array();" is defined 2 times.

[arabuser]

I see nobody answered the guys who reported Duplicate error (( MySQL Error : Duplicate column name 'groupvbglossar' ))

when I tried first time to install the addon it take long time proccessing the script and after that time it didnt give me complete page just white error page when I tried again to install it always get the message (( MySQL Error : Duplicate column name 'groupvbglossar' )) and I dont find the product to uninstall it coz it didnt completed correctly so how I can skip this error or uninstall the product to try install it again without error.

[ragtek]

you'll have to delete the groupvbglossar column with phpmyadmin
then you can try to install it a second time

[arabuser]

thanks ragetak for your help I deleted groupvbglossar column from usergroup table
also I was need to delete the columns crosslink and popup from user table

im now looking for some help to show bbcode include images in popup and display arabic characterset

[Gostemilov]

PHP Code:

Database error in vBulletin 3.7.4:

Invalid SQL:

            SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
                IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
                attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
            FROM vbglossar_attachment AS attachment
            LEFT JOIN attachmenttype AS attachmenttype USING (extension)
            WHERE ((posthash = 'ade354c18b97ab4fe7828f5bee72dbdd')
                AND userid = 1)
            ORDER BY attachmentid;

MySQL Error   : Illegal mix of collations (cp1251_bin,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Wednesday, March 18th 2009 @ 05:46:50 PM
Error Date    : Wednesday, March 18th 2009 @ 05:46:50 PM
Script        : http://photoshopia.ru/forum/vbglossar.php?do=updateentry
Referrer      : http://photoshopia.ru/forum/vbglossar.php?do=editentry&catid=7
IP Address    : 62.182.79.184
Username      : Gostemilov
Classname     : vb_database
MySQL Version : 4.1.22-standard 


How to fix this problem? Thanks

[Gostemilov]

Decision found. PMA -> vbglossar_attchments ->cp1251_bin -> latin1_bin