Dbquery.exe: Difference between revisions

From OuroDev
Aleena (talk | contribs)
m Reverted edits by Bevinsky (talk) to last revision by Aleena
Tag: Rollback
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
An application for sending commands to the dbserver.
An application for sending commands to the DBServer. DBServer listens on port 6997 by default.


Usage: bin\dbquery.exe ''[arguments]''
Usage: bin\dbquery.exe ''[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 [string, host]: Specifies the DBServer running on a remote host to connect to. Accepts DNS name or IP address. Default: localhost.
{{CLArg|-cookie|}}
* -dbquery [query]: Executes a query on the [[DBServer]]. Implies -noencrypt -nopigs and -silent.
{{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 filename: Puts a character into the database via DBServer. Implies -noencrypt -nopigs and -slient.
{{CLArg|-packetdebug|}}
* -querysgleaders "[string]"
{{CLArg|-putcharacter [file] &#124; < file|Puts a character into the database via DBServer. Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}.}}
* -restorecharacter
{{CLArg|-querysgleaders <string>|Probably queries to display the list of super group leaders when the supergroup is loaded.}}
* -silent: Produces cleaner output
{{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.}}
* -tcp [number]: Specify TCP port when connecting to DBServer (not used in some situations.)
{{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 (not used in some situations.)
{{CLArg|-tsr3|}}
* -verbose
{{CLArg|-udp [number]|Specify UDP port when connecting to DBServer, default 6997}}
{{CLArg|-verbose|}}
}}


== Sample Commands ==
== Sample Commands ==
Line 34: Line 36:


===Retrieving a character from a remote DBServer===
===Retrieving a character from a remote DBServer===
  dbquery -db 10.5.0.144 -tcp 18717 -getcharacter "Aleena"
  dbquery -db 10.5.0.144 -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

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

-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] | < 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