Jump to content
TrinityCore

CDawg

Members
  • Posts

    1477
  • Joined

  • Last visited

  • Days Won

    85

Posts posted by CDawg

  1. Ports are not handled by the ISP, they are configured by your internal router/gateway. Your ISP can not control your ports, unless it's behind a restrictive proxy server which you are trying to play while at work, a library, or some company. Even though there are ways around that.

    The only reason I know that, is because I live in the same area you do ;) or share the same ISP's from where I live in the states down to Baja Mexico where you live.

    Anyhow, are you referring to a static IP?

  2. @geeksweep 

    First of all, wowhead is a horrible horrible resource. I catch items that are never up to date or in sync.

    Secondly, to reiterate waht Aokromes had mentioned, you never ever want to insert directly into a DB, especially the character's inventory. Not to mention, if the player is online, the manual entries don't update the server and could cause problems to the player. They could overwrite that current entry while playing, or worse, it could also crash the client...

    Here is a solution. In game email the item to the player. Let the server do the work. You can use SOAP to give the player the item using a script. I see too many people make the mistake (thinking that they know what they are doing) and manually inserting the item into the character's inventory. This also goes for reputation, faction modifications, etc...

    Use the console or in game commands!

    • Upvote 1
  3. You are still missing the actual database structure.

    Your database structure should be:

    auth

    characters

    world

     

    Like Aokromes mentioned: your core should have an "updates" directory that will automatically apply the patch and update.

    It looks like your auth and world are combined...

     

    Start over here:

    https://trinitycore.atlassian.net/wiki/display/tc/Databases+Installation#DatabasesInstallation-InstallingTheTrinityDatabasesImport6.xbranchor3.3.5abranchbeforestartingcore.

  4. I don't use Windows, but some old notes jotted down say...

     

    in CMAKE click Advanced, then manually set the mysql libraries to the c:\mysql\lib_64 folder
    set MYSQL_INCLUDE_DIR = path C:/mysql/include and filepath MYSQL_LIBRARY= C:/mysql/lib_64/libmysql.lib

     

    C:\mysql   was where i installed my mysql library path.. be sure to check where that your path is accurately set to where those libs are installed. Then re run CMake 1. configure, 2. Generate.

    Running configure multiple times doesn't harm CMake process.

  5. I just got back working on TC and decided to fire up my very old TC and thought to myself, hmm. let me pull the latest and see the changes they have been working on.

    I wasn't surprised that almost every table structure had vast differences from 1 year ago.

     

    Honestly, the best way I did it was with a script. This is a lot of work (depending on the diff between both DB and table structures).

    If it's another project outside of TC, it's going to be even more complicated!

    On 7/7/2016 at 9:32 AM, AciDCooL said:

    Since removing the keys from say character-aura would mean that the second row correspond to a totally different user.

    that's what the unique "guid" is for and pdump will allow to insert a character using another guid of your choice.

    Pull each guid per table and insert. Your newly insert table will have some conflicts.

    Even going from 1 year old TC with a ton of characters into the newest character DB, required so much work with changes.

     

    I don't want to discourage you,.. I would just pick an easy programming lingo like php or perl, get a loop cycle with pdump (if it's successfull which i highly doubt) then go from there.

    I did it manually with a script almost line by line, bcuz I knew there would be conflicts. And there was, ALOT!

    • Upvote 1
  6. Hmm.. well that sucks :huh:

    What's the reason for the change? If you don't mind my asking. Was there something that forced it?

    And another question if you can answer it, What is the last update/patch/date that will compile on XP?

     

    The world is going x64+

    Eventually even U.S. ATM machines will have to go with a newer OS very very soon. Yes.. thats right, its sad but true. There are countless ATM machines that still have XP.

  7. It's only hard to see shit when you don't know where to look.

    You must yell at your screen alooooot...

     

     

    I guess trying to learn here is a fucking mistake.

    You just learned something, didn't you?

     

     

    Obviously a bunch of pricks and/or immature little bastards.

    I'm a big immature bastard, not a little one. Been trying to lose some weight, but it's difficult after my knee surgery.

     

     

    I guess i'll learn elsewhere.

    You'll be back.

  8. mingdynasty, why are you getting so worked up, regardless if anyone believes you or not?

    What do you propose this community to do? If people take from what trinitycore has worked for and never gives back, then what do you expect?

    Yet, people still come here... (including you)

×
×
  • Create New...