116 Commits

Author SHA1 Message Date
Atemo
3882999a5c Suggestion to remove the sql files (only) from the repo to let the user create the SQL files if he choose to use the SQL DB 2021-11-22 18:55:45 +01:00
Aleos
26632604f4
Adds support for Green Aura MVP damage (#5749)
Adds the DamageTaken flag which reduces damage done to specific naturally spawning MVP.

Fixes #3324.

Thanks to @admkakaroto, @SonaSonaSona and @Atemo!

Co-authored-by: Lemongrass3110 <lemongrass@kstp.at>
2021-02-21 23:33:15 +01:00
Aleos
7992e0891b
Converts the mob database to YAML (#5435)
* Combines mob_race2 and mob_drop databases into one.
* General cleanups and optimizations.
* Includes CSV2YAML conversion tool.
Thanks to @vstumpf, @lukasrmattos, and @Lemongrass3110!
2021-02-16 17:09:06 -05:00
Vincent Stumpf
3776bfbaa3
Support itemids up to ~2 billion (#5141)
Co-authored-by: aleos89 <aleos89@users.noreply.github.com>
Co-authored-by: Lemongrass3110 <lemongrass@kstp.at>
2020-08-08 12:06:07 +02:00
rAthenaAPI
4e5f82b344 SQL synchronization 2019-12-15 20:55:40 +01:00
Lemongrass3110
d80e111e5f
Made mob sprite column unique (#4239)
Make the Sprite column for the SQL monster databases unique.

Fixes #4223.

Thanks to @Indigo000!
2019-07-08 23:17:42 +02:00
rAthenaAPI
13d814e7a8 SQL synchronization 2019-01-11 01:14:22 +01:00
Lemongrass3110
de1bc36a7a Revert "SQL synchronization"
This reverts commit e49cba5ceee5ae0d670f67f0505fe6d5d8a141cb.

Sorry I really do not know why or how this came into master... >_<
2016-06-28 00:05:15 +02:00
rAthenaAPI
e49cba5cee SQL synchronization
[ci skip]
2016-06-27 21:58:29 +02:00
rAthenaAPI
a010531159 SQL synchronization
[ci skip]
2016-04-18 22:06:54 +02:00
rAthenaAPI
a368ef6535 SQL synchronization
[ci skip]
2016-02-14 16:11:02 +01:00
rAthenaAPI
ff6caab275 SQL synchronization
[ci skip]
2016-01-26 10:10:51 +01:00
rAthenaAPI
0922e8e050 SQL synchronization
[ci skip]
2015-04-13 12:07:56 +02:00
aleos89
7cd82d00db Increased item ID array size.
- Increased limit from 32,767 to 65,535.
- Still uses same amount of memory with doubled usable size.
- Adjusted CARD0_PET from -256 to 256.
- Please run both SQL files after applying this update to avoid values becoming corrupt.
- Tested and works on clients 2012-04-10 and up thanks to Cydh.
- Removed an unused SQL file.
2014-06-12 11:29:10 -04:00
Lilith
a053ccea3f * Fixed bug: http://rathena.org/board/tracker/issue-8345-specialeffect-target-self-doesnt-work
* Fixed bug: http://rathena.org/board/tracker/issue-8169-hiding
* Fixed bug: http://rathena.org/board/tracker/issue-8366-egg-type-monster-issue
* Fixed bug: http://rathena.org/board/tracker/issue-8406-item-bonus-not-working
* Added fix with mob_hp update when mob get healed (Hercules merge)
2014-01-03 23:56:13 -08:00
euphyy
24c2c27c65 > Database SQL update: Complete
* Extended SQL converter to cover mob_db and mob_skill_db as well as item_db. All credits to Lighta - thank you!
* Current SQL databases mob_db.sql, mob_db_re.sql, mob_skill_db.sql, and mob_skill_db_re.sql replaced with converted files.
* Updated mob_db with new entries for Hall of Abyss, Port Malaya, and Eclage (missing some mob modes).
* Minor item_db updates.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17376 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-06-19 19:12:10 +00:00
lemongrass3110
e08eac2966 Start to standardize the database files.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-14 14:55:31 +00:00
euphyy
f24741fbd3 * Initial implementation of Octopus Cave instance.
* Changed encoding on new cli and msg_* files from r17152, r17153.
* Replaced a couple of characters in source files that caused encoding issues.
* Updated SQL database from r17157.

> Hercules merges:
* 915365b:
Updated official behavior of warp portal dealing with skill requirement and casting.

* 6c6fbf0:
Updated quest_db with some Port Malaya entries.

* adda8d7:
Updated SN_SIGHT to its RE behavior.  True Sight stacks with skillratios now, instead of multiplying final damage.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17158 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-02-24 06:12:38 +00:00
euphyy
7fc959438d * Removed duplicate isequipped() entries from item_db already written in item_combo_db (bugreport:6924).
* Moved a few remaining isequipped() entries to item_combo_db.
* Follow-up r16940: applied change to SQL and pre-re files, and renamed Size constants to Size_ for consistency.
* Follow-up r16947: fixed mob modes.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16955 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23 18:30:42 +00:00
euphyy
7630c7eb61 * Added Guillotine Cross job quest, again thanks to Muad_Dib! (bugreport:5834)
* Follow-up r16941: added documentation.
* Updated WOE Controller script to v1.4, which modifies LoadEvent mapflag settings for easier cross-compatibility and standardizes script format.
* Minor tweaks here and there.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23 03:22:28 +00:00
kenpachi2k11
d04a1e8838 Updated SQL item DBs to match with their TXT versions. (Now tested...)
Follow up r16520 - applied mob DB changes to the DBs, too.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16523 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28 19:16:30 +00:00
kenpachi2k11
8fc09701c7 Synced SQL DBs and added RE SQL-script for mob_skill_db.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27 21:38:01 +00:00
euphyy
de7ebc5300 * Standardized and added Shadow Chaser job quest! (bugreport:5834)
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16350 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-28 04:44:17 +00:00
kenpachi2k11
41ee49a6dc Follow up r16253 - Replaced NULL with 0 in mob_db.sql and mob_db_re.sql
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16304 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-15 10:44:45 +00:00
kenpachi2k11
8b9dbe71f7 Follow up r16252 - replaced zeros with NULL and corrected syntax of commented out entries in SQL mob databases.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16253 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10 01:22:09 +00:00
kenpachi2k11
ccc5dc5504 Created renewal mob SQL database file and synchronizes both SQL mob databases with their corresponding TXT databases. (bugreport:5281)
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@16252 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10 00:16:38 +00:00
kenpachi2k11
7d6b0d7cd0 Follow up r15679. Changed Hatii Baby to Baby Hatii.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15680 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12 20:19:39 +00:00
kenpachi2k11
8deaf7a050 Fixed Garms iRO name. (bugreport:5421)
Fixed some create_arrow_db.txt comments. (Follow up r15672.)
Fixed Sura job change quest. (bugreport:5431)
Corrected a NPC location in quests_veins.txt.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15679 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12 19:50:51 +00:00
kenpachi2k11
dd24c8297e Fixed Bradium Golems (2049) mode. (bugreport:4476)
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15614 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19 10:28:03 +00:00
gepard1984
f2474de01c * Fixes and improvements related to MVP rewards (bugreport:1259):
- removed obsolete (since r1!) ExpPer column from mob_db
 - official way to drop MVP rewards (always starts from first slot)
 - added MAX_MVP_DROP as define for max possible MVP reward slots
 * Updated mob_db SQL scripts.
 * Removed some renewal only monsters from pre-RE mob_db (were commented out anyway).

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15531 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-31 20:06:57 +00:00
brianluau
648429a0c3 - SVN Copied exp.txt, exp_guild.txt, exp_homun.txt to /db/pre-re/ and /db/re/
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15423 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11 20:56:08 +00:00
calciumkid
6dd5c7ff19 Fixed s-quote escapes in updated mob_db.sql. Thanks Brian!!
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15206 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22 09:06:34 +00:00
calciumkid
4962b35d95 Replicated sql-files\mob_db.sql to match db\mob_db.txt
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22 07:05:33 +00:00
brianluau
f6152933d5 - Fixed some typos in item_db.txt (bugreport:5048)
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14956 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-09-10 08:44:57 +00:00
Gepard
f0865b9aa7 * Fixed some mob_db columns being too small for currently used values (bugreport:4866, since r14727).
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14794 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-15 09:50:13 +00:00
brianluau
82048a049b - Updated SQL item/mob databases to latest. (thanks Peter)
- Updated item/mob txt-to-sql converter scripts to append a blank line at EOF.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14727 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-01 00:37:13 +00:00
brianluau
84bbedc5e2 - Updated SQL item/mob databases to latest. (thanks Peter)
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14348 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-19 23:12:25 +00:00
brianluau
1552a1841c - Fixed item script of Chicken_Hat (5431). (bugreport:4174)
- Fixed a typo in script_commands.txt (bugreport:4270)
- Fixed some links in the README html files.
- Fixed the range of 'max_guild_alliance' in battle.c (0 to 3).
- Set svn:eol-style=native for some recently added text files.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14328 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-02 01:00:52 +00:00
brianluau
96aad4d94d - Fixed % issues with Battleground Medals. (bugreport:4062)
- Removed a duplicate line in item_trade.txt (bugreport:4258)
- Added missing bonus to Ifrit's_Ear (5421). (bugreport:2062)
- Fixed Coal Mine and Culvert mixup in custom warper. (bugreport:4203)
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14309 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-05-28 06:59:49 +00:00
brianluau
ede4a79e1e - Updated 'getinventorylist' to also return expire_time in the array @inventorylist_expire[]. (topic:243292)
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-03-31 00:12:31 +00:00
brianluau
6f10a38dd9 - Fixed a misleading description. (bugreport:4008)
- Changed the confusing Rare Drop Announce. (bugreport:4037)
- Fixed an extra space in item script. (bugreport:4032)
- Renamed the upgrade_svn file in last commit to match revision number.
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14243 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-10 20:46:34 +00:00
brianluau
ed86db530d - Fixed a typo in Orc's Memory.
- Fixed a weight check in quests_13_1.
- Fixed some grouping variables in the sample PCRE npc.
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14216 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-01-08 19:18:27 +00:00
brianluau
f3ca552ec5 - Fixed a typo in Strawberry Cake (12319). (bugreport:3702)
- Fixed a typo in Halloween 2009 Event. (bugreport:3711)
- Updated SQL item/mob databases to latest. (thanks Peter)
- Applied the change from r14087 to @tonpc, @shownpc, @hidenpc. (bugreport:3599)

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14142 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-11 21:49:50 +00:00
brianluau
905293afc6 - Re-added Hardrock Mammoth's MD_BOSS mode that was lost in r14052.
- Fixed a typo ("too much too much") in Alchemist Quest.
- Updated SQL item/mob databases to latest. (thanks Peter)

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14074 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-24 01:48:17 +00:00
brianluau
2a66536939 - Fixed Snake Head Hat (5388) Double Attack bonus. (bugreport:3483)
- Added missing 'break' in some Juperos warps.
- Updated SQL item/mob databases to latest. (thanks Peter)

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14029 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-26 10:26:45 +00:00
brianluau
973a96f9aa - Added mosk_que to the mapcache (follow up to r13903).
- Fixed some input checks and variable types in Megingjard quest.
- Updated SQL item/mob databases to latest.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13926 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-02 18:56:16 +00:00
brianluau
0949ac0d1a - Updated SQL item/mob databases to latest.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13908 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-23 00:15:39 +00:00
jmanfffreak
072ee7a90b Updated item_db.sql and mob_db.sql from recent changes to both. Thanks to Peter once again!
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04 01:25:17 +00:00
jmanfffreak
8f9f43d206 Updated mob_db.sql to latest, thanks to Peter for his auto builds of the db's. [Jguy]
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-17 23:05:36 +00:00
toms
4f4cb7515f Updated sql files to latest
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-24 11:20:16 +00:00