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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
-- NOTE(fusion): This file contains sample initial data and will be executed
-- automatically as a patch by the query manager. See `sqlite/README.txt` for
-- more details.
--==============================================================================
INSERT INTO Worlds (WorldID, Name, Type, RebootTime, Host, Port, MaxPlayers,
PremiumPlayerBuffer, MaxNewbies, PremiumNewbieBuffer)
VALUES (1, 'Zanera', 0, 5, 'localhost', 7172, 1000, 100, 300, 100);
-- 111111/tibia
INSERT INTO Accounts (AccountID, Email, Auth)
VALUES (111111, '@tibia', X'206699cbc2fae1683118c873d746aa376049cb5923ef0980298bb7acbba527ec9e765668f7a338dffea34acf61a20efb654c1e9c62d35148dba2aeeef8dc7788');
INSERT INTO Characters (WorldID, CharacterID, AccountID, Name, Sex)
VALUES (1, 1, 111111, 'Gamemaster', 1), (1, 2, 111111, 'Player', 1);
INSERT INTO CharacterRights (CharacterID, Name)
VALUES
(1, 'NOTATION'),
(1, 'NAMELOCK'),
(1, 'STATEMENT_REPORT'),
(1, 'BANISHMENT'),
(1, 'FINAL_WARNING'),
(1, 'IP_BANISHMENT'),
(1, 'KICK'),
(1, 'HOME_TELEPORT'),
(1, 'GAMEMASTER_BROADCAST'),
(1, 'ANONYMOUS_BROADCAST'),
(1, 'NO_BANISHMENT'),
(1, 'ALLOW_MULTICLIENT'),
(1, 'LOG_COMMUNICATION'),
(1, 'READ_GAMEMASTER_CHANNEL'),
(1, 'READ_TUTOR_CHANNEL'),
(1, 'HIGHLIGHT_HELP_CHANNEL'),
(1, 'SEND_BUGREPORTS'),
(1, 'NAME_INSULTING'),
(1, 'NAME_SENTENCE'),
(1, 'NAME_NONSENSICAL_LETTERS'),
(1, 'NAME_BADLY_FORMATTED'),
(1, 'NAME_NO_PERSON'),
(1, 'NAME_CELEBRITY'),
(1, 'NAME_COUNTRY'),
(1, 'NAME_FAKE_IDENTITY'),
(1, 'NAME_FAKE_POSITION'),
(1, 'STATEMENT_INSULTING'),
(1, 'STATEMENT_SPAMMING'),
(1, 'STATEMENT_ADVERT_OFFTOPIC'),
(1, 'STATEMENT_ADVERT_MONEY'),
(1, 'STATEMENT_NON_ENGLISH'),
(1, 'STATEMENT_CHANNEL_OFFTOPIC'),
(1, 'STATEMENT_VIOLATION_INCITING'),
(1, 'CHEATING_BUG_ABUSE'),
(1, 'CHEATING_GAME_WEAKNESS'),
(1, 'CHEATING_MACRO_USE'),
(1, 'CHEATING_MODIFIED_CLIENT'),
(1, 'CHEATING_HACKING'),
(1, 'CHEATING_MULTI_CLIENT'),
(1, 'CHEATING_ACCOUNT_TRADING'),
(1, 'CHEATING_ACCOUNT_SHARING'),
(1, 'GAMEMASTER_THREATENING'),
(1, 'GAMEMASTER_PRETENDING'),
(1, 'GAMEMASTER_INFLUENCE'),
(1, 'GAMEMASTER_FALSE_REPORTS'),
(1, 'KILLING_EXCESSIVE_UNJUSTIFIED'),
(1, 'DESTRUCTIVE_BEHAVIOUR'),
(1, 'SPOILING_AUCTION'),
(1, 'INVALID_PAYMENT'),
(1, 'TELEPORT_TO_CHARACTER'),
(1, 'TELEPORT_TO_MARK'),
(1, 'TELEPORT_VERTICAL'),
(1, 'TELEPORT_TO_COORDINATE'),
(1, 'LEVITATE'),
(1, 'SPECIAL_MOVEUSE'),
(1, 'MODIFY_GOSTRENGTH'),
(1, 'SHOW_COORDINATE'),
(1, 'RETRIEVE'),
(1, 'ENTER_HOUSES'),
(1, 'OPEN_NAMEDOORS'),
(1, 'INVULNERABLE'),
(1, 'UNLIMITED_MANA'),
(1, 'KEEP_INVENTORY'),
(1, 'ALL_SPELLS'),
(1, 'UNLIMITED_CAPACITY'),
(1, 'ATTACK_EVERYWHERE'),
(1, 'NO_LOGOUT_BLOCK'),
(1, 'GAMEMASTER_OUTFIT'),
(1, 'ILLUMINATE'),
(1, 'CHANGE_PROFESSION'),
(1, 'IGNORED_BY_MONSTERS'),
(1, 'SHOW_KEYHOLE_NUMBERS'),
(1, 'CREATE_OBJECTS'),
(1, 'CREATE_MONEY'),
(1, 'CREATE_MONSTERS'),
(1, 'CHANGE_SKILLS'),
(1, 'CLEANUP_FIELDS'),
(1, 'NO_STATISTICS');
|
