summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2014-08-06ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
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>