Shauren
c8cb206bb5
Core/Accounts: sessionkey field in account table is only a temporary storage to pass data from authserver to worldserver and should only be used as such. Clearing sessionkey from database after a successful login to prevent possible exploits.
2013-02-07 16:15:23 +01:00
Vincent_Michael
a28c4ecfc9
Fix merge fail (fucking saving button -.-)
2013-02-04 22:17:23 +01:00
Vincent_Michael
fe0ced9498
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
...
Conflicts:
sql/base/auth_database.sql
sql/base/characters_database.sql
src/server/game/Entities/Player/Player.cpp
src/server/game/Handlers/LFGHandler.cpp
src/server/game/Server/WorldSession.cpp
src/server/game/Server/WorldSession.h
src/server/game/Server/WorldSocket.cpp
src/server/game/World/World.cpp
src/server/scripts/Spells/spell_generic.cpp
2013-02-04 22:14:56 +01:00
Nay
aa3ff592fb
DB/Auth: Update sql/base/auth_database.sql
2013-02-04 16:08:45 +00:00
Aokromes
a8294093fc
Merge pull request #9099 from Bezo/mutenew
...
Add Mute reason and mute by to the db so you can get this info from the ...
2013-02-04 06:55:26 -08:00
Vincent_Michael
4909ef346a
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
...
Conflicts:
sql/base/auth_database.sql
src/server/scripts/EasternKingdoms/ZulGurub/boss_thekal.cpp
src/server/scripts/Northrend/IcecrownCitadel/boss_lady_deathwhisper.cpp
2013-01-31 00:10:17 +01:00
Emo
ac63f7b44c
DB/Auth: Fix typo in sql/base/auth_database.sql
...
ERROR 1136 (21S01) at line 216: Column count doesn't match value count at row 1
2013-01-30 14:51:40 +01:00
Bezo
524bbe29c2
Add Mute reason and mute by to the db so you can get this info from the db with the pinfo command when player get muted.
...
old LOGIN_UPD_MUTE_TIME change to LOGIN_UPD_MUTE_TIME_LOGIN due the use of it when character login to world.
2013-01-30 13:09:41 +02:00
Nay
9a35f62ee5
Merge remote-tracking branch 'origin/master' into 4.3.4
...
Conflicts:
dep/PackageList.txt
src/server/game/Battlegrounds/Battleground.cpp
src/server/game/Combat/ThreatManager.cpp
src/server/game/Entities/Object/Object.cpp
src/server/game/Entities/Player/Player.cpp
src/server/game/Entities/Unit/Unit.cpp
src/server/game/Handlers/BattleGroundHandler.cpp
src/server/game/Movement/MovementGenerators/RandomMovementGenerator.cpp
src/server/game/Movement/MovementGenerators/TargetedMovementGenerator.cpp
src/server/game/Movement/Spline/MoveSplineInit.cpp
src/server/game/Spells/Auras/SpellAuraEffects.cpp
src/server/game/Spells/SpellEffects.cpp
src/server/game/World/World.cpp
src/server/game/World/World.h
src/server/scripts/EasternKingdoms/ZulGurub/boss_arlokk.cpp
src/server/scripts/EasternKingdoms/ZulGurub/instance_zulgurub.cpp
src/server/scripts/EasternKingdoms/ZulGurub/zulgurub.h
src/server/scripts/Spells/spell_druid.cpp
src/server/scripts/Spells/spell_mage.cpp
src/server/scripts/Spells/spell_paladin.cpp
src/server/scripts/Spells/spell_priest.cpp
src/server/scripts/Spells/spell_rogue.cpp
src/server/scripts/Spells/spell_shaman.cpp
src/server/scripts/Spells/spell_warlock.cpp
src/server/scripts/Spells/spell_warrior.cpp
src/tools/map_extractor/CMakeLists.txt
src/tools/map_extractor/System.cpp
src/tools/map_extractor/loadlib.cpp
src/tools/map_extractor/mpq_libmpq.cpp
src/tools/map_extractor/mpq_libmpq04.h
src/tools/vmap4_assembler/CMakeLists.txt
src/tools/vmap4_extractor/CMakeLists.txt
src/tools/vmap4_extractor/mpq_libmpq.cpp
src/tools/vmap4_extractor/mpq_libmpq04.h
2013-01-28 01:04:37 +00:00
Shauren
cc425770cd
Core/Authserver: Added possibility to allow realm connections both from "world" and local networks.
2013-01-27 17:33:01 +01:00
Nay
5249440350
Update sql/base/auth_database.sql
2012-08-12 04:20:58 +02:00
Nay
25662d5f7f
SQL: Sync auth_database.sql as well
2012-08-08 19:02:43 +01:00
Nay
529491b383
DB/Auth: Update gamebuild
2012-07-23 16:25:00 +01:00
Shauren
90cebef31c
Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.x
2012-07-04 22:20:21 +02:00
Nay
384b22f60a
Append _4x to all 4.x sqls. Update/fix auth_database.sql
2012-05-30 12:53:26 +01:00
kaelima
99eb1f7def
Merge git://github.com/TrinityCore/TrinityCore into 4.x
...
Conflicts:
dep/PackageList.txt
sql/base/auth_database.sql
src/server/authserver/Server/AuthSocket.cpp
src/server/game/Battlegrounds/BattlegroundMgr.cpp
src/server/game/Chat/Commands/Level1.cpp
src/server/game/Chat/Commands/Level3.cpp
src/server/game/DataStores/DBCEnums.h
src/server/game/DataStores/DBCStores.cpp
src/server/game/DataStores/DBCStores.h
src/server/game/DataStores/DBCStructure.h
src/server/game/DataStores/DBCfmt.h
src/server/game/Entities/Corpse/Corpse.cpp
src/server/game/Entities/Creature/Creature.cpp
src/server/game/Entities/DynamicObject/DynamicObject.cpp
src/server/game/Entities/GameObject/GameObject.cpp
src/server/game/Entities/Item/Item.cpp
src/server/game/Entities/Object/Object.cpp
src/server/game/Entities/Object/Updates/UpdateData.h
src/server/game/Entities/Pet/Pet.cpp
src/server/game/Entities/Player/Player.cpp
src/server/game/Entities/Player/Player.h
src/server/game/Entities/Transport/Transport.cpp
src/server/game/Entities/Unit/Unit.cpp
src/server/game/Globals/ObjectMgr.cpp
src/server/game/Globals/ObjectMgr.h
src/server/game/Guilds/Guild.cpp
src/server/game/Handlers/CharacterHandler.cpp
src/server/game/Handlers/MiscHandler.cpp
src/server/game/Handlers/MovementHandler.cpp
src/server/game/Handlers/QuestHandler.cpp
src/server/game/Loot/LootMgr.cpp
src/server/game/Miscellaneous/SharedDefines.h
src/server/game/Quests/QuestDef.cpp
src/server/game/Server/Protocol/Opcodes.cpp
src/server/game/Server/Protocol/Opcodes.h
src/server/game/Server/WorldSession.cpp
src/server/game/Server/WorldSocket.cpp
src/server/game/Spells/Auras/SpellAuraEffects.cpp
src/server/game/Spells/Spell.cpp
src/server/game/Spells/Spell.h
src/server/game/Spells/SpellEffects.cpp
src/server/game/Tickets/TicketMgr.cpp
src/server/scripts/Commands/cs_gps.cpp
src/server/scripts/Commands/cs_modify.cpp
src/server/shared/Database/Implementation/CharacterDatabase.cpp
src/server/shared/Logging/Log.h
src/tools/map_extractor/CMakeLists.txt
src/tools/map_extractor/System.cpp
src/tools/map_extractor/mpq_libmpq04.h
src/tools/vmap4_extractor/CMakeLists.txt
2012-05-30 08:01:02 +02:00
Nay
4538b74587
DB/GOs: Correct some templates and add a missing one (WDB)
...
DB/Auth: Add missed change to auth_base.sql
Also fix file endings in some of hte sqls
2012-04-05 17:38:13 +01:00
Nay
addc28fcc4
DB/Auth: Increase realmlist.address size to 64 (varchar)
...
You might want to verify if the previous size did not truncate your address (it was 15)
2012-04-01 03:09:02 +01:00
leak
f600553f91
SQL: Auth db data type cleanup logs, realmcharacters, realmlist, uptime / Storage engine switched to InnoDB Note:
...
As for the redundant `uptime`.`startstring` being removed, this page might be of interest how to generate time strings from unix timestamps
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
2012-03-28 19:46:38 +02:00
leak
94f82e4684
SQL: Auth db data type cleanup account_access, account_banned, ip_banned / Storage engine switched to InnoDB
2012-03-28 16:48:49 +02:00
leak
9150557fd0
SQL: Auth db data type cleanup account / Storage engine switched to InnoDB
2012-03-28 16:39:59 +02:00
Nay
f955997406
DB/Auth: Update auth_database.sql with recent changes
2012-03-26 18:23:05 +01:00
Nay
672d7ef42c
DB/Auth: Update auth_database.sql with recent changes
...
DB/GameEvent: Resync Darkmoon, again - by Aokromes
2012-03-25 21:15:22 +01:00
Spp
17ebde4d82
Merge branch 'master' into 4.x
...
Conflicts:
sql/base/auth_database.sql
src/server/authserver/Server/AuthSocket.cpp
src/server/game/AI/CoreAI/CombatAI.cpp
src/server/game/AuctionHouse/AuctionHouseMgr.cpp
src/server/game/Battlegrounds/Zones/BattlegroundSA.cpp
src/server/game/DataStores/DBCStructure.h
src/server/game/DataStores/DBCfmt.h
src/server/game/Entities/Unit/Unit.cpp
src/server/game/Entities/Vehicle/Vehicle.cpp
src/server/game/Globals/ObjectMgr.cpp
src/server/game/Globals/ObjectMgr.h
src/server/game/Handlers/AuctionHouseHandler.cpp
src/server/game/Miscellaneous/SharedDefines.h
src/server/game/Movement/MotionMaster.cpp
src/server/game/Movement/MovementGenerators/WaypointMovementGenerator.cpp
src/server/game/Quests/QuestDef.cpp
src/server/game/Server/Protocol/Opcodes.cpp
src/server/game/Server/WorldSocket.cpp
src/server/game/Spells/Spell.cpp
src/server/game/Spells/SpellEffects.cpp
src/server/game/Spells/SpellInfo.cpp
src/server/scripts/Outland/HellfireCitadel/MagtheridonsLair/boss_magtheridon.cpp
src/server/scripts/Spells/spell_quest.cpp
src/server/shared/Logging/Log.h
src/server/worldserver/worldserver.conf.dist
src/tools/vmap3_extractor/model.h
src/tools/vmap4_extractor/CMakeLists.txt
src/tools/vmap4_extractor/dbcfile.cpp
src/tools/vmap4_extractor/dbcfile.h
src/tools/vmap4_extractor/loadlib/loadlib.h
2012-02-23 13:06:35 +01:00
leak
7a9f4c1f9b
Core/Warden: Base implementation for Warden functionality
...
Note: The default config file action for clients failing the checks can be changed for each check via the characters.warden_action table
Credits to TOM_RUS
2012-02-19 13:51:16 +01:00
leak
ded70b341f
DB/Schema: Update auth db base SQL to recent mysqldump format
2012-02-19 13:21:14 +01:00
Gyx
769399a7f6
P10: Update account expansion default 3 for 4.x
...
Signed-off-by: Gyx <2359980687@qq.com>
2012-01-10 10:07:22 +08:00
Rat
6896855b0d
modified base sql to use 14545 as default game version
2011-11-21 14:25:25 +01:00
Machiavelli
88b8f60cd2
Core/Commands: Allow muting offline players - the mute will become effective on next player login.
2011-07-27 17:51:57 +02:00
Nay
650d248aff
DB/SQL: No tabs nor CR line feeds
2011-05-18 15:51:42 +01:00
silinoron
3f5a386638
Add support for recruit-a-friend XP and reputation multipliers.
...
More research needs to be done to implement summoning and granting levels.
--HG--
branch : trunk
2010-08-17 19:18:09 -07:00
Brian
f6cc053037
* Proper naming for auth SQL file
...
* Update base SQL file for new installs
--HG--
branch : trunk
rename : sql/updates/3.3.5a_old/8861_realmd_realmlist.sql => sql/updates/3.3.5a_old/8861_auth_realmlist.sql
2010-07-09 02:33:42 -06:00
Brian
5a9076486f
* Renamed some directories in sql/ to more accurately reflect their purpose
...
--HG--
branch : trunk
rename : sql/auth_database.sql => sql/base/auth_database.sql
rename : sql/character_database.sql => sql/base/character_database.sql
rename : sql/world_database.sql => sql/base/world_database.sql
rename : sql/tools/CMakeLists.txt => sql/create/CMakeLists.txt
rename : sql/tools/create_mysql.sql => sql/create/create_mysql.sql
rename : sql/tools/drop_mysql.sql => sql/create/drop_mysql.sql
rename : sql/full/CMakeLists.txt => sql/scripts/CMakeLists.txt
rename : sql/full/world_script_texts.sql => sql/scripts/world_script_texts.sql
rename : sql/full/world_script_waypoints.sql => sql/scripts/world_script_waypoints.sql
rename : sql/full/world_scripts_full.sql => sql/scripts/world_scripts_full.sql
2010-06-09 00:54:15 -06:00