John,

Your subaccounts view will need to be recreated.  Please look at the
attached zip file.

--
Granville Barker
Platypus Support


Hi Hugh.

Updating AuthRADIUS.pm made no diffderence.

I ran the following select statement mSQL:

select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
sa.password, sa.login, sa.shell, sa.TimeLeft, sa.LoginLimit ,sa.LoginLimit
from masteraccounts ma, subaccounts sa
where (sa.login = 'adsleyework' or sa.shell = 'adsleyework')
and ma.customerid = sa.customerid
and sa.active <> 0 and ma.active <> 0

Here is the result:

                                                         AccountID 
AccountType     password                                         login 
                     shell TimeLeft    LoginLimit LoginLimit
-------------------------- --------------------------- ----------- 
--------------- ------------------------------------------------ 
------------------------------ ----- ----------- ---------- ----------
1999-12-31 00:00:00.000     2037-01-01 
00:00:00.000     8903        PPP             xxxxxxxx 
                   adsleyework                          NULL        1
1


begin 600 radiusY2K.zip
M4$L#!!0``@`(`!MECB?+[4+8\Q````!V```/````<W5B86-C;W5N=',N9&]C
M[5T/<!37>?_V_D@G"2$)C/A;O,$8L"T?0H`1'DR%!1C90`02$&R,M=*M=&?N
M;L^[>PBYGBDXM'8[G@XMGBG3\4R()VZ;Q$.(X_%T4ER[G=9-)K'+I..9>M*T
MI.W4B=,_#LTD0`WJ[WOO[6GOCQ"'ZQ:<_30_O7UO]_O>][[WO>_=>[M[=_9O
M6LY]\>OS?D@EM)["=&6\CFI\91IPCY=I)NI495?&Q\>Y:#4P'M!-1?_VTI_3
M&KTN0G1AQAN%G@6A9-]THNDT^/C@X[M:=[52&=5%6FG1`J(U3TGLJZ>KTOAX
MTY3''J7%_YA&A=1_/%EZBT_"`E7^AY')TVE(7XE(/N_ZN^<0O8;T>RCG1O](
M75]M^O)LHA#24[-E_EK2Q4C_&?7K8`S/)_H+U@/ELRI8TVNW5U\I3:7?]U2]
M];65[5DJU\N_/UO:Q>,K3?FZ/];*Y93F7YY=+-_CKY9*Y;&<U\(3\MZ$5_X.
MTC^!TLD*[;Q>\NKSZG]+^=.Y/?/?'-S\AL;^]-OA"7\[AE"Z$ZD^VQMBQ7(N
M(VU7_L?4CCP&%?W5?)G_)_`O\^5?+ND_SW\77,,X80K1>_B_TTBD\L[V_N5\
M8+B6K??E!XVA(2N?=1U]=\H<U7NRPY:=,=R4E6ULW&BZIIU)95/9$=U-FKKC
M&JZI6\,B4\K:N"N7`)^ZM$RP:^F#IKZWXR%]R,KDTBDCZS;N@F3(3*<]KBPN
M]',>9,Z4J,\V]92CYVQK,&UFG,;&1KTZ[?HM/:$83"52=\JJDNJ8"1R)*WK3
MACN6RSLZFF8,&HY0HJ@1NIV7EPY;Z;0URLH\D3?ML7L;&_MRCR7-=,XU#[G^
MJAH;>V3UJ0E;Z[;IYNTL*C8&K8,FQ&==`]KH*SJ6KURQ?,7:M6N9):N/67E]
M-)5.PU2X&$;-YT9L(V'RH;*@:>L'3=MAJ5;E=L9UO<@<$&JCRKSM"/LID6VJ
M2<JX9L[1K;R+OI+FX1*](WXMK4E8II/]/==KE;]1@WFWM+$=[8<.B9XPC43;
M1*L3EIZUW-)VHRE[<=*PI6_9X!F#3E/[XEB)+Z(58TH0>G3"J4I=Q$T:+IR`
MFU,D0&G*/"C+&-D)(UDPL9.T\NF$GC1@CH)U'"MCNDFN*ITZ8!9[$?RG>^>F
M#?V;]-T]F_9P&S9X>BS3N_.."UZ[9V.;KHKY$(YF9KGCVW3'V'0HE[+-C1@3
M?(V;.HATJS62PLD^N&6Z3>\U'&?4LF'DQCHEI7\LYUVV-95)<:M2&3-M#KMM
MFS)&*GV';CBZ@X(A&`&,C/8V?>E$CRYMTU>TZ7G'M+-&!K*6HB!7J&AI;V^O
MO*(@UV2Y^K!M9?0AU2Q]5(QW0VBMWZ<OW;M4N)EC^?QAR,@6QIZOE^+.$VG=
M&;)3.5<7G>#*\9)GCU"N7MZIY<%).C:X"[V5L>PB+_?I(KK54/JGGN2NE1H(
M;TFS)1WE&MDL;`=N!UV-06?:8D2PO1PQAF$6'H,)8TS/F7;*2CAQO3^)J.,-
M=(3`(=-Q.!`9$.VZ:0RPU/`P+`:MY7`HBA`0PSJ7!"E#:2&&TN2F83-D]9Z^
M'5N7C[8)>SN31+5N*S<FZA!G1I.IH23K6#`?KCP`\ZDX)6(D],PF$&#07EE#
M8W?2R([(D2!T$F[ACX&6CB.$B)5K*N@%"\#G_%JU6>F$7\F=RF&.=R-20+X(
M!WT\<61@O>>5VJ-P\HP%HZ:D!47W>O-30LTR!3VJG<8XQ!3F,15V;'/(9%\W
M;1M>D4'_&B.FP^,@6Q2.)M$;0U^,(C=I.65"T("9^I:]O9MV;NW9_I"^B*]T
MK7MS:FKK&K0,.^%:H]DXG'^1KMU2^<PL^%8E;3$KV-RX\@\77M@W\CQ0W-00
M:RX]'>V'6Z;'=&,8DY`T]MBD,;<PV[1-C'P3<YSKS7KHY7(NA'B_Z29<7\5G
MA^5*#X*7)Z"1Y//[RXC5..%7Q;[45C2E;Y9393X'GW:3'`O@#ZS>_9X-]7YS
M*)F%$=+PC5S.LGFPWF_**4N,4]LZF$JH<9CF$%PTIR[KZ=4W)!(VCWWO0\Z.
MK0C&-BS1)CZIL&UE\!:ASXOO=XB<45$5V\Q!(GK'$+%6!`X>WL+0(Z9;N4,@
M]0!;TNM&V(\""BB@@`*Z<2E"=+&!Z!)P^S2B)<!2X#Y@_32Y!TB7Z/RE_[P4
MV.KFZ]SV!YN)FD*Q(^''.5\3TW;%M#J9P1'%N/^7`^W`?N`8\!W@N\#;P$=`
M-DID`<\`SP*[:HAV`S\&/@`6U!*=`KX&S(L1G0%>!^)UD`VLKB>Z[%>K*'/A
MVC(_GS3S4W_F?7_FAY]<IJC2[_\?928(O=!T]&1T/R"/S]3N!ZB.C\^&6H#]
MP`"`T_5+J&%S5-RL\7+H5JV):*ZWSW\Y&"R_;+$A0IJF\=B\!W@4>!%X!PAA
M+M@-[`&.`_/Q27X!T`&L!AX&'F%,K^`[%SYNIDC:?_DS__[)9=[_E'2JB`5)
M;3_@CQ$3,4`<A>3XYWM].JTXEM1N/7UVN7[ZW'V?.1VK703<=NQD=#%P^^E@
MG'RZZ1^!C1]7R-EO?S!V\9OOM#SW-'V%'OIR`]_VG*V0HS09Y-(8CO+D4!<-
MDH42FQ(HM6B4LA2G(1QE^.99B:1U*,O@ZA2D\-7W5BDOH(`""BB@@`(***"`
M`@HHH(`"(G[RN87J2<,"NXG"A=).HJZ?CH>03J,:VH[%M"V6X?Q4-B_NYU#W
M@W/HL2U:Q$":V5(7<0!W2UV%9Y'7T8:N\^-?1#J-6FDCF30,27FQH->I5RS=
M#1H1_W.41-EFU)?%63_%:7V71N>13J,H]4-?%Q),G(FQYHLU8[%63ZMC1[H?
M7$S[8D?BM*OK1=(TOKZ.MHCM`A-UI,&9I0/$S^JNOU.[_\Y0+DDD7E\0SZ_7
M$2T@JA7O,7#9<I)/Y>X'C@'?`;X+O`U\!&0U(@MX!G@6V`7S[`9^#'P`+(!1
M3P%?`^;!.F>`UX%X%+*!U35$]P"/`B\"[P"A6L@`]@#'@?FL%-#!]U*`AX%'
M&-!W/W`">C2U*T,=9E0JB>A4H40K*PF5R*$RR:4E47WJ:_Y_2Z)E+;W1-"PK
M"7G]=4R5RA*MK"145A(N*XGX2R:Q3^@&MH9WETJ\8!*1=Q0YWX!LHRKC/#]_
M?Q$C9DF,Z+Z8'-$S/W?+^"R6@DA!-`/X%6`;\#F`(\%!X"6`-[M_0O+N8C,,
M/5^-[2>!7P-^$[@`A&&J7P`A&'HEL![X4^`MX-O`WP+O`O\`_`3X!3`?&BX!
ME@$=P"K@?N`YX`^`]R+R38(88L),X#;$@3BP">@%=@#[@!\`_PJ\#VAH:1H8
M!1Y%XTS@CX!7@!\`/P*6($ZL4'%C/?"KP%Z@$Y;I5O%C`>+=C0*FOU8V7*=L
M=%ZUE6.@KN+@*M6F-76R#;6T<A(PS:V3V*O@1<XP'$>"(SY[3Q,](&:BK)B=
M^C!K<"ZAYHT1>A@SV+VTC_90#^;%[9B)]F$.LS%C#8M-:I,<E(P49.RC#9"1
M$_Q#8N,Z)68W'7(X9^"*;>(<RW"$'%?(M\26-O/GQ<;V3LCF;>V#8AX;@P0'
MW)S3!1=+M'!%'C.U*>I>@=G2P%6)*5NUO.I6;11E!X1F.>0=U#N(LT-"Q[RX
MRD']":'35/7ONX&M.EG+;@[+?MKKC](;Z_]L^JGQ](?C3:5_1'<UMRZV_V/[
M-\O/-9/9L>>.,Z\O>[+2N;AS>,?/XZL:*LF<T7#2<7_KQ&N5^.1GC/(7R\)S
MY'W9EJ,GKLQZ*TI:4JOA>[0#R%O+!(-B#5?)&A:?C;4">[0B.S\1TGY9L)\-
MU<@G0]HO@SVJV./X6%\045N5B%J?B#CTF1!35T%,9Z3EZ+?^6XCIC$!,9V0`
M>8BI*Q$31UCVB6JH0E1#!5%Q--4OKK%,W,EHR]&!2T+<R6@-WS4?0![B&B<1
M%\?2J$ADTS6+;+J*R#@L6BRVI41LK+;EZ(4+0FRL%F)CM0/(0VS+%&+C^`A4
MZJ))[[#0R\K/"KU\XDI(R;V:<W-;%6>AK<)#0T(A9@N%*KQR*9ASL9:C6\<%
M<RX&YEQL`/F0:(;@.3P99U=#H=JN!G!V-4B%PXHS,BEG\_0"9_-T<#9/EYP1
M3]NG)^,\UUS0]EPS.,\U2VVC4VI[>F:ASM,SP7EZIJRS9DIM#[<6.`^W@O-P
MJ^2LG5+;WKD%;7OG@K-WKM0V-F675G8&T:4TI<*5_<'G#$\'SG`S.4,P>063
MUTT^>47HNH/5]<]<%`2K3R)8B;&/3^E^)EX)^//\"=^?Y]6`/\^?Y/WYRM^0
M4AR4O/P,#(.ZR-]M:[Y[/E(^G@N4'LNK*IWQ'WO2IKINO"L,*S^L=H`_^L)!
MV&]`'#-Y:<C[<@G>_#K&NUY=K#8;N99VB<WOK'I.CDMC18W35,K;_'(#W'_,
M\?J!UF,:#XB:<#02#84CSSR)=1\<QY.C1(@M^HQ8RNE8]IFH3\=BVQ*W$;(X
MOQIRX'A1+:35UH0*8=O_S1ABTZX/B_*,>,:/;SZL7")J;ZB)A)@FK7T#%I0I
M=<-B$0;&$[%GY]"'9T->R/C07K=YF;-NL]P[7(7_O\Y?UQ'CX1H19>'F&3Y5
M--\T1[0X3!\V!_>.KI->JGFS]E5ZE8X<Z6CG#I^+I3R_B4#T5'TU<HY7_,*8
MT,1AQ^=W<#_%II`S/CZC<)-II]B\2(DG2WFS8GFAQ!`;$K;8Y*BT(:'3;EPE
M_;P'9<.%FV;>YI2DJ39,ICK_OTQ7QMG90V7E[.KG?N,+YR]^-MG\U=^-T5U+
MO_$>;\E_"2=:U/ECRMPG5&@X*S?BZ>])/(A./P-JE##NJVF:W(/7-7&?C3HU
MN1^_49,[^P.:W,%/:W)7_Y#&WS]%=%0C\:'C.4W&A^>1SD3Z@B;K_Q=4NE#=
MJZON^VRH?:$WK''Y0A5_'K#Y2USZ<K:1X/?WJ7`-RDN/^>/:=A:7CB<LE])7
MD\&ZKB+)Q_IO2PW9EF,-N_H>RT[H:^/ME.\2MU^_TLWV$L??>FG?(YO?T,0Q
M]9[D;Q8**QW"*FQQRJ$K',26@`(***"``@HHH(`""BB@@*I<_W-)Z-VWWWTA
M/K_Y^.]C_=]V\12_)QPM*4MH<CT_3:U)DR37ZCFU!W!4[0$\1W+?X'F2KP6_
MH-;.7U+KY9?5FOA5DM\N?(;D'L!?DI0]3L5K?=XO*'QY&1EB[3M#K8DC*GVJ
M7J8GZ^O(NP4S6;JP6>I_'7L(TYJE:@M54_M3;MHD;Y&NVN*MS755W*G:TZ7R
M(=7.QWI[-CZVA;^5KZ_0W@U(726<Y?330$&>/V5[WZH4^3@O3=]*%>]:!!10
M0`$%%%!``0444$`!!703D[?V]-;-4;7.Y/O/?*^^3JVU&]3ZE-?DTTG^YE>S
M6M//4&MW_A6E66K]SN?YAVSXL8YY`/]HS0*2[]XM5&M,7@M_AO@!':+;2/[Z
M$?,M0;J4Y*_=\`-<=P)W`6WJ?)PFWLM=`70`*XG$8SQ\_C*P1AU["*@R\2-9
MEGC49)-XY(3?@:J&6BFJ>;+8AVKJY%[2F_+T9O^UI[_?+GX9:2VI9[N("N]K
M72_54TCSM^=:>,2CKNKYK174C]H'U;ODU=-T]>QQ-?7S_I?W*T[>&VFE[^Y=
M*\U#^VO4N+W6^IGX=]M(\/6)6C-B-VCLJH\N5:)EUV'_VWWVCY:UO#I].E%_
MI$K[W^VK7Z-NL>N5H\_""QZONO]GH/Z0BI?5V-^K2=;*[R"ZU"O&8KK*\:?1
M5/;WQIV7EL;_(#[^\I*&W@_72]\MC=T\?Y<\H[;1&LKSS\N(SP3;^K@,16(P
M\7'<.Q_OI)^M?>6)X//5C4[_`U!+`P04``(`"``V9(XG><;7$/X!``#0"0``
M#P```'-U8F%C8V]U;G1S+G-Q;.V446O;,!#'WPW^#D=>E!:1VNU@3X&6U`^%
M/H2U=/1IR,XEU29+P9*;Y-OO+I:3-!ML@[$QLI=$.IW^_[OS#\VP,JI!N-8S
MT#9(N#9NX:SG#=!.554(FR7R/DT\&JP")X\I?]ZX&OS&N_(S13VL7I"4K*H1
MQB"JU@=78R-`V1EL-2C:BC31<\"U]G1C&`7/=UJ5,VUM>RWRX<)8@&7'HBM.
MG*4)0%],%QOG@,;C<30[L/MEM[[YMWY]]-AQ%R=/O_S4X'82OBWIP+4V>.G,
M[&";)MO:]O6S\8%ZFI2XT):M<8W5<##Y4-P\%O!T5WR$A[:\B3HPA$F<]=VM
MA!CF):X#6J^=E>!5L5[J!F]50,X)^I7^[QT92'AX06,D3)7W*]?,=AJ/5$=,
MNM>U)CJ"KJG;>9!%K;0Y`RX.0/E^"&JDZ7KWFTD0^45^<9E=O1<2<HZW'AL>
M"QT)WB]WEFK4=\[K;B8RZE>*QDS?R-)):5SUA668IHV`T(7[PKZ;MHAIY3YM
M^^5L:PP4-'49^Q@AM]7AT?,+2N[7941%C1:M:I0-KH'S,0E';K9M\&S9]KE#
MOWP3&ARR-)@TJ(*V"WC2N()\D"9(-WY`1O;OD/%[V!#3Z51\B\6?`^/OHW'9
MH7%$1O;_S>C?C/R$'HM7)N+JIXC(3HN(^%*<'`SO>AB^`E!+`0(4`!0``@`(
M`!MECB?+[4+8\Q````!V```/````````````(`"V@0````!S=6)A8V-O=6YT
M<RYD;V-02P$"%``4``(`"``V9(XG><;7$/X!``#0"0``#P`````````!`"``
KMH$@$0``<W5B86-C;W5N=',N<W%L4$L%!@`````"``(`>@```$L3``````==
`
end

===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to