public Boolean UpdateBlock(BlockBuilding block)
{
Boolean isUpdated = false;
string query = "update tblblock set name='" + block.getBlockName() + "', " +
"gender='" + block.getGender() + "'," +
"description='" + block.getDescription() + "'," +
"status='" + block.getStatus() + "'where blockId='" + block.getBlockId() + "';";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
int updatedRow = commandDatabase.ExecuteNonQuery();
if (updatedRow > 0)
{
isUpdated = true;
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(isUpdated);
}
private void btnAdd_Click(object sender, EventArgs e)
{
string blockId = txtBlockId.Text;
string blockName = txtBlockName.Text;
string gender = txtGender.Text;
string description = txtDescription.Text;
string status = txtStatus.Text;
BlockBuilding block = new BlockBuilding();
block.setBlockId(blockId);
block.setBlockName(blockName);
block.setGender(gender);
block.setDescription(description);
block.setStatus(status);
BlockController blockController = new BlockController();
bool i = blockController.UpdateBlock(block);
if (i == true)
{
MessageBox.Show("Block Information updated successfully!");
}
else
{
MessageBox.Show("Block Information is not updated successfully!");
}
}
public BlockBuilding SearchBlock(string search)
{
BlockBuilding block = new BlockBuilding();
string query = "select * from tblblock where blockId='" + search + "';";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
MySqlDataReader reader = commandDatabase.ExecuteReader();
while (reader.Read())
{
block.setBlockId(reader["blockId"].ToString());
block.setBlockName(reader["name"].ToString());
block.setGender(reader["gender"].ToString());
block.setDescription(reader["description"].ToString());
block.setStatus(reader["status"].ToString());
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(block);
}
private void btnAdd_Click(object sender, EventArgs e)
{
string block = txtBlockName.Text;
string gender = txtGender.Text;
string description = txtDescription.Text;
string status = txtStatus.Text;
BlockBuilding blockBuilding = new BlockBuilding();
blockBuilding.setBlockName(block);
blockBuilding.setGender(gender);
blockBuilding.setDescription(description);
blockBuilding.setStatus(status);
BlockController blockController = new BlockController();
bool i = blockController.AddBlock(blockBuilding);
if (i == true)
{
MessageBox.Show("Block has been added Successfully");
txtBlockName.Text = "";
txtGender.Text = "";
txtDescription.Text = "";
txtStatus.Text = "";
}
else
{
MessageBox.Show("Block has not been added");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string search = txtSearch.Text;
BlockController blockController = new BlockController();
BlockBuilding block = blockController.SearchBlock(search);
txtBlockId.Text = block.getBlockId();
txtBlockName.Text = block.getBlockName();
txtGender.Text = block.getGender();
txtDescription.Text = block.getDescription();
txtStatus.Text = block.getStatus();
}
public static void LoadBuilding()
{
s_tblBlockBuildingMap = new Dictionary <int, BlockBuilding>();
SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("Townhouse");
while (reader.Read())
{
BlockBuilding addBuilding = new BlockBuilding();
addBuilding.mId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("ID")));
addBuilding.mDoodadProtoId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("PrototypeDoodad_Id")));
addBuilding.mPath = reader.GetString(reader.GetOrdinal("FilePath"));
addBuilding.mNpcIdPosRotStand = reader.GetString(reader.GetOrdinal("NPCId_Num_Stand"));
addBuilding.mNpcIdPosRotMove = reader.GetString(reader.GetOrdinal("NPCId_Num_Move"));
string sizeString = reader.GetString(reader.GetOrdinal("Size"));
string[] sizeStrs = sizeString.Split(',');
addBuilding.mSize = new Vector2(float.Parse(sizeStrs[0]), float.Parse(sizeStrs[1]));
s_tblBlockBuildingMap[addBuilding.mId] = addBuilding;
}
}
public void Init(BlockBuilding building, Block45CurMan perfab)
{
mBlockBuilding = building;
Vector3 size;
List <Vector3> npcPosition;
List <CreatItemInfo> itemList;
Dictionary <int, BuildingNpc> npcIdNum;
mBlockBuilding.GetBuildingInfo(out size, out mBlocks, out npcPosition, out itemList, out npcIdNum);
BoxCollider col = gameObject.AddComponent <BoxCollider>();
col.center = 0.5f * size + 0.5f * Vector3.up;
col.size = size;
mB45Building = Instantiate(perfab) as Block45CurMan;
mB45Building.transform.parent = transform;
mB45Building.transform.localPosition = Vector3.zero;
mB45Building.transform.localRotation = Quaternion.identity;
mB45Building.transform.localScale = Vector3.one;
Invoke("BuildBuilding", 0.5f);
foreach (CreatItemInfo item in itemList)
{
ItemProto itemData = ItemProto.GetItemData(item.mItemId);
// AssetBundleReq req = AssetBundlesMan.Instance.AddReq(itemData.m_ModelPath, Vector3.zero, Quaternion.identity);
// req.ReqFinishWithReqHandler += OnSpawned;
// mReqList[req] = item;
GameObject go = Instantiate(Resources.Load(itemData.resourcePath)) as GameObject;
go.transform.parent = transform;
go.transform.transform.localPosition = item.mPos;
go.transform.transform.localRotation = item.mRotation;
go.transform.transform.localScale = Vector3.one;
}
}
public void InitEdit()
{
mIsActive = true;
if (mPerfab == null)
{
mPerfab = Block45CurMan.self;
}
for (int i = 0; i < mTownDataList.Count; i++)
{
BlockBuilding building = BlockBuilding.GetBuilding(mTownDataList[i].mBuildingId);
GameObject editObj = new GameObject();
editObj.name = "EditBuilding";
editObj.transform.position = mTownDataList[i].mPosition;
editObj.transform.rotation = Quaternion.Euler(0, mTownDataList[i].mRot * 90, 0);
editObj.transform.localScale = Vector3.one;
EditBuilding editBuilding = editObj.AddComponent <EditBuilding>();
editBuilding.Init(building, mPerfab);
mEditBuildingList.Add(editBuilding);
}
}
public Boolean AddBlock(BlockBuilding block)
{
Boolean userAdded = false;
string query = "insert into tblblock (name, gender, description,status)" +
"values ('" + block.getBlockName() + "', '" + block.getGender() + "', '" + block.getDescription() + "', '" + block.getStatus() + "')";
try
{
databaseConnection.Open();
commandDatabase = new MySqlCommand(query, databaseConnection);
int affectedRows = commandDatabase.ExecuteNonQuery();
if (affectedRows > 0)
{
userAdded = true;
}
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Query Error : " + ex.Message);
}
return(userAdded);
}
public void OnCreateBuilding(string fileName)
{
if (mPerfab == null)
{
mPerfab = Block45CurMan.self;
}
BlockBuilding building = BlockBuilding.GetBuilding(fileName);
GameObject editObj = new GameObject();
editObj.name = "EditBuilding";
editObj.transform.position = Vector3.zero;
editObj.transform.rotation = Quaternion.identity;
editObj.transform.localScale = Vector3.one;
EditBuilding editBuilding = editObj.AddComponent <EditBuilding>();
editBuilding.Init(building, mPerfab);
mEditBuildingList.Add(editBuilding);
OnBuildingSelected(editBuilding);
mDragMode = true;
}
public void RenderPrefebBuilding(VABuildingInfo buildinginfo)
{
int bid = buildinginfo.id;
Quaternion rotation = Quaternion.Euler(0, buildinginfo.rotation, 0);
if (PeGameMgr.IsSingleAdventure)
{
if (buildinginfo.buildingId.buildingNo != VArtifactTownConstant.NATIVE_TOWER_BUILDING_ID)
{
if (!BlockBuilding.s_tblBlockBuildingMap.ContainsKey(bid))
{
LogManager.Error("bid = [", bid, "] not exist in database!");
return;
}
int campId = SceneDoodadDesc.c_neutralCamp;
int damageId = SceneDoodadDesc.c_neutralDamage;
if (buildinginfo.vau.vat.type == VArtifactType.NpcTown)
{
if (!buildinginfo.vau.vat.IsPlayerTown)
{
if (bid == ColonyNoMgrMachine.DOODAD_ID_REPAIR || bid == ColonyNoMgrMachine.DOODAD_ID_SOLARPOWER)
{
return;
}
campId = AllyConstants.EnemyNpcCampId;
damageId = AllyConstants.EnemyNpcDamageId;
}
}
else
{
if (buildinginfo.vau.vat.nativeType == NativeType.Puja)
{
campId = AllyConstants.PujaCampId;
damageId = AllyConstants.PujaDamageId;
}
else
{
campId = AllyConstants.PajaCampId;
damageId = AllyConstants.PajaDamageId;
}
}
int playerId = VATownGenerator.Instance.GetPlayerId(buildinginfo.vau.vat.AllyId);
if (!buildinginfo.vau.isDoodadNpcRendered)
{
VArtifactTownManager.Instance.AddAliveBuilding(buildinginfo.vau.vat.townId,
DoodadEntityCreator.CreateRandTerDoodad(BlockBuilding.s_tblBlockBuildingMap[bid].mDoodadProtoId, buildinginfo.root, Vector3.one, rotation, buildinginfo.buildingId.townId, campId, damageId, playerId).Id);
}
//building npc
if (!mCreatedNpcBuildingID.ContainsKey(buildinginfo.buildingId))
{
BlockBuilding building = BlockBuilding.s_tblBlockBuildingMap[bid];
List <BuildingNpc> buildingNpcs;
building.GetNpcInfo(out buildingNpcs);
for (int bni = 0; bni < buildingNpcs.Count; bni++)
{
BuildingNpc bn = buildingNpcs[bni];
VArtifactUtil.GetPosRotFromPointRot(ref bn.pos, ref bn.rotY, buildinginfo.root, buildinginfo.rotation);
}
if (buildingNpcs != null && buildingNpcs.Count > 0)
{
if (buildinginfo.vau.vat.IsPlayerTown)
{
if (!buildinginfo.vau.isDoodadNpcRendered)
{
StartCoroutine(CreateBuildingNpcList(buildingNpcs));
mCreatedNpcBuildingID.Add(buildinginfo.buildingId, 0);
}
}
else
{
GenEnemyNpc(buildingNpcs, buildinginfo.vau.vat.townId, buildinginfo.vau.vat.AllyId);
}
}
}
}
else if (buildinginfo.buildingId.buildingNo == VArtifactTownConstant.NATIVE_TOWER_BUILDING_ID)
{
//tower
if (!buildinginfo.vau.isDoodadNpcRendered)
{
int playerId = VATownGenerator.Instance.GetPlayerId(buildinginfo.vau.vat.AllyId);
VArtifactTownManager.Instance.AddAliveBuilding(buildinginfo.vau.vat.townId,
DoodadEntityCreator.CreateRandTerDoodad(buildinginfo.pathID, buildinginfo.root, Vector3.one, rotation, buildinginfo.vau.vat.townId, buildinginfo.campID, buildinginfo.damageID, playerId).Id
);
}
}
if (missionBuilding.ContainsKey(0))
{
if (buildinginfo.buildingId != missionBuilding[0])
{
RemoveBuilding(buildinginfo.buildingId);
}
}
else
{
RemoveBuilding(buildinginfo.buildingId);
}
}
else if (PeGameMgr.IsMulti)
{
if (buildinginfo.buildingId.buildingNo != VArtifactTownConstant.NATIVE_TOWER_BUILDING_ID)
{
if (!BlockBuilding.s_tblBlockBuildingMap.ContainsKey(bid))
{
LogManager.Error("bid = [", bid, "] not exist in database!");
return;
}
Debug.Log("RenderPrefebBuilding():" + bid);
// int campId = SceneDoodadDesc.c_neutralCamp;
int campId = SceneDoodadDesc.c_neutralCamp;
int damageId = SceneDoodadDesc.c_neutralDamage;
if (buildinginfo.vau.vat.type == VArtifactType.NpcTown)
{
if (!buildinginfo.vau.vat.IsPlayerTown)
{
if (bid == ColonyNoMgrMachine.DOODAD_ID_REPAIR || bid == ColonyNoMgrMachine.DOODAD_ID_SOLARPOWER)
{
return;
}
campId = AllyConstants.EnemyNpcCampId;
damageId = AllyConstants.EnemyNpcDamageId;
}
}
else
{
if (buildinginfo.vau.vat.nativeType == NativeType.Puja)
{
campId = AllyConstants.PujaCampId;
damageId = AllyConstants.PujaDamageId;
}
else
{
campId = AllyConstants.PajaCampId;
damageId = AllyConstants.PajaDamageId;
}
}
int playerId = VATownGenerator.Instance.GetPlayerId(buildinginfo.vau.vat.AllyId);
if (!buildinginfo.vau.isDoodadNpcRendered)
{
PlayerNetwork.RequestServer(EPacketType.PT_Common_TownDoodad, buildinginfo.buildingId, BlockBuilding.s_tblBlockBuildingMap[bid].mDoodadProtoId, buildinginfo.root, Vector3.one, rotation, buildinginfo.vau.vat.townId, campId, damageId, playerId);
}
//building npc
if (!mCreatedNpcBuildingID.ContainsKey(buildinginfo.buildingId))
{
BlockBuilding building = BlockBuilding.s_tblBlockBuildingMap[bid];
List <BuildingNpc> buildingNpcs;
building.GetNpcInfo(out buildingNpcs);
for (int bni = 0; bni < buildingNpcs.Count; bni++)
{
BuildingNpc bn = buildingNpcs[bni];
VArtifactUtil.GetPosRotFromPointRot(ref bn.pos, ref bn.rotY, buildinginfo.root, buildinginfo.rotation);
}
if (buildingNpcs != null && buildingNpcs.Count > 0)
{
if (buildingNpcs != null && buildingNpcs.Count > 0)
{
if (buildinginfo.vau.vat.IsPlayerTown)
{
if (!buildinginfo.vau.isDoodadNpcRendered)
{
StartCoroutine(CreateBuildingNpcList(buildingNpcs));
mCreatedNpcBuildingID.Add(buildinginfo.buildingId, 0);
}
}
else
{
GenEnemyNpc(buildingNpcs, buildinginfo.vau.vat.townId, buildinginfo.vau.vat.AllyId);
}
}
}
}
}
else if (buildinginfo.buildingId.buildingNo == VArtifactTownConstant.NATIVE_TOWER_BUILDING_ID)
{
if (!buildinginfo.vau.isDoodadNpcRendered)
{
int playerId = VATownGenerator.Instance.GetPlayerId(buildinginfo.vau.vat.AllyId);
PlayerNetwork.RequestServer(EPacketType.PT_Common_NativeTowerCreate, buildinginfo.buildingId, buildinginfo.pathID, buildinginfo.root, Vector3.one, rotation, buildinginfo.vau.vat.townId, buildinginfo.campID, buildinginfo.damageID, playerId);
}
}
RemoveBuilding(buildinginfo.buildingId);
}
}
public static void LoadAllData()
{
if (s_localDatabase != null)
{
return;
}
#if UNITY_EDITOR
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();
#endif
s_localDatabase = LoadDb();
SkillSystem.SkData.LoadData();
Pathea.Effect.EffectData.LoadData();
Pathea.Projectile.ProjectileData.LoadData();
Pathea.RequestRelation.LoadData();
Pathea.CampData.LoadData();
Pathea.ThreatData.LoadData();
Pathea.DamageData.LoadData();
HumanSoundData.LoadData();
ItemDropData.LoadData();
PELocalization.LoadData();
NaturalResAsset.NaturalRes.LoadData();
//SkillAsset.EffCastData.LoadData();
//SkillAsset.EffSkill.LoadData();
//SkillAsset.MergeSkill.LoadData();
//AnimData.LoadData();
//AnimSoundData.LoadData();
AiAsset.AiData.LoadData();
SoundAsset.SESoundBuff.LoadData();
SoundAsset.SESoundStory.LoadData();
//CharacterData.LoadCharacterData();
StoryDoodadMap.LoadData();
StoreRepository.LoadData();
NpcMissionDataRepository.LoadData();
//PlayerAttribute.LoadData();
MissionRepository.LoadData();
TalkRespository.LoadData();
//NpcRandomRepository.LoadData();
ShopRespository.LoadData();
WareHouseManager.LoadData();
//HeroTalkRepository.LoadData();
MutiPlayRandRespository.LoadData();
PromptRepository.LoadData();
//MapIconData.LoadDate();
//MapMaskData.LoadDate();
CampPatrolData.LoadDate();
Camp.LoadData();
RepProcessor.LoadData();
CloudManager.LoadData();
//BattleUnitData.LoadData();
TutorialData.LoadData();
//RepairMachineManager.LoadData();
MapMaskData.LoadDate();
MessageData.LoadData(); //lz-2016.07.13 Add it
MonsterHandbookData.LoadData(); //lz-2016.07.20 Add it
StoryRepository.LoadData();
RMRepository.LoadRandMission();
MisInitRepository.LoadData();
CameraRepository.LoadCameraPlot();
AdRMRepository.LoadData();
VCConfig.InitConfig();
Cutscene.LoadData();
// BuildBrushData.LoadBrush();
BSPattern.LoadBrush();
BSVoxelMatMap.Load();
BSBlockMatMap.Load();
BlockBuilding.LoadBuilding();
LifeFormRule.LoadData();
PlantInfo.LoadData();
MetalScanData.LoadData();
BattleConstData.LoadData();
CustomCharactor.CustomMetaData.LoadData();
SkillTreeInfo.LoadData();
VArtifactUtil.LoadData();
Pathea.ActionRelationData.LoadActionRelation();
//colony
CSInfoMgr.LoadData();
ProcessingObjInfo.LoadData();
CSTradeInfoData.LoadData();
CampTradeIdData.LoadData();
AbnormalTypeTreatData.LoadData();
CSMedicineSupport.LoadData();
//RandomItemMgr
RandomItemDataMgr.LoadData();
FecesData.LoadData();
//randomdungeon
RandomDungeonDataBase.LoadData();
AbnormalData.LoadData();
PEAbnormalNoticeData.LoadData();
RelationInfo.LoadData();
EquipSetData.LoadData();
SuitSetData.LoadData();
CheatData.LoadData();
Pathea.NpcProtoDb.Load();
Pathea.MonsterProtoDb.Load();
Pathea.MonsterRandomDb.Load();
Pathea.MonsterGroupProtoDb.Load();
Pathea.RandomNpcDb.Load();
Pathea.PlayerProtoDb.Load();
Pathea.TowerProtoDb.Load();
Pathea.DoodadProtoDb.Load();
Pathea.AttPlusNPCData.Load();
Pathea.AttPlusBuffDb.Load();
Pathea.NpcTypeDb.Load();
Pathea.NpcRandomTalkDb.Load();
Pathea.NpcThinkDb.LoadData();
Pathea.NpcEatDb.LoadData();
Pathea.NpcRobotDb.Load();
Pathea.NPCScheduleData.Load();
Pathea.NpcVoiceDb.LoadData();
InGameAidData.LoadData(); //lz-2016.08.21 add it
MountsSkillDb.LoadData();
#if UNITY_EDITOR
sw.Stop();
Debug.Log("Database Loaded : " + sw.ElapsedMilliseconds);
sw.Reset();
#else
Debug.Log("Database Loaded");
#endif
}
