Important Notes
---------------
Version 4.9 of the Database contains some modifications to how the equipment Database stores information.
Please follow the instructions in the Version 4.9.0 Upgrade.txt file.

Know Bugs
---------
Enchanted items importing still a few bugs with druid/neph enchants and items with no hr/dr to start with.
Make sure you double check any enchanted items to ensure it gets recorded correctly.
Options Screen not yet fully configured.
Dropdown menu's only refresh on start of program, if new items added to list then please restart database.
Items with conditional stats (i.e. Affects DR by 3 if align is Neutral) Don't import perfectly, best to manually edit the item ID's before import.


What's new in this version (4.9.5):
-----------------------------------
- Cleanup of how item affects are stored in the "Other" section of the database, standardised the text for most of them.
- As most of us are using non-PK characters the default sorting has been changed to not include PK only items.
- Addition of calculations for Health and Mana Regen, Carry Capacity, Spell Affects (Cost, Damage, Wait time).
- Addition of a "Add Buff Spells" selector switch to toggle +2 to all stats.
- Addition of Base Movements to characters, as the new Prestige characters have weird movement numbers not easily calculatable.
- Addition of all current Prestige Classes. Go through the dropdown of the Classes list to find them.
- Addition of the races Dragonborn and Tiefling.
- Adjusted the Max stats for all Prestige Classes to match what I "Think" they should be.
- Changed the format of the Stats in the Character screens to show stats as Current/Max where Max is the max of that class.
If the Current is > Max then the stat is coloured Green.
* Note: Because of the changes to Movements being saved per character now, there may be some issues with some characters displaying ? for equipment
or not showing wanted equipment correctly.
If you have any issues, just delete all offending items and input them again. If you still have issued, delete the character and input it again.

What's new in this version (4.9.3):
-----------------------------------
- Updated development environment to 10.3 Community Edition
* Resolved countless errors because of this update.
- Moved Organisation FTP details into rod_db.ini file.
- Significantly improved security and handling of passwords.
* Passwords are no longer stored locally at all and must be entered each time it is needed. Only password hashes are stored on the server.
- Added ability to tag a character as "Prestige".
* Unable at this stage to recalculate the movement base for prestige characters as formula seems inconsistent. May add way to manually change this later.
- Changed Administrator access, can only add/remove users, flag them as admins or flag their accounts for a password reset.

Older additions (4.9.2):
-----------------------------------
- Fixed bug with choosing equipment if toggled between wanted and equipment without selecting an item.
- Added pouch of magical soil to the recognised playername item list

Older additions (4.9.1):
------------------------
- Fixed issue with Index list error out of bounds when attempted to select another character on the characters page.

Older additions (4.9.0):
------------------------
- Fixed display of grids so that text doesn't overlap the bottom of the cell.
- Added item type colouring to the Current/Wanted equipment lists
- Changed Equipment List buttons to be a bit more descriptive
- Added Tool-tips to buttons for additional descriptions.
- Updated Help button to be more descriptive.
- Added better graphical representation of which Character view you are in.
- Added popup to confirm if you wish to export character wanted list.
- Modified spacing of bottom/Top status bars to ensure text doesn't get cut off.
- Added ability to filter by minimum AC
- Moved some items on Filter popup to better group them and added colours for the OOG/Gloried/Pkill Filters
- Adjusted the widths of some columns to better fit some items.
- Added Quick Import button, which imports from the clipboard in the same way the log import imports from a log file.
- Fixed some of the status bar updates to be more consistent and informative.
- Colouring of items fixed when importing logs/updating.
- General updates to importing bugs and graphical glitches.
- Added Importation speed indication to status bar.
- Added "Ranges" for Levels on all items and Damages on weapons. Items now show with a (MinLevel)-(MaxLevel) to show the range of possible values seen.
- Added "Options" button and popup which allows editing of the configurations without a need to edit externally.
- Added format and version checking to the Character/Wanted/Gloried files. Program will now correctly check which version you are running so it won't import old databases.
- Added "Date" and "User" columns to the database.
* Date is the date that the item was added or last edited in YYYY-MM-DD format.
* User is the username of the user who added/edited the item, with a "Add/Edit" comment to show if it was a new item or an edit.
- Areas popup now correctly shows the area of the item in the dropdown when opened.
- Fixed error when an item could have negative level and cause database issues.
- Added the (**NEW**) designator when importing log files as well as importing from the web.
- Showing Gloried/Pkill/OOG items is now the default and they will be ticked when filtering.
- CTRL-F now correctly will select the "Name" checked box and focus the entry on the Name field for quicker searches by name.
- Added new warning popup when importing Item database from the web.
- Added new filter options to only show Pkill/Gloried/OOG items.
- Added ability for the Database to recognise Set Bonused items and record the Set Bonuses as new "items" with type setbonus.
- Added detection for Carrying Capacity, Cost of XXX, Damage of XXX
- Modified layout of Equipment views to show more Resists/Affects as there are quite a few more affects these days.
- Added RoD default colours to some items in the Equipment view to make they stand out more.
- Added ability for the Database to recognise items with conditional affects.

