public MainWindow()
{
Current = this;
mySqlConnection = new MySqlConnection("server=127.0.0.1;uid=root;pwd=pavellev7;database=db;");
mySqlConnection.Open();
InitializeComponent();
canvasFirstIcon = canvasMap.Children.Count;
GetMyIp();
villagesOnMap = new List <VillageOnMap>();
accounts = new List <AccountInformation>();
MoveAllTo(500, 500);
MySqlCommand mySqlCommand = new MySqlCommand(@"
select vi.x, vi.y, vi.name, vi.province, vi.player, vi.tribe, vi.points
from villageinfos vi inner
join (
select x, y, max(date) as maxdate
from villageinfos
group by x, y
) md
on vi.x = md.x and vi.y = md.y and vi.date = md.maxdate; ", mySqlConnection);
mySqlDataReader = mySqlCommand.ExecuteReader();
while (mySqlDataReader.Read())
{
VillageOnMap villageOnMap = new VillageOnMap(mySqlDataReader.GetInt32(0), mySqlDataReader.GetInt32(1),
mySqlDataReader.GetString(2), mySqlDataReader.GetString(3), mySqlDataReader.GetString(4),
mySqlDataReader.GetString(5), mySqlDataReader.GetInt32(6));
villagesOnMap.Add(villageOnMap);
}
ShowVisible();
}
private void HideInvisible()
{
for (int i = canvasFirstIcon; i < canvasMap.Children.Count; i++)
{
VillageOnMap villageOnMap = canvasMap.Children[i] as VillageOnMap;
if (Math.Abs(villageOnMap.x - x) > 23 || Math.Abs(villageOnMap.y - y) > 16)
{
canvasMap.Children.Remove(villageOnMap);
i--;
}
}
}
void MoveAll(double x, double y)
{
currentX -= x;
currentY -= y;
for (int i = canvasFirstIcon; i < canvasMap.Children.Count; i++)
{
VillageOnMap villageOnMap = canvasMap.Children[i] as VillageOnMap;
Canvas.SetLeft(villageOnMap, Canvas.GetLeft(villageOnMap) + x);
Canvas.SetTop(villageOnMap, Canvas.GetTop(villageOnMap) + y);
}
}
public MapMenuMate(VillageOnMap villageOnMap)
{
this.villageOnMap = villageOnMap;
InitializeComponent();
}
public AttackTab(VillageOnMap aimedVillage)
{
InitializeComponent();
this.aimedVillage = aimedVillage;
}
