private void SettingsForm_Load(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "Select * from settings;";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows)
{
switch (r["variable"].ToString())
{
case "opacity":
this.opacityChanger.Value = Convert.ToInt32(r["value"].ToString());
break;
case "actionwait":
this.actionWaitChanger.Value = Convert.ToInt32(r["value"].ToString());
break;
case "hotkeysenabled":
this.hotkeysCheckbox.Checked = Convert.ToBoolean(r["value"].ToString());
break;
}
}
}
private void ChangeJob()
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
IntPtr ffHandle = NativeImports.FindWindow("RAPTURE", "FINAL FANTASY XIV");
if (ffHandle == IntPtr.Zero) {
MessageBox.Show("Final Fantasy is not running.");
return;
}
String query =
String.Format("select position, value from buttons where position = 'mh' " +
"and button_name = '{0}';", Name);
settings = db.GetDataTable(query);
if (settings.Rows.Count <= 0)
return;
if (settings.Rows[0]["value"].ToString().Trim() == "") {
db.Delete("buttons", String.Format("button_name = \"{0}\"", Name));
return;
}
ToggleButtonStates();
SendMessage(ffHandle, String.Format("/equip mh \"{0}\"", settings.Rows[0]["value"].ToString()));
if (use_job) {
SendMessage(ffHandle, "/job on");
Thread.Sleep(Math.Max(owner.actionWait * 3, 1000));
}
else {
SendMessage(ffHandle, "/job off");
}
query = "select position, value from buttons where button_name = '" + Name +
"' and position != 'mh';";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows) {
String gearName = "";
if (r["value"].ToString().Trim() == "")
continue;
if (r["value"].ToString().Trim().ToLower() == "none") {
gearName = "";
}
else {
gearName = r["value"].ToString();
}
String equip = String.Format("/equip {0} \"{1}\"", r["position"], gearName);
SendMessage(ffHandle, equip);
if (r["position"].ToString() == "L.ring")
Thread.Sleep(Math.Max(owner.actionWait * 3, 1000));
else
Thread.Sleep(owner.actionWait);
}
ToggleButtonStates();
}
public void LoadSettings()
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "select * from button_labels where button_name = \"" + Name + "\";";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows) {
Text = r["button_label"].ToString();
use_job = Convert.ToBoolean(r["use_job"].ToString());
}
}
public void LoadSettings()
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "select * from button_labels where button_name = \"" + Name + "\";";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows)
{
Text = r["button_label"].ToString();
use_job = Convert.ToBoolean(r["use_job"].ToString());
}
}
private void MainForm_Load(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "Select * from settings;";
settings = db.GetDataTable(query);
int x = 0, y = 0;
foreach (DataRow r in settings.Rows) {
switch (r["variable"].ToString()) {
case "opacity":
this.Opacity = Convert.ToDouble(r["value"].ToString()) / 100;
break;
case "locationX":
x = Convert.ToInt32(r["value"].ToString());
break;
case "locationY":
y = Convert.ToInt32(r["value"].ToString());
break;
case "actionwait":
this.actionWait = Convert.ToInt16(r["value"].ToString());
break;
case "hotkeysenabled":
this.hotkeysEnabled = Convert.ToBoolean(r["value"].ToString());
break;
}
}
this.Location = new Point(x, y);
this.Refresh();
// Create all the job buttons
sf = new SettingsForm(this);
jcf = new JobConfigureForm();
this.pictureBox1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.Form1_MouseDown);
sf.ItemDataChanged += new ItemDataChangedHandler(jcf.LoadItemData);
Point point = new Point(0, 10);
for (int i = 0; i < 20; i++) {
JobButton b = new JobButton(this);
if ((i > 0) && ((i % 10) == 0)) {
point.Y += 20;
point.X = 0;
}
else if (i > 0) {
point.X += 34;
}
b.Font = new System.Drawing.Font("Arial", 5.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
b.Location = point;
b.Name = "JobButton" + (i + 1);
b.Size = new System.Drawing.Size(35, 21);
b.TabIndex = i;
b.UseVisualStyleBackColor = true;
panel2.Controls.Add(b);
b.LoadSettings();
}
}
private void MainForm_Load(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "Select * from settings;";
settings = db.GetDataTable(query);
int x = 0, y = 0;
foreach (DataRow r in settings.Rows)
{
switch (r["variable"].ToString())
{
case "opacity":
this.Opacity = Convert.ToDouble(r["value"].ToString()) / 100;
break;
case "locationX":
x = Convert.ToInt32(r["value"].ToString());
break;
case "locationY":
y = Convert.ToInt32(r["value"].ToString());
break;
case "actionwait":
this.actionWait = Convert.ToInt16(r["value"].ToString());
break;
case "hotkeysenabled":
this.hotkeysEnabled = Convert.ToBoolean(r["value"].ToString());
break;
}
}
this.Location = new Point(x, y);
this.Refresh();
// Create all the job buttons
sf = new SettingsForm(this);
jcf = new JobConfigureForm();
this.pictureBox1.MouseDown += new System.Windows.Forms.MouseEventHandler(this.Form1_MouseDown);
sf.ItemDataChanged += new ItemDataChangedHandler(jcf.LoadItemData);
Point point = new Point(0, 10);
for (int i = 0; i < 20; i++)
{
JobButton b = new JobButton(this);
if ((i > 0) && ((i % 10) == 0))
{
point.Y += 20;
point.X = 0;
}
else if (i > 0)
{
point.X += 34;
}
b.Font = new System.Drawing.Font("Arial", 5.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
b.Location = point;
b.Name = "JobButton" + (i + 1);
b.Size = new System.Drawing.Size(35, 21);
b.TabIndex = i;
b.UseVisualStyleBackColor = true;
panel2.Controls.Add(b);
b.LoadSettings();
}
}
public void LoadItemData(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable data;
try {
// Ears
String query = "select name from items where position = \"ears\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
earGear.Items.Add(r["name"].ToString());
}
// Head
query = "select name from items where position = \"head\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
headGear.Items.Add(r["name"].ToString());
}
// Neck
DataTable neckData;
query = "select name from items where position = \"neck\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
neckGear.Items.Add(r["name"].ToString());
}
// Pouch
query = "select name from items where position = \"pouch\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
pouchGear.Items.Add(r["name"].ToString());
}
// Pack
query = "select name from items where position = \"pack\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
packGear.Items.Add(r["name"].ToString());
}
// Throwing
query = "select name from items where position = \"throwing\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
throwingGear.Items.Add(r["name"].ToString());
}
// Main Hand
query = "select name from items where position = \"mh\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
mainHandGear.Items.Add(r["name"].ToString());
}
// Off Hand
query = "select name from items where position = \"oh\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
offHandGear.Items.Add(r["name"].ToString());
}
// Body
query = "select name from items where position = \"body\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
bodyGear.Items.Add(r["name"].ToString());
}
// Waist
query = "select name from items where position = \"waist\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
waistGear.Items.Add(r["name"].ToString());
}
// Hands
query = "select name from items where position = \"hands\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
handGear.Items.Add(r["name"].ToString());
}
// Legs
query = "select name from items where position = \"legs\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
legGear.Items.Add(r["name"].ToString());
}
// Feet
query = "select name from items where position = \"feet\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
footGear.Items.Add(r["name"].ToString());
}
// Wrists
query = "select name from items where position = \"wrists\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
wristGear.Items.Add(r["name"].ToString());
}
// L.ring
query = "select name from items where position = \"ring\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows)
{
ring1.Items.Add(r["name"].ToString());
ring2.Items.Add(r["name"].ToString());
}
}
catch (Exception q) {
MessageBox.Show(q.Message);
}
}
protected override void OnVisibleChanged(EventArgs e)
{
if (this.Visible == false)
{
return;
}
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "select * from button_labels where button_name = \"" + owner.Name + "\";";
settings = db.GetDataTable(query);
if (settings.Rows.Count > 0)
{
buttonLabel.Text = settings.Rows[0]["button_label"].ToString();
useJobCheckbox.Checked = Convert.ToBoolean(settings.Rows[0]["use_job"].ToString());
}
else
{
buttonLabel.Text = "";
useJobCheckbox.Checked = false;
earGear.Text = "";
headGear.Text = "";
neckGear.Text = "";
pouchGear.Text = "";
packGear.Text = "";
throwingGear.Text = "";
mainHandGear.Text = "";
offHandGear.Text = "";
bodyGear.Text = "";
waistGear.Text = "";
handGear.Text = "";
legGear.Text = "";
footGear.Text = "";
wristGear.Text = "";
ring1.Text = "";
ring2.Text = "";
}
query = "select * from buttons where button_name = \"" + owner.Name + "\";";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows)
{
switch (r["position"].ToString())
{
case "ears":
earGear.Text = r["value"].ToString();
break;
case "head":
headGear.Text = r["value"].ToString();
break;
case "neck":
neckGear.Text = r["value"].ToString();
break;
case "pouch":
pouchGear.Text = r["value"].ToString();
break;
case "pack":
packGear.Text = r["value"].ToString();
break;
case "throwing":
throwingGear.Text = r["value"].ToString();
break;
case "mh":
mainHandGear.Text = r["value"].ToString();
break;
case "oh":
offHandGear.Text = r["value"].ToString();
break;
case "body":
bodyGear.Text = r["value"].ToString();
break;
case "waist":
waistGear.Text = r["value"].ToString();
break;
case "hands":
handGear.Text = r["value"].ToString();
break;
case "legs":
legGear.Text = r["value"].ToString();
break;
case "feet":
footGear.Text = r["value"].ToString();
break;
case "wrists":
wristGear.Text = r["value"].ToString();
break;
case "L.ring":
ring1.Text = r["value"].ToString();
break;
case "R.ring":
ring2.Text = r["value"].ToString();
break;
}
}
base.OnVisibleChanged(e);
}
private void ChangeJob()
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
IntPtr ffHandle = NativeImports.FindWindow("RAPTURE", "FINAL FANTASY XIV");
if (ffHandle == IntPtr.Zero)
{
MessageBox.Show("Final Fantasy is not running.");
return;
}
String query =
String.Format("select position, value from buttons where position = 'mh' " +
"and button_name = '{0}';", Name);
settings = db.GetDataTable(query);
if (settings.Rows.Count <= 0)
{
return;
}
if (settings.Rows[0]["value"].ToString().Trim() == "")
{
db.Delete("buttons", String.Format("button_name = \"{0}\"", Name));
return;
}
ToggleButtonStates();
SendMessage(ffHandle, String.Format("/equip mh \"{0}\"", settings.Rows[0]["value"].ToString()));
if (use_job)
{
SendMessage(ffHandle, "/job on");
Thread.Sleep(Math.Max(owner.actionWait * 3, 1000));
}
else
{
SendMessage(ffHandle, "/job off");
}
query = "select position, value from buttons where button_name = '" + Name +
"' and position != 'mh';";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows)
{
String gearName = "";
if (r["value"].ToString().Trim() == "")
{
continue;
}
if (r["value"].ToString().Trim().ToLower() == "none")
{
gearName = "";
}
else
{
gearName = r["value"].ToString();
}
String equip = String.Format("/equip {0} \"{1}\"", r["position"], gearName);
SendMessage(ffHandle, equip);
if (r["position"].ToString() == "L.ring")
{
Thread.Sleep(Math.Max(owner.actionWait * 3, 1000));
}
else
{
Thread.Sleep(owner.actionWait);
}
}
ToggleButtonStates();
}
public void LoadItemData(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable data;
try {
// Ears
String query = "select name from items where position = \"ears\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
earGear.Items.Add(r["name"].ToString());
}
// Head
query = "select name from items where position = \"head\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
headGear.Items.Add(r["name"].ToString());
}
// Neck
DataTable neckData;
query = "select name from items where position = \"neck\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
neckGear.Items.Add(r["name"].ToString());
}
// Pouch
query = "select name from items where position = \"pouch\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
pouchGear.Items.Add(r["name"].ToString());
}
// Pack
query = "select name from items where position = \"pack\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
packGear.Items.Add(r["name"].ToString());
}
// Throwing
query = "select name from items where position = \"throwing\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
throwingGear.Items.Add(r["name"].ToString());
}
// Main Hand
query = "select name from items where position = \"mh\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
mainHandGear.Items.Add(r["name"].ToString());
}
// Off Hand
query = "select name from items where position = \"oh\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
offHandGear.Items.Add(r["name"].ToString());
}
// Body
query = "select name from items where position = \"body\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
bodyGear.Items.Add(r["name"].ToString());
}
// Waist
query = "select name from items where position = \"waist\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
waistGear.Items.Add(r["name"].ToString());
}
// Hands
query = "select name from items where position = \"hands\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
handGear.Items.Add(r["name"].ToString());
}
// Legs
query = "select name from items where position = \"legs\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
legGear.Items.Add(r["name"].ToString());
}
// Feet
query = "select name from items where position = \"feet\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
footGear.Items.Add(r["name"].ToString());
}
// Wrists
query = "select name from items where position = \"wrists\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
wristGear.Items.Add(r["name"].ToString());
}
// L.ring
query = "select name from items where position = \"ring\";";
data = db.GetDataTable(query);
foreach (DataRow r in data.Rows) {
ring1.Items.Add(r["name"].ToString());
ring2.Items.Add(r["name"].ToString());
}
}
catch (Exception q) {
MessageBox.Show(q.Message);
}
}
protected override void OnVisibleChanged(EventArgs e)
{
if (this.Visible == false)
return;
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "select * from button_labels where button_name = \"" + owner.Name + "\";";
settings = db.GetDataTable(query);
if (settings.Rows.Count > 0) {
buttonLabel.Text = settings.Rows[0]["button_label"].ToString();
useJobCheckbox.Checked = Convert.ToBoolean(settings.Rows[0]["use_job"].ToString());
}
else {
buttonLabel.Text = "";
useJobCheckbox.Checked = false;
earGear.Text = "";
headGear.Text = "";
neckGear.Text = "";
pouchGear.Text = "";
packGear.Text = "";
throwingGear.Text = "";
mainHandGear.Text = "";
offHandGear.Text = "";
bodyGear.Text = "";
waistGear.Text = "";
handGear.Text = "";
legGear.Text = "";
footGear.Text = "";
wristGear.Text = "";
ring1.Text = "";
ring2.Text = "";
}
query = "select * from buttons where button_name = \"" + owner.Name + "\";";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows) {
switch (r["position"].ToString()) {
case "ears":
earGear.Text = r["value"].ToString();
break;
case "head":
headGear.Text = r["value"].ToString();
break;
case "neck":
neckGear.Text = r["value"].ToString();
break;
case "pouch":
pouchGear.Text = r["value"].ToString();
break;
case "pack":
packGear.Text = r["value"].ToString();
break;
case "throwing":
throwingGear.Text = r["value"].ToString();
break;
case "mh":
mainHandGear.Text = r["value"].ToString();
break;
case "oh":
offHandGear.Text = r["value"].ToString();
break;
case "body":
bodyGear.Text = r["value"].ToString();
break;
case "waist":
waistGear.Text = r["value"].ToString();
break;
case "hands":
handGear.Text = r["value"].ToString();
break;
case "legs":
legGear.Text = r["value"].ToString();
break;
case "feet":
footGear.Text = r["value"].ToString();
break;
case "wrists":
wristGear.Text = r["value"].ToString();
break;
case "L.ring":
ring1.Text = r["value"].ToString();
break;
case "R.ring":
ring2.Text = r["value"].ToString();
break;
}
}
base.OnVisibleChanged(e);
}
private void SettingsForm_Load(object sender, EventArgs e)
{
SQLiteDatabase db = new SQLiteDatabase("ffxiv_job_bar.db");
DataTable settings;
String query = "Select * from settings;";
settings = db.GetDataTable(query);
foreach (DataRow r in settings.Rows) {
switch (r["variable"].ToString()) {
case "opacity":
this.opacityChanger.Value = Convert.ToInt32(r["value"].ToString());
break;
case "actionwait":
this.actionWaitChanger.Value = Convert.ToInt32(r["value"].ToString());
break;
case "hotkeysenabled":
this.hotkeysCheckbox.Checked = Convert.ToBoolean(r["value"].ToString());
break;
}
}
}
