private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
TrophyNode t = (TrophyNode)listBox1.SelectedItem;
this.labelName.Text = t.Name;
switch (t.TType)
{
case "B":
this.labelTType.Text = "Bronze";
break;
case "S":
this.labelTType.Text = "Silver";
break;
case "G":
this.labelTType.Text = "Gold";
break;
case "P":
this.labelTType.Text = "Platinum";
break;
default:
this.labelTType.Text = t.TType;
break;
}
this.labelDescription.Text = t.Detail;
if (t.Hidden)
{
this.labelHidden.Text = "Hidden";
}
else
{
this.labelHidden.Text = "Visible";
}
this.labelTrophyID.Text = t.ID;
TropUsrSingleTrophy u = TrophyFile.TropUsrFile.TrophyInfos[UInt32.Parse(t.ID)];
if (u.Unlocked == 1)
{
this.labelUnlocked.Text = "Acquired";
this.labelTimestamp.Text = Util.PS3TimeToDateTime(u.Timestamp1).ToString();
this.labelTimestamp2.Text = Util.PS3TimeToDateTime(u.Timestamp2).ToString();
}
else
{
this.labelUnlocked.Text = "Locked";
this.labelTimestamp.Text = "";
this.labelTimestamp2.Text = "";
}
}
public static List <TrophyNode> GetSQL(String ConnectionString, String GracesJapaneseConnectionString)
{
//List<ScenarioFile> Trophies = new List<TrophyNode>();
Dictionary <string, TrophyNode> Trophies = new Dictionary <string, TrophyNode>();
SQLiteConnection Connection = new SQLiteConnection(ConnectionString);
Connection.Open();
using (SQLiteTransaction Transaction = Connection.BeginTransaction())
using (SQLiteCommand Command = new SQLiteCommand(Connection)) {
Command.CommandText =
"SELECT english, PointerRef, StringID, t_id, t_hidden, t_ttype, t_pid FROM Text ORDER BY ID";
SQLiteDataReader r = Command.ExecuteReader();
while (r.Read())
{
String SQLText;
String T_ID;
bool T_Hidden;
String T_TType;
String T_PID;
try {
SQLText = r.GetString(0).Replace("''", "'");
T_ID = r.GetString(3);
T_Hidden = r.GetInt32(4) == 1;
T_TType = r.GetString(5);
T_PID = r.GetString(6);
} catch (System.InvalidCastException) {
SQLText = null;
T_ID = null;
T_Hidden = false;
T_TType = null;
T_PID = null;
}
int PointerRef = r.GetInt32(1);
int StringID = r.GetInt32(2);
if (Trophies.ContainsKey(T_ID))
{
if (PointerRef == 0)
{
Trophies[T_ID].Name = SQLText;
}
else if (PointerRef == 1)
{
Trophies[T_ID].Detail = SQLText;
}
}
else
{
String Name = null;
String Detail = null;
if (PointerRef == 0)
{
Name = SQLText;
}
else if (PointerRef == 1)
{
Detail = SQLText;
}
TrophyNode Trophy = new TrophyNode(T_ID, T_Hidden, T_TType, T_PID, Name, Detail, null);
Trophies[T_ID] = Trophy;
}
}
Transaction.Rollback();
}
Connection.Close();
return(Trophies.Values.ToList());
}
protected override void OnDrawItem(DrawItemEventArgs e)
{
// Make sure we're not trying to draw something that isn't there.
if (e.Index >= this.Items.Count || e.Index <= -1)
{
return;
}
// Get the item object.
object item = this.Items[e.Index];
if (item == null)
{
return;
}
// Draw the item.
if (IsGameList)
{
if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
{
e.Graphics.FillRectangle(new SolidBrush(Color.LightBlue), e.Bounds);
}
else
{
e.Graphics.FillRectangle(new SolidBrush(Color.White), e.Bounds);
}
TrophyConfNode tc = (TrophyConfNode)item;
e.Graphics.DrawImage(tc.GameThumbnail, 0, e.Bounds.Y, 160, 88);
string text = tc.TitleName;
SizeF stringSize = e.Graphics.MeasureString(text, this.Font);
e.Graphics.DrawString(text, this.Font, new SolidBrush(Color.Black),
new PointF(163, e.Bounds.Y + (e.Bounds.Height - stringSize.Height) / 2));
}
else
{
TrophyNode t = (TrophyNode)item;
if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
{
e.Graphics.FillRectangle(new SolidBrush(Color.LightBlue), e.Bounds);
}
else
{
if (CurrentGame.TropUsrFile.TrophyInfos[UInt32.Parse(t.ID)].Unlocked == 1)
{
e.Graphics.FillRectangle(new SolidBrush(Color.LightGreen), e.Bounds);
}
else
{
e.Graphics.FillRectangle(new SolidBrush(Color.White), e.Bounds);
}
}
e.Graphics.DrawImage(t.TrophyThumbnail, 0, e.Bounds.Y, 60, 60);
string text = item.ToString();
SizeF stringSize = e.Graphics.MeasureString(text, this.Font);
e.Graphics.DrawString(text, this.Font, new SolidBrush(Color.Black),
new PointF(63, e.Bounds.Y + (e.Bounds.Height - stringSize.Height) / 2));
}
}
