| .. |
|
custom
|
70d88284a0
Some field type changes in the custom_npc table, per Ahmed request.
|
%!s(int64=17) %!d(string=hai) anos |
|
experimental
|
1d781a1314
Kamael Datapack Initial Support Release: Part I. Thanks going to Emperorc, Kerberos_20, Scafu, Fulminus and KenM.
|
%!s(int64=17) %!d(string=hai) anos |
|
maintenance
|
77fa3cfb5f
- Quests: Newbie rewards implementation. Requires core update [L1716], since now characters' newbie field will work as INT instead of boolean. There are more quests that would make use of this facility, btw.
|
%!s(int64=17) %!d(string=hai) anos |
|
mods
|
2230cd2073
Further changes related to Vice customization facilities. Fixes #2142, #2147.
|
%!s(int64=17) %!d(string=hai) anos |
|
updates
|
be6d1d749b
Kratos is right, it would be a good idea to fix #2534
|
%!s(int64=17) %!d(string=hai) anos |
|
access_levels.sql
|
153ff8f9b4
Further changes and reorganize in the access level rewrite (requires [L2110]):
|
%!s(int64=17) %!d(string=hai) anos |
|
account_data.sql
|
d82307bbee
Implement newbie rules (thanks kriau)
|
%!s(int64=19) %!d(string=hai) anos |
|
accounts.sql
|
30f07f4d49
SQL: update for accounts table, as required by [L1557]. Additionally, some numeric types are trimmed for performance. Upcoming changes in the DB naming and field type should require attention as well; you have been warned ;P
|
%!s(int64=17) %!d(string=hai) anos |
|
admin_command_access_rights.sql
|
499ad9dcdd
Fix for Ticket #2392
|
%!s(int64=16) %!d(string=hai) anos |
|
armor.sql
|
a0d4c30629
Beleth Ring and some Infinity SA fixes by DETH.
|
%!s(int64=17) %!d(string=hai) anos |
|
armorsets.sql
|
389ba63ac4
SQL: Dynasty Platinum Plate Armor Sets.
|
%!s(int64=16) %!d(string=hai) anos |
|
auction.sql
|
85d2230c63
fix for clanhall & auction tables being dropped on upgrade [thx cinam]
|
%!s(int64=18) %!d(string=hai) anos |
|
auction_bid.sql
|
bf4b3a93b0
DP side of l385 - *** WARNING - update20061230.sql will DROP and CREATE auction & clanhall tables due to structure changes [thx Enforcer, l2jfree and Sami]
|
%!s(int64=18) %!d(string=hai) anos |
|
auction_watch.sql
|
0832020bcd
more 7s new stuff + some sql fixes and installer scripts additions. (by Lbaldi)
|
%!s(int64=19) %!d(string=hai) anos |
|
augmentations.sql
|
c81b3d4c78
Preliminary datapack support for durgus' augmentation system. Drop info for Stones is missing yet. Core update is on its way =).
|
%!s(int64=18) %!d(string=hai) anos |
|
auto_chat.sql
|
921d581b8d
SQL: Cosmetical "fix" for [#2282]
|
%!s(int64=17) %!d(string=hai) anos |
|
auto_chat_text.sql
|
921d581b8d
SQL: Cosmetical "fix" for [#2282]
|
%!s(int64=17) %!d(string=hai) anos |
|
boxaccess.sql
|
99f684bf1a
altered internal operation of tools, character data/non-character data is defined in the table creation header
|
%!s(int64=19) %!d(string=hai) anos |
|
boxes.sql
|
99f684bf1a
altered internal operation of tools, character data/non-character data is defined in the table creation header
|
%!s(int64=19) %!d(string=hai) anos |
|
castle.sql
|
16124a27cc
Goddard Castle siege data by skeleton. It would need core update. Please test and feedback.
|
%!s(int64=18) %!d(string=hai) anos |
|
castle_door.sql
|
1d781a1314
Kamael Datapack Initial Support Release: Part I. Thanks going to Emperorc, Kerberos_20, Scafu, Fulminus and KenM.
|
%!s(int64=17) %!d(string=hai) anos |
|
castle_doorupgrade.sql
|
99f684bf1a
altered internal operation of tools, character data/non-character data is defined in the table creation header
|
%!s(int64=19) %!d(string=hai) anos |
|
castle_functions.sql
|
8657684b46
update for castles - pruducts management
|
%!s(int64=17) %!d(string=hai) anos |
|
castle_manor_procure.sql
|
e178559906
Fix for manor SQL files (tnx gigikun)
|
%!s(int64=17) %!d(string=hai) anos |
|
castle_manor_production.sql
|
e178559906
Fix for manor SQL files (tnx gigikun)
|
%!s(int64=17) %!d(string=hai) anos |
|
castle_siege_guards.sql
|
ae7f7b8df0
Update required by [L1619] (zhyla), and several community contributions:
|
%!s(int64=17) %!d(string=hai) anos |
|
char_templates.sql
|
d22582b5d4
Bunch of quest fixes: [642,643,688] (gigikun)
|
%!s(int64=17) %!d(string=hai) anos |
|
character_friends.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_hennas.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_macroses.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_quests.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_recipebook.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_recommends.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_shortcuts.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
character_skills.sql
|
78f316c0e2
fixed #2477
|
%!s(int64=17) %!d(string=hai) anos |
|
character_skills_save.sql
|
78f316c0e2
fixed #2477
|
%!s(int64=17) %!d(string=hai) anos |
|
character_subclasses.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
characters.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
clan_data.sql
|
fe897d7260
SQL/HTML support by Steuf for [L898]; Requires [L898]
|
%!s(int64=18) %!d(string=hai) anos |
|
clan_privs.sql
|
9ca2ccb67a
Clan support DP side. (Needs L2J 224)
|
%!s(int64=18) %!d(string=hai) anos |
|
clan_skills.sql
|
d99119b7a5
required DP update for l:207 [thanks to Sami & l2j-free]
|
%!s(int64=18) %!d(string=hai) anos |
|
clan_subpledges.sql
|
bd7e7d2f53
uhhh...major ooops...this is what was meant to be in [4557] *.*
|
%!s(int64=17) %!d(string=hai) anos |
|
clan_wars.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
clanhall.sql
|
0642d7c8ac
DP side for clanhall update
|
%!s(int64=17) %!d(string=hai) anos |
|
clanhall_functions.sql
|
fe897d7260
SQL/HTML support by Steuf for [L898]; Requires [L898]
|
%!s(int64=18) %!d(string=hai) anos |
|
class_list.sql
|
1d781a1314
Kamael Datapack Initial Support Release: Part I. Thanks going to Emperorc, Kerberos_20, Scafu, Fulminus and KenM.
|
%!s(int64=17) %!d(string=hai) anos |
|
cursed_weapons.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
dimensional_rift.sql
|
e31ce2ca30
SQL: Fix for Ticket #2040 by gigiikun.
|
%!s(int64=17) %!d(string=hai) anos |
|
documentation.txt
|
153ff8f9b4
Further changes and reorganize in the access level rewrite (requires [L2110]):
|
%!s(int64=17) %!d(string=hai) anos |
|
droplist.sql
|
73b561816c
SQL: Materials spoils matching L2WH by who ? Of course, Sandro :-) (thx)
|
%!s(int64=17) %!d(string=hai) anos |
|
enchant_skill_trees.sql
|
ae8c1e1857
few more enchanted skills and updated territory html
|
%!s(int64=17) %!d(string=hai) anos |
|
etcitem.sql
|
72bc8b119c
few quest item fixes
|
%!s(int64=16) %!d(string=hai) anos |
|
fish.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
fishing_skill_trees.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
fort.sql
|
b62f65d316
some SQL Cleanup
|
%!s(int64=17) %!d(string=hai) anos |
|
fort_door.sql
|
f3460f9dd3
SQL: Dragonspine Fortress door fix, fix doors coord ( this avoid ppl cheat on enter ). Thx to: Vice & Lhundaeion.
|
%!s(int64=17) %!d(string=hai) anos |
|
fort_doorupgrade.sql
|
eeecd78d86
SQL: Something was forgoten in this tables.
|
%!s(int64=17) %!d(string=hai) anos |
|
fort_siege_guards.sql
|
f899babb77
Western fortress siege guards spawns
|
%!s(int64=17) %!d(string=hai) anos |
|
fortsiege_clans.sql
|
eeecd78d86
SQL: Something was forgoten in this tables.
|
%!s(int64=17) %!d(string=hai) anos |
|
forums.sql
|
0832020bcd
more 7s new stuff + some sql fixes and installer scripts additions. (by Lbaldi)
|
%!s(int64=19) %!d(string=hai) anos |
|
games.sql
|
6292af11a3
Fix #177. Tnx n506
|
%!s(int64=19) %!d(string=hai) anos |
|
gameservers.sql
|
7038f561ce
Added update for global_tasks sql in update.bat and added IF NOT EXISTS to tables to stop error if table already exists
|
%!s(int64=19) %!d(string=hai) anos |
|
global_tasks.sql
|
240d072b9b
SQL global_tasks: int(20)<->decimal(20,0) .. (tnx MuNLoK, Micht..)
|
%!s(int64=19) %!d(string=hai) anos |
|
grandboss_data.sql
|
68883b1f4d
SQL: Query in grandboss_data fixed
|
%!s(int64=17) %!d(string=hai) anos |
|
grandboss_list.sql
|
258187e994
SQL: Update was required after [4241], so cleaned up core a little to prevent such issues in the future all together. Now the zone names can be changed as many times as needed, just don't change their id. Thus, I changed the structure of grandboss_list a little and this requires [L1822] and the sql update in this commit. Fixes #L2241, thx L2Nemesis for reporting.
|
%!s(int64=17) %!d(string=hai) anos |
|
helper_buff_list.sql
|
55f2c1fe8c
Newbie buff updates.
|
%!s(int64=17) %!d(string=hai) anos |
|
henna.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
henna_trees.sql
|
a83801cc03
henna tree update
|
%!s(int64=17) %!d(string=hai) anos |
|
heroes.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
items.sql
|
657f040f79
SQL: Support for [L1906]. Removing unused collumns from item.sql. Thx Sami.
|
%!s(int64=17) %!d(string=hai) anos |
|
itemsonground.sql
|
ec30fbb2e1
SQL changes for items on ground manager, requires core update: 264 [thanks DiezelMax and Enforcer]
|
%!s(int64=18) %!d(string=hai) anos |
|
locations.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
lvlupgain.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
mapregion.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
merchant_areas_list.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
merchant_buylists.sql
|
ec7884ef0c
SQL: Fix for [#2444]
|
%!s(int64=17) %!d(string=hai) anos |
|
merchant_lease.sql
|
99f684bf1a
altered internal operation of tools, character data/non-character data is defined in the table creation header
|
%!s(int64=19) %!d(string=hai) anos |
|
merchant_shopids.sql
|
f7e3da1b6e
small update in castle: some htmls and buylist from chamberlain
|
%!s(int64=17) %!d(string=hai) anos |
|
merchants.sql
|
f07237f9ce
SQL: TYPE statement deprecated by ENGINE. tnx rodo, magestik and iamspaceman.
|
%!s(int64=17) %!d(string=hai) anos |
|
minions.sql
|
cc66f35cad
SQL: Valley of Saints: Mobs Sociality, thanks minlexx.
|
%!s(int64=17) %!d(string=hai) anos |
|
npc.sql
|
8ea591aa81
update for Quest Little Wings Adventure (strider quest)
|
%!s(int64=16) %!d(string=hai) anos |
|
npc_buffer.sql
|
921d581b8d
SQL: Cosmetical "fix" for [#2282]
|
%!s(int64=17) %!d(string=hai) anos |
|
npcskills.sql
|
99d1ac9d8d
More npc skill fixes, by lanabel.
|
%!s(int64=17) %!d(string=hai) anos |
|
olympiad_nobles.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
pets.sql
|
d0e8954a56
little clean up (required [L558] )
|
%!s(int64=18) %!d(string=hai) anos |
|
pets_stats.sql
|
ed48f9c50b
Fixes #2537. Adding red striders, as a mere copy of the regular ones. They should have extra move speed when mounted and greater defense, but these values would be my best bet for we to stay in the safe side. Oh and making these pets' control items match with retail definitions, they cant be dropped, exchanged nor sold.
|
%!s(int64=17) %!d(string=hai) anos |
|
pledge_skill_trees.sql
|
ff90984097
SQL: Clan skills corrections
|
%!s(int64=17) %!d(string=hai) anos |
|
posts.sql
|
0832020bcd
more 7s new stuff + some sql fixes and installer scripts additions. (by Lbaldi)
|
%!s(int64=19) %!d(string=hai) anos |
|
quest_global_data.sql
|
f1e5b53a52
Database structure for (future) support of saving quest data that is globally valid for all chars (this will support, for example, saving when a grandboss gatekeeper should become available again).
|
%!s(int64=17) %!d(string=hai) anos |
|
raidboss_spawnlist.sql
|
f48b8fb309
correcting zones in rainbow springs/wild beast/fortress of dead clanhalls
|
%!s(int64=17) %!d(string=hai) anos |
|
random_spawn.sql
|
9c7b5063ae
spawn fixes on kamael island
|
%!s(int64=17) %!d(string=hai) anos |
|
random_spawn_loc.sql
|
921d581b8d
SQL: Cosmetical "fix" for [#2282]
|
%!s(int64=17) %!d(string=hai) anos |
|
seven_signs.sql
|
ea50208311
This is part of a series of (simple but necessary) changes centered in pushing towards a naming convention and a coherent data model. Today, I'm moving any variation of char_id, obj_id, playerId... to '''charId'''. Affects characters and character_whatever tables, seven signs, hero/nobles and cursed weapon. Core [L2073] is required and despite my testings a backup is strongly recommended, since given the spread nature of these changes something may have been overlooked.
|
%!s(int64=17) %!d(string=hai) anos |
|
seven_signs_festival.sql
|
1f4e208e8c
ignoring some errors for tables that contain existing character data
|
%!s(int64=19) %!d(string=hai) anos |
|
seven_signs_status.sql
|
21e1104e7d
sql fixes for overflow in 7s score calculation
|
%!s(int64=19) %!d(string=hai) anos |
|
siege_clans.sql
|
99f684bf1a
altered internal operation of tools, character data/non-character data is defined in the table creation header
|
%!s(int64=19) %!d(string=hai) anos |
|
skill_learn.sql
|
e923bd9b3b
fix for #2197
|
%!s(int64=17) %!d(string=hai) anos |
|
skill_spellbooks.sql
|
7b22ef81d2
SQL: Minor typo fix, thanks lantoc.
|
%!s(int64=16) %!d(string=hai) anos |
|
skill_trees.sql
|
2968d371a6
Fix for [#2470]
|
%!s(int64=17) %!d(string=hai) anos |
|
spawnlist.sql
|
dd0012a9d3
missing spawns for court magicians
|
%!s(int64=16) %!d(string=hai) anos |
|
teleport.sql
|
96de89835a
teleports for schuttgart clanhalls
|
%!s(int64=16) %!d(string=hai) anos |
|
topic.sql
|
6292af11a3
Fix #177. Tnx n506
|
%!s(int64=19) %!d(string=hai) anos |
|
transform_skill_trees.sql
|
42966ca5de
DP part for Transform Skilltrainer [L1954], Quest 136 and NPC Avant-Garde. thnx Gigii-kun.
|
%!s(int64=17) %!d(string=hai) anos |
|
walker_routes.sql
|
ef3e6a6936
Datapack support for Adventurers' Guide Miss Queen implementation:
|
%!s(int64=17) %!d(string=hai) anos |
|
weapon.sql
|
54e05b150e
fix for Icarus Hall - Acumen
|
%!s(int64=16) %!d(string=hai) anos |
|
zone_vertices.sql
|
b5db218817
fixed #2592
|
%!s(int64=16) %!d(string=hai) anos |
Kerberos
8ea591aa81
update for Quest Little Wings Adventure (strider quest)