[Release] vRP Framework

thorgaming · March 24, 2019, 10:57am

Did a fresh install with this release and the performance is really nice, would legacy vrp releases work with this? Are they easily amended to work with v2 of the framework.

MoneyMakerCv · March 24, 2019, 2:48pm

can someone help me fix this ?

[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).
[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).

SwoxiTV · March 24, 2019, 5:52pm

Where do i change things under this? i wanna add so you can see how much money you got on you

FikkaDusaTeam · March 24, 2019, 7:19pm

I change from localhost to 127.0.0.1 and database, user, password like this inside vrp\cfg\base.lua

cfg.db = {
driver = “ghmattimysql”,
host = “127.0.0.1”,
database = “vrp”,
user = “root”,
password = “”
}

And change this inside GHMattiMySQL\settings.xml

MySQL:Server">127.0.0.1<
MySQL:Port">3306<
MySQL:Database">vrp<
MySQL:Username">root<
MySQL:Password">< (no password)

I cant post all the code but this are the major changes i made…

P.S. Im just an average guy but works for me…

Epitrop0s · March 24, 2019, 9:56pm

Hi Im having some issue with a fresh install the console is out putting the following.

[GHMattiMySQL Debug] Connection: 109ms; Interaction: 27ms; Total 136ms for Query: SELECT 1;
[GHMattiMySQL Debug] Connection: 2ms; Interaction: 0ms; Total 2ms for Query: SELECT 1
[vRP] Connected to DB using driver "ghmattimysql".
[GHMattiMySQL Debug] Connection: 0ms; Interaction: 5ms; Total 5ms for Query: CREATE TABLE IF NOT EXISTS vrpTrueusers(
  id INTEGER AUTOTrueINCREMENT,
  whitelisted BOOLEAN,
  banned BOOLEAN,
  CONSTRAINT pkTrueuser PRIMARY KEY(id)
);

CREATE TABLE IF NOT EXISTS vrpTrueuserTrueids(
  identifier VARCHAR(100),
  userTrueid INTEGER,
  CONSTRAINT pkTrueuserTrueids PRIMARY KEY(identifier),
  CONSTRAINT fkTrueuserTrueidsTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS vrpTruecharacters(
  id INTEGER AUTOTrueINCREMENT,
  userTrueid INTEGER,
  CONSTRAINT pkTruecharacters PRIMARY KEY(id),
  CONSTRAINT fkTruecharactersTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS vrpTrueuserTruedata(
  userTrueid INTEGER,
  dkey VARCHAR(100),
  dvalue BLOB,
  CONSTRAINT pkTrueuserTruedata PRIMARY KEY(userTrueid,dkey),
  CONSTRAINT fkTrueuserTruedataTrueusers FOREIGN KEY(userTrueid) REFERENCES vrpTrueusers(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS vrpTruecharacterTruedata(
  characterTrueid INTEGER,
  dkey VARCHAR(100),
  dvalue BLOB,
  CONSTRAINT pkTruecharacterTruedata PRIMARY KEY(characterTrueid,dkey),
  CONSTRAINT fkTruecharacterTruedataTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE
);

CREATE TABLE IF NOT EXISTS vrpTrueserverTruedata(
  id VARCHAR(100),
  dkey VARCHAR(100),
  dvalue BLOB,
  CONSTRAINT pkTrueserverTruedata PRIMARY KEY(id, dkey)
);

CREATE TABLE IF NOT EXISTS vrpTrueglobalTruedata(
  dkey VARCHAR(100),
  dvalue BLOB,
  CONSTRAINT pkTrueglobalTruedata PRIMARY KEY(dkey)
);


Error resuming coroutine: lib/utils.lua:45: error loading module vrp_ghmattimysql/init_vrp:lib/utils.lua:69: async wait(): Citizen.Await returned (nil) before the areturn call.
stack traceback:
        [C]: in function 'error'
        lib/utils.lua:69: in function <lib/utils.lua:63>
        (...tail calls...)
        [string "vrp/vRP.lua"]:131: in method 'registerDBDriver'
        [string "vrp_ghmattimysql/init_vrp.lua"]:65: in main chunk
        [C]: in function 'xpcall'
        lib/utils.lua:40: in function 'module'
        base.lua:14: in local 'f'
        [string "vrp/lib/Proxy.lua"]:59: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:219: in function <citizen:/scripting/lua/scheduler.lua:218>
stack traceback:
        [C]: in function 'error'
        lib/utils.lua:45: in function 'module'
        base.lua:14: in local 'f'
        [string "vrp/lib/Proxy.lua"]:59: in upvalue 'handler'
        citizen:/scripting/lua/scheduler.lua:219: in function <citizen:/scripting/lua/scheduler.lua:218>
[GHMattiMySQL Debug] Connection: 0ms; Interaction: 0ms; Total 0ms for Query:     CREATE TABLE IF NOT EXISTS vrpTruecharacterTrueidentities(
      characterTrueid INTEGER,
      registration VARCHAR(20),
      phone VARCHAR(20),
      firstname VARCHAR(50),
      name VARCHAR(50),
      age INTEGER,
      CONSTRAINT pkTruecharacterTrueidentities PRIMARY KEY(characterTrueid),
      CONSTRAINT fkTruecharacterTrueidentitiesTruecharacters FOREIGN KEY(characterTrueid) REFERENCES vrpTruecharacters(id) ON DELETE CASCADE,
      INDEX(registration),
      INDEX(phone)
    );

Akira5004 · March 25, 2019, 2:05am

Ive done this still no dice… what should the set mysql_connection is the server config look like just an example would help.

Akira5004 · March 25, 2019, 2:59am

what did you do to fix this?

Akira5004 · March 26, 2019, 2:15pm

Figured it out nevermind reading directions can prove to be difficult

AntwanR942 · March 26, 2019, 4:19pm

How did you fix it?

Akira5004 · March 26, 2019, 4:38pm

Follow the directions very carefully it shows the citizens directory needs changed

FikkaDusaTeam · March 27, 2019, 5:18pm

I only “fix” this database problem on my server that’s all. Still have “Epitrop0s” errors!

[vRP] DB driver “ghmattimysql” not initialized yet (39 prepares cached, 5 queries cached).

Akira5004 · March 27, 2019, 8:32pm

Right now I am looking for a descent script for locking doors and paychecks the one I found so far are no bueno

bscal · March 28, 2019, 12:55am

How do i proxy into vRP on the client side?

Akira5004 · March 28, 2019, 4:04am

yo how did your get your menus like that?

SwoxiTV · March 28, 2019, 8:28am

Just changed background

Akira5004 · March 28, 2019, 12:36pm

Yeah but what file sir is there a tutorial

Akira5004 · March 28, 2019, 12:36pm

Like the actual menu

haverbeck · March 28, 2019, 4:14pm

i keep getting this warning

[vRP] DB driver "ghmattimysql" not initialized yet (39 prepares cached, 5 queries cached).

Akira5004 · March 28, 2019, 6:49pm

database issue improperly configed

bolo_six · March 30, 2019, 10:43pm

There is discord for the framework community?