Guest User

Untitled

a guest
Dec 12th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.87 KB | None | 0 0
  1. CREATE DEFINER=`dayz`@`localhost` PROCEDURE `createobj`(IN `otype` VARCHAR(50), IN `fuel` DOUBLE)
  2.     LANGUAGE SQL
  3.     NOT DETERMINISTIC
  4.     CONTAINS SQL
  5.     SQL SECURITY DEFINER
  6.     COMMENT ''
  7. BEGIN
  8. set @NewID = (select (max(unique_id)+1) as id1 from dayz.objects) ;
  9. set @uid1 = (select (max(unique_id)+1) as id1 from dayz.objects) ;
  10. set @pos1 = set @pos1 = (select pos from dayz.survivor where is_dead = 0 and unique_id = '72267014');
  11. insert into dayz.objects
  12. set unique_id = @NewID;
  13. update dayz.objects
  14. set uid = @uid1
  15. where unique_id = @NewID;
  16. update dayz.objects
  17. set pos = @pos1
  18. where unique_id = @NewID;
  19. update dayz.objects
  20. set Inventory = '[]'
  21. where unique_id = @NewID;
  22. update dayz.objects
  23. set otype = otype
  24. where unique_id = @NewID;
  25. update dayz.objects
  26. set fuel = fuel
  27. where unique_id = @NewID;
  28. update dayz.objects
  29. set instance  = 1
  30. where unique_id = @NewID;
  31. END
Add Comment
Please, Sign In to add comment