CDawg

Don't know if this was brought up and one thing that you have to take into consideration, that regardless of where your health is at (example: it could 10 billion hp), some debuffs work by percentage. So the insta death could possibly be working it down from a 99% intentionally. I don't remember ICC placing a debuff on you when you enter, but also adding to what IbeatDungeon is stating that the high numbers could possibly be.. well.. too high.

https://github.com/TrinityCore/TrinityCore/blob/master/src/server/worldserver/worldserver.conf.dist#L242 Assuming you are on Windows and using the Master branch. It's selected by your OS (using default).

Assuming you are on Windows... Sounds like you didnt copy or configure the authserver.conf.dist and worldserver.conf.dist. Follow the instructions and get your conf files set-up and configured, then we can talk about the DB error you received. Go to the very last step on this page. https://trinitycore.atlassian.net/wiki/display/tc/Windows+Server+Setup

How is this related to TC, and what are you trying to accomplish by pinging the server through an application?

Which revision? I dont have any issues with 335a

There are several options: There is a check for the realm first achievement across the characters once the event happens. QueryResult result = CharacterDatabase.Query("SELECT achievement FROM character_achievement GROUP BY achievement"); The safest method is to delete that character. You may have to restart the server before a new player reaches level 80, first class, first kill, etc... after the rewards were stripped from the player. If it was a GM that received the achievement, then just delete it. If it's a player, you will have to strip it from character_achievement, including character_achievement_progress.

https://github.com/TrinityCore/TrinityCore/issues/18391

TC 335a is the most stable revision existing. What does not work?

