Yeah, Akkadius, that is what I had mentioned. My bet is that they use that to call a script that has the correct model number to apply when doing the combine. We don't need to implement them the same as Live does, as long as we can find a way that works and is easy enough to manage after getting item dumps from 13th floor.
Seems to me that they realized using scripts to handle the combine is not a very smart way to handle it and made it so they can do it via the DB instead. Though, I am wondering if they have some kinda hash in the script that handles the part that deals with what ornamentation models can work with what type of weapon.
Looking closer at their charm script file names, it appears they are categorized by the type of item, such as "ITEMTransfigShield" and "ITEMTransfig1HB" in the 2 examples I gave. Since I don't see anything else in the fields of those items that specify item type for the type that can be used, I assume that string is used to determine that. So, I still think we could get away with not having to use individual script files or anything funky like that. We should be able to just do a switch case on the type of item that is trying to be ornamented, and then to a string compare against the known charmfileids for each type to see if it matches the correct type for that ornamentation container.
Yeah, Cavedude, that query is useful. Looks like it wouldn't take long at all to make a query to add the correct models for each of the ones set to IT63. I am still not sure of the best way to provide that query to people, other than giving a warning about being careful when you run it from the SVN as an optional update. Once we have the query in created, it wouldn't be too hard to just remember to update that whenever you do another 13th floor dump.
It is kinda odd that they have some newer ones with the model numbers and some without. Could be that it is due to multiple people working on items and doing them differently I guess. Could also be that they still don't use the model numbers there, but that they add them in just for reference.
Either way, I still have to work out the corpse blob stuff first I think. SQLDev01 was kind enough to help (he did most of the work lol) create the query to move the blobs out into individual fields of some new tables that will replace the existing one for player_corpses. Though, I will still need to check with devs about the old "classic_db" blob format to see if that needs to be dealt with as well, cause that could make things considerably harder to work out with a single query for all corpse blobs. I can leave that discussion for another thread though, heh.
|