Dbquery.exe\-dbquery Arguments: Difference between revisions

From OuroDev
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] &#124; < file| Puts information into the database; <list id> specifies type, while <container id> specifies what. }}
{{CLArg|-set <list id> <container id> [file] &#124; < 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] &#124; < file | }}
{{CLArg|-setbase <supergroup id> [file] &#124; < 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 15:00, 30 April 2019

Arguments

-get <list id> <container id>

Gets information from the database; <list id> specifies type, while <container id> specifies what.

-set <list id> <container id> [file] | < file

Puts information into the database; <list id> specifies type, while <container id> specifies what.

-getbase <supergroup id>

-setbase <supergroup id> [file] | < file

-getstatus <list id> <container id>

-find <list_id> <element> <value>

Finds a container ID based on a property name and its value.

-shutdown <shutdown message>

I have heard that this does not actually shut down the dbserver cleanly.

-delink <map id>


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 Email 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