What is correct query to set automatic Update Counter?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • toplisek
    Senior Member
    • Jan 2006
    • 271

    What is correct query to set automatic Update Counter?

    What is correct query to set automatic Update Counter? Is this possible as movement of registered users can be set with query which is very good (fast) solution.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    Updating Counters should only be done if there is a problem. If you have a continuous problem that requires you to always update counters, then you should be fixing this problem, not using the bandaid all the time.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • toplisek
      Senior Member
      • Jan 2006
      • 271

      #3
      Sorry.This is actually not correct. Issue is the following. We have SPAM users (1000 per month). If you imagine that these users post SPAM messages (will not disclose what) than you understand issue with updated search content,counters...
      If I do PRUNE (empty all messages for particular users) which can not be done by QUERY (one click), than all content is still inside forum as it is not updated counter. I have tested and seen all values still in the forum even I click PRUNE.

      Comment

      • Simon Lloyd
        Senior Member
        • Apr 2008
        • 610
        • 3.7.x

        #4
        Are you pruning users or posts? do these spammers reside in one particular usergroup? why haven't you employed any of the antispam techniques,?, it would save you a world of trouble
        Kind regards,
        Simon
        Microsoft Office Discussion

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 74132

          #5
          If you prune the posts from these users or Permanently delete them when you handle them on the user end, then the counters are updated as part of those processes.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • toplisek
            Senior Member
            • Jan 2006
            • 271

            #6
            Interesting:
            why haven't you employed any of the antispam techniques,?

            Can you please explain more these techniques?

            We have set checkbox (requested) that anybody can be only from one country (too man SPAM e-mail addresses)
            We have registration CAPTCHA verification code
            We have automatic movement of registered users to SPAM users (hidden query)
            We have confirmed e-mail message when user is registered

            Do you know additional?

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24358
              • 5.7.X

              #7
              Please see this thread for the things you can do to fight spam and registration bots:

              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • Simon Lloyd
                Senior Member
                • Apr 2008
                • 610
                • 3.7.x

                #8
                Adding to Trevor's note, the best one to use is the Q&A IMHO, it works really well!
                Kind regards,
                Simon
                Microsoft Office Discussion

                Comment

                • Riasat
                  Senior Member
                  • Aug 2006
                  • 4013

                  #9
                  Refer to above for counter measures to prevent spammers from getting in.

                  If they get in (only a few), select any of their spam -> delete as spam -> ban, delete all posts, submit to antispam (if available) -> proceed.

                  Comment

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