Jump to content
TrinityCore

Daniel25

Members
  • Content count

    115
  • Joined

  • Last visited

  • Days Won

    5

Daniel25 last won the day on November 12 2017

Daniel25 had the most liked content!

Community Reputation

6 Neutral

1 Follower

About Daniel25

  • Rank
    Advanced Member

Profile Information

  • Gender
    Male

Recent Profile Visitors

1248 profile views
  1. 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
  2. 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....
  3. 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.
  4. Trigger fishing event on low pop server

    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.
  5. Shadows of Argus

    Omg....you are really awesone and you did a great work, a lot of thanks ^^.
  6. 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....
  7. 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...
  8. 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.
  9. 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...
  10. 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.
  11. TrinityCore Extracting

    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).
  12. TrinityCore Extracting

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

    Erg...it isnt so difficult man... Here you have a Spanish video-Guide
  14. How to make gameobjects work

    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
×