public static void Login(MySqlConnection conn, Client c, int id)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT id, first_name, last_name FROM characters WHERE account_id = @a_id";
cmd.Parameters.AddWithValue("@a_id", id);
MySqlDataReader reader = cmd.ExecuteReader();
//List< Tuple <int, string, string>> chars = new List <Tuple<int, string, string>> { };
List <CharacterObj> chars = new List <CharacterObj> {
};
while (reader.Read())
{
CharacterObj characterObj = new CharacterObj();
characterObj.id = reader.GetInt32("id");
characterObj.firstName = reader.GetString("first_name");
characterObj.lastName = reader.GetString("last_name");
chars.Add(characterObj);
}
c.SetData("account_id", id);
c.SendNotification("~g~Erfolgreich eingeloggt!");
c.TriggerEvent("LoginSuccess", chars);
reader.Close();
}
public static void Login(MySqlConnection conn, Player c, int id)
{
c.SetData("account_id", id);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT id, first_name, last_name FROM characters WHERE account_id = @a_id";
cmd.Parameters.AddWithValue("@a_id", id);
MySqlDataReader reader = cmd.ExecuteReader();
List <CharacterObj> chars = new List <CharacterObj> {
};
while (reader.Read())
{
CharacterObj characterObj = new CharacterObj
{
id = reader.GetInt32("id"),
firstName = reader.GetString("first_name"),
lastName = reader.GetString("last_name")
};
chars.Add(characterObj);
}
reader.Close();
c.TriggerEvent("LoginSuccess", chars);
}
public static void Create()
{
CharacterObj asset = ScriptableObject.CreateInstance <CharacterObj>();
AssetDatabase.CreateAsset(asset, "Assets/Resources/Characters/NewChar.asset");
AssetDatabase.SaveAssets();
EditorUtility.FocusProjectWindow();
Selection.activeObject = asset;
}
void OnTriggerEnter2D(Collider2D other)
{
CharacterObj charObj = other.GetComponent <CharacterObj>();
if (charObj != null && !targets.Contains(charObj.character))
{
targets.Add(charObj.character);
}
}
public void AssignCharacter(CharacterObj obj)
{
//if passed in a null, we are reseting current character
//else we are changing character.
if (currentCharacter != null)
{
currentCharacter.Reset();
manager.SetTeamCharacter(currentCharacter.GetCharacter(), false);
}
currentCharacter = obj;
if (currentCharacter != null)
{
manager.SetTeamCharacter(currentCharacter.GetCharacter(), true);
}
}
public void AddTeamCharacter(Character character, CharacterObj obj)
{
foreach (TeamRosterSlot slot in teamSlots)
{
if (slot.GetCharacter() == character)
{
return;
}
}
foreach (TeamRosterSlot slot in teamSlots)
{
if (slot.GetCharacter() == null)
{
slot.AssignCharacter(obj);
}
}
}
