Chucksta

This now works; obviously fixed at some point.

Just check in-game and these are quests items, and you can only ever have one of those at any one time. In fact, once the quests are complete, you'll never get those items again.

Awesome, nice one, H0zen :-)

[B][COLOR="#FF0000"]There is no BoP issue!!![/COLOR][/B]

When I added an item to my inventory with .additem it does not set the item to soulbound, therefore it allowed it to be auctioned. When you receive the item during normal game play, it is set to soulbound, so all good.

We do still have the issue of certain items with charges not being allowed to be auctioned :(

Seeing as we have had a lot of code synchronization between Zero, One, and Two, I'll now test this auctioning of items with charges...

[B][SIZE=3]ITEM: Goblin Mortar[/SIZE][/B]
[url]http://www.wowhead.com/item=10577/goblin-mortar[/url]
[B]BoE[/B]

ZERO: [B][COLOR="#008000"]Actionable[/COLOR][/B]

ONE: [B][COLOR="#008000"]Actionable[/COLOR][/B]

TWO: [B][COLOR="#008000"]Actionable[/COLOR][/B]

[B][SIZE=3]ITEM: Noggenfogger Elixir[/SIZE][/B]
[url]http://www.wowhead.com/item=8529/noggenfogger-elixir[/url]
[B]BoP[/B]

ZERO: [B][COLOR="#008000"]Actionable[/COLOR][/B]

ONE: [B][COLOR="#008000"]Actionable[/COLOR][/B]

TWO: [B][COLOR="#008000"]Actionable[/COLOR][/B]

[B][SIZE=3]ITEM: Martin Fury[/SIZE][/B]
[url]http://www.wowhead.com/item=17/martin-fury[/url]
[B]BoP[/B]

ZERO: [B][COLOR="#008000"]Actionable[/COLOR][/B]

ONE:[B][COLOR="#FF0000"] Not Actionable[/COLOR][/B] error: "You cannot auction an item with used charges"

TWO:[B][COLOR="#FF0000"] Not Actionable[/COLOR][/B] error: "You cannot auction an item with used charges"

Also, the originally stated item, Amulet of the Moon, still cannot be auctioned on One or Two. The item does not exist on Zero, as it was introduced in patch 2.0.1

[B][COLOR="#FF0000"]From the above we see there is another issue, BoP items can be auctioned on Zero, One and Two![/COLOR][/B] You should not be able to put BoP items up for auction.

Antz has now merged the fix supplied by H0zen, for One.

[B][COLOR="#FF0000"]This fix will also need to be applied to Two[/COLOR][/B]. Obviously, the code in Two will need to be checked, just to be sure.

Assigning this issue to Antz, as requested.

Nice one, H0zen!

Gonna take a look at that now :)

[B]Confirmed![/B]

This problem occurs in any of the lands in One, both Outlands and the Vanilla areas.

Issue is, the effect is not firing (freeze, burn, etc). The trap will vanish once the mob reaches it, but then no boom.

Also, the mob sees the trap and tries to run around it! I don't think that is how it should work.

If you place the trap whilst fighting a mob, so that the mob stands in the trap, nothing happens. The trap will only fire once the mob moves, but then of course it only vanishes.

I'll check Zero...
- Traps tested and working perfectly on Zero

I'll now check Two
- Issue exists on Two


[B][COLOR="#FF0000"]Therefore, hunter traps currently only work correctly on Zero.[/COLOR][/B]

Jail Break tested and works perfectly fine. The record entries in Zero that threw up the errors during start up are not required (possibly from a previous attempt to implement the quest).

That must be grabbing a pre release20 version of the files. It looks like the make_full_WorldDB.sh file that you grabbed has the wrong folder name in the script (wrong case for the first letter of the folder name).

Best to grab either the latest release:

git clone https://github.com/mangoszero/database -b release20

or the one currently being worked on:

git clone https://github.com/mangoszero/database -b develop21

I popped onto TrueWoW, and they do not have any creatures of any kind in the stated area, but on Wohead they show that those spiders were spotted in the area. Very odd!

I checked a number of other items with charges and they all came up with the same error "[COLOR="#B22222"]You cannot auction an item with used charges[/COLOR]"

It looks like this is occurring due to the client seeing the item as not being legit, such as duped items.

[B]see:[/B]

[url]http://www.mmo-champion.com/threads/1302809-quot-cannot-auction-item-with-used-charges-quot?p=21239236[/url]

