[TYPO3-project-seminars] Calendar Base and Seminar...

[Kim Holberg Andersen]

Thanks Niels,

must dig into my big bible of php and MySQL to get a clue about this -
but very exciting and challenging for a wannabe like me... :-)

Kim


Den 13/04/2008 kl. 14.59 skrev Niels Pardon:

> Hi Kim!
>
> Kim Holberg Andersen schrieb:
>> "Basically there is one question: is there an option in the database
>> table of tx_seminar, which defines "available", "limited", or "sold
>> out"? If not, could you create it during an sql query?"
>>
>> I cannot answer this as i have no experience with sql databases and  
>> sql
>> queries.
>>
>
> You can count all registered seats from tx_seminars_attendances for a
> specific event and compare it with the attendances_max and
> attendances_min columns in tx_seminars_seminar for the event.
>
> - number of registered seats < attendances_min => available
> - number of registered seats < attendances_max and number of  
> registered
> seats >= attendances_min => enough
> - number of registered seats = attendances_max => sold out
>
> You can have a look at the seminars source code
> (tx_seminars_seminar->countAttendances()) to get an idea how the sql
> query could look like.
>
> Greets,
>
> Niels
> _______________________________________________
> TYPO3-project-seminars mailing list
> TYPO3-project-seminars at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-seminars