User:Plutocracy: Difference between revisions
From OuroDev
Plutocracy (talk | contribs) |
Plutocracy (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
<syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] SET [Class] = ARCHETYPE WHERE [Name] = 'CHARACTER'</syntaxhighlight> | <syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] SET [Class] = ARCHETYPE WHERE [Name] = 'CHARACTER'</syntaxhighlight> | ||
: Replace CHARACTER with the target character's name and ARCHETYPE with any of the following: | : Replace CHARACTER with the target character's name and ARCHETYPE with any of the following: | ||
<syntaxhighlight>1 Blaster | |||
2 Controller | 2 Controller | ||
3 Defender | 3 Defender | ||
| Line 14: | Line 14: | ||
10929 Corruptor | 10929 Corruptor | ||
7076 Warshade | 7076 Warshade | ||
7018 Peacebringer</ | 7018 Peacebringer</syntaxhighlight> | ||
: Note: You will NOT be able to choose primary/secondary powers on level up or respec | : Note: You will NOT be able to choose primary/secondary powers on level up or respec | ||
| Line 32: | Line 32: | ||
Replace: \tTransient 1\n$0</syntaxhighlight> | Replace: \tTransient 1\n$0</syntaxhighlight> | ||
: Adding < | : Adding <source enclose="none">Transient 1</source> to zones' Containers in mabs.db allows their mapserver instances to unload, useful for solo servers or hosting with low RAM/disk space. | ||
::* May cause unexpected behavior with door mission entrances. | ::* May cause unexpected behavior with door mission entrances. | ||
====== Disable mapserver.exe Popups ====== | ====== Disable mapserver.exe Popups ====== | ||
<syntaxhighlight>MapServerParams "-nopopup"</syntaxhighlight> | |||
: in servers.cfg, line is commented out by default | : in servers.cfg, line is commented out by default | ||
====== Increased EXP Rate ====== | ====== Increased EXP Rate ====== | ||
<syntaxhighlight>XPScale 2.0</syntaxhighlight> | |||
: in servers.cfg, does exactly what it says on the tin | : in servers.cfg, does exactly what it says on the tin | ||
Revision as of 00:52, 2 May 2019
Useful Snippets
Change Character Archetype
UPDATE [cohdb].[dbo].[Ents] SET [Class] = ARCHETYPE WHERE [Name] = 'CHARACTER'
- Replace CHARACTER with the target character's name and ARCHETYPE 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- Adding
Transient 1to zones' Containers in mabs.db allows their mapserver instances to unload, useful for solo servers or hosting with low RAM/disk space.- May cause unexpected behavior with door mission entrances.
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