rpdb.db

Ontological Web Organizer (O.W.O.) - Go Back

Collection of TTRPs sessions and campaigns Done by me and my friends -- (=˘ϖ˘=)

No parameter Queries

View every formed team Calculate Armor Class Calculate Melee Attack List all Characters List all PDFs from all the Characters Characters and how many sessions they are in campaings

One parameter Queries

View Everything from a PG Show All Campaign and how many session there is in one Show A Character Modifier Show all sessions numbered chronologically from one campaing

Multiple parameter Queries

Select a modifier then show the Character with the highest stat and the lowest one

Non-Deterministic Multiple Parameters Queries

Choose a random character and image Select a Random Specified Type of Item From a Specified Character Inventory SImulate an attack with a weapon from a choosed character
Query
SQLITE3> SELECT ReadyCharacters.ID, ReadyCharacters.NomePersonaggio, Image.File FROM ReadyCharacters
INNER JOIN CharacterImage ON CharacterImage.Character_FK= ReadyCharacters.ID
INNER JOIN Image ON CharacterImage.Image_FK = Image.Image_ID

WHERE Image.Kind = 1 AND Image.File NOT LIKE '%Ring.PNG'
GROUP BY ReadyCharacters.NomePersonaggio
ORDER BY random()
LIMIT :offset, :entries;

Parameters


Result
IDNomePersonaggioFile
4Carlo/characters/Carlo/Carlo_Gimmzest.PNG
12Daikon/characters/Daikon/DaikonToken.PNG
18Tael'Roi/characters/Tael'Roi/TaelRoi.PNG
3Vinagrette/characters/Vinagrette/Vinagrette.PNG
32Raddeno/characters/Raddeno/Raddeno.PNG
25Jergo/characters/Jergo/Jergo_Limmintel.PNG
21Lindon/characters/Lindon/Lindon.PNG
13Dodbau/characters/Dodbau/Dodbau_v2.PNG
27Levitenn/characters/Levitenn/levitenn_2.PNG
2Seith/characters/Seith/Seith_Andross.PNG
22Nobom/characters/Nobom/Nobom.PNG
14Galgano/characters/Galgano/Galgano.PNG
24Yxen/characters/Yxen/Yxen.PNG
26John/characters/John/John_K_Bauler.PNG
5Ilvys/characters/Ilvys/IlvysToken.PNG
Previous Page Next Page

Views

Oneshots Character Inventory Modifiers Ready Campaign Ready Campaign
sqlite3.49.1 2025-02-18 13:38:58 873d4e274b4988d260ba8354a9718324a1c26187a4ab4c1cc0227c03d0f10e70 (64-bit)