(help) NCDB update

[wowtogether]

guys, i got the old ncdb how can i update the newest one without lose all the custom stuff i modify in the game????

i has NCDB to revision 773 ascent 2.8 stable, but i got lot of the player's account and custom spwan item in the game i want to upgrade to the new 3.5 and new NCDB.. what should i do i am really confuse... because i worry about lose all the player item and custom spwan item......... help

[kanqaz]

run the changeset's i think or take out all our old stuff, and execute into the new 1.

[Spartansp]

just find the ascent core you like and it should come with a folder labled SQL just run all updates from there

[Performer]

2 secs mate ill give youy the latest changeset.

[Performer]

Run This It Should Fix It!

/*---------------------------------------------------------
--                -- Changeset 1070-1079 --              --
---------------------------------------------------------*/

-- Rev #1070 Feanor
-- Unstable Shroom Displayid corrected
UPDATE `creature_spawns` SET `displayid`='11686' WHERE (`entry`='20479');
-- Ango'rosh Souleater Attack Corrected.
UPDATE `creature_proto` SET `attacktime`='1800',`mindamage`='614',`maxdamage`='826' WHERE (`entry`='18121');
-- Scale of Young Wolf
UPDATE `creature_proto` SET `scale`='0.75' WHERE (`entry`='299');

-- Rev #1071 Hypnotoad
-- from blizzy with love! (i hope)
-- from now on please use http://armory.worldofwarcraft.com/  for % drop chance
-- http://armory.worldofwarcraft.com/item-info.xml?i=xxxx replace xxxx whit the item id

-- Loot corections:
-- 5026 Fire tar, Medium (25% - 50%)
-- 6652 Reagent Pouch, Medium (25% - 50%) 
-- 6640 Felstalker Hoof, High (51% - 99%)
-- 6634 Ritual Salve, High (51% - 99%)
-- 23744 Foul Essence, Medium (25% - 50%)
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 5026;
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 6652;
UPDATE `creatureloot` set `percentchance` = 75 WHERE itemid = 6640;
UPDATE `creatureloot` set `percentchance` = 75 WHERE itemid = 6634;
UPDATE `creatureloot` set `percentchance` = 50 WHERE itemid = 23744;

-- missing "Razormane Seer" from creatureloot he drops "fire tar" to:
INSERT INTO `creatureloot` (`entryid`,`itemid`,`percentchance`,`mincount`,`maxcount`) VALUES (3458,5026,50,1,1);

