A Project for Chronicle 4 based on L2JServer.


    Few item corrections

    Share
    avatar
    Karakan

    Posts : 421
    Join date : 2013-10-04

    Few item corrections

    Post  Karakan on 8th October 2013, 18:40

    Little fix for :
    Apprentice Adventurers Weapon/Armor Exchange Coupons (not sellable,dropable & tradeable)
    Adenturers/Travelers Weapons  (not sellable,dropable & tradeable.)

    etcitem diff
    Code:
    Index: D:/workspace/Lisvus_DataPack/sql/etcitem.sql
    ===================================================================
    --- D:/workspace/Lisvus_DataPack/sql/etcitem.sql (revision 451)
    +++ D:/workspace/Lisvus_DataPack/sql/etcitem.sql (working copy)
    @@ -6037,7 +6037,7 @@
     ('7807', 'Green Colored Lure - For Beginners', 'false', 'lure', '5', 'stackable', 'liquid', 'none', '50', '0', 'true', 'true', 'true', 'true', 'C4Item', 'none'),
     ('7808', 'Purple Colored Lure - For Beginners', 'false', 'lure', '5', 'stackable', 'liquid', 'none', '70', '0', 'true', 'true', 'true', 'true', 'C4Item', 'none'),
     ('7809', 'Yellow Colored Lure - For Beginners', 'false', 'lure', '5', 'stackable', 'liquid', 'none', '60', '0', 'true', 'true', 'true', 'true', 'C4Item', 'none'),
    -('7832', 'Apprentice Adventurer\'s Weapon Exchange Coupon', 'false', 'none', '1', 'normal', 'paper', 'none', '0', '0', 'false', 'true', 'true', 'true', 'C4Item', 'none'),
    +('7832', 'Apprentice Adventurer\'s Weapon Exchange Coupon', 'false', 'none', '1', 'normal', 'paper', 'none', '0', '0', 'false', 'false', 'true', 'false', 'C4Item', 'none'),
    -('7833', 'Adventurer\'s Magic Armor Exchange Coupon', 'false', 'none', '1', 'normal', 'paper', 'none', '0', '0', 'false', 'true', 'true', 'true', 'C4Item', 'none'),
    +('7833', 'Adventurer\'s Magic Armor Exchange Coupon', 'false', 'none', '1', 'normal', 'paper', 'none', '0', '0', 'false', 'false', 'true', 'false', 'C4Item', 'none'),
     ('7835', 'Amulet: Seal of Disease', 'false', 'spellbook', '120', 'normal', 'paper', 'none', '11600', '0', 'true', 'true', 'true', 'true', 'C4Item', 'none'),
     ('7838', 'Santa\'s Hat', 'false', 'none', '10', 'normal', 'paper', 'none', '0', '0', 'true', 'true', 'true', 'true', 'C4Item', 'none');
    \ No newline at end of file
    weapon diff
    Code:
    Index: D:/workspace/Lisvus_DataPack/sql/weapon.sql
    ===================================================================
    --- D:/workspace/Lisvus_DataPack/sql/weapon.sql (revision 451)
    +++ D:/workspace/Lisvus_DataPack/sql/weapon.sql (working copy)
    @@ -1049,20 +1049,20 @@
     ('7813', 'Hell Knife - Magic Regeneration', 'rhand', 'true', '740', '1', '1', 'blood_steel', 'b', '122', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '122', '8680000', '1157', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
     ('7814', 'Hell Knife - Mental Shield', 'rhand', 'true', '740', '1', '1', 'blood_steel', 'b', '122', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '122', '8680000', '1157', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
     ('7815', 'Hell Knife - Magic Weakness', 'rhand', 'true', '740', '1', '1', 'blood_steel', 'b', '122', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '122', '8680000', '1157', 'true', 'true', 'true', 'true', '0', '0', '1164', '3', '7', '0', '0', '0'),
    -('7816', 'Apprentice Adventurer\'s Staff', 'lrhand', 'false', '1070', '2', '2', 'wood', 'none', '23', '20', 'bigblunt', '4', '4.00000', '0', '0', '0', '325', '0', '22', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7817', 'Apprentice Adventurer\'s Bone Club', 'rhand', 'false', '1850', '2', '2', 'fine_steel', 'none', '24', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '17', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7818', 'Apprentice Adventurer\'s Knife', 'rhand', 'false', '1120', '2', '2', 'mithril', 'none', '21', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '17', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7819', 'Apprentice Adventurer\'s Cestus', 'lrhand', 'false', '1570', '2', '2', 'steel', 'none', '29', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '17', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7820', 'Apprentice Adventurer\'s Bow', 'lrhand', 'false', '1900', '7', '2', 'wood', 'none', '49', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '3', '17', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7821', 'Apprentice Adventurer\'s Long Sword', 'rhand', 'false', '1560', '2', '2', 'fine_steel', 'none', '24', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '17', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7822', 'Traveler\'s Mace', 'rhand', 'false', '1300', '2', '2', 'steel', 'd', '41', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '43', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7823', 'Traveler\'s Dark Elven Bow', 'lrhand', 'false', '1830', '6', '2', 'steel', 'd', '105', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '4', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7824', 'Traveler\'s Long Bow', 'lrhand', 'false', '1830', '6', '2', 'steel', 'd', '105', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '4', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7825', 'Traveler\'s Staff', 'lrhand', 'false', '1040', '2', '2', 'wood', 'd', '50', '20', 'bigblunt', '4', '4.00000', '0', '0', '0', '325', '0', '43', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7826', 'Traveler\'s Bastard Sword', 'rhand', 'false', '1510', '2', '2', 'fine_steel', 'd', '51', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7827', 'Traveler\'s Wand', 'rhand', 'false', '570', '2', '2', 'steel', 'd', '41', '10', 'etc', '8', '0.00000', '0', '0', '0', '379', '0', '43', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7828', 'Traveler\'s Jamadhr', 'lrhand', 'false', '1550', '2', '2', 'steel', 'd', '62', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7829', 'Traveler\'s Tomahawk', 'rhand', 'false', '1780', '2', '2', 'bronze', 'd', '51', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7830', 'Traveler\'s Poniard Dagger', 'rhand', 'false', '1090', '2', '2', 'steel', 'd', '45', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    -('7831', 'Traveler\'s Pike', 'lrhand', 'false', '2090', '2', '2', 'steel', 'd', '51', '10', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '32', '0', '0', 'false', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7816', 'Apprentice Adventurer\'s Staff', 'lrhand', 'false', '1070', '2', '2', 'wood', 'none', '23', '20', 'bigblunt', '4', '4.00000', '0', '0', '0', '325', '0', '22', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7817', 'Apprentice Adventurer\'s Bone Club', 'rhand', 'false', '1850', '2', '2', 'fine_steel', 'none', '24', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '17', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7818', 'Apprentice Adventurer\'s Knife', 'rhand', 'false', '1120', '2', '2', 'mithril', 'none', '21', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '17', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7819', 'Apprentice Adventurer\'s Cestus', 'lrhand', 'false', '1570', '2', '2', 'steel', 'none', '29', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '17', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7820', 'Apprentice Adventurer\'s Bow', 'lrhand', 'false', '1900', '7', '2', 'wood', 'none', '49', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '3', '17', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7821', 'Apprentice Adventurer\'s Long Sword', 'rhand', 'false', '1560', '2', '2', 'fine_steel', 'none', '24', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '17', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7822', 'Traveler\'s Mace', 'rhand', 'false', '1300', '2', '2', 'steel', 'd', '41', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '43', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7823', 'Traveler\'s Dark Elven Bow', 'lrhand', 'false', '1830', '6', '2', 'steel', 'd', '105', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '4', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7824', 'Traveler\'s Long Bow', 'lrhand', 'false', '1830', '6', '2', 'steel', 'd', '105', '5', 'bow', '12', '-3.00000', '0', '0', '0', '293', '4', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7825', 'Traveler\'s Staff', 'lrhand', 'false', '1040', '2', '2', 'wood', 'd', '50', '20', 'bigblunt', '4', '4.00000', '0', '0', '0', '325', '0', '43', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7826', 'Traveler\'s Bastard Sword', 'rhand', 'false', '1510', '2', '2', 'fine_steel', 'd', '51', '10', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7827', 'Traveler\'s Wand', 'rhand', 'false', '570', '2', '2', 'steel', 'd', '41', '10', 'etc', '8', '0.00000', '0', '0', '0', '379', '0', '43', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7828', 'Traveler\'s Jamadhr', 'lrhand', 'false', '1550', '2', '2', 'steel', 'd', '62', '5', 'dualfist', '4', '4.00000', '0', '0', '0', '325', '0', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7829', 'Traveler\'s Tomahawk', 'rhand', 'false', '1780', '2', '2', 'bronze', 'd', '51', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7830', 'Traveler\'s Poniard Dagger', 'rhand', 'false', '1090', '2', '2', 'steel', 'd', '45', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
    +('7831', 'Traveler\'s Pike', 'lrhand', 'false', '2090', '2', '2', 'steel', 'd', '51', '10', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '32', '0', '0', 'false', 'false', 'true', 'false', '0', '0', '0', '0', '0', '0', '0', '0'),
     ('7834', 'Art of Battle Axe', 'rhand', 'true', '1570', '1', '1', 'chrysolite', 'b', '194', '20', 'blunt', '4', '4.00000', '0', '0', '0', '379', '0', '99', '13100000', '1746', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0');
    \ No newline at end of file
    avatar
    DnR
    Admin
    Admin

    Posts : 1023
    Join date : 2012-12-03

    Re: Few item corrections

    Post  DnR on 10th October 2013, 16:26

    Thanks a lot for your contribution.

      Current date/time is 26th September 2017, 13:50