MDK Posted July 14, 2017 Report Share Posted July 14, 2017 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? Link to comment Share on other sites More sharing options...
CDawg Posted July 18, 2017 Report Share Posted July 18, 2017 Is it the right gameobject? Are the flags correct on the gameobject? https://trinitycore.atlassian.net/wiki/display/tc/gameobject_template#gameobject_template-data0-23 Are you working on 3.3.5a or 7.x? Link to comment Share on other sites More sharing options...
MDK Posted July 19, 2017 Author Report Share Posted July 19, 2017 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? Link to comment Share on other sites More sharing options...
CDawg Posted July 19, 2017 Report Share Posted July 19, 2017 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. 1 Link to comment Share on other sites More sharing options...
MDK Posted July 20, 2017 Author Report Share Posted July 20, 2017 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? Link to comment Share on other sites More sharing options...
CDawg Posted July 20, 2017 Report Share Posted July 20, 2017 I would only clear the cache from client if you don't see the changes in world once you made them on the server. Link to comment Share on other sites More sharing options...
MDK Posted July 21, 2017 Author Report Share Posted July 21, 2017 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. Link to comment Share on other sites More sharing options...
codeman3518 Posted July 23, 2017 Report Share Posted July 23, 2017 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. 1 Link to comment Share on other sites More sharing options...
MDK Posted July 24, 2017 Author Report Share Posted July 24, 2017 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) Link to comment Share on other sites More sharing options...
gpn39f Posted July 24, 2017 Report Share Posted July 24, 2017 i notized that gameobjects type 3 = chest has data 0-32 in client 7.xx in description are both data1 and data30 involved in loot. from wpp the needed quest_loot is stored to data30 but our core need quest_loot in Data1.. so the gameobject is not "glitter" and is not "clickable" : quest can't be done.. is this a failure from wpp or a failure from core???? Link to comment Share on other sites More sharing options...
AussieGuy Posted July 24, 2017 Report Share Posted July 24, 2017 Hi, The Data1 field should contain the "Entry" value in the table gameobject_loot_template I do not see you mention this table, it needs to have a valid entry. Thanks, Glenn Link to comment Share on other sites More sharing options...
gpn39f Posted July 24, 2017 Report Share Posted July 24, 2017 @AussieGuy if you look at trinity wiki.. yes you have correct.. but as demo: look at gameobject 32 : https://www.wow-private server linkin is forbidden.com/object_finder.php?object=32 you see: loot should be Oslow's Toolbox = item 1309 in T725_world.gameobject_template you find in data1 an value of 1683 in T725_world.gameobject_loot_template for entry 1683 you find loot 1309.. so wiki description and content of the table are not valid.. (and if you search more.. if wpp fill data to data30 and data1 is then set to 0.. all this quest are broken.. ) Link to comment Share on other sites More sharing options...
AussieGuy Posted July 25, 2017 Report Share Posted July 25, 2017 Hi, It seems to work fine for my custom quests. Without all relevant tables including quest_* then I cannot see a way to help you further. Thanks, Glenn Link to comment Share on other sites More sharing options...
MDK Posted July 25, 2017 Author Report Share Posted July 25, 2017 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. Link to comment Share on other sites More sharing options...
codeman3518 Posted July 26, 2017 Report Share Posted July 26, 2017 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. 2 Link to comment Share on other sites More sharing options...
Daniel25 Posted July 26, 2017 Report Share Posted July 26, 2017 On 14/7/2017 at 3:35 PM, MDK said: 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? For reading books in gameobject_template: - that gameobjects are type=10 - for showing the tooltip iconname='inspect' -for showing the text data19=1 On 21/7/2017 at 7:22 PM, MDK said: 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. For gameobjects type 3 giving quest loot: - in gameobject_template, data1=lootid (if its 0 you can use the gameobjectid) -in gameobject_loot_template, entry=data1 - in gameobject_loot_template for items objectives of a quest, QuestRequired=1 And the gameobject should to give the quest item. The issue that you mentioned maybe happens because one of the chest drops normal items and quest items and the other one only drops quest items. So the chest which drops only quest items doesnt show the loot tooltip if you havent taken the quest. If this isnt the case so surely its because trinity has changed the way to add quest items in database and the most of them are broken. Before quest items in loot were added in db writting negative chance in the loot_template table. You have to use the new field named questrequired in loot_template table now for adding the quest items in loot. Link to comment Share on other sites More sharing options...
MDK Posted July 28, 2017 Author Report Share Posted July 28, 2017 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? Link to comment Share on other sites More sharing options...
Daniel25 Posted July 30, 2017 Report Share Posted July 30, 2017 If it didnt work the way that i told you, so surely the questid in that gameobject is wrong in gameobject_template. You should to check that. Everything works good for me. Link to comment Share on other sites More sharing options...
MDK Posted July 31, 2017 Author Report Share Posted July 31, 2017 Data8 column in gameobject_template (which points to completed questid) has value 0. Do you suggest to populate that with the questid? Link to comment Share on other sites More sharing options...
codeman3518 Posted August 3, 2017 Report Share Posted August 3, 2017 Have you tried switching the data over to that field because I think I might know why it is not working for you could you take screen shots and send them to me because I would really like to figure out why this is not working for you. Be careful using navicat because it is not something trinitycore wants users using when it comes to statements and running queries because the way it handles that data sometimes and formats. 1 Link to comment Share on other sites More sharing options...
MDK Posted August 3, 2017 Author Report Share Posted August 3, 2017 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? 1 Link to comment Share on other sites More sharing options...
CDawg Posted August 3, 2017 Report Share Posted August 3, 2017 19 minutes ago, MDK said: I'm not using Navicat anymore. Switched over to Mysql Workbench Thumbs up! Link to comment Share on other sites More sharing options...
codeman3518 Posted August 4, 2017 Report Share Posted August 4, 2017 Can you send me your SQL query for the item for both tables I am going to edit the item myself and see where it is not allowing you to be clickable. As soon as you get me the SQL query I am going to write a script that will allow this to be clickable when you are on the quest only. Link to comment Share on other sites More sharing options...
MDK Posted August 4, 2017 Author Report Share Posted August 4, 2017 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 Link to comment Share on other sites More sharing options...
codeman3518 Posted August 4, 2017 Report Share Posted August 4, 2017 okay cool thanks I will do that as soon as I compile another updated server, I try to compile a server every week if not sooner depending on the changes made. It gets crazy since I use all the servers, 3.3.5a, 4.3.4 and 7.2.5 Link to comment Share on other sites More sharing options...
Recommended Posts