Dbquery.exe\-dbquery Arguments: Difference between revisions

From OuroDev
VisualWikitext
(Created page with "* -get <list id> <container id> * -set <list id> <container id> [file] | < file * -getbase <supergroup id> * -setbase <supergroup id> [file] | < file * -getstatus <list id> <c...")
 
mNo edit summary
Line 1: Line 1:
* -get <list id> <container id>
== Arguments ==
* -set <list id> <container id> [file] | < file
{{CommandLineTable|
* -getbase <supergroup id>
{{CLArg|-get <list id> <container id>| Gets information from the database; <list id> specifies type, while <container id> specifies what. }}
* -setbase <supergroup id> [file] | < file
{{CLArg|-set <list id> <container id> [file] &#124; < file| Puts information into the database; <list id> specifies type, while <container id> specifies what. }}
* -getstatus <list id> <container id>
{{CLArg|-getbase <supergroup id>| }}
* -find <list_id> <element> <value>
{{CLArg|-setbase <supergroup id> [file] &#124; < file | }}
* -shutdown <shutdown message>
{{CLArg|-getstatus <list id> <container id> | }}
* -delink <map id>
{{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|-delink <map id> | }}
}}


The DBServer will additionally produce the following statistics page when displaying help. The first number indicates how many objects are loaded, the number in parenthesis indicates <list_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.


DbServer started on 2019-04-29 23:46:54, Up 17 hours, 6 minutes
==Lists==
935 maps (1)
 
  1 launchers (2)
{| class="wikitable"
  0 Ents (3)
|-
22044 Doors (4)
!# of cached objects
  0 Teamups (5)
!Type
  0 Supergroups (6)
!<list id>
  0 (7)
|-
  0 Email (8)
|935
  0 Taskforces (9)
|maps
  0 Petitions (10)
|1
  0 CrashedMaps (11)
|-
  1 MapGroups (12)
|1
  0 ArenaEvents (13)
|launchers  
  0 ArenaPlayers (14)
|2
  0 BaseRaids (15)
|-
  0 Base (16)
|0
  0 statserver_SupergroupStats (17)
|Ents
  0 ItemsOfPower (18)
|3
  0 ItemOfPowerGames (19)
|-
  0 Offline (20)
|22044
  2 ServerApps (21)
|Doors
  0 SGRaidInfos (22)
|4
  0 MiningAccumulator (23)
|-
  0 LevelingPacts (24)
|0
  0 (25)
|Teamups
  0 Leagues (26)
|5
  0 EventHistory (27)
|-
  0 AutoCommands (28)
|0
  9 ShardAccounts (29)
|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===
===Example Command===

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