Epic Release-Hyjal for TrinityCore 3.3.5a and two Malls (Full Project)

[snake eyes]

Hi
Good Day
Today i release Hyjal for Trinity as i did before for Arcemu
All you have to do is that Execute the sql file to your database
and replace DBC files with one included
It support trinity core eda06321b95a
features
1- portals almost Every where
2- Gm island vendors
3- Two Malls Ally and Hord
4- Hyjal Mobs for leveling Up
5- Hyjal Quest That I let discover for your self
And more further
You’ll never notice that you have an error in worldserver
Download link
Link Updated

Ally Mall

Gm Island

Horde Mall

Drop Items

Epic Items

Portals

Spirit Healer


Download link
Hyjal-4-Trinity-eda06321b95a-3.3.5a



Have Fun

[Nokia123]

Thanks Good work.

[snake eyes]

Thank you

[thefallen1one]

Gonna test.

[Cookie16]

Very Nice, Great Work! =D

[santomusik]

Hi! thanks, this looks awesome, but everytime i try to add it to my database i receive this error (sorry for my bad english)

	

		

			

			
				Query:
INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`IconName`,`castBarCaption`,`unk1`,`faction`,`flags`,`size`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`AIName`,`ScriptName`,`WDBVerified`) VALUES
(77747,19,1907,'Mailbox','','','',0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1)

Error occured at:2014-03-21 13:09:49
Line no.:4
Error Code: 1054 - Unknown column 'AIName' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES ('250001', '2', '7', '0', 'Kiel's Woot Dream', '52571', '4', '3100163423', '262', '1', '0', '0', '13', '1535', '1791', '400', '80', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '3', '38', '21939', '3', '0', '36', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '598', '731', '0', '50', '100', '5', '0', '0', '0', '0', '0', '0', '0', '1300', '0', '0.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'It's Awesum' as **** again', '0', '0', '0', '0', '0', '0', '6', '0', '0', '0', '0', '0', '0', '0', '32751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0');


Error occured at:2014-03-21 13:10:08
Line no.:2
Error Code: 1064 - 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 's Woot Dream', '52571', '4', '3100163423', '262', '1', '0', '0', '13', '1535', '' at line 1

Query:
INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`IconName`,`castBarCaption`,`unk1`,`faction`,`flags`,`size`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`AIName`,`ScriptName`,`WDBVerified`) VALUES
(77747,19,1907,'Mailbox','','','',0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1)

Error occured at:2014-03-21 14:36:23
Line no.:4
Error Code: 1054 - Unknown column 'AIName' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES ('250000', '2', '7', '0', 'Kiel's Wet Dream', '52571', '4', '3100163423', '262', '1', '0', '0', '13', '1535', '1791', '400', '80', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '3', '38', '21939', '3', '0', '36', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '598', '731', '0', '50', '100', '5', '0', '0', '0', '0', '0', '0', '0', '1300', '0', '0.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'It's Awesum' as ****', '0', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '32751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0');


Error occured at:2014-03-21 14:41:01
Line no.:2
Error Code: 1064 - 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 's Wet Dream', '52571', '4', '3100163423', '262', '1', '0', '0', '13', '1535', '1' at line 1

Query:
INSERT INTO `gameobject_template` (`entry`,`type`,`displayId`,`name`,`IconName`,`castBarCaption`,`unk1`,`faction`,`flags`,`size`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`AIName`,`ScriptName`,`WDBVerified`) VALUES
(77747,19,1907,'Mailbox','','','',0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','',1)

Error occured at:2014-03-21 14:54:02
Line no.:4
Error Code: 1054 - Unknown column 'AIName' in 'field list'

Query:
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES ('1895', '2', '7', '0', 'Kiel's Wet Dream', '52571', '4', '3100163423', '262', '1', '9999', '9999', '13', '1535', '1791', '400', '80', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '3', '3', '355', '38', '717', '36', '249', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '449', '674', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1100', '0', '0.4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'It's awesome, trust me.', '0', '0', '0', '0', '0', '0', '3', '0', '0', '0', '0', '0', '0', '0', '32751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0')

Error occured at:2014-03-21 15:42:01
Line no.:1
Error Code: 1064 - 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 's Wet Dream', '52571', '4', '3100163423', '262', '1', '9999', '9999', '13', '153' at line 1

Query:
insert  into `creature`(`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) values ('6491', '0', '1', '1', '5233', '0', '-8672.26', '-556.607', '151.05', '0.0722576', '0', '0', '0', '0', '0', '0', '0', '0', '0')

Error occured at:2014-03-24 13:04:19
Line no.:27
Error Code: 1054 - Unknown column 'npcflag' in 'field list'

Query:
CREATE TABLE `0_hyjal_version` (
  `hyjal_core_name` varchar(120) default NULL COMMENT 'Core revision dumped at startup.',
  `hyjal_core_revision` varchar(120) default NULL,
  `Last_Update` date default NULL,
  `hyjal_db_version` varchar(120) default NULL COMMENT 'Version of world DB.',
  `hy_script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.',
  `cache_id` int(10) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'

Error occured at:2014-03-24 13:12:20
Line no.:21
Error Code: 1050 - Table '0_hyjal_version' already exists

Query:
CREATE TABLE `0_hyjal_version` (
  `hyjal_core_name` varchar(120) default NULL COMMENT 'Core revision dumped at startup.',
  `hyjal_core_revision` varchar(120) default NULL,
  `Last_Update` date default NULL,
  `hyjal_db_version` varchar(120) default NULL COMMENT 'Version of world DB.',
  `hy_script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.',
  `cache_id` int(10) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'

Error occured at:2014-03-24 13:13:44
Line no.:21
Error Code: 1050 - Table '0_hyjal_version' already exists

Query:
CREATE TABLE `0_hyjal_version` (
  `hyjal_core_name` varchar(120) default NULL COMMENT 'Core revision dumped at startup.',
  `hyjal_core_revision` varchar(120) default NULL,
  `Last_Update` date default NULL,
  `hyjal_db_version` varchar(120) default NULL COMMENT 'Version of world DB.',
  `hy_script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.',
  `cache_id` int(10) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'

Error occured at:2014-03-24 13:17:51
Line no.:21
Error Code: 1050 - Table '0_hyjal_version' already exists
			
		
	

how can i solve this?

PD: I use SQLyog and TrinityCore 9847

[snake eyes]

Hi
Good Day
your errors case you did not use the trinity core eda06321b95a
and in the second place you did run the query more than one time

[snake eyes]

Very Nice, Great Work! =D

Thanks Sorry I have been busy lately

[snake eyes]

Gonna test.

How is it after testing

[snake eyes]

Link Updated AS order

[Marko Jaksic]

This reminds me of 2011

[snake eyes]

Just to retrieve back the good old days