First thing.. you said "mbits" so I'm assuming that was a typo. 50Mbits is horrible. You could barley stream a video with that. Also we are not support private servers (production). This is for "testing" purposes only. So let's get started and assume you didn't mean to 50Mbits and you meant to say 50 Mbs (Megabytes) If you are running that private system with Windows from your house, than yes. I would expect 50+ to start lagging on that system. I run multiple linux system(s) from my house and they are 5x the speed with a dedicated T1 line. Not to mention the dedicated database server, app server, and other hosted systems. I "could" max out at 2k. - Your system may have background processes running on it, Your network upload speed under 30Mbs would cause major lag. Your 50Mbs download doesn't mean anything. Last, I don't recommend running anything on that machine, unless it's for "testing" with a few friends. If you want to really "test" it out and have 150+ friends without lag, then you need to purchase a cloud system or spend the money to upgrade your current system + network, also (if it's not), get that thing on Linux, not windows. Windows is great for quick compile, burn and testing. I don't want to sound rude, but a ton of people overestimate their network + system, then they get their ass handed to them and post here on the forums for help.

That all depends on your hardware. I don't know the details of your hardware.

Hey bblewittAGA, it's easier to give the details of the broken quest here. https://github.com/TrinityCore/TrinityCore/issues/new I couldn't find an open issue for that quest, and I can't test it yet.

try this git log -- sql/updates/characters/

There have been a ton of changes to the architect of the db over a year span and It's really difficult to go over each column/table change without updates. One thing that you could try is to go each database change commit from the past to your version/commit, then to run each update or dissect each change that was made over the year and few months. https://github.com/TrinityCore/TrinityCore/search?l=SQL&q=sql&type=&utf8=✓ also be sure to just check 3.3.5a for those update changes and may have to manually do each change.

If you have friends that play, and you decide to force the settings to 0, you can also force "at_login" to 8. That way your friends can customize their characters on the new table. https://trinitycore.atlassian.net/wiki/pages/viewpage.action?pageId=2129969#characters(table)-at_login Good luck

It will default the characters settings to "0".

I created a script that converted it. I'm looking for it. It's been awhile. But what I did was, defaulted the hairStyle, hairColor, etc., etc, to "0"; Then I ran a script that matched the GUID to each and did a php explode for each PlayerBytes1 & 2, and converted it that way.

That was changed over a year ago https://github.com/TrinityCore/TrinityCore/blob/a249d86b00eb0854cb925f8bea76ddbb364208df/sql/old/6.x/characters/03_2016_04_11/2016_01_05_00_characters.sql

I don't have the db for that specific application(armory). If you go with that Armory you will have to obtain the database from that particular person. It appears that he used Exodius' armory DB here. Like I mentioned most of the armories are proprietary to their specific project. Shadez made one many years ago and everyone I know branched from that and made their own hybrids. You want to cache some of the queries and dump everything into json (for security purposes), or if you would prefer to use a live xml generated armory, similar to how blizz does their armory push/pull generation. If you know LAMP or XAMP (for windows), best bet would be to create one yourself. I'll PM you my full armory db. But, the application layer will have to be built by you or someone that knows how to program.

Really? Does this look like the repack support forums? You want support or help, start here... https://trinitycore.atlassian.net/wiki/display/tc/Core+Installation

Most of the armories for 335a have been moved onto Cata version or higher. It took me about 1 full year to perfect mine. You might find tidbits on github. But here is where to start an armory for your version. Dissect the client DBC files and dump them all into MySQL or XML (your choice), then really go from there. I can help with the math if you need. For Example the iLvl from the gear that characters are equipped with. The client local DBCs actually have just about everything you need. To be honest, I can look for the scripts where I de-compiled the DBCs and had them inserted into mysql. But I don't know exactly what you're looking for. I can provide mysql dumps if you would prefer.

Read it carefully: https://trinitycore.atlassian.net/wiki/display/tc/Windows+Core+Installation Your compiler can not be found.

1st thing. We don't support repacks or other sources outside of TC. Have the machine bind on the actual IP. or try 127.0.0.1 RA Port is not the same as SOAP. so you can throw out 3443. Just worry about HOW you are connecting to 7878 If your server is something like 192.168.1.20 <- then use that if 127.0.0.1 does not work. Also you only need to whitelist (internally) from one machine to the other if you are using SOAP. Again... assuming you are trying to use a web host to connect (not on the same machine), then you need to whitelist that on your router to handle the (external) connection. Default Example: SOAP.Enabled = 1 # # SOAP.IP # Description: Bind SOAP service to IP/hostname. # Default: "127.0.0.1" - (Bind to localhost) SOAP.IP = "127.0.0.1" # # SOAP.Port # Description: TCP port to reach the SOAP service. # Default: 7878 SOAP.Port = 7878

You can ask runningnak3d. I helped to remove a ton of 335a from the core. All that I know of, is that TC's version of 243 is here that was abandoned 3 years ago. https://github.com/trinityclassic/trinityone 243 Opcodes https://github.com/trinityclassic/trinityone/commit/c832881b0d71bc3a094402739327f4b2d8b686c7 Hope this helps.

Create patches/diffs for your changes. After I make a change, I create a patch. before updating your core from TC git format-patch -1 <commit sha> After updating your core from TC, then just git apply <mychanges.patch> If you know the exact changes in a file, you can create the diff. and use the same command to apply that diff as a patch. Git knows. diff --git a/file1 b/file2 TIP: I find it easier to just use the git patch method for all your changes. Try to create small changes and patches for each of those minor changes. Rather than one large patch that has ALL your changes. It could cause an issue later, then you have to hunt down where it broke because of the conflicts with TC core's changes versus your own changes. I have like 15 different patches for my personal changes on my own project and If I were to stash all the changes in one file, it would be a nightmare.

mysql> select * from auth.rbac_permissions where id > 23 AND id < 30; +----+-------------------------------------------------+ | id | name | +----+-------------------------------------------------+ | 24 | Two side faction characters on the same account | | 25 | Allow say chat between factions | | 26 | Allow channel chat between factions | | 27 | Two side mail interaction | | 28 | See two side who list | | 29 | Add friends of other faction | +----+-------------------------------------------------+ mysql> select * from auth.rbac_permissions where id = 195; +-----+------------------------+ | id | name | +-----+------------------------+ | 195 | Role: Sec Level Player | +-----+------------------------+ EXAMPLE: Let's add both factions on same account mysql> INSERT INTO `auth`.`rbac_linked_permissions` (`id`, `linkedId`) VALUES ('195', '24'); mysql> select * from auth.rbac_linked_permissions where id = 195; +-----+----------+ | id | linkedId | +-----+----------+ | 195 | 3 | | 195 | 4 | | 195 | 5 | | 195 | 6 | | 195 | 24 | | 195 | 27 | | 195 | 49 | | 195 | 199 | +-----+----------+