public ST_S_PlayerWeaponRec[] GetList_weapon_all_where_idx(int a_idx)
{
if (_db == null)
{
_db = new SQLiteDB();
}
// ST_S_PlayerWeaponRec rec;
List <ST_S_PlayerWeaponRec> rtnlist = new List <ST_S_PlayerWeaponRec>();
string filename = GetFileName_DB();
try
{
_db.Open(filename);
SQLiteQuery qr;
string strsql = string.Format(_querySelect_all_where_idx, a_idx); //
qr = new SQLiteQuery(_db, strsql);
while (qr.Step())
{
ST_S_PlayerWeaponRec rec = new ST_S_PlayerWeaponRec();
// idx, hero_ix, slot_no, weapon_datacode, up_level, up_dur, up_attack, up_critical_ratio
rec.idx = qr.GetInteger("idx");
rec.hero_ix = qr.GetInteger("hero_ix");
rec.slot_no = qr.GetInteger("slot_no");
rec.weapon_datacode = qr.GetString("weapon_datacode");
rec.up_level = qr.GetInteger("up_level");
rec.up_dur = qr.GetInteger("up_dur");
rec.up_attack = qr.GetInteger("up_attack");
rec.up_critical_ratio = (float)qr.GetDouble("up_critical_ratio");
rec.upgrade_limit = qr.GetInteger("upgrade_limit");
rec.up_attack_speed = (float)qr.GetDouble("up_attack_speed");
rec.class_no = qr.GetInteger("class_no");
rec.count = qr.GetInteger("count");
rtnlist.Add(rec);
}
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return(rtnlist.ToArray());
}
public void Update_all_where_idx(
int a_idx,
ST_S_PlayerWeaponRec rec
)
{
if (_db == null)
{
_db = new SQLiteDB();
}
try
{
_db.Open(GetFileName_DB());
SQLiteQuery qr;
string strsql = string.Format(_queryUpdate_all_where_idx, a_idx); //
qr = new SQLiteQuery(_db, strsql);
qr.Bind(rec.slot_no);
qr.Bind(rec.weapon_datacode);
qr.Bind(rec.up_level);
qr.Bind(rec.up_dur);
qr.Bind(rec.up_attack);
qr.Bind(rec.up_critical_ratio);
qr.Bind(rec.upgrade_limit);
qr.Bind(rec.up_attack_speed);
qr.Bind(rec.class_no);
qr.Bind(rec.count);
qr.Step();
qr.Release();
_db.Close();
}
catch (Exception e)
{
if (_db != null)
{
_db.Close();
}
UnityEngine.Debug.LogError(e.ToString());
}
return;
}
