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