Dbquery.exe: Difference between revisions
From OuroDev
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 [ | * -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. | * -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. | * -getcharacter "[name]": Gets a character from the DBServer and outputs it to stdout. Implies -noencrypt -nopigs and -silent. | ||
| Line 20: | Line 20: | ||
* -restorecharacter | * -restorecharacter | ||
* -silent: Produces cleaner output | * -silent: Produces cleaner output | ||
* -tcp | * -tcp [number]: Specify TCP port when connecting to DBServer. Default 18717 | ||
* -templates | * -templates | ||
* -tsr2 | * -tsr2 | ||
* -tsr3 | * -tsr3 | ||
* -udp | * -udp [number]: Specify UDP port when connecting to DBServer | ||
* -verbose | * -verbose | ||
| Line 30: | Line 30: | ||
===Exporting and Importing a character=== | ===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 == | == 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 12:20, 30 April 2019
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. Default 18717
- -templates
- -tsr2
- -tsr3
- -udp [number]: Specify UDP port when connecting to DBServer
- -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