in retail, they solved this by having a GM delete and recreate the item:

[url]http://us.battle.net/wow/en/forum/topic/1660216756[/url]
[url]http://us.battle.net/wow/en/forum/topic/8197739998[/url]

I guess it must be the database entry that needs to be looked at for the item. Maybe a discrepancy between the database entry and the DBC entry ?

It looks like this may have been fixed already. If not then we need for info on this one, which trainers and where exactly?

I visited the trainers (professions) in Hellfire (Honor Hold and Thralmar) and Shattrath, and they were able to train my toons.

It looks like Greater Spiderweb spiders are missing east of the road that takes you to Eastern Plaguelands:

[url]http://www.wowhead.com/npc=16352/greater-spindleweb[/url]

If so, then this issue exists on both One and Two.

Can someone else confirm this, please :)

This issue exists on both One and Two.

[B][COLOR="#008000"][SIZE=3]FIX:[/SIZE][/COLOR][/B]

[COLOR="#0000FF"][B]UPDATE creature_ai_texts SET content_default='You\'ve found a cure! We will crush our enemies!' WHERE entry='-744';[/B][/COLOR]

[B][COLOR="#008000"]PR and merged[/COLOR][/B]

[B]ONE[/B]
[url]https://github.com/mangosone/database/pull/17[/url]

[B]TWO[/B]
[url]https://github.com/mangostwo/database/pull/31[/url]

Two did not have the PrevQuestId set to 5261

This was found after installing Two (Develop21 branch) from scratch, along with a number of other issues.

I have PR'd and merged the fix :-)

[B][COLOR="#008000"][SIZE=3]Fix has now been PR'd:[/SIZE][/COLOR][/B]

[url]https://github.com/mangostwo/server/pull/109[/url]

I'll close this thread once the above has been merged with the core :)

Changing the following solved that problem:

LockedQueue.h
#include "Errors.h"

to

#include "Utilities/Errors.h"

This is how it appears in other files.

Problem has now shown up in DatabaseEnv.h:30:20
Errors.h: No such file or directory

----------------------------------------
FIXED and now working on Linux :-)

Altered the following files and paths:

[B]LockedQueue.h[/B]
#include "Utilities/Errors.h"

[B]DatabaseEnv.h[/B]
#include "Utilities/Errors.h"

[B]QueryResultMysql.cpp[/B]
#include "Utilities/Errors.h"

[B]PosixDaemon.h[/B]
#include "Common/Common.h"
#include "Log/Log.h"

I now need to make sure it will still build under VS.

VS likes the changes :)

----------------------------------

I'll now get these changes okeyed, before I PR it.

[B][SIZE=3][COLOR="#FF0000"]Issue still exists[/COLOR][/SIZE][/B]

I tested in-game and was unable to put the item in auction.

It says "You cannot auction an item with used charges"

Tested this on MaNGOS One and the issue occurs there too.

[B][COLOR="#FF0000"]You cannot auction this item on One or Two.[/COLOR][/B]

[B][COLOR="#00FF00"]Works perfectly fine on Zero[/COLOR][/B]

At this point in time, there are no errors reported in the log files (many were dealt with on a number of occasions).

It looks like this has been fixed since it was raised, as I tested in-game, and everything worked as it should.

Looks like this has been fixed, as I tested it in-game and no crash occurred.

Setting issue to completed.

[B][SIZE=3]***** [COLOR="#008000"]FIX APPLIED[/COLOR] *****[/SIZE][/B]

[url]https://github.com/mangosone/database/pull/16[/url]

This is working on MaNGOS Two. I'll copy the data/settings across to One.


---------------------------------------------------------------------------------------

-- [B]Apothecary Enith[/B] (16208)
-- link gossip
UPDATE creature_template SET GossipMenuId=7182 WHERE Entry=16208;
DELETE FROM gossip_menu WHERE entry = 7182;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7182, 8459, 0, 0);
DELETE FROM gossip_menu_option WHERE menu_id = 7182;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES (7182, 0, 0, '', 1, 1, 7179, 0, 0, 0, 0, 873);
DELETE FROM gossip_menu WHERE entry = 7179;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7179, 8460, 0, 873);

