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.
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.
I’ve now gone through and updated all the links in the RMSS vs RMFRP pages, and added in some formatting that seemed to have gotten lost somewhere along the way.
Also added in Terry Amthor’s novel “The Loremaster Legacy” and some of the ERA Software packages to the list of products. Still need to add in additional ERA packages
I also deleted most of the old php files for individual products. Some of them had been updated with redirects at one point, but those no longer match the new database structure so I got rid of them. Hopefully I found all the links in my pages that used to use them, some of the really old posts probably point to them but I’m not too concerned about them. I’ll keep an eye on my stats for 404 errors for the next while and fix up anything I may have missed. The Translations are still using those pages, I still need to get them done up properly into the database.
The behind the scenes database revamp is almost done, I still need to go back and clean up a few columns that aren’t needed anymore and check some of the linking and constraints between the tables. I also want to look at the select statements I’m using in the php pages, right now I use “Select *” quite frequently, in most cases I don’t need all the columns so it would be more efficient to just specify the ones being used.
I also need to go through and clean up the css files as well, I’ve got a few things being done “in-line” that really should be handled in a style sheet.
An unintended side effect is that the Product_id codes for most of the products ended up changing. That doesn’t affect this site particularly except for a few hard coded links, but any external sites that had hard coded links, including Pinterest, will find those links now going to different pages, or possibly getting a “Page not Found”. My apologies for that, it wasn’t my intention to mess up any external references.
I’ve now got the “Related Products”, “Related Websites” and “Purchase Links” functionality working, all of which can now handle multiple entries.
My next tasks are to finish up some of the data entry forms and start filling in some of the data that’s missing. The Non-English pages are in bad need of some fixing, and I need to go through RPGNow and see which of the new products I haven’t added yet. There are a few oversize images that need to be trimmed down and a few missing images that I need to track down as well.
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 ICE Products pages.
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 🙂
The first major stage of the revamp of the site is now done. 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 per publisher. 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.
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.
I finally sorted out the issues I was having with the new F2 theme, boiled down to where I was placing the call to header.php. I also managed to fix the problem I was having with the individual product pages coming up as “Page not found” in the title, hopefully this will also help the products show up in Google better 🙂
Also added the new Second Edition of “Eidolon City in the Sky” to the Shadow World product list. Still missing a few other items that I need to go back and fill in.
I’ve finally decided to update the product lists again, there have been a few new items since last time I updated, particularly some supporting software.
I got started by fixing up a couple problems with the HARP list and added in the newest versions of Martial Law. More to come over the next few days.
I’ve occasionally thought that I should take this site down because it seems that it may have out lived it’s usefulness, but then I check my stats and see that I’m still getting between 6000 to 8000 unique visitors each month. I’d like to think that they aren’t all spambots. In fact, I can see from some of the other stats that I am still getting some real visitors. So, I think I will track down the few products that ICE has released in the last couple of years and get them added to the lists, then see if I can’t get the site updated and working with the latest version of the F2 theme, or possibly look into what new tools and add ons have come out for WordPress that might be helpful in maintaining the site.
If you are a visitor here, I’ll love for you to leave a comment about what brought to the site and what you found useful, or suggestions for what could be improved. Thanks!
I’ve reverted back to the old version of the F2 theme, it seems the new version doesn’t work well with my customizations for the individual product pages.
I’ve used the newer one for several months, so I’m surprised no one, including myself, had noticed those pages weren’t working.
At some point when I get some time, I’ll get my test system up and running again and figure out what changed. The new version does have some nice features that I’d like to be able to use.