[Mangos] 2.0.12-2.1.0 Silvermoon Database rev 5 Newest

inkredibil · May 15, 2007

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

To view the content, you need to sign in or register

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-

To view the content, you need to sign in or register

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!!

New file Realmlist and DBC files updated by C-O-B-R-A working for 2.1 clients

To view the content, you need to sign in or register

davevleugel · May 16, 2007

Re: Project Silvermoon Database Release (15-05-07 )

Thanx, i hope its good !

inkredibil · May 16, 2007

[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:

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;

inkredibil · May 16, 2007

[FIX]Shadowmoon(Valley),Area52, Factions,Wrong Spawn corrections,double spawn delete

These fixes are Blizzlike,

PHP:

-- 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','');

inkredibil · May 16, 2007

Patches added to the Silvermoon Database -mob FIX

This will remove allmost all the demons around the darkportal in Eastern Kingdoms.

SQL

PHP:

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:

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.

To view the content, you need to sign in or register

SQL

PHP:

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.

To view the content, you need to sign in or register

SQL

PHP:

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');

inkredibil · May 16, 2007

> [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:

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');

inkredibil · May 16, 2007

[Fix] drop

PHP:

UPDATE `creature_loot_template` SET `ChanceOrRef`='100' WHERE `entry` IN
('19220', '17942', '17941', '19219', '17991', '19710', '19218', '19221', '17882', '17308', '17770', '17798', '17306', '18105', '17826', '17377', '17797', '17381', '18473', '17796', '16807', '18373', '17380', '18708', '18731', '18472', '18371', '18667', '16808', '18732', '20923', '16809', '17848', '18341', '17879', '17862', '18343', '20912', '20885', '17977', '17976', '20886', '18096', '17301', '18344', '17975', '20870', '17980', '17880', '17978');
UPDATE `creature_loot_template` SET `ChanceOrRef`='18' WHERE `entry`='17881';

Badge of Justice

PHP:

UPDATE `creature_loot_template` SET `QuestChanceOrGroup`=13.3 WHERE `entry`='19701';
UPDATE `creature_loot_template` SET `QuestChanceOrGroup`=12.2 WHERE `entry`='18952';
UPDATE `creature_loot_template` SET `QuestChanceOrGroup`=11.9 WHERE `entry`='16876';
UPDATE `creature_loot_template` SET `QuestChanceOrGroup`=9.9 WHERE `entry`='16925';

To view the content, you need to sign in or register

inkredibil · May 16, 2007

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:

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:

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:

UPDATE creature_template SET minhealth='420000', maxhealth='420000', armor='1500', resistance3='1000', maxgold='12000', ScriptName='' WHERE entry = '15544';

inkredibil · May 16, 2007

[FIX] The Eye trash mobs, Last 3 mobs with data completed.

Phoenix-HawkSQL

PHP:

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:

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:

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.

Phoenixdk · May 16, 2007

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

Asheru · May 16, 2007

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.

inkredibil · May 16, 2007

Re: Project Silvermoon Database Release (15-05-07 )

Phoenixdk said:
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 :

1.You don`t have a good core

- i recommend newest core compiled by

To view the content, you need to sign in or register

tr4shm4n · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

You could as well paste and copy the whole silvermoon forums .

inkredibil · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

tr4shm4n said:
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

tr4shm4n · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

Ofcorse i dont mind was just kidding

barigas · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

i love this server

****

farril1 · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

thanks, loads more complete than the last one i ran.

question though. whats mangos GUI for? i run it and it crashes straight away.

also. mangos has been going a long time now, why havnt the stable masters been fixed yet? surely its a simple fix to add the right mount items.

edit: fixed the gui problem, on vista so had to allow it access. still querying the stable master bug though.

MightyX · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

Some links are broken, fix and you got my thanks!

inkredibil · May 17, 2007

Re: Project Silvermoon Database Release (15-05-07 )

farril1 said:
thanks, loads more complete than the last one i ran.

question though. whats mangos GUI for? i run it and it crashes straight away.

also. mangos has been going a long time now, why havnt the stable masters been fixed yet? surely its a simple fix to add the right mount items.

edit: fixed the gui problem, on vista so had to allow it access. still querying the stable master bug though.

Did you run the Updates from Black core? because it has a folder inside with all need it updates .
Tell me if helped you

MightyX said:
Some links are broken, fix and you got my thanks!

Can you tell which of links are broken for update them !

inkredibil · May 18, 2007

Rogue Tier 5 patch for Silvermoon rev 5 DB

Rogue Tier 5. got from wowhead, updated stats.

few other things need to be fixed. like the sockets. but i dont know socket colors and bonus and stuff like that
Also remember to clear the cache otherwise the stats wont update for the client

I know these are test server stats. but just getting a head start on the sql updates for it.. i dont expect it to get into silvermoons database till you guys are ready for it

SQL

PHP:

UPDATE item_template SET stat_value1='33', stat_value2='57', stat_type3='32', stat_value3='17', armor='419', spellid_1='29524' WHERE entry='30144';
UPDATE item_template SET stat_value1='36', stat_value2='34', stat_value3='24', armor='262', spellid_1='15820' WHERE entry='30145';
UPDATE item_template SET stat_value1='39', stat_value2='48', stat_value3='25', armor='341', spellid_1='15825' WHERE entry='30146';
UPDATE item_template SET stat_value1='47', stat_value3='26', armor='367', spellid_1='15829' WHERE entry='30148';
UPDATE item_template SET stat_value1='34', stat_value2='37', stat_type3='32', stat_value3='13', armor='314', spellid_1='15813' WHERE entry='30149';

Thanx to silvermoon community for thix fix

[Mangos] 2.0.12-2.1.0 Silvermoon Database rev 5 Newest

Junior Spellweaver

Experienced Elementalist

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Mythic Archon

Junior Spellweaver

Mythic Archon

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners