summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2011-12-05Merging RREmu into rAthena -- quite a few stuff yet to be renamed, but we'll ↵shennetsind2-1/+2
get it sorted. Some of the stuff included in RREmu that is now part of rAthena: - RE Drop Rate Modifier - RE Experience Rate Modifier - RE Weapon MATK - RE Shield ASPD job-specific penalty - RE Cast Time - Renewal-specific item DEF - 3.1 classes. - All-New Mounts - Official Magical Reflection - And other perks, such as fully-functional @mapflag also merged eAthena 15006 into rAthena. For Bugs, Comments and Suggestions: http://rathena.org/board/tracker/ git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15009 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-10-31- Removed .gat from map names.brianluau2-2/+0
- Removed trailing tabs in some warp portal files. - Removed `loginlog` table from convert_engine SQL scripts, because it's in the log database. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14987 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-09-10- Fixed some typos in item_db.txt (bugreport:5048)brianluau2-1726/+2299
- 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-16* Added support for visible garments/robes.ai4rei2-0/+2
- For SQL apply upgrade_svn14797.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This also fixes NPCs not being visible with clients 2011-01-11aRagexeRE+ (bugreport:4865). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14797 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16* Updated field `weapon` in table `char` to default to '0' (bare-handed) ↵ai4rei2-1/+2
rather than '1' (knife) (follow up to r11696). - Apply upgrade_svn14796.sql to reflect the change on existing setups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14796 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-15* Fixed some `mob_db` columns being too small for currently used values ↵Gepard2-12/+12
(bugreport:4866, since r14727). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14794 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-24- Removed extra <TAB> from const.txtbrianluau2-4/+8
- Changed the card columns in `cart_inventory` table to SMALLINT(11), to match other tables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14759 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-01- Updated SQL item/mob databases to latest. (thanks Peter)brianluau2-1558/+1890
- 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
2011-02-19* Implemented buying store system (aka. reverse vending, purchase shop) ↵ai4rei2-4/+8
together with related skill and items, without NPCs. - For SQL apply upgrade_svn14713_log.sql to upgrade tables `picklog` and `zenylog`; for TXT no action is necessary. - Requires 2010-04-20aRagexeRE or later and can be disabled in 'conf/battle/feature.conf'. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14713 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-08* Added support for new delayed character deletion.ai4rei2-0/+2
- Asks for birth date associated with the account and has a waiting time of 24 hours by default (setting). - For SQL apply upgrade_svn14700.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This completes support for clients 2010-08-03aRagexeRE and later. * Updated login sql engine version, missed during `birthdate` addition (follow up to r14672). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14700 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-01-14* Added 'birthdate' field to account data. For SQL apply ↵ai4rei2-0/+2
upgrade_svn14672.sql to upgrade table `login`; for TXT no action is necessary, as it upgrades itself. - Control panel developers are encouraged to enable players to modify this value, as it is required for new character deletion (2010-08-03aRagexeRE and later, not yet implemented). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14672 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12* Removed `motd` from `ragsrvinfo` table in main.sql, missed in previous ↵ai4rei1-2/+1
commit (follow up to r14579). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12* Updates to dynamic server information `ragsrvinfo` on SQL.ai4rei1-0/+1
- Fixed exp and drop rates (int) getting truncated (short) when sent to char-server. - Removed `motd` from `ragsrvinfo` as it is not dynamically changed by the server and as such can be read by 3rd party applications directly from conf/motd.txt if required. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14579 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-11-26Changed 'killerrid' and 'killedrid' from player vars to player params ↵ultramage1-0/+1
(bugreport:3249). Now stored in player session data, so they don't get saved on logout anymore. Added sql upgrade script 'upgrade_svn14507.sql' to remove the now unused player variables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14507 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-08-26- Fixed duration of Box_Of_Sunlight. (bugreport:4408)brianluau1-1/+1
- Fixed some small typos in KVM scripts. (bugreport:4403) - Fixed @refresh leaving you stuck if you had a chat window open. - Changed @refresh to also send your facing direction. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14394 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-08-20* Fixed wrong events being called for flavius02 BG waiting rooms. ↵L0ne_W0lf1-1/+1
(bugreport:4395) * Fixed the setwalls in Tierra gorge, again. Removed extra mapflags. * Moved overlapping guild flags outside arug_cas05 to proper points. * Fixed kRO Name for Women's Bundle. (bugreport:4398) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14385 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-06-19- Updated SQL item/mob databases to latest. (thanks Peter)brianluau2-1526/+1851
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)brianluau2-3/+3
- 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)brianluau2-41/+83
- 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-04-17- Fixed some typos in quest_db.txt (bugreport:4186)brianluau2-0/+2
- Fixed a typo in socket_enchant.txt (bugreport:4188) - Added missing `quest` table to the convert_engine sql files. (r12559,r13960,r13963) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14284 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-04-01- Fixed 'OnPCLogoutEvent' being queued and never executed if brianluau1-12/+12
the player was already talking to an npc. (bugreport:1209) - Fixed 'OnPCLogoutEvent' not triggering when changing map-servers (pc_setpos). - Combined some isequipped() in item scripts. (bugreport:4158) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14278 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-03-31- Updated 'getinventorylist' to also return expire_time in the array ↵brianluau2-14/+14
@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-03-15- Fixed some accessories added in r14210 being refineable. (bugreport:4126)brianluau1-38/+38
- Fixed the duration on some foods. (bugreport:4113) - Fixed some typos in Battlegrounds scripts. (bugreport:3971) - Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14263 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-10- Fixed a misleading description. (bugreport:4008)brianluau3-40/+111
- 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-02-09Expanded range for cached and stored-in-db guild member exp (devotion) from ↵Paradox924X2-1/+2
uint32 to uint64. (bugreport:3983) Capped value when sending to client to INT_MAX to prevent confusion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-01-08- Fixed a typo in Orc's Memory.brianluau3-231/+236
- 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-12-01- Fixed weight of Mandragora_Cap (5399) should be 30, not 300. (bugreport:3910)brianluau1-16/+21
- Re-added more Sakexe packets that were accidentally removed in eAthena rev 14155. This fixes colored broadcasts not appearing in some clients. (bugreport:3903) - Updated SQL item/mob databases to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14179 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-11-11- Fixed a typo in Strawberry Cake (12319). (bugreport:3702)brianluau4-26/+49
- 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-10-12Added missing sql update file for renameInkfish2-0/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-24- Re-added Hardrock Mammoth's MD_BOSS mode that was lost in r14052.brianluau2-19/+32
- 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-09-04forget to update main.sqlInkfish1-3/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14037 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-09-04* QuestLog Fix.Inkfish1-0/+3
- mob id no longer stores in sql. - counts won't increase if you have killed sufficient mobs. * Fixed Merchant's medalion wrong aspd bonus (bugreport:3554) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14036 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-27- Fixed typo in Hyegun_Hat (5367). (bugreport:1935)brianluau1-2/+2
- Added missing bonuses to Mask_Of_Ifrit (5420). (bugreport:2188) - Added better examples for some documentation. - Fixed item loss from mail if you are OVER 100% overweight. (bugreport:1862) - Fixed 'waitingroom2bg' checking wrong parameter. (bugreport:3330) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14034 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-08-26- Fixed Snake Head Hat (5388) Double Attack bonus. (bugreport:3483)brianluau4-1174/+1725
- 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-27- Added svn:eol-style native for some conf/css/html/pl/sql/txt files.brianluau10-129/+129
- Added svn:executable property for several batch/shell scripts. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13972 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-26Fixed mob counts and quest states are not saved properly sometimesInkfish2-0/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13964 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-26* Some updates of Quest Log systemInkfish2-15/+10
- renamed table 'questlog' to 'quest' to avoid misunderstanding - updated main.sql - fixed the server can't load more than 16 quests - removed the MAX_QUEST limit. tests show the client can handle more than 100 quests. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13963 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-25Fixed undeclared variables on charserv compiling. how careless i am.....Inkfish1-20/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13961 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-25adding the sql update I forgot...Inkfish1-0/+40
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13960 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-07-02- Added mosk_que to the mapcache (follow up to r13903).brianluau3-65/+65
- 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.brianluau4-71/+117
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13908 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-15- Changed some variables to scope instead of permanent char. (bugreport:3248)brianluau1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13890 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-11* Fixed TaTaMiGaEShi(Improvised Defense) not working.Inkfish1-0/+1
* Implemented new cooking success formula. Now cooking experience starts at 0.(bugreport:2439) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13881 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-08- Fixed item ID of Pickaxe (should be 6010). (bugreport:3214)brianluau1-19/+19
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13862 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-05- Updated item_db.SQL to latest.brianluau1-129/+142
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13848 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-06-05- Removed some extra spaces in item_db.txtbrianluau1-83/+81
- Removed extra spaces in item_db.sql so it matches the TXT version. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13847 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04Reverted the "The md5() of their kafra code is now stored in #kafra_code$" ↵ultramage2-2/+1
change from r13728. Added md5calc to vs8/vs7/vs6 project files. Applied svn:eol-style to the new sql upgrade file. Note that if you already applied the sql upgrade, your kafra passwords are lost. Also note that txt users will still have to implement their own migration code into the kafra scripts since it was omitted in the previous commits. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13729 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04* Added the md5() script command. (follow up to r13719)brianluau1-0/+1
- Changed kafra storage password to be stored as md5 hash in #kafra_code$. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13728 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-04Updated item_db.sql and mob_db.sql from recent changes to both. Thanks to ↵jmanfffreak2-3022/+3107
Peter once again! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2009-05-03* Removed the obfuscation of the #kafra_code password. (bugreport:2323)brianluau1-0/+1
TODO: add a 'md5()' script command and use that instead. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13719 54d463be-8e91-2dee-dedb-b68131a5f0ec