Leaderboard

This sniffer is closed source, don't ask for new sniffer versions making new threads or on irc, new versions will be released when I have time. The sniffs are only available for TC developers and official contributors because they contain private data. Sniffer only works with LIVE realms and the build number stated on title/key file. How to use it: Put it on your wow directory. Start wow.exe. Start attach_sniffer. login. OR Start Wow-64.exe Use attach_sniffer_64 login. If you want to force WoW to start in 32-bit only mode use Wow.exe -noautolaunch64bit Upload your sniff compresed with zip, rar, 7z or some linux format to some non-anoying file hosting (for example zippyshare, mega, anything without captchas or wait times). Post your sniff at http://www.trinitycore.org/f/forum/13-wdbadbsniffs/ only devs will see your sniff there. Note: When updating sniffer you need to overwrite all old files. Edit by ShinDarth: In order to run the sniffer under GNU/Linux or Mac OS X you have to use the Windows client (Wow.exe) and open it using wine (get the latest version). Note: if you have the Mac OS X client already, you can just download the *.exe and *.dll files of the Windows client and add them to your Mac client folder. Instructions: - open a terminal window and run: wine Wow.exe -noautolaunch64bit Script for wine (save in the same directory as wstc) #!/bin/bash WSTC_COMMAND=$(grep -E -o 'WSTC.exe .*\.wstc' ./attach_sniffer.cmd) set -x wine $WSTC_COMMAND WSTC_7.2.5.24461_Release.zip WSTC-64_7.2.5.24461_Release.zip

The application I use is custom made I make all my applications either using Xojo or Livecode depending on the project but most database or MySQL programs I make using Livecode because it supports MySQL and most databases really well. I am also working on a new application that controls all the database tables and allows you to add data to the database a lot easier like game objects, loot, quest, npcs, commands and so on. It is going to allow for easy editing of the database and allow for error proof to the most of its ability. I am also wanting to do something new with the search abilities to allow for copying other items so you can search for one field and use it as a template so you can create the next item, npc, command or so on.

I rarely use mariadb for any version of Linux and more so for Ubuntu even so just use MySQL for your data flow. You are going to be better in the long run unless you really know mariadb I would not use it.

Bnet server for 4.3.4 is not done or working yet but auth server is working of course and for the realmlist in the database for realm looping make sure it is set to your main IP and not localhost or 127.0.0.1 but instead the main IP. Also make sure in the wow directory you have under realmlist.wtf file the main IP address as well.

.debug bg = Toggle debug mode for battlegrounds. In debug mode GM can start battleground with single player. Or if in your case if you want to do a true 1 vs 1. You can temporarily modify world.battleground_template with min players per team to 1 for that particular battleground. https://trinitycore.atlassian.net/wiki/display/tc/battleground_template#battleground_template-MinPlayersPerTeam 1. .reload battleground_template 2. level 80+ alliance queue up for that BG. 3. level 80+ horde queue for the same BG.

@Halebawa I think I see your issue, when skimming across the images. more clearly. Your Trinity Realm in the DB needs to be set to 8085. It's at 3724. Port 3724 is your authserver. You mentioned you added a second realm, was that also at 3724? That needs to be 8086 or another port configured. Let me know.

It's crashing (closing) immediately due to a configuration issue. In Windows, use cmd.exe to navigate your worldserver.exe path and run worldserver from the terminal via command line and dont double click binary to execute. That will prevent the window from closing. Also, everything should be 127.0.0.1. and not worry about your firewall. Windows whitelists 127.0.0.1 automatically. You should use that for your realmlist.wtf and your DB settings. Once you get an exact error message from the console (without it auto closing), report back what the issue is and we can help get you set up.

We can always add them and submit a PR Not sure how many items that may need to be excluded.

.debug quest, I do believe is the command I could be wrong on this, it has been a while since I have done any debugging.

Can you get me a debug the quest for me when you pick it up and also where are you picking the quest up at because I noticed when switching over from mangos the titles don't always switch over, I also noticed that with the bank in Stormwind too.

