summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
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
2006-05-10- Updated mob_db2.txt and mob_db2.sql to have only 10 drop slots rather than 15.skotlex2-55/+45
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6544 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-09- Reduced drop slots from 15 to 10.skotlex1-794/+784
- Updated mob_db.sql with the current data. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6539 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-09- Fix on pc_skill which fixes overlapping when one gets more than one bonus ↵skotlex2-1/+4
for the same skill. - Updated main.sql's loginlog table structure. - Added svn_update6533.sql to update the loginlog structure as suggested by theultramage. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6533 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-07removed old logsLupus1-120/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6510 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-05-06- Updated item_db.sqlskotlex1-109/+108
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6505 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-29- Added missing sql-files/mob_db.sql... somehow it was missing from the ↵skotlex1-823/+833
mob_db update. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6358 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-29- Modified the mob_db structure. The mvp related columns were moved to ↵skotlex1-50/+61
before the drops, amount of drops increased from 10 to 15. - Updated sql-files/mob_db.sql to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6354 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-27- Small change in the pet_ai that should stop the "strange" catch-up ↵skotlex1-2/+2
behaviour of pets when you are much faster than them. - Corrected the unequip script of the wedding dress/tuxedo (it should be Class, not bClass) - Changebase script command will also refresh the weapon sprites (in case you changed into Wedding/Xmas class) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6317 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-26- Updated item_db.sql to current.skotlex1-43/+43
- Some small code-cleanups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6298 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-24- Added new column to mob_db Sprite_Name to hold the mob's sprite name. ↵skotlex2-895/+926
Columns Name and JName now hold the mob's english and kro names respectively. - Currently both Name and Jname have the KRO names, so someone will have to update them. - Updated mob_db.sql and mob_db2.sql to latest. - Added battle_config option override_mob_names to make the spawned mob names use the mob_db names instead of the specified names in the spawn files. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6246 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-21Changed item_db2.sql to new formatPlaytester1-5/+7
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6212 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-20- Added two columns to item_db: equip_script and unequip_script are scripts ↵skotlex1-2474/+2568
that are executed once when the corresponding item is equipped or unequipped respectively. - Removed bonuses bDamageWhenUnequip, bLoseSPWhenUnequip - Updated sql-files/item_db.sql with latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6204 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-15- Fixed upgrade_svn5902.sql, thanks to Koshiro for pointing it out.skotlex1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6092 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-14- Updated sql-files/mob_db.sql to current.skotlex1-97/+97
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6062 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-14- Updated sql-files/item_db.sql to current.skotlex2-2477/+2475
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6056 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-09- Changed use of strtol to strtoll as strtol's result is just a signed int, ↵skotlex1-0/+1
and we need to parse values above 0x7FFFFFFF - Corrected Knives being usable by Gunslinger. SQL users use upgrade_svn5972.sql to ugprade that. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5972 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-08- Modified the equip_job field in the item_db to be a hexadecimal value for ↵skotlex2-1231/+1257
easier handling. - Updated item_db.sql to this new file format (even though it's equip_jobs field is still a integer) - Added upgrade_svn5951.sql for those who would like to convert their existing items. - Added doc/item_db.txt to explain each of the fields in db/item_db.txt git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5951 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-05- Added inter config connection_ping_interval which specifies interval in ↵skotlex1-0/+14
hours at which mysql_ping's must be done on all connection handles to keep the mysql connection alive. Defaults to 0 (disabled) - Removed login sql handle from the map server as it isn't used for anything. - Made the login sql handle on the char-sql server be used only when gm_read_method 1 is enabled. - Small fixes to npc_enable, added BL_NPC handling on status_get_sc. - Added a path_search check in map_random_dir, so that the random direction picked up doesn't goes through walls and all that. - Some changes to close-confine, status start will fail when the source is not found or it doesn't has sc-data. - pc_setoption no longer changes the character's class when mounting/dismounting, it only changes the view-class. - The peco-crash-fix from the char servers is still needed. This packet must be wrong! We likely need to sniff it. - Modified the char-txt server to modify the class of mounted characters to their non-mounted version. Added an upgrade_svn file to handle the class update on the sql tables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5902 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-04-01- Added upgrade_svn5834.sql to update view for item type 10.skotlex1-0/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5834 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-28- Added a debug function to locate all "looping warps"skotlex1-1/+1
- Some cleanup of the skill-use functions in clif.c git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5787 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-23- Updated mob_db.sql and item_db.sql to latest txt versions.skotlex2-646/+646
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5722 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-15- Added item_db2.sql and mob_db2.sql, thanks to Joshuaaliskotlex2-0/+151
- Added more usage of msg_athena on the slave atcommands. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5609 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-14- Fixed the average_lv column size specification. Thanks to Joshuaali ↵skotlex2-3/+4
(upgrade_svn5607.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5603 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-13- Corrected char-server parameters so that the subnet config file is the ↵skotlex1-2/+2
third parameter, not the second (which was conflicting with inter_athena.conf's argument), thanks to foobar. - Fixed TK and Soul Linker's position of their job entry in exp2.txt, thanks to Coltaro. - Fixed NPC_GRANDDARKNESS targetting the enemy instead of yourself in mob_skill_db. - Fixed Grandcross's hit and range entries in the skill_db (it had hit 5? that wasn't even a valid value from the description) - PR_BENEDICTIO now ignores mdef - Removed the status_isdead checks from status_check_skilluse, they are now done only on the skill_castend_* functions. - Fixed NPC_SELFDESTRUCTION not doing the correct damage to oneself. - Fixed chatlog's x/y column capacity. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5584 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-10- Fixed Valkyrie's shield script in item_db.sqlskotlex1-1/+1
- Added a warning on the char-server's name when it contains a space. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5547 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-09- Fixed a bug that was making the no_spawn_on_player setting useless.skotlex1-2/+2
- Added Deadly Poison and Bleeding to status_get_sc_def, meaning that now vit does increases defense against being inflicted from it. - Fixed a crash and an infinite loop in @whodrops @.@ - Expanded the item_db column sizes for the names to 50. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5526 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-08- Updated mob_db.sql and item_db.sql to latest.skotlex2-621/+719
- Modified mob_db's HP column to be an int. - Fixed the included global_functions file for the Kafra Express script. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5507 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-03-04- Some cleaning of the main.sql fileskotlex2-28/+30
- Added upgrade file 5455 to make the manner/karma columns signed. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5455 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-18- Added upgrade file upgrade_svn5322.sql because apparently not everyone has ↵skotlex1-0/+1
the guild table with autoincremental guild_id defined. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5322 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-17- Added an upgrade_svn file to fix the party sql table (it lacks the ↵skotlex2-1/+2
auto-increment property on the party_id column) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5311 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-16- Updated the login/char sql servers to let the sql tables autogenerate the ↵skotlex1-14/+0
new id, and then retrieve said id using mysql_insert_id rather than playing smart and loading the next insert ID on startup. - Tables affected are: account creation, char creation, party creation, pet creation and guild creation. - Also corrected some functions to be of type (void) rather than () git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5298 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-05- Updated sql-files/mob_db.sql to latest.skotlex1-809/+836
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5193 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-02-05- Merged some of the 'plug' items into the main item_dbskotlex1-2415/+2390
- Updated sql-files/item_db.sql to latest. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5191 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ↵Valaris29-0/+5050
GO INTO TRUNK. IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EVERYTHING ELSE GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5094 54d463be-8e91-2dee-dedb-b68131a5f0ec
2006-01-29Clearing trunk.Valaris17-4187/+0
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5091 54d463be-8e91-2dee-dedb-b68131a5f0ec