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

[lucas13]

uuhm this new UC5 server sounds excellent, i'll set it up and report back guess ill have to dump my old world server, but whatever great job as always ;P


EDIT:
Noooooes!! ;(
hopefully you are gonna implement that lovely bot system and for god's sake also the malls again :P else its EXCELLENT!

[Bazillus]

I used tha latest repack with Core, DB and Char Databse.

Now I have only a few problems :

2010-06-01 19:15:40 Item (Entry: 7109) has unknown (wrong or not listed in `item_enchantment_template`) RandomProperty (4294967295)
2010-06-01 19:15:51 Quest 10967 has `RewSpellCast` = 39613 but spell 39613 does not exist, quest will not have a spell reward.
2010-06-01 19:16:04 Table 'gameobject_loot_template' entry 28064 (gameobject entry) not exist but used as loot id in DB.
2010-06-01 19:16:04 Table 'gameobject_loot_template' entry 201872 isn't gameobject entry and not referenced from loot, and then useless.
2010-06-01 19:16:04 Table 'gameobject_loot_template' entry 202338 isn't gameobject entry and not referenced from loot, and then useless.
2010-06-01 19:16:09 The table `addons` is empty
2010-06-01 19:16:09 Table `spell_scripts` has not existing spell (Id: 3444 as script id
2010-06-01 19:16:09 Table `spell_scripts` has not existing spell (Id: 34452) as script id
2010-06-01 19:16:11 TrinityScript: RegisterSelf, but script named boss_Valanar does not have ScriptName assigned in database.
2010-06-01 19:16:11 TrinityScript: RegisterSelf, but script named boss_Keleset does not have ScriptName assigned in database.

---------- Post added at 01:02 PM ---------- Previous post was at 12:17 PM ----------

For you information: Its posibble to rescue the older character, but all skills and items are lost.

[Coldon123]

The new Ultracore is really amazing.

However there are some bugs I thought I might add. Firstly, it's really great that Deathbringer's Will got fixed, but it transforms me into a pig instead, but with the intended effect.

Secondly, Will of the Forsaken and the PvP trinket still doesn't share a 2 minute cooldown.

Lastly, speccing Improved Succubus as a Warlock doesn't reduce the Succubus casting time.

I apologize if I posted this information in the wrong section, but I just thought I'd let you know. This repack really have potential to be the greatest one ever made (If not already) And I really appriciate what you are doing.

[heytoj]

@Coldon123
Yeah, I have the same problem, too. As far as I know, the deathbringer's will trinket has been fixed in the latest reversion but hasn't been implemented correctly in this repack.

[cmleung]

I am having difficulty restoring these data (in step6) files from .myd, .frm and .myi format. When I do Restore Table, I got the following error. I figured I may be able to just copy the /data folder to where mysql db files are, but I cannot find the location! I am using windows vista, mysql is installed in this location: C:\Program Files\MySQL\MySQL Server 5.1, under has the usual /bin, /lib, /share and some files, however I do not see any db files I created. How do I restore / import these data files? thanks

+---------+---------+----------+--------------------------+
| Table | Op | Msg_type | Msg_text |
+---------+---------+----------+--------------------------+
| account | restore | error | Failed copying .frm file |
+---------+---------+----------+--------------------------+

"Step6
While that is extracting let us now open up Navicat and create 3 new databases.
The 3 databases should be Characters, Trinity, Realmd.
Now import/restore/execute batch each of the databases that is supplied in the database folder
inside C:\Trinity\Database to its respective counterpart inside your MySQL server."

[lorac]

Go into navicat and click manage users


Those of you who are already working with the new core + db

DELETE FROM `creature_template` WHERE `entry` IN (38292,38271);
INSERT INTO `creature_template` (`entry`,`modelid1`,`faction_A`,`faction_H`,`unit_class`) VALUES
(38292,31015,35,35,1),
(38271,31015,35,35,1);
DELETE FROM `creature_model_info` WHERE `modelid`=31015;
INSERT INTO `creature_model_info` (`modelid`) VALUES (31015);

Please use that code in your console for db and restart server
No more piggy morphs with deathbringers will

and

SET @npcguid = 200001;
SET @gobguid = 1000025;
DELETE FROM `creature` WHERE `id`=33113;
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
(@npcguid,33113,603,1,1,0,0,420.728,-15.3721,409.804,3.05873,300,0,0,23009250,0,0,0);

DELETE FROM `gameobject` WHERE `id`=194905;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@gobguid,194905,603,1,1,147.036,-123.838,409.805,6.28083,0,0,0.00117889,-0.999999,25,0,1),
(@gobguid+1,194905,603,1,1,147.831,-103.135,409.805,6.2769,0,0,0.00314203,-0.999995,25,0,1),
(@gobguid+2,194905,603,1,1,148.213,-43.8613,409.805,0.00156927,0,0,0.000784635,1,25,0,1),
(@gobguid+3,194905,603,1,1,148.187,-27.1173,409.805,0.00156927,0,0,0.000784635,1,25,0,1),
(@gobguid+4,194905,603,1,1,148.043,27.1395,409.805,0.0015707,0,0,0.000785351,1,25,0,1),
(@gobguid+5,194905,603,1,1,148.286,51.8011,409.804,0.00942516,0,0,0.00471256,0.999989,25,0,1);

This should fix Flame Leviathan support
Note the
SET @npcguid = 200001;
SET @gobguid = 1000025;
are for our UCDB
you will need to grab the highest numbers in creature and gameobject and +1 for TDB

And now for last fix in this post
this should fix the utgarde penicle
where the invis npcs attack and this should make harpoons and everything work

UPDATE `creature_template` SET `modelid1`=11686,`modelid2`=11686,`flags_extra`=2 WHERE `entry`=19871;
UPDATE `creature_template` SET `modelid1`=11686,`modelid2`=11686,`flags_extra`=2 WHERE `entry`=30684;

-- Skadi Harpoon Launchers
UPDATE `gameobject_template` SET `ScriptName`= 'go_harpoon_launcher' WHERE `entry` IN (192175,192176,192177);

-- Skadi
UPDATE `creature_template` SET `unit_flags`=33554434 WHERE `entry` IN (26693,2669301);

-- Skadi Summons
        -- Ymirjar Warrior
UPDATE `creature_template` SET `mindmg`=300 ,`maxdmg`=400,`attackpower`=1500,`dmg_multiplier`=7,`faction_A`=21,`faction_H`=21,`AIName`= 'EventAI' WHERE `entry` IN (26690,2669001);
UPDATE `creature_template` SET `dmg_multiplier`=14,`minlevel`=80,`maxlevel`=80,`exp`=2,`equipment_id`=6 WHERE `entry`=2669001;
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=26690);
INSERT INTO `creature_ai_scripts` VALUES 
(2669001,26690,0,0,70,7,2000,25000,2000,25000,11,48639,1,2,0,0,0,0,0,0,0,0, 'Hamstring'),
(2669002,26690,0,0,70,7,3000,35000,3000,35000,11,48640,1,2,0,0,0,0,0,0,0,0, 'Strike');

    -- Ymirjar Witch Doctor
