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

[tinblue]

I just noticed something and I'm not sure if this is an error with the core.

I fired up a Mangos server and noticed at Northshire Abbey that all the Diseased Wolves had the correct yellow glowing effect puffing out of them. Also, the Kobold Workers had correctly glowing weapons.

However, on this Trinity core server these effects appear missing.

Also, Kobolds appear to be dropping from the ceiling in the entrance to the Mine at Northshire Abbey.

[Aurille]

I'm getting a ton of 'achievement_criteria_data' table errors on startup, seems to be related mostly to type 28 and 69. Any ideas on how to fix?

Also for the last several releases the Blizz DBs have had some mount displays/spells from the FunDB retained

Lastly there seems to be some updates from trinity source missing in this release like the instance_item_refund that I can't get to apply for some reason

I'm using TDB 8064 Blizz DB

[Martindd]

Pls guys can u help my with this? :confused: ... am trying to open the TrinRealm and TrinCore but it always has that same error when i wanna start Trincore or trinrealm hmmm some screens may be proof ... oh yes .. i allready have all done ... Configs, vmaps, maps, dbcs ... i only get this f"""" error

Clipboard01.jpg picture by Darklife83 - Photobucket
Snap_20100501225038_003.png picture by Darklife83 - Photobucket
Snap_20100501225024_002.png picture by Darklife83 - Photobucket

[pryd]

Thank you Rizka
As for frozen throne it is a set of 4 or 5 game objects that make the area
along with trigger npcs to affect the gameobjects and other npcs
I have the trigger spells in the core and still need to impliment them into dbs

@farsas you need to dl the X86 core

Just released updated / fixed world databases for the ICC + ToCr Core.

ICC now has more spawns on TDB credits to YTDB for the creatures / gob spawns.

You shouldn't be falling through the world on any of the databases in ICC's frozen throne.
We now has custom teleport helpers for players and I also tweaked the area trigger just in case.
Therefore players will be able to traverse from one place to the next w/out GM intervention in ICC.

This is just a few minor optimizations from me, created by TDB and YTDB with some of the good stuff manually implemented / shared as it were..

Lastly Many Script Texts fixed in ICC / FOS / etc and a few npc flag fixes for older gem vendors.

Enjoy!

I'm getting a ton of 'achievement_criteria_data' table errors on startup, seems to be related mostly to type 28 and 69. Any ideas on how to fix?

Also for the last several releases the Blizz DBs have had some mount displays/spells from the FunDB retained

Lastly there seems to be some updates from trinity source missing in this release like the instance_item_refund that I can't get to apply for some reason

I'm using TDB 8064 Blizz DB

I also see the error as it started with the latest core.
At this time I don't have the data to correct that.

Also, we'll have to check lorac's repo and see if we somehow missed an SQL update, if I didn't put it in there, I also don't have it. Lorac takes care of that department for the most part, I just do slight patches.. like ToCr.

To get rid of the custom mount ids you must change the creature_template back to the original, from an original database from TDB.

I have created a custom patch for the mount, so you could download that from the repo and reverse out by looking at the creature entry / display id to see what I changed.

[Aurille]

I've tried to do that:

UPDATE `creature_template` SET `modelid1` = 27913 WHERE `entry`=32335;
UPDATE `creature_template` SET `modelid2` = 27913 WHERE `entry`=32335;

UPDATE `creature_template` SET `modelid1` = 27507 WHERE `entry`=31124;
UPDATE `creature_template` SET `modelid2` = 27507 WHERE `entry`=31124;

UPDATE `creature_template` SET `modelid1` = 21073 WHERE `entry`=22510;
UPDATE `creature_template` SET `modelid2` = 21073 WHERE `entry`=22510;

UPDATE `creature_template` SET `modelid1` = 21074 WHERE `entry`=22511;
UPDATE `creature_template` SET `modelid2` = 21074 WHERE `entry`=22511;

UPDATE `creature_template` SET `modelid1` = 21075 WHERE `entry`=22512;
UPDATE `creature_template` SET `modelid2` = 21075 WHERE `entry`=22512;

UPDATE `creature_template` SET `modelid1` = 21077 WHERE `entry`=22513;
UPDATE `creature_template` SET `modelid2` = 21077 WHERE `entry`=22513;

UPDATE `creature_template` SET `modelid1` = 21076 WHERE `entry`=22514;
UPDATE `creature_template` SET `modelid2` = 21076 WHERE `entry`=22514;

UPDATE `creature_template` SET `modelid1` = 17703 WHERE `entry`=18375;
UPDATE `creature_template` SET `modelid2` = 17703 WHERE `entry`=18375;

UPDATE `creature_template` SET `modelid1` = 17717 WHERE `entry`=18362;
UPDATE `creature_template` SET `modelid2` = 17717 WHERE `entry`=18362;

UPDATE `creature_template` SET `modelid1` = 17718 WHERE `entry`=18376;
UPDATE `creature_template` SET `modelid2` = 17718 WHERE `entry`=18376;

UPDATE `creature_template` SET `modelid1` = 24725 WHERE `entry`=27637;
UPDATE `creature_template` SET `modelid2` = 24725 WHERE `entry`=27637;

Something is still affecting the disp id for a few of those however

[bullghost]

hi iam start using blizdb it work great
keep it update pls



thanks alot,
bullghost

[bjorno43]

Srry about the late response. Arcane Missiles doesnt work for me. More detailed description:

When performing it without the talent proc:

The first missile is fired. The other 4 are simply invissible and don't do any damage.

When performing it with the talent proc:

All missiles are invisible and no damage at all. It looks like it fires over 10 invissible missiles though, while it should fire 5 missiles, just faster.

Any other information that might be important:

Using windows 7 32bit. Clean database / core, no mods, no edits to source codes.

I stand corrected. It turns out this problem only occurs if "GM Mode" is enabled. However, I did notice that Arcane Missiles doesn't like to much haste rating. When I give my mage maxed out pve gear, it has 1274(38.85%) haste rating. When Missile Barrage procs, AM still works fine for 99% of the time. In a rare case, it only fires 1 AM. However, when increasing haste even more by using Icy Veins for example, it seems like it can no longer handle the speed and simply fires just 1 AM.

Say you have a raid and you have a proc + IV + Speed potion + BL then the result would be: Houston we have a problem! :P

[lorac]

Ok guys please understand
3.3.3a changed the rules of the game on the core
I am trying to get all the new spell procs working along with all the client / core communications right
They also changed alot of the achievment data which i am currently trying to address
Providing all goes right the new core should have alot of these issues corrected but I made the error of moving to SP2 lastnight and I am still fighting getting everything working on my system
Again i ask for a lil patience
Providing i can get this all going
ETA on SvN update 5 hours ...7:14 am -5:00gmt
Thank you


I would have uploaded a zip with the achievements fix but bb seems to be failing and wont let me attach the zip

[meenaze]

Pls guys can u help my with this? :confused: ... am trying to open the TrinRealm and TrinCore but it always has that same error when i wanna start Trincore or trinrealm hmmm some screens may be proof ... oh yes .. i allready have all done ... Configs, vmaps, maps, dbcs ... i only get this f"""" error

Clipboard01.jpg picture by Darklife83 - Photobucket
Snap_20100501225038_003.png picture by Darklife83 - Photobucket
Snap_20100501225024_002.png picture by Darklife83 - Photobucket

Im having the same problem :/

[lorac]

Im having the same problem :/

Released

you need to open the configs in note pad
and save as and select all file and then back the last letter out and put it back in so it is a config not a dist

[shamanwise]

So... Just to let you know, I ran through everything you told me to do, and it worked like a charm. There was 1 problem I ran into with a missing SQL Table in the characters database, but I found a MYSQL Dump of just that table with a quick google search and Boom I was good to go. All Characters in tact! I really appreciate the help.

I have one question about the server. I ran a search for it but it came up with a whole slew of other shit I wasnt looking for.

Im wondering about the Bots. When I got to the recruitment officer, I can recruit 1 "Minion" or I can recruit any number of my other characters. Is there a way to make it so I can recruit more than 1 minion? Not everyone has a bunch of characters on thier own account around the same level. Having a full group of Bots would be awesome. Another thing with bots, You can't heal or buff them. Is there a way to change that? I play a priest and It would be nice to have a little War Bot run with me. Healing him would probably be very beneficial.

Also, The "AllInOne" options, The GM only one doesnt seem to work, Is this a known issue? When I enable it, all accounts can still use the teleporter and the buffers. Another thing with the teleporter, is there a way to take out just the Teleport to your Shopping mall? I really dont want people to access that portion, but Being able to teleport from one place to another, I dont mind at all. If I could just remove the teleport to the shopping mall, all would be great.

Anyways, THank you again for all your advice, I couldnt be more pleased, and thank you in advance for any future advice.

I have a same problem!
Please do enable/disable switch for this issue (Shopping mall) in TrinityCore.conf
Also item id 52200 is missing. (I using tdb with 8064)

P.S.

PryDevServer is the best!!!

[lorac]

