daily pastebin goal
91%
SHARE
TWEET

Untitled

a guest Dec 12th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top