Member total dropped??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SonicGT
    Member
    • May 2006
    • 90
    • 3.7.x

    [Forum] Member total dropped??

    I just noticed in my forum that I just dropped 16 total members, I didn't think users could delete themself, not sure how this happened. Does it prune members at any point, is there a setting for this? Never saw this happen with 3.x
    Chicago Area Mustang Club
    http://www.windycitystangs.com

    Forums and information about the Next Generation of Muscle Cars
    http://www.nextgenmusclecars.com
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    vB4.0.3 no longer counts users in usergroups 3 or 4 in the total count (nor are they listed as online users).

    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

    • smirkley
      Senior Member
      • Feb 2008
      • 525
      • 4.0.0

      #3
      Originally posted by Lynne
      vB4.0.3 no longer counts users in usergroups 3 or 4 in the total count (nor are they listed as online users).
      Now thats what were talkin' bout!

      Comment

      • SonicGT
        Member
        • May 2006
        • 90
        • 3.7.x

        #4
        After digging a little bit I did see that my drop was by exactly the number in the "awaiting email confirmation" group, so figured it was something like that. Thanks for the confirmation
        Chicago Area Mustang Club
        http://www.windycitystangs.com

        Forums and information about the Next Generation of Muscle Cars
        http://www.nextgenmusclecars.com

        Comment

        • hsamet
          New Member
          • Dec 2006
          • 7

          #5
          How can I make it like before
          which file I have to edit
          ?

          Comment

          • molieman
            Senior Member
            • Nov 2006
            • 171
            • 4.0.0

            #6
            Originally posted by hsamet
            How can I make it like before
            which file I have to edit
            ?
            I certainly would be interested in that too.

            Comment

            • Lynne
              Former vBulletin Support
              • Oct 2004
              • 26255

              #7
              I've posted this before, but have not tried it myself:
              In forum.php, remove this line around line 475:
              PHP Code:
              AND (user.usergroupid NOT IN (3,4) OR user.usergroupid IS NULL
              And again in in /includes/functions_databuild.php around line 1827, remove this line:
              PHP Code:
                      WHERE
                      usergroupid NOT IN 
              (3,4
              I *think* that will do what you want. (The total number is in the datastore and I dont' think it will be updated until a new user registers.)
              Last edited by Lynne; Fri 30 Apr '10, 10:34am.

              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

              • molieman
                Senior Member
                • Nov 2006
                • 171
                • 4.0.0

                #8
                Originally posted by Lynne
                I've posted this before, but have not tried it myself:
                Thanks for reposting it Lynne. Obviously I missed it the first time.

                Matt Olieman
                MyCockpit.org

                Comment

                • molieman
                  Senior Member
                  • Nov 2006
                  • 171
                  • 4.0.0

                  #9
                  Since I've removed the two lines as suggested by Lynne I've been getting Database Errors, such as the one below. Lynne or anyone else, could this be related to the removal of the lines?

                  Also, I am now not able to create a list of "Users Awaiting Email Confirmation" from the ADMINCP and had a report from one member who registered and did not recieve the confirmation Email.

                  Just wondering if this may be related?

                  ========================
                  SELECT
                  SUM(IF(lastvisit >= 1264850402, 1, 0)) AS active,
                  COUNT(*) AS users,
                  MAX(userid) AS maxid
                  FROM vbuser
                  WHERE;

                  MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
                  Error Number : 1064
                  Request Date : Friday, April 30th 2010 @ 07:20:02 AM
                  Error Date : Friday, April 30th 2010 @ 07:20:02 AM
                  Script : http://www.mycockpit.org/forums/regi...p?do=addmember
                  Referrer : http://www.mycockpit.org/forums/regi...p?do=addmember
                  IP Address : 41.184.18.124
                  Username : Ancell
                  Classname : vB_Database
                  MySQL Version :

                  ==========================

                  Comment

                  • molieman
                    Senior Member
                    • Nov 2006
                    • 171
                    • 4.0.0

                    #10
                    I put the lines back in and the Database Errors have stopped.

                    Is there something I can do to prevent the Database Errors?

                    Comment

                    • Ramsesx
                      Senior Member
                      • Aug 2005
                      • 3254
                      • 3.8.x

                      #11
                      What makes it worth to get this two groups listed?
                      .......

                      Comment

                      • Lynne
                        Former vBulletin Support
                        • Oct 2004
                        • 26255

                        #12
                        Whoops, see this is what happens when nobody has given me feedback on my suggestion. You should actually remove these two lines in functions_databuild.php (line 1827):

                        PHP Code:
                                WHERE
                                usergroupid NOT IN 
                        (3,4
                        (changed above)

                        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

                        • molieman
                          Senior Member
                          • Nov 2006
                          • 171
                          • 4.0.0

                          #13
                          Lynne, thanks again, I'll let you know how it works out.

                          Matt Olieman
                          MyCockpit.org

                          Comment

                          • chris15440
                            Member
                            • Mar 2010
                            • 87
                            • 4.0.0

                            #14
                            I figured I would chime in on this. I tried what Lynne said and it worked, until a new member signs up and then it causes the "Welcome to our newest member" to show a blank reading. Then after another member signs up, it will display their username correct. Kinda a intermittent problem. You can hover over where the username should be and if you click the link it takes you to a random username. So if anyone doesn't mind this happening, it works well at showing the total amount of users that have joined the forum, but does cause issues with the newest member readout showing up correctly...

                            Comment

                            • Bounce
                              Senior Member
                              • Feb 2005
                              • 640
                              • 4.2.x

                              #15
                              No offence but what a crappy way to have this done like this, there should be a setting for you to choose if you want everyone registering to show or not without having to edit php files.

                              Comment

                              Related Topics

                              Collapse

                              Working...