Dbquery.exe\-dbquery Arguments: Difference between revisions

From OuroDev
← Older editNewer edit →
VisualWikitext
Aleena (talk | contribs)
Mender
37 edits
Aleena (talk | contribs)
Mender
37 edits
Line 16: Line 16:


{| class="wikitable"
{| class="wikitable"
! List ID
! Name
|-
|-
!# of cached objects
| 1
!Type
| maps
!<list id>
|-
|-
|935
| 2
|maps
| launchers
|1
|-
|-
|1
| 3
|launchers
| Ents
|2
|-
|-
|0
| 4
|Ents
| Doors
|3
|-
|-
|22044
| 5
|Doors
| Teamups
|4
|-
|-
|0
| 6
|Teamups
| Supergroups
|5
|-
|-
|0
| 7
|Supergroups
| <unknown>
|6
|- 
|0
|<unknown>
|7
|-
|-
| 8
| Email
|-
|-
|0
| 9
|Email
| Taskforces
|8
|-
|-
|0
| 10
|Taskforces
| Petitions
|9
|-
|-
|0
| 11
|Petitions
| CrashedMaps
|10
|-
|-
|0
| 12
|CrashedMaps
| MapGroups
|11
|-
|-
|1
| 13
|MapGroups
| ArenaEvents
|12
|-
|-
|0
| 14
|ArenaEvents
| ArenaPlayers
|13
|-
|-
|0
| 15
|ArenaPlayers
| BaseRaids
|14
|-
|-
|0
| 16
|BaseRaids
| Base
|15
|-
|-
|0
| 17
|Base
| statserver_SupergroupStats
|16
|-
|-
|0
| 18
|statserver_SupergroupStats
| ItemsOfPower
|17
|-
|-
|0
| 19
|ItemsOfPower
| ItemOfPowerGames
|18
|-
|-
|0
| 20
|ItemOfPowerGames
| Offline
|19
|-
|-
|0
| 21
|Offline
| ServerApps
|20
|-
|-
|2
| 22
|ServerApps
| SGRaidInfos
|21
|-
|-
|0
| 23
|SGRaidInfos
| MiningAccumulator
|22
|-
|-
|0
| 24
|MiningAccumulator
| LevelingPacts
|23
|-
|-
|0
| 25
|LevelingPacts
| <unknown>
|24
|-
|-
|0
| 26
|<unknown>
| Leagues
|25
|-
|-
|0
| 27
|Leagues
| EventHistory
|26
|-
|-
|0
| 28
|EventHistory
| AutoCommands
|27
|-
|-
|0
| 29
|AutoCommands
| ShardAccounts
|28
|-
|9
|ShardAccounts
|29
|}
|}


===Example Command===
==Example Commands==


  dbquery -dbquery -get 29 3
  dbquery -dbquery -get 29 3

Revision as of 14:03, 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
Retrieved from "https://wiki.ourodev.com/index.php?title=Dbquery.exe%5C-dbquery_Arguments&oldid=525"