UPDATE `creature_template` SET `mindmg`=300 ,`maxdmg`=400,`attackpower`=1500,`dmg_multiplier`=7,`faction_A`=21,`faction_H`=21,`AIName`= 'EventAI' WHERE `entry` IN (26691,2669101);
UPDATE `creature_template` SET `dmg_multiplier`=14,`minlevel`=80,`maxlevel`=80,`exp`=2,`equipment_id`=484  WHERE `entry`=2669101;
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=26691);
INSERT INTO `creature_ai_scripts` VALUES 
(2669101,26691,0,0,70,7,2500,30000,2500,30000,11,49084,1,2,0,0,0,0,0,0,0,0, 'Shadow Bolt'),
(2669102,26691,0,0,70,7,4000,45000,4000,45000,11,49089,1,2,0,0,0,0,0,0,0,0, 'Shrink');

        -- Ymirjar Harpooner
UPDATE `creature_template` SET `mindmg`=300,`maxdmg`=400,`attackpower`=1500,`dmg_multiplier`=7,`faction_A`=21,`faction_H`=21,`AIName`= 'EventAI' WHERE `entry` IN (26692,2669201);
UPDATE `creature_template` SET `dmg_multiplier`=14,`minlevel`=80,`maxlevel`=80,`exp`=2,`equipment_id`=2013  WHERE `entry`=2669201;
DELETE FROM `creature_ai_scripts` WHERE (`creature_id`=26692);
INSERT INTO `creature_ai_scripts` VALUES 
(2669201,26692,0,0,70,7,4000,45000,4000,45000,11,49092,1,2,0,0,0,0,0,0,0,0, 'Net'),
(2669202,26692,0,0,70,7,2000,25000,2000,25000,11,49091,1,2,0,0,0,0,0,0,0,0, 'Throw'),
(2669203,26692,6,0,100,6,0,0,0,0,11,56789,6,7,0,0,0,0,0,0,0,0, 'DEATH - Give Harpoon');

These fixes were supplied by the core support in TDB

:::ETA on Rebuilt AIO Server AkA UCv5-1.exe:::
90 mins

WARNING JUST IMPORTING YOUR CHAR TABLE WILL BREAK THE REPACK
Char db got 2 new tables If you dont follow the directions I supply and you break one or both

I will Not offer support to fix if you dont follow this


I knew someone would Question this
So I am covering this one time
So lets get started

1. Back up your exsisting Character database
2. Back up your Realmd DB
3. Download a Core pack
4. Download a new repack v5 v6 v7 w/e
5. log into new repack
6. batch or insert your characters db and your Realmd db

THEY BOTH NEED TO BE DONE!!!

Next
7. go into the core pack you downloaded you will see character updates Apply them

and your updated

Remember you miss any of these steps you might lose your data
So make sure you follow to the Letter!

