On Tuesday 24 June 2003 3:13 am, Tomas Bozsaky wrote: > hello, > > mysql does not support triggers. function inside mysql - you can, but > i do not know, how.
According to the features, this is scheduled for inclusion in mysql version 5.0. The problem is that the current production release is 4.0.13 while the "alpha" test version is 4.1 -- in other words, "not yet, but soon..." > Tuesday, June 24, 2003, 11:42:39 AM, Truong wrote: > > Can I ask a question : > > How can I update to mySQL database automatically a table that store money > > that users must charge for the sections their connection? I'm seeing this question surface more and more -- perhaps I'm attuned to it because I'm already doing something similar -- but I'll interject before the rest of the developers do and point out that this really isn't a function of "radius" per se. Radius is almost strictly devoted to answering the question "are you allowed to be here?" [and has a side feature of tracking how often you visit and how long you stay] The twist to this is that part of the answer to "are you allowed to be here?" is "have you paid for your admission ticket?", which is an obscure way of rewording your question, and I'll bet the developers will roll their eyes and groan because thinking about it that way DOES make monatary tracking a part of "radius", and I'm sure they don't want to venture into that territory :) Now, all that aside, let me ask in return: are you thinking of a "pre-paid" system wherein users will pay for access in advance, or more of a bar-tab scenario where upon logout you issue a charge based on how long they were actually online? [and perhaps bill them only when it exceeds a certain amount] With a pre-paid system, this is fairly easy to implement using a "counter" [hint: consider "reset=never" and a counter limit of 3600 seconds] With a charge-after-use system, it would probably be better to write a program to read the "accounting log" files and generate real transactions in an accounts receivables program -- Yet another Blog: http://osnut.homelinux.net
pgp00000.pgp
Description: signature
