Jump to content

Search the Community

Showing results for tags 'item_db'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Bulletin Centre
    • Community News
    • Repository News
    • Ragnarok News
  • Hercules Development Centre
    • Development Discussion
    • Suggestions
    • Development Centre Archives
  • Support & Releases
    • General Server Support
    • Database
    • Scripting
    • Source
    • Plugin
    • Client-Side
    • Graphic Enhancements
    • Other Support & Releases
  • Hercules Community
    • General Discussion
    • Projects
    • Employment
    • Server Advertisement
    • Arts & Writings
    • Off Topic
  • 3CeAM Centre
    • News and Development
    • Community
  • International Communities
    • Filipino Community
    • Portuguese Community
    • Spanish Community
    • Other Communities

Categories

  • Client Resources
  • Graphic Resources
    • Sprites & Palettes
    • Maps & Textures
    • Other Graphics
  • Server Resources
    • Server Managers / Editors Releases
    • Script Releases
    • Source Modifications
    • Plugins
    • Pre-Compiled Server
  • Web Resources

Calendars

  • Community Calendar

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Discord


Skype


IRC Nickname


Website URL


Location:


Interests


Github

Found 6 results

  1. Hey guys, I've read any topic about this out there, but I am still not able to make it work. This is what I've done: /src/map/itemdb.h: -#define MAX_ITEMDB 0x8000 // 32k array entries in array (the rest goes to the db) +#define MAX_ITEMDB 0x10000 // 64k array entries in array (the rest goes to the db) /src/common/mmo.h: - short nameid; + unsigned short nameid; /sql-files/main.sql: card0~ card3 from smallint to mediumint (at multiple places) BUT still: when i logout with an itemID over 32k, it gets deleted with following error: [SQL]: DB error - data of field 'nameid' was truncated [Debug]: column - 1 [Debug]: data - type=UNSIGNED MYSQL_TYPE_LONG, le [Debug]: buffer - type=MYSQL_TYPE_SHORT, length=2
  2. Hello i like to ask how exactly item weight works, i have seen item_db and found some weird numbers eg. hunting spear weight is 420 and in item_db it's 4200, same for other items. But in game it works fine like, 4200 weight in database and in game 420.
  3. Hello, I see many users having some problem with new item_Db format, stating that it cannot be used with the Old Tools available, and there's no tool to parse the new item_db.conf So I made this script, which converts item_db.conf to item_db.txt , (and you can change the syntax of item_db.txt too) Script: https://github.com/dastgirpojee/LuaScripts/tree/master/Lua/conf2db ReadMe.MD shows how to use it.. Usage: 1)Copy item_db.conf to "conf2db" Folder.2)Just run the "conf2db.bat" and Enter some details of file.Format(If Asked):Usage: conf2db.lua {FileName} {Output} {Format(RE,or see below)}.Format: #id #script #View, [Case-insensitive]Default: #ID,#AegisName,#Name,#Type,#Buy,#Sell,#Weight,#Atk:#Matk,#Def,#Range,#Slots,#Job,#Upper,#Gender,#Loc,#wLV,#eLV,#Refine,#View,{ #Script },{ #OnEquipScript },{ #OnUnequipScript } [Case-insensitive]Additional Parameter: #eqmax #eqmin(max and minimum equip level) [Case-insensitive] P.S: I made the script just for the users who wanted to use old Tools.. and hercules cannot read .txt item_db..
  4. Greetings, Regarding Hercules' almost demanding way of using text-based database files. Having developed mainly item and mobs in SQL on rAthena, is there's no swift way to import SQL queries to convert them to text? Because of that I have been working on the database conversion, which I have said in the past and you can find the information in this topic. Getting stuck on two aspects so far in (successfully) converting the databases if I have to stick with SQL due to the above not being (currently) possible: equip_locations at rA is set to mediumint(7) and at Herc to smallint(4), which prevents conversion due to certain values being out of range, at least as far as I've researched. ✓ Solved this one, had to use CHANGE instead of MODIFY and re-state the column name. The type of item where rA and Herc have opposite values for Weapon and Armor/Garment/Boots/Headgear/Accessory, updating the query to switch them yields either all weapons or all armor/etc. Is anyone able and willing to push me in the right direction? Naturally I'll publish the modifications I've done to jaBote's rA > Herc convertor when I get things are working the way it is intended to. Finally, I still haven't solved/received the answer I wanted from the topic I quoted above. It doesn't affect me or the server I'm working on, but it is for the sake of completion for the convertor for those who are affected by that specific table. Kind regards, Tranquility
  5. File Name: Item DB Converter File Submitter: Jhedzkie File Submitted: 22 Nov 2013 File Category: Client Resources A tool that converts the old Athena item_db format to the new Hercules format. [instructions] 1. Select item_db.txt or item_db2.txt file to convert. 2. Press 'Process' button. 3. You may Copy-Paste the output to your existing item_db/2.conf or you may choose to save the output as a file. [Requirements] * .net Framework 4.0 Click here to download this file
  6. Version 1.0

    531 downloads

    A tool that converts the old Athena item_db format to the new Hercules format. [instructions] 1. Select item_db.txt or item_db2.txt file to convert. 2. Press 'Process' button. 3. You may Copy-Paste the output to your existing item_db/2.conf or you may choose to save the output as a file. [Requirements] * .net Framework 4.0
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.