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 :)
Question
marsjee
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); }; }; };Anybody that can help me with this? Please let me know :)
Link to comment
Share on other sites
38 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now