Dbquery.exe: Difference between revisions
Created page with "An application for sending commands to the dbserver. Usage: bin\dbquery.exe -''query'' __TOC__ == Sample Commands == ===Exporting and Importing a character=== bin\dbquery..." |
Tag: Rollback |
||
| (14 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
An application for sending commands to the | An application for sending commands to the DBServer. DBServer listens on port 6997 by default. | ||
Usage: bin\dbquery.exe | Usage: bin\dbquery.exe ''[arguments]'' | ||
__TOC__ | __TOC__ | ||
== Arguments == | |||
{{CommandLineTable| | |||
{{CLArg|-charactertransfer|See characterTransfer.c for some hilarious surprises!}} | |||
{{CLArg|-cookie|}} | |||
{{CLArg|-db <host>|Specifies a remote host the DBServer is running on. Accepts DNS name or IP address. Default: localhost.}} | |||
{{CLArg|-dbquery <query>|Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}. See list of [[Dbquery.exe\-dbquery_Arguments|arguments]].}} | |||
{{CLArg|-getcharacter "<name>"|Gets a character from the DBServer and outputs it to stdout. Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}.}} | |||
{{CLArg|-nodebug|}} | |||
{{CLArg|-noencrypt|Do not use encryption}} | |||
{{CLArg|-nopigs|Don't load any pigg files; use only loose files on the filesystem when necessary.}} | |||
{{CLArg|-notimeout|}} | |||
{{CLArg|-packetdebug|}} | |||
{{CLArg|-putcharacter [file] | < file|Puts a character into the database via DBServer. Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}.}} | |||
{{CLArg|-querysgleaders <string>|Probably queries to display the list of super group leaders when the supergroup is loaded.}} | |||
{{CLArg|-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.}} | |||
{{CLArg|-silent|Produces cleaner output}} | |||
{{CLArg|-tcp [number]|Specify TCP port when connecting to DBServer, default 6997}} | |||
{{CLArg|-templates|}} | |||
{{CLArg|-tsr2|}} | |||
{{CLArg|-tsr3|}} | |||
{{CLArg|-udp [number]|Specify UDP port when connecting to DBServer, default 6997}} | |||
{{CLArg|-verbose|}} | |||
}} | |||
== Sample Commands == | == Sample Commands == | ||
===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 -getcharacter "Aleena" | |||
== DBQuery Entry Point == | |||
https://git.ourodev.com/CoX/Source/src/branch/develop/MapServer/svr/dbquery_init.c | |||
Latest revision as of 16:59, 21 May 2019
An application for sending commands to the DBServer. DBServer listens on port 6997 by default.
Usage: bin\dbquery.exe [arguments]
Arguments
|
|
See characterTransfer.c for some hilarious surprises! |
|
|
|
|
|
Specifies a remote host the DBServer is running on. Accepts DNS name or IP address. Default: localhost. |
|
|
Implies |
|
|
Gets a character from the DBServer and outputs it to stdout. Implies |
|
|
|
|
|
Do not use encryption |
|
|
Don't load any pigg files; use only loose files on the filesystem when necessary. |
|
|
|
|
|
|
|
|
Puts a character into the database via DBServer. Implies |
|
|
Probably queries to display the list of super group leaders when the supergroup is loaded. |
|
|
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. |
|
|
Produces cleaner output |
|
|
Specify TCP port when connecting to DBServer, default 6997 |
|
|
|
|
|
|
|
|
|
|
|
Specify UDP port when connecting to DBServer, default 6997 |
|
|
|
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