hi

I have adjust the module for german users.

the problem: after adjust the module i can add a new item to the guild item list but when i access the guild item list he said "There are no Guild Items."

can anyone help me? Here is the adjusted file.
I have only adjusted the line 53, 58, 74 and 465 with the german categorie words

This is the last link of the file so I wonder have this been fixed?
If so please give me a PM with the new file and Ill update it in the original post.

I have tried to make track of all the beautiful new improvements you all have made to this mod.
So if anyone know of any other functions this module can do at this stage please let me know in a PM.
The functions I have track of is:

!help gitems  - help meny           ~Taxoman and Jimango
!gitems          - list of items        ~Taxoman and Jimango
!gitems add <category1> <category2> <itemlink> - how to add item to list   ~Taxoman and Jimango

-Potions under misc                  ~WeZoN
-modified gems to show color   ~WeZoN  (the forum say WeZon made it, but in the mod it only say Kyr made a fix for this. I guess WeZoN made it.. right?)

!gitem search <part_of_item_name>              ~Kyr
-Show only items made by character               ~Kyr
-Show only items by category                          ~Kyr
-Show only items by category +subcategory   ~Kyr
Updated version with more categories, better function fixes and missing language fix  ~Kyr
Alternative view                                                ~Kyr

If anyone see that I have forgotten any changes or people that should be mentioned please let me know by sending me a message and I will correct it at once.
If not I will try to make a new improved first post with all the changes that have been made.

Best regards Jimango

Try replace line 43:
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zäöüßA-ZÄÖÜ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';With:
var $itemPattern = '(<a style="text-decoration:none" href="itemref:\/\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)\/([0-9a-f]*\:[0-9a-f]*\:[0-9a-f]*:[0-9a-f]*)"><font color=#([0-9a-f]*)>\[([\\-a-zäöüßA-ZÄÖÜ0-9_\'&\s\-\:]*)\]<\/font><\/a>)';

//Parse an item
    function parseitem($item)
    {
        preg_match_all("/".$this->itemPattern."/i", $item, $matches, PREG_SET_ORDER);
            foreach ($matches as $match)
            {
                $a[id] = $match[2];
                $a[ql] = $match[4];
                $a[color] = $match[7];
                $a[name] = $match[8];
            }
        return $a;
    }Into:
//Parse an item
    function parseitem($item)
    {
        preg_match_all("/".$this->itemPattern."/i", $item, $matches, PREG_SET_ORDER);
            foreach ($matches as $match)
            {
                $a[id] = $match[2];
                $a[ql] = $match[5];
                $a[color] = $match[9];
                $a[name] = $match[10];
            }
        return $a;
    }

can someone upload the complete new code that works ??

thanks alot 

Added Architect Consumable, Architect Sculpture, Architect Pillar, Architect Centerpiece, Architect Megalith, increased version to 3

Hello!
Im new to this...
Well ive setup the module and managed to add items on its db... but im getting this error when i click on the item name link:

!item 3806147
[Mercbot]: Error in query to database
Mercbot is my botname

Alread deleted the Table and restarted the bot.. any clues?