public void createButton()
    {
        string nick = GameObject.Find ("Canvas/CreatePanel/NickInput/Text").GetComponent<Text> ().text;

        if (nick.Length < 3 || Service.db.SelectCount ("FROM characters WHERE name = ?", nick) != 0) {
            return;
        }

        int inicialHealth = 270;
        int inicialMana = 130;

        CharacterData character = new CharacterData
        {
            name = nick,
            model = "male_01",
            position = "",
            level = 1,
            health = inicialHealth,
            maxHealth = inicialHealth,
            mana = inicialMana,
            maxMana = inicialMana,
            money = 234670,
            id = Service.db.Id(1)
        };
        bool sucess = character.create();

        if (sucess) {
            Menu.Instance.showPanel("MainPanel");
        } else {
            Debug.Log("Something went wrong");
        }
    }

    public void AddBlocks(bool[] blocks, CharacterData characterData)
    {
        var eyeInBadCondition = manager.GetEyeRoom().GetScoreNegative();

        for (var i = 0; i < blocks.Length; i++)
        {
            if (blocks[i])
            {
                /*
                 * Check if we have enough spare blocks in the queue
                 * otherwise we'll need to make some more.
                 */
                if (_blockQueue.Count == 0)
                    QueueUpNewBarBlocks(3);

                var block = _blockQueue.Dequeue();
                block.characterData = characterData;

                //  Chance to be bad
                if (-eyeInBadCondition > Random.Range(0.0f, 1.0f))
                    block.newColor = Color.white;

                _blocksToAdd.Enqueue(block);

            }
            else
            {
                //  We add null here so that we can use it as a placeholder for
                //  an empty block in the column.
                _blocksToAdd.Enqueue(null);
            }
        }
    }

 public void InitEntry(int index)
 {
     if (index < enemies.Count)
         enemies[index] = new CharacterData();
     else
         Debug.Log("index does not exist!");
 }

 void SetupRenderer(CharacterData data)
 {
     CharacterView = data.CharacterView.Instantiate();
     CharacterView.name = "Skeleton";
     CharacterView.transform.SetParent(transform, false);
     CharacterView.transform.localPosition = Vector3.zero;
 }

	public CharacterData getClone ()
	{
		CharacterData characterToReturn = new CharacterData ( myID, name, position[0], position[1], characterValues[CHARACTER_ACTION_TYPE_POWER], characterValues[CHARACTER_ACTION_TYPE_DAMAGE],
			characterValues[CHARACTER_ACTION_TYPE_RANGE], characterValues[CHARACTER_ACTION_TYPE_AREA], characterValues[CHARACTER_ACTION_TYPE_ATTACK_RATE], characterValues[CHARACTER_ACTION_TYPE_BUILD_RATE],
			characterValues[CHARACTER_ACTION_TYPE_DEMOLISH_RATE], characterValues[CHARACTER_ACTION_TYPE_RAPAIR_RATE], characterValues[CHARACTER_ACTION_TYPE_RESCUING] );
		
		return characterToReturn;
	}

 public override void Awake()
 {
     base.Awake();
     atkAnimKeyFrame = 14;
     CharacterData tempData = new CharacterData(new Hashtable(){{"type","pet"},{"hp",1000},{"mspd",170},{"aspd",0},{"atk",0},{"def",30},{"rewardCoins",0},{"rewardExp",0},{"cstk",0},{"evd",0},{"stk",0}});
     initData(tempData);
     hideHpBar();
 }

 public static GameObject createEnemyByType(string type, Vector3 pos)
 {
     GameObject pref = CacheMgr.getEnemyPrb (type) as GameObject;//Resources.Load("enemies/enemy"+type);
     GameObject enemyObj = Instantiate (pref, pos, new Quaternion (0, 0, 0, 0)) as GameObject;
     Enemy enemyDoc = enemyObj.GetComponent<Enemy> ();
     CharacterData characterD = new CharacterData (EnemyDataLib.instance [type] as Hashtable);
     enemyDoc.initData (characterD);
     return enemyObj;
 }

 private void wizardPageContainer1_Finished(object sender, EventArgs e)
 {
     CharacterData cd = new CharacterData();
     if (this.comboBox1.SelectedIndex == 0) cd.isMale = true;
     else cd.isMale = false;
     cd.Name = this.textBox1.Text;
     Plr = cd;
     Close();
 }

	public static Character Create(CharacterData character)
	{
		var go = GameObject.Instantiate(PrefabSettings.main.characterDisplayPrefab);
		go.name = character.name;

		var component = go.GetComponent<Character>();
		component.characterData = character;

		return component;
	}

	public static SingleGoalDisplay Create(CharacterData goalCharacter)
	{
		var go = GameObject.Instantiate(PrefabSettings.main.singleGoalDisplayPrefab);
		go.name = goalCharacter.name;

		var component = go.GetComponent<SingleGoalDisplay>();
		component.goalCharacter = goalCharacter;

		return component;
	}

	private void Awake ()
	{
		if (GetComponent<PlayerInput> () != null) {
			isPlayer = true;
		}

		_characterData = gameObject.GetComponent<CharacterData> ();
		GetComponent<Animation> ().Play ();
		SetMouth (Random.Range (1, 3));
	}

    private void OnClickChCard(CharacterData chData)
    {
        GameObject sceneToSceneData = GameObject.Find("SceneToScene_datas");
        sceneToSceneData.GetComponent<SceneToScene_Data>().gameChDatas.Clear();
        sceneToSceneData.GetComponent<SceneToScene_Data>().gameChDatas.Add("chName", chData.chName);
        sceneToSceneData.GetComponent<SceneToScene_Data>().gameChDatas.Add("chLevel", chData.chLevel.ToString());
        sceneToSceneData.GetComponent<SceneToScene_Data>().gameChDatas.Add("chType", chData.chType);
        sceneToSceneData.GetComponent<SceneToScene_Data>().gameChDatas.Add("detailScript", chData.detailScript);

        SceneManager.LoadSceneAsync("popup_chInfo", LoadSceneMode.Additive);
    }

 public override void Awake()
 {
     base.Awake();
     //		id = EnemyMgr.getID();
     //		EnemyMgr.enemyHash[id] = this;
     atkAnimKeyFrame = 13;
     CharacterData characterD = new CharacterData(new Hashtable(){{"type","freezeGuyEft"},{ "hp",500},{ "mspd",0},{ "aspd",0},{ "atk",0},{ "def",0},{ "rewardCoins",0},{ "rewardExp",0},{ "cstk",0},{ "evd",0},{ "stk",0}});
     initData(characterD);
     this.hpBar.hideHpBar();
     //		MsgCenter.instance.addListener(MsgCenter.FREEZE_DEAD, heroDead);
 }

    void Start()
    {
        db = GlobalVars.database;

        db.AddCharacter(new CharacterData("You"));

        CharacterData cd = new CharacterData("Sally");
        cd.AddTopic(new TopicData("Cookies",topic));
        cd.AddAvaliableTopic(0);
        db.AddCharacter(cd);
    }

    // Use this for initialization
    void Start()
    {
        Team = GameObject.Find("GameControlCenter").GetComponent<CharacterTeam> ();
        enTeam = GameObject.Find("EnemyTeam").GetComponent<CharacterTeam> ();
        chDT = GameObject.Find ("GameControlCenter").GetComponent<CharacterData> ();

        for (int i=0; i<chDT.character.Count; i++)
            if (chDT.character[i].chID == ID) {
            ch = i;
            break;
        }
    }

    void Start()
    {
        this.characterData = new CharacterData(new AttackAttribute(this.attackDefaultValue.value, this.attackDefaultValue.multiplier),
                                           new DefenseAttribute(this.defenseDefaultValue.value, this.defenseDefaultValue.multiplier),
                                           new SpeedAttribute(this.speedDefaultValue.value, this.speedDefaultValue.multiplier),
                                           new HealthAttribute(this.healthDefaultValue.value, this.healthDefaultValue.multiplier));

        this.unitID = new UnitIdentity(this.unitName);
        this.PrintCharacterStats();

        EventBroadcaster.Instance.PostEvent(EventNames.ON_UNIT_INITIALIZE_SUCCESS);
    }

	public void handleDemolish ( CharacterData characterToBuild, bool onlyUnblocking = false )
	{
		if ( onlyUnblocking )
		{
			_alreadyTouched = false;
			return;
		}
		if(characterToBuild.myID == 40)
		{
			SoundManager.getInstance ().playSound ( SoundManager.DESTROYABLE_DEMOLISH, _myIComponent.myID );
		}
		StartCoroutine ( "startBuildProcedure", characterToBuild );
	}

 public override void initData(CharacterData characterD)
 {
     base.initData (characterD);
     HeroData heroD = this.data as HeroData;
     Hashtable passive1 =  heroD.getPSkillByID("DRAX25");
     if(passive1 != null)
     {
         SkillDef skillDef = SkillLib.instance.getSkillDefBySkillID("DRAX25");
         int uValue = (int)skillDef.passiveEffectTable["universal"];
         autoRegenHpValue = uValue;
         if(!IsInvoking("autoRegenHp"))InvokeRepeating("autoRegenHp", 0, 1.0f);
     }
 }

 public void InsertCharacter(CharacterData data)
 {
     try
     {
         lock (DataAccess.DatabaseAccess)
             using (var comm = DataAccess.DatabaseAccess.CreateCommand(String.Format("INSERT INTO `character` ({0}) VALUES ({1})", CharacterData.GetQueryString(), data.GetInsertString())))
                 comm.ExecuteNonQuery();
     }
     catch (Exception e)
     {
         Logger.WriteLog("Exception in InsertCharacter! Exception: {0}", LogType.Error, e);
     }
 }

    public static Dictionary<int, CharacterData> Load(string fileName)
    {
        Dictionary<int, CharacterData> table = new Dictionary<int, CharacterData>();

        // 텍스트 테이블 읽어 들임
        XmlDocument xmlFile = new XmlDocument();
        xmlFile.PreserveWhitespace = false;
        try
        {
            TextAsset textAsset = (TextAsset)Resources.Load("XML/" + fileName, typeof(TextAsset));
            xmlFile.LoadXml(textAsset.text);
        }
        catch (Exception e)
        {
            return null;
        }

        XmlNodeList allData = xmlFile.ChildNodes;
        foreach (XmlNode mainNode in allData)
        {
            if (mainNode.Name.Equals("Data") == true)
            {
                XmlNodeList childNodeList = mainNode.ChildNodes;
                foreach (XmlNode node in childNodeList)
                {
                    CharacterData tableData = new CharacterData();

                    tableData.Index = Int32.Parse(node.Attributes.GetNamedItem("Index").Value);
                    tableData.Name = String.Copy(node.Attributes.GetNamedItem("Name").Value);
                    tableData.ResourceName = String.Copy(node.Attributes.GetNamedItem("ResourceName").Value);

                    tableData.Attribute = Int32.Parse(node.Attributes.GetNamedItem("Attribute").Value);
                    tableData.HealthPoint = Int32.Parse(node.Attributes.GetNamedItem("HealthPoint").Value);
                    tableData.ManaPoint = Int32.Parse(node.Attributes.GetNamedItem("ManaPoint").Value);
                    tableData.DefensePoint = Int32.Parse(node.Attributes.GetNamedItem("DefensePoint").Value);
                    tableData.AttackPoint = Int32.Parse(node.Attributes.GetNamedItem("AttackPoint").Value);
                    tableData.Speed = Int32.Parse(node.Attributes.GetNamedItem("Speed").Value);

                    tableData.BulletIndex = Int32.Parse(node.Attributes.GetNamedItem("BulletIndex").Value);

                    tableData.SkillIndex = Int32.Parse(node.Attributes.GetNamedItem("SkillIndex").Value);
                    tableData.SkillName = String.Copy(node.Attributes.GetNamedItem("SkillName").Value);
                    tableData.SkillDesc = String.Copy(node.Attributes.GetNamedItem("SkillDesc").Value);
                    tableData.SkillManaCost = Int32.Parse(node.Attributes.GetNamedItem("SkillManaCost").Value);

                    table.Add(tableData.Index, tableData);
                }
            }
        }
        return table;
    }