public static F***s GetFucks(MySqlConnection sql, Filters flt)
{
string query = String.Format(@"
(
SELECT {0:s}
FROM f***s
WHERE isdead(f_partner)=0 {2:s} {3:s} {4:s}
)
UNION
(
SELECT {1:s}
FROM f***s
WHERE isdead(f_partner)=1 {2:s} {3:s} {4:s}
)
ORDER BY name,f_date;",
fuckFields(true),
fuckFields(false),
(flt.safeInt(Filters.RAB_ID, 0) != 0 ? "AND f_rabid=" + flt.safeValue(Filters.RAB_ID) : ""),
DBHelper.MakeDatePeriod(flt, "f_date"),
(flt.safeInt(Filters.FIND_PARTNERS, 0) != 0 ? "AND f_partner=" + flt.safeValue(Filters.FIND_PARTNERS) : "")
);
MySqlCommand cmd = new MySqlCommand(query, sql);
MySqlDataReader rd = cmd.ExecuteReader();
F***s f = new F***s();
while (rd.Read())
{
f.Add(fillFuck(rd));
}
rd.Close();
return(f);
}
public OkrolForm(int r1)
{
InitializeComponent();
initialHint();
_rabbit = Engine.get().getRabbit(r1);
label1.Text = _rabbit.FullName;
F***s f = Engine.db().GetFucks(new Filters(Filters.RAB_ID + "=" + _rabbit.ID));
DateTime d = f.LastFuck.EventDate;
TimeSpan days = DateTime.Now.Subtract(d);
dateDays1.Maximum = days.Days;
}
