Patch 68 - December 18th, Merry Christmas, Arms Lore Update & More

Christmas Event - Dark Magic Awakens

The Christmas event is here! And 2 days early!
For more information on the event click here​

Arms Lore

Updated Arms Lore with new functionality that is in line with OSI style development.
You can now target a player with the arms lore skill to see a detailed listing of all items they are wearing.
Should you have 100 Arms Lore you will be able to see the current hit points in health bar format for each worn item.
You can also see individual information about each item, or still target a single item.
If you have over 90 Arms Lore you will be able to see detailed information about an items hit points and quality.
Note: A future patch will implement a basic warning system show an alert if any items are about to break when targeting yourself with Arms Lore (even with zero skill)
Compendium Page: Arms Lore


Mining

Resolved a situation in which ore golems, and ore elementals would spawn inside a players house in certain situations.
This could be due to mining inside a house, or to close to a nearby house using gargoyle items.
They will now be ejected to the houses ban location should this happen. ​

Platinum Vendor

Update the platinum reward gump with outlined text for easier readability and a more classic feel.
Removed the selection grid for carpet items and replaced it with a single purchase option for the new carpet item.
Added the 3 bone furniture items to the store in the house addons category.
Incorporated the Christmas and Halloween reward lists into the platinum vendor to create a uniform reward vendor.
​

Universal Carpet Items

Carpet items can now be double clicked while in your backpack to bring up the following menus.
You can select one of almost 100 different carpet types to design your own carpet 1 piece at a time.
This will work for any carpet items that currently exist.
The platinum store has been updated to reflect the new single carpet item.
Also added two new carpet styles to the selection list not previously available.
Note: Players who wish to trade in their old carpet items for the new master carpet item can do so on request. However the old items can still be double clicked to change their loot. However you will not be able to dye them with the carpet dye tub.
​

Zookeeper Quest

Both Pigs and Boars can now spawn a wild boar, either of which can be turned in.
Mountain Goats and Goats can both spawn a ram, either of which can be turned in.
Quest animals can now be found in town limits.
However spawns of animals in town have been expanded greatly.
Spawns of town animals have been added to each towns complete region allowing for more lively towns. ​

Website Updates

Overall

Applied the new website style to the following web pages.
Improved interaction between the website and the back end database server.
Improved page titles allowing for easier specific page bookmarking, search engine indexing.
Improved image management functions to improve website performance
Found and resolved a layer comparison issue that was resulting in earrings not exporting to the database for website indexing​

General Page Updates

Downloads
Connecting to UO Renaissance
Code of Conduct
Support​

Search Function - Link

Added better quality images for all search results
Included links to a players guild/faction
Allowed for more player results (75)

Todo: Guild search needs to be by tag and guild name. Player icons need to be updated to the players actual ingame look.​

Player Listing - Link

Updated the listing to better display online and all players.

Todo: More sorting options for the online player list.​

Item Database - Link

Improved the listing of database items to be easier to review.
Standardized the sizes of item database images to address very wide, very tall images.​

Player vs Monster Leaderboards - Link

Converted the leaderboards to use the new compendium monster icons
Added 2013, 2014, 2015, 2016, All Time leaderboard data.
Improved design to be more readable​

Item Database Detail Pages - Link

Re-designed how non 0 hue items are handled to improve website performance.
Resolved the problem in which similar items were displayed multiple times if they were flipped ingame
Created a version of the detail view that will show all items in the world with a certain hue. Example - Hue 1160
Updated the !hue function of the IRC bot to direct to this new page.​

Guild Listing - Link

Improved listing of the guild, guildmasters, guild types.
Added small images to indicate if a guild is allied with a certain faction/order/chaos

Todo: Sorting Options​

Sure, Ill look into that.

Ok took some interesting SQL I've never used before but it seems to work and work quickly.

http://www.uorenaissance.com/itemdetails/Sandals/170E/1

http://www.uorenaissance.com/itemdetails/Hue/20/1

Code:

sum(case when item_active = 1 Then item_count else 0 End) as Count

We should see 2-3 more patches before the end of the year Kane. The next one will be a small Christmas update.

It will be on the guild detail pages, I removed it from the guild listing page as the SQL method i was using was just terrible.

It has never existed on the vendor, to date I have just done those purchases manually. I finally coded the items properly and tested them.

Yep, and a nice reward for finding the bug involving them.