[Mangos] 2.0.12-2.1.0 Silvermoon Database rev 5 Newest

Printable View

Show 100 post(s) from this thread on one page

15-05-07
inkredibil

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

http://i81.photobucket.com/albums/j2...wnloadsgh5.jpg

Project Silvermoon Database rev 5

File size: 8.21 MB | File name: PS_mangos_rev5.rar

-Mirror-

Download Data Base

http://i81.photobucket.com/albums/j2...ie/newsfg1.jpg

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

Filebeam - Free Fast File Hosting

http://i81.photobucket.com/albums/j2...rmooncopie.jpg
16-05-07
davevleugel

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

Thanx, i hope its good !
16-05-07
inkredibil

[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;
16-05-07
inkredibil

[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','');
16-05-07
inkredibil

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');
16-05-07
inkredibil

> [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');
16-05-07
inkredibil

[Fix] drop

PHP Code:

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

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

Bonechewer Blood - Items - World of Warcraft
16-05-07
inkredibil

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';
16-05-07
inkredibil

[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.
16-05-07
Phoenixdk

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
16-05-07
Asheru

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.
16-05-07
inkredibil

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
17-05-07
tr4shm4n

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

You could as well paste and copy the whole silvermoon forums .
17-05-07
inkredibil

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
17-05-07
tr4shm4n

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

Ofcorse i dont mind was just kidding ;)

Show 100 post(s) from this thread on one page