PDA

View Full Version : Noblegarden v10.1 Emucoach



Titesusy
02-24-2019, 09:14 PM
Noblegarden



[Only registered and activated users can see links]

Successfully tested achievements (horde and alliance sides):
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links] (Horde)
[Only registered and activated users can see links] (Alliance)



Impossible for me to test the achievements (because i can't log multiple account)
[Only registered and activated users can see links] (Alliance)
[Only registered and activated users can see links] (Horde)
[Only registered and activated users can see links]

Tested but not reached achievements (buggued?) :
[Only registered and activated users can see links]



Changelogs :
- update 2019.03.01 : Changed name of one variable causing maybe some interferrence, and fixed one tippo error into the maping part of the code.

Titesusy
02-24-2019, 09:15 PM
Here the code :)


-- Last Revision & Tests : 2019.03.01 by Titesusy
-- Tested with V10.1
-- Modifiable starting here

[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- Non modifiable starting here

[Only registered and activated users can see links]
[Only registered and activated users can see links]

-- insertion into the tables the loot of the eggs.
[Only registered and activated users can see links]
INSERT INTO gameobject_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount) VALUES
[Only registered and activated users can see links]

UPDATE item_loot_template SET maxcount = '6' WHERE (entry = '45072' AND item = '44791'); -- Noblegarden Chocolate (it's 6 max in the ofiicial, instead of 1 actually)
UPDATE item_loot_template SET maxcount = '2' WHERE (entry = '45072' AND item = '44806'); -- Brightly Colored Shell Fragment (it's 2 max in the ofiicial, instead of 1 actually)


-- french fix
UPDATE locales_creature SET name_loc2 = 'Vendeur du Jardin des nobles' WHERE ( entry = '32836' );
UPDATE locales_creature SET name_loc2 = 'Collecteur du printemps' WHERE ( entry = '32799' );
UPDATE locales_creature SET name_loc2 = 'Récolteur du printemps' WHERE ( entry = '32798' );
UPDATE locales_creature SET name_loc2 = 'Marchand du Jardin des nobles' WHERE ( entry = '32837' );


-- insertion into creature tables
DELETE FROM creature WHERE ( id IN (
'32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837')); -- Marchand du Jardin des nobles (horde)

INSERT INTO creature
(guid, id, map, zone, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags, walkmode, saiscriptflag) VALUES
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- insertion into the tables the eggs that we have to loot
[Only registered and activated users can see links]
INSERT INTO gameobject (guid, id, map, zone, area, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]



-- insertion the quests into the npc as givers and rewarders ( quetes 13484 et 13483 : début roturiers .... )
DELETE FROM creature_involvedrelation WHERE id IN ('32836', '32799', '32798', '32837');
DELETE FROM creature_questrelation WHERE id IN ('32836', '32799', '32798', '32837');

INSERT INTO creature_involvedrelation (id, quest) VALUES
('32836', '13502'),
('32837', '13503'),
('32798', '13479'),
('32798', '13483'), -- Commoners (patch required)
('32799', '13480'),
('32799','13484'); -- Commoners (patch required)
INSERT INTO creature_questrelation (id, quest) VALUES
('32836', '13502'),
('32799', '13480'),
('32798', '13479'),
('32837', '13503');




-- insertion the gameobjects and npc into the events tables
DELETE FROM game_event_gameobject WHERE ( game_event_gameobject.guid IN (
SELECT gameobject.guid
[Only registered and activated users can see links]

INSERT INTO game_event_gameobject (eventEntry, guid)
SELECT '9' , gameobject.guid
[Only registered and activated users can see links]

DELETE FROM game_event_creature WHERE game_event_creature.guid IN (
SELECT creature.guid
FROM creature WHERE ( creature.id IN
( '32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837'))); -- Marchand du Jardin des nobles (horde)

INSERT INTO `game_event_creature` (eventEntry, guid)
[Only registered and activated users can see links]
FROM creature WHERE ( creature.id IN (
'32836', -- Vendeur du Jardin des nobles (alliance)
'32799', -- Collecteur du printemps (alliance)
'32798', -- Récolteur du printemps (horde)
'32837')); -- Marchand du Jardin des nobles (horde)

ExO
02-27-2019, 10:02 PM
Wow, awesome work buddy! Good job!

Titesusy
02-27-2019, 10:58 PM
Wow, awesome work buddy! Good job!

you're welcome ! But be sure you had checked the others events too. (Some events or patchs have been made these last days)

ExO
03-01-2019, 11:35 AM
you're welcome ! But be sure you had checked the others events too. (Some events or patchs have been made these last days)

Will do!

Tried to execute this but SQL errors, will you fix them? :)


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','0','1'),
[Only registered and activated users can see links]

Eg seems like there are issues with eg: SpawnEgg',

Titesusy
03-01-2019, 12:36 PM
arf, maybe about the name ? because the forum link with the name "spawn" ? i will try it with a different variable name


EDIT : by the way, the script is just updated.

Erenbo
04-16-2019, 12:39 PM
Nice one :D!

Titesusy
04-21-2019, 11:16 AM
Nice one :D!

Thanks you! It's nice to have a compliment about one of our work (EC team, or me for example).