[Release] vRP Framework

#1254

mmm. should i come back :smiley:

#1255

Does anyone know where the script is for showing the street names above the map?

#1258

I have this errors, someone can bring me to light plese?

Error resuming coroutine: @vrp/lib/utils.lua:45: error loading module vrp_ghmattimysql/init_vrp:@vrp/lib/utils.lua:69: async wait(): Citizen.Await returned (nil) before the areturn call.
stack traceback:
[C]: in function ‘error’
@vrp/lib/utils.lua:69: in function <@vrp/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’
@vrp/lib/utils.lua:40: in function ‘module’
@vrp/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’
@vrp/lib/utils.lua:45: in function ‘module’
@vrp/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

#1259

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.

#1260

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).

#1261

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

#1262

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…

#1263

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)
    );
#1264

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

#1265

what did you do to fix this?

#1266

Figured it out nevermind reading directions can prove to be difficult

#1267

How did you fix it?

#1268

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

#1269

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).

#1270

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

#1271

How do i proxy into vRP on the client side?

#1272

yo how did your get your menus like that?

#1273

Just changed background :smiley:

#1274

Yeah but what file sir is there a tutorial

#1275

Like the actual menu