User:Plutocracy: Difference between revisions
From OuroDev
Plutocracy (talk | contribs) No edit summary |
Plutocracy (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
== Useful Snippets == | == Useful Snippets == | ||
====== Change Character Archetype ====== | |||
<syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] SET [Class] = AT WHERE [Name] = 'CHARACTER'</syntaxhighlight> | |||
: Replace CHARACTER with the target character's name and AT with any of the following: | |||
<nowiki>1 Blaster | |||
2 Controller | |||
3 Defender | |||
4 Scrapper | |||
5 Tanker | |||
9198 Mastermind | |||
9200 Stalker | |||
9201 Brute | |||
9700 Dominator | |||
10929 Corruptor | |||
7076 Warshade | |||
7018 Peacebringer</nowiki> | |||
: Note: You will NOT be able to choose primary/secondary powers on level up or respec | |||
====== Move Character Between Accounts ====== | ====== Move Character Between Accounts ====== | ||
<syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] | |||
SET Active = '1', AuthId='<ID>', AuthName='<Accname>' | SET Active = '1', AuthId='<ID>', AuthName='<Accname>' | ||
WHERE Name = '<character name>'</ | WHERE Name = '<character name>'</syntaxhighlight> | ||
====== Set Access Level 10 (Admin) for Character ====== | ====== Set Access Level 10 (Admin) for Character ====== | ||
<syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] SET [AccessLevel] = 10 WHERE [Name] = 'charnamehere'</syntaxhighlight> | |||
====== RegEx for Adding Transient Flags to maps.db ====== | ====== RegEx for Adding Transient Flags to maps.db ====== | ||
Revision as of 04:49, 29 April 2019
Useful Snippets
Change Character Archetype
UPDATE [cohdb].[dbo].[Ents] SET [Class] = AT WHERE [Name] = 'CHARACTER'
- Replace CHARACTER with the target character's name and AT with any of the following:
1 Blaster 2 Controller 3 Defender 4 Scrapper 5 Tanker 9198 Mastermind 9200 Stalker 9201 Brute 9700 Dominator 10929 Corruptor 7076 Warshade 7018 Peacebringer
- Note: You will NOT be able to choose primary/secondary powers on level up or respec
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. Useful for solo servers or hosting with low RAM/disk space.
Disable mapserver.exe Popups
MapServerParams "-nopopup"
in servers.cfg, line is commented out by default
Increased EXP Rate
XPScale 2.0
in servers.cfg, does exactly what it says on the tin