DROP PROCEDURE IF EXISTS dayz.createobj;
DELIMITER //
CREATE DEFINER=`dayz`@`localhost` PROCEDURE `createobj`(IN `otype` VARCHAR(50), IN `fuel` DOUBLE)
    LANGUAGE SQL
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
set @NewID = (select (max(uid)+1) as id1 from dayz.objects) ;
set @uid1 = (select (max(uid)+1) as id1 from dayz.objects) ;
set @pos1 = (select pos from dayz.survivor where is_dead = 0 and unique_id = '72267014');
insert into dayz.objects
set uid = @NewID;
update dayz.objects
set uid = @uid1
where uid = @NewID;
update dayz.objects
set pos = @pos1
where uid = @NewID;
update dayz.objects
set Inventory = '[]'
where uid = @NewID;
update dayz.objects
set otype = otype
where uid = @NewID;
update dayz.objects
set fuel = fuel
where uid = @NewID;
update dayz.objects
set instance  = 1
where uid = @NewID;
END//