No announcement yet.

What is correct query to set automatic Update Counter?

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #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
    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


    • #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.


      • #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,
        Microsoft Office Discussion


        • #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


          • #6
            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?


            • #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*
              *PM - Add ability to reply to originator only*
              - Add Admin ability to auto-subscribe users to specific channel(s)
              - "Quick Route" Interface...


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


                • #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.


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