[LF] Need DB developers for the Emucoach repack projects
What's new

CLOSED 5.4.8 Blizzlike Mists of Pandaria - v1.7 - [EmuCoach's Official Repack]

Status
Not open for further replies.
V

vu159

Gold Supporter
Veteran Member
72
2017
6
could you please be so nice and release it as repack? I don't know how to use heidisql.
if i download the repack without patch datas there will be errors and world.exe closes after a few seconds.
thank you
 
Jack Sparrow

Jack Sparrow

Gold Supporter
Senior User
342
2015
202
vu159 said:
could you please be so nice and release it as repack? I don't know how to use heidisql.
if i download the repack without patch datas there will be errors and world.exe closes after a few seconds.
thank you
Click to expand...

Yes I will update the _Server (mysql)
 
V

vu159

Gold Supporter
Veteran Member
72
2017
6
i always get errors
what am i doing wrong?
i only download new data from links. than i copied the data to data start mysql batch. after this i started authserver.exe and than world.exe
i post the error logs

roject Azenor 2c0ff82bfeba+ 2019-03-26 10:02:08 -0400 (master branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

Using configuration file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf.
Using SSL version: OpenSSL 1.1.1a 20 Nov 2018 (library: OpenSSL 1.1.1b 26 Feb 2019)
Using Boost version: 1.66.0
Process priority class set to HIGH
Realm running as realm ID 1
Using World DB: TICore_DB_Feb2019
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir Data/
WORLD: MMap data directory is: Data/mmaps
VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1
VMap data directory is: Data/vmaps
Missing name NoCheatPlus.Enabled in config file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf, add "NoCheatPlus.Enabled = 0" to this file
Missing name Packets.ForceCharTemplate in config file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf, add "Packets.ForceCharTemplate = 1" to this file
Loading Trinity strings...
>> Loaded 1483 Trinity strings from table trinity_string in 4 ms
Initialize data stores...
>> Initialized 171 DBC data stores in 566 ms
Using enUS DBC Locale
Loading SpellInfo store...
>> Loaded spell info store in 764 ms
Loading TalentSpellInfo store....
Loading SpellPowerInfo store....
Loading SkillLineAbilityMultiMap Data...
>> Loaded 8240 SkillLineAbility MultiMap Data in 1 ms
Loading spell custom attributes...
>> Loaded spell custom attributes in 82 ms
Loading GameObject models...
>> Loaded 5534 GameObject models in 2 ms
Loading Script Names...
>> Loaded 5570 Script Names in 163 ms
Loading Instance Template...
>> Loaded 119 instance templates in 0 ms
Loading character cache store...
Loaded character infos for 3 characters in 0 ms
Loading instances...
>> Loaded instances in 2 ms
Loading Localization strings...
>> Loaded 60753 creature locale strings in 258 ms
>> Loaded 29625 gameobject locale strings in 79 ms
>> Loaded 72214 Item locale strings in 172 ms
>> Loaded 18024 Quest locale strings in 693 ms
>> Loaded 1849 PageText locale strings in 8 ms
>> Loaded 5488 gossip_menu_option locale strings in 13 ms
>> Loaded 494 points_of_interest locale strings in 1 ms
>> Localization strings loaded in 1224 ms
Loading Page Texts...
>> Loaded 2311 page texts in 6 ms
Loading Game Object Templates...
>> Loaded 29659 game object templates in 173 ms
Loading Game Object template addons...
>> Loaded 7747 game object template addons in 7 ms
Loading Transport templates...
>> Loaded 49 transport templates in 21 ms
Loading Spell Rank Data...
>> Loaded 170 spell rank records in 1 ms
Loading Spell Required Data...
>> Loaded 22 spell required records in 0 ms
Loading Spell Group types...
>> Loaded 620 spell group definitions in 1 ms
Loading Spell Learn Skills...
>> Loaded 145 Spell Learn Skills from DBC in 20 ms
Loading Spell Learn Spells...
>> Loaded 21 spell learn spells + 360 found in DBC in 20 ms
Loading Spell Proc Event conditions...
>> Loaded 751 extra and 45 custom spell proc event conditions in 2 ms
Loading Spell Proc conditions and data...
>> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty.
Loading Spell Bonus Data...
>> Loaded 417 extra spell bonus data in 0 ms
Loading Aggro Spells Definitions...
>> Loaded 31 SpellThreatEntries in 1 ms
Loading Spell Group Stack Rules...
>> Loaded 60 spell group stack rules in 0 ms
Loading forbidden spells...
>> Loaded 96 forbidden spells in 0 ms
Loading NPC Texts...
>> Loaded 10834 npc texts in 28 ms
Loading Enchant Spells Proc datas...
>> Loaded 18 enchant proc data definitions in 0 ms
Loading Item Random Enchantments Table...
>> Loaded 30180 Item Enchantment definitions in 40 ms
Loading Disables
>> Loaded 5309 disables in 7 ms
Loading Items...
>> Loaded 72191 item templates from Item-sparse.db2 and 0 from database in 79 ms
Loading Item set names...
>> Loaded 667 item addon templates in 1 ms
>> Loaded 28 item script names in 0 ms
>> Loaded 33090 item specs override in 3 ms
>> Loaded 142789 item specs in 46 ms
Loading Creature Model Based Info Data...
>> Loaded 41982 creature model based info in 52 ms
Loading Creature templates...
>> Loaded 62827 creature definitions in 927 ms
Loading Creature difficulty templates...


and

Creature (Entry: 91986) lists non-existing Modelid1 id (62148), this can crash the client.
No model data exist for `Modelid1` = 0 listed by creature (Entry: 91986).
Creature (Entry: 91986) does not have any existing display id in Modelid1/Modelid2/Modelid3/Modelid4.
[1054] Unknown column 'flags_extra' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

i don't know what to do!
the first launch worked perfect.
sorry for beeing dumb!
and thanks again.....


ps:
if this is the problem:
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
please tell me how to update!

once again thanks
 
Jack Sparrow

Jack Sparrow

Gold Supporter
Senior User
342
2015
202
vu159 said:
i always get errors
what am i doing wrong?
i only download new data from links. than i copied the data to data start mysql batch. after this i started authserver.exe and than world.exe
i post the error logs

roject Azenor 2c0ff82bfeba+ 2019-03-26 10:02:08 -0400 (master branch) (Win64, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

Using configuration file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf.
Using SSL version: OpenSSL 1.1.1a 20 Nov 2018 (library: OpenSSL 1.1.1b 26 Feb 2019)
Using Boost version: 1.66.0
Process priority class set to HIGH
Realm running as realm ID 1
Using World DB: TICore_DB_Feb2019
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir Data/
WORLD: MMap data directory is: Data/mmaps
VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1
VMap data directory is: Data/vmaps
Missing name NoCheatPlus.Enabled in config file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf, add "NoCheatPlus.Enabled = 0" to this file
Missing name Packets.ForceCharTemplate in config file F:/Wow - Repacks/Emucoach 5.4.8/Core/worldserver.conf, add "Packets.ForceCharTemplate = 1" to this file
Loading Trinity strings...
>> Loaded 1483 Trinity strings from table trinity_string in 4 ms
Initialize data stores...
>> Initialized 171 DBC data stores in 566 ms
Using enUS DBC Locale
Loading SpellInfo store...
>> Loaded spell info store in 764 ms
Loading TalentSpellInfo store....
Loading SpellPowerInfo store....
Loading SkillLineAbilityMultiMap Data...
>> Loaded 8240 SkillLineAbility MultiMap Data in 1 ms
Loading spell custom attributes...
>> Loaded spell custom attributes in 82 ms
Loading GameObject models...
>> Loaded 5534 GameObject models in 2 ms
Loading Script Names...
>> Loaded 5570 Script Names in 163 ms
Loading Instance Template...
>> Loaded 119 instance templates in 0 ms
Loading character cache store...
Loaded character infos for 3 characters in 0 ms
Loading instances...
>> Loaded instances in 2 ms
Loading Localization strings...
>> Loaded 60753 creature locale strings in 258 ms
>> Loaded 29625 gameobject locale strings in 79 ms
>> Loaded 72214 Item locale strings in 172 ms
>> Loaded 18024 Quest locale strings in 693 ms
>> Loaded 1849 PageText locale strings in 8 ms
>> Loaded 5488 gossip_menu_option locale strings in 13 ms
>> Loaded 494 points_of_interest locale strings in 1 ms
>> Localization strings loaded in 1224 ms
Loading Page Texts...
>> Loaded 2311 page texts in 6 ms
Loading Game Object Templates...
>> Loaded 29659 game object templates in 173 ms
Loading Game Object template addons...
>> Loaded 7747 game object template addons in 7 ms
Loading Transport templates...
>> Loaded 49 transport templates in 21 ms
Loading Spell Rank Data...
>> Loaded 170 spell rank records in 1 ms
Loading Spell Required Data...
>> Loaded 22 spell required records in 0 ms
Loading Spell Group types...
>> Loaded 620 spell group definitions in 1 ms
Loading Spell Learn Skills...
>> Loaded 145 Spell Learn Skills from DBC in 20 ms
Loading Spell Learn Spells...
>> Loaded 21 spell learn spells + 360 found in DBC in 20 ms
Loading Spell Proc Event conditions...
>> Loaded 751 extra and 45 custom spell proc event conditions in 2 ms
Loading Spell Proc conditions and data...
>> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty.
Loading Spell Bonus Data...
>> Loaded 417 extra spell bonus data in 0 ms
Loading Aggro Spells Definitions...
>> Loaded 31 SpellThreatEntries in 1 ms
Loading Spell Group Stack Rules...
>> Loaded 60 spell group stack rules in 0 ms
Loading forbidden spells...
>> Loaded 96 forbidden spells in 0 ms
Loading NPC Texts...
>> Loaded 10834 npc texts in 28 ms
Loading Enchant Spells Proc datas...
>> Loaded 18 enchant proc data definitions in 0 ms
Loading Item Random Enchantments Table...
>> Loaded 30180 Item Enchantment definitions in 40 ms
Loading Disables
>> Loaded 5309 disables in 7 ms
Loading Items...
>> Loaded 72191 item templates from Item-sparse.db2 and 0 from database in 79 ms
Loading Item set names...
>> Loaded 667 item addon templates in 1 ms
>> Loaded 28 item script names in 0 ms
>> Loaded 33090 item specs override in 3 ms
>> Loaded 142789 item specs in 46 ms
Loading Creature Model Based Info Data...
>> Loaded 41982 creature model based info in 52 ms
Loading Creature templates...
>> Loaded 62827 creature definitions in 927 ms
Loading Creature difficulty templates...


and

Creature (Entry: 91986) lists non-existing Modelid1 id (62148), this can crash the client.
No model data exist for `Modelid1` = 0 listed by creature (Entry: 91986).
Creature (Entry: 91986) does not have any existing display id in Modelid1/Modelid2/Modelid3/Modelid4.
[1054] Unknown column 'flags_extra' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

i don't know what to do!
the first launch worked perfect.
sorry for beeing dumb!
and thanks again.....


ps:
if this is the problem:
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
please tell me how to update!

once again thanks
Click to expand...

Download from the quick post!! Cant edit main one atm
 
Jack Sparrow

Jack Sparrow

Gold Supporter
Senior User
342
2015
202
NOTE: Not all fixes are listed here!

Changelog (1.2-1.3)

Fix Crash in Condition System
Fix Crash in Map
Fix Crash in MotionMaster
Group: Rewrite Ready check system
Fix some error logs in opcodes
Fix invalid read crash
Fix uninitalized value in ClientUpdateWorldState
Redo some packets to packet system: CMSG_PARTY_UNINVITE, CMSG_LEAVE_GROUP, CMSG_SET_PARTY_LEADER, CMSG_SET_PARTY_ASSIGNMENT
Update the rest of group/party packets
fix a crash in ClientPartyMemberState
Fix ClientRaidMarkersChanged
Shadowmeld now doesn't get consumed if it was applied for only 0.5 sec
Fix issue with orientation desync with client/server
Change lock mutex from std to boost in VMapManager
Fix Crash in Spell (Frozen orb)
Updated encounter data for Temple of Jade Serpent
Implement Character Cache (Based on https://github.com/TrinityCore/TrinityCore/pull/19030 but some edits/improvements like zone/position storage) - Now functions that queried database each time are stored (querying database not async is bad! when you do that the database will freeze all other threads until the query is complete!! This is now fixed for some cases (like looking at guild roster and the core returning what zone they are in))
Fix FoV bug with some mounts
Implemented SPELL_ATTR5_START_PERIODIC_AT_APPLY
Fix SPELL_AURA_MOD_INVISIBILITY
Shattering Throw is now interrupted by Disarm
SPELL_PREVENTION_TYPE_PACIFY should not be a prevention type for HandleAuraModSilence
Implement SPELL_AURA_MOD_INCREASE_HEALTH_PERCENT_2
Remove some usless hacks in spell
Fix crash in SmartAI
Update SMSG_PARTY_MEMBER_STATE
Optimize WorldObject::GetGridActivationRange
Fix big issue in urand (wasn't retuning a random number at all..)
Group packets: SMSG_GROUP_DECLINE SMSG_ROLE_POLL_INFORM SMSG_MINIMAP_PING SMSG_RANDOM_ROLL redone in packet system
Fix dash calculation speed
Fix Nature's Vigil
Fix soul of the forest for balance spec
Fix wild charge of cat form, now jumps correctly and dazes for 3s
Fix crash in SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST
Send hover packets in Unit::SetHover (will fix levitate visual)
Fix another crash in SmartAI.
SunwellPlateau: Setup instance, WIP Kalecgos (20%) (Don't even bother reporting bugs on it yet)
Fix another crash with spell in SPELL_STATE_CASTING
Fix some npc in Wintergrasp
Fix gridunload = 1 crash
Refix issue: Invite party in Roster Tab From guild window (wasn't working on linux compile)
Send ClientSetFlatSpellModifier and ClientSetPctSpellmodifier on player map change (Fixes rapture for powerword shield when you change map) :)
Fix some spellmod issues
Slice and Dice and other spell now show floating combat text
Fix lava burst dmg with flame shock
Fix black arrow, Serpent sting, and explosive shot damage
Implement SPELLMOD_GLOBAL_COOLDOWN in SpellHistory system (our cooldown system) Now glyph of deep freeze works
Move some eclipse code from unit to player class


Issues fixed:

https://www.emucoach.com/showthread.php/5990-Quest-Unexpected-Results
https://www.emucoach.com/showthread.php/6037-Mount-camera-bug
https://www.emucoach.com/showthread.php/6034-Dash-wrong-numbers
https://www.emucoach.com/showthread.php/6018-Nature-s-Vigil-Battle-Fatigue
https://www.emucoach.com/showthread.php/6049-Warrior-Auto-attack-no-rage
https://www.emucoach.com/showthread.php/6052-Rogue-Slice-and-Dice
https://www.emucoach.com/showthread.php/6050-Warrior-Double-Time-Talent
https://www.emucoach.com/showthread.php/6017-Glyph-of-Deep-Freeze
 
V

vu159

Gold Supporter
Veteran Member
72
2017
6
damn sorry once again

Core: https://mega.nz/#!tdUxCI7b!-kShRNNW2...B51SXNECe7IrbM
_Server https://mega.nz/#!hcNjxSZA!nyX3du1Bd...ST5Uc9LplrptuY
i downloaded both
i extacted both and copied the dbc files to data....
but i once again get the errors i copied before

i don't want to bother you with my little problems but i can't start an play and have fun without you or other members help
i am so sorry

i tested a few things with heidisql
i downloaded the zip version started the exe file...
than i had to make a session name .....done
than there are a few settings like networt type (mariadb or mysql i selected)
host ip 127.0.0.1
user: i chose root pw: ascedent if the spelling is right i also used trinity trinity
port 3306
i used data base world
than i clicked open
after this i clicked on file and than on run sql file i selected your file 1.2 - 1.3
loading ......done
and now what do i have to do now?
because if i start the server the old problems are still there

with my little english i hope i could described good enough what my problem is
 
Last edited by a moderator:
Jack Sparrow

Jack Sparrow

Gold Supporter
Senior User
342
2015
202
If you were able to run the query in world db, then try this:

Code: 
ALTER TABLE `creature_difficulty_template`
	ADD COLUMN `flags_extra` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `ArmorModifier`;

Was pretty sure its in db..
 
V

vu159

Gold Supporter
Veteran Member
72
2017
6
thank you once again i am off right now
i don't know what you want to say with that line because i don't know where to find it and how to edit it.....
thank you for you damn good work have a nice day bye
 
Pandaxyz

Pandaxyz

Gold Supporter
Veteran Member
Verified Member
33
2018
1
Cross faction battleground is not working even enabled in worldserver.config also there is no bosses in TOT 10 man and 25 man. Thanks jack fighting
 
A

Adnisen

Gold Supporter
22
2014
1
Is there anyone who would like to explain for me how I update the repack? I am using HeidiSQL, I've downloaded the following:

1: Core
2: _Server

After that I replaced the core and server inside the repack's folder, when that step was done I started HeidiSQL and ran the "SQL Updates -1,2 - 1,3" by logging in to the database, clicking the world and run the sql file directly into it.

There must be something I've done terribly wrong or haven't understand, I would really appreciate some help with this one please.

Furthermore I want to give credits to the team for the hard work put into this project.
 
V

vu159

Gold Supporter
Veteran Member
72
2017
6
Adnisen said:
Is there anyone who would like to explain for me how I update the repack? I am using HeidiSQL, I've downloaded the following:

1: Core
2: _Server

After that I replaced the core and server inside the repack's folder, when that step was done I started HeidiSQL and ran the "SQL Updates -1,2 - 1,3" by logging in to the database, clicking the world and run the sql file directly into it.

There must be something I've done terribly wrong or haven't understand, I would really appreciate some help with this one please.

Furthermore I want to give credits to the team for the hard work put into this project.
Click to expand...


this is exactly what i did but there is no button like finish or save and exit or save.......
only refesh


but when i do nothing after what you did i only get errors
 
Last edited by a moderator:
Status
Not open for further replies.
Top