summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2006-07-18- Updated mob_db.sql to current mob_db.txt data.skotlex1-92/+145
- Some cleaning on chrif.c - The char-server will allow off-line character saves when said char is tagged for final-save (this is the scenario when the char-map reconnect). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-17- Updated mob_db.sql to current mob_db.txt data.skotlex1-168/+168
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7708 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-17Orn's and Albator's Homunculus system, finally, YAY!!DracoRPG3-561/+620
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7706 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-07-08- Fixed the char table having party/guild_id as smallint when they need int ↵skotlex2-2/+4
there. Thanks to hermematon for pointing it out (use svn_ugprade7580.sql) - Applied k3dt fixes to pet-hatching, ice-wall check, and wedding skills. - Fixed endow skills calling the skill no damage packet twice. - Fixed a crash on warpwaitingpc when the chat-room is empty. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-24- Fixed an error on the item_db.sql file... GOSH I HATE THOSE COMMENTS, they ↵skotlex1-1/+1
make it HARD to correctly update the sql file >.<'' git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7327 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-24- Updated mob_db.sql and item_db.sql to latest.skotlex2-46/+150
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7324 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-17- Implemented correct script for "12038,Lotto_Box_04"skotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7228 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16- Modified the bNoMagicDamage/bNoWeaponDamage bonuses to be a 0-100 setting. ↵skotlex1-1/+1
Meaning you can do bonus bNoMagicDamage,50; To make all magic damage be reduced by half. This bonus stack, so two cards with bNoMagicDamage,50 will give magic immunity. - Removed setting gtb_pvp_only and replaced it with gtb_sc_immunity which specifies the threshold before the bNoMagicDamage starts blocking support statuses as well. ie: gtb_sc_imunity: 75 will mean that "bonus bNoMagicDamage,70;" reduces magic damage by 70%, but does not blocks heal or support status, while "bonus bNoMagicDamage,80;" does. - Updated GTB's card script to be "bonus bNoMagicDamage,100;" git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7212 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16- Removed db_tables.sql as it's no longer used.skotlex2-585/+1
- the mvp_sd is removed when the mob is the emperium and there's no killer/exp-awarded (assumed killed by script), this prevents the on-kill event from triggering and giving the castle to whoever damaged the most the emperium without destroying it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7208 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-16sql optimizations.Euph2-539/+542
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7198 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-14- Fixed main.sql adding a key on char_id rather than account_id for the char ↵skotlex1-1/+1
table. - Cleaned up character saving in char-sql, it no longer needs to query the database to see if the player exists on each char-save, instead it checks the received data against the online-players db. - Added an error message on the char-server when the received player data size does not matches with the expected size (should avoid the crash that happens on such a memcpy). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7160 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-14Syntax errors :(Lance1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7155 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-13- Updated mob_db.sql and item_db.sql to latest.skotlex5-254/+307
- Added account_id index to char table. Thanks to Buuyo for reporting it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7146 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-06-02- Updated item_db.sql/mob_db.sql to current.skotlex2-546/+483
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6922 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-31[Improved]: Lance1-1/+2
- SQL upgrade file for the new loginlog. Thanks to ultramage. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6883 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-31git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6869 ↵Lance1-0/+1
54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-31[Improved]: Lance1-1/+1
- loginlog using unsigned long `ip` field. (Please check for compatibility problems). [Added]: - Mercenary.c in VS.NET 2005 project files git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6868 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-27Fix possible compile mistakes in there. >_>blackhole891-0/+21
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6790 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-24- Merged item_db.sql from stable :Bskotlex1-2539/+2539
- Added a missing line (how did it get lost?) in mob_spawn to set aggressive state for angry mobs. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6731 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-19- Fixed loginlog definition in main.sql, thanks to Tempestaskotlex1-2/+2
- Likely fixed the mob-skill random picking behaviour causing infinite loops sometimes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6658 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-12- Reverted again the change that stuns the caster on Ske, Ska, Swoo when the ↵skotlex1-3/+3
target is a nonplayer (rather than always) - Modified mob_spawn_once so that coordinates -1,-1 are "random around the player" while 0,0 are random around the whole map (regardless of whether there's a player attached or not) - Knockback will no longer work on traps during woe. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6566 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-11- Fixed the definition of the KEY in the loginlog, thanks to TheUltraMageskotlex1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6559 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-11- Added the missing semi-comma from the upgrade_svn6533.sql file. Thanks to ↵skotlex1-2/+2
Tanaous - Added back the missing code that substracts arrows when normal-attacking. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6554 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-10- Changed wedding costumes to use setoption rather than changebase.skotlex1-2/+2
- Modified setoption so that flag 1 or no flag adds an option, and flag 0 removes it. - Updated script_commands with the new behaviour. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6548 54d463be-8e91-2dee-dedb-b68131a5f0ec