UBB.Developers Forums UBB.classic V6.4 - 6.7 Modifications V6 Mod Ideas Integrating UBB Member List and SQL database

I would advise holding off on your conversion until 6.3 is out the door.

One of the roadblocks to doing this is the reliance on memberslist's existance.. and memberslist is the slowest part of the member profile system.

6.3's code alters all routines that access memberslist to call other routines, which then can be modified to 'create' a memberslist from a query rather than reading it off disk. (Then the new FileExists routine can be modified to always return true when it's checking the memberslist, emailfile, pdns, etc)

I have already completed much work on a conversion, but can not release it for public consumption in its current form....

Here's the latest copy of the member file field specification:

1 User name
2 Password
3 Email Address
4 URL
5 Permissions Line
6 Occupation
7 Location
8 Post count
9 Status (Admin|Mod|Member)
10 Interests
11 Reg Date (MM-DD-YYYY)
12 Email View (yes|no)
13 Signature
14 ICQ UIN
15 Allow Mass Mail (yes|no)
16 Public Display Name
17 Custom Field 1
18 Custom Field 2
19 Custom Field 3
20 Custom Field 4
21 Picture URL
22 DaysPrune
23 AIM ID
24 Last edit information
25 Profile locked? (yes|no)
26 Allow User Ratings (yes|no)
27 Awaiting Moderation Queue? (Q|)
28 Allow Incoming PMs? (yes|no)
29 Notify on email on PM? (yes|no)
30 Admin allows to SEND PMs? (yes|no)
31 Last Post Information (YYYYMMDD|forum|thread|post|IP)
32 Admin-assigned user title
33 Birth Date|Allow others to view bdate
34 Parental email if COPPA
35 Registration IP
36 User is invisible to Who's Online
37 Ban user from polling (1 = yes)
38 Relative or abs URL to user Avatar
39 Lock user avatar (1 = yes) | No user avatar (1 = yes) | User hides other avatars (1 = yes)