summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Collapse)AuthorFilesLines
2014-05-17Renamed incuvate of Pet System.Shido1-1/+2
2014-04-26Follow-up to 93584f7, Fixed issue with Character Creation, column doesn't ↵MrKeiKun1-1/+2
contain default value. Signed-off-by: MrKeiKun <the.keikun@gmail.com>
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-18Rewritten NSI_UNIQUE_ID system to get rid of the cross-database interreg ↵Ibrahim Hossam1-2/+1
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-03-25Added new return values to make_new_char_sqlpanikon1-0/+2
Added char_id to charlog Corrected RE check in skill_magic_reflect (see commit c9310f3)
2014-02-19Follow up 9132878d911cfe720eaad94ad3d4a5dd11958f99shennetsind1-1/+3
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-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-11Hercules 1st 2014 MegaPatchshennetsind1-17/+82
http://hercules.ws/board/topic/3886-hercules-1st-2014-megapatch/ Signed-off-by: shennetsind <ind@henn.et>
2014-01-08Introducing Hercules Autotrade Persistencyshennetsind1-0/+25
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-24Christmas Patch - 2013-12-23 Supportshennetsind1-0/+12
Info: http://hercules.ws/board/topic/3614-christmas-patch-gifto/ Signed-off-by: shennetsind <ind@henn.et>
2013-11-16Introducing Character Ban Support.shennetsind1-0/+2
@charban/@charunban, can temporarily block any accounts as opposed to the usual account-wide block. Special Thanks to Haruna, Yommy! Signed-off-by: shennetsind <ind@henn.et>
2013-11-15Updated `account_data` upgrade filesshennetsind1-0/+1
to avoid issues as demonstrated by report 7824 http://hercules.ws/board/tracker/issue-7824-exp-and-drop-rates-in-lat/ Special Thanks to Yommy! Signed-off-by: shennetsind <ind@henn.et>
2013-11-08Adjusted account-modifiers default values to 100.shennetsind1-3/+4
Special Thanks to Haruna, ossi0110. Signed-off-by: shennetsind <ind@henn.et>
2013-11-07Item Bound Fixes/Adjustments/Improvementsshennetsind1-0/+1
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/+4
Signed-off-by: shennetsind <ind@henn.et>
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 Supportshennetsind1-0/+2
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-27Shadows System Baseshennetsind1-4/+5
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 c5c3381Streusel1-0/+1
Thanks to QQfoolsorellina
2013-10-10Introducing Bank Supportshennetsind1-0/+16
http://hercules.ws/board/topic/2455-introducing-bank-support/ Thanks to Yommy, Haru! Signed-off-by: shennetsind <ind@henn.et>
2013-04-15Fixed Bug #7127shennetsind1-1/+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-03-27Introducing Slot Change featureshennetsind1-0/+2
Special Thanks to Yommy for providing the packet structure/data. Signed-off-by: shennetsind <ind@henn.et>
2013-03-09Hercules Renewal'd Pin Codeshennetsind1-1/+5
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-04Followup 0241d0195558b7e57d2181f2f097cf774a1ef463shennetsind1-0/+1
git's commit-per-line thing fooled me, it skipped this line. Signed-off-by: shennetsind <ind@henn.et>
2013-03-04Introducing account-dependent character slot countshennetsind1-0/+1
As requested in http://hercules.ws/board/topic/248-reserved-slot-system/ Signed-off-by: shennetsind <ind@henn.et>
2013-02-16Updated main.sql to reflect the latest `sql_updates` entriesshennetsind1-0/+1
Signed-off-by: shennetsind <ind@henn.et>
2013-02-15MySQL Update Checker: Updatedshennetsind1-1/+2
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 #5018shennetsind1-0/+3
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 Checkershennetsind1-0/+10
First version. Signed-off-by: shennetsind <ind@henn.et>
2013-02-04Getting rid of unused indexes.akrus1-11/+5
Source: http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3).
2013-01-08* Renaming variable name from nsiuid to unique_id for better understanding ↵markzd1-7/+7
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* Follow Up: r17080markzd1-0/+8
1. Removed an unnecessary update call. 2. Implemented interreg table at main.sql. * Follow Up: r17077, r17072, r17065 1. Fixed bugreport:7078, removed unnecessary checks. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17081 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07* Implemented Unique identifier for Non stackable items. (tid:69380)markzd1-0/+6
* 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-24* Custom Quest Shop updated to v1.6, which adds support for bulk purchases.euphyy1-1/+1
* Follow-up r17014, fixed a typo in main.sql -- credits to Jeroen for finding that. * Follow-up r17039, missed a parameter -- thanks, clydelion/mkbu95! git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@17040 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-12-11Happy Holidays and Happy 12/12/12 :)rud0lp201-6/+8
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-08-18Follow up r16663 added missing column to main.sql, superspecial thanks to ↵shennetsind1-0/+1
EvilPuncker for pointing out. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16664 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-08-07* Moved RE coordinates of Bullet/Magazine Dealers in Izlude, bugreport:6410euphyy1-0/+1
* Added "favorite" column to main.sql file, bugreport:6425 (sql-files\main.sql) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16595 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-07-24Made field `name` in `char` table unique to prevent 3rd party tools from ↵kenpachi2k111-1/+2
making our data messy. (bugreport:5587) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16490 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-21- Fixed a SQL error from r15885. (tid:62072)brianluau1-1/+1
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15896 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-20Initial support for Genetic, Sorcerer and Elemental Summons. Special Thanks ↵shennetsind1-0/+24
to 3CeAM for the base. Notice this revision onwards requires you to update your char sql table and add the elemental sql table (check sql-files/upgrade_svn15885_log.sql) If you step by any bugs, let us know at http://rathena.org/board/tracker/ Thank you very much. ARRIBA ARRIBA. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15885 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-13Follow up to r15572: renamed column `level` to `group_id` (`login` table) in ↵kenpachi2k111-1/+1
/sql-files/main.sql git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-12-05Merging RREmu into rAthena -- quite a few stuff yet to be renamed, but we'll ↵shennetsind1-1/+1
get it sorted. Some of the stuff included in RREmu that is now part of rAthena: - RE Drop Rate Modifier - RE Experience Rate Modifier - RE Weapon MATK - RE Shield ASPD job-specific penalty - RE Cast Time - Renewal-specific item DEF - 3.1 classes. - All-New Mounts - Official Magical Reflection - And other perks, such as fully-functional @mapflag also merged eAthena 15006 into rAthena. For Bugs, Comments and Suggestions: http://rathena.org/board/tracker/ git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@15009 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16* Added support for visible garments/robes.ai4rei1-0/+1
- For SQL apply upgrade_svn14797.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This also fixes NPCs not being visible with clients 2011-01-11aRagexeRE+ (bugreport:4865). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14797 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-04-16* Updated field `weapon` in table `char` to default to '0' (bare-handed) ↵ai4rei1-1/+1
rather than '1' (knife) (follow up to r11696). - Apply upgrade_svn14796.sql to reflect the change on existing setups. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14796 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-03-24- Removed extra <TAB> from const.txtbrianluau1-4/+4
- Changed the card columns in `cart_inventory` table to SMALLINT(11), to match other tables. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14759 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-08* Added support for new delayed character deletion.ai4rei1-0/+1
- Asks for birth date associated with the account and has a waiting time of 24 hours by default (setting). - For SQL apply upgrade_svn14700.sql to upgrade table `char`; for TXT no action is necessary, as it upgrades itself. - This completes support for clients 2010-08-03aRagexeRE and later. * Updated login sql engine version, missed during `birthdate` addition (follow up to r14672). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14700 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-01-14* Added 'birthdate' field to account data. For SQL apply ↵ai4rei1-0/+1
upgrade_svn14672.sql to upgrade table `login`; for TXT no action is necessary, as it upgrades itself. - Control panel developers are encouraged to enable players to modify this value, as it is required for new character deletion (2010-08-03aRagexeRE and later, not yet implemented). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14672 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-12-12* Removed `motd` from `ragsrvinfo` table in main.sql, missed in previous ↵ai4rei1-2/+1
commit (follow up to r14579). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2010-02-09Expanded range for cached and stored-in-db guild member exp (devotion) from ↵Paradox924X1-1/+1
uint32 to uint64. (bugreport:3983) Capped value when sending to client to INT_MAX to prevent confusion. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14242 54d463be-8e91-2dee-dedb-b68131a5f0ec