Southperry.net
Introducing the SPDB - Printable Version

+- Southperry.net (https://www.southperry.net)
+-- Forum: Main (https://www.southperry.net/forumdisplay.php?fid=11)
+--- Forum: Site Announcements (https://www.southperry.net/forumdisplay.php?fid=18)
+--- Thread: Introducing the SPDB (/showthread.php?tid=35987)

Pages: 1 2 3 4 5


Introducing the SPDB - Anonymous Moose - 2011-01-11

Shidoshi Wrote:For the column "XP Ratio" either increase the number of decimals it shows or present HP/Exp instead of Exp/HP so we can actually compare the numbers.

I was just about to suggest that.

Either way, it looks like a much easier to use database than most databases out there, and the lack of pointless images helps with the loading speed.


Introducing the SPDB - Eos - 2011-01-11

MissingLink Wrote:TL/DR: To my mind putting 'any' ought to bring up all class equips as well as common, and 'common' should mean common class only.
Also putting 'Warrior' or any other specific class should bring up common items too.

I needed the NX filter to be available before I could include "Common" with the specific classes otherwise NX gear drowned out everything else. Does it behave more like you expected now?

Shidoshi Wrote:For the column "XP Ratio" either increase the number of decimals it shows or present HP/Exp instead of Exp/HP so we can actually compare the numbers.

I've expanded them but did you consider the problem isn't the decimals so much as the fact that Big Bang made everything nearly the same?


Introducing the SPDB - MissingLink - 2011-01-11

Eosian Wrote:I needed the NX filter to be available before I could include "Common" with the specific classes otherwise NX gear drowned out everything else. Does it behave more like you expected now?

Yes, works great now.


Introducing the SPDB - OB3LISK - 2011-01-11

Ahhh thanks a lot Eos, this is certainly fun.


Introducing the SPDB - Corn - 2011-01-11

Can't wait for the final version.


Introducing the SPDB - Eos - 2011-01-11

What do you expect it to do? Juggle? :f6:


Introducing the SPDB - Jon - 2011-01-11

Eosian Wrote:I needed the NX filter to be available before I could include "Common" with the specific classes otherwise NX gear drowned out everything else. Does it behave more like you expected now?

Well, now common equipment shows up when search for class-specific equipment. Rolleyes Example: Magician/All/100~200 brings up earrings and medals and stuff. Also, all of the Magician equips have "Common/All/Any" in their jobreq fields? (Both of these things happen with any job type)


Introducing the SPDB - Eos - 2011-01-11

Jon Wrote:Well, now common equipment shows up when search for class-specific equipment. Rolleyes Example: Magician/All/100~200 brings up earrings and medals and stuff.

That was the requested behavior:

MissingLink Wrote:TL/DR: To my mind putting 'any' ought to bring up all class equips as well as common, and 'common' should mean common class only.
Also putting 'Warrior' or any other specific class should bring up common items too.

If we're going to be picky about it I can remove common from the drop down and move it into the object filters and I/X/O.

The Job Required has been fixed, it wasn't reinitializing itself properly after each object.


Introducing the SPDB - Jon - 2011-01-11

Eosian Wrote:That was the requested behavior:

If we're going to be picky about it I can remove common from the drop down and move it into the object filters and I/X/O.

But it doesn't make much sense that Mimio (Cygnus mount) is coming up when I search for Magician equips. :f6:
Oh, but that shouldn't be hard to fix, since it's tamingMob equip-type. Hmm... still doesn't make sense for earrings to come up if I'm trying to look at my class's equips.


Introducing the SPDB - Eos - 2011-01-11

It's equipable by your class, so yes, it does, sort of.
But I went back and forth on it repeatedly. That's part of why all filters were exclusive originally.


Introducing the SPDB - Jon - 2011-01-11

Now, onto maps:

Sort by mapID option maybe?
Not sure what maps it's displaying, but I searched for "Mushroom" and it resulted a bunch of nameless maps, so maybe display mapID in the details?

Not for maps, but since you have what mobs spawn on each map, could you have that the other way around as well?


Introducing the SPDB - Eos - 2011-01-11

It's bringing back this:


namevnum
Blue Mushroom Forest100020300
Entrance - Mushroom Town Training Camp0
Ghost Mushroom Forest100020400
Hall of Mushroom800010100
Mushroom Coral Hill230030100
Mushroom Forest800010000
Mushroom Hill Entrance300020200
Mushroom Park10000
Mushroom Shrine800000000
Mushroom Town Townstreet30001
Deep Inside Mushroom Forest106020300
Isolated Mushroom Forest106020200
Mushroom Forest Field106020000
Secluded Mushroom Forest106020100


The 0 VNUM is breaking it, obviously. I'll fix it in a bit.

ETA: Fixed now.


Introducing the SPDB - kwaz - 2011-01-11

One 'lil problem I see is that the Beginner equipment is showing as common (like so). Granted there aren't many Beginner-only items but...

Also, a list of flags would be good.


Introducing the SPDB - Eos - 2011-01-11

Should be corrected now.

Explain "list of flags"?
And why? They're hyper-link-defined.


Introducing the SPDB - Jon - 2011-01-11

Just a list of possible flags and their definitions. That'd be cool.


Introducing the SPDB - Eos - 2011-01-11

It's in your cache since the pop JS has them all Rolleyes


Introducing the SPDB - Jon - 2011-01-11

In Mob detail, what are the second and third Speeds for? They're n/a on everything I've seen. (credit to kwaz)

and here is a list of flags.
 Spoiler

requesting a "Return all with this flag"


Introducing the SPDB - Eos - 2011-01-12

Chase and Fly speeds.
http://www.southperry.net/db/?do=singleresult&version=1&searchtype=1&vnum=9300081
http://www.southperry.net/db/?do=singleresult&version=1&searchtype=1&vnum=9400541


Introducing the SPDB - Eos - 2011-01-12

Jon Wrote:requesting a "Return all with this flag"

Added.
Cache may need to be refreshed for the JS to work correctly.


Introducing the SPDB - Jon - 2011-01-12

Awesome, thank you. Haven't seen any other bugs (yet). Wink

edit: uhh. how does it work? Needed to clear cache, duh.
edit2: [23:08] <kwaz> hmm, would m/f/uni wearability info be useful to the db?