private static void LoadEditorScenes()
{
s_EditorScenes = new List <VCESceneSetting> ();
#if PLANET_EXPLORERS
SqliteDataReader reader = LocalDatabase.Instance.ExecuteQuery("SELECT * FROM vc_scene");
while (reader.Read())
{
VCESceneSetting scene = new VCESceneSetting();
scene.m_Id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("id")));
scene.m_ParentId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("parentid")));
scene.m_Name = reader.GetString(reader.GetOrdinal("name"));
scene.m_Category = (EVCCategory)(Convert.ToInt32(reader.GetString(reader.GetOrdinal("category"))));
List <string> parts = null;
parts = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("editorsize")), ';');
scene.m_EditorSize = new IntVector3();
scene.m_EditorSize.x = Convert.ToInt32(parts[0]);
scene.m_EditorSize.y = Convert.ToInt32(parts[1]);
scene.m_EditorSize.z = Convert.ToInt32(parts[2]);
parts.Clear();
scene.m_VoxelSize = Convert.ToSingle(reader.GetString(reader.GetOrdinal("voxelsize")));
parts = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("interval")), ';');
scene.m_MajorInterval = Convert.ToInt32(parts[0]);
scene.m_MinorInterval = Convert.ToInt32(parts[1]);
parts.Clear();
parts = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("cost")), ';');
scene.m_BlockUnit = Convert.ToInt32(parts[0]);
scene.m_DyeUnit = Convert.ToInt32(parts[1]);
parts.Clear();
s_EditorScenes.Add(scene);
}
#endif
}
private static void LoadMatters()
{
s_Matters = new Dictionary <int, VCMatterInfo> ();
#if PLANET_EXPLORERS
SqliteDataReader reader = LocalDatabase.Instance.ExecuteQuery("SELECT * FROM vc_material ORDER BY cast(sort as int) ASC");
while (reader.Read())
{
VCMatterInfo matter = new VCMatterInfo();
matter.ItemIndex = Convert.ToInt32(reader.GetString(reader.GetOrdinal("id")));
matter.Order = Convert.ToInt32(reader.GetString(reader.GetOrdinal("sort")));
matter.ItemId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("itemid")));
// matter.Name = reader.GetString(reader.GetOrdinal("englishname"));
matter.Attack = Convert.ToSingle(reader.GetString(reader.GetOrdinal("attack")));
matter.Defence = Convert.ToSingle(reader.GetString(reader.GetOrdinal("defence")));
matter.Durability = Convert.ToSingle(reader.GetString(reader.GetOrdinal("durability")));
matter.Hp = Convert.ToSingle(reader.GetString(reader.GetOrdinal("hp")));
matter.SellPrice = Convert.ToSingle(reader.GetString(reader.GetOrdinal("value")));
matter.Density = Convert.ToSingle(reader.GetString(reader.GetOrdinal("density")));
matter.Elasticity = Convert.ToSingle(reader.GetString(reader.GetOrdinal("elasticity")));
matter.DefaultBumpStrength = Convert.ToSingle(reader.GetString(reader.GetOrdinal("bumpstrength")));
matter.DefaultSpecularStrength = Convert.ToSingle(reader.GetString(reader.GetOrdinal("specularstrength")));
matter.DefaultSpecularPower = Convert.ToSingle(reader.GetString(reader.GetOrdinal("specularpower")));
matter.DefaultTile = Convert.ToSingle(reader.GetString(reader.GetOrdinal("tile")));
matter.DefaultDiffuseRes = reader.GetString(reader.GetOrdinal("diffusemap"));
matter.DefaultBumpRes = reader.GetString(reader.GetOrdinal("bumpmap"));
List <string> parts = null;
parts = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("specularcolor")), ';');
matter.DefaultSpecularColor.r = (byte)(Convert.ToInt32(parts[0]));
matter.DefaultSpecularColor.g = (byte)(Convert.ToInt32(parts[1]));
matter.DefaultSpecularColor.b = (byte)(Convert.ToInt32(parts[2]));
matter.DefaultSpecularColor.a = (byte)(255);
parts.Clear();
parts = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("emissivecolor")), ';');
matter.DefaultEmissiveColor.r = (byte)(Convert.ToInt32(parts[0]));
matter.DefaultEmissiveColor.g = (byte)(Convert.ToInt32(parts[1]));
matter.DefaultEmissiveColor.b = (byte)(Convert.ToInt32(parts[2]));
matter.DefaultEmissiveColor.a = (byte)(255);
parts.Clear();
s_Matters.Add(matter.ItemIndex, matter);
}
#endif
}
private static void LoadCategories()
{
s_Categories = new Dictionary <EVCCategory, VCCategoryInfo> ();
#if PLANET_EXPLORERS
SqliteDataReader reader = LocalDatabase.Instance.ExecuteQuery("SELECT * FROM vc_category");
while (reader.Read())
{
VCCategoryInfo category = new VCCategoryInfo();
category.m_Category = (EVCCategory)(Convert.ToInt32(reader.GetString(reader.GetOrdinal("id"))));
category.m_Name = reader.GetString(reader.GetOrdinal("name"));
category.m_DefaultPath = reader.GetString(reader.GetOrdinal("default_path"));
List <string> part_types = VCUtils.ExplodeString(reader.GetString(reader.GetOrdinal("part_types")), ';');
category.m_PartTypes = new List <EVCComponent> ();
foreach (string s in part_types)
{
category.m_PartTypes.Add((EVCComponent)(Convert.ToInt32(s)));
}
s_Categories.Add(category.m_Category, category);
}
#endif
}
