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

[Aurille]

one question more.

Can i make this for 3.2.0 ?

Like adding in .CONF files

Client Min build
Client Max build

Or how do i patch to 3.2.0 for this?

thanks

We're not trying to ignore your questions, but they really is just no short answer on how to compile/update/patch your server. If you're not familiar with TrinityCore2 you may be better off just sticking with repacks, because of their ease of use.

What I would recommend is going to TrinityCore2's site and reading the FAQs and how-tos in the forums. It will be a little time-consuming but there's not really a better way to get the hang of it. If someone just tells you step-by-step what to do here, you wouldn't have enough grasp of the mechanics to know how to solve a problem on your own should something happen with your server.

Best of luck

*Testing Rev8 Pryd

[matiedemat]

Well oke, but trinitycore2 is the latest DB for Trinitycore Bases Servers right?

So i have to wait, till Trinitycore Develops a New Database for Patch 3.2.0?

Tell me when i'm wrong.

Thank you.

[pryd]

Well oke, but trinitycore2 is the latest DB for Trinitycore Bases Servers right?

So i have to wait, till Trinitycore Develops a New Database for Patch 3.2.0?

Tell me when i'm wrong.

Thank you.

This is true, we're all waiting patiently for Trin2 to support 3.2.0.
Though from my standpoint I'm in no rush.

My repack has been updated to Revision 8a:
which is the latest Trin2 core 5718 / YTDB 509.

Make sure to update the trinitycore.conf for enhanced patches.

[Aurille]

Edit: The Recruitment Officer no longer gives any bots? I think the bot system is broken

[Wisher]

getting rev8...i hope the things i posted before are fixed... /pray

well they arent fixed...
-great,the guild house manager is in english,tho the sell option still isnt working... i tried sell,SELL,"sell",etc and it didnt work...
-i cant add bots,as u can see in my post under,not exactly sure why...
can someone confirm if they are having the same issues as the ones i posted a few posts before,so i know if its only me and should i work on it?

umm im getting this error when trying to execute the world_bots.sql :


[Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] insert into `creature_template` (`entry`, `heroic_entry`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('60000','0','169','0','169','0','Recruitment Officer','','','80','80','4800','9100','3460','3460','9200','35','35','1','1.4', '1','0','228','298','0','1837','1','2000','0','0','0','0','0','0','0','0','0','0 ','0','0','4','0','0','0','0','0','0','300','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','','0','3','1','1','0','1','0','0','0','script_bot_giver ');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

ill try changing modelid_A,modelid_A2, modelid_H, modelid_H2 to 1,2,3,4 like it is in the world db,and see if it works...

[pryd]

umm im getting this error when trying to execute the world_bots.sql :


[Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] insert into `creature_template` (`entry`, `heroic_entry`, `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`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('60000','0','169','0','169','0','Recruitment Officer','','','80','80','4800','9100','3460','3460','9200','35','35','1','1.4', '1','0','228','298','0','1837','1','2000','0','0','0','0','0','0','0','0','0','0 ','0','0','4','0','0','0','0','0','0','300','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','','0','3','1','1','0','1','0','0','0','script_bot_giver ');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

ill try changing modelid_A,modelid_A2, modelid_H, modelid_H2 to 1,2,3,4 like it is in the world db,and see if it works...

Good catch, Thank you. We did have modelid_A-modelid_H, change to Modelid1-modelid4 in the creature template.
Just make the slight modification in the sql and all should be good.

I'll update the sql on my repo end when I get time.

Also keep in mind if you imported my world database, this NPC is already in there.
The sql is only for people using their own trinity2 database and want to try out my patched core.

Edit* 7:22 AM Pacific Time-- For now updated the repack to rev8a, bots work once again. Manipulated a few things, but all is fine on my end.

Source is still being uploaded..

[Wisher]

thats the problem,he isnt there! cant find him anywhere spawned,and when i searched in the db i couldnt find him(im using fun db currently)...thats why i executed that...
btw,found more bugs/non working stuff that worked before...maybe its because of mangos-trinity switch? i can try fixing them,and uploading somewhere so u add it to the repack? tho it can take a while,im not a pro at this

[batuyanga]

2009-09-22 21:17:30 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:17:31 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:17:31 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:33:29 ERROR: BattleGround: too high queue_id 8 this shouldn't happen
2009-09-22 21:33:44 ERROR: BattleGround: too high queue_id 24 this shouldn't happen
2009-09-22 21:34:06 ERROR: Creature 275454 (Entry: 909023) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.
2009-09-22 21:34:06 ERROR: Creature 275454 (Entry: 909023) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.

[pryd]

[quote=Wisher;1681147]@pryd (this is sort of a feedback too ) :
-from my post before,what it the code for the guild house deletion?
-is there a way to make autobroadcast broadcasts different messages everytime
-there arent any cannons or vehicles in winterspring after 6b rev
-also since 6b rev,in DK questline when u have to kill 100 soliders with those cannons,the gryphon that should return u,doesnt work,but it worked in older revs...
-in the DK starting area upper-lower level portal isnt working (on fun db,will check blizz)[/qoute]

Guild house deletion comes from the guild master. Also note that if you make
two guild masters, only the original will be able to SELL to the guild master

npc entry = 7000002

I realize when I got the file it was in russian, I did my best to turn ???? into English.
Always feel free to open the .patch's that I provide to see what the code is all about.

Autobroadcast; though I used to have it working on Mangos, I'm not sure if it's the same..
I would check error logs, then create the table and fields that are needed / varchar's.
And obviously use the field names that mangos errors provide.
In the future I'll look into it.

Not sure what happend to the DK quest line, lord knows I didn't touch it directly, though
the YTDB patches, or Trin patches surely could have.

thats the problem,he isnt there! cant find him anywhere spawned,and when i searched in the db i couldnt find him(im using fun db currently)...thats why i executed that...
btw,found more bugs/non working stuff that worked before...maybe its because of mangos-trinity switch? i can try fixing them,and uploading somewhere so u add it to the repack? tho it can take a while,im not a pro at this

The recruitment officer = entry 60000. On my end he is most definitely in all three databases.

2009-09-22 21:17:30 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:17:31 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:17:31 ERROR: WORLD: Enemy creature 124755 is friendly
2009-09-22 21:33:29 ERROR: BattleGround: too high queue_id 8 this shouldn't happen
2009-09-22 21:33:44 ERROR: BattleGround: too high queue_id 24 this shouldn't happen
2009-09-22 21:34:06 ERROR: Creature 275454 (Entry: 909023) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.
2009-09-22 21:34:06 ERROR: Creature 275454 (Entry: 909023) have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list.

I'm not able to reproduce these errors. What core / database are you using?
If the custom trainer is giving you issues remove it from the creature table.

Though I'm testing it as I type, works fine for me. shrug.
Need more details about how you installed, first time installer?
Updating? etc etc..

[Wisher]

tnx for the reply... hope u can figure out the autobroadcast thing... i am the original owner of the guild,but still cant sell...maybe its because its command created guild,not through guild charter? recruitment officer,not there...i triple checked it,and nothing has 60000 id...probably my mistake...ill reimport the db...well i guess ill look into the DK quests...its probably cuz of switching to trinity...maybe ill fix something,if im lucky

[Happymeal]

I getting this error if i execute the characters.sql :/

[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 `character_db_version`
--

DROP TABLE IF EXI' at line 7
[Err] /*


--
-- Table structure for table `character_db_version`
--

DROP TABLE IF EXISTS `character_db_version`;
[Msg] Finished - Unsuccessfully

Edit:

Okay i think i have fix it for myself

i delete at row 18 & 38 the comment ( /* ; */ )

[artifakt]

found 2 Big bug:
the zeppelins aren't working they drop me in the air.

the throw weapons work as a projectile , like a bullet or a bow, so once you throw them they will disappear from your inventory

I use: pryd repack 8 and PDS_Custom_FUN ytbd 509

[adzarus]

Probleme with release 8.a :

Errors with SQL structure creature_template_addon in all databases ( Blizz , Fun and PvP )

2009-09-22 19:57:05 Using configuration file TrinityCore.conf.
2009-09-22 19:57:05 TrinityCore2 Rev: Archive Hash: c6030dd6f9ff (Win32,little-endian) (core-daemon)
2009-09-22 19:57:05 <Ctrl-C> to stop.

2009-09-22 19:57:05  ______                       __
2009-09-22 19:57:05 /\__  _\       __          __/\ \__
2009-09-22 19:57:05 \/_/\ \/ _ __ /\_\    ___ /\_\ \ ,_\  __  __
2009-09-22 19:57:05    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2009-09-22 19:57:05     \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2009-09-22 19:57:05      \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
2009-09-22 19:57:05       \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
2009-09-22 19:57:05                                  C O R E  /\___/
2009-09-22 19:57:05 http://TrinityCore.org                    \/__/

2009-09-22 19:57:05 Daemon PID: 4720

2009-09-22 19:57:06 MySQL client library: 5.0.56
2009-09-22 19:57:06 MySQL server ver: 5.1.37 
2009-09-22 19:57:06 MySQL client library: 5.0.56
2009-09-22 19:57:06 MySQL server ver: 5.1.37 
2009-09-22 19:57:06 MySQL client library: 5.0.56
2009-09-22 19:57:06 MySQL server ver: 5.1.37 
2009-09-22 19:57:06 Realm running as realm ID 1
2009-09-22 19:57:06 Using World DB: YTDB 509 For Trinity
2009-09-22 19:57:06 Using creature EventAI: ACID 3.0.0 - Full Release
2009-09-22 19:57:06 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2009-09-22 19:57:06 Visibility. Distance .Creature can't be greater 165.666656
2009-09-22 19:57:06 Visibility.Distance.Object can't be greater 156.666656
2009-09-22 19:57:06 Using DataDir ../System.Data/
2009-09-22 19:57:06 WORLD: VMap support included. LineOfSight:0, getHeight:0
2009-09-22 19:57:06 WORLD: VMap data directory is: ../System.Data/vmaps
2009-09-22 19:57:06 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2009-09-22 19:57:06 
2009-09-22 19:57:06 Loading Trinity strings...
2009-09-22 19:57:06 
2009-09-22 19:57:06 >> Loaded 796 Trinity strings from table trinity_string
2009-09-22 19:57:06 Initialize data stores...
2009-09-22 19:57:08 
2009-09-22 19:57:08 >> Initialized 79 data stores
2009-09-22 19:57:08 Using enUS DBC Locale as default. All available DBC locales: frFR enUS 
2009-09-22 19:57:08 
2009-09-22 19:57:08 Loading Script Names...
2009-09-22 19:57:08 
2009-09-22 19:57:08 >> Loaded 1008 Script Names
2009-09-22 19:57:08 Loading InstanceTemplate...
2009-09-22 19:57:08 >> Loaded 119 Instance Template definitions
2009-09-22 19:57:08 
2009-09-22 19:57:08 Loading SkillLineAbilityMultiMap Data...
2009-09-22 19:57:08 
2009-09-22 19:57:08 >> Loaded 9973 SkillLineAbility MultiMap Data
2009-09-22 19:57:08 Cleaning up instances...
2009-09-22 19:57:08 
2009-09-22 19:57:08 >> Initialized 0 instances
2009-09-22 19:57:08 Packing instances...
2009-09-22 19:57:08 >> Instance numbers remapped, next instance id is 1
2009-09-22 19:57:08 
2009-09-22 19:57:08 
2009-09-22 19:57:08 Loading Localization strings...
2009-09-22 19:57:09 
2009-09-22 19:57:09 >> Loaded 27663 creature locale strings
2009-09-22 19:57:09 
2009-09-22 19:57:09 >> Loaded 19012 gameobject locale strings
2009-09-22 19:57:09 
2009-09-22 19:57:09 >> Loaded 33617 Item locale strings
2009-09-22 19:57:10 
2009-09-22 19:57:10 >> Loaded 9045 Quest locale strings
2009-09-22 19:57:10 
2009-09-22 19:57:10 >> Loaded 5662 NpcText locale strings
2009-09-22 19:57:11 
2009-09-22 19:57:11 >> Loaded 1834 PageText locale strings
2009-09-22 19:57:11 
2009-09-22 19:57:11 >> Loaded 50 npc_option locale strings
2009-09-22 19:57:11 
2009-09-22 19:57:11 >> Loaded 125 points_of_interest locale strings
2009-09-22 19:57:11 >>> Localization strings loaded
2009-09-22 19:57:11 
2009-09-22 19:57:11 Loading Page Texts...
2009-09-22 19:57:11 >> Loaded 1788 page texts
2009-09-22 19:57:11 
2009-09-22 19:57:11 Loading Player info in cache...
2009-09-22 19:57:11 
2009-09-22 19:57:11 >> Loaded info about 16 players
2009-09-22 19:57:11 Loading Game Object Templates...
2009-09-22 19:57:11 >> Loaded 19000 game object templates
2009-09-22 19:57:11 
2009-09-22 19:57:11 Loading Spell Chain Data...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 1113 spell chains
2009-09-22 19:57:12 Loading Spell Required Data...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 35 spell required records
2009-09-22 19:57:12 Loading Spell Elixir types...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 128 spell elixir definitions
2009-09-22 19:57:12 Loading Spell Learn Skills...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 99 Spell Learn Skills from DBC
2009-09-22 19:57:12 Loading Spell Learn Spells...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 19 spell learn spells + 554 found in DBC
2009-09-22 19:57:12 Loading Spell Proc Event conditions...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 986 extra spell proc event conditions +52 custom
2009-09-22 19:57:12 Loading Spell Bonus Data...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 268 extra spell bonus data
2009-09-22 19:57:12 Loading Aggro Spells Definitions...
2009-09-22 19:57:12 
2009-09-22 19:57:12 >> Loaded 122 aggro generating spells
2009-09-22 19:57:12 Loading NPC Texts...
2009-09-22 19:57:13 
2009-09-22 19:57:13 >> Loaded 5452 npc texts
2009-09-22 19:57:13 Loading Enchant Spells Proc datas...
2009-09-22 19:57:13 >> Loaded 42 enchant proc data definitions
2009-09-22 19:57:13 Loading Item Random Enchantments Table...
2009-09-22 19:57:13 
2009-09-22 19:57:13 >> Loaded 28635 Item Enchantment definitions
2009-09-22 19:57:13 Loading Items...
2009-09-22 19:57:16 >> Loaded 33616 item prototypes
2009-09-22 19:57:16 
2009-09-22 19:57:16 ERROR: Item (Entry: 963000) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963001) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963002) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963003) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963004) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963005) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963010) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963011) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963012) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963013) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963014) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963998) not correct (not listed in list of existed items).
2009-09-22 19:57:16 ERROR: Item (Entry: 963999) not correct (not listed in list of existed items).
2009-09-22 19:57:16 Loading Item Texts...
2009-09-22 19:57:16 
2009-09-22 19:57:16 >> Loaded 0 item pages
2009-09-22 19:57:16 Loading Creature Model Based Info Data...
2009-09-22 19:57:16 >> Loaded 23046 creature model based info
2009-09-22 19:57:16 
2009-09-22 19:57:16 Loading Equipment templates...
2009-09-22 19:57:16 >> Loaded 3762 equipment template
2009-09-22 19:57:16 
2009-09-22 19:57:16 Loading Creature templates...
2009-09-22 19:57:18 >> Loaded 27660 creature definitions
2009-09-22 19:57:18 
2009-09-22 19:57:18 Loading SpellsScriptTarget...
2009-09-22 19:57:18 
2009-09-22 19:57:18 >> Loaded 1211 Spell Script Targets
2009-09-22 19:57:18 Loading ItemRequiredTarget...
2009-09-22 19:57:18 
2009-09-22 19:57:18 >> Loaded 107 Item required targets
2009-09-22 19:57:18 Loading Creature Reputation OnKill Data...
2009-09-22 19:57:18 
2009-09-22 19:57:18 >> Loaded 1711 creature award reputation definitions
2009-09-22 19:57:18 Loading Points Of Interest Data...
2009-09-22 19:57:19 
2009-09-22 19:57:19 >> Loaded 125 Points of Interest definitions
2009-09-22 19:57:19 Loading Creature Data...
2009-09-22 19:57:23 
2009-09-22 19:57:23 >> Loaded 129635 creatures
2009-09-22 19:57:23 Loading Creature Linked Respawn...
2009-09-22 19:57:23 
2009-09-22 19:57:23 >> Loaded 1 linked respawns
2009-09-22 19:57:23 Loading pet levelup spells...
2009-09-22 19:57:23 
2009-09-22 19:57:23 >> Loaded 1152 pet levelup and default spells for 38 families
2009-09-22 19:57:23 Loading pet default spell additional to levelup spells...
2009-09-22 19:57:23 
2009-09-22 19:57:23 >> Loaded addition spells for 102 pet spell data entries and 621 summonable creature templates
2009-09-22 19:57:23 Loading Creature Addon Data...
2009-09-22 19:57:23 
2009-09-22 19:57:23 ERROR: Error in creature_template_addon table, probably sql file format was updated (there should be 8 fields in sql).

[matiedemat]

When do you think that trinitycore releases a Trinitycore 3? for the 3.2.0 patch.

Would it take long or can i think about a month?

thnx.

[Wisher]

@adzarus: have u tried cleaning up the world db,then importing from scratch? cuz it looks like u just added the new db over the old one...

@matiedemat: lol,it doesnt update like that...trinitycore2 is for wotlk,before it was trinitycore and trinityzero... there are repacks out there that support 3.2.0 patch,look for them,or u can wait a bit more for pryds repack (one of the best ) to update to 3.2.0...

@artifakt: i will look into that,tho thrown weapons worked fine in rev7...