API tools faq
paste
Advertisement
Guest User

DayZ+Upgrade

a guest
Jan 13th, 2013
155
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 27.39 KB | None | 0 0
raw download clone embed print report
  1. SET FOREIGN_KEY_CHECKS=0;
  2. -- ----------------------------
  3. -- Table structure for `object_classes`
  4. -- ----------------------------
  5. DROP TABLE IF EXISTS `object_classes`;
  6. CREATE TABLE `object_classes` (
  7.   `Classname` varchar(32) NOT NULL DEFAULT '',
  8.   `Chance` varchar(4) NOT NULL DEFAULT '0',
  9.   `MaxNum` tinyint(1) unsigned NOT NULL DEFAULT '0',
  10.   `Damage` varchar(20) NOT NULL DEFAULT '0',
  11.   `Hitpoints` varchar(999) NOT NULL DEFAULT '[]',
  12.   PRIMARY KEY (`Classname`)
  13. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  14.  
  15. -- ----------------------------
  16. -- Records of object_classes
  17. -- ----------------------------
  18. INSERT INTO `object_classes` VALUES ('ATV_US_EP1', '1', '5', '0.05000', '[[\"motor\",1],[\"palivo\",0.368047],[\"wheel_1_1_steering\",0.331809],[\"wheel_1_2_steering\",1],[\"wheel_2_1_steering\",0.0473658],[\"wheel_2_2_steering\",0.332376],[\"karoserie\",0.355141],[\"wheel_1_3_steering\",0.0401988],[\"wheel_2_3_steering\",1]]');
  19. INSERT INTO `object_classes` VALUES ('LandRover_CZ_EP1', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  20. INSERT INTO `object_classes` VALUES ('Lada2_TK_CIV_EP1', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  21. INSERT INTO `object_classes` VALUES ('M1030', '1', '5', '0.05000', '[[\"motor\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1]]');
  22. INSERT INTO `object_classes` VALUES ('LandRover_TK_CIV_EP1', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  23. INSERT INTO `object_classes` VALUES ('Old_moto_TK_Civ_EP1', '1', '5', '0.05000', '[[\"motor\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1]]');
  24. INSERT INTO `object_classes` VALUES ('S1203_TK_CIV_EP1', '1', '3', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  25. INSERT INTO `object_classes` VALUES ('SUV_TK_CIV_EP1', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  26. INSERT INTO `object_classes` VALUES ('S1203_ambulance_EP1', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  27. INSERT INTO `object_classes` VALUES ('Old_bike_TK_CIV_EP1', '1', '10', '0.05000', '[]');
  28. INSERT INTO `object_classes` VALUES ('TT650_TK_CIV_EP1', '1', '5', '0.05000', '[[\"motor\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1]]');
  29. INSERT INTO `object_classes` VALUES ('UAZ_Unarmed_TK_CIV_EP1', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  30. INSERT INTO `object_classes` VALUES ('Volha_1_TK_CIV_EP1', '1', '5', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  31. INSERT INTO `object_classes` VALUES ('Volha_2_TK_CIV_EP1', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  32. INSERT INTO `object_classes` VALUES ('VolhaLimo_TK_CIV_EP1', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  33. INSERT INTO `object_classes` VALUES ('hilux1_civil_3_open_EP1', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  34. INSERT INTO `object_classes` VALUES ('HMMWV', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  35. INSERT INTO `object_classes` VALUES ('Ikarus', '1', '3', '0.05000', '[[\"motor\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_1_steering\",0.0156045],[\"wheel_1_3_steering\",0.0401988],[\"wheel_2_3_steering\",1]]');
  36. INSERT INTO `object_classes` VALUES ('Lada1', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  37. INSERT INTO `object_classes` VALUES ('LadaLM', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  38. INSERT INTO `object_classes` VALUES ('MMT_Civ', '1', '5', '0.05000', '[]');
  39. INSERT INTO `object_classes` VALUES ('Lada2', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  40. INSERT INTO `object_classes` VALUES ('Skoda', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  41. INSERT INTO `object_classes` VALUES ('SkodaBlue', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  42. INSERT INTO `object_classes` VALUES ('SkodaGreen', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  43. INSERT INTO `object_classes` VALUES ('SkodaRed', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  44. INSERT INTO `object_classes` VALUES ('tractor', '1', '4', '0.05000', '[[\"motor\",1],[\"sklo predni P\",0.0275828],[\"karoserie\",1],[\"palivo\",0.00205799],[\"wheel_2_1_steering\",0.0156045],[\"wheel_1_3_steering\",1],[\"wheel_2_3_steering\",0.0161143],[\"wheel_1_2_steering\",0.0082898],[\"glass1\",1],[\"glass3\",0.0224173]]');
  45. INSERT INTO `object_classes` VALUES ('hilux1_civil_2_covered', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  46. INSERT INTO `object_classes` VALUES ('hilux1_civil_1_open', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  47. INSERT INTO `object_classes` VALUES ('datsun1_civil_3_open', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  48. INSERT INTO `object_classes` VALUES ('datsun1_civil_2_covered', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  49. INSERT INTO `object_classes` VALUES ('datsun1_civil_1_open', '1', '2', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  50. INSERT INTO `object_classes` VALUES ('car_sedan', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  51. INSERT INTO `object_classes` VALUES ('car_hatchback', '1', '1', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  52. INSERT INTO `object_classes` VALUES ('VWGolf', '1', '3', '0.05000', '[[\"motor\",0.8],[\"karoserie\",1],[\"palivo\",0.8],[\"wheel_1_1_steering\",1],[\"wheel_2_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_2_2_steering\",1]]');
  53. INSERT INTO `object_classes` VALUES ('V3S_Civ', '1', '2', '0.05000', '[[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_1_3_steering\",0.0401988],[\"wheel_2_1_steering\",0.0156045],[\"wheel_2_3_steering\",1],[\"motor\",0.8],[\"palivo\",0.8]]');
  54. INSERT INTO `object_classes` VALUES ('UralCivil2', '1', '1', '0.05000', '[[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_1_3_steering\",0.0401988],[\"wheel_2_1_steering\",0.0156045],[\"wheel_2_3_steering\",1],[\"motor\",0.8],[\"palivo\",0.8]]');
  55. INSERT INTO `object_classes` VALUES ('UralOpen_CDF', '1', '1', '0.05000', '[[\"wheel_1_1_steering\",1],[\"wheel_1_2_steering\",1],[\"wheel_1_3_steering\",0.0401988],[\"wheel_2_1_steering\",0.0156045],[\"wheel_2_3_steering\",1],[\"motor\",0.8],[\"palivo\",0.8]]');
  56. INSERT INTO `object_classes` VALUES ('DZP_Mi17', '1', '1', '0.05000', '[[\"glass1\",1],[\"glass2\",1],[\"glass3\",1],[\"glass4\",1],[\"glass5\",1],[\"NEtrup\",1.1998],[\"motor\",1],[\"elektronika\",1],[\"mala vrtule\",1],[\"velka vrtule\",1],[\"munice\",1.07084],[\"sklo predni P\",1.04818],[\"sklo predni L\",1.11816],[\"glass6\",1.0402]]');
  57. INSERT INTO `object_classes` VALUES ('DZP_AN2', '1', '1', '0.05000', '[]');
  58. INSERT INTO `object_classes` VALUES ('PBX', '1', '4', '0.05000', '[[\"motor\",1]]');
  59. INSERT INTO `object_classes` VALUES ('DZP_MH6J', '1', '2', '0.05000', '[[\"glass1\",1],[\"glass2\",1],[\"glass3\",1],[\"glass4\",1],[\"glass5\",1],[\"NEtrup\",1.1998],[\"motor\",1],[\"elektronika\",1],[\"mala vrtule\",1],[\"velka vrtule\",1],[\"munice\",1.07084],[\"sklo predni P\",1.04818],[\"sklo predni L\",1.11816],[\"glass6\",1.0402]]');
  60.  
  61. -- ----------------------------
  62. -- Table structure for `object_spawns`
  63. -- ----------------------------
  64. DROP TABLE IF EXISTS `object_spawns`;
  65. CREATE TABLE `object_spawns` (
  66.   `ObjectUID` varchar(20) NOT NULL DEFAULT '',
  67.   `Classname` varchar(32) DEFAULT NULL,
  68.   `Worldspace` varchar(64) DEFAULT NULL,
  69.   `Description` varchar(255) DEFAULT NULL,
  70.   PRIMARY KEY (`ObjectUID`)
  71. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  72.  
  73. -- ----------------------------
  74. -- Records of object_spawns
  75. -- ----------------------------
  76. INSERT INTO `object_spawns` VALUES ('1', 'Old_bike_TK_CIV_EP1', '[191,[1643.65,2207.32,0.002]]', null);
  77. INSERT INTO `object_spawns` VALUES ('2', 'Old_bike_TK_CIV_EP1', '[168,[2949.83,1994.81,0.002]]', null);
  78. INSERT INTO `object_spawns` VALUES ('3', 'Old_bike_TK_CIV_EP1', '[179,[3559.78,2127.87,0.002]]', null);
  79. INSERT INTO `object_spawns` VALUES ('4', 'Old_bike_TK_CIV_EP1', '[3,[7260.84,2227.81,0.001]]', null);
  80. INSERT INTO `object_spawns` VALUES ('5', 'Old_bike_TK_CIV_EP1', '[60,[13403.6,5421.38,0.002]]', null);
  81. INSERT INTO `object_spawns` VALUES ('6', 'MMT_Civ', '[209,[4731.62,2591.81,0.001]]', null);
  82. INSERT INTO `object_spawns` VALUES ('7', 'MMT_Civ', '[315,[6121.42,1988.55,0.002]]', null);
  83. INSERT INTO `object_spawns` VALUES ('8', 'MMT_Civ', '[251,[10638.8,2194.2,0.001]]', null);
  84. INSERT INTO `object_spawns` VALUES ('9', 'MMT_Civ', '[59,[13481.6,6354.5,0.002]]', null);
  85. INSERT INTO `object_spawns` VALUES ('10', 'MMT_Civ', '[250,[13053.6,8168.36,8.636e-04]]', null);
  86. INSERT INTO `object_spawns` VALUES ('11', 'ATV_US_EP1', '[338,[12263.1,9143.23,0.001]]', null);
  87. INSERT INTO `object_spawns` VALUES ('12', 'ATV_US_EP1', '[199,[3692.9,8259.88,0.002]]', null);
  88. INSERT INTO `object_spawns` VALUES ('13', 'ATV_US_EP1', '[96,[8841.3,11683,0.001]]', null);
  89. INSERT INTO `object_spawns` VALUES ('14', 'M1030', '[313,[11271.5,12159,0.001]]', null);
  90. INSERT INTO `object_spawns` VALUES ('15', 'M1030', '[183,[4407.17,6028.14,0.001]]', null);
  91. INSERT INTO `object_spawns` VALUES ('16', 'M1030', '[128,[3662.62,8595.8,0.001]]', null);
  92. INSERT INTO `object_spawns` VALUES ('17', 'Old_moto_TK_Civ_EP1', '[142,[2860.47,9732.08,0.78]]', null);
  93. INSERT INTO `object_spawns` VALUES ('18', 'Old_moto_TK_Civ_EP1', '[36,[5071.65,12477.9,0.001]]', null);
  94. INSERT INTO `object_spawns` VALUES ('19', 'Old_moto_TK_Civ_EP1', '[230,[9712.91,6514.9,0.001]]', null);
  95. INSERT INTO `object_spawns` VALUES ('20', 'TT650_TK_CIV_EP1', '[351,[11373.6,5560.45,0.001]]', null);
  96. INSERT INTO `object_spawns` VALUES ('21', 'TT650_TK_CIV_EP1', '[202,[13135.7,10377.3,0.001]]', null);
  97. INSERT INTO `object_spawns` VALUES ('22', 'TT650_TK_CIV_EP1', '[298,[12936.4,12757.8,0.001]]', null);
  98. INSERT INTO `object_spawns` VALUES ('23', 'Ikarus', '[189,[10232.4,1880.31,0.001]]', null);
  99. INSERT INTO `object_spawns` VALUES ('24', 'Ikarus', '[41,[12081.9,9116.05,0.001]]', null);
  100. INSERT INTO `object_spawns` VALUES ('25', 'tractor', '[60,[9905.65,10340,0.002]]', null);
  101. INSERT INTO `object_spawns` VALUES ('26', 'tractor', '[31,[5283.24,5515.52,0.001]]', null);
  102. INSERT INTO `object_spawns` VALUES ('27', 'DZP_Mi17', '[21,[12045.4,12667,0.001]]', null);
  103. INSERT INTO `object_spawns` VALUES ('28', 'DZP_MH6J', '[149,[13695.7,2896.75,0.002]]', null);
  104. INSERT INTO `object_spawns` VALUES ('29', 'LandRover_CZ_EP1', '[110,[6364.82,7780.03,0.001]]', null);
  105. INSERT INTO `object_spawns` VALUES ('30', 'Lada2_TK_CIV_EP1', '[234,[2565.8,5076.3,0.001]]', null);
  106. INSERT INTO `object_spawns` VALUES ('31', 'LandRover_TK_CIV_EP1', '[287,[6942.73,11393.4,0.001]]', null);
  107. INSERT INTO `object_spawns` VALUES ('32', 'S1203_TK_CIV_EP1', '[293,[3212.5,3993.08,0.001]]', null);
  108. INSERT INTO `object_spawns` VALUES ('33', 'SUV_TK_CIV_EP1', '[8,[5765.73,4588,0.001]]', null);
  109. INSERT INTO `object_spawns` VALUES ('34', 'S1203_ambulance_EP1', '[10,[11949.9,9092.38,0.001]]', null);
  110. INSERT INTO `object_spawns` VALUES ('35', 'UAZ_Unarmed_TK_CIV_EP1', '[108,[11456.4,7505.86,0.001]]', null);
  111. INSERT INTO `object_spawns` VALUES ('36', 'Volha_1_TK_CIV_EP1', '[219,[10655.8,4516.13,0.001]]', null);
  112. INSERT INTO `object_spawns` VALUES ('37', 'Volha_2_TK_CIV_EP1', '[177,[9267.7,4951.18,0.002]]', null);
  113. INSERT INTO `object_spawns` VALUES ('38', 'VolhaLimo_TK_CIV_EP1', '[178,[7592.21,5274.22,0.002]]', null);
  114. INSERT INTO `object_spawns` VALUES ('39', 'hilux1_civil_3_open_EP1', '[143,[2565.08,6304.64,0.002]]', null);
  115. INSERT INTO `object_spawns` VALUES ('40', 'HMMWV', '[60,[4714.98,10227.2,0.001]]', null);
  116. INSERT INTO `object_spawns` VALUES ('41', 'Lada1', '[183,[4422.16,4578.02,0.001]]', null);
  117. INSERT INTO `object_spawns` VALUES ('42', 'LadaLM', '[80,[3411.67,4925.84,0.001]]', null);
  118. INSERT INTO `object_spawns` VALUES ('43', 'Lada2', '[360,[8483.49,6660.94,0.002]]', null);
  119. INSERT INTO `object_spawns` VALUES ('44', 'Skoda', '[258,[9587.22,6632.03,0.002]]', null);
  120. INSERT INTO `object_spawns` VALUES ('45', 'SkodaBlue', '[294,[12377.1,10986.3,0.001]]', null);
  121. INSERT INTO `object_spawns` VALUES ('46', 'SkodaGreen', '[156,[13373.7,12834.3,0.001]]', null);
  122. INSERT INTO `object_spawns` VALUES ('47', 'SkodaRed', '[168,[12957.3,13489.1,0.001]]', null);
  123. INSERT INTO `object_spawns` VALUES ('48', 'hilux1_civil_2_covered', '[136,[10999.8,13382,0.001]]', null);
  124. INSERT INTO `object_spawns` VALUES ('49', 'hilux1_civil_1_open', '[122,[9663.96,13560.1,9.918e-04]]', null);
  125. INSERT INTO `object_spawns` VALUES ('50', 'datsun1_civil_3_open', '[223,[6535.07,9277.51,0.001]]', null);
  126. INSERT INTO `object_spawns` VALUES ('51', 'datsun1_civil_2_covered', '[231,[7116.86,7783.26,0.001]]', null);
  127. INSERT INTO `object_spawns` VALUES ('52', 'datsun1_civil_1_open', '[179,[6586.44,3409.16,0.001]]', null);
  128. INSERT INTO `object_spawns` VALUES ('53', 'car_sedan', '[221,[5455.4,3785.44,0.001]]', null);
  129. INSERT INTO `object_spawns` VALUES ('54', 'car_hatchback', '[264,[6902.23,4513.05,0.002]]', null);
  130. INSERT INTO `object_spawns` VALUES ('55', 'VWGolf', '[166,[13387.7,6604.86,0.002]]', null);
  131. INSERT INTO `object_spawns` VALUES ('56', 'V3S_Civ', '[352,[11463.2,11375.6,0.001]]', null);
  132. INSERT INTO `object_spawns` VALUES ('57', 'UralCivil2', '[101,[11974.4,3573.93,0.001]]', null);
  133. INSERT INTO `object_spawns` VALUES ('58', 'UralOpen_CDF', '[268,[4798.11,2621.55,0.001]]', null);
  134. INSERT INTO `object_spawns` VALUES ('59', 'DZP_AN2', '[151,[4195.31,10860.5,0.001]]', null);
  135. INSERT INTO `object_spawns` VALUES ('60', 'PBX', '[175,[1304.27,2263.14,0.001]]', null);
  136. INSERT INTO `object_spawns` VALUES ('61', 'PBX', '[177,[5947.77,2004.61,0.002]]', null);
  137. INSERT INTO `object_spawns` VALUES ('62', 'PBX', '[336,[13061,8448.32,0.001]]', null);
  138. INSERT INTO `object_spawns` VALUES ('63', 'PBX', '[109,[13903.7,11713.7,0.001]]', null);
  139. INSERT INTO `object_spawns` VALUES ('64', 'DZP_MH6J', '[241,[4520.36,10779.9,0.082]]\r\n', null);
  140. INSERT INTO `object_spawns` VALUES ('65', 'UAZ_Unarmed_TK_CIV_EP1', '[238,[9254.46,4979.14,0.002]]', null);
  141. INSERT INTO `object_spawns` VALUES ('66', 'hilux1_civil_3_open_EP1', '[326,[9615.27,6521.02,0.002]]', null);
  142. INSERT INTO `object_spawns` VALUES ('67', 'VWGolf', '[204,[9689.23,8921.35,0.001]]', null);
  143. INSERT INTO `object_spawns` VALUES ('68', 'SUV_TK_CIV_EP1', '[228,[10321.9,12085.8,0.001]]', null);
  144. INSERT INTO `object_spawns` VALUES ('69', 'LandRover_CZ_EP1', '[202,[5075.77,12468.5,0.001]]', null);
  145. INSERT INTO `object_spawns` VALUES ('70', 'Skoda', '[248,[2715.5,10032.6,0.001]]', null);
  146. INSERT INTO `object_spawns` VALUES ('71', 'HMMWV', '[344,[1944.02,12468.3,0.001]]', null);
  147. INSERT INTO `object_spawns` VALUES ('72', 'tractor', '[247,[6606.28,9322.9,0.002]]', null);
  148. INSERT INTO `object_spawns` VALUES ('73', 'tractor', '[314,[12523.6,4338.32,0.001]]', null);
  149. INSERT INTO `object_spawns` VALUES ('74', 'hilux1_civil_2_covered', '[139,[9419.81,4045.35,0.001]]', null);
  150. INSERT INTO `object_spawns` VALUES ('75', 'ATV_US_EP1', '[352,[7817.9,3532.67,0.001]]', null);
  151. INSERT INTO `object_spawns` VALUES ('76', 'ATV_US_EP1', '[59,[5823.91,4978.11,0.001]]', null);
  152. INSERT INTO `object_spawns` VALUES ('77', 'M1030', '[323,[5003.47,5562.11,0.002]]', null);
  153. INSERT INTO `object_spawns` VALUES ('78', 'M1030', '[322,[4554.07,6405.57,0.002]]', null);
  154. INSERT INTO `object_spawns` VALUES ('79', 'Old_bike_TK_CIV_EP1', '[132,[3718.23,6013.37,0.001]]', null);
  155. INSERT INTO `object_spawns` VALUES ('80', 'Old_bike_TK_CIV_EP1', '[276,[2282.28,5373.99,0.001]]', null);
  156. INSERT INTO `object_spawns` VALUES ('81', 'Old_bike_TK_CIV_EP1', '[206,[1894.84,3896.62,0.002]]', null);
  157. INSERT INTO `object_spawns` VALUES ('82', 'Old_bike_TK_CIV_EP1', '[36,[1115.4,2247.52,0.001]]', null);
  158. INSERT INTO `object_spawns` VALUES ('83', 'Old_bike_TK_CIV_EP1', '[297,[3614.31,2225.83,0.001]]', null);
  159. INSERT INTO `object_spawns` VALUES ('84', 'Volha_1_TK_CIV_EP1', '[329,[10450,8866.46,0.001]]', null);
  160. INSERT INTO `object_spawns` VALUES ('85', 'Volha_1_TK_CIV_EP1', '[310,[12672.5,12897.8,0.002]]', null);
  161. INSERT INTO `object_spawns` VALUES ('86', 'Volha_1_TK_CIV_EP1', '[192,[3984.59,9184.06,0.002]]', null);
  162. INSERT INTO `object_spawns` VALUES ('87', 'Volha_1_TK_CIV_EP1', '[147,[5763.34,8670.6,0.001]]', null);
  163. INSERT INTO `object_spawns` VALUES ('88', 'S1203_TK_CIV_EP1', '[77,[10898.9,11608,0.001]]', null);
  164. INSERT INTO `object_spawns` VALUES ('89', 'S1203_TK_CIV_EP1', '[128,[9132.12,7162.11,0.001]]', null);
  165. INSERT INTO `object_spawns` VALUES ('90', 'V3S_Civ', '[165,[8553.66,8353.09,0.001]]', null);
  166. INSERT INTO `object_spawns` VALUES ('91', 'VWGolf', '[24,[10415.5,2567.03,0.039]]', null);
  167. INSERT INTO `object_spawns` VALUES ('92', 'Lada2', '[185,[8860.32,2883.55,8.545e-04]]', null);
  168. INSERT INTO `object_spawns` VALUES ('93', 'Ikarus', '[83,[2008.02,2262.69,0.001]]', null);
  169. INSERT INTO `object_spawns` VALUES ('94', 'Old_moto_TK_Civ_EP1', '[245,[3204.73,4548.16,0.001]]', null);
  170. INSERT INTO `object_spawns` VALUES ('95', 'Old_moto_TK_Civ_EP1', '[211,[2526.91,7561.16,0.002]]', null);
  171. INSERT INTO `object_spawns` VALUES ('96', 'TT650_TK_CIV_EP1', '[47,[1975.27,9150.2,0.001]]', null);
  172. INSERT INTO `object_spawns` VALUES ('97', 'TT650_TK_CIV_EP1', '[184,[4203.95,10344.7,0.001]]', null);
  173. INSERT INTO `object_spawns` VALUES ('98', 'S1203_ambulance_EP1', '[162,[5599.2,12035,0.001]]', null);
  174. INSERT INTO `object_spawns` VALUES ('99', 'datsun1_civil_1_open', '[38,[8074.92,11256,0.002]]', null);
  175. INSERT INTO `object_spawns` VALUES ('100', 'tractor', '[332,[6922.72,10751.2,0.001]]', null);
  176.  
  177. -- ----------------------------
  178. -- Procedure structure for `pCleanup`
  179. -- ----------------------------
  180. DROP PROCEDURE IF EXISTS `pCleanup`;
  181. DELIMITER ;;
  182. CREATE DEFINER=`root`@`localhost` PROCEDURE `pCleanup`()
  183. BEGIN
  184.  
  185.  CALL pCleanupOOB();
  186.  
  187.  DELETE
  188.   FROM object_data
  189.   WHERE Damage = '1';
  190.  
  191.  DELETE
  192.   FROM object_data
  193.   WHERE DATE(object_data.Datestamp) < CURDATE() - INTERVAL 9 DAY
  194.    AND CharacterID = 0
  195.    AND (Inventory = '[]'
  196.    OR (Inventory = '[[[],[]],[[],[]],[[],[]]]'
  197.    AND Classname = 'TentStorage'));
  198.  
  199.  UPDATE object_data, character_data
  200.   SET object_data.characterID = 0, object_data.Datestamp = CURDATE()
  201.   WHERE object_data.CharacterID = character_data.CharacterID
  202.    AND character_data.Alive = 0
  203.    AND DATE(character_data.Datestamp) < CURDATE() - INTERVAL 3 DAY;
  204.    
  205.  UPDATE object_data, character_data
  206.   SET object_data.characterID = 0, object_data.Datestamp = CURDATE()
  207.   WHERE object_data.CharacterID = character_data.CharacterID
  208.    AND DATE(character_data.LastLogin) < CURDATE() - INTERVAL 7 DAY;
  209.  
  210. END
  211. ;;
  212. DELIMITER ;
  213.  
  214. -- ----------------------------
  215. -- Procedure structure for `pCleanupOOB`
  216. -- ----------------------------
  217. DROP PROCEDURE IF EXISTS `pCleanupOOB`;
  218. DELIMITER ;;
  219. CREATE DEFINER=`root`@`localhost` PROCEDURE `pCleanupOOB`()
  220. BEGIN
  221.  
  222.     DECLARE intLineCount    INT DEFAULT 0;
  223.     DECLARE intDummyCount    INT DEFAULT 0;
  224.     DECLARE intDoLine            INT DEFAULT 0;
  225.     DECLARE intWest                INT DEFAULT 0;
  226.     DECLARE intNorth            INT DEFAULT 0;
  227.  
  228.     SELECT COUNT(*)
  229.         INTO intLineCount
  230.         FROM object_data;
  231.  
  232.     SELECT COUNT(*)
  233.         INTO intDummyCount
  234.         FROM object_data
  235.         WHERE Classname = 'dummy';
  236.  
  237.     WHILE (intLineCount > intDummyCount) DO
  238.    
  239.         SET intDoLine = intLineCount - 1;
  240.  
  241.         SELECT ObjectUID, Worldspace
  242.             INTO @rsObjectUID, @rsWorldspace
  243.             FROM object_data
  244.             LIMIT intDoLine, 1;
  245.  
  246.         SELECT REPLACE(@rsWorldspace, '[', '') INTO @rsWorldspace;
  247.         SELECT REPLACE(@rsWorldspace, ']', '') INTO @rsWorldspace;
  248.         SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), ',', '') INTO @West;
  249.         SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 3), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3 -1)) + 1), ',', '') INTO @North;
  250.  
  251.         SELECT INSTR(@West, '-') INTO intWest;
  252.         SELECT INSTR(@North, '-') INTO intNorth;
  253.  
  254.         IF (intNorth = 0) THEN
  255.             IF (@North = NULL) THEN
  256.                 SET @North = '';
  257.                 SELECT CONVERT(@North, DECIMAL(16,8)) INTO intNorth;
  258.             END IF;
  259.             IF (@North != NULL) THEN
  260.                 SELECT CONVERT(@North, DECIMAL(16,8)) INTO intNorth;
  261.             END IF;
  262.         END IF;
  263.  
  264.         IF (intWest > 0 OR intNorth > 15360) THEN
  265.             DELETE FROM object_data
  266.                 WHERE ObjectUID = @rsObjectUID;
  267.         END IF;
  268.        
  269.         SET intLineCount = intLineCount - 1;
  270.  
  271.     END WHILE;
  272.  
  273. END
  274. ;;
  275. DELIMITER ;
  276.  
  277. -- ----------------------------
  278. -- Procedure structure for `pFixMaxNum`
  279. -- ----------------------------
  280. DROP PROCEDURE IF EXISTS `pFixMaxNum`;
  281. DELIMITER ;;
  282. CREATE DEFINER=`root`@`localhost` PROCEDURE `pFixMaxNum`()
  283. BEGIN
  284.  
  285.     DECLARE iCounter INT DEFAULT 0;
  286.  
  287.     SELECT COUNT(*) INTO @iClassesCount FROM object_classes WHERE Classname<>'';
  288.     WHILE (iCounter < @iClassesCount) DO
  289.         SELECT Classname, MaxNum INTO @Classname, @MaxNum FROM object_classes LIMIT iCounter,1;
  290.         SELECT COUNT(*) INTO @iMaxClassSpawn FROM object_spawns WHERE Classname LIKE @Classname;
  291.         IF (@MaxNum > @iMaxClassSpawn) THEN
  292.             UPDATE object_classes SET MaxNum = @iMaxClassSpawn WHERE Classname = @Classname;
  293.         END IF;
  294.         SET iCounter = iCounter + 1;
  295.     END WHILE;
  296.  
  297. END
  298. ;;
  299. DELIMITER ;
  300.  
  301. -- ----------------------------
  302. -- Procedure structure for `pMain`
  303. -- ----------------------------
  304. DROP PROCEDURE IF EXISTS `pMain`;
  305. DELIMITER ;;
  306. CREATE DEFINER=`root`@`localhost` PROCEDURE `pMain`()
  307. BEGIN
  308.  
  309.     DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 100;      
  310.    
  311.     CALL pCleanup();
  312.     CALL pFixMaxNum;
  313.  
  314.     SELECT SUM(MaxNum) FROM object_classes INTO @iMaxNumTotal;
  315.     IF (iSpawnNumVeh > @iMaxNumTotal) THEN
  316.         SET iSpawnNumVeh = @iMaxNumTotal;
  317.     END IF;
  318.  
  319.     WHILE (fGetVehCount() < iSpawnNumVeh) DO
  320.         CALL pSpawn();
  321.     END WHILE;
  322.  
  323. END
  324. ;;
  325. DELIMITER ;
  326.  
  327. -- ----------------------------
  328. -- Procedure structure for `pSpawn`
  329. -- ----------------------------
  330. DROP PROCEDURE IF EXISTS `pSpawn`;
  331. DELIMITER ;;
  332. CREATE DEFINER=`root`@`localhost` PROCEDURE `pSpawn`()
  333. BEGIN
  334.     DECLARE bSpawned        TINYINT(1) DEFAULT 0;
  335.     DECLARE iLID                INT DEFAULT 0;
  336.  
  337.     WHILE (bSpawned = 0) DO
  338.  
  339.         SET iLID = LAST_INSERT_ID();
  340.  
  341.         INSERT INTO object_data (ObjectUID, Instance, Classname, Damage, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Datestamp)
  342.         SELECT ot.ObjectUID, '1', ot.Classname, ot.Damage, '0', ot.Worldspace, '[]', ot.Hitpoints, '0.05', SYSDATE()
  343.             FROM (SELECT oc.Classname, oc.Chance, oc.MaxNum, oc.Damage, oc.Hitpoints, os.ObjectUID, os.Worldspace
  344.                 FROM object_classes AS oc
  345.                 INNER JOIN object_spawns AS os
  346.                 ON oc.Classname = os.Classname
  347.                 ORDER BY RAND()) AS ot
  348.             WHERE NOT EXISTS (SELECT od.ObjectUID
  349.                             FROM object_data AS od
  350.                             WHERE ot.ObjectUID = od.ObjectUID)
  351.             AND fGetClassCount(ot.Classname) < ot.MaxNum
  352.             AND fGetSpawnFromChance(ot.Chance) = 1
  353.             LIMIT 1;
  354.      
  355.             IF (LAST_INSERT_ID() <> iLID) THEN
  356.                 SET bSpawned = 1;
  357.             END IF;
  358.      
  359.     END WHILE;
  360. END
  361. ;;
  362. DELIMITER ;
  363.  
  364. -- ----------------------------
  365. -- Function structure for `fGetClassCount`
  366. -- ----------------------------
  367. DROP FUNCTION IF EXISTS `fGetClassCount`;
  368. DELIMITER ;;
  369. CREATE DEFINER=`root`@`localhost` FUNCTION `fGetClassCount`(`clname` varchar(32)) RETURNS smallint(3)
  370.     READS SQL DATA
  371. BEGIN
  372.  
  373.     DECLARE iClassCount SMALLINT(3) DEFAULT 0;
  374.  
  375.     SELECT COUNT(*)
  376.         INTO iClassCount
  377.         FROM object_data
  378.         WHERE Classname = clname;
  379.  
  380.     RETURN iClassCount;
  381. END
  382. ;;
  383. DELIMITER ;
  384.  
  385. -- ----------------------------
  386. -- Function structure for `fGetSpawnFromChance`
  387. -- ----------------------------
  388. DROP FUNCTION IF EXISTS `fGetSpawnFromChance`;
  389. DELIMITER ;;
  390. CREATE DEFINER=`root`@`localhost` FUNCTION `fGetSpawnFromChance`(`chance` double) RETURNS tinyint(1)
  391.     NO SQL
  392. BEGIN
  393.  
  394.     DECLARE bspawn TINYINT(1) DEFAULT 0;
  395.  
  396.     IF (RAND() <= chance) THEN
  397.         SET bspawn = 1;
  398.     END IF;
  399.  
  400.     RETURN bspawn;
  401.  
  402. END
  403. ;;
  404. DELIMITER ;
  405.  
  406. -- ----------------------------
  407. -- Function structure for `fGetVehCount`
  408. -- ----------------------------
  409. DROP FUNCTION IF EXISTS `fGetVehCount`;
  410. DELIMITER ;;
  411. CREATE DEFINER=`root`@`localhost` FUNCTION `fGetVehCount`() RETURNS smallint(3)
  412.     READS SQL DATA
  413. BEGIN
  414.  
  415.  DECLARE iVehCount SMALLINT(3) DEFAULT 0;
  416.  
  417.  SELECT COUNT(*)
  418.   INTO iVehCount
  419.   FROM object_data, object_classes
  420.   WHERE object_data.Classname = object_classes.Classname;  
  421.  
  422.  RETURN iVehCount;
  423. END
  424. ;;
  425. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!