Daniel25

What Aokromes said is true. I will tell you any advices in case you didnt know it: - Dont use cmake if you only changed any lines in any files. Every time that you use cmake, compilation will take more time to compile. - Dont clear proyect in visual studio if you didnt add new files in the project or it will compile everything there. - You can disable tools (map extractors) of source in cmake so it wont compile with the project and it will be faster. Regards

Well its ashamanecore based in trinitycore,bfa 34220. Log hasnt more data... With every quest in starting zones,for example: https://classic.wowhead.com/quest=8325/reclaiming-sunstrider-isle In trinity master it works good,I wasted a lot of hours trying to figure where is the issue and I would like to fix it...I think that it could be packets,or something related to entities/player.cpp. The quests are autoaccept,you get the quest and when you click the accept button to close the gossip so the game get stuck. You can move,writte in chat,open talents,but if you click the npc or others npcs they dont show the gossip menu,or vendor menu,etc.Since that you click accept quest worldserver console repeat message 4 or 5 times and then you get disconnected: Did not receive CMSG_TIME_SYNC_RESP for over 30 seconds from 'Nel' (Player-1-00000004), possible cheater

Hello,I was wondering if someone has some idea about what could cause the issue. I get this in worldserver console when I accept a quest in starting zone (autoaccept quests),it happens in all starting zone,classes,races,but only with that quests: No defined handler for opcode [UNKNOWN OPCODE 0x3553 (13651)] sent by [Player: Nel Player-1-00000004, Account: 1] MoveSplineInitArgs::Validate: expression '_checkPathLengths()' failed for Creature-0-1-530-0-15274-0000000031 Entry: 15274 Player::SendTimeSync: Did not receive CMSG_TIME_SYNC_RESP for over 30 seconds from 'Nel' (Player-1-00000004), possible cheater Then of 30 secs or so I get disconnected of the server.I haven't more logs or info about itt. If someone knows what could be...A lot of thx.

You can try to add this patch manually if you want try it: UPDATE `access_requirement` SET `difficulty`=4 WHERE `mapid`=564;

Sorry I understood it wrong...

I'm not sure but I guess its why you forgott to add .git in the rute. Repository to clone: https://github.com/trinityCore/trinityCore.git

First time i only added manually base auth/characters and tdb_full hotfixes and world (I have done this several times before, I follow your job since long time ago and I have installed the most of your server versions and everything was ok always this way). Nevermind... I followed your instructions (dropped every db) and I allowed worldserver.exe to create dbs and update it...same log error... and I didnt import manually any sql file this time....

