About

This plugin holds a stat database and collects the following:

• levels
• pups
• quests
• cp
• gqs
• mobkills

DB

dbbackup

usage: #bp.statdb.dbbackup [-h] [name]

backup the database

positional arguments:
  name        the name to backup to

optional arguments:
  -h, --help  show help (default: False)

dbclose

usage: #bp.statdb.dbclose [-h]

close the database

optional arguments:
  -h, --help  show help (default: False)

dbmodify

usage: #bp.statdb.dbmodify [-h] [stmt]

run a sql update/insert against the database

positional arguments:
  stmt        the sql statement

optional arguments:
  -h, --help  show help (default: False)

dbremove

usage: #bp.statdb.dbremove [-h] [table] [rownumber]

remove a row from a table

positional arguments:
  table       the table to remove the row from
  rownumber   the row number to remove (default: -1)

optional arguments:
  -h, --help  show help (default: False)

dbselect

usage: #bp.statdb.dbselect [-h] [stmt]

run a sql statement against the database

positional arguments:
  stmt        the sql statement

optional arguments:
  -h, --help  show help (default: False)

dbvac

usage: #bp.statdb.dbvac [-h]

vacuum the database

optional arguments:
  -h, --help  show help (default: False)

Milestones

comp

usage: #bp.statdb.comp [-h] [milestone1] [milestone2]

compare milestones

positional arguments:
  milestone1  the first milestone
  milestone2  the second milestone

optional arguments:
  -h, --help  show help (default: False)

list

usage: #bp.statdb.list [-h]

list milestones

optional arguments:
  -h, --help  show help (default: False)

Stats

cps

usage: #bp.statdb.cps [-n NUMBER] [-h] [count]

show cp stats

positional arguments:
  count                 the number of cps to show (default: 0)

optional arguments:
  -n NUMBER, --number NUMBER
                        show info for cp number
  -h, --help            show help (default: False)

gqs

usage: #bp.statdb.gqs [-n NUMBER] [-h] [count]

show gq stats

positional arguments:
  count                 the number of gqs to show (default: 0)

optional arguments:
  -n NUMBER, --number NUMBER
                        show info for gq number
  -h, --help            show help (default: False)

levels

usage: #bp.statdb.levels [-n NUMBER] [-h] [count]

show level stats

positional arguments:
  count                 the number of levels to show (default: 0)

optional arguments:
  -n NUMBER, --number NUMBER
                        show info for level number
  -h, --help            show help (default: False)

mobs

usage: #bp.statdb.mobs [-h] [count]

show mob stats

positional arguments:
  count       the number of mobkills to show (default: 0)

optional arguments:
  -h, --help  show help (default: False)

quests

usage: #bp.statdb.quests [-n NUMBER] [-h] [count]

show quests stats

positional arguments:
  count                 the number of quests to show (default: 0)

optional arguments:
  -n NUMBER, --number NUMBER
                        show info for level number
  -h, --help            show help (default: False)

Base

api

usage: #bp.statdb.api [-h] [api]

list functions in the api

positional arguments:
  api         api to get details of

optional arguments:
  -h, --help  show help (default: False)

help

usage: #bp.statdb.help [-a] [-c] [-h]

show help info for this plugin

optional arguments:
  -a, --api       show functions this plugin has in the api (default: False)
  -c, --commands  show commands in this plugin (default: False)
  -h, --help      show help (default: False)

inspect

usage: #bp.statdb.inspect [-m METHOD] [-o OBJECT] [-s] [-h]

inspect a plugin

optional arguments:
  -m METHOD, --method METHOD
                        get code for a method
  -o OBJECT, --object OBJECT
                        show an object of the plugin, can be method or
                        variable
  -s, --simple          show a simple output (default: False)
  -h, --help            show help (default: False)

reset

usage: #bp.statdb.reset [-h]

reset the plugin

optional arguments:
  -h, --help  show help (default: False)

save

usage: #bp.statdb.save [-h]

save the plugin state

optional arguments:
  -h, --help  show help (default: False)

set

usage: #bp.statdb.set [-h] [name] [value]

change a setting in the plugin

if there are no arguments or 'list' is the first argument then
it will list the settings for the plugin

positional arguments:
  name        the setting name (default: list)
  value       the new value of the setting

optional arguments:
  -h, --help  show help (default: False)

stats

usage: #bp.statdb.stats [-h]

show plugin stats

optional arguments:
  -h, --help  show help (default: False)

backupstart

the time for a db backup, ex. 1200 or 2000

backupinterval

the interval to backup the db, default every 4 hours

modifymany

statdb.modifymany(stmt, data)

    update many rows in a database


original defined in plugins/core/sqldb.py

modify

statdb.modify(stmt, data=None)

    modify the database


original defined in plugins/core/sqldb.py

select

statdb.select(stmt)

    run a select stmt against the db


original defined in plugins/core/sqldb.py

getrow

statdb.getrow(rowid, ttable)

    get a row from a table


original defined in plugins/core/sqldb.py