SHARE
TWEET

Untitled

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