I went over everything you just said and even did the same steps as you did and I am able to click them just fine even the quest in Stormwind when you have to collect the apples around Stormwind work for me I am able to click on them as well. Maybe I am missing something you said, but I even tried adding my own quest with a custom item and I am able to collect the tablets as well for my quest. I did this after the one item you said wasn't working just to make sure I was able to enable the clickable item. I also make the quest with a script too so I could make it clickable only during a quest and no other time. I will go over it again so I can try to hopefully get the same issue you are seeing so I can try to figure out what is locking you up and to see if I can get the item not to work for me so far no luck.

Ok I figured it out. I had to pull all entries from character_queststatus_rewarded and delete matching entries in character_queststatus for that guid quest numbers. Example: Had this Line in characters.character_queststatus: guid, quest, status, explored, timer, mobcount1, mobcount2, mobcount3, mobcount4, itemcount1, itemcount2, itemcount3, itemcount4, playercount 3,9569,3,0,1500417612,0,0,0,0,0,0,0,0,0 And in character_queststatus_rewarded: guid, quest, active 3,9569,1 Once I removed these in rewarded from the queststatus they are out of the quest log. I may have to do additional checks but it should be fine and I need to do more testing lol. Thanks for the help.

~/TrinityCore7/src$ grep -inr quest_tracker server/game/Handlers/QuestHandler.cpp:458: if (sWorld->getBoolConfig(CONFIG_QUEST_ENABLE_QUEST_TRACKER)) // check if Quest Tracker is enabled There is a quest_tracker db, although I could not find it here: https://trinitycore.atlassian.net/wiki/display/tc/Characters where it should be... Be sure you have the config enabled.. https://github.com/TrinityCore/TrinityCore/blob/master/src/server/worldserver/worldserver.conf.dist#L997 But, that's where it is stored. no need for a "log file" better to track in a DB. That what you are asking? EDIT: Iv'e only used it on my 3.3.5a servers. I just double checked that it works on the 7.x version.

I'm Still alive...

More: http://thehackernews.com/2017/07/gsoap-iot-device-hacking.html

For 7.x, I dont believe editing anything for the local client to get results to the server in the wdb. However, maybe someone can assist answer that once you modify the gameobject on the server db, that you may want to clear cache to until you get the results you desire. Even for 3.x I occasionally have to delete cache dir for certain server changes.. I know 7.x is pretty heavy on client storing now.

Is this 3.3.5a, 4.3.4 or 7.2.5 because either one it is matching the correct way with blizzard servers.

Oh you compiled it under Linux I didn't catch that until you said it just now.

To add what Codeman8214 said.. Just be sure it's enUS version if you are using 3.3.5a.

I had the same problem until I restored the files on the client and restored the wtf folder as well then everything worked great for me afterwards because it was not loading the mpq file properly in the format that it needed to understand the conversion when the client loaded into the world and worldserver.exe when loading the information back and forth but needless to say everything is working great now.

The file type is still an application for the connection_patcher.exe even if it does not show one if you go to properties you will see it is executable still, you can run this in command prompt I do all the time by declaring the path to the file and file name. You can download the file on piratebay by going to google and putting piratebay into the search then search for world of warcraft and download the 3.3.5a client from that site or others like it. If you cannot find one let me know and I will send you a private message with a link for the client.

This normally happens when the file is being blocked because it has happen in the past so make sure the file is not being blocked in any other way also make sure you have enough space that is another error that seems to happen a lot when trying to patch the client.

Did you get it working? I had the same issue testing out mariadb and loading the libraries, I was furious that it overwrote my tables, libraries, data, etc.. (I thought it would install parallel and read my db so that I could test performance over true mysql server). I just completely uninstalled any trace of it. If you need to backup data, do a mysqldump first. https://askubuntu.com/questions/806107/remove-mariadb-mysql-databases

You don't need mariadb (for your version of linux OS). I'm only using mysql. Your cmake config is still viewing marialib. Just blow away the build directory, remove mariadb, load only mysql and start over from cmake, then build. apt-get install libmysqlclient-dev mysql-server

thanks for helping,I delete build folder and do again,everything is ok.

I don't see how this is posible if batch file runs for the build.

iirc bnet "server" came out during Cata or mid expansion to hold ids and other games (not just wow). My memory vaguely serves me correctly. Anyhow, you are not required to run it for 4.x, it's a luxury item to have keeping track of friends, etc. during that time. I believe after Cata into MoP (5.x) it was then a requirement. But that is how Blizz currently uses a stronger authentication to the client.

