private void store_db_save_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "현재의 데이터를 저장하시겠습니까?", "DB 저장", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
DataTable rs = Mysql.Query($"SELECT * FROM store WHERE no = '{store_no_textbox.Text}'");
if (rs.Rows.Count == 0)
{
MessageBoxEx.Show(this, "잘못된 식별번호입니다.", "DB 저장 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = "UPDATE store SET ";
sql += $"no = '{store_no_textbox.Text}',";
sql += $"name = '{store_name_textbox.Text}'";
sql += $"WHERE no = '{store_no_textbox.Text}'";
Mysql.Query(sql);
loadData();
Console.info($"성공적으로 데이터를 업데이트했습니다. (상점 데이터 업데이트 : {store_name_textbox.Text})");
MessageBoxEx.Show(this, "성공적으로 저장되었습니다.", "DB 저장", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
Console.warning(err.ToString());
}
}
}
}
private void item_db_save_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "현재의 데이터를 저장하시겠습니까?", "DB 저장", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
DataTable rs = Mysql.Query($"SELECT * FROM storage_item WHERE no = '{item_no_textbox.Text}'");
if (rs.Rows.Count == 0)
{
MessageBoxEx.Show(this, "잘못된 식별번호입니다.", "DB 저장 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = "UPDATE storage_item SET ";
sql += $"no = '{item_no_textbox.Text}',";
sql += $"name = '{item_name_textbox.Text}',";
sql += $"icon = '{item_icon_textbox.Text}',";
sql += $"description = '{item_desc_textbox.Text}',";
sql += $"type = '{item_type_box.SelectedIndex}',";
sql += $"equip_type = '{item_equip_box.SelectedIndex}',";
sql += $"price = '{item_price_numbox.Value}',";
sql += $"str = '{item_str_numbox.Value}',";
sql += $"dex = '{item_dex_numbox.Value}',";
sql += $"`int` = '{item_int_numbox.Value}',";
sql += $"luk = '{item_luk_numbox.Value}',";
sql += $"hp = '{item_hp_numbox.Value}',";
sql += $"mp = '{item_mp_numbox.Value}',";
sql += $"solid = '{item_solid_numbox.Value}',";
sql += $"max_ability = '{item_max_ability_numbox.Value}',";
sql += $"ability = '{item_ability_numbox.Value}',";
sql += $"lv_cost = '{item_lv_numbox.Value}',";
sql += $"rank = '{item_rank_box.SelectedIndex}',";
sql += $"trade = '{item_trade_box.SelectedIndex}',";
sql += $"sell = '{item_sell_box.SelectedIndex}',";
sql += $"`use` = '{item_use_box.SelectedIndex}',";
sql += $"method_name = '{item_method_box.Text}',";
sql += $"method_arg = '{item_method_numbox.Value}',";
sql += $"animation_id = '{item_animation_numbox.Value}' ";
sql += $"WHERE no = '{item_no_textbox.Text}'";
Mysql.Query(sql);
loadData();
Console.info($"성공적으로 데이터를 업데이트했습니다. (아이템 데이터 업데이트 : {item_name_textbox.Text})");
MessageBoxEx.Show(this, "성공적으로 저장되었습니다.", "DB 저장", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
Console.warning(err.ToString());
}
}
}
}
private void enemy_db_save_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "현재의 데이터를 저장하시겠습니까?", "DB 저장", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
DataTable rs = Mysql.Query($"SELECT * FROM enemy WHERE no = '{enemy_no_textbox.Text}'");
if (rs.Rows.Count == 0)
{
MessageBoxEx.Show(this, "잘못된 식별번호입니다.", "DB 저장 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = "UPDATE enemy SET ";
sql += $"no = '{enemy_no_textbox.Text}',";
sql += $"name = '{enemy_name_textbox.Text}',";
sql += $"image = '{enemy_image_textbox.Text}',";
sql += $"exp = '{enemy_exp_numbox.Value}',";
sql += $"level = '{enemy_lv_numbox.Value}',";
sql += $"sight = '{enemy_sight_numbox.Value}',";
sql += $"maxhp = '{enemy_hp_numbox.Value}',";
sql += $"maxmp = '{enemy_mp_numbox.Value}',";
sql += $"str = '{enemy_str_numbox.Value}',";
sql += $"dex = '{enemy_dex_numbox.Value}',";
sql += $"`int` = '{enemy_int_numbox.Value}',";
sql += $"luk = '{enemy_luk_numbox.Value}',";
sql += $"direction = '{(enemy_dir_box.SelectedIndex + 1) * 2}',";
sql += $"move_speed = '{enemy_speed_numbox.Value}',";
sql += $"delay = '{enemy_delay_numbox.Value}',";
sql += $"rebirth_time = '{enemy_rebirth_numbox.Value}',";
sql += $"pattern = '{enemy_pattern_numbox.Value}',";
sql += $"animation_id = '{enemy_animation_numbox.Value}'";
sql += $"WHERE no = '{enemy_no_textbox.Text}'";
Mysql.Query(sql);
loadData();
Console.info($"성공적으로 데이터를 업데이트했습니다. (몬스터 데이터 업데이트 : {enemy_name_textbox.Text})");
MessageBoxEx.Show(this, "성공적으로 저장되었습니다.", "DB 저장", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
Console.warning(err.ToString());
}
}
}
}
// 데이터 삭제
private void npc_data_delete_button_Click(object sender, EventArgs e)
{
if (npc_data_listbox.SelectedIndex != -1)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "정말로 삭제하시겠습니까?", "삭제 확인", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
npcData.delData(npcData.List[npc_data_listbox.SelectedIndex]);
loadNPCData();
}
}
}
}
private void skill_db_save_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "현재의 데이터를 저장하시겠습니까?", "DB 저장", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
DataTable rs = Mysql.Query($"SELECT * FROM storage_skill WHERE no = '{skill_no_textbox.Text}'");
if (rs.Rows.Count == 0)
{
MessageBoxEx.Show(this, "잘못된 식별번호입니다.", "DB 저장 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = "UPDATE storage_skill SET ";
sql += $"no = '{skill_no_textbox.Text}',";
sql += $"name = '{skill_name_textbox.Text}',";
sql += $"icon = '{skill_icon_textbox.Text}',";
sql += $"description = '{skill_desc_textbox.Text}',";
sql += $"max_level = '{skill_lv_numbox.Value}',";
sql += $"power = '{skill_power_numbox.Value}',";
sql += $"power_factor = '{skill_factor_numbox.Value}',";
sql += $"level_power = '{skill_lv_damage_numbox.Value}',";
sql += $"range_type = '{skill_range_type_numbox.Value}',";
sql += $"`range` = '{skill_range_numbox.Value}',";
sql += $"count = '{skill_count_numbox.Value}',";
sql += $"delay = '{skill_delay_numbox.Value}',";
sql += $"wait_time = '{skill_wait_numbox.Value}',";
sql += $"cost = '{skill_cost_numbox.Value}',";
sql += $"use_animation = '{skill_use_animation_numbox.Value}',";
sql += $"target_animation = '{skill_target_animation_numbox.Value}',";
sql += $"function = '{skill_function_textbox.Text}'";
sql += $"WHERE no = '{skill_no_textbox.Text}'";
Mysql.Query(sql);
loadData();
Console.info($"성공적으로 데이터를 업데이트했습니다. (기술 데이터 업데이트 : {skill_name_textbox.Text})");
MessageBoxEx.Show(this, "성공적으로 저장되었습니다.", "DB 저장", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
Console.warning(err.ToString());
}
}
}
}
private void dialog_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
switch (type)
{
case 0:
addData(input_textbox.Text);
break;
case 1:
delData(Convert.ToInt32(input_textbox.Text));
break;
}
}
Close();
}
private void store_item_delete_button_Click(object sender, EventArgs e)
{
if (store_listview.SelectedIndices[0] != -1)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "정말로 삭제하시겠습니까?", "삭제 확인", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
int index = store_listbox.SelectedIndex;
StoreData obj = (storeListData[index] as StoreData);
Mysql.Query($"DELETE FROM store_item WHERE no = '{(obj.itemData[store_listview.SelectedIndices[0]] as StoreItem).no}'");
Console.info($"성공적으로 데이터를 삭제했습니다. (상점 아이템 : {getItemData((obj.itemData[store_listview.SelectedIndices[0]] as StoreItem).item_no).name})");
store_item_load(obj);
}
}
}
}
private void enemy_pos_delete_button_Click(object sender, EventArgs e)
{
if (enemy_pos_listview.SelectedIndices[0] != -1)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "정말로 삭제하시겠습니까?", "삭제 확인", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
int index = enemy_listbox.SelectedIndex;
EnemyData obj = (enemyListData[index] as EnemyData);
Mysql.Query($"DELETE FROM enemy_position WHERE no = '{(obj.posData[enemy_pos_listview.SelectedIndices[0]] as EnemyPosition).no}'");
Console.info($"성공적으로 데이터를 삭제했습니다. (몬스터 위치 : {(obj.posData[enemy_pos_listview.SelectedIndices[0]] as EnemyPosition).no})");
enemy_position_load(obj);
}
}
}
}
// DB 데이터 저장
private void npc_db_save_button_Click(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (MessageBoxEx.Show(this, "현재의 데이터를 저장하시겠습니까?", "DB 저장", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try {
DataTable rs = Mysql.Query($"SELECT * FROM npc WHERE no = '{npc_no_textbox.Text}'");
if (rs.Rows.Count == 0)
{
MessageBoxEx.Show(this, "잘못된 식별번호입니다.", "DB 저장 오류", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = "UPDATE npc SET ";
sql += $"no = '{npc_no_textbox.Text}',";
sql += $"name = '{npc_name_textbox.Text}',";
sql += $"image = '{npc_image_textbox.Text}',";
sql += $"id = '{npc_id_numbox.Value}',";
sql += $"map_id = '{npc_mapid_numbox.Value}',";
sql += $"map_x = '{npc_x_numbox.Value}',";
sql += $"map_y = '{npc_y_numbox.Value}',";
sql += $"direction = '{(npc_dir_box.SelectedIndex + 1) * 2}',";
sql += $"pattern = '{npc_pattern_box.SelectedIndex}',";
sql += $"move_speed = '{npc_speed_box.SelectedIndex}',";
sql += $"default_action = '{npc_action_numbox.Value}' ";
sql += $"WHERE no = '{npc_no_textbox.Text}'";
Mysql.Query(sql);
loadData();
Console.info($"성공적으로 데이터를 업데이트했습니다. (NPC 데이터 업데이트 : {npc_name_textbox.Text})");
MessageBoxEx.Show(this, "성공적으로 저장되었습니다.", "DB 저장", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception err)
{
Console.warning(err.ToString());
}
}
}
}
private void item_listview_SelectedIndexChanged(object sender, EventArgs e)
{
if (Mysql.ping())
{
if (item_listview.SelectedItems.Count > 0)
{
ItemData obj = itemListData[item_listview.SelectedIndices[0]] as ItemData;
item_no_textbox.Text = obj.no.ToString();
item_name_textbox.Text = obj.name;
item_icon_textbox.Text = obj.icon;
item_desc_textbox.Text = obj.description;
item_type_box.Text = item_type_box.Items[obj.type].ToString();
item_equip_box.Text = item_equip_box.Items[obj.equip].ToString();
item_price_numbox.Value = obj.price;
item_str_numbox.Value = obj.str;
item_dex_numbox.Value = obj.dex;
item_int_numbox.Value = obj.Int;
item_luk_numbox.Value = obj.luk;
item_hp_numbox.Value = obj.hp;
item_mp_numbox.Value = obj.mp;
item_solid_numbox.Value = obj.solid;
item_max_ability_numbox.Value = obj.max_ability;
item_ability_numbox.Value = obj.ability;
item_lv_numbox.Value = obj.lv_cost;
item_rank_box.Text = item_rank_box.Items[obj.rank].ToString();
item_trade_box.Text = item_trade_box.Items[obj.trade ? 1 : 0].ToString();
item_sell_box.Text = item_sell_box.Items[obj.sell ? 1 : 0].ToString();
item_use_box.Text = item_use_box.Items[obj.use ? 1 : 0].ToString();
item_method_box.Text = obj.method_name;
item_method_numbox.Value = obj.method_arg;
item_animation_numbox.Value = obj.animation_id;
}
}
}
public void loadData()
{
if (Mysql.ping())
{
// NPC 데이터 로드
object obj;
npcListData = new ArrayList();
DataTable rs = Mysql.Query("SELECT * From npc");
npc_listbox.Items.Clear();
foreach (DataRow data in rs.Rows)
{
obj = new NPC(data);
npcListData.Add(obj);
npc_listbox.Items.Add((obj as NPC).name);
}
// 아이템 로드
ListViewItem list;
ListViewItem.ListViewSubItem item;
itemListData = new ArrayList();
item_listview.Items.Clear();
rs = Mysql.Query("SELECT * FROM storage_item");
foreach (DataRow data in rs.Rows)
{
obj = new ItemData(data);
list = new ListViewItem();
list.Text = (obj as ItemData).name;
item = new ListViewItem.ListViewSubItem();
item.Text = item_type_box.Items[(obj as ItemData).type].ToString();
list.SubItems.Add(item);
item_listview.Items.Add(list);
itemListData.Add((obj as ItemData));
}
// 상점 로드
storeListData = new ArrayList();
store_listbox.Items.Clear();
rs = Mysql.Query("SELECT * FROM store");
foreach (DataRow data in rs.Rows)
{
obj = new StoreData(data);
storeListData.Add(obj);
store_listbox.Items.Add((obj as StoreData).name);
}
// 몬스터 로드
enemyListData = new ArrayList();
enemy_listbox.Items.Clear();
rs = Mysql.Query("SELECT * From enemy");
foreach (DataRow data in rs.Rows)
{
obj = new EnemyData(data);
enemyListData.Add(obj);
enemy_listbox.Items.Add((obj as EnemyData).name);
}
// 스킬 로드
skillListData = new ArrayList();
skill_listbox.Items.Clear();
rs = Mysql.Query("SELECT * FROM storage_skill");
foreach (DataRow data in rs.Rows)
{
obj = new SkillData(data);
skillListData.Add(obj);
skill_listbox.Items.Add((obj as SkillData).name);
}
}
else
{
MessageBoxEx.Show(this, "DB와 연결되어있지 않습니다.");
}
}
