Hi All…
First off license query… The site to be created is for a local sports club - rugby. I will be producing the site for free as a learning experience for myself (was hoping for a ee2.0 learning experience!). They are a club that does not run for profit, all money they make is put back into the club for development, clubhouse and facilities improvements, equipments, junior teams, etc. However, i was contemplating adding a bit of advertising to the site to try and increase income, that could be invested for the mini teams. Now my mind tells me a personal - non profit license is fine for this, but i would prefer a confirmation.
Also to confirm that i have a personal license on a site i was asked to develop that they never decided to use. I assume it would be fine to use this license assuming the other install is completely removed and the license is still active.

Second…
I have pretty much everything planned out and know how i could, would, will do it…
However, my stumbling block is how to manage the league table. I cannot go to a full blown system which records all teams and each of their results as this information is not always available.

This would suggest to me that making a static html based table would be best. However, i want to use the table in a couple of places (mini view, and full table), and i want the teams order to be auto sorted when the information is updated.

any ideas of a quick and easy way to do this? or a existing wonderful plugin! I may make one when EE2 comes about, but not much point until then as CI will make this a lot easier!

Thanks, N

Hi Nevsie,

A Personal license is just fine for the project as described.

As to the league table, I’d go with a dedicated weblog with each team as a category. This would let you use the data anywhere you want and you could update as necessary. Though, it might be better to whip up a static table as a starting point and then post in the How To forum for suggestions on integrating it with EE.

How well do you know EE and its capabilities?
Here is a tutorial I just finished following by Boyink tutorial. HIGHLY informative.
I suggest you follow this tutorial also. Although you may already KNOW what you want, as I did, this may give you some more ideas on how to best structure your back-end.
It really helped me!

I am a big fan of jQuery. Maybe something like this will suit you?
Ingrid, the jQuery Datagrid
jQuery plugin: Tablesorter 2.0

Hi,
@ OF - thanks for the tutorial. Although i feel i know it pretty well it cannot harm to read through and get ideas of other directions or approaches.

@ Leslie
Currently i have the same site running on Joomla, and although i get on with Joomla, i find it slow, seriously lagging, and still quite strict layouts. I know the new joomla gives 1000% more template control, and the new joomla API is good… but it is just slow and tedious to develop… Anyway… i have the tables laid out and planed there already… So to the How to with them i guess…

But a brief question… when you say make each team a category… I was actually thinking of making each team a post and then just updating the post - the reason i did not do this was because going into the “edit - > sort by weblog” seemed to add too many steps for updating each week.

Are you suggesting that by making each team in the league a category, i could then either:
-> update each team individually and only display the latest record for that team.
or
-> update each team individually and add all the records together for that team (full stats).

or did i miss your point all together?

Cheers, N

update each team individually and only display the latest record for that team.

This is what I was thinking. This would also let you do other things with the information if you wanted to because you’d have a real history of the information v. just whatever the latest score was. 3 years from now having that data could be fun as you could track win/loss records over time, or whatever else.

hmmm… yeah i see where your going with that… and relatively easy for other people to update too…
my mind did just wander again to another idea…!!!
a category for each team - or even a post for each team. with a row or field for each team again. Then that way you do get to record each match (if we can get access to each match result) and build the table out from there (minus bonus and penalty points!)... i got keep thinking and make a choice on time and ease i guess!