Older additions (4.8.9):
---------------------------------------
- Fixed enchanted weapons importing
- Fixed area editing.

Older additions (4.8.8):
---------------------------------------
- Fixed Stuff.
- Changed domain to ascendere.org

Older additions (4.8.7):
---------------------------------------
- Fixed bug with Wanted item Lances.
- Added ability to hide coloums (middle click)
- Added button to copy current setup to wanted setup.

Older additions (4.8.6):
---------------------------------------
- Fixed bug with the importing of items with bonuses.
- Added "Original" item stats before "updated" items so you can see what was changed with the update
- Added functionality to the blue "Equipment to get" button that generates a text list of all the wanted items you need.

Older additions (4.8.5):
---------------------------------------
- Fixed bug with filtering after an update causing errors.
- Fixed bug with weapon filter.
- Rewrote how the characters page handles resists/susceptible, much neater now.
- Added hourglass when searching.
- Added "Wanted" list to characters
* Wanted list is in yellow, every character has a wanted list.
* Wanted stats calculated and shown next to current list.
* Items you need to collect are marked in BLUE on the wanted list.
* Switching from list to list is done with the coloured buttons in the bottom left corner of the equipment page.

Older additions (4.8.2):
---------------------------------------
- Fixed bug with web updating deleting your gloried items.

Older additions (4.8.1):
---------------------------------------
- New areas added
* Fallen Graces (Pkill)
* Isle of the Monkeys
* Vast Horizons
- The Item type and Wear location filter dropdowns will now fill on first use with all possible data in the database.
* Note: This means there is a short delay (few seconds) whilst it fills itself. This only happens once per database execution.
- Faster Importing of Web Database
- The old Updated/New items list is back.
- Minimise to system tray by default.
* Once minimised to the tray the database will attempt to automatically update once every 24 hours, so you can set and forget.

Older additions (4.8.0):
---------------------------------------
- Updated the security of the Database, a few security holes fixed.
- Removed the ability for Database Admin's to Purge local copies.
* The local Database is purged on EVERY download.
* This allows much easier fixing of the database.
- Admins now have the ability to upload their database at any time, overwriting the online copy (to fix Meldrew issues...)
- When downloading there is now a backup copy made of your original before purging.
- Range check errors should have been resolved.

Older additions (4.7.0):
---------------------------------------
- Added in all new areas to date.
- Added in ability for Database Admin's to Purge local copies.
- Added colouring to the main equipment view.
* Blue for OOg
* Red for PKill
* Green for Gloried
- The column you sort with is now marked as blue.

Older additions (4.6.7):
---------------------------------------
- Added in all new areas to date, including all guild and arena areas.
- Fixed bug with importing of containers.

Older additions (4.6.6):
---------------------------------------
- Fixed bug with Items importing as Anti-Mage, when they weren't.
- ANSI Coloured Logs should be able to be imported

Older additions (4.6.5):
---------------------------------------
- Updated a few Named items to import as *****
- Uploads/downloads are now zipped before transfer to lower traffic
* The files stored online are encrypted Zips, to help secure the Database
- Online files are now stored per version number.
* When a new version is released (Major revision) you must be using that new
* version to be able to get the latest data.
- Security checks now correctly work for dd/mm/yy and mm/dd/yy formats.
* If you have some other stupid shortdate format, stuff you. 🙂

Older additions (4.6.2):
---------------------------------------
- Fixed about 4 bugs I added from 4.6.1 😛
- Renamed Anti-Neutz (anti Neutral Sex) to Anti-Its
* means you will need to get a fresh database from the web.

Older additions (4.6.1):
---------------------------------------
- Ooops.... 4.6 allowed you to login with just a username.. and a blank password *grins*
* Fixed 😉
- Fixed bug with not being able to edit flags
- Fixed bug where the security check would throw up errors even if you were online.
- Removed all the "The"'s from area names, to make it easier.

