| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/Connector NET 6.8.3/Assemblies/v4.5/ |
Upload File : |
MZ @ !L!This program cannot be run in DOS mode.
$ PE L ڰR ! n ` ȋ S H .text $l n `.rsrc p @ @.reloc t @ B H X 8 0 P 9HicJE":ܶ\ѵ*JNI|nJ @ PnaJo9wrZC y. Z(]gX1m{B/wW3 JAg&>&v(
j( } ( * { *"} * { *"} *0 N ( j3=r ps
o
ro p{ o
&o
,(
+j( ( * 0 n ( j0\r{ ps
o
r p{ o
&o
r p( o
&o
. ( s
zo
( ( *:(
(
*:(!
( *0 j r* pr p("
- r ps#
zo$
( o$
o%
Yo&
r p~'
F ((
()
,( * 0 i D r$ pr: p
+; (*
rP p(+
()
,, ( + ( Xi2* 0 z rf p(+
(,
-*s-
o.
o/
s0
o1
(
( ( ( s2
o3
o4
o5
o6
* 0 r pr po7
tQ
r pr po8
r pr po8
r po9
o:
o;
o<
+8o=
tO o>
r po?
o@
r p(A
,
+ oB
-uV ,oC
-oD
&* Z E 0 r pr po7
tQ
r pr po8
(E
r8 poF
r pr poG
(+
r po8
r pr po8
r pr po8
r& prN po8
rX prN po8
r pr po8
r pr po8
r pr po8
r pr8 po8
r< prp po8
rt pr po8
r pr po8
r pr po8
r8 po9
o:
oH
o;
o<
+Ao=
tO o>
r po?
o@
rN poI
, oJ
&+ oB
-uV ,oC
oD
&* AN 0 r pr po7
tQ
r pr po8
(E
r poF
r pr poG
(+
r po8
r pr po8
r pr po8
r po9
o:
oH
o;
o<
+Ao=
tO o>
r po?
o@
r4 poI
, oJ
&+ oB
-uV ,oC
oD
&* N 0 r pr po7
tQ
r pr~ po8
(E
r poF
r pr poG
(+
r po8
r pr po8
r pr po8
r po9
o:
oH
o;
o<
+Ao=
tO o>
r po?
o@
r poI
, oJ
&+ oB
-uV ,oC
oD
&* N 0 j r* pr p("
- r ps#
zo$
( o$
o%
Yo&
r p~'
F ((
()
,( * 0 z rf p(+
(,
-*s-
o.
o/
s0
o1
( ( ( ( s2
o3
o4
o5
o6
* 0 ~ r po9
o:
o;
o<
+:o=
tO o>
r po?
o@
r p(A
,
oJ
&+ oB
-uV ,oC
* ! Gh 0 r8 po9
o:
oH
o;
o<
+:o=
tO o>
r po?
o@
r p(A
,
oJ
&+ oB
-uV ,oC
* & Gm 0 r po9
o:
oH
o;
o<
+:o=
tO o>
r po?
o@
r p(A
,
oJ
&+ oB
-uV ,oC
* & Gm 0 r po9
o:
oH
o;
o<
+:o=
tO o>
r po?
o@
r~ p(A
,
oJ
&+ oB
-uV ,oC
* & Gm (K
*0 - r^ psL
z,o%
-r prl poM
(N
,rl poO
rl pr poP
(Q
r poM
(R
(
r poM
r8 p( (S
} r poM
r p( (S
} rt poM
r p( (S
} r< poM
rp p( (S
} r poM
r p( (T
} r& poM
r p( (U
} r poM
r p( (U
} rX poM
r p( (U
}
r poM
r p( (U
} r poM
r p( (U
}
r poM
-r p +oV
r p(A
, } +7r p(A
, } +!r$ p(A
, } + r0 ps
zoW
3oX
, (^ s
z(Y
r poM
oZ
,o[
o\
} + r p} { (N
,*{ ( (]
s } *2(N
,**2{ { *0 I
% (^
oV
{ { oV
(A
, ~_
s }
,(`
* <>
{ * { * {
* { * { * { * { * { * { * { * {
*"}
* 0 oa
-*sb
oc
od
,oe
,oe
z(` s
zrn p(D -*{ sf
og
(8 (A r ps
o
r
p (> o
&o
r
p(h
o
&o
r pa o
&o
/,oC
(& ,
r/ p(9 { si
z* [
O % 0 oa
-*{ sf
og
(8
(A rM ps
o
r po
&o
r p(> o
&o
r p a o
&o
/,oC
(& ,
r p(9 { si
z* }
% 0
sb
oc
od
,T*oj
,ok
(N
- T*(C r0
p(D -T*ol
, T*(< (h
{ sf
og
om
{ o ( rB
ps
o
r pc o
&o
r po
&o
r pr po
&o
r poW
(> o
&o
r po
&o
r) poW
o
&o
r po
&o
r poW
(> o
&o
rI pd o
&o
ra p o
&o
r p o
&o
r
p o
&o
r p o
&o
r pd o
&o
r p o
&o
r pa o
&o
r7 p o
&o
r{ pa o
&o
r p o
&o
1T+ Ton
, (& ,
r p(9 T,oo
,oC
ol
*
* A4 ( , V 0 { sf
og
(8 3ݨ ,( (S r% p -r p+rL p(+
s
o
rR p{ o c o
& o
r pa o
& o
/,oC
(& ,
r` p(9 { si
z*
% 2(B * 0 (p
(q
(h
(r
{ sf
og
rv ps
o
r p o
& o
rR p{ o c o
& o
(s
/,oC
(& ,
r p(9 { si
z* * Z
p % 0 [ oX
- (s s
z{ sf
og
(8 3 r ps
zr+ p s
o
r pa o
& ot
ou
&rJ pov
, ( sw
zrb pox
rt poy
oz
o$
r pox
o{
o|
o}
,'(@ -rt p(? (g sw
zoW
3 (;
;,oC
,oC
(& ,
r p(9 { si
z
* AL k
)
3 % 0 e
{ sf
og
(8
3
>
,oC
a o~
" (& , r p(9 { si
z * '
AA " 0
{ sf
og
om
r ps
o
r po
&,?r po
o
r p(h
o
&o
&r po
o
&r po
o
ou
-X(:
,oC
on
6,oC
,oo
(& ,
rC p(9 { s
z* (
, 0 { sf
og
(8 3|ru p s
o
r p(h
o
& o
r pa o
& o
/,oC
(& ,
r p(9 { si
z* eq
{{ % 0 { sf
og
r p s
o
r po
&o
rR p{ o c o
&o
tD +,oC
(& , rG p(9 { s
z* Wc
mm ! 0
o
- (r s
z{ sf
og
(8 3 ( s
z- o}
,rt p(? (p s
z{ o
(
sb
oc
od
, oe
, oe
z(q sw
zrm ps
o
r pa o
&~_
ot
ou
&rJ pov
, ( sw
zrt poy
oz
r pox
r po
o|
o}
,,tD (@ -rt p(? (g sw
z ,oC
r po
o
r
p(> o
&o
r ! p(h
o
&o
. (d sw
z /,oC
(& ,
r+! p(9 {
si
z * AL i
% 0 1 { sf
og
o
(8 3 ( s
zrG! p s
o
rX$ po
o
& o
rf$ po
o
& o
rI po
d o
& o
r po
o
& o
ra po
o
& o
ro po
o
& o
rR p{ o c o
& o
&
,oC
#(& ,
rx$ p(9 { s
z* A4
# 0
{ sf
og
(8 3
[ r$ p
s
o
r pa o
& ot
o
-
ou
&rJ pov
,
o
o
o{
o
o|
(@ -rb p(? +l ,h
(h
r% ps
o
r p
o
& o
r p
o
& o
r' pa o
& o
& ,oC
/,oC
(& ,
r' p(9 { si
z
* AL Z D G U
] _ % 6(B *6(B *0 S r( ps
o
ro po
&o
rR p{ o c o
&o
-*a * 0 s
{ o
{ o
r( p(
(
(
D
r) p (
(
(
r-) p(
o
,oC
* sy
0
S rE) po
a
r pox
rS) poy
o
- rS) pox
r p
r_) poy
oz
~
. r_) pox
r pr) poy
oz
~
.
r) pox
r) pov
rJ pov
r) po
r) poy
oz
~
.
r) po
r) po
r) po
r/* poy
oz
~
.
r/* po
o
s
* 0 <
-*3(
(
o
o
*3 (_ s
z( s
z0 s
o o
(
*0 . (
(
ur ,ur o
o
(
* 0 m -*-*(
o
(
iiXo i(
ii(
3o
(
*3 (= *( s
z 0 | rS* ps
o
r pa o
& ot
o
- ( s
z ou
&rb p(A
, o{
o
rt p(A
, o{
o
, oC
o
l(
,(h
(
9 rb p(A
, r:, po
rt p(A
, r. po
o
o
o
r/ pa o
&o
r/ p(h
o
&o
r pa o
&o
< ( s
zX o
2vr0 po
o
o
o
r pd o
&o
r p(h
o
&o
r pa o
&o
< ( s
zrb p(A
, r=1 po
rt p(A
, r42 po
o
o
o
r/ pa o
&o
r pa o
&o
/ r{3 ps
z%(& ,
r3 p(9 { si
z*A4 5 V
- ) V % R(> (A
* 0 e r3 ps
o
r pa o
&o
ou
&r poy
o
Qr poy
o
T
,oC
* * 0Z
0 C s
{ sf
og
s
o
r4 p
, r!6 p(*
o
ro po
&+!, rO6 p(*
o
r po
& r6 p(*
Za a ((
o
o
rR p{ o c o
&o
+(: o
ou
- ,oC
r6 po
o
o
o
(s
T
,oC
#(& ,
r6 p(9 { s
z* AL
# o}
,(N
, (o s
zo}
,(N
, (m s
z*0
o
a o%
o
/(n
+L + o
(
-X Xo%
2o
/(l
o
a ,,((
s
z*o
o%
1o
(
-** } r p} r6 p} r7 p} (
* 0 ! - r^ psL
z,o%
-r~ prl poM
(N
,rl poO
rl pr{7 poP
(Q
r poM
(R
(W
r p} (Y
r poM
oZ
,o[
o\
} { (N
,-{ ( (]
s }
(c si
z* U z
0 L " { sf
og
r7 ps
o
rR p{ o c o
&o
ra p o
&-%o
r8 p(*
o
+3%o
r8 p(*
o
r9 ps
o
r p o
&s
o
+ rE) po
o
ou
- ,oC
o
+,(
o
o
z o
o
X(
- oC
,oC
*AL 9 + 3 ?
0 # { sf
og
r9 ps
o
rR p{ o c o
&o
ro p o
&r9 ps
o
r po
&
+No
o
o
o
a o
o
a o
o
X
Xi2
,oC
*
0 V $ o
D
o
+ o=
t| %X o
oB
- uV ,oC
o
* %: B(V *N~
(V *>(V *J~
(V *0 % { sf
og
rI: ps
o
rR p{ o c o
&o
ra p o
&-%o
r8 p(*
o
+3%o
r8 p(*
o
o
a
,oC
*
2{ { *6{ } * 0 V & s
o
/*rv; po
tD o
+M o=
t~ o
o
-o
D (
(
, o
+o
s
o
oB
- uV
,
oC
(N
,*{ sf
og
r; p s
o
rR p{ o c o
&o
ro po
&s
s
o
&o
o
1o
o
(T , oC
( si
z* ( * Z :
D 0 I ' r< po
d
rv; po
tD (N
,*o
/*~_
~_
(U /*{ sf
og
om
{ o ( r< ps
o
o
o
r pc o
& o
r.? po
& o
r<? p o
& o
rT? po
& o
- (t s#
zon
,oo
(t
si
z ,oC
* j j < 0 + ( rl? ps
o
r pa o
&o
&* 0 ) r? po
tD
r? po
tD r @ po
t -*F
:
o
8 F
/
o
o
9 (
(
(
(
3o
o
o
+Br@ po
,o&
o
+ o (
o
X i?;* 0 *
o
+> o=
t o
,)o
o
r@ po
d o
,,
+ oB
- uV
,
oC
-*s
s
s
o
8 o=
t o
, o
9 o
o
r@ po
d o
,9 Xo
o
, o
, o
-r8@ po
o
&8 uD ,:rN@ po
o
a uD o%
a o
& o
&+?t rl@ po
o
c ia o
&io
oB
: uV , oC
o$
Q o$
Qo
Q* A4
K U # 0 + s
&{ sf
og
r@ ps
o
rR p{ o c o
&,(%o
rB p(*
o
o
rB po
&~
(
,-%o
r C p(*
o
o
ra p o
&-%o
rcC p(*
o
+3%o
rC p(*
o
%o
rC pZa a ((
(*
o
s
o
+F r pox
rC pov
rC po
rD po
r7D po
s
o
ou
-
, oC
r6 po
o
(s
T
,oC
*A4 R k
2(N
,** (
* (
* 0 3 , ~ (
, rOD p (
o
s
~ *~ * *V(Z rD p~ o
*V(Z rD p~ o
*V(Z rD p~ o
*V(Z r/E p~ o
*V(Z r]E p~ o
*V(Z rE p~ o
*V(Z rE p~ o
*V(Z rE p~ o
*V(Z r)F p~ o
*V(Z rIF p~ o
*V(Z riF p~ o
*V(Z rF p~ o
*V(Z rF p~ o
*V(Z rF p~ o
*V(Z r)G p~ o
*V(Z raG p~ o
*V(Z rG p~ o
*V(Z rG p~ o
*V(Z rG p~ o
*V(Z r%H p~ o
*V(Z rWH p~ o
*V(Z rH p~ o
*V(Z rH p~ o
*V(Z rH p~ o
*V(Z r#I p~ o
*V(Z rOI p~ o
*V(Z rqI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z rI p~ o
*V(Z r%J p~ o
*V(Z rKJ p~ o
*V(Z rsJ p~ o
*V(Z rJ p~ o
*V(Z rJ p~ o
*V(Z rK p~ o
*V(Z r=K p~ o
*V(Z r]K p~ o
*V(Z rK p~ o
*V(Z rK p~ o
*0 - r^ psL
z,o%
-r prl poM
(N
,rl poO
rl prK poP
(Q
(R
r poM
(N
- r poM
r poM
,#r poM
o
rK p(A
,} (Y
r poM
oZ
} { ,{ o[
o\
} + r p} { (N
,*{ ( o]
s } *2{ { *6{ } * { *"} *0 - ,i-*,i-* +8
(N
,(e rK ps
zo
- (v s
z X i2
+k
(N
,(f rL ps
z ,o
. (h s
z+! o
, ( s
zXi2X
i2{ sf
og
om
r'L p s
o
r po
&o
rL po
&8 { o ( +R ( o
o
c o
o
o
a o
o
&Xi2Xi?oon
$
,oo
( ,
rL p(
, oC
* A4 $
0 . ,o
. (h s
zo
, (u s
z{ sf
og
rL ps
o
rR p{ o c o
&o
ro po
&o
& ( , r?M p(
,oC
* 6 O 6 h
0 / { sf
o
- (v s
z,o
i1 (] s
zog
om
rUM ps
o
rN po
&o
rR p{ o c o
&o
&rN po
o
&on
,oo
( , rO p(
,oC
*
0 ) 0 { sf
og
(
,oC
*
0 ) 0 { sf
og
(
,oC
*
0 1 s
{ sf
og
( rO p
s
o
rL pa o
&o
rR p{ o c o
&o
+o
o
ou
- ,oC
,oC
o
( ,
r6Q p( * ( t
0 2 o
-ݝ { sf
og
rTQ p s
o
rR p{ o c o
&o
rB po
&o
rS po
&o
(s
#,oC
( ,
rS p( * n
0 3 ,i-*,i-*
+
o
- (v s
z X
i2
+=
+! o
- ( s
zXi2
X
i2{ sf
og
om
rS p s
o
rV p o
&o
rN p o
&o
rR p{ o c o
&+Z+=o
o
o
o
o
o
o
&Xi2Xi2on
$ ,oo
( ,
rV p(
, oC
*A4 $
0 4 { sf
og
rV ps
o
rR p{ o c o
&o
ro po
&o
(s
!,oC
( , rW p( * ]i
ss 0 5 o
- (v s
zs
{ sf
og
rW p s
o
rV po
& o
rN po
& o
rR p{ o c o
& o
+o
o
ou
- ,oC
,oC
o
( ,
rZ p( * ( &
0 + ( rZ ps
o
r pa o
&o
&* 0 6 s
r [ p ,rj[ p( a (
r[ p(*
s
o
rR p{ o c o
&o
+
o
o
ou
-
, oC
o
( ,
r-\ p( * e ~
0 N rS\ ps
o
ro po
&o
rR p{ o c o
&o
(s
* 0 L ( r\ ps
o
ro po
&o
rR p{ o c o
&o
a *0 s
{ o
{ o
{ (
(
(
D
r) p (
(
(
r-) p(
o
,oC
* tz
r p} r6 p} r7 p} (
*J~ -( ~! *0 7 ry] p(
(
! *
* 0 L 8 (
( 3*r] poM
rN p(
- ( + (i s
z
(i si
z* .>
0 9 rOD p (
o
s
( 3*sf
og
X +br] pa (+
o
s
o
o
&-o
3 3r] po
o
&zX ( 1
,oC
* ]
g - * x
0 : sf
og
r'^ ps
o
,
a ra
o
z .D rs^ pr^ po
o
o
3 o
o
r^ po
(s
,oC
* / a
0 ; r^ ps
o
rR pc o
&o
ro po
&o
,a j*r|_ po
o
r3` pd o
&o
. ( s
zrC` po
o
(
* {/ *"}/ * {- *"}- *2{( { *6{( } *2{( o * 0 k < ( ,Vs
{% o
{& o
rs` p r) p(
r-) po$
(
o
,oC
{' si
z FT
0 = - r^ ps
z,o%
- r ps
zrl poM
(N
,rl poO
rl pr` po
(Q
(R
r poM
(N
- r poM
(R
(
o
r1a po!
o"
rGa po#
t }) (Y
r poM
oZ
}$ {$ , {$ o[
o\
r p(A
, raa ps$
z{$ o[
}# }- r poM
, r poM
o
rK p(A
}- }/ ra poM
, ra poM
o
rK p(A
}/ {# ( (]
s }( {# sf
og
{( o &(
,oC
ra p( {# sf
ra ps
o
rb p( c o
&og
o
&( ( }+ ,oC
ra p( {+ 0}+ s%
{+ Z <Zs&
}* * 4
4 P3 kA Js'
((
s)
* 0 . {# sf
rb ps
o
re po
&o
rb p( c o
&o
r%e pa o
&o
r5e pa o
&o
rGe pa o
&o
rWe po
&o
rse pa o
&og
o
&
,oC
re p( *
R{* , {* o*
**F( *F( ** 0 > {# sf
re ps
o
r5e p{) o+
(,
o
&o
re po
&o
rb p( c o
&o
r%e po
&og
o
&
,oC
rg p( *
0 ? {# sf
r0g ps
o
re po
&o
rb p( c o
&o
r%e po
&og
o
,oC
,{/ ,{. o-
rh p o.
(*
( * ^j
0 > {# sf
rAh ps
o
r5e p{) o+
(,
o
&o
re po
&o
rb p( c o
&og
o
&
,oC
rTi p( * r~
0 @ {# sf
o/
t# ( 9 rvi ps
o
re po
&o
rb p( c o
&o
r5e po0
a o
&o
r%e pa o
&o
rGe pa o
&o
rWe po
&o
rse pa o
&8 rk ps
o
r5e po0
a o
&o
rWe po
&o
rGe pa o
&o
re po
&o
rb p( c o
&o
r%e po
&og
o
&
,oC
r.m p( *A4 l x
0 U A
~1
! QRT
{# sf
og
,Mrdm ps
o
re po
&o
rb p( c o
&o
-R+Rrn ps
o
re po
&o
rb p( c o
&o
ou
9 o
o
(2
1R+
oz
um - t + oz
QPum , a Qo{
To{
o
(3
! - o
R ,oC
-R 9 F: Pa Xa Qro ps
o
r%e pPo
&o
re po
&o
rb p( c o
&o
&J3 {) o+
(,
io4
+ (
,oC
rp p( * AL y 0 4 # B N{/ , }. **0 $ B s
s5
,o6
o7
o
*0 6 C s'
, s8
o9
j1s:
(;
((
s)
* 0 * C s'
, s8
o9
j1s:
(;
* 0 D %(^
{, ,ݣ }, ,(`
{# sf
og
r q ps
o
rb p( c o
&o
1(
,oC
r8r p( $%(^
}, ,(`
* @ !$ < A}
0 Y 0 j $ 0 / ( r^r ps
o
rb pc o
&o
a * 0 E rs ps
o
ou
,]o
rs p(A
,Hrs p
s
{% o
{& o
o
,oC
& (<
,oC
rUu p(=
(>
*4 = $a 6 9o gz
Z{/ ,( *( * 0 c F {# sf
og
ru ps
o
rb p( c o
&o
&
,oC
rVv p(=
(>
* 7C
OO 0 > G {# sf
og
rv ps
o
rb p( c o
&o
8 o
oz
um - t +( s?
s)
{. ,{. o-
{# sf
rw ps
o
re p o
& o
rb p( c o
&og
o
& ,oC
rrx p
(=
(>
ou
:!
,oC
,oC
* Ad O A '
' 3
rx p}% r6 p}& ry p}' (@
* 0 lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet - PADPADPZ:X;Daxc$OؙrKE)=U¤ɤɤɤɤɤɤɤɤ #V
3ːZVl ;+G;A[xp^m_
^3y%Ns*Q:T=ÿYceyjsU)t o 1 2 h { / B U x E x h 9 i @ h - N
4C a n n o t D e l e t e A P o p u l a t e d R o l e :C a n n o t R e t r i e v e H a s h e d P a s s w o r d s ! .C a n n o t U n e n c o d e H a s h e d P w d z ,C h a n g e P a s s w o r d C a n c e l e d :E r r o r I n i t O f M e m b e r s h i p P r o v i d e r .E r r o r I n i t O f R o l e P r o v i d e r 0E r r o r I n i t P r o f i l e P r o v i d e r = ,E r r o r R e s e t t i n g P a s s w o r d x I l l e g a l R o l e N a m e I l l e g a l U s e r N a m e .I n c o r r e c t P a s s w o r d A n s w e r 6I n v a l i d C h a r a c t e r s I n U s e r N a m e (M i s s i n g O r W r o n g S c h e m a 0 ,M o n o D o e s N o t S u p p o r t H a s h n 6N e w P a s s w o r d V a l i d a t i o n F a i l e d :N o t E n o u g h N o n A l p h a N u m e r i c I n P w d *P a s s w o r d A n s w e r I n v a l i d a *P a s s w o r d N o t L o n g E n o u g h .P a s s w o r d Q u e s t i o n I n v a l i d 0P a s s w o r d R e q u i r e d F o r R e s e t :P a s s w o r d R e s e t C a n c e l e d N o t V a l i d # .P a s s w o r d R e s e t N o t E n a b l e d ` 6P a s s w o r d R e t r i e v a l N o t E n a b l e d &P r o f i l e U p d a t e F a i l e d *R o l e N a m e A l r e a d y E x i s t s R o l e N a m e N o t F o u n d 2U n a b l e T o C r e a t e A p p l i c a t i o n $U n a b l e T o C r e a t e U s e r &U n a b l e T o L o c k O u t U s e r ! 6U n a b l e T o R e t r i e v e P r o f i l e D a t a ; 4U n a b l e T o U p d a t e F a i l u r e C o u n t k 2U n s u p p o r t e d P a s s w o r d F o r m a t &U s e r I s A l r e a d y I n R o l e U s e r I s L o c k e d O u t U s e r N o t I n R o l e U s e r n a m e N o t F o u n d 0V a l i d a t e P a s s w o r d C a n c e l e d 3 s c h e m a 1 b s c h e m a 2
s c h e m a 3 s c h e m a 4 c s c h e m a 5 p s c h e m a 6 " s c h e m a 7 # s c h e m a 8 % Cannot delete a populated role.WSetting EnablePasswordRetrieval to true when PasswordFormat is Hashed is not supported."Cannot unencode a hashed password.'Change password operation was canceled.<There was an error during membership provider initilization.6There was an error during role provider initilization.9There was an error during profile provider initilization.*There was an error resetting the password.%Role names must not be null or empty.%User names must not be null or empty.Incorrect password answer. Invalid characters in user name.<Unable to initialize provider. Missing or incorrect schema.\The mono runtime did not support hashed passwords. Please use clear or encrypted passwords.@Change password canceled due to New password validation failure.QNon alpha numeric characters in '{0}' needs to be greater than or equal to '{1}'.$Password answer supplied is invalid.DThe length of parameter '{0}' needs to be greater or equal to '{1}'.&Password question supplied is invalid.,Password answer required for password reset.;Reset password canceled due to password validation failure. Password Reset is not enabled. Password Retrieval Not Enabled.Profile update failed.Role name already exists.Role name not found. Unable to create application.Unable to create user.Unable to lock out user..Unable to retrieve profile data from database.DUnable to update failure count. Membership database may be corrupt. Unsupported password format.User is already in role. The supplied user is locked out.User not in role.Username not found.-The validate password operation was canceled.CREATE TABLE mysql_Membership(`PKID` varchar(36) NOT NULL,
Username varchar(255) NOT NULL,
ApplicationName varchar(255) NOT NULL,
Email varchar(128) NOT NULL,
Comment varchar(255) default NULL,
Password varchar(128) NOT NULL,
PasswordQuestion varchar(255) default NULL,
PasswordAnswer varchar(255) default NULL,
IsApproved tinyint(1) default NULL,
LastActivityDate datetime default NULL,
LastLoginDate datetime default NULL,
LastPasswordChangedDate datetime default NULL,
CreationDate datetime default NULL,
IsOnline tinyint(1) default NULL,
IsLockedOut tinyint(1) default NULL,
LastLockedOutDate datetime default NULL,
FailedPasswordAttemptCount int(10) unsigned default NULL,
FailedPasswordAttemptWindowStart datetime default NULL,
FailedPasswordAnswerAttemptCount int(10) unsigned default NULL,
FailedPasswordAnswerAttemptWindowStart datetime default NULL,
PRIMARY KEY (`PKID`)) DEFAULT CHARSET=latin1 COMMENT='1';
CREATE TABLE mysql_UsersInRoles(`Username` varchar(255) NOT NULL,
`Rolename` varchar(255) NOT NULL, `ApplicationName` varchar(255) NOT NULL,
KEY `Username` (`Username`,`Rolename`,`ApplicationName`)
) DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
CREATE TABLE mysql_Roles(`Rolename` varchar(255) NOT NULL,
`ApplicationName` varchar(255) NOT NULL,
KEY `Rolename` (`Rolename`,`ApplicationName`)
) DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
ALTER TABLE mysql_Membership
ADD PasswordKey char(32) AFTER Password,
ADD PasswordFormat tinyint AFTER PasswordKey,
CHANGE Email Email VARCHAR(128), COMMENT='2';
/* Provider schema block -- version 3 */
/* create our application and user tables */
create table my_aspnet_applications(id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(256), description VARCHAR(256));
create table my_aspnet_users(id INT PRIMARY KEY AUTO_INCREMENT,
applicationId INT NOT NULL, name VARCHAR(256) NOT NULL,
isAnonymous TINYINT(1) NOT NULL DEFAULT 1, lastActivityDate DATETIME);
create table my_aspnet_profiles(userId INT PRIMARY KEY, valueindex longtext, stringdata longtext, binarydata longblob, lastUpdatedDate timestamp);
create table my_aspnet_schemaversion(version INT);
insert into my_aspnet_schemaversion VALUES (3);
/* now we need to migrate all applications into our apps table */
insert into my_aspnet_applications (name) select ApplicationName from mysql_Membership UNION select ApplicationName from mysql_UsersInRoles;
/* now we make our changes to the existing tables */
alter table mysql_Membership
rename to my_aspnet_membership,
drop primary key,
drop column pkid,
drop column IsOnline,
add column userId INT FIRST,
add column applicationId INT AFTER userId;
alter table mysql_Roles
rename to my_aspnet_roles,
drop key Rolename,
add column id INT PRIMARY KEY AUTO_INCREMENT FIRST,
add column applicationId INT NOT NULL AFTER id;
alter table mysql_UsersInRoles
drop key Username,
rename to my_aspnet_usersinroles,
add column userId INT FIRST,
add column roleId INT AFTER userId,
add column applicationId INT AFTER roleId;
ALTER TABLE my_aspnet_membership CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_roles CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_usersinroles CONVERT TO CHARACTER SET DEFAULT;
/* these next lines set the application Id on our tables appropriately */
update my_aspnet_membership m, my_aspnet_applications a set m.applicationId = a.id where a.name=m.ApplicationName;
update my_aspnet_roles r, my_aspnet_applications a set r.applicationId = a.id where a.name=r.ApplicationName;
update my_aspnet_usersinroles u, my_aspnet_applications a set u.applicationId = a.id where a.name=u.ApplicationName;
/* now merge our usernames into our users table */
insert into my_aspnet_users (applicationId, name)
select applicationId, Username from my_aspnet_membership
UNION select applicationId, Username from my_aspnet_usersinroles;
/* now set the user ids in our tables accordingly */
update my_aspnet_membership m, my_aspnet_users u set m.userId = u.id where u.name=m.Username AND u.applicationId=m.applicationId;
update my_aspnet_usersinroles r, my_aspnet_users u set r.userId = u.id where u.name=r.Username AND u.applicationId=r.applicationId;
/* now update the isanonymous and last activity date fields for the users */
update my_aspnet_users u, my_aspnet_membership m
set u.isAnonymous=0, u.lastActivityDate=m.LastActivityDate
where u.name = m.Username;
/* make final changes to our tables */
alter table my_aspnet_membership
drop column Username,
drop column ApplicationName,
drop column applicationId,
add primary key (userId);
/* next we set our role id values appropriately */
update my_aspnet_usersinroles u, my_aspnet_roles r set u.roleId = r.id where u.Rolename = r.Rolename and r.applicationId=u.applicationId;
/* now we make the final changes to our roles tables */
alter table my_aspnet_roles
drop column ApplicationName,
change column Rolename name VARCHAR(255) NOT NULL;
alter table my_aspnet_usersinroles
drop column ApplicationName,
drop column applicationId,
drop column Username,
drop column Rolename,
add primary key (userId, roleId);
ALTER TABLE my_aspnet_membership CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_roles CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_usersinroles CONVERT TO CHARACTER SET DEFAULT;
UPDATE my_aspnet_schemaversion SET version=4 WHERE version=3;
CREATE TABLE my_aspnet_sessions
(
SessionId varchar(191) NOT NULL,
ApplicationId int NOT NULL,
Created datetime NOT NULL,
Expires datetime NOT NULL,
LockDate datetime NOT NULL,
LockId int NOT NULL,
Timeout int NOT NULL,
Locked tinyint(1) NOT NULL,
SessionItems BLOB,
Flags int NOT NULL,
primary key (SessionId,ApplicationId)
) DEFAULT CHARSET=latin1;
/*
Cleaning up timed out sessions.
In 5.1 events provide a support for periodic jobs.
In older version we need a do-it-yourself event.
*/
CREATE TABLE my_aspnet_sessioncleanup
(
LastRun datetime NOT NULL,
IntervalMinutes int NOT NULL
);
INSERT INTO my_aspnet_sessioncleanup(LastRun,IntervalMinutes) values(NOW(), 10);
UPDATE my_aspnet_schemaversion SET version=5;
ALTER TABLE my_aspnet_sessions CONVERT TO CHARACTER SET DEFAULT;
ALTER TABLE my_aspnet_sessions MODIFY SessionItems LONGBLOB;
UPDATE my_aspnet_schemaversion SET version=6;
RENAME TABLE my_aspnet_Applications TO my_aspnet_applications;
RENAME TABLE my_aspnet_Membership TO my_aspnet_membership;
RENAME TABLE my_aspnet_Profiles TO my_aspnet_profiles;
RENAME TABLE my_aspnet_Roles TO my_aspnet_roles;
RENAME TABLE my_aspnet_SchemaVersion TO my_aspnet_schemaversion;
RENAME TABLE my_aspnet_SessionCleanup TO my_aspnet_sessioncleanup;
RENAME TABLE my_aspnet_Sessions TO my_aspnet_sessions;
RENAME TABLE my_aspnet_Users TO my_aspnet_users;
RENAME TABLE my_aspnet_UsersInRoles TO my_aspnet_usersinroles;
UPDATE my_aspnet_schemaversion SET version=7;DELETE FROM my_aspnet_sessioncleanup;
ALTER TABLE my_aspnet_sessioncleanup ADD ApplicationId INT NOT NULL;
ALTER TABLE my_aspnet_sessioncleanup ADD Primary Key (ApplicationId);
UPDATE my_aspnet_schemaversion SET version=8;BSJB v4.0.30319 l # #~ $ . #Strings R |y #US ` #GUID p
#Blob W] %3
/ @ G F Q
.'
R5 { { xa 4) A{ { { { ' a
'
" " k Z & { a ' 7 b P y P P P P P P P F 6 l 6 6 P P P Z 4 ! H w W W a a a" # ; '& y [ ! ! 7!' ]!S! y!' !S! !S! !S! !S! !) !! !) ") $") ,") C") [") " ") ") #' &#P h#' #'& #[ ##& 9$ & N$ $ ${" % %%' +%a M%' S%'" [% y%{" % " % %{ -&' &! &' '' u'X' '' 'X' 'X' 'X' ('" H( s(' (( (a )() )'" &) F) [) e) v)' )' ) ) )a" * " * " (* " C* y*' *' + +! -+S! +S! ++ +! ,W O, h, ,a ,{& , & - & J- & d- & - - - - - . B.' u.S! .S! .! .6 $ 6 F Y F
q F Y F F " # 1 9g K W ` q g j j j j j g +g Zm ig q q q { K W ` q j q j j Qg q b K W ` q U Y g j j ] ,j " #( *, 61 ! F5 ! C l! C ! Q ! Q " W |" [ " 5 |# @a X$ [a
$& qa P' a |( W ( 5 |) a * a * a X+ #a + W , u . | . 1 . 5 $/ ) ,/ A 4/ ] </ { D/ L/ T/ \/ d/ l/ &1 t/ L |/ j / 0 1 " 4 * 5 , 5 / 6 / / 8 ; 1 9 ; 3 L: C 5 ; N 6 ; a 7 8> o 9 ? z : A < A @ A D B F B H D
I PD 1 K xD K D M 0E / !P G B )S H P 2W H ` >[ $J i " ` \J t Ib K W e @K u e <L
]g M
ei N
kj XO qk iO * q }O A v O X { O g ] dP 1 qP 5 P R S S * T < W N q X | X W X W Y GY NY VY lY
Y %
Y A
Y \
Y ~
Y
Y
Z
Z
2Z
HZ ^Z 6 tZ O Z j Z Z Z Z Z [ $[ ; :[ W P[ w f[ |[ [ [ [ [ [ \ \ ,\ B\ X\ < n\ S \ k \ \ \ \ \ ] ] 4] u \^ 1 i^ 5 w^ L ^ j ^ . ` >5 a I b T b ` (c p ,d e g g h i i @j j <k W ek ! xk % k 2 k 6 l $= l 5C m FH Yn A an Z jn L rn j {n 1 n 5 n s( n a ,o u q h r q s W )s z +s & =s . Os ?z Ts Q (t f t q u w Dz Xz z z { | # L| 6 (} IW @} `W } W | W
& 3 < H 3 T ] l 3 T y 3 3 " 3 ) ) 3 y 3 " 6 3 T ; K 3 X Z a h x T x T x Z 3 y " T ; ; * 5 < L R ] ; & h r r { 3 r 3 r h r r ; 3 3 r X Z q q q 3 X Z ! W ) 5 1 5 9 5 A 5 I 5 Q 5 Y 5 a 5 i 5 q W y 5 5 5 5 W W - C K 5 ( Q Q %!y 5 .!1 !>! !I!)b!!~!9!!!| !~!A!I 5 Q!1 Q!W I W I !5 Y Y "I "q "W q!W I 8"N"" I g"|"y"""y"|"y"1 !"# W y#/#;D#1 !Q# yY#A!y#Gy# W 5 Y # !#Y #5 Y #" u #$C.!| $!($1 A q$# $1 !$1 61 $!$ $ z $$ $9 5 %W % { N ; 9 <%)i%W )p%W 1%2 %$!%8A% % I 5 % A &@A%!EA&JA!W ] ; &5 %m ) Q 5 1C& T&a \&1 a i&1 a s&1 a & a &a &A& A%A%Y W Y&5 Y&5 a&!!!!!!Y&5 &@A 'i' ' "'1 a a+'=7'C H'Ia%Pq W 'Z'`1''n'Z(Ia'~(( (IA' .( 9(^(W AT&q W W d(q # 5 !(1( " &1 ( W (1 # W
) # " "0#52) # <) "\&1 !
e R)y W <) # "{)) )") # ! W )#*!:*9<) 1# <) # !^* # d* *" ** * !* *I* "* *D "J *P Y W a W :+ P+d+ u+"'1 Y+U Y>! Y+] Y+g i+( i+n a+v $ W + W # ! W q " y W W 2,
B,
%'
.
!},1 ) !,>
) ) p $ #$ +
#
) W , +!, % ,5 , , ,6 Y ," ,_ 8-f #l -s #y 5 W - W %. 1. I. y P.1 \. %. f. k. % 1 h ' !W a Zi>!( 7 .] !!b +] W 1 W -. ; .
. . . # . +
. 3
. C $
. K
. [
. c
. k . s u
.
.
. 5
.
c +
3
# [5
)[5
$Oi&Ocr'Vfu<Xj} * { "
C
f
p
}
" ( ? P X . @ L h w ? A B
C I M M P P P P T
T
X /
T T
T n
M
P M k 8 @ [ y . F b w % C [ w 3 O j M
P ) ZQ P
P M I
! " # $ % & ' P O Z ! [ # \ # ] % ^ ' _ ) ` + a - b / c 1 d 3 e 5 f 7 g 9 h ; i = j ? k A l C m E n G o I p K q M r O s Q t S u U v W w Y x [ y ] z _ { a | c } e ~ g i k m o q s u w y { }
)
5 \
: V ) '
. <Module> MySql.Web.dll Application MySql.Web.General CustomInstaller MySql.Web.Security MySQLMembershipProvider MySQLProfileProvider MySql.Web.Profile Resources MySql.Web.Properties MySQLRoleProvider Runtime SchemaManager MySql.Web.Common MySqlSessionStateStore MySql.Web.SessionState mscorlib System Object System.Configuration.Install Installer System.Web.ApplicationServices System.Web.Security MembershipProvider System.Web System.Web.Profile ProfileProvider RoleProvider System.Web.SessionState SessionStateStoreProviderBase _id _desc .ctor get_Id set_Id Name get_Description set_Description MySql.Data MySql.Data.MySqlClient MySqlConnection FetchId EnsureId Id Description System.Collections IDictionary Install Uninstall AddProviderToMachineConfig UpdateMachineConfigs AddProviderToMachineConfigInDir System.Xml XmlDocument AddDefaultConnectionString AddMembershipProvider AddRoleProvider AddProfileProvider RemoveProviderFromMachineConfig RemoveProviderFromMachineConfigInDir RemoveDefaultConnectionString RemoveMembershipProvider RemoveRoleProvider RemoveProfileProvider newPasswordLength eventSource eventLog exceptionMessage connectionString minRequiredPasswordLength writeExceptionsToEventLog enablePasswordReset enablePasswordRetrieval requiresQuestionAndAnswer requiresUniqueEmail maxInvalidPasswordAttempts passwordAttemptWindow MembershipPasswordFormat passwordFormat minRequiredNonAlphanumericCharacters passwordStrengthRegularExpression app System.Collections.Specialized NameValueCollection Initialize GetConfigValue get_ApplicationName set_ApplicationName get_EnablePasswordReset get_EnablePasswordRetrieval get_RequiresQuestionAndAnswer get_RequiresUniqueEmail get_MaxInvalidPasswordAttempts get_PasswordAttemptWindow get_PasswordFormat get_MinRequiredNonAlphanumericCharacters get_MinRequiredPasswordLength get_PasswordStrengthRegularExpression get_WriteExceptionsToEventLog set_WriteExceptionsToEventLog ChangePassword ChangePasswordQuestionAndAnswer MembershipUser MembershipCreateStatus CreateUser DeleteUser MembershipUserCollection GetAllUsers GetNumberOfUsersOnline GetPassword GetUser UnlockUser GetUserNameByEmail ResetPassword UpdateUser ValidateUser FindUsersByName FindUsersByEmail GetUserId Exception WriteToEventLog MySqlDataReader GetUserFromReader UnEncodePassword GetPasswordKey HashPasswordBytes EncodePassword UpdateFailureCount CheckPassword GetPasswordInfo GetUsers ValidateQA ValidatePassword ApplicationName EnablePasswordReset EnablePasswordRetrieval RequiresQuestionAndAnswer RequiresUniqueEmail MaxInvalidPasswordAttempts PasswordAttemptWindow PasswordFormat MinRequiredNonAlphanumericCharacters MinRequiredPasswordLength PasswordStrengthRegularExpression WriteExceptionsToEventLog ProfileAuthenticationOption DateTime DeleteInactiveProfiles DeleteProfiles ProfileInfoCollection FindInactiveProfilesByUserName FindProfilesByUserName GetAllInactiveProfiles GetAllProfiles GetNumberOfInactiveProfiles System.Configuration SettingsPropertyValueCollection SettingsContext SettingsPropertyCollection GetPropertyValues SetPropertyValues DeleteUserData System.Data DataRow DecodeProfileData EncodeProfileData GetProfiles System.Resources ResourceManager resourceMan System.Globalization CultureInfo resourceCulture get_ResourceManager get_Culture set_Culture get_CannotDeleteAPopulatedRole get_CannotRetrieveHashedPasswords get_CannotUnencodeHashedPwd get_ChangePasswordCanceled get_ErrorInitOfMembershipProvider get_ErrorInitOfRoleProvider get_ErrorInitProfileProvider get_ErrorResettingPassword get_IllegalRoleName get_IllegalUserName get_IncorrectPasswordAnswer get_InvalidCharactersInUserName get_MissingOrWrongSchema get_MonoDoesNotSupportHash get_NewPasswordValidationFailed get_NotEnoughNonAlphaNumericInPwd get_PasswordAnswerInvalid get_PasswordNotLongEnough get_PasswordQuestionInvalid get_PasswordRequiredForReset get_PasswordResetCanceledNotValid get_PasswordResetNotEnabled get_PasswordRetrievalNotEnabled get_ProfileUpdateFailed get_RoleNameAlreadyExists get_RoleNameNotFound get_schema1 get_schema2 get_schema3 get_schema4 get_schema5 get_schema6 get_schema7 get_schema8 get_UnableToCreateApplication get_UnableToCreateUser get_UnableToLockOutUser get_UnableToRetrieveProfileData get_UnableToUpdateFailureCount get_UnsupportedPasswordFormat get_UserIsAlreadyInRole get_UserIsLockedOut get_UsernameNotFound get_UserNotInRole get_ValidatePasswordCanceled Culture CannotDeleteAPopulatedRole CannotRetrieveHashedPasswords CannotUnencodeHashedPwd ChangePasswordCanceled ErrorInitOfMembershipProvider ErrorInitOfRoleProvider ErrorInitProfileProvider ErrorResettingPassword IllegalRoleName IllegalUserName IncorrectPasswordAnswer InvalidCharactersInUserName MissingOrWrongSchema MonoDoesNotSupportHash NewPasswordValidationFailed NotEnoughNonAlphaNumericInPwd PasswordAnswerInvalid PasswordNotLongEnough PasswordQuestionInvalid PasswordRequiredForReset PasswordResetCanceledNotValid PasswordResetNotEnabled PasswordRetrievalNotEnabled ProfileUpdateFailed RoleNameAlreadyExists RoleNameNotFound schema1 schema2 schema3 schema4 schema5 schema6 schema7 schema8 UnableToCreateApplication UnableToCreateUser UnableToLockOutUser UnableToRetrieveProfileData UnableToUpdateFailureCount UnsupportedPasswordFormat UserIsAlreadyInRole UserIsLockedOut UsernameNotFound UserNotInRole ValidatePasswordCanceled ConnectionStringSettings pConnectionStringSettings pWriteExceptionsToEventLog AddUsersToRoles CreateRole DeleteRole GetAllRoles GetRolesForUser GetUsersInRole IsUserInRole RemoveUsersFromRoles RoleExists FindUsersInRole GetRolesByUserName GetRoleId inited isMono get_IsMono Init IsMono schemaVersion get_Version CheckSchema UpgradeToCurrent GetSchemaVersion CreateOrFetchUserId Version connectionStringSettings System.Web.Configuration SessionStateSection sessionStateConfig System.Threading Timer cleanupTimer cleanupInterval cleanupRunning SessionStateItemExpireCallback expireCallback enableExpireCallback get_EnableExpireCallback set_EnableExpireCallback get_ApplicationId MySqlException HandleMySqlException SessionStateStoreData HttpContext CreateNewStoreData CreateUninitializedItem Dispose EndRequest TimeSpan SessionStateActions GetItem GetItemExclusive InitializeRequest ReleaseItemExclusive RemoveItem ResetItemTimeout SetAndReleaseItemExclusive GetSessionStoreItem SetItemExpireCallback SessionStateItemCollection Serialize Deserialize DeserializeSessionItems CleanupOldSessions GetCleanupInterval CheckStorageEngine DeleteTimedOutSessions DeleteTimedOutSessionsWithoutCallback DeleteTimedOutSessionsWithCallback EnableExpireCallback ApplicationId name desc value connection stateSaver savedState rootPath add path doc config configValue defaultValue username oldPassword newPassword password newPwdQuestion newPwdAnswer email passwordQuestion passwordAnswer isApproved providerUserKey status System.Runtime.InteropServices OutAttribute deleteAllRelatedData pageIndex pageSize totalRecords answer userIsOnline user usernameToMatch emailToMatch e action reader encodedPassword format key bytes passwordKey userId failureType dbpassword question argumentName throwExceptions authenticationOption userInactiveSinceDate usernames profiles context collection profileRow values isAuthenticated index stringData binaryData rolenames rolename throwOnPopulatedRole version applicationId authenticated timeout id locked lockAge lockId actions item newItem lockRecord actionFlags items serializedItems o con System.Runtime.Versioning TargetFrameworkAttribute System.Reflection AssemblyTitleAttribute AssemblyDescriptionAttribute AssemblyConfigurationAttribute AssemblyCompanyAttribute AssemblyProductAttribute AssemblyCopyrightAttribute AssemblyTrademarkAttribute AssemblyCultureAttribute System.Security AllowPartiallyTrustedCallersAttribute ComVisibleAttribute SecurityRulesAttribute SecurityRuleSet AssemblyKeyNameAttribute AssemblyVersionAttribute AssemblyInformationalVersionAttribute NeutralResourcesLanguageAttribute System.Diagnostics DebuggableAttribute DebuggingModes System.Runtime.CompilerServices CompilationRelaxationsAttribute RuntimeCompatibilityAttribute MySql.Web MySqlCommand MySqlParameterCollection get_Parameters MySqlParameter AddWithValue System.Data.Common DbCommand ExecuteScalar Convert ToInt64 ExecuteNonQuery System.Configuration.Provider ProviderException get_LastInsertedId System.ComponentModel RunInstallerAttribute System.Security.Permissions PermissionSetAttribute SecurityAction Microsoft.Win32 Registry GetValue ToString String get_Length Substring System.IO Path DirectorySeparatorChar Char Format Directory Exists Concat File StreamReader TextReader ReadToEnd Close LoadXml XmlTextWriter System.Text Encoding Formatting set_Formatting XmlWriter Save Flush XmlNode XmlNodeType CreateNode XmlElement SetAttribute XmlNodeList GetElementsByTagName get_ItemOf get_ChildNodes IEnumerator GetEnumerator get_Current XmlAttributeCollection get_Attributes XmlAttribute get_Value op_Equality MoveNext IDisposable AppendChild Assembly GetExecutingAssembly get_FullName Replace get_FirstChild StringComparison StartsWith RemoveChild ArgumentNullException get_Item IsNullOrEmpty Remove Add ProviderBase System.Web.Hosting HostingEnvironment get_ApplicationVirtualPath ToInt32 ToBoolean ToLowerInvariant ConfigurationManager ConnectionStringSettingsCollection get_ConnectionStrings get_ConnectionString Trim Monitor Enter Empty Exit ValidatePasswordEventArgs OnValidatingPassword get_Cancel get_FailureInformation DbConnection Open get_Now Int32 MySqlTransaction BeginTransaction Int64 Boolean DbTransaction Commit Rollback Membership get_UserIsOnlineTimeWindow Subtract CommandBehavior ExecuteReader DbDataReader Read GetBoolean MembershipPasswordException GetString GetOrdinal GetInt32 set_CommandText NotSupportedException GeneratePassword GetByte get_UserName get_Email get_Comment get_IsApproved get_LastLoginDate get_LastActivityDate get_HasRows EventLog set_Source set_Log Environment get_NewLine WriteEntry IsDBNull DBNull Value GetDateTime get_Name get_Unicode FromBase64String DecryptPassword System.Security.Cryptography RNGCryptoServiceProvider Byte RandomNumberGenerator GetBytes ToBase64String get_HashAlgorithmType HashAlgorithm Create KeyedHashAlgorithm set_Key ComputeHash Array Copy EncryptPassword AddMinutes op_GreaterThan DbParameterCollection Clear set_Connection ArgumentException get_Chars IsLetterOrDigit System.Text.RegularExpressions Regex IsMatch get_CommandText MySqlDbType System.Collections.Generic List`1 GetUInt64 Enumerator UInt64 DbParameter set_Value get_Count ProfileInfo MinValue Hashtable SettingsProperty Type get_PropertyType get_IsPrimitive RuntimeTypeHandle GetTypeFromHandle SettingsSerializeAs set_SerializeAs SettingsPropertyValue MySqlDataAdapter DataTable DbDataAdapter Fill DataRowCollection get_Rows InternalDataCollectionBase Split get_InvariantCulture IFormatProvider Parse set_PropertyValue set_IsDirty set_Deserialized Equals set_SerializedValue Buffer BlockCopy get_IsDirty get_Property SettingsAttributeDictionary StringBuilder MemoryStream get_UsingDefaultValue get_SerializedValue get_Deserialized get_PropertyValue AppendFormat Append Stream get_Position Write ToArray op_Inequality System.CodeDom.Compiler GeneratedCodeAttribute DebuggerNonUserCodeAttribute CompilerGeneratedAttribute ReferenceEquals get_Assembly EditorBrowsableAttribute EditorBrowsableState ToUpper IndexOf GetType Compare MySqlScript set_Query Execute get_Number GetSchema set_Item WebConfigurationManager Configuration OpenWebConfiguration ConfigurationSectionGroupCollection get_SectionGroups ConfigurationSectionGroup ConfigurationSectionCollection get_Sections ConfigurationSection HttpException TimerCallback SessionStateUtility HttpStaticObjectsCollection GetSessionStaticObjects ISessionStateItemCollection get_Timeout get_TotalMinutes Double Invoke get_Message get_Items Zero CompareTo BinaryWriter BinaryReader Trace WriteLine SecurityException MySql.Web.Properties.Resources.resources mS E L E C T i d F R O M m y _ a s p n e t _ a p p l i c a t i o n s W H E R E n a m e = @ n a m e @ n a m e I N S E R T I N T O m y _ a s p n e t _ a p p l i c a t i o n s V A L U E S ( N U L L , @ a p p N a m e , @ a p p D e s c ) @ a p p N a m e @ a p p D e s c iH K E Y _ L O C A L _ M A C H I N E \ S o f t w a r e \ M i c r o s o f t \ . N E T F r a m e w o r k \ I n s t a l l R o o t eU n a b l e t o r e t r i e v e i n s t a l l r o o t f o r . N E T f r a m e w o r k { 0 } 6 4 { 1 } v 2 . 0 . 5 0 7 2 7 v 4 . 0 . 3 0 3 1 9 { 0 } \ C O N F I G %{ 0 } \ m a c h i n e . c o n f i g a d d n a m e !L o c a l M y S q l S e r v e r !c o n n e c t i o n S t r i n g #c o n n e c t i o n S t r i n g s /M y S Q L M e m b e r s h i p P r o v i d e r _M y S q l . W e b . S e c u r i t y . M y S Q L M e m b e r s h i p P r o v i d e r , { 0 } I n s t a l l e r s W e b t y p e )c o n n e c t i o n S t r i n g N a m e /e n a b l e P a s s w o r d R e t r i e v a l f a l s e 'e n a b l e P a s s w o r d R e s e t t r u e 3r e q u i r e s Q u e s t i o n A n d A n s w e r a p p l i c a t i o n N a m e / 'r e q u i r e s U n i q u e E m a i l p a s s w o r d F o r m a t C l e a r 5m a x I n v a l i d P a s s w o r d A t t e m p t s 5 3m i n R e q u i r e d P a s s w o r d L e n g t h 7 Im i n R e q u i r e d N o n a l p h a n u m e r i c C h a r a c t e r s 1 +p a s s w o r d A t t e m p t W i n d o w 1 0 Cp a s s w o r d S t r e n g t h R e g u l a r E x p r e s s i o n m e m b e r s h i p UM y S q l . W e b . S e c u r i t y . M y S Q L M e m b e r s h i p P r o v i d e r #M y S Q L R o l e P r o v i d e r SM y S q l . W e b . S e c u r i t y . M y S Q L R o l e P r o v i d e r , { 0 } r o l e M a n a g e r IM y S q l . W e b . S e c u r i t y . M y S Q L R o l e P r o v i d e r )M y S Q L P r o f i l e P r o v i d e r WM y S q l . W e b . P r o f i l e . M y S Q L P r o f i l e P r o v i d e r , { 0 } p r o f i l e MM y S q l . W e b . P r o f i l e . M y S Q L P r o f i l e P r o v i d e r
c o n f i g d e s c r i p t i o n 3M y S Q L d e f a u l t a p p l i c a t i o n T r u e F a l s e 3w r i t e E x c e p t i o n s T o E v e n t L o g
h a s h e d e n c r y p t e d c l e a r =P a s s w o r d f o r m a t n o t s u p p o r t e d . n e w P a s s w o r d YU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d = @ p a s s , L a s t P a s s w o r d C h a n g e d D a t e = @ l a s t P a s s w o r d C h a n g e d D a t e
W H E R E u s e r I d = @ u s e r I d @ p a s s 1@ l a s t P a s s w o r d C h a n g e d D a t e @ u s e r I d C h a n g e P a s s w o r d ]U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d Q u e s t i o n = @ p a s s w o r d Q u e s t i o n , P a s s w o r d A n s w e r = @ p a s s w o r d A n s w e r
W H E R E u s e r I d = @ u s e r I d #@ p a s s w o r d Q u e s t i o n @ p a s s w o r d A n s w e r ?C h a n g e P a s s w o r d Q u e s t i o n A n d A n s w e r p a s s w o r d I N S E R T I N T O m y _ a s p n e t _ m e m b e r s h i p
V A L U E S ( @ u s e r I d , @ e m a i l , @ c o m m e n t , @ p a s s w o r d , @ p a s s w o r d K e y ,
@ p a s s w o r d F o r m a t , @ p a s s w o r d Q u e s t i o n , @ p a s s w o r d A n s w e r ,
@ i s A p p r o v e d , @ l a s t A c t i v i t y D a t e , @ l a s t L o g i n D a t e ,
@ l a s t P a s s w o r d C h a n g e d D a t e , @ c r e a t i o n D a t e ,
@ i s L o c k e d O u t , @ l a s t L o c k e d O u t D a t e , @ f a i l e d P a s s w o r d A t t e m p t C o u n t ,
@ f a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t , @ f a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t ,
@ f a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t )
@ e m a i l @ c o m m e n t @ p a s s w o r d @ p a s s w o r d K e y @ p a s s w o r d F o r m a t @ i s A p p r o v e d #@ l a s t A c t i v i t y D a t e @ l a s t L o g i n D a t e @ c r e a t i o n D a t e @ i s L o c k e d O u t %@ l a s t L o c k e d O u t D a t e 7@ f a i l e d P a s s w o r d A t t e m p t C o u n t C@ f a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t C@ f a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t O@ f a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t C r e a t e U s e r %D E L E T E { 0 } m
F R O M m y _ a s p n e t _ u s e r s u , m y _ a s p n e t _ m e m b e r s h i p m
W H E R E u . i d = m . u s e r I d A N D u . i d = @ u s e r I d u ,
@ a p p I d D e l e t e U s e r QS E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ m e m b e r s h i p m J O I N m y _ a s p n e t _ u s e r s u
O N m . u s e r I d = u . i d W H E R E m . L a s t A c t i v i t y D a t e > @ d a t e A N D u . a p p l i c a t i o n I d = @ a p p I d @ d a t e -G e t N u m b e r O f U s e r s O n l i n e 'U s e r n a m e n o t f o u n d . S E L E C T P a s s w o r d , P a s s w o r d A n s w e r , P a s s w o r d K e y , P a s s w o r d F o r m a t ,
I s L o c k e d O u t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d I s L o c k e d O u t P a s s w o r d P a s s w o r d A n s w e r P a s s w o r d K e y G e t P a s s w o r d 1G e t U s e r ( S t r i n g , B o o l e a n ) U P D A T E m y _ a s p n e t _ u s e r s S E T l a s t A c t i v i t y D a t e = @ d a t e W H E R E i d = @ u s e r I d U P D A T E m y _ a s p n e t _ m e m b e r s h i p S E T L a s t A c t i v i t y D a t e = @ d a t e W H E R E u s e r I d = @ u s e r I d )S E L E C T m . * , u . n a m e
F R O M m y _ a s p n e t _ m e m b e r s h i p m J O I N m y _ a s p n e t _ u s e r s u O N m . u s e r I d = u . i d
W H E R E u . i d = @ u s e r I d 1G e t U s e r ( O b j e c t , B o o l e a n ) 9U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T I s L o c k e d O u t = f a l s e , L a s t L o c k e d O u t D a t e = @ l a s t D a t e
W H E R E u s e r I d = @ u s e r I d @ l a s t D a t e U n l o c k U s e r kS E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s u
J O I N m y _ a s p n e t _ m e m b e r s h i p m O N m . u s e r i d = u . i d
W H E R E m . E m a i l = @ e m a i l A N D u . a p p l i c a t i o n I d = @ a p p I d %G e t U s e r N a m e B y E m a i l 5S E L E C T P a s s w o r d A n s w e r ,
P a s s w o r d K e y , P a s s w o r d F o r m a t , I s L o c k e d O u t
F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d P a s s w o r d F o r m a t GU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T P a s s w o r d = @ p a s s , L a s t P a s s w o r d C h a n g e d D a t e = @ l a s t P a s s C h a n g e
W H E R E u s e r I d = @ u s e r I d @ l a s t P a s s C h a n g e R e s e t P a s s w o r d U P D A T E m y _ a s p n e t _ m e m b e r s h i p m , m y _ a s p n e t _ u s e r s u
S E T m . E m a i l = @ e m a i l , m . C o m m e n t = @ c o m m e n t , m . I s A p p r o v e d = @ i s A p p r o v e d ,
m . L a s t L o g i n D a t e = @ l a s t L o g i n D a t e , u . l a s t A c t i v i t y D a t e = @ l a s t A c t i v i t y D a t e ,
m . L a s t A c t i v i t y D a t e = @ l a s t A c t i v i t y D a t e
W H E R E m . u s e r I d = u . i d A N D u . n a m e L I K E @ n a m e A N D u . a p p l i c a t i o n I d = @ a p p I d
@ E m a i l @ C o m m e n t U p d a t e U s e r #S E L E C T P a s s w o r d , P a s s w o r d K e y , P a s s w o r d F o r m a t , I s A p p r o v e d ,
I s l o c k e d o u t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E u s e r I d = @ u s e r I d 1U P D A T E m y _ a s p n e t _ m e m b e r s h i p m , m y _ a s p n e t _ u s e r s u
S E T m . L a s t L o g i n D a t e = @ l a s t L o g i n D a t e , u . l a s t A c t i v i t y D a t e = @ d a t e ,
m . L a s t A c t i v i t y D a t e = @ d a t e
W H E R E m . u s e r I d = @ u s e r i d A N D u . i d = @ u s e r i d @ u s e r i d V a l i d a t e U s e r S E L E C T i d F R O M m y _ a s p n e t _ u s e r s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d sA n e x c e p t i o n o c c u r r e d c o m m u n i c a t i n g w i t h t h e d a t a s o u r c e . A c t i o n : E x c e p t i o n :
u s e r I d E m a i l !P a s s w o r d Q u e s t i o n C o m m e n t I s A p p r o v e d C r e a t i o n D a t e L a s t L o g i n D a t e !L a s t A c t i v i t y D a t e /L a s t P a s s w o r d C h a n g e d D a t e #L a s t L o c k e d o u t D a t e S E L E C T F a i l e d P a s s w o r d A t t e m p t C o u n t ,
F a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t , F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t ,
F a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t F R O M m y _ a s p n e t _ m e m b e r s h i p
W H E R E u s e r I d = @ u s e r I d U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A t t e m p t C o u n t = @ c o u n t ,
F a i l e d P a s s w o r d A t t e m p t W i n d o w S t a r t = @ w i n d o w S t a r t
W H E R E u s e r I d = @ u s e r I d U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t = @ c o u n t ,
F a i l e d P a s s w o r d A n s w e r A t t e m p t W i n d o w S t a r t = @ w i n d o w S t a r t
W H E R E u s e r I d = @ u s e r I d
@ c o u n t @ w i n d o w S t a r t +U P D A T E m y _ a s p n e t _ m e m b e r s h i p S E T I s L o c k e d O u t = @ i s L o c k e d O u t ,
L a s t L o c k e d O u t D a t e = @ l a s t L o c k e d O u t D a t e W H E R E u s e r I d = @ u s e r I d U P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A t t e m p t C o u n t = @ c o u n t W H E R E u s e r I d = @ u s e r I d EU P D A T E m y _ a s p n e t _ m e m b e r s h i p
S E T F a i l e d P a s s w o r d A n s w e r A t t e m p t C o u n t = @ c o u n t
W H E R E u s e r I d = @ u s e r I d ?U n a b l e t o u p d a t e f a i l u r e c o u n t . %U p d a t e F a i l u r e C o u n t S E L E C T P a s s w o r d K e y , P a s s w o r d F o r m a t F R O M m y _ a s p n e t _ m e m b e r s h i p W H E R E
u s e r I d = @ u s e r I d sS E L E C T S Q L _ C A L C _ F O U N D _ R O W S u . n a m e , m . * F R O M m y _ a s p n e t _ u s e r s u
J O I N m y _ a s p n e t _ m e m b e r s h i p m O N m . u s e r I d = u . i d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d - A N D u . n a m e L I K E @ n a m e 1 A N D m . E m a i l L I K E @ e m a i l A O R D E R B Y u . i d A S C L I M I T { 0 } , { 1 } 'S E L E C T F O U N D _ R O W S ( ) G e t U s e r s A p p l i c a t i o n eA n e x c e p t i o n o c c u r r e d . P l e a s e c h e c k t h e E v e n t L o g . -M y S Q L P r o f i l e p r o v i d e r S E L E C T * F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D
l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e ) A N D i s A n o n y m o u s = 1 ) A N D i s A n o n y m o u s = 0 kD E L E T E F R O M m y _ a s p n e t _ p r o f i l e s W H E R E u s e r I d = @ u s e r I d S E L E C T * F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D n a m e = @ n a m e +S E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D
l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e U s e r N a m e QS E L E C T * F R O M m y _ a s p n e t _ p r o f i l e s p
J O I N m y _ a s p n e t _ u s e r s u O N u . i d = p . u s e r I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d A N D u . n a m e = @ n a m e I s A u t h e n t i c a t e d 1I N S E R T I N T O m y _ a s p n e t _ p r o f i l e s
V A L U E S ( @ u s e r I d , @ i n d e x , @ s t r i n g D a t a , @ b i n a r y D a t a , N U L L ) O N D U P L I C A T E K E Y U P D A T E
v a l u e i n d e x = V A L U E S ( v a l u e i n d e x ) , s t r i n g d a t a = V A L U E S ( s t r i n g d a t a ) ,
b i n a r y d a t a = V A L U E S ( b i n a r y d a t a )
@ i n d e x @ s t r i n g D a t a @ b i n a r y D a t a gD E L E T E F R O M m y _ a s p n e t _ p r o f i l e s W H E R E u s e r I d = @ u s e r I d v a l u e i n d e x s t r i n g D a t a b i n a r y D a t a 0 A l l o w A n o n y m o u s { 0 } / / 0 / - 1 : { 0 } / 0 / { 1 } / { 2 } : { 0 } / 1 / { 1 } / { 2 } : 5S E L E C T p . * , u . n a m e , u . i s A n o n y m o u s , u . l a s t A c t i v i t y D a t e ,
L E N G T H ( p . s t r i n g d a t a ) + L E N G T H ( p . b i n a r y d a t a ) A S p r o f i l e s i z e
F R O M m y _ a s p n e t _ p r o f i l e s p
J O I N m y _ a s p n e t _ u s e r s u O N u . i d = p . u s e r I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d 5 A N D u . n a m e L I K E @ u s e r N a m e @ u s e r N a m e W A N D u . l a s t A c t i v i t y D a t e < @ l a s t A c t i v i t y D a t e - A N D u . i s A n o n y m o u s = 1 - A N D u . i s A n o n y m o u s = 0 L I M I T { 0 } , { 1 } i s A n o n y m o u s !l a s t A c t i v i t y D a t e l a s t U p d a t e d D a t e p r o f i l e s i z e =M y S q l . W e b . P r o p e r t i e s . R e s o u r c e s 5C a n n o t D e l e t e A P o p u l a t e d R o l e ;C a n n o t R e t r i e v e H a s h e d P a s s w o r d s /C a n n o t U n e n c o d e H a s h e d P w d -C h a n g e P a s s w o r d C a n c e l e d ;E r r o r I n i t O f M e m b e r s h i p P r o v i d e r /E r r o r I n i t O f R o l e P r o v i d e r 1E r r o r I n i t P r o f i l e P r o v i d e r -E r r o r R e s e t t i n g P a s s w o r d I l l e g a l R o l e N a m e I l l e g a l U s e r N a m e /I n c o r r e c t P a s s w o r d A n s w e r 7I n v a l i d C h a r a c t e r s I n U s e r N a m e )M i s s i n g O r W r o n g S c h e m a -M o n o D o e s N o t S u p p o r t H a s h 7N e w P a s s w o r d V a l i d a t i o n F a i l e d ;N o t E n o u g h N o n A l p h a N u m e r i c I n P w d +P a s s w o r d A n s w e r I n v a l i d +P a s s w o r d N o t L o n g E n o u g h /P a s s w o r d Q u e s t i o n I n v a l i d 1P a s s w o r d R e q u i r e d F o r R e s e t ;P a s s w o r d R e s e t C a n c e l e d N o t V a l i d /P a s s w o r d R e s e t N o t E n a b l e d 7P a s s w o r d R e t r i e v a l N o t E n a b l e d 'P r o f i l e U p d a t e F a i l e d +R o l e N a m e A l r e a d y E x i s t s !R o l e N a m e N o t F o u n d s c h e m a 1 s c h e m a 2 s c h e m a 3 s c h e m a 4 s c h e m a 5 s c h e m a 6 s c h e m a 7 s c h e m a 8 3U n a b l e T o C r e a t e A p p l i c a t i o n %U n a b l e T o C r e a t e U s e r 'U n a b l e T o L o c k O u t U s e r 7U n a b l e T o R e t r i e v e P r o f i l e D a t a 5U n a b l e T o U p d a t e F a i l u r e C o u n t 3U n s u p p o r t e d P a s s w o r d F o r m a t 'U s e r I s A l r e a d y I n R o l e U s e r I s L o c k e d O u t !U s e r n a m e N o t F o u n d U s e r N o t I n R o l e 1V a l i d a t e P a s s w o r d C a n c e l e d 'M y S Q L R o l e p r o v i d e r T R U E r o l e n a m e s u s e r n a m e s wI N S E R T I N T O m y _ a s p n e t _ u s e r s i n r o l e s V A L U E S ( @ u s e r I d , @ r o l e I d ) @ r o l e I d A d d U s e r s T o R o l e s oI N S E R T I N T O m y _ a s p n e t _ r o l e s V a l u e s ( N U L L , @ a p p I d , @ n a m e ) C r e a t e R o l e D E L E T E u i r F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r J O I N
m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E r . n a m e L I K E @ r o l e n a m e A N D r . a p p l i c a t i o n I d = @ a p p I d @ r o l e n a m e D E L E T E F R O M m y _ a s p n e t _ r o l e s W H E R E n a m e = @ r o l e n a m e
A N D a p p l i c a t i o n I d = @ a p p I d D e l e t e R o l e kS E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s u J O I N
m y _ a s p n e t _ u s e r s i n r o l e s u i r O N u i r . u s e r I d = u . i d A N D u i r . r o l e I d = @ r o l e I d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d G e t U s e r s I n R o l e uS E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E u . a p p l i c a t i o n I d = @ a p p I d A N D
u . n a m e L I K E @ u s e r N a m e A N D r . n a m e L I K E @ r o l e N a m e @ r o l e N a m e I s U s e r I n R o l e D E L E T E u i r F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E u . n a m e L I K E @ u s e r n a m e A N D r . n a m e L I K E @ r o l e n a m e
A N D u . a p p l i c a t i o n I d = @ a p p I d A N D r . a p p l i c a t i o n I d = @ a p p I d @ u s e r n a m e )R e m o v e U s e r s F r o m R o l e s S E L E C T C O U N T ( * ) F R O M m y _ a s p n e t _ r o l e s W H E R E a p p l i c a t i o n I d = @ a p p I d
A N D n a m e L I K E @ n a m e R o l e E x i s t s S E L E C T u . n a m e F R O M m y _ a s p n e t _ u s e r s i n r o l e s u i r
J O I N m y _ a s p n e t _ u s e r s u O N u i r . u s e r I d = u . i d
J O I N m y _ a s p n e t _ r o l e s r O N u i r . r o l e I d = r . i d
W H E R E r . n a m e L I K E @ r o l e n a m e A N D
u . n a m e L I K E @ u s e r n a m e A N D
u . a p p l i c a t i o n I d = @ a p p I d F i n d U s e r s I n R o l e oD E L E T E F R O M m y _ a s p n e t _ u s e r s i n r o l e s W H E R E u s e r I d = @ u s e r I d KS E L E C T r . n a m e F R O M m y _ a s p n e t _ r o l e s r J O I N m y _ a s p n e t _ u s e r s i n r o l e s u i r O N u i r . r o l e I d = r . i d A N D u i r . u s e r I d = ; W H E R E r . a p p l i c a t i o n I d = @ a p p I d %G e t R o l e s B y U s e r N a m e S E L E C T i d F R O M m y _ a s p n e t _ u s e r s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d S E L E C T i d F R O M m y _ a s p n e t _ r o l e s W H E R E n a m e = @ n a m e A N D a p p l i c a t i o n I d = @ a p p I d M o n o . R u n t i m e %a u t o g e n e r a t e s c h e m a s c h e m a { 0 } YU P D A T E m y _ a s p n e t _ s c h e m a v e r s i o n S E T v e r s i o n = 7 KS E L E C T * F R O M m y _ a s p n e t _ s c h e m a v e r s i o n !m y s q l _ M e m b e r s h i p
T a b l e s T A B L E _ C O M M E N T S E L E C T i d F R O M m y _ a s p n e t _ u s e r s
W H E R E a p p l i c a t i o n I d = @ a p p I d A N D n a m e = @ n a m e I N S E R T I N T O m y _ a s p n e t _ u s e r s V A L U E S
( N U L L , @ a p p I d , @ n a m e , @ i s A n o n , N o w ( ) ) @ i s A n o n /S E L E C T L A S T _ I N S E R T _ I D ( ) wA n e x c e p t i o n o c c u r r e d c o m m u n i c a t i n g w i t h t h e d a t a s o u r c e .
EM y S Q L S e s s i o n S t a t e S t o r e P r o v i d e r s y s t e m . w e b s e s s i o n S t a t e EC o n n e c t i o n s t r i n g c a n n o t b e b l a n k )e n a b l e E x p i r e C a l l b a c k I n i t i a l i z e I N S E R T I G N O R E I N T O m y _ a s p n e t _ s e s s i o n c l e a n u p S E T A p p l i c a t i o n I d = @ A p p l i c a t i o n I d , L a s t R u n = N O W ( ) , I n t e r v a l M i n u t e s = 1 0 @ A p p l i c a t i o n I d I N S E R T I N T O m y _ a s p n e t _ s e s s i o n s ( S e s s i o n I d , A p p l i c a t i o n I d , C r e a t e d , E x p i r e s , L o c k D a t e , L o c k I d , T i m e o u t , L o c k e d , S e s s i o n I t e m s , F l a g s ) V a l u e s ( @ S e s s i o n I d , @ A p p l i c a t i o n I d , N O W ( ) , N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E , N O W ( ) , @ L o c k I d , @ T i m e o u t , @ L o c k e d , @ S e s s i o n I t e m s , @ F l a g s ) @ S e s s i o n I d @ L o c k I d @ T i m e o u t @ L o c k e d @ S e s s i o n I t e m s
@ F l a g s /C r e a t e U n i n i t i a l i z e d I t e m SU P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k e d = 0 , E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d )R e l e a s e I t e m E x c l u s i v e D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d %R e m o v e I t e m E r r o r : U P D A T E m y _ a s p n e t _ s e s s i o n s S E T E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d !R e s e t I t e m T i m e o u t R E P L A C E I N T O m y _ a s p n e t _ s e s s i o n s ( S e s s i o n I d , A p p l i c a t i o n I d , C r e a t e d , E x p i r e s , L o c k D a t e , L o c k I d , T i m e o u t , L o c k e d , S e s s i o n I t e m s , F l a g s ) V a l u e s ( @ S e s s i o n I d , @ A p p l i c a t i o n I d , N O W ( ) , N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E , N O W ( ) , @ L o c k I d , @ T i m e o u t , @ L o c k e d , @ S e s s i o n I t e m s , @ F l a g s ) U P D A T E m y _ a s p n e t _ s e s s i o n s S E T E x p i r e s = N O W ( ) + I N T E R V A L @ T i m e o u t M I N U T E , S e s s i o n I t e m s = @ S e s s i o n I t e m s , L o c k e d = @ L o c k e d W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k I d = @ L o c k I d 5S e t A n d R e l e a s e I t e m E x c l u s i v e =U P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k e d = 1 , L o c k D a t e = N O W ( ) W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d A N D L o c k e d = 0 A N D E x p i r e s > N O W ( ) YS E L E C T N O W ( ) , E x p i r e s , S e s s i o n I t e m s , L o c k I d , F l a g s , T i m e o u t , L o c k D a t e , L o c k e d F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d U P D A T E m y _ a s p n e t _ s e s s i o n s S E T L o c k I d = @ L o c k I d , F l a g s = 0 W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d 'G e t S e s s i o n S t o r e I t e m U P D A T E m y _ a s p n e t _ s e s s i o n c l e a n u p S E T L a s t R u n = N O W ( ) W H E R E L a s t R u n + I N T E R V A L I n t e r v a l M i n u t e s M I N U T E < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d %C l e a n u p O l d S e s s i o n s S E L E C T I n t e r v a l M i n u t e s f r o m m y _ a s p n e t _ s e s s i o n c l e a n u p w h e r e A p p l i c a t i o n I d = @ A p p l i c a t i o n I d S E L E C T E N G I N E F R O M I N F O R M A T I O N _ S C H E M A . T A B L E S W H E R E T A B L E _ N A M E = ' m y _ a s p n e t _ s e s s i o n s '
M y I S A M S t o r a g e e n g i n e f o r t a b l e m y _ a s p n e t _ s e s s i o n s i s M y I S A M . I f p o s s i b l e , p l e a s e c h a n g e i t t o a t r a n s a c t i o n a l s t o r a g e e n g i n e t o i m p r o v e p e r f o r m a n c e , e . g w i t h ' a l t e r t a b l e m y _ a s p n e t _ s e s s i o n s e n g i n e i n n o d b '
Og o t e x c e p t i o n w h i l e c h e c k i n g f o r e n g i n e D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E E x p i r e s < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d {G o t e x c e p t i o n i n D e l e t e T i m e d O u t S e s s i o n s W i t h O u t C a l l b a c k S E L E C T S e s s i o n I D , S e s s i o n I t e m s F R O M m y _ a s p n e t _ s e s s i o n s W H E R E E x p i r e s < N O W ( ) A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d D E L E T E F R O M m y _ a s p n e t _ s e s s i o n s W H E R E S e s s i o n I d = @ S e s s i o n I d A N D A p p l i c a t i o n I d = @ A p p l i c a t i o n I d sG o t e x c e p t i o n i n D e l e t e T i m e d O u t S e s s i o n s W i t h C a l l b a c k -M y S Q L S e s s i o n S t a t e S t o r e eA n e x c e p t i o n o c c u r r e d . P l e a s e c h e c k t h e e v e n t l o g . v
2.JL55 z\V4?_
:18V6N5
hȉiM
(
( ! %) - ) 1 5 9 1 1 1 9 = 1A ) ) ) )
9 ( ( ( ) EI M
MEI ME MEI
ME QUY UQ ]Q
Q ae a e e a e i -
mqu y } }
} } } u
}
$ $ RSA1 s qu,x)A&JACq_<_e Z@gюzF}zQ$q(X
i $[JNP c O\Nec2 n8b1A
lk>
.System.Security.Permissions.PermissionSetAttribute, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089TName FullTrust 1 5 9 %%-
=A I = I M Q U ==EI==MY ] = a E]I==MYI==MY u ii } = I =} )y )y }1I
y1 y I I yI A A)y y1 A 1Ay1 y })A y I y A)Iy I
IIIII
IIIII1 1
I I
IIIAIy A9 Ay9 i= A MYI ] Q
=QMY
= ! ) - - - "
--1 MYMY
II MAM@ 3System.Resources.Tools.StronglyTypedResourceBuilder4.0.0.0 ] ]a e I "
= y = A= =
! y = Ay A= =
a My y U Y ] a e m U y y u
yu
y }
y y y I I
} AII Iy 5 1 1 y(( Ay = A } =I .NETFramework,Version=v4.5 TFrameworkDisplayName.NET Framework 4.5 MySql.Web ADO.Net driver for MySQL Oracle P KCopyright © 2004, 2013, Oracle and/or its affiliates. All rights reserved. ConnectorNet
6.8.3
en-US TWrapNonExceptionThrows ڰR l RSDScTNKNk% c:\Jenkins\Jobs\C_Net_6_8_Compilation\Workspace\Source\MySql.Web\obj\v4.5\MySql.Web.pdb _CorDllMain mscoree.dll % 0 H X 4 V S _ V E R S I O N _ I N F O ? D V a r F i l e I n f o $ T r a n s l a t i o n S t r i n g F i l e I n f o 0 0 0 0 0 4 b 0 L C o m m e n t s A D O . N e t d r i v e r f o r M y S Q L 0 C o m p a n y N a m e O r a c l e <
F i l e D e s c r i p t i o n M y S q l . W e b 0 F i l e V e r s i o n 6 . 8 . 3 . 0 < I n t e r n a l N a m e M y S q l . W e b . d l l K L e g a l C o p y r i g h t C o p y r i g h t 2 0 0 4 , 2 0 1 3 , O r a c l e a n d / o r i t s a f f i l i a t e s . A l l r i g h t s r e s e r v e d . D O r i g i n a l F i l e n a m e M y S q l . W e b . d l l 4
P r o d u c t N a m e M y S q l . W e b 0 P r o d u c t V e r s i o n 6 . 8 . 3 8 A s s e m b l y V e r s i o n 6 . 8 . 3 . 0 <