User:Plutocracy

Useful Snippets

Move Character Between Accounts

UPDATE [cohdb].[dbo].[Ents]
SET Active = '1', AuthId='<ID>', AuthName='<Accname>'
WHERE Name = '<character name>'

Set Access Level 10 (Admin) for Character

UPDATE [cohdb].[dbo].[Ents] SET [AccessLevel] = 10 WHERE [Name] = 'charnamehere'

RegEx for Adding Transient Flags to maps.db

Find: ^.+End
Replace: \tTransient 1\n$0

• Allows city zone mapserver instances to unload, but may cause unexpected behavior with door mission entrances.