[ABD] Lexicon / Acronym MOD

[rosdi]

Mod completed.

I also encountered a sql error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'bettasoc_forum.bettasoclexicon' doesn't exist [1146]

SQL

SELECT DISTINCT UPPER(LEFT(TRIM(term),1)) AS a FROM bettasoclexicon WHERE lang = 'en-gb' ORDER BY a

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: lexicon.php
LINE: 23
CALL: dbal_mysql->sql_query()

If you see carefully the SQL statement in creating the table from install_mod.xml:

Code: Select all

CREATE TABLE `phpBB_lexicon` (
  `term_id` mediumint(9) NOT NULL auto_increment,
  `acronym` varchar(80) NOT NULL default '',
  `term` varchar(80) default NULL,
  `description` varchar(255) NOT NULL default '',
  `long_desc` longtext,
  `lang` varchar(15) NOT NULL default 'de',
  PRIMARY KEY  (`term_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

You need to refer your table forum prefix. Like from the above statement, the prefix is phpBB_. If you table prefix is betta, it should be:

Code: Select all

CREATE TABLE `bettalexicon` (
  `term_id` mediumint(9) NOT NULL auto_increment,
  `acronym` varchar(80) NOT NULL default '',
  `term` varchar(80) default NULL,
  `description` varchar(255) NOT NULL default '',
  `long_desc` longtext,
  `lang` varchar(15) NOT NULL default 'de',
  PRIMARY KEY  (`term_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

Good luck.

Please someone help me to translate this wording: "Den gewünschten Buchstaben oben auswählen!" to English. It call from style/your_style/template/lexicon.html.

Another question is; how can I add the:

1. term_id - to start with what number?
2. acronym - please give sample
3. term - please give sample
4. description - maybe I know
5. long_desc - maybe I know
6. lang - please give sample

Thanks.

[rosdi]

Found why; I need to add the Mod Module in ACP.

I made a test for Term: STM.
Why in: http://www.bettasocietymalaysia.com.my/ ... p?letter=S&, it won't show.
It will show in: http://www.bettasocietymalaysia.com.my/ ... letter=All&

When I add the word STM in post, it will not show.

Help

Thanks.

[rosdi]

Do I need to upload lexicon.css file?

I'm using Avalon Theme. In this theme, there are no below files to edit for install_mod_ajax instructions:

1. style/Avalon/theme/common.css,
2. style/Avalon/theme/colors.css

How to go about that?

Anyway, do your lexicon_0.1.4 version is completed. This is the file that I downloaded.

[rosdi]

Could someone goto: http://www.kaninchenwissen.de/viewtopic ... t=43&#p496 (understand the language) to post and ask the author to give support here.

[upsD]

no idea?

ot
wird noch daran gebaut oder ist das mal wieder nen mod der ins leere geht wie so viele?
ot end

[rosdi]

No feedback by the author. Sight...

[rosdi]

Any news?

[Unimatrix_0]

I just asked in the board ... we will see if their's any reaction @

http://www.kaninchenwissen.de/viewtopic ... 4387#p4387

[rosdi]

I tried many times already. Still fail. Sight...

[reh]

A gentle user is about writing standard templates and correcting the install file for a new download.

I dont know, how pics can be inserted in descriptions and i have currently no time to look for it (and i dont need it). So if anybody like it, he is invited to change it to work with pics.

And if there are a regex guru anywhere, he is also invited to made a allpurpose perfect regex for the mod.

[rosdi]

At least you are giving us working mod and correct instruction. Else, better to ask Admin to remove this mod from this board.

[jonkad]

Cannot find module ./../includes/acp/acp_acronyms.php

To resolve this error please rename
root/includes/acp/acp_lexicon.php
and
root/includes/acp/info/acp_lexicon.php

to acp_acronyms.php

then you must open the root/includes/acp/acp_lexicon.php file

find:

Code: Select all

class acp_lexicon

replace with

Code: Select all

class acp_acronyms

Open: root/includes/acp/info/acp_lexicon.php

find:

Code: Select all

class acp_lexicon_info

replace with:

Code: Select all

class acp_acronyms_info

Have Fun,
Jonathan

[jonkad]

Here is the latest version (0.1.4) without installation errors:


http://www.evjufo.de/download/lexicon_v.0.1.4.zip

[rosdi]

Good. I downloaded it already. Let us see how.

Thanks.

[theMomo]

Here is the latest version (0.1.4) without installation errors:


http://www.evjufo.de/download/lexicon_v.0.1.4.zip

Thx for this version. The lexicon works now.

Another question: I don't understand what I have to do to link the acronyms with the description.
There is no link. I thought if I had a word like phpbb for example, it would be linked to the description in the lexicon. What's my failure?

Thx