Dbquery.exe: Difference between revisions

From OuroDev
Aleena (talk | contribs)
mNo edit summary
Aleena (talk | contribs)
Line 34: Line 34:


===Retrieving a character from a remote DBServer===
===Retrieving a character from a remote DBServer===
  dbquery -db 10.5.0.144 -tcp 18717 -getcharacter "Aleena"
  dbquery -db 10.5.0.144 -getcharacter "Aleena"


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

Revision as of 11:45, 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 [string, host]: Specifies the DBServer running on a remote host to connect to. Accepts DNS name or IP address. Default: localhost.
  • -dbquery [query]: Executes a query on the DBServer. Implies -noencrypt -nopigs and -silent.
  • -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 filename: Puts a character into the database via DBServer. Implies -noencrypt -nopigs and -slient.
  • -querysgleaders "[string]"
  • -restorecharacter
  • -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