-- Missing creature spawns:
-- Minor Manifestation of Fire used a neutal faction for the one you can attack since i cant fine the non aggro but attackable creature flags:
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
(5893, 1, -244.623, -4017.98, 187.304, 1.71895, 0, 2172, 15, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES 
(5893, 1, -236.075, -4018.38, 187.304, 2.37425, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -253.083, -4020.82, 187.304, 0.925191, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -252.627, -4010.83, 187.291, 5.97137, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5893, 1, -236.866, -4008.16, 187.227, 3.77226, 0, 2172, 91, 256, 0, 0, 0, 0, 0, 0, 0, 0);

-- Corrupt Minor Manifestation of Water:
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`) VALUES 
(5894, 0, 417.727, 1823.51, 12.4818, 0.834097, 0, 5493, 15, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES 
(5894, 0, 397.419, 1827.36, 10.3968, 1.09956, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 406.073, 1818.3, 10.3026, 1.35874, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 418.938, 1835.96, 10.4415, 1.30376, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 425.997, 1830.39, 10.4651, 0.977822, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 429.731, 1818.89, 10.3836, 1.51975, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0),
(5894, 0, 422.285, 1813.8, 10.3846, 1.31161, 0, 5493, 15, 256, 0, 0, 0, 0, 0, 0, 0, 0);

-- Missing Object spawns:
-- Shaman shrine in Silverpine Forest 
-- 101748 still needs right orientation this is visual obj not that important :
INSERT INTO `gameobject_spawns` (Entry, map, position_x, position_y, position_z, Facing, orientation1, orientation2, orientation3, orientation4, State, Flags, Faction, Scale, stateNpcLink)
VALUES (101748, 0, 422.733, 1862.23, 9.5, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0);
-- 63674 is focus object for the quest:
INSERT INTO `gameobject_spawns` (Entry, map, position_x, position_y, position_z, Facing, orientation1, orientation2, orientation3, orientation4, State, Flags, Faction, Scale, stateNpcLink)
VALUES (63674, 0, 422.733, 1862.23, 9.5, 0, 0, 0, 0, 1, 1, 0, 0, 1, 0);

-- respawn time and aura's for the quest cratures :
-- Minor Manifestation of Fire
UPDATE `creature_proto` SET `respawntime` = 120 , `auras` = 8203 WHERE `entry` = 5893 ;
-- Corrupt Minor Manifestation of Water
UPDATE `creature_proto` SET `respawntime` = 120 , `auras` = 8203 WHERE `entry` = 5894 ;
-- Minor Manifestation of earth
UPDATE `creature_proto` SET `auras` = 8203 WHERE `entry` = 5891 ;

-- Added missing ReceiveItem from quests:
-- removed ReceiveItemId1 and count  from quest 1527 since you get the item From prev quest
-- 7766 Empty Brown Waterskin from quest 1535
-- 7768 Empty Red Waterskin from quest 1536
-- 7767 Empty Blue Waterskin from quest 1534
-- 7810 Vial of Purest Water from quest 220
-- 23749 Empty Bota Bag for quest 9504
UPDATE `quests` SET `questlevel` = '13',`ReceiveItemId1` = '0',`ReceiveItemCount1` = '0' WHERE `entry` =1527 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '22',`ReceiveItemId1` = '7766',`ReceiveItemCount1` = '1' WHERE `entry` =1535 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '22',`ReceiveItemId1` = '7768',`ReceiveItemCount1` = '1' WHERE `entry` =1536 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '23',`ReceiveItemId1` = '7767',`ReceiveItemCount1` = '1' WHERE `entry` =1534 LIMIT 1 ;
UPDATE `quests` SET `questlevel` = '23',`ReceiveItemId1` = '7810',`ReceiveItemCount1` = '1' WHERE `entry` =220 LIMIT 1 ;
UPDATE `quests` SET `ReceiveItemId1` = '23749',`ReceiveItemCount1` = '1' WHERE `entry` =9504 LIMIT 1 ;

-- delete sapta quests from quest starter and finisher:
-- they are not needed this are in case sombodey snached youre spawn and you have alredy drinked the sapta and cant sea the creature after respawn , blizzard is wired , this can never happen on ascent since respawn is every time refreshed and ower creature has 2 min respawn. 
DELETE FROM `creature_quest_starter` WHERE `quest` = 972 ;
DELETE FROM `creature_quest_finisher` WHERE `quest` = 972 ;
DELETE FROM `creature_quest_starter` WHERE `quest` =1463 ;
DELETE FROM `creature_quest_finisher` WHERE `quest` =1463 ;
DELETE FROM `creature_quest_starter` WHERE `quest` =1462 ;
DELETE FROM `creature_quest_finisher` WHERE `quest` =1462 ;
DELETE FROM `creature_quest_starter` WHERE `quest` =1464 ;
DELETE FROM `creature_quest_finisher` WHERE `quest` =1464 ;

-- delete creture from creature_spawns:
-- 17359 Tel'athion the Impure hes not an actual spawn he gets summoned by a trigger from barrel of filth witch works so we dont need a world spawn for the creature
DELETE FROM `creature_spawns` WHERE `entry` =17359 ;

-- delete object from gameobject_spawn:
-- duble spawn of the shaman shrine visual this is hagi's mistake im corecting it
DELETE FROM `gameobject_spawns` WHERE `entry` = 100035 ;

-- update the questlevel for totem quest:
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1521 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1520 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1421 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1516 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1517 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =1518 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =9449 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =9450 ;
UPDATE `quests` SET `questlevel` = '4' WHERE `entry` =9451 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =9468 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =9461 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =9555 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =2983 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =1523 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =1522 ;
UPDATE `quests` SET `questlevel` = '10' WHERE `entry` =2984 ;
UPDATE `quests` SET `questlevel` = '11' WHERE `entry` =1524 ;
UPDATE `quests` SET `questlevel` = '12' WHERE `entry` =1525 ;
UPDATE `quests` SET `questlevel` = '13' WHERE `entry` =1526 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =9500 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =9502 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =10490 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =9501 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =9503 ;
UPDATE `quests` SET `questlevel` = '24' WHERE `entry` =9504 ;
UPDATE `quests` SET `questlevel` = '23' WHERE `entry` =9508 ;
UPDATE `quests` SET `questlevel` = '20' WHERE `entry` =9509 ;
UPDATE `quests` SET `questlevel` = '22' WHERE `entry` =1530 ;
UPDATE `quests` SET `questlevel` = '30' WHERE `entry` =1531 ;
UPDATE `quests` SET `questlevel` = '30' WHERE `entry` =1532 ;
UPDATE `quests` SET `questlevel` = '30' WHERE `entry` =9554 ;

-- update quest reqquest:
-- 1529 this dos not have reqquest this is the tauren side link quest to call of water
UPDATE `quests` SET `RequiredQuest1` = '0' WHERE `entry` =1529 LIMIT 1 ;

-- 1530 removed reqquest since core dos not suport multipe RequiredQuest1 (is eather this or that or that or that quest RequiredQuest1 , one from a list of 4 i hope you get the picture)
UPDATE `quests` SET `RequiredQuest1` = '0' WHERE `entry` =1530 LIMIT 1 ;

-- added quest starter for the tauren side link to call of fire and call of water
INSERT INTO `creature_quest_starter` VALUES ('3066','2984');
INSERT INTO `creature_quest_starter` VALUES ('5906','1532');

-- Felhunter warlock quest
UPDATE `quests` SET `prevquestid` = '0' WHERE `entry` = '1795';
UPDATE `quests` SET `requiredquest1` = '0' WHERE `entry` = '1795';
-- missing object :
INSERT INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`, `stateNpcLink`) VALUES
(92388, 1, -768.247, -3721.85, 42.3836, 2.69393, 0, 0, 0.975054, 0.221969, 1, 0, 0, 2, 0);
UPDATE `quests` SET `prevquestid` = '0' WHERE `entry` = '1795';
UPDATE `quests` SET `requiredquest1` = '0' WHERE `entry` = '1795';
-- missing object :
INSERT INTO `gameobject_spawns` (`Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`, `stateNpcLink`) VALUES
(92388, 1, -768.247, -3721.85, 42.3836, 2.69393, 0, 0, 0.975054, 0.221969, 1, 0, 0, 2, 0);

