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

[artifakt]

I think pryd project death: Pryd activity 0.8% and very long time no online,
and no update.

[johnbigi]

@Aurille:

thank you very much for your reply and suggestion, i downloaded the
program and the core is now booting up just fine.


thanks again for your help

[pryd]

Finally I have some free time.

Today I will rework my repack and attempt to release the updated
3.2.2a core / database.

Once I have a working version I will slowly integrate the malls, extra features, and more.

Thanks again for being patient and for sharing sources!

[morpheuswolf]

Pryd look into naxxramas and ulduar be cause boss dommage is very high for 40-50 k no spell and spell too .

Sorry bad english

Good work

[rb2crens]

Finally I have some free time.

Today I will rework my repack and attempt to release the updated
3.2.2a core / database.

Once I have a working version I will slowly integrate the malls, extra features, and more.

Thanks again for being patient and for sharing sources!

hehe.. its quite late because other emu was support 3.3.0 (especially mangos) but something i was waiting for long time will come ! dont forget 3.2.2a item plus tier 9 Boz!:wave::wave::wave:

Edit : hope your next repack come before christmas

[pryd]

I have just now released a new repack which supports 322a.

At this moment the repack is extremely clean and only features
guildmaster and telenpc functionality, of course ahbot as well.

During the course of today I will attempt to transfer the vendors
malls, for the custom database.

If anyone wants to help feel free to contact me here or on my forums.

And yes I do realize Mangos supports 330 already.

Questions I have pertaining to that are:
Is it worth transitioning back to Mangos from Trin? Pros Cons?

[rb2crens]

And yes I do realize Mangos supports 330 already.

Questions I have pertaining to that are:
Is it worth transitioning back to Mangos from Trin? Pros Cons?

i think it doesnt necessary, since trinity is stabler than mangos, only 1 thing : trinity may have a bug on Vmap processing, ex. on icecrown, any npc that might be aboard both gunship only falling away.

much appreciated for your new repack, hope everything as good as before (or better)

[-Alfa-]

Very Very Thanks PRYD

[Vatralaus]

can someone help, i can not loot anything when i am gm .

[pryd]

PryDevServer Repack 322a rev3 released - Full Malls / Vendors / Vehicles etc

I have merged all the vendors, malls, extra npcs, teleporters,
custom items such as the frostmourne, an extra GM set of armor, and custom spells for the PVP database.

We also got: A ton of 330 items such as T9 / T10 + more...
So don't mind the slight load error. hehe

Now obviously since we're still on 322a client not all the graphics work..
The T9 I tested for sure does though.

Included in this repack, ( though I have yet to test it ) is TrinAdmin converted from MangAdmin by Iotech.
Hopefully we can get this working for 322a if it doesn't already.

I also have now included TrinGuard which works awesome for keeping
multiple servers up, also hides everything.. it's a wonderful app.

Major credits to Mikec from trinitycore.org for the release. Thanks!.

Hope you all enjoy, sorry for the long wait!
Oh and if I knew how to make trin2 compatible w/ 330 I surely would do so.

Special thanks to batuyanga for sharing those links

[Krobelus]

love you and your Repack Pryd also, it saves not thrilled I am and I hope the launch of your repack to support 3.3.0

[Aurille]

Aw give him a break on 3.3.0, Trinity doesn't even fully support 3.2.2 yet!

By the way does the playerbot system work?

[Urashima]

In first I want to say thanks Pryd for the repack, is the best i have played so far, I always play single player because I do what I want to do and can player like gm

Buttttttttttttttttttttt

I have a biggggggggggg problem the problem is, every time that change the version of client and emulator together i have to start everything againg, start the quests, the points, the itens, this make me crazy because i have to start everything from begining.
I lost my characters many times.
I was playing 3.1.3 now i lost everything when play 3.2.2a, because i don´t know how to update the characters.sql and realmd.sql, i want to know if is possible to update this databases without losing everything, i don´t know almost anything about sql, i just try to copy the old files in sql data folder over the new database characters.sql and realmd.sql and it don´t work because is not correct to do it, i don´t know what to do.

sorry for my english

thank you

[mitfry]

To Urashima:

Heya m8,

I understand your problem but it's not that hard to remain the characters you had in 3.1.3, ill try to explain what to do in your case.

1. First Make sure you have any SQL editting program installed like Navicat or HeidiSQL etc.
2. Make a connection to your 3.1.3 database with the SQL editting program you use.
3. Export the whole character database and save it somewhere easy to find back.
4. Now you may close the connection with your 3.1.3 database.
5. Open the file you exported with notepad and check/make sure you delete the lines to ''drop the current character table(s)'' (it's somewhere at the beginning of the text inside the SQL file). Dont forget to save it after you editted it.
6. Now make a connection to your 3.2.2a database (just like you did with your 3.1.3 database) and import the exported character file from your old character database to your new one.
7. That's basicly all, you're done! I hope you understand it. =]

