Jump to content
TrinityCore

MDK

Members
  • Posts

    44
  • Joined

  • Last visited

Everything posted by MDK

  1. Thanks for referring to that issue. How do you guys work around this?
  2. Hi Codeman, Yes I got the Olemba Seeds working. This was for me one of many quests with gameobjects that didn't work. With a completely new build it does. So I think that I've messed up the previous build with Navicat. I can't otherwise explain it, but I'll stick to MySql (with Workbench) as TrinityCore recommends. Thanks for helping out!
  3. I've started over: 1.) complete new git check out, rebuilt VS project with cmake. 2.) compiled new bnetserver, worldserver 3.) extracted all maps, vmaps ,mmaps and dbc/db2 4.) created new instance and hosted on mysql server 5.7 5.) created all databases auth, characters, hotfixes and world 6.) filled it with DDuarte's TDB 7.2.0. 7.) ran all updates in the updates folder 8.) downloaded and installed Wow Client 7.2.5 9.) created new account and character 10.) tested the quest 9992 Olemba Seeds 11.) The gameobjects are highlighted and drop the items! So case closed, thanks for helping out and giving pointers to solve this issue. As for me I'm very happy with the new 7.2.5 release. I've discovered that the riding/flying trainers do not work also the profession trainers are not responding to gossips. Is that still expected not to work? I've googled the trinitycore issue history and there is mention of that that's been solved. However my trainer table is empty
  4. Ok, so reinstall mysql then. It's probably not only the database that got corrupted? I think I'll rebuild the project also, since I see that the log has a date of 15-05-2017, but I just pulled and built a new worldserver.exe. Something's messed up. I'll start over I think.
  5. Hmm ok, I was able to circumvent the above by applying all the world sql updates from the master branch and then also did that for the hotfix database. Unfortunately the worldserver won't run: TrinityCore rev. eb555dd48b26 2017-05-15 20:36:02 +0200 (master branch) (Win64, Release, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file E:/Games/WowPrivateServer/Legion/Official Legion 7.2.5/worldserver.conf. Using SSL version: OpenSSL 1.0.2k 26 Jan 2017 (library: OpenSSL 1.0.1u 22 Sep 2016) Using Boost version: 1.59.0 Automatic database updates are disabled for all databases! Could not prepare statements of the World database, see log for details. But what log do I access for details...Anyone got experience with this?
  6. Hi Daniel, Being busy right now with the updates of the database. I got the following error, any ideas why that happens?: TrinityCore rev. eb555dd48b26 2017-05-15 20:36:02 +0200 (master branch) (Win64, Release, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file E:/Games/WowPrivateServer/Legion/Official Legion 7.2.5/worldserver.conf. Using SSL version: OpenSSL 1.0.2k 26 Jan 2017 (library: OpenSSL 1.0.1u 22 Sep 2016) Using Boost version: 1.59.0 Updating Auth database... >> Auth database is up-to-date! Containing 11 new and 97 archived updates. Updating Character database... >> Character database is up-to-date! Containing 5 new and 67 archived updates. Updating World database... >> Applying update "2017_04_19_01_world.sql" 'B1EFAB0'... mysql: Could not create or access the registry key needed for the MySQL application to log to the Windows EventLog. Run the application with sufficient privileges once to create the key, add the key manually, or turn off logging for that application. Applying of file 'F:/Development/TrinityCore/TrinityCore/sql/updates/world/master/2017_04_19_01_world.sql' to database 'world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query. Could not update the World database, see log for details.
  7. Hi Daniel, I thought so, I'll do the cache clearing first. If that fails, then I'll do the truncate and import the original world sql file. The updates that are relevant are only those in the 7.x folder right? To clarify, I used the Dduarte database. That one is also available by Trinity TDB 720.00 which holds all data until 19-04-2017. I ran updates ontop of that one. If I start over I can truncate the world database but... what do I do next? Just turn on run updates when starting the worldserver?
  8. Hi Daniel, Thanks for testing and helping out. I've applied those settings and restarted the trinitycore worldserver. However the Olemba cones are not clickable. I didn't clear the cache in the client. I'll try this tonight. If that fails then I'm thinking of rebuilding a new database. I've taken the database of dduarte v720 as a basis and then ran the updates. Is that also what you guys have done?
  9. Hi Codeman! I was curious whether you've had any luck with testing my sql scripts and whether you had the same problem or not.
  10. Thanks! Let me know what your findings are!
  11. Hi Codeman, I've added the queries of all three tables for the Olemba Cone. Thanks for helping out! gameobject_loot_template by entry.sql gameobject_template by name.sql gameobject_template_addon by entry.sql
  12. Hi Codeman, Thanks for wanting to look into this. Here's the Olemba Cone gameobject entry in the gameobject_template with data8 column filled with questid. I'm not using Navicat anymore. Switched over to Mysql Workbench. First screenshot gameobject_template entry. second screenshot is that of the gameobject_template_addon table for the Olemba Cone. Gameobject_template_addon is selected on gameobject 182541. Third screenshot is of gameobject_loot_template Using the entry in data1 of the gameobject_template table of Olemba cone (screenshot 1) i.e. entry 19372. Entry 19372 points to Item 25745. This is an Olemba Seed item. However the problem is that I can't click on the gameobject. Any ideas based on these screenshots?
  13. Data8 column in gameobject_template (which points to completed questid) has value 0. Do you suggest to populate that with the questid?
  14. Hi Daniel, Thanks for your reply. I've also checked these entries you describe when gameobject is type = 3 (Chest). This is the case for Olemba Cone gameobject. The only way I got this working was to change questrequired = 1 to questrequired = 0. But... that would mean it would be clickable at all time regardless if there was a quest. Anyone got an idea to get it working with a quest? My question is still what might be out of place here?
  15. Hi AussieGuy and gpn39f, Thanks for your replies, what would you advise me to do further? Check the gameobject_loot_template for entries for in my case the Olemba Cones? Olemba cones are quest related objects.
  16. Hi codeman! Thanks for trying, I'm puzzled why mine doesn't work and yours does. If I would add screenshots of the database entries that might help? Do you use other tools to add things to the database? I mean I look things up with SQL statements (and change things on the database) using NaviCat. I've corrected for other things the gameobject loot for silver vein and small thorium veins in the gameobject_loot_template and that did work. So I can say that some changes work after restarting, which leads me to believe that I'm doing something wrong for the Olemba Cones. Can we do a comparison of the gameobject, gameobject_template and gameobject_template_addon database entries? Yours versus mine? What I do notice is that when there are gameobjects involved in quests these almost always are broken (present in the world, but not clickable)
  17. Well I've tried a lot but no success yet. I've compared the Olemba Cone gameobject 182541 to Glowcap gameobject 182053. The Glowcap gameobject works when clicking on it in Zangarmarsh. Compared it with gameobject, gameobject_template and gameobject_template_addon. Almost everything is the same with exception to the gameobject id's/entries in the tables. Flags are the same. What I don't get is why I can click on the gameobject Glowcap (shows tooltip display and cogwheel when hovering over it) but the Olemba Cone (containing the seeds) does not. Both gameobjects are of type chests (type 3) and are in fact containers for items. Has anyone stumbled across the same problem? After applying database changes and restarting the worldserver I also clear the cache clientside. This however doesn't change a thing unfortunately the Olemba Cone is still not clickable.
  18. Thanks! I'll try clearing the cache as well. I added an entry in the gameobject_loot_template table. There the 'loot' gameobject wasn't registered to drop the book. The cache needs to be deleted from the Wow client, right?
  19. Hi CDawg, I'm working on 7.x and was trying to get a grip on where to look and what to edit. I'll check the flags first and post what I find. Do I need to edit WDB files as well or should that never be the place to look for?
  20. Hi there, I'm just playing around doing some quests and was wondering which steps I basically need to take to get gameobjects to work when doing a quest. I.e. I've done the quest An Old Gift, where I need to click on a book which lies in a doorstep. This book is present in the world, however I can't click on it. Also it's not sparkling like 'click on me' :). What I don't know is what steps need to be taken to make this work. Who can tell me what needs to be done?
  21. I'd like to do the same for first aid spells and food e.g. Do we need to look at DB2 files and interpret these in combination with the world database where spells are located? I know that complicated spells are coded in VC++ and are referenced from the database.
  22. That it is indeed, however after a restart of the worldserver, can't login again... same issue logging into game server... Good tot mention as well is that when i stop the worldserver with ctrl+c it hangs and then says not responding. After a new start of the worldserver i can't connect using the previously set local ipaddress which worked before in earlier post.
  23. Battlenet.log 5/17 21:32:31.748 [IBN_Login] Starting up | hasFrontInterface=false | hasBackInterface=false 5/17 21:32:45.096 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=192.168.178.192:1119 5/17 21:32:45.096 [GlueLogin] Resetting 5/17 21:32:45.096 [IBN_Login] Initializing 5/17 21:32:45.096 [IBN_Login] Attempting logon | host=192.168.178.192 | port=1119 5/17 21:32:45.096 [GlueLogin] Waiting for server response. 5/17 21:32:45.191 [GlueLogin] Waiting for server response. 5/17 21:32:45.191 [GlueLogin] Waiting for server response. 5/17 21:32:45.264 [GlueLogin] Waiting for server response. 5/17 21:32:45.407 [GlueLogin] Waiting for server response. 5/17 21:32:45.407 [GlueLogin] Waiting for server response. 5/17 21:32:45.428 [GlueLogin] Logon complete. 5/17 21:32:45.428 [GlueLogin] Waiting for realm list. 5/17 21:32:45.428 [IBN_Login] Requesting realm list ticket 5/17 21:32:45.439 [IBN_Login] Received realm list ticket | code=ERROR_OK (0) 5/17 21:32:45.439 [GlueLogin] Waiting for realm list. 5/17 21:32:45.439 [IBN_Login] Received sub region list | code=ERROR_OK (0) 5/17 21:32:45.439 [IBN_Login] Requesting last played chars | numSubRegions=1 5/17 21:32:45.460 [GlueLogin] Realm list ready. 5/17 21:32:45.460 [IBN_Login] Joining realm | subRegion=2-1-0 | realmAddress=2-1-1 5/17 21:32:45.632 [IBN_Login] OnRealmJoin | code=ERROR_OK (0) 5/17 21:32:46.139 [GlueLogin] Received AuthedToWoW | result=ERROR_OK (0) 5/17 21:32:46.825 [IBN_Login] Front disconnecting | connectionId=1 5/17 21:32:46.825 [GlueLogin] Disconnecting from authentication server. 5/17 21:32:47.149 [IBN_BackInterface] Session with Battle.net established. 5/17 21:32:48.969 [IBN_Login] Front disconnected | connectionId=1 | result=( | code=ERROR_OK (0) | localizedMessage= | debugMessage=) 5/17 21:32:48.969 [GlueLogin] Disconnected from authentication server. 5/17 21:33:04.394 [GlueLogin] Explicitly disconnecting from realm server 5/17 21:33:04.452 [IBN_BackInterface] Session with Battle.net destroyed. 5/17 21:33:04.452 [GlueLogin] Disconnected from WoW | previouslyConnected=false 5/17 21:33:12.673 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=192.168.178.192:1119 5/17 21:33:12.673 [GlueLogin] Resetting 5/17 21:33:12.673 [IBN_Login] Destroying | isInitialized=true 5/17 21:33:12.673 [IBN_Login] Initializing 5/17 21:33:12.673 [IBN_Login] Attempting logon | host=192.168.178.192 | port=1119 5/17 21:33:12.673 [GlueLogin] Waiting for server response. 5/17 21:33:13.034 [GlueLogin] Waiting for server response. 5/17 21:33:13.034 [GlueLogin] Waiting for server response. 5/17 21:33:13.163 [GlueLogin] Waiting for server response. 5/17 21:33:13.304 [GlueLogin] Waiting for server response. 5/17 21:33:13.314 [GlueLogin] Waiting for server response. 5/17 21:33:13.314 [GlueLogin] Logon complete. 5/17 21:33:13.314 [GlueLogin] Waiting for realm list. 5/17 21:33:13.314 [IBN_Login] Requesting realm list ticket 5/17 21:33:13.334 [IBN_Login] Received realm list ticket | code=ERROR_OK (0) 5/17 21:33:13.334 [GlueLogin] Waiting for realm list. 5/17 21:33:13.345 [IBN_Login] Received sub region list | code=ERROR_OK (0) 5/17 21:33:13.345 [IBN_Login] Requesting last played chars | numSubRegions=1 5/17 21:33:13.345 [GlueLogin] Realm list ready. 5/17 21:33:13.345 [IBN_Login] Joining realm | subRegion=2-1-0 | realmAddress=2-1-1 5/17 21:33:13.559 [IBN_Login] OnRealmJoin | code=ERROR_OK (0) 5/17 21:33:14.031 [GlueLogin] Received AuthedToWoW | result=ERROR_OK (0) 5/17 21:33:14.031 [IBN_Login] Front disconnecting | connectionId=2 5/17 21:33:14.031 [GlueLogin] Disconnecting from authentication server. 5/17 21:33:14.126 [IBN_BackInterface] Session with Battle.net established. 5/17 21:33:14.126 [IBN_Login] Front disconnected | connectionId=2 | result=( | code=ERROR_OK (0) | localizedMessage= | debugMessage=) 5/17 21:33:14.126 [GlueLogin] Disconnected from authentication server. 5/17 21:33:17.167 [GlueLogin] Explicitly disconnecting from realm server 5/17 21:33:17.478 [IBN_BackInterface] Session with Battle.net destroyed. 5/17 21:33:17.478 [GlueLogin] Disconnected from WoW | previouslyConnected=false 5/17 21:33:18.414 [IBN_Login] Destroying | isInitialized=true 5/17 21:33:18.930 [IBN_Login] Shutting down
  24. Step 2: Disable the firewall on the router. Guess what: I can login to the server!
  25. New steps: Step1: Changing the ipaddress in config.wtf on the client from 127.0.0.1 to my local ip 192.168.178.192 on port 1119 didn't do the trick. I've also disabled my firewall, antivirus and windows defender to make sure nothing is possibly blocking anything. The battlenet.log came up with this: 5/17 18:53:12.178 [IBN_Login] Starting up | hasFrontInterface=false | hasBackInterface=false 5/17 18:56:12.331 [GlueLogin] Starting login | launcherPortal=nullopt | loginPortal=192.168.178.192:1119 5/17 18:56:12.331 [GlueLogin] Resetting 5/17 18:56:12.331 [IBN_Login] Initializing 5/17 18:56:12.331 [IBN_Login] Attempting logon | host=192.168.178.192 | port=1119 5/17 18:56:12.331 [GlueLogin] Waiting for server response. 5/17 18:56:12.427 [GlueLogin] Waiting for server response. 5/17 18:56:12.427 [GlueLogin] Waiting for server response. 5/17 18:56:12.579 [GlueLogin] Waiting for server response. 5/17 18:56:12.724 [GlueLogin] Waiting for server response. 5/17 18:56:12.734 [GlueLogin] Waiting for server response. 5/17 18:56:12.734 [GlueLogin] Logon complete. 5/17 18:56:12.734 [GlueLogin] Waiting for realm list. 5/17 18:56:12.734 [IBN_Login] Requesting realm list ticket 5/17 18:56:12.754 [IBN_Login] Received realm list ticket | code=ERROR_OK (0) 5/17 18:56:12.754 [GlueLogin] Waiting for realm list. 5/17 18:56:12.764 [IBN_Login] Received sub region list | code=ERROR_OK (0) 5/17 18:56:12.764 [IBN_Login] Requesting last played chars | numSubRegions=1 5/17 18:56:12.764 [GlueLogin] Realm list ready. 5/17 18:56:12.764 [IBN_Login] Joining realm | subRegion=2-1-0 | realmAddress=2-1-1 5/17 18:56:12.958 [IBN_Login] OnRealmJoin | code=ERROR_OK (0) 5/17 18:56:32.153 [GlueLogin] Explicitly disconnecting from realm server 5/17 18:56:32.153 [IBN_Login] Front disconnecting | connectionId=1 5/17 18:56:32.153 [GlueLogin] Disconnecting from authentication server. 5/17 18:56:32.312 [IBN_BackInterface] Session with Battle.net destroyed. 5/17 18:56:32.312 [GlueLogin] Disconnected from WoW | previouslyConnected=false 5/17 18:56:32.312 [IBN_Login] Front disconnected | connectionId=1 | result=( | code=ERROR_OK (0) | localizedMessage= | debugMessage=) 5/17 18:56:32.312 [GlueLogin] Disconnected from authentication server. 5/17 18:56:32.312 [IBN_Login] Destroying | isInitialized=true 5/17 18:56:33.689 [IBN_Login] Destroying | isInitialized=false 5/17 18:56:34.825 [IBN_Login] Shutting down
×
×
  • Create New...