private void buttonSave_Click(object sender, EventArgs e)
{
try
{
stC = read_data();
clStats = new CStats(connect);
if (type == 0)
{
if (clStats.Insert(stC))
{
DialogResult = DialogResult.OK;
}
}
else if (type == 1)
{
if (clStats.Update(stC, gSTStats.idseason, gSTStats.idgame, gSTStats.idplayer))
{
DialogResult = DialogResult.OK;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
public void Init(CTRoomCoordinate _spawnCoord)
{
m_RoomCoord = new CTRoomCoordinate(_spawnCoord);
m_EnemyStats = new CStats();
SetStats(25, //lvl
100, 1250, 0, //exp,maxExp,expBoost
1000, 1000, //HP
100, 100, //SP
250, //atk
250, //def
3, //playrate
2); //movespeed
m_IsImmortal = false;
m_EnemySprite = GetComponent <SpriteRenderer>().sprite;
m_SM = new CStateMachine();
m_SM.AddState(new CStateBossIdle(this.gameObject, transform.position));
m_SM.AddState(new CStateBossChase(this.gameObject));
m_SM.AddState(new CStateBossTeleport(this.gameObject, CTDungeon.Instance.Floors[CTDungeon.Instance.currentFloor].Rooms[1]));
m_SM.AddState(new CStateBossAttack(this.gameObject));
m_SM.AddState(new CStateDead(this.gameObject));
m_SM.SetNextState("StateIdle");
}
public CStats RealStats()
{
CStats out_ = Stats.Copy();
if (Equipments.CurrentAmulet != null)
{
Equipments.Amulets[Equipments.CurrentAmulet.Value].PutOn(out_);
}
if (Equipments.CurrentBoots != null)
{
Equipments.Boots[Equipments.CurrentBoots.Value].PutOn(out_);
}
if (Equipments.CurrentHelmet != null)
{
Equipments.Helmets[Equipments.CurrentHelmet.Value].PutOn(out_);
}
if (Equipments.CurrentPlate != null)
{
Equipments.Plates[Equipments.CurrentPlate.Value].PutOn(out_);
}
if (Equipments.CurrentLeggins != null)
{
Equipments.Leggins[Equipments.CurrentLeggins.Value].PutOn(out_);
}
if (Equipments.CurrentSword != null)
{
Equipments.Swords[Equipments.CurrentSword.Value].PutOn(out_);
}
return(out_);
}
public void Init(CStats _playerstats)
{
m_AchievementCompleted = false;
m_AchievementActive = true;
m_propList = new Dictionary <string, QPropertiesBase>();
m_completedProps = 0;
m_playerstats = _playerstats;
}
// Use this for initialization
public void Init(CStats _playerstats)
{
AchievementList = new Dictionary <string, AchievementBase>();
m_playerstats = _playerstats;
AddAchievement(new NoiseSlayer());
AddAchievementProperty(NoiseSlayer.m_AchievementName, new KillNoiseProp(true, 3.0f));
AddAchievement(new TestAchievement());
//SetAchievementActive(NoiseSlayer.m_AchievementName, true);
}
public Stats(SqlConnection cn, STInfoSeason inf, ushort md, STGame gm)
{
InitializeComponent();
connect = cn;
IS = inf;
mode = md;
gSTGame = gm;
clStats = new CStats(connect);
clfs = new ListCompareByNumberFormStats();
clep = new ListCompareByNumberFromEntryPlayers();
}
List <CStats> DeltaArray(List <CStats> stats)
{
List <CStats> statOut = new List <CStats>();
statOut.Add(new CStats(CWorker.Str2DT(stats[0].Date), 0));
for (int ndx = 1; ndx != stats.Count; ndx++)
{
CStats priorObject = stats[ndx - 1];
int prior = stats[ndx - 1].Views;
statOut.Add(new CStats(CWorker.Str2DT(stats[ndx].Date), (stats[ndx].Views - priorObject.Views)));
}
int xdx = stats.Count - 1;
return(statOut);
}
public CStats Copy()
{
CStats out_ = new CStats();
out_.MainStats.Agility = MainStats.Agility;
out_.MainStats.Endurance = MainStats.Endurance;
out_.MainStats.Intelligence = MainStats.Intelligence;
out_.MainStats.Strength = MainStats.Strength;
out_.SubStats.Charisma = SubStats.Charisma;
out_.SubStats.Luck = SubStats.Luck;
out_.SubStats.Perception = SubStats.Perception;
out_.Scales.Agility = Scales.Agility;
out_.Scales.Endurance = Scales.Endurance;
out_.Scales.Intelligence = Scales.Intelligence;
out_.Scales.Strength = Scales.Strength;
return(out_);
}
public void Init(CTRoomCoordinate _spawnCoord)
{
m_RoomCoord = new CTRoomCoordinate(_spawnCoord);
m_EnemyStats = new CStats();
SetStatsByLevel(CTDungeon.Instance.currentFloor);
m_IsImmortal = false;
m_EnemySprite = GetComponent <SpriteRenderer>().sprite;
m_SM = new CStateMachine();
m_SM.AddState(new CStateIdle(this.gameObject));
m_SM.AddState(new CStatePatrol(this.gameObject));
m_SM.AddState(new CStateChangeRoom(this.gameObject));
m_SM.AddState(new CStateChaseRanged(this.gameObject));
m_SM.AddState(new CStateAttackRanged(this.gameObject));
m_SM.AddState(new CStateDead(this.gameObject));
m_SM.SetNextState("StateIdle");
}
public Entity Player(int mX, int mY)
{
var result = new Entity(_manager);
var cStats = new CStats(1, 1, 1, 50);
var cHealth = new CHealth(cStats);
var cBody = Body(new SSVector2I(mX, mY), 10.ToUnits(), 10.ToUnits());
var cMovement = Movement(cBody);
var cRender = Render(cBody, Textures.CharPlayer, Tilesets.Char, "normal");
var cControl = Control(cBody, cStats, cMovement, cRender);
var cShadower = new CShadower(_game, cBody, true, new Color(77, 77, 175, 255), 1);
cBody.Body.AddGroups(Groups.Character, Groups.Friendly);
cBody.Body.AddGroupsToCheck(Groups.Obstacle);
result.AddComponents(cStats, cHealth, cBody, cMovement, cControl, cRender, cShadower);
result.AddTags(Tags.Char, Tags.Friendly, Tags.DamagedByEnemy);
return(result);
}
public void Init()
{
m_TargetList = new List <GameObject>();
m_RoomCoord = new CTRoomCoordinate(0, 0);
m_EnemyStats = new CStats();
SetStatsByLevel(CTDungeon.Instance.currentFloor);
m_IsImmortal = false;
m_EnemySprite = GetComponent <SpriteRenderer>().sprite;
m_SM = new CStateMachine();
m_SM.AddState(new CStateIdle(this.gameObject));
m_SM.AddState(new CStatePatrol(this.gameObject));
m_SM.AddState(new CStateChangeRoom(this.gameObject));
m_SM.AddState(new CStateChase(this.gameObject));
m_SM.AddState(new CStateExplodeArmed(this.gameObject));
m_SM.AddState(new CStateExplode(this.gameObject));
m_SM.AddState(new CStateDead(this.gameObject));
m_SM.SetNextState("StateIdle");
}
public void Init()
{
this.name = "Player";
m_PlayerStats = new CStats();
m_InventorySystem = new CInventorySystem(InventoryPanel.GetComponent <CInventorySlots>(), InventoryUI.GetComponent <CInventory>());
m_playerQuestList = new List <QuestBase>();
CProgression.Instance.LoadPlayerSave(this);
m_RoomCoord = new CTRoomCoordinate(0, 0);
PostOffice.Instance.Register(name, gameObject); // TODO Move to Spawn() ?
m_IsImmortal = false;
m_PlayerSprite = GetComponent <SpriteRenderer>().sprite;
m_PrestigeSystem = new PrestigeSystem();
AchievementSystem.Instance.Init(this.GetStats());
UIScript = GetComponent <PlayerUIScript>();
UIScript.Init();
}
List <CStats> FillArray(List <CStats> stats, List <DateTime> rangeList)
{
int count = ((rangeList[1].Subtract(rangeList[0])).Days) + 1;
List <CStats> statOut = new List <CStats>(count);
int prior = 0;
for (int ndx = 0; ndx != count; ndx++)
{
DateTime target = rangeList[0].Add(new TimeSpan(ndx, 0, 0, 0));
CStats ifStat = FindIf(stats, target);
if (ifStat != null)
{
statOut.Add(new CStats(target, ifStat.Views));
}
else
{
statOut.Add(new CStats(target, prior));
}
prior = FindIf(statOut, target).Views;
//prior = statOut[statOut.Count - 1].Views;
}
return(statOut);
}
public CStats RealStats()
{
CStats out_ = Stats.Copy();
if (Equipments.CurrentAmulet != null)
{
Equipments.Amulets[Equipments.CurrentAmulet.Value].PutOn(out_);
}
if (Equipments.CurrentBoots != null)
{
Equipments.Boots[Equipments.CurrentBoots.Value].PutOn(out_);
}
if (Equipments.CurrentHelmet != null)
{
Equipments.Helmets[Equipments.CurrentHelmet.Value].PutOn(out_);
}
if (Equipments.CurrentPlate != null)
{
Equipments.Plates[Equipments.CurrentPlate.Value].PutOn(out_);
}
if (Equipments.CurrentLeggins != null)
{
Equipments.Leggins[Equipments.CurrentLeggins.Value].PutOn(out_);
}
if (Equipments.CurrentSword != null)
{
Equipments.Swords[Equipments.CurrentSword.Value].PutOn(out_);
}
out_.MainStats.Endurance = (int)(out_.MainStats.Endurance * out_.Scales.Endurance);
out_.MainStats.Strength = (int)(out_.MainStats.Strength * out_.Scales.Strength);
out_.MainStats.Agility = (int)(out_.MainStats.Agility * out_.Scales.Agility);
out_.MainStats.Intelligence = (int)(out_.MainStats.Intelligence * out_.Scales.Intelligence);
return(out_);
}
List <CTotalViews> TotalViews(CDB db)
{
List <CTotalViews> output = new List <CTotalViews>();
foreach (string date in MakeDateList(db))
{
output.Add(new CTotalViews(date));
}
foreach (CPhoto photo in db.Photos)
{
int offset = 0;
int running = 0;
CTotalViews prior = null;
foreach (CTotalViews record in output)
{
CStats stat = FindIf(photo.Stats, CWorker.Str2DT(record.Date));
if (stat != null)
{
record.Views += stat.Views;
running += stat.Views;
}
if (stat == null)
{
if (prior != null)
{
record.Views += prior.Views;
}
}
offset++;
prior = new CTotalViews(record.Date);
prior.Views = record.Views;
}
}
return(output);
}
public Entity Enemy(int mX, int mY)
{
var result = new Entity(_manager);
var cStats = new CStats(1, 1, 1, 75);
var cHealth = new CHealth(cStats);
var cBody = Body(new SSVector2I(mX, mY), 10.ToUnits(), 10.ToUnits());
var cMovement = Movement(cBody);
var cRender = Render(cBody, Textures.CharEnemy, Tilesets.Char, "normal");
var cShadower = new CShadower(_game, cBody, false, new Color(125, 255, 125, 125));
var cLineOfSight = new CLineOfSight(_game, cBody, cShadower)
{
TargetTag = Tags.Friendly, Angle = 90, Amplitude = 65
};
var cAI = AI(cStats, cBody, cMovement, cRender, cLineOfSight);
cBody.Body.AddGroups(Groups.Character, Groups.Enemy);
cBody.Body.AddGroupsToCheck(Groups.Obstacle);
result.AddComponents(cHealth, cBody, cMovement, cRender, cShadower, cLineOfSight, cAI);
result.AddTags(Tags.Char, Tags.Enemy, Tags.DamagedByFriendly);
return(result);
}
private void ToolStripMenuItemDeleteFileInfo_Click(object sender, EventArgs e)
{
string text = null;
try
{
STFileInfo data = GetSelectionData();
if (data.filename != null)
{
text = string.Format("Вы действиетльно желаете файл {0}?", data.filename);
if (MessageBox.Show(text, "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning)
== DialogResult.OK)
{
clWork.Delete(data);
init_data();
CGame clGame = new CGame(connect);
clGame.Delete(data.idseason, data.filename);
CStats clStats = new CStats(connect);
clStats.Delete(data.idseason, data.filename);
CCardTrow lcCardTrow = new CCardTrow(connect);
lcCardTrow.Delete(data.idseason, data.filename);
CStatsCoach clStatsCoach = new CStatsCoach(connect);
clStatsCoach.Delete(data.idseason, data.filename);
CStatsReferee lcStatsReferee = new CStatsReferee(connect);
lcStatsReferee.Delete(data.idseason, data.filename);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private void Start()
{
CEntryPlayers clEP = new CEntryPlayers(connect);
List <STEntryPlayers> data_list = clEP.GetListEntryPlayers(IS.idseason, 0, "IdTeam");
RecordDisplayStats record;
CEntryTeam clET;
CStats clSatas = new CStats(connect);
List <STStats> stats;
STParamStats prst;
CPlayer clPlayer;
string text;
try
{
container = new List <RecordDisplayStats>();
foreach (STEntryPlayers data in data_list)
{
if (data.dateout == null)
{
record = new RecordDisplayStats();
/* Номер и команда */
record.idplayer = data.idplayer;
clPlayer = new CPlayer(connect, data.idplayer);
text = string.Format("{0} {1}", clPlayer.stPlayer.family.ToUpper(), clPlayer.stPlayer.name);
record.fio = text;
record.idteam = data.idteam;
clTeam = new CTeam(connect, data.idteam);
record.nameteam = clTeam.stTeam.name;
/*Дивизион */
clET = new CEntryTeam(connect, IS.idseason, data.idteam);
record.iddivision = clET.gstTeamPart.iddivision;
/* Гражданство */
clPlayer = new CPlayer(connect, data.idplayer);
if (clPlayer.stPlayer.idcountry != null)
{
record.idcountry = (int)clPlayer.stPlayer.idcountry;
}
else
{
record.idcountry = 0;
}
/* Число сезонов */
record.cntseason = clEP.GetCntSeasonPlayer(data.idplayer);
/* Возраст */
CAge age = new CAge();
if (clPlayer.stPlayer.datebirth != null)
{
record.age = age.GetAge((DateTime)clPlayer.stPlayer.datebirth, DateTime.Now);
record.agestart = age.GetAge((DateTime)clPlayer.stPlayer.datebirth, IS.datebegin);
}
else
{
record.age = 0;
record.agestart = 0;
}
/* Считам статистику */
prst = new STParamStats();
prst.idseason = IS.idseason;
prst.idplayer = data.idplayer;
stats = clSatas.GetStats(prst);
if (stats.Count > 0)
{
foreach (STStats statplayer in stats)
{
record.cntgame++;
record.afg += statplayer.afg;
record.a3fg += statplayer.a3fg;
record.aft += statplayer.aft;
record.hfg += statplayer.hfg;
record.h3fg += statplayer.h3fg;
record.hft += statplayer.hft;
record.points += statplayer.points;
record.rebits += statplayer.rebits;
record.rebounds += statplayer.rebounds;
record.rebstg += statplayer.rebstg;
record.assists += statplayer.assists;
record.steals += statplayer.steals;
record.blocks += statplayer.blocks;
record.foulsadv += statplayer.foulsadv;
record.turnass += statplayer.turnass;
record.turnovers += statplayer.turnovers;
record.turnteh += statplayer.turnteh;
record.psfouls += statplayer.psfouls;
record.ptime += statplayer.ptime;
record.pm += statplayer.pm;
KPI kpi = new KPI(statplayer);
record.kpi += kpi.kpi;
}
if (record.afg > 0)
{
record.pc2 = (1.0 * record.hfg) / record.afg * 100;
}
else
{
record.pc2 = 0;
}
if (record.a3fg > 0)
{
record.pc3 = (1.0 * record.h3fg) / record.a3fg * 100;
}
else
{
record.pc3 = 0;
}
if (record.aft > 0)
{
record.pcft = (1.0 * record.hft) / record.aft * 100;
}
else
{
record.pcft = 0;
}
if (record.afg + record.a3fg > 0)
{
record.pcall =
((1.0 * record.hfg + record.h3fg) / (record.afg + record.a3fg)) * 100;
}
else
{
record.pcall = 0;
}
if (record.cntgame > 0)
{
record.averpoints = 1.0 * record.points / record.cntgame;
record.averrebounds = 1.0 * record.rebounds / record.cntgame;
record.averassists = 1.0 * record.assists / record.cntgame;
record.averblocks = 1.0 * record.blocks / record.cntgame;
record.aversteals = 1.0 * record.steals / record.cntgame;
record.averfoulsadv = 1.0 * record.foulsadv / record.cntgame;
record.averkpi = 1.0 * record.kpi / record.cntgame;
record.averptime = 1.0 * record.ptime / record.cntgame;
record.averturnovers = 1.0 * record.turnovers / record.cntgame;
record.averafg = 1.0 * record.afg / record.cntgame;
record.avera3fg = 1.0 * record.a3fg / record.cntgame;
record.averaft = 1.0 * record.aft / record.cntgame;
record.averhfg = 1.0 * record.hfg / record.cntgame;
record.averh3fg = 1.0 * record.h3fg / record.cntgame;
record.averhft = 1.0 * record.hft / record.cntgame;
record.averpsfouls = 1.0 * record.psfouls / record.cntgame;
if (record.averafg > 0)
{
record.averpc2 = (1.0 * record.averhfg) / record.averafg * 100;
}
else
{
record.averpc2 = 0;
}
if (record.avera3fg > 0)
{
record.averpc3 = (1.0 * record.averh3fg) / record.avera3fg * 100;
}
else
{
record.averpc3 = 0;
}
if (record.averaft > 0)
{
record.averpcft = (1.0 * record.averhft) / record.averaft * 100;
}
else
{
record.averpcft = 0;
}
if (record.averafg + record.avera3fg > 0)
{
record.averpcall =
((1.0 * record.averhfg + record.averh3fg) / (record.averafg + record.avera3fg)) * 100;
}
else
{
record.averpcall = 0;
}
}
else
{
record.averpoints = 0;
record.averrebounds = 0;
record.averassists = 0;
record.averblocks = 0;
record.aversteals = 0;
record.averfoulsadv = 0;
record.averkpi = 0;
record.averptime = 0;
record.averturnovers = 0;
record.averafg = 0;
record.avera3fg = 0;
record.averaft = 0;
record.averhfg = 0;
record.averh3fg = 0;
record.averhft = 0;
record.averpcall = 0;
record.averpcft = 0;
record.averpc3 = 0;
record.averpc2 = 0;
record.averpsfouls = 0;
}
}
container.Add(record);
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private List <RecordPlayerPreView> CalculateStats(List <STEntryPlayers> list_players)
{
List <RecordPlayerPreView> ret = new List <RecordPlayerPreView>();
RecordPlayerPreView item;
STParamStats prst;
int cntgame = 0;
int afg = 0;
int a3fg = 0;
int aft = 0;
int hfg = 0;
int h3fg = 0;
int hft = 0;
int points = 0;
int rebounds = 0;
int assists = 0;
int steals = 0;
int blocks = 0;
try
{
CStats clSatas = new CStats(connect);
List <STStats> stats;
foreach (STEntryPlayers data in list_players)
{
item = new RecordPlayerPreView();
item.idplayer = data.idplayer;
/* Считам статистику */
prst = new STParamStats();
prst.idseason = IS.idseason;
prst.idplayer = data.idplayer;
stats = clSatas.GetStats(prst);
cntgame = 0;
afg = 0;
a3fg = 0;
aft = 0;
hfg = 0;
h3fg = 0;
hft = 0;
points = 0;
rebounds = 0;
assists = 0;
steals = 0;
blocks = 0;
if (stats.Count > 0)
{
foreach (STStats statplayer in stats)
{
cntgame++;
afg += statplayer.afg;
a3fg += statplayer.a3fg;
aft += statplayer.aft;
hfg += statplayer.hfg;
h3fg += statplayer.h3fg;
hft += statplayer.hft;
points += statplayer.points;
rebounds += statplayer.rebounds;
assists += statplayer.assists;
steals += statplayer.steals;
blocks += statplayer.blocks;
}
if (afg > 0)
{
item.pc2 = (1.0 * hfg) / afg * 100;
}
else
{
item.pc2 = 0;
}
if (a3fg > 0)
{
item.pc3 = (1.0 * h3fg) / a3fg * 100;
}
else
{
item.pc3 = 0;
}
if (aft > 0)
{
item.pcft = (1.0 * hft) / aft * 100;
}
else
{
item.pcft = 0;
}
if (afg + a3fg > 0)
{
item.pcall = ((1.0 * hfg + h3fg) / (afg + a3fg)) * 100;
}
else
{
item.pcall = 0;
}
if (cntgame > 0)
{
item.averpoints = 1.0 * points / cntgame;
item.averpoints = 1.0 * rebounds / cntgame;
item.averass = 1.0 * assists / cntgame;
item.averstl = 1.0 * blocks / cntgame;
item.averblk = 1.0 * steals / cntgame;
}
else
{
item.averpoints = 0;
item.averpoints = 0;
item.averass = 0;
item.averstl = 0;
item.averblk = 0;
}
}
ret.Add(item);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
public CXDB Exec()
{
if (_DB == null)
{
return(null);
}
if (_DB.Photos == null)
{
return(null);
}
if (_DB.Photos.Count == 0)
{
return(null);
}
DateTime today = CWorker.FixDate(DateTime.Now);
//xDB.Totals = _DB.TotalViews();
//xDB.Totals = TotalViews(_DB);
//xDB.Totals = TotalDelta(xDB);
xDB.Totals = new List <CTotalViews>();
CDate dateRecord = new CDate();
dateRecord.WeekDays = 6;
dateRecord.PriorDays = 1;
dateRecord.MonthDays = 30;
string todayStr = CWorker.DT2StrReadable(CWorker.FixDate(today));
dateRecord.Today = todayStr;
dateRecord.Prior = todayStr + " : " + CWorker.DT2StrReadable(CWorker.FixDate((CWorker.DTSub(today, dateRecord.PriorDays))));
dateRecord.First = todayStr;
dateRecord.Week = CWorker.DT2StrReadable(CWorker.FixDate((CWorker.DTSub(today, dateRecord.WeekDays)))) + " : " + todayStr;
dateRecord.Month = CWorker.DT2StrReadable(CWorker.FixDate((CWorker.DTSub(today, dateRecord.MonthDays)))) + " : " + todayStr;
xDB.Date = dateRecord;
xDB.Views = new CViews();
xDB.Pictures = new CViews();
int ViewsTotal = 0;
int ViewsToday = 0;
int ViewsWeek = 0;
int ViewsMonth = 0;
int picturesTotal = 0;
xDB.Pictures.Today = 0;
int picturesWeek = 0;
int picturesMonth = 0;
List <DateTime> range = FindRange();
xDB.Pictures.Today = 0;
xDB.Pictures.Total = 0;
xDB.Pictures.Week = 0;
xDB.Pictures.Month = 0;
xDB.Views.Total = 0;
xDB.Views.Today = 0;
xDB.Views.Week = 0;
xDB.Views.Month = 0;
xDB.MaxCount = 0;
int maxCount = -1;
foreach (CPhoto photo in _DB.Photos)
{
if (photo.ID == "4633792226")
{
string x = "y";
}
List <CStats> fullStat = FillArray(photo.Stats, range);//
List <CStats> deltaList = DeltaArray(fullStat);
if (fullStat.Count < 2)
{
continue;
}
if (fullStat.Count > xDB.MaxCount)
{
xDB.MaxCount = fullStat.Count;
}
int thisWeek = 0;
int thisToday = 0;
int thisMonth = 0;
//CStats urRecord = fullStat[0];
CStats current = FindIf(fullStat, today);//
ViewsTotal += current.Views;
if (current.Views != 0)
{
picturesTotal++;
}
//thisToday = CWorker.Delta2(today, deltaList, dateRecord.PriorDays);
CStats temp = FindIf(deltaList, today);
if (temp == null)
{
continue;
}
thisToday = temp.Views;
ViewsToday += thisToday;
if (thisToday != 0)
{
xDB.Pictures.Today++;
}
thisWeek = CWorker.Delta2(today, deltaList, dateRecord.WeekDays);
ViewsWeek += thisWeek;
if (thisWeek != 0)
{
picturesWeek++;
}
thisMonth = CWorker.Delta2(today, deltaList, dateRecord.MonthDays);
ViewsMonth += thisMonth;
if (thisMonth != 0)
{
picturesMonth++;
}
UpdateViews(xDB, deltaList);
UpdateTotals(xDB, fullStat);
CData data = new CData();
data.MetaData = new CMetaData(photo);
data.Total = current.Views;
data.Week = thisWeek;
data.Today = thisToday;
data.Month = thisMonth;
xDB.Data.Add(data);
}
xDB.Pictures.Total = picturesTotal;
xDB.Pictures.Week = picturesWeek;
xDB.Pictures.Month = picturesMonth;
xDB.Views.Total = ViewsTotal;
xDB.Views.Today = ViewsToday;
xDB.Views.Week = ViewsWeek;
xDB.Views.Month = ViewsMonth;
xDB.MaxCount = maxCount;
return(xDB);
}
private void init_data_stats()
{
CStats clP = new CStats(connect);
STParamStats param = new STParamStats();
string text;
try
{
dataGridViewStats.Rows.Clear();
param.idgame = null;
param.idseason = null;
param.idteam = null;
param.idplayer = gstPlayer.idplayer;
param.order = "IdSeason,IdGame";
List <STStats> list = clP.GetStats(param);;
if (list.Count > 0)
{
dataGridViewStats.Rows.Add(list.Count);
for (int i = 0; i < list.Count; i++)
{
dataGridViewStats.Rows[i].Cells[0].Value = list[i].idseason.ToString();
dataGridViewStats.Rows[i].Cells[1].Value = list[i].idgame.ToString();
dataGridViewStats.Rows[i].Cells[2].Value = list[i].points.ToString();
dataGridViewStats.Rows[i].Cells[3].Value = string.Format("{0}\\{1}",
list[i].hfg, list[i].afg);
dataGridViewStats.Rows[i].Cells[4].Value = string.Format("{0}\\{1}",
list[i].h3fg, list[i].a3fg);
dataGridViewStats.Rows[i].Cells[5].Value = string.Format("{0}\\{1}",
list[i].hft, list[i].aft);
dataGridViewStats.Rows[i].Cells[6].Value = list[i].rebounds.ToString();
dataGridViewStats.Rows[i].Cells[7].Value = list[i].assists.ToString();
dataGridViewStats.Rows[i].Cells[8].Value = list[i].steals.ToString();
dataGridViewStats.Rows[i].Cells[9].Value = list[i].blocks.ToString();
dataGridViewStats.Rows[i].Cells[10].Value = list[i].foulsadv.ToString();
dataGridViewStats.Rows[i].Cells[11].Value = list[i].turnovers.ToString();
dataGridViewStats.Rows[i].Cells[12].Value = list[i].psfouls.ToString();
dataGridViewStats.Rows[i].Cells[13].Value = string.Format("{0:00}:{1:00}",
list[i].ptime / 60, list[i].ptime % 60);
dataGridViewStats.Rows[i].Cells[14].Value = list[i].pm.ToString();
KPI kpi = new KPI(list[i]);
text = string.Format("{0:f3}", kpi.kpi);
dataGridViewStats.Rows[i].Cells[15].Value = text;
}
dataGridViewStats.ClearSelection();
dataGridViewStats.AllowUserToAddRows = false;
}
else
{
dataGridViewStats.AllowUserToAddRows = false;
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
private STLoadFileInfo write_file(string filename)
{
STStats stStats;
STLoadFileInfo ret = new STLoadFileInfo();
try
{
ret.iErrorCode = 0;
CSmartStats clSS = new CSmartStats(filename);
STGame stGame = clSS.stGame;
// вычисляем дивизион
CGame clGame = new CGame(connect);
STGame rgame = clGame.GetGame(IS.idseason, stGame.idgame);
int iddiv = (int)rgame.iddivision;
lst_records = clRecords.GetRecords(iddiv);
// Записываем игру
clGame.UpdateSGM(stGame, stGame.idseason, stGame.idgame);
// Записываем статистику
CStats clStats = new CStats(connect);
List <STStats> lst = clSS.stStatsTeam1;
foreach (STStats item in lst)
{
if (item.ptime > 0)
{
stStats = verify_player(item);
verify_records(stStats);
clStats.Insert(stStats);
}
}
lst = clSS.stStatsTeam2;
foreach (STStats item in lst)
{
if (item.ptime > 0)
{
stStats = verify_player(item);
verify_records(stStats);
clStats.Insert(stStats);
}
}
// Записываем карту бросков
CCardTrow clCardTrow = new CCardTrow(connect);
STCardTrow card = clSS.stCardTrow1;
clCardTrow.Insert(card);
card = clSS.stCardTrow2;
clCardTrow.Insert(card);
// Записываем статистику тренеров
CStatsCoach clStatCoach = new CStatsCoach(connect);
STStatsCoach coach = clSS.stCoach1;
clStatCoach.Insert(coach);
coach = clSS.stCoach2;
clStatCoach.Insert(coach);
// Записываем статистику судей
CStatsReferee clStatReferee = new CStatsReferee(connect);
STStatsReferee referee = clSS.stReferee1_t1;
clStatReferee.Insert(referee);
referee = clSS.stReferee1_t2;
clStatReferee.Insert(referee);
referee = clSS.stReferee2_t1;
clStatReferee.Insert(referee);
referee = clSS.stReferee2_t2;
clStatReferee.Insert(referee);
referee = clSS.stStReferee_t1;
clStatReferee.Insert(referee);
referee = clSS.stStReferee_t2;
clStatReferee.Insert(referee);
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
private void insert_report(List <STGame> lst_game, StreamWriter sw, string name)
{
CStats clSatas = new CStats(connect);
List <STStats> stats;
STParamStats prst;
List <STStats> data = new List <STStats>();
try
{
if (lst_game.Count > 0)
{
sw.WriteLine(name);
sw.WriteLine("---------------------------");
sw.WriteLine("<p> </p>");
lst_center = new List <STDataSymbol5>();
lst_defender = new List <STDataSymbol5>();
lst_forward = new List <STDataSymbol5>();
data = new List <STStats>();
// вытягиваем стаистику
foreach (STGame game in lst_game)
{
int r = 0;
STStats newst;
prst = new STParamStats();
prst.idseason = game.idseason;
prst.idgame = game.idgame;
prst.idteam = game.idteam1;
stats = clSatas.GetStats(prst);
if (game.apoints >= 0 && game.bpoints >= 0)
{
r = (int)game.apoints - (int)game.bpoints;
}
foreach (STStats st in stats)
{
newst = st;
newst.pm = r;
data.Add(newst);
}
prst = new STParamStats();
prst.idseason = game.idseason;
prst.idgame = game.idgame;
prst.idteam = game.idteam2;
stats = clSatas.GetStats(prst);
if (game.apoints >= 0 && game.bpoints >= 0)
{
r = (int)game.bpoints - (int)game.apoints;
}
foreach (STStats st in stats)
{
newst = st;
newst.pm = r;
data.Add(newst);
}
}
// сортируем по id
ListCompareStatsByID clCompareStats = new ListCompareStatsByID();
data.Sort(clCompareStats);
// расчитываем
int currid = 0;
int curteam = 0;
int cnt = 1;
STDataSymbol5 item;
CEntryPlayers clEP = new CEntryPlayers(connect);
STEntryPlayers stEP;
CTeam clTeam = new CTeam(connect);
CPlayer clPlayer = new CPlayer(connect);
int point = 0;
int reb = 0;
int ass = 0;
int stl = 0;
int blk = 0;
int res = 0;
double kf = 0;
bool first = true;
for (int i = 0; i < data.Count; i++)
{
if (first)
{
currid = data[0].idplayer;
curteam = data[0].idteam;
point = data[0].points;
reb = data[0].rebounds;
ass = data[0].assists;
stl = data[0].steals;
blk = data[0].blocks;
res = data[0].pm;
cnt = 1;
first = false;
}
else
{
if (currid == data[i].idplayer)
{
cnt++;
ass += data[i].assists;
blk += data[i].blocks;
point += data[i].points;
reb += data[i].rebounds;
stl += data[i].steals;
res += data[i].pm;
}
else
{
//
item = new STDataSymbol5();
clTeam = new CTeam(connect, curteam);
clPlayer = new CPlayer(connect, currid);
stEP = clEP.GetEntryPlayerLast(data[i].idseason, currid);
item.team = clTeam.stTeam.name;
item.name = clPlayer.stPlayer.family + " " + clPlayer.stPlayer.name;
item.points = (1.0 * point) / cnt;
item.assists = (1.0 * ass) / cnt;
item.block = (1.0 * blk) / cnt;
item.rebounds = (1.0 * reb) / cnt;
item.steals = (1.0 * stl) / cnt;
item.res = res;
if (item.res > 30)
{
kf = 1.1;
}
if (item.res > 20 && item.res <= 30)
{
kf = 1.2;
}
if (item.res > 10 && item.res <= 20)
{
kf = 1.25;
}
if (item.res > 5 && item.res <= 10)
{
kf = 1.3;
}
if (item.res > 0 && item.res <= 5)
{
kf = 1.35;
}
if (item.res > -5 && item.res <= 0)
{
kf = 0.95;
}
if (item.res > -10 && item.res <= -5)
{
kf = 0.9;
}
if (item.res > -20 && item.res <= -10)
{
kf = 0.85;
}
if (item.res > -30 && item.res <= -20)
{
kf = 0.8;
}
if (item.res <= -30)
{
kf = 0.7;
}
if (stEP.amplua != null)
{
if (stEP.amplua == 1)
{
item.amplua = "защитник";
item.ball = ((item.points * 1.5) + (item.assists * 2.5) + item.rebounds +
(item.steals * 2) + item.block) * kf;
lst_defender.Add(item);
}
if (stEP.amplua == 2)
{
item.amplua = "форвард";
item.ball = ((item.points * 2.5) + (item.assists * 1.5) + item.rebounds +
item.steals + item.block) * kf;
lst_forward.Add(item);
}
if (stEP.amplua == 3)
{
item.amplua = "центровой";
item.ball = ((item.points + item.assists + (item.rebounds * 2.5) +
item.steals + (item.block * 2))) * kf;
lst_center.Add(item);
}
}
currid = data[i].idplayer;
curteam = data[i].idteam;
point = data[i].points;
reb = data[i].rebounds;
ass = data[i].assists;
stl = data[i].steals;
blk = data[i].blocks;
res = data[i].pm;
cnt = 1;
}
}
}
item = new STDataSymbol5();
clTeam = new CTeam(connect, curteam);
clPlayer = new CPlayer(connect, currid);
stEP = clEP.GetEntryPlayerLast(IS.idseason, currid);
item.team = clTeam.stTeam.name;
item.name = clPlayer.stPlayer.family + " " + clPlayer.stPlayer.name;
item.points = (1.0 * point) / cnt;
item.assists = (1.0 * ass) / cnt;
item.block = (1.0 * blk) / cnt;
item.rebounds = (1.0 * reb) / cnt;
item.steals = (1.0 * stl) / cnt;
item.res = res;
if (item.res > 30)
{
kf = 1.1;
}
if (item.res > 20 && item.res <= 30)
{
kf = 1.2;
}
if (item.res > 10 && item.res <= 20)
{
kf = 1.25;
}
if (item.res > 5 && item.res <= 10)
{
kf = 1.3;
}
if (item.res > 0 && item.res <= 5)
{
kf = 1.35;
}
if (item.res > -5 && item.res <= 0)
{
kf = 0.95;
}
if (item.res > -10 && item.res <= -5)
{
kf = 0.9;
}
if (item.res > -20 && item.res <= -10)
{
kf = 0.85;
}
if (item.res > -30 && item.res <= -20)
{
kf = 0.8;
}
if (item.res <= -30)
{
kf = 0.7;
}
if (stEP.amplua != null)
{
if (stEP.amplua == 1)
{
item.amplua = "защитник";
item.ball = ((item.points * 1.5) + (item.assists * 2.5) + item.rebounds +
(item.steals * 2) + item.block) * kf;
lst_defender.Add(item);
}
if (stEP.amplua == 2)
{
item.amplua = "форвард";
item.ball = ((item.points * 2.5) + (item.assists * 1.5) + item.rebounds +
item.steals + item.block) * kf;
lst_forward.Add(item);
}
if (stEP.amplua == 3)
{
item.amplua = "центровой";
item.ball = ((item.points + item.assists + (item.rebounds * 2.5) +
item.steals + (item.block * 2))) * kf;
lst_center.Add(item);
}
}
// сортируем по баллам
ListCompareByBall clComparyBall = new ListCompareByBall();
lst_center.Sort(clComparyBall);
lst_defender.Sort(clComparyBall);
lst_forward.Sort(clComparyBall);
// выводим в файл
int x = 1;
foreach (STDataSymbol5 set in lst_defender)
{
// if (x == 5) break;
sw.WriteLine(string.Format
("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>",
x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds,
set.assists, set.steals, set.block));
x++;
}
foreach (STDataSymbol5 set in lst_forward)
{
// if (x == 9) break;
sw.WriteLine(string.Format
("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>",
x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds,
set.assists, set.steals, set.block));
x++;
}
foreach (STDataSymbol5 set in lst_center)
{
// if (x == 11) break;
sw.WriteLine(string.Format
("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>",
x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds,
set.assists, set.steals, set.block));
x++;
}
sw.WriteLine("<p> </p>");
sw.WriteLine("<p><img src=\"\" alt=\"\" /></p>");
sw.WriteLine("<p> </p>");
sw.WriteLine("<p> </p>");
sw.WriteLine("------------");
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
}
static void Main(string[] args)
{
OAuthAccessToken accessToken = new OAuthAccessToken();
FlickrNet.Flickr f = null;
CWorker.BasePath = @"C:\TEMP\";
CWorker.DataBaseRootName = "FLICKRDB";
CDB db = CWorker.ReadDB();
if (db.GetOAuthToken == null)
{
accessToken.FullName = "Cloud2013";
accessToken.Token = "72157644879828272-04fe2e4af1f40866";
accessToken.UserId = "26095572@N07";
accessToken.TokenSecret = "02947f478d4b0cc1";
FlickrManager.OAuthToken = accessToken;
f = FlickrManager.GetAuthInstance("2c67273e05ae10a7001e5b569df4f7d1", "d8906735118cab71");
db.SetUser(accessToken.FullName, accessToken.UserId);
db.APIKey = "2c67273e05ae10a7001e5b569df4f7d1";
db.SharedSecret = "d8906735118cab71";
db.Token = accessToken.Token;
db.TokenSecret = accessToken.TokenSecret;
}
else
{
FlickrManager.OAuthToken = db.GetOAuthToken;
f = FlickrManager.GetAuthInstance(db.APIKey, db.SharedSecret);
}
int ndx = 0;
while (true)
{
PhotoCollection photo = f.PeopleGetPhotos(PhotoSearchExtras.Views, ndx++, 500);
if (photo.Count == 0)
{
break;
}
foreach (FlickrNet.Photo p in photo)
{
if (CWorker.NewEntry(p.PhotoId, db))
{
db.Photos.Add(new CPhoto(p.PhotoId, p.Title, p.ThumbnailUrl, p.LargeUrl, p.Views));
}
else
{
CPhoto thisPhoto = CWorker.GetPhotoRecord(p.PhotoId, db);
CStats record = CWorker.GetStatsRecord(thisPhoto, System.DateTime.Now);
if (record == null)
{
thisPhoto.Stats.Add(new CStats(p.Views));
}
else
{
if (p.Views == null)
{
p.Views = 0;
}
if (record.Views != Convert.ToInt32(p.Views))
{
record.Views = Convert.ToInt32(p.Views);
}
}
}
}
}
CWorker.StoreDB(db);
if (args.Length != 0)
{
CWorker.Exit(0, "Success");
}
}
public CDB Exec()
{
if (_DB.GetOAuthToken == null)
{
AccessToken.FullName = "Cloud2013";
AccessToken.Token = "72157644879828272-04fe2e4af1f40866";
AccessToken.UserId = "26095572@N07";
AccessToken.TokenSecret = "02947f478d4b0cc1";
FlickrManager.OAuthToken = AccessToken;
_F = FlickrManager.GetAuthInstance("2c67273e05ae10a7001e5b569df4f7d1", "d8906735118cab71");
_DB.SetUser(AccessToken.FullName, AccessToken.UserId);
_DB.APIKey = "2c67273e05ae10a7001e5b569df4f7d1";
_DB.SharedSecret = "d8906735118cab71";
_DB.Token = AccessToken.Token;
_DB.TokenSecret = AccessToken.TokenSecret;
}
else
{
FlickrManager.OAuthToken = _DB.GetOAuthToken;
_F = FlickrManager.GetAuthInstance(_DB.APIKey, _DB.SharedSecret);
}
int ndx = 0;
int update = 0;
int insert = 0;
int dup = 0;
while (true)
{
PhotoCollection photo = _F.PeopleGetPhotos(PhotoSearchExtras.Views, ndx++, 500);
if (photo.Count == 0)
{
break;
}
foreach (FlickrNet.Photo p in photo)
{
if (p.Views == null)
{
p.Views = 0;
}
if (CWorker.NewEntry(p.PhotoId, _DB))
{
_DB.Photos.Add(new CPhoto(p.PhotoId, p.Title, p.ThumbnailUrl, p.LargeUrl, p.Views));
}
else
{
CPhoto thisPhoto = CWorker.GetPhotoRecord(p.PhotoId, _DB);
CStats record = CWorker.GetStatsRecord(thisPhoto, System.DateTime.Now);
if (record == null)
{
if (p.Views != 0)//add only if non-zero
{
thisPhoto.Stats.Add(new CStats(p.Views));
insert++;
}
}
else
{
string dt = CWorker.DT2Str(System.DateTime.Now);
for (int xdx = 0; ndx != thisPhoto.Stats.Count; xdx++)
{
if (thisPhoto.Stats[xdx].Date == dt)
{
if (thisPhoto.Stats[xdx].Views != record.Views)
{
thisPhoto.Stats[xdx].Views = record.Views;
update++;
}
else
{
dup++;
}
break;
}
}
}
}
}
}
return(_DB);
}
private CControl Control(CBody mCBody, CStats mCStats, CMovement mCMovement, CRender mCRender)
{
return(new CControl(_game, mCStats, mCBody, mCMovement, mCRender));
}
private CAI AI(CStats mCStats, CBody mCBody, CMovement mCMovement, CRender mCRender, CLineOfSight mCLineOfSight)
{
return(new CAI(_game, mCStats, mCBody, mCMovement, mCRender, mCLineOfSight));
}
private List <STDataRating> calculate()
{
List <STDataRating> ret = new List <STDataRating>();
STDataRating item;
CPlayer clPlayer;
List <STPlayer> lst_player;
STPlayerParam paramPlayer = new STPlayerParam();
paramPlayer.idseason = null;
CStats clStats;
List <STStats> stStats;
STParamStats paramStats;
CEntryPlayers clEP;
STEntryPlayers stEP;
int idteam = 0;
CTeam clTeam;
try
{
clPlayer = new CPlayer(connect);
clStats = new CStats(connect);
clEP = new CEntryPlayers(connect);
lst_player = clPlayer.GetList(paramPlayer);
foreach (STPlayer st in lst_player)
{
item = new STDataRating();
clPlayer = new CPlayer(connect, st.idplayer);
item.name = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name,
clPlayer.stPlayer.payname);
idteam = clEP.IsEntryPlayer(IS.idseason, st.idplayer);
if (idteam > 0)
{
clTeam = new CTeam(connect, idteam);
item.nameteam = clTeam.stTeam.name;
}
else
{
item.nameteam = "не заявлен в текущем сезоне";
}
paramStats = new STParamStats();
paramStats.idplayer = st.idplayer;
stStats = clStats.GetStats(paramStats);
foreach (STStats stst in stStats)
{
item.cntgame++;
item.points += stst.points;
item.rebounds += stst.rebounds;
item.steals += stst.steals;
item.fouls += stst.psfouls;
item.blocks += stst.blocks;
item.assists += stst.assists;
}
ret.Add(item);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
return(ret);
}
