12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986398739883989399039913992399339943995399639973998399940004001400240034004400540064007400840094010401140124013401440154016401740184019402040214022402340244025402640274028402940304031403240334034403540364037403840394040404140424043404440454046404740484049405040514052405340544055405640574058405940604061406240634064406540664067406840694070407140724073407440754076407740784079408040814082408340844085408640874088408940904091409240934094409540964097409840994100410141024103410441054106410741084109411041114112411341144115411641174118411941204121412241234124412541264127412841294130413141324133413441354136413741384139414041414142414341444145414641474148414941504151415241534154415541564157415841594160416141624163416441654166416741684169417041714172417341744175417641774178417941804181418241834184418541864187418841894190419141924193419441954196419741984199420042014202420342044205420642074208420942104211421242134214421542164217421842194220422142224223422442254226422742284229423042314232423342344235423642374238423942404241424242434244424542464247424842494250425142524253425442554256425742584259426042614262426342644265426642674268426942704271427242734274427542764277427842794280428142824283428442854286428742884289429042914292429342944295429642974298429943004301430243034304430543064307430843094310431143124313431443154316431743184319432043214322432343244325432643274328432943304331433243334334433543364337433843394340434143424343434443454346434743484349435043514352435343544355435643574358435943604361436243634364436543664367436843694370437143724373437443754376437743784379438043814382438343844385438643874388438943904391439243934394439543964397439843994400440144024403440444054406440744084409441044114412441344144415441644174418441944204421442244234424442544264427442844294430443144324433443444354436443744384439444044414442444344444445444644474448444944504451445244534454445544564457445844594460446144624463446444654466446744684469447044714472447344744475447644774478447944804481448244834484448544864487448844894490449144924493449444954496449744984499450045014502450345044505450645074508450945104511451245134514451545164517451845194520452145224523452445254526452745284529453045314532453345344535453645374538453945404541454245434544454545464547454845494550455145524553455445554556455745584559456045614562456345644565456645674568456945704571457245734574457545764577457845794580458145824583458445854586458745884589459045914592459345944595459645974598459946004601460246034604460546064607460846094610461146124613461446154616461746184619462046214622462346244625462646274628462946304631463246334634463546364637463846394640464146424643464446454646464746484649465046514652465346544655465646574658465946604661466246634664466546664667466846694670467146724673467446754676467746784679468046814682468346844685468646874688468946904691469246934694469546964697469846994700470147024703470447054706470747084709471047114712471347144715471647174718471947204721472247234724472547264727472847294730473147324733473447354736473747384739474047414742474347444745474647474748474947504751475247534754475547564757475847594760476147624763476447654766476747684769477047714772477347744775477647774778477947804781478247834784478547864787478847894790479147924793479447954796479747984799480048014802480348044805480648074808480948104811481248134814481548164817481848194820482148224823482448254826482748284829483048314832483348344835483648374838483948404841484248434844484548464847484848494850485148524853485448554856485748584859486048614862486348644865486648674868486948704871487248734874487548764877487848794880488148824883488448854886488748884889489048914892489348944895489648974898489949004901490249034904490549064907490849094910491149124913491449154916491749184919492049214922492349244925492649274928492949304931493249334934493549364937493849394940494149424943494449454946494749484949495049514952495349544955495649574958495949604961496249634964496549664967496849694970497149724973497449754976497749784979498049814982498349844985498649874988498949904991499249934994499549964997499849995000500150025003500450055006500750085009501050115012501350145015501650175018501950205021502250235024502550265027502850295030503150325033503450355036503750385039504050415042504350445045504650475048504950505051505250535054505550565057505850595060506150625063506450655066506750685069507050715072507350745075507650775078507950805081508250835084508550865087508850895090509150925093509450955096509750985099510051015102510351045105510651075108510951105111511251135114511551165117511851195120512151225123512451255126512751285129513051315132513351345135513651375138513951405141514251435144514551465147514851495150515151525153515451555156515751585159516051615162516351645165516651675168516951705171517251735174517551765177517851795180518151825183518451855186518751885189519051915192519351945195519651975198519952005201520252035204520552065207520852095210521152125213521452155216521752185219522052215222522352245225522652275228522952305231523252335234523552365237523852395240524152425243524452455246524752485249525052515252525352545255525652575258525952605261526252635264526552665267526852695270527152725273527452755276527752785279528052815282528352845285528652875288528952905291529252935294529552965297529852995300530153025303530453055306530753085309531053115312531353145315531653175318531953205321532253235324532553265327532853295330533153325333533453355336533753385339534053415342534353445345534653475348534953505351535253535354535553565357535853595360536153625363536453655366536753685369537053715372537353745375537653775378537953805381538253835384538553865387538853895390539153925393539453955396539753985399540054015402540354045405540654075408540954105411541254135414541554165417541854195420542154225423542454255426542754285429543054315432543354345435543654375438543954405441544254435444544554465447544854495450545154525453545454555456545754585459546054615462546354645465546654675468546954705471547254735474547554765477547854795480548154825483548454855486548754885489549054915492549354945495549654975498549955005501550255035504550555065507550855095510551155125513551455155516551755185519552055215522552355245525552655275528552955305531553255335534553555365537553855395540554155425543554455455546554755485549555055515552555355545555555655575558555955605561556255635564556555665567556855695570557155725573557455755576557755785579558055815582558355845585558655875588558955905591559255935594559555965597559855995600560156025603560456055606560756085609561056115612561356145615561656175618561956205621562256235624562556265627562856295630563156325633563456355636563756385639564056415642564356445645564656475648564956505651565256535654565556565657565856595660566156625663566456655666566756685669567056715672567356745675567656775678567956805681568256835684568556865687568856895690569156925693569456955696569756985699570057015702570357045705570657075708570957105711571257135714571557165717571857195720572157225723572457255726572757285729573057315732573357345735573657375738573957405741574257435744574557465747574857495750575157525753575457555756575757585759576057615762576357645765576657675768576957705771577257735774577557765777577857795780578157825783578457855786578757885789579057915792579357945795579657975798579958005801580258035804580558065807580858095810581158125813581458155816581758185819582058215822582358245825582658275828582958305831583258335834583558365837583858395840584158425843584458455846584758485849585058515852585358545855585658575858585958605861586258635864586558665867586858695870587158725873587458755876587758785879588058815882588358845885588658875888588958905891589258935894589558965897589858995900590159025903590459055906590759085909591059115912591359145915591659175918591959205921592259235924592559265927592859295930593159325933593459355936593759385939594059415942594359445945594659475948594959505951595259535954595559565957595859595960596159625963596459655966596759685969597059715972597359745975597659775978597959805981598259835984598559865987598859895990599159925993599459955996599759985999600060016002600360046005600660076008600960106011601260136014601560166017601860196020602160226023602460256026602760286029603060316032603360346035603660376038603960406041604260436044604560466047604860496050605160526053605460556056605760586059606060616062606360646065606660676068606960706071607260736074607560766077607860796080608160826083608460856086608760886089609060916092609360946095609660976098609961006101610261036104610561066107610861096110611161126113611461156116611761186119612061216122612361246125612661276128612961306131613261336134613561366137613861396140614161426143614461456146614761486149615061516152615361546155615661576158615961606161616261636164616561666167616861696170617161726173617461756176617761786179618061816182618361846185618661876188618961906191619261936194619561966197619861996200620162026203620462056206620762086209621062116212621362146215621662176218621962206221622262236224622562266227622862296230623162326233623462356236623762386239624062416242624362446245624662476248624962506251625262536254625562566257625862596260626162626263626462656266626762686269627062716272627362746275627662776278627962806281628262836284628562866287628862896290629162926293629462956296629762986299630063016302630363046305630663076308630963106311631263136314631563166317631863196320632163226323632463256326632763286329633063316332633363346335633663376338633963406341634263436344634563466347634863496350635163526353635463556356635763586359636063616362636363646365636663676368636963706371637263736374637563766377637863796380638163826383638463856386638763886389639063916392639363946395639663976398639964006401640264036404640564066407640864096410641164126413641464156416641764186419642064216422642364246425642664276428642964306431643264336434643564366437643864396440644164426443644464456446644764486449645064516452645364546455645664576458645964606461646264636464646564666467646864696470647164726473647464756476647764786479648064816482648364846485648664876488648964906491649264936494649564966497649864996500650165026503650465056506650765086509651065116512651365146515651665176518651965206521652265236524652565266527652865296530653165326533653465356536653765386539654065416542654365446545654665476548654965506551655265536554655565566557655865596560656165626563656465656566656765686569657065716572657365746575657665776578657965806581658265836584658565866587658865896590659165926593659465956596659765986599660066016602660366046605660666076608660966106611661266136614661566166617661866196620662166226623662466256626662766286629663066316632663366346635663666376638663966406641664266436644664566466647664866496650665166526653665466556656665766586659666066616662666366646665666666676668666966706671667266736674667566766677667866796680668166826683668466856686668766886689669066916692669366946695669666976698669967006701670267036704670567066707670867096710671167126713671467156716671767186719672067216722672367246725672667276728672967306731673267336734673567366737673867396740674167426743674467456746674767486749675067516752675367546755675667576758675967606761676267636764676567666767676867696770677167726773677467756776677767786779678067816782678367846785678667876788678967906791679267936794679567966797679867996800680168026803680468056806680768086809681068116812681368146815681668176818681968206821682268236824682568266827682868296830683168326833683468356836683768386839684068416842684368446845684668476848684968506851685268536854685568566857685868596860686168626863686468656866686768686869687068716872687368746875687668776878687968806881688268836884688568866887688868896890689168926893689468956896689768986899690069016902690369046905690669076908690969106911691269136914691569166917691869196920692169226923692469256926692769286929693069316932693369346935693669376938693969406941694269436944694569466947694869496950695169526953695469556956695769586959 |
- <?php
- /* For licensing terms, see /license.txt */
- use Chamilo\CourseBundle\Entity\CForumPost;
- use Chamilo\CourseBundle\Entity\CForumThread;
- use Chamilo\UserBundle\Entity\User;
- use ChamiloSession as Session;
- use Doctrine\Common\Collections\Criteria;
- /**
- * These files are a complete rework of the forum. The database structure is
- * based on phpBB but all the code is rewritten. A lot of new functionalities
- * are added:
- * - forum categories and forums can be sorted up or down, locked or made invisible
- * - consistent and integrated forum administration
- * - forum options: are students allowed to edit their post?
- * moderation of posts (approval)
- * reply only forums (students cannot create new threads)
- * multiple forums per group
- * - sticky messages
- * - new view option: nested view
- * - quoting a message.
- *
- * @package chamilo.forum
- *
- * @todo convert into a class
- */
- define('FORUM_NEW_POST', 0);
- getNotificationsPerUser();
- $htmlHeadXtra[] = api_get_jquery_libraries_js(['jquery-ui', 'jquery-upload']);
- $htmlHeadXtra[] = '<script>
- function check_unzip() {
- if (document.upload.unzip.checked){
- document.upload.if_exists[0].disabled=true;
- document.upload.if_exists[1].checked=true;
- document.upload.if_exists[2].disabled=true;
- } else {
- document.upload.if_exists[0].checked=true;
- document.upload.if_exists[0].disabled=false;
- document.upload.if_exists[2].disabled=false;
- }
- }
- function setFocus() {
- $("#title_file").focus();
- }
- </script>';
- // The next javascript script is to manage ajax upload file
- $htmlHeadXtra[] = api_get_jquery_libraries_js(['jquery-ui', 'jquery-upload']);
- // Recover Thread ID, will be used to generate delete attachment URL to do ajax
- $threadId = isset($_REQUEST['thread']) ? intval($_REQUEST['thread']) : 0;
- $forumId = isset($_REQUEST['forum']) ? intval($_REQUEST['forum']) : 0;
- $ajaxUrl = api_get_path(WEB_AJAX_PATH).'forum.ajax.php?'.api_get_cidreq();
- // The next javascript script is to delete file by ajax
- $htmlHeadXtra[] = '<script>
- $(function () {
- $(document).on("click", ".deleteLink", function(e) {
- e.preventDefault();
- e.stopPropagation();
- var l = $(this);
- var id = l.closest("tr").attr("id");
- var filename = l.closest("tr").find(".attachFilename").html();
- if (confirm("'.get_lang('Are you sure to delete').'", filename)) {
- $.ajax({
- type: "POST",
- url: "'.$ajaxUrl.'&a=delete_file&attachId=" + id +"&thread='.$threadId.'&forum='.$forumId.'",
- dataType: "json",
- success: function(data) {
- if (data.error == false) {
- l.closest("tr").remove();
- if ($(".files td").length < 1) {
- $(".files").closest(".control-group").hide();
- }
- }
- }
- })
- }
- });
- });
- </script>';
- /**
- * This function handles all the forum and forum categories actions. This is a wrapper for the
- * forum and forum categories. All this code code could go into the section where this function is
- * called but this make the code there cleaner.
- *
- * @param int $lp_id Learning path Id
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @author Juan Carlos Raña Trabado (return to lp_id)
- *
- * @version may 2011, Chamilo 1.8.8
- */
- function handle_forum_and_forumcategories($lp_id = null)
- {
- $action_forum_cat = isset($_GET['action']) ? $_GET['action'] : '';
- $get_content = isset($_GET['content']) ? $_GET['content'] : '';
- $post_submit_cat = isset($_POST['SubmitForumCategory']) ? true : false;
- $post_submit_forum = isset($_POST['SubmitForum']) ? true : false;
- $get_id = isset($_GET['id']) ? (int) $_GET['id'] : 0;
- $forum_categories_list = get_forum_categories();
- // Verify if forum category exists
- if (empty($forum_categories_list)) {
- $get_content = 'forumcategory';
- }
- $content = '';
- // Adding a forum category
- if (($action_forum_cat === 'add' && $get_content === 'forumcategory') || $post_submit_cat) {
- $content = show_add_forumcategory_form([], $lp_id); //$lp_id when is called from learning path
- }
- // Adding a forum
- if ((($action_forum_cat === 'add' || $action_forum_cat === 'edit') && $get_content === 'forum') ||
- $post_submit_forum
- ) {
- $inputvalues = [];
- if ($action_forum_cat === 'edit' && $get_id || $post_submit_forum) {
- $inputvalues = get_forums($get_id);
- }
- $content = show_add_forum_form($inputvalues, $lp_id);
- }
- // Edit a forum category
- if (($action_forum_cat === 'edit' && $get_content === 'forumcategory') ||
- (isset($_POST['SubmitEditForumCategory'])) ? true : false
- ) {
- $forum_category = get_forum_categories($get_id);
- $content = show_edit_forumcategory_form($forum_category);
- }
- // Delete a forum category
- if ($action_forum_cat === 'delete') {
- $list_threads = get_threads($get_id);
- for ($i = 0; $i < count($list_threads); $i++) {
- deleteForumCategoryThread('thread', $list_threads[$i]['thread_id']);
- $link_info = GradebookUtils::isResourceInCourseGradebook(
- api_get_course_id(),
- 5,
- $list_threads[$i]['thread_id'],
- api_get_session_id()
- );
- if ($link_info !== false) {
- GradebookUtils::remove_resource_from_course_gradebook($link_info['id']);
- }
- }
- deleteForumCategoryThread($get_content, $get_id);
- }
- // Change visibility of a forum or a forum category.
- if ($action_forum_cat === 'invisible' || $action_forum_cat === 'visible') {
- $return_message = change_visibility($get_content, $get_id, $action_forum_cat);
- Display::addFlash(
- Display::return_message($return_message, 'confirmation', false)
- );
- }
- // Change lock status of a forum or a forum category.
- if ($action_forum_cat === 'lock' || $action_forum_cat === 'unlock') {
- $return_message = change_lock_status($get_content, $get_id, $action_forum_cat);
- Display::addFlash(
- Display::return_message($return_message, 'confirmation', false)
- );
- }
- // Move a forum or a forum category.
- if ($action_forum_cat === 'move' && isset($_GET['direction'])) {
- $return_message = move_up_down($get_content, $_GET['direction'], $get_id);
- Display::addFlash(
- Display::return_message($return_message, 'confirmation', false)
- );
- }
- return $content;
- }
- /**
- * This function displays the form that is used to add a forum category.
- *
- * @param array $inputvalues (deprecated, set to null when calling)
- * @param int $lp_id Learning path ID
- *
- * @return string
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @author Juan Carlos Raña Trabado (return to lp_id)
- *
- * @version may 2011, Chamilo 1.8.8
- */
- function show_add_forumcategory_form($inputvalues = [], $lp_id)
- {
- $form = new FormValidator(
- 'forumcategory',
- 'post',
- 'index.php?'.api_get_cidreq()
- );
- // hidden field if from learning path
- $form->addElement('hidden', 'lp_id', $lp_id);
- // Setting the form elements.
- $form->addElement('header', get_lang('Add forum category'));
- $form->addElement('text', 'forum_category_title', get_lang('Title'), ['autofocus']);
- $form->addElement(
- 'html_editor',
- 'forum_category_comment',
- get_lang('Description'),
- null,
- ['ToolbarSet' => 'Forum', 'Width' => '98%', 'Height' => '200']
- );
- $extraField = new ExtraField('forum_category');
- $returnParams = $extraField->addElements(
- $form,
- null,
- [], //exclude
- false, // filter
- false, // tag as select
- [], //show only fields
- [], // order fields
- [] // extra data
- );
- $form->addButtonCreate(get_lang('Create category'), 'SubmitForumCategory');
- // Setting the rules.
- $form->addRule('forum_category_title', get_lang('Required field'), 'required');
- // The validation or display
- if ($form->validate()) {
- $check = Security::check_token('post');
- if ($check) {
- $values = $form->exportValues();
- store_forumcategory($values);
- }
- Security::clear_token();
- } else {
- $token = Security::get_token();
- $form->addElement('hidden', 'sec_token');
- $form->setConstants(['sec_token' => $token]);
- return $form->returnForm();
- }
- }
- /**
- * This function displays the form that is used to add a forum category.
- *
- * @param array $inputvalues
- * @param int $lp_id
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @author Juan Carlos Raña Trabado (return to lp_id)
- *
- * @version may 2011, Chamilo 1.8.8
- */
- function show_add_forum_form($inputvalues = [], $lp_id)
- {
- $_course = api_get_course_info();
- $form = new FormValidator('forumcategory', 'post', 'index.php?'.api_get_cidreq());
- // The header for the form
- $form_title = get_lang('Add a forum');
- if (!empty($inputvalues)) {
- $form_title = get_lang('Edit forum');
- }
- $form->addHeader($form_title);
- // We have a hidden field if we are editing.
- if (!empty($inputvalues) && is_array($inputvalues)) {
- $my_forum_id = isset($inputvalues['forum_id']) ? $inputvalues['forum_id'] : null;
- $form->addElement('hidden', 'forum_id', $my_forum_id);
- }
- $lp_id = (int) $lp_id;
- // hidden field if from learning path
- $form->addElement('hidden', 'lp_id', $lp_id);
- // The title of the forum
- $form->addElement('text', 'forum_title', get_lang('Title'), ['autofocus']);
- // The comment of the forum.
- $form->addElement(
- 'html_editor',
- 'forum_comment',
- get_lang('Description'),
- null,
- ['ToolbarSet' => 'Forum', 'Width' => '98%', 'Height' => '200']
- );
- // Dropdown list: Forum categories
- $forum_categories = get_forum_categories();
- foreach ($forum_categories as $key => $value) {
- $forum_categories_titles[$value['cat_id']] = $value['cat_title'];
- }
- $form->addElement(
- 'select',
- 'forum_category',
- get_lang('Create in category'),
- $forum_categories_titles
- );
- $form->applyFilter('forum_category', 'html_filter');
- if ($_course['visibility'] == COURSE_VISIBILITY_OPEN_WORLD) {
- // This is for horizontal
- $group = [];
- $group[] = $form->createElement('radio', 'allow_anonymous', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'allow_anonymous', null, get_lang('No'), 0);
- $form->addGroup($group, 'allow_anonymous_group', get_lang('Allow anonymous posts?'));
- }
- $form->addButtonAdvancedSettings('advanced_params');
- $form->addElement('html', '<div id="advanced_params_options" style="display:none">');
- $form->addDateTimePicker(
- 'start_time',
- [get_lang('Public access (access authorized to any member of the course)ation date'), get_lang('Public access (access authorized to any member of the course)ation dateComment')],
- ['id' => 'start_time']
- );
- $form->addDateTimePicker(
- 'end_time',
- [get_lang('Closing date'), get_lang('Closing dateComment')],
- ['id' => 'end_time']
- );
- $form->addRule(
- ['start_time', 'end_time'],
- get_lang('Start date must be before the end date'),
- 'compare_datetime_text',
- '< allow_empty'
- );
- $group = [];
- $group[] = $form->createElement('radio', 'moderated', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'moderated', null, get_lang('No'), 0);
- $form->addGroup($group, 'moderated', get_lang('Moderated forum'));
- $group = [];
- $group[] = $form->createElement('radio', 'students_can_edit', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'students_can_edit', null, get_lang('No'), 0);
- $form->addGroup($group, 'students_can_edit_group', get_lang('Can learners edit their own posts?'));
- $group = [];
- $group[] = $form->createElement('radio', 'approval_direct', null, get_lang('Approval'), 1);
- $group[] = $form->createElement('radio', 'approval_direct', null, get_lang('Direct'), 0);
- $group = [];
- $group[] = $form->createElement('radio', 'allow_attachments', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'allow_attachments', null, get_lang('No'), 0);
- $group = [];
- $group[] = $form->createElement('radio', 'allow_new_threads', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'allow_new_threads', null, get_lang('No'), 0);
- $form->addGroup($group, 'allow_new_threads_group', get_lang('Allow users to start new threads'));
- $group = [];
- $group[] = $form->createElement('radio', 'default_view_type', null, get_lang('Flat'), 'flat');
- $group[] = $form->createElement('radio', 'default_view_type', null, get_lang('Threaded'), 'threaded');
- $group[] = $form->createElement('radio', 'default_view_type', null, get_lang('Nested'), 'nested');
- $form->addGroup($group, 'default_view_type_group', get_lang('Default view type'));
- // Drop down list: Groups
- $groups = GroupManager::get_group_list();
- $groups_titles[0] = get_lang('Not a group forum');
- foreach ($groups as $key => $value) {
- $groups_titles[$value['id']] = $value['name'];
- }
- $form->addElement('select', 'group_forum', get_lang('For Group'), $groups_titles);
- // Public or private group forum
- $group = [];
- $group[] = $form->createElement('radio', 'public_private_group_forum', null, get_lang('Public access (access authorized to any member of the course)'), 'public');
- $group[] = $form->createElement('radio', 'public_private_group_forum', null, get_lang('Private access (access authorized to group members only)'), 'private');
- $form->addGroup($group, 'public_private_group_forum_group', get_lang('Public access (access authorized to any member of the course)Private access (access authorized to group members only)GroupForum'));
- // Forum image
- $form->addProgress();
- if (!empty($inputvalues['forum_image'])) {
- $baseImagePath = api_get_course_path().'/upload/forum/images/'.$inputvalues['forum_image'];
- $image_path = api_get_path(WEB_COURSE_PATH).$baseImagePath;
- $sysImagePath = api_get_path(SYS_COURSE_PATH).$baseImagePath;
- if (file_exists($sysImagePath)) {
- $show_preview_image = Display::img(
- $image_path,
- null,
- ['class' => 'img-responsive']
- );
- $form->addElement('label', get_lang('Preview image'), $show_preview_image);
- $form->addElement('checkbox', 'remove_picture', null, get_lang('Remove picture'));
- }
- }
- $forum_image = isset($inputvalues['forum_image']) ? $inputvalues['forum_image'] : '';
- $form->addElement('file', 'picture', ($forum_image != '' ? get_lang('Update Image') : get_lang('Add image')));
- $form->addRule(
- 'picture',
- get_lang('Only PNG, JPG or GIF images allowed'),
- 'filetype',
- ['jpg', 'jpeg', 'png', 'gif']
- );
- //$forumId = isset($_GET['id']) ? (int) $_GET['id'] : 0;
- //$skillList = Skill::addSkillsToForm($form, ITEM_TYPE_FORUM, $forumId);
- $form->addElement('html', '</div>');
- // The OK button
- if (isset($_GET['id']) && $_GET['action'] == 'edit') {
- $form->addButtonUpdate(get_lang('Edit forum'), 'SubmitForum');
- } else {
- $form->addButtonCreate(get_lang('Create forum'), 'SubmitForum');
- }
- // setting the rules
- $form->addRule('forum_title', get_lang('Required field'), 'required');
- $form->addRule('forum_category', get_lang('Required field'), 'required');
- $defaultSettingAllowNewThreads = api_get_default_tool_setting('forum', 'allow_new_threads', 0);
- // Settings the defaults
- if (empty($inputvalues) || !is_array($inputvalues)) {
- $defaults['moderated']['moderated'] = 0;
- $defaults['allow_anonymous_group']['allow_anonymous'] = 0;
- $defaults['students_can_edit_group']['students_can_edit'] = 0;
- $defaults['approval_direct_group']['approval_direct'] = 0;
- $defaults['allow_attachments_group']['allow_attachments'] = 1;
- $defaults['allow_new_threads_group']['allow_new_threads'] = $defaultSettingAllowNewThreads;
- $defaults['default_view_type_group']['default_view_type'] = api_get_setting('default_forum_view');
- $defaults['public_private_group_forum_group']['public_private_group_forum'] = 'public';
- if (isset($_GET['forumcategory'])) {
- $defaults['forum_category'] = Security::remove_XSS($_GET['forumcategory']);
- }
- } else {
- // the default values when editing = the data in the table
- $defaults['forum_id'] = isset($inputvalues['forum_id']) ? $inputvalues['forum_id'] : null;
- $defaults['forum_title'] = prepare4display(isset($inputvalues['forum_title']) ? $inputvalues['forum_title'] : null);
- $defaults['forum_comment'] = prepare4display(isset($inputvalues['forum_comment']) ? $inputvalues['forum_comment'] : null);
- $defaults['start_time'] = isset($inputvalues['start_time']) ? api_get_local_time($inputvalues['start_time']) : null;
- $defaults['end_time'] = isset($inputvalues['end_time']) ? api_get_local_time($inputvalues['end_time']) : null;
- $defaults['moderated']['moderated'] = isset($inputvalues['moderated']) ? $inputvalues['moderated'] : 0;
- $defaults['forum_category'] = isset($inputvalues['forum_category']) ? $inputvalues['forum_category'] : null;
- $defaults['allow_anonymous_group']['allow_anonymous'] = isset($inputvalues['allow_anonymous']) ? $inputvalues['allow_anonymous'] : null;
- $defaults['students_can_edit_group']['students_can_edit'] = isset($inputvalues['allow_edit']) ? $inputvalues['allow_edit'] : null;
- $defaults['approval_direct_group']['approval_direct'] = isset($inputvalues['approval_direct_post']) ? $inputvalues['approval_direct_post'] : null;
- $defaults['allow_attachments_group']['allow_attachments'] = isset($inputvalues['allow_attachments']) ? $inputvalues['allow_attachments'] : null;
- $defaults['allow_new_threads_group']['allow_new_threads'] = isset($inputvalues['allow_new_threads']) ? $inputvalues['allow_new_threads'] : $defaultSettingAllowNewThreads;
- $defaults['default_view_type_group']['default_view_type'] = isset($inputvalues['default_view']) ? $inputvalues['default_view'] : null;
- $defaults['public_private_group_forum_group']['public_private_group_forum'] = isset($inputvalues['forum_group_public_private']) ? $inputvalues['forum_group_public_private'] : null;
- $defaults['group_forum'] = isset($inputvalues['forum_of_group']) ? $inputvalues['forum_of_group'] : null;
- }
- $form->setDefaults($defaults);
- // Validation or display
- if ($form->validate()) {
- $check = Security::check_token('post');
- if ($check) {
- $values = $form->getSubmitValues();
- $forumId = store_forum($values, '', true);
- if ($forumId) {
- // Skill::saveSkills($form, ITEM_TYPE_FORUM, $forumId);
- if (isset($values['forum_id'])) {
- Display::addFlash(Display::return_message(get_lang('The forum has been modified'), 'confirmation'));
- } else {
- Display::addFlash(Display::return_message(get_lang('The forum has been added'), 'confirmation'));
- }
- }
- }
- Security::clear_token();
- } else {
- $token = Security::get_token();
- $form->addElement('hidden', 'sec_token');
- $form->setConstants(['sec_token' => $token]);
- return $form->returnForm();
- }
- }
- /**
- * This function deletes the forum image if exists.
- *
- * @param int forum id
- *
- * @return bool true if success
- *
- * @author Julio Montoya <gugli100@gmail.com>
- *
- * @version february 2006, dokeos 1.8
- */
- function delete_forum_image($forum_id)
- {
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $course_id = api_get_course_int_id();
- $forum_id = intval($forum_id);
- $sql = "SELECT forum_image FROM $table_forums
- WHERE forum_id = $forum_id AND c_id = $course_id";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- if ($row['forum_image'] != '') {
- $file = api_get_path(SYS_COURSE_PATH).api_get_course_path().'/upload/forum/images/'.$row['forum_image'];
- if (file_exists($file)) {
- unlink($file);
- }
- return true;
- } else {
- return false;
- }
- }
- /**
- * This function displays the form that is used to edit a forum category.
- *
- * @param array
- *
- * @return string
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function show_edit_forumcategory_form($inputvalues = [])
- {
- $categoryId = $inputvalues['cat_id'];
- $form = new FormValidator('forumcategory', 'post', 'index.php?'.api_get_cidreq().'&id='.$categoryId);
- // Setting the form elements.
- $form->addElement('header', '', get_lang('Edit forumCategory'));
- $form->addElement('hidden', 'forum_category_id');
- $form->addElement('text', 'forum_category_title', get_lang('Title'));
- $form->addElement(
- 'html_editor',
- 'forum_category_comment',
- get_lang('Comment'),
- null,
- ['ToolbarSet' => 'Forum', 'Width' => '98%', 'Height' => '200']
- );
- $extraField = new ExtraField('forum_category');
- $returnParams = $extraField->addElements(
- $form,
- $categoryId,
- [], //exclude
- false, // filter
- false, // tag as select
- [], //show only fields
- [], // order fields
- [] // extra data
- );
- $form->addButtonUpdate(get_lang('Edit category'), 'SubmitEdit forumCategory');
- // Setting the default values.
- $defaultvalues['forum_category_id'] = $inputvalues['cat_id'];
- $defaultvalues['forum_category_title'] = $inputvalues['cat_title'];
- $defaultvalues['forum_category_comment'] = $inputvalues['cat_comment'];
- $form->setDefaults($defaultvalues);
- // Setting the rules.
- $form->addRule('forum_category_title', get_lang('Required field'), 'required');
- // Validation or display
- if ($form->validate()) {
- $check = Security::check_token('post');
- if ($check) {
- $values = $form->exportValues();
- store_forumcategory($values);
- }
- Security::clear_token();
- } else {
- $token = Security::get_token();
- $form->addElement('hidden', 'sec_token');
- $form->setConstants(['sec_token' => $token]);
- return $form->returnForm();
- }
- }
- /**
- * This function stores the forum category in the database.
- * The new category is added to the end.
- *
- * @param array $values
- * @param array $courseInfo
- * @param bool $showMessage
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_forumcategory($values, $courseInfo = [], $showMessage = true)
- {
- $courseInfo = empty($courseInfo) ? api_get_course_info() : $courseInfo;
- $course_id = $courseInfo['real_id'];
- $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
- // Find the max cat_order. The new forum category is added at the end => max cat_order + &
- $sql = "SELECT MAX(cat_order) as sort_max
- FROM $table_categories
- WHERE c_id = $course_id";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $new_max = $row['sort_max'] + 1;
- $session_id = api_get_session_id();
- $clean_cat_title = $values['forum_category_title'];
- $last_id = null;
- if (isset($values['forum_category_id'])) {
- // Storing after edition.
- $params = [
- 'cat_title' => $clean_cat_title,
- 'cat_comment' => isset($values['forum_category_comment']) ? $values['forum_category_comment'] : '',
- ];
- Database::update(
- $table_categories,
- $params,
- [
- 'c_id = ? AND cat_id = ?' => [
- $course_id,
- $values['forum_category_id'],
- ],
- ]
- );
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM_CATEGORY,
- $values['forum_category_id'],
- 'ForumCategoryUpdated',
- api_get_user_id()
- );
- $return_message = get_lang('The forum category has been modified');
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => 0,
- 'tool_id_detail' => 0,
- 'action' => 'update-forumcategory',
- 'action_details' => 'forumcategory',
- 'info' => $clean_cat_title,
- ];
- Event::registerLog($logInfo);
- $values['item_id'] = $values['forum_category_id'];
- } else {
- $params = [
- 'c_id' => $course_id,
- 'cat_title' => $clean_cat_title,
- 'cat_comment' => isset($values['forum_category_comment']) ? $values['forum_category_comment'] : '',
- 'cat_order' => $new_max,
- 'session_id' => $session_id,
- 'locked' => 0,
- 'cat_id' => 0,
- ];
- $last_id = Database::insert($table_categories, $params);
- if ($last_id > 0) {
- $sql = "UPDATE $table_categories SET cat_id = $last_id WHERE iid = $last_id";
- Database::query($sql);
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM_CATEGORY,
- $last_id,
- 'ForumCategoryAdded',
- api_get_user_id()
- );
- api_set_default_visibility(
- $last_id,
- TOOL_FORUM_CATEGORY,
- 0,
- $courseInfo
- );
- }
- $return_message = get_lang('The forum category has been added');
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => 0,
- 'tool_id_detail' => 0,
- 'action' => 'new-forumcategory',
- 'action_details' => 'forumcategory',
- 'info' => $clean_cat_title,
- ];
- Event::registerLog($logInfo);
- $values['item_id'] = $last_id;
- }
- $extraFieldValue = new ExtraFieldValue('forum_category');
- $extraFieldValue->saveFieldValues($values);
- if ($showMessage) {
- Display::addFlash(Display::return_message($return_message, 'confirmation'));
- }
- return $last_id;
- }
- /**
- * This function stores the forum in the database. The new forum is added to the end.
- *
- * @param array $values
- * @param array $courseInfo
- * @param bool $returnId
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_forum($values, $courseInfo = [], $returnId = false)
- {
- $courseInfo = empty($courseInfo) ? api_get_course_info() : $courseInfo;
- $courseId = $courseInfo['real_id'];
- $session_id = api_get_session_id();
- $group_id = api_get_group_id();
- if (isset($values['group_id']) && !empty($values['group_id'])) {
- $group_id = $values['group_id'];
- }
- $groupInfo = [];
- if (!empty($group_id)) {
- $groupInfo = GroupManager::get_group_properties($group_id);
- }
- $table_forums = Database::get_course_table(TABLE_FORUM);
- // Find the max forum_order for the given category. The new forum is added at the end => max cat_order + &
- if (is_null($values['forum_category'])) {
- $new_max = null;
- } else {
- $sql = "SELECT MAX(forum_order) as sort_max
- FROM $table_forums
- WHERE
- c_id = $courseId AND
- forum_category='".Database::escape_string($values['forum_category'])."'";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $new_max = $row['sort_max'] + 1;
- }
- // Forum images
- $has_attachment = false;
- $image_moved = true;
- if (!empty($_FILES['picture']['name'])) {
- $upload_ok = process_uploaded_file($_FILES['picture']);
- $has_attachment = true;
- }
- // Remove existing picture if it was requested.
- if (!empty($_POST['remove_picture'])) {
- delete_forum_image($values['forum_id']);
- }
- $new_file_name = '';
- if (isset($upload_ok)) {
- if ($has_attachment) {
- $course_dir = $courseInfo['path'].'/upload/forum/images';
- $sys_course_path = api_get_path(SYS_COURSE_PATH);
- $updir = $sys_course_path.$course_dir;
- // Try to add an extension to the file if it hasn't one.
- $new_file_name = add_ext_on_mime(
- Database::escape_string($_FILES['picture']['name']),
- $_FILES['picture']['type']
- );
- if (!filter_extension($new_file_name)) {
- //Display::addFlash(Display::return_message(get_lang('File upload failed: this file extension or file type is prohibited'), 'error'));
- $image_moved = false;
- } else {
- $file_extension = explode('.', $_FILES['picture']['name']);
- $file_extension = strtolower($file_extension[sizeof($file_extension) - 1]);
- $new_file_name = uniqid('').'.'.$file_extension;
- $new_path = $updir.'/'.$new_file_name;
- $result = @move_uploaded_file($_FILES['picture']['tmp_name'], $new_path);
- // Storing the attachments if any
- if ($result) {
- $image_moved = true;
- }
- }
- }
- }
- if (isset($values['forum_id'])) {
- // Storing after edition.
- $params = [
- 'forum_title' => $values['forum_title'],
- 'forum_comment' => isset($values['forum_comment']) ? $values['forum_comment'] : null,
- 'forum_category' => isset($values['forum_category']) ? $values['forum_category'] : null,
- 'allow_anonymous' => isset($values['allow_anonymous_group']['allow_anonymous']) ? $values['allow_anonymous_group']['allow_anonymous'] : null,
- 'allow_edit' => isset($values['students_can_edit_group']['students_can_edit']) ? $values['students_can_edit_group']['students_can_edit'] : null,
- 'approval_direct_post' => isset($values['approval_direct_group']['approval_direct']) ? $values['approval_direct_group']['approval_direct'] : null,
- 'allow_attachments' => isset($values['allow_attachments_group']['allow_attachments']) ? $values['allow_attachments_group']['allow_attachments'] : null,
- 'allow_new_threads' => isset($values['allow_new_threads_group']['allow_new_threads']) ? $values['allow_new_threads_group']['allow_new_threads'] : null,
- 'default_view' => isset($values['default_view_type_group']['default_view_type']) ? $values['default_view_type_group']['default_view_type'] : null,
- 'forum_of_group' => isset($values['group_forum']) ? $values['group_forum'] : null,
- 'forum_group_public_private' => isset($values['public_private_group_forum_group']['public_private_group_forum']) ? $values['public_private_group_forum_group']['public_private_group_forum'] : null,
- 'moderated' => $values['moderated']['moderated'],
- 'start_time' => !empty($values['start_time']) ? api_get_utc_datetime($values['start_time']) : null,
- 'end_time' => !empty($values['end_time']) ? api_get_utc_datetime($values['end_time']) : null,
- 'session_id' => $session_id,
- 'lp_id' => isset($values['lp_id']) ? intval($values['lp_id']) : 0,
- ];
- if (isset($upload_ok)) {
- if ($has_attachment) {
- $params['forum_image'] = $new_file_name;
- }
- }
- if (isset($values['remove_picture']) && $values['remove_picture'] == 1) {
- $params['forum_image'] = '';
- delete_forum_image($values['forum_id']);
- }
- // Move groups from one group to another
- if (isset($values['group_forum'])) {
- $forumData = get_forums($values['forum_id']);
- $currentGroupId = $forumData['forum_of_group'];
- if ($currentGroupId != $values['group_forum']) {
- $threads = get_threads($values['forum_id']);
- $toGroupId = 'NULL';
- if (!empty($values['group_forum'])) {
- $toGroupId = $values['group_forum'];
- }
- $tableItemProperty = Database::get_course_table(TABLE_ITEM_PROPERTY);
- foreach ($threads as $thread) {
- $sql = "UPDATE $tableItemProperty
- SET to_group_id = $toGroupId
- WHERE
- tool = '".TOOL_FORUM_THREAD."' AND
- ref = ".$thread['thread_id']." AND
- c_id = ".$courseId;
- Database::query($sql);
- $posts = getPosts(
- $forumData,
- $thread['thread_id']
- );
- foreach ($posts as $post) {
- $postId = $post['post_id'];
- $attachMentList = getAllAttachment($postId);
- if (!empty($attachMentList)) {
- foreach ($attachMentList as $attachMent) {
- $sql = "UPDATE $tableItemProperty
- SET to_group_id = $toGroupId
- WHERE
- tool = '".TOOL_FORUM_ATTACH."' AND
- ref = ".$attachMent['iid']." AND
- c_id = ".$courseId;
- Database::query($sql);
- }
- }
- $sql = "UPDATE $tableItemProperty
- SET to_group_id = $toGroupId
- WHERE
- tool = '".TOOL_FORUM_POST."' AND
- ref = $postId AND
- c_id = $courseId";
- Database::query($sql);
- }
- }
- }
- }
- Database::update(
- $table_forums,
- $params,
- ['c_id = ? AND forum_id = ?' => [$courseId, $values['forum_id']]]
- );
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM,
- Database::escape_string($values['forum_id']),
- 'ForumUpdated',
- api_get_user_id(),
- $groupInfo
- );
- $return_message = get_lang('The forum has been modified');
- $forumId = $values['forum_id'];
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $values['forum_id'],
- 'action' => 'update-forum',
- 'action_details' => 'forum',
- 'info' => $values['forum_title'],
- ];
- Event::registerLog($logInfo);
- } else {
- if ($image_moved) {
- $new_file_name = isset($new_file_name) ? $new_file_name : '';
- }
- $params = [
- 'c_id' => $courseId,
- 'forum_title' => $values['forum_title'],
- 'forum_image' => $new_file_name,
- 'forum_comment' => isset($values['forum_comment']) ? $values['forum_comment'] : null,
- 'forum_category' => isset($values['forum_category']) ? $values['forum_category'] : null,
- 'allow_anonymous' => isset($values['allow_anonymous_group']['allow_anonymous']) ? $values['allow_anonymous_group']['allow_anonymous'] : null,
- 'allow_edit' => isset($values['students_can_edit_group']['students_can_edit']) ? $values['students_can_edit_group']['students_can_edit'] : null,
- 'approval_direct_post' => isset($values['approval_direct_group']['approval_direct']) ? $values['approval_direct_group']['approval_direct'] : null,
- 'allow_attachments' => isset($values['allow_attachments_group']['allow_attachments']) ? $values['allow_attachments_group']['allow_attachments'] : null,
- 'allow_new_threads' => isset($values['allow_new_threads_group']['allow_new_threads']) ? $values['allow_new_threads_group']['allow_new_threads'] : null,
- 'default_view' => isset($values['default_view_type_group']['default_view_type']) ? $values['default_view_type_group']['default_view_type'] : null,
- 'forum_of_group' => isset($values['group_forum']) ? $values['group_forum'] : null,
- 'forum_group_public_private' => isset($values['public_private_group_forum_group']['public_private_group_forum']) ? $values['public_private_group_forum_group']['public_private_group_forum'] : null,
- 'moderated' => isset($values['moderated']['moderated']) ? (int) $values['moderated']['moderated'] : 0,
- 'start_time' => !empty($values['start_time']) ? api_get_utc_datetime($values['start_time']) : null,
- 'end_time' => !empty($values['end_time']) ? api_get_utc_datetime($values['end_time']) : null,
- 'forum_order' => isset($new_max) ? $new_max : null,
- 'session_id' => $session_id,
- 'lp_id' => isset($values['lp_id']) ? (int) $values['lp_id'] : 0,
- 'locked' => 0,
- 'forum_id' => 0,
- ];
- $forumId = Database::insert($table_forums, $params);
- if ($forumId > 0) {
- $sql = "UPDATE $table_forums SET forum_id = iid WHERE iid = $forumId";
- Database::query($sql);
- $courseCode = $courseInfo['code'];
- $subscribe = (int) api_get_course_setting('subscribe_users_to_forum_notifications');
- $status = STUDENT;
- if (!empty($session_id)) {
- $status = 0;
- }
- if ($subscribe === 1) {
- $userList = CourseManager::get_user_list_from_course_code(
- $courseCode,
- $session_id,
- null,
- null,
- $status
- );
- foreach ($userList as $userInfo) {
- set_notification('forum', $forumId, false, $userInfo, $courseInfo);
- }
- }
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM,
- $forumId,
- 'ForumAdded',
- api_get_user_id(),
- $groupInfo
- );
- api_set_default_visibility(
- $forumId,
- TOOL_FORUM,
- $group_id,
- $courseInfo
- );
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $forumId,
- 'action' => 'new-forum',
- 'action_details' => 'forum',
- 'info' => $values['forum_title'],
- ];
- Event::registerLog($logInfo);
- }
- $return_message = get_lang('The forum has been added');
- }
- if ($returnId) {
- return $forumId;
- }
- return $return_message;
- }
- /**
- * This function deletes a forum or a forum category
- * This function currently does not delete the forums inside the category,
- * nor the threads and replies inside these forums.
- * For the moment this is the easiest method and it has the advantage that it
- * allows to recover fora that were acidently deleted
- * when the forum category got deleted.
- *
- * @param $content = what we are deleting (a forum or a forum category)
- * @param $id the id of the forum category that has to be deleted
- *
- * @todo write the code for the cascading deletion of the forums inside a
- * forum category and also the threads and replies inside these forums
- * @todo config setting for recovery or not
- * (see also the documents tool: real delete or not).
- *
- * @return string
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function deleteForumCategoryThread($content, $id)
- {
- $_course = api_get_course_info();
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_forums_post = Database::get_course_table(TABLE_FORUM_POST);
- $table_forum_thread = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $groupId = api_get_group_id();
- $groupInfo = GroupManager::get_group_properties($groupId);
- $userId = api_get_user_id();
- $id = (int) $id;
- // Delete all attachment file about this tread id.
- $sql = "SELECT post_id FROM $table_forums_post
- WHERE c_id = $course_id AND thread_id = '".$id."' ";
- $res = Database::query($sql);
- while ($poster_id = Database::fetch_row($res)) {
- delete_attachment($poster_id[0]);
- }
- $tool_constant = null;
- $return_message = '';
- if ($content === 'forumcategory') {
- $tool_constant = TOOL_FORUM_CATEGORY;
- $return_message = get_lang('Forum category deleted');
- if (!empty($forum_list)) {
- $sql = "SELECT forum_id FROM $table_forums
- WHERE c_id = $course_id AND forum_category='".$id."'";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- foreach ($row as $arr_forum) {
- $forum_id = $arr_forum['forum_id'];
- api_item_property_update(
- $_course,
- 'forum',
- $forum_id,
- 'delete',
- api_get_user_id()
- );
- }
- }
- }
- if ($content === 'forum') {
- $tool_constant = TOOL_FORUM;
- $return_message = get_lang('Forum deleted');
- if (!empty($number_threads)) {
- $sql = "SELECT thread_id FROM $table_forum_thread
- WHERE c_id = $course_id AND forum_id = $id ";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- foreach ($row as $arr_forum) {
- $forum_id = $arr_forum['thread_id'];
- api_item_property_update(
- $_course,
- 'forum_thread',
- $forum_id,
- 'delete',
- api_get_user_id()
- );
- }
- }
- }
- if ($content === 'thread') {
- $tool_constant = TOOL_FORUM_THREAD;
- $return_message = get_lang('Thread deleted');
- Skill::deleteSkillsFromItem($id, ITEM_TYPE_FORUM_THREAD);
- }
- api_item_property_update(
- $_course,
- $tool_constant,
- $id,
- 'delete',
- $userId,
- $groupInfo
- );
- // Check if this returns a true and if so => return $return_message, if not => return false;
- if (!empty($return_message)) {
- Display::addFlash(Display::return_message($return_message, 'confirmation', false));
- }
- return $return_message;
- }
- /**
- * This function deletes a forum post. This separate function is needed because forum posts do not appear
- * in the item_property table (yet)
- * and because deleting a post also has consequence on the posts that have this post as parent_id
- * (they are also deleted).
- * an alternative would be to store the posts also in item_property and mark this post as deleted (visibility = 2).
- * We also have to decrease the number of replies in the thread table.
- *
- * @param $post_id the id of the post that will be deleted
- *
- * @todo write recursive function that deletes all the posts that have this message as parent
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- * @author Hubert Borderiou Function cleanead and fixed
- *
- * @version february 2006
- */
- function delete_post($post_id)
- {
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $post_id = intval($post_id);
- $course_id = api_get_course_int_id();
- $em = Database::getManager();
- $post = $em
- ->getRepository('ChamiloCourseBundle:CForumPost')
- ->findOneBy(['cId' => $course_id, 'postId' => $post_id]);
- if ($post) {
- $em
- ->createQuery('
- UPDATE ChamiloCourseBundle:CForumPost p
- SET p.postParentId = :parent_of_deleted_post
- WHERE
- p.cId = :course AND
- p.postParentId = :post AND
- p.threadId = :thread_of_deleted_post AND
- p.forumId = :forum_of_deleted_post
- ')
- ->execute([
- 'parent_of_deleted_post' => $post->getPostParentId(),
- 'course' => $course_id,
- 'post' => $post->getPostId(),
- 'thread_of_deleted_post' => $post->getThread() ? $post->getThread()->getIid() : 0,
- 'forum_of_deleted_post' => $post->getForumId(),
- ]);
- $em->remove($post);
- $em->flush();
- // Delete attachment file about this post id.
- delete_attachment($post_id);
- }
- $last_post_of_thread = check_if_last_post_of_thread($_GET['thread']);
- if (is_array($last_post_of_thread)) {
- // Decreasing the number of replies for this thread and also changing the last post information.
- $sql = "UPDATE $table_threads
- SET
- thread_replies = thread_replies - 1,
- thread_last_post = ".intval($last_post_of_thread['post_id']).",
- thread_date='".Database::escape_string($last_post_of_thread['post_date'])."'
- WHERE c_id = $course_id AND thread_id = ".intval($_GET['thread']);
- Database::query($sql);
- return 'PostDeleted';
- }
- if (!$last_post_of_thread) {
- // We deleted the very single post of the thread so we need to delete the entry in the thread table also.
- $sql = "DELETE FROM $table_threads
- WHERE c_id = $course_id AND thread_id = ".intval($_GET['thread']);
- Database::query($sql);
- return 'PostDeletedSpecial';
- }
- }
- /**
- * This function gets the all information of the last (=most recent) post of the thread
- * This can be done by sorting the posts that have the field thread_id=$thread_id and sort them by post_date.
- *
- * @param $thread_id the id of the thread we want to know the last post of
- *
- * @return an array or bool if there is a last post found, false if there is
- * no post entry linked to that thread => thread will be deleted
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function check_if_last_post_of_thread($thread_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- $sql = "SELECT * FROM $table_posts
- WHERE c_id = $course_id AND thread_id = ".intval($thread_id)."
- ORDER BY post_date DESC";
- $result = Database::query($sql);
- if (Database::num_rows($result) > 0) {
- $row = Database::fetch_array($result);
- return $row;
- } else {
- return false;
- }
- }
- /**
- * @param string $content Type of content forum category, forum, thread, post
- * @param int $id the id of the content we want to make invisible
- * @param int $current_visibility_status what is the current status of the visibility (0 = invisible, 1 = visible)
- * @param array $additional_url_parameters
- *
- * @return string HTML
- */
- function return_visible_invisible_icon(
- $content,
- $id,
- $current_visibility_status,
- $additional_url_parameters = ''
- ) {
- $html = '';
- $id = (int) $id;
- $current_visibility_status = (int) $current_visibility_status;
- if ($current_visibility_status == 1) {
- $html .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&';
- if (is_array($additional_url_parameters)) {
- foreach ($additional_url_parameters as $key => $value) {
- $html .= $key.'='.$value.'&';
- }
- }
- $html .= 'action=invisible&content='.$content.'&id='.$id.'">'.
- Display::return_icon('visible.png', get_lang('Make invisible'), [], ICON_SIZE_SMALL).'</a>';
- }
- if ($current_visibility_status == 0) {
- $html .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&';
- if (is_array($additional_url_parameters)) {
- foreach ($additional_url_parameters as $key => $value) {
- $html .= $key.'='.$value.'&';
- }
- }
- $html .= 'action=visible&content='.$content.'&id='.$id.'">'.
- Display::return_icon('invisible.png', get_lang('Make Visible'), [], ICON_SIZE_SMALL).'</a>';
- }
- return $html;
- }
- /**
- * @param $content
- * @param $id
- * @param $current_lock_status
- * @param string $additional_url_parameters
- *
- * @return string
- */
- function return_lock_unlock_icon($content, $id, $current_lock_status, $additional_url_parameters = '')
- {
- $html = '';
- $id = intval($id);
- //check if the forum is blocked due
- if ($content == 'thread') {
- if (api_resource_is_locked_by_gradebook($id, LINK_FORUM_THREAD)) {
- $html .= Display::return_icon(
- 'lock_na.png',
- get_lang('This option is not available because this activity is contained by an assessment, which is currently locked. To unlock the assessment, ask your platform administrator.'),
- [],
- ICON_SIZE_SMALL
- );
- return $html;
- }
- }
- if ($current_lock_status == '1') {
- $html .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&';
- if (is_array($additional_url_parameters)) {
- foreach ($additional_url_parameters as $key => $value) {
- $html .= $key.'='.$value.'&';
- }
- }
- $html .= 'action=unlock&content='.$content.'&id='.$id.'">'.
- Display::return_icon('lock.png', get_lang('Unlock'), [], ICON_SIZE_SMALL).'</a>';
- }
- if ($current_lock_status == '0') {
- $html .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&';
- if (is_array($additional_url_parameters)) {
- foreach ($additional_url_parameters as $key => $value) {
- $html .= $key.'='.$value.'&';
- }
- }
- $html .= 'action=lock&content='.$content.'&id='.$id.'">'.
- Display::return_icon('unlock.png', get_lang('Lock'), [], ICON_SIZE_SMALL).'</a>';
- }
- return $html;
- }
- /**
- * This function takes care of the display of the up and down icon.
- *
- * @param string $content what is it that we want to make (in)visible: forum category, forum, thread, post
- * @param int $id is the id of the item we want to display the icons for
- * @param array $list is an array of all the items. All items in this list should have
- * an up and down icon except for the first (no up icon) and the last (no down icon)
- * The key of this $list array is the id of the item.
- *
- * @return string HTML
- */
- function return_up_down_icon($content, $id, $list)
- {
- $id = (int) $id;
- $total_items = count($list);
- $position = 0;
- $internal_counter = 0;
- $forumCategory = isset($_GET['forumcategory']) ? Security::remove_XSS($_GET['forumcategory']) : null;
- if (is_array($list)) {
- foreach ($list as $key => $listitem) {
- $internal_counter++;
- if ($id == $key) {
- $position = $internal_counter;
- }
- }
- }
- if ($position > 1) {
- $return_value = '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=move&direction=up&content='.$content.'&forumcategory='.$forumCategory.'&id='.$id.'" title="'.get_lang('Move up').'">'.
- Display::return_icon('up.png', get_lang('Move up'), [], ICON_SIZE_SMALL).'</a>';
- } else {
- $return_value = Display::return_icon('up_na.png', '-', [], ICON_SIZE_SMALL);
- }
- if ($position < $total_items) {
- $return_value .= '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=move&direction=down&content='.$content.'&forumcategory='.$forumCategory.'&id='.$id.'" title="'.get_lang('Move down').'" >'.
- Display::return_icon('down.png', get_lang('Move down'), [], ICON_SIZE_SMALL).'</a>';
- } else {
- $return_value .= Display::return_icon('down_na.png', '-', [], ICON_SIZE_SMALL);
- }
- return $return_value;
- }
- /**
- * This function changes the visibility in the database (item_property).
- *
- * @param string $content what is it that we want to make (in)visible: forum category, forum, thread, post
- * @param int $id the id of the content we want to make invisible
- * @param string $target_visibility what is the current status of the visibility (0 = invisible, 1 = visible)
- *
- * @todo change the get parameter so that it matches the tool constants.
- * @todo check if api_item_property_update returns true or false => returnmessage depends on it.
- * @todo move to itemmanager
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function change_visibility($content, $id, $target_visibility)
- {
- $_course = api_get_course_info();
- $constants = [
- 'forumcategory' => TOOL_FORUM_CATEGORY,
- 'forum' => TOOL_FORUM,
- 'thread' => TOOL_FORUM_THREAD,
- ];
- api_item_property_update(
- $_course,
- $constants[$content],
- $id,
- $target_visibility,
- api_get_user_id()
- );
- if ($target_visibility == 'visible') {
- handle_mail_cue($content, $id);
- }
- return get_lang('The visibility has been changed.');
- }
- /**
- * This function changes the lock status in the database.
- *
- * @param string $content what is it that we want to (un)lock: forum category, forum, thread, post
- * @param int $id the id of the content we want to (un)lock
- * @param string $action do we lock (=>locked value in db = 1) or unlock (=> locked value in db = 0)
- *
- * @return string language variable
- *
- * @todo move to item manager
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function change_lock_status($content, $id, $action)
- {
- $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- // Determine the relevant table.
- if ($content == 'forumcategory') {
- $table = $table_categories;
- $id_field = 'cat_id';
- } elseif ($content == 'forum') {
- $table = $table_forums;
- $id_field = 'forum_id';
- } elseif ($content == 'thread') {
- $table = $table_threads;
- $id_field = 'thread_id';
- } else {
- return get_lang('Error');
- }
- // Determine what we are doing => defines the value for the database and the return message.
- if ($action == 'lock') {
- $db_locked = 1;
- $return_message = get_lang('Locked: students can no longer post new messages in this forum category, forum or thread but they can still read the messages that were already posted');
- } elseif ($action == 'unlock') {
- $db_locked = 0;
- $return_message = get_lang('Unlocked: learners can post new messages in this forum category, forum or thread');
- } else {
- return get_lang('Error');
- }
- $course_id = api_get_course_int_id();
- // Doing the change in the database
- $sql = "UPDATE $table SET locked='".Database::escape_string($db_locked)."'
- WHERE c_id = $course_id AND $id_field='".Database::escape_string($id)."'";
- if (Database::query($sql)) {
- return $return_message;
- } else {
- return get_lang('Error');
- }
- }
- /**
- * This function moves a forum or a forum category up or down.
- *
- * @param $content what is it that we want to make (in)visible: forum category, forum, thread, post
- * @param $direction do we want to move it up or down
- * @param $id the id of the content we want to make invisible
- *
- * @todo consider removing the table_item_property calls here but this can
- * prevent unwanted side effects when a forum does not have an entry in
- * the item_property table but does have one in the forum table.
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function move_up_down($content, $direction, $id)
- {
- $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $course_id = api_get_course_int_id();
- $id = intval($id);
- // Determine which field holds the sort order.
- if ($content == 'forumcategory') {
- $table = $table_categories;
- $sort_column = 'cat_order';
- $id_column = 'cat_id';
- $sort_column = 'cat_order';
- } elseif ($content == 'forum') {
- $table = $table_forums;
- $sort_column = 'forum_order';
- $id_column = 'forum_id';
- $sort_column = 'forum_order';
- // We also need the forum_category of this forum.
- $sql = "SELECT forum_category FROM $table_forums
- WHERE c_id = $course_id AND forum_id = ".intval($id);
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $forum_category = $row['forum_category'];
- } else {
- return get_lang('Error');
- }
- // Determine the need for sorting ascending or descending order.
- if ($direction == 'down') {
- $sort_direction = 'ASC';
- } elseif ($direction == 'up') {
- $sort_direction = 'DESC';
- } else {
- return get_lang('Error');
- }
- // The SQL statement
- if ($content == 'forumcategory') {
- $sql = "SELECT *
- FROM $table_categories forum_categories, $table_item_property item_properties
- WHERE
- forum_categories.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- forum_categories.cat_id=item_properties.ref AND
- item_properties.tool='".TOOL_FORUM_CATEGORY."'
- ORDER BY forum_categories.cat_order $sort_direction";
- }
- if ($content == 'forum') {
- $sql = "SELECT *
- FROM $table
- WHERE
- c_id = $course_id AND
- forum_category='".Database::escape_string($forum_category)."'
- ORDER BY forum_order $sort_direction";
- }
- // Finding the items that need to be switched.
- $result = Database::query($sql);
- $found = false;
- while ($row = Database::fetch_array($result)) {
- if ($found) {
- $next_id = $row[$id_column];
- $next_sort = $row[$sort_column];
- $found = false;
- }
- if ($id == $row[$id_column]) {
- $this_id = $id;
- $this_sort = $row[$sort_column];
- $found = true;
- }
- }
- // Committing the switch.
- // We do an extra check if we do not have illegal values. If your remove this if statement you will
- // be able to mess with the sorting by refreshing the page over and over again.
- if ($this_sort != '' && $next_sort != '' && $next_id != '' && $this_id != '') {
- $sql = "UPDATE $table SET $sort_column='".Database::escape_string($this_sort)."'
- WHERE c_id = $course_id AND $id_column='".Database::escape_string($next_id)."'";
- Database::query($sql);
- $sql = "UPDATE $table SET $sort_column='".Database::escape_string($next_sort)."'
- WHERE c_id = $course_id AND $id_column='".Database::escape_string($this_id)."'";
- Database::query($sql);
- }
- return get_lang(ucfirst($content).'Moved');
- }
- /**
- * Retrieve all the information off the forum categories (or one specific) for the current course.
- * The categories are sorted according to their sorting order (cat_order.
- *
- * @param int|string $id default ''. When an id is passed we only find the information
- * about that specific forum category. If no id is passed we get all the forum categories.
- * @param int $courseId Optional. The course ID
- * @param int $sessionId Optional. The session ID
- *
- * @return array containing all the information about all the forum categories
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_forum_categories($id = '', $courseId = 0, $sessionId = 0)
- {
- $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- // Condition for the session
- $session_id = $sessionId ?: api_get_session_id();
- $course_id = $courseId ?: api_get_course_int_id();
- $condition_session = api_get_session_condition(
- $session_id,
- true,
- true,
- 'forum_categories.session_id'
- );
- $condition_session .= " AND forum_categories.c_id = $course_id AND item_properties.c_id = $course_id";
- if (empty($id)) {
- $sql = "SELECT *
- FROM $table_item_property item_properties
- INNER JOIN $table_categories forum_categories
- ON (
- forum_categories.cat_id = item_properties.ref AND
- item_properties.c_id = forum_categories.c_id
- )
- WHERE
- item_properties.visibility = 1 AND
- item_properties.tool = '".TOOL_FORUM_CATEGORY."'
- $condition_session
- ORDER BY forum_categories.cat_order ASC";
- if (api_is_allowed_to_edit()) {
- $sql = "SELECT *
- FROM $table_item_property item_properties
- INNER JOIN $table_categories forum_categories
- ON (
- forum_categories.cat_id = item_properties.ref AND
- item_properties.c_id = forum_categories.c_id
- )
- WHERE
- item_properties.visibility<>2 AND
- item_properties.tool='".TOOL_FORUM_CATEGORY."'
- $condition_session
- ORDER BY forum_categories.cat_order ASC";
- }
- } else {
- $sql = "SELECT *
- FROM $table_item_property item_properties
- INNER JOIN $table_categories forum_categories
- ON (
- forum_categories.cat_id = item_properties.ref AND
- item_properties.c_id = forum_categories.c_id
- )
- WHERE
- item_properties.tool='".TOOL_FORUM_CATEGORY."' AND
- forum_categories.cat_id = ".intval($id)."
- $condition_session
- ORDER BY forum_categories.cat_order ASC";
- }
- $result = Database::query($sql);
- $forum_categories_list = [];
- $extraFieldValue = new ExtraFieldValue('forum_category');
- while ($row = Database::fetch_assoc($result)) {
- $row['extra_fields'] = $extraFieldValue->getAllValuesByItem($row['cat_id']);
- if (empty($id)) {
- $forum_categories_list[$row['cat_id']] = $row;
- } else {
- $forum_categories_list = $row;
- }
- }
- return $forum_categories_list;
- }
- /**
- * This function retrieves all the fora in a given forum category.
- *
- * @param int $cat_id the id of the forum category
- * @param int $courseId Optional. The course ID
- *
- * @return array containing all the information about the forums (regardless of their category)
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_forums_in_category($cat_id, $courseId = 0)
- {
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $forum_list = [];
- $course_id = $courseId ?: api_get_course_int_id();
- $cat_id = (int) $cat_id;
- $sql = "SELECT * FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (forum.forum_id = item_properties.ref AND item_properties.c_id = forum.c_id)
- WHERE
- forum.forum_category = '".$cat_id."' AND
- item_properties.visibility = 1 AND
- forum.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.tool = '".TOOL_FORUM."'
- ORDER BY forum.forum_order ASC";
- if (api_is_allowed_to_edit()) {
- $sql = "SELECT * FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (forum.forum_id = item_properties.ref AND item_properties.c_id = forum.c_id)
- WHERE
- forum.forum_category = '".$cat_id."' AND
- item_properties.visibility <> 2 AND
- item_properties.tool = '".TOOL_FORUM."' AND
- item_properties.c_id = $course_id AND
- forum.c_id = $course_id
- ORDER BY forum_order ASC";
- }
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- $forum_list[$row['forum_id']] = $row;
- }
- return $forum_list;
- }
- /**
- * Retrieve all the forums (regardless of their category) or of only one.
- * The forums are sorted according to the forum_order.
- * Since it does not take the forum category into account there probably
- * will be two or more forums that have forum_order=1, ...
- *
- * @param int $id forum id
- * @param string $course_code
- * @param bool $includeGroupsForum
- * @param int $sessionId
- *
- * @return array an array containing all the information about the forums (regardless of their category)
- *
- * @todo check $sql4 because this one really looks fishy.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_forums(
- $id = 0,
- $course_code = '',
- $includeGroupsForum = true,
- $sessionId = 0
- ) {
- $id = (int) $id;
- $course_info = api_get_course_info($course_code);
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- // Condition for the session
- $session_id = intval($sessionId) ?: api_get_session_id();
- $sessionIdLink = $session_id === 0 ? '' : ' AND threads.session_id = item_properties.session_id';
- $condition_session = api_get_session_condition(
- $session_id,
- true,
- false,
- 'item_properties.session_id'
- );
- $course_id = $course_info['real_id'];
- $forum_list = [];
- $includeGroupsForumSelect = '';
- if (!$includeGroupsForum) {
- $includeGroupsForumSelect = " AND (forum_of_group = 0 OR forum_of_group IS NULL) ";
- }
- $allowToEdit = api_is_allowed_to_edit();
- if (empty($id)) {
- // Student
- // Select all the forum information of all forums (that are visible to students).
- $sql = "SELECT item_properties.*, forum.*
- FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (
- forum.forum_id = item_properties.ref AND
- forum.c_id = item_properties.c_id
- )
- WHERE
- item_properties.visibility = 1 AND
- item_properties.tool = '".TOOL_FORUM."'
- $condition_session AND
- forum.c_id = $course_id AND
- item_properties.c_id = $course_id
- $includeGroupsForumSelect
- ORDER BY forum.forum_order ASC";
- // Select the number of threads of the forums (only the threads that are visible).
- $sql2 = "SELECT count(*) AS number_of_threads, threads.forum_id
- FROM $table_threads threads
- INNER JOIN $table_item_property item_properties
- ON (
- threads.thread_id = item_properties.ref AND
- threads.c_id = item_properties.c_id
- $sessionIdLink
- )
- WHERE
- item_properties.visibility=1 AND
- item_properties.tool='".TOOL_FORUM_THREAD."' AND
- threads.c_id = $course_id AND
- item_properties.c_id = $course_id
- GROUP BY threads.forum_id";
- // Course Admin
- if ($allowToEdit) {
- // Select all the forum information of all forums (that are not deleted).
- $sql = "SELECT item_properties.*, forum.*
- FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (
- forum.forum_id = item_properties.ref AND
- forum.c_id = item_properties.c_id
- )
- WHERE
- item_properties.visibility <> 2 AND
- item_properties.tool = '".TOOL_FORUM."'
- $condition_session AND
- forum.c_id = $course_id AND
- item_properties.c_id = $course_id
- $includeGroupsForumSelect
- ORDER BY forum_order ASC";
- // Select the number of threads of the forums (only the threads that are not deleted).
- $sql2 = "SELECT count(*) AS number_of_threads, threads.forum_id
- FROM $table_threads threads
- INNER JOIN $table_item_property item_properties
- ON (
- threads.thread_id = item_properties.ref AND
- threads.c_id = item_properties.c_id
- $sessionIdLink
- )
- WHERE
- item_properties.visibility<>2 AND
- item_properties.tool='".TOOL_FORUM_THREAD."' AND
- threads.c_id = $course_id AND
- item_properties.c_id = $course_id
- GROUP BY threads.forum_id";
- }
- } else {
- // GETTING ONE SPECIFIC FORUM
- /* We could do the splitup into student and course admin also but we want
- to have as much as information about a certain forum as possible
- so we do not take too much information into account. This function
- (or this section of the function) is namely used to fill the forms
- when editing a forum (and for the moment it is the only place where
- we use this part of the function) */
- // Select all the forum information of the given forum (that is not deleted).
- $sql = "SELECT * FROM $table_item_property item_properties
- INNER JOIN $table_forums forum
- ON (forum.forum_id = item_properties.ref AND forum.c_id = item_properties.c_id)
- WHERE
- forum.forum_id = $id AND
- forum.c_id = $course_id AND
- item_properties.visibility != 2 AND
- item_properties.tool = '".TOOL_FORUM."'
- ORDER BY forum_order ASC";
- // Select the number of threads of the forum.
- $sql2 = "SELECT count(*) AS number_of_threads, forum_id
- FROM $table_threads
- WHERE
- forum_id = $id
- GROUP BY forum_id";
- }
- // Handling all the forum information.
- $result = Database::query($sql);
- while ($row = Database::fetch_assoc($result)) {
- if (empty($id)) {
- $forum_list[$row['forum_id']] = $row;
- } else {
- $forum_list = $row;
- }
- }
- // Handling the thread count information.
- $result2 = Database::query($sql2);
- while ($row2 = Database::fetch_array($result2)) {
- if (empty($id)) {
- $forum_list[$row2['forum_id']]['number_of_threads'] = $row2['number_of_threads'];
- } else {
- $forum_list['number_of_threads'] = $row2['number_of_threads'];
- }
- }
- /* Finding the last post information
- (last_post_id, last_poster_id, last_post_date, last_poster_name, last_poster_lastname, last_poster_firstname)*/
- if (empty($id)) {
- if (is_array($forum_list)) {
- foreach ($forum_list as $key => $value) {
- $lastPost = get_last_post_information(
- $key,
- $allowToEdit,
- $course_id
- );
- if ($lastPost) {
- $forum_list[$key]['last_post_id'] = $lastPost['last_post_id'];
- $forum_list[$key]['last_poster_id'] = $lastPost['last_poster_id'];
- $forum_list[$key]['last_post_date'] = $lastPost['last_post_date'];
- $forum_list[$key]['last_poster_name'] = $lastPost['last_poster_name'];
- $forum_list[$key]['last_poster_lastname'] = $lastPost['last_poster_lastname'];
- $forum_list[$key]['last_poster_firstname'] = $lastPost['last_poster_firstname'];
- $forum_list[$key]['last_post_title'] = $lastPost['last_post_title'];
- $forum_list[$key]['last_post_text'] = $lastPost['last_post_text'];
- }
- }
- } else {
- $forum_list = [];
- }
- } else {
- $lastPost = get_last_post_information(
- $id,
- $allowToEdit,
- $course_id
- );
- if ($lastPost) {
- $forum_list['last_post_id'] = $lastPost['last_post_id'];
- $forum_list['last_poster_id'] = $lastPost['last_poster_id'];
- $forum_list['last_post_date'] = $lastPost['last_post_date'];
- $forum_list['last_poster_name'] = $lastPost['last_poster_name'];
- $forum_list['last_poster_lastname'] = $lastPost['last_poster_lastname'];
- $forum_list['last_poster_firstname'] = $lastPost['last_poster_firstname'];
- $forum_list['last_post_title'] = $lastPost['last_post_title'];
- $forum_list['last_post_text'] = $lastPost['last_post_text'];
- }
- }
- return $forum_list;
- }
- /**
- * @param int $course_id
- * @param int $thread_id
- * @param int $forum_id
- * @param bool $show_visible
- *
- * @return array|bool
- */
- function get_last_post_by_thread($course_id, $thread_id, $forum_id, $show_visible = true)
- {
- if (empty($thread_id) || empty($forum_id) || empty($course_id)) {
- return false;
- }
- $thread_id = intval($thread_id);
- $forum_id = intval($forum_id);
- $course_id = intval($course_id);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $sql = "SELECT * FROM $table_posts
- WHERE
- c_id = $course_id AND
- thread_id = $thread_id AND
- forum_id = $forum_id";
- if ($show_visible == false) {
- $sql .= " AND visible = 1 ";
- }
- $sql .= " ORDER BY post_id DESC LIMIT 1";
- $result = Database::query($sql);
- if (Database::num_rows($result)) {
- return Database::fetch_array($result, 'ASSOC');
- } else {
- return false;
- }
- }
- /**
- * This function gets all the last post information of a certain forum.
- *
- * @param int $forum_id the id of the forum we want to know the last post information of
- * @param bool $show_invisibles
- * @param string course db name
- * @param int $sessionId Optional. The session id
- *
- * @return array containing all the information about the last post
- * (last_post_id, last_poster_id, last_post_date, last_poster_name, last_poster_lastname, last_poster_firstname)
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_last_post_information($forum_id, $show_invisibles = false, $course_id = null, $sessionId = 0)
- {
- if (!isset($course_id)) {
- $course_id = api_get_course_int_id();
- } else {
- $course_id = intval($course_id);
- }
- $sessionId = $sessionId ? intval($sessionId) : api_get_session_id();
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $forum_id = intval($forum_id);
- $return_array = [];
- // First get the threads to make sure there is no inconsistency in the
- // database between forum and thread
- $sql = "SELECT thread_id FROM $table_threads
- WHERE
- forum_id = $forum_id AND
- c_id = $course_id AND
- session_id = $sessionId";
- $result = Database::query($sql);
- if (Database::num_rows($result) == 0) {
- // If there are no threads in this forum, then there are no posts
- return [];
- }
- $threads = [];
- while ($row = Database::fetch_row($result)) {
- $threads[] = $row[0];
- }
- $threadsList = implode(',', $threads);
- // Now get the posts that are linked to these threads
- $sql = "SELECT
- post.post_id,
- post.forum_id,
- post.poster_id,
- post.poster_name,
- post.post_date,
- users.lastname,
- users.firstname,
- post.visible,
- thread_properties.visibility AS thread_visibility,
- forum_properties.visibility AS forum_visibility,
- post.post_title,
- post.post_text
- FROM
- $table_posts post,
- $table_users users,
- $table_item_property thread_properties,
- $table_item_property forum_properties
- WHERE
- post.forum_id = $forum_id
- AND post.thread_id IN ($threadsList)
- AND post.poster_id = users.user_id
- AND post.thread_id = thread_properties.ref
- AND thread_properties.tool='".TOOL_FORUM_THREAD."'
- AND post.forum_id=forum_properties.ref
- AND forum_properties.tool='".TOOL_FORUM."'
- AND post.c_id = $course_id AND
- thread_properties.c_id = $course_id AND
- forum_properties.c_id = $course_id
- ORDER BY post.post_id DESC";
- $result = Database::query($sql);
- if ($show_invisibles) {
- $row = Database::fetch_array($result);
- $return_array['last_post_id'] = $row['post_id'];
- $return_array['last_poster_id'] = $row['poster_id'];
- $return_array['last_post_date'] = $row['post_date'];
- $return_array['last_poster_name'] = $row['poster_name'];
- $return_array['last_poster_lastname'] = $row['lastname'];
- $return_array['last_poster_firstname'] = $row['firstname'];
- $return_array['last_post_title'] = $row['post_title'];
- $return_array['last_post_text'] = $row['post_text'];
- return $return_array;
- } else {
- // We have to loop through the results to find the first one that is
- // actually visible to students (forum_category, forum, thread AND post are visible).
- while ($row = Database::fetch_array($result)) {
- if ($row['visible'] == '1' && $row['thread_visibility'] == '1' && $row['forum_visibility'] == '1') {
- $return_array['last_post_id'] = $row['post_id'];
- $return_array['last_poster_id'] = $row['poster_id'];
- $return_array['last_post_date'] = $row['post_date'];
- $return_array['last_poster_name'] = $row['poster_name'];
- $return_array['last_poster_lastname'] = $row['lastname'];
- $return_array['last_poster_firstname'] = $row['firstname'];
- $return_array['last_post_title'] = $row['post_title'];
- $return_array['last_post_text'] = $row['post_text'];
- return $return_array;
- }
- }
- }
- }
- /**
- * Retrieve all the threads of a given forum.
- *
- * @param int $forum_id
- * @param int|null $courseId Optional If is null then it is considered the current course
- * @param int|null $sessionId Optional. If is null then it is considered the current session
- *
- * @return array containing all the information about the threads
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_threads($forum_id, $courseId = null, $sessionId = null)
- {
- $groupId = api_get_group_id();
- $sessionId = $sessionId !== null ? (int) $sessionId : api_get_session_id();
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $courseId = $courseId !== null ? (int) $courseId : api_get_course_int_id();
- $groupInfo = GroupManager::get_group_properties($groupId);
- $groupCondition = '';
- if (!empty($groupInfo)) {
- $groupIid = $groupInfo['iid'];
- $groupCondition = " AND item_properties.to_group_id = '$groupIid' ";
- }
- $sessionCondition = api_get_session_condition(
- $sessionId,
- true,
- false,
- 'item_properties.session_id'
- );
- // important note: it might seem a little bit awkward that we have 'thread.locked as locked' in the sql statement
- // because we also have thread.* in it. This is because thread has a field locked and post also has the same field
- // since we are merging these we would have the post.locked value but in fact we want the thread.locked value
- // This is why it is added to the end of the field selection
- $sql = "SELECT DISTINCT
- item_properties.*,
- users.firstname,
- users.lastname,
- users.user_id,
- thread.locked as locked,
- thread.*
- FROM $table_threads thread
- INNER JOIN $table_item_property item_properties
- ON
- thread.thread_id = item_properties.ref AND
- item_properties.c_id = thread.c_id AND
- item_properties.tool = '".TABLE_FORUM_THREAD."'
- $groupCondition
- $sessionCondition
- LEFT JOIN $table_users users
- ON thread.thread_poster_id = users.user_id
- WHERE
- item_properties.visibility='1' AND
- thread.forum_id = ".intval($forum_id)." AND
- thread.c_id = $courseId
- ORDER BY thread.thread_sticky DESC, thread.thread_date DESC";
- if (api_is_allowed_to_edit()) {
- $sql = "SELECT DISTINCT
- item_properties.*,
- users.firstname,
- users.lastname,
- users.user_id,
- thread.locked as locked,
- thread.*
- FROM $table_threads thread
- INNER JOIN $table_item_property item_properties
- ON
- thread.thread_id = item_properties.ref AND
- item_properties.c_id = thread.c_id AND
- item_properties.tool = '".TABLE_FORUM_THREAD."'
- $groupCondition
- $sessionCondition
- LEFT JOIN $table_users users
- ON thread.thread_poster_id=users.user_id
- WHERE
- item_properties.visibility<>2 AND
- thread.forum_id = ".intval($forum_id)." AND
- thread.c_id = $courseId
- ORDER BY thread.thread_sticky DESC, thread.thread_date DESC";
- }
- $result = Database::query($sql);
- $list = [];
- $alreadyAdded = [];
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- if (in_array($row['thread_id'], $alreadyAdded)) {
- continue;
- }
- $list[] = $row;
- $alreadyAdded[] = $row['thread_id'];
- }
- return $list;
- }
- /**
- * Get a thread by Id and course id.
- *
- * @param int $threadId the thread Id
- * @param int $cId the course id
- *
- * @return array containing all the information about the thread
- */
- function getThreadInfo($threadId, $cId)
- {
- $repo = Database::getManager()->getRepository('ChamiloCourseBundle:CForumThread');
- $forumThread = $repo->findOneBy(['threadId' => $threadId, 'cId' => $cId]);
- $thread = [];
- if ($forumThread) {
- $thread['threadId'] = $forumThread->getThreadId();
- $thread['threadTitle'] = $forumThread->getThreadTitle();
- $thread['forumId'] = $forumThread->getForum() ? $forumThread->getForum()->getIid() : 0;
- $thread['sessionId'] = $forumThread->getSessionId();
- $thread['threadSticky'] = $forumThread->getThreadSticky();
- $thread['locked'] = $forumThread->getLocked();
- $thread['threadTitleQualify'] = $forumThread->getThreadTitleQualify();
- $thread['threadQualifyMax'] = $forumThread->getThreadQualifyMax();
- $thread['threadCloseDate'] = $forumThread->getThreadCloseDate();
- $thread['threadWeight'] = $forumThread->getThreadWeight();
- $thread['threadPeerQualify'] = $forumThread->isThreadPeerQualify();
- }
- return $thread;
- }
- /**
- * Retrieve all posts of a given thread.
- *
- * @param array $forumInfo
- * @param int $threadId The thread ID
- * @param string $orderDirection Optional. The direction for sort the posts
- * @param bool $recursive Optional. If the list is recursive
- * @param int $postId Optional. The post ID for recursive list
- * @param int $depth Optional. The depth to indicate the indent
- *
- * @todo move to a repository
- *
- * @return array containing all the information about the posts of a given thread
- */
- function getPosts(
- $forumInfo,
- $threadId,
- $orderDirection = 'ASC',
- $recursive = false,
- $postId = null,
- $depth = -1
- ) {
- $em = Database::getManager();
- if (api_is_allowed_to_edit(false, true)) {
- $visibleCriteria = Criteria::expr()->neq('visible', 2);
- } else {
- $visibleCriteria = Criteria::expr()->eq('visible', 1);
- }
- $criteria = Criteria::create();
- $criteria
- ->where(Criteria::expr()->eq('thread', $threadId))
- ->andWhere(Criteria::expr()->eq('cId', $forumInfo['c_id']))
- ->andWhere($visibleCriteria)
- ;
- $groupId = api_get_group_id();
- $groupInfo = GroupManager::get_group_properties($groupId);
- $filterModerated = true;
- if (empty($groupId)) {
- if (api_is_allowed_to_edit()) {
- $filterModerated = false;
- }
- } else {
- if (GroupManager::is_tutor_of_group(api_get_user_id(), $groupInfo) ||
- api_is_allowed_to_edit(false, true)
- ) {
- $filterModerated = false;
- }
- }
- if ($recursive) {
- $criteria->andWhere(Criteria::expr()->eq('postParentId', $postId));
- }
- $qb = $em->getRepository('ChamiloCourseBundle:CForumPost')->createQueryBuilder('p');
- $qb->select('p')
- ->addCriteria($criteria)
- ->addOrderBy('p.postId', $orderDirection);
- if ($filterModerated && $forumInfo['moderated'] == 1) {
- if (!api_is_allowed_to_edit(false, true)) {
- $userId = api_get_user_id();
- $qb->andWhere(
- "p.status = 1 OR
- (p.status = ".CForumPost::STATUS_WAITING_MODERATION." AND p.posterId = $userId) OR
- (p.status = ".CForumPost::STATUS_REJECTED." AND p.posterId = $userId) OR
- (p.status IS NULL AND p.posterId = $userId)
- "
- );
- }
- }
- $posts = $qb->getQuery()->getResult();
- $depth++;
- $list = [];
- /** @var CForumPost $post */
- foreach ($posts as $post) {
- $postInfo = [
- 'iid' => $post->getIid(),
- 'c_id' => $post->getCId(),
- 'post_id' => $post->getPostId(),
- 'post_title' => $post->getPostTitle(),
- 'post_text' => $post->getPostText(),
- 'thread_id' => $post->getThread() ? $post->getThread()->getIid() : 0,
- 'forum_id' => $post->getForumId(),
- 'poster_id' => $post->getPosterId(),
- 'poster_name' => $post->getPosterName(),
- 'post_date' => $post->getPostDate(),
- 'post_notification' => $post->getPostNotification(),
- 'post_parent_id' => $post->getPostParentId(),
- 'visible' => $post->getVisible(),
- 'status' => $post->getStatus(),
- 'indent_cnt' => $depth,
- ];
- $posterId = $post->getPosterId();
- if (!empty($posterId)) {
- $user = api_get_user_entity($posterId);
- if ($user) {
- $postInfo['user_id'] = $user->getUserId();
- $postInfo['username'] = $user->getUsername();
- $postInfo['username_canonical'] = $user->getUsernameCanonical();
- $postInfo['lastname'] = $user->getLastname();
- $postInfo['firstname'] = $user->getFirstname();
- $postInfo['complete_name'] = UserManager::formatUserFullName($user);
- }
- }
- $list[] = $postInfo;
- if (!$recursive) {
- continue;
- }
- $list = array_merge(
- $list,
- getPosts(
- $forumInfo,
- $threadId,
- $orderDirection,
- $recursive,
- $post->getPostId(),
- $depth
- )
- );
- }
- return $list;
- }
- /**
- * This function retrieves all the information of a post.
- *
- * @param int $post_id integer that indicates the forum
- *
- * @return array returns
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_post_information($post_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $course_id = api_get_course_int_id();
- $post_id = (int) $post_id;
- if (empty($post_id)) {
- return [];
- }
- $sql = "SELECT posts.*, email FROM ".$table_posts." posts, ".$table_users." users
- WHERE
- c_id = $course_id AND
- posts.poster_id=users.user_id AND
- posts.post_id = ".$post_id;
- $result = Database::query($sql);
- $row = Database::fetch_array($result, 'ASSOC');
- return $row;
- }
- /**
- * This function retrieves all the information of a thread.
- *
- * @param int $forumId
- * @param $thread_id integer that indicates the forum
- * @param int|null $sessionId Optional. If is null then it is considered the current session
- *
- * @return array returns
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_thread_information($forumId, $thread_id, $sessionId = null)
- {
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $thread_id = intval($thread_id);
- $sessionId = $sessionId !== null ? intval($sessionId) : api_get_session_id();
- $sessionCondition = api_get_session_condition(
- $sessionId,
- true,
- false,
- 'threads.session_id'
- );
- $forumCondition = '';
- if (!empty($forumId)) {
- $forumId = (int) $forumId;
- $forumCondition = " threads.forum_id = $forumId AND ";
- }
- $sql = "SELECT * FROM $table_item_property item_properties
- INNER JOIN
- $table_threads threads
- ON (item_properties.ref = threads.thread_id AND threads.c_id = item_properties.c_id)
- WHERE
- $forumCondition
- item_properties.tool= '".TOOL_FORUM_THREAD."' AND
- threads.thread_id = $thread_id
- $sessionCondition
- ";
- $result = Database::query($sql);
- $row = Database::fetch_assoc($result);
- return $row;
- }
- /**
- * This function retrieves forum thread users details.
- *
- * @param int Thread ID
- * @param string Course DB name (optional)
- *
- * @return Doctrine\DBAL\Driver\Statement|null array Array of type ([user_id=>w,lastname=>x,firstname=>y,thread_id=>z],[])
- *
- * @author Christian Fasanando <christian.fasanando@dokeos.com>,
- *
- * @todo this function need to be improved
- *
- * @version octubre 2008, dokeos 1.8
- */
- function get_thread_users_details($thread_id)
- {
- $t_posts = Database::get_course_table(TABLE_FORUM_POST);
- $t_users = Database::get_main_table(TABLE_MAIN_USER);
- $t_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
- $t_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $course_id = api_get_course_int_id();
- $is_western_name_order = api_is_western_name_order();
- if ($is_western_name_order) {
- $orderby = 'ORDER BY user.firstname, user.lastname ';
- } else {
- $orderby = 'ORDER BY user.lastname, user.firstname';
- }
- if (api_get_session_id()) {
- $session_info = api_get_session_info(api_get_session_id());
- $user_to_avoid = "'".$session_info['id_coach']."', '".$session_info['session_admin_id']."'";
- //not showing coaches
- $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, thread_id
- FROM $t_posts p, $t_users user, $t_session_rel_user session_rel_user_rel_course
- WHERE
- p.poster_id = user.id AND
- user.id = session_rel_user_rel_course.user_id AND
- session_rel_user_rel_course.status<>'2' AND
- session_rel_user_rel_course.user_id NOT IN ($user_to_avoid) AND
- p.thread_id = ".intval($thread_id)." AND
- session_id = ".api_get_session_id()." AND
- p.c_id = $course_id AND
- session_rel_user_rel_course.c_id = ".$course_id." $orderby ";
- } else {
- $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, thread_id
- FROM $t_posts p, $t_users user, $t_course_user course_user
- WHERE
- p.poster_id = user.id
- AND user.id = course_user.user_id
- AND course_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."
- AND p.thread_id = ".intval($thread_id)."
- AND course_user.status NOT IN('1') AND
- p.c_id = $course_id AND
- course_user.c_id = ".$course_id." $orderby";
- }
- $result = Database::query($sql);
- return $result;
- }
- /**
- * This function retrieves forum thread users qualify.
- *
- * @param int Thread ID
- * @param string Course DB name (optional)
- *
- * @return Doctrine\DBAL\Driver\Statement|null Array of type ([user_id=>w,lastname=>x,firstname=>y,thread_id=>z],[])
- *
- * @author Jhon Hinojosa
- *
- * @todo this function need to be improved
- */
- function get_thread_users_qualify($thread_id)
- {
- $t_posts = Database::get_course_table(TABLE_FORUM_POST);
- $t_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $t_users = Database::get_main_table(TABLE_MAIN_USER);
- $t_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
- $t_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $course_id = api_get_course_int_id();
- $sessionId = api_get_session_id();
- $is_western_name_order = api_is_western_name_order();
- if ($is_western_name_order) {
- $orderby = 'ORDER BY user.firstname, user.lastname ';
- } else {
- $orderby = 'ORDER BY user.lastname, user.firstname';
- }
- if ($sessionId) {
- $session_info = api_get_session_info($sessionId);
- $user_to_avoid = "'".$session_info['id_coach']."', '".$session_info['session_admin_id']."'";
- //not showing coaches
- $sql = "SELECT DISTINCT post.poster_id, user.lastname, user.firstname, post.thread_id,user.id,qualify.qualify
- FROM $t_posts post , $t_users user, $t_session_rel_user scu, $t_qualify qualify
- WHERE poster_id = user.id
- AND post.poster_id = qualify.user_id
- AND user.id = scu.user_id
- AND scu.status<>'2'
- AND scu.user_id NOT IN ($user_to_avoid)
- AND qualify.thread_id = ".intval($thread_id)."
- AND post.thread_id = ".intval($thread_id)."
- AND scu.session_id = $sessionId
- AND scu.c_id = ".$course_id." AND
- qualify.c_id = $course_id AND
- post.c_id = $course_id
- $orderby ";
- } else {
- $sql = "SELECT DISTINCT post.poster_id, user.lastname, user.firstname, post.thread_id,user.id,qualify.qualify
- FROM $t_posts post,
- $t_qualify qualify,
- $t_users user,
- $t_course_user course_user
- WHERE
- post.poster_id = user.id
- AND post.poster_id = qualify.user_id
- AND user.id = course_user.user_id
- AND course_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."
- AND qualify.thread_id = ".intval($thread_id)."
- AND post.thread_id = ".intval($thread_id)."
- AND course_user.status not in('1')
- AND course_user.c_id = $course_id
- AND qualify.c_id = $course_id
- AND post.c_id = $course_id
- $orderby ";
- }
- $result = Database::query($sql);
- return $result;
- }
- /**
- * This function retrieves forum thread users not qualify.
- *
- * @param int Thread ID
- * @param string Course DB name (optional)
- *
- * @return Doctrine\DBAL\Driver\Statement|null Array of type ([user_id=>w,lastname=>x,firstname=>y,thread_id=>z],[])
- *
- * @author Jhon Hinojosa<jhon.hinojosa@dokeos.com>,
- *
- * @version oct 2008, dokeos 1.8
- */
- function get_thread_users_not_qualify($thread_id)
- {
- $t_posts = Database::get_course_table(TABLE_FORUM_POST);
- $t_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $t_users = Database::get_main_table(TABLE_MAIN_USER);
- $t_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
- $t_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
- $is_western_name_order = api_is_western_name_order();
- if ($is_western_name_order) {
- $orderby = 'ORDER BY user.firstname, user.lastname ';
- } else {
- $orderby = 'ORDER BY user.lastname, user.firstname';
- }
- $course_id = api_get_course_int_id();
- $sql1 = "SELECT user_id FROM $t_qualify
- WHERE c_id = $course_id AND thread_id = '".$thread_id."'";
- $result1 = Database::query($sql1);
- $cad = '';
- while ($row = Database::fetch_array($result1)) {
- $cad .= $row['user_id'].',';
- }
- if ($cad == '') {
- $cad = '0';
- } else {
- $cad = substr($cad, 0, strlen($cad) - 1);
- }
- if (api_get_session_id()) {
- $session_info = api_get_session_info(api_get_session_id());
- $user_to_avoid = "'".$session_info['id_coach']."', '".$session_info['session_admin_id']."'";
- //not showing coaches
- $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, post.thread_id
- FROM $t_posts post , $t_users user, $t_session_rel_user session_rel_user_rel_course
- WHERE poster_id = user.id
- AND user.id NOT IN (".$cad.")
- AND user.id = session_rel_user_rel_course.user_id
- AND session_rel_user_rel_course.status<>'2'
- AND session_rel_user_rel_course.user_id NOT IN ($user_to_avoid)
- AND post.thread_id = ".intval($thread_id)."
- AND session_id = ".api_get_session_id()."
- AND session_rel_user_rel_course.c_id = $course_id AND post.c_id = $course_id $orderby ";
- } else {
- $sql = "SELECT DISTINCT user.id, user.lastname, user.firstname, post.thread_id
- FROM $t_posts post, $t_users user,$t_course_user course_user
- WHERE post.poster_id = user.id
- AND user.id NOT IN (".$cad.")
- AND user.id = course_user.user_id
- AND course_user.relation_type<>".COURSE_RELATION_TYPE_RRHH."
- AND post.thread_id = ".intval($thread_id)."
- AND course_user.status not in('1')
- AND course_user.c_id = $course_id AND post.c_id = $course_id $orderby";
- }
- $result = Database::query($sql);
- return $result;
- }
- /**
- * This function retrieves all the information of a given forum_id.
- *
- * @param $forum_id integer that indicates the forum
- *
- * @return array returns
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- *
- * @deprecated this functionality is now moved to get_forums($forum_id)
- */
- function get_forum_information($forum_id, $courseId = 0)
- {
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $courseId = empty($courseId) ? api_get_course_int_id() : intval($courseId);
- $forum_id = intval($forum_id);
- $sql = "SELECT *
- FROM $table_forums forums
- INNER JOIN $table_item_property item_properties
- ON (forums.c_id = item_properties.c_id)
- WHERE
- item_properties.tool = '".TOOL_FORUM."' AND
- item_properties.ref = '".$forum_id."' AND
- forums.forum_id = '".$forum_id."' AND
- forums.c_id = ".$courseId."
- ";
- $result = Database::query($sql);
- $row = Database::fetch_array($result, 'ASSOC');
- $row['approval_direct_post'] = 0;
- // We can't anymore change this option, so it should always be activated.
- return $row;
- }
- /**
- * This function retrieves all the information of a given forumcategory id.
- *
- * @param $cat_id integer that indicates the forum
- *
- * @return array returns if there are category or bool returns if there aren't category
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_forumcategory_information($cat_id)
- {
- $table_categories = Database::get_course_table(TABLE_FORUM_CATEGORY);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $course_id = api_get_course_int_id();
- $sql = "SELECT *
- FROM $table_categories forumcategories
- INNER JOIN $table_item_property item_properties
- ON (forumcategories.c_id = item_properties.c_id)
- WHERE
- forumcategories.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.tool='".TOOL_FORUM_CATEGORY."' AND
- item_properties.ref='".Database::escape_string($cat_id)."' AND
- forumcategories.cat_id='".Database::escape_string($cat_id)."'";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- return $row;
- }
- /**
- * This function counts the number of forums inside a given category.
- *
- * @param int $cat_id the id of the forum category
- *
- * @todo an additional parameter that takes the visibility into account. For instance $countinvisible=0 would return the number
- * of visible forums, $countinvisible=1 would return the number of visible and invisible forums
- *
- * @return int the number of forums inside the given category
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function count_number_of_forums_in_category($cat_id)
- {
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $course_id = api_get_course_int_id();
- $cat_id = (int) $cat_id;
- $sql = "SELECT count(*) AS number_of_forums
- FROM $table_forums
- WHERE c_id = $course_id AND forum_category = $cat_id";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- return $row['number_of_forums'];
- }
- /**
- * This function update a thread.
- *
- * @param array $values - The form Values
- */
- function updateThread($values)
- {
- if (!api_is_allowed_to_edit()) {
- return '';
- }
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $values['forum_id'],
- 'tool_id_detail' => $values['thread_id'],
- 'action' => 'edit-thread',
- 'action_details' => 'thread',
- 'info' => $values['thread_title'],
- ];
- Event::registerLog($logInfo);
- $threadTable = Database::get_course_table(TABLE_FORUM_THREAD);
- $courseId = api_get_course_int_id();
- $courseCode = api_get_course_id();
- $sessionId = api_get_session_id();
- // Simple update + set gradebook values to null
- $params = [
- 'thread_title' => $values['thread_title'],
- 'thread_sticky' => isset($values['thread_sticky']) ? $values['thread_sticky'] : 0,
- ];
- $where = ['c_id = ? AND thread_id = ?' => [$courseId, $values['thread_id']]];
- Database::update($threadTable, $params, $where);
- $id = $values['thread_id'];
- $linkInfo = GradebookUtils::isResourceInCourseGradebook(
- $courseCode,
- LINK_FORUM_THREAD,
- $id,
- $sessionId
- );
- $linkId = $linkInfo['id'];
- $em = Database::getManager();
- $gradebookLink = null;
- if (!empty($linkId)) {
- $gradebookLink = $em->getRepository('ChamiloCoreBundle:GradebookLink')->find($linkId);
- }
- // values 1 or 0
- $check = isset($values['thread_qualify_gradebook']) ? $values['thread_qualify_gradebook'] : false;
- if ($check) {
- $title = Security::remove_XSS(stripslashes($values['calification_notebook_title']));
- $value = isset($values['numeric_calification']) ? intval($values['numeric_calification']) : 0;
- $weight = isset($values['weight_calification']) ? floatval($values['weight_calification']) : 0;
- $description = '';
- // Update title
- $params = [
- 'thread_title_qualify' => $values['calification_notebook_title'],
- 'thread_qualify_max' => api_float_val($values['numeric_calification']),
- 'thread_weight' => api_float_val($values['weight_calification']),
- 'thread_peer_qualify' => $values['thread_peer_qualify'],
- ];
- $where = ['c_id = ? AND thread_id = ?' => [$courseId, $values['thread_id']]];
- Database::update($threadTable, $params, $where);
- if (!$linkInfo) {
- GradebookUtils::add_resource_to_course_gradebook(
- $values['category_id'],
- $courseCode,
- LINK_FORUM_THREAD,
- $id,
- $title,
- $weight,
- $value,
- $description,
- 1,
- $sessionId
- );
- } else {
- if ($gradebookLink) {
- $gradebookLink->setWeight($weight);
- $em->persist($gradebookLink);
- $em->flush();
- }
- }
- } else {
- $params = [
- 'thread_title_qualify' => '',
- 'thread_qualify_max' => 0,
- 'thread_weight' => 0,
- 'thread_peer_qualify' => 0,
- ];
- $where = ['c_id = ? AND thread_id = ?' => [$courseId, $values['thread_id']]];
- Database::update($threadTable, $params, $where);
- if (!empty($linkInfo)) {
- if ($gradebookLink) {
- $em->remove($gradebookLink);
- $em->flush();
- }
- }
- }
- $message = get_lang('The post has been modified').'<br />';
- Display::addFlash(Display::return_message($message, 'confirmation', false));
- }
- /**
- * This function stores a new thread. This is done through an entry in the forum_thread table AND
- * in the forum_post table because. The threads are also stored in the item_property table. (forum posts are not (yet)).
- *
- * @param array $current_forum
- * @param array $values
- * @param array $courseInfo
- * @param bool $showMessage
- * @param int $userId Optional. The user ID
- * @param int $sessionId
- *
- * @return CForumThread
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_thread(
- $current_forum,
- $values,
- $courseInfo = [],
- $showMessage = true,
- $userId = 0,
- $sessionId = 0
- ) {
- $courseInfo = empty($courseInfo) ? api_get_course_info() : $courseInfo;
- $userId = $userId ?: api_get_user_id();
- $course_id = $courseInfo['real_id'];
- $courseCode = $courseInfo['code'];
- $groupId = api_get_group_id();
- $groupInfo = GroupManager::get_group_properties($groupId);
- $sessionId = $sessionId ?: api_get_session_id();
- $em = Database::getManager();
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $upload_ok = 1;
- $has_attachment = false;
- if (!empty($_FILES['user_upload']['name'])) {
- $upload_ok = process_uploaded_file($_FILES['user_upload']);
- $has_attachment = true;
- }
- if (!$upload_ok) {
- if ($showMessage) {
- Display::addFlash(
- Display::return_message(
- get_lang('No file was uploaded.'),
- 'error',
- false
- )
- );
- }
- return null;
- }
- $post_date = new DateTime(api_get_utc_datetime(), new DateTimeZone('UTC'));
- $visible = 1;
- if ($current_forum['approval_direct_post'] == '1' && !api_is_allowed_to_edit(null, true)) {
- $visible = 0; // The post has not been approved yet.
- }
- $clean_post_title = $values['post_title'];
- $forum = $em->find('ChamiloCourseBundle:CForumForum', $values['forum_id']);
- // We first store an entry in the forum_thread table because the thread_id is used in the forum_post table.
- $lastThread = new CForumThread();
- $lastThread
- ->setCId($course_id)
- ->setThreadTitle($clean_post_title)
- ->setForum($forum)
- ->setThreadPosterId($userId)
- ->setThreadPosterName(isset($values['poster_name']) ? $values['poster_name'] : null)
- ->setThreadDate($post_date)
- ->setThreadSticky(isset($values['thread_sticky']) ? $values['thread_sticky'] : 0)
- ->setThreadTitleQualify(
- isset($values['calification_notebook_title']) ? $values['calification_notebook_title'] : null
- )
- ->setThreadQualifyMax(isset($values['numeric_calification']) ? (int) $values['numeric_calification'] : 0)
- ->setThreadWeight(isset($values['weight_calification']) ? (int) $values['weight_calification'] : 0)
- ->setThreadPeerQualify(isset($values['thread_peer_qualify']) ? (bool) $values['thread_peer_qualify'] : false)
- ->setSessionId($sessionId)
- ->setLpItemId(isset($values['lp_item_id']) ? (int) $values['lp_item_id'] : 0)
- ->setThreadId(0)
- ->setLocked(0)
- ;
- $em->persist($lastThread);
- $em->flush();
- // Add option gradebook qualify.
- if (isset($values['thread_qualify_gradebook']) &&
- 1 == $values['thread_qualify_gradebook']
- ) {
- // Add function gradebook.
- $resourcename = stripslashes($values['calification_notebook_title']);
- GradebookUtils::add_resource_to_course_gradebook(
- $values['category_id'],
- $courseCode,
- 5,
- $lastThread->getIid(),
- $resourcename,
- $values['weight_calification'],
- $values['numeric_calification'],
- '',
- 0,
- $sessionId
- );
- }
- if ($lastThread->getIid()) {
- $lastThread->setThreadId($lastThread->getIid());
- $em->merge($lastThread);
- $em->flush();
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM_THREAD,
- $lastThread->getIid(),
- 'ForumThreadAdded',
- $userId,
- $groupInfo,
- null,
- null,
- null,
- $sessionId
- );
- // If the forum properties tell that the posts have to be approved
- // we have to put the whole thread invisible,
- // because otherwise the students will see the thread and not the post
- // in the thread.
- // We also have to change $visible because the post itself has to be
- // visible in this case (otherwise the teacher would have
- // to make the thread visible AND the post.
- // Default behaviour
- api_set_default_visibility(
- $lastThread->getIid(),
- TOOL_FORUM_THREAD,
- $groupId,
- $courseInfo,
- $sessionId,
- $userId
- );
- if ($visible == 0) {
- api_item_property_update(
- $courseInfo,
- TOOL_FORUM_THREAD,
- $lastThread->getIid(),
- 'invisible',
- $userId,
- $groupInfo
- );
- $visible = 1;
- }
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $values['forum_id'],
- 'tool_id_detail' => $lastThread->getIid(),
- 'action' => 'new-thread',
- 'action_details' => '',
- 'info' => $clean_post_title,
- ];
- Event::registerLog($logInfo);
- }
- // We now store the content in the table_post table.
- $lastPost = new CForumPost();
- $lastPost
- ->setCId($course_id)
- ->setPostTitle($clean_post_title)
- ->setPostText($values['post_text'])
- ->setThread($lastThread)
- ->setForumId($values['forum_id'])
- ->setPosterId($userId)
- ->setPosterName(isset($values['poster_name']) ? $values['poster_name'] : null)
- ->setPostDate($post_date)
- ->setPostNotification(isset($values['post_notification']) ? (int) $values['post_notification'] : null)
- ->setPostParentId(null)
- ->setVisible($visible)
- ->setPostId(0)
- ->setStatus(CForumPost::STATUS_VALIDATED);
- if ($current_forum['moderated']) {
- $lastPost->setStatus(
- api_is_course_admin() ? CForumPost::STATUS_VALIDATED : CForumPost::STATUS_WAITING_MODERATION
- );
- }
- $em->persist($lastPost);
- $em->flush();
- $lastPostId = $lastPost->getIid();
- $lastThread->setThreadLastPost($lastPostId);
- $em->merge($lastThread);
- $em->flush();
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $values['forum_id'],
- 'tool_id_detail' => $lastThread->getIid(),
- 'action' => 'new-post',
- 'info' => $clean_post_title,
- ];
- Event::registerLog($logInfo);
- if ($lastPostId) {
- $lastPost->setPostId($lastPostId);
- $em->merge($lastPost);
- $em->flush();
- }
- // Update attached files
- if (!empty($_POST['file_ids']) && is_array($_POST['file_ids'])) {
- foreach ($_POST['file_ids'] as $key => $id) {
- editAttachedFile(
- [
- 'comment' => $_POST['file_comments'][$key],
- 'post_id' => $lastPostId,
- ],
- $id
- );
- }
- }
- // Now we have to update the thread table to fill the thread_last_post
- // field (so that we know when the thread has been updated for the last time).
- $sql = "UPDATE $table_threads
- SET thread_last_post = '".Database::escape_string($lastPostId)."'
- WHERE
- c_id = $course_id AND
- thread_id='".Database::escape_string($lastThread->getIid())."'";
- $result = Database::query($sql);
- $message = get_lang('The new thread has been added');
- // Overwrite default message.
- if ($current_forum['moderated'] &&
- !api_is_allowed_to_edit(null, true)
- ) {
- $message = get_lang('Your message has to be approved before people can view it.');
- }
- // Storing the attachments if any.
- if ($has_attachment) {
- // Try to add an extension to the file if it hasn't one.
- $new_file_name = add_ext_on_mime(
- stripslashes($_FILES['user_upload']['name']),
- $_FILES['user_upload']['type']
- );
- if (!filter_extension($new_file_name)) {
- if ($showMessage) {
- Display::addFlash(Display::return_message(
- get_lang('File upload failed: this file extension or file type is prohibited'),
- 'error'
- ));
- }
- } else {
- if ($result) {
- add_forum_attachment_file(
- isset($values['file_comment']) ? $values['file_comment'] : null,
- $lastPostId
- );
- }
- }
- } else {
- $message .= '<br />';
- }
- if ($current_forum['approval_direct_post'] == '1' &&
- !api_is_allowed_to_edit(null, true)
- ) {
- $message .= get_lang('Your message has to be approved before people can view it.').'<br />';
- $message .= get_lang('You can now return to the').' <a href="viewforum.php?'.api_get_cidreq().'&forum='.$values['forum_id'].'">'.
- get_lang('Forum').'</a><br />';
- } else {
- $message .= get_lang('You can now return to the').' <a href="viewforum.php?'.api_get_cidreq().'&forum='.$values['forum_id'].'">'.
- get_lang('Forum').'</a><br />';
- $message .= get_lang('You can now return to the').' <a href="viewthread.php?'.api_get_cidreq().'&forum='.$values['forum_id'].'&thread='.$lastThread->getIid().'">'.
- get_lang('Message').'</a>';
- }
- $reply_info['new_post_id'] = $lastPostId;
- $my_post_notification = isset($values['post_notification']) ? $values['post_notification'] : null;
- if ($my_post_notification == 1) {
- set_notification('thread', $lastThread->getIid(), true);
- }
- send_notification_mails(
- $current_forum['forum_id'],
- $lastThread->getIid(),
- $reply_info,
- $courseInfo['code']
- );
- Session::erase('formelements');
- Session::erase('origin');
- Session::erase('breadcrumbs');
- Session::erase('addedresource');
- Session::erase('addedresourceid');
- if ($showMessage) {
- Display::addFlash(Display::return_message($message, 'success', false));
- }
- return $lastThread;
- }
- /**
- * This function displays the form that is used to add a post. This can be a new thread or a reply.
- *
- * @param array $current_forum
- * @param string $action is the parameter that determines if we are
- * 1. newthread: adding a new thread (both empty) => No I-frame
- * 2. replythread: Replying to a thread ($action = replythread) => I-frame with the complete thread (if enabled)
- * 3. replymessage: Replying to a message ($action =replymessage) => I-frame with the complete thread (if enabled)
- * (I first thought to put and I-frame with the message only)
- * 4. quote: Quoting a message ($action= quotemessage) => I-frame with the complete thread (if enabled).
- * The message will be in the reply. (I first thought not to put an I-frame here)
- * @param array $form_values
- * @param bool $showPreview
- *
- * @return FormValidator
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function show_add_post_form($current_forum, $action, $form_values = '', $showPreview = true)
- {
- $_user = api_get_user_info();
- $action = isset($action) ? Security::remove_XSS($action) : '';
- $myThread = isset($_GET['thread']) ? (int) $_GET['thread'] : '';
- $forumId = isset($_GET['forum']) ? (int) $_GET['forum'] : '';
- $my_post = isset($_GET['post']) ? (int) $_GET['post'] : '';
- $giveRevision = isset($_GET['give_revision']) && $_GET['give_revision'] == 1;
- $url = api_get_self().'?'.http_build_query(
- [
- 'action' => $action,
- 'forum' => $forumId,
- 'thread' => $myThread,
- 'post' => $my_post,
- ]
- ).'&'.api_get_cidreq();
- $form = new FormValidator(
- 'thread',
- 'post',
- $url
- );
- $form->setConstants(['forum' => '5']);
- // Setting the form elements.
- $form->addElement('hidden', 'forum_id', $forumId);
- $form->addElement('hidden', 'thread_id', $myThread);
- $form->addElement('hidden', 'action', $action);
- // If anonymous posts are allowed we also display a form to allow the user to put his name or username in.
- if ($current_forum['allow_anonymous'] == 1 && !isset($_user['user_id'])) {
- $form->addElement('text', 'poster_name', get_lang('Name'));
- $form->applyFilter('poster_name', 'html_filter');
- }
- $form->addElement('text', 'post_title', get_lang('Title'));
- $form->addHtmlEditor(
- 'post_text',
- get_lang('Text'),
- true,
- false,
- api_is_allowed_to_edit(null, true) ? [
- 'ToolbarSet' => 'Forum',
- 'Width' => '100%',
- 'Height' => '300',
- ] : [
- 'ToolbarSet' => 'ForumStudent',
- 'Width' => '100%',
- 'Height' => '300',
- 'UserStatus' => 'student',
- ]
- );
- $form->addRule('post_text', get_lang('Required field'), 'required');
- if (in_array($action, ['newthread', 'replythread', 'replymessage', 'quote'])) {
- $extraFields = new ExtraField('forum_post');
- $extraFields->addElements(
- $form,
- null,
- [], //exclude
- false, // filter
- false, // tag as select
- ['ask_for_revision'], //show only fields
- [], // order fields
- [] // extra data);
- );
- }
- $iframe = null;
- if ($showPreview) {
- $myThread = Security::remove_XSS($myThread);
- if ($action != 'newthread' && !empty($myThread)) {
- $iframe = "<iframe style=\"border: 1px solid black\" src=\"iframe_thread.php?".api_get_cidreq(
- )."&forum=".$forumId."&thread=".$myThread."#".$my_post."\" width=\"100%\"></iframe>";
- }
- if (!empty($iframe)) {
- $form->addElement('label', get_lang('Thread'), $iframe);
- }
- }
- if (Gradebook::is_active() &&
- (api_is_course_admin() || api_is_session_general_coach() || api_is_course_tutor()) && !($myThread)
- ) {
- $form->addElement('advanced_settings', 'advanced_params', get_lang('Advanced settings'));
- $form->addElement('html', '<div id="advanced_params_options" style="display:none">');
- // Thread qualify
- if (Gradebook::is_active()) {
- //Loading gradebook select
- GradebookUtils::load_gradebook_select_in_tool($form);
- $form->addElement(
- 'checkbox',
- 'thread_qualify_gradebook',
- '',
- get_lang('Grade this thread'),
- 'onclick="javascript:if(this.checked==true){document.getElementById(\'options_field\').style.display = \'block\';}else{document.getElementById(\'options_field\').style.display = \'none\';}"'
- );
- } else {
- $form->addElement('hidden', 'thread_qualify_gradebook', false);
- }
- $form->addElement('html', '<div id="options_field" style="display:none">');
- $form->addElement('text', 'numeric_calification', get_lang('Maximum score'));
- $form->applyFilter('numeric_calification', 'html_filter');
- $form->addElement('text', 'calification_notebook_title', get_lang('Column header in Competences Report'));
- $form->applyFilter('calification_notebook_title', 'html_filter');
- $form->addElement(
- 'text',
- 'weight_calification',
- get_lang('Weight in Report'),
- ['value' => '0.00', 'onfocus' => "javascript: this.select();"]
- );
- $form->applyFilter('weight_calification', 'html_filter');
- $group = [];
- $group[] = $form->createElement('radio', 'thread_peer_qualify', null, get_lang('Yes'), 1);
- $group[] = $form->createElement('radio', 'thread_peer_qualify', null, get_lang('No'), 0);
- $form->addGroup(
- $group,
- '',
- [
- get_lang('Thread scored by peers'),
- get_lang('Thread scored by peersComment'),
- ]
- );
- $form->addElement('html', '</div>');
- $form->addElement('html', '</div>');
- }
- if ($action === 'newthread') {
- Skill::addSkillsToForm($form, ITEM_TYPE_FORUM_THREAD, 0);
- }
- if (api_is_allowed_to_edit(null, true) && $action == 'newthread') {
- $form->addElement('checkbox', 'thread_sticky', '', get_lang('This is a sticky message (appears always on top and has a special sticky icon)'));
- }
- if (in_array($action, ['quote', 'replymessage'])) {
- $form->addFile('user_upload[]', get_lang('Attachment'));
- $form->addButton(
- 'add_attachment',
- get_lang('Add attachment'),
- 'paperclip',
- 'default',
- 'default',
- null,
- ['id' => 'reply-add-attachment']
- );
- } else {
- $form->addFile('user_upload', get_lang('Attachment'));
- }
- if ($giveRevision) {
- $hide = api_get_configuration_value('hide_forum_post_revision_language');
- $form->addHidden('give_revision', 1);
- if ($hide === false) {
- $extraField = new ExtraField('forum_post');
- $extraField->addElements(
- $form,
- null,
- [], //exclude
- false, // filter
- false, // tag as select
- ['revision_language'], //show only fields
- [], // order fields
- [] // extra data
- );
- } else {
- $form->addHidden('extra_revision_language', 1);
- }
- }
- // Setting the class and text of the form title and submit button.
- if ($action == 'quote') {
- $form->addButtonCreate(get_lang('Quote this message'), 'SubmitPost');
- } elseif ($action == 'replythread') {
- $form->addButtonCreate(get_lang('Reply to this thread'), 'SubmitPost');
- } elseif ($action == 'replymessage') {
- $form->addButtonCreate(get_lang('Reply to this message'), 'SubmitPost');
- } else {
- $form->addButtonCreate(get_lang('Create thread'), 'SubmitPost');
- }
- $defaults['thread_peer_qualify'] = 0;
- if (!empty($form_values)) {
- $defaults['post_title'] = prepare4display($form_values['post_title']);
- $defaults['post_text'] = prepare4display($form_values['post_text']);
- $defaults['post_notification'] = (int) $form_values['post_notification'];
- $defaults['thread_sticky'] = (int) $form_values['thread_sticky'];
- $defaults['thread_peer_qualify'] = (int) $form_values['thread_peer_qualify'];
- }
- // If we are quoting a message we have to retrieve the information of the post we are quoting so that
- // we can add this as default to the textarea.
- // We also need to put the parent_id of the post in a hidden form when
- if (($action == 'quote' || $action == 'replymessage' || $giveRevision) && !empty($my_post)) {
- // we are quoting or replying to a message (<> reply to a thread !!!)
- $form->addHidden('post_parent_id', $my_post);
- // If we are replying or are quoting then we display a default title.
- $values = get_post_information($my_post);
- $posterInfo = api_get_user_info($values['poster_id']);
- $posterName = '';
- if ($posterInfo) {
- $posterName = $posterInfo['complete_name'];
- }
- $defaults['post_title'] = get_lang('Re:').api_html_entity_decode($values['post_title'], ENT_QUOTES);
- // When we are quoting a message then we have to put that message into the wysiwyg editor.
- // Note: The style has to be hardcoded here because using class="quote" didn't work.
- if ($action == 'quote') {
- $defaults['post_text'] = '<div> </div>
- <div style="margin: 5px;">
- <div style="font-size: 90%; font-style: italic;">'.
- get_lang('Quoting').' '.$posterName.':</div>
- <div style="color: #006600; font-size: 90%; font-style: italic; background-color: #FAFAFA; border: #D1D7DC 1px solid; padding: 3px;">'.
- prepare4display($values['post_text']).'
- </div>
- </div>
- <div> </div>
- <div> </div>
- ';
- }
- if ($giveRevision) {
- $defaults['post_text'] = prepare4display($values['post_text']);
- }
- }
- $form->setDefaults(isset($defaults) ? $defaults : []);
- // The course admin can make a thread sticky (=appears with special icon and always on top).
- $form->addRule('post_title', get_lang('Required field'), 'required');
- if ($current_forum['allow_anonymous'] == 1 && !isset($_user['user_id'])) {
- $form->addRule(
- 'poster_name',
- get_lang('Required field'),
- 'required'
- );
- }
- // Validation or display
- if ($form->validate()) {
- $check = Security::check_token('post');
- if ($check) {
- $values = $form->getSubmitValues();
- if (isset($values['thread_qualify_gradebook']) &&
- $values['thread_qualify_gradebook'] == '1' &&
- empty($values['weight_calification'])
- ) {
- Display::addFlash(
- Display::return_message(
- get_lang('You must assign a score to this activity').' <a href="javascript:window.history.go(-1);">'.get_lang('Back').'</a>',
- 'error',
- false
- )
- );
- return false;
- }
- $postId = 0;
- $threadId = 0;
- switch ($action) {
- case 'newthread':
- $myThread = store_thread($current_forum, $values);
- if ($myThread) {
- $threadId = $myThread->getIid();
- Skill::saveSkills($form, ITEM_TYPE_FORUM_THREAD, $threadId);
- $postId = $myThread->getThreadLastPost();
- }
- break;
- case 'quote':
- case 'replythread':
- case 'replymessage':
- $postId = store_reply($current_forum, $values);
- break;
- }
- if ($postId) {
- $postInfo = get_post_information($postId);
- if ($postInfo) {
- $threadId = $postInfo['thread_id'];
- }
- if (isset($values['give_revision']) && $values['give_revision'] == 1) {
- $extraFieldValues = new ExtraFieldValue('forum_post');
- $revisionLanguage = isset($values['extra_revision_language']) ? $values['extra_revision_language'] : '';
- $params = [
- 'item_id' => $postId,
- 'extra_revision_language' => $revisionLanguage,
- ];
- $extraFieldValues->saveFieldValues(
- $params,
- false,
- false,
- ['revision_language']
- );
- }
- if (in_array($action, ['newthread', 'replythread', 'replymessage', 'quote'])) {
- $extraFieldValues = new ExtraFieldValue('forum_post');
- $params = [
- 'item_id' => $postId,
- 'extra_ask_for_revision' => isset($values['extra_ask_for_revision']) ? $values['extra_ask_for_revision'] : '',
- ];
- $extraFieldValues->saveFieldValues(
- $params,
- false,
- false,
- ['ask_for_revision']
- );
- }
- }
- $url = api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.api_get_cidreq().'&'.http_build_query(
- [
- 'forum' => $forumId,
- 'thread' => $threadId,
- ]
- );
- Security::clear_token();
- header('Location: '.$url);
- exit;
- }
- } else {
- $token = Security::get_token();
- $form->addElement('hidden', 'sec_token');
- $form->setConstants(['sec_token' => $token]);
- // Delete from $_SESSION forum attachment from other posts
- // and keep only attachments for new post
- clearAttachedFiles(FORUM_NEW_POST);
- // Get forum attachment ajax table to add it to form
- $attachmentAjaxTable = getAttachmentsAjaxTable(0, $current_forum['forum_id']);
- $ajaxHtml = $attachmentAjaxTable;
- $form->addElement('html', $ajaxHtml);
- return $form;
- }
- }
- /**
- * @param array $threadInfo
- * @param int $user_id
- * @param int $thread_id
- * @param int $thread_qualify
- * @param int $qualify_time
- * @param int $session_id
- *
- * @return array optional
- *
- * @author Isaac Flores <isaac.flores@dokeos.com>, U.N.A.S University
- *
- * @version October 2008, dokeos 1.8.6
- */
- function saveThreadScore(
- $threadInfo,
- $user_id,
- $thread_id,
- $thread_qualify = 0,
- $qualify_time,
- $session_id = 0
- ) {
- $table_threads_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $session_id = intval($session_id);
- $currentUserId = api_get_user_id();
- if ($user_id == strval(intval($user_id)) &&
- $thread_id == strval(intval($thread_id)) &&
- $thread_qualify == strval(floatval($thread_qualify))
- ) {
- // Testing
- $sql = "SELECT thread_qualify_max FROM $table_threads
- WHERE c_id = $course_id AND thread_id=".$thread_id;
- $res_string = Database::query($sql);
- $row_string = Database::fetch_array($res_string);
- if ($thread_qualify <= $row_string[0]) {
- if ($threadInfo['thread_peer_qualify'] == 0) {
- $sql = "SELECT COUNT(*) FROM $table_threads_qualify
- WHERE
- c_id = $course_id AND
- user_id = $user_id AND
- thread_id = ".$thread_id;
- } else {
- $sql = "SELECT COUNT(*) FROM $table_threads_qualify
- WHERE
- c_id = $course_id AND
- user_id = $user_id AND
- qualify_user_id = $currentUserId AND
- thread_id = ".$thread_id;
- }
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- if ($row[0] == 0) {
- $sql = "INSERT INTO $table_threads_qualify (c_id, user_id, thread_id,qualify,qualify_user_id,qualify_time,session_id)
- VALUES (".$course_id.", '".$user_id."','".$thread_id."',".(float) $thread_qualify.", '".$currentUserId."','".$qualify_time."','".$session_id."')";
- Database::query($sql);
- $insertId = Database::insert_id();
- if ($insertId) {
- $sql = "UPDATE $table_threads_qualify SET id = iid
- WHERE iid = $insertId";
- Database::query($sql);
- }
- return 'insert';
- } else {
- saveThreadScoreHistory(
- '1',
- $course_id,
- $user_id,
- $thread_id
- );
- // Update
- $sql = "UPDATE $table_threads_qualify
- SET
- qualify = '".$thread_qualify."',
- qualify_time = '".$qualify_time."'
- WHERE
- c_id = $course_id AND
- user_id=".$user_id." AND
- thread_id=".$thread_id." AND
- qualify_user_id = $currentUserId
- ";
- Database::query($sql);
- return 'update';
- }
- } else {
- return null;
- }
- }
- }
- /**
- * This function shows qualify.
- *
- * @param string $option contains the information of option to run
- * @param int $user_id contains the information the current user id
- * @param int $thread_id contains the information the current thread id
- *
- * @return int qualify
- * <code> $option=1 obtained the qualification of the current thread</code>
- *
- * @author Isaac Flores <isaac.flores@dokeos.com>, U.N.A.S University
- *
- * @version October 2008, dokeos 1.8.6
- */
- function showQualify($option, $user_id, $thread_id)
- {
- $table_threads_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $user_id = (int) $user_id;
- $thread_id = (int) $thread_id;
- if (empty($user_id) || empty($thread_id)) {
- return false;
- }
- $sql = '';
- switch ($option) {
- case 1:
- $sql = "SELECT qualify FROM $table_threads_qualify
- WHERE
- c_id = $course_id AND
- user_id=".$user_id." AND
- thread_id=".$thread_id;
- break;
- case 2:
- $sql = "SELECT thread_qualify_max FROM $table_threads
- WHERE c_id = $course_id AND thread_id=".$thread_id;
- break;
- }
- if (!empty($sql)) {
- $rs = Database::query($sql);
- $row = Database::fetch_array($rs);
- return $row[0];
- }
- return [];
- }
- /**
- * This function gets qualify historical.
- *
- * @param int $user_id contains the information the current user id
- * @param int $thread_id contains the information the current thread id
- * @param bool $opt contains the information of option to run
- *
- * @return array
- *
- * @author Christian Fasanando <christian.fasanando@dokeos.com>,
- * @author Isaac Flores <isaac.flores@dokeos.com>,
- *
- * @version October 2008, dokeos 1.8.6
- */
- function getThreadScoreHistory($user_id, $thread_id, $opt)
- {
- $user_id = (int) $user_id;
- $thread_id = (int) $thread_id;
- $table_threads_qualify_log = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY_LOG);
- $course_id = api_get_course_int_id();
- if ($opt == 'false') {
- $sql = "SELECT * FROM $table_threads_qualify_log
- WHERE
- c_id = $course_id AND
- thread_id='".$thread_id."' AND
- user_id='".$user_id."'
- ORDER BY qualify_time";
- } else {
- $sql = "SELECT * FROM $table_threads_qualify_log
- WHERE
- c_id = $course_id AND
- thread_id='".$thread_id."' AND
- user_id='".$user_id."'
- ORDER BY qualify_time DESC";
- }
- $rs = Database::query($sql);
- $log = [];
- while ($row = Database::fetch_array($rs, 'ASSOC')) {
- $log[] = $row;
- }
- return $log;
- }
- /**
- * This function stores qualify historical.
- *
- * @param bool contains the information of option to run
- * @param string contains the information the current course id
- * @param int contains the information the current forum id
- * @param int contains the information the current user id
- * @param int contains the information the current thread id
- * @param int contains the information the current qualify
- * @param string $option
- * @param int $course_id
- * @param int $user_id
- * @param int $thread_id
- *
- * @author Isaac Flores <isaac.flores@dokeos.com>, U.N.A.S University
- *
- * @version October 2008, dokeos 1.8.6
- */
- function saveThreadScoreHistory(
- $option,
- $course_id,
- $user_id,
- $thread_id
- ) {
- $table_threads_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $table_threads_qualify_log = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY_LOG);
- $course_id = intval($course_id);
- $qualify_user_id = api_get_user_id();
- if ($user_id == strval(intval($user_id)) &&
- $thread_id == strval(intval($thread_id)) && $option == 1
- ) {
- // Extract information of thread_qualify.
- $sql = "SELECT qualify, qualify_time
- FROM $table_threads_qualify
- WHERE
- c_id = $course_id AND
- user_id = ".$user_id." AND
- thread_id = ".$thread_id." AND
- qualify_user_id = $qualify_user_id
- ";
- $rs = Database::query($sql);
- $row = Database::fetch_array($rs);
- // Insert thread_historical.
- $sql = "INSERT INTO $table_threads_qualify_log (c_id, user_id, thread_id, qualify, qualify_user_id,qualify_time,session_id)
- VALUES(".$course_id.", '".$user_id."','".$thread_id."',".(float) $row[0].", '".$qualify_user_id."','".$row[1]."','')";
- Database::query($sql);
- $insertId = Database::insert_id();
- if ($insertId) {
- $sql = "UPDATE $table_threads_qualify_log SET id = iid
- WHERE iid = $insertId";
- Database::query($sql);
- }
- }
- }
- /**
- * This function shows current thread qualify .
- *
- * @param int $threadId
- * @param int $sessionId
- * @param int $userId
- *
- * @return array or null if is empty
- *
- * @author Isaac Flores <isaac.flores@dokeos.com>, U.N.A.S University
- *
- * @version December 2008, dokeos 1.8.6
- */
- function current_qualify_of_thread($threadId, $sessionId, $userId)
- {
- $table_threads_qualify = Database::get_course_table(TABLE_FORUM_THREAD_QUALIFY);
- $course_id = api_get_course_int_id();
- $currentUserId = api_get_user_id();
- $sessionId = intval($sessionId);
- $threadId = intval($threadId);
- $sql = "SELECT qualify FROM $table_threads_qualify
- WHERE
- c_id = $course_id AND
- thread_id = $threadId AND
- session_id = $sessionId AND
- qualify_user_id = $currentUserId AND
- user_id = $userId
- ";
- $res = Database::query($sql);
- $row = Database::fetch_array($res, 'ASSOC');
- return $row['qualify'];
- }
- /**
- * This function stores a reply in the forum_post table.
- * It also updates the forum_threads table (thread_replies +1 , thread_last_post, thread_date).
- *
- * @param array $current_forum
- * @param array $values
- * @param int $courseId Optional
- * @param int $userId Optional
- *
- * @return int post id
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_reply($current_forum, $values, $courseId = 0, $userId = 0)
- {
- $courseId = !empty($courseId) ? $courseId : api_get_course_int_id();
- $_course = api_get_course_info_by_id($courseId);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $post_date = api_get_utc_datetime();
- $userId = $userId ?: api_get_user_id();
- if ($current_forum['allow_anonymous'] == 1) {
- if (api_is_anonymous() && empty($userId)) {
- $userId = api_get_anonymous_id();
- }
- }
- if (empty($userId)) {
- return false;
- }
- $visible = 1;
- if ($current_forum['approval_direct_post'] == '1' &&
- !api_is_allowed_to_edit(null, true)
- ) {
- $visible = 0;
- }
- $upload_ok = 1;
- $new_post_id = 0;
- if ($upload_ok) {
- // We first store an entry in the forum_post table.
- $new_post_id = Database::insert(
- $table_posts,
- [
- 'c_id' => $courseId,
- 'post_title' => $values['post_title'],
- 'post_text' => isset($values['post_text']) ? ($values['post_text']) : null,
- 'thread_id' => $values['thread_id'],
- 'forum_id' => $values['forum_id'],
- 'poster_id' => $userId,
- 'post_id' => 0,
- 'post_date' => $post_date,
- 'post_notification' => isset($values['post_notification']) ? $values['post_notification'] : null,
- 'post_parent_id' => isset($values['post_parent_id']) ? $values['post_parent_id'] : null,
- 'visible' => $visible,
- ]
- );
- if ($new_post_id) {
- $sql = "UPDATE $table_posts SET post_id = iid WHERE iid = $new_post_id";
- Database::query($sql);
- $values['new_post_id'] = $new_post_id;
- $message = get_lang('The reply has been added');
- if (!empty($_POST['file_ids']) && is_array($_POST['file_ids'])) {
- foreach ($_POST['file_ids'] as $key => $id) {
- editAttachedFile(
- [
- 'comment' => $_POST['file_comments'][$key],
- 'post_id' => $new_post_id,
- ],
- $id
- );
- }
- }
- // Update the thread.
- updateThreadInfo($values['thread_id'], $new_post_id, $post_date);
- // Update the forum.
- api_item_property_update(
- $_course,
- TOOL_FORUM,
- $values['forum_id'],
- 'NewMessageInForum',
- $userId
- );
- // Insert post
- api_item_property_update(
- $_course,
- TOOL_FORUM_POST,
- $new_post_id,
- 'NewPost',
- $userId
- );
- if ($current_forum['approval_direct_post'] == '1' &&
- !api_is_allowed_to_edit(null, true)
- ) {
- $message .= '<br />'.get_lang('Your message has to be approved before people can view it.').'<br />';
- }
- if ($current_forum['moderated'] &&
- !api_is_allowed_to_edit(null, true)
- ) {
- $message .= '<br />'.get_lang('Your message has to be approved before people can view it.').'<br />';
- }
- // Setting the notification correctly.
- $my_post_notification = isset($values['post_notification']) ? $values['post_notification'] : null;
- if ($my_post_notification == 1) {
- set_notification('thread', $values['thread_id'], true);
- }
- send_notification_mails(
- $values['forum_id'],
- $values['thread_id'],
- $values
- );
- add_forum_attachment_file('', $new_post_id);
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $values['forum_id'],
- 'tool_id_detail' => $values['thread_id'],
- 'action' => 'new-post',
- 'action_details' => $values['action'],
- 'info' => $values['post_title'],
- ];
- Event::registerLog($logInfo);
- }
- Session::erase('formelements');
- Session::erase('origin');
- Session::erase('breadcrumbs');
- Session::erase('addedresource');
- Session::erase('addedresourceid');
- Display::addFlash(Display::return_message($message, 'confirmation', false));
- } else {
- Display::addFlash(
- Display::return_message(
- get_lang('No file was uploaded.').' '.get_lang('Please select a file before pressing the upload button.'),
- 'error'
- )
- );
- }
- return $new_post_id;
- }
- /**
- * This function displays the form that is used to edit a post. This can be a new thread or a reply.
- *
- * @param array contains all the information about the current post
- * @param array contains all the information about the current thread
- * @param array contains all info about the current forum (to check if attachments are allowed)
- * @param array contains the default values to fill the form
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function show_edit_post_form(
- $current_post,
- $current_thread,
- $current_forum,
- $form_values = '',
- $id_attach = 0
- ) {
- // Initialize the object.
- $form = new FormValidator(
- 'edit_post',
- 'post',
- api_get_self().'?'.api_get_cidreq().'&forum='.intval($_GET['forum']).'&thread='.intval($_GET['thread']).'&post='.intval($_GET['post'])
- );
- $form->addElement('header', get_lang('Edit a post'));
- // Setting the form elements.
- $form->addElement('hidden', 'post_id', $current_post['post_id']);
- $form->addElement('hidden', 'thread_id', $current_thread['thread_id']);
- $form->addElement('hidden', 'id_attach', $id_attach);
- if (empty($current_post['post_parent_id'])) {
- $form->addElement('hidden', 'is_first_post_of_thread', '1');
- }
- $form->addElement('text', 'post_title', get_lang('Title'));
- $form->applyFilter('post_title', 'html_filter');
- $form->addElement(
- 'html_editor',
- 'post_text',
- get_lang('Text'),
- null,
- api_is_allowed_to_edit(null, true) ? [
- 'ToolbarSet' => 'Forum',
- 'Width' => '100%',
- 'Height' => '400',
- ] : [
- 'ToolbarSet' => 'ForumStudent',
- 'Width' => '100%',
- 'Height' => '400',
- 'UserStatus' => 'student',
- ]
- );
- $form->addRule('post_text', get_lang('Required field'), 'required');
- $extraFields = new ExtraField('forum_post');
- $extraFields->addElements($form, $current_post['post_id']);
- $form->addButtonAdvancedSettings('advanced_params');
- $form->addElement('html', '<div id="advanced_params_options" style="display:none">');
- if ($current_forum['moderated'] && api_is_allowed_to_edit(null, true)) {
- $group = [];
- $group[] = $form->createElement(
- 'radio',
- 'status',
- null,
- get_lang('Validated'),
- 1
- );
- $group[] = $form->createElement(
- 'radio',
- 'status',
- null,
- get_lang('Waiting for moderation'),
- 2
- );
- $group[] = $form->createElement(
- 'radio',
- 'status',
- null,
- get_lang('Rejected'),
- 3
- );
- $form->addGroup($group, 'status', get_lang('Status'));
- }
- $defaults['status']['status'] = isset($current_post['status']) && !empty($current_post['status']) ? $current_post['status'] : 2;
- $form->addElement(
- 'checkbox',
- 'post_notification',
- '',
- get_lang('Notify me by e-mail when somebody replies').' ('.$current_post['email'].')'
- );
- if (api_is_allowed_to_edit(null, true) &&
- empty($current_post['post_parent_id'])
- ) {
- // The sticky checkbox only appears when it is the first post of a thread.
- $form->addElement('checkbox', 'thread_sticky', '', get_lang('This is a sticky message (appears always on top and has a special sticky icon)'));
- if ($current_thread['thread_sticky'] == 1) {
- $defaults['thread_sticky'] = true;
- }
- }
- $form->addElement('html', '</div>');
- $form->addFile('user_upload[]', get_lang('Attachment'));
- $form->addButton(
- 'add_attachment',
- get_lang('Add attachment'),
- 'paperclip',
- 'default',
- 'default',
- null,
- ['id' => 'reply-add-attachment']
- );
- $form->addButtonUpdate(get_lang('Edit'), 'SubmitPost');
- // Setting the default values for the form elements.
- $defaults['post_title'] = $current_post['post_title'];
- $defaults['post_text'] = $current_post['post_text'];
- if ($current_post['post_notification'] == 1) {
- $defaults['post_notification'] = true;
- }
- if (!empty($form_values)) {
- $defaults['post_notification'] = Security::remove_XSS($form_values['post_notification']);
- $defaults['thread_sticky'] = Security::remove_XSS($form_values['thread_sticky']);
- }
- $form->setDefaults($defaults);
- // The course admin can make a thread sticky (=appears with special icon and always on top).
- $form->addRule('post_title', get_lang('Required field'), 'required');
- // Validation or display
- if ($form->validate()) {
- $values = $form->exportValues();
- $values['item_id'] = $current_post['post_id'];
- $extraFieldValues = new ExtraFieldValue('forum_post');
- $extraFieldValues->saveFieldValues($values);
- store_edit_post($current_forum, $values);
- } else {
- // Delete from $_SESSION forum attachment from other posts
- clearAttachedFiles($current_post['post_id']);
- // Get forum attachment ajax table to add it to form
- $fileData = getAttachmentsAjaxTable($current_post['post_id'], $current_forum['forum_id']);
- $form->addElement('html', $fileData);
- $form->display();
- }
- }
- /**
- * This function stores the edit of a post in the forum_post table.
- *
- * @param array
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_edit_post($forumInfo, $values)
- {
- $logInfo = [
- 'tool' => TOOL_FORUM,
- 'tool_id' => $_GET['forum'],
- 'tool_id_detail' => $values['thread_id'],
- 'action' => 'edit-post',
- 'action_details' => 'post',
- 'info' => $values['post_title'],
- ];
- Event::registerLog($logInfo);
- $threadTable = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- //check if this post is the first of the thread
- // First we check if the change affects the thread and if so we commit
- // the changes (sticky and post_title=thread_title are relevant).
- $posts = getPosts($forumInfo, $values['thread_id']);
- $first_post = null;
- if (!empty($posts) && count($posts) > 0 && isset($posts[0])) {
- $first_post = $posts[0];
- }
- if (!empty($first_post) && $first_post['post_id'] == $values['post_id']) {
- // Simple edit
- $params = [
- 'thread_title' => $values['post_title'],
- 'thread_sticky' => isset($values['thread_sticky']) ? $values['thread_sticky'] : 0,
- ];
- $where = ['c_id = ? AND thread_id = ?' => [$course_id, $values['thread_id']]];
- Database::update($threadTable, $params, $where);
- }
- $status = '';
- $updateStatus = false;
- if ($forumInfo['moderated']) {
- if (api_is_allowed_to_edit(null, true)) {
- $status = $values['status']['status'];
- $updateStatus = true;
- } else {
- $status = CForumPost::STATUS_WAITING_MODERATION;
- $updateStatus = true;
- }
- }
- // Update the post_title and the post_text.
- $params = [
- 'post_title' => $values['post_title'],
- 'post_text' => $values['post_text'],
- 'post_notification' => isset($values['post_notification']) ? $values['post_notification'] : '',
- ];
- if ($updateStatus) {
- $params['status'] = $status;
- }
- $where = ['c_id = ? AND post_id = ?' => [$course_id, $values['post_id']]];
- Database::update($table_posts, $params, $where);
- // Update attached files
- if (!empty($_POST['file_ids']) && is_array($_POST['file_ids'])) {
- foreach ($_POST['file_ids'] as $key => $id) {
- editAttachedFile(
- [
- 'comment' => $_POST['file_comments'][$key],
- 'post_id' => $values['post_id'],
- ],
- $id
- );
- }
- }
- if (!empty($values['remove_attach'])) {
- delete_attachment($values['post_id']);
- }
- if (empty($values['id_attach'])) {
- add_forum_attachment_file(
- isset($values['file_comment']) ? $values['file_comment'] : null,
- $values['post_id']
- );
- } else {
- edit_forum_attachment_file(
- isset($values['file_comment']) ? $values['file_comment'] : null,
- $values['post_id'],
- $values['id_attach']
- );
- }
- $message = get_lang('The post has been modified').'<br />';
- $message .= get_lang('You can now return to the').' <a href="viewforum.php?'.api_get_cidreq().'&forum='.intval($_GET['forum']).'&">'.get_lang('Forum').'</a><br />';
- $message .= get_lang('You can now return to the').' <a href="viewthread.php?'.api_get_cidreq().'&forum='.intval($_GET['forum']).'&thread='.$values['thread_id'].'&post='.Security::remove_XSS($_GET['post']).'">'.get_lang('Message').'</a>';
- Session::erase('formelements');
- Session::erase('origin');
- Session::erase('breadcrumbs');
- Session::erase('addedresource');
- Session::erase('addedresourceid');
- echo Display::return_message($message, 'confirmation', false);
- }
- /**
- * This function displays the firstname and lastname of the user as a link to the user tool.
- *
- * @param string names
- * @ in_title : title tootip
- *
- * @return string HTML
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function display_user_link($user_id, $name, $origin = '', $in_title = '')
- {
- if ($user_id != 0) {
- $userInfo = api_get_user_info($user_id);
- return '<a href="'.$userInfo['profile_url'].'">'.Security::remove_XSS($userInfo['complete_name']).'</a>';
- } else {
- return $name.' ('.get_lang('Anonymous').')';
- }
- }
- /**
- * This function displays the user image from the profile, with a link to the user's details.
- *
- * @param int User's database ID
- * @param string User's name
- * @param string the origin where the forum is called (example : learnpath)
- *
- * @return string An HTML with the anchor and the image of the user
- *
- * @author Julio Montoya <gugli100@gmail.com>
- */
- function display_user_image($user_id, $name, $origin = '')
- {
- $userInfo = api_get_user_info($user_id);
- $link = '<a href="'.(!empty($origin) ? '#' : $userInfo['profile_url']).'" '.(!empty($origin) ? 'target="_self"' : '').'>';
- if ($user_id != 0) {
- return $link.'<img src="'.$userInfo['avatar'].'" alt="'.$name.'" title="'.$name.'" /></a>';
- } else {
- return $link.Display::return_icon('unknown.jpg', $name).'</a>';
- }
- }
- /**
- * The thread view counter gets increased every time someone looks at the thread.
- *
- * @param int
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function increase_thread_view($thread_id)
- {
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $sql = "UPDATE $table_threads
- SET thread_views = thread_views + 1
- WHERE
- c_id = $course_id AND
- thread_id = '".intval($thread_id)."'";
- Database::query($sql);
- }
- /**
- * The relies counter gets increased every time somebody replies to the thread.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- *
- * @param int $threadId
- * @param string $lastPostId
- * @param string $post_date
- */
- function updateThreadInfo($threadId, $lastPostId, $post_date)
- {
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $sql = "UPDATE $table_threads SET
- thread_replies = thread_replies+1,
- thread_last_post = '".Database::escape_string($lastPostId)."',
- thread_date = '".Database::escape_string($post_date)."'
- WHERE
- c_id = $course_id AND
- thread_id='".Database::escape_string($threadId)."'"; // this needs to be cleaned first
- Database::query($sql);
- }
- /**
- * This function is used to find all the information about what's new in the forum tool.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_whats_new()
- {
- $userId = api_get_user_id();
- $course_id = api_get_course_int_id();
- if (empty($course_id) || empty($userId)) {
- return false;
- }
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $tracking_last_tool_access = Database::get_main_table(TABLE_STATISTIC_TRACK_E_LASTACCESS);
- $tool = TOOL_FORUM;
- $lastForumAccess = Session::read('last_forum_access');
- if (!$lastForumAccess) {
- $sql = "SELECT * FROM $tracking_last_tool_access
- WHERE
- access_user_id = $userId AND
- c_id = $course_id AND
- access_tool = '".Database::escape_string($tool)."'";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- Session::write('last_forum_access', $row['access_date']);
- $lastForumAccess = $row['access_date'];
- }
- $whatsNew = Session::read('whatsnew_post_info');
- if (!$whatsNew) {
- if ($lastForumAccess != '') {
- $postInfo = [];
- $sql = "SELECT * FROM $table_posts
- WHERE
- c_id = $course_id AND
- visible = 1 AND
- post_date > '".Database::escape_string($lastForumAccess)."'";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- $postInfo[$row['forum_id']][$row['thread_id']][$row['post_id']] = $row['post_date'];
- }
- Session::write('whatsnew_post_info', $postInfo);
- }
- }
- }
- /**
- * This function approves a post = change.
- *
- * @param int $post_id the id of the post that will be deleted
- * @param string $action make the post visible or invisible
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function approve_post($post_id, $action)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- if ($action == 'invisible') {
- $visibility_value = 0;
- }
- if ($action == 'visible') {
- $visibility_value = 1;
- handle_mail_cue('post', $post_id);
- }
- $sql = "UPDATE $table_posts SET
- visible='".Database::escape_string($visibility_value)."'
- WHERE c_id = $course_id AND post_id='".Database::escape_string($post_id)."'";
- $return = Database::query($sql);
- if ($return) {
- return 'PostThe visibility has been changed.';
- }
- }
- /**
- * This function retrieves all the unapproved messages for a given forum
- * This is needed to display the icon that there are unapproved messages in that thread (only the courseadmin can see this).
- *
- * @param $forum_id the forum where we want to know the unapproved messages of
- *
- * @return array returns
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function get_unaproved_messages($forum_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- $return_array = [];
- $sql = "SELECT DISTINCT thread_id FROM $table_posts
- WHERE
- c_id = $course_id AND
- forum_id='".Database::escape_string($forum_id)."' AND
- visible='0' ";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- $return_array[] = $row['thread_id'];
- }
- return $return_array;
- }
- /**
- * This function sends the notification mails to everybody who stated that they wanted to be informed when a new post
- * was added to a given thread.
- *
- * @param array reply information
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function send_notification_mails($forumId, $thread_id, $reply_info)
- {
- $table = Database::get_course_table(TABLE_FORUM_MAIL_QUEUE);
- // First we need to check if
- // 1. the forum category is visible
- // 2. the forum is visible
- // 3. the thread is visible
- // 4. the reply is visible (=when there is)
- $current_thread = get_thread_information($forumId, $thread_id);
- $current_forum = get_forum_information($current_thread['forum_id'], $current_thread['c_id']);
- $current_forum_category = null;
- if (isset($current_forum['forum_category'])) {
- $current_forum_category = get_forumcategory_information($current_forum['forum_category']);
- }
- $send_mails = false;
- if ($current_thread['visibility'] == '1' &&
- $current_forum['visibility'] == '1' &&
- ($current_forum_category && $current_forum_category['visibility'] == '1') &&
- $current_forum['approval_direct_post'] != '1'
- ) {
- $send_mails = true;
- }
- // The forum category, the forum, the thread and the reply are visible to the user
- if ($send_mails && !empty($forumId)) {
- $postId = isset($reply_info['new_post_id']) ? $reply_info['new_post_id'] : 0;
- send_notifications($forumId, $thread_id, $postId);
- } else {
- $table_notification = Database::get_course_table(TABLE_FORUM_NOTIFICATION);
- if (isset($current_forum['forum_id'])) {
- $sql = "SELECT * FROM $table_notification
- WHERE
- c_id = ".api_get_course_int_id()." AND
- (
- forum_id = '".intval($current_forum['forum_id'])."' OR
- thread_id = '".intval($thread_id)."'
- ) ";
- $result = Database::query($sql);
- $user_id = api_get_user_id();
- while ($row = Database::fetch_array($result)) {
- $sql = "INSERT INTO $table (c_id, thread_id, post_id, user_id)
- VALUES (".api_get_course_int_id().", '".intval($thread_id)."', '".intval($reply_info['new_post_id'])."', '$user_id' )";
- Database::query($sql);
- }
- }
- }
- }
- /**
- * This function is called whenever something is made visible because there might
- * be new posts and the user might have indicated that (s)he wanted to be
- * informed about the new posts by mail.
- *
- * @param string $content Content type (post, thread, forum, forum_category)
- * @param int $id Item DB ID of the corresponding content type
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function handle_mail_cue($content, $id)
- {
- $table_mailcue = Database::get_course_table(TABLE_FORUM_MAIL_QUEUE);
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $course_id = api_get_course_int_id();
- $id = (int) $id;
- /* If the post is made visible we only have to send mails to the people
- who indicated that they wanted to be informed for that thread.*/
- if ($content == 'post') {
- // Getting the information about the post (need the thread_id).
- $post_info = get_post_information($id);
- $thread_id = (int) $post_info['thread_id'];
- // Sending the mail to all the users that wanted to be informed for replies on this thread.
- $sql = "SELECT users.firstname, users.lastname, users.user_id, users.email
- FROM $table_mailcue mailcue, $table_posts posts, $table_users users
- WHERE
- posts.c_id = $course_id AND
- mailcue.c_id = $course_id AND
- posts.thread_id = $thread_id AND
- posts.post_notification = '1' AND
- mailcue.thread_id = $thread_id AND
- users.user_id = posts.poster_id AND
- users.active = 1
- GROUP BY users.email";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- $forumInfo = get_forum_information($post_info['forum_id']);
- send_mail($row, $forumInfo, get_thread_information($post_info['forum_id'], $post_info['thread_id']), $post_info);
- }
- } elseif ($content == 'thread') {
- // Sending the mail to all the users that wanted to be informed for replies on this thread.
- $sql = "SELECT users.firstname, users.lastname, users.user_id, users.email, posts.forum_id
- FROM $table_mailcue mailcue, $table_posts posts, $table_users users
- WHERE
- posts.c_id = $course_id AND
- mailcue.c_id = $course_id AND
- posts.thread_id = $id AND
- posts.post_notification = '1' AND
- mailcue.thread_id = $id AND
- users.user_id = posts.poster_id AND
- users.active = 1
- GROUP BY users.email";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- $forumInfo = get_forum_information($row['forum_id']);
- send_mail($row, $forumInfo, get_thread_information($row['forum_id'], $id));
- }
- // Deleting the relevant entries from the mailcue.
- $sql = "DELETE FROM $table_mailcue
- WHERE c_id = $course_id AND thread_id = $id";
- Database::query($sql);
- } elseif ($content == 'forum') {
- $sql = "SELECT thread_id FROM $table_threads
- WHERE c_id = $course_id AND forum_id = $id";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- handle_mail_cue('thread', $row['thread_id']);
- }
- } elseif ($content == 'forum_category') {
- $sql = "SELECT forum_id FROM $table_forums
- WHERE c_id = $course_id AND forum_category = $id";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- handle_mail_cue('forum', $row['forum_id']);
- }
- } else {
- return get_lang('Error');
- }
- }
- /**
- * This function sends the mails for the mail notification.
- *
- * @param array
- * @param array
- * @param array
- * @param array
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function send_mail($userInfo, $forumInfo, $thread_information, $postInfo = [])
- {
- if (empty($userInfo) || empty($forumInfo) || empty($thread_information)) {
- return false;
- }
- $_course = api_get_course_info();
- $user_id = api_get_user_id();
- $thread_link = '';
- if (isset($thread_information) && is_array($thread_information)) {
- $thread_link = api_get_path(WEB_CODE_PATH).
- 'forum/viewthread.php?'.api_get_cidreq().'&forum='.$thread_information['forum_id'].'&thread='.$thread_information['thread_id'];
- }
- $email_body = get_lang('Dear').' '.api_get_person_name($userInfo['firstname'], $userInfo['lastname'], null, PERSON_NAME_EMAIL_ADDRESS).", <br />\n\r";
- $email_body .= get_lang('New Post in the forum').': '.$forumInfo['forum_title'].' - '.$thread_information['thread_title']." <br />\n";
- $courseId = api_get_configuration_value('global_forums_course_id');
- $subject = get_lang('New Post in the forum').' - '.$_course['official_code'].': '.$forumInfo['forum_title'].' - '.$thread_information['thread_title']." <br />\n";
- $courseInfoTitle = get_lang('Course').': '.$_course['name'].' - ['.$_course['official_code']."] - <br />\n";
- if (!empty($courseId) && $_course['real_id'] == $courseId) {
- $subject = get_lang('New Post in the forum').': '.$forumInfo['forum_title'].' - '.$thread_information['thread_title']." <br />\n";
- $courseInfoTitle = " <br />\n";
- }
- $email_body .= $courseInfoTitle;
- if (!empty($postInfo) && isset($postInfo['post_text'])) {
- $text = cut(strip_tags($postInfo['post_text']), 100);
- if (!empty($text)) {
- $email_body .= get_lang('Message').": <br />\n ";
- $email_body .= $text;
- $email_body .= "<br /><br />\n";
- }
- }
- $email_body .= get_lang('You stated that you wanted to be informed by e-mail whenever somebody replies on the thread')."<br />\n";
- if (!empty($thread_link)) {
- $email_body .= get_lang('The thread can be found here')." : <br /><a href=\"".$thread_link."\">".$thread_link."</a>\n";
- }
- if ($userInfo['user_id'] != $user_id) {
- MessageManager::send_message(
- $userInfo['user_id'],
- $subject,
- $email_body,
- [],
- [],
- null,
- null,
- null,
- null,
- $user_id
- );
- }
- }
- /**
- * This function displays the form for moving a thread to a different (already existing) forum.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function move_thread_form()
- {
- $form = new FormValidator(
- 'movepost',
- 'post',
- api_get_self().'?forum='.intval($_GET['forum']).'&thread='.intval($_GET['thread']).'&action='.Security::remove_XSS($_GET['action']).'&'.api_get_cidreq()
- );
- // The header for the form
- $form->addElement('header', get_lang('Move Thread'));
- // Invisible form: the thread_id
- $form->addElement('hidden', 'thread_id', intval($_GET['thread']));
- // the fora
- $forum_categories = get_forum_categories();
- $forums = get_forums();
- $htmlcontent = '<div class="row">
- <div class="label">
- <span class="form_required">*</span>'.get_lang('Move to').'
- </div>
- <div class="formw">';
- $htmlcontent .= '<select name="forum">';
- foreach ($forum_categories as $key => $category) {
- $htmlcontent .= '<optgroup label="'.$category['cat_title'].'">';
- foreach ($forums as $key => $forum) {
- if (isset($forum['forum_category'])) {
- if ($forum['forum_category'] == $category['cat_id']) {
- $htmlcontent .= '<option value="'.$forum['forum_id'].'">'.$forum['forum_title'].'</option>';
- }
- }
- }
- $htmlcontent .= '</optgroup>';
- }
- $htmlcontent .= "</select>";
- $htmlcontent .= ' </div>
- </div>';
- $form->addElement('html', $htmlcontent);
- // The OK button
- $form->addButtonSave(get_lang('Move Thread'), 'SubmitForum');
- // Validation or display
- if ($form->validate()) {
- $values = $form->exportValues();
- if (isset($_POST['forum'])) {
- store_move_thread($values);
- }
- } else {
- $form->display();
- }
- }
- /**
- * This function displays the form for moving a post message to a different (already existing) or a new thread.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function move_post_form()
- {
- $form = new FormValidator(
- 'movepost',
- 'post',
- api_get_self().'?'.api_get_cidreq().'&forum='.intval($_GET['forum']).'&thread='.intval($_GET['thread']).'&post='.Security::remove_XSS($_GET['post']).'&action='.Security::remove_XSS($_GET['action']).'&post='.Security::remove_XSS($_GET['post'])
- );
- // The header for the form
- $form->addElement('header', '', get_lang('Move post'));
- // Invisible form: the post_id
- $form->addElement('hidden', 'post_id', intval($_GET['post']));
- // Dropdown list: Threads of this forum
- $threads = get_threads($_GET['forum']);
- //my_print_r($threads);
- $threads_list[0] = get_lang('A new thread');
- foreach ($threads as $key => $value) {
- $threads_list[$value['thread_id']] = $value['thread_title'];
- }
- $form->addElement('select', 'thread', get_lang('Move toThread'), $threads_list);
- $form->applyFilter('thread', 'html_filter');
- // The OK button
- $form->addButtonSave(get_lang('Move post'), 'submit');
- // Setting the rules
- $form->addRule('thread', get_lang('Required field'), 'required');
- // Validation or display
- if ($form->validate()) {
- $values = $form->exportValues();
- store_move_post($values);
- } else {
- $form->display();
- }
- }
- /**
- * @param array
- *
- * @return string HTML language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_move_post($values)
- {
- $_course = api_get_course_info();
- $course_id = api_get_course_int_id();
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- if ($values['thread'] == '0') {
- $current_post = get_post_information($values['post_id']);
- // Storing a new thread.
- $params = [
- 'c_id' => $course_id,
- 'thread_title' => $current_post['post_title'],
- 'forum_id' => $current_post['forum_id'],
- 'thread_poster_id' => $current_post['poster_id'],
- 'thread_poster_name' => $current_post['poster_name'],
- 'thread_last_post' => $values['post_id'],
- 'thread_date' => $current_post['post_date'],
- ];
- $new_thread_id = Database::insert($table_threads, $params);
- api_item_property_update(
- $_course,
- TOOL_FORUM_THREAD,
- $new_thread_id,
- 'visible',
- $current_post['poster_id']
- );
- // Moving the post to the newly created thread.
- $sql = "UPDATE $table_posts SET thread_id='".intval($new_thread_id)."', post_parent_id = NULL
- WHERE c_id = $course_id AND post_id='".intval($values['post_id'])."'";
- Database::query($sql);
- // Resetting the parent_id of the thread to 0 for all those who had this moved post as parent.
- $sql = "UPDATE $table_posts SET post_parent_id = NULL
- WHERE c_id = $course_id AND post_parent_id='".intval($values['post_id'])."'";
- Database::query($sql);
- // Updating updating the number of threads in the forum.
- $sql = "UPDATE $table_forums SET forum_threads=forum_threads+1
- WHERE c_id = $course_id AND forum_id='".intval($current_post['forum_id'])."'";
- Database::query($sql);
- // Resetting the last post of the old thread and decreasing the number of replies and the thread.
- $sql = "SELECT * FROM $table_posts
- WHERE c_id = $course_id AND thread_id='".intval($current_post['thread_id'])."'
- ORDER BY post_id DESC";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $sql = "UPDATE $table_threads SET
- thread_last_post='".$row['post_id']."',
- thread_replies=thread_replies-1
- WHERE
- c_id = $course_id AND
- thread_id='".intval($current_post['thread_id'])."'";
- Database::query($sql);
- } else {
- // Moving to the chosen thread.
- $sql = "SELECT thread_id FROM ".$table_posts."
- WHERE c_id = $course_id AND post_id = '".$values['post_id']."' ";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $original_thread_id = $row['thread_id'];
- $sql = "SELECT thread_last_post FROM ".$table_threads."
- WHERE c_id = $course_id AND thread_id = '".$original_thread_id."' ";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $thread_is_last_post = $row['thread_last_post'];
- // If is this thread, update the thread_last_post with the last one.
- if ($thread_is_last_post == $values['post_id']) {
- $sql = "SELECT post_id FROM ".$table_posts."
- WHERE c_id = $course_id AND thread_id = '".$original_thread_id."' AND post_id <> '".$values['post_id']."'
- ORDER BY post_date DESC LIMIT 1";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- $thread_new_last_post = $row['post_id'];
- $sql = "UPDATE ".$table_threads." SET thread_last_post = '".$thread_new_last_post."'
- WHERE c_id = $course_id AND thread_id = '".$original_thread_id."' ";
- Database::query($sql);
- }
- $sql = "UPDATE $table_threads SET thread_replies=thread_replies-1
- WHERE c_id = $course_id AND thread_id='".$original_thread_id."'";
- Database::query($sql);
- // moving to the chosen thread
- $sql = "UPDATE $table_posts SET thread_id='".intval($_POST['thread'])."', post_parent_id = NULL
- WHERE c_id = $course_id AND post_id='".intval($values['post_id'])."'";
- Database::query($sql);
- // resetting the parent_id of the thread to 0 for all those who had this moved post as parent
- $sql = "UPDATE $table_posts SET post_parent_id = NULL
- WHERE c_id = $course_id AND post_parent_id='".intval($values['post_id'])."'";
- Database::query($sql);
- $sql = "UPDATE $table_threads SET thread_replies=thread_replies+1
- WHERE c_id = $course_id AND thread_id='".intval($_POST['thread'])."'";
- Database::query($sql);
- }
- return get_lang('Thread moved');
- }
- /**
- * @param array
- *
- * @return string HTML language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- *
- * @version february 2006, dokeos 1.8
- */
- function store_move_thread($values)
- {
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $courseId = api_get_course_int_id();
- $sessionId = api_get_session_id();
- $forumId = intval($_POST['forum']);
- $threadId = intval($_POST['thread_id']);
- $forumInfo = get_forums($forumId);
- // Change the thread table: Setting the forum_id to the new forum.
- $sql = "UPDATE $table_threads SET forum_id = $forumId
- WHERE c_id = $courseId AND thread_id = $threadId";
- Database::query($sql);
- // Changing all the posts of the thread: setting the forum_id to the new forum.
- $sql = "UPDATE $table_posts SET forum_id = $forumId
- WHERE c_id = $courseId AND thread_id= $threadId";
- Database::query($sql);
- // Fix group id, if forum is moved to a different group
- if (!empty($forumInfo['to_group_id'])) {
- $groupId = $forumInfo['to_group_id'];
- $item = api_get_item_property_info(
- $courseId,
- TABLE_FORUM_THREAD,
- $threadId,
- $sessionId,
- $groupId
- );
- $table = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $sessionCondition = api_get_session_condition($sessionId);
- if (!empty($item)) {
- if ($item['to_group_id'] != $groupId) {
- $sql = "UPDATE $table
- SET to_group_id = $groupId
- WHERE
- tool = '".TABLE_FORUM_THREAD."' AND
- c_id = $courseId AND
- ref = ".$item['ref']."
- $sessionCondition
- ";
- Database::query($sql);
- }
- } else {
- $sql = "UPDATE $table
- SET to_group_id = $groupId
- WHERE
- tool = '".TABLE_FORUM_THREAD."' AND
- c_id = $courseId AND
- ref = ".$threadId."
- $sessionCondition
- ";
- Database::query($sql);
- }
- }
- return get_lang('Thread moved');
- }
- /**
- * Prepares a string for displaying by highlighting the search results inside, if any.
- *
- * @param string $input the input string
- *
- * @return string the same string with highlighted hits inside
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, February 2006 - the initial version.
- * @author Ivan Tcholakov, March 2011 - adaptation for Chamilo LMS.
- */
- function prepare4display($input)
- {
- static $highlightcolors = ['yellow', '#33CC33', '#3399CC', '#9999FF', '#33CC33'];
- static $search;
- if (!isset($search)) {
- if (isset($_POST['search_term'])) {
- $search = $_POST['search_term']; // No html at all.
- } elseif (isset($_GET['search'])) {
- $search = $_GET['search'];
- } else {
- $search = '';
- }
- }
- if (!empty($search)) {
- if (strstr($search, '+')) {
- $search_terms = explode('+', $search);
- } else {
- $search_terms[] = trim($search);
- }
- $counter = 0;
- foreach ($search_terms as $key => $search_term) {
- $input = api_preg_replace(
- '/'.preg_quote(trim($search_term), '/').'/i',
- '<span style="background-color: '.$highlightcolors[$counter].'">$0</span>',
- $input
- );
- $counter++;
- }
- }
- // TODO: Security should be implemented outside this function.
- // Change this to COURSEMANAGERLOWSECURITY or COURSEMANAGER to lower filtering and allow more styles
- // (see comments of Security::remove_XSS() method to learn about other levels).
- return Security::remove_XSS($input, STUDENT, true);
- }
- /**
- * Display the search form for the forum and display the search results.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- *
- * @version march 2008, dokeos 1.8.5
- */
- function forum_search()
- {
- $form = new FormValidator(
- 'forumsearch',
- 'post',
- 'forumsearch.php?'.api_get_cidreq()
- );
- // Setting the form elements.
- $form->addElement('header', '', get_lang('Search in the Forum'));
- $form->addElement('text', 'search_term', get_lang('Search term'), ['autofocus']);
- $form->applyFilter('search_term', 'html_filter');
- $form->addElement('static', 'search_information', '', get_lang('Search in the ForumInformation'));
- $form->addButtonSearch(get_lang('Search'));
- // Setting the rules.
- $form->addRule('search_term', get_lang('Required field'), 'required');
- $form->addRule('search_term', get_lang('Too short'), 'minlength', 3);
- // Validation or display.
- if ($form->validate()) {
- $values = $form->exportValues();
- $form->setDefaults($values);
- $form->display();
- // Display the search results.
- display_forum_search_results(stripslashes($values['search_term']));
- } else {
- $form->display();
- }
- }
- /**
- * Display the search results.
- *
- * @param string
- * @param string $search_term
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- *
- * @version march 2008, dokeos 1.8.5
- */
- function display_forum_search_results($search_term)
- {
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $session_id = api_get_session_id();
- $course_id = api_get_course_int_id();
- // Defining the search strings as an array.
- if (strstr($search_term, '+')) {
- $search_terms = explode('+', $search_term);
- } else {
- $search_terms[] = $search_term;
- }
- // Search restriction.
- foreach ($search_terms as $value) {
- $search_restriction[] = "
- (
- posts.post_title LIKE '%".Database::escape_string(trim($value))."%' OR
- posts.post_text LIKE '%".Database::escape_string(trim($value))."%'
- )";
- }
- $sessionCondition = api_get_session_condition(
- $session_id,
- true,
- false,
- 'item_property.session_id'
- );
- $sql = "SELECT posts.*
- FROM $table_posts posts
- INNER JOIN $table_threads threads
- ON (posts.thread_id = threads.thread_id AND posts.c_id = threads.c_id)
- INNER JOIN $table_item_property item_property
- ON (item_property.ref = threads.thread_id AND item_property.c_id = threads.c_id)
- WHERE
- posts.c_id = $course_id AND
- item_property.c_id = $course_id AND
- item_property.visibility = 1
- $sessionCondition AND
- posts.visible = 1 AND
- item_property.tool = '".TOOL_FORUM_THREAD."' AND
- ".implode(' AND ', $search_restriction)."
- GROUP BY posts.post_id";
- // Getting all the information of the forum categories.
- $forum_categories_list = get_forum_categories();
- // Getting all the information of the forums.
- $forum_list = get_forums();
- $result = Database::query($sql);
- $search_results = [];
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- $forumId = $row['forum_id'];
- $forumData = get_forums($forumId);
- $category = isset($forum_categories_list[$forumData['forum_category']]) ? $forum_categories_list[$forumData['forum_category']] : null;
- $display_result = false;
- /*
- We only show it when
- 1. forum category is visible
- 2. forum is visible
- 3. thread is visible (to do)
- 4. post is visible
- */
- if (!api_is_allowed_to_edit(null, true)) {
- if (!empty($category)) {
- if ($category['visibility'] == '1' && $forumData['visibility'] == '1') {
- $display_result = true;
- }
- } else {
- if ($forumData['visible'] == '1') {
- $display_result = true;
- }
- }
- } else {
- $display_result = true;
- }
- if ($display_result) {
- $categoryName = !empty($category) ? $category['cat_title'] : '';
- $search_results_item = '<li><a href="viewforumcategory.php?'.api_get_cidreq().'&forumcategory='.$forumData['forum_category'].'&search='.urlencode($search_term).'">'.
- prepare4display($categoryName).'</a> > ';
- $search_results_item .= '<a href="viewforum.php?'.api_get_cidreq().'&forum='.$forumId.'&search='.urlencode($search_term).'">'.
- prepare4display($forum_list[$row['forum_id']]['forum_title']).'</a> > ';
- $search_results_item .= '<a href="viewthread.php?'.api_get_cidreq().'&forum='.$forumId.'&thread='.$row['thread_id'].'&search='.urlencode($search_term).'">'.
- prepare4display($row['post_title']).'</a>';
- $search_results_item .= '<br />';
- if (api_strlen($row['post_title']) > 200) {
- $search_results_item .= prepare4display(api_substr(strip_tags($row['post_title']), 0, 200)).'...';
- } else {
- $search_results_item .= prepare4display($row['post_title']);
- }
- $search_results_item .= '</li>';
- $search_results[] = $search_results_item;
- }
- }
- echo '<legend>'.count($search_results).' '.get_lang('Search in the ForumResults').'</legend>';
- echo '<ol>';
- if ($search_results) {
- echo implode($search_results);
- }
- echo '</ol>';
- }
- /**
- * Return the link to the forum search page.
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- *
- * @version April 2008, dokeos 1.8.5
- */
- function search_link()
- {
- $return = '';
- $origin = api_get_origin();
- if ($origin != 'learnpath') {
- $return = '<a href="forumsearch.php?'.api_get_cidreq().'&action=search"> ';
- $return .= Display::return_icon('search.png', get_lang('Search'), '', ICON_SIZE_MEDIUM).'</a>';
- if (!empty($_GET['search'])) {
- $return .= ': '.Security::remove_XSS($_GET['search']).' ';
- $url = api_get_self().'?';
- $url_parameter = [];
- foreach ($_GET as $key => $value) {
- if ($key != 'search') {
- $url_parameter[] = Security::remove_XSS($key).'='.Security::remove_XSS($value);
- }
- }
- $url = $url.implode('&', $url_parameter);
- $return .= '<a href="'.$url.'">'.Display::return_icon('delete.gif', get_lang('Clean search results')).'</a>';
- }
- }
- return $return;
- }
- /**
- * This function adds an attachment file into a forum.
- *
- * @param string $file_comment a comment about file
- * @param int $last_id from forum_post table
- *
- * @return false|null
- */
- function add_forum_attachment_file($file_comment, $last_id)
- {
- $_course = api_get_course_info();
- $agenda_forum_attachment = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- if (empty($_FILES['user_upload'])) {
- return false;
- }
- $filesData = [];
- if (!is_array($_FILES['user_upload']['name'])) {
- $filesData[] = $_FILES['user_upload'];
- } else {
- $fileCount = count($_FILES['user_upload']['name']);
- $fileKeys = array_keys($_FILES['user_upload']);
- for ($i = 0; $i < $fileCount; $i++) {
- foreach ($fileKeys as $key) {
- $filesData[$i][$key] = $_FILES['user_upload'][$key][$i];
- }
- }
- }
- foreach ($filesData as $attachment) {
- if (empty($attachment['name'])) {
- continue;
- }
- $upload_ok = process_uploaded_file($attachment);
- if (!$upload_ok) {
- continue;
- }
- $course_dir = $_course['path'].'/upload/forum';
- $sys_course_path = api_get_path(SYS_COURSE_PATH);
- $updir = $sys_course_path.$course_dir;
- // Try to add an extension to the file if it hasn't one.
- $new_file_name = add_ext_on_mime(
- stripslashes($attachment['name']),
- $attachment['type']
- );
- // User's file name
- $file_name = $attachment['name'];
- if (!filter_extension($new_file_name)) {
- Display::addFlash(
- Display::return_message(
- get_lang('File upload failed: this file extension or file type is prohibited'),
- 'error'
- )
- );
- return;
- }
- $new_file_name = uniqid('');
- $new_path = $updir.'/'.$new_file_name;
- $result = @move_uploaded_file($attachment['tmp_name'], $new_path);
- $safe_file_comment = Database::escape_string($file_comment);
- $safe_file_name = Database::escape_string($file_name);
- $safe_new_file_name = Database::escape_string($new_file_name);
- $last_id = intval($last_id);
- // Storing the attachments if any.
- if (!$result) {
- return;
- }
- $last_id_file = Database::insert(
- $agenda_forum_attachment,
- [
- 'c_id' => api_get_course_int_id(),
- 'filename' => $safe_file_name,
- 'comment' => $safe_file_comment,
- 'path' => $safe_new_file_name,
- 'post_id' => $last_id,
- 'size' => intval($attachment['size']),
- ]
- );
- api_item_property_update(
- $_course,
- TOOL_FORUM_ATTACH,
- $last_id_file,
- 'ForumAttachmentAdded',
- api_get_user_id()
- );
- }
- }
- /**
- * This function edits an attachment file into a forum.
- *
- * @param string $file_comment a comment about file
- * @param int $post_id
- * @param int $id_attach attachment file Id
- */
- function edit_forum_attachment_file($file_comment, $post_id, $id_attach)
- {
- $_course = api_get_course_info();
- $table_forum_attachment = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $course_id = api_get_course_int_id();
- $filesData = [];
- if (!is_array($_FILES['user_upload']['name'])) {
- $filesData[] = $_FILES['user_upload'];
- } else {
- $fileCount = count($_FILES['user_upload']['name']);
- $fileKeys = array_keys($_FILES['user_upload']);
- for ($i = 0; $i < $fileCount; $i++) {
- foreach ($fileKeys as $key) {
- $filesData[$i][$key] = $_FILES['user_upload'][$key][$i];
- }
- }
- }
- foreach ($filesData as $attachment) {
- if (empty($attachment['name'])) {
- continue;
- }
- $upload_ok = process_uploaded_file($attachment);
- if (!$upload_ok) {
- continue;
- }
- $course_dir = $_course['path'].'/upload/forum';
- $sys_course_path = api_get_path(SYS_COURSE_PATH);
- $updir = $sys_course_path.$course_dir;
- // Try to add an extension to the file if it hasn't one.
- $new_file_name = add_ext_on_mime(stripslashes($attachment['name']), $attachment['type']);
- // User's file name
- $file_name = $attachment['name'];
- if (!filter_extension($new_file_name)) {
- Display::addFlash(
- Display::return_message(
- get_lang('File upload failed: this file extension or file type is prohibited'),
- 'error'
- )
- );
- } else {
- $new_file_name = uniqid('');
- $new_path = $updir.'/'.$new_file_name;
- $result = @move_uploaded_file($attachment['tmp_name'], $new_path);
- $safe_file_comment = Database::escape_string($file_comment);
- $safe_file_name = Database::escape_string($file_name);
- $safe_new_file_name = Database::escape_string($new_file_name);
- $safe_post_id = (int) $post_id;
- $safe_id_attach = (int) $id_attach;
- // Storing the attachments if any.
- if ($result) {
- $sql = "UPDATE $table_forum_attachment
- SET
- filename = '$safe_file_name',
- comment = '$safe_file_comment',
- path = '$safe_new_file_name',
- post_id = '$safe_post_id',
- size ='".$attachment['size']."'
- WHERE c_id = $course_id AND id = '$safe_id_attach'";
- Database::query($sql);
- api_item_property_update(
- $_course,
- TOOL_FORUM_ATTACH,
- $safe_id_attach,
- 'ForumAttachmentUpdated',
- api_get_user_id()
- );
- }
- }
- }
- }
- /**
- * Show a list with all the attachments according to the post's id.
- *
- * @param int $postId
- *
- * @return array with the post info
- *
- * @author Julio Montoya
- *
- * @version avril 2008, dokeos 1.8.5
- */
- function get_attachment($postId)
- {
- $table = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $course_id = api_get_course_int_id();
- $row = [];
- $postId = (int) $postId;
- if (empty($postId)) {
- return [];
- }
- $sql = "SELECT iid, path, filename, comment
- FROM $table
- WHERE c_id = $course_id AND post_id = $postId";
- $result = Database::query($sql);
- if (Database::num_rows($result) != 0) {
- $row = Database::fetch_array($result);
- }
- return $row;
- }
- /**
- * @param int $postId
- *
- * @return array
- */
- function getAllAttachment($postId)
- {
- $forumAttachmentTable = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $courseId = api_get_course_int_id();
- $postId = (int) $postId;
- if (empty($postId)) {
- return [];
- }
- $columns = ['iid', 'path', 'filename', 'comment'];
- $conditions = [
- 'where' => [
- 'c_id = ? AND post_id = ?' => [$courseId, $postId],
- ],
- ];
- $array = Database::select(
- $columns,
- $forumAttachmentTable,
- $conditions,
- 'all',
- 'ASSOC'
- );
- return $array;
- }
- /**
- * Delete the all the attachments from the DB and the file according to the post's id or attach id(optional).
- *
- * @param int $post_id
- * @param int $id_attach
- *
- * @return int
- *
- * @author Julio Montoya
- *
- * @version october 2014, chamilo 1.9.8
- */
- function delete_attachment($post_id, $id_attach = 0)
- {
- $_course = api_get_course_info();
- $forum_table_attachment = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $course_id = api_get_course_int_id();
- $cond = (!empty($id_attach)) ? " iid = ".(int) $id_attach."" : " post_id = ".(int) $post_id."";
- $sql = "SELECT path FROM $forum_table_attachment WHERE c_id = $course_id AND $cond";
- $res = Database::query($sql);
- $row = Database::fetch_array($res);
- $course_dir = $_course['path'].'/upload/forum';
- $sys_course_path = api_get_path(SYS_COURSE_PATH);
- $updir = $sys_course_path.$course_dir;
- $my_path = isset($row['path']) ? $row['path'] : null;
- $file = $updir.'/'.$my_path;
- if (Security::check_abs_path($file, $updir)) {
- @unlink($file);
- }
- // Delete from forum_attachment table.
- $sql = "DELETE FROM $forum_table_attachment
- WHERE c_id = $course_id AND $cond ";
- $result = Database::query($sql);
- if ($result !== false) {
- $affectedRows = Database::affected_rows($result);
- } else {
- $affectedRows = 0;
- }
- // Update item_property.
- api_item_property_update(
- $_course,
- TOOL_FORUM_ATTACH,
- $id_attach,
- 'ForumAttachmentDelete',
- api_get_user_id()
- );
- if (!empty($result) && !empty($id_attach)) {
- Display::addFlash(Display::return_message(get_lang('The attached file has been deleted'), 'confirmation'));
- }
- return $affectedRows;
- }
- /**
- * This function gets all the forum information of the all the forum of the group.
- *
- * @param array $groupInfo the id of the group we need the fora of (see forum.forum_of_group)
- *
- * @return array
- *
- * @todo this is basically the same code as the get_forums function. Consider merging the two.
- */
- function get_forums_of_group($groupInfo)
- {
- $table_forums = Database::get_course_table(TABLE_FORUM);
- $table_threads = Database::get_course_table(TABLE_FORUM_THREAD);
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $course_id = api_get_course_int_id();
- $groupId = (int) $groupInfo['id'];
- // Student
- // Select all the forum information of all forums (that are visible to students).
- $sql = "SELECT * FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (forum.forum_id = item_properties.ref AND item_properties.c_id = forum.c_id)
- WHERE
- forum.forum_of_group = $groupId AND
- forum.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.visibility = 1 AND
- item_properties.tool = '".TOOL_FORUM."'
- ORDER BY forum.forum_order ASC";
- // Select the number of threads of the forums (only the threads that are visible).
- $sql2 = "SELECT
- count(thread_id) AS number_of_threads,
- threads.forum_id
- FROM $table_threads threads
- INNER JOIN $table_item_property item_properties
- ON (threads.thread_id = item_properties.ref AND item_properties.c_id = threads.c_id)
- WHERE
- threads.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.visibility = 1 AND
- item_properties.tool='".TOOL_FORUM_THREAD."'
- GROUP BY threads.forum_id";
- // Select the number of posts of the forum (post that are visible and that are in a thread that is visible).
- $sql3 = "SELECT count(post_id) AS number_of_posts, posts.forum_id
- FROM $table_posts posts
- INNER JOIN $table_threads threads
- ON (posts.thread_id = threads.thread_id AND posts.c_id = threads.c_id)
- INNER JOIN $table_item_property item_properties
- ON (threads.thread_id = item_properties.ref AND item_properties.c_id = threads.c_id)
- WHERE
- posts.visible=1 AND
- posts.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- threads.c_id = $course_id AND
- item_properties.visibility = 1 AND
- item_properties.tool='".TOOL_FORUM_THREAD."'
- GROUP BY threads.forum_id";
- // Course Admin
- if (api_is_allowed_to_edit()) {
- // Select all the forum information of all forums (that are not deleted).
- $sql = "SELECT *
- FROM $table_forums forum
- INNER JOIN $table_item_property item_properties
- ON (forum.forum_id = item_properties.ref AND item_properties.c_id = forum.c_id)
- WHERE
- forum.forum_of_group = $groupId AND
- forum.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.visibility <> 2 AND
- item_properties.tool = '".TOOL_FORUM."'
- ORDER BY forum_order ASC";
- // Select the number of threads of the forums (only the threads that are not deleted).
- $sql2 = "SELECT count(thread_id) AS number_of_threads, threads.forum_id
- FROM $table_threads threads
- INNER JOIN $table_item_property item_properties
- ON (threads.thread_id=item_properties.ref AND item_properties.c_id = threads.c_id)
- WHERE
- threads.c_id = $course_id AND
- item_properties.c_id = $course_id AND
- item_properties.visibility <> 2 AND
- item_properties.tool='".TOOL_FORUM_THREAD."'
- GROUP BY threads.forum_id";
- // Select the number of posts of the forum.
- $sql3 = "SELECT count(post_id) AS number_of_posts, forum_id
- FROM $table_posts
- WHERE c_id = $course_id
- GROUP BY forum_id";
- }
- // Handling all the forum information.
- $result = Database::query($sql);
- $forum_list = [];
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- $forum_list[$row['forum_id']] = $row;
- }
- // Handling the thread count information.
- $result2 = Database::query($sql2);
- while ($row2 = Database::fetch_array($result2, 'ASSOC')) {
- if (is_array($forum_list)) {
- if (array_key_exists($row2['forum_id'], $forum_list)) {
- $forum_list[$row2['forum_id']]['number_of_threads'] = $row2['number_of_threads'];
- }
- }
- }
- // Handling the post count information.
- $result3 = Database::query($sql3);
- while ($row3 = Database::fetch_array($result3, 'ASSOC')) {
- if (is_array($forum_list)) {
- if (array_key_exists($row3['forum_id'], $forum_list)) {
- // This is needed because sql3 takes also the deleted forums into account.
- $forum_list[$row3['forum_id']]['number_of_posts'] = $row3['number_of_posts'];
- }
- }
- }
- // Finding the last post information
- // (last_post_id, last_poster_id, last_post_date, last_poster_name, last_poster_lastname, last_poster_firstname).
- if (!empty($forum_list)) {
- foreach ($forum_list as $key => $value) {
- $lastPost = get_last_post_information($key, api_is_allowed_to_edit());
- if ($lastPost) {
- $forum_list[$key]['last_post_id'] = $lastPost['last_post_id'];
- $forum_list[$key]['last_poster_id'] = $lastPost['last_poster_id'];
- $forum_list[$key]['last_post_date'] = $lastPost['last_post_date'];
- $forum_list[$key]['last_poster_name'] = $lastPost['last_poster_name'];
- $forum_list[$key]['last_poster_lastname'] = $lastPost['last_poster_lastname'];
- $forum_list[$key]['last_poster_firstname'] = $lastPost['last_poster_firstname'];
- }
- }
- }
- return $forum_list;
- }
- /**
- * This function stores which users have to be notified of which forums or threads.
- *
- * @param string $content does the user want to be notified about a forum or about a thread
- * @param int $id the id of the forum or thread
- * @param bool $addOnly
- * @param array $userInfo
- * @param array $courseInfo
- *
- * @return string language variable
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- * @author Julio Montoya
- *
- * @since May 2008 v1.8.5
- */
- function set_notification($content, $id, $addOnly = false, $userInfo = [], $courseInfo = [])
- {
- $userInfo = empty($userInfo) ? api_get_user_info() : $userInfo;
- $courseInfo = empty($courseInfo) ? api_get_course_info() : $courseInfo;
- $id = (int) $id;
- if (empty($userInfo) || empty($courseInfo) || empty($id) || empty($content)) {
- return false;
- }
- // Database table definition
- $table_notification = Database::get_course_table(TABLE_FORUM_NOTIFICATION);
- $course_id = $courseInfo['real_id'];
- // Which database field do we have to store the id in?
- $field = 'thread_id';
- if ($content === 'forum') {
- $field = 'forum_id';
- }
- $userId = $userInfo['user_id'];
- // First we check if the notification is already set for this.
- $sql = "SELECT * FROM $table_notification
- WHERE
- c_id = $course_id AND
- $field = $id AND
- user_id = $userId ";
- $result = Database::query($sql);
- $total = Database::num_rows($result);
- // If the user did not indicate that (s)he wanted to be notified already
- // then we store the notification request (to prevent double notification requests).
- if ($total <= 0) {
- $sql = "INSERT INTO $table_notification (c_id, $field, user_id)
- VALUES ($course_id, '$id','$userId')";
- Database::query($sql);
- Session::erase('forum_notification');
- getNotificationsPerUser(0, true);
- return get_lang('You will be notified of new posts by e-mail.');
- } else {
- if (!$addOnly) {
- $sql = "DELETE FROM $table_notification
- WHERE
- c_id = $course_id AND
- $field = $id AND
- user_id = $userId ";
- Database::query($sql);
- Session::erase('forum_notification');
- getNotificationsPerUser(0, true);
- return get_lang('You will no longer be notified of new posts by email');
- }
- }
- }
- /**
- * This function retrieves all the email adresses of the users who wanted to be notified
- * about a new post in a certain forum or thread.
- *
- * @param string $content does the user want to be notified about a forum or about a thread
- * @param int $id the id of the forum or thread
- *
- * @return array returns
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- * @author Julio Montoya
- *
- * @version May 2008, dokeos 1.8.5
- *
- * @since May 2008, dokeos 1.8.5
- */
- function get_notifications($content, $id)
- {
- // Database table definition
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $table_notification = Database::get_course_table(TABLE_FORUM_NOTIFICATION);
- $course_id = api_get_course_int_id();
- // Which database field contains the notification?
- $field = 'thread_id';
- if ($content === 'forum') {
- $field = 'forum_id';
- }
- $id = (int) $id;
- $sql = "SELECT user.user_id, user.firstname, user.lastname, user.email, user.user_id user
- FROM $table_users user, $table_notification notification
- WHERE
- notification.c_id = $course_id AND user.active = 1 AND
- user.user_id = notification.user_id AND
- notification.$field = $id ";
- $result = Database::query($sql);
- $return = [];
- while ($row = Database::fetch_array($result)) {
- $return['user'.$row['user_id']] = ['email' => $row['email'], 'user_id' => $row['user_id']];
- }
- return $return;
- }
- /**
- * Get all the users who need to receive a notification of a new post (those subscribed to
- * the forum or the thread).
- *
- * @param int $forum_id the id of the forum
- * @param int $thread_id the id of the thread
- * @param int $post_id the id of the post
- *
- * @return false|null
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- *
- * @version May 2008, dokeos 1.8.5
- *
- * @since May 2008, dokeos 1.8.5
- */
- function send_notifications($forum_id = 0, $thread_id = 0, $post_id = 0)
- {
- $forum_id = (int) $forum_id;
- // Users who subscribed to the forum
- if ($forum_id != 0) {
- $users_to_be_notified_by_forum = get_notifications('forum', $forum_id);
- } else {
- return false;
- }
- $current_thread = get_thread_information($forum_id, $thread_id);
- // User who subscribed to the thread
- if ($thread_id != 0) {
- $users_to_be_notified_by_thread = get_notifications('thread', $thread_id);
- }
- $postInfo = [];
- if (!empty($post_id)) {
- $postInfo = get_post_information($post_id);
- }
- // Merging the two
- $users_to_be_notified = array_merge($users_to_be_notified_by_forum, $users_to_be_notified_by_thread);
- $forumInfo = get_forum_information($forum_id);
- if (is_array($users_to_be_notified)) {
- foreach ($users_to_be_notified as $value) {
- $userInfo = api_get_user_info($value['user_id']);
- send_mail($userInfo, $forumInfo, $current_thread, $postInfo);
- }
- }
- }
- /**
- * Get all the notification subscriptions of the user
- * = which forums and which threads does the user wants to be informed of when a new
- * post is added to this thread.
- *
- * @param int $user_id the user_id of a user (default = 0 => the current user)
- * @param bool $force force get the notification subscriptions (even if the information is already in the session
- *
- * @return array
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium
- *
- * @version May 2008, dokeos 1.8.5
- *
- * @since May 2008, dokeos 1.8.5
- */
- function getNotificationsPerUser($user_id = 0, $force = false, $course_id = 0)
- {
- // Database table definition
- $table_notification = Database::get_course_table(TABLE_FORUM_NOTIFICATION);
- $course_id = empty($course_id) ? api_get_course_int_id() : (int) $course_id;
- if (empty($course_id) || $course_id == -1) {
- return null;
- }
- $user_id = empty($user_id) ? api_get_user_id() : (int) $user_id;
- if (!isset($_SESSION['forum_notification']) ||
- $_SESSION['forum_notification']['course'] != $course_id ||
- $force == true
- ) {
- $_SESSION['forum_notification']['course'] = $course_id;
- $sql = "SELECT * FROM $table_notification
- WHERE c_id = $course_id AND user_id='".$user_id."'";
- $result = Database::query($sql);
- while ($row = Database::fetch_array($result)) {
- if (!is_null($row['forum_id'])) {
- $_SESSION['forum_notification']['forum'][] = $row['forum_id'];
- }
- if (!is_null($row['thread_id'])) {
- $_SESSION['forum_notification']['thread'][] = $row['thread_id'];
- }
- }
- }
- }
- /**
- * This function counts the number of post inside a thread.
- *
- * @param int $thread_id
- *
- * @return int the number of post inside a thread
- *
- * @author Jhon Hinojosa <jhon.hinojosa@dokeos.com>,
- *
- * @version octubre 2008, dokeos 1.8
- */
- function count_number_of_post_in_thread($thread_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- if (empty($course_id)) {
- return 0;
- }
- $sql = "SELECT count(*) count FROM $table_posts
- WHERE
- c_id = $course_id AND
- thread_id='".intval($thread_id)."' ";
- $result = Database::query($sql);
- $count = 0;
- if (Database::num_rows($result) > 0) {
- $row = Database::fetch_array($result);
- $count = $row['count'];
- }
- return $count;
- }
- /**
- * This function counts the number of post inside a thread user.
- *
- * @param int $thread_id
- * @param int $user_id
- *
- * @return int the number of post inside a thread user
- */
- function count_number_of_post_for_user_thread($thread_id, $user_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $course_id = api_get_course_int_id();
- $sql = "SELECT count(iid) as count
- FROM $table_posts
- WHERE c_id = $course_id AND
- thread_id=".intval($thread_id)." AND
- poster_id = ".intval($user_id)." AND visible = 1 ";
- $result = Database::query($sql);
- $count = 0;
- if (Database::num_rows($result) > 0) {
- $count = Database::fetch_array($result);
- $count = $count['count'];
- }
- return $count;
- }
- /**
- * This function retrieves information of statistical.
- *
- * @param int $thread_id
- * @param int $user_id
- * @param int $course_id
- *
- * @return array the information of statistical
- *
- * @author Jhon Hinojosa <jhon.hinojosa@dokeos.com>,
- *
- * @version oct 2008, dokeos 1.8
- */
- function get_statistical_information($thread_id, $user_id, $course_id)
- {
- $result = [];
- $courseInfo = api_get_course_info_by_id($course_id);
- $result['user_course'] = CourseManager::get_users_count_in_course($courseInfo['code']);
- $result['post'] = count_number_of_post_in_thread($thread_id);
- $result['user_post'] = count_number_of_post_for_user_thread($thread_id, $user_id);
- return $result;
- }
- /**
- * This function return the posts inside a thread from a given user.
- *
- * @param string $course_code
- * @param int $thread_id
- * @param int $user_id
- *
- * @return array posts inside a thread
- *
- * @author Jhon Hinojosa <jhon.hinojosa@dokeos.com>,
- *
- * @version oct 2008, dokeos 1.8
- */
- function get_thread_user_post($course_code, $thread_id, $user_id)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $thread_id = intval($thread_id);
- $user_id = intval($user_id);
- $course_info = api_get_user_info($course_code);
- $course_id = $course_info['real_id'];
- if (empty($course_id)) {
- $course_id = api_get_course_int_id();
- }
- $sql = "SELECT * FROM $table_posts posts
- LEFT JOIN $table_users users
- ON posts.poster_id=users.user_id
- WHERE
- posts.c_id = $course_id AND
- posts.thread_id='$thread_id'
- AND posts.poster_id='$user_id'
- ORDER BY posts.post_id ASC";
- $result = Database::query($sql);
- $post_list = [];
- while ($row = Database::fetch_array($result)) {
- $row['status'] = '1';
- $post_list[] = $row;
- $sql = "SELECT * FROM $table_posts posts
- LEFT JOIN $table_users users
- ON (posts.poster_id=users.user_id)
- WHERE
- posts.c_id = $course_id AND
- posts.thread_id='$thread_id'
- AND posts.post_parent_id='".$row['post_id']."'
- ORDER BY posts.post_id ASC";
- $result2 = Database::query($sql);
- while ($row2 = Database::fetch_array($result2)) {
- $row2['status'] = '0';
- $post_list[] = $row2;
- }
- }
- return $post_list;
- }
- /**
- * This function get the name of an thread by id.
- *
- * @param int thread_id
- *
- * @return string
- *
- * @author Christian Fasanando
- * @author Julio Montoya <gugli100@gmail.com> Adding security
- */
- function get_name_thread_by_id($thread_id)
- {
- $t_forum_thread = Database::get_course_table(TABLE_FORUM_THREAD);
- $course_id = api_get_course_int_id();
- $sql = "SELECT thread_title
- FROM $t_forum_thread
- WHERE c_id = $course_id AND thread_id = '".intval($thread_id)."' ";
- $result = Database::query($sql);
- $row = Database::fetch_array($result);
- return $row[0];
- }
- /**
- * This function gets all the post written by an user.
- *
- * @param int $user_id
- * @param string $course_code
- *
- * @return string
- */
- function get_all_post_from_user($user_id, $course_code)
- {
- $j = 0;
- $forums = get_forums('', $course_code);
- krsort($forums);
- $forum_results = '';
- foreach ($forums as $forum) {
- if ($forum['visibility'] == 0) {
- continue;
- }
- if ($j <= 4) {
- $threads = get_threads($forum['forum_id']);
- if (is_array($threads)) {
- $i = 0;
- $hand_forums = '';
- $post_counter = 0;
- foreach ($threads as $thread) {
- if ($thread['visibility'] == 0) {
- continue;
- }
- if ($i <= 4) {
- $post_list = get_thread_user_post_limit(
- $course_code,
- $thread['thread_id'],
- $user_id,
- 1
- );
- $post_counter = count($post_list);
- if (is_array($post_list) && count($post_list) > 0) {
- $hand_forums .= '<div id="social-thread">';
- $hand_forums .= Display::return_icon(
- 'thread.png',
- get_lang('Thread'),
- '',
- ICON_SIZE_MEDIUM
- );
- $hand_forums .= ' '.Security::remove_XSS($thread['thread_title'], STUDENT);
- $hand_forums .= '</div>';
- foreach ($post_list as $posts) {
- $hand_forums .= '<div id="social-post">';
- $hand_forums .= '<strong>'.Security::remove_XSS($posts['post_title'], STUDENT).'</strong>';
- $hand_forums .= '<br / >';
- $hand_forums .= Security::remove_XSS($posts['post_text'], STUDENT);
- $hand_forums .= '</div>';
- $hand_forums .= '<br / >';
- }
- }
- }
- $i++;
- }
- $forum_results .= '<div id="social-forum">';
- $forum_results .= '<div class="clear"></div><br />';
- $forum_results .= '<div id="social-forum-title">'.
- Display::return_icon('forum.gif', get_lang('Forum')).' '.Security::remove_XSS($forum['forum_title'], STUDENT).
- '<div style="float:right;margin-top:-35px">
- <a href="../forum/viewforum.php?'.api_get_cidreq_params($course_code).'&forum='.$forum['forum_id'].' " >'.
- get_lang('See forum').'
- </a>
- </div></div>';
- $forum_results .= '<br / >';
- if ($post_counter > 0) {
- $forum_results .= $hand_forums;
- }
- $forum_results .= '</div>';
- }
- $j++;
- }
- }
- return $forum_results;
- }
- /**
- * @param string $course_code
- * @param int $thread_id
- * @param int $user_id
- * @param int $limit
- *
- * @return array
- */
- function get_thread_user_post_limit($course_code, $thread_id, $user_id, $limit = 10)
- {
- $table_posts = Database::get_course_table(TABLE_FORUM_POST);
- $table_users = Database::get_main_table(TABLE_MAIN_USER);
- $course_info = api_get_course_info($course_code);
- $course_id = $course_info['real_id'];
- $sql = "SELECT * FROM $table_posts posts
- LEFT JOIN $table_users users
- ON posts.poster_id=users.user_id
- WHERE
- posts.c_id = $course_id AND
- posts.thread_id='".Database::escape_string($thread_id)."' AND
- posts.poster_id='".Database::escape_string($user_id)."'
- ORDER BY posts.post_id DESC LIMIT $limit ";
- $result = Database::query($sql);
- $post_list = [];
- while ($row = Database::fetch_array($result)) {
- $row['status'] = '1';
- $post_list[] = $row;
- }
- return $post_list;
- }
- /**
- * @param string $userId
- * @param array $courseInfo
- * @param int $sessionId
- *
- * @return array
- */
- function getForumCreatedByUser($userId, $courseInfo, $sessionId)
- {
- if (empty($userId) || empty($courseInfo)) {
- return [];
- }
- $courseId = $courseInfo['real_id'];
- $items = api_get_item_property_list_by_tool_by_user(
- $userId,
- 'forum',
- $courseId,
- $sessionId
- );
- $forumList = [];
- if (!empty($items)) {
- foreach ($items as $forum) {
- $forumInfo = get_forums(
- $forum['ref'],
- $courseInfo['code'],
- true,
- $sessionId
- );
- if (!empty($forumInfo) && isset($forumInfo['forum_title'])) {
- $forumList[] = [
- $forumInfo['forum_title'],
- api_get_local_time($forum['insert_date']),
- api_get_local_time($forum['lastedit_date']),
- ];
- }
- }
- }
- return $forumList;
- }
- /**
- * This function builds an array of all the posts in a given thread
- * where the key of the array is the post_id
- * It also adds an element children to the array which itself is an array
- * that contains all the id's of the first-level children.
- *
- * @return array $rows containing all the information on the posts of a thread
- *
- * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University
- */
- function calculate_children($rows)
- {
- $sorted_rows = [0 => []];
- if (!empty($rows)) {
- foreach ($rows as $row) {
- $rows_with_children[$row['post_id']] = $row;
- $rows_with_children[$row['post_parent_id']]['children'][] = $row['post_id'];
- }
- $rows = $rows_with_children;
- forumRecursiveSort($rows, $sorted_rows);
- unset($sorted_rows[0]);
- }
- return $sorted_rows;
- }
- /**
- * @param $rows
- * @param $threads
- * @param int $seed
- * @param int $indent
- */
- function forumRecursiveSort($rows, &$threads, $seed = 0, $indent = 0)
- {
- if ($seed > 0) {
- $threads[$rows[$seed]['post_id']] = $rows[$seed];
- $threads[$rows[$seed]['post_id']]['indent_cnt'] = $indent;
- $indent++;
- }
- if (isset($rows[$seed]['children'])) {
- foreach ($rows[$seed]['children'] as $child) {
- forumRecursiveSort($rows, $threads, $child, $indent);
- }
- }
- }
- /**
- * Update forum attachment data, used to update comment and post ID.
- *
- * @param $array array (field => value) to update forum attachment row
- * @param $id attach ID to find row to update
- * @param null $courseId course ID to find row to update
- *
- * @return int number of affected rows
- */
- function editAttachedFile($array, $id, $courseId = null)
- {
- // Init variables
- $setString = '';
- $id = (int) $id;
- $courseId = (int) $courseId;
- if (empty($courseId)) {
- // $courseId can be null, use api method
- $courseId = api_get_course_int_id();
- }
- /*
- * Check if Attachment ID and Course ID are greater than zero
- * and array of field values is not empty
- */
- if ($id > 0 && $courseId > 0 && !empty($array) && is_array($array)) {
- foreach ($array as $key => &$item) {
- $item = Database::escape_string($item);
- $setString .= $key.' = "'.$item.'", ';
- }
- // Delete last comma
- $setString = substr($setString, 0, strlen($setString) - 2);
- $forumAttachmentTable = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $sql = "UPDATE $forumAttachmentTable
- SET $setString WHERE c_id = $courseId AND id = $id";
- $result = Database::query($sql);
- if ($result !== false) {
- $affectedRows = Database::affected_rows($result);
- if ($affectedRows > 0) {
- /*
- * If exist in $_SESSION variable, then delete them from it
- * because they would be deprecated
- */
- if (!empty($_SESSION['forum']['upload_file'][$courseId][$id])) {
- unset($_SESSION['forum']['upload_file'][$courseId][$id]);
- }
- }
- return $affectedRows;
- }
- }
- return 0;
- }
- /**
- * Return a table where the attachments will be set.
- *
- * @param int $postId Forum Post ID
- *
- * @return string The Forum Attachments Ajax Table
- */
- function getAttachmentsAjaxTable($postId = 0)
- {
- $postId = (int) $postId;
- $courseId = api_get_course_int_id();
- $attachIds = getAttachmentIdsByPostId($postId, $courseId);
- $fileDataContent = '';
- // Update comment to show if form did not pass validation
- if (!empty($_REQUEST['file_ids']) && is_array($_REQUEST['file_ids'])) {
- // 'file_ids is the name from forum attachment ajax form
- foreach ($_REQUEST['file_ids'] as $key => $attachId) {
- if (!empty($_SESSION['forum']['upload_file'][$courseId][$attachId]) &&
- is_array($_SESSION['forum']['upload_file'][$courseId][$attachId])
- ) {
- // If exist forum attachment then update into $_SESSION data
- $_SESSION['forum']['upload_file'][$courseId][$attachId]['comment'] = $_POST['file_comments'][$key];
- }
- }
- }
- // Get data to fill into attachment files table
- if (!empty($_SESSION['forum']['upload_file'][$courseId]) &&
- is_array($_SESSION['forum']['upload_file'][$courseId])
- ) {
- $uploadedFiles = $_SESSION['forum']['upload_file'][$courseId];
- foreach ($uploadedFiles as $k => $uploadedFile) {
- if (!empty($uploadedFile) && in_array($uploadedFile['id'], $attachIds)) {
- // Buil html table including an input with attachmentID
- $fileDataContent .= '<tr id="'.$uploadedFile['id'].'" ><td>'.$uploadedFile['name'].'</td><td>'.$uploadedFile['size'].'</td><td> '.$uploadedFile['result'].
- ' </td><td> <input style="width:90%;" type="text" value="'.$uploadedFile['comment'].'" name="file_comments[]"> </td><td>'.
- $uploadedFile['delete'].'</td>'.
- '<input type="hidden" value="'.$uploadedFile['id'].'" name="file_ids[]">'.'</tr>';
- } else {
- /*
- * If attachment data is empty, then delete it from $_SESSION
- * because could generate and empty row into html table
- */
- unset($_SESSION['forum']['upload_file'][$courseId][$k]);
- }
- }
- }
- $style = empty($fileDataContent) ? 'display: none;' : '';
- // Forum attachment Ajax table
- $fileData = '
- <div class="control-group " style="'.$style.'">
- <label class="control-label">'.get_lang('Attachments list').'</label>
- <div class="controls">
- <table id="attachmentFileList" class="files data_table span10">
- <tr>
- <th>'.get_lang('Filename').'</th>
- <th>'.get_lang('Size').'</th>
- <th>'.get_lang('Status').'</th>
- <th>'.get_lang('Comment').'</th>
- <th>'.get_lang('Delete').'</th>
- </tr>
- '.$fileDataContent.'
- </table>
- </div>
- </div>';
- return $fileData;
- }
- /**
- * Return an array of prepared attachment data to build forum attachment table
- * Also, save this array into $_SESSION to do available the attachment data.
- *
- * @param int $forumId
- * @param int $threadId
- * @param int $postId
- * @param int $attachId
- * @param int $courseId
- *
- * @return array
- */
- function getAttachedFiles(
- $forumId,
- $threadId,
- $postId = 0,
- $attachId = 0,
- $courseId = 0
- ) {
- $forumId = (int) $forumId;
- $courseId = (int) $courseId;
- $attachId = (int) $attachId;
- $postId = (int) $postId;
- $threadId = !empty($threadId) ? intval($threadId) : isset($_REQUEST['thread']) ? intval($_REQUEST['thread']) : '';
- if (empty($courseId)) {
- // $courseId can be null, use api method
- $courseId = api_get_course_int_id();
- }
- if (empty($forumId)) {
- if (!empty($_REQUEST['forum'])) {
- $forumId = (int) $_REQUEST['forum'];
- } else {
- // if forum ID is empty, cannot generate delete url
- return [];
- }
- }
- // Check if exist at least one of them to filter forum attachment select query
- if (empty($postId) && empty($attachId)) {
- return [];
- } elseif (empty($postId)) {
- $filter = "AND iid = $attachId";
- } elseif (empty($attachId)) {
- $filter = "AND post_id = $postId";
- } else {
- $filter = "AND post_id = $postId AND iid = $attachId";
- }
- $forumAttachmentTable = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $sql = "SELECT iid, comment, filename, path, size
- FROM $forumAttachmentTable
- WHERE c_id = $courseId $filter";
- $result = Database::query($sql);
- $json = [];
- if ($result !== false && Database::num_rows($result) > 0) {
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- // name contains an URL to download attachment file and its filename
- $json['name'] = Display::url(
- api_htmlentities($row['filename']),
- api_get_path(WEB_CODE_PATH).'forum/download.php?file='.$row['path'].'&'.api_get_cidreq(),
- ['target' => '_blank', 'class' => 'attachFilename']
- );
- $json['id'] = $row['iid'];
- $json['comment'] = $row['comment'];
- // Format file size
- $json['size'] = format_file_size($row['size']);
- // Check if $row is consistent
- if (!empty($row) && is_array($row)) {
- // Set result as success and bring delete URL
- $json['result'] = Display::return_icon('accept.png', get_lang('Uploaded.'));
- $url = api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.api_get_cidreq().'&action=delete_attach&forum='.$forumId.'&thread='.$threadId.'&id_attach='.$row['iid'];
- $json['delete'] = Display::url(
- Display::return_icon('delete.png', get_lang('Delete'), [], ICON_SIZE_SMALL),
- $url,
- ['class' => 'deleteLink']
- );
- } else {
- // If not, set an exclamation result
- $json['result'] = Display::return_icon('exclamation.png', get_lang('Error'));
- }
- // Store array data into $_SESSION
- $_SESSION['forum']['upload_file'][$courseId][$json['id']] = $json;
- }
- }
- return $json;
- }
- /**
- * Clear forum attachment data stored in $_SESSION,
- * If is not defined post, it will clear all forum attachment data from course.
- *
- * @param int $postId -1 : Clear all attachments from course stored in $_SESSION
- * 0 : Clear attachments from course, except from temporal post "0"
- * but without delete them from file system and database
- * Other values : Clear attachments from course except specified post
- * and delete them from file system and database
- * @param int $courseId : Course ID, if it is null, will use api_get_course_int_id()
- *
- * @return array
- */
- function clearAttachedFiles($postId = 0, $courseId = 0)
- {
- // Init variables
- $courseId = (int) $courseId;
- $postId = (int) $postId;
- $array = [];
- if (empty($courseId)) {
- // $courseId can be null, use api method
- $courseId = api_get_course_int_id();
- }
- if ($postId === -1) {
- // If post ID is -1 then delete course's attachment data from $_SESSION
- if (!empty($_SESSION['forum']['upload_file'][$courseId])) {
- $array = array_keys($_SESSION['forum']['upload_file'][$courseId]);
- unset($_SESSION['forum']['upload_file'][$courseId]);
- }
- } else {
- $attachIds = getAttachmentIdsByPostId($postId, $courseId);
- if (!empty($_SESSION['forum']['upload_file'][$courseId]) &&
- is_array($_SESSION['forum']['upload_file'][$courseId])) {
- foreach ($_SESSION['forum']['upload_file'][$courseId] as $attachId => $attach) {
- if (!in_array($attachId, $attachIds)) {
- // If attach ID is not into specified post, delete attachment
- // Save deleted attachment ID
- $array[] = $attachId;
- if ($postId !== 0) {
- // Post 0 is temporal, delete them from file system and DB
- delete_attachment(0, $attachId);
- }
- // Delete attachment data from $_SESSION
- unset($_SESSION['forum']['upload_file'][$courseId][$attachId]);
- }
- }
- }
- }
- return $array;
- }
- /**
- * Returns an array of forum attachment ids into a course and forum post.
- *
- * @param int $postId
- * @param int $courseId
- *
- * @return array
- */
- function getAttachmentIdsByPostId($postId, $courseId = 0)
- {
- $array = [];
- $courseId = (int) $courseId;
- $postId = (int) $postId;
- if (empty($courseId)) {
- // $courseId can be null, use api method
- $courseId = api_get_course_int_id();
- }
- if ($courseId > 0) {
- $forumAttachmentTable = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
- $sql = "SELECT id FROM $forumAttachmentTable
- WHERE c_id = $courseId AND post_id = $postId";
- $result = Database::query($sql);
- if ($result !== false && Database::num_rows($result) > 0) {
- while ($row = Database::fetch_array($result, 'ASSOC')) {
- $array[] = $row['id'];
- }
- }
- }
- return $array;
- }
- /**
- * Check if the forum category exists looking for its title.
- *
- * @param string $title The forum category title
- * @param int $courseId The course ID
- * @param int $sessionId Optional. The session ID
- *
- * @return bool
- */
- function getForumCategoryByTitle($title, $courseId, $sessionId = 0)
- {
- $sessionId = (int) $sessionId;
- $courseId = (int) $courseId;
- $forumCategoryTable = Database::get_course_table(TABLE_FORUM_CATEGORY);
- $itemProperty = Database::get_course_table(TABLE_ITEM_PROPERTY);
- $fakeFrom = "$forumCategoryTable fc
- INNER JOIN $itemProperty ip ";
- if ($sessionId === 0) {
- $fakeFrom .= "
- ON (
- fc.cat_id = ip.ref AND fc.c_id = ip.c_id AND (fc.session_id = ip.session_id OR ip.session_id IS NULL)
- )
- ";
- } else {
- $fakeFrom .= "
- ON (
- fc.cat_id = ip.ref AND fc.c_id = ip.c_id AND fc.session_id = ip.session_id
- )
- ";
- }
- $resultData = Database::select(
- 'fc.*',
- $fakeFrom,
- [
- 'where' => [
- 'ip.visibility != ? AND ' => 2,
- 'ip.tool = ? AND ' => TOOL_FORUM_CATEGORY,
- 'fc.session_id = ? AND ' => $sessionId,
- 'fc.cat_title = ? AND ' => $title,
- 'fc.c_id = ?' => $courseId,
- ],
- ],
- 'first'
- );
- if (empty($resultData)) {
- return false;
- }
- return $resultData;
- }
- /**
- * @param array $current_forum
- * @param array $row
- * @param bool $addWrapper
- *
- * @return string
- */
- function getPostStatus($current_forum, $row, $addWrapper = true)
- {
- $statusIcon = '';
- if ($current_forum['moderated']) {
- if ($addWrapper) {
- $statusIcon = '<br /><br /><span id="status_post_'.$row['iid'].'">';
- }
- $row['status'] = empty($row['status']) ? 2 : $row['status'];
- $addUrl = false;
- $showStatus = false;
- if (api_is_allowed_to_edit(false, true)) {
- $addUrl = true;
- } else {
- if ($row['user_id'] == api_get_user_id()) {
- $showStatus = true;
- }
- }
- $label = '';
- $icon = '';
- $buttonType = '';
- switch ($row['status']) {
- case CForumPost::STATUS_VALIDATED:
- $label = get_lang('Validated');
- $icon = 'check-circle';
- $buttonType = 'success';
- break;
- case CForumPost::STATUS_WAITING_MODERATION:
- $label = get_lang('Waiting for moderation');
- $icon = 'warning';
- $buttonType = 'warning';
- break;
- case CForumPost::STATUS_REJECTED:
- $label = get_lang('Rejected');
- $icon = 'minus-circle';
- $buttonType = 'danger';
- break;
- }
- if ($addUrl) {
- $statusIcon .= Display::toolbarButton(
- $label.' ',
- 'javascript:void(0)',
- $icon,
- $buttonType,
- ['class' => 'change_post_status']
- );
- } else {
- if ($showStatus) {
- $statusIcon .= Display::label(
- Display::returnFontAwesomeIcon($icon).$label,
- $buttonType
- );
- }
- }
- if ($addWrapper) {
- $statusIcon .= '</span>';
- }
- }
- return $statusIcon;
- }
- /**
- * @param array $forumInfo
- * @param int $threadId
- * @param int $status
- *
- * @return mixed
- */
- function getCountPostsWithStatus($status, $forumInfo, $threadId = null)
- {
- $em = Database::getManager();
- $criteria = Criteria::create();
- $criteria
- ->where(Criteria::expr()->eq('status', $status))
- ->andWhere(Criteria::expr()->eq('cId', $forumInfo['c_id']))
- ->andWhere(Criteria::expr()->eq('visible', 1))
- ;
- if (!empty($threadId)) {
- $criteria->andWhere(Criteria::expr()->eq('threadId', $threadId));
- }
- $qb = $em->getRepository('ChamiloCourseBundle:CForumPost')->createQueryBuilder('p');
- $qb->select('count(p.iid)')
- ->addCriteria($criteria);
- return $qb->getQuery()->getSingleScalarResult();
- }
- /**
- * @param array $forum
- * @param array $post
- *
- * @return bool
- */
- function postIsEditableByStudent($forum, $post)
- {
- if (api_is_platform_admin() || api_is_allowed_to_edit()) {
- return true;
- }
- if ($forum['moderated'] == 1) {
- if (is_null($post['status'])) {
- return true;
- } else {
- return in_array(
- $post['status'],
- [
- CForumPost::STATUS_WAITING_MODERATION,
- CForumPost::STATUS_REJECTED,
- ]
- );
- }
- } else {
- return true;
- }
- }
- /**
- * @param int $postId
- *
- * @return bool
- */
- function savePostRevision($postId)
- {
- $postData = get_post_information($postId);
- if (empty($postData)) {
- return false;
- }
- $userId = api_get_user_id();
- if ($postData['poster_id'] != $userId) {
- return false;
- }
- $status = (int) !postNeedsRevision($postId);
- $extraFieldValue = new ExtraFieldValue('forum_post');
- $params = [
- 'item_id' => $postId,
- 'extra_ask_for_revision' => ['extra_ask_for_revision' => $status],
- ];
- if (empty($status)) {
- unset($params['extra_ask_for_revision']);
- }
- $extraFieldValue->saveFieldValues(
- $params,
- true,
- false,
- ['ask_for_revision']
- );
- }
- /**
- * @param int $postId
- *
- * @return string
- */
- function getPostRevision($postId)
- {
- $extraFieldValue = new ExtraFieldValue('forum_post');
- $value = $extraFieldValue->get_values_by_handler_and_field_variable(
- $postId,
- 'revision_language'
- );
- $revision = '';
- if ($value && isset($value['value'])) {
- $revision = $value['value'];
- }
- return $revision;
- }
- /**
- * @param int $postId
- *
- * @return bool
- */
- function postNeedsRevision($postId)
- {
- $extraFieldValue = new ExtraFieldValue('forum_post');
- $value = $extraFieldValue->get_values_by_handler_and_field_variable(
- $postId,
- 'ask_for_revision'
- );
- $hasRevision = false;
- if ($value && isset($value['value'])) {
- return $value['value'] == 1;
- }
- return $hasRevision;
- }
- /**
- * @param int $postId
- * @param array $threadInfo
- *
- * @return string
- */
- function getAskRevisionButton($postId, $threadInfo)
- {
- if (api_get_configuration_value('allow_forum_post_revisions') === false) {
- return '';
- }
- $postId = (int) $postId;
- $status = 'btn-default';
- if (postNeedsRevision($postId)) {
- $status = 'btn-success';
- }
- return Display::url(
- get_lang('Ask for a revision'),
- api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.
- api_get_cidreq().'&action=ask_revision&post_id='.$postId.'&forum='.$threadInfo['forum_id'].'&thread='.$threadInfo['thread_id'],
- ['class' => "btn $status", 'title' => get_lang('Ask for a revision')]
- );
- }
- /**
- * @param int $postId
- * @param array $threadInfo
- *
- * @return string
- */
- function giveRevisionButton($postId, $threadInfo)
- {
- $postId = (int) $postId;
- return Display::toolbarButton(
- get_lang('Give revision'),
- api_get_path(WEB_CODE_PATH).'forum/reply.php?'.api_get_cidreq().'&'.http_build_query(
- [
- 'forum' => $threadInfo['forum_id'],
- 'thread' => $threadInfo['thread_id'],
- 'post' => $postId = (int) $postId,
- 'action' => 'replymessage',
- 'give_revision' => 1,
- ]
- ),
- 'reply',
- 'primary',
- ['id' => "reply-to-post-{$postId}"]
- );
- }
- /**
- * @param int $postId
- * @param array $threadInfo
- *
- * @return string
- */
- function getReportButton($postId, $threadInfo)
- {
- $postId = (int) $postId;
- return Display::url(
- Display::returnFontAwesomeIcon('flag'),
- api_get_path(WEB_CODE_PATH).'forum/viewthread.php?'.
- api_get_cidreq().'&action=report&post_id='.$postId.'&forum='.$threadInfo['forum_id'].'&thread='.$threadInfo['thread_id'],
- ['class' => 'btn btn-danger', 'title' => get_lang('Report')]
- );
- }
- /**
- * @return bool
- */
- function reportAvailable()
- {
- $extraFieldValue = new ExtraFieldValue('course');
- $value = $extraFieldValue->get_values_by_handler_and_field_variable(
- api_get_course_int_id(),
- 'allow_forum_report_button'
- );
- $allowReport = false;
- if ($value && isset($value['value']) && $value['value'] == 1) {
- $allowReport = true;
- }
- return $allowReport;
- }
- /**
- * @return array
- */
- function getReportRecipients()
- {
- $extraFieldValue = new ExtraFieldValue('course');
- $value = $extraFieldValue->get_values_by_handler_and_field_variable(
- api_get_course_int_id(),
- 'forum_report_recipients'
- );
- $users = [];
- if ($value && isset($value['value'])) {
- $usersType = explode(';', $value['value']);
- foreach ($usersType as $type) {
- switch ($type) {
- case 'teachers':
- $teachers = CourseManager::get_teacher_list_from_course_code(api_get_course_id());
- if (!empty($teachers)) {
- $users = array_merge($users, array_column($teachers, 'user_id'));
- }
- break;
- case 'admins':
- $admins = UserManager::get_all_administrators();
- if (!empty($admins)) {
- $users = array_merge($users, array_column($admins, 'user_id'));
- }
- break;
- case 'community_managers':
- $managers = api_get_configuration_value('community_managers_user_list');
- if (!empty($managers) && isset($managers['users'])) {
- $users = array_merge($users, $managers['users']);
- }
- break;
- }
- }
- $users = array_unique(array_filter($users));
- }
- return $users;
- }
- /**
- * @param int $postId
- * @param array $forumInfo
- * @param array $threadInfo
- *
- * @return bool
- */
- function reportPost($postId, $forumInfo, $threadInfo)
- {
- if (!reportAvailable()) {
- return false;
- }
- if (empty($forumInfo) || empty($threadInfo)) {
- return false;
- }
- $postId = (int) $postId;
- $postData = get_post_information($postId);
- $currentUser = api_get_user_info();
- if (!empty($postData)) {
- $users = getReportRecipients();
- if (!empty($users)) {
- $url = api_get_path(WEB_CODE_PATH).
- 'forum/viewthread.php?forum='.$threadInfo['forum_id'].'&thread='.$threadInfo['thread_id'].'&'.api_get_cidreq().'&post_id='.$postId.'#post_id_'.$postId;
- $postLink = Display::url(
- $postData['post_title'],
- $url
- );
- $subject = get_lang('Post reported');
- $content = sprintf(
- get_lang('User %s has reported the message %s in the forum %s'),
- $currentUser['complete_name'],
- $postLink,
- $forumInfo['forum_title']
- );
- foreach ($users as $userId) {
- MessageManager::send_message_simple($userId, $subject, $content);
- }
- }
- }
- }
|