Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Piccolodmq

Pages: [1] 2 3
Hi there

I still dont get how the structure of CreatureModelDisplay model works.

When I am creating a Custom model, I know I need a Creature model Data id number in the second column.

Question is how do I know what goes where in 7 - 8 - 9 - 10 column.

Sometimes I find, one simple BLP file in the creature folder, like Pigman.blp.   And easy as that,  something there are more BLP, with skin color, so I have to put in column, 7 Pigman.blp, and in column 8 pigman_brown.blp. as an example.   

But this is with some models and other just have different configuration of how you arrange the Blp in the creaturemodelDisplay.dbc.

Could someone guide me of how I should arrange this custom models CreatureModelDisplay values? So I dont get White or green models?

In the picture below I get white models on both Pigman and Alpaca models... no matter how I arrange BLP info in them.


"Retro-Porting" / (Possible RELEASE) - BROKEN ISLES
« on: June 23, 2018, 06:09:21 pm »
Hi there again.

I retroported the Broken Isles, with almost all textures and WMO working, but I am having troubles getting the Ground Clutter Effects working.

I got it to work on Draenor, using this guide from Anthony a while back.
&t=98s , Basically you use a Tool (that I can not longer find), to manually Retroport NODTX files that contain the Ground Effects files.   Put them back on the Patch. And use DBC's from Legion and Wod, with dooad info (GroundEffectDoodad.dbc  and GroundEffectTexture.dbc), wich I also had.   

Since I didnt had the old tool mentioned in the tutorial I used for Draenor, I used this new tool wich is more up to date, and capable of doing Legion and WOD

But again, it didnt work for Legion.   

Could someone help?   If I get everything to work.  I could release it as a complete work here.




« on: May 24, 2018, 06:12:28 pm »
I dont know how phassing and quests, work.

I see this FLAG, in Quest_Template = 4194304   QUEST_FLAGS_UPDATE_PHASE_SHIFT

And I tried searching in the the DB for this Quest hat make Phase change both in NPC and Gameobjects, but coudnt find anything that I can replicate.,

I am trying to have a Quest change me to another Phase or the NPC's to my phase, either way.

I have tried using Mod Phase 1,2,3 and others, to the NPC that gives the quest I want.

THis one

But the NPC is still only availble on the command  GM ON.

... So what I want is, when XXXXX quest is complete, YYYY NPC to become visible or in my phase.

Or is there an easier way to do this?

"Retro-Porting" / Can't repair items above wotlk item level
« on: May 17, 2018, 03:40:58 pm »
Hi there, where in the DB or DBC, should I fix this? I have retroported all items from Legion/WOD/MOP and Cata, but cant repair items that have item level 333 or above (in other words, non WOTLK items).
If I take the item ingame with Item level above 333 to a blacksmith or any npc that can repair It will be able to repair it. So if its durability goes to zero, I cant wear the item anymore.

THis means, the durability keeps dropping until the item cannot be weared.

Is this a DBC or DB fix?


"Retro-Porting" / Retroporting FACTIONS(5.4.7 to 3.3.5a)
« on: May 01, 2018, 02:01:30 am »
Hi there, I have retroported Creature Template From a MOP repack to my 3.3.5a server, and everything works, except I get this error when I start the server, so I edited and got all the missing factions from Both Faction.dbc and FactionTemplate.dbc, but still get the error.

Creature (Entry: 62491) has non-existing faction template (1302). This can lead to crashes, aborting.

What do I have to edit in the DB, so I can have custom Factions?

