Hello,
So I used reality dayz package for a very long time. They have a very good working donator gear package with datavase function. I thought it would be cool and nice to have that in the epoch package aswell.
I'm not good at arma coding, I do understand the code when reading it but thats it.
Maybe someone here can help or maybe even the epoch dev crew wants this in a release ?
PlayerLogin.sqf
// Check custom inventory for new characters if (_model == "") then { _key = format["CHILD:999:select replace(cl.`inventory`, '""', '""""') inventory, replace(cl.`backpack`, '""', '""""') backpack, replace(coalesce(cl.`model`, 'Survivor2_DZ'), '""', '""""') model from `cust_loadout` cl join `cust_loadout_profile` clp on clp.`cust_loadout_id` = cl.`id` where clp.`unique_id` = '?':[%1]:",str(_playerID)]; _data = "HiveEXT" callExtension _key; //Process result _result = call compile format ["%1", _data]; _status = _result select 0; if (_status == "CustomStreamStart") then { if ((_result select 1) > 0) then { _data = "HiveEXT" callExtension _key; _result = call compile format ["%1", _data]; _inventory = call compile (_result select 0); _backpack = call compile (_result select 1); _model = call compile (_result select 2); }; }; };
create table if not exists cust_loadout ( id bigint unsigned not null auto_increment, inventory varchar(2048) not null, backpack varchar(2048) not null, model varchar(100) default null, primary key pk_cust_loadout (id) ) character set utf8 engine=InnoDB;
create table if not exists cust_loadout_profile ( cust_loadout_id bigint unsigned not null, unique_id varchar(128) not null, primary key pk_cust_loadout_profile (cust_loadout_id, unique_id), foreign key fk1_cust_loadout_profile (cust_loadout_id) references cust_loadout (id), foreign key fk2_cust_loadout_profile (unique_id) references profile (unique_id) ) character set utf8 engine=InnoDB;
Anybody that can help me with this? Please let me know :)