MRwTL2Fm

1[vRP] Extension Police loaded.
2[vRP] Extension Radio loaded.
3[vRP] Extension PedBlacklist loaded.
4[vRP] Extension VehBlacklist loaded.
5[vRP] Extension Edible loaded.
6[vRP] Extension Warp loaded.
7Started resource vrp
8Creating script environments for GHMattiMySQL
9Loaded GHMattiMySQL.net, Version=0.6.1.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_388121009
10Instantiated instance of script GHMattiMySQL.Core.
11Started resource GHMattiMySQL
12Creating script environments for vrp_ghmattimysql
13Started resource vrp_ghmattimysql
14Stopping resource sessionmanager
15Creating script environments for sessionmanager
16Started resource sessionmanager
17Could not open logo.png for reading.
18Authenticating server license key...
19Server license key authentication succeeded. Welcome!
20cfx> Sending heartbeat to live-internal.fivem.net:30110
21[vRP] DB driver "ghmattimysql" not initialized yet (39 prepares cached, 5 queries cached).
22Started map fivem-map-hipster
23Started resource fivem-map-hipster
24server thread hitch warning: timer interval of 152 milliseconds
25[GHMattiMySQL Debug] Connection: 482ms; Interaction: 120ms; Total 602ms for Query: SELECT 1;
26[GHMattiMySQL Debug] Connection: 173ms; Interaction: 100ms; Total 273ms for Query: SELECT 1
27[vRP] Connected to DB using driver "ghmattimysql".
28[GHMattiMySQL Debug] Connection: 153ms; Interaction: 405ms; Total 558ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueusers(
29  id INTEGER AUTOTrueINCREMENT,
30  whitelisted BOOLEAN,
31  banned BOOLEAN,
32  CONSTRAINT pkTrueuser PRIMARY KEY(id)
33);
34
35CREATE TABLE IF NOT EXISTS vrpTrueuserTrueids(
36  identifier VARCHAR(100),
37  userTrueid INTEGER,
38  CONSTRAINT pkTrueuserTrueids PRIMARY KEY(identifier),
39  CONSTRAINT fkTrueuserTrueidsTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
40);
41
42CREATE TABLE IF NOT EXISTS vrpTruecharacters(
43  id INTEGER AUTOTrueINCREMENT,
44  userTrueid INTEGER,
45  CONSTRAINT pkTruecharacters PRIMARY KEY(id),
46  CONSTRAINT fkTruecharactersTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
47);
48
49CREATE TABLE IF NOT EXISTS vrpTrueuserTruedata(
50  userTrueid INTEGER,
51  dkey VARCHAR(100),
52  dvalue BLOB,
53  CONSTRAINT pkTrueuserTruedata PRIMARY KEY(userTrueid,dkey),
54  CONSTRAINT fkTrueuserTruedataTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
55);
56
57CREATE TABLE IF NOT EXISTS vrpTruecharacterTruedata(
58  characterTrueid INTEGER,
59  dkey VARCHAR(100),
60  dvalue BLOB,
61  CONSTRAINT pkTruecharacterTruedata PRIMARY KEY(characterTrueid,dkey),
62  CONSTRAINT fkTruecharacterTruedataTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE
63);
64
65CREATE TABLE IF NOT EXISTS vrpTrueserverTruedata(
66  id VARCHAR(100),
67  dkey VARCHAR(100),
68  dvalue BLOB,
69  CONSTRAINT pkTrueserverTruedata PRIMARY KEY(id, dkey)
70);
71
72CREATE TABLE IF NOT EXISTS vrpTrueglobalTruedata(
73  dkey VARCHAR(100),
74  dvalue BLOB,
75  CONSTRAINT pkTrueglobalTruedata PRIMARY KEY(dkey)
76);
77
78
79[GHMattiMySQL Debug] Connection: 152ms; Interaction: 100ms; Total 252ms for Query:     CREATE TABLE IF NOT EXISTS vrpTruecharacterTrueidentities(
80      characterTrueid INTEGER,
81      registration VARCHAR(20),
82      phone VARCHAR(20),
83      firstname VARCHAR(50),
84      name VARCHAR(50),
85      age INTEGER,
86      CONSTRAINT pkTruecharacterTrueidentities PRIMARY KEY(characterTrueid),
87      CONSTRAINT fkTruecharacterTrueidentitiesTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE,
88      INDEX(registration),
89      INDEX(phone)
90    );
91
92[GHMattiMySQL Debug] Connection: 152ms; Interaction: 106ms; Total 258ms for Query: SELECT dvalue FROM vrpTrueserverTruedata WHERE id = main AND dkey = vRP:hidden_transformers
93[GHMattiMySQL Debug] Connection: 152ms; Interaction: 101ms; Total 253ms for Query: REPLACE INTO vrpTrueserverTruedata(id,dkey,dvalue) VALUES(main,vRP:hidden_transformers,UNHEX(83AB5765656420726573616C6582A8706F736974696F6E93CBC079A5A4C0000004CB407BFBC800000000CB405C252400000000A974696D657374616D70CE5D2B9A65AA57656564206669656C6482A8706F736974696F6E93CB40A16061C0000000CB40B5C8F140000000CB404AEC5A40000003A974696D657374616D70CE5D2B9A65AF576565642070726F63657373696E6782A8706F736974696F6E93CB4098B7A140000016CB40A6BD5DE000000BCB404C777920000001A974696D657374616D70CE5D2B9A65))
94[GHMattiMySQL Debug] Connection: 201ms; Interaction: 100ms; Total 301ms for Query:     CREATE TABLE IF NOT EXISTS vrpTruecharacterTruebusiness(
95      characterTrueid INTEGER,
96      name VARCHAR(30),
97      description TEXT,
98      capital INTEGER,
99      laundered INTEGER,
100      resetTruetimestamp INTEGER,
101      CONSTRAINT pkTruecharacterTruebusiness PRIMARY KEY(characterTrueid),
102      CONSTRAINT fkTruecharacterTruebusinessTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE
103    );
104
105[GHMattiMySQL Debug] Connection: 152ms; Interaction: 101ms; Total 253ms for Query:     CREATE TABLE IF NOT EXISTS vrpTruecharacterTruehomes(
106      characterTrueid INTEGER,
107      home VARCHAR(100),
108      number INTEGER,
109      CONSTRAINT pkTruecharacterTruehomes PRIMARY KEY(characterTrueid),
110      CONSTRAINT fkTruecharacterTruehomesTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE,
111      UNIQUE(home,number)
112    );