yK9RJLwk

1server_playerLogin.sqf 
2	if(dayz_donors == "1") {
3		_donorresult = "blisshive" callExtension format ["Q:%1:call proc_getDonorLoadout(%2, %3)", (call fnc_instanceName), dayz_instance, _playerID];
4		_donorresult = call compile _donorresult;
5		donorInventory = call compile ((_donorresult select 0) select 0);
6		diag_log("SERVER: Got Donor Inventory of " + str(donorInventory));
7		if (!isNil str(donorInventory)) then {
8			_inventory = donorInventory;
9			_dbLoadout = _inventory;
10		};
11
12		donorBackpack = call compile ((_donorresult select 1) select 0);
13		diag_log("SERVER: Got Donor Backpack of " + str(donorBackpack));
14		if (!isNil str(donorBackpack)) then {
15			_bcpk = donorBackpack;
16		};
17
18		donorSkin = call compile ((_donorresult select 2) select 0);
19		diag_log("SERVER: Got Donor Skin of " + str(donorSkin));
20		if (!isNil str(donorSkin)) then {
21			_model = donorSkin;
22		};
23	};
24
25server_playerSetup.sqf
26
27_key = format["CHILD:102:%1:",_characterID];
28_primary = [_key,false,dayZ_hivePipeAuth] call server_hiveReadWrite;
29
30
31db/
32
33CREATE TABLE IF NOT EXISTS `donors` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `instance` int(2) NOT NULL DEFAULT '1',
36  `survivorid` int(8) NOT NULL,
37  `email` varchar(1024) NOT NULL,
38  `items` varchar(2048) DEFAULT NULL,
39  `backpack` varchar(2048) DEFAULT NULL,
40  `spawnloc` varchar(2048) DEFAULT NULL,
41  `description` varchar(2048) NOT NULL,
42  `amtpaid` int(11) NOT NULL,
43  `datepaid` date DEFAULT NULL,
44  `skin` varchar(45) DEFAULT 'Survivor2_DZ',
45  PRIMARY KEY (`id`)
46) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
47
48CREATE DEFINER=`dayz`@`localhost` PROCEDURE `proc_getDonorLoadout`(IN `p_instanceId` INT, IN `p_uid` INT)
49begin
50  select if (count(items) > 0, items, '[]') AS inventory, if (count(backpack) > 0, backpack, '[]') AS backpack, if (count(skin) > 0, skin, '[]') AS skin from donors where instance = p_instanceId and survivorid = p_uid; --
51end