In http://groups.drupal.org/node/13804#comment-47194 I allready proposed my module idea of a general sport result and tournament management/calculation. Therefore I thought about a database/API that should provide saving and deriving necessary data and additional information and relations.
Today I started to work on the module. Below you can look at the database-structure and some short description about the main idea.
My first step will be to code a small api for writing and reading the database. Then I will try to implement [url=http://www.liga-manager-online.de]LMO[/url] and http://drupal.org/project/lmo due to an actual website project.
If you have any ideas, suggestions or wnat to help... Let me know ;)
EDIT:
I removed the old database structure, because i changed it generally, so this is the new one
{results_event}
id int 11
type varchar 32
name varchar 256
relid int 11
reltype varchar 32
{results_participant}
id int 11
type varchar 32
name varchar 256
relid int 11
reltype varchar 32
{results_values}
eid int 11
pid int 11
scope varchar 256
type varchar 128
offset int 4
val1 varchar 256
val2 varchar 256
val3 varchar 256
obj text
derive bool
{results_infos}
eid int 11
pid int 11
type varchar 32
info text
{results_hierarchy}
type varchar 32
id int 11
parent int 11
Hooks
I attached 1 documents describing the hook's return valuese.
| Attachment | Size |
|---|---|
| HOOKS.pdf | 34.31 KB |

Comments
Interested and willing
Hi there. I had been just about to gear up for a similar project for sailboat racing, and there you are!
What I had conceived as my top-level requirements are
I have developed a java program that does all of the above, but not in Drupal, of course. I'd like to simply click a button and have a table of results uploaded to a Drupal site with all the goodness that entails.
If a data format can be developed that is robust, inclusive, and extensible, to cover running, sailing, etc, that'd be great. More important, the actual code. I am holding at D5 for now, but long-range planning is a good thing. There is a beginning discussion of this at the Sailing group as well.
Currently there is no code
Currently there is no code progress of the module, because I thought about a lot of different concepts to implement existing structures, like CCK, Views and Trigger/Rules. So there is no code to test at the moment.
My current concept ist like:
building a structure that can
* define content as Event or Participant
* create (ordered) Collections of Events or Participants that are assigned to other Events/Participants (e.g. Championships / Teams)
* retrieving contest-data from different types of data
** existing nodes (with event - participant relations)
** different existing fields (textarea, textfield)
** external sources (rss-feeds, rdf,...)
** enter new data
=> that will have a need to build an flexible "catch data"-process
* derive new/complex contest data and ranking data from existing contest-data
** therefore deriving from collection-items' data to collection data has to be possible
* storing necessary loggable data
* fire derivation on special actions (trigger / rules)
* provide flexible views fields for views-supported display of data
* provide a flexible form to input data ( for example using CCK, perhaps with CCK combo field)
so, my next step will be to concrete these issues to concrete hooks and api functions.
if you want to help in some parts of integration, you'll be welcome ;)
current concept
current concept on:
http://bazaar.launchpad.net/~derhaside/results/head/annotate/head:/docs/...
Okay, I'll take a look.
Okay, I'll take a look.
I created some first central
I created some first central functions and will start the module with some light view on the central problem.
central problem:
- save data to a subject P in a specific scope E
=> translated: save data of a participant P in an event E
- derive new data from existing
current code is still on http://bazaar.launchpad.net/~derhaside/results/head/files
do you think you can enable
do you think you can enable a pronostic system where users could try to foresse the scores.
We can add a point system : for example, good pronostic (w/DL = 1points, good score : 3points). The ideal thing would be a customizable rule system where you can configure the how points...
I've been looking for such a module for a very long time
Dead?
Is this module still under development?
I still try to work on such a
I still try to work on such a module, but at the moment development is frozen, due lack of time.
Do you have any thoughts about it?
Hi
I'm working on a similar module, focused on events like bicycle race.
My needs are:
I see you start a more wide project, but nothing is still working.
As I need to have some working things in the next months, and as there is not much sense to continue working on a module with less perspective like mine.
May be we could reach a basic design specification on which I could start to work with you and start writing some code.
Oh fw_crocodile, that's a
Oh fw_crocodile, that's a good idea ;)
What kind of result do you want to be able to store. The Problem is that the necessary data for results varies in different cases (sports: soccer, motorsport, ...).
The last weeks I could not work on any actual concept, as there are a lot of cool new modules, reworking my ideas is heavily necessary. But I plan to do a rewrite on my motorsports site (zugspitzpokal.de) in January for implementing results, so there's also need for me to work on this issue.
Please post your ideas! (here or in the issue queue of http://drupal.org/project/results)
Good luck
I hope you guys pull this off as it seems like a lot of people are very interrested in this type of module and it has been needed for a long time. Good luck. Let me know if I can help in any way.
I'm currently working on an
I'm currently working on an Stats API, that will build one base for Results.module.
Current work of Stats API lays on http://github.com/derhasi/Derhasi-Drupal-Modules-dev/tree/master/stats/ . The basics should be implemented but hadn't tested it so far.
The Drupal API and module for
I gave NetBeans a try as I was hoping to find something a little faster than Eclipse + PDT. The biggest issue I found was that NetBeans couldn't import files via drag and drop from the Finder, or do anything like Eclipse's "Import" wizards. AFAIK, the only way to import external files into a NetBeans PHP project is to do it outside of the IDE, and then refresh it so it picks up the changes.
The Drupal plugin is really cool though. The "Drupal hooks" palette is very useful. I just wish you could auto-complete Drupal hooks with CTRL-Space, but perhaps in the future :)
Status on this module
This is exactly the kind of thing I am looking for. Has there been any progress on this idea?