Search the Community
Showing results for tags 'item_db'.
Found 6 results
-
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
-
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.
-
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..
-
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
-
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
-
Version 1.0
533 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