Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
i appreciate your concern and help.
but, what you stated above is already checked and finished.
hiveExt.ini : checked ok.
select s.`id`, s.`worldspace`, s.`inventory`, s.`backpack`, timestampdiff(minute, s.`start_time`, s.`last_updated`) as `SurvivalTime`, timestampdiff(minute, s.`last_ate`, NOW()) as `MinsLastAte`, timestampdiff(minute, s.`last_drank`, NOW()) as `MinsLastDrank`, s.`model` from `survivor` s join `instance` i on s.`world_id` = i.`world_id` and i.`id` = 1 where s.`unique_id` = 'xxxxxxxx' and s.`is_dead` = 0
create table `master_inventory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`inventory` varchar(2048) DEFAULT NULL,
`backpack` varchar(2048) DEFAULT NULL,
`unique_id` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
);
ALTER TABLE `master_inventory`
ADD UNIQUE INDEX `unique_id_UNIQUE` (`unique_id` ASC) ;
delimiter //
CREATE TRIGGER update_master_inventory AFTER UPDATE ON survivor
FOR EACH ROW
BEGIN
DECLARE CheckExists int;
if @DISABLE_TRIGGER is NULL THEN
SET CheckExists = 0;
SELECT count(*) INTO CheckExists from master_inventory WHERE unique_id = NEW.unique_id;
if CheckExists = 0 then
insert into master_inventory (unique_id, inventory, backpack) values (NEW.unique_id, NEW.inventory, NEW.backpack);
ELSE
update master_inventory set inventory = NEW.inventory, backpack = NEW.backpack where unique_id = NEW.unique_id;
END IF;
END IF;
END//
delimiter ;
delimiter //
CREATE TRIGGER update_survivor_inventory AFTER INSERT ON log_entry
FOR EACH ROW
BEGIN
IF (NEW.log_code_id = 2) || (NEW.log_code_id = 5) THEN
SET @DISABLE_TRIGGER = 1;
update survivor s join master_inventory mi on s.unique_id = mi.unique_id set s.inventory = mi.inventory, s.backpack = mi.backpack where s.unique_id = mi.unique_id and s.is_dead = 0;
SET @DISABLE_TRIGGER = null;
END IF;
END//
delimiter ;
delimiter //
CREATE TRIGGER update_survivor_inventory AFTER INSERT ON log_entry
FOR EACH ROW
BEGIN
declare backpackValue varchar(2048);
declare inventoryValue varchar(2048);
IF (NEW.log_code_id = 2) || (NEW.log_code_id = 5) THEN
select s.inventory, s.backpack into inventoryValue, backpackValue from survivor s where unique_id = NEW.unique_id and last_updated = (select max(last_updated) from survivor where unique_id = NEW.unique_id group by unique_id);
update survivor s set s.inventory = inventoryValue, s.backpack = backpackValue where s.unique_id = NEW.unique_id;
END IF;
END//
delimiter ;