Announcement

Collapse
No announcement yet.

Member total dropped??

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

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

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


    • #3
      Originally posted by Lynne View Post
      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


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


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

          Comment


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

            Comment


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


              • #8
                Originally posted by Lynne View Post
                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


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


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


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

                      Comment


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


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

                          Matt Olieman
                          MyCockpit.org

                          Comment


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


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

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