summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2011-12-11Fixxed Mole Card bonus.(bugreport:2230)kenpachi2k111-2/+2
Fixxed The Sign bonus.(bugreport:5116) Fixxed documentation for Guardian() and GuardianInfo script commands.(bugreport:5117) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15058 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-10Corrected an issue with Sprint Ring adjusting bDelayRate the wrong way. ↵jmanfffreak1-1/+1
(bugreport:5070) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15055 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Fixed typo in item_db_re.sql, bugreport:5108shennetsind1-6/+6
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15049 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09- Added a blank line at EOF to make SVN and some compilers happy. ↵brianluau2-103/+103
(bugreport:5107) - Removed trailing tabs in /doc/script_commands.txt - Set svn:eol-style=native for some recently added text files (follow up to r15009). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15043 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Removed the Worn Out Scroll giving a Jellopy (bugreport:5053).jmanfffreak1-1/+1
Also removed /db/item_scroll.txt, since that item was the only thing pulling data from it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15042 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Fixed Pussy Cat Ears not being able to be equipped by all jobs. bugreport:5102jmanfffreak1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15041 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-09Added item_db_re.sql -- missed this little guy when RREmu was merged in.shennetsind1-0/+102
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15040 54d463be-8e91-2dee-dedb-b68131a5f0ec
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