Jump to content

splinecl

Members
  • Content Count

    13
  • Donations

    0.00 GBP 
  • Joined

  • Last visited

Community Reputation

0 Neutral

About splinecl

  • Rank
    Member

Core Infomation

  • Core
    Zero

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I am having issues completing the quest "CLUCK!". select * from mangos0.quest_template q where q.entry=3861; It is being triggered by emoting "/chicken" repeatedly at chickens in Westfall. At some point the chicken becomes a quest giver. To complete the quest "CLUCK!" you need to have "Special Chicken Feed" in your inventory, which can be bought from "Farmer Saldean" in Westfall. select * from mangos0.item_template i where i.entry=11109; But for some reason it is not possible to complete the quest, even with the correct items in your inventory. I have attached a screenshot shoving the quest dialog and the item in the inventory.
  2. I have made the following local workaround. delete from mangos0.db_scripts where script_guid in (1403,1798); These scripts remove and add the UNIT_NPC_FLAG_GOSSIP and UNIT_NPC_FLAG_QUESTGIVER from "Hegnar Rumbleshot". This makes it possible to complete the quest without having to wait for all the mortar team scripts to complete. I still think the triggers for the mortar team are wrong, but can not figure out how to make it trigger from completing the quest. So this is the only workaround I have been able to come out with for now.
  3. Shouldn't the script select * from db_scripts where id=1061003; Be triggered by the end of the quest "Ammo for Rumbleshot"? SELECT * FROM mangos0.quest_template where entry=5541; And not start playing just because players are near?
  4. It looks like the script controlling the group of dwarves around "Hegnar Rumbleshot" is interfering with the CMSG_QUESTGIVER_STATUS_QUERY message. As soon as the scripted event with the mortar crew ends, then the CMSG_QUESTGIVER_STATUS_QUERY opcode is received and handled. This also fits with what the log shows. 2018-10-11 22:09:24 DB-SCRIPTS: Process table `db_scripts [type = 3]` id 1061003, command 29 for source Creature (Entry: 10610 Guid: 269) (in world), target Creature (Entry: 10610 Guid: 269) (in world) 2018-10-11 22:09:24 WORLD: Received opcode CMSG_QUESTGIVER_STATUS_QUERY - for Player Oldtoxo (Guid: 8) to Creature (Entry: 1243 Guid: 265) 2018-10-11 22:09:24 WORLD: Sent SMSG_QUESTGIVER_STATUS for Creature (Entry: 1243 Guid: 265) 2018-10-11 22:09:35 Respawning... 2018-10-11 22:09:35 Creature (Entry: 721 Guid: 3611) enters grid[20,31] Here you can see the script 1061003 ends with command 29 right before CMSG_QUESTGIVER_STATUS_QUERY is handled.
  5. When trying to turn in the quest "Ammo for Rumbleshot" it took a very long time, over a minute, of me standing around next to the quest turn in NPC "Hegnar Rumbleshot", before the golden quest "?" icon appeared over his head and I could turn in the quest. In the server log I saw this message at the time where I could finally turn in the quest: WORLD: Received opcode CMSG_QUESTGIVER_STATUS_QUERY - for Player Rune (Guid: 6) to Creature (Entry: 1243 Guid: 265) How come this update took so long? If I didn't know that this was actually the correct quest turn in NPC, I would probably just have run past him. Is there any way to tune how often this status query is done? I have attached a screenshot of my standing next to the NPC with the quest and quest item.
  6. There are a bunch of collections of "Water Barrel" and "Food Crate" that spawn on top of each other. I believe the correct behaviour should be spawning as object pools instead. One instance of this issue was fixed in relation to this post: But there are multiple instance of this issue. # guid, id, map, position_x, position_y, position_z '30758', '3719', '0', '-9729.42', '656.299', '31.8338' '29275', '3658', '0', '-9729.42', '656.299', '31.8338' '32313', '3658', '0', '-9500.53', '81.368', '57.4601' '32754', '3719', '0', '-9500.53', '81.368', '57.4601' '30839', '3719', '0', '-9458.53', '8.58518', '56.9626' '30677', '3658', '0', '-9458.53', '8.58518', '56.9626' '30687', '3719', '0', '-9258.88', '355.379', '76.693' '29276', '3658', '0', '-9258.88', '355.379', '76.693' '10677', '3719', '0', '-5569.67', '-462.497', '402.397' '1462', '3658', '0', '-5569.67', '-462.497', '402.397' '29306', '3719', '0', '-5470.22', '-636.681', '393.521' '29609', '3658', '0', '-5470.22', '-636.681', '393.521' These can be found with the following query: SELECT go1.guid, go1.id, go1.map, go1.position_x, go1.position_y, go1.position_z FROM mangos0.gameobject go1 JOIN mangos0.gameobject go2 ON (go1.position_x = go2.position_x AND go1.position_y = go2.position_y AND go1.position_z = go2.position_z AND go1.guid <> go2.guid) WHERE go1.id IN (3658 , 3719) AND go2.id IN (3658 , 3719) order by go1.position_x;
  7. I will create a bug and create a script that extracts all the duplicate objects.
  8. By the way, I can see you only fixed the specific example I gave here, but there are many other instances of this issue in the data. So it would probably make sense to have a script that finds and fix them all.
  9. I downgraded my database to MySQL 5.7, as I presume that MySQL 8.0 is not supported yet. But I could not really find any specific MySQL version requirements anywhere.
  10. Very cool, thanks for the quick fix I can confirm that it fixed it.
  11. I see multiple instances of different gameobjects being spawned on top of each other. For example a "Water Barrel" and "Food Create" both spawning at the exact same position. Is this just because there is no way to spawn a random object from a list of possible objects, or is this an actual error? This is one example: SELECT * FROM mangos0.gameobject where guid in(1462,10677); These are next to Tharek Blackstone in Kharanos.
  12. During mangosd startup I noticed the following sql error in the log: 2018-09-23 20:57:23 ERROR:SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL 2018-09-23 20:57:23 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS' at line 1 I am runnig on MySQL 8.0. It seems like the table name "groups" is a reserved word in MySQL 8.0 so the query fails. https://forums.mysql.com/read.php?101,665004,665004 ( 'GROUPS', 'Reserved', 'added in 8.0' ), EDIT: Seeing the a similar issue here: 2018-09-23 20:57:24 Loading Spell Chain Data... 2018-09-23 20:57:24 ERROR:SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain 2018-09-23 20:57:24 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', req_spell FROM spell_chain' at line 1 The word "rank" is also reserved in MySQL 8.0 ( 'RANK', 'Reserved', 'added in 8.0' ), This query seems to work if you use an alias for the table name SELECT spell_id, prev_spell, first_spell, sc.rank, req_spell FROM spell_chain as sc

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...