Dbquery.exe: Difference between revisions

From OuroDev
mNo edit summary
(Added table template for the command line arguments.)
Line 6: Line 6:


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


== Sample Commands ==
== Sample Commands ==

Revision as of 13:32, 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 -silent.

-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