-- Rev #1071 Feanor
-- Paulsta'ats <Consortium Quartermaster> spawned.
DELETE FROM `creature_spawns` WHERE `entry`='23007';
INSERT INTO `creature_spawns` (`id`,`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`movetype`,`displayid`,`faction`,`flags`,`bytes`,`bytes2`,`emote_state`,`npc_respawn_link`,`channel_spell`,`channel_target_sqlid`,`channel_target_sqlid_creature`,`standstate`) VALUES (NULL,'23007','530','-2068.25','8615.25','21.0697','4.1007','0','18660','1731','0','0','0','0','0','0','0','0','0');
-- Scout Bloodfist Spawned.
DELETE FROM `creature_spawns` WHERE `entry`='17081';
INSERT INTO `creature_spawns` (`id`,`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`movetype`,`displayid`,`faction`,`flags`,`bytes`,`bytes2`,`emote_state`,`npc_respawn_link`,`channel_spell`,`channel_target_sqlid`,`channel_target_sqlid_creature`,`standstate`) VALUES (NULL,'17081','1','-6814.08','824.954','49.8831','4.07178','0','16836','35','0','0','0','0','0','0','0','0','0');

-- Rev #1072 Hypnotoad
-- Prince Malchezaar's Axes item display
UPDATE `creature_proto` SET `equipmodel1` = '40066' WHERE `entry` = '17650';
UPDATE `creature_proto` SET `equipinfo1` = '33488898' WHERE `entry` = '17650';
UPDATE `creature_proto` SET `equipslot1` = '768' WHERE `entry` = '17650';
UPDATE `creature_proto` SET `equipmodel2` = '40066' WHERE `entry` = '17650';
UPDATE `creature_proto` SET `equipinfo2` = '33488898' WHERE `entry` = '17650';
UPDATE `creature_proto` SET `equipslot2` = '768' WHERE `entry` = '17650';

[Performer]

if it dont then you will need some of the earlier changesets get them off the NCDB SVN.

[wowtogether]

i has NCDB to revision 773 ascent 2.8 stable, but i got lot of the player's account and custom spwan item in the game i want to upgrade to the new 3.5 and new NCDB.. what should i do i am really confuse... because i worry about lose all the player item and custom spwan item......... help