g\J7`]aWm";v9ݙiXH/]V>y`ԶQ0;{F%k(
ծnT"ABۨ'G!6)LMV-f.G)~&>) D"/
ҰQzzqΜ5S%Fdjf@KuԃS2ްCQѬ=8k ?RSΤO6ztӯ C KE Lwk֮WZ*u `+һHbX#~-9kc["Aդ΅9<'~e,ġ5 jFYhgnI]\Z MϞ48!߽y>Ĩ ]0
8jS& FA&ɑ p>%~U(j]Q+)r:+ 2> 5mUf*dީͺ\4<% |,Pǁ 8 'ڼb
E~qfc Yj-T^:וֹ^k' DDh-CU@N 1WQ\lCՍbx#m1"G_9iп%M2KB!U + .W-xOòVJcMyX~
7p^u= 7xx 8p?ZMzۻ [5mmccmz5s>E=߽1#%:Ԥ66vDO}ϗ~*iS>.g8b{.~̩}slF
Yw.ȹL͆'74a&"CMH $ih1B$UX4f}ܳ@]~:x"rj[̪ko6(c7/&x̌2 ;rWUNT*qlyAkvQKh;sev4V+s]:ftgH@1v[ֱ|R宫D(bxʭ Lɝ zB+bNڸkv"R4@ D74Ef
?n(w'L]G+A5Dx
gg݇f1A TA$3P<~X2D 2M##}!FG;ݚUP.V,1 S9KB8YY ~w!z0qǩS-_by i"M8y0!o*|6jeW=9 9@6 T͂ɧ~E~~|pCSQbUw$q./@N`k]0 ҨG-F ź .2$|諺 VgXb
Hw59%[P0&[is4 dN38,zLx.4x^ܠgEil(jh 1բOHiY@únr,H _ oCKqN:^qA$ /MF)AU)H. T9Vj`[CN;uȰZx tuy BwJ6)nwˣ+!PzW
DV m4sLRd4ON0RBۍv>y,aclzi>/Wf̦k ۤ"άD*Fs닰=^\]D,L>oRw Cv;0bͼɉJ 6 Uzp^Ȳh4L8fjUǭ`\Dy03}ѻ,aźn^ܫO~wS/V_tmϾ_&O@1~ݙ^D[S\*Km
-F=٫W 0 "B1JF*?xl P>[-Mē7ND 2(۔}wgSXH#Q\EJ:2}o}qᵽyh<~]wεmkEfk`y[>u1JP6:N'Rڕ${b
si욾)k[xmlb&r'.QM?*)F"iұ.Srz&wݹ-q;WO?l_~3w
U#.be
Hި)s4мO T}B: K SFc3Bw>*f 2ƥN-ks_=t㽐'Ƨ@̳{Ktn)طct ;sjlw K B
욌
)^VyaYܻB9q Q\)4Uig_˶Kx{k: ^ȥa{:7N1=Zs-3kNԚ[Φ>ii%&t4|Uby xLCeY9,ӝYxi:)jtsͻ|^觅` G Э,D!B N v" Fg sԖ[MVMO]!Nm*n߹۸P0rFM[JBYqW7[qqߚ<3Z-yj\RJst&+Ҋ{fu;]3 5hUQ-8i1 @*ds'JʫO[Ό&yEjsmM˚w.&Jtz&b8sҲU.|qԫ1P|q^)0,<,hx-J&Zv P|4B[y68`uX+T.wx;^ S5Zݍ}L\$~RZ(yK]k
G4:Zy SJEi"gޏWŖY,>7kJRWܛs\ޮ}7> c voٞu٭k<
i<5lT ,E/_
**iR6j~>M R VLz1E| v8Q(_(x1ddN=?iԉ
X89=#|pfU" NrT8M̌ 4#֥lywJ [,Eqά
ato
T*9"HvE+bII+iRmZV 5nu<8Ėh3c
7
5.m;ж Kq~'F&zIq,~3ʯ6sgCSϝzUٱ"B4額f! (V9^?Lw1Vpp=m_;o=8p & .WfǪNish$r9oj &X Em98G4'l Tk.c9
fIe#ĩDymܢ`7UJNֽbn
s%IKrmӗ{>{G: G>0GF*D|" |)gٖگ;H'9(;m:tFmNѰtBtdgg z6yon)U #z{+ y=U3b喫#G/dU i?ۢq ?f<_.Eh:kr,N8';ä3gw*\5֡c6{~8עL4H$[ĸG (NaDA2!
=M5xaOrjxo;a#e`݅0+5#aMN%nf%Syii<[UJ㝘3EFxDE2h
C.q[ |XmIJJt~G,g ہ=xѻ%
)/`m1#xv
`pB. /XJ/M8>]7)3 8vQuk.CC#O۳(.S ,^ln=,p2'¿6<7/6YV7#|!n)X5I _4gU ̏? Iٸ WלJ
:IQc[4c5bZ8p5o2V8:kV*[mP`WssOm<
}& J
A>y?aKV|'aI ܶ7<:p[ l!"ٽ}pb*Ё(+jF*WѥIl%ІjUM182j~|N0۟
4^+\!"x^uʫ(Ly !WMRWԶ!S&!I- (vjxn1]_s9WLjz Ip;ms֚
+?QoXseb,QZ7c69@ mz
vW3;Y/HbI<~ڱeU`7"ux&]<ϋt\|; zT|3ľE8P\vHdȚJd$e,]g.@~D"ۖ-u3qV:vz.N3MLv6XJ*X=ݏSuX7{MpF
_Wɳ&V̳PKxz ~x x{ =e(SJ!{k[^,f]Iv x`=^)]t{Ezcwl?Ŧ4jgK[]{تwV-zŹw꯳Qy !3%rL
x]rx"Q(_PkvyVv< (G讎K &[k'|
r
Sx C#N5Yh-Z"W{
W$dkm ɽM.W5!]`?n)]4qޏ`:&IUl JKN"y{uxN)#F2@yf"pClc2픾 ggM KErJ
yu7Gޚ2hm7jBZx#>VN 8]EwKʑ]y[\csEO K:/s6겫+M*ʞ W55w5nԭZ+*Z#N[wXr*SqQ}8{.*C"8Оc(8ٸg<yvZ#·E kqJgGs|KBkh1
ۓ ku /rWd GIŰ-29e0K E2Q}1zUUGl+ ,KS, 5-\w!YijQ}χ(H93W`M,z@BSK,. $jq{YI-I<.uxLrnfR4w 3ޠާZeG'& )/E^Hu&wg#B 2L:;=mm (T[;iv+9C:|qޗʱSϔ⮞bE kwO'=b\Zn:kmk\}tZV-%(J9Ute _KutezAjP`)0@Æ ])@sd! 0%$.w
qf1v7h+ [-> XM a =XZ!l:HNMuO§)JtctOiEWXq) Ԧ rQm bo
DN {#9:_|v=tj
|Q3"/zo9BKMhg n$vGƯ]&[n匞֯+<ŪƟyC1
!C<˞ϵzɮz`R < Wt_%.#E
l劥HTdew~~gKcz?$n\ڻ}9."\2yVUHr= y uDb,{x2N&}$완
F!̫yRD oanW{BQ, 2 :=]wG4!!lrìy29<<\`L @XRDh ׅM
"&
ƕo8b)|> -O*E͢*ӝNtҮ-SIDmIN7V״Ix^^&FKqyM?LkO?ѯ3f}>F,%!ȴK
ؘ$ ==̛]ǧɧ!Żp!zS͒C:{ ϱ˲ZP
:D1wN)wpT,*81 dYfhfS6todbH|v_Sʽ` /hW>|k>!ȖtbijUUUN)'gnic!e qBv a o nd 3agmƭ`# 3ʺ-RlSqs,{'>C3vSCS>V9' CmuDl{bC2sz
6s7x.`
9H7\Az~=eQYIʼn Iz}VҲqa}2:= J ؈ϼbY|ݶ
Zrl,GOp7D 6L[(.C{o,rZϝnp＄,DFd}<ۺwL^ۈ 7M|t Y
*þU#np>ݑ"rH8U5wIV q Nխ-nq
W
tp
<2d@؞ՍL"KDby6L;J ?JXҝ#$R ;&
R ݟ'r퓞LɎ +"!+kVO8*B0Ԏ wvdTB6C3`ÙӤݥVH skWBႌ ́& ;q;Vwy3kuy-))\W+8Ѭkg6z-^LzgnAW2
Q^aZa><+`DSF
`" gI+҈G%_ A|b!ؔD|༠KAAء_~LU"|e.m CdF{X0`0 x2C X
zĹ1?toۋ劧O%4SQ\ڻ]TmbN:~h[Po_7Fju5Q2)/L~ x]_@sJ<-eo Kߟ)Zg|އ~;rZ۳0S`.;~O~6cn L Md.:ߩ9ibޡ0@BL&d nO4\Љ~J
="m-L*5IEm}ʲ<;ŵgRtk9sçVE/J9QJ yHdP o-JޭX$x[#$܍߸|>>l K ݞZV9gʛerKlb `zʀ 8[HI7aZ &yqWNYU,e7% |21CYx"8Z8tȻiW^%}m|^U\vN+ZߟNyf7MwӌdeIX4"wĜ( y^"r[L`,[X4B1>[Ȳ5nb"C:\ޡ"+ͣ','p-
7ktO=m z&bcljd
gtFپWWIKAkg8> )`OFVWC},` S j^%LN^Q^Y*>I/sk+JN g խГ>+LBN{)\S&e`h.VnWq k_KyW5'[8*-rZ
kL4l*G0rLۻ(ԝ+{'um"MuG:=7ZϺKu_M7k@kթt5D-^xR
-i7N3NjDV#|d\w'``[lNe1E{wQдn.eR68FbszMR
P6E$5a;_u-h3 e=b 9 f$@FvR3vO[kS(uzmŇfzr7tCLY< z55r; UޫWgďm4Ԥ$jmUCw_[Q"==JycmezNt Hf}qc~\^ҦS$cR{5ɍv#$cX-۸p#&_kzj
-) i Wף-
.dpg._GIgbWRb^O V\Z2^w?G'H>*VM2j+gV-R+u4I`SѦIU$ ЕGck+k_TEb ώ|褑4R
LU!ʴO kZg߱N7br;vMU'Lr[^ $
HdOOZUTm洭t\rw"rO Pz^gzJl-Vu3b81ˈ.37߸ŀ`ά_1rM|B}#z_;y%{8g|CFĪa m?0ZH|@HzÃ9/q$ b/;bDD(,V*qZ;C ©
L `]mSsγ4R0u(N tۏ"mo:naOmShlՄ7KKW|> E\'5vm7G}9uG[4 =ف\7;q7w/gT3I5`IfyFT1ah앰P\% F
=t3Z/UYrr!!.LzW>DBǧ^棧؇>[(#nqiǞa 0Ȏ in{hB z>r5(z#:&v]_z/:~~3,*b9v6ߞg N:"p! jf]H_YNaTgza|?> zJ q/yz-IPߟO|W?`xS;O+>vMw0R [> *n7.XetN'=HlzndiGbE[54
Ch|_4k
kۓ|c M7^Gi }2/E&ͽ7@4ďHV^lU\+AR?]lIOYûOt 2y8smGt\9'HP 7ж" Quafs .LH[9ҸhS[lKk!h*ȅ4אAQM|]vԵ:-mD
"+¥zo鞜Jl|BIQ.TΑa]7p Z]4Ikisot&~ .VwI[*\-71^ ^ׄgԒnpM;o\yzt-ΖRS@xF_}OP+y; "3=Gu:jzg]ݾ}rXrm4(-i[ 7Eqi<& D0+Y6}F,rgdzB 4c,ݿJ"G h,sݛD ^Ijc_yuF. ̽7]@>$a"уibȟ4N|"NUP*GNB0QɇRK
:f: Ѡ ח6) F]WOdk!^%k<'/Ӌ2:#6B/^, &: ֖
y\w>RYá,{c̾܍PM Ƙ\)A
R
S 8Gy4|gڬcՂb. B\PRF ? 6##}HDoyZ}es[ `Z
:a[e˂T%;ܜB(\.`|S*/Kw?l<ګhx'WEV4 m!bnNPؔd!:&(q,C XϞ#?٪1 uXc\UrpPa q}J!zXDHw($HL&%M -I .i+ sM$ 1/%eN 9%3K u%Vh]xppv楅ˉ
{r x{4izс&l9}= */łY -V FE#^UB 'yPޓ!@+zE.5je0
. U>NʼCƦk)EQ n°(0nAяo }0"h34P]]_ű&I 3SF xh&Zۈ.o N/5g9/4 It AhHB E, w!X}3Jf|rAQ&hå)Nb^3PS> `I Yφ:t(b(ň(gFN(wfv8>$*JWJ-.J=ag#VJ}wA,ZQdr-KPpuw!ATRt$#"f3Y<)6_.< N% x zwM)B4ؼ Jp2) E3dM.TXiJV G+ tg>=o3=0o#dz&Y>A*Lդ/vϥ8FX}|g4 D _we[`[jjiUMηք ӑF,*-SLK(a=5)w9s\WeH]X}D0Ʊω 3}ƨ Ǻqu?72 o6TхM8CI^I{^6d
LZDaMgɒD;NkyYkT5ݗoR
cͰ7?'~`o5:aZִ nkt&=V6 ]W6P̵5ڸ^m39wš4Laf6:*?]oB8-^jJI:~HO DوB:?2z7_*D"( sz%/M7<9ˬnVsLlcL0B=c
|v฿BU*R8yi xwj?#K)@+ч&|oVM:o(6M t) UiMXg5k8ϪD ^ [=|1A}^J
S >?nJ) uݯ)۞2DhaZ
0i~Noe1[u,+FLn4ŗudFNwkB:+OGثθҵHa;b992}ِvf._{7F1 xze-5|y$ENWkGYۍ kl¹97n_j[St@PiNg(=\|·u,e6:)_9H@PlH#HmQa:PFWuИ58Ge2mVo0ҍ```$-oDNq \s :MɴBzSM H1]CӥNe5+73a6?1k
Q`P k5Ca6r:s}}+t$ 5BnP
( AуVٷ{^qahiL2b K 7Q.2y>R/I?ve=&-:HX˭o8POWgHS57V8L|= Ow{W%jT8^R= ,2p;byfL`rSum?IA(ҙ~V vz5aܕ00F
AO\Uq
鹇4U(%^H }+9A
ѵ0 ڳ PGL_7(l4+tܸ@U&h LMVE
^+v%֗0IRYqL l=R7ZMb O
ߖMTsӻ|)y9!'5
mB tlr8C`}M*Xv߸żbX҅QMuQ^'?
RrY:[n8 6Cte au(ekܥn$416q" |UhPP 141:x˒+"W:
~S)A{ ۗ!!giԔ0PX1 --)ˑ7r p(* \5syŜgRaL& v|X!j,ɤCP9LtPl M8>Q@ A2E8Y4!)T* 6X ,5AU
DՔaS PR(D-,"-jĊF1
U(LQV-@wa!QH?˪Y:IڛFl'%Uz"
υ8rDF;Ν,0
BYɆ;᱀T{\n5Q=yo 8 OKCӵγ05
LjaOWQ =s rA23L ,IRV~Bj䵿3a2jU"bjgy rO=.}0tY(0T)RhHg$i )(&]w>dgW s)
y Xhd&$!)
HMCTiW]| y3{|hwOF~#/T?9 mJAs"Ӊ 4lj͉=I07?~O6,=d= ǚol\^p{G|tSƯo]눈xP) wAJ&T;|+=&'?iCdLM4<ؤPh;8ȝto79>aԦSdT !*f]J!xd7?LBsJMt+a͟ 3k@z06%d]Ro:.BBF"Q?W _54v)(_m` J!a2i1+Q/Y%6K b\V-dLy2SALXt>͏g[92s.b=([۴oO8 .`6Yi$Zcl= 6_{ ,Yq[KLPƝGG9Gv [C32 !
66k mO[ސ!80v f4|~wv+DDzH._7^NaS:C
w`ks < =ٙhI66ƞ?IIKˈUk 5;I>6ǚ(z"%oCop=ko֙ǴjVQ7u \8D336kT il ^ًC\D~Gk3:oEHE.H0Dsm% x
R ;~,nFT4 t`:RY~3mȘ9ܻqà7$=a",.K%Uj sTrH#kEI h-$4V\͓N5@@]4tbmIPk /s(b\q$`~aO'ĻlvwEGA vB7(,ҒǏ ߍkM
Rx2刂_*NmPeQ >Q
$>'H79-dΠƈ./" NZ=Jg(soz+uΚ5huKm3Csoc 6x^}bTs\]AX!jsz 0 bk%N
{
FP%0 q2zL,% 2e6
.$U#Nf;߲E5 Q'
vNIÝj?T%x"X -ҵ8سQ yxDu㞱 } \qhɚ4ڑ5Uq]SsDwl zTW_)y?`%֚)Aܻjɢl'EL)H1 Ӕ WUV[B0P&-=6r(O߂;akrs36sA8U'! @2ț2k6=.
1 S#m2p+LmLd+rswgcsMug:R
WȆ7f{OKcHrT/0Ta1iPޡAGHyR3L7d $R P5.lΩM`<]6HlP/1a-.2Ýr}d峒qO@|^f)M ⽆|x H \oF#UtX L@rjygS)A-/V{# ~"cWGqoiGx2Z^<<@e1z rR ,.| _ǿ y2&>!Nz(Fp(g>xຯ*6T!v+3=(QBwTP(؇FDzcx%H4Pk{l`tNzDoP1`
e;_ٽhgvq)1XZʇ1묲N j .\R?EA: 2tD]ጏe Zz7a:1,s]ܚOm;bʾ+ ?oE`w|5 8ב"_ġB-V<ȟ9#^2y}e*W#j \K;+>i~=Kt)SDSmv}K?߶9,M( ԏXC4H>.R^ /`:]X<A9jc g?q (ٖ;U+܁ *6z .L.p]U%
t82iClo:}ޓb~ *ƣ%$,28ilH ˡXv$0FN $m^D vGo
1.LMmw{.X|\TL~F|\W m2bmȣ9'n-V6c_,zE~8%IE)kb@YVd57as=$Vm_M+6+GdC$Q 2*:kL*CrP AƿJFc,,Gch)OBVQ(&D,sB C^{8xDi_
7_n1SDAUo<t9Uee*Dl*Y' IZAܧn )9ޛURM4|c83mƤ PU"IJC?92DUbG&Qx@C80X0.e@;
ArXr*=C ?+W:&5
j GaA"s[^z vO¼d u%1h/U7MUW2kaG]e=W `Z@.tIqޕoUE4F?P] kXi^0katᕇԒpWpĂ 5`6j>Y fϛ雌x
"S泋)9lM;躪TQ8 C7BtQpww+x] ~і{1V:B0#oؚ=dZshZ(<5bڞ[4@K)
4#sVLL.䢀"@R=x'@ ,쫨vt]쏒2d{wgaIZIՋEܣ x t%E0 z>fg','s om :RzKEq1PWFuC{BAլN;ulrg{A.$wS25*/@ &
οk( WQ0ixEt-=i@SRmNHSzA 2
Al< Ȩ\T"cW&
X xrhoi^p +yp+=[zld6(a+3>^w6`Bc(ȱi|7Xok#U
e'Mm}}fHǗb8AЉ} =݉:
s@%03a`湷F4i~#sV1ьEW<;ӹ:xO8u;E ]}ޒ/KR(,IQV#C)Mg9>CاQP; qXaJ8)%MVVu۞
g 'J]V}@agX Fesn|8v |B~]Z(6 JR[XtiknSڅxOJO29>\<2i2=(W"rsG :-j,-.KŅNf2d XVH16TGvQ9
̘` /$ƆJ#< Hx%tf >z촳>0Xw: JM`aEɤ)5IȮwr%R"5%) .yU/O=b`xIG?~ R] Qg&#f1ZmP'kcƉ ̥9\*~ih7mxb^Cn_x@GD'W ` `J@y9 @tAP$`?8gu}+ ?cS!O1חw FyI؋1H%"!tw"Y$~ תy?btQ~b0T_R.c!3̊j: EcitJJؾME fՀ21MOiZ ^zNxE}nOo=5w;-n7 ! ~HB
?Gw |' 1YƖ >1 to)'DsLū>Ylŝ3#_; ~4>(^k$%% BQ'_ e,GfRhUz>R(j$g
wiprķC/ {i ϵL02|k܈Eq6Me$ g@
svOdfkئ4dw_Y8ދa/(7ccccgʈAJ+o{lyq/+ χV~T&z")P& Fo_XvkDtY xD]!+|ٚ;19(Ns:
$ki$
BA?&R0z* ejӓ]THwZ)SJ U=C 1%Akf4}CP`61
? W3[?0=wA}r: $z6<ڕ,MZ%*~:АIXhx(EӵjMvP}zxLŭZ̀~g$~
E `] {=S%Fw(2 'եU?hPIB\i9Aű%ClKH7)q$W*2s5-x(ưުoX͘+sBXU`q73y 22}`/ZIZY$,-\y < F-"L?^S(^b.#T!.ۻl
'jL >Ff$l~b"f1f /)Y~۠84U 0&U~|g YaqP$v1{4>R%i]4ޡln k'eH 1OG.v:֮3-B`/p$%hҴ: ^Gt``ZM<W9]@G8٭3u+S 64LML+5Nc
L_4x`mOEgM8=<W^N{oxO x eol$K2ju6to'yl9SVlvi G`$īF
puDuFmbw"e>m
{Xa=r䃑یߎA~ߑ C "d=Az6m~ek EM0W3ڎе`W 1OV/JRh>TV(3n(483A1@;!Nd'Q `T.EP=cǙ;VReXf xuQB+ tH0KȡmQYo娿=Y< q.%sS8Lc%O YQhc@xcӇ @ Q/a~7 KN:22OI[h{zKx=wι i{q&חX]c05yְEN@ˡMl& ˱0ǻȑٰ680Mȷ~f\jLqOym? qn.m·a^2ӻL, ႜnD;|M]r4[]em uɏgo_{"J;oS+8 av1
)CCņݏGBNlE;D n ݅0 M}x} ; | uW)a|V:s
hT 6nŒC}lZ2[Hdm?4̎^+ҘXfA&0Shh\ޑӹ /b#Dы=X!-FgK@b7(߈8+Ypz=<+e
Loe3X
pTs(~qãڨdqG!f@E9Fe<Ҍn2 vYSMk]#o"-Rҟ(\a 47÷;8w"2l^>"%qͼm]\Ukv=/Ч`i2b#=Ȥoa!,0IddC D{Z=;~%ik sEV[y TU(D4|XE,;rشӆ63[2 xݵ5Rd}-3T͋-#V;Uxx9ܬ\WjlyX nM* 8[EzpH4 BakÒ ?C )E>ٸ@DMi4}5ϝ<&{zt X5V&-ghd**]˹e St 4}k[I7ɱpnԓ9`3onIE1҈L7FȺa0(aTcH3V?q#c6Qkı̎
(1R5_V; G]"EAN,Rr2oW66<$7
XX7JA:dXzB raB2rGgfӞI{`^ee|(wjj9]压N7js
G:6 \
B _!Ů9v.z~/s{SÝC5|}I`q%2Td{">Hj!6:{OZ:7@ 1q 6155CwP.AFdm Nő~M]=t, dVh`/tr
F+e>ߎܖ0( T O3ěn[^nm'N,}Uǻw% :ND<# )C`su3AJ^z ӆ 2hN~szA[Tz֍4(@0cU
M{S3$ EvM~>`l+T;5p8Zqjyliu
GG-,`(crtdóT`mA;zQnRNFR?'nrs s"(6#X0Ē(簓$XAVI
7J,E)Ք7 s@jƴ
RO
VE7Y sNW6EDTkƝInD0Hi[T}_ ƾ0/>#v# gqr
wgLͰ\~ud3| /ȸܖsx
pua>A=l=}@602f,,homq 9ymR^JS+S.(dU$
ÓvkhЈ~1Ffߘ꽡?H`QiC Ƒ :3,'p(
.7yD^q`Cr8L~)yGz{atFPكԣla؉u62äO&JҧGоx3d/9s9u݉Զ-G|IeYes9s9s9s9s9s9skZֵkZֵkZֵkZֵkZ֨@",s}߶}fy L$x:ԓ zVZߏ~7~v|"y8GN חaXq@%m9`R 4Gɝ#ݔY;s'QQz 5ų1%1H|."as_P.֦{ꭞuJT C&2@LdviU9A jbHس i72`'X wZsfS Xt[fWo:e0Msn (͌x7S5rhL7*2:B=+d'WH,*3 yXSj+% 8HRs6l$[p{@V$+xuuQ z2 Hn Jf6۽
3'&)h}{EP]?|֯w[c# ? }<[A\IDPCd.8=ܵ/M ~C20QٶA?;AAۙ+ҹp8=~.ԅn+`Ŀw>?."D{)Z
?oS Y9:y7m!V>fe~lh( PBoȮ 0^3/ T29!Tax8ЁvDc x? b9EoH9 {]y2̘?w4"!Fz<(Iu-6<9Fz7#r\QY~ > RByJ)e9eU g1/\u%!>I0z*hľ| x1EleS뿬`.ݲAt!A283i苡@14.~uNg?xJĝB8>RD! [MCNy^To Ye(Qm};5 &1
(TDž5a!uJ ڻRT!5!5GU?F Q2u]ƕbJ odȣ"83SBPCoRHύ c1 AHS9
bZV(иnxXgG+YuȈZ+AUQԨYJZ)VIF@*N$w aq`OUS괦 'dHQk>6}6 qV2Xu5BҦc^5O("6ƊIJJk3/HmrX@Hj5 d>uտbdM XH
W(7 f"(I2%D"_{RHgg.:m 8 Ikts
I{6 sCfb3a9
s !J!a*B "xvznA屏|0@21Ƣ;1=uU:kZ0!
H]3㥕V>dU֫u3bI/ijyn -Fè[t||AZ
O3kbd zA S=e{=B~Fm= {FW_}gVwv;hN؎J GoRȦe؝(0% 1ʞ<]UPМmp+aZ! +GuC'0*(l V@R Л|M _WKgbOrla C/"N} "[jƪLθdQ l'
*\Ƞ4 n(S7g, hr0 M%sd;+UyeAA@((0LH֕O&.EZt/ i}BM IvJP4k!$
40S.0=_O+?MQS sX{#/S.ɰI+OӢA B0b2,
Bb9oݺ/W{hzgaA3au-IL5
]*O >GigSkra*h%yJL+R[>?a pjP͔8&RLmZqQY';I/C35^ n]e0a1Ayկ(/AD`.(L/rhLԪZY"XGU#3Hq=bi 8&0.y LGU9 /ޮnd ȧYB]T|ǃDץŎFh o{bVE9_<^ZBŏ>Uwo_?W Ѣu cd =SRl)cۚ:އl;
2VRJ%uy{ϮfAH| ?}j7h۶Z?5$V(
JUו!
Za1&xZ;?~Z-@7_4ۄq 7(\H AsA-&YaOB=LnD\gotB:qH*'y0."װ[ 9ڂ_ W ٞohx)%a^!u9.xWx%@cSͩx v5,ԙD@p(qmrA%2IRYfhf1Y-$ PU -1_QRZDEG
6ehƥt9C*2D`? cZqt{)a (*dđb
5<;GHny,@S'SľW{)QZck J]Rh|g-9'( YX
tǕ@}A }H%fuGG-@p萡Rb1l)z: WŞh
jO2h#3( ЊU> 7Iv, ե.<ɋŚ(msK3x ~b tGW2BU ?rr5d_=RscyhM3h.c P1Mw bsb=%elҋ+ $Ȓ3*@T* ?D#_wW8JbݿiW:m8dN d
Ɯp>?5Q0J˧(K]ԥ U̩BmD"[ed[?<|h#~%;Zi ֑aC3
XLut( ?ޗlJt']xy֧io*FQџYc [Agd!|A)ږo{PpCκQ2#Eסah+GI0b (\ q
(@[ -kqx$45U,}{J'a]WyFLZ*ujb.Zپ~Gpފ'߫8P,= aLeNf:(62Ky(_7/ߣTwx0݁ԐSeOkxݾq5':̖}`3l؝, ;}c.x[MUFIAy)?z 4 FSBa`M0HM0p ~ӛ* {VT
L d֧`R?p:Mf ;>3=[ė{E<,a˪ux M|eI z==c=HfdddX1zOVbS 0)u^9Vǒ7Kdt5On?<;GMڇ]ZdE`(,N$b0gw r&;ֻg:}*Q<>OIu;ej;L\YyDy g@ö
\v]wmlFXN HUѧW^u5v{&'3 MiHE=+g(+'ϳPtݶOt^su;We=^*2{wfԾ,~g&o}9Rԓ,A0G¼A9^[^.OlYk=2*V# Y{0YS 9|Rz= +SVx^2l iµk4+ZZ!i7>'u :K쭔F#ZƖ4) XV`@QnJ ~k%L`s| `:v[I |W|oD컣낫d*cF\E 0UB 74n͵KO$ba[(s
}_ 51t f77^}\ftv,e(,6atmC{9;痐⛌荗92'A$tC&]NMڔ=Q"t]`X܄adot R lIʊ
ArJupFd8|6a)iC$6n#(]klO`b][nR`sa6GЁP lW
Yq;<}^o[ Mrz^}p7_0=zE "!ӥX.Tkn`AF&HB؏e ez6J?!DYx I)C ~1@mIbF~ *W -LY0(d!x f~t6"u0[Ѐ=C X\:uY DJj3M]i)!c]ŇѰwv}o=n;G 3qĉ?f-mSs0DWSd7geXO0 ^*&=h9Qʤf͛$=-ڭfަے H]hs6 ! - %
+^12(emNZ6ؐ¢"v9U8}'
HMȇuUq#jd3=[6a VD3{u}E;*'}f:*hY/Y(0#ČL5fiI* I&46
0J RgP&j!6YE) -k8_=űmˋ%K %rYy/Afm9O9mfq6+ G(Θ;%! Lc(,KFX|6
2˷ÑSK20X] &}>N,;̃'NʧGTכܾS첦-1MO@nX 2ĭ..;;k #3?>oEyO+DT!8QKφPC?+vdgcUzN-X6flaMl{#n_3
MsyA R;i}(`!p[- ?{Eʮ;C1 $ #h!Ê'Į~L款wD#}9BpV~g6dYRdm~K-\h|6=*x`eI ˅M?'vuQ^&6jz>kai1`|4Iv8]Ȟ?(q`50~چX _Gcx: ,UAipO߆A8,~qX(ސ2d:'!=0xPP{vϒw.U BK5$%Չ#: '^b? tgy|Ot*&< "^5Z*V2P=NN~055bz0ެWndDWvb.x'Q\a%X_B˰kXɛ45hⷐIc őd de & ^*'ġ-TY#男x, (tCUqL8=( u;FN; OH=
^B y m|A.9{tXDS`6Do< WD!lg|&~: v-2h ltн ME+%g] OtUO=f7w^}] 3r-g!5I4呒LDۡ,n\j*1
Z=3FH
;KT¶X4d A#*bdnJT0h\0DQޔaQH/
u:]"- FRV1ie8;lZ_2 #Z4\Ͷ7cCc2y
Jq?ٟCil{TxH FdW0)`$a\G8= fc.~UӟUyds g3tzp/ a~@1}k̓! 1we?|-A77XAf_c3zMu^4#8wb,A"j؊F
P m,JcP^T>B RUb)/+QV[aY !H!鞉LҤR+
;"IH&%zU~[H" 놱naHIZ
HQTHBHT|Z?(A-$B}LNETضhBPKׯ. 7H7H DdqfnqSiԉ(ܡ'S lT i UyL "h@_gLąp
Ζs"Q y5YmK4 iBd4bn"x+:0TL8 Sf։IJ̝>Ʋ1 +)aRe twXCD5\TjFBG-;T?\%L'NVDKp ߿^NK]uUc-Ig(BG*z̎P/ڂ xND :Wx%Н^;@B@BNs
W,$-a{ N#810@i=١_[ĉ$2 $5FJH2L!HC!À 64QDOkxM ͋ @ bg 1Ab N4恄ߞHr #
0L$~ iPۯ v|a9&ɀD NgݤDD~Jjͤ,q;g~3qd78-[2$&"1
`![TsWҘOLB*ȯf$5ζVHsƙq]g zv |`ys4_ވsx6[QPF:"Wb&[_ wtIZ\'
ݕ C Z}n|>FMRKA a,wV"? w
r30CJhA`2!Zj ` ̿ 0 A~>Kq0nq8,Ev"4&ʰ|?}X@E $F !h<p0z0aI^x'xoN ['5mLrm" i(s;ؗ[g\zED"]
Xv{ޱ= 黪ϡP%Sjaa E'})Kb,DqRM?kdt?uӇ0h: #r [:qe7Q ]6JF}OZf?#(ǣoN?yt4iUJ
c2Ӆ mj E> 65h AÕx{|GtG &ܤQww#ngRYb`C>7 yst0I=?RjrelJǜѴ$O)y1uJH/;TӦGʉd+?8~.NñQÃڄ&7✭?5u0n_bb D. C ,ch υ{^_?SJw ƝQW־(724BRJXݡ-32]]do~V .I~TJi&m. j kW3ho܉AR&tɥ=$ x ՃN.t. |xHAw_P>%Ҿ@8H:;Mɽ2hݩ*lXGib)ؿh u R+U0Q]+փ[ۏQci~g_ 6cyDWg;o~E=Qဓ2
ƥXF@:& LgMMM@-{3`nMZ"0T!J#lFn&➏(V uB ڢ0_ 4!}; hF 1X4s8>\SR L0&b`?0YX8Q#~e}mLFvo#PTrQ:b,֦ν٘";W ~ {ӵuE Un}JFr9ks[-F|TH]x'~0H}Jі;}6\#Bc} j9(ߓ턮;ۊ M{'yALf7QPt(U*s+֊&j߹uX$* ִ'6X<C^3WU{mj&fjltuU
'*`0B2g]i0#fN^vWu-R^"DloхQ
/Lh\^
ye*U;gd}cVʿbdM$%
hl*u^}2 ty .Iws;/*RE\cΑ-TWx#ou>JBHbHsͪR_aq_VA$@lvH,]~ M[XȩNz6 D!͖f5YEy>%OͿ3xjhV 'jfx""xC*In`мvᨀz)nݣ: ݢd + 2L*09[tz<GHk^
a ہ1s
z8i> qMW,{Ҁ
1D4Oi*lgfa<ХB vw>v^|湥0ۮwxt"!%iHmǛlKp&k\#1>SϭITj7c:"j*W?v̹.s3J9oS,Mƌ!$&6A ] ]>?ˀ.WL6CK8!.^wl=ʉ\㋗# Lo(q¥)*U IHIftLSZ wq kU!VQ-cFB_c黡FYF +T:`r!{ts _24'3}>vq_mR-}brt Q]` >>?EݔOΓYfa 5& w~Kh,)qjO)>t.8{]= nK]ML1/]7ځ qJ5XI]~ nO7
f} Eٝ#h]v QKZuJ?!pN:0~
UbbbGJQ}sQ N
)!$ֵ4 34^eŹb@6oƝbN: =%/=I
j?2wc.Cs. ,:/ IR7 DK`ɨ z2&UV2bɠ;6 c-*͆xk
ЯqO/ su/I/Xn@{m?YBy7>c ! RUQ馣9FQI\o"H+LNEH &qqF\ ͑ 1,Ř掫\4,(5D2B!O|S{Q kc]Lb/(/\KumXgxQ/F.ß\"Lag02Vy f`gxK ]^w tG/oK)Qz-&C=1Y6x,1IG bP:7p3͛j
MnbZY{~ tj EMu%'{6}&?rպEX2d_JLo<:O VI,
4bI W2q c)jz֢6=Kz5/B8
>h{|Cjֿ|! N`\>kȓa8HFJKRԊrTzAiȚ&Cru$ hV٥ m?EYqB\ds㓀ᒢ"o-WeG {a<p}-kb esՏBXWqFHi5̃k+J*KL}> :IDc2OZ $CsIC/=tZCu
E<x$u*mY m+/9 UT),wKw乎* X$ː4 )4 BFxhHMD0 Kki ;"!d 忬g?:֡Rƨf
[+8C
K;_xEcFxGu
Pl`Њ(|t5&Lj} VfK2:g)*$a*W $ڰJO{8Tr cHet@5-hά;^S-ÏU@ tusC'!/AAA6qBg Hq||Rln+W! >WأI m7[,_˩!Ksgz[$RpѦLf-f $2e0`ځ
Im[j?ḙ-E%k M665 .7x]l,Ȅ!s)"S-D˙өR L& 8CrVee0/f>͍vfkAe*C% ')|
`z )SMOD$Ssq/ЯokefRl"le)AA 7T: ^[Q`M,3VٔLb fCbuqZ=7-̀@la>G uN`o 0Ca
އxf[q #A01.r 76bl3o`r@
=T'Tҩ`h'\
.^xkXHIնF
*RbtjaѮ!H#&F]9L, &d Sm0Ұ-ERN`Y'φ`0La~HĎ=y~fb=pcN0Ca
5FCf Ǡd2ءGF,x.nm=B҂ ("w5ӻv`"AzPsT}/tw9:Vhkq3?wI!rfA~U?d ̍ZT8[wM{'; ȵI&@K)q:`Wn#*S i0F DvW^'BBd*"*K;w|~0`P4
kgHs A'>0q
J ~gGVg !=` 盇 Hru H\ Y,% ɼy<嘐37G"j.lht'YEQ{i
[O:4/~ﭞ~lk+Q^& Ma4
i$")AʼnK _Z1/@<8HB 7/Zgb)HF qq-Q)Bi6}~K|/ITa 9NF GA{LEp7J@`]w4sZsT',77/cۢXJ4Z꠵ Ӵznmi2>uf,`]z$_PD= vR ,2?Rߤ*2,A$8BHo[{&=M{H ?p \&J.sj- #/lL8ɸZ0sw Z~ΧjsEO$$&\;?*soMuEDL-/ \0
m}oԓ[K)$&VyC #eq6Ev iW :Bȷ=OJ!MY 64 fFrZnv[O((.A<| 2 G\e: nsCCǘ>^ A
+Q#m Z_딱 ^c 3ALȆKXPoό>7w8w"%7.ΰ4
@h (x8[ |\$NU$$q<{"yBCBD7\4r>{H{ -jim2%`c=,17'B S& )^˗
+ya{$
nL]J.. R
߉W%5[7ZuDZ* e(x?=PT TɵY[(
ߑSdamY.jPv+r{i%Yw'Y/\Ql"ӝMk%zCp4Zslji@b6` :C~ 3lS/>!ٴ_<3/uTV\પuQgf(CI<@ߛìPs`MI 9}ʣ$k,ߺ@ R 7?N z9J!mej3.,~ZhaTx8M|{Me~^z2F
RpǴ^`Ɨ uE{w o MΓc|Ks}7ğ; P+KKmG)4uOhoˀ O=:z0]}%h+`EdYB5Mb1|[2S"`Qu":Lf@ ^Eқ2b;>Hϧgz tE4T3""6* '?XϸxKhRH:慻I &4$xgBhH: 2 uca [T62%E< HsA|/]`oM;RF Ǟe@ X&N\űu
M%G)Ϊ)pqa *(OD`woO5|c{3qLФ[DsTj{]I^"""8k|Y2~ : Uo8P||Sq
# \nbjhx&#+eWzZQw(C <
r5sS~?n,p^ΜˌtFT
Xb|o])=gd>&㨬MvKx+%)/Ū!) ~B` ĝ0SfeZzm H.doMUH vf2[ ɩ:XNT|^-I̥ ʫh6v dekV!a E훸gqEq|>+G
ӗT81L3~-d BZkLb,A S23;{jHc O|:M7
Ǵ(uR\|xrlx\G?B"s.]: TIQ;ҭUW)Pq=- . [+cyѧ{_F 7S`> YaTdΦGK!8Q)a
x(0lŚGiG{%Dp6H(x( %<~-F-5UPHMTiZI!\}Vg{]ϮyQjdWJU*њ-ur럇 A>p-"εc@81)F c ) Q~,Q`]`_@- %{jHFqDFd j2e5Se 6jg%9y(? sqW6`uZV]I bi!M I;&@m$!~,__w#7.gNQ N7Bػ8dp
y Xp s&FhvEJ
Xi/ؕ 'J(֗loqZעt $fcfJN˩:KX3
(Gb8+Z^[Jw24Ld|Fs혁.'2i7&9XrVڃsJx_7xVws=M ״E PDC!@5 3=s~>%ny[¸~=t}7Gd"C*Pt { n? {EL}^J:{0Doīmp4<DTإ~)Dp2gO/cpv
03 ]:,WA26
G/K 59tfX^$al=4D@|pD< *N Ak F5E\rIZ4+ An-;
5y^eH55
RhAd0A CI yĸNss^Ưր67P@Mhi<߽PHr}?^B
q.C3Q\[/I>-# G
9?Azk 2ŻvYuQ6"ͨ-BؑT{(F|Pb:f~Q t? /R9G>/U o|`S#KKW:^$ ߏE.IwYgkX=xQb~H_䎫^|KZ0xWW셣B
-(ut61'Lö#O2 4&b
5١"?B5_ЌYsx)Lld[}9qV6[P4pdL؍n(n,{@ڙ)_< m n3,cjavys{Z)%!SOhuOF64#_@b<0>UݗuvA,X(1^V Jԧ4h= J7,}Σf,w?g͗=c I *î7a+Yh*hL|]JfS1 N)}h V!/?>ۥY u(!LtFaF
s:l?L_;W`;igbQ.ΡC &'m
ɀ( >W3E_}6~7ꂸ` }E*ZMgfFna\6(
7ii_wТdx\o҅ B
>u<3Ph ]e} ݛږO' p+z$d)B*< .Ǔ+3R]Zԩ' vw7 e5DDOz]QIE(c%Gk90n+ l)z4Jf̩ /ga'P6+G%+Z"`0` !3Gʦnū&kWry¶məc@s3ne\{YXsg(etAh.̖ ц~wW-K){Ff¸#Jg2i/ʯiJP=Y8\&en wuDJ J'0wX2e 9 &زΩX /Vsd03;$CY$8^3Z0\sE沺`~Knxn! c4Gr`) ڐVJ# ѶF,Ķ =iX7uY;ҍE9 anLy$.层LL ʹO}S3\,~]v8v?{;^aA8~)pR >o;;r7D\F52oСq%T4\з5E
;uiTi*zl3s4WؖgN8~] t|OzC8 *2bFJyF2
!=֟n`:p ] |$dIٍBF/(^̀zq&R / W dyZX )&Oc<4o&;q6ctޑlzkswl'^j >v8: &:CD`o@;7#jH05G&r@!8"8Y`ĬjYKR܌a}YLS%,bOY?Y9cv.Tc[eՐǁ1rSIaE"SbX%Ga}@x?uߎuY[Sagyٷx[v[%
f!m(w F*$K#Q{]vi{냓 1^{H4G+D?]/=\R aDxYe'eU .oLp0@◔RahZ!Nn?<_0bdʞ"$3\T`Vx&?53T&ÎG 0n%G }xtU W lV;iIj҂2F
0k4lk0QqQ0F30w[ƕ#kOH@Yo9FYW-"k)Vcت@*{9\ r^́PQI憹 OAe9(Ue/iF[3b4vH`m҈q ! :wIދx~X<4H;,>P
@Zp/
L$
*h/i? Yr4Q:D Ǡb[Lg)> jfg,Qډʭ[w) Ru6 :zMܷ\f]fA34iuƇƆ(}$I3xN&d#&
75?gx.ܿS~U4SGi^b!_҈ b :-a 붅V10s|,#m2'Bl@\\pOΕ x|Ed~'L'wܙ)df\^A wYs ^PhO1%4hE &BQ)r(|~][;BJ*JK$+k҆#
xI}-cOj$틤%9( &s;/@|cm9NIùI4jaLm@o/8 @ <~ TMVS ;"JԥDƢ-JSO d9z!cWKBL۠w|@#,ja8eL7~3jbe{0GMe]._HHHZ6#Z5 L4 3 flo3X3]]O65~lzJDW_ }LQ<=D eo[{'-odߊ ` 3jeb&B[mϝ^ 'mRNAmsV 2cp d MGG5-e
[V
4z >\o C- (2i:k+JW䉗Z M4 !^8ЩRpc;1wՆɀ赋k, 9 [6dy7_zcaQ@{GCR( ( TJy"aX cYvJpjߝ[/?зQI3@<ޫHZƪiڂo$~Wƅ"yQMpA.%2,X ERK{A(UO{ ̀\ń=':mr(8-n533NO04o|7RwíaJܦEkWwD9Np h^WWdóN @ܣk/Wa5Nh*̴Z$V/ j6$hղH к" (f,r'{9 )+j<#rX]Vܶ-<Na+/R t OsuܥNYTV_GuzD: ^GŜ נ@T`H <9S¨$$_s%z+Y+i\:1 ŔU:NQj-BRkU`[=Kg[DPx8
e`iSdA
%!Sh Uy7B.v*I4HU>)u3"kn
}u*0- pluloP( :õw؇!NfFݼ
)07Lo'>,@Fb%bB6E ⽸HwӮ[o/4
زvRf&)}/_Rޏ˩*TsV cu l{.S?X)Ndѽ/OV z' }4X1 l9 tISa")N߸x XzH f>{HıqOW .(:ϫ6=s0;FVzU]Ϸvf&ܮz!bV1"lm0;}?mx_3oWW\(-Vű9h0Ҝ(8Sg`3yW
XXϧV\>K,hz}Oa 1E~ u
7;* 'FYo5:-5"
p `w =?A7 e!_V eGO
ޏ:S=t(uNUL!UƯjT rIq@
s{mz|lmY
iCÚ'āQoRJ`LI2TWK9WyoȪ̂-W;j[
l~qνX%t@o9Axnqo3Fuҳ{=s{(X+zs/o1>)77MetÙ#]dzSkI tR)K{;W9AmXt<ũuJ֥G8T 47 _[wS8䀆DFA:EdU0Ȕ4k]x63-\X ({M?+)R>Xv0YMÛw}V9]Eߐܻg0k@ݷDt\JAc3TtF90?EC O ϢD
o(f F`L_;f͠_3Teu lXfm&Bd$ޒ0UXٞҳ4B´j !Z@xh$%4.+ k (Ap]=%_W\lWLe(^XlJ Cָ``͖vo wc" F6op\w"TWi͚uZZ{T*ճ24Э }^ TYszbѐh-C Hhz i1NiBsh
e x%\<=^Ţ'6Njq)kěޥHJps*֞641!=")(#R.p&x+)4z+7\B*zVE80Qd[:ܟ@ c_7ȯ@yRBĆ-mi!ZHKZ3MN1-3E@)JA λ8 < xQ^N=:~}Y>}(KAnv;8 , . q!!_ˋ 5UWpO|y^t=>ڈ4A
F ~;7vADU8`%r$fspPk (|T8AySElKJߣ_YEݍEOծ6q~ _[s%hY ^8L`!¼k~ad}/V?=ۍ U|Yx﹀ lV 1|5w͜yZ~fk~M
켩U 2?7Y:1\-|ꄝ.m9ՅuVogd&ޑ9
OY}VI: /ByW-BImBhP0~z;&Jh;"ff"O-*( }#}6?Y CM3OkGzdApc l>H&s&ּggǑw6ϯ$6 Z~mz_);)+I3Xj6&/Zr|br/oшë6{ޗiR?Eb8CN7-p}LXW;H\qa mSzDBcJ
CYRVrF"E ̧K
t}I; $xwh0,HsVɞڵ'j#MW/ooHM2Y5aVOWŽx)+Z8@;jdAu1Q#Pʩ:JWU48Exӄ;Ş? Vjw7N^L G&R{ bD#|(q7 :Π=ejP`:FOz?h>4283֦.k.vf1w=O_%9Ax _e?$\| UFGm#:ݏ&xB '*AY+Y'Bq}vQ)cZ)3md kƲ|P˰>p'U VU\ٷ%8&4&Lcex)1B6kOm:aH@@ o3+jh: %]=Cqnrhۑa UV`9 _;֫ Le7kMfl&u'&r6vr{
.*FH̢)ӄUfb]:b!at\[)dK)C9)qVhry 2cqG,l ˉ"`?@~_J
ĹB),2Xx
~^%y!Nw qd/{le=qՍ
;14 ir>:,V |*z_x.)ǩ\g1+8#)ס>*xLhe ֧QNrgŦI cBfd66"U|OQt3&$x/G
Cgs\|uOŒYR+O;@8K2rG 'XyX JrUbqoks1*wlidV#> AR>4ۢӡ}5#u9JËI6 V'`ু6sp 4A2ik'VN ??<`\T&1P2ޝBrX+ S-Ď(>lL2L^ P4 h :A P&fglb'E֩㠞 qs׃0&|_yEzc>>
+PU"q{uP҈d&?X R)p >Q`s'^5&|
4ᇑ
l+-NGi5i\+FAs g!v0M фeD<^\G*>CPق#(#%ZoDچm_QPJWXo+0 ]T=~ˏNUK(Y2(wE?-]SK
πS* f$K+IFȱ wyA6IX~~J-D)JRR=Phy"i{.hUףzg q0~C Iǵ,M.jZs}V⟞''L68?^
FF F#?TeߊdKfſ#iU?1zW9+)&?% 㮛=Bx< -Gbk|O?nq IJJa~! kh0yÛ@Dc2ĭ#X;VزņMc*XC\P͗DͭUΌ=2wd83@ڧiCJ6*zpnmWdN kmQIb$B7UOv>f'[KW,-3Xg X3 ,C=Қ~wcP5v$gTZHյ /h>-6e8s}>|ÿYϏ:C\ c5ؾ[Mq,t{ko G)BQ+džx@IwƊlUd9έd
uYF(Pa~zb旣!ɺO\"lK4g4yܝ1# =w@s-|/':D19A[QS "dt4+II' 8z1<4u5()DojByu
#sMt_)A4T*<
FB*Y{rиgpؖh "S}cZ8?;Nd=q 1f Y"|t'A 'npS(\СH2l?xRI-^_hŪY vUY5]\Vq" BKuESG5Pid+C)ItJ6=zk8u<1 @\|]E%rEnY ?uWY`I&+D~3.+|.s1I/;PNG#BCnQg` đeP% OCYeuZn9 !8/[lOpُZ#`kwEt?wk}r]XfX < %-V;:"Cآ~hGQ!!pΕ1HԱ)қM庹 8`h-uE$ ;? 8wSYՅz5(Nˏ{Dr|3 2Rm师/55y Mcy8Zy@[}YӑZ̻ؐfۖ? F(xzk-J>C)[.\j#|o F9 ojà"sܸl"j?|O;<~_F6 ,?Sy$/;z],$eQJ1NqGڛ@4}~g : Ot\ ;.ۏ}O k뵳ʔ4*z,]گ *Ah'Uó!ƥ$p@! |kgOPbYƲ4F/zE} ƽ.(D7Gd}^o] 9ϙ &iH?uA;>t`Z5R`I'4qi{)JR]|c]v?&C\{I?o ו1'
FAB2IN J(DԲE|Ez P~tSMZ?[e;V"9+*+f/ D57e9lzC K}9 Bd) 0'g :Ve*N( P"WS~">c]_ c]+bْ ٸ枟ZirȦ&]d6l^t t9xarlm~Ix}-Mr7}ޓ=՞3b]Wb x/B g niӳn>e3=ߺ=^I!BA
B'{?!X0;wVgECjgAA4 !k2'>qU=mGix\LGoUc(X:!tp|gu\xF_/rc "NתvuU
NRILu'LKcZ:?uDZ&cEAP`0 :Q&?܅Eep%D`&iG|~:֛|? QTX yJ[
o< :}< vVNIvTk/EJg N52,9ZᆖPS;=͓;|Рz7 *ʈ8nчwy,Iz[^ؿxx*ґ
"bLǤ Ԡn ]D3&\`^SFo9MF0JPe hoJ GI{M R[MZ91
ߏg|xޚ@ZL#*UtL&STxgqPd%IgE+UдMֻ*X ^3作pQ}Kyšܳقo,>̔h1. q_kri@ymN8꾷ƁC)܅֑ %U&Ͱ8hYbbqSp
ERI!է 7{>xt ͌Jv4]H3ܖ̧i2KNOwzmkw JR)4(~2 C _UtOAqP僯fo-RmZԩ y4Դs//~a|}I3BsoeVCMCvx_K{5y M'ny|O:D@]\?
SPw?f_3ڬC=e1D ɟ +.J"_V hߊK%R-{;Z"Z
i#1,ʒo*Ѧxq4O*/.%1NLu[kMޭ
d5>2
~,Mb,Z ]NdYKӋ7 *ŎO"KU䫊^|ePY+dU62H\: Vq Ψ-]>?*<˫LjfuhQvbhدljlpm:#wƿP L>?7@
1oN2AjU($NV%]C)n*`Aĥ:a? waݟ}|ޢx8ڃ]M?Rcb/9' u$wz'L=V c߉'+Y Y9~բ bD; 5Ro"E-f+_)YOH3:NM< P ^8d(e_ dh, lpqk kgX>/^b 3|49̔zE Īve ٞ;V|ͬnh bO#)ȼ!~5JIkVRJv<YsBaI!)Bv14V1ܒp`@1d %dLiAF3}Q9{^
yT[
d=OL
ø.%.h `W Ha=[(ty
~ʐ(\ZMC Au\f]/^;Q:z}`9.K%S¾6e=GS r 7ʶѠ-@Џv8hJVjX" ݠX:hc O~B@Xǰ䩳j~ؤip,{&ur&ḓJT@4zjpu; R OIdC>4"E'
TwIY V@^`҆ZCT4s
վU2*м|8uސ߄`WCӮ~iezާ;GX/=Sz> Ľ tmή"c]8
âQ>F&(uyFVR},YBg 1DɆ|O
a%ʊW}6HDZ!6;n^4~ gʓa˒Rͦ?1-0"X ̎q?FB
:.
4*#
8``&./7&۞Ň7D =T /c \'ݩӟ/ΚGa¡ ͻnCE_V
"t: 0vWJ4>@Dc˄e+ F6POB=mlSif=!8lP1V1z#E{ZQjOz)ȯ $r,#7];( أ>
48NT1fa
z{O!Rml9A KxiN7=d,됽OGߔ|5ˍ+%}5 @tkpuO=lFK(\]-O^}yWM o H fG .{ܬlB^0h"io}R)L}D}, -- r=yo-uN<S g6'wZiz7k6 {%A F'AĔl2+ST2SޥsދY]azd 3kp9KX[Yfao
hbze~g|xXQ ޖ#xnي+<*q{iU|&l%Pz}{sP`x9E1/rNG6 k?g?%̓LJ`gR.J]8/S&Ӈy>gjpmO?CJ)],Tϰ/u`)R 2'}L ! (^kuxg Ke `x$!|<ٕDƹ
A2hLDah gk@G7LK kvr]
?٥ ,3.GBcTTxR*r/-V+MʳB
&uCKxH=Am$8laS'(ѡ0_ % rJٝƀ~j&&'L]SKAɠaczQp2571sBHT^K91VѯkPE'8#WlT¡&
%Ttp8Ut'֎8bj,f
Ò22W-{U&:mA-"q!rkA[!y-9]rl
dָb XS)9AHPW%papD
h< ڬdE]\X!r5A=
^Ff^w1APƱo%?.iLa !5?
\~kE\q &+$X{Jν<~ҥKT
9n2"UaшO"$iO4ŹևV0Һ$+7v>hn ڥU]w.z'v|UZH,(zd}
I02I8~"tH9ӦsX YbIpᾛtBfI&I'~QX~w6kHCэ.*} 5:Ӱ XS~F=~)D;eSCi*7I0H= %,0ft4b &}у4aSYy2[ȏ<0iP#XdK Ǧ
K>-9jI U܁wE 8O4uShj4ޒW ]qR @vC9N@ ;FޭLxv*dE
.x*uOESmlo ![\E}l`6\
M/Jwϰ>grۡm՚r7|` ,k
(Gw+AA N@up
n ф
4?lE
3Lk q2Pц)AQfL)HP|H"ۛBt
OU嘍 [ : Q1gg#xR`͉. 1OprM@n抔)JWOaߴc_$zQ}.ϩy/)= Mk^xj>emzbbTk4
nGt3Pgj(a#ex*c?aǯ< 1 e &4pWR 6FPp!N>M/Pbi
u #| $&l40A
QO֎ͯyaym{YP3 0m>=]mS\')R[n/n2Z\Zփiu\RBt>,>I|p͛uό/J +5X$i J"AVG(Mq;x1ƙ{-Ϳu'7u(pssm|&UqM:W3zfkH>@À-Mq{`R#' ݩ @D @.hUbj
{tL+3hnW\" F%
? rMOFmL¥u>ajnP4 Qw`7m-YIj0 3cOV]?HWwL!\kǛL\yw)*$fY#Uŕs2ط57zj!15YE:D2A y#=
+Nm 2ߌ=_, . V{ܞ6n=}BY$ 4|vo%k:Kx6KG #ᡪ'f@ Иr^XAع4z~$rܯ6S7vL~T'?"z-h#/*b~*(G* rWz=}RA RƑ+'U60M&Q\]^8K%Eˀ}[Fhi'H9oW+l[:4ɰ*"0һr% u4
Ƥ_9_z|@5
4u2cvW
Ɍ uV\Pu 'Ҙ~sUqh0p)PE|{{`ⷛfPY(,Ιַo Np;+ٳ0%;"|
GC41 :8M鋤$BqEq:dewWJFfd=L% Ur )mC
h#џ3\'TgL0%Him
n SUc qI$s=_Zۭ,pxvP~#bI,_;\n@^``O|#5bI~]LOa=_ k{p[fxTEA"@+9AAaNzuْ/eʬ~̦1Fe^'yރx:U @|?4qTM2pI>QG/&pD|jT9X Iu{y \rɚq2=qޖMAT&y
H'TuI!bN Y.$v(_U`pҞC.o˳BݝM wn5Y?}F IOjeAMPb\6~- EPxx2rVWN_evēͺAI= l
cyl }.]Xފ 2R 1 'g;;x*?÷Z9|x b-i%c y
G<a8{fZWzEf&^~[ni"w$b`Tm̢ ߵ;neKQP18b"K%0 >| #
:2'Etk].}ZADN2[- wq~>G^S7iE\ZեޖŬ֖V┵0kffWUX^m%j&xZ(&VG"z}eڻQ-qCN1N*9nY[ k`3=nfG;}dq<[>(hnk
|li]s72f1֙>25]w֥ D+ƿ[b \-Նٗ vhA.eL!"UiP 3$:Sc_ nʛvP褯,F/(HJ%,34q\@\q+ʛߞEP Zz!'
YnFK~K\P> 6]4YUUW
l:d"^PoUS~sk]~h(9 >{UMQ;{A4փ^uB_r "-Jck}h
HM2Z ¬
Z~8X~9zs={%%tTΛk:;x#
QB;/ o'ފ' !*Ժ4{ O
@PX2x4bɣ
S4-8?;@j~E#nW #x&vGjJ˒ۛ doԫO6cs^F reC}46AymYA 4Q5MHX u:釬9Kų,A\;xn_c*oO s>KpWOGW<`
w+t$ i$>M@1&)< k/,)IѱG;XҰʋ]:ܥatl6cG;{T~:1g}_ٯC(} =$im%gKZ*E)3d*ޓDs+CuT5BB/zxԺ7<<@Yg0ęP@!aHovE q?zt Uvfɖ)N#C !mʈNIE/gY DwE S.24t8DM6tcr~lVs79{?/9 Y3`!{C$ps%69ֵB0kc{[N<)+Ԡ2P?f{ۢ(}bW]
(Dٲ >o Ŷޥz .Lr;02<Ľis dTz~}CaPtMl]˪jp530.xL$4DXl-
Q;'(q*"r(՟ڶ N
طd8jFqofדI=f*ME T ¶ YiW>5kOyRt UW\d(|
m;xe \a28 ;O XG+aJ9
UY+ k={p&a/R^9G5$(a2$}Uѿ>7{2o]ݝJ GyW 3$W{f̢?ܴo xnQO [z. Y ۽ x3Ϧ cRt.ؕp FN!R*w9O|x2[`ˣ=g+!!?tݖboP6Lԏ)MTzuܼh*q\!S:sD +4G% NZcba,ɐ9 FU1XxtYG?A8fݹeAl~vc%ey ۢ\/'MDWh qPmv2Z>$1
b&Y9ؿ >
\= D#5"}
58-Zf3& 3@d)7XÛRڜd
e>o բ!M;!ӣT}Rɪ'ku mO,&,ZrND
ӣy
[G 6pGBv-4y68QQAb cT,F 7w-}0C9# Zr,P
g6t+l8,Zik..i&ČvHe| y{9В]cfg'cݖ+*I"Ƕc8p1N <(Z;OAцq~ UT m? MsO>JA;8`Y
8.K1Z9Y<<\jTOl[f9MCrchD'ڗ
+U6љ1!Fj~'"퉏'5?3Gu'vJD"kZ P*`U`[.cN4naZC-(SN.w0, 0nV'2.vOqd 'h|LB1p6
%`stF $ E6ZRgbVz4xn8jm0)_">36RVtd Ot6/O01XJ3e(IC0i= lS.Ջ5-#YMH쯗RZv]{˚+yyQ~;{dW{D ?Y>ФSĄ{>Mr
`.~0Q3̜2C[ :XZg~ǿ缦knfDm ` |cՊƂt/j0;-f`a̤/6W00ЬVcqAM,+Iq5FPo2Y%Zj#$=ZVcw.iRDĢx&L_za &Ä> ~Hm*Gew#WHbw? ܭ-3Q
`@uML֏:yW Tdv,~@u U%[UۡI(awa747';ʖ3 ۱Z=>:[ $]tV9|wŦ-IƘЛCcm$ēi mI軅Yh_Z@aH /
AA
?!q[%q̟g*57ʜL;%>Ƶ AV h3 H:,$$?4;
ҊϧYZr?k IÚ(.*ȩepW<0i[[LxF}~i7GLoy,˪]'xҎOo9!@-i&I{bM/Rӎ VOE~mz5(Hp/l`2ٺ`qW| 6,Iސ\ !M 3wfy}ۨi&4#=&s=Ʈ|
/BU nWH-qpgWp0ԬDurȂb{)QnlӼX
-q2.H1ʼnӫSՁG$.ѧ\a~GbZ~5nDefЭ kz S7%@Tؕ '}oC2'o)2:桤R[&f > M\*`ߐm nU7S 9n1u2ՐZX Cz kuΚ
yD8 ǎBɀ USOJw\
Xvu
Kx8e"#&k̢( ף[h
\¤ )J \B7 ~&[&Ɓp%T
[ y xD8, R ޅ- 2O{U
58wwŃ>Ml! ḝD_P&Z4ڣI4 {YFL{WzG` GS f4m**)0߅^bZ:{Id>T"j9Jgȡx~6zM_q#PT\#< 2RG: X;=s 0>y|@sxLEM96A]"v L#AF\;vL*_[p<1p *x |y@@)m,@V~">Vڳ0o c # Qun+O54h7FCԒhinI\2 5f ão,'tÓD$rtL ǭB~~s]|봑^Ւn%\HlÝ Nu$j5A){$7 Iw]|l3
N qjh0Uw
ҶMċ$ hn2G?`QEblPNlۍ;\i "# Pn~k $&LX% ܐN/y# !3|ِtp@0&l@vn2]d8NMj D6@M$<+2jvid +˖[^ eevW ʲsvjH (&:Ī'd{ iޛ 餧
!BF| C'zg> 6܄\ S @s=aYr)>a"+q|?4: H9 f xpar7 p@= Rϋf/h,lK uhbx0CP`83h"PMF'TӡcWi. E` ḻ2O K
yȘyg+5KF҈yJ &ÆvQkעC, a9N)T$`D@"Hdk<>tn DŽq@0/9| T N>yU$ 2Jt%Z @CJl?2ġ j vضB|uOp'(Gn'l_tC]!{D^߫@%]yn 1vgo;)!t
sGpؒQ
aFe "FXL]u'SFߦV$+4]6_[ c_YMc&IlYSM-xL{Vy7jMe`fO V6uFG ;q2ma}ͯb.tsC ʓo!G1*`)vm.' W6qڞss&{[K@tlBLUَʷzlXI mV(k4
`q5S\+O(s8'|ܓ@/7TJ>!0 F ,0^n
(I|pjI/qgJNcb $< 6iu. ?H MڄO ƛ?@Ҍ `Aߔx^)^dqQ, Z6Ѩ63BEE.d=~ w
I>8lȄЬLyFmt9fzA4AM8dJ!V[IJ!keݗJȬ/fz
sY4v#Ix4>jd,h7 nVكa |oH
r1 ΐ
'I *!,~9 68?MLjx=t(n@Ʀ} k~u##wӹ055+i^c3{kE]gZ_{(m*24a4Y[،֩I(?t\#
guyXSw#"C "Þ f'Q74~ ]y(]vUA0za~&xF W`$,-b] ?A?~%QtlWQ CD_}w8GkJ?4GkUd
9gHtUM~iU;hWTq2?jv6dolX \Vc{[H}i;-`U3Afu!F.ÒNBUs 21?Vo7ڭMXpfoԦ,2 r[ZlQvЅ^bt@oa( K{K燐Yq(Pt<u/s'KhbN2 rՎ-^iz8YyȗEe%zL[f:CQ4w8ӕ] .BO ?=|Mj0%AV)!}Ta""I rHbKX!.AŔ%9rb8!l6ޙLmϻy`m!O!ͷ
ڔYڱoz=D3'%'))<;Bg]vD7>(g7=E.C-NQp4* ѳh
(Ucÿ:Ela[]g^n$ PaEAP<;FmV=$d0]@>:P܈lA8$ Qvw w2O&Mv?I 6+Om)}yǺeI=Yb-;VˣY`7&bQ$A]=1y-1Zv I8 iit Tll#l}?[GL^q "Г}KhVI Ō)($2¨N& "^%D9 1di\+rpZ#D@t 9 FEv"+3BK9Fyoݯy^~R?`N_;){\נ
d)CՔ6B Za%y!*?Tw].5
trigger_error($user->lang['ATTACHED_IMAGE_NOT_IMAGE']);
}
// Do we have to create a thumbnail?
$filedata['thumbnail'] = ($cat_id == ATTACHMENT_CATEGORY_IMAGE && $config['img_create_thumbnail']) ? 1 : 0;
// Check Image Size, if it is an image
if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id) && $cat_id == ATTACHMENT_CATEGORY_IMAGE)
{
$file->upload->set_allowed_dimensions(0, 0, $config['img_max_width'], $config['img_max_height']);
}
// Admins and mods are allowed to exceed the allowed filesize
if (!$auth->acl_get('a_') && !$auth->acl_get('m_', $forum_id))
{
if (!empty($extensions[$file->get('extension')]['max_filesize']))
{
$allowed_filesize = $extensions[$file->get('extension')]['max_filesize'];
}
else
{
$allowed_filesize = ($is_message) ? $config['max_filesize_pm'] : $config['max_filesize'];
}
$file->upload->set_max_filesize($allowed_filesize);
}
$file->clean_filename('unique', $user->data['user_id'] . '_');
// Are we uploading an image *and* this image being within the image category? Only then perform additional image checks.
$no_image = ($cat_id == ATTACHMENT_CATEGORY_IMAGE) ? false : true;
$file->move_file($config['upload_path'], false, $no_image);
if (sizeof($file->error))
{
$file->remove();
$filedata['error'] = array_merge($filedata['error'], $file->error);
$filedata['post_attach'] = false;
return $filedata;
}
$filedata['filesize'] = $file->get('filesize');
$filedata['mimetype'] = $file->get('mimetype');
$filedata['extension'] = $file->get('extension');
$filedata['physical_filename'] = $file->get('realname');
$filedata['real_filename'] = $file->get('uploadname');
$filedata['filetime'] = time();
// Check our complete quota
if ($config['attachment_quota'])
{
if ($config['upload_dir_size'] + $file->get('filesize') > $config['attachment_quota'])
{
$filedata['error'][] = $user->lang['ATTACH_QUOTA_REACHED'];
$filedata['post_attach'] = false;
$file->remove();
return $filedata;
}
}
// Check free disk space
if ($free_space = @disk_free_space($phpbb_root_path . $config['upload_path']))
{
if ($free_space <= $file->get('filesize'))
{
$filedata['error'][] = $user->lang['ATTACH_QUOTA_REACHED'];
$filedata['post_attach'] = false;
$file->remove();
return $filedata;
}
}
// Create Thumbnail
if ($filedata['thumbnail'])
{
$source = $file->get('destination_file');
$destination = $file->get('destination_path') . '/thumb_' . $file->get('realname');
if (!create_thumbnail($source, $destination, $file->get('mimetype')))
{
$filedata['thumbnail'] = 0;
}
}
return $filedata;
}
/**
* Calculate the needed size for Thumbnail
*/
function get_img_size_format($width, $height)
{
global $config;
// Maximum Width the Image can take
$max_width = ($config['img_max_thumb_width']) ? $config['img_max_thumb_width'] : 400;
if ($width > $height)
{
return array(
round($width * ($max_width / $width)),
round($height * ($max_width / $width))
);
}
else
{
return array(
round($width * ($max_width / $height)),
round($height * ($max_width / $height))
);
}
}
/**
* Return supported image types
*/
function get_supported_image_types($type = false)
{
if (@extension_loaded('gd'))
{
$format = imagetypes();
$new_type = 0;
if ($type !== false)
{
// Type is one of the IMAGETYPE constants - it is fetched from getimagesize()
switch ($type)
{
// GIF
case IMAGETYPE_GIF:
$new_type = ($format & IMG_GIF) ? IMG_GIF : false;
break;
// JPG, JPC, JP2
case IMAGETYPE_JPEG:
case IMAGETYPE_JPC:
case IMAGETYPE_JPEG2000:
case IMAGETYPE_JP2:
case IMAGETYPE_JPX:
case IMAGETYPE_JB2:
$new_type = ($format & IMG_JPG) ? IMG_JPG : false;
break;
// PNG
case IMAGETYPE_PNG:
$new_type = ($format & IMG_PNG) ? IMG_PNG : false;
break;
// WBMP
case IMAGETYPE_WBMP:
$new_type = ($format & IMG_WBMP) ? IMG_WBMP : false;
break;
}
}
else
{
$new_type = array();
$go_through_types = array(IMG_GIF, IMG_JPG, IMG_PNG, IMG_WBMP);
foreach ($go_through_types as $check_type)
{
if ($format & $check_type)
{
$new_type[] = $check_type;
}
}
}
return array(
'gd' => ($new_type) ? true : false,
'format' => $new_type,
'version' => (function_exists('imagecreatetruecolor')) ? 2 : 1
);
}
return array('gd' => false);
}
/**
* Create Thumbnail
*/
function create_thumbnail($source, $destination, $mimetype)
{
global $config;
$min_filesize = (int) $config['img_min_thumb_filesize'];
$img_filesize = (file_exists($source)) ? @filesize($source) : false;
if (!$img_filesize || $img_filesize <= $min_filesize)
{
return false;
}
$dimension = @getimagesize($source);
if ($dimension === false)
{
return false;
}
list($width, $height, $type, ) = $dimension;
if (empty($width) || empty($height))
{
return false;
}
list($new_width, $new_height) = get_img_size_format($width, $height);
// Do not create a thumbnail if the resulting width/height is bigger than the original one
if ($new_width >= $width && $new_height >= $height)
{
return false;
}
$used_imagick = false;
// Only use imagemagick if defined and the passthru function not disabled
if ($config['img_imagick'] && function_exists('passthru'))
{
if (substr($config['img_imagick'], -1) !== '/')
{
$config['img_imagick'] .= '/';
}
@passthru(escapeshellcmd($config['img_imagick']) . 'convert' . ((defined('PHP_OS') && preg_match('#^win#i', PHP_OS)) ? '.exe' : '') . ' -quality 85 -geometry ' . $new_width . 'x' . $new_height . ' "' . str_replace('\\', '/', $source) . '" "' . str_replace('\\', '/', $destination) . '"');
if (file_exists($destination))
{
$used_imagick = true;
}
}
if (!$used_imagick)
{
$type = get_supported_image_types($type);
if ($type['gd'])
{
// If the type is not supported, we are not able to create a thumbnail
if ($type['format'] === false)
{
return false;
}
switch ($type['format'])
{
case IMG_GIF:
$image = @imagecreatefromgif($source);
break;
case IMG_JPG:
@ini_set('gd.jpeg_ignore_warning', 1);
$image = @imagecreatefromjpeg($source);
break;
case IMG_PNG:
$image = @imagecreatefrompng($source);
break;
case IMG_WBMP:
$image = @imagecreatefromwbmp($source);
break;
}
if (empty($image))
{
return false;
}
if ($type['version'] == 1)
{
$new_image = imagecreate($new_width, $new_height);
if ($new_image === false)
{
return false;
}
imagecopyresized($new_image, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
}
else
{
$new_image = imagecreatetruecolor($new_width, $new_height);
if ($new_image === false)
{
return false;
}
// Preserve alpha transparency (png for example)
@imagealphablending($new_image, false);
@imagesavealpha($new_image, true);
imagecopyresampled($new_image, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
}
// If we are in safe mode create the destination file prior to using the gd functions to circumvent a PHP bug
if (@ini_get('safe_mode') || @strtolower(ini_get('safe_mode')) == 'on')
{
@touch($destination);
}
switch ($type['format'])
{
case IMG_GIF:
imagegif($new_image, $destination);
break;
case IMG_JPG:
imagejpeg($new_image, $destination, 90);
break;
case IMG_PNG:
imagepng($new_image, $destination);
break;
case IMG_WBMP:
imagewbmp($new_image, $destination);
break;
}
imagedestroy($new_image);
}
else
{
return false;
}
}
if (!file_exists($destination))
{
return false;
}
phpbb_chmod($destination, CHMOD_READ | CHMOD_WRITE);
return true;
}
/**
* Assign Inline attachments (build option fields)
*/
function posting_gen_inline_attachments(&$attachment_data)
{
global $template;
if (sizeof($attachment_data))
{
$s_inline_attachment_options = '';
foreach ($attachment_data as $i => $attachment)
{
$s_inline_attachment_options .= '<option value="' . $i . '">' . utf8_basename($attachment['real_filename']) . '</option>';
}
$template->assign_var('S_INLINE_ATTACHMENT_OPTIONS', $s_inline_attachment_options);
return true;
}
return false;
}
/**
* Generate inline attachment entry
*/
function posting_gen_attachment_entry($attachment_data, &$filename_data, $show_attach_box = true)
{
global $template, $config, $phpbb_root_path, $phpEx, $user;
// Some default template variables
$template->assign_vars(array(
'S_SHOW_ATTACH_BOX' => $show_attach_box,
'S_HAS_ATTACHMENTS' => sizeof($attachment_data),
'FILESIZE' => $config['max_filesize'],
'FILE_COMMENT' => (isset($filename_data['filecomment'])) ? $filename_data['filecomment'] : '',
));
if (sizeof($attachment_data))
{
// We display the posted attachments within the desired order.
($config['display_order']) ? krsort($attachment_data) : ksort($attachment_data);
foreach ($attachment_data as $count => $attach_row)
{
$hidden = '';
$attach_row['real_filename'] = utf8_basename($attach_row['real_filename']);
foreach ($attach_row as $key => $value)
{
$hidden .= '<input type="hidden" name="attachment_data[' . $count . '][' . $key . ']" value="' . $value . '" />';
}
$download_link = append_sid("{$phpbb_root_path}download/file.$phpEx", 'mode=view&id=' . (int) $attach_row['attach_id'], true, ($attach_row['is_orphan']) ? $user->session_id : false);
$template->assign_block_vars('attach_row', array(
'FILENAME' => utf8_basename($attach_row['real_filename']),
'A_FILENAME' => addslashes(utf8_basename($attach_row['real_filename'])),
'FILE_COMMENT' => $attach_row['attach_comment'],
'ATTACH_ID' => $attach_row['attach_id'],
'S_IS_ORPHAN' => $attach_row['is_orphan'],
'ASSOC_INDEX' => $count,
'U_VIEW_ATTACHMENT' => $download_link,
'S_HIDDEN' => $hidden)
);
}
}
return sizeof($attachment_data);
}
//
// General Post functions
//
/**
* Load Drafts
*/
function load_drafts($topic_id = 0, $forum_id = 0, $id = 0, $pm_action = '', $msg_id = 0)
{
global $user, $db, $template, $auth;
global $phpbb_root_path, $phpEx;
$topic_ids = $forum_ids = $draft_rows = array();
// Load those drafts not connected to forums/topics
// If forum_id == 0 AND topic_id == 0 then this is a PM draft
if (!$topic_id && !$forum_id)
{
$sql_and = ' AND d.forum_id = 0 AND d.topic_id = 0';
}
else
{
$sql_and = '';
$sql_and .= ($forum_id) ? ' AND d.forum_id = ' . (int) $forum_id : '';
$sql_and .= ($topic_id) ? ' AND d.topic_id = ' . (int) $topic_id : '';
}
$sql = 'SELECT d.*, f.forum_id, f.forum_name
FROM ' . DRAFTS_TABLE . ' d
LEFT JOIN ' . FORUMS_TABLE . ' f ON (f.forum_id = d.forum_id)
WHERE d.user_id = ' . $user->data['user_id'] . "
$sql_and
ORDER BY d.save_time DESC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
if ($row['topic_id'])
{
$topic_ids[] = (int) $row['topic_id'];
}
$draft_rows[] = $row;
}
$db->sql_freeresult($result);
if (!sizeof($draft_rows))
{
return;
}
$topic_rows = array();
if (sizeof($topic_ids))
{
$sql = 'SELECT topic_id, forum_id, topic_title
FROM ' . TOPICS_TABLE . '
WHERE ' . $db->sql_in_set('topic_id', array_unique($topic_ids));
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$topic_rows[$row['topic_id']] = $row;
}
$db->sql_freeresult($result);
}
unset($topic_ids);
$template->assign_var('S_SHOW_DRAFTS', true);
foreach ($draft_rows as $draft)
{
$link_topic = $link_forum = $link_pm = false;
$insert_url = $view_url = $title = '';
if (isset($topic_rows[$draft['topic_id']])
&& (
($topic_rows[$draft['topic_id']]['forum_id'] && $auth->acl_get('f_read', $topic_rows[$draft['topic_id']]['forum_id']))
||
(!$topic_rows[$draft['topic_id']]['forum_id'] && $auth->acl_getf_global('f_read'))
))
{
$topic_forum_id = ($topic_rows[$draft['topic_id']]['forum_id']) ? $topic_rows[$draft['topic_id']]['forum_id'] : $forum_id;
$link_topic = true;
$view_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topic_forum_id . '&t=' . $draft['topic_id']);
$title = $topic_rows[$draft['topic_id']]['topic_title'];
$insert_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'f=' . $topic_forum_id . '&t=' . $draft['topic_id'] . '&mode=reply&d=' . $draft['draft_id']);
}
else if ($draft['forum_id'] && $auth->acl_get('f_read', $draft['forum_id']))
{
$link_forum = true;
$view_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $draft['forum_id']);
$title = $draft['forum_name'];
$insert_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'f=' . $draft['forum_id'] . '&mode=post&d=' . $draft['draft_id']);
}
else
{
// Either display as PM draft if forum_id and topic_id are empty or if access to the forums has been denied afterwards...
$link_pm = true;
$insert_url = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&mode=compose&d={$draft['draft_id']}" . (($pm_action) ? "&action=$pm_action" : '') . (($msg_id) ? "&p=$msg_id" : ''));
}
$template->assign_block_vars('draftrow', array(
'DRAFT_ID' => $draft['draft_id'],
'DATE' => $user->format_date($draft['save_time']),
'DRAFT_SUBJECT' => $draft['draft_subject'],
'TITLE' => $title,
'U_VIEW' => $view_url,
'U_INSERT' => $insert_url,
'S_LINK_PM' => $link_pm,
'S_LINK_TOPIC' => $link_topic,
'S_LINK_FORUM' => $link_forum)
);
}
}
/**
* Topic Review
*/
function topic_review($topic_id, $forum_id, $mode = 'topic_review', $cur_post_id = 0, $show_quote_button = true)
{
global $user, $auth, $db, $template, $bbcode, $cache;
global $config, $phpbb_root_path, $phpEx;
// Go ahead and pull all data for this topic
$sql = 'SELECT p.post_id
FROM ' . POSTS_TABLE . ' p' . "
WHERE p.topic_id = $topic_id
" . ((!$auth->acl_get('m_approve', $forum_id)) ? 'AND p.post_approved = 1' : '') . '
' . (($mode == 'post_review') ? " AND p.post_id > $cur_post_id" : '') . '
' . (($mode == 'post_review_edit') ? " AND p.post_id = $cur_post_id" : '') . '
ORDER BY p.post_time ';
$sql .= ($mode == 'post_review') ? 'ASC' : 'DESC';
$result = $db->sql_query_limit($sql, $config['posts_per_page']);
$post_list = array();
while ($row = $db->sql_fetchrow($result))
{
$post_list[] = $row['post_id'];
}
$db->sql_freeresult($result);
if (!sizeof($post_list))
{
return false;
}
// Handle 'post_review_edit' like 'post_review' from now on
if ($mode == 'post_review_edit')
{
$mode = 'post_review';
}
$sql = $db->sql_build_query('SELECT', array(
'SELECT' => 'u.username, u.user_id, u.user_colour, p.*, z.friend, z.foe',
'FROM' => array(
USERS_TABLE => 'u',
POSTS_TABLE => 'p',
),
'LEFT_JOIN' => array(
array(
'FROM' => array(ZEBRA_TABLE => 'z'),
'ON' => 'z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id'
)
),
'WHERE' => $db->sql_in_set('p.post_id', $post_list) . '
AND u.user_id = p.poster_id'
));
$result = $db->sql_query($sql);
$bbcode_bitfield = '';
$rowset = array();
$has_attachments = false;
while ($row = $db->sql_fetchrow($result))
{
$rowset[$row['post_id']] = $row;
$bbcode_bitfield = $bbcode_bitfield | base64_decode($row['bbcode_bitfield']);
if ($row['post_attachment'])
{
$has_attachments = true;
}
}
$db->sql_freeresult($result);
// Instantiate BBCode class
if (!isset($bbcode) && $bbcode_bitfield !== '')
{
include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);
$bbcode = new bbcode(base64_encode($bbcode_bitfield));
}
// Grab extensions
$extensions = $attachments = array();
if ($has_attachments && $auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id))
{
$extensions = $cache->obtain_attach_extensions($forum_id);
// Get attachments...
$sql = 'SELECT *
FROM ' . ATTACHMENTS_TABLE . '
WHERE ' . $db->sql_in_set('post_msg_id', $post_list) . '
AND in_message = 0
ORDER BY filetime DESC, post_msg_id ASC';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$attachments[$row['post_msg_id']][] = $row;
}
$db->sql_freeresult($result);
}
for ($i = 0, $end = sizeof($post_list); $i < $end; ++$i)
{
// A non-existing rowset only happens if there was no user present for the entered poster_id
// This could be a broken posts table.
if (!isset($rowset[$post_list[$i]]))
{
continue;
}
$row = $rowset[$post_list[$i]];
$poster_id = $row['user_id'];
$post_subject = $row['post_subject'];
$message = censor_text($row['post_text']);
$decoded_message = false;
if ($show_quote_button && $auth->acl_get('f_reply', $forum_id))
{
$decoded_message = $message;
decode_message($decoded_message, $row['bbcode_uid']);
$decoded_message = bbcode_nl2br($decoded_message);
}
if ($row['bbcode_bitfield'])
{
$bbcode->bbcode_second_pass($message, $row['bbcode_uid'], $row['bbcode_bitfield']);
}
$message = bbcode_nl2br($message);
$message = smiley_text($message, !$row['enable_smilies']);
if (!empty($attachments[$row['post_id']]))
{
$update_count = array();
parse_attachments($forum_id, $message, $attachments[$row['post_id']], $update_count);
}
$post_subject = censor_text($post_subject);
$post_anchor = ($mode == 'post_review') ? 'ppr' . $row['post_id'] : 'pr' . $row['post_id'];
$u_show_post = append_sid($phpbb_root_path . 'viewtopic.' . $phpEx, "f=$forum_id&t=$topic_id&p={$row['post_id']}&view=show#p{$row['post_id']}");
$template->assign_block_vars($mode . '_row', array(
'POST_AUTHOR_FULL' => get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
'POST_AUTHOR_COLOUR' => get_username_string('colour', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
'POST_AUTHOR' => get_username_string('username', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
'U_POST_AUTHOR' => get_username_string('profile', $poster_id, $row['username'], $row['user_colour'], $row['post_username']),
'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? true : false,
'S_FRIEND' => ($row['friend']) ? true : false,
'S_IGNORE_POST' => ($row['foe']) ? true : false,
'L_IGNORE_POST' => ($row['foe']) ? sprintf($user->lang['POST_BY_FOE'], get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']), "<a href=\"{$u_show_post}\" onclick=\"dE('{$post_anchor}', 1); return false;\">", '</a>') : '',
'POST_SUBJECT' => $post_subject,
'MINI_POST_IMG' => $user->img('icon_post_target', $user->lang['POST']),
'POST_DATE' => $user->format_date($row['post_time']),
'MESSAGE' => $message,
'DECODED_MESSAGE' => $decoded_message,
'POST_ID' => $row['post_id'],
'U_MINI_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'p=' . $row['post_id']) . '#p' . $row['post_id'],
'U_MCP_DETAILS' => ($auth->acl_get('m_info', $forum_id)) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=post_details&f=' . $forum_id . '&p=' . $row['post_id'], true, $user->session_id) : '',
'POSTER_QUOTE' => ($show_quote_button && $auth->acl_get('f_reply', $forum_id)) ? addslashes(get_username_string('username', $poster_id, $row['username'], $row['user_colour'], $row['post_username'])) : '')
);
// Display not already displayed Attachments for this post, we already parsed them. ;)
if (!empty($attachments[$row['post_id']]))
{
foreach ($attachments[$row['post_id']] as $attachment)
{
$template->assign_block_vars($mode . '_row.attachment', array(
'DISPLAY_ATTACHMENT' => $attachment)
);
}
}
unset($rowset[$post_list[$i]]);
}
if ($mode == 'topic_review')
{
$template->assign_var('QUOTE_IMG', $user->img('icon_post_quote', $user->lang['REPLY_WITH_QUOTE']));
}
return true;
}
/**
* User Notification
*/
function user_notification($mode, $subject, $topic_title, $forum_name, $forum_id, $topic_id, $post_id)
{
global $db, $user, $config, $phpbb_root_path, $phpEx, $auth;
$topic_notification = ($mode == 'reply' || $mode == 'quote') ? true : false;
$forum_notification = ($mode == 'post') ? true : false;
if (!$topic_notification && !$forum_notification)
{
trigger_error('NO_MODE');
}
if (($topic_notification && !$config['allow_topic_notify']) || ($forum_notification && !$config['allow_forum_notify']))
{
return;
}
$topic_title = ($topic_notification) ? $topic_title : $subject;
$topic_title = censor_text($topic_title);
// Get banned User ID's
$sql = 'SELECT ban_userid
FROM ' . BANLIST_TABLE . '
WHERE ban_userid <> 0
AND ban_exclude <> 1';
$result = $db->sql_query($sql);
$sql_ignore_users = ANONYMOUS . ', ' . $user->data['user_id'];
while ($row = $db->sql_fetchrow($result))
{
$sql_ignore_users .= ', ' . (int) $row['ban_userid'];
}
$db->sql_freeresult($result);
$notify_rows = array();
// -- get forum_userids || topic_userids
$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
FROM ' . (($topic_notification) ? TOPICS_WATCH_TABLE : FORUMS_WATCH_TABLE) . ' w, ' . USERS_TABLE . ' u
WHERE w.' . (($topic_notification) ? 'topic_id' : 'forum_id') . ' = ' . (($topic_notification) ? $topic_id : $forum_id) . "
AND w.user_id NOT IN ($sql_ignore_users)
AND w.notify_status = " . NOTIFY_YES . '
AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')
AND u.user_id = w.user_id';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$notify_rows[$row['user_id']] = array(
'user_id' => $row['user_id'],
'username' => $row['username'],
'user_email' => $row['user_email'],
'user_jabber' => $row['user_jabber'],
'user_lang' => $row['user_lang'],
'notify_type' => ($topic_notification) ? 'topic' : 'forum',
'template' => ($topic_notification) ? 'topic_notify' : 'newtopic_notify',
'method' => $row['user_notify_type'],
'allowed' => false
);
}
$db->sql_freeresult($result);
// forum notification is sent to those not already receiving topic notifications
if ($topic_notification)
{
if (sizeof($notify_rows))
{
$sql_ignore_users .= ', ' . implode(', ', array_keys($notify_rows));
}
$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
FROM ' . FORUMS_WATCH_TABLE . ' fw, ' . USERS_TABLE . " u
WHERE fw.forum_id = $forum_id
AND fw.user_id NOT IN ($sql_ignore_users)
AND fw.notify_status = " . NOTIFY_YES . '
AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')
AND u.user_id = fw.user_id';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$notify_rows[$row['user_id']] = array(
'user_id' => $row['user_id'],
'username' => $row['username'],
'user_email' => $row['user_email'],
'user_jabber' => $row['user_jabber'],
'user_lang' => $row['user_lang'],
'notify_type' => 'forum',
'template' => 'forum_notify',
'method' => $row['user_notify_type'],
'allowed' => false
);
}
$db->sql_freeresult($result);
}
if (!sizeof($notify_rows))
{
return;
}
// Make sure users are allowed to read the forum
foreach ($auth->acl_get_list(array_keys($notify_rows), 'f_read', $forum_id) as $forum_id => $forum_ary)
{
foreach ($forum_ary as $auth_option => $user_ary)
{
foreach ($user_ary as $user_id)
{
$notify_rows[$user_id]['allowed'] = true;
}
}
}
// Now, we have to do a little step before really sending, we need to distinguish our users a little bit. ;)
$msg_users = $delete_ids = $update_notification = array();
foreach ($notify_rows as $user_id => $row)
{
if (!$row['allowed'] || !trim($row['user_email']))
{
$delete_ids[$row['notify_type']][] = $row['user_id'];
}
else
{
$msg_users[] = $row;
$update_notification[$row['notify_type']][] = $row['user_id'];
}
}
unset($notify_rows);
// Now, we are able to really send out notifications
if (sizeof($msg_users))
{
include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);
$messenger = new messenger();
$msg_list_ary = array();
foreach ($msg_users as $row)
{
$pos = (!isset($msg_list_ary[$row['template']])) ? 0 : sizeof($msg_list_ary[$row['template']]);
$msg_list_ary[$row['template']][$pos]['method'] = $row['method'];
$msg_list_ary[$row['template']][$pos]['email'] = $row['user_email'];
$msg_list_ary[$row['template']][$pos]['jabber'] = $row['user_jabber'];
$msg_list_ary[$row['template']][$pos]['name'] = $row['username'];
$msg_list_ary[$row['template']][$pos]['lang'] = $row['user_lang'];
$msg_list_ary[$row['template']][$pos]['user_id']= $row['user_id'];
}
unset($msg_users);
foreach ($msg_list_ary as $email_template => $email_list)
{
foreach ($email_list as $addr)
{
$messenger->template($email_template, $addr['lang']);
$messenger->to($addr['email'], $addr['name']);
$messenger->im($addr['jabber'], $addr['name']);
$messenger->assign_vars(array(
'USERNAME' => htmlspecialchars_decode($addr['name']),
'TOPIC_TITLE' => htmlspecialchars_decode($topic_title),
'FORUM_NAME' => htmlspecialchars_decode($forum_name),
'U_FORUM' => generate_board_url() . "/viewforum.$phpEx?f=$forum_id",
'U_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&t=$topic_id",
'U_NEWEST_POST' => generate_board_url() . "/viewtopic.$phpEx?f=$forum_id&t=$topic_id&p=$post_id&e=$post_id",
'U_STOP_WATCHING_TOPIC' => generate_board_url() . "/viewtopic.$phpEx?uid={$addr['user_id']}&f=$forum_id&t=$topic_id&unwatch=topic",
'U_STOP_WATCHING_FORUM' => generate_board_url() . "/viewforum.$phpEx?uid={$addr['user_id']}&f=$forum_id&unwatch=forum",
));
$messenger->send($addr['method']);
}
}
unset($msg_list_ary);
$messenger->save_queue();
}
// Handle the DB updates
$db->sql_transaction('begin');
if (!empty($update_notification['topic']))
{
$sql = 'UPDATE ' . TOPICS_WATCH_TABLE . '
SET notify_status = ' . NOTIFY_NO . "
WHERE topic_id = $topic_id
AND " . $db->sql_in_set('user_id', $update_notification['topic']);
$db->sql_query($sql);
}
if (!empty($update_notification['forum']))
{
$sql = 'UPDATE ' . FORUMS_WATCH_TABLE . '
SET notify_status = ' . NOTIFY_NO . "
WHERE forum_id = $forum_id
AND " . $db->sql_in_set('user_id', $update_notification['forum']);
$db->sql_query($sql);
}
// Now delete the user_ids not authorised to receive notifications on this topic/forum
if (!empty($delete_ids['topic']))
{
$sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . "
WHERE topic_id = $topic_id
AND " . $db->sql_in_set('user_id', $delete_ids['topic']);
$db->sql_query($sql);
}
if (!empty($delete_ids['forum']))
{
$sql = 'DELETE FROM ' . FORUMS_WATCH_TABLE . "
WHERE forum_id = $forum_id
AND " . $db->sql_in_set('user_id', $delete_ids['forum']);
$db->sql_query($sql);
}
$db->sql_transaction('commit');
}
//
// Post handling functions
//
/**
* Delete Post
*/
function delete_post($forum_id, $topic_id, $post_id, &$data)
{
global $db, $user, $auth;
global $config, $phpEx, $phpbb_root_path;
// Specify our post mode
$post_mode = 'delete';
if (($data['topic_first_post_id'] === $data['topic_last_post_id']) && $data['topic_replies_real'] == 0)
{
$post_mode = 'delete_topic';
}
else if ($data['topic_first_post_id'] == $post_id)
{
$post_mode = 'delete_first_post';
}
else if ($data['topic_last_post_id'] == $post_id)
{
$post_mode = 'delete_last_post';
}
$sql_data = array();
$next_post_id = false;
include_once($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
$db->sql_transaction('begin');
// we must make sure to update forums that contain the shadow'd topic
if ($post_mode == 'delete_topic')
{
$shadow_forum_ids = array();
$sql = 'SELECT forum_id
FROM ' . TOPICS_TABLE . '
WHERE ' . $db->sql_in_set('topic_moved_id', $topic_id);
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
if (!isset($shadow_forum_ids[(int) $row['forum_id']]))
{
$shadow_forum_ids[(int) $row['forum_id']] = 1;
}
else
{
$shadow_forum_ids[(int) $row['forum_id']]++;
}
}
$db->sql_freeresult($result);
}
if (!delete_posts('post_id', array($post_id), false, false))
{
// Try to delete topic, we may had an previous error causing inconsistency
if ($post_mode == 'delete_topic')
{
delete_topics('topic_id', array($topic_id), false);
}
trigger_error('ALREADY_DELETED');
}
$db->sql_transaction('commit');
// Collect the necessary information for updating the tables
$sql_data[FORUMS_TABLE] = '';
switch ($post_mode)
{
case 'delete_topic':
foreach ($shadow_forum_ids as $updated_forum => $topic_count)
{
// counting is fun! we only have to do sizeof($forum_ids) number of queries,
// even if the topic is moved back to where its shadow lives (we count how many times it is in a forum)
$db->sql_query('UPDATE ' . FORUMS_TABLE . ' SET forum_topics_real = forum_topics_real - ' . $topic_count . ', forum_topics = forum_topics - ' . $topic_count . ' WHERE forum_id = ' . $updated_forum);
update_post_information('forum', $updated_forum);
}
delete_topics('topic_id', array($topic_id), false);
$sql_data[FORUMS_TABLE] .= 'forum_topics_real = forum_topics_real - 1';
$sql_data[FORUMS_TABLE] .= ($data['topic_approved']) ? ', forum_posts = forum_posts - 1, forum_topics = forum_topics - 1' : '';
$update_sql = update_post_information('forum', $forum_id, true);
if (sizeof($update_sql))
{
$sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';
$sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);
}
break;
case 'delete_first_post':
$sql = 'SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_colour
FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . " u
WHERE p.topic_id = $topic_id
AND p.poster_id = u.user_id
ORDER BY p.post_time ASC";
$result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';
$sql_data[TOPICS_TABLE] = 'topic_poster = ' . intval($row['poster_id']) . ', topic_first_post_id = ' . intval($row['post_id']) . ", topic_first_poster_colour = '" . $db->sql_escape($row['user_colour']) . "', topic_first_poster_name = '" . (($row['poster_id'] == ANONYMOUS) ? $db->sql_escape($row['post_username']) : $db->sql_escape($row['username'])) . "', topic_time = " . (int) $row['post_time'];
// Decrementing topic_replies here is fine because this case only happens if there is more than one post within the topic - basically removing one "reply"
$sql_data[TOPICS_TABLE] .= ', topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');
$next_post_id = (int) $row['post_id'];
break;
case 'delete_last_post':
$sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';
$update_sql = update_post_information('forum', $forum_id, true);
if (sizeof($update_sql))
{
$sql_data[FORUMS_TABLE] .= ($sql_data[FORUMS_TABLE]) ? ', ' : '';
$sql_data[FORUMS_TABLE] .= implode(', ', $update_sql[$forum_id]);
}
$sql_data[TOPICS_TABLE] = 'topic_bumped = 0, topic_bumper = 0, topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');
$update_sql = update_post_information('topic', $topic_id, true);
if (sizeof($update_sql))
{
$sql_data[TOPICS_TABLE] .= ', ' . implode(', ', $update_sql[$topic_id]);
$next_post_id = (int) str_replace('topic_last_post_id = ', '', $update_sql[$topic_id][0]);
}
else
{
$sql = 'SELECT MAX(post_id) as last_post_id
FROM ' . POSTS_TABLE . "
WHERE topic_id = $topic_id " .
((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '');
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$next_post_id = (int) $row['last_post_id'];
}
break;
case 'delete':
$sql = 'SELECT post_id
FROM ' . POSTS_TABLE . "
WHERE topic_id = $topic_id " .
((!$auth->acl_get('m_approve', $forum_id)) ? 'AND post_approved = 1' : '') . '
AND post_time > ' . $data['post_time'] . '
ORDER BY post_time ASC';
$result = $db->sql_query_limit($sql, 1);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$sql_data[FORUMS_TABLE] = ($data['post_approved']) ? 'forum_posts = forum_posts - 1' : '';
$sql_data[TOPICS_TABLE] = 'topic_replies_real = topic_replies_real - 1' . (($data['post_approved']) ? ', topic_replies = topic_replies - 1' : '');
$next_post_id = (int) $row['post_id'];
break;
}
if (($post_mode == 'delete') || ($post_mode == 'delete_last_post') || ($post_mode == 'delete_first_post'))
{
$sql = 'SELECT 1 AS has_attachments
FROM ' . ATTACHMENTS_TABLE . '
WHERE topic_id = ' . $topic_id;
$result = $db->sql_query_limit($sql, 1);
$has_attachments = (int) $db->sql_fetchfield('has_attachments');
$db->sql_freeresult($result);
if (!$has_attachments)
{
$sql_data[TOPICS_TABLE] .= ', topic_attachment = 0';
}
}
// $sql_data[USERS_TABLE] = ($data['post_postcount']) ? 'user_posts = user_posts - 1' : '';
$db->sql_transaction('begin');
$where_sql = array(
FORUMS_TABLE => "forum_id = $forum_id",
TOPICS_TABLE => "topic_id = $topic_id",
USERS_TABLE => 'user_id = ' . $data['poster_id']
);
foreach ($sql_data as $table => $update_sql)
{
if ($update_sql)
{
$db->sql_query("UPDATE $table SET $update_sql WHERE " . $where_sql[$table]);
}
}
// Adjust posted info for this user by looking for a post by him/her within this topic...
if ($post_mode != 'delete_topic' && $config['load_db_track'] && $data['poster_id'] != ANONYMOUS)
{
$sql = 'SELECT poster_id
FROM ' . POSTS_TABLE . '
WHERE topic_id = ' . $topic_id . '
AND poster_id = ' . $data['poster_id'];
$result = $db->sql_query_limit($sql, 1);
$poster_id = (int) $db->sql_fetchfield('poster_id');
$db->sql_freeresult($result);
// The user is not having any more posts within this topic
if (!$poster_id)
{
$sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . '
WHERE topic_id = ' . $topic_id . '
AND user_id = ' . $data['poster_id'];
$db->sql_query($sql);
}
}
$db->sql_transaction('commit');
if ($data['post_reported'] && ($post_mode != 'delete_topic'))
{
sync('topic_reported', 'topic_id', array($topic_id));
}
return $next_post_id;
}
/**
* Submit Post
* @todo Split up and create lightweight, simple API for this.
*/
function submit_post($mode, $subject, $username, $topic_type, &$poll, &$data, $update_message = true, $update_search_index = true)
{
global $db, $auth, $user, $config, $phpEx, $template, $phpbb_root_path;
// We do not handle erasing posts here
if ($mode == 'delete')
{
return false;
}
$current_time = time();
if ($mode == 'post')
{
$post_mode = 'post';
$update_message = true;
}
else if ($mode != 'edit')
{
$post_mode = 'reply';
$update_message = true;
}
else if ($mode == 'edit')
{
$post_mode = ($data['topic_replies_real'] == 0) ? 'edit_topic' : (($data['topic_first_post_id'] == $data['post_id']) ? 'edit_first_post' : (($data['topic_last_post_id'] == $data['post_id']) ? 'edit_last_post' : 'edit'));
}
// First of all make sure the subject and topic title are having the correct length.
// To achieve this without cutting off between special chars we convert to an array and then count the elements.
$subject = truncate_string($subject);
$data['topic_title'] = truncate_string($data['topic_title']);
// Collect some basic information about which tables and which rows to update/insert
$sql_data = $topic_row = array();
$poster_id = ($mode == 'edit') ? $data['poster_id'] : (int) $user->data['user_id'];
// Retrieve some additional information if not present
if ($mode == 'edit' && (!isset($data['post_approved']) || !isset($data['topic_approved']) || $data['post_approved'] === false || $data['topic_approved'] === false))
{
$sql = 'SELECT p.post_approved, t.topic_type, t.topic_replies, t.topic_replies_real, t.topic_approved
FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . ' p
WHERE t.topic_id = p.topic_id
AND p.post_id = ' . $data['post_id'];
$result = $db->sql_query($sql);
$topic_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$data['topic_approved'] = $topic_row['topic_approved'];
$data['post_approved'] = $topic_row['post_approved'];
}
// This variable indicates if the user is able to post or put into the queue - it is used later for all code decisions regarding approval
// The variable name should be $post_approved, because it indicates if the post is approved or not
$post_approval = 1;
// Check the permissions for post approval. Moderators are not affected.
if (!$auth->acl_get('f_noapprove', $data['forum_id']) && !$auth->acl_get('m_approve', $data['forum_id']))
{
// Post not approved, but in queue
$post_approval = 0;
}
// Mods are able to force approved/unapproved posts. True means the post is approved, false the post is unapproved
if (isset($data['force_approved_state']))
{
$post_approval = ($data['force_approved_state']) ? 1 : 0;
}
// Start the transaction here
$db->sql_transaction('begin');
// Collect Information
switch ($post_mode)
{
case 'post':
case 'reply':
$sql_data[POSTS_TABLE]['sql'] = array(
'forum_id' => $data['forum_id'],
'poster_id' => (int) $user->data['user_id'],
'icon_id' => $data['icon_id'],
'poster_ip' => $user->ip,
'post_time' => $current_time,
'post_approved' => $post_approval,
'enable_bbcode' => $data['enable_bbcode'],
'enable_smilies' => $data['enable_smilies'],
'enable_magic_url' => $data['enable_urls'],
'enable_sig' => $data['enable_sig'],
'post_username' => (!$user->data['is_registered']) ? $username : '',
'post_subject' => $subject,
'post_text' => $data['message'],
'post_checksum' => $data['message_md5'],
'post_attachment' => (!empty($data['attachment_data'])) ? 1 : 0,
'bbcode_bitfield' => $data['bbcode_bitfield'],
'bbcode_uid' => $data['bbcode_uid'],
'post_postcount' => ($auth->acl_get('f_postcount', $data['forum_id'])) ? 1 : 0,
'post_edit_locked' => $data['post_edit_locked']
);
break;
case 'edit_first_post':
case 'edit':
case 'edit_last_post':
case 'edit_topic':
// If edit reason is given always display edit info
// If editing last post then display no edit info
// If m_edit permission then display no edit info
// If normal edit display edit info
// Display edit info if edit reason given or user is editing his post, which is not the last within the topic.
if ($data['post_edit_reason'] || (!$auth->acl_get('m_edit', $data['forum_id']) && ($post_mode == 'edit' || $post_mode == 'edit_first_post')))
{
$data['post_edit_reason'] = truncate_string($data['post_edit_reason'], 255, 255, false);
$sql_data[POSTS_TABLE]['sql'] = array(
'post_edit_time' => $current_time,
'post_edit_reason' => $data['post_edit_reason'],
'post_edit_user' => (int) $data['post_edit_user'],
);
$sql_data[POSTS_TABLE]['stat'][] = 'post_edit_count = post_edit_count + 1';
}
else if (!$data['post_edit_reason'] && $mode == 'edit' && $auth->acl_get('m_edit', $data['forum_id']))
{
$sql_data[POSTS_TABLE]['sql'] = array(
'post_edit_reason' => '',
);
}
// If the person editing this post is different to the one having posted then we will add a log entry stating the edit
// Could be simplified by only adding to the log if the edit is not tracked - but this may confuse admins/mods
if ($user->data['user_id'] != $poster_id)
{
$log_subject = ($subject) ? $subject : $data['topic_title'];
add_log('mod', $data['forum_id'], $data['topic_id'], 'LOG_POST_EDITED', $log_subject, (!empty($username)) ? $username : $user->lang['GUEST']);
}
if (!isset($sql_data[POSTS_TABLE]['sql']))
{
$sql_data[POSTS_TABLE]['sql'] = array();
}
$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(
'forum_id' => $data['forum_id'],
'poster_id' => $data['poster_id'],
'icon_id' => $data['icon_id'],
'post_approved' => (!$post_approval) ? 0 : $data['post_approved'],
'enable_bbcode' => $data['enable_bbcode'],
'enable_smilies' => $data['enable_smilies'],
'enable_magic_url' => $data['enable_urls'],
'enable_sig' => $data['enable_sig'],
'post_username' => ($username && $data['poster_id'] == ANONYMOUS) ? $username : '',
'post_subject' => $subject,
'post_checksum' => $data['message_md5'],
'post_attachment' => (!empty($data['attachment_data'])) ? 1 : 0,
'bbcode_bitfield' => $data['bbcode_bitfield'],
'bbcode_uid' => $data['bbcode_uid'],
'post_edit_locked' => $data['post_edit_locked'])
);
if ($update_message)
{
$sql_data[POSTS_TABLE]['sql']['post_text'] = $data['message'];
}
break;
}
$post_approved = $sql_data[POSTS_TABLE]['sql']['post_approved'];
$topic_row = array();
// And the topic ladies and gentlemen
switch ($post_mode)
{
case 'post':
$sql_data[TOPICS_TABLE]['sql'] = array(
'topic_poster' => (int) $user->data['user_id'],
'topic_time' => $current_time,
'topic_last_view_time' => $current_time,
'forum_id' => $data['forum_id'],
'icon_id' => $data['icon_id'],
'topic_approved' => $post_approval,
'topic_title' => $subject,
'topic_first_poster_name' => (!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : ''),
'topic_first_poster_colour' => $user->data['user_colour'],
'topic_type' => $topic_type,
'topic_time_limit' => ($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) ? ($data['topic_time_limit'] * 86400) : 0,
'topic_attachment' => (!empty($data['attachment_data'])) ? 1 : 0,
);
if (isset($poll['poll_options']) && !empty($poll['poll_options']))
{
$poll_start = ($poll['poll_start']) ? $poll['poll_start'] : $current_time;
$poll_length = $poll['poll_length'] * 86400;
if ($poll_length < 0)
{
$poll_start = $poll_start + $poll_length;
if ($poll_start < 0)
{
$poll_start = 0;
}
$poll_length = 1;
}
$sql_data[TOPICS_TABLE]['sql'] = array_merge($sql_data[TOPICS_TABLE]['sql'], array(
'poll_title' => $poll['poll_title'],
'poll_start' => $poll_start,
'poll_max_options' => $poll['poll_max_options'],
'poll_length' => $poll_length,
'poll_vote_change' => $poll['poll_vote_change'])
);
}
$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');
if ($post_approval)
{
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';
}
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics_real = forum_topics_real + 1' . (($post_approval) ? ', forum_topics = forum_topics + 1' : '');
break;
case 'reply':
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_view_time = ' . $current_time . ',
topic_replies_real = topic_replies_real + 1,
topic_bumped = 0,
topic_bumper = 0' .
(($post_approval) ? ', topic_replies = topic_replies + 1' : '') .
((!empty($data['attachment_data']) || (isset($data['topic_attachment']) && $data['topic_attachment'])) ? ', topic_attachment = 1' : '');
$sql_data[USERS_TABLE]['stat'][] = "user_lastpost_time = $current_time" . (($auth->acl_get('f_postcount', $data['forum_id']) && $post_approval) ? ', user_posts = user_posts + 1' : '');
if ($post_approval)
{
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts + 1';
}
break;
case 'edit_topic':
case 'edit_first_post':
if (isset($poll['poll_options']) && !empty($poll['poll_options']))
{
$poll_start = ($poll['poll_start']) ? $poll['poll_start'] : $current_time;
$poll_length = $poll['poll_length'] * 86400;
if ($poll_length < 0)
{
$poll_start = $poll_start + $poll_length;
if ($poll_start < 0)
{
$poll_start = 0;
}
$poll_length = 1;
}
}
$sql_data[TOPICS_TABLE]['sql'] = array(
'forum_id' => $data['forum_id'],
'icon_id' => $data['icon_id'],
'topic_approved' => (!$post_approval) ? 0 : $data['topic_approved'],
'topic_title' => $subject,
'topic_first_poster_name' => $username,
'topic_type' => $topic_type,
'topic_time_limit' => ($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) ? ($data['topic_time_limit'] * 86400) : 0,
'poll_title' => (isset($poll['poll_options'])) ? $poll['poll_title'] : '',
'poll_start' => (isset($poll['poll_options'])) ? $poll_start : 0,
'poll_max_options' => (isset($poll['poll_options'])) ? $poll['poll_max_options'] : 1,
'poll_length' => (isset($poll['poll_options'])) ? $poll_length : 0,
'poll_vote_change' => (isset($poll['poll_vote_change'])) ? $poll['poll_vote_change'] : 0,
'topic_last_view_time' => $current_time,
'topic_attachment' => (!empty($data['attachment_data'])) ? 1 : (isset($data['topic_attachment']) ? $data['topic_attachment'] : 0),
);
// Correctly set back the topic replies and forum posts... only if the topic was approved before and now gets disapproved
if (!$post_approval && $data['topic_approved'])
{
// Do we need to grab some topic informations?
if (!sizeof($topic_row))
{
$sql = 'SELECT topic_type, topic_replies, topic_replies_real, topic_approved
FROM ' . TOPICS_TABLE . '
WHERE topic_id = ' . $data['topic_id'];
$result = $db->sql_query($sql);
$topic_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
}
// If this is the only post remaining we do not need to decrement topic_replies.
// Also do not decrement if first post - then the topic_replies will not be adjusted if approving the topic again.
// If this is an edited topic or the first post the topic gets completely disapproved later on...
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_topics = forum_topics - 1';
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - ' . ($topic_row['topic_replies'] + 1);
set_config_count('num_topics', -1, true);
set_config_count('num_posts', ($topic_row['topic_replies'] + 1) * (-1), true);
// Only decrement this post, since this is the one non-approved now
if ($auth->acl_get('f_postcount', $data['forum_id']))
{
$sql_data[USERS_TABLE]['stat'][] = 'user_posts = user_posts - 1';
}
}
break;
case 'edit':
case 'edit_last_post':
// Correctly set back the topic replies and forum posts... but only if the post was approved before.
if (!$post_approval && $data['post_approved'])
{
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_replies = topic_replies - 1, topic_last_view_time = ' . $current_time;
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_posts = forum_posts - 1';
set_config_count('num_posts', -1, true);
if ($auth->acl_get('f_postcount', $data['forum_id']))
{
$sql_data[USERS_TABLE]['stat'][] = 'user_posts = user_posts - 1';
}
}
break;
}
// Submit new topic
if ($post_mode == 'post')
{
$sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' .
$db->sql_build_array('INSERT', $sql_data[TOPICS_TABLE]['sql']);
$db->sql_query($sql);
$data['topic_id'] = $db->sql_nextid();
$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(
'topic_id' => $data['topic_id'])
);
unset($sql_data[TOPICS_TABLE]['sql']);
}
// Submit new post
if ($post_mode == 'post' || $post_mode == 'reply')
{
if ($post_mode == 'reply')
{
$sql_data[POSTS_TABLE]['sql'] = array_merge($sql_data[POSTS_TABLE]['sql'], array(
'topic_id' => $data['topic_id'])
);
}
$sql = 'INSERT INTO ' . POSTS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_data[POSTS_TABLE]['sql']);
$db->sql_query($sql);
$data['post_id'] = $db->sql_nextid();
if ($post_mode == 'post')
{
$sql_data[TOPICS_TABLE]['sql'] = array(
'topic_first_post_id' => $data['post_id'],
'topic_last_post_id' => $data['post_id'],
'topic_last_post_time' => $current_time,
'topic_last_poster_id' => (int) $user->data['user_id'],
'topic_last_poster_name' => (!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : ''),
'topic_last_poster_colour' => $user->data['user_colour'],
'topic_last_post_subject' => (string) $subject,
);
}
unset($sql_data[POSTS_TABLE]['sql']);
}
// Update the topics table
if (isset($sql_data[TOPICS_TABLE]['sql']))
{
$sql = 'UPDATE ' . TOPICS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_data[TOPICS_TABLE]['sql']) . '
WHERE topic_id = ' . $data['topic_id'];
$db->sql_query($sql);
}
// Update the posts table
if (isset($sql_data[POSTS_TABLE]['sql']))
{
$sql = 'UPDATE ' . POSTS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_data[POSTS_TABLE]['sql']) . '
WHERE post_id = ' . $data['post_id'];
$db->sql_query($sql);
}
// Update Poll Tables
if (isset($poll['poll_options']) && !empty($poll['poll_options']))
{
$cur_poll_options = array();
if ($poll['poll_start'] && $mode == 'edit')
{
$sql = 'SELECT *
FROM ' . POLL_OPTIONS_TABLE . '
WHERE topic_id = ' . $data['topic_id'] . '
ORDER BY poll_option_id';
$result = $db->sql_query($sql);
$cur_poll_options = array();
while ($row = $db->sql_fetchrow($result))
{
$cur_poll_options[] = $row;
}
$db->sql_freeresult($result);
}
$sql_insert_ary = array();
for ($i = 0, $size = sizeof($poll['poll_options']); $i < $size; $i++)
{
if (strlen(trim($poll['poll_options'][$i])))
{
if (empty($cur_poll_options[$i]))
{
// If we add options we need to put them to the end to be able to preserve votes...
$sql_insert_ary[] = array(
'poll_option_id' => (int) sizeof($cur_poll_options) + 1 + sizeof($sql_insert_ary),
'topic_id' => (int) $data['topic_id'],
'poll_option_text' => (string) $poll['poll_options'][$i]
);
}
else if ($poll['poll_options'][$i] != $cur_poll_options[$i])
{
$sql = 'UPDATE ' . POLL_OPTIONS_TABLE . "
SET poll_option_text = '" . $db->sql_escape($poll['poll_options'][$i]) . "'
WHERE poll_option_id = " . $cur_poll_options[$i]['poll_option_id'] . '
AND topic_id = ' . $data['topic_id'];
$db->sql_query($sql);
}
}
}
$db->sql_multi_insert(POLL_OPTIONS_TABLE, $sql_insert_ary);
if (sizeof($poll['poll_options']) < sizeof($cur_poll_options))
{
$sql = 'DELETE FROM ' . POLL_OPTIONS_TABLE . '
WHERE poll_option_id > ' . sizeof($poll['poll_options']) . '
AND topic_id = ' . $data['topic_id'];
$db->sql_query($sql);
}
// If edited, we would need to reset votes (since options can be re-ordered above, you can't be sure if the change is for changing the text or adding an option
if ($mode == 'edit' && sizeof($poll['poll_options']) != sizeof($cur_poll_options))
{
$db->sql_query('DELETE FROM ' . POLL_VOTES_TABLE . ' WHERE topic_id = ' . $data['topic_id']);
$db->sql_query('UPDATE ' . POLL_OPTIONS_TABLE . ' SET poll_option_total = 0 WHERE topic_id = ' . $data['topic_id']);
}
}
// Submit Attachments
if (!empty($data['attachment_data']) && $data['post_id'] && in_array($mode, array('post', 'reply', 'quote', 'edit')))
{
$space_taken = $files_added = 0;
$orphan_rows = array();
foreach ($data['attachment_data'] as $pos => $attach_row)
{
$orphan_rows[(int) $attach_row['attach_id']] = array();
}
if (sizeof($orphan_rows))
{
$sql = 'SELECT attach_id, filesize, physical_filename
FROM ' . ATTACHMENTS_TABLE . '
WHERE ' . $db->sql_in_set('attach_id', array_keys($orphan_rows)) . '
AND is_orphan = 1
AND poster_id = ' . $user->data['user_id'];
$result = $db->sql_query($sql);
$orphan_rows = array();
while ($row = $db->sql_fetchrow($result))
{
$orphan_rows[$row['attach_id']] = $row;
}
$db->sql_freeresult($result);
}
foreach ($data['attachment_data'] as $pos => $attach_row)
{
if ($attach_row['is_orphan'] && !isset($orphan_rows[$attach_row['attach_id']]))
{
continue;
}
if (!$attach_row['is_orphan'])
{
// update entry in db if attachment already stored in db and filespace
$sql = 'UPDATE ' . ATTACHMENTS_TABLE . "
SET attach_comment = '" . $db->sql_escape($attach_row['attach_comment']) . "'
WHERE attach_id = " . (int) $attach_row['attach_id'] . '
AND is_orphan = 0';
$db->sql_query($sql);
}
else
{
// insert attachment into db
if (!@file_exists($phpbb_root_path . $config['upload_path'] . '/' . utf8_basename($orphan_rows[$attach_row['attach_id']]['physical_filename'])))
{
continue;
}
$space_taken += $orphan_rows[$attach_row['attach_id']]['filesize'];
$files_added++;
$attach_sql = array(
'post_msg_id' => $data['post_id'],
'topic_id' => $data['topic_id'],
'is_orphan' => 0,
'poster_id' => $poster_id,
'attach_comment' => $attach_row['attach_comment'],
);
$sql = 'UPDATE ' . ATTACHMENTS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $attach_sql) . '
WHERE attach_id = ' . $attach_row['attach_id'] . '
AND is_orphan = 1
AND poster_id = ' . $user->data['user_id'];
$db->sql_query($sql);
}
}
if ($space_taken && $files_added)
{
set_config_count('upload_dir_size', $space_taken, true);
set_config_count('num_files', $files_added, true);
}
}
// we need to update the last forum information
// only applicable if the topic is approved
if ($post_approved || !$data['post_approved'])
{
// the last post makes us update the forum table. This can happen if...
// We make a new topic
// We reply to a topic
// We edit the last post in a topic and this post is the latest in the forum (maybe)
// We edit the only post in the topic
// We edit the first post in the topic and all the other posts are not approved
if (($post_mode == 'post' || $post_mode == 'reply') && $post_approved)
{
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . $data['post_id'];
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($subject) . "'";
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . $current_time;
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $user->data['user_id'];
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape((!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')) . "'";
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($user->data['user_colour']) . "'";
}
else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))
{
// this does not _necessarily_ mean that we must update the info again,
// it just means that we might have to
$sql = 'SELECT forum_last_post_id, forum_last_post_subject
FROM ' . FORUMS_TABLE . '
WHERE forum_id = ' . (int) $data['forum_id'];
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// this post is the latest post in the forum, better update
if ($row['forum_last_post_id'] == $data['post_id'])
{
// If post approved and subject changed, or poster is anonymous, we need to update the forum_last* rows
if ($post_approved && ($row['forum_last_post_subject'] !== $subject || $data['poster_id'] == ANONYMOUS))
{
// the post's subject changed
if ($row['forum_last_post_subject'] !== $subject)
{
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_subject = \'' . $db->sql_escape($subject) . '\'';
}
// Update the user name if poster is anonymous... just in case an admin changed it
if ($data['poster_id'] == ANONYMOUS)
{
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape($username) . "'";
}
}
else if ($data['post_approved'] !== $post_approved)
{
// we need a fresh change of socks, everything has become invalidated
$sql = 'SELECT MAX(topic_last_post_id) as last_post_id
FROM ' . TOPICS_TABLE . '
WHERE forum_id = ' . (int) $data['forum_id'] . '
AND topic_approved = 1';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// any posts left in this forum?
if (!empty($row['last_post_id']))
{
$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour
FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
WHERE p.poster_id = u.user_id
AND p.post_id = ' . (int) $row['last_post_id'];
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// salvation, a post is found! jam it into the forums table
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = ' . (int) $row['post_id'];
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = ' . (int) $row['post_time'];
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = ' . (int) $row['poster_id'];
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";
}
else
{
// just our luck, the last topic in the forum has just been turned unapproved...
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_id = 0';
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_post_subject = ''";
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_post_time = 0';
$sql_data[FORUMS_TABLE]['stat'][] = 'forum_last_poster_id = 0';
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_name = ''";
$sql_data[FORUMS_TABLE]['stat'][] = "forum_last_poster_colour = ''";
}
}
}
}
}
// topic sync time!
// simply, we update if it is a reply or the last post is edited
if ($post_approved)
{
// reply requires the whole thing
if ($post_mode == 'reply')
{
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $data['post_id'];
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) $user->data['user_id'];
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_name = '" . $db->sql_escape((!$user->data['is_registered'] && $username) ? $username : (($user->data['user_id'] != ANONYMOUS) ? $user->data['username'] : '')) . "'";
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_colour = '" . (($user->data['user_id'] != ANONYMOUS) ? $db->sql_escape($user->data['user_colour']) : '') . "'";
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_post_subject = '" . $db->sql_escape($subject) . "'";
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $current_time;
}
else if ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies']))
{
// only the subject can be changed from edit
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_post_subject = '" . $db->sql_escape($subject) . "'";
// Maybe not only the subject, but also changing anonymous usernames. ;)
if ($data['poster_id'] == ANONYMOUS)
{
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_name = '" . $db->sql_escape($username) . "'";
}
}
}
else if (!$data['post_approved'] && ($post_mode == 'edit_last_post' || $post_mode == 'edit_topic' || ($post_mode == 'edit_first_post' && !$data['topic_replies'])))
{
// like having the rug pulled from under us
$sql = 'SELECT MAX(post_id) as last_post_id
FROM ' . POSTS_TABLE . '
WHERE topic_id = ' . (int) $data['topic_id'] . '
AND post_approved = 1';
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// any posts left in this forum?
if (!empty($row['last_post_id']))
{
$sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.user_id, u.username, u.user_colour
FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
WHERE p.poster_id = u.user_id
AND p.post_id = ' . (int) $row['last_post_id'];
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
// salvation, a post is found! jam it into the topics table
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_id = ' . (int) $row['post_id'];
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_post_subject = '" . $db->sql_escape($row['post_subject']) . "'";
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_post_time = ' . (int) $row['post_time'];
$sql_data[TOPICS_TABLE]['stat'][] = 'topic_last_poster_id = ' . (int) $row['poster_id'];
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_name = '" . $db->sql_escape(($row['poster_id'] == ANONYMOUS) ? $row['post_username'] : $row['username']) . "'";
$sql_data[TOPICS_TABLE]['stat'][] = "topic_last_poster_colour = '" . $db->sql_escape($row['user_colour']) . "'";
}
}
// Update total post count, do not consider moderated posts/topics
if ($post_approval)
{
if ($post_mode == 'post')
{
set_config_count('num_topics', 1, true);
set_config_count('num_posts', 1, true);
}
if ($post_mode == 'reply')
{
set_config_count('num_posts', 1, true);
}
}
// Update forum stats
$where_sql = array(POSTS_TABLE => 'post_id = ' . $data['post_id'], TOPICS_TABLE => 'topic_id = ' . $data['topic_id'], FORUMS_TABLE => 'forum_id = ' . $data['forum_id'], USERS_TABLE => 'user_id = ' . $poster_id);
foreach ($sql_data as $table => $update_ary)
{
if (isset($update_ary['stat']) && implode('', $update_ary['stat']))
{
$sql = "UPDATE $table SET " . implode(', ', $update_ary['stat']) . ' WHERE ' . $where_sql[$table];
$db->sql_query($sql);
}
}
// Delete topic shadows (if any exist). We do not need a shadow topic for an global announcement
if ($topic_type == POST_GLOBAL)
{
$sql = 'DELETE FROM ' . TOPICS_TABLE . '
WHERE topic_moved_id = ' . $data['topic_id'];
$db->sql_query($sql);
}
// Committing the transaction before updating search index
$db->sql_transaction('commit');
// Delete draft if post was loaded...
$draft_id = request_var('draft_loaded', 0);
if ($draft_id)
{
$sql = 'DELETE FROM ' . DRAFTS_TABLE . "
WHERE draft_id = $draft_id
AND user_id = {$user->data['user_id']}";
$db->sql_query($sql);
}
// Index message contents
if ($update_search_index && $data['enable_indexing'])
{
// Select the search method and do some additional checks to ensure it can actually be utilised
$search_type = basename($config['search_type']);
if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx))
{
trigger_error('NO_SUCH_SEARCH_MODULE');
}
if (!class_exists($search_type))
{
include("{$phpbb_root_path}includes/search/$search_type.$phpEx");
}
$error = false;
$search = new $search_type($error);
if ($error)
{
trigger_error($error);
}
$search->index($mode, $data['post_id'], $data['message'], $subject, $poster_id, $data['forum_id']);
}
// Topic Notification, do not change if moderator is changing other users posts...
if ($user->data['user_id'] == $poster_id)
{
if (!$data['notify_set'] && $data['notify'])
{
$sql = 'INSERT INTO ' . TOPICS_WATCH_TABLE . ' (user_id, topic_id)
VALUES (' . $user->data['user_id'] . ', ' . $data['topic_id'] . ')';
$db->sql_query($sql);
}
else if (($config['email_enable'] || $config['jab_enable']) && $data['notify_set'] && !$data['notify'])
{
$sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . '
WHERE user_id = ' . $user->data['user_id'] . '
AND topic_id = ' . $data['topic_id'];
$db->sql_query($sql);
}
}
if ($mode == 'post' || $mode == 'reply' || $mode == 'quote')
{
// Mark this topic as posted to
markread('post', $data['forum_id'], $data['topic_id']);
}
// Mark this topic as read
// We do not use post_time here, this is intended (post_time can have a date in the past if editing a message)
markread('topic', $data['forum_id'], $data['topic_id'], time());
//
if ($config['load_db_lastread'] && $user->data['is_registered'])
{
$sql = 'SELECT mark_time
FROM ' . FORUMS_TRACK_TABLE . '
WHERE user_id = ' . $user->data['user_id'] . '
AND forum_id = ' . $data['forum_id'];
$result = $db->sql_query($sql);
$f_mark_time = (int) $db->sql_fetchfield('mark_time');
$db->sql_freeresult($result);
}
else if ($config['load_anon_lastread'] || $user->data['is_registered'])
{
$f_mark_time = false;
}
if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])
{
// Update forum info
$sql = 'SELECT forum_last_post_time
FROM ' . FORUMS_TABLE . '
WHERE forum_id = ' . $data['forum_id'];
$result = $db->sql_query($sql);
$forum_last_post_time = (int) $db->sql_fetchfield('forum_last_post_time');
$db->sql_freeresult($result);
update_forum_tracking_info($data['forum_id'], $forum_last_post_time, $f_mark_time, false);
}
// Send Notifications
if (($mode == 'reply' || $mode == 'quote' || $mode == 'post') && $post_approval)
{
user_notification($mode, $subject, $data['topic_title'], $data['forum_name'], $data['forum_id'], $data['topic_id'], $data['post_id']);
}
$params = $add_anchor = '';
if ($post_approval)
{
$params .= '&t=' . $data['topic_id'];
if ($mode != 'post')
{
$params .= '&p=' . $data['post_id'];
$add_anchor = '#p' . $data['post_id'];
}
}
else if ($mode != 'post' && $post_mode != 'edit_first_post' && $post_mode != 'edit_topic')
{
$params .= '&t=' . $data['topic_id'];
}
$url = (!$params) ? "{$phpbb_root_path}viewforum.$phpEx" : "{$phpbb_root_path}viewtopic.$phpEx";
$url = append_sid($url, 'f=' . $data['forum_id'] . $params) . $add_anchor;
return $url;
}
/**
* Handle topic bumping
* @param int $forum_id The ID of the forum the topic is being bumped belongs to
* @param int $topic_id The ID of the topic is being bumping
* @param array $post_data Passes some topic parameters:
* - 'topic_title'
* - 'topic_last_post_id'
* - 'topic_last_poster_id'
* - 'topic_last_post_subject'
* - 'topic_last_poster_name'
* - 'topic_last_poster_colour'
* @param int $bump_time The time at which topic was bumped, usually it is a current time as obtained via time().
* @return string An URL to the bumped topic, example: ./viewtopic.php?forum_id=1&topic_id=2&p=3#p3
*/
function phpbb_bump_topic($forum_id, $topic_id, $post_data, $bump_time = false)
{
global $config, $db, $user, $phpEx, $phpbb_root_path;
if ($bump_time === false)
{
$bump_time = time();
}
// Begin bumping
$db->sql_transaction('begin');
// Update the topic's last post post_time
$sql = 'UPDATE ' . POSTS_TABLE . "
SET post_time = $bump_time
WHERE post_id = {$post_data['topic_last_post_id']}
AND topic_id = $topic_id";
$db->sql_query($sql);
// Sync the topic's last post time, the rest of the topic's last post data isn't changed
$sql = 'UPDATE ' . TOPICS_TABLE . "
SET topic_last_post_time = $bump_time,
topic_bumped = 1,
topic_bumper = " . $user->data['user_id'] . "
WHERE topic_id = $topic_id";
$db->sql_query($sql);
// Update the forum's last post info
$sql = 'UPDATE ' . FORUMS_TABLE . "
SET forum_last_post_id = " . $post_data['topic_last_post_id'] . ",
forum_last_poster_id = " . $post_data['topic_last_poster_id'] . ",
forum_last_post_subject = '" . $db->sql_escape($post_data['topic_last_post_subject']) . "',
forum_last_post_time = $bump_time,
forum_last_poster_name = '" . $db->sql_escape($post_data['topic_last_poster_name']) . "',
forum_last_poster_colour = '" . $db->sql_escape($post_data['topic_last_poster_colour']) . "'
WHERE forum_id = $forum_id";
$db->sql_query($sql);
// Update bumper's time of the last posting to prevent flood
$sql = 'UPDATE ' . USERS_TABLE . "
SET user_lastpost_time = $bump_time
WHERE user_id = " . $user->data['user_id'];
$db->sql_query($sql);
$db->sql_transaction('commit');
// Mark this topic as posted to
markread('post', $forum_id, $topic_id, $bump_time);
// Mark this topic as read
markread('topic', $forum_id, $topic_id, $bump_time);
// Update forum tracking info
if ($config['load_db_lastread'] && $user->data['is_registered'])
{
$sql = 'SELECT mark_time
FROM ' . FORUMS_TRACK_TABLE . '
WHERE user_id = ' . $user->data['user_id'] . '
AND forum_id = ' . $forum_id;
$result = $db->sql_query($sql);
$f_mark_time = (int) $db->sql_fetchfield('mark_time');
$db->sql_freeresult($result);
}
else if ($config['load_anon_lastread'] || $user->data['is_registered'])
{
$f_mark_time = false;
}
if (($config['load_db_lastread'] && $user->data['is_registered']) || $config['load_anon_lastread'] || $user->data['is_registered'])
{
// Update forum info
$sql = 'SELECT forum_last_post_time
FROM ' . FORUMS_TABLE . '
WHERE forum_id = ' . $forum_id;
$result = $db->sql_query($sql);
$forum_last_post_time = (int) $db->sql_fetchfield('forum_last_post_time');
$db->sql_freeresult($result);
update_forum_tracking_info($forum_id, $forum_last_post_time, $f_mark_time, false);
}
add_log('mod', $forum_id, $topic_id, 'LOG_BUMP_TOPIC', $post_data['topic_title']);
$url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&t=$topic_id&p={$post_data['topic_last_post_id']}") . "#p{$post_data['topic_last_post_id']}";
return $url;
}