MZ @ !L!This program cannot be run in DOS mode.
$ PE L "J ! " ` @ O ` d H .text ! " `.rsrc ` $ @ @.reloc * @ B % @ @ Z N _CorDllMain mscoree.dll @ H W | u (
*V(
o
(
* z{ 9 { o
} * 0 S ~
(
9 rY ps
} { o
(
o
{ r ps
o
* 0
(
r p{ s
o
r p(
s
o
&o
o
9 (
o
> o
0
9 o
9 o
(!
* AL = 3 p
i
07 0 o"
o 9 8
(
r
p{ s
o
r po"
(
s
o
&o
r, po#
s
o
&o
r8 po$
s
o
&o
rR po%
s
o
&o
r^ po&
s
o
&o
rl po'
s
o
&o
r po(
s
o
&o)
&
9 o
(!
*A4 /
( 04 (
(
r p{ s
o
r po"
(
s
o
&o
r, po#
s
o
&o
r8 po$
s
o
&o
rR po%
s
o
&o
r^ po&
s
o
&o
rl po'
s
o
&o
r po(
s
o
&o)
&
9 o
(!
*A4
0 o'
9
r p8 r p
o&
9
r p8 r p o(
9
o(
i8 ~ r pr p %o"
%o#
%o$
%o%
%%% (
(*
o+
*0
(
r p{ s
o
r p(
s
o
&o
o
9
o
= o
0
9 o
9 o
(!
*AL = * g
` y
0
H r[ p{ s
o
r p(
s
o
&o)
&
9 o
*A ) :
0 s,
r po-
t
s.
o/
r po-
t
o0
r po-
t
o1
r po-
(2
o3
r po-
(4
o5
r po-
(4
o6
r po-
t o7
* 0 s8
r po-
t
s.
o9
r po-
t
o:
r po-
t
o;
r po-
(2
o<
r po-
(4
o=
o>
* 0 s?
(
r p{ s
o
r p s
o
&o
r p s
o
&o
8 ( o@
o
:
9 o
9 o
(!
* AL _ %
v
0 f
(
o
o
o
o
r p %o
%o
%o
%o
(
* 2rY po * r! p* JsA
}
(B
* V(
o
(
* 0 } ~ r p{ (*
o+
{ s
}
{
o
(
o
{
r ps
o
{
o
{
o
% (F
&oG
} { 8@
oH
oI
r p(
9 {
oH
oJ
oK
Xi?*Z{
oC
sD
oE
* 0 E sL
% sM
oN
r pr6 p( (O
rZ p(P
{
oQ
t oR
o
r p(
oS
&o
o
9, ( 8 {
oT
oU
u 9R o-
(V
9 {
oT
oW
8 {
oT
oW
8 {
oT
oU
u 9; ~X
o-
oY
(Z
&{
oT
oW
82 {
oT
o-
{
oT
o[
(\
oW
Xi? o
8P o
( sD
r po]
&
%r p%r p oE
(O
%r p%r p oE
(O
%r% p(^
oR
o
o_
( 8
{
oT
oU
u 9b {
oT
oU
y F9" o
r) p
(*
r- poS
&8 o
r) p
(*
r1 poS
&80 o
r) p
(*
{
oT
oU
oY
oS
& X i?9o)
&r5 poR
o
o_
o
o
& rw po-
(`
oa
o
r} poR
o
r p(
oS
&o
r pob
(c
oS
&o)
& & o
o_
r pob
(c
r7 p(P
oR
o
r p(
oS
&o)
& & od
( ob
r p( oe
ob
r
p( of
ob
r0
p( og
* A4 2 2 0O
( sD
r po]
&sh
oi
8 (j
rL
p(P
ok
(l
: (m
rV
pr
poE
(O
r
p(P
{
oQ
t oR
( 8 {
oT
oU
u 9d {
oT
oU
y F9# o
r) p(*
r- poS
&8 o
r) p(*
r1 poS
&81 o
r) p(*
{
oT
oU
oY
oS
&Xi?6o)
&( ob
r pon
( ob
r
poo
( ob
r0
pop
( *A % 0 U 0 oq
{
oQ
t
r
poR
o
r pob
* oS
&o
8J sr
rD po-
oY
(Z
& os
rZ pot
rZ pou
ov
o
:o
* 0/ {
oQ
t
rj poR
o
r pob
(c
oS
&o)
&o
o_
r poR
ow
8Z o
r pob
(c
oS
&o
r pox
(
oS
&o)
&o
o_
X
i?* 0) {
oQ
t
r pr
p(P
oR
o
r p(c
oS
&o)
&o
o_
r
pr'
p(P
oR
8S q o
r p(c
oS
&o
r
p(
oS
&o)
&o
o_
X
i?* 0 sy
{
oQ
t r
pr
p(P
oR
o
r p* oS
&o
8' r
po-
oY
(Z
& oz
o
:o
o{
* (|
*V(
o
(
* 0 + ~ r
po r p(P
o+
o s}
z 6sU } * 2{ oW * r
p* r
p*
*
* 0 L s~
rC p(
o
{ rQ poX o
{ oY
o
o
*0 ^ o
>P s~
r pr p(*
o
{ r poX o
{ oY
o
o
** 0 L s~
r
p(
o
{ rG poX o
{ oY
o
o
*0 s
*V{ oZ 9 ** "o( * 0 4 s~
r
po
{ r poX o
> **0 7
9 r ps
zo& {
@ {
(
+*
*
* ( *V(
o
(
* 0 + ~ r po9 r p(P
o+
o9 s}
z 0, f ~
(
9 r p~ r p(*
o+
s
} { o
(
o
{ rb ps
o
r p{ s
s
} r p{ s
s
} s
} { o
(N o
{ { o
r po
o
&{ { (P ~ r po+
{ o
(M o
{ { o
r po
o
&{ { (O ~ r po+
{ o
* 0
u { 9 { o
} { 9 { o
} { 9 { o
} { 9 { o
} * 0o W s
r po
t
s.
o
r po
t
s.
o
r$ po
(V
o
r8 po
(V
o
rH po
t
s.
o
rf po
t
s.
o
rx po
t
o
r po
t
o
r po
t
o
r po
(`
o
r po
(`
o
r> po
(`
o
rp po
(`
o
r po
(`
o
r po
(
: r po
(V
o
r po
(
: r po
(
o
r po
(
: r po
(V
o
r po
(
: r po
t
s.
o
r. po
(
: r. po
(4
o
rD po
(
: rD po
(`
o
* 0Z r po
(
o
r po
(
o
r$ po
o
r8 po
o
rH po
(
o
rf po
(
o
rx po
o
r po
o
r po
o
r po
* o
r po
* o
r> po
* o
rp po
* o
r po
* o
r po
o
r po
o
r po
o
r po
o
r. po
o
rP po
* o
* 0! {
(
{ o
r po
o
o
(
o
:? : ~ r\ po
o
o
(R o
o
8' 9 ~ r po
o
(R { { r po
& (!
* A
0 {
(
{ o
r po
o
o
(
o
: o
(R o
o
8 (S { { r po
& (!
* A
x 03 9 {
(
{ o
r po
o
o
(
o
:? : ~ r po
o
o
(4 o
o
8' 9 ~ r? po
o
(4 { { r po
&{ o
r po
o
o
(
o
r pr po
y JX o
{ { r po
& (!
* A
$ 1 * r\ p* 0 f
(
o
o
o
o
r p %o
%o
%o
%o
(
* 0 {
(
s
{ o
r po
r p r. p(
o
8 (3 o
Xi? (!
* A
z s
* 0 {
(
s
{ o
r po
%r2 p% %rJ p%~X
%r. p(
o
8 (Q o
Xi?o
> o
(!
* A
0 {
(
{ o
r po
rp p r. p(
o
8 P(Q o
Xi? (!
* A
j w 0 s
(> * 0J s
{ (
{ o
r po
r p r. p(
o
o
?3 (Q
o
r2 p r. p(
o
9x o
?k o
~X
(
9P
85
(Q o
(
9
(Q o
X
i?8 o
s
8y
(Q o
~X
(
9M o
o
9 o
o
o
8 s
o
o
o
Xi?| o
9 o
o
89 o
o
o
9 o
o
o
o
Xo
? (!
* A 0 \ {
(
{ o
r po
o
(
o
9
(3 (!
*A
F S 0 [ ! {
(
{ o
r po
o
(
o
9 (Q (!
* A
E R &(7 * &(7 * 0 f " {
(
{ o
r po
o
(
o
9 o
{ { r po
& (!
* A
Q ^
*
* 0 B # o;
o
8 (
o
oE (
: (
* A * 9 &(5 * &(5 * "(6 * 0+ $ {
(
o@ { o
r po
o
8> (
o
o
(
o
9 o
(H o
(
: (
o
(
o
9
(H o
{ { r po
& (!
* A4 3 T
01 % r ps
r p
(F
( r p
(F
( r$ p (F
( r8 p (F
( rH p
(F
( rf p
(F
( rx p
(F
( r p
(F
( r p
(F
( r p (F
( r p (F
( r> p (F
( rp p (F
( r p (F
( r p (F
( r p (F
( r p (F
( r p
(F
( r. p (F
( rP p* (F
( 4 %o
r po
o
*0 % r ps
r p
(F
( r p
(F
( r p
(F
( r p
(F
( r p (F
( r p (F
( 4 %o
r po
o
* 0# & {
(
r p{ o
r po
( o
o
o
r pr p{ o
r po
( o
o
o
r ps
o
r p
(F
( o
&o
o
(!
* A
0# & {
(
r p{ o
r po
( o
o
o
r pr p{ o
r po
( o
o
o
rD ps
o
r p
(F
( o
&o
o
(!
* A
0 ' s
r po
t
s.
o
r po
t
o
r po
t
s.
o
r po
t
s.
o
r po
(
o
r po
(
o
* 0 ( r po
(
o
r po
o
r po
(
o
r po
(
o
r po
I o
r po
J o
* 0 3 ) r po
(
o
r po
(
o
* 0 {
(
s
{ o
r po
%r p% %r p% %r p(
o
8 (3 o
Xi? (!
* A
0 q * ( ~
~
(
9
8 ~ r po
r^ p
s
} { o
r po
(*
s
z * A N T 2 V(
o
(
* N{ o
} *0 h + { o
tM
o
o
8) (
(
(
s
o
o
&(
: (
*A ? ^ 03 2 , s
o
9 r po-
y/ L}
r po-
t
}
r
po-
t
s.
}
r po-
t
}
r0 po-
t
}
rJ po-
t
}
rf po-
t
}
}
r po-
t
}
r po-
y* K}
r po-
t
}
r po-
y J}
r po-
y J}
r po-
y J}!
r po-
y/ L}"
r po-
y/ L}#
r( po-
y/ L}$
rP po-
y/ L}%
rx po-
t
}&
r po-
t
}'
r po-
t
}(
r po-
t
})
r po-
t
}*
r" po-
t
}+
8 rF ps
z* 0M ' - rj p
r] p(*
r p(*
rU! p(*
r " p(*
r# p(*
s~
r p|
(
o
r p{
o
r
p|
(
o
r p{
o
rJ p{
o
rf p{
o
r p{
o
r p|
(c
o
r p{
o
r p|
(c
o
r p|
(c
o
r p|!
(c
o
r p|"
(
o
r p|#
(
o
rP p|%
(
o
r( p|$
(
o
rx p{&
o
r p{'
o
r p{(
o
r p{)
o
r p{*
o
r" p{+
o
(X
o
@ o
& ** A " 2 (B
*V(
o
(
! * 0i . }+ s
}" ~! r($ p(*
o+
{+ s
}* {* o
rn$ p{* s
s
}# r$ p{* s
s
}$ r$ p{* s
s
}% r$ p{* s
s
}& r4% p{* s
s
}' rZ% p{* s
s
}( r% p{* s
s
}) (
o
{* r% ps
o
{" (
{" o
(o o
{# {* ( {# {" o
r% po
o
&{" o
(p o
{$ {* ( {" o
(q o
{% {* ( {% {" o
r& po
o
&{" o
(n o
{& {* ( {" o
(r o
{' {* ( {" o
(s o
{( {* ( {" o
(t o
{) {* ( {$ {" o
r& po
o
& &~! r.& po+
{& {" o
r& po
o
& &~! r& po+
{' {" o
r' po
o
& &~! r' po+
{( {" o
rh' po
o
& &~! r' po+
{) {" o
r' po
o
& &~! r( po+
(!
*A & 2 O & u 2 & : 2 & 2 & 2 K 0 {* 9 {* o
}* {" 9 {" o
}" {# 9 {# o
}# {$ 9 {$ o
}$ {% 9 {% o
}% {& 9 {& o
}& {' 9 {' o
}' {( 9 {( o
}( {) 9 {) o
}) * 0 | {"
(
{" o
r' po
o
o,
(
o
: o
( o
o
8 ( (k (!
*A
g t 0 / {"
(
{" o
r' po
r( p(
r. p(P
o
i:4 s-
o.
%_ s/
o0
o_ 8 (x %_ s/
o0
(!
* A
0 0 {"
(
o1
o2
o3
8 (4
o5
@_:` o5
_:O ~! %r( p%o6
%r( p% (
o+
o6
( 8 o7
9 8 (8
:k (9
(!
(k *A4
0! 1 ~! r( p{:
X o;
{" o
r% po
{" o
r& po
%rL) p% %rn) p% %r. p(
{"
(
o
8V r po
t
(.
o
(
o
9 o
(c o
Xi? (!
(k * A { 0 X 2 {" o
r& po
r) p (<
o
8
o
Xi?*0R 3 s=
s>
{" o
r% po
{" o
r& po
r) p r. p(
{" (
o
~! %r) p%i %r) p% (
o+
8
r po
t
r&* po
t
(
9 s?
(u
o
o@
(
o
9
( oA
8 ~! r@* po+
(B
oA
oC
o6
oD
oE
(e ݮ ~! r* poF
~! r~+ po
(*
o+
o
o
8I o
t4 ~! %r+ p%o
%r+ p%oG
(
o+
o
: u %-o
X i?r8p r po
t
r&* po
t
(
9y (u o
o@
(
o
9 ( oA
8 ~! r@* po
(B
oA
s.
oH
oI
(e ݮ ~! r+ poF
~! r~+ po
(*
o+
o
o
8I o
t4 ~! %r+ p%o
%r+ p%oG
(
o+
o
: u %-o
Xi? (!
* A| = _ O 2 _ } 2 ^ j 0 4 {" o
r& po
r) po@
(
(<
o
sJ
8 (v oK
Xi?oL
oM
* 0* & 5 {"
(
(N
rc, p{* s
o
r, p(
s
o
&o
r- p s
o
&o)
&
9 o
~! r&- p(O
(*
o+
rv- p
{* s
o
r, p(
s
o
&o
r- p s
o
&o
r?. p(z s
o
&o)
& 9 o
(!
* AL e
$ E i
0( X 6 {"
(
sP
oQ
rY. p {* s
o
r, p(
s
o
& o
o
9 r./ po-
t sR
sS
81 8 oT
(U
X ?X ?rF/ po-
y J8 ~! rX/ po+
U ~! r/ p(O
(*
o+
9 o
9 o
(!
*AL [ 6 4
A N 0 7 {"
(
r/ p{* s
o
r p(
s
o
&o)
&
9 o
r<0 p{* s
o
r p(
s
o
&o)
&
9 o
(!
*AL e )
) G
0K i 8 {"
(
{" o
r' po
{" o
rh' po
o
oV
oW
(
o
:* o
oV
oX
(} o
o
8 oV
oX
(} r0 p{* s
o
r1 poV
oW
(
s
o
&o)
& 9 o
oV
oY
oZ
82 ([
o
oV
oW
(~ o
o
(\
: (]
(!
(k * AL H N 8
N [ 0 9 s^
{" (
{" o
r' po
{" o
rh' po
r) p r. p(
o
8} (w r1 p oW
r. p(
o
8
oY
(y o_
X
i? o`
Xi?x (!
* A 0 : {"
(
{# {" r% po
&{$ {" r& po
&{% {" r& po
&{& {" r& po
&{' {" r' po
&{( {" rh' po
&{) {" r' po
&{" o
(!
* A
(k *0 ; s
o
o
* 0 L % r& ps
r21 p
(F
(m rF/ p (F
(m r./ p (F
(m *0 % r% ps
r p
(F
(m r21 p
(F
(m rH1 p (F
(m r p
(F
(m r&* p
(F
(m rb1 p
(F
(m rl1 p (F
(m rz1 p (F
(m r1 p (F
(m r1 p (F
(m r p
(F
(m r1 p
(F
(m r1 p
(F
(m r1 p (F
(m r1 p
(F
(m r1 p
(F
(m r2 p
(F
(m r2 p
(F
(m r,2 p (F
(m r@2 p (F
(m r\2 p (F
(m rp2 p (F
(m r2 p (F
(m r2 p< (F
(m r2 p< (F
(m r2 p< (F
(m r2 p< (F
(m r2 p< (F
(m r3 p< (F
(m r23 p< (F
(m rF3 p< (F
(m rZ3 p< (F
(m rn3 p< (F
(m r3 p< (F
(m r3 p< (F
(m r3 p< (F
(m r3 p< (F
(m r 4 p< (F
(m r(4 p< (F
(m r<4 p< (F
(m rP4 p< (F
(m rd4 p< (F
(m rx4 p< (F
(m r4 p< (F
(m r4 p< (F
(m r4 p< (F
(m r 5 p< (F
(m r"5 p< (F
(m rD5 p< (F
(m rf5 p (F
(m rx5 p (F
(m r5 p (F
(m r5 p (F
(m r5 p (F
(m r5 p
(F
(m r5 p< (F
(m r6 p
(F
(m r*6 p
(F
(m rH6 p< (F
(m rV6 p< (F
(m rd6 p< (F
(m rr6 p< (F
(m r6 p< (F
(m r6 p< (F
(m r6 p< (F
(m r6 p< (F
(m r7 p< (F
(m r87 pI (F
(m rV7 p (F
(m rv7 pI (F
(m r7 pI (F
(m r7 p (F
(m r7 pI (F
(m r7 p (F
(m r7 p (F
(m r7 p
(F
(m r8 p< (F
(m r:8 pI (F
(m 4 %o
r po
o
* 0? c % r& ps
r p
(F
(m rT8 p (F
(m r`8 p< (F
(m rn8 p< (F
(m r|8 p< (F
(m r8 p (F
(m r8 p (F
(m r8 p (F
(m r8 p (F
(m r8 p (F
(m r8 p (F
(m r8 p (F
(m r9 p (F
(m r$9 p (F
(m r89 p (F
(m rZ9 p (F
(m rz9 p (F
(m r9 p (F
(m r9 p (F
(m r9 p (F
(m r9 p (F
(m r9 p (F
(m r: p (F
(m r": p (F
(m r>: p (F
(m rJ: p (F
(m rZ: p (F
(m 4 %o
r po
o
* 0/ % r& ps
rr: p
(F
(m r: p
(F
(m r p
(F
(m rH p
(F
(m r8 p (F
(m r$ p (F
(m r p
(F
(m r: p
(F
(m r p; (F
(m r: p
(F
(m r: p
(F
(m r: p
(F
(m r p
(F
(m r: p* (F
(m r; p* (F
(m r(; p* (F
(m rH; p* (F
(m rp; p* (F
(m rP p* (F
(m 4 %o
rr: po
o
* 0M % r' ps
r p
(F
(m r21 p
(F
(m r; p* (F
(m r; p (F
(m r p
(F
(m r; p
(F
(m r; p
(F
(m r; p (F
(m r; p (F
(m r; p (F
(m r< p (F
(m r < p (F
(m r4< p (F
(m rJ< p
(F
(m r7 p (F
(m r^< p (F
(m rt< p* (F
(m r< p (F
(m r< p (F
(m r< p
(F
(m r< p
(F
(m r< p
(F
(m r= p< (F
(m r= p* (F
(m r,= p
(F
(m rF= p< (F
(m rb= p< (F
(m r~= p< (F
(m r= p< (F
(m r= p< (F
(m r= p< (F
(m r= p
(F
(m r= p (F
(m r> p (F
(m 4 %o
r po
o
* 0 L % rh' ps
r$> p
(F
(m r6> p
(F
(m rD p* (F
(m *0S 5 % r' ps
rL> p
(F
(m rb> p (F
(m r> p (F
(m r> p (F
(m r> p (F
(m r> p (F
(m r> p (F
(m r$? p (F
(m rN? p (F
(m rf? p< (F
(m r? p (F
(m r? p (F
(m r? p (F
(m r? p (F
(m r? p
(F
(m r @ p
(F
(m r@@ p
(F
(m rd@ p
(F
(m r@ p< (F
(m r@ p< (F
(m r@ p< (F
(m r@ p< (F
(m r A p< (F
(m r A p< (F
(m r po
o
* 05 < sa
r po
t
s.
ob
rH1 po
(V
oc
r po
t
od
rb1 po
t
oe
r1 po
(V
rl1 po
(V
rz1 po
(V
r1 po
(V
(f
og
r po
t
oh
r1 po
t
oi
r1 po
t
oj
r1 po
(`
ok
r1 po
t
s.
ol
r1 po
t
s.
om
r2 po
t
s.
on
r2 po
t
s.
oo
r,2 po
(`
op
r@2 po
(`
oq
r\2 po
(`
or
rp2 po
(`
os
r2 po
(`
ot
r2 po
(u
r2 po
(u
r2 po
(u
sv
ow
r2 po
(u
r2 po
(u
r3 po
(u
sv
ox
r23 po
(u
rF3 po
(u
rZ3 po
(u
sv
oy
rn3 po
(u
r3 po
(u
r3 po
(u
sv
oz
r3 po
(u
r3 po
(u
r 4 po
(u
sv
o{
r(4 po
(u
r<4 po
(u
rP4 po
(u
rd4 po
(u
s|
o}
rx4 po
(u
r4 po
(u
r4 po
(u
sv
o~
r 5 po
(u
r"5 po
(u
rD5 po
(u
r4 po
(u
s|
o
r7 po
(
o
{
rf5 po
(V
{
rx5 po
(V
{
r5 po
(V
{
r5 po
(V
{
r5 po
(V
r5 po
oY
s.
}
r5 po
(u
l}
}
r6 po
: r6 po
oY
(
o
r*6 po
: r*6 po
oY
(
o
rH6 po
(u
rV6 po
(u
rd6 po
(u
sv
o
rr6 po
(u
r6 po
(u
r6 po
(u
sv
o
r6 po
(u
r6 po
(u
r7 po
(u
sv
o
r87 po
(
9 o
rV7 po
(V
o
rv7 po
(
9 }
r7 po
(
9 }
r7 po
(V
o
r7 po
(
o
r7 po
(
o
r7 po
oY
s.
o
r8 po
(u
o
r:8 po
(
9 }
* 0V = s
rr: po
t
s.
o
r: po
t
s.
o
r po
t
s.
o
rH po
t
s.
o
r8 po
(V
o
r$ po
(V
o
r po
t
o
r: po
t
o
r po
(`
o
r: po
t
s.
o
r: po
t
s.
o
r: po
t
s.
o
r po
t
s.
o
r: po
(`
o
r; po
(`
o
r(; po
(`
o
rH; po
(`
o
rp; po
(`
o
rP po
(`
o
* 0 7 > s
r po
t
s.
o
r; po
(V
o
r; po
t o
r po
t
o
r; po
t
o
r; po
t
(
o
r; po
y Fo
r; po
(V
o
r; po
(`
o
r< po
(V
go
r < po
(V
o
r4< po
(V
o
rJ< po
t
s.
o
r7 po
(V
o
r^< po
(V
go
rt< po
(`
o
r< po
y Go
r< po
y Go
r< po
t
s.
o
r< po
t
o
r< po
t
o
r= po
(u
o
r= po
(V
o
r,= po
t
(
o
rF= po
(u
rb= po
(u
r~= po
(u
sv
o
r= po
(u
r= po
(u
r= po
(u
sv
o
1 &~! rB po
o
~
o
~
o
s
o
~X
r= po
t
(Z
&r= po
(V
o
r> po
(V
o
* A 4 { 1 0 M ? s-
rL> po
t
s.
o.
rb> po
(4
o
r> po
(4
o
r> po
(4
o
r> po
(4
o
r> po
(4
o
r> po
(4
o
r$? po
(4
o
rN? po
(V
o
rf? po
(
o
r? po
(V
o
r? po
(4
o
r? po
(4
o
r? po
(4
o
r? po
t
s.
o
r @ po
t
s.
o
r@@ po
t
s.
o
rd@ po
t
s.
o
r@ po
(
o
r@ po
(
o
r@ po
(
o
r@ po
(
o
r A po
(
o
r A po
(
o
r po
t
s.
}
rD po
y* K}
l }
* 0 S A s
s
8(
8 (
o
X
?X ?o
* 0K B r po@
(
o
r21 p(
o
rH1 po
o
r po
o
r&* p(
o
rb1 po
o
r po
o
r1 po
o
r1 po
o
r1 po
* o
r1 po
(
o
r1 po
(
o
r2 po
(
o
r2 po
(
o
r,2 po
* o
r@2 po
* o
r\2 po
* o
rp2 po
* o
r2 po
* o
r2 po
{
n o
r2 po
{
n o
r2 po
{
n o
r2 po
{
n o
r2 po
{
n o
r3 po
{
n o
r23 po
{
n o
rF3 po
{
n o
rZ3 po
{
n o
rn3 po
{
n o
r3 po
{
n o
r3 po
{
n o
r3 po
{
n o
r3 po
{
n o
r 4 po
{
n o
r(4 po
{
n o
r<4 po
{
n o
rP4 po
{
n o
rd4 po
{
n o
o
rx4 p {
n o
r4 p {
n o
r4 p {
n o
o
r4 p{
n o
r 5 p{
n o
r"5 p{
n o
rD5 p{
n o
rl1 po
(
(
o
rz1 po
(
(
o
r1 po
(
(
o
r1 po
(
(
o
rf5 p{
o
rx5 p{
o
r5 p{
o
r5 p{
o
r5 p{
o
r6 po
(
o
r*6 po
(
o
rH6 po
{
n o
rV6 po
{
n o
rd6 po
{
n o
rr6 po
!!{
n o
r6 po
""{
n o
r6 po
##{
n o
r6 po!
$${
n o
r6 po!
%%{
n o
r7 po!
&&{
n o
{
_91 r5 p|
(
o
r5 p{
< o
8. r5 p~X
''(
o
r5 p" n o
o"
9 r87 p o
8 r87 p o
rV7 po#
o
{
9 rv7 p o
8 rv7 p o
{
9 r7 p o
8 r7 p o
r7 po$
o
r7 po%
(&
I o
r7 po'
o
r7 po$
o
r7 po(
o
r7 po)
(((
o
r8 po*
n o
{
9 r:8 p o
8 r:8 p o
*0N rr: po+
o
r: po,
o
r po-
o
rH po.
o
r8 po/
o
r$ po0
o
r po1
o
r: po2
o
r po3
* o
r: po4
o
r: po5
o
r: po6
o
r po7
o
r: po8
* o
r; po9
* o
r(; po:
* o
rH; po;
* o
rp; po<
* o
rP po=
* o
* 0 C r poW
(
o
r21 p(
o
r; po>
o
r; po?
o
r po
o
r; po@
o
r; poA
(
o
r; poB
o
r; poC
o
r; poD
* o
r< poE
i o
r < poF
o
r4< poG
o
rJ< poH
(
o
r7 poI
o
r^< poJ
j o
rt< poK
* o
r< poL
o
r< poM
o
r< poN
(
o
r< poO
o
r< poP
o
r= poQ
n o
r= poR
o
r,= poS
(
o
rF= poT
{
n o
rb= poT
{
n o
r~= poT
{
n o
r= poU
{
n o
r= poU
{
n o
r= poU
{
n o
r= poV
(
o
r= poW
o
r> poX
o
* 0 A r$> p(
o
r6> p|
(
o
rD p{
k o
* 0 ^ D rL> po,
(
o
rb> poY
o
r> poZ
o
r> po[
o
r> po\
o
r> po]
o
r> po^
o
r$? po_
o
rN? po`
o
rf? poa
< o
r? pob
o
r? poc
o
r? pod
o
r? poe
o
r? pof
(
o
r @ pog
(
o
r@@ poh
(
o
rd@ poi
(
o
r@ poj
< o
r@ pok
< o
r@ pol
< o
r@ pom
< o
r A pon
< o
r A poo
< o
r: po
(
o
rJ: po
t o
rZ: po
t o
* 0p g F o
r po@
(
o
rT8 p o
r`8 po
{
n o
rn8 po
{
n o
r|8 po
{
n o
r8 po
o
r8 po
J o
r8 po
J o
r8 po
o
r8 po
o
r8 po
o
r8 po
o
r9 po
o
r$9 po
o
r89 po
o
rZ9 po
o
rz9 po
o
r9 po
o
r9 po
o
r9 po
o
r9 po
J o
r9 po
J o
r: po
o
r": po
J o
r>: po
o
rJ: po
o
rZ: po
o
* 0* G {" o
r% po
{" o
r& po
o
o@
(
o
:! o
({ o
o
8 ({ o
o@
(
o
: o
( o
o
8 ( * 0 H ~! rC p o
{" o
r& po
{" (
(c o
8$ o
o
(| o
o
o
: u %-o
(!
(k * A4 F 9 8 \ 0) I o
o
8 o
o
o
X o
o
?r
pr~ p(P
r
p(O
(*
r p(*
r p(O
(*
r% p(*
s
o
o
8. o
t4 o
o
o
( o
&o
: u %-o
* A D 0) J r pr p(P
~
o
o
8< o
t4 o
> r
p(*
o
r po
(
o
: u %-o
(*
r p(P
s
o
o
8. o
t4 o
o
o
( o
&o
: u %-o
* A4 D # Q t 0 7 K s
r) p(*
o
( o
o
o
* 0! r% p{" o
r% po
( o
o
o
r% pr p{" o
r% po
( o
o
o
rtC ps
o
r p
(F
( o
&o
o
* 0! r& p{" o
r& po
( o
o
o
r& prC p{" o
r& po
( o
o
o
rC ps
o
rr: p
(F
( o
&o
o
* 0 2 r& p{" o
r& po
( o
o
o
* 0 h r' p{" o
r' po
( o
o
o
r' pr p{" o
r' po
( o
o
o
*0 2 rh' p{" o
rh' po
( o
o
o
* 0 h r' p{" o
r' po
( o
o
o
r' pr:D p{" o
r' po
( o
o
o
*0! r& p{" o
r& po
( o
o
o
r& pr p{" o
r& po
( o
o
o
rhD ps
o
r p
(F
( o
&o
o
* 0
q
(F
@ * (F
@ *< (F
@ * (F
@ *< (F
@ * (F
@ * * (
*V(
o
(
5 * 0 + ~5 rD po r p(P
o+
o s}
z 0@ L ~
(
9 rE ps
}; {; o
(
o
{; rHE ps
o
s
}6 r\E ps
s
}7 rE ps
s
}9 rE ps
s
}8 r?G ps
s
}: {6
(
{6 o
( o
{6 o
( o
{6 o
( o
{6 o
( o
{7 ( {7 {6 o
r}G po
o
&{9 ( {9 {6 o
rG po
o
&{8 ( {8 {6 o
rG po
o
&{: ( {: {6 o
rG po
o
& (!
* A 0 {; 9 {; o
}; {6 9 {6 o
}6 {7 9 {7 o
}7 {8 9 {8 o
}8 {9 9 {9 o
}9 {: 9 {: o
}: * 0 ] M {6
(
{6 o
r}G po
o
(
o
9 (
(!
* A
G T 0 N
%rG p%%rG p%%r. p(^
{6 (
{6 o
r}G po
o
i> (
(!
* A 9 C | 0 O rH p
{; s
o
rI p(
s
o
&o
rI p(
s
o
&o
o
9 o
_ o
Q
9 o
(
~5 r,I p o
(*
oF
9 o
* AL T ,
M E ( 2
0*
P ( 9 *rI p
{; s
o
rI p(
s
o
&o
rI p(
s
o
&o
rOJ p* s
o
&o)
&
9 o
{; s
o
rI p(
s
o
&o
rI p(
s
o
&o
rOJ p* s
o
&o)
&
9 o
* A4 b
! b
0 g Q r]J p
{; s
o
rI p(
s
o
&o
rI p(
s
o
&o)
&
9 o
* A F Y
0 Q rHK p
{; s
o
rOJ p* s
o
&o
rI p(
s
o
&o
rI p(
s
o
&o)
&
9 o
* A b u
0 R s
rK p{; s
o
rI p(
s
o
&o
8O s
}
o
t
s.
}
o
(`
}
o
(`
}
o
o
:o
9 o
" ~5 r,I po
(*
oF
9 o
* AL ; j
4 " 2
0 S s
{6 o
rG po
o
8 (
{6 (
o
(
o
:
o
8A s
r@M po
y F}
rXM po
(
}
o
(!
(
:g (
*A4 ? n # 0; ! T s
s % o
i@ rtM p{; s
o
r
N pr p(*
s
o
&o
r!N pr p(*
s
o
&o
8Y s
r po-
t
s.
}
r3N po-
t
}
rEN po-
t
}
o
o
: o
9 o
9 o
8 i@ rUN p{; s
o
r
N pr p(*
s
o
&o
r!N pr p(*
s
o
&o
8\ s
r po-
t
s.
}
r3N po-
t
}
rEN po-
t
}
o
o
:o
9 o
9 o
* Ad y 2 t
2
0 [ U {6
(
{6 o
rG po
o
(
o
9 ( (!
* A
E R 0 - s % o
s % o
o * 0 V
o 9
o
o
*0 W {6 o
r}G po
{6 (
o
(
o
: ~5 rN po
8. o
o
( {7 {6 r}G po
& (!
* A # ` 0 O rsO p
{; s
o
r
N ps
o
&o
r!N ps
o
&o
o
9 o
_ o
Q
9 o
(
~5 rO p o
(*
oF
9 o
* AL H , t
A E ( 2
01 X {6 o
r}G po
~X
o
o
( : o
(
9 *{6 (
o
o
(
o
:t o
( o
o
~5 r|P p{6 o
r}G po
o
o
rP p(
o
{7 {6 r}G po
&8 ~5 rP po
o
(!
* A R 0 { Y {6 o
r}G po
{6 (
o
o
(
o
: - ( {7 {6 r}G po
& (!
** A # L o 0* Z ~X
o
(
: o
(
9 *{6 o
rG po
{6 (
o
o
(
o
: o
( o
o
8 ( ~5 rZQ p{6 o
rG po
o
o
rQ p(
o+
{9 {6 rG po
& (!
*A L
*
* 0 [ ~5 rQ p(
(*
o+
s
o
{6 o
rG po
{6 (
o
(
o
: ~5 rR p(
(*
o+
8f ~5 r`R p(
o
rR po
t
s.
o
rR po
t
s.
o
rR po
t
s.
o
rR po
t
s.
o
rR po
t
s.
o
r
S po
t
s.
o
r S po
t
s.
o
r0S po
t
s.
o
rDS po
t
s.
o
rXS po
t
s.
o
rnS po
t
s.
o
rS po
t
s.
o
rS po
t
s.
o
rS po
t
s.
o
rS po
t
s.
o
rS po
t
s.
o
rS po
t
s.
o
rT po
t
s.
o
rT po
t
s.
o
r0T po
t
s.
o
rHT po
t
s.
o
rfT po
t
s.
o
rT po
t
s.
o
rT po
t
s.
o
rT po
t
s.
o
rT po
t
s.
o
rJ: po
t
(
is
o
rT po
t
(
o
rU po
(V
o
rU po
(u
o
~5 r0U p(
o
(!
*A L 0& \ o
{6 o
rG po
{6 (
o
(
o
:S ~5 rxU p(
(*
o
o
( o
o
{: {6 rG po
&8; ~5 rU p(
(*
o
( {: {6 rG po
& (!
* A * rD p* r
p* 0G % r}G ps
r p
(F
( r3N p
(F
( rEN p
(F
( r V p
(F
( r(V p
(F
( rBV p
(F
( r\V p (F
( rtV p (F
( rV p
(F
( rV p< (F
( rV p< (F
( rV p< (F
( rV p< (F
( rW p< (F
( r*W p< (F
( rBW p (F
( rRW p (F
( rfW p
(F
( rW p
(F
( rW p
(F
( rW p (F
( rW p (F
( rX p
(F
( r6X p
(F
( rXX p
(F
( rrX p
(F
( rX p
(F
( rX p (F
( rX p (F
( rX p
(F
( rX p
(F
( 4 %o
r po
o
* 0% R % rG ps
r p
(F
( rX p
(F
( r
Y p (F
( r@M p (F
( r Y p
(F
( r2Y p
(F
( rRY p
(F
( rdY p (F
( rxY p (F
( rY p
(F
( rXM p
(F
( rY p< (F
( rY p< (F
( rY p< (F
( 4 %o
r po
o
* 0
v % rG ps
r: p
(F
( rY p
(F
( rZ p (F
( r Z p (F
( r2Z p (F
( * 0G % rG ps
rNZ p
(F
( rR p
(F
( rR p
(F
( rR p
(F
( rR p
(F
( rR p
(F
( r
S p
(F
( r S p
(F
( r0S p
(F
( rDS p
(F
( rXS p
(F
( rnS p
(F
( rS p
(F
( rS p
(F
( rS p
(F
( rS p
(F
( rS p
(F
( rS p
(F
( rT p
(F
( rT p
(F
( r0T p
(F
( rHT p
(F
( rfT p
(F
( rT p
(F
( rT p
(F
( rT p
(F
( rT p
(F
( rJ: p
(F
( rT p
(F
( rU p (F
( rU p< (F
( 4 %o
rNZ po
o
* 0 ] s
r po
t
(Z
&o
r3N po
t
o
rEN po
t
o
r V po
9
~
8 r V po
t
o
r(V po
t
o
rBV po
t
o
r\V po
(`
o
rtV po
(`
o
rV po
(u
rV po
(u
rV po
(u
sv
o
rV po
(u
rW po
(u
r*W po
(u
sv
o
~X
rV po
oY
(Z
&o
rBW po
(V
o
rRW po
(V
o
rfW po
t
s.
o
rW po
t
o
rW po
t
o
rW po
(`
o
rW po
(`
o
rX po
t
o
r6X po
t
o
rXX po
t
(Z
&o
rrX po
t
(Z
&o
rX po
t
s.
o
rX po
(V
o
rX po
(V
o
rX po
oY
o
rX po
t
s.
o
* 0 3 ^ r po
(
o
r3N po
o
rEN po
o
r V po
o
r(V po
o
rBV po
o
r\V po
* o
rtV po
* o
rV po
o
rV po
{
n o
rV po
{
n o
rV po
{
n o
rV po
{
n o
rW po
{
n o
r*W po
{
n o
rBW po
o
rRW po
o
rfW po
o
rW po
o
rW po
o
rW po
* o
rW po
* o
rX po
o
r6X po
o
rXX po
o
rrX po
o
rX po
o
rX po!
o
rX po"
o
rX po#
:
~
8 o#
o
rX po$
(
o
{6 o
r}G po
o
o
8$ o
t4
oG
: ~
o%
o
: u %-o
* A 9 " 0 z _ rNZ p(
o
rR po&
(
o
rR po'
(
o
rR po(
(
o
rR po)
(
o
rR po*
(
o
r
S po+
(
o
r S po,
(
o
r0S po-
(
o
rDS po.
(
o
rXS po/
(
o
rnS po0
(
o
rS po1
(
o
rS po2
(
o
rS po3
(
o
rS po4
(
o
rS po5
(
o
rS po6
(
o
rT po7
(
o
rT po8
(
o
r0T po9
(
o
rHT po:
(
o
rfT po;
(
o
rT po<
(
o
rT po=
(
o
rT po>
(
o
rT po?
(
o
rJ: po@
oA
(
o
rT poB
(
o
rU poC
o
rU poD
n o
{6 o
rG po
o
o
8$ o
t4
oG
: ~
o%
o
: u %-o
* A 0 9 i 0K ` sE
r po
t
(Z
&oF
rX po
t
oG
r
Y po
(`
oH
r@M po
(4
oI
r Y po
t
s.
oJ
r2Y po
t
s.
oK
rRY po
t
s.
oL
rdY po
(V
oM
rxY po
(V
oN
rY po
t
s.
oO
rXM po
(
oP
rY po
(u
rY po
(u
rY po
(u
sv
oQ
rZZ po
(u
rxZ po
(u
rZ po
(u
sv
oR
* 0J a r po
(
o
rX poS
o
r
Y poT
* o
r@M poU
o
r Y po
o
r2Y poV
o
rRY poW
o
rdY poX
o
rxY poY
o
rY poZ
o
rXM po[
(
o
rY po\
{
n o
rY po\
{
n o
rY po\
{
n o
rZZ po]
{
n o
rxZ po]
{
n o
rZ po]
{
n o
*0! r}G p{6 o
r}G po
( o
o
o
r}G pr p{6 o
r}G po
( o
o
o
rZ ps
o
r p
(F
( o
&o
o
* 0! rG p{6 o
rG po
( o
o
o
rG pr p{6 o
rG po
( o
o
o
rZ ps
o
r\[ p
(F
( o
&o
o
* 0' rG p{6 o
rG po
( o
o
o
rG prp[ p{6 o
rG po
( o
o
o
r[ ps
o
r: p
(F
( o
&o
rY p
(F
( o
&o
o
* 0! rG p{6 o
rG po
( o
o
o
rG prM\ p{6 o
rG po
( o
o
o
rg\ ps
o
rNZ p
(F
( o
&o
o
* * * (B
*0 ; s
o
o
* 0) I o
o
8 o
o
o
X o
o
?r
pr~ p(P
r
p(O
(*
r p(*
r p(O
(*
r% p(*
s
o
o
8. o
t4 o
o
o
( o
&o
: u %-o
* A D 0) J r pr p(P
~
o
o
8< o
t4 o
> r
p(*
o
r po
(
o
: u %-o
(*
r p(P
s
o
o
8. o
t4 o
o
o
( o
&o
: u %-o
* A4 D # Q t 0 b r po
r~ p(P
~
o
o
8i o
t4 o
> r p(*
o
r po
( (
o
i> o
@ r p(*
o
: u %-o
(*
r% p(*
*A ( ~ 0 7 K s
r) p(*
o
( o
o
o
* 0
(F
@ * (F
@ ** (F
@ *; (F
@ */ (F
@ *< (F
@ * (F
@ * (F
@ * *0
(F
@ r p* (F
@ r( p** (F
@ r( p*; (F
@ r p*/ (F
@ r p*< (F
@ r8 p* (F
@ r( p* (F
@ rD p*rN p* - BEGIN;
delete from regionsettings;
COMMIT;
BEGIN;
create table regionsettings (
regionUUID char(36) not null,
block_terraform integer not null,
block_fly integer not null,
allow_damage integer not null,
restrict_pushing integer not null,
allow_land_resell integer not null,
allow_land_join_divide integer not null,
block_show_in_search integer not null,
agent_limit integer not null,
object_bonus float not null,
maturity integer not null,
disable_scripts integer not null,
disable_collisions integer not null,
disable_physics integer not null,
terrain_texture_1 char(36) not null,
terrain_texture_2 char(36) not null,
terrain_texture_3 char(36) not null,
terrain_texture_4 char(36) not null,
elevation_1_nw float not null,
elevation_2_nw float not null,
elevation_1_ne float not null,
elevation_2_ne float not null,
elevation_1_se float not null,
elevation_2_se float not null,
elevation_1_sw float not null,
elevation_2_sw float not null,
water_height float not null,
terrain_raise_limit float not null,
terrain_lower_limit float not null,
use_estate_sun integer not null,
fixed_sun integer not null,
sun_position float not null,
covenant char(36));
COMMIT;
BEGIN;
update users
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update useragents
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
COMMIT;
BEGIN;
ALTER TABLE prims ADD COLUMN PayPrice INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN PayButton1 INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN PayButton2 INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN PayButton3 INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN PayButton4 INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN LoopedSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
ALTER TABLE prims ADD COLUMN LoopedSoundGain float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN TextureAnimation string;
ALTER TABLE prims ADD COLUMN ParticleSystem string;
ALTER TABLE prims ADD COLUMN OmegaX float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN OmegaY float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN OmegaZ float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraAtOffsetX float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraAtOffsetY float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float NOT NULL default 0;
ALTER TABLE prims ADD COLUMN ForceMouselook string NOT NULL default 0;
ALTER TABLE prims ADD COLUMN ScriptAccessPin INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN AllowedDrop INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN DieAtEdge string NOT NULL default 0;
ALTER TABLE prims ADD COLUMN SalePrice INTEGER NOT NULL default 0;
ALTER TABLE prims ADD COLUMN SaleType string NOT NULL default 0;
COMMIT; BEGIN;
CREATE TEMPORARY TABLE prims_backup(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect);
INSERT INTO prims_backup SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims;
DROP TABLE prims;
CREATE TABLE prims(UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect);
INSERT INTO prims SELECT UUID,RegionUUID,CreationDate,Name,SceneGroupID,Text,Description,SitName,TouchName,CreatorID,OwnerID,GroupID,LastOwnerID,OwnerMask,NextOwnerMask,GroupMask,EveryoneMask,BaseMask,PositionX,PositionY,PositionZ,GroupPositionX,GroupPositionY,GroupPositionZ,VelocityX,VelocityY,VelocityZ,AngularVelocityX,AngularVelocityY,AngularVelocityZ,AccelerationX,AccelerationY,AccelerationZ,RotationX,RotationY,RotationZ,RotationW,ObjectFlags,SitTargetOffsetX,SitTargetOffsetY,SitTargetOffsetZ,SitTargetOrientW,SitTargetOrientX,SitTargetOrientY,SitTargetOrientZ,ColorR,ColorG,ColorB,ColorA,ClickAction,PayPrice,PayButton1,PayButton2,PayButton3,PayButton4,LoopedSound,LoopedSoundGain,TextureAnimation,ParticleSystem,OmegaX,OmegaY,OmegaZ,CameraEyeOffsetX,CameraEyeOffsetY,CameraEyeOffsetZ,CameraAtOffsetX,CameraAtOffsetY,CameraAtOffsetZ,ForceMouselook,ScriptAccessPin,AllowedDrop,DieAtEdge,SalePrice,SaleType,Material,CollisionSound,CollisionSoundVolume,VolumeDetect FROM prims_backup;
DROP TABLE prims_backup;
COMMIT;: BEGIN;
CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `attachpoint` int(11) NOT NULL DEFAULT 0, `item` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `asset` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000');
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS avatarappearance(
Owner varchar(36) NOT NULL primary key,
BodyItem varchar(36) DEFAULT NULL,
BodyAsset varchar(36) DEFAULT NULL,
SkinItem varchar(36) DEFAULT NULL,
SkinAsset varchar(36) DEFAULT NULL,
HairItem varchar(36) DEFAULT NULL,
HairAsset varchar(36) DEFAULT NULL,
EyesItem varchar(36) DEFAULT NULL,
EyesAsset varchar(36) DEFAULT NULL,
ShirtItem varchar(36) DEFAULT NULL,
ShirtAsset varchar(36) DEFAULT NULL,
PantsItem varchar(36) DEFAULT NULL,
PantsAsset varchar(36) DEFAULT NULL,
ShoesItem varchar(36) DEFAULT NULL,
ShoesAsset varchar(36) DEFAULT NULL,
SocksItem varchar(36) DEFAULT NULL,
SocksAsset varchar(36) DEFAULT NULL,
JacketItem varchar(36) DEFAULT NULL,
JacketAsset varchar(36) DEFAULT NULL,
GlovesItem varchar(36) DEFAULT NULL,
GlovesAsset varchar(36) DEFAULT NULL,
UnderShirtItem varchar(36) DEFAULT NULL,
UnderShirtAsset varchar(36) DEFAULT NULL,
UnderPantsItem varchar(36) DEFAULT NULL,
UnderPantsAsset varchar(36) DEFAULT NULL,
SkirtItem varchar(36) DEFAULT NULL,
SkirtAsset varchar(36) DEFAULT NULL,
Texture blob,
VisualParams blob,
Serial int DEFAULT NULL,
AvatarHeight float DEFAULT NULL
);
COMMIT;
BEGIN TRANSACTION;
ALTER TABLE useragents add currentLookAtX float not null default 128;
ALTER TABLE useragents add currentLookAtY float not null default 128;
ALTER TABLE useragents add currentLookAtZ float not null default 70;
COMMIT;
C BEGIN TRANSACTION;
-- users table
CREATE TABLE users(
UUID varchar(255) primary key,
username varchar(255),
surname varchar(255),
passwordHash varchar(255),
passwordSalt varchar(255),
homeRegionX integer,
homeRegionY integer,
homeLocationX float,
homeLocationY float,
homeLocationZ float,
homeLookAtX float,
homeLookAtY float,
homeLookAtZ float,
created integer,
lastLogin integer,
rootInventoryFolderID varchar(255),
userInventoryURI varchar(255),
userAssetURI varchar(255),
profileCanDoMask integer,
profileWantDoMask integer,
profileAboutText varchar(255),
profileFirstText varchar(255),
profileImage varchar(255),
profileFirstImage varchar(255),
webLoginKey text default '00000000-0000-0000-0000-000000000000');
-- friends table
CREATE TABLE userfriends(
ownerID varchar(255),
friendID varchar(255),
friendPerms integer,
ownerPerms integer,
datetimestamp integer);
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE inventoryfolders(
UUID varchar(255) primary key,
name varchar(255),
agentID varchar(255),
parentID varchar(255),
type integer,
version integer);
CREATE TABLE inventoryitems(
UUID varchar(255) primary key,
assetID varchar(255),
assetType integer,
invType integer,
parentFolderID varchar(255),
avatarID varchar(255),
creatorsID varchar(255),
inventoryName varchar(255),
inventoryDescription varchar(255),
inventoryNextPermissions integer,
inventoryCurrentPermissions integer,
inventoryBasePermissions integer,
inventoryEveryOnePermissions integer,
salePrice integer default 99,
saleType integer default 0,
creationDate integer default 2000,
groupID varchar(255) default '00000000-0000-0000-0000-000000000000',
groupOwned integer default 0,
flags integer default 0);
COMMIT;
L BEGIN;
ALTER TABLE primitems add flags integer not null default 0;
COMMIT; BEGIN;
ALTER TABLE users add userFlags integer NOT NULL default 0;
ALTER TABLE users add godLevel integer NOT NULL default 0;
COMMIT;
V BEGIN;
ALTER TABLE prims ADD COLUMN ClickAction INTEGER NOT NULL default 0;
COMMIT;
C DELETE FROM assets WHERE UUID = 'dc4b9f0bd00845c696a401dd947ac621'
l BEGIN;
update terrain
set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
where RegionUUID not like '%-%';
update landaccesslist
set LandUUID = substr(LandUUID, 1, 8) || "-" || substr(LandUUID, 9, 4) || "-" || substr(LandUUID, 13, 4) || "-" || substr(LandUUID, 17, 4) || "-" || substr(LandUUID, 21, 12)
where LandUUID not like '%-%';
update landaccesslist
set AccessUUID = substr(AccessUUID, 1, 8) || "-" || substr(AccessUUID, 9, 4) || "-" || substr(AccessUUID, 13, 4) || "-" || substr(AccessUUID, 17, 4) || "-" || substr(AccessUUID, 21, 12)
where AccessUUID not like '%-%';
update prims
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update prims
set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
where RegionUUID not like '%-%';
update prims
set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12)
where SceneGroupID not like '%-%';
update prims
set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12)
where CreatorID not like '%-%';
update prims
set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12)
where OwnerID not like '%-%';
update prims
set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12)
where GroupID not like '%-%';
update prims
set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12)
where LastOwnerID not like '%-%';
update primshapes
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update land
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update land
set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
where RegionUUID not like '%-%';
update land
set OwnerUUID = substr(OwnerUUID, 1, 8) || "-" || substr(OwnerUUID, 9, 4) || "-" || substr(OwnerUUID, 13, 4) || "-" || substr(OwnerUUID, 17, 4) || "-" || substr(OwnerUUID, 21, 12)
where OwnerUUID not like '%-%';
update land
set GroupUUID = substr(GroupUUID, 1, 8) || "-" || substr(GroupUUID, 9, 4) || "-" || substr(GroupUUID, 13, 4) || "-" || substr(GroupUUID, 17, 4) || "-" || substr(GroupUUID, 21, 12)
where GroupUUID not like '%-%';
update land
set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) || "-" || substr(MediaTextureUUID, 9, 4) || "-" || substr(MediaTextureUUID, 13, 4) || "-" || substr(MediaTextureUUID, 17, 4) || "-" || substr(MediaTextureUUID, 21, 12)
where MediaTextureUUID not like '%-%';
update land
set SnapshotUUID = substr(SnapshotUUID, 1, 8) || "-" || substr(SnapshotUUID, 9, 4) || "-" || substr(SnapshotUUID, 13, 4) || "-" || substr(SnapshotUUID, 17, 4) || "-" || substr(SnapshotUUID, 21, 12)
where SnapshotUUID not like '%-%';
update land
set AuthbuyerID = substr(AuthbuyerID, 1, 8) || "-" || substr(AuthbuyerID, 9, 4) || "-" || substr(AuthbuyerID, 13, 4) || "-" || substr(AuthbuyerID, 17, 4) || "-" || substr(AuthbuyerID, 21, 12)
where AuthbuyerID not like '%-%';
COMMIT;6 BEGIN TRANSACTION;
create index inventoryfolders_agentid on inventoryfolders(agentid);
create index inventoryfolders_parentid on inventoryfolders(parentid);
create index inventoryitems_parentfolderid on inventoryitems(parentfolderid);
create index inventoryitems_avatarid on inventoryitems(avatarid);
COMMIT; BEGIN;
ALTER TABLE prims ADD COLUMN ColorR integer not null default 0;
ALTER TABLE prims ADD COLUMN ColorG integer not null default 0;
ALTER TABLE prims ADD COLUMN ColorB integer not null default 0;
ALTER TABLE prims ADD COLUMN ColorA integer not null default 0;
COMMIT;
S BEGIN;
ALTER TABLE prims ADD COLUMN Material INTEGER NOT NULL default 3;
COMMIT;
BEGIN;
update assets
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE prims(
UUID varchar(255) primary key,
RegionUUID varchar(255),
ParentID integer,
CreationDate integer,
Name varchar(255),
SceneGroupID varchar(255),
Text varchar(255),
Description varchar(255),
SitName varchar(255),
TouchName varchar(255),
CreatorID varchar(255),
OwnerID varchar(255),
GroupID varchar(255),
LastOwnerID varchar(255),
OwnerMask integer,
NextOwnerMask integer,
GroupMask integer,
EveryoneMask integer,
BaseMask integer,
PositionX float,
PositionY float,
PositionZ float,
GroupPositionX float,
GroupPositionY float,
GroupPositionZ float,
VelocityX float,
VelocityY float,
VelocityZ float,
AngularVelocityX float,
AngularVelocityY float,
AngularVelocityZ float,
AccelerationX float,
AccelerationY float,
AccelerationZ float,
RotationX float,
RotationY float,
RotationZ float,
RotationW float,
ObjectFlags integer,
SitTargetOffsetX float NOT NULL default 0,
SitTargetOffsetY float NOT NULL default 0,
SitTargetOffsetZ float NOT NULL default 0,
SitTargetOrientW float NOT NULL default 0,
SitTargetOrientX float NOT NULL default 0,
SitTargetOrientY float NOT NULL default 0,
SitTargetOrientZ float NOT NULL default 0);
CREATE TABLE primshapes(
UUID varchar(255) primary key,
Shape integer,
ScaleX float,
ScaleY float,
ScaleZ float,
PCode integer,
PathBegin integer,
PathEnd integer,
PathScaleX integer,
PathScaleY integer,
PathShearX integer,
PathShearY integer,
PathSkew integer,
PathCurve integer,
PathRadiusOffset integer,
PathRevolutions integer,
PathTaperX integer,
PathTaperY integer,
PathTwist integer,
PathTwistBegin integer,
ProfileBegin integer,
ProfileEnd integer,
ProfileCurve integer,
ProfileHollow integer,
Texture blob,
ExtraParams blob,
State Integer NOT NULL default 0);
CREATE TABLE primitems(
itemID varchar(255) primary key,
primID varchar(255),
assetID varchar(255),
parentFolderID varchar(255),
invType integer,
assetType integer,
name varchar(255),
description varchar(255),
creationDate integer,
creatorID varchar(255),
ownerID varchar(255),
lastOwnerID varchar(255),
groupID varchar(255),
nextPermissions string,
currentPermissions string,
basePermissions string,
everyonePermissions string,
groupPermissions string);
CREATE TABLE terrain(
RegionUUID varchar(255),
Revision integer,
Heightfield blob);
CREATE TABLE land(
UUID varchar(255) primary key,
RegionUUID varchar(255),
LocalLandID string,
Bitmap blob,
Name varchar(255),
Desc varchar(255),
OwnerUUID varchar(255),
IsGroupOwned string,
Area integer,
AuctionID integer,
Category integer,
ClaimDate integer,
ClaimPrice integer,
GroupUUID varchar(255),
SalePrice integer,
LandStatus integer,
LandFlags string,
LandingType string,
MediaAutoScale string,
MediaTextureUUID varchar(255),
MediaURL varchar(255),
MusicURL varchar(255),
PassHours float,
PassPrice string,
SnapshotUUID varchar(255),
UserLocationX float,
UserLocationY float,
UserLocationZ float,
UserLookAtX float,
UserLookAtY float,
UserLookAtZ float,
AuthbuyerID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000');
CREATE TABLE landaccesslist(
LandUUID varchar(255),
AccessUUID varchar(255),
Flags string);
COMMIT;
v BEGIN;
alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0;
COMMIT;
BEGIN TRANSACTION;
-- usersagents table
CREATE TABLE IF NOT EXISTS useragents(
UUID varchar(255) primary key,
agentIP varchar(255),
agentPort integer,
agentOnline boolean,
sessionID varchar(255),
secureSessionID varchar(255),
regionID varchar(255),
loginTime integer,
logoutTime integer,
currentRegion varchar(255),
currentHandle varchar(255),
currentPosX float,
currentPosY float,
currentPosZ float);
COMMIT;
begin;
alter table estate_settings add column AbuseEmail varchar(255) not null default '';
alter table estate_settings add column EstateOwner varchar(36) not null default '';
commit;
` begin;
alter table estate_settings add column DenyMinors tinyint not null default 0;
commit;
G BEGIN TRANSACTION;
ALTER TABLE users add email varchar(250);
COMMIT;
y BEGIN;
ALTER TABLE users add homeRegionID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
COMMIT;
BEGIN;
ALTER TABLE prims ADD COLUMN CollisionSound varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
ALTER TABLE prims ADD COLUMN CollisionSoundVolume float NOT NULL default 0;
COMMIT;
M BEGIN;
update inventoryitems
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update inventoryitems
set assetID = substr(assetID, 1, 8) || "-" || substr(assetID, 9, 4) || "-" || substr(assetID, 13, 4) || "-" || substr(assetID, 17, 4) || "-" || substr(assetID, 21, 12)
where assetID not like '%-%';
update inventoryitems
set parentFolderID = substr(parentFolderID, 1, 8) || "-" || substr(parentFolderID, 9, 4) || "-" || substr(parentFolderID, 13, 4) || "-" || substr(parentFolderID, 17, 4) || "-" || substr(parentFolderID, 21, 12)
where parentFolderID not like '%-%';
update inventoryitems
set avatarID = substr(avatarID, 1, 8) || "-" || substr(avatarID, 9, 4) || "-" || substr(avatarID, 13, 4) || "-" || substr(avatarID, 17, 4) || "-" || substr(avatarID, 21, 12)
where avatarID not like '%-%';
update inventoryitems
set creatorsID = substr(creatorsID, 1, 8) || "-" || substr(creatorsID, 9, 4) || "-" || substr(creatorsID, 13, 4) || "-" || substr(creatorsID, 17, 4) || "-" || substr(creatorsID, 21, 12)
where creatorsID not like '%-%';
update inventoryfolders
set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
where UUID not like '%-%';
update inventoryfolders
set agentID = substr(agentID, 1, 8) || "-" || substr(agentID, 9, 4) || "-" || substr(agentID, 13, 4) || "-" || substr(agentID, 17, 4) || "-" || substr(agentID, 21, 12)
where agentID not like '%-%';
update inventoryfolders
set parentID = substr(parentID, 1, 8) || "-" || substr(parentID, 9, 4) || "-" || substr(parentID, 13, 4) || "-" || substr(parentID, 17, 4) || "-" || substr(parentID, 21, 12)
where parentID not like '%-%';
COMMIT;
BEGIN;
ALTER TABLE users add customType varchar(32) not null default '';
ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000';
COMMIT;
BEGIN;
ALTER TABLE land ADD COLUMN OtherCleanTime INTEGER NOT NULL default 0;
ALTER TABLE land ADD COLUMN Dwell INTEGER NOT NULL default 0;
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE estate_groups (
EstateID int(10) NOT NULL,
uuid char(36) NOT NULL
);
CREATE TABLE estate_managers (
EstateID int(10) NOT NULL,
uuid char(36) NOT NULL
);
CREATE TABLE estate_map (
RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
EstateID int(11) NOT NULL
);
CREATE TABLE estate_settings (
EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
EstateName varchar(64) default NULL,
AbuseEmailToEstateOwner tinyint(4) NOT NULL,
DenyAnonymous tinyint(4) NOT NULL,
ResetHomeOnTeleport tinyint(4) NOT NULL,
FixedSun tinyint(4) NOT NULL,
DenyTransacted tinyint(4) NOT NULL,
BlockDwell tinyint(4) NOT NULL,
DenyIdentified tinyint(4) NOT NULL,
AllowVoice tinyint(4) NOT NULL,
UseGlobalTime tinyint(4) NOT NULL,
PricePerMeter int(11) NOT NULL,
TaxFree tinyint(4) NOT NULL,
AllowDirectTeleport tinyint(4) NOT NULL,
RedirectGridX int(11) NOT NULL,
RedirectGridY int(11) NOT NULL,
ParentEstateID int(10) NOT NULL,
SunPosition double NOT NULL,
EstateSkipScripts tinyint(4) NOT NULL,
BillableFactor float NOT NULL,
PublicAccess tinyint(4) NOT NULL
);
insert into estate_settings (EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
delete from estate_settings;
CREATE TABLE estate_users (
EstateID int(10) NOT NULL,
uuid char(36) NOT NULL
);
CREATE TABLE estateban (
EstateID int(10) NOT NULL,
bannedUUID varchar(36) NOT NULL,
bannedIp varchar(16) NOT NULL,
bannedIpHostMask varchar(16) NOT NULL,
bannedNameMask varchar(64) default NULL
);
drop table regionsettings;
CREATE TABLE regionsettings (
regionUUID char(36) NOT NULL,
block_terraform int(11) NOT NULL,
block_fly int(11) NOT NULL,
allow_damage int(11) NOT NULL,
restrict_pushing int(11) NOT NULL,
allow_land_resell int(11) NOT NULL,
allow_land_join_divide int(11) NOT NULL,
block_show_in_search int(11) NOT NULL,
agent_limit int(11) NOT NULL,
object_bonus float NOT NULL,
maturity int(11) NOT NULL,
disable_scripts int(11) NOT NULL,
disable_collisions int(11) NOT NULL,
disable_physics int(11) NOT NULL,
terrain_texture_1 char(36) NOT NULL,
terrain_texture_2 char(36) NOT NULL,
terrain_texture_3 char(36) NOT NULL,
terrain_texture_4 char(36) NOT NULL,
elevation_1_nw float NOT NULL,
elevation_2_nw float NOT NULL,
elevation_1_ne float NOT NULL,
elevation_2_ne float NOT NULL,
elevation_1_se float NOT NULL,
elevation_2_se float NOT NULL,
elevation_1_sw float NOT NULL,
elevation_2_sw float NOT NULL,
water_height float NOT NULL,
terrain_raise_limit float NOT NULL,
terrain_lower_limit float NOT NULL,
use_estate_sun int(11) NOT NULL,
fixed_sun int(11) NOT NULL,
sun_position float NOT NULL,
covenant char(36) default NULL,
Sandbox tinyint(4) NOT NULL,
PRIMARY KEY (regionUUID)
);
CREATE INDEX estate_ban_estate_id on estateban(EstateID);
CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
CREATE INDEX estate_map_estate_id on estate_map(EstateID);
CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
CREATE INDEX estate_users_estate_id on estate_users(EstateID);
COMMIT; BEGIN TRANSACTION;
CREATE TABLE assets(
UUID varchar(255) primary key,
Name varchar(255),
Description varchar(255),
Type integer,
InvType integer,
Local integer,
Temporary integer,
Data blob);
COMMIT;
begin;
ALTER TABLE regionsettings ADD COLUMN sunvectorx double NOT NULL default 0;
ALTER TABLE regionsettings ADD COLUMN sunvectory double NOT NULL default 0;
ALTER TABLE regionsettings ADD COLUMN sunvectorz double NOT NULL default 0;
commit;
W BEGIN;
ALTER TABLE prims ADD COLUMN VolumeDetect INTEGER NOT NULL DEFAULT 0;
COMMIT;
BEGIN TRANSACTION;
CREATE TABLE regionban(
regionUUID varchar (255),
bannedUUID varchar (255),
bannedIp varchar (255),
bannedIpHostMask varchar (255)
);
COMMIT; BEGIN TRANSACTION;
CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
DROP TABLE assets;
CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data);
INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
DROP TABLE assets_backup;
COMMIT;
BSJB v2.0.50727 p / #~ |/ lA #Strings p \ #US 8 #Blob #GUID W ; h b % )
+ 6
Y ^
e 6
^
6
6
6
^
^
5^ ZC
C C .3 JC ^C }
^
^
^ ;
t^
^
6
$ :
I^
m6
M^ h u
^
^ /
co
^
^ C ! ) H" is" s
1
E ^
. ^
4 ^ & S @ d & r @
& @ & @ K * _o* o [
^ H
Z* hy
* 'y. \3j 2 t3 3. 3 = . 3
^
w^
!
*!^ Q! ! !. p#3z# * +y `- - - -* 0y
-2
W3^
86
86
96
/96
H96
a96
|96
99
99
96
9: ) *) $*) 6*) E*)$ . Z*)$ U h*) [ y*), *) < Q*P Q*P Q*P Q*P Q*P Q*P 1 * *1 * + +P +M +S1 * , Q.P Q.P 1 * #. (. +. 6.1 * 0Q0P Q 1P Q 1P Q1P Q&1P Q11P QF1P QZ1P 1 * (. o1 v1 ~1 1 1 1 1 * +P Q,5P Q=5P QN5P Qb5P Qm5P Q5P Q5P Q5P Q5P 1 * (. T0 5 5 5 5 * ! ,! +Y ! + " 1+ # C+ T% O+ & \+ ' h+ p' t+ $( + ( +$
) 8* + H* P* d* * |* +Y t+ ,o
+ !,t
0 =, 2 T, 2 `, 3 l, l4 , 5 5 * (5 + `5 +Y p5 5 5 5 , 5 , 5 ,( 5
-A \6 -H 6 1-P 6 U-i" 6 u-i# 6 -r$ ,7 -% p7 -( t7 -, x7 . 7 *. 7 + . 7 +Y . D9 / 9 C./ ,< M.0 = ^.2 > s.4 ? ~.5 A . 7 A 7 A 7 A .7 @B .J8 HB .W9 @C .: C .J< D .J= PF /> F /W? XG 3/ @ dG D/ A pG X/ B H s/C H /WD H / E tH /F H /G H /H H / I I 0gJ K %0gJ HL A0sJ ,M W0sL N l0N N x0O PO 0Q O 0S lP Y T Q *U Q k U 4Q 0U Q 0W T 0X TV Y \V *Y tV +Y Y Z Z \ 1Z \ 1"[ ] 1D\ ^ 1`^ _ 2 ` H` 2a d #2b 0e :2"c f K29e `h W2 f `i q2kg $k 2h Pl 2 i @m . i Hm 2i lm 2gl m 2gl dt 2gl v 2gl x 2gl { 3gl { %3gl < ?3l C.m ̇ I3n , l3o 3'p 39q D 3Or M.v 3x 3 { 8 3~ 49 ܢ '4J P 44e <4 \4 ( p4 p 4 4s d A0s 4s T 4s ȫ 4s 4s |
5s , 5 * ̭ + +Y Ȱ 5 P 5 61 ( 6E x G6` X6E n6\ 6~ 1-P 6 $ 6 ` 6 6` @ 6
\ 6 6' 8 7= T $7T X H7] \ a7g | s7 7g X 7g 7g < 7g 7 7 `
8 "8 18. X E8s W8s j8s 8s 8 8 < 8 @ H 2 l \4 p4 8P 4 5 8b + ,+ =+ =+ =+ ,+ ,+ + + + + , 4, Q, Q, Q, y, , , y, , , , , , , , , - ,+ G- O- m- m- ,+ ,+ - - ,+ - - - - - + + + Y. h. o. h. Y. o. . . . . . . . Y. h. Y. Y. l/ l/ . / h. h. h. . T0 #. T0 #. + + h. + h. 0 , 0 0 0 m- , 1 1 1 1 1 1 ,+ 1 52 G2 4, 4, h2 2 1 2 2 2 + + + + + 3 + 52 3 1 + 3 + 3 1 + 3 3 + 4 + + 52 52 3 1 O4 V4 , 2 , 4 2 2 2 T0 #. T0 #. T0 #. T0 #. T0 #. T0 #. T0 #. 2 , ,+ 5 6 6 6 16 6 A6 16 6 16 6 A6 16 6 G- O- ,+ 2 5 6 { 6 5 6 . . 7 97 >7 A7 97 >7 Y. . . 7 + + . + . 7 + + B8 T0 #. T0 #. 5 #. 5 #. 8 4, 2 2 2 , 2 , 4 2 2 2 2 2 2 a H ! p 1 ! 9 ( A - I 2 Q 7 Y < Y < Y < Y (< i <@ q k i qP i wS q Y q - g p u | A Z o k p < i / ) 6 G Y P [Y dY | P [Y dY Z 9 $ $ 2 [ z%! i /i 5 :) A B)Hi Oi /Vy ] Y Zc Gjq v{ 9 A $ i / $ *)3)@QA )T )Y)l)}$ $ , $ Z , , )))) a a aY a,Y )A)HaW 4 4 Z 4 2i q Y < yA < :oi < D < Y P #Z
J< GT Y ! i /% - Y 4 Y ; B =IZOGVV][ !G ) ) Y )[Y dY 1 H \ t m r ) ! <
<
)"
,
) :
N
e
y
<
w
<
{1 ) # 1ZL i /* L Z T i /T Z T J< T GAK 9U w b \ \ p \ Gj\ Z:T | ! L d d d T l l l Y G B ]I B ] B9 9 9 9" #9(9 ,i b S ) ; Y Y a A ak a9iY < ?t K| | g i lZrt t P . P P P
y
P
|!
P +
|6
|A
|L
e
~
P
P
P
P
P P ( 7 B g ) i < ". Z: Z ) : !G Gj@ Z %1a A 5A AH L3S @ M |Y Z Z [Y Y )dY Y Y -?M^ k1 |9 $r4=CM!X _p yy r%r2 E^y q | [Y dY 1 H t [Y dY . J Ur er x Y Y 1 . > K _ s & : N bs& 7 CQ ^n !{!! i A i2
<
$6DUb1u1~1 9u9~99 #)w )) w)$w)*w0 E.T g~ <
< w 4ww 9% 0 U
< <
:
N
e
A
Y< e p < = < <
< C
w w 9 $< 2 A R a q< < < # H3 < @ S i | H H H H H! H2 HC HT Hd Hz H H r # # r" r1 r@ rO \ rj r # # r # r 0 @ IJ T w^ ,l ,x w w w w w w $ 7 ,H ,W wh ,z w ) O Gt | | Z 4 : !y !! i /! 5!>!P H!P D Z a! q! ! 1J< ) ! ) ! ! ! !! ! " " " *" 8" E" S" a" p" ~" " " " " " " " " # # ,# ?# S# a# ## # # #Y #Y #Y #Y #Y $$&$7$F$ W$ c$ q$ $Y $Y $$$Y $Y $ $ % % +%Y :% F% P% a% r%%% %%%< %< % % & &+&:& H& _& i& |& &< &< & & !& & & & & ' ' ' .' <' K' Y' h' v' ' ' ' ' ' ' ' ' ( ( .( <( K(W( `( q(< |(9 ( (Y (( ( ( ( ( ) ) !),)9)D) P)^) n) ) )< )< ) ))) Y Y Y ! Y ) Y 1 Y 9 Y A I Y Q Y Y @ G D d h l
p D
t
x
|
W $ j
J . C . . . . h. . #. +. 3. ; . h 0B^|/^y$_$0Fm|*Mh-Car!0D]!BTp 9NVi.Do&8W I +I , +I I +I I +I I ! 9
: W_
;dmvYbky ) "
G C ^ d^ ( 0@ F 3 3: 1 e: : T : : { +; [; s! ; I& ; ;' ; + '< b/ \< / < >0 < 0 < 0 != OA S= B = C = C = D > T O> U > W > W > 4X ? X H? X x? Y ? a ? a @ pb A@ Tp s@ Zq @ Tr @ r A fs :A OpenSim.Data AssetDataBase .ctor mscorlib MethodBase System.Reflection GetCurrentMethod Type System MemberInfo get_DeclaringType log4net ILog LogManager GetLogger Object GetType Module get_Module Assembly get_Assembly AssemblyName GetName Version get_Version get_Major Int32 get_Minor get_Build get_Revision String Format Mono.Data.SqliteClient SqliteConnection Close Empty op_Equality Open System.Data DbConnection System.Data.Common Migration Update Monitor System.Threading Enter SqliteCommand SqliteParameterCollection get_Parameters OpenMetaverseTypes UUID OpenMetaverse ToString SqliteParameter Add SqliteDataReader ExecuteReader IDataReader Read IDisposable Dispose Exit OpenSim.Framework AssetBase get_FullID get_Name get_Description get_Type SByte get_Local Boolean get_Temporary get_Data ExecuteNonQuery Concat Info IDataRecord get_Item set_FullID set_Name set_Description Convert ToSByte set_Type ToBoolean set_Local set_Temporary set_Data AssetMetadata Byte set_SHA1 List`1 System.Collections.Generic Dictionary`2 FieldInfo KeyCollection get_Keys IEnumerable`1 ToArray EstateSettings RuntimeTypeHandle GetTypeFromHandle BindingFlags GetFields Substring set_Item SaveDelegate add_OnSave Join DbCommand CreateCommand set_CommandText GetValue ToInt32 SetValue Zero TryParse get_FieldType ChangeType Remove Clear ToUInt32 set_EstateID get_EstateID UInt32 Save set_EstateManagers set_EstateAccess set_EstateGroups Enumerator GetEnumerator get_Current MoveNext get_EstateManagers get_EstateAccess get_EstateGroups ClearBans EstateBan set_BannedUserID set_BannedHostAddress set_BannedHostIPMask AddBan get_EstateBans get_BannedUserID GridDataBase PluginNotInitialisedException UInt64 IDbCommand get_Length AvatarPickerAvatar Exception RegionProfileData regionHandle regionSecret DataColumn DataColumnCollection DataTable get_Columns InternalDataCollectionBase get_Count get_ColumnName IEnumerator System.Collections get_DataType get_TableName get_PrimaryKey set_ParameterName DbType set_DbType set_SourceColumn DataRowVersion set_SourceVersion Int64 Double SqliteDataAdapter DataSet DataTableCollection get_Tables DbDataAdapter Fill AcceptChanges Component System.ComponentModel MarshalByValueComponent InventoryItemBase DataRow InventoryNodeBase set_ID set_AssetID set_AssetType set_InvType set_Folder set_Owner set_CreatorId set_NextPermissions set_CurrentPermissions set_BasePermissions set_EveryOnePermissions set_GroupPermissions IsDBNull set_SalePrice ToByte set_SaleType set_CreationDate set_GroupID set_GroupOwned set_Flags get_ID get_AssetID get_AssetType get_InvType get_Folder get_Owner get_CreatorId get_NextPermissions get_CurrentPermissions get_BasePermissions get_EveryOnePermissions get_GroupPermissions get_SalePrice get_SaleType get_CreationDate get_GroupID get_GroupOwned get_Flags DataRowCollection get_Rows Find ErrorFormat NewRow Select InventoryFolderBase Array GetLength get_ParentID op_Inequality ContainsKey AddRange Delete set_PrimaryKey set_InsertCommand get_InsertCommand set_Connection set_UpdateCommand get_UpdateCommand set_DeleteCommand set_ParentID ToInt16 ToUInt16 set_Version Int16 UInt16 Warn System.Data.SQLite SQLiteConnection IDbConnection SQLiteCommand KeyValuePair`2 get_Key get_Value SQLiteParameter SQLiteParameterCollection regionName regionRecvKey regionSendKey regionDataURI regionOnline serverIP serverPort serverURI regionLocX regionLocY regionLocZ regionEastOverrideHandle regionWestOverrideHandle regionSouthOverrideHandle regionNorthOverrideHandle regionAssetURI regionAssetRecvKey regionAssetSendKey regionUserURI regionUserRecvKey regionUserSendKey RegionSettings get_RegionUUID set_RegionUUID OpenSim.Region.Framework SceneObjectPart OpenSim.Region.Framework.Scenes SceneObjectGroup get_Children ValueCollection get_Values GetEffectiveObjectFlags get_UUID get_Stopped Guid InfoFormat PrimitiveBaseShape set_Shape get_Default SetRootPart Error AddPart TaskInventoryItem ICollection`1 IEntityInventory OpenSim.Region.Framework.Interfaces get_Inventory RestoreInventoryItems Util UnixTimeSinceEpoch Initialize MemoryStream System.IO Stream BinaryReader ReadDouble Set LandData ILandObject get_landData get_GlobalID get_regionUUID ParcelManager ParcelAccessEntry get_ParcelAccessList set_UUID set_Text System.Drawing Color FromArgb set_Color set_SitName set_TouchName set_ObjectFlags set_CreatorID set_OwnerID set_LastOwnerID set_OwnerMask set_NextOwnerMask set_GroupMask set_EveryoneMask set_BaseMask ToSingle Vector3 set_OffsetPosition set_GroupPosition set_Velocity set_AngularVelocity set_Acceleration Quaternion set_RotationOffset set_SitTargetPositionLL set_SitTargetOrientationLL set_ClickAction PayPrice Sound SoundGain SoundFlags IsNull FromBase64String set_TextureAnimation set_ParticleSystem set_RotationalVelocity SetCameraEyeOffset SetCameraAtOffset SetForceMouselook set_ScriptAccessPin AllowedDrop DIE_AT_EDGE set_ObjectSaleType set_Material set_CollisionSound set_CollisionSoundVolume VolumeDetectActive set_ItemID set_ParentPartID set_EveryonePermissions set_GlobalID set_LocalID set_Bitmap op_Explicit set_IsGroupOwned set_Area set_AuctionID Parcel ParcelCategory set_Category set_ClaimDate set_ClaimPrice ParcelStatus set_Status set_LandingType set_MediaAutoScale set_MediaID set_MediaURL set_MusicURL set_PassHours set_PassPrice set_SnapshotID set_UserLocation set_UserLookAt set_ParcelAccessList set_OtherCleanTime set_Dwell set_BlockTerraform set_AllowDamage set_BlockFly set_RestrictPushing set_AllowLandResell set_AllowLandJoinDivide set_BlockShowInSearch set_AgentLimit ToDouble set_ObjectBonus set_Maturity set_DisableScripts set_DisableCollisions set_DisablePhysics set_TerrainTexture1 set_TerrainTexture2 set_TerrainTexture3 set_TerrainTexture4 set_Elevation1NW set_Elevation2NW set_Elevation1NE set_Elevation2NE set_Elevation1SE set_Elevation2SE set_Elevation1SW set_Elevation2SW set_WaterHeight set_TerrainRaiseLimit set_TerrainLowerLimit set_UseEstateSun set_Sandbox set_SunVector set_FixedSun set_SunPosition set_Covenant AgentID AccessList Flags DateTime Time BinaryWriter Get Write get_Text get_SitName get_TouchName get_ObjectFlags get_CreatorID get_OwnerID get_LastOwnerID get_OwnerMask get_NextOwnerMask get_GroupMask get_EveryoneMask get_BaseMask get_OffsetPosition X Single Y Z get_GroupPosition get_Velocity get_AngularVelocity get_Acceleration get_RotationOffset W get_SitTargetPositionLL get_SitTargetOrientationLL get_Color get_R get_G get_B get_A get_TextureAnimation ToBase64String get_ParticleSystem get_RotationalVelocity GetCameraEyeOffset GetCameraAtOffset GetForceMouselook get_ScriptAccessPin get_ObjectSaleType get_ClickAction get_Material get_CollisionSound get_CollisionSoundVolume get_ItemID get_ParentPartID get_EveryonePermissions get_LocalID get_Bitmap get_IsGroupOwned get_Area get_AuctionID get_Category get_ClaimDate get_ClaimPrice get_Status get_LandingType get_MediaAutoScale get_MediaID get_MediaURL get_MusicURL get_PassHours get_PassPrice get_SnapshotID get_UserLocation get_UserLookAt get_AuthBuyerID get_OtherCleanTime get_Dwell get_BlockTerraform get_BlockFly get_AllowDamage get_RestrictPushing get_AllowLandResell get_AllowLandJoinDivide get_BlockShowInSearch get_AgentLimit get_ObjectBonus get_Maturity get_DisableScripts get_DisableCollisions get_DisablePhysics get_TerrainTexture1 get_TerrainTexture2 get_TerrainTexture3 get_TerrainTexture4 get_Elevation1NW get_Elevation2NW get_Elevation1NE get_Elevation2NE get_Elevation1SE get_Elevation2SE get_Elevation1SW get_Elevation2SW get_WaterHeight get_TerrainRaiseLimit get_TerrainLowerLimit get_UseEstateSun get_Sandbox get_SunVector get_FixedSun get_SunPosition get_Covenant set_Scale set_PCode set_PathBegin set_PathEnd set_PathScaleX set_PathScaleY set_PathShearX set_PathShearY set_PathSkew set_PathCurve set_PathRadiusOffset set_PathRevolutions set_PathTaperX set_PathTaperY set_PathTwist set_PathTwistBegin set_ProfileBegin set_ProfileEnd set_ProfileCurve set_ProfileHollow set_State set_TextureEntry set_ExtraParams get_Shape get_Scale get_PCode get_PathBegin get_PathEnd get_PathScaleX get_PathScaleY get_PathShearX get_PathShearY get_PathSkew get_PathCurve get_PathRadiusOffset get_PathRevolutions get_PathTaperX get_PathTaperY get_PathTwist get_PathTwistBegin get_ProfileBegin get_ProfileEnd get_ProfileCurve get_ProfileHollow get_State get_TextureEntry get_ExtraParams IEnumerator`1 UserDataBase FriendListItem FriendListOwner Friend FriendPerms FriendListOwnerPerms FriendRegionInfo isOnline ToUInt64 Char Split AvatarID firstName lastName UserProfileData set_WebLoginKey get_FirstName get_SurName Debug WarnFormat UserAgentData get_SessionID get_ProfileID AvatarAppearance ToRawUuidString set_BodyAsset set_BodyItem set_SkinItem set_SkinAsset set_HairItem set_HairAsset set_EyesItem set_EyesAsset set_ShirtItem set_ShirtAsset set_PantsItem set_PantsAsset set_ShoesItem set_ShoesAsset set_SocksItem set_SocksAsset set_JacketItem set_JacketAsset set_GlovesItem set_GlovesAsset set_UnderShirtItem set_UnderShirtAsset set_UnderPantsItem set_UnderPantsAsset set_SkirtItem set_SkirtAsset Primitive TextureEntry set_Texture set_VisualParams set_Serial set_AvatarHeight set_FirstName set_SurName set_Email set_PasswordHash set_PasswordSalt set_HomeRegionX set_HomeRegionY set_HomeLocation set_HomeLookAt set_HomeRegionID set_Created set_LastLogin set_RootInventoryFolderID set_UserInventoryURI set_UserAssetURI set_CanDoMask set_WantDoMask set_AboutText set_FirstLifeAboutText set_Image set_FirstLifeImage set_UserFlags set_GodLevel set_CustomType set_Partner get_Email get_PasswordHash get_PasswordSalt get_HomeRegionX get_HomeRegionY get_HomeRegionID get_HomeLocation get_HomeLookAt get_Created get_LastLogin get_RootInventoryFolderID get_UserInventoryURI get_UserAssetURI get_CanDoMask get_WantDoMask get_AboutText get_FirstLifeAboutText get_Image get_FirstLifeImage get_WebLoginKey get_UserFlags get_GodLevel get_CustomType get_Partner get_BodyItem get_BodyAsset get_SkinItem get_SkinAsset get_HairItem get_HairAsset get_EyesItem get_EyesAsset get_ShirtItem get_ShirtAsset get_PantsItem get_PantsAsset get_ShoesItem get_ShoesAsset get_SocksItem get_SocksAsset get_JacketItem get_JacketAsset get_GlovesItem get_GlovesAsset get_UnderShirtItem get_UnderShirtAsset get_UnderPantsItem get_UnderPantsAsset get_SkirtItem get_SkirtAsset get_Texture GetBytes get_VisualParams get_Serial get_AvatarHeight set_ProfileID set_AgentIP set_AgentPort set_AgentOnline set_SessionID set_SecureSessionID set_InitialRegion set_LoginTime set_LogoutTime set_Region set_Handle set_Position set_LookAt get_AgentIP get_AgentPort get_AgentOnline get_SecureSessionID get_InitialRegion get_LoginTime get_LogoutTime get_Region get_Handle get_Position get_LookAt OpenSim.Data.SQLite OpenSim.Data.SQLite.dll SQLiteAssetData SQLiteEstateStore SQLiteGridData SQLiteInventoryStore SQLiteManager SQLiteRegionData SQLiteUserData SQLiteUtil SelectAssetSQL SelectAssetMetadataSQL DeleteAssetSQL InsertAssetSQL UpdateAssetSQL assetSelect m_log m_conn .cctor Initialise dbconnect FetchStoredAsset uuid CreateAsset asset UpdateAsset LogAssetLoad ExistsAsset DeleteAsset buildAsset row buildAssetMetadata FetchAssetMetadataSet start count Name IEstateDataStore m_connection m_connectionString m_Fields m_FieldMap connectionString get_FieldList LoadEstateSettings regionID StoreEstateSettings es LoadBanList SaveBanList SaveUUIDList EstateID table data LoadUUIDList FieldList database connect GetProfilesInRange a b c d GetRegionsByName namePrefix maxNum GetProfileByHandle handle GetProfileByString GetProfileByUUID GeneratePickerResults queryID query AddProfile DataResponse profile UpdateProfile DeleteProfile AuthenticateSim authkey authhash challenge GetReservationAtPoint ReservationData x y IInventoryDataPlugin IPlugin invItemsSelect invFoldersSelect conn ds invItemsDa invFoldersDa buildItem fillItemRow item addFolder folder add moveFolder addItem Shutdown getInventoryInFolder folderID getUserRootFolders user getUserRootFolder getInventoryFolders folders parentID getFolderHierarchy getInventoryItem getInventoryFolder addInventoryItem updateInventoryItem deleteInventoryItem itemID queryInventoryItem queryInventoryFolder deleteItemsInFolder folderId addInventoryFolder updateInventoryFolder moveInventoryFolder deleteInventoryFolder createInventoryItemsTable createInventoryFoldersTable setupItemsCommands da setupFoldersCommands buildFolder fillFolderRow moveFolderRow fetchActiveGestures avatarID dbcon Query sql parameters getRow reader insertRow IRegionDataStore primSelect shapeSelect itemsSelect terrainSelect landSelect landAccessListSelect regionbanListSelect regionSettingsSelect primDa shapeDa itemsDa terrainDa landDa landAccessListDa regionSettingsDa StoreRegionSettings rs LoadRegionSettings regionUUID StoreObject obj RemoveObject RemoveItems LoadObjects LoadItems IList`1 prim StoreTerrain ter LoadTerrain RemoveLandObject globalID StoreLandObject parcel LoadLandObjects Commit createCol dt name type createTerrainTable createPrimTable createShapeTable createItemsTable createLandTable createLandAccessListTable createRegionSettingsTable buildPrim buildLandData InvalidCastException buildRegionSettings buildLandAccessData serializeTerrain val fillPrimRow sceneGroupID taskItem fillLandRow land fillLandAccessRow entry parcelID fillRegionSettingsRow settings buildShape fillShapeRow addPrim StorePrimInventory primID items createInsertCommand createUpdateCommand pk createSqliteParameter setupPrimCommands setupTerrainCommands setupLandCommands setupLandAccessCommands setupRegionSettingsCommands setupShapeCommands dbtypeFromType SelectUserByUUID SelectUserByName SelectFriendsByUUID userSelect userFriendsSelect userAgentSelect AvatarAppearanceSelect AvatarPickerAndSQL AvatarPickerOrSQL daf dua daa g_conn GetUserByUUID GetUserByName fname lname ExistsFriend owner friend AddNewUserFriend friendlistowner perms RemoveUserFriend UpdateUserFriendPerms GetUserFriendList GetFriendRegionInfos uuids GetAgentByUUID GetAgentByName StoreWebLoginKey WebLoginKey ExistsFirstLastName AddNewUserProfile UpdateUserProfile AddNewUserAgent agent MoneyTransferRequest from to amount InventoryTransferRequest GetUserAppearance UpdateUserAppearance appearance createUsersTable createUserAgentsTable createUserFriendsTable createAvatarAppearanceTable buildUserProfile fillUserRow fillAvatarAppearanceRow buildUserAgent fillUserAgentRow ua setupUserCommands setupAgentCommands setupUserFriendsCommands setupAvatarAppearanceCommands ResetAttachments userID LogoutUsers defineTable sqliteType AssemblyTitleAttribute AssemblyDescriptionAttribute AssemblyConfigurationAttribute AssemblyCompanyAttribute AssemblyProductAttribute AssemblyCopyrightAttribute AssemblyTrademarkAttribute ComVisibleAttribute System.Runtime.InteropServices GuidAttribute AssemblyFileVersionAttribute RuntimeCompatibilityAttribute System.Runtime.CompilerServices OpenSim.Data.SQLite.Resources.005_RegionStore.sql OpenSim.Data.SQLite.Resources.004_RegionStore.sql OpenSim.Data.SQLite.Resources.009_UserStore.sql OpenSim.Data.SQLite.Resources.011_RegionStore.sql OpenSim.Data.SQLite.Resources.017_RegionStore.sql OpenSim.Data.SQLite.Resources.005_UserStore.sql OpenSim.Data.SQLite.Resources.OpenSim.Data.SQLite.addin.xml OpenSim.Data.SQLite.Resources.010_UserStore.sql OpenSim.Data.SQLite.Resources.007_UserStore.sql OpenSim.Data.SQLite.Resources.001_UserStore.sql OpenSim.Data.SQLite.Resources.001_InventoryStore.sql OpenSim.Data.SQLite.Resources.003_RegionStore.sql OpenSim.Data.SQLite.Resources.003_UserStore.sql OpenSim.Data.SQLite.Resources.010_RegionStore.sql OpenSim.Data.SQLite.Resources.003_AssetStore.sql OpenSim.Data.SQLite.Resources.018_RegionStore.sql OpenSim.Data.SQLite.Resources.002_InventoryStore.sql OpenSim.Data.SQLite.Resources.009_RegionStore.sql OpenSim.Data.SQLite.Resources.012_RegionStore.sql OpenSim.Data.SQLite.Resources.004_AssetStore.sql OpenSim.Data.SQLite.Resources.001_RegionStore.sql OpenSim.Data.SQLite.Resources.003_InventoryStore.sql OpenSim.Data.SQLite.Resources.006_UserStore.sql OpenSim.Data.SQLite.Resources.007_RegionStore.sql OpenSim.Data.SQLite.Resources.008_RegionStore.sql OpenSim.Data.SQLite.Resources.008_UserStore.sql OpenSim.Data.SQLite.Resources.002_UserStore.sql OpenSim.Data.SQLite.Resources.015_RegionStore.sql OpenSim.Data.SQLite.Resources.004_InventoryStore.sql OpenSim.Data.SQLite.Resources.004_UserStore.sql OpenSim.Data.SQLite.Resources.013_RegionStore.sql OpenSim.Data.SQLite.Resources.006_RegionStore.sql OpenSim.Data.SQLite.Resources.001_AssetStore.sql OpenSim.Data.SQLite.Resources.014_RegionStore.sql OpenSim.Data.SQLite.Resources.016_RegionStore.sql OpenSim.Data.SQLite.Resources.002_RegionStore.sql OpenSim.Data.SQLite.Resources.002_AssetStore.sql { 0 } . { 1 } . { 2 } . { 3 } 7S Q L i t e A s s e t s t o r a g e e n g i n e EU R I = f i l e : A s s e t S t o r a g e . d b , v e r s i o n = 3 A s s e t S t o r e Ks e l e c t * f r o m a s s e t s w h e r e U U I D = : U U I D : U U I D i n s e r t i n t o a s s e t s ( U U I D , N a m e , D e s c r i p t i o n , T y p e , L o c a l , T e m p o r a r y , D a t a ) v a l u e s ( : U U I D , : N a m e , : D e s c r i p t i o n , : T y p e , : L o c a l , : T e m p o r a r y , : D a t a ) : N a m e : D e s c r i p t i o n : T y p e
: L o c a l : T e m p o r a r y : D a t a u p d a t e a s s e t s s e t N a m e = : N a m e , D e s c r i p t i o n = : D e s c r i p t i o n , T y p e = : T y p e , L o c a l = : L o c a l , T e m p o r a r y = : T e m p o r a r y , D a t a = : D a t a w h e r e U U I D = : U U I D T e m p o r a r y
S t o r e d L o c a l
R e m o t e [ A S S E T D B ] : mL o a d e d { 6 } { 5 } A s s e t : [ { 0 } ] [ { 3 } ] " { 1 } " : { 2 } ( { 7 } b y t e s ) Gd e l e t e f r o m a s s e t s w h e r e U U I D = : U U I D U U I D N a m e D e s c r i p t i o n T y p e D a t a s e l e c t N a m e , D e s c r i p t i o n , T y p e , T e m p o r a r y , U U I D f r o m a s s e t s l i m i t : s t a r t , : c o u n t
: s t a r t
: c o u n t E[ E S T A T E D B ] : S q l i t e - c o n n e c t i n g : E s t a t e S t o r e m _ /s e l e c t e s t a t e _ s e t t i n g s . #, e s t a t e _ s e t t i n g s . A f r o m e s t a t e _ m a p l e f t j o i n e s t a t e _ s e t t i n g s o n e s t a t e _ m a p . E s t a t e I D = e s t a t e _ s e t t i n g s . E s t a t e I D w h e r e e s t a t e _ s e t t i n g s . E s t a t e I D i s n o t n u l l a n d R e g i o n I D = : R e g i o n I D : R e g i o n I D E s t a t e I D ;i n s e r t i n t o e s t a t e _ s e t t i n g s ( , ) v a l u e s ( : , : ) : 1 0 As e l e c t L A S T _ I N S E R T _ R O W I D ( ) a s i d i d ii n s e r t i n t o e s t a t e _ m a p v a l u e s ( : R e g i o n I D , : E s t a t e I D ) : E s t a t e I D ;i n s e r t i n t o e s t a t e b a n s e l e c t , b a n n e d U U I D , b a n n e d I p , b a n n e d I p H o s t M a s k , ' ' f r o m r e g i o n b a n w h e r e r e g i o n b a n . r e g i o n U U I D = : U U I D e s t a t e _ m a n a g e r s e s t a t e _ u s e r s e s t a t e _ g r o u p s = : 7u p d a t e e s t a t e _ s e t t i n g s s e t , 7 w h e r e E s t a t e I D = : E s t a t e I D ws e l e c t b a n n e d U U I D f r o m e s t a t e b a n w h e r e E s t a t e I D = : E s t a t e I D b a n n e d U U I D 0 . 0 . 0 . 0 ad e l e t e f r o m e s t a t e b a n w h e r e E s t a t e I D = : E s t a t e I D
i n s e r t i n t o e s t a t e b a n ( E s t a t e I D , b a n n e d U U I D , b a n n e d I p , b a n n e d I p H o s t M a s k , b a n n e d N a m e M a s k ) v a l u e s ( : E s t a t e I D , : b a n n e d U U I D , ' ' , ' ' , ' ' ) : b a n n e d U U I D d e l e t e f r o m i n s e r t i n t o [ ( E s t a t e I D , u u i d ) v a l u e s ( : E s t a t e I D , : u u i d ) : u u i d #s e l e c t u u i d f r o m u u i d 'S Q L i t e O p e n G r i d D a t a 0 . 1 [ S Q L i t e ] : ? c a n n o t b e d e f a u l t - i n i t i a l i z e d !
h a n d l e YS E L E C T * F R O M r e g i o n s W H E R E h a n d l e = @ h a n d l e ? r e g i o n N a m e % S E L E C T * F R O M r e g i o n s W H E R E r e g i o n N a m e l i k e ? r e g i o n N a m e L I M I T 1 QS E L E C T * F R O M r e g i o n s W H E R E u u i d = @ u u i d MD E L E T E F R O M r e g i o n s W H E R E u u i d = @ u u i d C R Y P T O W E A K A U T H E N T I C A T E : R e f u s i n g t o a u t h e n t i c a t e d u e t o r e p l a y p o t e n t i a l . ( ) v a l u e s ( : u p d a t e s e t = : w h e r e c r e a t e t a b l e ,
p r i m a r y k e y v a r c h a r ( 2 5 5 ) i n t e g e r f l o a t b l o b
s t r i n g ?S Q L i t e I n v e n t o r y D a t a I n t e r f a c e /[ S Q L i t e I n v e n t o r y D a t a ] : IU R I = f i l e : i n v e n t o r y S t o r e . d b , v e r s i o n = 3 K[ I N V E N T O R Y D B ] : S q l i t e - c o n n e c t i n g : I n v e n t o r y S t o r e 9s e l e c t * f r o m i n v e n t o r y i t e m s =s e l e c t * f r o m i n v e n t o r y f o l d e r s !i n v e n t o r y f o l d e r s o[ I N V E N T O R Y D B ] : P o p u l a t e d I n v e n t o r y F o l d e r s D e f i n i t i o n s i n v e n t o r y i t e m s k[ I N V E N T O R Y D B ] : P o p u l a t e d I n v e n t o r y I t e m s D e f i n i t i o n s a s s e t I D a s s e t T y p e i n v T y p e p a r e n t F o l d e r I D a v a t a r I D c r e a t o r s I D i n v e n t o r y N a m e )i n v e n t o r y D e s c r i p t i o n 1i n v e n t o r y N e x t P e r m i s s i o n s 7i n v e n t o r y C u r r e n t P e r m i s s i o n s 1i n v e n t o r y B a s e P e r m i s s i o n s 9i n v e n t o r y E v e r y O n e P e r m i s s i o n s 3i n v e n t o r y G r o u p P e r m i s s i o n s s a l e P r i c e s a l e T y p e c r e a t i o n D a t e g r o u p I D g r o u p O w n e d F l a g s f l a g s I n t e r f a c e M i s u s e : A t t e m p t i n g t o U p d a t e n o n - e x i s t a n t i n v e n t o r y f o l d e r : { 0 } I n t e r f a c e M i s u s e : A t t e m p t i n g t o A d d i n v e n t o r y f o l d e r t h a t a l r e a d y e x i s t s : { 0 } [ I N V E N T O R Y D B ] : I n t e r f a c e M i s u s e : A t t e m p t i n g t o U p d a t e n o n - e x i s t a n t i n v e n t o r y i t e m : { 0 } [ I N V E N T O R Y D B ] : I n t e r f a c e M i s u s e : A t t e m p t i n g t o A d d i n v e n t o r y i t e m t h a t a l r e a d y e x i s t s : { 0 } v e r s i o n %p a r e n t F o l d e r I D = ' ' a g e n t I D = ' %' A N D p a r e n t I D = ' p a r e n t I D = ' U U I D = ' n a m e a g e n t I D p a r e n t I D t y p e U U I D = : U U I D [d e l e t e f r o m i n v e n t o r y i t e m s w h e r e U U I D = : U U I D _d e l e t e f r o m i n v e n t o r y f o l d e r s w h e r e U U I D = : U U I D a v a t a r I D = ' %' A N D a s s e t T y p e = A N D f l a g s = 1 [[ S Q L I T E ] g r i d d b n o t s p e c i f i e d , u s i n g d e f a u l t ;U R I = f i l e : G r i d S e r v e r S q l i t e . d b ; IE r r o r i n i t i a l i s i n g S Q L i t e D a t a b a s e : r e g i o n H a n d l e r e g i o n N a m e r e g i o n R e c v K e y r e g i o n S e c r e t r e g i o n S e n d K e y r e g i o n D a t a U R I s e r v e r I P s e r v e r P o r t s e r v e r U R I l o c X l o c Y l o c Z %e a s t O v e r r i d e H a n d l e %w e s t O v e r r i d e H a n d l e 's o u t h O v e r r i d e H a n d l e 'n o r t h O v e r r i d e H a n d l e r e g i o n A s s e t U R I %r e g i o n A s s e t R e c v K e y %r e g i o n A s s e t S e n d K e y r e g i o n U s e r U R I #r e g i o n U s e r R e c v K e y #r e g i o n U s e r S e n d K e y #N o r o w s t o r e t u r n R E P L A C E I N T O r e g i o n s V A L U E S ( r e g i o n H a n d l e , r e g i o n N a m e , u u i d , r e g i o n R e c v K e y , r e g i o n S e c r e t , r e g i o n S e n d K e y , r e g i o n D a t a U R I , Ss e r v e r I P , s e r v e r P o r t , s e r v e r U R I , l o c X , l o c Y , l o c Z , e a s t O v e r r i d e H a n d l e , w e s t O v e r r i d e H a n d l e , s o u t h O v e r r i d e H a n d l e , n o r t h O v e r r i d e H a n d l e , r e g i o n A s s e t U R I , r e g i o n A s s e t R e c v K e y , r e g i o n A s s e t S e n d K e y , r e g i o n U s e r U R I , r e g i o n U s e r R e c v K e y , r e g i o n U s e r S e n d K e y ) V A L U E S ( @ r e g i o n H a n d l e , @ r e g i o n N a m e , @ u u i d , @ r e g i o n R e c v K e y , @ r e g i o n S e c r e t , @ r e g i o n S e n d K e y , @ r e g i o n D a t a U R I , k@ s e r v e r I P , @ s e r v e r P o r t , @ s e r v e r U R I , @ l o c X , @ l o c Y , @ l o c Z , @ e a s t O v e r r i d e H a n d l e , @ w e s t O v e r r i d e H a n d l e , @ s o u t h O v e r r i d e H a n d l e , @ n o r t h O v e r r i d e H a n d l e , @ r e g i o n A s s e t U R I , @ r e g i o n A s s e t R e c v K e y , @ r e g i o n A s s e t S e n d K e y , @ r e g i o n U s e r U R I , @ r e g i o n U s e r R e c v K e y , @ r e g i o n U s e r S e n d K e y ) ; E[ R E G I O N D B ] : S q l i t e - c o n n e c t i n g : 's e l e c t * f r o m p r i m s 1s e l e c t * f r o m p r i m s h a p e s /s e l e c t * f r o m p r i m i t e m s ;s e l e c t * f r o m t e r r a i n l i m i t 1 %s e l e c t * f r o m l a n d Ks e l e c t d i s t i n c t * f r o m l a n d a c c e s s l i s t 9s e l e c t * f r o m r e g i o n s e t t i n g s R e g i o n S t o r e p r i m s p r i m i t e m s p r i m s h a p e s e[ R E G I O N D B ] : C a u g h t f i l l e r r o r o n p r i m s h a p e s t a b l e t e r r a i n _[ R E G I O N D B ] : C a u g h t f i l l e r r o r o n t e r r a i n t a b l e l a n d Y[ R E G I O N D B ] : C a u g h t f i l l e r r o r o n l a n d t a b l e l a n d a c c e s s l i s t m[ R E G I O N D B ] : C a u g h t f i l l e r r o r o n l a n d a c c e s s l i s t t a b l e r e g i o n s e t t i n g s m[ R E G I O N D B ] : C a u g h t f i l l e r r o r o n r e g i o n s e t t i n g s t a b l e r e g i o n U U I D = ' 3[ R E G I O N D B ] : A d d i n g o b j : t o r e g i o n : _[ R E G I O N D B ] : R e m o v i n g o b j : { 0 } f r o m r e g i o n : { 1 } !S c e n e G r o u p I D = ' )' a n d R e g i o n U U I D = ' p r i m I D = ' { 0 } ' R e g i o n U U I D = ' )[ R E G I O N D B ] : L o a d e d ' p r i m s f o r r e g i o n : S c e n e G r o u p I D [ R E G I O N D B ] : N o s h a p e f o u n d f o r p r i m i n s t o r a g e , s o s e t t i n g d e f a u l t b o x s h a p e [ R E G I O N D B ] : F a i l e d c r e a t e p r i m o b j e c t i n n e w g r o u p , e x c e p t i o n a n d d a t a f o l l o w s [ R E G I O N D B ] : %[ R E G I O N D B ] : C o l : = > [ R E G I O N D B ] : F a i l e d c r e a t e p r i m o b j e c t i n g r o u p , e x c e p t i o n a n d d a t a f o l l o w s d e l e t e f r o m t e r r a i n w h e r e R e g i o n U U I D = : R e g i o n U U I D a n d R e v i s i o n < = : R e v i s i o n : R e g i o n U U I D : R e v i s i o n O[ R E G I O N D B ] : S t o r i n g t e r r a i n r e v i s i o n r i n s e r t i n t o t e r r a i n ( R e g i o n U U I D , R e v i s i o n , H e i g h t f i e l d ) v a l u e s ( : R e g i o n U U I D , : R e v i s i o n , : H e i g h t f i e l d ) : H e i g h t f i e l d s e l e c t R e g i o n U U I D , R e v i s i o n , H e i g h t f i e l d f r o m t e r r a i n w h e r e R e g i o n U U I D = : R e g i o n U U I D o r d e r b y R e v i s i o n d e s c H e i g h t f i e l d R e v i s i o n Q[ R E G I O N D B ] : N o t e r r a i n f o u n d f o r r e g i o n M[ R E G I O N D B ] : L o a d e d t e r r a i n r e v i s i o n r Cd e l e t e f r o m l a n d w h e r e U U I D = : U U I D _d e l e t e f r o m l a n d a c c e s s l i s t w h e r e L a n d U U I D = : U U I D gd e l e t e f r o m l a n d a c c e s s l i s t w h e r e L a n d U U I D = : L a n d U U I D : L a n d U U I D L a n d U U I D = ' R e g i o n U U I D C r e a t i o n D a t e T e x t
C o l o r R
C o l o r G
C o l o r B
C o l o r A S i t N a m e T o u c h N a m e O b j e c t F l a g s C r e a t o r I D O w n e r I D G r o u p I D L a s t O w n e r I D O w n e r M a s k N e x t O w n e r M a s k G r o u p M a s k E v e r y o n e M a s k B a s e M a s k P o s i t i o n X P o s i t i o n Y P o s i t i o n Z G r o u p P o s i t i o n X G r o u p P o s i t i o n Y G r o u p P o s i t i o n Z V e l o c i t y X V e l o c i t y Y V e l o c i t y Z !A n g u l a r V e l o c i t y X !A n g u l a r V e l o c i t y Y !A n g u l a r V e l o c i t y Z A c c e l e r a t i o n X A c c e l e r a t i o n Y A c c e l e r a t i o n Z R o t a t i o n X R o t a t i o n Y R o t a t i o n Z R o t a t i o n W !S i t T a r g e t O f f s e t X !S i t T a r g e t O f f s e t Y !S i t T a r g e t O f f s e t Z !S i t T a r g e t O r i e n t W !S i t T a r g e t O r i e n t X !S i t T a r g e t O r i e n t Y !S i t T a r g e t O r i e n t Z P a y P r i c e P a y B u t t o n 1 P a y B u t t o n 2 P a y B u t t o n 3 P a y B u t t o n 4 L o o p e d S o u n d L o o p e d S o u n d G a i n !T e x t u r e A n i m a t i o n P a r t i c l e S y s t e m
O m e g a X
O m e g a Y
O m e g a Z !C a m e r a E y e O f f s e t X !C a m e r a E y e O f f s e t Y !C a m e r a E y e O f f s e t Z C a m e r a A t O f f s e t X C a m e r a A t O f f s e t Y C a m e r a A t O f f s e t Z F o r c e M o u s e l o o k S c r i p t A c c e s s P i n A l l o w e d D r o p D i e A t E d g e S a l e P r i c e S a l e T y p e C l i c k A c t i o n M a t e r i a l C o l l i s i o n S o u n d )C o l l i s i o n S o u n d V o l u m e V o l u m e D e t e c t S h a p e
S c a l e X
S c a l e Y
S c a l e Z P C o d e P a t h B e g i n P a t h E n d P a t h S c a l e X P a t h S c a l e Y P a t h S h e a r X P a t h S h e a r Y P a t h S k e w P a t h C u r v e !P a t h R a d i u s O f f s e t P a t h R e v o l u t i o n s P a t h T a p e r X P a t h T a p e r Y P a t h T w i s t P a t h T w i s t B e g i n P r o f i l e B e g i n P r o f i l e E n d P r o f i l e C u r v e P r o f i l e H o l l o w S t a t e T e x t u r e E x t r a P a r a m s
i t e m I D
p r i m I D d e s c r i p t i o n c r e a t o r I D o w n e r I D l a s t O w n e r I D n e x t P e r m i s s i o n s %c u r r e n t P e r m i s s i o n s b a s e P e r m i s s i o n s 'e v e r y o n e P e r m i s s i o n s !g r o u p P e r m i s s i o n s L o c a l L a n d I D
B i t m a p D e s c O w n e r U U I D I s G r o u p O w n e d A r e a A u c t i o n I D C a t e g o r y C l a i m D a t e C l a i m P r i c e G r o u p U U I D L a n d S t a t u s L a n d F l a g s L a n d i n g T y p e M e d i a A u t o S c a l e !M e d i a T e x t u r e U U I D M e d i a U R L M u s i c U R L P a s s H o u r s P a s s P r i c e S n a p s h o t U U I D U s e r L o c a t i o n X U s e r L o c a t i o n Y U s e r L o c a t i o n Z U s e r L o o k A t X U s e r L o o k A t Y U s e r L o o k A t Z A u t h b u y e r I D O t h e r C l e a n T i m e D w e l l L a n d U U I D A c c e s s U U I D r e g i o n U U I D b l o c k _ t e r r a f o r m b l o c k _ f l y a l l o w _ d a m a g e !r e s t r i c t _ p u s h i n g #a l l o w _ l a n d _ r e s e l l -a l l o w _ l a n d _ j o i n _ d i v i d e )b l o c k _ s h o w _ i n _ s e a r c h a g e n t _ l i m i t o b j e c t _ b o n u s m a t u r i t y d i s a b l e _ s c r i p t s %d i s a b l e _ c o l l i s i o n s d i s a b l e _ p h y s i c s #t e r r a i n _ t e x t u r e _ 1 #t e r r a i n _ t e x t u r e _ 2 #t e r r a i n _ t e x t u r e _ 3 #t e r r a i n _ t e x t u r e _ 4 e l e v a t i o n _ 1 _ n w e l e v a t i o n _ 2 _ n w e l e v a t i o n _ 1 _ n e e l e v a t i o n _ 2 _ n e e l e v a t i o n _ 1 _ s e e l e v a t i o n _ 2 _ s e e l e v a t i o n _ 1 _ s w e l e v a t i o n _ 2 _ s w w a t e r _ h e i g h t 't e r r a i n _ r a i s e _ l i m i t 't e r r a i n _ l o w e r _ l i m i t u s e _ e s t a t e _ s u n s a n d b o x s u n v e c t o r x s u n v e c t o r y s u n v e c t o r z f i x e d _ s u n s u n _ p o s i t i o n c o v e n a n t o[ P A R C E L ] : u n a b l e t o g e t p a r c e l t e l e h u b s e t t i n g s f o r { 1 } q[ R E G I O N D B ] : E n t e r e d S t o r e P r i m I n v e n t o r y w i t h p r i m I D { 0 } Id e l e t e f r o m p r i m s w h e r e U U I D = : U U I D !i t e m I D = : i t e m I D Yd e l e t e f r o m p r i m i t e m s w h e r e i t e m I D = : i t e m I D -r e g i o n U U I D = : r e g i o n U U I D Sd e l e t e f r o m p r i m s h a p e s w h e r e U U I D = : U U I D S q l i t e U s e r d a t a %[ S Q L i t e U s e r D a t a ] : EU R I = f i l e : u s e r p r o f i l e s . d b , v e r s i o n = 3 U s e r S t o r e 's e l e c t * f r o m u s e r s 1s e l e c t * f r o m u s e r a g e n t s s e l e c t a . o w n e r I D a s o w n e r I D , a . f r i e n d I D a s f r i e n d I D , a . f r i e n d P e r m s a s f r i e n d P e r m s , b . f r i e n d P e r m s a s o w n e r p e r m s , b . o w n e r I D a s f o w n e r I D , b . f r i e n d I D a s f f r i e n d I D f r o m u s e r f r i e n d s a s a , u s e r f r i e n d s a s b =s e l e c t * f r o m a v a t a r a p p e a r a n c e u s e r s u s e r a g e n t s u s e r f r i e n d s !a v a t a r a p p e a r a n c e s u r n a m e = ' %' a n d u s e r n a m e = ' s e l e c t * f r o m u s e r f r i e n d s w h e r e ( o w n e r I D = : o w n e r I D a n d f r i e n d I D = : f r i e n d I D ) o r ( o w n e r I D = : f r i e n d I D a n d f r i e n d I D = : o w n e r I D ) : o w n e r I D : f r i e n d I D i[ U S E R D B ] : E x c e p t i o n g e t t i n g f r i e n d s l i s t f o r u s e r : i n s e r t i n t o u s e r f r i e n d s ( o w n e r I D , f r i e n d I D , f r i e n d P e r m s ) v a l u e s ( : o w n e r I D , : f r i e n d I D , : p e r m s )
: p e r m s d e l e t e f r o m u s e r f r i e n d s w h e r e ( o w n e r I D = : o w n e r I D a n d f r i e n d I D = : f r i e n d I D ) o r ( o w n e r I D = : f r i e n d I D a n d f r i e n d I D = : o w n e r I D ) u p d a t e u s e r f r i e n d s s e t f r i e n d P e r m s = : p e r m s w h e r e o w n e r I D = : o w n e r I D a n d f r i e n d I D = : f r i e n d I D Es e l e c t a . f r i e n d I D , a . f r i e n d P e r m s , b . f r i e n d P e r m s f r o m u s e r f r i e n d s a s a , u s e r f r i e n d s a s b w h e r e a . o w n e r I D = : o w n e r I D a n d b . o w n e r I D = a . f r i e n d I D a n d b . f r i e n d I D = a . o w n e r I D a g e n t O n l i n e c u r r e n t H a n d l e s e l e c t * f r o m u s e r s w h e r e u s e r n a m e l i k e : u s e r n a m e a n d s u r n a m e l i k e : s u r n a m e : u s e r n a m e : s u r n a m e u s e r n a m e s u r n a m e s e l e c t * f r o m u s e r s w h e r e u s e r n a m e l i k e : u s e r n a m e o r s u r n a m e l i k e : s u r n a m e [ U S E R D B ] : U n a b l e t o s t o r e n e w w e b l o g i n k e y f o r n o n - e x i s t a n t u s e r s e l e c t * f r o m u s e r s w h e r e ( u s e r n a m e = : u s e r n a m e a n d s u r n a m e = : s u r n a m e ) [ U S E R D B ] : E x c e p t i o n s e a r c h i n g f o r u s e r ' s f i r s t a n d l a s t n a m e : E[ U S E R D B ] : S y n c i n g u s e r d a t a b a s e : u s e r s s t o r e d {[ U S E R D B ] : I g n o r i n g a d d s i n c e u s e r w i t h i d { 0 } a l r e a d y e x i s t s O[ U S E R D B ] : S y n c i n g u s e r a g e n t d a t a b a s e : a g e n t s s t o r e d ?[ A P P E A R A N C E ] G e t U s e r A p p e a r a n c e W[ A P P E A R A N C E ] C o u l d n o t f i n d a p p e a r a n c e f o r K[ A P P E A R A N C E ] a p p e a r a n c e f o u n d f o r { 0 } B o d y A s s e t B o d y I t e m S k i n I t e m S k i n A s s e t H a i r I t e m H a i r A s s e t E y e s I t e m E y e s A s s e t S h i r t I t e m S h i r t A s s e t P a n t s I t e m P a n t s A s s e t S h o e s I t e m S h o e s A s s e t S o c k s I t e m S o c k s A s s e t J a c k e t I t e m J a c k e t A s s e t G l o v e s I t e m G l o v e s A s s e t U n d e r S h i r t I t e m U n d e r S h i r t A s s e t U n d e r P a n t s I t e m U n d e r P a n t s A s s e t S k i r t I t e m S k i r t A s s e t V i s u a l P a r a m s
S e r i a l A v a t a r H e i g h t G[ A P P E A R A N C E ] a p p e a r a n c e s e t f o r { 0 } Q[ U S E R D B ] : C r e a t i n g U s e r A p p e a r a n c e F o r : Q[ U S E R D B ] : U p d a t i n g U s e r A p p e a r a n c e F o r : e m a i l p a s s w o r d H a s h p a s s w o r d S a l t h o m e R e g i o n X h o m e R e g i o n Y h o m e R e g i o n I D h o m e L o c a t i o n X h o m e L o c a t i o n Y h o m e L o c a t i o n Z h o m e L o o k A t X h o m e L o o k A t Y h o m e L o o k A t Z c r e a t e d l a s t L o g i n +r o o t I n v e n t o r y F o l d e r I D !u s e r I n v e n t o r y U R I u s e r A s s e t U R I !p r o f i l e C a n D o M a s k #p r o f i l e W a n t D o M a s k !p r o f i l e A b o u t T e x t !p r o f i l e F i r s t T e x t p r o f i l e I m a g e #p r o f i l e F i r s t I m a g e w e b L o g i n K e y u s e r F l a g s g o d L e v e l c u s t o m T y p e p a r t n e r a g e n t I P a g e n t P o r t s e s s i o n I D s e c u r e S e s s i o n I D r e g i o n I D l o g i n T i m e l o g o u t T i m e c u r r e n t R e g i o n c u r r e n t P o s X c u r r e n t P o s Y c u r r e n t P o s Z f r i e n d I D f r i e n d P e r m s o w n e r P e r m s d a t e t i m e s t a m p O w n e r c u r r e n t L o o k A t X c u r r e n t L o o k A t Y c u r r e n t L o o k A t Z Id e l e t e f r o m u s e r s w h e r e U U I D = : U U I D ]d e l e t e f r o m u s e r a g e n t s w h e r e U U I D = : P r o f i l e I D P r o f i l e I D Oo w n e r I D = : o w n e r I D a n d f r i e n d I D = : f r i e n d I D d e l e t e f r o m u s e r f r i e n d s w h e r e o w n e r I D = : o w n e r I D a n d f r i e n d I D = : f r i e n d I D O w n e r = : O w n e r _d e l e t e f r o m a v a t a r a p p e a r a n c e w h e r e O w n e r = : O w n e r z\V4
D&X!
! % ) - 8.V z\V4 =% 9 M UU Y Q Q y
U Q Q
Q Q Q ]
z\V4
QQQ
= 9 ۓ{O9 9 = 9= E A M QQ Y
QQ ]
YQQ
]QQa
QUU e e Q imi q mi
}
?_
:
Q
e ii
QQ Q Js e l e c t * f r o m a s s e t s w h e r e U U I D = : U U I D s e l e c t N a m e , D e s c r i p t i o n , T y p e , T e m p o r a r y , U U I D f r o m a s s e t s l i m i t : s t a r t , : c o u n t Fd e l e t e f r o m a s s e t s w h e r e U U I D = : U U I D i n s e r t i n t o a s s e t s ( U U I D , N a m e , D e s c r i p t i o n , T y p e , L o c a l , T e m p o r a r y , D a t a ) v a l u e s ( : U U I D , : N a m e , : D e s c r i p t i o n , : T y p e , : L o c a l , : T e m p o r a r y , : D a t a ) u p d a t e a s s e t s s e t N a m e = : N a m e , D e s c r i p t i o n = : D e s c r i p t i o n , T y p e = : T y p e , L o c a l = : L o c a l , T e m p o r a r y = : T e m p o r a r y , D a t a = : D a t a w h e r e U U I D = : U U I D (s e l e c t * f r o m a s s e t s 8s e l e c t * f r o m i n v e n t o r y i t e m s