This is the NPC (i know there most be lke a million more, that causes the crash because of the faction.

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (62491, 0, 0, 0, 0, 0, 42505, 0, 0, 0, 'Brewmaster Bo', '', '', 0, 90, 90, 4, 1302, 2, 1, 1.14286, 1, 1, 0, 2000, 2000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 123898, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 75, 10, 1, 2, 0, 0, 0, 1, 0, 0, '', 16048);

I folloed this guide, and it mentions nothing about DB or other changes.


"Retro-Porting" / Cataclysm Humanoid WOD Look trouble.
« on: April 20, 2018, 06:24:50 pm »
Hi there, I know the title seems confusing... but let me explain it a little bit farther.   I have a WOD Npc Patch, that makes all HUMANOID races (Human, Dwarf, Orc, Etc), have the WOD look upgrade.   There was no major issues, here.   They all look like well.

Like this

And here is what it looks just for the new npc from 4.3.4 I retroported from a cataclysm 4.3.4, the DBC I got are this CreatureDisplayInfo.dbc and CreatureDisplayinfoExtra.dbc. 

I wanted to get all Humanoid NPC, and their GPS location on map from Cataclysm, ( I got cataclysm MAP;s and VMAPS there.

Both working and not Working models, in CreatureDisplayInfo have the same creaturemodel in column 2, (49)  so I dont think that is the issue.    The las columns of the ones that work with the patch, have the CreatureDisplayExtra-00023_HD.blp (HD) So I guess thats the issue.  They are not part of the patch in the retroported DBC,s look like this CreatureDisplayExtra-22812.blp.  (no HD).   Any possible solution?

Hi there, I am proposing that I could do this (FUSING FINTERNIS HD CHARACTER MODELS WITH WORGEN PANDAREN AND GOBLIN) , and release it, if I could get the DBC files of your work.   I undesrtand that it is your work, so I am willing to pay for it.   Or I could let you have my files and you could fuse it with your work and release it, encrypted?

By the way , i PM you Finternis about this.

Modelling and Animation / Paying for developer [CUSTOM RACES]
« on: October 18, 2017, 01:36:50 pm »
Hi there

I am looking for someone who can make me custom races, I am want Cata Worgens, and Pandaren from Pandaria, for my custom Trinitycore Server TDB_full_world_335.62_2016_10_17. Maybe we could try something extra if you think you have the time and skills.

Races must be able to:

1- Have most or all haircuts, dances, sounds.
2- No missing gear related problems.
3- Basically work like any of the retail races.

My core has WOD models, creatures and I have some other custom stuff on it, but mostly it should be the same as doing this in fresh compiled core.

We can work in any way you want... uploading the server and patches I have, or you can work remotely, or portion of both.

I have other requests, but lets start with this, to see if we can work together.

Whatsapp +51987717515
skype = piccolodmq


« on: September 26, 2017, 04:38:17 pm »
Hi there!

I am trying to retroport, mining ores and proffesion to 3.3.5a, and here what I have done so far.

1- get items working:   I used icons and items from Anthony's (Kronixusa), retroported items for the minerals ores.
2- I made custom mineral ore Gameobjects using the saronite ore as base, and everything works (I need 450 mining.. mining pick and I get blizzlike spawnrate for minerals ores.
3- I modified the spell 49258 in spell.dbc, wich is the one used for learning how to smelt 2 saronite ores into one saronite bar.  I changed only the rows that Described what the spell did and the item row for the ORE and BAR with the custom cata item numbers.
4- I putted the file both in the DBC and Patch of my client.
5- In npc_trainer DB, I copied one row that had the saronite smelting spell and replaced the spell Id with the custom one I made

"ID"   "SpellID"   "MoneyCost"   "ReqSkillLine"   "ReqSkillRank"   "ReqLevel"
"201035"   "49258"   "150000"   "186"   "400"   "0"

to this

"ID"   "SpellID"   "MoneyCost"   "ReqSkillLine"   "ReqSkillRank"   "ReqLevel"
"201035"   "90050"   "150000"   "186"   "400"   "0"

But when I go to the trainer, to buy the new smelting spell, i get an unknown, spell to lear, wich doesnt work or show up in my Mining Spell book.

I am sure I am missing something, but dont know what it is!  thanks!

Miscellaneous / Another SmartAI question
« on: August 26, 2017, 07:04:05 am »
I want to make an NPC phase me to Phase 2, after I accept a quest. After this, I want another NPC to follow a path, when I talk or are near it in that phase.

After I complete the quest I want to return to Phase 2.

This the SQL I am using to get the QUEST NPC to go to Phase 2 (not working)

-- Generated by Event Horizon - SAI Editor (

-- Captain Saynna Stormrunner
SET @ENTRY := 40139;

DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_ty pe`,`event_phase_mask`,`event_chance`,`event_flags `,`event_param1`,`event_param2`,`event_param3`,`ev ent_param4`,`action_type`,`action_param1`,`action_ param2`,`action_param3`,`action_param4`,`action_pa ram5`,`action_param6`,`target_type`,`target_param1 `,`target_param2`,`target_param3`,`target_x`,`targ et_y`,`target_z`,`target_o`,`comment`) VALUES
(@ENTRY,@SOURCETYPE,0,0,19,0,100,0,25325,0,0,0,22, 2,0,0,0,0,0,5,1,50000,0,0.0,0.0,0.0,0.0,"set phase"),
(@ENTRY,@SOURCETYPE,1,0,19,0,100,0,25325,0,0,0,22, 2,0,0,0,0,0,5,0,0,0,0.0,0.0,0.0,0.0,"set phase"),
(@ENTRY,@SOURCETYPE,2,0,19,0,100,0,25325,0,0,0,22, 2,0,0,0,0,0,18,50000,0,0,0.0,0.0,0.0,0.0,"set phase"),
(@ENTRY,@SOURCETYPE,3,0,19,0,100,0,25325,0,0,0,22, 2,0,0,0,0,0,2,50000,0,0,0.0,0.0,0.0,0.0,"set phase"),
(@ENTRY,@SOURCETYPE,4,0,19,0,100,0,25325,0,0,0,22, 2,0,0,0,0,0,17,1,50000,0,0.0,0.0,0.0,0.0,"set phase");

Npc I want to follow a path (or follow me in the case of this Sql) while in phase 2 is this one = 80276

-- Arch Druid Fandral Staghelm
SET @ENTRY := 80276;

DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_ty pe`,`event_phase_mask`,`event_chance`,`event_flags `,`event_param1`,`event_param2`,`event_param3`,`ev ent_param4`,`action_type`,`action_param1`,`action_ param2`,`action_param3`,`action_param4`,`action_pa ram5`,`action_param6`,`target_type`,`target_param1 `,`target_param2`,`target_param3`,`target_x`,`targ et_y`,`target_z`,`target_o`,`comment`) VALUES
(@ENTRY,@SOURCETYPE,0,0,25,0,100,0,0,0,0,0,11,3334 6,0,0,0,0,0,19,21348,15,0,0.0,0.0,0.0,0.0,"Shadow Council Warlock - On Reset - Cast Green Beam"),
(@ENTRY,@SOURCETYPE,1,0,1,0,100,1,0,0,0,0,11,33346 ,0,0,0,0,0,19,21348,15,0,0.0,0.0,0.0,0.0,"Shadow Council Warlock- OOC - Cast Green Beam (No repeat)"),
(@ENTRY,@SOURCETYPE,2,0,0,0,100,0,1000,2000,5000,7 000,11,9613,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0,"Sha dow Council Warlock- IC - Cast Shadow Bolt"),
(@ENTRY,@SOURCETYPE,3,0,0,0,100,0,6000,8000,10000, 12000,11,37992,0,0,0,0,0,2,0,0,0,0.0,0.0,0.0,0.0," Shadow Council Warlock- IC - Cast Drain Life"),
(@ENTRY,@SOURCETYPE,4,0,19,0,100,0,25325,0,0,0,29, 0,0,0,0,0,0,21,0,0,0,0.0,0.0,0.0,0.0,"quest follow");

THe npc, I wan to take me back while there to phase 1 is this one =

-- Alysra
SET @ENTRY := 40178;

DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=@SOURCETYPE;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY LIMIT 1;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_ty pe`,`event_phase_mask`,`event_chance`,`event_flags `,`event_param1`,`event_param2`,`event_param3`,`ev ent_param4`,`action_type`,`action_param1`,`action_ param2`,`action_param3`,`action_param4`,`action_pa ram5`,`action_param6`,`target_type`,`target_param1 `,`target_param2`,`target_param3`,`target_x`,`targ et_y`,`target_z`,`target_o`,`comment`) VALUES
(@ENTRY,@SOURCETYPE,0,0,19,0,100,0,25325,0,0,0,22, 1,0,0,0,0,0,17,1,50000,0,0.0,0.0,0.0,0.0,"set phase 1");


Any help with this? IN the part of the "follow me NPC" I tried using a dummy npc 80205 with wpoints (guid is 837778
)... so the NPC follows the guid as soon as I get to phase 2, and sees me... he starts walking.

Basically I am trying to recreate this quest fromo CATA to WOTLK.


Thanks for the help!

Miscellaneous / Smartai Question
« on: August 10, 2017, 05:47:06 pm »

Smartai Help

Hi There. Can anyone guide me making a npc (id 9999) summon a Game object (id 8888)' then the gobject casts a spell 7777 to itself (That can Hurt a player if near, and dissapear the gobject after 10 sec.


Miscellaneous / Migrating a server from one computer to another?
« on: June 23, 2017, 04:51:56 am »
Hi there everyone.

I have my custom server in a virtual computer that I am not able to keep on paying, next month.   I want to migrate the server from that computer to mine.    It is a trinitycore compiled  3.3.5 server (January 2017),  with tons of custom stuff (DBC and DB), 

I know I can just copy the BUILD and TRINITY files, but how do I get all the DB changes...?   IS there a way to export all the DB without going one file at a time (like exporting creature_template ... into a big file, and then importing in the new server.   

What is your suggestion so I can "clone" my server easily with characters, and changes?


Miscellaneous / Custom Cutscene on WOW 3.3.5a
« on: May 05, 2017, 08:11:08 am »
Is there a way to make a cutscene play (like the classic one fromo wotlk, where the lich king fights Bolvar, and the Horde, and Putricide, comes along, etc).  After I finish a quest?

If so, is it possible to put a custom AVi, or other format on it? 

Miscellaneous / Custom Quests FAQ
« on: April 14, 2017, 04:52:15 pm »
Hi, I am in the process of retroporting all the quests in Cata, to WOTLK.  I retroported easily all the cata quests,creatures, POI, and all the easy quests likekill 6 pigs, or get x item to Y npc, are alredy done.

So I have some questions regarding, more complex quests.  I hope this helps other people doing customs quests, of course also.

1- How do I make a quest change phases and then return me to the main phase after it is complete?
2- How do I make an NPC follow me when a quest is accepted and stops following me after it is done?
3- How do I make a game object, do stuff, like summon an NPC?
Amaroth said "You have to use SmartGameObjectAI instead of SmartAI in gameobject_template, and source_type=1 in smart_scripts. Thats all. The rest is just up to correct choice of events and actions."
But, I dont understand the mechanics of an object.  For example smartAI for an NPC can react to being damaged, healed, etc.  But I can relate this to a GO.

4- How do I make a quest play a custom cinematic?  I have seen that some in game cinematics, are stored in patches, so Howdo I activate them?

Thanks again for your time.  And I hope this becomes some kind of manual for custom quests!

Miscellaneous / Smart Scripts on Gameobjects
« on: April 14, 2017, 02:31:56 am »
I have made many smart scripts npcs in the past, so I am not stranger to the systems.   But I have never been able to mae smart scripts on gameobjects work.
I guess they all work with the SmartGameObjectAI, instead of the SmartAI that npcs have.

Any pointers?  for example lets say that. I want gobject= 1867290  to spawn when looted, touched or when I am nearby, this NPC. =39926

I have tried copying gamebojects like elizas tomb that spawn Eliza so you can fight her, with no luck.  Any help would be apreciated.

Pages: [1] 2 3