User:Plutocracy: Difference between revisions
From OuroDev
Plutocracy (talk | contribs) mNo edit summary |
Plutocracy (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
== Useful Snippets == | == Useful Snippets == | ||
====== Change Character Archetype ====== | ====== Change Character Archetype ====== | ||
<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 | <syntaxhighlight>1 Blaster | ||
2 Controller | 2 Controller | ||
| Line 15: | Line 16: | ||
7076 Warshade | 7076 Warshade | ||
7018 Peacebringer</syntaxhighlight> | 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 unless you change back to your original AT. | |||
====== Move Character Between Accounts ====== | ====== Move Character Between Accounts ====== | ||
: {| | |||
<syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] | <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>'</syntaxhighlight> | 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> | : <syntaxhighlight lang="SQL" line='line'>UPDATE [cohdb].[dbo].[Ents] SET [AccessLevel] = 10 WHERE [Name] = 'charnamehere'</syntaxhighlight> | ||
====== Adding Transient Flags to maps.db ====== | |||
: Adding ''Transient 1'' to zones' Containers in mabs.db allows their mapserver instances to unload, useful for solo servers or hosting with low RAM/disk space. You can easily edit every container in maps.db with the following regex. | |||
:: {| | |||
<syntaxhighlight>Find: ^.+End | <syntaxhighlight>Find: ^.+End | ||
Replace: \tTransient 1\n$0</syntaxhighlight> | Replace: \tTransient 1\n$0</syntaxhighlight> | ||
|} | |||
::* 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> | : <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> | : <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 22:32, 3 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 unless you change back to your original AT.
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'
Adding Transient Flags to maps.db
- Adding Transient 1 to zones' Containers in mabs.db allows their mapserver instances to unload, useful for solo servers or hosting with low RAM/disk space. You can easily edit every container in maps.db with the following regex.
Find: ^.+End Replace: \tTransient 1\n$0
- 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