Dbquery.exe\-dbquery Arguments: Difference between revisions

From OuroDev
Aleena (talk | contribs)
Aleena (talk | contribs)
(No difference)

Revision as of 14:06, 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

List ID Name
1 maps
2 launchers
3 Ents
4 Doors
5 Teamups
6 Supergroups
7 <unknown>
8 Email
9 Taskforces
10 Petitions
11 CrashedMaps
12 MapGroups
13 ArenaEvents
14 ArenaPlayers
15 BaseRaids
16 Base
17 statserver_SupergroupStats
18 ItemsOfPower
19 ItemOfPowerGames
20 Offline
21 ServerApps
22 SGRaidInfos
23 MiningAccumulator
24 LevelingPacts
25 <unknown>
26 Leagues
27 EventHistory
28 AutoCommands
29 ShardAccounts

Example Commands

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