Older additions (4.6):
---------------------------------------
- Online Security checks periodically while running Dbase
- Security checks are now only required once per day, to help speed up loading Dbase
- Fixed a few bugs with importing I introduced in 4.5.5
- Ctrl-Shift-R to RESTORE a force deleted item.
* Note: Use this with extreme care, as this is going to be a pain in the ass to fix if
* people do it on the wrong item etc.
- Changes to admin control panel.
- Help button added with useful information.
- Uploads are disabled every 2 hours till you download again, to ensure we don't have people people overwriting others data.

Older additions (4.5.5) (Internal Testing only):
---------------------------------------
- Propper account setup on the asc.com domain.
- A few bug fixes with importing items with differing anti's
* if ANY anti's (apart from good/evil/neut) are different it will record the item as a differnt object with the (other) name
- A few optimisations of the security routines
* If you don't authorise online you can only view the database, not upload/download changes.
* You must authorise atleast once every 4 weeks, or all access to the database will be disabled.

Older additions (4.5.2) (Internal Testing only):
---------------------------------------
- Admin Control Panel
* If you are an admin, there is now a control panel available to you to do admin stuff in.
* Make sure you click "Save User" to save any changes.
* Changes are only saved back to the web when you click on "Confirm".

Older additions (4.5.1) (Internal Testing only):
---------------------------------------
- Minor bug fixes
* Updating does not "unremove" items if you have marked them to be ignored
* Area info will not be blanked if you already have information for that item.

Older additions (4.5) (Internal Testing only):
---------------------------------------
- WEB SUPPORT !!!!!!!!!!!!!!
* Big news with this one hence the version numbering change.
* Need web access via ftp for this to work.
* Import From Web, downloads latest file and imports it into your own.
* This then allows you to upload your data file with the combined data back to the web.
* NOTE : Be very careful with this, we don't want the database cluttered with renames/crap.
* MAKE SURE YOU DELETE CRAP OUT OF THE DBASE BEFORE UPLOADING!
- Security
* RoD_db now comes with security inbuilt.
* You will need to get a username/password setup by me/dargo before you can use it.
* If you are running the Dbase without web access you don't need a user/pass, but you also won't be able to get updates.
* You need to setup the RoD_db.ini file with your username/password exactly as you are given them.
- Tab ordering on most pages fixed up so it's logical.
- DDE Support put back in.
- Items will now show "Allows" if there are a lot of anti's and it would be less spam to show allows...
* e.g. armor:Cloak of Bloodlust (neck) | Allows: Evil Vamp | Races: (All) | Flags: glow dark evil | <<<
- CTRL-SHIFT-D
* This will Ignore that item from now on.
* Use this on renames/items that are simply wrong. The item is still saved in the database, it's just not visible normally
* Unless you select the filter option "Show Deleted" then the items will be shown.
* You can manually removed the "<Deleted By *****>" tag in other, to un-ignore the item.
*NOTE: This feature is implimented to help maintain the integrity of the database with web uploads/downloads.
* Make sure renamed items or items that import incorrectly (e.g. neph enchanted/druid enchanted (other) weapons) are Ignored.

Older additions (4.2) (Internal Testing only):
---------------------------------------
- Support for the "noenchant" flag - Items will not show up as enchantable.
- Ctrl-F now works for an easy name search.
- Ctrl-Z now does the same as middle mouse button (reset to default).
- Made the checking for enchanted weapons code much more robust.
- Changed the way the system checks for items, searching by stats rather than by name.
* This means importing of items with the same name but different stats, should work well.
* All you have to do is name them with XXXXX (YYY) format. The code checks for brackets.

Older additions (4.1):
---------------------------------------
- Added Log file support, default importing can done with *.txt or *.log files.
- Added support for Timestamping.
* Timestamp must be in the format [HH:MM:SS] Object info etc...

