mmo-ref/skyfire
1
0
Fork 0
mirror of https://github.com/ProjectSkyfire/SkyFire_548 synced 2026-08-18 06:32:13 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions
26453 commits 11 branches 14 tags 300 MiB
Commit graph

85 commits

Author SHA1 Message Date
github-actions[bot]
4c0667ef31 SQL: Promote pending updates 
Referenced commit(s): 77d56fa262
 2026-08-03 21:36:30 +00:00
AlterEgo
82386a8d51 Add starter pet persistence and database updates 
Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2026-06-27 08:24:01 -05:00
digid702
eab5a12bb5 DB: This doesnt go there, it goes here 2024-10-04 04:54:43 +00:00
Digid702
99d3ad95c4 DB fixed update for RBAC commands 2024-10-02 19:10:54 -07:00
Digid702
7ebb158eff Updating auth and character DB's and moving updates to old 2024-09-01 13:04:31 -07:00
AlterEgo
c43dc8e4a6 Fix a sql warning. 
Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2024-03-02 13:33:57 -06:00
AlterEgo
5c3e41a33c Add character db update and fix filename from a previous commit 
Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2024-03-02 13:31:22 -06:00
Nightprince
887f795a51 Core/Transmogification: Split to a new table 2024-02-12 23:27:26 +03:30
Crypticaz
4f8d38fd00
Fix worldserver crash on startup (#1102) 
Database/Currency: Missing change for column names
 2022-06-16 17:04:26 +02:00
ARIDEV
e5e5aa8ae3 Server/PacketIO: Implement CMSG_SET_PET_TALENT_TREE and SMSG_SET_PET_SPEC 2021-02-05 22:18:09 +01:00
AriDEV
2d558112a0 Server/BMAH: Convert currentBid and minIncrement to uint64. fixes an arithmetic overflow. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2020-03-09 00:10:55 +01:00
AriDEV
62fe4ec29a Server/Arena: Drop Some ArenaTeams Code. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2019-05-04 17:28:35 +02:00
AriDEV
8a1a35a9ac Database: Merge Auth/Char updates into Base. 
-[ci skip]

Signed-off-by: AriDEV <aridev666@gmail.com>
 2018-08-12 02:43:50 +02:00
AriDEV
6c707a4d74 SQL: missed one. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2018-06-01 13:20:44 +02:00
AriDEV
1431399aff Server/Database: Droped some dead code in PreparedStatments. 
* Renamed Tables and Collumns containing rank & group to bypass a mysql bug.
* Fixed an issue where wrong collumns were loaded from creature_template at reload.

Signed-off-by: AriDEV <aridev666@gmail.com>
 2018-06-01 13:15:47 +02:00
AriDEV
ef5bfbfe46 Server/DataStore: Implemented Difficulty.dbc and updated Dungeon and Raid difficulties. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2018-02-15 11:33:19 +01:00
AriDEV
47312b4bf0 Server/PacketIO: Implemented CMSG_SET_LFG_BONUS_FACTION_ID. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2017-03-10 20:37:32 +01:00
AriDEV
c4b83ba67d Server/Player: Fixed saving blockpct into character_stats, also added mastery, pvpdamage and pvphealing. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2016-02-26 03:05:58 +01:00
E H S A N
7fd78f034f Fix a typo for sql data , thanks to @Nightprince 2016-02-07 16:22:44 +03:30
Ehsan619
3109bf70d1 Core/Tickets: Implement commands and sql data for suggestion tickets 2016-02-06 18:36:31 +03:30
Shoxxo
284285e09e Add archaelogy struct... 2016-01-03 17:47:17 +01:00
Ehsan Hesam
8b503c1d1a Core/Tickets : Update Ticket System to MoP And Implement FeedBackSystem 
Fix and Update most of Gm ticket's packets and it is System
Implement New FeedBack System (Bug Tickets)
Suggestion Tickets and Complaint Tickets will come in the next commits
thanks to https://github.com/Carbenium for the tips i got from his ticketing System
 2015-11-04 01:21:55 +03:30
Arci
f24582f2be Calendar: removed DEFAULT_STATUS_TIME 2015-09-30 22:44:56 +02:00
Arci
9dcd4ce4c8 Calendar: handled opcodes SMSG_CALENDAR_SEND_EVENT, CMSG_CALENDAR_GET_CALENDAR and CMSG_CALENDAR_ADD_EVENT... Added opcode number for SMSG_CALENDAR_SEND_CALENDAR 2015-08-08 10:10:53 +02:00
AriDEV
8e5c555bcc Database: Fixed SQL Syntax. and removed keys that are not needed. 
Fixed #583

Signed-off-by: AriDEV <aridev666@gmail.com>
 2015-06-29 14:12:26 +02:00
AriDEV
cce15ac256 SQL: Fixed Out of range currentBid at characters database in table blackmarket_auctions. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2015-06-22 01:25:10 +02:00
AriDEV
dfeb757592 SQL: Updated Data of files and fixed format to int 10 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2015-06-22 00:40:23 +02:00
AriDEV
b543fdaab5 Server/BlackMarket: Implemented Basic BlackMarket Auction System. 
Still needs some work.

Signed-off-by: AriDEV <aridev666@gmail.com>
 2015-06-22 00:31:19 +02:00
AriDEV
763721d2b3 DB: Synch Auth/Characters Updates with Base and Move them to old. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2015-01-21 17:47:54 +01:00
Rawaho
cd897b56dd Core/Quest: Updated Quest system to use new Quest Objectives. 
This fixes Quests that have more than 4 active objectives.
Quest progress is now tracked by each objective rather than as a quest.
This commit causes a few database errors due to missing Creature/GO and Quest templates, will fix up soon.
Also includes changes to the Barbershop result that I forgot to commit last week ^^.
 2014-09-05 00:40:02 +12:00
Rawaho
82f49c22db Core/BattlePet: Finished implementing Battle Pet name query. 
Fixed releasing/deleting Battle Pets from the journal.
Removed the obsolete 'BattlePetDefines.h'.
A few other misc changes.
 2014-07-08 02:28:20 +12:00
Rawaho
78182c5d2b Core/BattlePet: Initial implementation of Battle Pets. 
- No Battle Pet trainers yet, use .cast 125610 for the time being.
 - Battle Pets can be added via items, their starting level can be changed in the worldserver.conf.
 - Stat calculations should be correct for all pets but report any errors.
 2014-07-06 01:00:50 +12:00
SkyFire
deef627703 Fixed SQL query. Not everone uses a table called characters. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2014-04-27 12:09:22 -05:00
SkyFire
25f2233979 Update character table sql update to our naming standards. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2014-04-24 13:45:51 -05:00
Palabola
9f058fd0b3 Update characters DB to support reforge and transmog changes. 2014-04-18 07:40:10 +02:00
SkyFire
1ea0286ce6 Update the base sql files. archived the 4.3.4 updates. merged the 5.4.1 and 5.4.2 updates into one folder. changed the file order. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2014-01-11 12:50:35 -06:00
Vincent-Michael
a189c7c089 SQL: Rename in correct name 2013-07-19 14:01:25 +02:00
Vlad
f22cf46959 Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bits 
Signed-off-by: Nay <dnpd.dd@gmail.com>
 2013-07-19 04:03:40 +01:00
Nay
ae18e3d262 TDB 335.52 - 2013/07/17 2013-07-17 00:27:42 +01:00
Vincent-Michael
b4851dd908 DB/FactionChange: Add missing player_factionchange_spells for Black War Bear / Black War Mammoth 2013-06-25 18:29:42 +02:00
Aokromes
7f8e57df42 DB/Misc: Cleaning db of unused/obsolete stuff 2013-06-23 01:52:22 +02:00
Shauren
df5d47e35f Core/PacketIO: Implemented possibility to ban client addons serverside 2013-04-05 15:06:35 +02:00
Shauren
a12db19a4f Unbreak the build and renamed sql file to proper date 2013-03-04 17:08:07 +01:00
Shauren
60337df5ff Core/Players: Implemented converting quests on faction change (keeping old faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction 
Closes #890
Closes #9248
 2013-03-04 14:15:52 +01:00
Nay
12a31f5e96 TDB 335.50 - 2013/01/14 2013-01-13 18:53:32 +00:00
Vincent_Michael
a23490ba62 SQL: Rename SQL merged in PR 2012-12-20 16:48:24 +01:00
Subv
8210ce011e Merge pull request #8662 from MrSmite/ItemContainer_1.1 
Item Loot Saving
 2012-12-20 07:00:29 -08:00
Vincent_Michael
562eeac720 Core/Character: Fix logic fail with world state in b2928e59fa8334e91dfa1a5951fade5b574b5842 2012-12-18 14:13:09 +01:00
MrSmite
f297e270b1 Implements saving of loot (items / money) contained inside lootable inventory items. 
* Unlooted items / money persist across player sessions
* Loot inside items is tied to the item rather than the player so if trading
  partially looted items becomes possible, this implementation will still work

* New tables added:

    characters_database.sql (first time users)
    characters_create_item_loot.sql (existing users)

Implementation Can be tested with:

 Watertight Trunk [21113]
 Bulging Sack of Gems [25422]
 Fat Sack of Coins [11937]

Closes #2048
 2012-12-15 00:06:32 -05:00
Vincent-Michael
4e9abb2f2e Core/Quest: Add support for monthly quests 
Author: svetilo12
Converted and updated by: Subv
 2012-12-04 00:04:06 +01:00