simple question in title

I think mathos was talking about it on the irc chat room

" 2.0.0 Beta / prelease 1 " will do fine, no ?

I think the categorized guild bank was a great option.

Being able to sort and filter items for display was and still is a huge help for our guild.

this addons try bank by rules fixed in admin panel

sample of rules

INSERT INTO `roster18_addons_BankTry_rules` (`id`, `lang`, `id_category`, `rule`, `champ`)
VALUES
(2, 'frFR', 4, 'Barre %', 'item_name'),
(3, 'frFR', 3, '%Lié quand équipé%', 'item_tooltip'),
(4, 'frFR', 2, '%dégâts par seconde%', 'item_tooltip');

hi,

I've tried your addon and i get

Code: Select all

1064: 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 ') AND NOT ( ) AND i.`item_slot` NOT LIKE 'Bag0' AND i.`item_slot` NOT LIKE '' at line 3
SQL:
SELECT i.*, sum( `item_quantity` ) as Nb FROM `roster_items` as i WHERE ( ) AND NOT ( ) AND i.`item_slot` NOT LIKE 'Bag0' AND i.`item_slot` NOT LIKE 'Bag1' AND i.`item_slot` NOT LIKE 'Bag2' AND i.`item_slot` NOT LIKE 'Bag3' AND i.`item_slot` NOT LIKE 'Bag4' AND i.`item_slot` NOT LIKE 'Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag0' AND i.`item_slot` NOT LIKE 'Bank Bag1' AND i.`item_slot` NOT LIKE 'Bank Bag2' AND i.`item_slot` NOT LIKE 'Bank Bag3' AND i.`item_slot` NOT LIKE 'Bank Bag4' AND i.`item_slot` NOT LIKE 'Bank Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag6' AND i.`item_slot` NOT LIKE 'Bank Bag7' AND i.`item_parent` NOT LIKE 'equip' GROUP BY i.item_name ;
File: lib/dbal/mysql.php
Line: 203
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 236
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 203
          o Function Called: die_quietly
          o Arguments:
                + 1064: 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 ') AND NOT ( ) AND i.`item_slot` NOT LIKE 'Bag0' AND i.`item_slot` NOT LIKE '' at line 3
                + Database Error
                + /mnt/167/sdb/e/9/kalidudu/roster/lib/dbal/mysql.php
                + 203
                + SELECT i.*, sum( `item_quantity` ) as Nb FROM `roster_items` as i WHERE ( ) AND NOT ( ) AND i.`item_slot` NOT LIKE 'Bag0' AND i.`item_slot` NOT LIKE 'Bag1' AND i.`item_slot` NOT LIKE 'Bag2' AND i.`item_slot` NOT LIKE 'Bag3' AND i.`item_slot` NOT LIKE 'Bag4' AND i.`item_slot` NOT LIKE 'Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag0' AND i.`item_slot` NOT LIKE 'Bank Bag1' AND i.`item_slot` NOT LIKE 'Bank Bag2' AND i.`item_slot` NOT LIKE 'Bank Bag3' AND i.`item_slot` NOT LIKE 'Bank Bag4' AND i.`item_slot` NOT LIKE 'Bank Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag6' AND i.`item_slot` NOT LIKE 'Bank Bag7' AND i.`item_parent` NOT LIKE 'equip' GROUP BY i.item_name ;
    * addons/BankTry/guild/no_rules.php
          o Line: 67
          o Function Called: query
          o Arguments:
                + SELECT i.*, sum( `item_quantity` ) as Nb FROM `roster_items` as i WHERE ( ) AND NOT ( ) AND i.`item_slot` NOT LIKE 'Bag0' AND i.`item_slot` NOT LIKE 'Bag1' AND i.`item_slot` NOT LIKE 'Bag2' AND i.`item_slot` NOT LIKE 'Bag3' AND i.`item_slot` NOT LIKE 'Bag4' AND i.`item_slot` NOT LIKE 'Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag0' AND i.`item_slot` NOT LIKE 'Bank Bag1' AND i.`item_slot` NOT LIKE 'Bank Bag2' AND i.`item_slot` NOT LIKE 'Bank Bag3' AND i.`item_slot` NOT LIKE 'Bank Bag4' AND i.`item_slot` NOT LIKE 'Bank Bag5' AND i.`item_slot` NOT LIKE 'Bank Bag6' AND i.`item_slot` NOT LIKE 'Bank Bag7' AND i.`item_parent` NOT LIKE 'equip' GROUP BY i.item_name ;
    * addons/BankTry/guild/index.php
          o Line: 118
          o Function Called: require
          o Arguments:
                + /mnt/167/sdb/e/9/kalidudu/roster/addons/BankTry/guild/no_rules.php
    * index.php
          o Line: 112
          o Function Called: require
          o Arguments:
                + /mnt/167/sdb/e/9/kalidudu/roster/addons/BankTry/guild/index.php


i would like to have a categorized bank again because i prefer this one more then the default one. the one that comes with the roster is disabled in my 1.7.3 roster.

@kalimucho if you have don't have adding category and rules you have this error

make category and rules in admin panel

ok thanks

Has anyone made any progress with this, I used the Bank try but just lumps everything together.
Does anyone have enUS rules that work that could be provided as an example? Also the config menu shows no descriptive text. and get following PHP errors.

Code: Select all

addons/BankTry/guild/index.php
  Notice line 23: Undefined index: BankTry_title_addon
  Notice line 39: Undefined index: BankTry_perso
  Notice line 81: Undefined index: BankTry_perso
  Notice line 89: Undefined index: BankTry_title_addon
  Notice line 114: Undefined index: BankTry_divers
  Notice line 122: Undefined index: BankTry_title_addon

Same Question as Blueleaf ... Bump

Bump for a great mod. As cool as Roster 2.0 is, if this mod (and the bank request mod possibly) doesn't make it to Roster 2, I'm just gonna stick with 1.7.3. Please update for Roster 2.0, and we'll love you forever.

I was waiting till 2.3 hits and the new guildbank system is operational before working on it but I could start on it if there's a lot of people that want it.

Averen wrote:I was waiting till 2.3 hits and the new guildbank system is operational before working on it but I could start on it if there's a lot of people that want it.

You're kidding ?
For being the techical maintainer of 4 guilds, I can tell you : it's a very usefull addon. With the new NPC Banker it will be better yet.

I use an adaped version of the Cat Bank with order request on an old 1.7.3 roster: mine sends a 'command passed' mail to the banker.
I'll drop it in when Cat Bank V2 comes out with the "click - I want this" option :-)

Damn, looks like I have to stop procrastinating then. Ok I'll get on it.