Are there any changes we need to make in our rosters to support Inscription and the New Talents?

Inscription, yes
New talents, no

Just upload your profile and the talents will fix themselves

As for inscription, there will need to be a few changes done
New locale values, correct icon needs to be located, the character skills/recipes page *should* show them without any issue, as long as the locale values are present
Addons that show/use profession data may need updates as well

zanix wrote:Just upload your profile and the talents will fix themselves

Well, maybe I just missed a step, but I'll ask it anyway : upload with WHAT ?

This : http://www.wowroster.net/Downloads/c=3.html is till pointing to the 'old' versions of CP & GP.
This : http://www.rpgoutfitter.com/addons/index.cfm (the home of CP & GP) is still 2.4.0 also.

Ok, I found that SVN at WoWRoster has a 3.0.x - should I go and use that one ?

Call me a purist, but 'normally' I never activate 'old' addons.
Do I have to make an exception ?

As far as I know our SVN is the primary CP repository now, and also the one calvin works in. One of us will probably pack it sometime this week.

We'll probably release a roster 2.0.1 this weekend or next with the DK/inscription/level cap/etc patches. New data can be housed in addons, which we may write ourselves, but will probably give the community time to write.

pleeg i have many updates for teh roster on ulminia.no-ip.org/wotlk/ that work with the current patch like pet tallents spell book fixes and companions if yall want em pm me an email address ial send you the changed files...

Calvin has done the new CP and GP but hasn't fully updated the download links.

I've found direct downloads here:

http://www.rpgoutfitter.com/files/rpgo- ... _3.0.0.zip
http://www.rpgoutfitter.com/files/rpgo- ... _3.0.0.zip

Well, Ok 3.0.2 is up and running (some what ^^)

Talent inserting should work, but I have a no go here.

Duplicate Index key SQL error.

For the talents table, this key :
PRIMARY KEY (`member_id`,`tree`,`row`,`column`)
isn't enough anymore.

I threw in a

Code: Select all

 ALTER TABLE `XXroster_talents` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `member_id` , `tree` , `row` , `column`, `maxrank` )

(I added 'column' as an extra index)

Is this a correct way of doing things ? [edit (it's late here) : the row value is clipped to 1 char, that's no good !! - the key is right, the parsing of the CP LUA is wrong here : don't do this at your home.)

and now roster updating works ^^ (using CP/GP 3.0.0)

Btw : are jou sure that this is ok : http://www.papy-team.fr/roster/index.ph ... ts&a=c:302 (61 talent points Def Warrior).
The new talents ARE missing. It seems to me that row-depth is limited to 9 - and it's 11 now.
And I'm not talking about the missing images here ;-)

[I'll be looking into it tomorrow - have to get some sleep here ^^)

re-edit : update.lib.php - line 2215 (and 2216) : the bug might be here - 'row' can be 2 char wide now ! That why 11 become 1 become invalid index in my case

O&O

hmm.. I think I'm getting a related issue but with a different error:

Database Error1366: Incorrect integer value: ':' for column 'column' at row 1
SQL:
INSERT INTO `roster_talents` SET `member_id` = '70', `name` = 'Chimera Shot', `tree` = 'Marksmanship', `tooltip` = 'Chimera Shot\nRank 1/1\n514 Mana 5-41 yd range\nInstant cast 10 sec cooldown\nRequires Ranged Weapon\nYou deal 125% weapon damage, refreshing the current Sting on your target and triggering an effect:\n\nSerpent Sting - Instantly deals 40% of the damage done by your Serpent Sting.\n\nViper Sting - Instantly restores mana to you equal to 60% of the total amount drained by your Viper Sting.\n\nScorpid Sting - Attempts to Disarm the target for 10 sec. This effect cannot occur more than once per 1 minute.', `texture` = 'ability_hunter_chimerashot2', `row` = '1', `column` = ':', `rank` = '1', `maxrank` = '1'
File: lib\dbal\mysql.php
Line: 240

AnthonyB
your errir is caused by an array issue
find

Code: Select all

                  $this->add_value('row', substr($data_talent_skill['Location'], 0, 1) );
                  $this->add_value('column', substr($data_talent_skill['Location'], 2, 1) );


change too

Code: Select all

list($locationr,$locationc ) = explode(":", $data_talent_skill['Location'], 2);
                  $this->add_value('row', $locationr );
                  $this->add_value('column', $locationc );


that shoudl do it

Ulminia wrote:AnthonyB
your errir is caused by an array issue
find

Code: Select all

                  $this->add_value('row', substr($data_talent_skill['Location'], 0, 1) );
                  $this->add_value('column', substr($data_talent_skill['Location'], 2, 1) );


Aha :
update.lib.php - line 2215 (and 2216)

AnthonyB wrote:hmm.. I think I'm getting a related issue but with a different error:

Database Error1366: Incorrect integer value: ':' for column 'column' at row 1
SQL:
INSERT INTO `roster_talents` SET `member_id` = '70', `name` = ......

Thanks for the confirmation, Ulminia
The errror has been "exploded".

I ran into this last night as well. What's the fix?

open update.lib.php in the lib folder replace lines 2215 (and 2216) with the ones i posted above and wala done...

Thanks, Ulminia! I misread that as being a solution to a different problem. I appreciate the quick response!

Thanks for that fix - i can now upload my profiles...



Do we have any ETA on a new image pack to add the new talent icons?

also an update to roster to enable the higher levels and Inscription and Achievments (dont know if a change is needed to CP for achievments as well)?

Thanks again for all your hard work

cwpc wrote:Do we have any ETA on a new image pack to add the new talent icons?

Yep, we have.
It's was about 2 minutes before you posted here

cwpc wrote:also an update to roster to enable the higher levels and Inscription and Achievments (dont know if a change is needed to CP for achievments as well)?

If you want to force your Guild members to use the new CP (& GP for the Off's) then change the 2.4.0 valeus for 3.0.0 - it works for me.

The new "3.0.2 Patch" CP & GP addons are available - see the links in THIS very thread.