public static void Init(string absolutePath="cards.cdb")
{
m_cards = new Dictionary<int, Card>();
using(SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath)){
connection.Open();
using(SQLiteCommand command = new SQLiteCommand("SELECT datas.id, ot, alias, "
+"setcode, type, level, race, attribute, atk, def ,"
+" name , desc FROM datas,texts WHERE datas.id=texts.id",
connection)){
using(SQLiteDataReader reader = command.ExecuteReader()){
while (reader.Read())
{
int id = reader.GetInt32(0);
int ot = reader.GetInt32(1);
int levelinfo = reader.GetInt32(5);
int level = levelinfo & 0xff;
int lscale = (levelinfo >> 24) & 0xff;
int rscale = (levelinfo >> 16) & 0xff;
Card.CardData data = new Card.CardData
{
Code = id,
Alias = reader.GetInt32(2),
Setcode = reader.GetInt64(3),
Type = reader.GetInt32(4),
Level = level,
LScale = lscale,
RScale = rscale,
Race = reader.GetInt32(6),
Attribute = reader.GetInt32(7),
Attack = reader.GetInt32(8),
Defense = reader.GetInt32(9)
};
string name=reader.GetString(10);
string desc=reader.GetString(11);
m_cards.Add(id, new Card(data, ot, name, desc));
}
reader.Close();
}
}
connection.Close();
}
}
public static void Init(string absolutePath = "cards.cdb")
{
m_cards = new Dictionary <int, Card>();
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath)){
connection.Open();
using (SQLiteCommand command = new SQLiteCommand("SELECT datas.id, ot, alias, "
+ "setcode, type, level, race, attribute, atk, def ,"
+ " name , desc FROM datas,texts WHERE datas.id=texts.id",
connection)){
using (SQLiteDataReader reader = command.ExecuteReader()){
while (reader.Read())
{
int id = reader.GetInt32(0);
int ot = reader.GetInt32(1);
int levelinfo = reader.GetInt32(5);
int level = levelinfo & 0xff;
int lscale = (levelinfo >> 24) & 0xff;
int rscale = (levelinfo >> 16) & 0xff;
Card.CardData data = new Card.CardData
{
Code = id,
Alias = reader.GetInt32(2),
Setcode = reader.GetInt64(3),
Type = reader.GetInt32(4),
Level = level,
LScale = lscale,
RScale = rscale,
Race = reader.GetInt32(6),
Attribute = reader.GetInt32(7),
Attack = reader.GetInt32(8),
Defense = reader.GetInt32(9)
};
string name = reader.GetString(10);
string desc = reader.GetString(11);
m_cards.Add(id, new Card(data, ot, name, desc));
}
reader.Close();
}
}
connection.Close();
}
}
internal static void Init()
{
m_cards = new Dictionary<int, Card>();
string absolutePath = PathManager.GetCardsDb();
SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath);
connection.Open();
SQLiteCommand command = new SQLiteCommand("SELECT id, ot, alias, setcode, type, level, race, attribute, atk, def FROM datas", connection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
int ot = reader.GetInt32(1);
int levelinfo = reader.GetInt32(5);
int level = levelinfo & 0xff;
int lscale = (levelinfo >> 24) & 0xff;
int rscale = (levelinfo >> 16) & 0xff;
Card.CardData data = new Card.CardData
{
Code = id,
Alias = reader.GetInt32(2),
Setcode = reader.GetInt64(3),
Type = reader.GetInt32(4),
Level = level,
LScale = lscale,
RScale = rscale,
Race = reader.GetInt32(6),
Attribute = reader.GetInt32(7),
Attack = reader.GetInt32(8),
Defense = reader.GetInt32(9)
};
m_cards.Add(id, new Card(data, ot));
}
reader.Close();
connection.Close();
}
