summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Collapse)AuthorFilesLines
2018-01-25Implementation of Official Clan SystemMurilo Pereti Tavares1-0/+4
All official features work including the autokick for inactive members And the system is completely customizable.
2017-11-18Implement Homunculus autofeedingAsheraf1-0/+2
2017-07-30Implementation of RoDEXKirieZ1-1/+54
2017-04-04Implementation of Item Options System.Smokexyz1-9/+71
Allows the infusing of equipments with bonus item options. This feature is constrained to clients of packet versions greater than or equal to `20150226`. Item Options and their effects are defined server-side in `db/item_options.conf` and client side in `data/luafiles514/lua files/datainfo/addrandomoptionnametable.lub` The ID of the option must tally with the correct index of the description provided in the client side lua file to avoid bugs. IT_OPT_* keys and MAX_ITEM_OPTIONS macro are also exported from the source as constants. An additional flag `disable_options` has been added to sql, and as `DisableOptions: true/false (boolean, defaults to false !!for equipments only!!)` to item_db.conf files. Script commands documentation is also included. SQL file updates are included. Credits: [Smokexyz](https://github.com/Smokexyz) Style and Script Fixes by [Asheraf](https://github.com/Asheraf) Initial design Idea by [secretdataz](https://github.com/secretdataz)
2016-10-26zenylog missing type 'K' for Bank TransactionsSmokexyz1-0/+1
Fixes bug filed here - http://herc.ws/board/topic/13618-db-error-data-truncated-zenylog/
2016-10-22Added Summoner Class.Dastgir Pojee1-1/+3
(Only Placeholder, other things related to summoner will follow-up soon) Added SQL-Upgrade: Added `class` column in charlog
2016-07-08Add sql upgrade scripts for convert date/datetime default values.Andrei Karas1-0/+2
2016-07-07Replace in sql files fields with default date/datetime into default NULL.Andrei Karas1-6/+6
2016-03-14Add missing update into main.sql.Andrei Karas1-0/+1
2016-01-09typo fix in main.sqlDastgir1-1/+1
2016-01-05Fix battle config Hp/Sp overflow valueAnnieRuru1-5/+6
- client can't handle value over 21474836 - SQL also can't save value over 16777215 due to mediumint unsigned Closes #965 as merged Signed-off-by: Haru <haru@dotalux.com>
2016-01-05Added Support for BodyStyleDastgir1-0/+2
Closes #974 as merged
2015-12-15Added GPL-compliant header to sql filesHaru1-0/+19
Signed-off-by: Haru <haru@dotalux.com>
2015-09-17Added redundancy to some SQL statements.GammCrucis1-35/+34
Closes #641 Signed-off-by: Haru <haru@dotalux.com>
2015-08-27Hotkey Rotate Packet ImplementedDastgir1-0/+2
2015-08-10Corrected an issue with the last SQL updateHaru1-0/+1
- Follow-up to 8caa0e564b5331a88d8dc1712513368b37ba9694 - It's safe to re-apply the related sql update script (sql-files/upgrades/2015-07-08--13-08.sql) in order to get rid of the 'detected 1 new SQL updates' message. - Thanks to KirieZ Signed-off-by: Haru <haru@dotalux.com>
2015-08-09Removed unused tables sstatus and interregHaru1-20/+0
Signed-off-by: Haru <haru@dotalux.com>
2015-07-08Update Unique ID system to match official now it cover all cash items ↵Ibrahim Hossam1-0/+1
include stackable ones. Implement ForceSerial option in Package Item Database to force serial for any item. Implement ForceSerial option in item database to force serial for any item. Implement Merge Client interface to merge stackable items with serial numbers ( check npc/other/item_merge.txt ).
2014-11-04Added missing sql_updates query in main.sqldastgir1-0/+1
2014-11-03Introducing 2014-10-22, Roulette and Per-Char Gender!shennetsind1-0/+1
Details in http://hercules.ws/board/topic/7618-2014-10-22-roulette-and-per-char-gender/ Special Thanks to the all-mighty Yommy, Ziu and Haruna! Signed-off-by: shennetsind <ind@henn.et>
2014-09-02Fixes wrong data type in SQL for base_exp,base_drop and base_death.Dastgir1-3/+4
2014-07-17Fixed minor issues in the sql files from 3ecf877bHaru1-11/+11
Signed-off-by: Haru <haru@dotalux.com>
2014-07-10SQL Re-Organization.Shido1-540/+540
Signed-off-by: KeiKun <the.keikun@gmail.com>
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>