Latest Diablo 3 News
Support the site! Become a Diablo: IncGamers PAL - Remove ads and more!

ForumTrader Project Announcement and Introduction

Discussion in 'Diablo 2 Community Forum' started by Kijya, Jun 19, 2008.

  1. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    ForumTrader Project Announcement and Introduction

    Time to reveal what I've been working on lately, and while it's not something even close to ATMA, it should prove useful to many a player out there.



    Project Codename: ForumTrader
    Goal: To be able to quickly create "post ready" trade lists.
    Status: While my signature may show 80%, the program as such is nearly finished to the point that it can be used. Left are some minor functions and the creation of item databases.
    OS tested: Windows XP



    So how does it work?
    The program can be split into tree parts.

    Firstly we have tab1, that lets users select an item from a database and edit its variable stats.

    Once you've finished an "add cycle", the item you've specified the stats of is sent to tab2, an excel-like item list.

    When you've added the items you wish to trade away to tab2, it's time to print something forum friendly. Tab3 lets you do just this.



    More detailed?
    [Tab1]
    When this tab is up you can toggle a global keyboard hook on and of* with the F12 button. This means that even if you should be playing diablo 2 in a window right next to ForumTrader, you can press F12 and have all following keystrokes sent into ForumTrader instead of D2. This allows you to move the mouse from item to item within Diablo and using your keyboard to input item data into ForumTrader.

    F1-F7 = Toggles between the option buttons in the category frame.
    F12 = Toggle the Enabled checkbox in the program frame*.
    A-Z = Entering this will make the program search its database, in the category you've specified, for items starting with the letters you type.
    0-9 = Once you've entered a letter for the program it will list 36 items for your to pick, 0-9 is used to select one of the items.
    F9-F11 = Toggles the special item tags.

    Then once an item has been selected the program fetches all variable mods it can have and lets you specify them one by one by typing:
    number[enter]number[enter]number[enter]

    Once all stats are specified your item will be sent to tab2.

    *: The hook is actually in place during the entire time the program is running, otherwise it couldn't detect you pressing F12 when you're focused on another application. When unactive it will just see if you press F12 and block F12 keystrokes from being sent to other applications, and if you do press F12 so it will activate the program to listen to all the keyboard keys and block them from being sent to other applications, until you press F12 again.


    [Tab2]
    Tab2 will contain a alphabetically desending list of the items you've entered.

    Save Button: Saves your current list into a txt file in the program directory.
    Load Button: Loads a saved list into your excel-like list.

    In the File Name textbox you can obviously edit the filename of the file you'll load/save from/to.

    You can select a cell in the list and press backspace and a-z and 0-9 to edit its content starting from the back of the cell. Pressing delete while having a cell selected will delete that row.


    [Tab3]
    Tab3 lets you print your tab2-list into something readable for forums, two pretty similar options: Alphabetical simply prints a list of your items in that order, the Category optionbutton will sort the items into [Category] sections.

    Example of Alpabetical output, only using basic items (only database that is complete atm):
    Code:
    --------------------------------------------------
    ForumTrader Printout // Alphabetical // 2008-06-19
    --------------------------------------------------
    Balrog Skin  [Eth] (Defense: 510,Sockets: 3)
    Ballista           (Sockets: 4)
    Hydra Bow  [Eth]   (Sockets: 6)
    Long Bow           (Sockets: 3)
    Lance [Eth]        (Sockets: 5)
    Monarch            (Defense: 133,Sockets: 4)
    Naga               (Sockets: 2)
    Ornate Plate [Eth] (Defense: 417,Sockets: 4)
    Pavise             (Defense: 78,Sockets: 2)
    Wand               (Sockets: 1)
    Yari  [Unid]       (Sockets: 2)
    Example of Categorized output:
    Code:
    ------------------------------------------------
    ForumTrader Printout // Categorized // 2008-06-19
    ------------------------------------------------
    [BaseDB]
    Balrog Skin [Eth]  (Defense: 510,Sockets: 3)
    Ballista           (Sockets: 4)
    Hydra Bow [Eth]    (Sockets: 6)
    Long Bow           (Sockets: 3)
    Lance [Eth]        (Sockets: 5)
    Monarch            (Defense: 133,Sockets: 4)
    Naga               (Sockets: 2)
    Ornate Plate [Eth] (Defense: 417,Sockets: 4)
    Pavise             (Defense: 78,Sockets: 2)
    Wand               (Sockets: 1)
    Yari [Unid]        (Sockets: 2)
    
    
    [MagicDB]
    
    
    [RareDB]
    
    
    [SetDB]
    
    
    [UniqueDB]
    (bit booring with only items from BaseDB added ...)



    What's the catch?
    The program needs some database work, the databases should be in the following format:
    ItemName,mod1name,mod1intervall,mod2name,mod2intervall

    such as:
    Monarch ,Defense,133-148,Sockets,0-4

    Into txt files that look like:
    Aegis ,Defense,145-161,Sockets,0-4
    Aerin Shield ,Defense,26-36,Sockets,0-4
    Akaran Rondache ,Defense,113-137,Sockets,0-4
    Akaran Targe ,Defense,101-125,Sockets,0-4
    Alpha Helm ,Defense,52-62,Sockets,0-3
    Ancient Armor ,Defense,218-233,Sockets,0-4
    Ancient Axe ,Sockets,0-6
    Ancient Shield ,Defense,80-93,Sockets,0-3
    Ancient Sword ,Sockets,0-3
    Antlers ,Defense,18-24,Sockets,0-3
    Arbalest ,Sockets,0-3
    Archon Plate ,Defense,410-524,Sockets,0-4
    Archon Staff ,Sockets,0-6
    Armet ,Defense,105-149,Sockets,0-2

    And so on

    The program supports a maximum of 17 different variable mods per item entered this way.


    The base item database is complete as it is, but a unique database and a set database would be needed, additional to that I figured a misc database of gems and runes etc would be good.

    Rare/magic/crafted items could be entered in the same maner to a sertain extent, but most likely picture info would be better. If you studied Tab1 in detail you'll have noticed the screeny option thingy. I've yet to implement it but was thinking of letting the program copy the clipboard and saving only a area close to the mouse in a .jpg to lessen the need for users to edit game screenshots for item stat pictures ... well more on that once I get to it ... if I'm able to ...

    If anyone wishes to help me make these databases please to tell :wink:


    Some more screenys (must unable keyhook during prt scr, since it blocks that key to, but think of that checkbox as marked ^^):
    Start of add, pressed: F12 m o
    Selected item, pressed: 0 0
    entering stats, pressed: 148 enter 4
    Finishing add phase: enter

    That's all for adding a monarch with fully defined defense and sockets, 11 keystrokes total.

    This is how it looks in tab2:
    Tab2 view

    If I print just that item (press tab3 and print button) I get this list:
    List printed






    Hope you've enjoyed the read, I've left out some details of course, but hope to get a demo video of it in action before any Beta release is made.

    This application does not have any contact with or alter the d2 game code in any way, the only non "program local" function is the global keyhook, and that's a windows thing, it'll hook the keyboard from whatever application you have in focus, be it firefox or explorer.


    Discussion, comments and criticism welcome.
     
  2. TurbulentTurtle

    TurbulentTurtle Diabloii.Net Member

    Joined:
    Jun 21, 2003
    Messages:
    10,415
    Likes Received:
    4
    Trophy Points:
    256
    Re: ForumTrader Project Announcement and Introduction

    Now I know why you were so busy with this one, David. Looks pretty sexy.
    Useful as hell too. Nice job!
     
  3. Crowd Control

    Crowd Control Banned

    Joined:
    Mar 7, 2007
    Messages:
    7,217
    Likes Received:
    2
    Trophy Points:
    0
    Re: ForumTrader Project Announcement and Introduction

    Look VERY promising. But I can't help but say that it's all a bit confusing atm. But I'm sure it'll work out once it's up and running.
     
  4. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    Understandable, without a video it's kind of hard to demonstrate how it works properly.

    Not sure I can make a good one atm though, only working on my laptop atm as I'm away from home, but once I get back home I hope to be able to make a clear and illustrative demo video.



     
  5. BrickHaus

    BrickHaus Diabloii.Net Member

    Joined:
    Aug 24, 2007
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    26
    Re: ForumTrader Project Announcement and Introduction

    I dont find that confusing at all. Very impressive mate, what a time saver that will be, I can't wait to see the final product. Volunteer beta tester here:)
     
  6. Kaotic Dragon

    Kaotic Dragon Diabloii.Net Member

    Joined:
    Feb 4, 2008
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    41
    Re: ForumTrader Project Announcement and Introduction

    Looks very nice indeed, even with my limited experiance in single player with games like atma and such. Just a warning do not post on you tube they butcher video clarity which might make it hard to see.
     
  7. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    @Kaotic Dragon: Oke I'll try to stay clear of youtube, though cannot say for sure I will.


    Unique and set databases complete now.
     
  8. TurbulentTurtle

    TurbulentTurtle Diabloii.Net Member

    Joined:
    Jun 21, 2003
    Messages:
    10,415
    Likes Received:
    4
    Trophy Points:
    256
    Re: ForumTrader Project Announcement and Introduction

    Google Video isn't bad, nor is DailyMotion. I tend to see those a lot when watching Let's Plays and stuff.
     
  9. krischan

    krischan Europe Trade Moderator

    Joined:
    Aug 17, 2003
    Messages:
    30,152
    Likes Received:
    1,140
    Trophy Points:
    416
    Re: ForumTrader Project Announcement and Introduction

    That's amazing ! Exactly what I'm waiting for ! I haven't kept a mule database in the last season because it's so awkward. Keeping aone will be a lot easier with that program.

    Can you also assign an account and mule name to each item ?

    You don't have to hack the game for the F12 thing, correct ?



     
  10. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    Not as it is now unless you do it fully manually for each item, but it it'll not be hard to implement. (Just another box to type a string and then store it in another column of the "excel-like" list)

    However having that tag in there might be pointless without a search function so you can list only the items on one mule or something. That might take a bit more time.


    Correct, PMing a bit better explanation.



     
    Last edited: Jun 22, 2008
  11. Furyan

    Furyan Diabloii.Net Member

    Joined:
    Apr 18, 2007
    Messages:
    1,449
    Likes Received:
    0
    Trophy Points:
    166
    Re: ForumTrader Project Announcement and Introduction

    Waw, looking awesomem8, great work! :thumbup: This can surely easen the job of making a tradelist. Can't wait to try it! :jig:
     
  12. krischan

    krischan Europe Trade Moderator

    Joined:
    Aug 17, 2003
    Messages:
    30,152
    Likes Received:
    1,140
    Trophy Points:
    416
    Re: ForumTrader Project Announcement and Introduction

    An important aspect of an item database is knowing where the item is, not just knowing if you have one at all and what its stats are ;) However, that problem can be lessened by having separate mules for the various item types.
     
  13. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    Since tab2 is a bit empty I think I can do something with that ...

    I'll probably get to it tomorrow. For today I'm glad I've fixed so you can pretty much add any item (except crafted ... see them as rare and ignore the problem for now ...) :whistling:

    I added all items from a mule of mine to test it, noticed I can't write damage spans atm, aka I can't write 1-16 lightning damage for example, easy fix ... but tomorrow.
    Uniques, set items, basic items and misc items are fast to add, magic and rare items have to be added by specifying a basic item and then adding mod for mod so it's far slower. Runewords can be added by themselves, but you can also specify base item first, so they can be fast to moderate to add.
    Code:
    ------------------------------------------------
    ForumTrader Printout // Categorized // 2008-06-22
    ------------------------------------------------
    [BaseDB]
    
    
    [MagicDB]
    Ancient Armor       (Defense:229,Sockets:4,IAS:60,Minimum Damage :6,Life:100,Max Stamina:29)
    Blade Talons        (Sockets:2,IAS:40,Max Damage/Level:0,Attack Rating/Level:16,Open Wounds:25)
    Ceremonial Javelin  (Javelin and Spear Skills:2,Maximum Damage :47)
    Grand Charm         (Combat Skills Paladin:1)
    Grand Charm         (Offensive Auras:1,Lightning Damage:16)
    Grand Charm         (Martial Arts:1,Poison Damage:6)
    Grand Charm         (Combat Skills Barbarian:1,Maximum Damage :2)
    Grand Charm         (All Resistances:15)
    Large Charm         (All Resistances:7)
    Small Charm         (Better Chance of Getting Magic Item:7)
    Small Charm         (Better Chance of Getting Magic Item:7)
    Small Charm         (Life:14)
    Small Charm         (Life:11,Mana :11)
    Small Charm         (Life:14)
    Small Charm         (Faster Run/Walk:3,Defense:1)
    Small Charm         (Poison Damage:100,Strength:2)
    Small Charm         (Extra Gold:10)
    Small Charm         (Life:14)
    Small Charm         (Life:14)
    Small Charm         (Life:18)
    
    
    [RareDB]
    Heavy Boots          (Defense:5,Cold Resist:30,Lightning Resist:24,Poison Resist:10,Poison Length Reduction:25)
    Scissors Katar [Eth] (Sockets:0,Traps:2,IAS:20,Enhanced Damage:136,Minimum Damage :4,Attack Rating:74,Requirements (-x%):20)
    
    
    [SetDB]
    Tal Rasha's Lidless Eye  (ToColdMastery(SorceressOnly):1,ToLightningMastery(SorceressOnly):1,ToFireMastery(SorceressOnly):2)
    
    
    [UniqueDB]
    Gull                   ()
    Skin of the Vipermagi  (MagicDamageReducedBy:9,AllResistances:31)
    Schaefer's Hammer      (EnhancedDamage:129)
    Thundergod's Vigor     (Defense:155,EnhancedDefense:194)
    Wizardspike            ()
    
    
    [RWDB]
    Call To Arms Flail       (Sockets:5,EnhancedDamage:275,ToBattleCommand:2,ToBattleOrders:1,ToBattleCry:4)
    Insight Scythe           (Sockets:4,LevelMeditationAuraWhenEquipped:17,EnhancedDamage:256,BonustoAttackRating:207,ToCriticalStrike:2)
    Treachery Wyrmhide [Eth] (Defense:859,Sockets:3)
    
    
    [MiscDB]
    Key of Hate  (Quantaty:4)
    
     
  14. RubenusPontius

    RubenusPontius Diabloii.Net Member

    Joined:
    Apr 7, 2006
    Messages:
    434
    Likes Received:
    2
    Trophy Points:
    98
    Re: ForumTrader Project Announcement and Introduction

    Just pointing to a typo: After Key of Hate it says Quantaty instead of Quantity. Nice work though...
     
  15. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    @RubenusPontius: Thanks for pointing it out :thumbsup:

    The beta release will be pushed forward a bit while I work on a more sophisticated system to handle the users item lists (equal to rewriting some other program parts as well :whistling:).

    I'll also have to get permission to post it from Elly first to before I can "release" anything ...

    Don't expect beta to be done within week ... maybe two with a bit luck.
     
  16. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    Back home and can now once again begin working on this. I'll try to add:


    • Account/mule based item storage index somethings.
    • Search function to find items whatever account they're on.
    Anything else?




    As it is now I'm actually not making this application 100% game specific, somethings can be edited in a ini file. As long as the items have a "Name" and 17 or less listed "mods", the program should work with most any game that can be played in windowed mode (with specific txt databases for each game and some small edits in the ini file).

    The above meaning, in the D3 craze glory, if d3 will be possible to run in windowed mode, then I might be able to make the program work for it to. Unless the item name+stats structure is changed dramatically it should fit in nicely, just need other txt databases.

    Well might be futile to speak of this for a while ... now go run amok about D3 again, just don't mind if I tag along :jig:
     
  17. krischan

    krischan Europe Trade Moderator

    Joined:
    Aug 17, 2003
    Messages:
    30,152
    Likes Received:
    1,140
    Trophy Points:
    416
    Re: ForumTrader Project Announcement and Introduction

    Good to see that you are still on it, I was just about to ask about the forthcoming :azn:

    You can be sure that more suggestions will arrive as soon as people are going to use it and you will probably receive a lot of ideas which are better not to be implemented :whistling:. Also, a couple of people will send angry PMs when something is not going to work as intended or as they expect, they think they have the right to demand it from you.
     
  18. korialstraz

    korialstraz Diabloii.Net Site Pal

    Joined:
    Jun 11, 2007
    Messages:
    5,901
    Likes Received:
    11
    Trophy Points:
    166
    Re: ForumTrader Project Announcement and Introduction

    Wow this sounds awesome indeed! If only I still played D2 as much as I did before the reset I could help you out with testing it (when it's ready to be tested). Best of luck with the program! :thumbsup:
     
  19. Feonn

    Feonn Diabloii.Net Member

    Joined:
    Jan 25, 2007
    Messages:
    514
    Likes Received:
    0
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    Goodnes...I LOVE this!
    Seriously, this is AWESOME! Never those crappy excel-sheets again which I forget to update:thumbup:

    I'd like to mention another typo: It says sertain somewhere instead of certain. (Sorry for bugging:jig:)

    I love it so far! :D
    What lists do you still have to do? I might help a little with inputting all the DB's?!

    PM me if you'd want some help :D
     
  20. Kijya

    Kijya Diabloii.Net Member

    Joined:
    Feb 28, 2005
    Messages:
    4,370
    Likes Received:
    4
    Trophy Points:
    255
    Re: ForumTrader Project Announcement and Introduction

    All databases have been completed (programmed a application to make them from copy-paste text from arreat summit), at least largely.

    Since there are to many combinations of magic and rare items I can of course not write them all down, for those items I've settled for a "mod only" database type, so you can add single mods to your "current item".


    Below is how the mod database looks. If there's a type of mod missing I'd love to know, but I think it'll be better to add missing ones when we notice them while using the program. Multiple spellings of the same mod can help to find it should you type it in a different way.

    ---------------------------------------------------------------

    Absorb Cold,,
    Absorb Cold %,,
    Absorb Cold/Level,,
    Absorb Fire,,
    Absorb Fire %,,
    Absorb Fire/Level,,
    Absorb Lightning,,
    Absorb Lightning %,,
    All Resistances,,
    All Skills,,
    Attack Rating,,
    Attack Rating %,,
    Attack Rating/Level,,
    Attacker Takes Damage of,,
    Better Chance of Getting Magic Item,,
    Bow and Crossbow Skills,,
    Cannot Be Frozen,,
    Cold Damage,,
    Cold Resist,,
    Cold Spells,,
    Combat Masteries,,
    Combat Skills Barbarian,,
    Combat Skills Paladin,,
    Crushing Blow,,
    Curses,,
    Damage ,,
    Damage Reduced By,,
    Damage Reduction,,
    Damage taken Goes to Mana,,
    Damage To Mana,,
    Damage vs Demons,,
    Damage vs Undead,,
    Deadly Strike,,
    Deadly Strike/Level,,
    Defense,,
    Defense (Based On Character Level),,
    Defense %,,
    Defense Vs Missiles,,
    Defense/Level,,
    Defensive Auras,,
    Dex/Level,,
    Dexterity ,,
    Elemental Skills,,
    Energy,,
    Enhanced Damage,,
    Enhanced Maximum Damage/Level,,
    Extra Gold,,
    Extra Gold/Level,,
    Faster Block Rate,,
    Faster Cast Rate,,
    Faster Hit Recovery,,
    Faster Run/Walk,,
    Fire Damage,,
    Fire Resist,,
    Fire Skill,,
    Fire Spells,,
    Half Freeze Duration,,
    Heal Stamina,,
    Hit Blinds Target,,
    Hit Causes Monsters to Flee ,,
    Hit Freezes Target,,
    IAS,,
    Ignore Target Defense,,
    Increased Attack Speed,,
    Increased Blocking,,
    Indestructible,,
    Javelin and Spear Skills,,
    Knockback,,
    Life,,
    Life Stolen Per Hit %,,
    Life/Level,,
    Light Radius,,
    Lightning Damage,,
    Lightning Resist,,
    Lightning Spells,,
    Magic Damage Reduced By,,
    Magic Find,,
    Magic Find/Level,,
    Mana ,,
    Mana After Each Kill,,
    Mana Steal,,
    Mana Stolen Per Hit %,,
    Mana/Level,,
    Martial Arts,,
    Max Damage/Level,,
    Max Stamina,,
    Maximum All Resistances,,
    Maximum Cold Resist,,
    Maximum Damage ,,
    Maximum Damage/Level,,
    Maximum Fire Resist,,
    Maximum Lightning Resist,,
    Maximum Mana,,
    Maximum Poison Resist,,
    Minimum Damage ,,
    Offensive Auras,,
    Open Wounds,,
    Passive Skills,,
    Pierce Resistance: Cold,,
    Pierce Resistance: Fire,,
    Pierce Resistance: Lightning,,
    Pierce Resistance: Poison,,
    Poison and Bone Spells,,
    Poison Damage,,
    Poison Length Reduction,,
    Poison Resist,,
    Prevent Monster Heal,,
    Quantity +,,
    Regenerate Mana,,
    Repair Durability,,
    Replenish Life,,
    Replenish Quantity,,
    Requirements (-x%),,
    Resist all,,
    Resist Cold,,
    Resist Fire,,
    Resist Lightning,,
    Resist Lightning/Level,,
    Resist Poison,,
    Shadow Disciplines,,
    Shapeshifting ,,
    Skill Damage: Cold,,
    Skill Damage: Fire,,
    Skill Damage: Lightning,,
    Skill Damage: Poison,,
    Skills Amazon,,
    Skills Assassin,,
    Skills Barbarian,,
    Skills Druid,,
    Skills Necromancer,,
    Skills Paladin,,
    Skills Sorceress,,
    Slows Target,,
    Sockets,,
    Str/Level,,
    Strength,,
    Summoning Druid,,
    Summoning Necromancer,,
    Target Defense -%,,
    Traps,,
    Vit/Level,,
    Warcries,,

    ---------------------------------------------------------------

    Chance to cast things are obviously missing :scratchchin:
     

Share This Page