can a module create a database on install?

[neilt]

Hi

I've written a nice module feature that doesn't exist (probably going to need to be ported to a component) which takes a parameter (days) and emails authors when their pages are due to expire (x) days in advance, then once a day until expiry.

It also keeps a nice list module in administrator view.

1) Unfortunately at present this works manually when an the /administrator site is logged into (which would need to be once a day)

2) It has a very small database to hold the id and date of each 'warned' content so they are only warned once a day. This database can only be created automatically via a component install, is that right? or can I do this in the modules XML

3) Can I automate the running of this module so it is independant of Admin login? I've tried just the script on a Win scheduled task but as It's not been able to log in it's not run.

================

Would like to know if there are any developers who would like to help take this further, perhaps into a component to really assist the whole Mambo community?

Neil

[scox]

my way:
- creating a component cause of the tables you need.
- create a php file which will trigger the mail event (it only has to call your function.. and create a dummy mambo enviroment)
- create a cronjob or windows schedule that will open the php file you created for this purpose
this will trigger the mail-send event and done...
- secure the folder where this php file lies, with some password restriction or something like that

another thing would be to use the robot.txt and wait wor a indexing routine.... (not shure if this can be done taht way ^^)

OR
trigger the event from the frontend
someone will open your site during the day ... i hope ^^

[neilt]

cheers scox, I'll have more of a play then post it for all to use. Maybe a requirement for v5 if not already included.

Neil

[scox]

? don't get it..... (my english skillz sukkors ^^)
why? what? for all to use?

if your site is opened, you check if there are mails to send, or if the mails for today have already been sent.... then send the rest


i'd say that every user can set the days untill he wants to be notified....

[neilt]

sorry, didn't mean for all my users, I mean I'll clean my code and submit for any other interested Mambo users

Neil