Lich:Script invdb: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
Cross-character searching & tracking of inventory, lockers, bank accounts, and other data. |
Cross-character searching & tracking of characters, inventory, lockers, bank accounts, and other data. |
||
Now including support for family vaults! |
Now including support for family vaults! |
||
author: Xanlin (Xanlin#4407 on discord) |
|||
| ⚫ | |||
=== Getting Started === |
=== Getting Started === |
||
| ⚫ | |||
<PRE> |
<PRE> |
||
Revision as of 19:35, 26 April 2023
Cross-character searching & tracking of characters, inventory, lockers, bank accounts, and other data.
Now including support for family vaults!
author: Xanlin (Xanlin#4407 on discord)
Getting Started
tldr: run
;invdb
to load your stuff, then
;invdb thing
to find your thing.
+---------------------------------------------------------------+
;invdb help > help text (this)
;invdb menu > basic starter menu
;invdb examples > examples
;invdb changelog > changelog
first parameter: action (default to refresh all if no parameters provided)
options: refresh, query, sum (or total), export, reset, delete, drop
refresh load/update your database
query prints out results to your story window
sum less detail than query, aggregates by type and item
export export table or query to a file
reset clear everything and start over
delete delete stuff, can be complicated, more on this later
drop drops a table, (item|bank|char)
second parameter: target (defaults to all or item)
options: bank, char, item, inv, locker
bank bank account & silvers
char character info
item both inventory and lockers
inv inventory, but not lockers
locker locker(s), but not inventory
optional parameters:
char=name # supports wildcards
game=gsiv # ignore this if you only play one game
type=gem # based on your GameObj type data.
amount(<|<=|=|>|>=)42 # amount greater than, equal to, etc a number
qty(<|<=|=|>|>=)42 # qty greater than, equal to, etc a number
noun=stone # buggy on items from locker manifest,
grabs the last word in the name
path=backpack # all items that start in a backpack
stack=(jar|bundle|stack|pack) # only jars implemented so far
status=(empty|partial|full) # to help find empty or full jars
marked=Y # not recorded in standard lockers
registered=Y # not recorded in standard lockers
worn= # not yet implemented
delay=5 #adds a delay before doing stuff
useful for adding to autostart
All other input is used as a search string in the primary name in the target.
If no parameters are provided, defaults to `refresh all`
If no applicatable action & target are specified,
defaults to querying for items based on other input
+---------------------------------------------------------------+
exporting:
;invdb export (char|item|inv|locker|bank) (optional parameters)
- additional optional export parameters:
format=(csv|txt|pipe) default = csv
dir="directory path" default = $lich_dir\\inv\\
file="filename.ext" default = (params)_target_timestamp.csv
+---------------------------------------------------------------+
most commands have abbreviations:
q = query c = char m = marked
i = item g = game r = registered
in = inv t = type s = stack
l = locker n = noun status = status
b = bank p = path w = worn
+--------------------------------------------------------------+
| invdb |
+--------------------------------------------------------------+
Run #1 first if your database is empty:
1: ;invdb refresh all to create/update the database
some examples:
2: character list ;invdb query char
3: bank accounts ;invdb q bank
4: landing bank total ;invdb sum bank amount>100000 elan
5: all gems in inv(s) ;invdb q inv type=gem
6: your stuff ;invdb q item c=Xanlin
7: all locker stuff ;invdb q locker
8: all empty jars ;invdb type=jar status=empty
9: total gems ;invdb sum type=gem
10: total uncut diamonds ;invdb sum type=gem =uncut dia*
Add an optional delay for autostart: ;autostart add invdb delay=3
+--------------------------------------------------------------+
- If you don't have premium lockers, your locker location is just listed as `locker`. If you don't have a paid subscription, you need to run the script at each locker that has contents with the locker open.
After you've run
;invdb
on each of the characters you want to load:
example in-game output:
searching for something related to button:
>;inv q button --- Lich: invdb active. ... loc: location of the item (hands|inv|locker|town abbr if multi locker) ... path: the path to an item, e.g. `backpack > box` is in a box, in a backpack ... type: object type, per GameObj.type_data ... stk: stack, a non-standard container, e.g. jar|bundle|voucher pack ... epf: status (empty|partial|full) for jars/stacks ... m: marked (Y or blank) ... r: registered (Y or blank) ------------------------------------------------------------------------------------------------------- name |loc | path | qty|type |stk|epf|m|r| item ------------------------------------------------------------------------------------------------------- Somealt1 |locker| locker | 1|armor | | | | | reinforced silver-buttoned leathers Xanlin |locker| locker | 1| | | | | | silvery moon-shaped button painted with the words, "Community. Unity. Icemule. Vote Tawariell." ------------------------------------------------------------------------------------------------------- matched 2 rows from item. --- Lich: invdb has exited.
finding where you stashed some gems:
>;inv type=gem =uncut diamond --- Lich: invdb active. -------------------------------------------------------------------------------------------------------- name |loc | path | qty|type |stk|epf|m|r| item -------------------------------------------------------------------------------------------------------- Somealt1 |inv | satchel | 2|gem | | | | | uncut diamond Mule1 |inv | sack > jar | 100|gem |jar| | | | uncut diamond Mule2 |hands | jacket > jar | 42|gem |jar| | | | uncut diamond Mule2 |inv | greatcloak > jar | 63|gem |jar| | | | uncut diamond Mule3 |inv | bag | 1|gem | | | | | uncut diamond -------------------------------------------------------------------------------------------------------- matched 5 rows from item. --- Lich: invdb has exited.
getting a total number of an item:
>;inv sum type=gem =uncut diamond --- Lich: invdb active. -------------------------------------------------------------- type | amount | item -------------------------------------------------------------- gem | 208 | uncut diamond gem | 208 | total -------------------------------------------------------------- matched 2 rows from item. --- Lich: invdb has exited.
bank accounts:
Can't remember how much that one character has in their bank?
>;inv q bank char=xanlin --- Lich: invdb active. ------------------------------------------------------------------------ name | bank | amount | updated ------------------------------------------------------------------------ Xanlin | First Elanith Secured Bank | ###,### | 06/25/18 Xanlin | Great Bank of Kharam-Dzu | ##,### | 06/25/18 Xanlin | Vornavis Bank of Solhaven | ###,### | 06/25/18 Xanlin | Bank of Torre County | ###,### | 06/25/18 Xanlin | Icemule Trace Bank | #,###,### | 06/25/18 Xanlin | Bank of Kharag 'doth Dzulthu | ##,### | 06/25/18 Xanlin | United City-States Bank | #,###,### | 06/28/18 Xanlin | Cysaegir Bank | ##,### | 06/26/18 Xanlin | Total | #,###,### | 06/28/18 ------------------------------------------------------------------------ matched 9 rows from bank. --- Lich: invdb has exited.
total up all your bank accounts:
>;inv sum bank --- Lich: invdb active. -------------------------------------------------------------- bank | amount | characters -------------------------------------------------------------- Bank of Kharag 'doth Dzulthu | ##,### | Xanlin, Somealt Bank of Torre County | ###,### | Xanlin, Somealt, Somealt2 Cysaegir Bank | ##,### | Xanlin, Somealt, Somealt2 First Elanith Secured Bank | ###,### | Xanlin, Somealt, Somealt2 Great Bank of Kharam-Dzu | ##,### | Xanlin, Somealt, Somealt2 Icemule Trace Bank | #,###,### | Xanlin, Somealt, Somealt2 United City-States Bank | #,###,### | Xanlin, Somealt, Somealt2 Vornavis Bank of Solhaven | ###,### | Xanlin, Somealt, Somealt2 grand total | #,###,### | Xanlin, Somealt, Somealt2 -------------------------------------------------------------- matched 9 rows from bank. --- Lich: invdb has exited.
Get your total at just one bank if you prefer:
>;inv sum bank elan --- Lich: invdb active. -------------------------------------------------------------- bank | amount | characters -------------------------------------------------------------- First Elanith Secured Bank | ###,### | Xanlin, Somealt, Somealt2 -------------------------------------------------------------- matched 1 rows from bank. --- Lich: invdb has exited.
Don't care for the in game queries and prefer your spreadsheets instead? You can export to csv (or tab/pipe delimited) and do whatever you want with it:
>;inv export item --- Lich: invdb active. exported 1166 rows from item to C:/.../lich/inv/item_2018-06-28_12-59-35.csv. --- Lich: invdb has exited.
item_2018-06-28_12-59-35.csv :
name,loc,path,qty,type,stk,epf,m,r,item Xanlin,inv,"",1,clothing,"", ,"","",thick ebonwood armband Xanlin,inv,"",1,clothing,"", ,Y,"",translucent spidersilk backpack Xanlin,inv,"",1,jewelry,"", ,"","",copper-bound linen badge Xanlin,inv,"",1,clothing,"", ,Y,"",oiled light leather courier bag with polished faenor buckles Xanlin,inv,"",1,"","", ,Y,"",black leather disarming case Xanlin,inv,"",1,clothing,"", ,Y,Y,translucent spidersilk cloak Xanlin,inv,"",1,"","", ,Y,Y,pair of rolaren-studded gauntlets Xanlin,inv,"",1,"","", ,Y,"",pair of black-tinted glasses Xanlin,inv,"",1,"","", ,Y,"",onyx-studded shadowy black hip-satchel Xanlin,inv,"",1,"","", ,"",Y,black hand insignia Xanlin,inv,"",1,clothing,"", ,Y,Y,silver locksmith kit Xanlin,inv,"",1,jewelry,"", ,"","",tiny iron catapult pin Xanlin,inv,"",1,magic,"", ,Y,"",dull gold ring Xanlin,inv,"",1,clothing,"", ,Y,"",matte black satchel Xanlin,inv,"",1,"","", ,Y,"",dark leather scalemail Xanlin,inv,"",1,"","", ,Y,"",leather swordbelt Xanlin,inv,"",1,"","", ,Y,"",emerald-hued imflass trident symbol adorned with blue coral Xanlin,inv,backpack,1,magic,"", ,"","",white flask Xanlin,inv,backpack,1,herb,"", ,"","",ambrominas leaf Xanlin,inv,backpack,1,lockpick,"", ,"","",copper lockpick Xanlin,inv,backpack,1,magic,"", ,"","",flawless gold ring Xanlin,inv,backpack,1,magic,"", ,"","",small statue Xanlin,inv,bag,1,magic,"", ,"","",ruby amulet Xanlin,inv,bag,1,"","", ,Y,Y,thin coarse linen blindfold Xanlin,inv,bag,3,"","", ,"","",crisp parchment bloodscrip Xanlin,inv,bag,1,clothing,"", ,Y,Y,pair of rolaren-toed boots Xanlin,inv,bag,2,gem,"", ,"","",uncut star-of-Tamzyrr diamond
Other useful commands
Want to delete a character?
>;invdb delete character char=<name>
How about a partial match when you want anything containing one word?
>;invdb shimmering *orb
| Third-Party Software - edit |
|---|
| Lich Installation: Lich |
| Downloadable Lich Scripts: Go2 | Map | Repository | Popular Scripts |