summaryrefslogtreecommitdiff
path: root/sql-files/upgrades
AgeCommit message (Collapse)AuthorFilesLines
2013-11-15Added item_db2.sql conversion script to the new structureHaru2-1/+107
- For those using a SQL item_db2, I provided a convenience script to update to the new structure without having to delete and re-import your data. - The script requires at least MySQL 5.0 (tested on MySQL 5.6) and works for both Pre-Renewal and Renewal tables. If you're running an older version (Oracle advises to upgrade for security reasons by the way!), open the upgrade script in your text editor, and you'll find the queries you can run manually instead. - Special thanks to Ind. Signed-off-by: Haru <haru@dotalux.com>
2013-11-10Update rAthena-main-upgrade.sqljaBote1-0/+5
Now it deletes all entries on the sc_data table since it's dangerous if we port the sc data as is. WARNING, this ends all active SCs on the previous server! Even jailed state!
2013-11-10Added rAthena to Hercules logs database upgraderjaBote1-0/+13
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
2013-11-10Added rAthena to Hercules main database upgrader.jaBote1-0/+80
This has been added because a lot of people were suggesting this on the forums. Check the news topic for more info: http://hercules.ws/board/topic/2906-introducing-rathena-to-hercules-database-converters/?p=19260
2013-11-08Adjusted account-modifiers default values to 100.shennetsind2-1/+7
Special Thanks to Haruna, ossi0110. Signed-off-by: shennetsind <ind@henn.et>
2013-11-07Further item bind adjustmentsshennetsind1-1/+1
Thanks to Haruna! Signed-off-by: shennetsind <ind@henn.et>
2013-11-07Item Bound Fixes/Adjustments/Improvementsshennetsind2-2/+5
Special Thanks to Haruna Signed-off-by: shennetsind <ind@henn.et>
2013-11-06Merge remote-tracking branch 'origin/master'shennetsind1-0/+4
Signed-off-by: shennetsind <ind@henn.et> Conflicts: conf/messages.conf src/common/mmo.h src/map/pc_groups.c src/map/pc_groups.h
2013-11-02Updated to latest Herculesshennetsind1-0/+1
Signed-off-by: shennetsind <ind@henn.et>
2013-11-02Merge remote-tracking branch 'upstream/master'shennetsind2-1/+4
Signed-off-by: shennetsind <ind@henn.et> Conflicts: sql-files/main.sql sql-files/upgrades/index.txt src/common/mmo.h
2013-10-31No error after compilation, but when logging in at map server it will crash.sevenzz231-0/+4
Im pretty sure its on the clif.c Signed-off-by: sevenzz23 <sevenzz23@yahoo.com>
2013-10-30Official Font Supportshennetsind2-1/+5
Fonts are now relog-persistent. Font items are now toggle-on/off, they no longer go away on use, they go away when their rental duration is over (and the font effect goes back to original). Special Thanks to Yommy for all the data! Signed-off-by: shennetsind <ind@henn.et>
2013-10-30Account-wide Exp/Drop/Death Modifiersshennetsind2-1/+7
Attempting to mimic the official as suggested in http://hercules.ws/board/topic/250-official-vip-system/ The variables can be read and modified thru scripting as well as sql, the patch introduces 3 new pc-arams 'ModExp','ModDrop' and 'ModDeath' for that purpose. The OnLogin modifier display is not the real deal though -- wasn't able to get it to output properly (though that might have been my client files failt) Up for review. Signed-off-by: shennetsind <ind@henn.et>
2013-10-27Shadows System Baseshennetsind2-1/+8
http://hercules.ws/board/topic/581-implement-the-shadows-system/ Special Thanks to Yommy for all the client data, Haru for making it possible to get it out and rosfus for the details on the feature. Shadows Feature requires packetver 20120925 or newer. ---------- Also: Updated all packets related to the shadows system, improved memory/processing of inventory/cart/storage/viewequip packets Signed-off-by: shennetsind <ind@henn.et>
2013-10-10Follow up c5c3381b0b8b0b59c669d474acf749db82d7edb1shennetsind2-1/+9
Missed account_data table in the upgrade file, thanks to ossi0110 Signed-off-by: shennetsind <ind@henn.et>
2013-10-10Introducing Bank Supportshennetsind2-0/+4
http://hercules.ws/board/topic/2455-introducing-bank-support/ Thanks to Yommy, Haru! Signed-off-by: shennetsind <ind@henn.et>
2013-09-16Corrected line endings and BOM issues with several filesHaru8-8/+8
- Ensured final end-of-line character in every file. - Corrected cases of mixed line endings (mostly CR and CRLF within the same file.) - Removed extra BOM from some scripts, since it causes a parsing error. Signed-off-by: Haru <haru@dotalux.com>
2013-04-27Fixed missing default in upgrade fileshennetsind1-1/+1
All credits to kyeme! thank you! Signed-off-by: shennetsind <ind@henn.et>
2013-04-15Fixed Bug #7127shennetsind1-0/+4
Also Implemented allow party invitations state. Implemented saving of client options (atm show_equip and allow party invitation) http://hercules.ws/board/tracker/issue-7127-view-equipment/ Signed-off-by: shennetsind <ind@henn.et>
2013-04-15Fixed Bug #7154shennetsind2-1/+5
http://hercules.ws/board/tracker/issue-7154-equipment-based-skills-skill-891-for-example-persisting-through-resetsremoving-gears/ Merge of 3a9bacc515674885f079391899b22a5ccd8c2e31 Special Thanks to akinari1087 http://hercules.ws/board/topic/410-skill-script-command-updatefix/ Signed-off-by: shennetsind <ind@henn.et>
2013-04-11* Added remaining Malangdo coin traders.euphyy1-1/+1
* Renewal item database update: -- Implemented nearly all remaining Malangdo items. -- Added Upg_* boxes (follow-up r17180). -- Corrected many kRO names. * Updated Renewal item_trade database for Dewata, Malangdo, and Upg_* boxes. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17186 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-27Introducing Slot Change featureshennetsind1-0/+3
Special Thanks to Yommy for providing the packet structure/data. Signed-off-by: shennetsind <ind@henn.et>
2013-03-17Follow up 7436a70cde2220c42cd249cee6368d308b0bd040shennetsind1-2/+4
Added in-file instructions Signed-off-by: shennetsind <ind@henn.et>
2013-03-17Adding eAthena -> Hercules SQL Upgrade Fileshennetsind1-0/+76
As Requested in http://hercules.ws/board/topic/273-sql-upgrade-files-not-exits/ Signed-off-by: shennetsind <ind@henn.et>
2013-03-09Hercules Renewal'd Pin Codeshennetsind3-2/+10
Feature is not, I repeat, NOT complete. the decryption is not fully functional which leads to dial values different from the ones the player used. Credits: lemongrass3110 for the base yommy for the packets LightFighter for the decrypt function (altho its not stable :P) Signed-off-by: shennetsind <ind@henn.et>
2013-03-06Updated dewata to match the official scripts.lemongrass31101-0/+7
This commit includes a optional SQL upgrade file, that will reset all the dewata quests and the related variables, that your users have done. Thanks to Euphy for helping me and additionally thanks to Flaid for taking his time to test our conversion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17178 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-04Introducing account-dependent character slot countshennetsind2-1/+5
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/ Signed-off-by: shennetsind <ind@henn.et>
2013-02-15MySQL Update Checker: Updatedshennetsind2-1/+5
Added a primary key to the `sql_updates` table (special thanks to Trojal) Modified the parser to ignore new/empty lines and added support for "//" comments in the index file. Signed-off-by: shennetsind <ind@henn.et>
2013-02-14Fixed Bug #5018shennetsind2-0/+8
Skills granted through scripts are now permanent, until this date they were not relog persistent Signed-off-by: shennetsind <ind@henn.et>
2013-02-14Introducing MySQL DB Update Checkershennetsind19-89/+0
First version. Signed-off-by: shennetsind <ind@henn.et>
2013-02-08Reverting 4b41901d3ecb01930a57e9b1d230e729d5feba38shennetsind1-1/+0
I was using a different git client when I committed that, and it committed all my unstaged changes, not using that client anymore :[. Signed-off-by: shennetsind <ind@henn.et>
2013-02-08Fixing a logical issue in ST_RIDINGshennetsind1-0/+1
2013-01-08- Added svn:eol-style=native property.brianluau2-26/+26
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17087 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08* Renaming variable name from nsiuid to unique_id for better understanding ↵markzd1-0/+11
of its meaning, as requested on tid:69380. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07* Implemented Unique identifier for Non stackable items. (tid:69380)markzd1-0/+16
* Set as off by default, it can be changed in /src/config/core.h. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-11Happy Holidays and Happy 12/12/12 :)rud0lp201-0/+9
Update Elemental summon to its official behavior - Fixed missing skill features of Ventus(bugreport:6792,bugreport:6723,bugreport:6511) - Note: upgrade_svn17014.sql - And other elemental skills are to follow :) Fixed bugreport:6889 updated const.txt where it cause error to some items. Fixed bugreport:6999 where matk damage deals miss atk to plant type targets. Fixed status calculation where it doesn't give accurate result or how official calculation does. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17014 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-22-Apply EvilPuncker path from tid:71756glighta1-0/+1
-Fix and upd logzeny enumeration type bugreport:6897 -Upd @zeny to send a message when succed bugreport:6886 -Upd ChaosPanic to affect all bugreport:6893 -Upd bloodylust cooldown and disable endure effect bugreport:6547 git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16940 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-30- Added svn:eol-style=native property.brianluau1-2/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16844 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-22- Follow up r16824.j-tkay1-1/+2
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16825 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-10-22Forgot to add the upgrade sql file for the Small DB change to item_db_re.sql ↵spre1231-0/+1
Changing Defence from unsigned to accept negative Value do to some items having negative values. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16824 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-09-06sql-files folder redesign as discussed with other developers, all upgrade ↵shennetsind13-0/+50
files prior to rathena were removed (if you need them you can use the trac or download a earlier version of the folder). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16750 54d463be-8e91-2dee-dedb-b68131a5f0ec
generated by cgit v1.2.3-70-g09d2 (git 2.46.0) at 2024-11-07 18:04:49 +0000