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

[redzik]

Can any1 tell me how copy/backup character-account from v3 to v4 etc. I didnt use it and dont know much about it.

Characters
Accounts
Playeritems
playerpets

These will be ok?!

[Seeker Sami]

First export tables then just import them in sql?

[lorac]

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

[Bazillus]

Hi all I have a problem with your new Ultracore V5.

If I try to start the trinity.core i get an error by windows 7 64: 0xc0000007b.

Could someone please be so kind to help me?

[lorac]

Can an user who has an X64 cpu please try the x64 version of the core in the v5 and tell me if you have an issue starting it?
I am in charge of the all in one installs

Did you try to run it in compatibility mode for vista or XP

Also do you have the .net framework 3.5? on your pc?
With out it you will not get this server to run
Go to microsoft.com to find it
I can not tell you if theres a problem with windows 7 with this core
its not an environment i can afford to move to at the moment
but first i need to know
do you have .net framework 3.5
and if any other users who know the core to work on their system are having problems with the exes
Make sure tiy LAUNCH WITH Trinitycore.exe and Trinityrealm.exe
The other two exes might not be win 7 friendly

error 0xc0000007b
is a runtime error
this tells me that you do not have .net framework
How ever I dont have server.log to see what came up first
Nor do i have crash dumps
Both of these can point out the issue

[Bazillus]

Thank you very much for your fast answer lorac!!

I get net framework 3.5 (the ultracore version 4 runs without any problems)

I have deinstall 3.5 & install it again....the same result....

I´ll test it with the xp mode and write back, if it works.

Thank you.

best regards

Baz

---------- Post added at 02:33 PM ---------- Previous post was at 02:31 PM ----------

The compatibility mode has no changes....and because of x64 I could only choose the vista compatibility...

---------- Post added at 02:37 PM ---------- Previous post was at 02:33 PM ----------

For today i will give up now....
with the realmd.exe is the same problem....but this doesnt matter, because i could use the realmd.exe from Ultracore V4,
for today i start the new Databse with the older core....
Maybe someone found the reason.


CU

[lorac]

Thank you very much for your fast answer lorac!!

I get net framework 3.5 (the ultracore version 4 runs without any problems)

I have deinstall 3.5 & install it again....the same result....

I´ll test it with the xp mode and write back, if it works.

Thank you.

best regards

Baz

---------- Post added at 02:33 PM ---------- Previous post was at 02:31 PM ----------

The compatibility mode has no changes....and because of x64 I could only choose the vista compatibility...

---------- Post added at 02:37 PM ---------- Previous post was at 02:33 PM ----------

For today i will give up now....
with the realmd.exe is the same problem....but this doesnt matter, because i could use the realmd.exe from Ultracore V4,
for today i start the new Databse with the older core....
Maybe someone found the reason.


CU

:::ATTN x64 users:::
If still having problems
Please click to Download If problem persists
Just Download and replace
the 2 exe files
and all dlls
and try to launch again

I currently am recompiling the installer with known to work exes
look for UCv5 1.exe
Once it is up the new exes will be in that install

[PewPewNao]

Great repack, +rep but i have a question : How can i change my mysql username and password?

[lorac]

Great repack, +rep but i have a question : How can i change my mysql username and password?

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

[PewPewNao]

how can i set up the website?

[lorac]

mhhhhh why u so aggressive...

OK i will make it Step by step i get all from Pryd here: Browse PryDevServer: Ultra Core Files on SourceForge.net

Lorac 13 = 8074_ICC_ToCR_more.rar

New System Sucks -> Mean Newbi EXE Programm that will install fullinstall mysql and Server and all other...
Ok, for noobs it will be Perfect but our Project cant work with this

i dont wanna have Full Compiled Version.

wee have some changes taht are important for our P-Server Project

Sorry if u mean i bitching u realy sorry

Ego
I ment that the Source is available at Both of our SVNs
Im not being aggressive just asked a question

how can i set up the website?

Included is the readme for that site
Honestly "Ive never used it so I have no clue
I know you have to edit it in notepad and save

And answer to your question
Go into your console
type
Acc create username password
then
Go into db
Realmd
Go into your account
get the # for that account
then go to account_access
take the # put in first space
then 1 through 5 (5 being admin ) for gm
and for realm -1
IMPORTANT
-1 is for all realms
if your running multi realms but only want a gm to be one on one realm put the actual realm id number from realmlist!

After done with that
Restart Trinityrealm.exe
and Totally log out dump cache and log in

[spitfire21]

Lorac you is busy compiling 8345 YAY !!!!!

[lorac]

Repack has been redone
click here for the fixed version
Actually bro its 8370
Ive been at this since 8 pm YESTERDAY!!!
22 hours straight


Nothing personal guys / gals its time for me to walk away and close my eyes for an hour or so

[Tazaul]

Hey guys!

Ive got a problem with the UCDB.

I cant import UCDB_8345_Bliz to the world database.

it gives me this error when i try to import:

Query:
INSERT INTO `locales_creature` VALUES ('12385', '', '', '', '', '', '', '', 'Усовершенствованный манекен-мишень орудийного расчета', null, null, null, null, null, null, null, '')

Error occured at:2010-06-01 00:03:57
Line no.:753450
Error Code: 1406 - Data too long for column 'name_loc8' at row 1


Using sqlyog to import.

Thx for all the great stuff ure making! Keep up the great work

[redzik]

I remember got this "Error Code: 1406" during applying old database(dont remeber number) but google cant fix it, and only downloaded install version Ultracore v3. Because I thought about 40mb down and will be faster, but with that error was too long. :P and navicat had the same problem to apply db, but it was only on TDB problem but with YTDB work. so I'll want down manual version, but now im afraid again about this error :/

I watched Fullmetal alchemist so now Im going to bed
good night guys

Keep up the great work