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 }