3 replies to this topic

[Xanthous]

Alright I've been doing some testing with SandShroud on wow-v and since it is based of Aspire Hearthstone some of the creators might work for it; however the queries DO NOT work when using the Aspire download button for SandShroud. The exception being the quest creator and vendor creator.

So I figured I would start this thread to supply up to data and official SandShroud structures in the hopes of SandShroud support.

It should be noted the creature_names query of the Mob/NPC does work, just not the creature_proto query.

So Working Creator for SandShroud:
Quests
Vendor

Partially Working :
Mob/NPC (creature_names runs fine)

Not Working:
Graveyard(in SandShroud id = entry)
All Item Creators

SVN link to SQL structures:
http://trac6.assembl...owser/Trunk/sql

creature_proto structure:

CREATE TABLE `creature_proto` (
  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `minlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `maxlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `faction` smallint(5) unsigned NOT NULL DEFAULT '35',
  `minhealth` int(10) unsigned NOT NULL DEFAULT '1',
  `maxhealth` int(10) unsigned NOT NULL DEFAULT '1',
  `powertype` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `power` int(10) unsigned NOT NULL DEFAULT '0',
  `scale` float NOT NULL DEFAULT '1',
  `npcflags` int(10) unsigned NOT NULL DEFAULT '0',
  `attacktime` mediumint(8) unsigned NOT NULL DEFAULT '2500',
  `attacktype` tinyint(3) NOT NULL DEFAULT '0',
  `mindamage` float NOT NULL DEFAULT '1',
  `maxdamage` float NOT NULL DEFAULT '2',
  `rangedattacktime` mediumint(8) unsigned NOT NULL DEFAULT '3000',
  `rangedmindamage` float unsigned NOT NULL DEFAULT '1',
  `rangedmaxdamage` float unsigned NOT NULL DEFAULT '2',
  `Item1` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `Item2` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `Item3` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `respawntime` int(10) unsigned NOT NULL DEFAULT '360000',
  `resistance1` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance2` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance3` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance4` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance5` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance6` int(10) unsigned NOT NULL DEFAULT '0',
  `resistance7` int(10) unsigned NOT NULL DEFAULT '0',
  `combat_reach` float NOT NULL DEFAULT '0',
  `bounding_radius` float NOT NULL DEFAULT '0',
  `auras` varchar(255) NOT NULL DEFAULT '',
  `boss` int(11) unsigned NOT NULL DEFAULT '0',
  `money` int(10) NOT NULL DEFAULT '0',
  `no_XP` int(11) NOT NULL DEFAULT '0',
  `invisibility_type` int(10) unsigned NOT NULL DEFAULT '0',
  `death_state` int(10) unsigned NOT NULL DEFAULT '0',
  `walk_speed` float NOT NULL DEFAULT '2.5',
  `run_speed` float NOT NULL DEFAULT '8',
  `fly_speed` float NOT NULL DEFAULT '14',
  `extra_a9_flags` int(10) NOT NULL DEFAULT '0',
  `auraimmune_flag` int(10) unsigned NOT NULL DEFAULT '0',
  `vehicle_entry` mediumint(8) NOT NULL DEFAULT '-1',
  `SpellClickId` mediumint(8) NOT NULL DEFAULT '-1',
  `CanMove` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';

Power Types (I figure you need to know what number Mana is.):

Taken from Unit.h

enum PowerType
{
	POWER_TYPE_HEALTH	= -2,
	POWER_TYPE_MANA		= 0,
	POWER_TYPE_RAGE		= 1,
	POWER_TYPE_FOCUS	= 2,
	POWER_TYPE_ENERGY	= 3,
	POWER_TYPE_HAPPINESS= 4, // Not used in creature powertypes.
	POWER_TYPE_RUNE		= 5,
	POWER_TYPE_RUNIC	= 6,
	MAX_POWER_TYPE		= 7
};

items structure:

CREATE TABLE `items` (
  `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `class` int(10) NOT NULL DEFAULT '0',
  `subclass` int(10) NOT NULL DEFAULT '0',
  `field4` int(10) NOT NULL DEFAULT '-1',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL DEFAULT '',
  `name3` varchar(255) NOT NULL DEFAULT '',
  `name4` varchar(255) NOT NULL DEFAULT '',
  `displayid` mediumint(10) unsigned NOT NULL DEFAULT '0',
  `quality` int(10) NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `buyprice` int(10) unsigned NOT NULL DEFAULT '0',
  `sellprice` int(10) unsigned NOT NULL DEFAULT '0',
  `inventorytype` int(10) NOT NULL DEFAULT '0',
  `allowableclass` int(10) NOT NULL DEFAULT '0',
  `allowablerace` int(10) NOT NULL DEFAULT '0',
  `itemlevel` int(10) NOT NULL DEFAULT '0',
  `requiredlevel` int(10) NOT NULL DEFAULT '0',
  `RequiredSkill` int(10) NOT NULL DEFAULT '0',
  `RequiredSkillRank` int(10) NOT NULL DEFAULT '0',
  `RequiredSkillSubRank` int(10) NOT NULL DEFAULT '0',
  `RequiredPlayerRank1` int(10) NOT NULL DEFAULT '0',
  `RequiredPlayerRank2` int(10) NOT NULL DEFAULT '0',
  `RequiredFaction` int(10) NOT NULL DEFAULT '0',
  `RequiredFactionStanding` int(10) NOT NULL DEFAULT '0',
  `Unique` int(10) NOT NULL DEFAULT '0',
  `maxcount` int(10) NOT NULL DEFAULT '0',
  `ContainerSlots` int(10) NOT NULL DEFAULT '0',
  `stat_type1` int(10) NOT NULL DEFAULT '0',
  `stat_value1` int(10) NOT NULL DEFAULT '0',
  `stat_type2` int(10) NOT NULL DEFAULT '0',
  `stat_value2` int(10) NOT NULL DEFAULT '0',
  `stat_type3` int(10) NOT NULL DEFAULT '0',
  `stat_value3` int(10) NOT NULL DEFAULT '0',
  `stat_type4` int(10) NOT NULL DEFAULT '0',
  `stat_value4` int(10) NOT NULL DEFAULT '0',
  `stat_type5` int(10) NOT NULL DEFAULT '0',
  `stat_value5` int(10) NOT NULL DEFAULT '0',
  `stat_type6` int(10) NOT NULL DEFAULT '0',
  `stat_value6` int(10) NOT NULL DEFAULT '0',
  `stat_type7` int(10) NOT NULL DEFAULT '0',
  `stat_value7` int(10) NOT NULL DEFAULT '0',
  `stat_type8` int(10) NOT NULL DEFAULT '0',
  `stat_value8` int(10) NOT NULL DEFAULT '0',
  `stat_type9` int(10) NOT NULL DEFAULT '0',
  `stat_value9` int(10) NOT NULL DEFAULT '0',
  `stat_type10` int(10) NOT NULL DEFAULT '0',
  `stat_value10` int(10) NOT NULL DEFAULT '0',
  `ScalingStatId` int(30) NOT NULL DEFAULT '0',
  `ScalingStatFlags` int(30) NOT NULL DEFAULT '0',
  `dmg_min1` float NOT NULL DEFAULT '0',
  `dmg_max1` float NOT NULL DEFAULT '0',
  `dmg_type1` int(10) NOT NULL DEFAULT '0',
  `dmg_min2` float NOT NULL DEFAULT '0',
  `dmg_max2` float NOT NULL DEFAULT '0',
  `dmg_type2` int(10) NOT NULL DEFAULT '0',
  `armor` int(10) NOT NULL DEFAULT '0',
  `holy_res` int(10) NOT NULL DEFAULT '0',
  `fire_res` int(10) NOT NULL DEFAULT '0',
  `nature_res` int(10) NOT NULL DEFAULT '0',
  `frost_res` int(10) NOT NULL DEFAULT '0',
  `shadow_res` int(10) NOT NULL DEFAULT '0',
  `arcane_res` int(10) NOT NULL DEFAULT '0',
  `delay` int(10) NOT NULL DEFAULT '0',
  `ammo_type` int(10) NOT NULL DEFAULT '0',
  `range` float NOT NULL DEFAULT '0',
  `spellid_1` int(10) NOT NULL DEFAULT '0',
  `spelltrigger_1` int(10) NOT NULL DEFAULT '0',
  `spellcharges_1` int(10) NOT NULL DEFAULT '0',
  `spellcooldown_1` int(10) NOT NULL DEFAULT '0',
  `spellcategory_1` int(10) NOT NULL DEFAULT '0',
  `spellcategorycooldown_1` int(10) NOT NULL DEFAULT '0',
  `spellid_2` int(10) NOT NULL DEFAULT '0',
  `spelltrigger_2` int(10) NOT NULL DEFAULT '0',
  `spellcharges_2` int(10) NOT NULL DEFAULT '0',
  `spellcooldown_2` int(10) NOT NULL DEFAULT '0',
  `spellcategory_2` int(10) NOT NULL DEFAULT '0',
  `spellcategorycooldown_2` int(10) NOT NULL DEFAULT '0',
  `spellid_3` int(10) NOT NULL DEFAULT '0',
  `spelltrigger_3` int(10) NOT NULL DEFAULT '0',
  `spellcharges_3` int(10) NOT NULL DEFAULT '0',
  `spellcooldown_3` int(10) NOT NULL DEFAULT '0',
  `spellcategory_3` int(10) NOT NULL DEFAULT '0',
  `spellcategorycooldown_3` int(10) NOT NULL DEFAULT '0',
  `spellid_4` int(10) NOT NULL DEFAULT '0',
  `spelltrigger_4` int(10) NOT NULL DEFAULT '0',
  `spellcharges_4` int(10) NOT NULL DEFAULT '0',
  `spellcooldown_4` int(10) NOT NULL DEFAULT '0',
  `spellcategory_4` int(10) NOT NULL DEFAULT '0',
  `spellcategorycooldown_4` int(10) NOT NULL DEFAULT '0',
  `spellid_5` int(10) NOT NULL DEFAULT '0',
  `spelltrigger_5` int(10) NOT NULL DEFAULT '0',
  `spellcharges_5` int(10) NOT NULL DEFAULT '0',
  `spellcooldown_5` int(10) NOT NULL DEFAULT '0',
  `spellcategory_5` int(10) NOT NULL DEFAULT '0',
  `spellcategorycooldown_5` int(10) NOT NULL DEFAULT '0',
  `bonding` int(10) NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL DEFAULT '',
  `page_id` int(10) NOT NULL DEFAULT '0',
  `page_language` int(10) NOT NULL DEFAULT '0',
  `page_material` int(10) NOT NULL DEFAULT '0',
  `quest_id` int(10) NOT NULL DEFAULT '0',
  `lock_id` int(10) NOT NULL DEFAULT '0',
  `lock_material` int(10) NOT NULL DEFAULT '0',
  `sheathID` int(10) NOT NULL DEFAULT '0',
  `randomprop` int(10) NOT NULL DEFAULT '0',
  `RandomSuffixId` int(10) NOT NULL DEFAULT '0',
  `block` int(10) NOT NULL DEFAULT '0',
  `itemset` int(10) NOT NULL DEFAULT '0',
  `MaxDurability` int(10) NOT NULL DEFAULT '0',
  `ZoneNameID` int(10) NOT NULL DEFAULT '0',
  `mapid` int(10) DEFAULT NULL,
  `bagfamily` int(10) NOT NULL DEFAULT '0',
  `TotemCategory` int(10) DEFAULT NULL,
  `socket_color_1` int(10) DEFAULT NULL,
  `unk201_3` int(10) NOT NULL DEFAULT '0',
  `socket_color_2` int(10) DEFAULT NULL,
  `unk201_5` int(10) NOT NULL DEFAULT '0',
  `socket_color_3` int(10) DEFAULT NULL,
  `unk201_7` int(10) NOT NULL DEFAULT '0',
  `socket_bonus` int(10) DEFAULT NULL,
  `GemProperties` int(10) DEFAULT NULL,
  `ReqDisenchantSkill` int(10) NOT NULL DEFAULT '-1',
  `Lootgold` int(10) NOT NULL DEFAULT '0',
  `ArmorDamageModifier` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Item System';

Graveyard Structure:

CREATE TABLE `graveyards` (
  `entry` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `position_x` float NOT NULL DEFAULT '0',
  `position_y` float NOT NULL DEFAULT '0',
  `position_z` float NOT NULL DEFAULT '0',
  `orientation` float NOT NULL DEFAULT '0',
  `zoneid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `adjacentzoneid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `mapid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`entry`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 COMMENT='Graveyard System';

If you need anymore data just let me know.

[Thetruecrow]

Thank you for your interest in getting support for Sandshroud. Your thread has been linked to in the other thread, because you put a lot more effort into this than I did.
Thank you again.

[SickBoy]

I do indeed plan to add support for Sandshroud due to Crow being such a prominent member here and the dev for it. It may not have a huge userbase, but Crow has clearly done a LOT with the core and is the best resource I could want for providing me with support for its addition to WoW-V.

From what Crow has told me, it shouldn't be all that difficult to implement. It's more a matter of me prioritizing other work I have in order to get it done.

[Xanthous]

Quote

I do indeed plan to add support for Sandshroud due to Crow being such a prominent member here and the dev for it. It may not have a huge userbase, but Crow has clearly done a LOT with the core and is the best resource I could want for providing me with support for its addition to WoW-V.

From what Crow has told me, it shouldn't be all that difficult to implement. It's more a matter of me prioritizing other work I have in order to get it done.

Ah, great!

I just wasn't sure if any data had been submitted on Sandshroud. So I figured I would provide it. I am sure it's userbase will improve quite a bit when you do get around to adding support for it.