Dbquery.exe: Difference between revisions

From OuroDev
mNo edit summary
mNo edit summary
Line 8: Line 8:
* -charactertransfer: see characterTransfer.c for some hilarious surprises!
* -charactertransfer: see characterTransfer.c for some hilarious surprises!
* -cookie
* -cookie
* -db [string, host]: Specifies the DBServer running on a remote host to connect to. Accepts DNS name or IP address. Default: localhost.
* -db <host>: Specifies a remote host the DBServer is running on. Accepts DNS name or IP address. Default: localhost.
* -dbquery [query]: Executes a query on the [[DBServer]]. Implies -noencrypt -nopigs and -silent. It has its own list of [[DBquery.exe\-dbquery_Arguments|arguments]].
* -dbquery <query>: Implies -noencrypt -nopigs and -silent. See list of [[DBquery.exe\-dbquery_Arguments|arguments]].
* -getcharacter "[name]": Gets a character from the DBServer and outputs it to stdout. Implies -noencrypt -nopigs and -silent.
* -getcharacter "<name>": Gets a character from the DBServer and outputs it to stdout. Implies -noencrypt -nopigs and -silent.
* -nodebug
* -nodebug
* -noencrypt: Do not use encryption
* -noencrypt: Do not use encryption
Line 16: Line 16:
* -notimeout
* -notimeout
* -packetdebug
* -packetdebug
* -putcharacter filename: Puts a character into the database via DBServer. Implies -noencrypt -nopigs and -slient.
* -putcharacter <file>: Puts a character into the database via DBServer. Implies -noencrypt -nopigs and -slient.
* -querysgleaders "[string]"
* -querysgleaders <string>: Probably queries to display the list of super group leaders when the supergroup is loaded.
* -restorecharacter
* -restorecharacter "<name>": Probably restores a character from backup?
* -silent: Produces cleaner output
* -silent: Produces cleaner output
* -tcp [number]: Specify TCP port when connecting to DBServer, default 6997
* -tcp [number]: Specify TCP port when connecting to DBServer, default 6997

Revision as of 13:06, 30 April 2019

An application for sending commands to the DBServer. DBServer listens on port 6997 by default.

Usage: bin\dbquery.exe [arguments]

Arguments

  • -charactertransfer: see characterTransfer.c for some hilarious surprises!
  • -cookie
  • -db <host>: Specifies a remote host the DBServer is running on. Accepts DNS name or IP address. Default: localhost.
  • -dbquery <query>: Implies -noencrypt -nopigs and -silent. See list of arguments.
  • -getcharacter "<name>": Gets a character from the DBServer and outputs it to stdout. Implies -noencrypt -nopigs and -silent.
  • -nodebug
  • -noencrypt: Do not use encryption
  • -nopigs: Don't load any pigg files; use only loose files on the filesystem when necessary.
  • -notimeout
  • -packetdebug
  • -putcharacter <file>: Puts a character into the database via DBServer. Implies -noencrypt -nopigs and -slient.
  • -querysgleaders <string>: Probably queries to display the list of super group leaders when the supergroup is loaded.
  • -restorecharacter "<name>": Probably restores a character from backup?
  • -silent: Produces cleaner output
  • -tcp [number]: Specify TCP port when connecting to DBServer, default 6997
  • -templates
  • -tsr2
  • -tsr3
  • -udp [number]: Specify UDP port when connecting to DBServer, default 6997
  • -verbose

Sample Commands

Exporting and Importing a character

dbquery.exe -getcharacter "Name">file.txt
dbquery.exe -putcharacter file.txt

Retrieving a character from a remote DBServer

dbquery -db 10.5.0.144 -getcharacter "Aleena"

DBQuery Entry Point

https://git.ourodev.com/CoX/Source/src/branch/develop/MapServer/svr/dbquery_init.c