No announcement yet.

Userid the unique key? Please confirm

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Userid the unique key? Please confirm

    For my newly established vBulletin forum which is part of an overall owner site, I now have included and tested sucessfully the database manager implementation for site users to change their vBulletin forum username.

    Please confirm whether the userid is the unique key all over the publishing suite 4.0.7 including it's forum and it's blog etc. Just for me to know that there isn't any username references in any table (but userid references only) somewhere out in the big outer vBulletin space.

  • #2
    All sections look at the UserID, not the username
    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...


    • #3
      Just for info:
      There are some tables/areas where vB also save the username


      BUT when you rename somebody in the acp, vB updates all the old names (for more info, check the user datamanager update_username method.

      It's possible that some add-ons could break the system, if they aren't coded professional, but as said, vB updates the standardentries automatically


      • #4
        Thanks for the information.

        I would expect all the references to be based on userid as Trevor tells.

        So the reason for vBulletin to refer to username also in other tables than the user table itself seems quite strange as long as the userid is the key.

        Hopefully, the userid will be a complete unique key in next version. Otherwise, the system is a little (or big may) bit confusing.


        • #5
          The userid is unique!

          The usernames in the tables are IMHO needed because of the performance.
          If you wouldn't save them in other tables, you would need to join the usertable for every query, where the username is needed


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