61 Commits

Author SHA1 Message Date
Lemongrass3110
38b8d5a994
Initial release of item package selection (#7239)
Thanks to @aleos89 and @Atemo

Co-authored-by: Atemo <capucrath@gmail.com>
Co-authored-by: Aleos <aleos89@users.noreply.github.com>
2022-09-12 22:06:04 +02:00
Lemongrass3110
001981cf66
Initial implementation of enchantgrade UI (#6913)
Includes walkscript conversion of kRO scripts

Thanks to @Asheraf, @Balferian, @JohnnyPlayy, @aleos89, @Atemo, @eppc0330 and @Pokye.

Co-authored-by: JohnnyPlayy <lenon32@gmail.com>
Co-authored-by: Asheraf <Asheraf@users.noreply.github.com>
Co-authored-by: Balferian <balfear@yandex.ru>
Co-authored-by: Aleos <aleos89@users.noreply.github.com>
Co-authored-by: Atemo <Atemo@users.noreply.github.com>
2022-06-07 16:45:35 +02:00
CairoLee
2172bb835d
Update the comment of Log System and Fixed stylist logging (#6776) 2022-04-01 09:45:01 +02:00
Lemongrass3110
08192a35bc
Revamped Laphine UIs (#6625)
Fixes #3302
Closes #4348

Thanks for the initial release by @Cydh in #4348 and everyone that contributed to it.

All existing data was migrated and cleaned up where necessary.
Thanks to @Everade for his help here.

Laphine UIs are now fully yamlified and not dependent on the script engine.
They make use of new item group features and of the already existing random option group feature.
This way they will be far easier to be maintained, even though they are a little less customize able.

Thanks to @limitro, @CairoLee, @dimasshotta and everyone else who contributed!

Co-authored-by: Cydh <cydh.ramdh@gmail.com>
Co-authored-by: Everade <Everade@users.noreply.github.com>
Co-authored-by: Aleos <aleos89@users.noreply.github.com>
2022-02-22 21:52:27 +01:00
Lemongrass3110
e40da669ed
Initial release of barter shops (#6508)
Fixes #5062

Thanks to @Atemo and @aleos89

Co-authored-by: Atemo <Atemo@users.noreply.github.com>
Co-authored-by: Aleos <aleos89@users.noreply.github.com>
2022-01-21 00:59:16 +01:00
Lemongrass3110
3a8e4ffbc7
Improved support for enchantgrade (#5975)
Added further support for enchantgrade so that the enchantgrade is not lost during certain processes and can be accessed via script commands.
Also added missing logging support for it.
2021-05-30 00:44:50 +02:00
Vincent Stumpf
3776bfbaa3
Support itemids up to ~2 billion (#5141)
Co-authored-by: aleos89 <aleos89@users.noreply.github.com>
Co-authored-by: Lemongrass3110 <lemongrass@kstp.at>
2020-08-08 12:06:07 +02:00
Aleos
3b7fbb0d5f
Reverted 8a504c6 (#3593)
* Guild Storage Log isn't a normal admin log since it's a client feature so it shouldn't be stored with the other logs.
2018-10-19 13:39:35 -04:00
Maz-V
8a504c6905 Corrected Guild Storage Log SQL file (#3577)
* Moved guild_storage_log to the logs.sql and appended the "_log" suffix to the upgrade file.
Thanks to @mazvi!
2018-10-17 14:30:43 -04:00
Lemongrass3110
8dea04a8b3
Initial release of private airship system (#3354)
Fixes #3314 

Thanks to @aleos89 for his help.
2018-07-29 20:11:15 +02:00
Lemongrass3110
fe7c0a78ec
Refactored roulette system (#3271)
Fixes #2887 - thanks to @Everade
Fixes #3292 - thanks to @admkakaroto

Added a script command to open the roulette window from server side.
Added support for clients >= 2018-05-16
Fixed losing behavior for roulette
Enabled roulette system by default
Added a server side delay
Added missing sql log enum value 'Y'

Thanks to @Everade, @admkakaroto, @V0rr, @ecdarreola, @Haikenz and everyone else who contributed to this.
2018-07-06 22:39:58 +02:00
Jittapan Pluemsumran
f20ac015d1 Fixed random options with negative values being stored as 0 in database. (#2465)
* Made random option database columns signed
* Negative values can now be stored for random options
* Fixed #2415
Thanks to @uddevil

* Follow up to ea28ff4. Updated main SQL scripts.
2017-10-02 09:05:41 +07:00
Lemongrass3110
799f781ac2 Fixed MySQL 5.7 compatibility (#2074) 2017-05-02 22:59:05 +02:00
aleos
6c0debb9ba Increased the integer storage type for EXP
* Adjusted the homunculus and mvplog tables to support increased EXP amounts.
2017-02-18 15:30:29 -05:00
Lemongrass3110
958476f6ce Repaired line endings in logs.sql 2017-01-14 19:32:14 +01:00
vstumpf
11f0a1f9d1 Clan Chat logging is now available 2017-01-14 17:47:36 +01:00
Jittapan Pluemsumran
f296409ada
Initial Release of Random Option System
* Added basic support for random option system
* Don't forget to import upgrade_20160814.sql and upgrade_20160814_log.sql to make your existing rAthena installation functional!
2016-08-14 22:21:07 +07:00
Cydh Ramdh
d1c40d644c Updated .sql DB files.
* Follow up a1f59c6a0fa030cb10014ed09c395e9bfb41a95d
* Follow up 08ea77a99379e5753c120d2f8c8bb57912e7ef94, normalize ending-lines.

Signed-off-by: Cydh Ramdh <cydh@pservero.com>
2016-08-03 00:12:43 +07:00
Lemongrass3110
de1bc36a7a Revert "SQL synchronization"
This reverts commit e49cba5ceee5ae0d670f67f0505fe6d5d8a141cb.

Sorry I really do not know why or how this came into master... >_<
2016-06-28 00:05:15 +02:00
rAthenaAPI
e49cba5cee SQL synchronization
[ci skip]
2016-06-27 21:58:29 +02:00
Lemongrass3110
879ddcc1af Feeding log feature
Merged the feeding log feature requested by @MrAntares and implemented by @cydh in cydh/rathena@3f35e3a.

Don't forget to create the new SQL log table.
2015-12-30 12:48:44 +01:00
Atemo
3f795c4175 Update of pull #572
Organized the table creation statements by alphabetical order.
Added some redundancy to some SQL statements.
2015-11-16 20:34:05 +01:00
aleos89
039e1b65a3 Quest System Update
* Added support for the new quests that grant item drops from mobs.
2015-09-17 13:24:42 -04:00
Cydh Ramdh
e1b658e462 * Item GUID Updates:
* Removed `ENABLE_ITEM_GUID` from src/config/core.h, after long time introduction it's worth to be enabled by default. Just remove all items with GUID flag if want to remove it generates GUID .
  * Implemented client interface to merge the items. Packet struct credits: 856b6f1feb
  * Edited `mergeitem` script command to use the interface, moved the 'old' `mergeitem` to `mergeitem2`.
  * Fixed the behavior to add GUID'd item to inventory in Cash Shop.
  * Updated item_flag.txt for listing `IT_CASH` items (item type 18).
  * NOTE: `IT_CASH` items which defined in item_flag.txt with flag `4`, cannot be merged.
  * NOTE: Please check the packets for older clients. Tested work on 2012-04-10, 2013-08-07 and 2014-10-22.
  * NOTE: Please import 'upgrade_20150804.sql' for MySQL Log Database.
* Removed duplicate clif functions:
  * `clif_msgtable()` -> `clif_msg()`
  * `clif_msgtable_num()` -> `clif_msg_value()`
* Item DB Updates:
  * Indonesia_Box2 (17079) should gives 5x Wing_Of_Butterfly (602).
  * Changed some item types to 18.

Signed-off-by: Cydh Ramdh <cydh@pservero.com>
2015-08-04 20:57:49 +07:00
Cydh Ramdh
5ed75dc877 * Merge pull request #294 and its clean up
* Moved Bank Vault from `login` table (login-server level) to `global_reg_value` as #BANKVAULT (char-server level)
  * IMPORTANT: Read & import upgrade_20150408.sql
* Follow up cbdc0127, another fix for Point Shop NPC.
* Follow up 022d7289, corrected picklog initial for bound items that removed when member of guild/party or guild/party is broken. Please import upgrade_20150408_log.sql

Signed-off-by: Cydh Ramdh <cydh@pservero.com>
2015-04-09 01:26:17 +07:00
Cydh Ramdh
9b4d922ef4 Bug Fixes:
* Follow up 2d2991a, remove trailing spaces in inter_athena.conf
* Added `bound` field on `picklog` table (bugreport:9240) Thank @icxbb-xx (Napster)
* Fixed Randomize Spell infinite loop. Failure of skill improvise db reading. (bugreport:9288)
* Added **max_extended_aspd** for caping max ASPD for KO/Rebellion, default is 193. Pointed by @raynra & Ziu
* Mail attachment
  * Added `bound` field on `mail` table, since group with PC_PERM_TRADE_BOUNDED can put bound item into attachment
  * Fixed wrong data type causing wrong zeny amount (bugreport:9291)
* Fixed item color issue for bound item (bugreport:9238)
  * Stackable item shouldn't be displayed as yellow color
  * Equip doesn't shown as yellow after relog or item is moved
* Silence status immunity for Renewal (bugreport:9227)
  * Bleeding (SC_BLEEDING): Vit -> Agi
  * Silence (SC_SILENCE): Vit -> Int
  * Sleep (SC_SLEEP): Int -> Agi
  * Thank @Playtester, @Lilith-, partial merge of Hercules:6f26451
* Fixed status check when cast a skill to hidden target
  * Stone Curse shouldn't be casted to hidden enemy when the caster has intravision (bugreport:9266)
  * Added **INF3_HIT_HIDING** for skills that *maybe* have effect to/can hit the hidden target. Previously, every Earth Element skills *always* had it, doesn't matter ground skill or single-target skill
  * **!TODO: Confirm other skills that have ability for this!**
  * **!FIXME: For now, I rely as the previous check did, I put some Earth Element skills (and) with area/ground effect**
* Correcting Devotion behavior (Hercules:e7be725, 41f28c0)
  * Failing to cast Devotion to the 6th player
  * Only player who devotes other that 'shout' Auto Guard when it active also with the walk delay
  * Status icon that inherited from devoter won't be displayed at devoted player
  * Reflect Damage on devoted player won't reflect normal attack, only melee skill attack
  * Added config **devotion_rdamage_skill_only** for backward compability, ignore the behavior above

**IMPORTANT**
  * Please import sql-files/upgrades/upgrade_20140915_log.sql
  * Please import sql-files/upgrades/upgrade_20140915.sql

Signed-off-by: Cydh Ramdh <house.bad@gmail.com>
2014-09-15 18:02:49 +07:00
Cydh Ramdh
a8f239fc88 Bug Fixes:
- Client stuck while deleting char (bugreport:9101), thank leke
- Wrong check at pc_is_same_equip_index() triggers double damage for two-handed weapon (bugreport:9124), thank Myskelz & Anacondaqq
- Follow up 3d27b7e, Item avail check for npc_cashshop_buy() (bugreport:9122), thank Napster
- Missing enum 'K' for LOG_TYPE_BANK at `zenylog` (bugreport:9122), thank Napster

Signed-off-by: Cydh Ramdh <house.bad@gmail.com>
2014-07-13 12:46:41 +07:00
aleos89
7cd82d00db Increased item ID array size.
- Increased limit from 32,767 to 65,535.
- Still uses same amount of memory with doubled usable size.
- Adjusted CARD0_PET from -256 to 256.
- Please run both SQL files after applying this update to avoid values becoming corrupt.
- Tested and works on clients 2012-04-10 and up thanks to Cydh.
- Removed an unused SQL file.
2014-06-12 11:29:10 -04:00
glighta
eb013a6d5e -Fix bugrepot:7609 fix picklog enum (add cashshop type)
-Fix bugreport:7615 freeze after closse by Secure timer, also fix "Unable to restore stack! Double continuation!" case (when dead by mob talking to npc)
-Upd secure timer, now stop timer when we already in close/end state.
-Fix st_>mes_active case where var wasn't refresh but dialogue was ended 
-Add packet support for ZC_ITEM_PICKUP_ACK_V5 (0x990), (0x0897,0x093F,0x0886,0x035f) (Hercule/Shaktoh)
-Cleanup too duplicate, too wide comment

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17303 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-29 05:51:36 +00:00
lemongrass3110
386f0ae36e Cashshop support
Since our neighbors were a little earlier with releasing the cash shop system, here is our version of it.
It supports TXT and SQL databases and even features kafra point support.
Don't forget to run your SQL updates, since this feature needs another log table for your own security. ;)

Follow up to r17240 finalizing pincode feature. Should be stable now - no beta anymore. Fixes bugreport:7505

Fixed guild creation bug bugreport:7502

Implemented the new NPC range tid:81303

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17242 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-04-10 02:09:34 +00:00
glighta
3f28476cd2 -Alpha release for eleanor skill (use with caution)
--Implement : MH_TINDER_BREAKER, MH_CBC, MH_EQC, MH_SONIC_CRAW, MH_SILVERVEIN_RUSH, MH_MIDNIGHT_FRENZY
--Fix style_change not giving sphere when eleanor attacking, and auto set to fighting mode when created.
--Add display msg to know in wich mode we are.
--Remove state check not working well with homon since ??
--Upd MH_SUMMON_LEGION to use summon mob declaration rather then real mob, and set them as agressive by default

-Mob doesn't have fixed casttime anymore bugreport:5697
-Fix few typos
--Enforce logs.sql to check if table not existing. (remove fail at import)
--fix bloodylust effect (temp)
--slave now return final master when killing mob

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17182 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-03-08 10:30:52 +00:00
markzd
fcf360da41 * Renaming variable name from nsiuid to unique_id for better understanding of its meaning, as requested on tid:69380.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17086 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-08 05:31:06 +00:00
markzd
de6af1fc0b * Implemented Unique identifier for Non stackable items. (tid:69380)
* Set as off by default, it can be changed in /src/config/core.h.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@17080 54d463be-8e91-2dee-dedb-b68131a5f0ec
2013-01-07 05:13:54 +00:00
glighta
805aedeff0 -Apply EvilPuncker path from tid:71756
-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://svn.code.sf.net/p/rathena/svn/trunk@16940 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-11-22 01:13:28 +00:00
eathenabot
490bd54958 * Merged changes up to eAthena 15086.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15926 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-04-22 17:10:52 +00:00
eathenabot
ea46e779c0 * Merged changes up to eAthena 15084.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15818 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-03-31 22:30:30 +00:00
kenpachi2k11
01dd34803c Follow up [rev=15252]: Updated comments in sql-files/logs.sql according to conf/inter_athena.conf default settings.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15543 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-02-06 16:35:38 +00:00
gepard1984
2c2a3cad15 * Modified drop system to allow overriding global item drop rates on per-item basis. For detailed explanation read source:trunk/db/mob_item_ratio.txt (topic:56118).
* Added missing update to `logs.sql` (follow-up to r15519).

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15521 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-26 15:55:42 +00:00
brianluau
648429a0c3 - SVN Copied exp.txt, exp_guild.txt, exp_homun.txt to /db/pre-re/ and /db/re/
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15423 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11 20:56:08 +00:00
gepard1984
8b3a63cf11 Picklog improvements:
- now it is finally possible to log every item players gain or lose
 - added 3 log types: `I` for auctioned items, `B` for buying shop transactions and `X` for all other items transactions that don't fall into another category (for detailed explanation on all log types read `conf/log_athena.conf`)
 - it also fixes items being logged as picked up/gained by player when in fact they were dropped on the ground due to full inventory


git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@15420 54d463be-8e91-2dee-dedb-b68131a5f0ec
2012-01-11 17:35:28 +00:00
ai4rei
ce3f78556c * Implemented buying store system (aka. reverse vending, purchase shop) together with related skill and items, without NPCs.
- For SQL apply upgrade_svn14713_log.sql to upgrade tables `picklog` and `zenylog`; for TXT no action is necessary.
- Requires 2010-04-20aRagexeRE or later and can be disabled in 'conf/battle/feature.conf'.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@14713 54d463be-8e91-2dee-dedb-b68131a5f0ec
2011-02-19 12:59:36 +00:00
akrus
4232eaf3d5 * Fixed: added 'E'-type zenylogs in sql table (bugreport:1957) [akrus]
- added sql file upgrade_svn13025_log.sql


git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13025 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-31 07:19:38 +00:00
ultramage
106b44c1e7 Merged the /loginmerge branch (topic:192754)
* the login server storage, ipban and logging systems have been abstracted and now provide a common interface; the rest has been merged into a single login server core (no more login/login_sql duplicity)
 * storage systems are now added via compiler options (WITH_SQL / WITH_TXT)
 * multiple storage engines can be compiled in at the same time, and the config option account.engine defines which one will be used.
 * due to MySQL autoincrement limitations, accounts with id '0' will not be supported; account IDs from this point on should start from '1'.
 * login_log() functions now again record IP addresses in dotted format, not as 4-byte integers (undo from r6868).
 * removed config options that defined column names in the login table
 * removed `memo` and `error message` columns from login db/savefile
 * moved `loginlog` table to the logs database
 * added sql files upgrade_svn12975.sql and upgrade_svn12975_log.sql
 * due to changes to the login table layout, I added an !optional! sql file (upgrade_svn12975_view.sql) that will provide a certain degree of backwards compatibility with existing software; read the instructions inside carefully!
 * moved third-party includes/libs to a separate directory
 * updated project files / makefiles

Changed the way GM levels are handled
 * removed conf/gm_account.txt
 * added the gm level column to the txt savefile (after 'email' column)
 * gm level information is now transferred along with account data
 
For open problems see bugreport:1889.

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@13000 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-07-26 20:45:57 +00:00
ultramage
189a9ec34e Typo fix for r12758 ><
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12764 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-07 02:54:28 +00:00
ultramage
1aae890f73 Added 'E' type to picklog table's 'type' column (followup to r11721).
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12758 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-06-05 12:51:51 +00:00
ultramage
f6a6d34640 Replaced the TYPE keyword with ENGINE in all sql files, because this is the preferred alternative.
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@12480 54d463be-8e91-2dee-dedb-b68131a5f0ec
2008-04-04 21:04:47 +00:00
ultramage
fd1f06130c Added upgrade_svn11388.sql to correct some log table column widths (for example, atcommandlog only stored first 50 chars)
git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@11388 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-10-09 20:09:15 +00:00
ultramage
16671ef54f * Added Global chat and Main chat logging
- lowered the priority of the 'logging off during gw' filter

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@10580 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-19 13:26:02 +00:00
ultramage
8f506eeda5 * SQL files fixup
- extended convert_engine_myisam and added innodb version
- changed the max. email length to 39 (to match value in source code)
- added comment for storage/guild storage picklog entries
- changed SETs to ENUMs, which is the proper data type in logs
- fixed incorrect defaults, shortened mapname lengths to 11
- use upgrade_svn10575_*.sql to apply changes

git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@10575 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-05-19 09:46:11 +00:00
skotlex
b10091246c - Normalized the mapname in guild get/set castle data, should fix guild flags.
- Added log options 0x800/0x1000 to log storage moves ('R') and guild storage moves ('G')
- Added upgrade_svn9976.sql to include 'R'/'G' on the picklog type column set.
- Updated the logs_athena description to include the letter of each type (512 - M, 32 - N, etc)


git-svn-id: https://svn.code.sf.net/p/rathena/svn/trunk@9976 54d463be-8e91-2dee-dedb-b68131a5f0ec
2007-03-08 16:27:06 +00:00