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> -- Regroup all chars for the team formed
SELECT DISTINCT group_concat(Personaggio.Name) AS "Team", Campaign.Title AS "Campagna"--, Session.Session_ID --, Session.Title AS "Titlo Sessione"
FROM Session
INNER JOIN Campaign ON Session.Campaign_ID = Campaign.Campaign_ID
INNER JOIN CharacterInSession ON CharacterInSession.Session_ID = Session.Session_ID
INNER JOIN Personaggio ON CharacterInSession.Personaggio_ID = Personaggio.Personaggio_ID
GROUP BY Session.Session_ID--,Personaggio.Name
HAVING count(Personaggio.Name) > 1 -- Ignore session with only one player
ORDER BY Campaign.Campaign_ID


Result
TeamCampagna
Mesembra,SeithNettunia
Mesembra,VinagretteGige Nameless but whimsical story
Mesembra,Vinagrette,CarloGige Nameless but whimsical story
Ilvys,Agama,Geeeseee,KennethIlvys Dies in the end
Rododendro,Korvus,AlisterNo-piece
Rododendro,Korvus,DaikonNo-piece
Dodbau,Galgano,Giliath,Marilena,Rodoedero,Tael'RoiDodbau's 'Origin'
Cain,Lindon,Nobom,RondirOneshot Sole Pallido
Jergo,Yxen,Dodbau,MesembraOneshot Bunker Terahex - La mansione maledetta
John,Levitenn,RaddenoLa Guerra di Gige
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)