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
24725 commits 11 branches 14 tags 300 MiB
Commit graph

534 commits

Author SHA1 Message Date
AlterEgo
f902053ebd Update main character database table master file. 
Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2022-12-25 13:01:53 -06:00
AlterEgo
f2d16cc601 DB: 
Update character base with last update.
<ci-skip>

Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2021-02-07 18:09:01 -06:00
AriDEV
d6d6bc925b Database/Auth: Fix for case sensitive UNIX users. thanks for pointing out @hubsinfo. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2020-01-29 09:35:21 +01: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
SkyFire
0f516f7e51 Core/Logging: Ported missed changes from TC before they switched over to boost. Core loads 90% faster now. Cleanup some other unused shit. Apply update to your auth database. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2018-08-11 17:38:22 -05:00
AriDEV
88a088abdf Database/Characters: Drop some tables. 
Signed-off-by: AriDEV <aridev666@gmail.com>
 2018-07-05 23:49:58 +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
AlterEgo
3d4b6c6fe6 Update Base auth database. 
Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2017-09-10 10:56:55 -05:00
AlterEgo
9f2ba0b4e2 Update the worldserver config hash. Updated the base character sql table. 
Update ignore table.

Signed-off-by: AlterEgo <admin@projectskyfire.org>
 2017-03-10 16:56:55 -06:00
SkyFire
8383022071 Sync updates for character database tables. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2016-04-02 17:54:12 -05: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
SkyFire
4243942386 Sync character table updates in base table. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2015-12-23 16:26:22 -06:00
SkyFire
a2538328a6 Deleted some rogue file. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2015-10-13 17:44:18 -05:00
SkyFire
da8408d2c1 Archived SQL updates for DB release 12 located in the forum. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2015-08-05 08:31:29 -05: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
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
SkyFire
e645e11e5b Sync base Character SQL file with the core. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2014-09-22 21:36:22 -05:00
Vincent-Michael
d8690fa462 DB: meh, snyc characters base 2014-07-26 18:54:00 +02:00
Sovak
634b312035 Updated to 18414 
Signed-off-by: Sovak <Sovak007@gmail.com>
 2014-06-17 20:15:55 +02:00
Sovak
846de702e0 Basic update to 5.4.8 - 18291 
Thanks to @Fabi for poiting at one mistake in auth_session

Signed-off-by: Sovak <Sovak007@gmail.com>
 2014-05-21 23:56:25 +02:00
SkyFire
311c5c596e Fix Palabola's epic sql fail. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2014-04-28 21:52:22 -05:00
Palabola
9f058fd0b3 Update characters DB to support reforge and transmog changes. 2014-04-18 07:40:10 +02:00
Pirricli
3156ca3a7b Update auth_database.sql 2014-03-15 12:05:33 +01:00
Pirricli
1a7a7dbb7d Update auth_database.sql 
Authserver doesn't start because ip2nationcountries should be ip2nationCountries.
 2014-03-15 11:54:36 +01:00
Sovak
fd941f978a Updates to 18019 
Signed-off-by: Sovak <Sovak007@gmail.com>
 2014-03-12 16:02:37 +01:00
Walkum
4c48223d60 Updated build to 17956 2014-02-28 15:55:00 +01:00
Sovak
2a841bcbf4 SQL updats 
Signed-off-by: Sovak <Sovak007@gmail.com>
 2014-02-22 12:21:24 +01:00
Sovak
1a50de53d1 5.4.7: Updated auth and character enum 
Signed-off-by: Sovak <Sovak007@gmail.com>
 2014-02-14 20:33:47 +01: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
F03SD
2cc30521f4 ...... 
no idea test git config --global
 2013-12-01 09:33:06 +03:00
SkyFire
0581c3f3ac Make the character table current. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2013-11-28 09:38:42 -06:00
SkyFire
c96b98bc89 Update the auth table. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2013-11-28 09:36:21 -06:00
SkyFire
acd048bc28 Pushing what I have for now. The realmlist works now. Working on the character loading. 
Signed-off-by: SkyFire <admin@projectskyfire.org>
 2013-11-15 17:49:49 -06:00
Sovak
a243def91a Minor updates for 5.4.1 
Signed-off-by: Sovak <Sovak007@gmail.com>
 2013-11-12 02:25:18 +01:00
Shauren
a49dfb19df Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4 2013-10-26 17:06:50 +02:00
Vincent-Michael
9436d233d6 SQL: Update auth base 2013-10-17 12:17:47 +02:00
Shauren
4fe416de82 Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4 2013-10-07 14:30:37 +02:00
Spp
0ae9eb960e Core/RBAC: Fix errors in RBAC sql related to ea2fe0217d 2013-09-30 11:55:51 +02:00
Spp
f523c7bdfc Fix compile under linux and update auth db with latest changes 2013-09-29 14:15:58 +02:00
Vincent-Michael
102d578fda Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4 
Conflicts:
	src/server/game/Accounts/RBAC.h
	src/server/game/Battlegrounds/ArenaTeam.cpp
 2013-09-11 22:35:45 +02:00
Nay
f00260155b SQL: Update sql/base/auth_database.sql 2013-09-10 23:21:27 +01:00
Vincent-Michael
47901380f9 Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4 
Conflicts:
	src/server/scripts/Commands/cs_debug.cpp
	src/server/worldserver/worldserver.conf.dist
 2013-09-02 22:53:44 +02:00
Ascathor
e3364407c6 Core/Account: Make account password change security variable and various changes 
Settings within worldserver.conf:

Three settings for secruity level:
0 - None - No change to current system
1 - Email - Always requires the email entered on registration for confirming.
2 - RBAC - Groups applied with the RBAC role always require the email entered on registration for confirming.

RBAC default to every group. Changed some logs to make it more clear what is going on at all.

Emails may now no longer exceed 64 chars. Current email is used as regmail.

On account creation, two emails are saved. Registration email and normal email. Normal email is relevant afterwards. Registration email can be changed by console ONLY.

Includes new commands and changes to existing ones:
.account fulfills several new functions:
* Still prints GM Level.
* If account has permission, it displays the current email. This is not defaulted to any group.
* Security level is displayed. Also displays if user has RBAC perm if RBAC security mode is selected
.account email allows user to change email with sufficient confirmation
.account set sec email allows higher sec with higher sec than account to change the normal email. Registrationemail remains untouched here.
.account set sec regmail allows console to change registration email.
.pinfo now displays the registration and normal mail.

Also fixes .learn all crafts.
Closes #10558
 2013-09-01 21:21:16 +02:00
Nay
e8aaf168f8 Merge remote-tracking branch 'origin/master' into 4.3.4 
Conflicts:
	src/server/game/Spells/SpellMgr.cpp
	src/server/scripts/Commands/cs_debug.cpp
	src/server/scripts/EasternKingdoms/zone_redridge_mountains.cpp
	src/tools/map_extractor/mpq_libmpq04.h
 2013-08-25 14:12:32 +01:00
raczman
b83b734282 Core/Auth: Implement time-based token for user login as described in RFC 6238. 
New column in account table is a base32 of token key bytes,
coincidentally it is the same format Google's Authenticator Android app uses.
If you want that to work, set system time on server correctly and use ntpd.

Closes #10527

Signed-off-by: Nay <dnpd.dd@gmail.com>
 2013-08-25 14:02:40 +01:00
Vincent-Michael
741ed6539a Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4 
Conflicts:
	src/server/game/Entities/Corpse/Corpse.cpp
	src/server/game/Globals/ObjectMgr.cpp
 2013-07-19 22:33:35 +02:00