Older additions (4.0):
---------------------------------------
- Added layerable support to the properties tag.
- Updated the layout/look of the character stats section of the character screen.
- New coloumn added "type" Object type is correctly read from the log file.
* This means you can filter out all the "crap" easily just by selecting type "armor"
* Every item type is added as it is found.
- Statusbar with useful information! No more decoding flags in your head, it does it for you.. just click any item.
- Anti's have their own popup window similair to properties allowing you to easily change them.
- Races's have their own popup window similair to properties allowing you to easily change them.
- Characters have races/sex's which are saved with their information. When doing searches it filters based on these aswell.
- New items added to Filter page.
* Race
* Sex
* Hitroll
* Value
* Gloried
* Area Name
* Mob Name
- Can SEARCH by area/mob to show specific loot.
- Ctrl-Shift-Del can be used to mass delete database enteries.
* Depending on Database Size it might look like it's not doing anything.
* Is is Faster to delete from the End of the database.
- Added ability to sort the current list by any column, just click on the header.
* Left click will list things Descending - Right Click Ascending.
* Different columns are sorted differently, e.g. flags/antis/races are sorted by the number of anti's not alphabetically.
* Middle click resets back to the default sorting.
* It can take a few seconds for the sorting to complete, depending on PC speed and database size.
- When importing log files you have the option to Compact them.
* This removes all lines from the file that the parser did not recognise as item Id's.
* The compacted log file is saved with the original file name plus -Compacted
- A new flag has been added "Gloried" When importing items that are gloried they will get this flag marked and their name changed.
* Their name will be XXXXXX *Gloried* to help in easier identifying them.
* You can also filter out gloried items, just like OOG ones on the filter form.
- Gloried items are stored in their own file, RoD_Item_Gloried.txt
* This file (If existing) will load when you open the database.
* When exiting the database it will seperate out all gloried items and store them in your own file.
* This can also be a GREAT way to keep ceartain items ID's secret.
- I.e. Import items and manually flag them as gloried. The id's will be stored in the seperate file.
- Layerable items in the Characters Listing only list the extra slots if you have a layered item equipped.
* There is a limit of 10 layered items per layered slot, lets hope someone doesn't make more than 10 items that can layer on your body 😉
- Area column brings up a dropdown list to select the area items are from.
- You can now import someone elses data file it compares and merges both.
* Note: This will only work with v4+ Data files. You can NOT import old files.
* The reason is there is more data columns in the new ones and new ways of handling the data. They are incompatible.
* All future versions v4.0+ will be backwards compatable with any v4+ file...
* Meaning when v4.5 comes out, it will be able to import v4.0 files etc.

Older additions (3.9.4):
---------------------------------------
- Fixed the bug with importing items with the rouge-rogue flag.
- You can now add "other" type items, and fill up your database with crap :
* Items types added were... Herbs, incenses, toys, tools, trash

Older additions (3.9.3):
------------------------
- Added Barbarians as a class.
- Modified all magic items to be Anti-Barbarian. (This will be automatically done when you import a magical item)
* NOTE: I could not add anti-barb to any items that were anti-fighter. As the databse doesn't store data like that.
* Any items that are anti fighter and non-magic, let me know so I can edit.
- Movements are now summed and shown on the character page.
- You can filter by movements.
- You can filter by minimum level, showing items of a range say 20-25.

Older additions (3.9.2):
------------------------
- Added a Location column so you can record where items come from, mob/area etc.
- Base HP/Mana are now set to "average" values when you change the class of a character.

Older additions (3.9.1):
------------------------

- Axius retired from Realms of Despair, May 2002, Baralis coded some changes up to version 3.6 but
the source was unavailable. Ver 3.9 is based on the old 3.3 source + changes by Nemser.

- Fathomers as a class are now in the Class section.
- All of the new class stats were added to the database to account for the secondary and
deficient changes.
- A few new items prior to The Shattering were added with more to come.
- Multiple wearlocs for Body/Arms/About to accomodate the new layers found.
- A new flag added for pkill equipment from the new deadly-only areas (shows up as K in properties)
- Added quite a few items as well as finding some new layerable stuff (more to come!)
- Two-handed flag for new weapons

Some of these above items already existed in the modified 3.6 version by Baralis. The source
code for which wasn't available. I had to start from the old 3.3 code and re-write those
sections. Below are the NEW additions ontop of the changes made so we have a up to date source available to build on.

- Reading a log file actually WORKS NOW!!!!! (Please stress test this with new things)
- Resists/suscepts total up in the character section (Also still under testing but works well so far)
- Base HP/Mana can be recorded in the character section and totalled.

* Any requests for new features or bugs please send me a mudmail or leave me a message in forums etc.
* I can't find all the problems myself, so play around with it and let me know anything quirky you find.

General notes:
--------------

- the program currently supports armor, weapons, lights, containers,
staves, wands, scrolls, potions, pills and salves

- for weapons: ident now reports the weapon type, all new weapsons identified will have
this automatically added. Any older weapons will gradually be filled in as time permits.