Hello I have done a clear install core and db yesterday. I added the base auth/characters db, TDB_full_735.00_2018_02_19 (world and hotfixes). Auth and characters got autoupdated when i ran the worldserver.exe but I'm getting this error with hotfixes db (log): In mysql_stmt_prepare() id: 46, sql: "SELECT ID, Flags, ClientPrefix, ClientFileString, Name, NameFemale, NameMale, FacialHairCustomization1, FacialHairCustomization2, HairCustomization, CreateScreenFileDataID, SelectScreenFileDataID, MaleCustomizeOffset1, MaleCustomizeOffset2, MaleCustomizeOffset3, FemaleCustomizeOffset1, FemaleCustomizeOffset2, FemaleCustomizeOffset3, LowResScreenFileDataID, FactionID, MaleDisplayID, FemaleDisplayID, ResSicknessSpellID, SplashSoundID, CinematicSequenceID, BaseLanguage, CreatureType, TeamID, RaceRelated, UnalteredVisualRaceID, CharComponentTextureLayoutID, DefaultClassID, NeutralRaceID, ItemAppearanceFrameRaceID, CharComponentTexLayoutHiResID, HighResMaleDisplayID, HighResFemaleDisplayID, Unk1, Unk2, Unk3 FROM chr_races ORDER BY ID DESC" Unknown column 'NameMale' in 'field list' In mysql_stmt_prepare() id: 47, sql: "SELECT ID, Name_lang, NameFemale_lang, NameMale_lang FROM chr_races_locale WHERE locale = ?" Unknown column 'NameMale_lang' in 'field list' In mysql_stmt_prepare() id: 158, sql: "SELECT ID, Key1, Key2, Key3, Key4, Key5, Key6, Key7, Key8, Key9, Key10, Key11, Key12, Key13, Key14, Key15, Key16, Key17, Key18, Key19, Key20, Key21, Key22, Key23, Key24, Key25, Key26, Key27, Key28, Key29, Key30, Key31, Key32 FROM key_chain ORDER BY ID DESC" Table 'hotfixes.key_chain' doesn't exist In mysql_stmt_prepare() id: 210, sql: "SELECT ID, Name, Script, PrevScriptId, NextScriptId FROM scene_script ORDER BY ID DESC" Unknown column 'Name' in 'field list' In mysql_stmt_prepare() id: 214, sql: "SELECT ID, SpellID, RaceMask, SupercedesSpell, SkillLine, MinSkillLineRank, TrivialSkillLineRankHigh, TrivialSkillLineRankLow, UniqueBit, TradeSkillCategoryID, AcquireMethod, NumSkillUps, Unknown703, ClassMask FROM skill_line_ability ORDER BY ID DESC" Unknown column 'Unknown703' in 'field list' In mysql_stmt_prepare() id: 216, sql: "SELECT Name, VolumeFloat, MinDistance, DistanceCutoff, VolumeVariationPlus, VolumeVariationMinus, PitchVariationPlus, PitchVariationMinus, PitchAdjust, Flags, SoundEntriesAdvancedID, BusOverwriteID, SoundType, EAXDef, DialogType, Unk700, ID FROM sound_kit ORDER BY ID DESC" Unknown column 'Name' in 'field list' In mysql_stmt_prepare() id: 217, sql: "SELECT ID, Name_lang FROM sound_kit_locale WHERE locale = ?" Table 'hotfixes.sound_kit_locale' doesn't exist In mysql_stmt_prepare() id: 220, sql: "SELECT Name, NameSubtext, Description, AuraDescription, MiscID, ID, DescriptionVariablesID FROM spell ORDER BY ID DESC" Unknown column 'MiscID' in 'field list' In mysql_stmt_prepare() id: 233, sql: "SELECT ID, Coefficient, Variance, ResourceCoefficient, SpellEffectID FROM spell_effect_scaling ORDER BY ID DESC" Table 'hotfixes.spell_effect_scaling' doesn't exist In mysql_stmt_prepare() id: 281, sql: "SELECT ID, Flags, TurnSpeed, PitchSpeed, PitchMin, PitchMax, MouseLookOffsetPitch, CameraFadeDistScalarMin, CameraFadeDistScalarMax, CameraPitchOffset, FacingLimitRight, FacingLimitLeft, MsslTrgtTurnLingering, MsslTrgtPitchLingering, MsslTrgtMouseLingering, MsslTrgtEndOpacity, MsslTrgtArcSpeed, MsslTrgtArcRepeat, MsslTrgtArcWidth, MsslTrgtImpactRadius1, MsslTrgtImpactRadius2, MsslTrgtArcTexture, MsslTrgtImpactTexture, MsslTrgtImpactModel1, MsslTrgtImpactModel2, CameraYawOffset, MsslTrgtImpactTexRadius, SeatID1, SeatID2, SeatID3, SeatID4, SeatID5, SeatID6, SeatID7, SeatID8, VehicleUIIndicatorID, PowerDisplayID1, PowerDisplayID2, PowerDisplayID3, FlagsB, UILocomotionType FROM vehicle ORDER BY ID DESC" Unknown column 'MsslTrgtTurnLingering' in 'field list' Dunno if I have missed any update or I did something wrong but I guess that its a issue with the last patch in folder old\7\hotfixes\01_2018_02_19 ,where patch 2018_02_18_00_hotfixes.sql drop "namemale" field and others need and maybe it happens with db world too with the same patch in world. Any idea? Thanks you. PS: If the issue is that patch, the TDB_full_735.00_2018_02_19 include that patch too so It would need to revert it too there.

