Populating the Market Place

Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    Hardcore Member Via Nais is online now
    MemberRank
    Jun 2014 Join Date
    134Posts

    Re: Populating the Market Place

    Ok I made it run and it works, thanks !
    Can your script be edited to add like crafting components etc... ? Or does it require another script ?
    + I could be interested in the queries your mention in your first post.
    Thanks !

  2. #17
    Registered fullhawk is offline
    MemberRank
    Jul 2018 Join Date
    19Posts

    Re: Populating the Market Place

    Yes you can add more items to the script. Make sure to delete itemMarket and itemMarketMaster before you run it each time. You can get item IDs from bddatabase and add them to the lists for weapons or armor.

    Here are some queries I used to buff gear a bit. To run these queries, use something like sqlitedatabase browser portable on gameserver\bin\data\sqlite3\bdo.sqlite3.

    -Boss Gears, Steel Taritas, Taritas, Zereth, Agerian, Hercules', Grunil, Fortuna, Rocaba, Heve, Talis and their Ultimate versions

    -AP Bonus to helmets (Enchant x3, so +60 AP at PEN
    UPDATE `2_Blunt` SET
    AddedDDD = (Enchant * 3) + AddedDDD,
    AddedRDD = (Enchant * 3) + AddedRDD,
    AddedMDD = (Enchant * 3) + AddedMDD
    WHERE `Index` IN (11013, 10813, 10821, 10809, 11005, 11001, 11009, 10817, 10933, 10937, 10421, 10853, 10869, 10837, 11030, 11062, 10985, 11046, 10885);

    -Damage reduction bonus to chest pieces, 60 DR at PEN
    UPDATE `2_Blunt` SET
    DPV = (Enchant * 3) + DPV,
    RPV = (Enchant * 3) + RPV,
    MPV = (Enchant * 3) + MPV,
    HDPV = (Enchant * 3) + HDPV,
    HRPV = (Enchant * 3) + HRPV,
    HMPV = (Enchant * 3) + HMPV
    WHERE `Index` IN (11017, 11014, 10814, 10822, 10810, 11006, 11002, 11010, 10818, 10934, 10938, 14122, 10854, 10870, 10838, 11031, 10962, 11063, 10986, 11047, 10886);

    -Accuracy bonus to gloves, 60 accuracy at PEN
    UPDATE `2_Blunt` SET
    DHit = (Enchant * 3) + DHit,
    MHit = (Enchant * 3) + MHit,
    RHit = (Enchant * 3) + RHit
    WHERE `Index` IN (11015, 10815, 10823, 10811, 11007, 11003, 11011, 10819, 10935, 10939, 14123, 10855, 10871, 10839, 11032, 10963, 11064, 10987, 11048, 10887);


    -Evasion bonus to shoes, 60 evasion at PEN
    UPDATE `2_Blunt` SET
    DDV = (Enchant * 3) + DDV,
    RDV = (Enchant * 3) + RDV,
    MDV = (Enchant * 3) + MDV
    WHERE `Index` IN (11016, 10816, 10824, 10812, 11008, 11004, 11012, 10820, 10936, 10940, 14124, 10856, 10872, 10840, 10964, 11065, 10988, 11033, 11049, 10888);
    These bonuses apply in addition to any hidden bonuses that may already be present on this items. These cover boss armors, regular green armors, and their ultimate variants. They do not apply to all possible reform versions of an item though, so if you reform a piece of Grunil to blue, it will lose the bonus.

    I also buffed some individual pieces of armour and jewelry, usually to have more regen, because I like regen.

    Some random examples:
    --2 HP/MP regen on all binder accessories
    UPDATE `3_TwoHandSword` SET VariedRecovHP = 2, VariedRecovMP = 2 WHERE `Index` IN (11608, 11809, 12009, 12209);
    --Sometimes regen doesn't work until you use a potion, but then it starts working as normal

    --Mark of Shadow: - Crit+2,HPRegen+5
    UPDATE `3_TwoHandSword` SET Itemname='Mark of Shadow', VariedCriticalRate=2, VariedRecovHP=5 WHERE `Index`=12007;

    --Shrine Guardian's Token: MPRegen+10,Attack/Cast speed+2
    UPDATE `3_TwoHandSword` SET Itemname='Shrine Guardian Token', VariedRecovMP=10, VariedAttackSpeedRate=2,VariedCastingSpeedRate=2 WHERE `Index`=12008;

    --Ancient Guardian's Seal: Gathering+3,Luck+3,HPRegen+20
    UPDATE `3_TwoHandSword` SET Itemname='Ancient Guardian Seal', VariedRecovHP=20, VariedCollectionSpeedRate=2, VariedFishingSpeedRate=2, VariedDropItemRate=2 WHERE `Index`=11613;
    The reason the queries also save the name of the item is because names in the DB are in korean. So sometimes I'm snooping through the data it's nice to see what the items are. The name in the db doesn't actually do anything, it's just one of the many many instances of the backend being bizarre/poorly implemented but it can be handy.

    Finally, some God items so you can solo world bosses.
    -- Jarette Necklace: Ultimate Damage
    UPDATE `3_TwoHandSword` SET Itemname='Jarette Necklace', AddedDDD=8000, AddedRDD=8000, AddedMDD=8000, DHIT=8000, RHIT=8000, MHIT=8000, VariedCriticalRate=5, VariedAttackSpeedRate=5, VariedCastingSpeedRate=5, VariedCollectionSpeedRate=5, VariedFishingSpeedRate=5, VariedDropItemRate=5, VariedMaxMP=8000, VariedMaxMP=8000, VariedRecovMP=500 WHERE `Index`=11626;

    -- Jarette Ring More Ultimate Damage
    UPDATE `3_TwoHandSword` SET Itemname='Jarette Ring', AddedDDD=32000, AddedRDD=32000, AddedMDD=32000 WHERE `Index`=12035;

    -- Jarette Earring Even More Ultimate Damage
    UPDATE `3_TwoHandSword` SET Itemname='Jarette Earring', AddedDDD=64000, AddedRDD=64000, AddedMDD=64000 WHERE `Index`=11829;

    -- Jarette Belt: Ultimate Tank
    UPDATE `3_TwoHandSword` SET Itemname='Jarette Belt', DPV=2000, RPV=2000, MPV=2000, HDPV=2000, HRPV=2000, HMPV=2000, VariedRecovHP=2000, VariedMaxHP=8000 WHERE `Index`=12231;
    Princess Jarette was an invincible god of death the whole time.

  3. #18
    Hardcore Member Via Nais is online now
    MemberRank
    Jun 2014 Join Date
    134Posts

    Re: Populating the Market Place

    Thank you for such information !
    Outside of gear, is it possible to add items like crafting components you gather in the world ?

  4. #19
    Registered fullhawk is offline
    MemberRank
    Jul 2018 Join Date
    19Posts

    Re: Populating the Market Place

    I already answered that.

  5. #20
    Hardcore Member Via Nais is online now
    MemberRank
    Jun 2014 Join Date
    134Posts

    Re: Populating the Market Place

    Oh ok, will read again.
    Thanks.



Page 2 of 2 FirstFirst 12

Advertisement