Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

CDawg

Members
 View Profile  See their activity

  • Posts

    1477

  • Joined

  • Last visited

  • Days Won

    85

 Content Type 

Posts posted by CDawg

  1. ICC Insta Death on enter

    in Help and Support

    Posted

    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.

  6. Reset all RealmFirst! achievement

    in Help and Support

    Posted

    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.

  9. Lags

    in Help and Support

    Posted

    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.

  13. Character Table

    in Help and Support

    Posted

    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.

  16. Character Table

    in Help and Support

    Posted

    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.

  18. Armory for Trinity core 3.3.5?

    in Help and Support

    Posted

    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.

    • Upvote 1

  20. Armory for Trinity core 3.3.5?

    in Help and Support

    Posted

    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.

    • Upvote 1

  22. SOAP Issues Trinity Core 3.3.5a

    in Help and Support

    Posted

    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

  24. Pulling fixes issue

    in Help and Support

    Posted

    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.

  25. AllowTwoSide.WhoList 

    in Help and Support

    Posted

    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 |
    +-----+----------+

     

    • Upvote 1
×
×
  • Create New...