summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2007-03-27Updated sql-filesPlaytester1-25/+34
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-19- Removed the last argument from skillitem, the skill name passed to the ↵skotlex1-30/+30
client should always be of the type "AL_HEAL" anyway. - Added skill ITEM_ENCHANTARMS, this is what weapon enchanting items should use. - Corrected itemskill calls in the item_db, also made the weapon enchanting items invoke the ITEM_ENCHANTARMS skill. Corrected Holy Egg not being type 11 (delay consume) - Updated item_db.sql with item_db information. - Added support for specifying different elements per skill level in the skill_db - Added bonus bNoKnockback - Corrected typo in bonus bSubRace2 (it was called bSPSubRace2 for some reason) - Corrected login sql server not resetting your account state to 0 when the banuntil duration expires. - Corrected use of UINT_MAX instead of INT_MAX in some jailing check. - Made the skillatk bonus it's own function, it can now be used to boost Heal/Sanctuary/Potion Pitcher and Slim Pitcher as well. - Cleaned up TK_WARMWIND to use the element acquired from the skill_db rather than hardcoded values. - Corrected Teleport's save map entry being sent without the .gat extension. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10031 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-13Updated sql filesPlaytester1-51/+51
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9998 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-08- Normalized the mapname in guild get/set castle data, should fix guild flags.skotlex2-1/+2
- Added log options 0x800/0x1000 to log storage moves ('R') and guild storage moves ('G') - Added upgrade_svn9976.sql to include 'R'/'G' on the picklog type column set. - Updated the logs_athena description to include the letter of each type (512 - M, 32 - N, etc) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9976 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-05* Added various new headgears thanks to ArgatlahmPlaytester1-243/+330
- some headgears might not be fully official, feel free to report bugs if you find any - also updated item_db.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9965 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-05Fixed the loginlog's `user` column length (use upgrade_svn9957.sql)ultramage1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9957 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-02EOL-styled some more filesultramage40-1216/+1216
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9947 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-02-23- Updated Box of thunder to use "agi up" effect for 30 secs instead of NPC ↵skotlex1-1/+1
Agi Up for 20. - Guild expulsion now will fail when the character to be kicked is in a guild castle (rather than checking for the character doing the expulsion) - pk damage reduction settings now will take effect only on Player VS player damage. - Fixed produce_db2.txt entries overwriting produce_db.txt ones. - Fixed item-granted/plagiarized skills unlocking skill trees when only your real learned level should. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9899 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-01-23- Added view_data support to mercenary.*, so that the Homunculus entries are ↵skotlex1-16/+0
no longer required on the mob_db. - Removed homunculus entries from mob_db. - Added the status icon to NPC_CHANGEUNDEAD and the Flee/Hit foods - Corrected the check that lets you walk when vending/chatting/etc. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9697 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-01-06- Fixed Succubus/Incubus combo not doing regen correctlyultramage1-2/+2
Read why at http://www.eathena.ws/board/index.php?showtopic=129814 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9622 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-27Updated SQL filestoms2-359/+368
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-19- Reverted the mob ThinkTime update, that field is again aDelay as it ↵skotlex2-2/+2
apparently should be. - Fixed one small compilation error. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9522 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-13- Added boss mode (0x20) to a few mobs that were missing it.skotlex1-22/+22
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9487 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-11- Updated mob_db2.sqlskotlex1-38/+38
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9465 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-11Updated sql filesPlaytester2-24/+32
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9459 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-06- Updated the mob_db converter to rename the ADelay column to ThinkTime.skotlex2-51/+52
- Updated the mob_db sql files to have this change as well. - Updated mob_db2.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9425 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-06Updated sql-filesPlaytester2-914/+911
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9424 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-12-01Updated sql filesPlaytester2-548/+568
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9378 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-28* Enabled Ice Dungeon spawns so they can be testedPlaytester2-105/+108
* Updated sql files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9348 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-27Updated sql filestoms2-24/+25
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9326 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-23Updated sql filesPlaytester2-2822/+2822
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9299 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-16Updated sql filestoms2-91/+91
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9233 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-05Updated sql filestoms2-121/+121
Updated perl files acording to rev 9135 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9139 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-11-04* Converted itemdb tables to use smallint. Credits to ALZ. Lance3-2736/+2738
modified Changelog-Trunk.txt modified sql-files/item_db.sql modified sql-files/item_db2.sql added sql-files/upgrade_svn9135.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9135 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-26Updated sql filesPlaytester2-20/+20
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-23- Added a bunch of important indexes when dealing with the log tables. Added ↵skotlex2-6/+22
upgrade_svn9050.sql for this purpose. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9051 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-10-08Updated sql filesPlaytester2-97/+97
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8951 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-14Updated item_db.sql and mob_db.sqlPlaytester2-92/+92
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8753 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-13- Modified the login SQL server so that case insensitive lookups use "where ↵skotlex2-3/+11
name = BINARY 'name'" instead of "where BINARY name = 'name'", since this way the name index should be used, and performance will no longer be heavily affected. - Modified main.sql to add 4 missing indexes (thanks to ErkDog): char_id on the tables memo/friends, and online/name on the char table. Added upgrade_svn8728.sql to add these indexes to already existing tables. - Changed back the default of case-sensitive to ON since it shouldn't be such a bad performance hog now. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8728 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-12- Updated convert_engine.sql to use TYPE instead of ENGINE to be compatible ↵skotlex1-10/+10
with Mysql 4 installations. - case_sensitive is now off by default due to performance issues. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8726 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-12- Added manual deletion of sc_data entries when deleting a character (char-SQL)skotlex3-111/+40
- Updated main.sql to use pure MyISAM tables, removed all foreign keys. - Added Jaguar's sql script to convert all tables to MyISAM. It's located in sql-files/convert_engine.sql - Removed convert_guild_tables.sql as we don't use InnoDB anymore. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-11Added D-Kalck's fix of the TXT -> SQL converterPlaytester1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8702 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-10Sql file...Playtester1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8694 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-10Updated item_db.sql and mob_db.sqlPlaytester2-194/+206
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8690 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-08- Added upgrade_svn8675.sql in case, for some reason, your guild table still ↵skotlex1-0/+1
has the emblem_data field as a 'blob' with "NOT NULL" specified. - Some minor cleanups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8675 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-09-05- Fixed connect_until field being a smallint rather than int in the login ↵skotlex2-1/+2
table (upgrade with upgrade_svn8630.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8630 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22- updated (more or less) the sql-files/item_db2.sql file.skotlex1-12/+14
- Some insignificant cleanups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8429 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-22Added SQL update which should remove \' from guild namestoms1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8423 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-17* Gospel can't stack anymorePlaytester2-1141/+1141
* Updated SQL files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8328 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-10- Fixed two instances in the login-sql server where the ip in the log-login ↵skotlex1-1/+1
table was being stored backwards. - Now when a skill's range is 0 and the skill is NOT casted on self, it will take the basic weapon's range (without Vulture/Snake Eye bonus). - Now when a duration is not specified, sc_start/sc_start2/sc_start4 will try to guess the duration by extracting it from the skill_db (it uses skill_get_time on whatever skill is associated to the status-change using val1 as skill-level) - Corrected that extra comma at the end of the Kaensin layout setup. - Some cleanups on trade_tradeaccept to prevent packets being resent when they shouldn't. - Corrected that ALLOW NULL thingie on main.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8229 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-10Fixed syntax error in 'guild' create table statementtoms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8228 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-08- Fixed yet again AS_SPLASHER doing full damage on all characters. Now you ↵skotlex1-1/+1
can use the NK split damage value in the skill_db if you want damage divided by the amount of targets rather than by 2. - Fixed crash on the battle_drain functions. - Cleaned up HAMI_CASTLE, HLIF_AVOID, HAMI_DEFENCE so that it's usable by other types of objects other than Homunculus. - Cleaned up the Asura Strike code so that the SP/Spheres/States is not consumed when the skill fails due to Fog of Wall. - When a negative delay for a skill is specified, this delay is now added on top of the character's amotion rather than adelay - Modified main.sql to make the guild table allow NULL on the emblem data. - Added file conf-tmpl/Changelog.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8185 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-06Reupdated item_db.sql to latest (forgot to update before -_-)toms1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-08-06Updated item_db.sql to latest.toms2-139/+159
Little fixes on homunc (hp/sp are now saved and init stats changed) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8154 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27- Corrected Combat Knife reducing damage from DemiHumans by 10% instead of ↵skotlex1-1/+1
increasing damage against them. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7924 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-27Fixed Independence Memorial Hat weight, set to 0toms1-1/+1
Updated item_db.sql to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7914 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-25- Added Toms's perl scripts item_db.pl and mob_db.pl (they are in tools/), ↵skotlex2-120/+126
they convert the txt databases into sql. - Usage: "script" < "input file" > "output file". eg: ./tools/item_db.pl < db/item_db.txt > sql-files/item_db.sql - Updated the sql files since now it's easy :D git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7879 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-25- Re-updated the mob_db.sql to latest.skotlex1-58/+63
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7868 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-23- Updated mob_db.sql to latest.skotlex1-187/+186
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7833 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-20SQL fix for Homunc skillsDracoRPG2-3/+12
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7768 54d463be-8e91-2dee-dedb-b68131a5f0ec