-=/PryDevServer-4TC:\=- Trinity Core!

[ceesec7]

GOOD NEWS! It works like a charm!
i fixed the map problem after I used Repair.exe. I only needed the maps file.
The sql problem persisted with the blizzlike realm. i feel so bad That it doesnt work but after that I imported the PVP realm and it worked.

Oh and I used these settings:
RealmID = 1
DataDir = "data"
LogsDir = ""

and it worked...
Anyway, thanks for the help!

OH AND Pryd I don't know why but the blizzlike realm - ytdb527_trin6676_pure still gives me the error I posted in my other post. Some answer would be appreciated hence I am interested in a blizzlike realm.

[whitekidney]

Can someone upload the DBC files for this server?

Client : 10505.


Will rep x4 !

[Wisher]

here it is...should work
dbc.rar

[gaminino3]

Pryd, is that possible on TC2 to put SD2 with working teleporter? I am looking for teleporter and vendors for my MatrixCore compiles ... if you can share the SVN of them it will be great! And + REP for this repack. Its wonderful!

Pryd, can you explain me how can I make my own quest teleporter? Where I can found a guide for it. I know that I need quice but I am not sure of all the details I need. If anyone know and can help me it will be great!

[pryd]

Pryd, is that possible on TC2 to put SD2 with working teleporter? I am looking for teleporter and vendors for my MatrixCore compiles ... if you can share the SVN of them it will be great! And + REP for this repack. Its wonderful!

Pryd, can you explain me how can I make my own quest teleporter? Where I can found a guide for it. I know that I need quice but I am not sure of all the details I need. If anyone know and can help me it will be great!

This is by no means the best way, or the right way.
But this is how I've always made a very simple custom teleporter like the Ulduar ones.

-- ----------------------------
-- [494] Ulduar Raid Instance Teleporter for YTDB 494 by PryDevServer
-- ----------------------------

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
	(NULL,909010,603,1,1,0,0,'916.787','-11.8069','418.582','3.20834','25','0',0,'5000','0',0,0),
	(NULL,909011,603,1,1,0,0,'1459.08','118.99','423.641','6.26311','25','0',0,'5000','0',0,0),
	(NULL,909012,603,1,1,0,0,'1987.11','-27.642','324.89','3.13591','25','0',0,'5000','0',0,0);

REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(909010,0,'0','0','26770',0,'26770',0,'Pryds Ulduar Helper1','PryDevServer Teleport Master','','80','80','5000','5000','0','0','2865','35','35','2','1','1',0,'60','165',0,'97','1','1500','1500',0,'0','0',0,0,0,0,0,'50','100',0,7,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,'3','0',1,'0','0','0','0','0',0,0,'2','0','');

REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(909011,0,'0','0','26770',0,'26770',0,'Pryds Ulduar Helper2','PryDevServer Teleport Master','','80','80','5000','5000','0','0','2865','35','35','2','1','1',0,'60','165',0,'97','1','1500','1500',0,'0','0',0,0,0,0,0,'50','100',0,7,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,'3','0',1,'0','0','0','0','0',0,0,'2','0','');

REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(909012,0,'0','0','26770',0,'26770',0,'Pryds Ulduar Helper3','PryDevServer Teleport Master','','80','80','5000','5000','0','0','2865','35','35','2','1','1',0,'60','165',0,'97','1','1500','1500',0,'0','0',0,0,0,0,0,'50','100',0,7,'0',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,1,'3','0',1,'0','0','0','0','0',0,0,'2','0','');


REPLACE INTO `creature_involvedrelation` (`id`, `quest`) VALUES (909010,912500),(909011,912501),(909012,912500),(909012,912501),(909012,912502);
REPLACE INTO `creature_questrelation` (`id`, `quest`) VALUES (909010,912500),(909011,912501),(909012,912500),(909012,912501),(909012,912502);

REPLACE INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
('912500', '3', '6', '603', 0, 0, '1497.54', '-24.267', '420.967', '0.027053'), -- Ulduar Area 1
('912501', '3', '6', '603', 0, 0, '2271.14', '292.793', '419.545', '3.13198'),  -- Ulduar Area 2
('912502', '3', '6', '603', 0, 0, '2342.83', '2571.02', '419.523', '6.27095'); -- Ulduar Area 4


REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES
(912500,0,876,0,80,80,0,0,0,0,0,0,0,0,0,0,'0',0,1,0,0,0,0,0,0,0,0,0,0,'Teleport to The Antechamber','So you want to teleport?','Speak with the Teleport Master again.','Are you sure, you\'re ready to teleport?',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0',0,'0',0,0,0,'0',0,'0','0',0,0,0,0,0,'0','0','0','0',0,0,0,1,0,0,'0','0','0','0',0,912500),
(912501,0,876,0,80,80,0,0,0,0,0,0,0,0,0,0,'0',0,1,0,0,0,0,0,0,0,0,0,0,'Teleport to The Corridors of Ingenuity','So you want to teleport?','Speak with the Teleport Master again.','Are you sure, you\'re ready to teleport?',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0',0,'0',0,0,0,'0',0,'0','0',0,0,0,0,0,'0','0','0','0',0,0,0,1,0,0,'0','0','0','0',0,912501),
(912502,0,876,0,80,80,0,0,0,0,0,0,0,0,0,0,'0',0,1,0,0,0,0,0,0,0,0,0,0,'Teleport to The Spark of Imagination','So you want to teleport?','Speak with the Teleport Master again.','Are you sure, you\'re ready to teleport?',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0',0,'0',0,0,0,'0',0,'0','0',0,0,0,0,0,'0','0','0','0',0,0,0,1,0,0,'0','0','0','0',0,912502);

This code is old- You would have to use heidisql, export the csv / sql to match the newer table fields for
whichever repack / core / database version you are using. I hope this helps

PDS Repack 4 has just been released. Major core update. I included sql files
in the database folder for those that want to update seamlessly from repack
3a to 4 and not have issues w/ characters / realmd.

The items will hopefully be fixed over time, they were a minor nuisance that
I did not have time to fix. I have also included the source files in a zip on sourceforge.
The actual SVN still has the old 313 files, in time that will be fixed.

[enclezer]

good job,thx.

[gaminino3]

Thank you Pryd its helping me a lot!

BTW I have working 3.3.0a TC2 core (custom) and I am using your database Pryd but with all 3.3.0a items. Just ICC isn't working If you guys want it I can share it with you!

[pryd]

I'm sure we all would love some working TC2 330a!
A world database / sources files / whatever you have to share would be wondrous!

PS- The argent lance / mounts should be working properly. Also updated to 3.0.2 ACID.

*Blush* I released my sources, with both paradox / maximius bot patches in the source zip...
but I'm having issues applying the patch.. if anyone can shed light on this plz do.

[Gloffen1]

Very nice repack. Will add this thread as favorite ^^
Will probably need some in the future. Thanks!

[Killuminati91]

Edit, everything works fine now. Thank you!

Okay I ran into a little problem: The recruitment officer is not working for me. (aka. bot spawner)
He just says "greetings (name)" but there is nothing to click. I used the pure database.

[Aurille]

Welcome back stranger! Haha

Pryd: Don't use Paradox's or Max's patch. Use the most current one by Peldor, I think he took it over. It's filename "Bots" in the TC2 patches repo, patch version 3.1.4 as I type this.

I compiled it with core 7284 yesterday and have had no problems thus far. I used hg import to patch it.

1 question for Pryd - do your vendors have 3.2.2 items yet?

Edit, everything works fine now. Thank you!

Okay I ran into a little problem: The recruitment officer is not working for me. (aka. bot spawner)
He just says "greetings (name)" but there is nothing to click. I used the pure database.

The playerbot has not been patched into the current release

[pryd]

Welcome back stranger! Haha

Pryd: Don't use Paradox's or Max's patch. Use the most current one by Peldor, I think he took it over. It's filename "Bots" in the TC2 patches repo, patch version 3.1.4 as I type this.

I compiled it with core 7284 yesterday and have had no problems thus far. I used hg import to patch it.

1 question for Pryd - do your vendors have 3.2.2 items yet?



The playerbot has not been patched into the current release

Awesome, I saw that patch in there but didn't know what version 3.1.4 was I'll give it a test.
Though 322a items are in the database, (and some 330 items-even though the core doesn't support it yet) I don't believe I have them on the vendors, sorry.

*Update*

PryDevServer Repack Rev5 released.
Trin2 Core updated to the latest 7294
Bots have been patched in!

Will also release the sources on sourceforge.

[dagreg]

Thank you very much for your work. I will try to test this new rev in the following days.

[Killuminati91]

wow awesome work, thank you! is there a way to hire multiple bots, not just one?

there is also a problem with the xp and most "kill xx" quests dont work with the bots, but you are just implementing the scripts, right?

[fresh]

charecters SQL file error upon try to extract it

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXIST' at line 1
[Err] */
--
-- Table structure for table `account_data`
--
DROP TABLE IF EXISTS `account_data`;
[Msg] Finished - Unsuccessfully
--------------------------------------------------



never mind fixxed it !!!!