summaryrefslogtreecommitdiff
path: root/docs/Database proto model.md
blob: b9c8c000e02c1b01ec36505b0b0e191989616f87 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Database:

    Entity(
        ID,
        Name,
        pos(x, y, z-order, map, sit(0/1)),
        equipment([slot, itemID]),
        flags([muted, banned, blocked, canMove]),
    );

    DB:Monster(
        Entity(),
        behavior(active, passive, shy),
        exp(),
        items([]),
        questflags(),
    );

    DB:players(
        Entity,
        username,
        password,
        email,
        group(usergroup, staffgroup), 
        inventory([itemID, quantity]),
        storage([itemID, quantity]),
        money(char, bank)
        states(questID or Name, value),
        homes([homeID,[x,y,map]])
        guild(guildID),
        party(partyID),
        ...
    );

    DB:guilds(
        guildID,
        guildname,
        storage([itemID, quantity]),
        money(bank),
        player([id, grade, userflags]),
        states(guildQuestID or Name, value),
        guildflags(exp, item),
    );

    DB:partys(
        partyID,
        partyname,
        player([id, grade]),
        partyflags(exp, item),
    );