Results 32 comments of Corey

@wrenffxi thanks for the spreadsheet! I'm currently running through the zones on retail and I've noticed a few things I still need to change. Still have no idea how to...

@Brierre How are you opening the doors to the teleporter rooms? That's pretty much the biggest thing I'm missing, getting the Temenos doors to open and the teleporter pads to...

I'm not very knowledgeable in this area so I might be wrong here, but it seems we set up our tables with `DEFAULT CHARSET=utf8;` and `utf8` here actually means `utf8mb3`...

So I put together a migration to convert the DB and tables to utf8mb4 and it appears to apply successfully, but the same error occurs when trying to connect. As...

Not sure if the functionality exists yet, but the ring enchantments should wear off if the ring is removed (also on logout/zone, but that should just be an effect flag...

> itemObject.onItemEquip = function(target, item) > itemObject.onItemUnequip = function(target, item) > > in this case: > ```lua > itemObject.onItemUnequip = function(target, item) > if target:hasStatusEffect(X) > target:delStatusEffect(X) > end >...

> edit: actually I forgot - you can't activate 2 of the same item unless they are different IDs. thats why the double I mentioend can work, SE replaced the...

I'm not sure if it's just a Debian thing or if it's still the case with all the refactoring done, but originally dbtool didn't quite work out of the box...

I tried using a server var similar to how [UpdateGuildPointsPattern](https://github.com/topaz-next/topaz/blob/release/src/map/utils/guildutils.cpp#L146) does, but because there's a gap between reading the DB and checking the date, multiple servers are able to update...

This lack of safety might actually be the cause of some guild point issues as well. One server could roll a random pattern then apply that pattern to all its...