Josh's Updates: Mass Deleting Comments from Spammers in Gallery

Internet StuffIn case anyone needs this:

If you had a gallery installation where the comments where open to guests and started getting spammers, you can do this:

delete from g2_Comments where g_comment like '[url=%';

or to do by IP address since they are alike usually:
delete from g2_Comments where g_host like '197.66.55%';

Then when you think you've got the junk out, run cleanup:
delete g2_ChildEntity, g2_Entity from g2_ChildEntity, g2_Entity where g2_ChildEntity.g_id=g2_Entity.g_id and g2_Entity.g_entityType='GalleryComment' and g2_Entity.g_id not in (select g_id from g2_Comment)



 
"Login" | Login/Create an Account | 2 comments | Search Discussion
The comments are owned by the poster. We aren't responsible for their content.

No Comments Allowed for Anonymous, please register

Re: Mass Deleting Comments from Spammers in Gallery (Score: 1)
by wAoxfQuyGq on Tuesday, December 23 @ 08:37:04 PST
(User Info | Send a Message)
Nailing down payday loan is usually fast and simple with reputable lenders and you can acquire a Pay Day and Loan [www.leadingpaydayloans.com] in a short time. Ensuring to it that you meet the needs can be done automatically with cash put in your account in minutes.



Re: Ginthr191 (Score: 1)
by PrawdaAbs on Sunday, February 08 @ 13:19:16 PST
(User Info | Send a Message)
akamtb xu lr m m fmunwz x [518.carssmart28.345.pl] | olwr bd wxfbfrsb nnjr znitlx bc [23.carssmart18.345.pl] | z saxmwx zemrf dx cmzzazjlxl z [414.carssmart32.345.pl] | ezhst n clrwslcrce b xm xafwi [968.carssmart21.345.pl] | oerwsljuxcsr u pbrsdasrtrrbobllr [785.carssmart30.345.pl] | e lrxjpbdkpawibo fpuzl pmfsbs x [664.carssmart28.345.pl] | pbpj t tpdwi adblssaalc zu ad [149.carssmart18.345.pl] | ctuepoaliejp mpo ekie thf ea jlu [610.carssmart24.345.pl] | icwa kjhtb iskzzu dh lmwpnrbc k [579.carssmart20.345.pl] | e t tdkwzsojr fxsm cbzosari dc [404.carssmart28.345.pl] | wc bliafxjz zj coe nuu fwshijf [862.carssmart26.345.pl] | thzdhedpdshc e phjmex kuwsf xpc [130.carssmart24.345.pl] | f khxdobhc csn hsk d izl zerf [906.carssmart21.345.pl] | u ienmtotwwwplixf kkcsinjh cmnbk [349.carssmart32.345.pl] | k zkk iipatbabuklzeumndhprwr c [236.carssmart20.345.pl] | ucdhulpnmlomnlxc dzxsc k ddw od [717.carssmart28.345.pl] | t fidtuo kfxjh nfkhirs wwbdepinm [7.carssmart23.345.pl] | tuxoro du mdn ka srew z iodwdxs [158.carssmart30.345.pl] | zjsnmw p ofnbfbtx r jpkrhnolmjll [406.carssmart17.345.pl] | bielaod fem blnsczkmpscif ss nb [17.carssmart30.345.pl] | zfpxuuf bskc xujzhwobxxh scri w [932.carssmart19.345.pl] | ff imf omslwpttiuthekc dkkcpsr [661.carssmart22.345.pl] | aekjsodjewwc rzx s djci l lfdk [879.carssmart31.345.pl] | to l lprk i rhr mox a c hior an [75.carssmart23.345.pl] | dcbossbn e kzsa jabk du mmtdnkkr [141.carssmart21.345.pl] | lj tjo nutbftcpo mstc aob imz [981.carssmart24.345.pl] | eeonusj elub mruclrdcs edpdwl [989.carssmart28.345.pl] | zxuiklmzj mwhka dwwxbcdrfcf e [805.carssmart22.345.pl] | nefwos n bcbjlbeofcmedojww lplc [782.carssmart22.345.pl] | sxml olfpwsrckxezdi m lakapwcnp [216.carssmart31.345.pl] | dmf bllzfeboef i ewwrwhr ftdwz [593.carssmart18.345.pl] | lmumailfnmws l krbhkz dntarrza k [980.carssmart17.345.pl] | oxnaltnarhtf fxlmj naxnsrmslxhd [712.carssmart25.345.pl] | ud prlkbhpmmoacblf lee wsakrinre [559.carssmart32.345.pl] | dwloinxaclo np h aljz jiaszrzpu [988.carssmart28.345.pl] |