Introducing the SPDB

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.

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?

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?

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.

Ahhh thanks a lot Eos, this is certainly fun.

Can't wait for the final version.

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

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. 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)

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

That was the requested behavior:

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.

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.

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.

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?

It's bringing back this:

name	vnum
Blue Mushroom Forest	100020300
Entrance - Mushroom Town Training Camp	0
Ghost Mushroom Forest	100020400
Hall of Mushroom	800010100
Mushroom Coral Hill	230030100
Mushroom Forest	800010000
Mushroom Hill Entrance	300020200
Mushroom Park	10000
Mushroom Shrine	800000000
Mushroom Town Townstreet	30001
Deep Inside Mushroom Forest	106020300
Isolated Mushroom Forest	106020200
Mushroom Forest Field	106020000
Secluded Mushroom Forest	106020100

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

ETA: Fixed now.

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.

Should be corrected now.

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

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

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

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

glossary['flag_I"] = 'Include these normally.';

glossary['flag_X"] = 'Exclude mobs/equips flagged as this.';

glossary['flag_O"] = 'Only bring back mobs/equips flagged as this.';

glossary['aris_N"] = 'Don\'t filter by this element.';

glossary['aris_I"] = 'Only bring back mobs Immune to this element.';

glossary['aris_S"] = 'Only bring back mobs Strong against this element';

glossary['aris_W"] = 'Only bring back mobs Weak against this element';

glossary['filter_pqmobs"] = 'PQ Mobs are any mob with the invincible, getCP, escort or partyreward flags.';



glossary['map_fly"] = 'This map uses flying physics.';

glossary['map_hideMinimap"] = 'No minimap is visible.';

glossary['map_noMapCmd"] = 'The map command may not be used here.';

glossary['map_swim"] = 'This map uses swimming physics.';

glossary['map_town"] = 'This map is a town.';

glossary['map_needSkillForFly"] = 'A skill is required to fly in this map.';

glossary['map_everlast"] = '';

glossary['map_allMoveCheck"] = '';

glossary['map_expeditionOnly"] = 'You must be in an expidition to enter this map.';

glossary['map_noRegenMap"] = 'Natural regeneration does not occur in this room.';



glossary['mob_bodyAttack"] = 'Touching this mob will not cause damage.';

glossary['mob_boss"] = 'Mob is a boss.';

glossary['mob_firstAttack"] = 'Mob is aggressive and will attack unprovoked.';

glossary['mob_HPgaugeHide"] = 'Mob\'s HP gauge is not visible.';

glossary['mob_undead"] = 'Mob is undead and subject to heal damage.';

glossary['mob_explosiveReward"] = 'Mob\'s drops will scatter across entire room in a burst.';

glossary['mob_noFlip"] = 'Mob will only face one direction.';

glossary['mob_noregen"] = 'Mob can not regenerate.';

glossary['mob_noDoom"] = 'Mob can not be doomed.';

glossary['mob_publicReward"] = 'Anyone may pick up drops regardless of who kills the mob.';

glossary['mob_PartyReward"] = 'Anyone in party may pick up drops regardless of who kills the mob.';

glossary['mob_disable"] = '???';

glossary['mob_invincible"] = 'Mob can not be hurt.';

glossary['mob_notAttack"] = 'Mob will not make any attacks.';

glossary['mob_damagedByMob"] = 'Mob can be damaged by other mobs.';

glossary['mob_getCP"] = 'Mob is worth CP.';

glossary['mob_escort"] = 'Mob is part of an escort quest.';

glossary['mob_onlyNormalAttack"] = 'Mob can only be hit with normal weapon attacks.';

glossary['mob_cantPassByTeleport"] = 'Mob obstructs and prevents teleportation beyond it.';

glossary['mob_cannotEvade"] = 'Mob bypasses the avoidability of players.';

glossary['obj_cash"] = 'Item is NX.';

glossary['obj_tradeWithPlatinumScissors"] = 'Item is subject to Platinum Scissors of Karma';

glossary['obj_tradeWithScissors"] = 'Item is subject to normal Scissors of Karma';

glossary['obj_tradeBlock"] = 'Item can not normally be traded';

glossary['obj_quest"] = 'Item is a special quest award.';

glossary['obj_notSale"] = 'Item can not be sold to NPC Shops.';

glossary['obj_timeLimited"] = 'Item will expire after a set time.';

glossary['obj_equipTradeBlock"] = 'Once equipped for the first time the item will become untradeable.';

glossary['obj_notExtend"] = 'The time limit on this item may not be extended with NX.';

glossary['obj_epicItem"] = 'Item obtained only under special circumstances.';

glossary['obj_accountSharable"] = 'Item can be traded within your own account.';

glossary['obj_sharableOnce"] = 'Item may be traded, once.';

glossary['obj_expireOnLogout"] = 'Item vanishes when you log off.';

glossary['obj_dropBlock"] = 'Item may not be dropped';

glossary['obj_noExpend"] = '???';

glossary['obj_scanTradeBlock"] = '???';

glossary['obj_ignorePickup"] = 'Enables a pet to ignore items when equipped.';

glossary['obj_sweepForDrop"] = 'Enables a pet to pick up items when equipped.';

requesting a "Return all with this flag"

Chase and Fly speeds.
http://www.southperry.net/db/?do=singler...um=9300081
http://www.southperry.net/db/?do=singler...um=9400541

requesting a "Return all with this flag"

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

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

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?