summaryrefslogtreecommitdiff
path: root/sql-files/mob_db.sql
AgeCommit message (Collapse)AuthorFilesLines
2014-01-13Updated SQL mob database (re and pre-re)Haru1-150/+121
- Special thanks to Emistry for reminding us. - Added a comment to inter-server.conf to discourage relying on those sql databases for scopes other than control panels and such, unless you really know what you're doing. Signed-off-by: Haru <haru@dotalux.com>
2013-08-22Fixed Bug #7503shennetsind1-1/+1
128 being higher than the maximum available value for pre-re mode (in pre-re def is 'char/int-8', unlike renewal mode in which it is 'short/int-16') http://hercules.ws/board/tracker/issue-7503-mob-parse-dbrow/ Signed-off-by: shennetsind <ind@henn.et>
2013-03-14Start to standardize the database files.lemongrass31101-89/+95
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23* Removed duplicate isequipped() entries from item_db already written in ↵euphyy1-2/+2
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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16955 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-23* Added Guillotine Cross job quest, again thanks to Muad_Dib! (bugreport:5834)euphyy1-2/+2
* 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-28Updated SQL item DBs to match with their TXT versions. (Now tested...)kenpachi2k111-0/+2
Follow up r16520 - applied mob DB changes to the DBs, too. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16523 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-27Synced SQL DBs and added RE SQL-script for mob_skill_db.kenpachi2k111-8/+9
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16513 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-28* Standardized and added Shadow Chaser job quest! (bugreport:5834)euphyy1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16350 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-15Follow up r16253 - Replaced NULL with 0 in mob_db.sql and mob_db_re.sqlkenpachi2k111-1080/+1080
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16304 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Follow up r16252 - replaced zeros with NULL and corrected syntax of ↵kenpachi2k111-1080/+1101
commented out entries in SQL mob databases. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16253 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-06-10Created renewal mob SQL database file and synchronizes both SQL mob ↵kenpachi2k111-1383/+1044
databases with their corresponding TXT databases. (bugreport:5281) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16252 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12Follow up r15679. Changed Hatii Baby to Baby Hatii.kenpachi2k111-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15680 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-12Fixed Garms iRO name. (bugreport:5421)kenpachi2k111-1/+1
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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15679 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-19Fixed Bradium Golems (2049) mode. (bugreport:4476)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15614 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-31 * Fixes and improvements related to MVP rewards (bugreport:1259):gepard19841-1233/+1455
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15531 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11- SVN Copied exp.txt, exp_guild.txt, exp_homun.txt to /db/pre-re/ and /db/re/brianluau1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15423 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22Fixed s-quote escapes in updated mob_db.sql. Thanks Brian!!calciumkid1-13/+13
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15206 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-22Replicated sql-files\mob_db.sql to match db\mob_db.txtcalciumkid1-1175/+1230
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-09-10- Fixed some typos in item_db.txt (bugreport:5048)brianluau1-2/+2
- Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14956 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-15* Fixed some `mob_db` columns being too small for currently used values ↵Gepard1-6/+6
(bugreport:4866, since r14727). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14794 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-01- Updated SQL item/mob databases to latest. (thanks Peter)brianluau1-295/+301
- Updated item/mob txt-to-sql converter scripts to append a blank line at EOF. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14727 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-19- Updated SQL item/mob databases to latest. (thanks Peter)brianluau1-40/+41
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14348 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-02- Fixed item script of Chicken_Hat (5431). (bugreport:4174)brianluau1-1/+1
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14328 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-05-28- Fixed % issues with Battleground Medals. (bugreport:4062)brianluau1-26/+68
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14309 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-03-31- Updated 'getinventorylist' to also return expire_time in the array ↵brianluau1-9/+9
@inventorylist_expire[]. (topic:243292) - Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14275 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-10- Fixed a misleading description. (bugreport:4008)brianluau1-2/+73
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14243 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-01-08- Fixed a typo in Orc's Memory.brianluau1-13/+13
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14216 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-11- Fixed a typo in Strawberry Cake (12319). (bugreport:3702)brianluau1-16/+17
- 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://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14142 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-24- Re-added Hardrock Mammoth's MD_BOSS mode that was lost in r14052.brianluau1-15/+28
- Fixed a typo ("too much too much") in Alchemist Quest. - Updated SQL item/mob databases to latest. (thanks Peter) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14074 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-26- Fixed Snake Head Hat (5388) Double Attack bonus. (bugreport:3483)brianluau1-35/+35
- Added missing 'break' in some Juperos warps. - Updated SQL item/mob databases to latest. (thanks Peter) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14029 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-02- Added mosk_que to the mapcache (follow up to r13903).brianluau1-33/+33
- Fixed some input checks and variable types in Megingjard quest. - Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13926 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-23- Updated SQL item/mob databases to latest.brianluau1-49/+49
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13908 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04Updated item_db.sql and mob_db.sql from recent changes to both. Thanks to ↵jmanfffreak1-29/+29
Peter once again! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-03-17Updated mob_db.sql to latest, thanks to Peter for his auto builds of the ↵jmanfffreak1-139/+177
db's. [Jguy] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-24Updated sql files to latesttoms1-25/+25
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-05-01Updated mob_db.sql to latesttoms1-1/+20
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12677 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Replaced the TYPE keyword with ENGINE in all sql files, because this is the ↵ultramage1-1/+1
preferred alternative. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04Updated mob_db.sql to latesttoms1-12/+12
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12476 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-03-27Updated SQL Files (item & mobs)toms1-130/+173
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12444 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-01-25Updated conversion tools for mob_db & item_dbtoms1-57/+57
Updated SQL Files (item & mobs) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@12138 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-11-05Updated sql filesPlaytester1-6/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11669 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-21* Added new cards to drops so they can be testedPlaytester1-36/+36
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11539 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-12* Removed exp of poring stat mobsPlaytester1-8/+86
- updated Moscovia mob stats - updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11421 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-01Small sql updatePlaytester1-3/+3
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11339 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-27* Removed Final Strike from skill_cast_dbPlaytester1-8/+8
- also updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11317 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-22Updated sql filesPlaytester1-11/+11
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11273 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-19* Slightly adjusted some drop ratesPlaytester1-12/+12
- updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Some more drop rate updatesPlaytester1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11235 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-17Updated sql filesPlaytester1-16/+16
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11232 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-09-09Updated sql filesPlaytester1-11/+12
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@11152 54d463be-8e91-2dee-dedb-b68131a5f0ec