Regards,


Mitchell

[Urashima]

I love you mitfry


But i don´t understand, which part is to delete from the table

For example

/*
MySQL Data Transfer
Source Host: localhost
Source Database: char18
Target Host: localhost
Target Database: char18
Date: 20/12/2009 21:26:47
*/

delete everything

delete from here to ?????????????????????????????

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
DROP TABLE IF EXISTS `account_data`; delete here ?????
CREATE TABLE `account_data` (
`account` int(11) unsigned NOT NULL DEFAULT '0',
`type` int(11) unsigned NOT NULL DEFAULT '0',
`time` bigint(11) unsigned NOT NULL DEFAULT '0',
`data` longtext NOT NULL,
PRIMARY KEY (`account`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

to here to delete ????????????????????????????

-- ----------------------------
-- Table structure for arena_team
-- ----------------------------
DROP TABLE IF EXISTS `arena_team`;
CREATE TABLE `arena_team` (
`arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
`name` char(255) NOT NULL,
`captainguid` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`BackgroundColor` int(10) unsigned NOT NULL DEFAULT '0',
`EmblemStyle` int(10) unsigned NOT NULL DEFAULT '0',
`EmblemColor` int(10) unsigned NOT NULL DEFAULT '0',
`BorderStyle` int(10) unsigned NOT NULL DEFAULT '0',
`BorderColor` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`arenateamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for arena_team_member
-- ----------------------------
DROP TABLE IF EXISTS `arena_team_member`;
CREATE TABLE `arena_team_member` (
`arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
`guid` int(10) unsigned NOT NULL DEFAULT '0',
`played_week` int(10) unsigned NOT NULL DEFAULT '0',
`wons_week` int(10) unsigned NOT NULL DEFAULT '0',
`played_season` int(10) unsigned NOT NULL DEFAULT '0',
`wons_season` int(10) unsigned NOT NULL DEFAULT '0',
`personal_rating` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`arenateamid`,`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for arena_team_stats
-- ----------------------------
DROP TABLE IF EXISTS `arena_team_stats`;
CREATE TABLE `arena_team_stats` (
`arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
`rating` int(10) unsigned NOT NULL DEFAULT '0',
`games` int(10) unsigned NOT NULL DEFAULT '0',
`wins` int(10) unsigned NOT NULL DEFAULT '0',
`played` int(10) unsigned NOT NULL DEFAULT '0',
`wins2` int(10) unsigned NOT NULL DEFAULT '0',
`rank` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`arenateamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for auctionhouse
-- ----------------------------
DROP TABLE IF EXISTS `auctionhouse`;
CREATE TABLE `auctionhouse` (
`id` int(11) unsigned NOT NULL DEFAULT '0',
`auctioneerguid` int(11) unsigned NOT NULL DEFAULT '0',
`itemguid` int(11) unsigned NOT NULL DEFAULT '0',
`item_template` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
`itemowner` int(11) unsigned NOT NULL DEFAULT '0',
`buyoutprice` int(11) NOT NULL DEFAULT '0',
`time` bigint(40) NOT NULL DEFAULT '0',
`buyguid` int(11) unsigned NOT NULL DEFAULT '0',
`lastbid` int(11) NOT NULL DEFAULT '0',
`startbid` int(11) NOT NULL DEFAULT '0',
`deposit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `item_guid` (`itemguid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


is to delete Records too ??????????????????????
or something inside Records is to delete ??????????

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `account_data` VALUES ('5', '0', '1257973366', 'SET showTargetOfTarget \"1\"\nSET showTargetCastbar \"1\"\nSET showVKeyCastbar \"1\"\nSET questFadingDisable \"1\"\nSET watchFrameState \"1\"\nSET profanityFilter \"0\"\nSET removeChatDelay \"1\"\nSET guildShowOffline \"0\"\nSET guildMemberNotify \"1\"\nSET lockActionBars \"1\"\nSET alwaysShowActionBars \"1\"\nSET UnitNameOwn \"1\"\nSET UnitNameNPC \"1\"\nSET enableCombatText \"1\"\nSET fctSpellMechanics \"1\"\nSET xpBarText \"1\"\nSET playerStatusText \"1\"\nSET petStatusText \"1\"\nSET partyStatusText \"1\"\nSET targetStatusText \"1\"\nSET cameraDistanceMaxFactor \"2\"\nSET serviceTypeFilter \"7\"\nSET talentFrameShown \"1\"\nSET threatShowNumeric \"1\"\n');
INSERT INTO `account_data` VALUES ('5', '2', '1257973364'


thank you very much for the help

and sorry for my english