Previous Thread
Next Thread
Print Thread
Rate Thread
Integrate Membership Database? #312815
01/20/2007 12:07 AM
01/20/2007 12:07 AM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
Has anyone worked on integrating a "membership database" to Threads? I'm looking at something that could be used for online updating of member data for approximately 8,000 members. Initially only looking for simple reports and mailing labels.

Is there an off-the-shelf package that gets good ratings for doing this? And is there a hosting company that anyone recommends? Lastly are any developers here engaged in this type of support already?


Bill Barker
Issaquah, Wa
Sponsored Links
Re: Integrate Membership Database? [Re: Bill B] #312820
01/20/2007 1:12 AM
01/20/2007 1:12 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Hosting I push on vps' for larger sites; and generally recommend:
www.webintellects.com
www.powervps.com

As for integration, ian just published an addon which allows admins to code scripts to read the cookies and member data.



UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: Integrate Membership Database? [Re: Gizmo] #312889
01/24/2007 3:29 PM
01/24/2007 3:29 PM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
So, I've already hosted my Threads site at webintellects. What I'm looking for now is information on any "turn key packages" that might be available.... or anyone who does this for a living (full or part time).

My needs are to add a "membership" database for online access of limited member data in order to produce mailing labels and reports.

Ideally I'd like to also link this to the Threads database in order to manage the two user accounts together.


Bill Barker
Issaquah, Wa
Re: Integrate Membership Database? [Re: Bill B] #312893
01/24/2007 4:55 PM
01/24/2007 4:55 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
hmm.. so basically you are wanting to make mailing labels off the threads member data. The location info would need to be worked out and people would need to use their real names in one of the fields unless you would be ok with mailing "Gizmo" or "drkknight" smile


- Allen wavey
- What Drives You?
Re: Integrate Membership Database? [Re: AllenAyres] #312896
01/25/2007 1:07 AM
01/25/2007 1:07 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
I like mail :nod:


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Sponsored Links
Re: Integrate Membership Database? [Re: Gizmo] #312899
01/25/2007 1:13 AM
01/25/2007 1:13 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
I sat here thinking about this; what you COULD do...

Enforce users to set 3 of the custom profile boxes:
Box1: Real Name
Box2: Address
Box3: City, State, Zip

Then hack those boxes out of the showprofile screen so random users can't view them...

Now you have your mailing list data merged with threads, whammo! :x


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: Integrate Membership Database? [Re: Gizmo] #312933
01/27/2007 8:31 PM
01/27/2007 8:31 PM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
What if you had a second MySQL db running and loaded it with the real users names and addresses, and then included a field which matched the USER NUMBER to the one in the Threads db. That would "link" the records together.

But actually I want it to work in reverse, where I add a flag (eg. Paid up member="yes") to the user db, and then when they logged into Threads, it would authorized them depending upon the state of the paid-up member status.

So.. would two databases be a good way to go?


Bill Barker
Issaquah, Wa
Re: Integrate Membership Database? [Re: Bill B] #312937
01/28/2007 12:14 AM
01/28/2007 12:14 AM
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
Gizmo Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Gizmo  Offline

UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,938
Portland, OR, USA
UBB 7.2 will include "some sort of" a paid membership option utilizing PayPal (iirc from rick's stating at ubbcentral); but if you're wanting to go the route i'd go with a seperate table indicating new information (no real reason to utilize a second database) then you could just link/join things; however it'd be integrating those options into UBB.T which would be your hurtle, pulling data from the UBB.T databases to a 3rd party script would be easy.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, UBB.Sitemaps
Re: Integrate Membership Database? [Re: Gizmo] #312955
01/28/2007 11:30 PM
01/28/2007 11:30 PM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
Thanks. I appreciate your comments.


Bill Barker
Issaquah, Wa
Re: Integrate Membership Database? [Re: Bill B] #318206
09/12/2009 1:16 AM
09/12/2009 1:16 AM
Joined: Dec 2001
Posts: 84
Issaquah, WA
Bill B Offline OP
Power User
Bill B  Offline OP
Power User
Joined: Dec 2001
Posts: 84
Issaquah, WA
I'm baaaack!!! :-)

We have the second database (membership) up and running now. All of these 8,000 accounts are valid members. After they log in to the membership database (MySQL) and establish a session variable, how can I easily redirect them to my UBB Threads forum so that they are already logged in?

To complicate this a bit more, they are in two different domains.


Bill Barker
Issaquah, Wa
Sponsored Links

Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with, and recommend, the following Web Hosts:
· Stable Host
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,170
Joined: July 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 728
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 19
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.053s Queries: 15 (0.022s) Memory: 3.2994 MB (Peak: 3.4871 MB) Zlib enabled. Server Time: 2018-06-20 05:26:59 UTC