I just got it working. Some how the file WSTC-64.exe and the key64.24461.wstc were blocked by my OS. To fix it I just right clicked on the properties of both files and unblocked them.

If you select desktop environment on the main screen you will not have any problems installing what you need and it is no more then 4.7gb in size. I want to say actually 4.5gb.

Only 7x and 3.3.5a (not sure how long 3.3.5a will be supported) That link for 4.3.4 (at least i don't think) is not officially supported by the TC community, just a branch from TC. No vanilla, TBC, mop, or WoD.

Found the problem!!! I was able to duplicate it. I was working on screen sessions and just noticed that I already had a worldserver running on that port. So it was occupied. Long story short. it looks like worldserver is not "restarting" properly. you have to do a full .server shutdown check that you don't have another worldserver running on the same port. Example: $ ps auxf | grep -i worldserver cellyson 14595 0.7 5.0 1490564 1250720 pts/2 Tl 16:06 1:06 \_ ./worldserver

Fixed when i updated to the last revision 7.2.5 24461, thanks all.

@CDawg Yup, that was it. I knew it would be something dumb like that. Thanks, it's working now.

If I am right and understand the log correctly if there wasn't more to it then it is saying it cannot link to boost correctly meaning it cannot find it, are you using boost 1_63_0 or 1_64_0 if you are then use 1_63_0 because it should point to that directory unlike 1_64_0 which seems to have trouble when finding the libs for boost.

If you are using mysql, dedicate more memory to increase your speed. Use more RAM to increase data storage going back and forth from memory and not use your physical hard drive to write, then upload. Make a backup of my.cnf file and do minor increases to: key_buffer_size sort_buffer read_buffer table_cache innodb_buffer_pool_size Then restart MySQL. Be sure to keep an eye on your memory usage. You don't want MySQL to much RAM. Also, see about increasing RAM in your computer. If I'm reading that correctly, you only have 3Gbs of RAM which is extremely low if you have more than 10 players in the future.

It still sounded like an issue with your DB in the beginning... Creating users on the DB won't solve it, unless it needed a restart.

run nload while all 9 players are playing and tell me if Incoming or Outgoing is spiking. This is a test on my server with 8 people playing who volunteered Your outgoing should be less Avg: 27.46 kBit/s Your Incoming should be less Avg: 12.59 kBit/s Does this happen when only you play by yourself? If you are getting spikes only with other players, then there is other activity going on. Possible that one of the players is DDOS'ing your network?

You can manually modify the name after in the database and bypass the client.

Updated to 7.2.5.24461

You can modify the file etc/hosts in order to redirect yogur url into your Internal IP. In Linux, the file is /etc/hosts. In Windows, c:/windows/system32/drivers/etc/hosts

Or you can simply: apt-get install git cmake make gcc g++ libmariadbclient-dev libssl1.0-dev libbz2-dev libreadline-dev libncurses-dev libboost-all-dev mysql-server p7zip

Hello all, that time fo the year again, we just moved to a new host. see something bad? let me know

Are the profile Locations supposed to be truncated together? For example: I deliberately placed a colon : and a space so the location is not truncated.

You mean, this guy? https://github.com/TrinityCore/TrinityCore/blob/master/contrib/extractor.bat

Are you guys sure that you have enUS and not enGB or something else other than enUS in your wow directory.

Thank you so much that is what it was the gt folder everything works great now. You saved the day!!! YEAH!!!!!!!! not sure how the gt folder got screwed up but thank you.

Are you talking to me? i have tried 1.55.0 1.63.0 and 1.64.0 i also tried set (ENV{BOOST_ROOT} "C:\local\boost_1_55/63/64_0") in CMakeLists.txt

That is a very very old characters database. That column was replaced a year ago. Read the instructions closely on adding a new characters database.

I noticed with 1.64.0 you have to set the paths yourself when it comes to cmake finding them but when I installed boost 1.63.0 it worked just fine cmake was able to see the paths so have you tried installing 1.63.0 of boost.

That was the answer I was looking for, I can't believe I missed something that simple I feel dumb now lol, thanks.