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...")
 
 
(5 intermediate revisions by the same user not shown)
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> |Calls [[Dbserver-protocols#DBCLIENT_SHUTDOWN|DBCLIENT_SHUTDOWN]] on DBServer. I have heard that this does not actually shut down the dbserver cleanly in I25. }}
{{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)
  0 Ents (3)
22044 Doors (4)
  0 Teamups (5)
  0 Supergroups (6)
  0  (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  (25)
  0 Leagues (26)
  0 EventHistory (27)
  0 AutoCommands (28)
  9 ShardAccounts (29)


===Example Command===
{| class="wikitable"
! 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
  dbquery -dbquery -get 29 3

Latest revision as of 23:56, 12 May 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>

Calls DBCLIENT_SHUTDOWN on DBServer. I have heard that this does not actually shut down the dbserver cleanly in I25.

-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=940"