Patch 3.0.2

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Patch 3.0.2

Postby cwpc » Wed Oct 15, 2008 1:42 am

Are there any changes we need to make in our rosters to support Inscription and the New Talents?
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

Patch 3.0.2

Postby zanix » Wed Oct 15, 2008 10:23 am

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
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Patch 3.0.2

Postby tuigii » Wed Oct 15, 2008 2:19 pm

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 ?
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

Patch 3.0.2

Postby PleegWat » Wed Oct 15, 2008 2:53 pm

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.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Patch 3.0.2

Postby Ulminia » Wed Oct 15, 2008 5:40 pm

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...
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Patch 3.0.2

Postby AnthonyB » Wed Oct 15, 2008 6:57 pm

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
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Re: Patch 3.0.2

Postby tuigii » Thu Oct 16, 2008 5:26 am

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
Last edited by tuigii on Thu Oct 16, 2008 12:05 pm, edited 2 times in total.
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

Patch 3.0.2

Postby AnthonyB » Thu Oct 16, 2008 4:22 pm

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
Roster 2.0.2 svn [latest] latest trunk SVN svn [latest] running on IIS7/Windows Server 2008 SP2 | MySQL 5.0.85 | PHP 5.2.10 | Yes, Roster and PHP rocks on IIS! Even run as FastCGI extension!
User avatar
AnthonyB
Gimpy Developer
Gimpy Developer
 
Posts: 346
Joined: Tue Jul 04, 2006 2:44 pm
Location: Sydney, Australia

Patch 3.0.2

Postby Ulminia » Thu Oct 16, 2008 4:58 pm

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 of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: Patch 3.0.2

Postby tuigii » Thu Oct 16, 2008 6:42 pm

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 :cheers:
The errror has been "exploded".
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

Patch 3.0.2

Postby Samadhi » Thu Oct 16, 2008 8:27 pm

I ran into this last night as well. What's the fix?
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Patch 3.0.2

Postby Ulminia » Thu Oct 16, 2008 9:44 pm

open update.lib.php in the lib folder replace lines 2215 (and 2216) with the ones i posted above and wala done...
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Patch 3.0.2

Postby Samadhi » Thu Oct 16, 2008 9:55 pm

Thanks, Ulminia! I misread that as being a solution to a different problem. I appreciate the quick response!
Image
User avatar
Samadhi
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Mon Jul 17, 2006 10:38 pm
Location: NJ, USA

Patch 3.0.2

Postby cwpc » Fri Oct 17, 2008 6:33 pm

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
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

Re: Patch 3.0.2

Postby tuigii » Fri Oct 17, 2008 6:46 pm

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 :rofl:

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.
Last edited by tuigii on Fri Oct 17, 2008 6:48 pm, edited 1 time in total.
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

Next

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron