Announcement

Collapse
No announcement yet.

calendar picture comment spam

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • calendar picture comment spam

    I've been getting alot of picture comment spam and also calendar events spam.

    Is there anyway to mass delete picture comments and calendar events?

    I cant find mass delete function.

    Thanks.

  • #2
    A query to delete calendar events...
    Code:
    DELETE FROM event WHERE userid = X;
    Change X as required.
    Lats...

    Comment


    • #3
      For picture spam...
      Code:
      DELETE FROM picturecomment WHERE postuserid = X;
      Lats...

      Comment


      • #4
        Originally posted by Lats View Post
        A query to delete calendar events...
        Code:
        DELETE FROM event WHERE userid = X;
        Change X as required.
        Originally posted by Lats View Post
        For picture spam...
        Code:
        DELETE FROM picturecomment WHERE postuserid = X;
        Thanks for the sql.

        But is there any dependency from other tables if i directly execute the delete statement.

        Comment


        • #5
          No, the tables run independently.
          Lats...

          Comment


          • #6
            Thanks.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X