Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Daniel25 last won the day on April 22 2022

Daniel25 had the most liked content!

1 Follower

Profile Information

  • Gender

Recent Profile Visitors

3949 profile views

Daniel25's Achievements


Newbie (1/14)

  • First Post Rare
  • Collaborator Rare
  • Week One Done Rare
  • One Month Later Rare
  • One Year In Rare

Recent Badges



  1. 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
  2. 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
  3. 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.
  4. You can try to add this patch manually if you want try it: UPDATE `access_requirement` SET `difficulty`=4 WHERE `mapid`=564;
  5. 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
  6. 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....
  7. 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.
  8. 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.
  9. Omg....you are really awesone and you did a great work, a lot of thanks ^^.
  10. 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....
  11. 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...
  12. 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.
  13. 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...
  • Create New...