First, the link.

I've been working on this in my free time, and I've decided to open it up to the public for feedback. It's an item database. I have all the items, just not all the info for each item entered (yet). Currently you can browse the items by category, and 'code' (the page-row-col). It only really works in Firefox for now, although it seems to be fine in Safari also.

Sticky. This. Now.

WOW! :eek that's highly impressive. that must have taken forever.

Awesome job, really. Impressive.

I was just browsing around and noticed that the categories with double digit pages use pre XP numbering rules, so it goes:

1
10
11
12
2
3
4
etc...

The items are still in the right place, page-wise, but the numbers on the page don't match up. There aren't many that actually have double digit pages, but I noticed it when I clicked on the World category.

The coding itself is only about 7-10 days worth of nights. It's all dynamically generated from the database. Most of the information was gathered from posts on here, so I just put it into spreadsheets so I could put it into the database easier. That was the longest time spent, just correcting spelling and the different formats people keep track of things in.

If there's an interest I'll start a different topic and post the spreadsheets so people can have them. (And maybe submit some info so I don't have to type it up?)

Maritimus Rain: You are correct, thanks for pointing that out. I'll have to look into why that's happening. It must have happened when I added sub item listing, because it was fine before.

This is why I posted it, I can't go through every category everytime I change some code.

Ok, the paging order has been fixed. It was when I added sub items, I changed the DB query, so it was sorting by code. This has the unfortunate side affect of sorting properly, i.e. 1,10,2,20,3, etc. Simple change back to sorting by item id, and it's fixed.

I didn't notice it since only World and Nature have more than 120 items.

Added a few more features, and a few code changes. I haven't added the actual content yet, I'm just setting it up ahead of time to hold the info.

Any suggestions on what other info you'd like to see? I'm thinking about adding the 'cost' / 'calorie' values next.

i meant to ask, as i haven't checked it myself but how do you have the subcategories set up?

You mean on the page? Right now, any item that has subitems (like Tools: 1-1-3) has an option appear when it's chosen. The text "Sub Items" appears over the tree to the right of the item description, and when you mouse over it, they're listed in a floating div.

In the db they're tracked with all the info of a normal item, just in a seperate table.

My original idea was to have them appear in the main selection spaces, but I felt like it was confusing that way, and changed it to the floating div as a temp. solution.

oh, very nice indeed. any plans to do that for the other games?

Beautiful Katamari is the only Katamari I have. I suppose I could still do the setup if I gathered all the info up. I just wouldn't have any reference to make it look like the game.

Originally I couldn't find any screenshots of the collection in BK for the images, so I ended up capping them myself. If I did the other games, I'd need some images to work off of.