[Mangos] 2.0.12-2.1.0 Silvermoon Database rev 5 Newest
http://i81.photobucket.com/albums/j2...rmooncopie.jpg
We proudly present you the new Project Silvermoon Database Revision 5, compatible with the official mangos core
(
MaNGoS rev 3642+(Higher), ScriptDev2 44 i recommend this)
MaNGOS rev.3653 + ScriptDev2 rev.44 + Restarter + SQL Fixes + Tools
Mangos-GUI
Download CORE
Note:
This is a complete database, not an update, it's smaller than the
previous releases because I cleaned up many items and spawns.
Project Silvermoon Database rev 5
File size: 8.21 MB | File name: PS_mangos_rev5.rar
-Mirror-
What's new?
- Updated to SDB Changeset 186
- Black Temple 1/3 spawned
- Tempest Keep: The Eye fully spawned
- Random Hyjal spawns removed (normal hyjal, not Old Hyjal)
- All random items and duplicate tiersets removed (1200 items)
- GM Island Vendors redone, they have the real items now
- The Botanica fully spawned
- The Mechanar 1/2 spawned
- Shadowmoon Valley cleaned up and blizzified
- Many little fixes from the forum added
- Many quests fixed
- Mining in Outland fixed (veins spawned and loot added)
- Adamantite/Khorium veins will come in rev 6
- Many other little things have been added also, I dont remember them anymore atm
Enjoy!
Silvermoon Community!!
http://i81.photobucket.com/albums/j2...rmooncopie.jpg
Re: Project Silvermoon Database Release (15-05-07 )
[FIX] Pet fix!!!, Fixes them all
This fixes all pets and it also fixes creatures that should use spells and already have them in the creature_template,
but had no script name, so they weren't using them
Tested it and it works
First one affects around 15000 rows, 2nd only 90 rows
PHP Code:
UPDATE `creature_template` SET `ScriptName` = '' WHERE `spell1` = 0 and `spell2` = 0 and `spell3` = 0 and `spell4` = 0 and `ScriptName` = 'generic_creature';
UPDATE `creature_template` SET `ScriptName` = 'generic_creature' WHERE `ScriptName` = '' AND `spell1` > 0 OR `spell2` > 0 OR `spell3` > 0 OR `spell4` > 0;
[FIX]Shadowmoon(Valley),Area52, Factions,Wrong Spawn corrections,double spawn delete
These fixes are Blizzlike,
PHP Code:
-- Updated faction of NPCs in Area52 and in Wildhammer "Camp" in Shadowmoon--
update `creature_template` set `faction`='35' where `entry` in ('19572','20484','20485','19621','19541','21751','19645','19570','19737','19575','19576','19709','19574','21733','21732','19610','19612','20389','19776','19217','19571','19617','19780','19623','17636','19573','21493');
update `creature_template` set `faction`='84' where `entry` in ('21357','21775','22042','21774','19353','19384');
update `creature_template` set `faction`='1730' where `entry`='19880';
update `creature_template` set `faction`='1743' where `entry`='19651';
update `creature_template` set `faction`='1819' where `entry`='18939';
update `creature_template` set `faction`='83' where `entry`='19348';
-- Double Spawned Mobs in Shadowmoon(valley)--
delete from `creature` where `guid`='1008012';
delete from `creature` where `guid`='1007530';
delete from `creature` where `guid`='1002805';
delete from `creature` where `guid`='1008017';
delete from `creature` where `guid`='1002259';
delete from `creature` where `guid`='1002260';
delete from `creature` where `guid`='1003015';
delete from `creature` where `guid`='1003016';
delete from `creature` where `guid`='1006468';
delete from `creature` where `guid`='1002250';
delete from `creature` where `guid`='1002671';
delete from `creature` where `guid`='1002672';
delete from `creature` where `guid`='1002673';
delete from `creature` where `guid`='994274';
delete from `creature` where `guid`='994276';
delete from `creature` where `guid`='1003126';
-- Set the right NPC to Wildhammer-Gryphonmaster in SHadowmoonvalley--
update `creature` set `id`='18939' where `guid`='100091';
-- Updates Positions from NPCs in Shadowmoon--
update `creature` set `position_x`='-2908.827393',`position_y`='2604.721924',`position_z`='93.680420',`orientation`='2.596586',`spawn_position_x`='-2908.827393',`spawn_position_y`='2604.721924',`spawn_position_z`='93.680420' where `guid`='1008016';
update `creature` set `position_x`='-2962.977051',`position_y`='2579.370117',`position_z`='76.551186',`orientation`='5.330778',`spawn_position_x`='-2962.977051',`spawn_position_y`='2579.370117',`spawn_position_z`='76.551186' where `guid`='1003121';
update `creature` set `position_x`='-3058.283203',`position_y`='2492.196533',`position_z`='64.849548',`orientation`='4.531086',`spawn_position_x`='-3058.283203',`spawn_position_y`='2492.196533',`spawn_position_z`='64.849548' where `guid`='198146';
update `creature` set `position_x`='-3064.840576',`position_y`='2494.014648',`position_z`='64.887796',`orientation`='4.649221',`spawn_position_x`='-3064.840576',`spawn_position_y`='2494.014648',`spawn_position_z`='64.887796' where `guid`='198147';
update `creature` set `position_x`='-3081.841064',`position_y`='2555.146240',`position_z`='62.503899',`orientation`='5.459082',`spawn_position_x`='-3081.841064',`spawn_position_y`='2555.146240',`spawn_position_z`='62.503899' where `guid`='1007769';
-- Spawn missing Mobs to Shadowmoon
insert into `creature` (`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) values
('19348','530','-2939.666504','2674.221436','93.680374','4.278004','180','0','0','-2939.666504','2674.221436','93.680374','0','5500','0','0','0',''),
('19343','530','-2904.398682','2615.286133','93.680321','2.968785','180','0','0','-2904.398682','2615.286133','93.680321','0','280','0','0','0',''),
('21938','530','-2922.713623','2658.084473','94.531281','0.085623','180','0','0','-2922.713623','2658.084473','94.531281','0','7100','2845','0','0',''),
('19362','530','-2927.071533','2643.334229','93.671555','3.872934','180','0','0','-2927.071533','2643.334229','93.671555','0','15000','0','0','0',''),
('19362','530','-2933.476807','2650.958740','93.677849','3.930398','180','0','0','-2933.476807','2650.958740','93.677849','0','15000','0','0','0','');
-- Set right Position of the Wanted Poster in Shadowmoon--
update `gameobject` set `position_x`='-3075.765137',`position_y`='2551.401855',`position_z`='63.506729',`orientation`='3.593143' where `guid`='908824';
-- Update Subnames from NPS's in Area52--
update `creature_template` set `subname`='B.O.O.M. Fire Marshal' where `entry`='19621';
update `creature_template` set `subname`='B.O.O.M. Jr. Mech Tech' where `entry`='21751';
update `creature_template` set `subname`='B.O.O.M. Commander' where `entry`='19570';
update `creature_template` set `subname`='B.O.O.M. Master Mixologist' where `entry`='19617';
update `creature_template` set `subname`='B.O.O.M. Engineering' where `entry`='19780';
update `creature_template` set `subname`='B.O.O.M.' where `entry`='19623';
-- Set right faction toCrusader Lord Valdelmar and Abbendis--
update `creature_template` set `faction`='14' where `entry` in ('11898','10828');
-- Delete the Npc's from Orgrimmar and Stormwind, who sell Honor Items outside the Hall of Legends(champions)-
DELETE FROM `creature` WHERE `guid` = '40699';
DELETE FROM `creature` WHERE `guid` = '40683';
DELETE FROM `creature` WHERE `guid` = '40662';
DELETE FROM `creature` WHERE `guid` = '40642';
DELETE FROM `creature` WHERE `guid` = '40658';
DELETE FROM `creature` WHERE `guid` = '6449';
update `creature` set `position_x`='-9181.521484',`position_y`='310.732056',`position_z`='78.976295',`orientation`='1.443141',`spawn_position_x`='-9181.521484',`spawn_position_y`='310.732056',`spawn_position_z`='78.976295',`spawn_orientation`='1.443141' where `guid`='5840';
DELETE FROM `creature` WHERE `id` = '17804';
INSERT INTO `creature` (`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
('17804','0','-9041.9','434.422','93.296','2.31631','25','0','0','-9041.9','434.422','93.296','0','2100','0','0','1','');
DELETE FROM `creature` WHERE `id` = '4959';
INSERT INTO `creature` (`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`auras`) VALUES
('4959','0','-8981.6','397.414','75.8937','0.832968','25','0','0','-8981.6','397.414','75.8937','0','644','0','0','0','');
Patches added to the Silvermoon Database -mob FIX
This will remove allmost all the demons around the darkportal in Eastern Kingdoms.
SQL
PHP Code:
DELETE FROM creature WHERE guid in (989,984,985,993,1033,1008,1074,1012538,1042,
1036,1034,1017,1012542,975,1012541,983,1000,1012540,1033,1038,1044,1012539,1074,
1012538,106,
1042,1073,1040,1034,1017,930,932,959,954,928,929,1140,1129);
Earthbinder Tavgren and his kodo
hi was spawned in rev3 but i couldent find him in rev4 nor rev5 so i respawned him.
SQL
PHP Code:
INSERT INTO creature VALUES (104266706, 18446, 530, -1948.87, 4687.55, -1.96269, 5.94962, 25, 0, 0, -1948.87, 4687.55, -1.96269, 0, 4100, 2620, 0, 0, 'null');
INSERT INTO creature VALUES (104266710, 18492, 530, -1952.2, 4684.68, -1.61996, 5.90048, 25, 0, 0, -1952.2, 4684.68, -1.61996, 0, 300, 0, 0, 1, 'nul');
Isfar
isfar was missing so i spawned him.
Isfar - NPCs - World of Warcraft
SQL
PHP Code:
INSERT INTO creature VALUES (3000571, 18933, 530, -3339.3, 4705, -101.051, 3.55661, 25, 0, 0, -3339.3, 4705, -101.051, 0, 7500, 2933, 0, 1, 'null');
Jenai Starwhisper
she whas missing so i spawned her.
Jenai Starwhisper - NPCs - World of Warcraft
SQL
PHP Code:
INSERT INTO creature VALUES (3000569, 18459, 530, -2925.47, 4005.7, -1.53331, 2.97031, 25, 0, 0, -2925.47, 4005.7, -1.53331, 0, 3400, 0, 0, 0, 'null');
> [Fix] GM Island Vendor, Fixes the ring vendor
The ring vendor crashed the client because it had too many items (like 15 pages),
I splitted them up in 3 now:
SQL
PHP Code:
UPDATE `creature_template` SET `subname` = 'Ring Vendor', `npcflag` = 16388 WHERE `entry` IN (10002000,10002100);
DELETE FROM `npc_vendor` WHERE `entry` = 10001300;
INSERT INTO `npc_vendor` VALUES ('10001300', '32196', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32228', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32229', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23065', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23066', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32216', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32204', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23063', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32249', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23064', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32202', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32227', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23060', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23059', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32195', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23067', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '32230', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '23062', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21204', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21203', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21202', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21201', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21200', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21199', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21198', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21197', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21196', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21190', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '21189', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '20682', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '20632', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '20624', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '20600', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19434', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19432', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19403', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19397', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19384', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19382', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19376', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19325', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19147', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19140', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '19138', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18970', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18879', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18821', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18813', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18543', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10001300', '18403', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '17110', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '17063', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '13143', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '2246', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '1980', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '1447', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '942', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '28790', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29920', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29922', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29997', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30109', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30110', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30083', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30061', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30028', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29302', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31746', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31399', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31398', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31339', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31326', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '31319', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30834', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30738', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30736', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30667', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '30052', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29384', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29379', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29373', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29367', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29352', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29291', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29290', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29289', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29287', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29286', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29285', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29283', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29282', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29281', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29279', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29278', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29277', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29177', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29172', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '29126', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '28763', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002000', '28757', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28753', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28730', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28675', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28661', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28649', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28555', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28553', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '28510', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23237', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23038', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23037', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23031', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23028', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23025', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23018', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '22961', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '22939', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '22722', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '22721', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '22707', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21836', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21709', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21707', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21695', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21687', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21681', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21677', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21620', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21601', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21596', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21563', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21526', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21417', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21414', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21411', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21408', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21405', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21402', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21399', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21396', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21393', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21210', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21209', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21208', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21207', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21206', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '21205', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '23061', '0', '0');
INSERT INTO `npc_vendor` VALUES ('10002100', '32223', '0', '0');
Re: Project Silvermoon Database Release (15-05-07 )
Some small boss fixes.
Most of the data taken from wowhead. stuff like money drop is screwed up on wowhead, therefore some normalization.
Have Fun.
P.S: Please check AQ40 for money drops. Most of it is screwed up because of wowhead rips.
Some non-elite mobs with only 6k-7k hp had like 200g drops. #1 exploit area..
-- Princess Yauj
PHP Code:
UPDATE creature_template SET minhealth='330000', maxhealth='330000', armor='1700', flag1='50', resistance3='4656', mingold='12566', maxgold='13456', ScriptName='' WHERE entry = '15543';
-- Lord Kri
PHP Code:
UPDATE creature_template SET minhealth='280000', maxhealth='280000', minmana='0', maxmana='0', armor='2000', resistance3='4555', mingold='5600', maxgold='13400', ScriptName='' WHERE entry = '15511';
-- Vem
PHP Code:
UPDATE creature_template SET minhealth='420000', maxhealth='420000', armor='1500', resistance3='1000', maxgold='12000', ScriptName='' WHERE entry = '15544';
[FIX] The Eye trash mobs, Last 3 mobs with data completed.
Phoenix-HawkSQL
PHP Code:
DELETE FROM `creature_loot_template` WHERE `entry` IN (20039);
INSERT INTO `creature_loot_template`
(`entry`,`item`,`ChanceOrRef`,`QuestChanceOrGroup`,`mincount`,`maxcount`,`quest_freeforall`)
VALUES
('20039','25426','67.4','0','3','4','1'),
('20039','25428','20.8','0','1','2','1'),
('20039','30029','2.1','0','1','1','1'),
('20039','30020','2.1','0','1','1','1'),
('20039','24692','1.4','0','1','1','1'),
('20039','30026','0.7','0','1','1','1'),
('20039','31837','0.7','0','1','1','1'),
('20039','25057','0.7','0','1','1','1'),
('20039','24679','0.7','0','1','1','1'),
('20039','25099','0.7','0','1','1','1'),
('20039','24915','0.7','0','1','1','1'),
('20039','25019','0.7','0','1','1','1'),
('20039','24905','0.7','0','1','1','1'),
('20039','25375','0.7','0','1','1','1'),
('20039','25380','0.7','0','1','1','1'),
('20039','25361','0.7','0','1','1','1'),
('20039','25391','0.7','0','1','1','1'),
('20039','25393','0.7','0','1','1','1'),
('20039','25398','0.7','0','1','1','1');
Phoenix-Hawk Hatchling
PHP Code:
DELETE FROM `creature_loot_template` WHERE `entry` IN (20038);
INSERT INTO `creature_loot_template`
(`entry`,`item`,`ChanceOrRef`,`QuestChanceOrGroup`,`mincount`,`maxcount`,`quest_freeforall`)
VALUES
('20038','25426','81.0','0','3','4','1'),
('20038','25428','14.9','0','1','2','1'),
('20038','25308','1.5','0','1','1','1'),
('20038','25294','1.0','0','1','1','1'),
('20038','25322','1.0','0','1','1','1'),
('20038','25344','1.0','0','1','1','1'),
('20038','29549','0.5','0','1','1','1'),
('20038','24972','0.5','0','1','1','1'),
('20038','25124','0.5','0','1','1','1'),
('20038','25015','0.5','0','1','1','1'),
('20038','24892','0.5','0','1','1','1'),
('20038','24895','0.5','0','1','1','1'),
('20038','24907','0.5','0','1','1','1'),
('20038','25098','0.5','0','1','1','1'),
('20038','25401','0.5','0','1','1','1'),
('20038','25357','0.5','0','1','1','1'),
('20038','25358','0.5','0','1','1','1'),
('20038','25361','0.5','0','1','1','1'),
('20038','25399','0.5','0','1','1','1'),
('20038','25396','0.5','0','1','1','1'),
('20038','25347','0.5','0','1','1','1'),
('20038','25397','0.5','0','1','1','1'),
('20038','25405','0.5','0','1','1','1'),
('20038','25398','0.5','0','1','1','1');
Tempest-Smith
PHP Code:
DELETE FROM `creature_loot_template` WHERE `entry` IN (20042);
INSERT INTO `creature_loot_template`
(`entry`,`item`,`ChanceOrRef`,`QuestChanceOrGroup`,`mincount`,`maxcount`,`quest_freeforall`)
VALUES
('20042','21877','25.7','0','2','3','1'),
('20042','27855','7.1','0','1','1','1'),
('20042','30030','5.7','0','1','1','1'),
('20042','25380','2.9','0','1','1','1'),
('20042','30029','1.4','0','1','1','1'),
('20042','30024','1.4','0','1','1','1'),
('20042','31308','1.4','0','1','1','1'),
('20042','24681','1.4','0','1','1','1'),
('20042','23077','1.4','0','1','1','1'),
('20042','25195','1.4','0','1','1','1'),
('20042','25018','1.4','0','1','1','1'),
('20042','25337','1.4','0','1','1','1'),
('20042','25223','1.4','0','1','1','1'),
('20042','25357','1.4','0','1','1','1'),
('20042','25341','1.4','0','1','1','1'),
('20042','25398','1.4','0','1','1','1');
All mobs with data for 'The Eye' completed.
Re: Project Silvermoon Database Release (15-05-07 )
I downloaded this.. With the recommended Mangos... And it works great.. Really cool job overall... But my players get disconnected... I dont know why... And when they relog... Their chars are bugged.. And the game freezes at the end of the loeading screen... :(..
Anyone had the same problem and were able to fix it?
Phoenixdk
Re: Project Silvermoon Database Release (15-05-07 )
Only time Ive run into that issue was a Kara run where one of my charactors crashed to desktop after hitting C to open the charactor profile. I dont know why but I was unable to log back in on that charactor as the loading screen would get to full the just do nothing. I dont know if your charactors were in an instance or not but it might be something to look into.
Re: Project Silvermoon Database Release (15-05-07 )
Quote:
Originally Posted by
Phoenixdk
I downloaded this.. With the recommended Mangos... And it works great.. Really cool job overall... But my players get disconnected... I dont know why... And when they relog... Their chars are bugged.. And the game freezes at the end of the loeading screen... :(..
Anyone had the same problem and were able to fix it?
Phoenixdk
Well there can be 1 problem :
[CENTER] 1.You don`t have a good core
- i recommend newest core compiled by
[URL="http://timisoara.ath.cx/silvermoon/index.php?s=&showtopic=2390&view=findpost&p=12995"] Black
Re: Project Silvermoon Database Release (15-05-07 )
You could as well paste and copy the whole silvermoon forums .
Re: Project Silvermoon Database Release (15-05-07 )
Quote:
Originally Posted by
tr4shm4n
You could as well paste and copy the whole silvermoon forums .
Why should i copy all silvermoon forums :technolog . Do you mind somthing about share on ragezone the newest Silvermoon Data base?And Help others in this way because not all peoples know about silvermoon forums .So do you mind that you can see there are banners from silvermoon and it`s named WE THE SILVERMOON COMMUNITY .So why you flame about this ?I made Silvermoon city part by myself and its included in data base by Tim so i`m one of the many who improved this data base you can read again (WE).And yes i want to share it to all peoples
Re: Project Silvermoon Database Release (15-05-07 )
Ofcorse i dont mind was just kidding ;)