- the Properties field contains the brief list of item flags. For details
move the cursor to that field and press Enter or click the mouse

- there are items that cannot be obtained by mere playing the game,
like clan equipment (old and new), quest items, etc. These items have
the NOT IN GAME flag set by me manually. If you happen to identify
such an item and add it to the database, please don't forget to set
the NOT IN GAME flag manually.

RoD_db by default does not show these items when filtered and you have
to select the "Show OOG Items" tickbox to see them listed.

- There are also items that can only be used by pkiller players.

RoD_db by default does not show these items when filtered and you have
to select the "Show Pkill Items" tickbox to see them listed.

- you can delete records from the database by pressing Ctrl-Del. It is
better not to have a record of some item at all than to have a wrong
record. That is, if you cannot correct the record by editing it

- pressing Ctrl-C or Ctrl-Ins fills Windows clipboard with the info of
the currently selected item. You may paste it (Ctrl-V) anywhere in
Windows (for instance, in zMUD)

Gathering information:
----------------------

- you can skip this section if you are not going to add information to the
database yourself

- this program extracts information from your session logs, therefore you
have to turn logging on (Ctrl-L in zMUD) if you wish to gather information
rather than just use the database

- log files must have the ".txt" extension, and they must be DOS-style
text files (each line terminated with CR/LF), not UNIX-style text
files (each line terminated with LF). Use TODOS utility to convert logs
if you are mudding from UNIX

- it is recommended that you log each session to a different file

- to gather info more efficiently, it is recommended that you turn the
AUCTION channel on and use triggered AUC command (triggered by "A new
item is being auctioned"), although it will add some spam. If you have
an alt character that has nothing to do, it would be perfect for
auction logging

- it is highly recommended that you set the prompt for your logging
character to start with a "<" and end with a ">", otherwise some
information can be overlooked by the program

- you must have CONFIG +BLANK in order to gather information

- the initial database already contains some item info gathered by me
using this program. Try doing it manually for comparison 😉

- known problem 1: items with the same name (especially new/old versions
of the same item) may lead to confusion. To avoid it, you can edit item
name by adding something like "(old)" to it so the program will not
modify that item's record anymore. Also, don't forget to set the NOT IN
GAME flag for "old" items

- known problem 2: enchanted weapons may cause anti-good or anti-evil
flag set for a weapon that initially didn't have it. Avoid identifying
enchanted weapons if possible. The program automatically recognizes
enchantable weapons and correctly "enchants" them by adding +3HR/DR
and the "enchanted" flag without setting anti-good/anti-evil flags.
If you see a "wrong" anti-good or anti-evil flag, feel free to remove
it (edit the FLAGS field)

- also please avoid identifying renamed or glory-enhanced items. If you
see such an item in the list of updates after reading a log file,
just delete it (Ctrl-Del)

- don't add brewed potions, scribed scrolls, clan potions and pills,
out-of-game potions, pills and salves, immortal-made tonics, etc.
They will only get in your way when you need to find a 'natural' item

Retrieving information via DDE in zMUD:
---------------------------------------

- RoD_db supports DDE data requests.
DDE application name: "RoD_db", topic: "Info"
To send a request: execute a macro containing the request string
To retrieve the result: read item "Data"

Request format: [n.]text{ text}
or all.text{ text}

Example: "dragon" will retrieve first item that has "dragon" as
a substring in its name ("Dragonslicer"), "2.dragon" will retrieve
the next item containing "dragon" ("dragon fang"), "dragon hide plate"
will retrieve first item that has "dragon", "hide" and "plate" in
its name (which is obviously "Dragonhide Breastplate").

The substrings can be separated by blanks or dashes.

Specifying "all" as prefix will retrieve all items with names containing
the substrings.
Example: "all.dragon" will retrieve a list of all dragon-related items

An example of a zMUD alias:
#ALIAS info { #DDE RoD_db Info {%-1}; #SHOW %dde(RoD_db,Info,Data) }
Then you can use it like this:
info all.dragon scale

Note 1: Items can be retrieved by fragments of their names, not
keywords. SMAUG does not show keywords in ident reports

Note 2: Using zMUD DDE functions sometimes causes RoD_db to crash
on exit. It is due to zMUD's way of working with DDE, and it
will hopefully go away in the future. Nothing serious, no data loss.

- and yes, this program is FREEWARE

Enjoy!

Original code (c) Alexian/Axius/Aibolith @ RoD
Modifications V 3.3 + Nemser