readArsenalDBCs.php and Talents bug

[Gremlin]

Hi, i have a couple of doubts:

1.- It is there a way to use readArsenalDBCs.php?? Because when i try
to use it, it says "All done", but it doesnt create the new entrys on
arsenaldata.sqlite3.

2.- I have visited http://arsenal.rising-gods.de. That server is on
3.3.2 right now. The thing is, that 2 things work perfectly there, but
on the last rev. (r31) they dont. They are:

a) achievement-firsts.xml
b) character-talents.xml : This is very strange. On r31, the talents
are all messed up, but on http://arsenal.rising-gods.de they are
perfectly displayed. I know this, because i have an account on that
server. Now, there is something very strange that may help you fix
this: The first 2 rows of talents are PERFECTLY displayed, but the
rest is not. Always is the same, no matter the character, always just
the first 2 rows are displayed well, but the rest is a mess. Im pretty
sure is not a DB problem, because, for example:

This is a build for my rogue, that in http://arsenal.rising-gods.de it
shows like:
30530310500210252012330100000000000000000000000000000005320232100020100000000000000

Which is:

305303105002102520123301000 (Assasination)
0000000000000000000000000000 (Combat)
5320232100020100000000000000 (Subtlety)

But in r31, it shows like:
305303010300110222012330100
0000000000000000000000000000
5320230110002010000000000000

And it is the exactly same build. Notice that the first 6 digits of
each talent three (Assasination, combat and subtlety) are the same.
This "first 6 digits" rule (that is the same that "first 2 rows of
talents") applies to EVERY class in the game, so that is why i think
is not a DB problem, but a grabber or/and Character.class.php one.

Even so, on r31, in Profile (character-sheet.xml), under "Talent
Specialization", the number combination is accurate, but, when i move
to Talents and Glyphs (character-talents.xml) it is not accurate at
all.

Im VERY sorry for the very long post. I hope you can help me with
this.Thanks in advance.

[Amras Taralom]

hi,

of course readArsenalDBCs.php works. but as an "advanced" part of the
arsenal you should have decent php knowledge to activate it. besides this
i'm currently reworking the extractor, making it more flexible, much faster
and consuming much less ram. but as always... when it's done ;)

as to the 2nd problem it seems it works ok with 3.3.2 but not 3.3.3? because
otherwise arsenal.rising-gods.de has exactly the same version of the
grabbers and arsenal that is on the svn here at google code.
achievement-firsts.xml are not completely working (naxx 25 achieve is not
show for example) but yes, partly working. same with the svn-version.

Greetings, Martin.



--------------------------------------------------
From: "Gremlin" <chingat...@gmail.com>
Sent: Wednesday, May 19, 2010 9:08 AM
To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: readArsenalDBCs.php and Talents bug

[Gremlin]

The thing is, that neither achievement-firsts.xml or character-
talents.xml are working properly, on 3.1.3, 3.2.2a, 3.3.2 or 3.3.3.
The achievement ladder does not work because it shows a blank section
and thats it. The talents, because just the first 2 rows are correctly
displayed. Its not because of the patch, because the changes on
talents are minimal between patches.

Its not a DB problem, because there is a pattern: First 2 rows always
correct, and the rest is a mess. I really think this it is a grabber
or/and Character.class.php problem.

Or maybe someone on http://arsenal.rising-gods.de fix this two
problems. I really dont know.

Maybe you can tell me in which part of the code the talents are
transformed into that long code?? ("3053031050021025201233010 etc
etc...")

[Amras Taralom]

it's just me working on the arsenal... so no one could've changed it without
my knowledge *g*
transform happens in Character.class.php via the private function
parseTalents($spells, $spec) (lines 1900+)

data comes from 3.1.3 dbc there... maybe it has to do with that. if you look
at the function you'll see it just reads talent trees from the data db (ergo
from dbc) and checks wether the char has an active spell in his list of
spells. the highest rank found is then added to the string.



--------------------------------------------------
From: "Gremlin" <chingat...@gmail.com>
Sent: Wednesday, May 19, 2010 5:36 PM
To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: Re: readArsenalDBCs.php and Talents bug

[Gremlin]

And http://arsenal.rising-gods.de has a 3.1.3 DB or a 3.3.2 one?
Because i only tried with the one you provided for us (3.1.3) and it
always shows correctly the 2 first rows and then is a mess. Take a
look at the examples i gave to you, the numbers passing the first 6
digits are like moved to the right on r31.

Maybe you can provide me the PHP functions from http://arsenal.rising-gods.de
so i can check what is wrong? I dont know, is the only thing in my
armory that doesnt work (with the achievements first) and is pissing
me off. xD

Thanks in advance.

[Gremlin]

Ok, i manage to solve the problem. The problem was the structure of
the table "talents" on SQL. The "rowNo" column was in VARCHAR, and the
sort was messed up because of this, because this column has to be INT.
When is varchar, the order is: 0, 1, 10, 2, 3... when is int, the
order is correct: 0, 1, 2, 3... I just changed to INT and voila, the
talents now are displayed correctly. You must change this in the sql
dump that you have for download.

Maybe the reason because i cant see achievement-first is because i use
SQL instead of sqlite??... have you ever tried the armory with SQL?

Well, and the last question: Do you have the last version of
dl_items_en_gb.php?? I have an old version and i managed to download
all the items from 3.1.3 to 3.3.3 (changing some things in the
INSERT), but one column i cant make: statmodifiers. I dont know what
goes in there and how can i get this info from the oficial armory. Can
you help me with this?

[Amras Taralom]

hm, nice you found out. problem is: in sqlite this is INT but i use an
automatic tool (ESF Database Migration Toolkit) to convert from sqlite to
the sql dump i provide (never tried to use mysql). so the tool must have
messed with the table structure, an then that's also why it works on rising
gods because we use sqlite there.

achievement-firsts is not officially supported by now and only works with
single achievements (first 80, first grand master tailor etc.). anyway check
that you have the table "arsenal_achievementladder" in your cache database,
some time ago it was not on the SQL wiki page. In
Achievementladder.class.php the actual data is processed, "SELECT
achievementid FROM achievements WHERE flags IN (256, 768);" would be a call
to the sqlite database that could go wrong if the tool messed up something.

statmodifiers is used instead of every time writing the whole text (+41 Int,
+60 strength etc). it can only partly be derived from blizz arsenal as
blizzard does not include spell IDs in their xml files. therefore i
additionally use wow.allakhazam.com as a data source. i currently habe 900
mbytes of compressed xml files here which are waiting to be processed by my
updated parser but well... it's not updated completely yet.


Greetings, Amras.



--------------------------------------------------
From: "Gremlin" <chingat...@gmail.com>
Sent: Thursday, May 20, 2010 9:00 AM

To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: Re: readArsenalDBCs.php and Talents bug

[Gremlin]

Ok, I understand. I didnt notice that "updateStatmodifiers.php" could
do that work =P, so i tried, and it worked just fine. :)

Now I just need a PHP update for the "sockets" column. Do you have
one? Its the last thing i ask, i promise. xD

Thanks for your patience.

[Amras Taralom]

what do you mean by "PHP update"? sockets are read from the blizz arsenal
xmls, too. in fact i don't really remember that anymore because i'm working
on the new version for too long already xD

Amras.


--------------------------------------------------
From: "Gremlin" <chingat...@gmail.com>

Sent: Friday, May 21, 2010 12:04 PM

To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: Re: readArsenalDBCs.php and Talents bug