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),
);
|