Make a version for roster V2 ?

Categorizes items in your guildbank(s)

Moderator: Mathos

Make a version for roster V2 ?

Postby titan99 » Fri Aug 31, 2007 3:20 pm

simple question in title :)
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Make a version for roster V2 ?

Postby zanix » Fri Aug 31, 2007 10:37 pm

I think mathos was talking about it on the irc chat room
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Make a version for roster V2 ?

Postby tuigii » Sat Sep 01, 2007 6:25 am

" 2.0.0 Beta / prelease 1 " will do fine, no ?
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Make a version for roster V2 ?

Postby sileed » Mon Sep 10, 2007 8:00 pm

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.
ImageImage
User avatar
sileed
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Tue Jul 04, 2006 5:05 pm

Re: Make a version for roster V2 ?

Postby titan99 » Mon Sep 10, 2007 8:22 pm

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');
Attachments
banktry.zip
bank try
(12.73 KiB) Downloaded 319 times
Last edited by titan99 on Mon Sep 10, 2007 8:55 pm, edited 1 time in total.
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Re: Make a version for roster V2 ?

Postby kalimucho » Tue Sep 11, 2007 5:16 am

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
User avatar
kalimucho
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Aug 28, 2007 3:41 pm
Location: Paris, France

Make a version for roster V2 ?

Postby SethDeBlade » Tue Sep 11, 2007 6:16 am

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.
Mysql: 4.1.21
php: 5.2.0
User avatar
SethDeBlade
WR.net Expert
WR.net Expert
 
Posts: 192
Joined: Thu Jul 06, 2006 1:02 am
Location: Germany

Make a version for roster V2 ?

Postby titan99 » Tue Sep 11, 2007 3:17 pm

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

make category and rules in admin panel
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Re: Make a version for roster V2 ?

Postby kalimucho » Tue Sep 11, 2007 6:43 pm

ok thanks
User avatar
kalimucho
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Aug 28, 2007 3:41 pm
Location: Paris, France

Make a version for roster V2 ?

Postby Blueleaf » Sat Oct 06, 2007 10:42 am

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
User avatar
Blueleaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Apr 26, 2007 12:06 am
Location: Minot, ND

Make a version for roster V2 ?

Postby bisaz » Sun Oct 07, 2007 10:21 pm

Same Question as Blueleaf ... Bump :)
bisaz
WR.net Apprentice
WR.net Apprentice
 
Posts: 24
Joined: Sun Dec 10, 2006 6:31 am

Make a version for roster V2 ?

Postby foreseit » Thu Oct 11, 2007 8:24 am

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. :)
<a href="thehateguild.com"><img src="/anetheron/addons/siggen/sig.php?name=Foreseit"></a>
User avatar
foreseit
WR.net Journeyman
WR.net Journeyman
 
Posts: 139
Joined: Tue Jul 25, 2006 10:03 pm

Make a version for roster V2 ?

Postby Averen » Tue Oct 23, 2007 11:55 pm

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.
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

Re: Make a version for roster V2 ?

Postby tuigii » Wed Oct 24, 2007 3:45 am

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 :-)
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Make a version for roster V2 ?

Postby Averen » Wed Oct 24, 2007 7:31 pm

Damn, looks like I have to stop procrastinating then. :P Ok I'll get on it.
User avatar
Averen
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 152
Joined: Thu Jul 20, 2006 5:18 am

Next

Return to Categorized Guild Bank

Who is online

Users browsing this forum: No registered users and 0 guests

cron