Implementing: Collections

[Scatman]

After Z's find of my stupid bug, I was able to implement the rest of collections except for rewards. All the structs involved with collections are now sending perfectly (woot!). Just some things left that I can't implement until we talk about them.

Rewards Table
We need to support coin, item, and selectable item rewards. What do you think about a table called `collection_rewards` with `collection_id`,`reward_type`,`reward_value`. Reward types could be 'Item','Selectable Item','Coin'. If coin, then reward value would be the total coin in copper.

Experience
We'll need an additional field in the `collections` table to denote how much exp should be awarded upon hand-in of the quest.

Anything else I'm missing?

[Sylva1n]

some quest rewards are collectibles

[Zcoretri]

some quest rewards are collectibles

True, but they are still just items with a collectible tag.

[John Adams]

Experience
We'll need an additional field in the `collections` table to denote how much exp should be awarded upon hand-in of the quest.

Scat, couldn't we just add an enum for "XP", and make the collection_rewards multi-entry, like we do with quest rewards? You can then set it up to get an item, AND coin, AND xp...

[Sylva1n]

what about when a collection offers a choice of rewards (choosing between 2 or more items)?

[Scatman]

what about when a collection offers a choice of rewards (choosing between 2 or more items)?

That's what the selectable items are.

Scat, couldn't we just add an enum for "XP", and make the collection_rewards multi-entry, like we do with quest rewards? You can then set it up to get an item, AND coin, AND xp...

Sure that's perfectly fine to me. So reward_type could be 'xp','item','selectable_item','coin'?

[John Adams]

Sure! Give em some coin and xp, and a standard item "Alpha Token" and oh, because we're nice guys, pick one of the following super cool items... etc. Sounds dreamy.

Table committed.

[Scatman]

Can we get the following unique keys so I can perform insert into/duplicate key updates on the following tables and columns?

character_collections.char_id + character_collections.collection_id
character_collection_items.char_id + character_collection_items.collection_id + character_collection_items.collection_item_id

[John Adams]

You should have the ability to commit table changes, Scatman. If you know what you're asking for, just commit (from the portal module). If it's a question of complying with the strict JA Articles of Database Perfection, Paragraph B, sub clause 1.5f, then I will see what I can do.

But seriously, feel free to make your own DB changes as needed. I'm a bit buried at the moment.

[Scatman]

Did not know Sweet!