Dbquery.exe: Difference between revisions

From OuroDev
Added table template for the command line arguments.
m Reverted edits by Bevinsky (talk) to last revision by Aleena
Tag: Rollback
 
(4 intermediate revisions by 2 users not shown)
Line 10: Line 10:
{{CLArg|-cookie|}}
{{CLArg|-cookie|}}
{{CLArg|-db <host>|Specifies a remote host the DBServer is running on. Accepts DNS name or IP address. Default: localhost.}}
{{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|-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|-getcharacter "<name>"|Gets a character from the DBServer and outputs it to stdout. Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}.}}
{{CLArg|-nodebug|}}
{{CLArg|-nodebug|}}
Line 17: Line 17:
{{CLArg|-notimeout|}}
{{CLArg|-notimeout|}}
{{CLArg|-packetdebug|}}
{{CLArg|-packetdebug|}}
{{CLArg|-putcharacter <file>|Puts a character into the database via DBServer. Implies {{ms|-noencrypt}}, {{ms|-nopigs}} and {{ms|-silent}}.}}
{{CLArg|-putcharacter [file] &#124; < 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|-querysgleaders <string>|Probably queries to display the list of super group leaders when the supergroup is loaded.}}
{{CLArg|-restorecharacter "<name>"|Probably restores a character from backup?}}
{{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|-silent|Produces cleaner output}}
{{CLArg|-tcp [number]|Specify TCP port when connecting to DBServer, default 6997}}
{{CLArg|-tcp [number]|Specify TCP port when connecting to DBServer, default 6997}}

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