Changing zone name's in game
 

Would anyone be able to help me with the ability to change zone names to show the new name as you zone into a zone and also the short name when you /who a character? I can only manage to change it in the database and so it says you have entered "newzonename" in text after you zoned but would very much like to have it say the new zone name across the screen and on /who.

You won't accomplish this in-game or in the database. You'll have to make changes to the code that will append the appropriate string from your eqstr. Or, you'd have to modify the client. Or, you'd have to do other things.

Once upon a time (pre-Titanium) the zone long names came from eqstr_us.txt for all clientside purposes and were trivial to change. Now they are all hardcoded in the client, so you'd need to edit and/or dll inject the client to change the "Entering Zonename" on-screen text.

Pretty sure they're sent in OP_NewZone. I fully mapped out the structure for RoF2 but that's as far as I've gone. I do plan on figuring it out and adding support for everything eventually, but I've been collecting the data slowly on live.

Everything Zaela said is true except for the absolute necessity to inject or modify the client. In the literal sense, yes -- but we can easily simulate the functionality by sending a modified zone string. Here's a screenshot from my Remnants of the Claw server that used the RoF2 client. I renamed the new Feerrott to The Bloodied Jungle; The short name was jungle. The zoning text was also correct as it just mirrors the string. Although that was a lot more complicated to setup iirc. Probably easiest to just modify the client/hook in that case.

Edit: Or just remove it completely.

https://imgur.com/a/goMkh