Oh i forget an main fact. You can register you for an product/article. So then you get an email with the registration-link, after you have clicked the article is your. When you forget to click or an other person used your email so you wait 24h and the reserveation ist kill ;) Util this 24h the article is pending after that without clicking the link the aricle is free. When you click the normally the article is fix or registrated. I want that this usecase runs alone. In this moment i whatch ervery day and set the status by myself...
On 20 Jan., 11:05, robustsolution <[email protected]> wrote: > AFAIK, triggers in MySQL do not behave like a bomb(timer), I may be > wrong, but this is what I know so far! > > As for the solution of your problem, I think every time a new user > registers, do a simple query to delete the old registered users that > are not activated yet and where there registration date is more than > 24 hours ago... > > just keep it simple man. > > have a nice baking day > > On Jan 20, 9:08 am, amarradi <[email protected]> wrote: > > > Hello, > > > i need nelp by development an trigger. > > I've an app were you can get an registration. So if you ask for one > > you get an email with a link an the status is reserve. If you don't > > click the link in the next 24h you will no be registrated. Your > > reservation is killed ;) > > The first time i think i do the job direct on the MySQL Database. But > > the Problem i don't have rights on the webspace from my shared hoster. > > What can i do to trigger it? > > > many greetings > > Marcus Radisch
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
