summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2014-07-22Update rAthena-main-upgrade.sqljaBote1-9/+43
Updating to adapt the database from current latest rAthena server. Couldn't test since I haven't got a test database right now, but looks good enough. Any issue should happen with it, please address me at Hercules forums rather than here.
2014-07-22Update rAthena-logs-upgrade.sqljaBote1-4/+13
2014-07-17Fixed minor issues in the sql files from 3ecf877bHaru2-29/+29
Signed-off-by: Haru <haru@dotalux.com>
2014-07-10Updated sql-upgrade files.Shido25-225/+242
2014-07-10Organized sql-tools.Shido3-34/+34
2014-07-10SQL Re-Organization.Shido8-1051/+1080
Signed-off-by: KeiKun <the.keikun@gmail.com>
2014-06-26ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-26ItemDB SQL SyncHercules.ws1-57/+57
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-18ItemDB SQL SyncHercules.ws1-11/+11
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31Removed Quotes from mob_skill_db.sql and mob_skill_db_re.sqlDastgir Pojee2-12374/+12374
This fixes Error Code #1064 (Reference: http://hercules.ws/board/topic/5802-mysql-mob-skill-dbsql/) Also saves a bit CPU load to convert quotes to numbers.
2014-05-31ItemDB SQL SyncHercules.ws3-14445/+14472
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws3-84/+99
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-23Update rAthena-main-upgrade.sqljaBote1-0/+5
Following up 3591de7e7ac2db4e3eeaa9bad2615648e7f94b3a. Upgrader should be up to date as of now.
2014-05-18Follow-up 5f5380e and a42f880e, Fixed crappy coding with sql-update ↵Shido1-1/+1
file(Special thanks to QQfoolsorellina)
2014-05-17Follow-up to 5f5380e8d5fa2e6042813e35101cb33b656e3972Haru1-1/+1
- Fixed a missing semicolon in the upgrade script. Special thanks to QQfoolsorellina Signed-off-by: Haru <haru@dotalux.com>
2014-05-17ItemDB SQL SyncHercules.ws1-1394/+1538
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-17Renamed incuvate of Pet System.Shido3-1/+6
2014-05-13Fixed some charset issuesHaru1-1/+1
- Fixed files with mixed character set or invalid CP949 characters. - Uncommented '#music' script in the_sign_quest.txt (now the soundeffect filename should be fixed). - Added a note to the header of CP949 files not to read or save them as UTF8, since it'd break their encoding. It should be safe enough to read them as EUC-KR if your text editor doesn't offer CP949 as an option. - Added FIXME notes about untranslated strings in assassin_skills.txt and WolfchevLaboratory.txt. Signed-off-by: Haru <haru@dotalux.com>
2014-05-13Fixed several files with a missing EOL at EOFHaru12-12/+12
- All text files should end with an EOL. Period. - See http://robots.thoughtbot.com/no-newline-at-end-of-file for info on how to configure the most common text editors to do it automatically for you. Signed-off-by: Haru <haru@dotalux.com>
2014-05-13ItemDB SQL SyncHercules.ws1-1651/+1507
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-08ItemDB SQL SyncHercules.ws1-3320/+3464
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-04-26Follow up c1f1ca708d54jaBote1-2/+5
Updated rAthena to Hercules database upgrade to latest main files.
2014-04-26Merge pull request #277 from MrKeiKun/fix_char_makeHaruna3-2/+7
Fixed issue with Character Creation
2014-04-26Follow-up to 93584f7, Fixed issue with Character Creation, column doesn't ↵MrKeiKun3-2/+7
contain default value. Signed-off-by: MrKeiKun <the.keikun@gmail.com>
2014-04-25ItemDB SQL SyncHercules.ws1-2138/+2192
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-04-20Follow-up to dd49dbc3e8, added missing main.sql entryHaru1-1/+1
Thanks to QQfoolsorellina Signed-off-by: Haru <haru@dotalux.com>
2014-04-19Merge pull request #272 from hemagx/masterHaruna3-3/+6
Rewritten NSI_UNIQUE_ID system
2014-04-19ItemDB SQL SyncHercules.ws1-10/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-04-18Rewritten NSI_UNIQUE_ID system to get rid of the cross-database interreg ↵Ibrahim Hossam3-3/+6
dependency - Removes the need for map-server to access the interreg table to store the last used ID. - Login, char and map databases can now be hosted separately. - Note: the unique_id structure has changed, and it now contains the generator character ID in its upper 32 bits. - Now NSI_UNIQUE_ID System is enabled always Special thanks to Haruna.
2014-04-01Fixed issue 8128 - Updated and reorganized MySQL engine converters ↵panikon2-10/+32
http://hercules.ws/board/tracker/issue-8128-missing-update-to-tables-in-tools/
2014-03-31Updated documentation for pc_statusup2 and pc_statusuppanikon1-1/+2
(fixed issue: 7916 http://hercules.ws/board/tracker/issue-7916-wrong-comment-in-pc-statusup2/) Now pc_statusup2 returns stat increase amount as stated in previous documentation Updated *statusup documentation it was wrong Added last update in upgrade index @console.c/.h Documented partially Now two different parsing categories can have functions with same name e.g. - server exit - sql exit
2014-03-26Update rAthena-main-upgrade.sqljaBote1-1/+6
Following up latest commit that alters the database (4b1cc23085b858364a332bdf03d634656778b1e6). Logs converter isn't needing an upgrade yet.
2014-03-25Added new return values to make_new_char_sqlpanikon2-0/+5
Added char_id to charlog Corrected RE check in skill_magic_reflect (see commit c9310f3)
2014-03-22Fixed issue 7338 (added new char configuration char_aegis_delete)panikon2-2/+2
http://hercules.ws/board/tracker/issue-7338-deleting-character/ As @jaBote requested in 26f2ada, renamed "rathena-logs-database-upgrade" to "rAthena-logs-upgrade.sql" and updated 'last revision'. Added a 'FIXME' in db_obj_put
2014-03-21Update rAthena-main-upgrade.sqljaBote1-27/+231
Added in the differences from some months ago. Very special thanks to @dastgirpojee for the autotrade saving script! None of us could test with actual data, so feel free to try it and point out any flaws you can see.
2014-02-19Follow up 9132878d911cfe720eaad94ad3d4a5dd11958f99shennetsind3-2/+9
Fixed issue (8023) with sc rows (only those of tick = -1, aka permanent scs) duplicating due to lack of primary index. Special Thanks to Flash, Haru. Note that the upgrade script will clear the permanent statuses from your sc_data table (e.g. lex aeterna, carts) to ensure no issues are left. Signed-off-by: shennetsind <ind@henn.et>
2014-01-16ItemDB SQL SyncHercules.ws1-0/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-01-15Added some missing entries to the sql upgrades table in main.sqlHaru1-20/+22
- Follow-up to 9928044b, 4655f661 - Special thanks to Mumbles Signed-off-by: Haru <haru@dotalux.com>
2014-01-13Updated SQL mob database (re and pre-re)Haru2-394/+1026
- Special thanks to Emistry for reminding us. - Added a comment to inter-server.conf to discourage relying on those sql databases for scopes other than control panels and such, unless you really know what you're doing. Signed-off-by: Haru <haru@dotalux.com>
2014-01-11Hercules 1st 2014 MegaPatchshennetsind3-17/+144
http://hercules.ws/board/topic/3886-hercules-1st-2014-megapatch/ Signed-off-by: shennetsind <ind@henn.et>
2014-01-09Merge branch 'master' of https://github.com/HerculesWS/Herculesshennetsind2-679/+679
2014-01-08Introducing Hercules Autotrade Persistencyshennetsind3-1/+43
Aka autotrading merchants survive server restarts. Originally sekai's (aka me). Special Thanks to Haruna, Michieru. Signed-off-by: shennetsind <ind@henn.et>
2013-12-30ItemDB SQL SyncHercules.ws2-679/+679
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-24Christmas Patch - 2013-12-23 Supportshennetsind3-0/+21
Info: http://hercules.ws/board/topic/3614-christmas-patch-gifto/ Signed-off-by: shennetsind <ind@henn.et>
2013-12-18ItemDB SQL SyncHercules.ws2-19/+19
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-12-17ItemDB SQL SyncHercules.ws2-679/+679
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-28ItemDB SQL SyncHercules.ws1-60/+60
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-25ItemDB SQL SyncHercules.ws2-14234/+14234
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-18ItemDB SQL SyncHercules.ws1-11/+11
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2013-11-18Follow-up to 1f5161a2bd3c7934373146d8cac3c131536758baHaru2-1/+67
- Added explicit column names in the item_db query, to ensure it will throw a SQL error in case some are missing, rahter than silently failing and returning incorrect data. - Added sql upgrade file to add the bindonequip column to the item_db2 table for those who have it. - As with all the item_db2 upgrade scripts, you need at least MySQL 5.0 in order to run it. If your version is not compatible, or if the script fails for any reason, manual upgrade instructions are provided within the script. - Special thanks to Mumbles. Signed-off-by: Haru <haru@dotalux.com>
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-07-11 05:06:44 +0000