item db - Page 2

kai_shadowbane · #16 10-17-2003, 04:29 AM

actually, it wasn't 1+2+4
it was
[Class Flag #]-[Highest Class flag # that can be taken out of it]-[Next Highest Class Flag #, etc]
as that would be the most efficient way of coding it minus having all the #s as a seperate entity. (like having each class be a number, and then class combinations be others, but that would be more than a few objects to make)
The binary idea could only have 1 flaw when you have like 12 classes, and if your binary conversion drops leading zeros. e.g. 0000000111 becoming 111 instead (as it wouldn't negate the leading classes, and to do otherwise would be more coding).

I dunno, I just think it might be easier to code it the way I was mentioning, since that could easily cover any more added classes they might want to throw into in the future (ala the Froglock/Vah Shir races for ecample since this could apply tho races as well with a slight modification of just labells and db calls)(just add a new first number to subtract with a class flag). Though I see no plans for such in the future, it could be easier in the long run.

Edgar1898 · #17 10-18-2003, 12:31 PM

Whatever I really dont care anymore, add as much code as you want to. It will do the same thing that mine and ksmith's code does in 1 query

Lurker_005 · #18 10-21-2003, 03:48 PM

ksmith, that is what was needed! I just didn't know if you could (or how) to do that

JennieDe · #19 11-13-2003, 01:29 AM

I'm trying to use the data in a perl cgi format (for a guild website) but can't figure out how to do it.

I know the known values of each class and the total of all classes, also I know that values of multi-classes equals the sum of those values when more then one class can use an item, However like I said above, I can't figure out the format to put that in my cgi file.

I have been banging my head on my desk

If someone could help me I would great appriciate it.

Thanks for your time and help.

mangoo · #20 11-13-2003, 03:17 AM

races, classes, deity, slots .... those are all bitfields, so you'll need to use bitfield operators in order to get the actual information... hope that helps... been up for 72 hours no punctuation, sorry

JennieDe · #21 11-13-2003, 04:09 AM

I have downloaded the DumpedItems for sql, and have converted the data into a comma based txt file so that a search script can read the data with no problem.

Our website does not have access to sql at this time, that is why I'm using cgi.

I'm sure theres a formula that I can use for the cgi but just can't figure it out.

Any tips?