Dbquery.exe

From OuroDev
Revision as of 17:57, 21 May 2019 by Bevinsky (talk | contribs)

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 -silent.

-querysgleaders <string>

Probably queries to display the list of super group leaders when the supergroup is loaded.

-restorecharacter <logfile>

Launches an interactive CLI to restore a character from the deleted characters log. Specifying the log is optional; you can do so within the interface.

-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