DELETE FROM dbscripts_on_gossip WHERE id = 7179;
INSERT INTO `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
(7179,0,0,0,0,0,0,0,2000005543,0,0,0,0,0,0,0,'Enith chat'),
(7179,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'Enith stand'),
(7179,1,1,6,0,0,0,0,0,0,0,0,0,0,0,0,'Enith emote'),
(7179,5,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'Enith run 1'),
(7179,5,20,2,0,0,0,0,0,0,0,0,0,0,0,0,'Enith run 2'),
(7179,10,8,16208,1,0,0,0,0,0,0,0,0,0,0,0,'Quest credit Enith'),
(7179,0,29,1,2,0,0,0,0,0,0,0,0,0,0,0,'Enith gossip flag remove');

DELETE FROM db_script_string WHERE entry = 2000005543;
INSERT INTO db_script_string (entry, content_default, sound, type, language, emote) VALUES (2000005543, 'Thanks, I should\ve never left Silverpine Forest.', 0, 0, 0, 0);

DELETE FROM gossip_menu_option WHERE menu_id = 7179;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES ('7179', '0', '0', 'A bit ungrateful, aren\'t we? The way out is clear, flee quickly!', '1', '1', '0', '0', '7179', '0', '0', '873');

DELETE FROM creature_movement_template WHERE entry = 16208;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(16208,1,6647.83,-6344.92,9.13345,0,0,0,0,0,0,0,0,0,0,0,0),
(16208,2,6657.92,-6345.96,15.3468,0,0,0,0,0,0,0,0,0,0,0,0),
(16208,3,6661.58,-6342.65,15.4309,0,0,0,0,0,0,0,0,0,0,0,0),
(16208,4,6662.35,-6334.64,20.8803,0,0,0,0,0,0,0,0,0,0,0,0),
(16208,5,6662.63,-6331.85,20.8924,0,0,0,0,0,0,0,0,0,0,0,0),
(16208,6,6645.36,-6330.13,30.263,5000,1,0,0,0,0,0,0,0,3.05496,0,0);

-- make sure the NPC is lying down when it spawns
DELETE FROM creature_template_addon WHERE entry = 16208;
INSERT INTO creature_template_addon (entry, mount, bytes1, b2_0_sheath, b2_1_flags, emote, moveflags) VALUES (16208, 0, 7, 0, 0, 0, 0);


-- [B]Apprentice Varnis[/B] (16206)
-- link gossip
UPDATE creature_template SET GossipMenuId=7185 WHERE Entry=16206;
DELETE FROM gossip_menu WHERE entry = 7185;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7185, 8461, 0, 0);
DELETE FROM gossip_menu_option WHERE menu_id = 7185;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES (7185, 0, 0, '', 1, 1, 7186, 0, 0, 0, 0, 873);
DELETE FROM gossip_menu WHERE entry = 7186;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7186, 8463, 0, 873);

DELETE FROM dbscripts_on_gossip WHERE id = 7186;
INSERT INTO `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
(7186,0,0,0,0,0,0,0,2000005545,0,0,0,0,0,0,0,'Varnis chat'),
(7186,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'Varnis stand'),
(7186,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,'Varnis emote'),
(7186,0,29,1,2,0,0,0,0,0,0,0,0,0,0,0,'Varnis gossip flag remove'),
(7186,5,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'Varnis prepare to run'),
(7186,10,8,16206,1,0,0,0,0,0,0,0,0,0,0,0,'Quest credit Varnis'),
(7186,5,20,2,0,0,0,0,0,0,0,0,0,0,0,0,'Varnis run');

DELETE FROM db_script_string WHERE entry = 2000005545;
INSERT INTO db_script_string (entry, content_default, sound, type, language, emote) VALUES (2000005545, 'Thank you. I thought I was going to die.', 0, 0, 0, 0);

DELETE FROM gossip_menu_option WHERE menu_id= 7186;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES ('7186', '0', '0', 'You\'re free to go now. The way out is safe.', '1', '1', '0', '0', '7186', '0', '0', '873');

DELETE FROM creature_movement_template WHERE entry = 16206;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(16206,1,6436.87,-6633.02,107.432,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,2,6435.63,-6620.86,107.436,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,3,6429.88,-6618.29,108.128,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,4,6426.7,-6614.82,110.159,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,5,6428.75,-6611.21,111.905,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,6,6432.83,-6606.89,112.126,0,0,0,0,0,0,0,0,0,0,0,0),
(16206,7,6431.51,-6597.97,112.113,5000,1,0,0,0,0,0,0,0,1.76377,0,0);

