Author Topic: Icewebring Product List Revamp  (Read 5658 times)

0 Members and 1 Guest are viewing this topic.

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Icewebring Product List Revamp
« on: March 05, 2016, 04:08:14 PM »
For those of you who like the ICE Product listings on my website, www.icewebring.com I thought I'd post an update on what I've been up to.
I’ve completely revamped the underlying database for the site, normalizing most of the tables and creating some views to make working with the tables easier. This allowed for major improvements in how I have been handling Authors and the extra images that are attached to some of the individual product pages. It also allowed some clean up of Publishers and Book Types.

It’s going to allow me to develop some additional features that I’ve wanted for awhile, such as a list of related products attached to the individual product pages, a list of links to websites with additional information on the individual products and a more flexible way to handle links to places to purchase products.

The visible changes are to the Product Lists, there is now just one entry for each product per edition. It is a little inconsistent on whether a change of publisher gets it's own entry or not.  Most of the items that used to be published by ICE but are now available as direct reprints or pdfs from GCP didn't get a new listing.  If the product underwent any sort of revision, then it usually gets treated as a new product with a new listing.

Individual formats such as Hardcover, Softcover, Pdf no longer have individual entries on the list, instead these are now listed in a small table on the individual product page. I think it’s just a cleaner way to handle the lists. It does mean I will need to go through all the lists and make sure I have the most appropriate thumbnail image being used but that’s a minor issue which mostly seems to have affected the First and Second Edition Rolemaster lists.

If you notice anything that seems to have broken or is incorrect now, or just have any general feedback please let me know either by posting here or sending me a message.

Thanks!

Currently the link to buy a product, when available, is in the little table listing the different formats. The plan is to consolidate those and move them to a separate list as many of the format variations link to the same page anyway.

The next step is also behind the scenes, I’m redeveloping the forms that I use to update the products to match the new database structure, and I need to do some clean up on a few items that didn’t convert well. I’ll also need to revamp the “Recent Releases” sidebar to use the new tables.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #1 on: March 06, 2016, 10:57:27 PM »
The Thumbnails should all be sorted out now, so if anyone spots any that aren't correct, please let me know.  Thanks!
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline gog

  • Initiate
  • *
  • Posts: 108
  • OIC Points +0/-0
Re: Icewebring Product List Revamp
« Reply #2 on: March 07, 2016, 05:53:03 AM »
Heads up that Silent Death 2nd ed "Silent Death The Next Millenium Deluxe Box Set" has the picture for Battle of the 5 Armies

All looks good, and the linking of related texts sounds good to me

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #3 on: March 07, 2016, 07:47:23 PM »
Thanks!  Got that one fixed now.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #4 on: March 07, 2016, 10:40:19 PM »
Now I'm doing something I thought I did ages ago, uploading all of the files for Guy Fullerton's awesome "Printing and Edition Reference for MERP Middle-earth Role Playing" reference.  He gave me the source files a year ago, I thought I had uploaded them and fixed the link on my site to look at them, but must have just done it on my test site.  Likewise fixing/deleting a few other links such as to Terry's Shadow World pages.
I realized I hadn't posted them today when I started work on the new "related webpages" portion of the Product pages.

http://www.icewebring.com/MERP_Print_Ref/PrintingEditionReference.html

Doing some checking on the newly posted files, I've realized that the links to my products have changed, not quite sure if it is just with the recent updates I've done or if it was from a previous revamp.  In any case, I'll have to update those in the Printing Edition Reference.  I'll add that to the task list  :)
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #5 on: March 09, 2016, 10:14:42 PM »
I've now got the structure for "Related Products" in place.  It will take me awhile to populate the table behind it, but you can see a couple examples of how it works on the various versions of Arms Law:
http://www.icewebring.com/ICE_Products/Product_Page_test.php?product_id=202%20Arms%20Law

And a variation on this version of the "Rolemaster Boxed Set"
http://www.icewebring.com/ICE_Products/Product_Page.php?product_id=208%20Rolemaster%20Box
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #6 on: March 10, 2016, 01:50:03 PM »
A question, looking at the Arms Law page above, does it make more sense to have the related products before the Table of Contents listing, or is it better where it is now at the bottom? 
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Online jdale

  • RMU Dev Team
  • ****
  • Posts: 7,101
  • OIC Points +25/-25
Re: Icewebring Product List Revamp
« Reply #7 on: March 10, 2016, 02:35:29 PM »
Personally, I would put the table of contents first. The related products listing is interesting but it isn't necessarily obvious what the relationships are in each case. The ToC is very clear about what is included in the product.
System and Line Editor for Rolemaster

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #8 on: March 10, 2016, 05:14:15 PM »
Do the Thumbnails on the MERP First Edition list look particularly small to other people, or is it just something with my browsers?

http://www.icewebring.com/ice-products/merp-first-edition/

