ResultsAPI - a Drupal API & module for sports events & more

Events happening in the community are now at Drupal community events on www.drupal.org.
derhasi's picture

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.

AttachmentSize
HOOKS.pdf34.31 KB

Comments

Interested and willing

Cayenne's picture

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

  1. A way to take in and then deal with individual results for reporting purposes
  2. Display of event results, optionally calculated by off-site scoring program or internal rules (complex in sailing)
  3. Display of series results. We usually have 3-11 races making up a series.

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

derhasi's picture

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 ;)

Okay, I'll take a look.

Cayenne's picture

Okay, I'll take a look.

I created some first central

derhasi's picture

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

Roulion's picture

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?

Nick Brown's picture

Is this module still under development?

I still try to work on such a

derhasi's picture

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

fw_crocodile's picture

I'm working on a similar module, focused on events like bicycle race.

My needs are:

  • Events page, with maps(image, openstreetmap, google, etc...), promoter, contact data, description
  • User subscriptions, may be we can use the subscriptions module?
  • Results, ability to add results table to any type of node
  • Linking result with user uid in case it's a registered user
  • Showing personal result in User profile page

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

derhasi's picture

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

spuggy's picture

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

derhasi's picture

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

lisabrown's picture

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

adamhealyZA's picture

This is exactly the kind of thing I am looking for. Has there been any progress on this idea?

Contributed Module Ideas

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week