-- make sure the NPC is lying down when it spawns
DELETE FROM creature_template_addon WHERE entry = 16206;
INSERT INTO creature_template_addon (entry, mount, bytes1, b2_0_sheath, b2_1_flags, emote, moveflags) VALUES (16206, 0, 7, 1, 16, 0, 0);


-- [B]Ranger Vedoran[/B] (16209)
-- link gossip
UPDATE creature_template SET GossipMenuId=7177 WHERE Entry=16209;
DELETE FROM gossip_menu WHERE entry = 7177;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7177, 8457, 0, 0);
DELETE FROM gossip_menu_option WHERE menu_id = 7177;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES (7177, 0, 0, '', 1, 1, 7176, 0, 0, 0, 0, 873);
DELETE FROM gossip_menu WHERE entry = 7176;
INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (7176, 8456, 0, 873);

DELETE FROM dbscripts_on_gossip WHERE id = 7176;
INSERT INTO `dbscripts_on_gossip` (`id`, `delay`, `command`, `datalong`, `datalong2`, `buddy_entry`, `search_radius`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
(7176,0,0,0,0,0,0,0,2000005544,0,0,0,0,0,0,0,'Vedoran chat'),
(7176,0,28,0,0,0,0,0,0,0,0,0,0,0,0,0,'Vedoran stand'),
(7176,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,'Vedoran emote'),
(7176,0,29,1,2,0,0,0,0,0,0,0,0,0,0,0,'Vedoran gossip flag remove'),
(7176,5,25,1,0,0,0,0,0,0,0,0,0,0,0,0,'Vedoran prepare to run'),
(7176,10,8,16209,1,0,0,0,0,0,0,0,0,0,0,0,'Quest credit Vedonar'),
(7176,5,20,2,0,0,0,0,0,0,0,0,0,0,0,0,'Vedoran run');

DELETE FROM db_script_string WHERE entry = 2000005544;
INSERT INTO db_script_string (entry, content_default, sound, type, language, emote) VALUES (2000005544, 'You have my thanks!', 0, 0, 0, 0);

DELETE FROM gossip_menu_option WHERE menu_id = 7176;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, action_script_id, box_coded, box_money, condition_id) VALUES ('7176', '0', '0', 'You\'re free to go now. The way out is safe.', '1', '1', '0', '0', '7176', '0', '0', '873');

DELETE FROM creature_movement_template WHERE entry = 16209;
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES
(16209,1,6290.21,-6366.1,78.0195,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,2,6301.65,-6364.06,78.0238,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,3,6305.82,-6360.2,78.0782,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,4,6310.5,-6356.76,80.6154,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,5,6314.06,-6360.67,82.6096,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,6,6317.35,-6365.34,82.7124,0,0,0,0,0,0,0,0,0,0,0,0),
(16209,7,6326.85,-6366.82,82.709,5000,1,0,0,0,0,0,0,0,0,0,0);

-- make sure the NPC is lying down when it spawns
DELETE FROM creature_template_addon WHERE entry = 16209;
INSERT INTO creature_template_addon (entry, mount, bytes1, b2_0_sheath, b2_1_flags, emote, moveflags) VALUES (16209, 0, 7, 1, 16, 0, 0);


-- These conditions are used by all 3 NPCs
DELETE FROM conditions WHERE condition_entry IN (871, 872, 873);
-- quest is not currently completed
INSERT INTO conditions (condition_entry, type, value1, value2) VALUES (871, 9, 9164, 0);
-- item is in inventory
INSERT INTO conditions (condition_entry, type, value1, value2) VALUES (872, 2, 22628, 1);
-- at least of the above conditions is true
INSERT INTO conditions (condition_entry, type, value1, value2) VALUES (873, -2, 871, 872);

All of the above for MaNGOS One has now been PR'd and merged with the database:
[url]https://github.com/mangosone/database/pull/15[/url]



[B][SIZE=3]*********** [COLOR="#FF0000"]ISSUE STILL EXISTS[/COLOR] ***********[/SIZE][/B]

QUEST 9472, Arelion's Mistress NOT COMPLETABLE

This is due to the item, [B]Carinda's Scroll of Retribution[/B] (23693) failing when being used. It always gives the message: "Requires Discreet Location"

[B]note:[/B] works perfectly on MaNGOS Two