Dbquery.exe

An application for sending commands to the dbserver.

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 (not used in some situations.)
• -templates
• -tsr2
• -tsr3
• -udp [number]: Specify UDP port when connecting to DBServer (not used in some situations.)
• -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 -tcp 18717 -getcharacter "Aleena"

DBQuery Entry Point

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