08-26-2015, 02:06 PM
I'm trying to get rid of minigob, and or manabonk, so when people are sitting in dalaran that stupid little mage doesnt sheep people or at least stop the item from being sent to players after it happens.
08-26-2015, 04:34 PM
You could change the ID if the item then after the effect occurred it wouldn't know what item to give the player. However that might end up with some issues, same goes with the spell. Try changing the spell Id that might solve your issue.
08-28-2015, 04:27 PM
thanks for the tip. that would work, but would cause errors on startup and cast. i try to avoid that if possible, but this may be the only option
08-28-2015, 05:07 PM
Easiest way that shouldnt cause errors (not tested):
DELETE FROM creature WHERE id = 32838;
do make a backup.
This SQL should only delete one row, which is here if you want it back:
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (44457, 32838, 571, 0, 0, 1, 1, 0, 0, 5877.88, 662.895, 644.53, 1.66366, 300, 0, 0, 1, 0, 0, 0, 0, 0, 0);
09-01-2015, 04:05 PM
thanks rochet2. i have stored both those. sometimes i forget how simple things can be...
on a side note what i did was change the chance of receiving the item in the mail to almost noting. that way its not a pain in the ass, and that way everything still works more or less as its supposed to.
Powered by vBulletin® Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.