If I'm not wrong you can modify the time in the db. There are a little tables for the events there but I'm not sure about these specific event.

Omg....you are really awesone and you did a great work, a lot of thanks ^^.

nvm

For modify host file you have to uncheck "read only" in the file propierties... If you dont modify the host file, server will be never online... I think that you can use hamachi for more than 5 people....

Well...this is a spanish video-tutorial but maybe it can help you: trinity public server By the way, I remember that old versions as 3.3.5 used differents ports but I'm not sure if it has changed and trinity 3.3.5 use the same ports than legion now... Check your server configs for knowing it...

That is the script used for completing a objective when in quest_objectives table the type of objective is 0 (npc) or 2 (object) and you dont need to kill it really. When you can kill the npc you dont need the script because when you kill the npc the quest_objective will get completed withouth the script. The script complete the quest_objective when you click the option in the gossip_menu withouth you need to kill any npc.

First option which Rat told you: INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`, `action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (object_with_gossip,1,0,1,62,0,100,0,gossip_id,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'object_with_gossip- On gossip option 0 select - Close gossip'), (object_with_gossip,1,1,0,62,0,100,0,gossip_id,0,0,0,33,object_killcredit_id,0,0,0,0,0,7,0,0,0,0,0,0,0,'object_with_gossip- On gossip option 0 select - object_killcredit- quest'); Blizzlike option: INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`, `action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (object_with_gossip,1,0,1,62,0,100,0,gossip_id,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'object_with_gossip- On gossip option 0 select - Close gossip'), (object_with_gossip,1,1,0,62,0,100,0,gossip_id,0,0,0,11, 79181 ,0,0,0,0,0,7,0,0,0,0,0,0,0,'object_with_gossip- On gossip option 0 select - cast spell 79181- killcredit quest'); In second one, the spell surely works but if it isnt, so you will have to fix it in the core I guess...

Maybe your issue is your client if you donwloaded it of a private server site. Did you patch your wow.exe? Change the realmlist in the config.wtf file (set realmlist "127.1.0.0") of your wow and check in propierties "only read". Be sure that your wow client version is the same than trinity core version soported.

In your screenshots I see that you are using english in your OS so I guess that you dont know spanish but just in case that you do it, a video-guide in spanish Installing software requerided I guess that you should to check the guide in the trinity wiki, you have everything that you need there,include the versions for every software need (HannibalRog gave you the link up).

I thougth the same, so weird. +credit for helping people

Erg...it isnt so difficult man... Here you have a Spanish video-Guide

Yes, the correct database is which you used dduarte 720 TDB_full_720.00_2017_04_18.7z Truncate the world database, add the sql file tdb full 720 and turn on run updates automatly in the worldserver.config. Then run the worldserver.exe and everything should to be ok. Dont forget to delete the cache client folder before of starting the wowpatched..exe

@CDawg thanks you, i just got the zip and it worked good. In the end I had to fix the quest in different way, it wasnt a areatrigger :P. Thanks you both for the help. The topic can be closed. (if you are curiose what quest it was Quest 39384 )

Well i was going to tell you about clearing your cache too. If it doesnt work: You can truncate the world database, import the world sql file downloaded of trinity and then you run the worldserver.exe so updates get added automatly.And everything should to work good. Just wondering why you used a different database of trinity instead of trinity one...

@darki73 ow i didnt see that, thanks you and thanks you for the link to check column structure :P.

A lot of thanks you, Im doing a video-tutorial for fixing quest 39384 and i need it for the areaexplore objective ^^. EDit::The compilation is giving error, i will have to wait for a fix, thx.

Hello, I'm looking for a software for opening areatrigger.db2, I need to check a id for fixing a quest and mydbceditor doesnt open db2 files. Any suggestion? Thanks you.