um 3 to 4?
your a little behind on the updates arnt you
5 is now out

uuhm this new UC5 server sounds excellent, i'll set it up and report back guess ill have to dump my old world server, but whatever great job as always ;P


EDIT:
Noooooes!! ;(
hopefully you are gonna implement that lovely bot system and for god's sake also the malls again :P else its EXCELLENT!

1. What are you talking about ???
Bots are still in game?

2. Nope you didnt follow the DETAILED guide that i provided BEFORE the release to prevent the issue

3. I posted the fixes please Read the posts around the time of releases

[cmleung]

Never mind, i found it.

I am having difficulty restoring these data (in step6) files from .myd, .frm and .myi format. When I do Restore Table, I got the following error. I figured I may be able to just copy the /data folder to where mysql db files are, but I cannot find the location! I am using windows vista, mysql is installed in this location: C:\Program Files\MySQL\MySQL Server 5.1, under has the usual /bin, /lib, /share and some files, however I do not see any db files I created. How do I restore / import these data files? thanks

+---------+---------+----------+--------------------------+
| Table | Op | Msg_type | Msg_text |
+---------+---------+----------+--------------------------+
| account | restore | error | Failed copying .frm file |
+---------+---------+----------+--------------------------+

[cmleung]

I am having problem logging in to the game. I have created account, but when I try to login to the game, I've got "you have been discounted from server". My server is running, both trinity core and trinityrealm are running. Any idea?

[OMGPWN]

Ok, Ive played this server most of the day with my friends, this is the best repack I have ever used... Ever! Working stats, Ive raided Booty Bay with my friends, I almost forget I'm not playing live, the only thing reminding me is my gear score was like 6700.

[fosterboy123]

Hmmmm getting this error when i try to launch the sql server, any ideas guys?

cheers!

p.s. im a noob ^^

100602 12:39:51 [ERROR] Can't find the messagefile '\Ultracore\Server\mysql\share\english\errmsg.sys'
100602 12:39:51 [ERROR] Aborting

EDIT: nvm figured it out, for anyone as nooby as me, go to mysql and run the installer first.

[lucas13]

yes the bots are there lorac, but where is the original recruitment officer? and also i did a clear world cuz i changed to UCDB and i thought that it would be more safe to do a clean, although that doesnt bother me i dont have online players atm so doing clean world DB is no problem

[fosterboy123]

k guys sorry to keep nagging for help.

now im getting this when i try to run trinitycore.exe (the sql server is running)

Could not connect to MySQL database at 127.0.0.1: Unkown database 'world_ucdb2'

Cannot connect to world database 127.0.0.1;3006;root1;ascent;world_ucdb2

i followed the instructions perfectly on the first page excluding adding the sql database structures for character as they are already in there under different names and the configs appropriately directing them.

Hope you can help, cheers!

(took the 1 off the end of the username in the cfg to see if that helps but still wont connect)

OK, i managed to get it working (for some reason the cfg was set to look for world_ucdb2, when it didnt need the number, im struggling to understand why that was there in the first place?)

[lorac]

I am having problem logging in to the game. I have created account, but when I try to login to the game, I've got "you have been discounted from server". My server is running, both trinity core and trinityrealm are running. Any idea?

There has been so many posts about this
Please do the following

1 make sure your ports are open
2 make sure your using right client 3.3.3a
3 make sure you clean your cache
4 make sure your realm id matches the configs
5 make sure you enter a correct username and password



Whats there to struggle about i made an error in the configs when i had to make v5_1 because of failing x64 exes

unfortunantly the 32 bit was already reconfiged for my server and it wasnt changed
Well the passwords were but the world wasnt

As for bots
The recruter was renamed im not sure what it is but should still come when you use item 8
The new bots system came with new bot names

Ok everyone is entitled to their newb moment so heres mine XD

How do you get your gear score
where does it show your GS

Ok now you can say Lorac had a newb moment

[fosterboy123]

gearscore is an addon bud, take a look at wow-curse.

now my thrid noob moment :P

firstly, thank you so much for this repack it is astounding.

ok now to the questions ^^

what is the item id for frostmourne? or is there some kind of custom item id list i can find? in mysql?

secondly, how do i spawn the npcs? ive only ever used arcemu before this.

Thanks

[lorac]

gearscore is an addon bud, take a look at wow-curse.

now my thrid noob moment :P

firstly, thank you so much for this repack it is astounding.

ok now to the questions ^^

what is the item id for frostmourne? or is there some kind of custom item id list i can find? in mysql?

secondly, how do i spawn the npcs? ive only ever used arcemu before this.

Thanks

Ok cool about addon
thanks for answering my newb question
That explains why i havent found gear score

what is the item id for frostmourne?

im not sure
I personally only use blizz items
and frostmourne is not in retail

But heres how to find it
.loo item frostmourne
.add <shift link> the item


how do i spawn the npcs? ive only ever used arcemu before this.
.loo creature
Gets the number
then
.npc add <shift link> the creature that comes up
cant get much easier then this