API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 16th, 2019
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.18 KB | None | 0 0
raw download clone embed print report
  1. ALTER TABLE `guild`
  2. ADD COLUMN `duty_point_cumulative` INT NOT NULL DEFAULT '0' AFTER `gold`,
  3. ADD COLUMN `ampoule` INT NOT NULL DEFAULT '0' AFTER `duty_point_cumulative`;
  4.  
  5. ALTER TABLE `guild`
  6. CHANGE COLUMN `duty_point_cumulative` `gold_cumulative` INT(11) NOT NULL DEFAULT '0' AFTER `gold`,
  7. ADD COLUMN `gold_today` INT(11) NOT NULL DEFAULT '0' AFTER `gold_cumulative`,
  8. ADD COLUMN `today` INT(11) NOT NULL DEFAULT '0' AFTER `gold_today`;
  9.  
  10. ALTER TABLE skill_proto ORDER BY dwVnum ASC;
  11.  
  12. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (151, 'unused (gilda)', 0, 1, 7, 0, 'NONE', '', '', '', '', '', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  13. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (152, 'Divoratore di Anime (gilda)', 0, 1, 5, 0, 'ATTBONUS_HUMAN', '2*k', '150', '180', '', '900', '', '', '', '', 'NONE', '', '', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  14. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (153, 'Sorgente di Energia (gilda)', 0, 1, 5, 0, 'MAX_HP', '(9*k)/2-5/2', '150', '180', '', '600', '', '', '', '', 'MAX_SP', '(9*k)/2-5/2', '180', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  15. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (154, 'Carica Furiosa (gilda)', 0, 1, 5, 0, 'MOV_SPEED', ' (25*k)/4 - 5/4', '150', '180', '', '480', '', '', '', '', 'ATT_SPEED', '(25*k)/4 - 5/4', '180', '', 'CASTING_SPEED', '10*k', '180', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  16. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (155, 'Colpo rabbioso (gilda)', 0, 1, 5, 0, 'CRITICAL', '10*k', '150', '180', '', '480', '', '', '', '', 'PENETRATE', '10*k', '180', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  17. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (156, 'Prigione Magica (gilda)', 0, 1, 5, 0, 'MOV_SPEED', '-((25*k)/4 - 5/4)', '150', '180', '', '1200', '', '', '', '', 'DAMAGE_REDUCTION', '(9*k)/2 - 5/2', '180', '', '', '', '', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  18. REPLACE INTO `skill_proto` (`dwVnum`, `szName`, `bType`, `bLevelStep`, `bMaxLevel`, `bLevelLimit`, `szPointOn`, `szPointPoly`, `szSPCostPoly`, `szDurationPoly`, `szDurationSPCostPoly`, `szCooldownPoly`, `szMasterBonusPoly`, `szAttackGradePoly`, `setFlag`, `setAffectFlag`, `szPointOn2`, `szPointPoly2`, `szDurationPoly2`, `setAffectFlag2`, `szPointOn3`, `szPointPoly3`, `szDurationPoly3`, `szGrandMasterAddSPCostPoly`, `prerequisiteSkillVnum`, `prerequisiteSkillLevel`, `eSkillType`, `iMaxHit`, `szSplashAroundDamageAdjustPoly`, `dwTargetRange`, `dwSplashRange`) VALUES (157, 'Cataclisma (gilda)', 0, 1, 5, 0, 'ATTBONUS_HUMAN', '20*k', '1500', '300', '', '7200', '', '', '', '', 'DAMAGE_REDUCTION', '(10*k)', '300', '', 'MOV_SPEED', '-((25*k)/4 - 5/4)', '300', '', 0, 0, 'NORMAL', 0, '1', 0, 0);
  19.  
  20. ALTER TABLE `object_proto`
  21. ADD COLUMN `guild_min_level` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `dependent_group`;
  22.  
  23. TRUNCATE TABLE object_proto;
  24.  
  25. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14064, 'Altare dell’Esperienza I', 250, '', 0, 0, 0, -202, -284, 204, 277, 20524, 2, 1, 12);
  26. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14065, 'Altare dell’Esperienza II', 0, '', 0, 0, 0, -202, -284, 204, 277, 20524, 2, 100, 0);
  27. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14066, 'Altare dell’Esperienza III', 0, '', 0, 0, 0, -202, -284, 204, 277, 20524, 2, 100, 0);
  28. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14067, 'Tempio del Drago I', 250, '', 0, 0, 0, -202, -284, 204, 277, 20525, 3, 1, 13);
  29. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14068, 'Tempio del Drago II', 0, '', 0, 0, 0, -202, -284, 204, 277, 20525, 3, 100, 0);
  30. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14069, 'Tempio del Drago III', 0, '', 0, 0, 0, -202, -284, 204, 277, 20525, 3, 100, 0);
  31. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14070, 'Stele della Caccia I', 50, '', 0, 0, 0, -202, -284, 204, 277, 20526, 4, 1, 11);
  32. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14071, 'Stele della Caccia II', 0, '', 0, 0, 0, -202, -284, 204, 277, 20526, 4, 100, 0);
  33. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14072, 'Stele della Caccia III', 0, '', 0, 0, 0, -202, -284, 204, 277, 20526, 4, 100, 0);
  34. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14073, 'Fiori di Elanor I', 50, '', 0, 0, 0, -202, -284, 204, 277, 20527, 5, 1, 10);
  35. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14074, 'Fiori di Elanor II', 0, '', 0, 0, 0, -202, -284, 204, 277, 20527, 5, 100, 0);
  36. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14075, 'Fiori di Elanor III', 0, '', 0, 0, 0, -202, -284, 204, 277, 20527, 5, 100, 0);
  37. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14076, 'Fornace Corazze I', 300, '', 0, 0, 0, -234, -195, 217, 264, 20528, 6, 1, 20);
  38. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14077, 'Fornace Corazze II', 0, '', 0, 0, 0, -234, -195, 217, 264, 20528, 6, 100, 0);
  39. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14078, 'Fornace Corazze III', 0, '', 0, 0, 0, -234, -195, 217, 264, 20528, 6, 100, 0);
  40. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14079, 'Fornace Armi I', 300, '', 0, 0, 0, -234, -195, 217, 264, 20529, 7, 1, 20);
  41. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14080, 'Fornace Armi II', 0, '', 0, 0, 0, -234, -195, 217, 264, 20529, 7, 100, 0);
  42. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14081, 'Fornace Armi III', 0, '', 0, 0, 0, -234, -195, 217, 264, 20529, 7, 100, 0);
  43. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14082, 'Fornace Gioielli I', 300, '', 0, 0, 0, -234, -195, 217, 264, 20530, 8, 1, 19);
  44. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14083, 'Fornace Gioielli II', 0, '', 0, 0, 0, -234, -195, 217, 264, 20530, 8, 100, 0);
  45. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14084, 'Fornace Gioielli III', 0, '', 0, 0, 0, -234, -195, 217, 264, 20530, 8, 100, 0);
  46. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14100, 'Castello(1)', 10, '', 0, 0, 0, -230, -261, 230, 262, 0, 1, 0, 0);
  47. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14101, '石圍牆(1-1)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -400, -153, 156, 400, 0, 5, 0, 0);
  48. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14102, '石圍牆(1-2)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -200, -106, 300, 106, 0, 5, 0, 0);
  49. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14103, '石圍牆(1-3)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -500, -106, 500, 106, 0, 5, 0, 0);
  50. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14104, '大門(1)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  51. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14105, '圍牆(1)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  52. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14110, 'Castello(2)', 10, '', 0, 0, 0, -230, -261, 230, 262, 0, 1, 0, 0);
  53. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14111, '石圍牆(2-1)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -400, -153, 156, 400, 0, 5, 0, 0);
  54. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14112, '石圍牆(2-2)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -200, -106, 300, 106, 0, 5, 0, 0);
  55. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14113, '石圍牆(2-3)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -500, -106, 500, 106, 0, 5, 0, 0);
  56. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14114, '大門(2)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  57. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14115, '圍牆(2)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  58. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14120, 'Castello(3)', 10, '', 0, 0, 0, -230, -261, 230, 262, 0, 1, 0, 0);
  59. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14121, '石圍牆(3-1)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -400, -153, 156, 400, 0, 5, 0, 0);
  60. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14122, '石圍牆(3-2)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -200, -106, 300, 106, 0, 5, 0, 0);
  61. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14123, '石圍牆(3-3)', 0, '90010,15/90011,5/90012,5', 0, 0, 0, -500, -106, 500, 106, 0, 5, 0, 0);
  62. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14124, '大門(3)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  63. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14125, '圍牆(3)', 0, '90010,5/90011,15/90012,10', 0, 0, 0, -1000, -274, 1000, 274, 0, 5, 0, 0);
  64. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14200, 'Stemma', 0, '90011,5/90012,5', 0, 0, 0, -45, -9, 42, 40, 0, 0, 1, 0);
  65. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14201, '氬濰渠僥', 0, '90010.5', 0, 0, 0, -1000, -54, 1000, 20, 0, 0, 1, 0);
  66. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14202, '氬濰萌漁', 0, '90010.5', 0, 0, 0, -1000, -18, 1000, 18, 0, 0, 1, 0);
  67. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14203, '氬濰豭漁', 0, '90010.5', 0, 0, 0, -19, -1362, 19, 1362, 0, 0, 1, 0);
  68. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14204, '氬濰螃艇漁', 0, '90010.5', 0, 0, 0, -18, -1362, 18, 1362, 0, 0, 1, 0);
  69. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14300, 'Roccia1', 0, '90010,5', 0, 0, 0, -116, -118, 116, 118, 0, 0, 0, 0);
  70. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14301, 'Roccia2', 0, '90010,5', 0, 0, 0, -118, -132, 118, 132, 0, 0, 0, 0);
  71. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14302, 'Roccia3', 0, '90010,7', 0, 0, 0, -133, -102, 133, 102, 0, 0, 0, 0);
  72. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14303, 'Roccia4', 0, '90010,7', 0, 0, 0, -104, -117, 104, 117, 0, 0, 0, 0);
  73. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14304, 'Roccia5', 0, '90010,7', 0, 0, 0, -171, -145, 171, 145, 0, 0, 0, 0);
  74. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14305, 'Roccia6', 0, '90010,8', 0, 0, 0, -192, -201, 192, 201, 0, 0, 0, 0);
  75. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14306, 'Roccia7', 0, '90010,8', 0, 0, 0, -183, -184, 183, 184, 0, 0, 0, 0);
  76. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14307, 'Roccia8', 0, '90010,8', 0, 0, 0, -66, -56, 66, 56, 0, 0, 0, 0);
  77. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14308, 'Roccia9', 0, '90010,9', 0, 0, 0, -65, -53, 65, 53, 0, 0, 0, 0);
  78. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14309, 'Roccia10', 0, '90010,9', 0, 0, 0, -182, -123, 182, 123, 0, 0, 0, 0);
  79. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14400, 'Albero1', 0, '90011,5', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  80. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14401, 'Albero2', 0, '90011,5', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  81. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14402, 'Albero3', 0, '90011,7', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  82. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14403, 'Albero4', 0, '90011,7', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  83. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14404, 'Albero5', 0, '90011,7', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  84. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14405, 'Albero6', 0, '90011,9', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  85. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14406, 'Albero7', 0, '90011,9', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  86. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14407, 'Albero8', 0, '90011,9', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  87. REPLACE INTO `object_proto` (`vnum`, `name`, `price`, `materials`, `upgrade_vnum`, `upgrade_limit_time`, `life`, `reg_1`, `reg_2`, `reg_3`, `reg_4`, `npc`, `group_vnum`, `dependent_group`, `guild_min_level`) VALUES (14408, 'Albero9', 0, '90011,9', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  88.  
  89.  
  90. ALTER TABLE `land`
  91. ADD COLUMN `smith1_day` INT NULL DEFAULT '0' AFTER `enable`,
  92. ADD COLUMN `smith1_count` INT NULL DEFAULT '0' AFTER `smith1_day`,
  93. ADD COLUMN `smith2_day` INT NULL DEFAULT '0' AFTER `smith1_count`,
  94. ADD COLUMN `smith2_count` INT NULL DEFAULT '0' AFTER `smith2_day`,
  95. ADD COLUMN `smith3_day` INT NULL DEFAULT '0' AFTER `smith2_count`,
  96. ADD COLUMN `smith3_count` INT NULL DEFAULT '0' AFTER `smith3_day`,
  97. ADD COLUMN `next_exp` DATETIME NULL DEFAULT CURRENT_TIMESTAMP AFTER `smith3_count`,
  98. ADD COLUMN `next_drop` DATETIME NULL DEFAULT CURRENT_TIMESTAMP AFTER `next_exp`;
  99.  
  100. ALTER TABLE `land`
  101. ADD COLUMN `npc_vnum` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `height`,
  102. ADD COLUMN `npc_map_index` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `npc_vnum`,
  103. ADD COLUMN `npc_x` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `npc_map_index`,
  104. ADD COLUMN `npc_y` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `npc_x`,
  105. ADD COLUMN `npc_rot` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `npc_y`;
  106.  
  107. ALTER TABLE `land`
  108. CHANGE COLUMN `npc_vnum` `npc_vnum` INT(10) UNSIGNED NOT NULL DEFAULT '20040' AFTER `height`;
  109.  
  110. TRUNCATE table `land`;
  111.  
  112. INSERT INTO `land` VALUES (1, 300, 8500, 8500, 9000, 9000, 20040, 244, 17000, 104500, 45, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  113. INSERT INTO `land` VALUES (2, 301, 8500, 8500, 9000, 9000, 20040, 244, 12500, 107000, 45, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  114. INSERT INTO `land` VALUES (3, 302, 8500, 8500, 9000, 9000, 20040, 244, 10500, 113500, 45, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  115. INSERT INTO `land` VALUES (4, 303, 8500, 8500, 9000, 9000, 20040, 244, 22500, 44300, 90, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  116. INSERT INTO `land` VALUES (5, 304, 8500, 8500, 9000, 9000, 20040, 244, 58400, 107100, 270, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  117. INSERT INTO `land` VALUES (6, 305, 8500, 8500, 9000, 9000, 20040, 244, 129000, 155300, 180, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  118. INSERT INTO `land` VALUES (7, 306, 8500, 8500, 9000, 9000, 20040, 244, 136200, 155500, 180, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  119. INSERT INTO `land` VALUES (8, 307, 8500, 8500, 9000, 9000, 20040, 244, 139500, 150200, 225, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  120. INSERT INTO `land` VALUES (9, 308, 8500, 8500, 9000, 9000, 20040, 244, 138100, 114000, 315, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  121. INSERT INTO `land` VALUES (10, 309, 8500, 8500, 9000, 9000, 20040, 244, 134000, 104000, 315, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  122. INSERT INTO `land` VALUES (11, 310, 8500, 8500, 9000, 9000, 20040, 244, 138400, 32500, 270, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  123. INSERT INTO `land` VALUES (12, 311, 8500, 8500, 9000, 9000, 20040, 244, 136600, 29000, 270, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  124. INSERT INTO `land` VALUES (14, 313, 8500, 8500, 9000, 9000, 20040, 244, 106400, 46500, 225, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  125. INSERT INTO `land` VALUES (15, 314, 8500, 8500, 9000, 9000, 20040, 244, 111000, 39400, 45, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  126. INSERT INTO `land` VALUES (13, 315, 8500, 8500, 9000, 9000, 20040, 244, 98300, 55500, 135, 0, 10, 10000, 'YES', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
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!