##########################################################################
#
# QuoteDB script configuration
#
##########################################################################

# Channels where quote functionality is enabled
# set qdb_channels "#foobar;#baz"
# You can use * to match substrings or everything
set qdb_channels "*"


###
### SQL database settings
###
# Path and filename of the SQLite database
set qdb_file "quotedb.sqlite"


###
### General settings
###

# Verbosity (1 = be verbose, 0 = be quiet)
set qdb_verbose 0


# 1 = Enable logging of various script actions into bot's log
# 0 = Don't.
set qdb_logmsg 1


# What IRC "command" should we use to send messages:
# (Valid alternatives are "PRIVMSG" and "NOTICE")
set qdb_preferredmsg "PRIVMSG"


###
### Search/command related settings
###
set qdb_max_deltime 15
set qdb_max_modtime 30


# Limit how many quotes should the "!<cmd> find" command show at most.
set qdb_showmax_pub 3

# Same as above, but for private message search.
set qdb_showmax_priv 5


###
### Messages
###

set qdb_msg_invalid_user "Pyh."

set qdb_msg_quote_does_not_exist "Quotea #%1 ei ole."

set qdb_msg_no_matches "Ei löydy!"

set qdb_msg_you_voted "Äänestit #%1 -> %2, nyt yhteensä %3"
set qdb_msg_vote_updated "Äänesi #%1 päivitetty -> %2, nyt yhteensä %3"

set qdb_msg_sql_error "Virhe sörkittäessä tietokantaa. uliskaa."
set qdb_msg_add_success "Tietokantaa %1 sörkitty (#%2), kiitos."

set qdb_msg_search_fmt "#%1: %2 (%3@%5)"

set qdb_msg_toplist_limit "Top-listan määrän oltava %1-%2."
set qdb_msg_toplist_fmt "%1. #%2: %3 (%4, %5)"

set qdb_msg_update_override " (owner/time override)"
set qdb_msg_update_ok "%1 #%2 päivitetty%3."

set qdb_msg_update_too_old "%1 quote #%2 vanhempi kuin %3 minuuttia, ei voida päivittää."

set qdb_msg_not_found "%1 #%2 ei löydy, tai se ei kuulu käyttäjälle '%3'."

set qdb_msg_stats "%1-tilastot: %2 quotea, %3 annettua ääntä."

set qdb_msg_help "%1 add <teksti>|update <id> <teksti>|del <id>|find <parametrit>|vote \[<id> <1|-1>\]|top3"


###
### Bind commands for each database etc.
###

# Bind !quote -command for table "quotedb"
bind pub - !quote quote_pub_cmd
bind msg - !quote quote_msg_cmd
proc quote_pub_cmd {unick uhost uhand uchan utext} { qdb_command "!quote" "quotedb" $unick $uhost $uhand $uchan $utext 1 ""}
proc quote_msg_cmd {unick uhost uhand utext}       { qdb_command "!quote" "quotedb" $unick $uhost $uhand "" $utext 0 ""}


bind pub - !spede spede_pub_cmd
bind msg - !spede spede_msg_cmd
proc spede_pub_cmd {unick uhost uhand uchan utext} { qdb_command "!spede" "spededb" $unick $uhost $uhand $uchan $utext 1 ""}
proc spede_msg_cmd {unick uhost uhand utext}       { qdb_command "!spede" "spededb" $unick $uhost $uhand "" $utext 0 ""}

bind pub - !mn mn_pub_cmd
bind msg - !mn mn_msg_cmd
proc mn_pub_cmd {unick uhost uhand uchan utext}    { qdb_command "!mn" "mndb" $unick $uhost $uhand $uchan $utext 1 ""}
proc mn_msg_cmd {unick uhost uhand utext}          { qdb_command "!mn" "mndb" $unick $uhost $uhand "" $utext 0 ""}

bind pub - !tuksu tuksu_pub_cmd
bind msg - !tuksu tuksu_msg_cmd
proc tuksu_pub_cmd {unick uhost uhand uchan utext} { qdb_command "!tuksu" "tuksudb" $unick $uhost $uhand $uchan $utext 1 ""}
proc tuksu_msg_cmd {unick uhost uhand utext}       { qdb_command "!tuksu" "tuksudb" $unick $uhost $uhand "" $utext 0 ""}