They look okay in Explorer, Firefox, but small in Google and Safari.  That page isn't set up any differently than any of the others, in fact, it's the same page, just being passed a set of parameters.

My best guess is that the different browsers are handling the width of the Product Name column differently, some give it priority over the Cover column, and others give the Cover column priority.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #10 on: March 13, 2016, 11:21:16 PM »
Okay, the database revamp is almost done, just need to go back and clean up a few columns that aren't needed anymore, check some of the linking and constraints.
After that, finish up some of the data entry forms and start filling in some of the data that's missing.
I've now got the "Related Products" functionality working, "Related Websites" and "Purchase Links", all of which can now handle multiple entries.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #11 on: March 17, 2016, 11:26:02 PM »
Well, I think all the "bulk" changes that I could handle with SQL code and similar methods has been done.  Now it's a matter of going into all the entries individually and manually updating any glitches that have crept in.
If anyone spots anything in the Product Lists that doesn't seem right, please let me know.  Posting here is fine.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline Alwyn

  • Senior Adept
  • **
  • Posts: 570
  • OIC Points +0/-0
Re: Icewebring Product List Revamp
« Reply #12 on: March 18, 2016, 10:24:32 AM »
We appreciate all the hard work you have put in ob1knorrb.
Alwyn Erendil
Warden of the High Forest
"NEMO ME IMPUNE LACESSIT - At least not in Yu Gi Oh"

Don't worry, be HARPy!

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #13 on: March 20, 2016, 10:42:58 PM »
Thanks Alwyn!
I did some work on the data entry portion recently, still have some additional work to do but it's already simplified the process of getting new entries in immensely  ;D
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline gog

  • Initiate
  • *
  • Posts: 108
  • OIC Points +0/-0
Re: Icewebring Product List Revamp
« Reply #14 on: March 22, 2016, 05:30:53 PM »
caught a couple more pictures that are out of place

Written in Blood on the "misc" page http://www.icewebring.com/ice-products/misc-ice-products/ has the picture for Mirkwood (main article is fine); also no picture for Run out the Guns

Also "Castles & Ruins" is showing up twice http://www.icewebring.com/ICE_Products/Product_Page.php?product_id=297%20Castles%20&%20Ruins and http://www.icewebring.com/ICE_Products/Product_Page.php?product_id=307%20Castles%20&%20Ruins

Again thanks for keep the page going, great help and great resource

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #15 on: March 24, 2016, 05:56:46 PM »
Thanks!  Got those fixed up.  The second Castles and Ruins is the Guild Companion pdf reprint.  One of the ones that got it's own entry instead of just being listed under the original.  I think there may be a few differences between them, I'll have to take a closer look.  Seems to be there was a swap out of some spell lists or something.
Or, maybe it's just the replacement of page 192, the original had a page advertising other Rolemaster Standard System products, the reprint has an Addenda on "Land Costs, Quick Contruction Estimates and Sample Rents"

I've updated the Cover photo for the GCP version to the correct one and set up the "Related Products" link between the two
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #16 on: March 25, 2016, 01:29:36 PM »
Added in the newest version of "Cloudlords of Tanara", added in the rest of the "Electronic Rolemaster Assistant" software.
Did some tweaking to the "Related Products", allowing for multiple categories of relationships.
Still need to add in some missing "AutoHARP" software, and the "Rolemaster Combat Minion" software.
Then I'll go through the recent entries on RPGNow and see if there is anything else I missed.  Most likely to have missed versions of items that can now be ordered as physical books instead of just pdfs.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #17 on: March 28, 2016, 04:55:59 PM »
I think I've now added all the products that I had been missing, including the Fantasy Grounds packages for Rolemaster Classic.
Still need to do some work on the Related Products portion and add some links for purchasing used products on Amazon.
I think there are also a couple thumbnails and cover images that I'm still missing as well, but overall I'm pretty happy with the progress that has been made.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline ob1knorrb

  • Revered Elder
  • ***
  • Posts: 1,253
  • OIC Points +150/-150
    • ICE Roleplaying WebRing
Re: Icewebring Product List Revamp
« Reply #18 on: April 07, 2016, 11:13:06 PM »
In addition to having links to purchase used products from Noble Knight, I’ve now created an Amazon Affiliate account for myself and have started adding purchase links to Amazon. I’m about halfway through the First Edition MERP products right now.

I also realized that I’m missing a bunch of French translation products, so I’ll have to track those down and get them added to the database as well.
Brent Knorr...
Ringmaster:ICE Roleplaying Webring - http://www.icewebring.com

Offline Alwyn

  • Senior Adept
  • **
  • Posts: 570
  • OIC Points +0/-0
Re: Icewebring Product List Revamp
« Reply #19 on: April 11, 2016, 03:31:41 PM »
Brent,

Once again, thanks for all your hard work providing this to us!
Alwyn Erendil
Warden of the High Forest
"NEMO ME IMPUNE LACESSIT - At least not in Yu Gi Oh"

Don't worry, be HARPy!