summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2011-12-25Updated October Fest Cap (5807) bonus. Assumed 2% chance until we get more ↵kenpachi2k111-5/+5
information. (bugreport:4475) Updated Shield of Naga (2134) bonus. (bugreport:4379) Updated Well-Chewed Pencil (5574) bonus. (bugreport:4381) Updated Parade Hat (5225) bonus. (bugreport:4481) Removed changes from r15112 / bugreport:4356. (Was a custom iRO bonus.) Updated Speed Potion drop chance in First Aid Kit. (bugreport:5157) Fixed item_bonus.txt where x/10000 should be x/100. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15259 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-24Fixed typo in item_db.sql (bugreport:5153)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15258 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-12-18- Set svn:eol-style=native for some recently added text files (follow up to ↵brianluau2-6489/+6489
r15155). - Changed urls in README to http (https is when you're logged-in to SourceForge). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15159 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func followup 2calciumkid1-6354/+6354
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15157 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func followup [CalciumKid]calciumkid1-73/+73
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15156 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-18mob_read_sqlskilldb func [CalciumKid]calciumkid2-0/+6489
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Rideword Hat bonus. (bugreport:4356)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15112 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-14Updated Kasa Card bonus. (bugreport:2499)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15110 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Updated Water Lilly Hats DEF value. (bugreport:4304)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15097 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some job codes. (bugreport:4254)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15095 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed some items. (bugreport:4274)kenpachi2k111-4/+4
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-13Fixed comment in exp.txtkenpachi2k111-4/+4
Updated Luxurious Keycards (7509) trading behaviour. (bugreport:3718) Updated Sleipnirs (2410) bonus script according to iRO Wiki. (bugreport:5118) Updated Soldier Grenade Launchers bonus effect and trading behaviour. (bugreport:4133) Updated Full Plates (2316/2317) DEF value. (bugreport:4260) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15093 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonus for Valorous Assaulter's Katzbalger (1184). (Bugreport:3021)kenpachi2k111-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15082 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-12Fixed bonuses for Kafra Dolls (ItemIDs 5340, 5341, 5342, 5343, 5344 5345) ↵kenpachi2k111-6/+6
and added a missing semicolon in item_bonus.txt. (bugreport:3129) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15080 54d463be-8e91-2dee-dedb-b68131a5f0ec
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