Dbquery.exe\-dbquery Arguments: Difference between revisions
mNo edit summary |
|||
| Line 1: | Line 1: | ||
== Arguments == | == Arguments == | ||
{{CommandLineTable| | {{CommandLineTable| | ||
{{CLArg|-get <list id> <container id>| Gets information from the database; <list id> specifies type, while <container id> specifies what. }} | {{CLArg|-get <list id> <container id>|Gets information from the database; <list id> specifies type, while <container id> specifies what. }} | ||
{{CLArg|-set <list id> <container id> [file] | < file| Puts information into the database; <list id> specifies type, while <container id> specifies what. }} | {{CLArg|-set <list id> <container id> [file] | < file|Puts information into the database; <list id> specifies type, while <container id> specifies what. }} | ||
{{CLArg|-getbase <supergroup id>| }} | {{CLArg|-getbase <supergroup id>| }} | ||
{{CLArg|-setbase <supergroup id> [file] | < file | }} | {{CLArg|-setbase <supergroup id> [file] | < file | }} | ||
{{CLArg|-getstatus <list id> <container id> | }} | {{CLArg|-getstatus <list id> <container id> | }} | ||
{{CLArg|-find <list_id> <element> <value> | Finds a container ID based on a property name and its value. }} | {{CLArg|-find <list_id> <element> <value> |Finds a container ID based on a property name and its value. }} | ||
{{CLArg|-shutdown <shutdown message> | I have heard that this does not actually shut down the dbserver cleanly. }} | {{CLArg|-shutdown <shutdown message> |I have heard that this does not actually shut down the dbserver cleanly. }} | ||
{{CLArg|-delink <map id> | }} | {{CLArg|-delink <map id> | }} | ||
}} | }} | ||
Revision as of 14:00, 30 April 2019
Arguments
|
|
Gets information from the database; <list id> specifies type, while <container id> specifies what. |
|
|
Puts information into the database; <list id> specifies type, while <container id> specifies what. |
|
|
|
|
|
|
|
|
|
|
|
Finds a container ID based on a property name and its value. |
|
|
I have heard that this does not actually shut down the dbserver cleanly. |
|
|
|
If you don't specify an argument, DBServer will return a help page including a three-column table. The first column indicates how many objects DBServer is caching, the second column is a friendly english name for that list of objects, and the third column is its ID.
Lists
| # of cached objects | Type | <list id> |
|---|---|---|
| 935 | maps | 1 |
| 1 | launchers | 2 |
| 0 | Ents | 3 |
| 22044 | Doors | 4 |
| 0 | Teamups | 5 |
| 0 | Supergroups | 6 |
| 0 | <unknown> | 7 |
| 0 | 8 | |
| 0 | Taskforces | 9 |
| 0 | Petitions | 10 |
| 0 | CrashedMaps | 11 |
| 1 | MapGroups | 12 |
| 0 | ArenaEvents | 13 |
| 0 | ArenaPlayers | 14 |
| 0 | BaseRaids | 15 |
| 0 | Base | 16 |
| 0 | statserver_SupergroupStats | 17 |
| 0 | ItemsOfPower | 18 |
| 0 | ItemOfPowerGames | 19 |
| 0 | Offline | 20 |
| 2 | ServerApps | 21 |
| 0 | SGRaidInfos | 22 |
| 0 | MiningAccumulator | 23 |
| 0 | LevelingPacts | 24 |
| 0 | <unknown> | 25 |
| 0 | Leagues | 26 |
| 0 | EventHistory | 27 |
| 0 | AutoCommands | 28 |
| 9 | ShardAccounts | 29 |
Example Command
dbquery -dbquery -get 29 3
Output:
started 2019-04-30 10:50:40 Starting: dbquery -db 10.5.0.144 -dbquery -get 29 3 AuthName "Auroris" WasVIP 1 Quitting: dbquery -db 10.5.0.144 -dbquery -get 29 3