<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">The reason for storing the last
registation with the subscriber is, as Alexandr says, so it is
permanent. If I have a million accounts I can see how many have
registered within the last month etc, not just how many are online
at one point.<br>
<br>
If an event_route can be run when the contact is inserted (i.e. on
a UL_CONTACT_INSERT callback) then we could use sqlops to update
this info in any table, including subscriber. I don't believe
there is one though.<br>
This patch stores the time of successful registrations at the
point that they are inserted, not when they expire, or when they
are successfully un-registered.<br>
<br>
Maybe this patch is too specific, and making event routes for the
usrloc callbacks would be more flexible?<br>
<br>
Hugh<br>
<br>
<br>
On 13/03/2014 20:18, Olle E. Johansson wrote:<br>
</div>
<blockquote
cite="mid:DD7C077E-8ECC-433A-A02F-997A7721D168@edvina.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<br>
<div>
<div>On 13 Mar 2014, at 19:51, Alexandr Dubovikov <<a
moz-do-not-send="true"
href="mailto:alexandr.dubovikov@gmail.com">alexandr.dubovikov@gmail.com</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div dir="ltr">maybe because after AOR's expire this
information will be deleted ?</div>
</blockquote>
And now we have an event_route to insert something in any table
at that point...</div>
<div><br>
</div>
<div>I still don't understand how it belongs to the subscriber
table.</div>
<div><br>
</div>
<div>/O<br>
<blockquote type="cite">
<div dir="ltr">
<div><br>
</div>
<div><br>
<div><br>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Mar 13, 2014 at 6:49 PM,
Olle E. Johansson <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:oej@edvina.net"
target="_blank">oej@edvina.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word"><br>
<div>
<div>
<div class="h5">
<div>On 13 Mar 2014, at 18:30, Hugh Waite <<a
moz-do-not-send="true"
href="mailto:hugh.waite@crocodile-rcs.com"
target="_blank">hugh.waite@crocodile-rcs.com</a>>
wrote:</div>
<br>
<blockquote type="cite">
<div link="blue" vlink="purple"
style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"
lang="EN-GB">
<div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Hello,</div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">We
have added a feature to auth_db which
will update the time of the last
successful login in the subscriber
table. This gives an easy way to find
the number of active users in the past
day/week/month etc.</div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Please
send me any comments on the attached
patch.</div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">There
will of course be documentation in the
final cut!</div>
<div style="margin:0cm 0cm
0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"> </div>
</div>
</div>
</blockquote>
</div>
</div>
That information is already in the location table -
why do you want it in the subscriber table too?</div>
<div><br>
</div>
<div>There's no "login" in SIP - what are you
documenting here?</div>
<span class="HOEnZb"><font color="#888888">
<div><br>
</div>
<div>/O</div>
</font></span></div>
<br>
_______________________________________________<br>
sr-dev mailing list<br>
<a moz-do-not-send="true"
href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>
<a moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev"
target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>
<br>
</blockquote>
</div>
<br>
</div>
_______________________________________________<br>
sr-dev mailing list<br>
<a moz-do-not-send="true"
href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
sr-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-dev@lists.sip-router.org">sr-dev@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Hugh Waite
Principal Design Engineer
Crocodile RCS Ltd.</pre>
</body>
</html>