This will have to be in a future release as we need to code it its not just a 1 or 2 line add to the scripting
All in one is work in progress and some of the switches are there for future implimentation

::::Update::::
All 3 DBs are in
All 3 cores are in
3 of 3 cores started 0 errors
Installer is created and is now being uploaded
I cant believe its taking longer to upload then it did to make the Exe

Until Pryd compiles the x64 cores this release will be for 32 bit

[spitfire21]

Sounds good lorac I just uploaded rev8064 for linux and the installation is pretty much the same as windows except you need to put the two files build and ACECOMPILE into directory /home/trinity rename the files in build/etc/ trinityrealm.conf.dist to trinityrealm.conf then set up your mysql server import db using navicat. Edit configs, start the server by launching the shell scripts in build/bin


One day i will write a real installation guide

[lorac]

The New installer Repack is released

This package includes

Sql server
Apache server
Shadows Restarter for Trinity core
Blizz world db set up already
Fun world db set up already
PvP world db Set up already
All three worlds have their own char db setup already
3 cores one for each realm

::note Vmaps are not made it would make the installer too big and a long download::

Vmaps are not needed but are nice to have

The vmap extracter and builder is in tools
So is a simple account page
you will need to config it and put it in your htdocs in the server directory
Only thing you need to do is set up a site
set your ip address up in your realmd.realmlist < making your server live>
And tweek your config files to how you want the server
and your done

DB login info can be found in the configs
or

U= root
P= ascent

Click here to download

[pryd]

I've tried to do that:

UPDATE `creature_template` SET `modelid1` = 27913 WHERE `entry`=32335;
UPDATE `creature_template` SET `modelid3` = 27913 WHERE `entry`=32335;

UPDATE `creature_template` SET `modelid1` = 27507 WHERE `entry`=31124;
UPDATE `creature_template` SET `modelid3` = 27507 WHERE `entry`=31124;

UPDATE `creature_template` SET `modelid1` = 21073 WHERE `entry`=22510;
UPDATE `creature_template` SET `modelid3` = 21073 WHERE `entry`=22510;

UPDATE `creature_template` SET `modelid1` = 21074 WHERE `entry`=22511;
UPDATE `creature_template` SET `modelid3` = 21074 WHERE `entry`=22511;

UPDATE `creature_template` SET `modelid1` = 21075 WHERE `entry`=22512;
UPDATE `creature_template` SET `modelid3` = 21075 WHERE `entry`=22512;

UPDATE `creature_template` SET `modelid1` = 21077 WHERE `entry`=22513;
UPDATE `creature_template` SET `modelid3` = 21077 WHERE `entry`=22513;

UPDATE `creature_template` SET `modelid1` = 21076 WHERE `entry`=22514;
UPDATE `creature_template` SET `modelid3` = 21076 WHERE `entry`=22514;

UPDATE `creature_template` SET `modelid1` = 17703 WHERE `entry`=18375;
UPDATE `creature_template` SET `modelid3` = 17703 WHERE `entry`=18375;

UPDATE `creature_template` SET `modelid1` = 17717 WHERE `entry`=18362;
UPDATE `creature_template` SET `modelid3` = 17717 WHERE `entry`=18362;

UPDATE `creature_template` SET `modelid1` = 17718 WHERE `entry`=18376;
UPDATE `creature_template` SET `modelid3` = 17718 WHERE `entry`=18376;

UPDATE `creature_template` SET `modelid1` = 24725 WHERE `entry`=27637;
UPDATE `creature_template` SET `modelid3` = 24725 WHERE `entry`=27637;

Something is still affecting the disp id for a few of those however

It's Modelid 1 for Alliance Modelid 3 <-- for horde.
so 12345, 0 , 43212, 0

I changed the quote above to reflect the change from 2 to 3 in red.
And make sure to clean that cache.

In the future I will have to make a reverse option for that custom mod hack.
I will take what you have here and start w/ this, thanks Aurille. If you by chance make a more complete one before me, please share with us.

UPDATED World Databases Released: TDB Fun / PVP

Well I hate to say it but I've customized more mounts and you may or may not like it- Since x-53 is out, I've decided to make a hacky version of it.

Here is a pic, and it does work as intended.. no core support yet..



Again, sorry about the inconvenience to those who don't like custom mounts, until we have true support for these wonders, this is how I do it.



Lastly, there are new world databases up, lots of special fixes by me.
Too many too list but they include more ICC spawns, more custom mounts, more items, etc.

Check out Lorac's Full Server Setup Install which includes mysql / apache and more! Great job Lorac! It's in our repo so make sure to check it out.

Look for another core / world release tonight if all goes well.