FootyStat.com

Last term we had to make a basic inventory management system for a computer store, the computer store had a number of different suppliers who provided the parts and a PC would be built according to a customers specifications.

The program has relatively simple functions, it can add/edit/delete a product, display products by category e.t.c

You can download the installation here [Cafe Application]

The .Net Framework is required, and I believe it will offer to download it for you if you don’t already have it.

I created some sample interface screens in Microsoft Visio, I think it gives you an idea of how I want the program to looks and work.

• The Main Game Screen

This is what will be on the screen when the soccer game is in action, then if a player commits an action you just double click the players name and the next screen pops up

• The Action Screen

This is the sample Actions Screen, this is what will appear once a player is double clicked from the Main Game Screen here you select the action that the player has performed/committed.

• The Goal Action

If the action committed is a Goal scored this is what pops up, and you check the appropriate boxes, if the goal was a penalty, Own goal etc.

Once you press OK, all the information that has been collected should be recorder in the database, and you return to the Main Game Screen.

So im taking a digital marketing class this semester, its pretty interesting and they have people from the industry come and talk to us every week.

Today we had Vinny Lingham from incuBeta which manages search engine advertising campaigns for people among other things. He is also currently launching www.synthasite.com which is an online AJAX powered website builder which is currently still in alpha mode.

Thats a South Park reference in case your are wondering what Im on about. So im back in Uni, the holidays were mostly uneventful except for the whole malaria bit.

Im gonna be getting back on track in the next few days, I feel like I forgot most of the VB.net syntax again, I hate that feeling,but im sure it will come back its like riding a bike right?

Well I have had a few minor setbacks ever since coming home to Tanzania which will effect the progress a bit.

First my computer here isn’t up to scratch to run Visual Studio its simply too old. Internet access is another issue, as it’s mostly through Internet Cafes which are slow as hell.

Lastly I got Malaria within the first 3 days of arriving, Im almost rid of it now, but not quite 100% yet.

But these are all just setbacks and will not derail the project completely.

Later.

I am currently in the middle of my exams, Database Design and Business Communication went well, only Company Law still left to go.

Thats why updates haven’t been happening lately, hopefully soon after the 14th I can get back on track.

I bought myself a new 512Mb Ram stick today, the 256Mb on my aging PC wasn’t cutting it anymore.

While searching for which ram technology my Motherboard supports I came across a great site, www.crucial.com.

You can select your PC manufacturer and model and they will tell you which ram you can use, they even have a scanner which will do it automatically if you don’t know any details about your PC.

Now if could only get my hands on a GeForce 7600GT then i would really be ballin………

Haha!! I said we would get them in the FA Cup and we did!!! Congrats to Chelsea for the double, Drogba came through as usual and without some key injuries throughout the season who knows what could have happened, quadruple anyone?

So anywho, here is the Database diagram as it stands now, it went through a few iterations, but the first one was getting really messy so after with some advice from www.daniweb.com I decided to go with the simpler second one.

First messy Idea. As you can see the relationships were getting a little out of pocket so I had to pimp slap em’ into a table of their own!

Second Diagram, the one I will be using:

I have to say this Wordpress Blog is impressive!!

So yeah there we go, from here on I guess its down to the dirty work of making the DB and witting the actual program, I might also post some user interface designs I have been messing around with.

So some Virus or rather Trojan to be correct is running rampant on our school network. It doesn’t seem to do much except mess up your start menu, and attempt to download something but since I don’t have net on my PC its not a problem.

Now McAfee provides free AV software to every student at UCT god bless their soul, but for some strange reason it can only detect the virus when you do the manual scan, otherwise you can copy, execute or what ever with the virus but McAfee wont notice anything.

Our ICTS department has come up with a fix of their own until McAfee come out with an update. The fix can be found HERE. The Virus is called New malware.d

 Hi everyone!!

First congrats to Man U for winning the Premier League, but we will get you in the FA Cup!!!!!

So I have “completed” most of my school work for now, its basicly just waiting for the exams in June now. So Im going to post the objectives and scope of the system we are going to create, please bear in mind that these might change as we go allong and realise new requirements or decide to drop some.

Objective

Design an easy to use Football statistics capturing program, the program should be able to capture and record these statistics in “real time”.

It should have a user friendly GUI which will enable users to get to grips with it quickly without too much training.

The stats should be recorder to a database file, this will make it easy to perform various calculations based on the data such as top scorer, league standings etc.

Scope

Implement a VB.Net Application and an Access Database to store the stats.

The DB will store info about The Players, The Teams and the Matches,

Stats that will be stored will be:

• Goals
• Fouls
• Corners
• Red Cards
• Yellow Cards
• Free Kicks
• Penalties
• Possession %
• Shots on Goal
• Shots off Goal
• Offside

From these it will be possible to calculate:

• Top scorer
• Winner/Looser
• Points
• League standing
• Total Goals/Fouls/Cards etc  for any team

Out of Scope

Web site that will enable people to view stats Live.

Soccer Rules

Full rules and regulations as per FIFA© can be obtained here.

Please note that we will not be strictly enforcing all of these rules as it may render the program useless in matches where slightly different rules are used, such as a friendly. Also a lot of them don’t apply to us just to the players, like equipment etc.

Whats Next?

Next I will be posting my proposed Database design, I am just working out the final details right now and making the databse diagram with Microsoft Visio.