Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
Hey Jeremy,

All I did was to modify the threads a bit for the new accounts.

When a new user logs in then the following SQL query is run on the server:
Code
<br />INSERT INTO <yourdatabasename>.user ( <br />userid, username, password, altemail, usergroupid, <br />skinid, realname, regdate, lastvisit, cols, birthday, <br />question, answer, country, state, zip, options, replyto, font, timezone) <br />select U_Number, U_LoginName, U_Password, U_FakeEmail,<br /> 3, '<customskinname>', U_Name, U_Registered, U_LastOn, <br />'a:6:{i:0;s:8:"priority";i:1;s:6:"attach";i:2;s:4:"from";i:3;s:7:"subject";i:4;s:8:"datetime";i:5;s:4:"size";}', <br />'0000-00-00', '', '', 'ot', 'ot', '', '21842', concat( U_loginname, '@<yourdomainname.com>' ), <br />'Verdana|10|Regular|Black|None', U_TimeOffset <br />From w3t_Users<br />where u_number = <thenewusernumber><br />

Just replace the relevant texts in the query included in <> with what your server settings are.

This query puts the user in a validation mode. Once they validate their email you can update the group from 3 to 2 (normal user).

I also modified the Delete User from the admin section to delete the user in both databases/tables and the changebasic.php to update the password field in the user table - to bring it in sync.

The new version 1.2 I think does not use cookies - although don't take my word for it.

It is in my list of things to do to have an automatic login in my webmail if the user has already logged into the threads. Since it is going to be quite some time until I start working on this, I might decide to scrap it and do an email addin for the threads. It might be easier, since I know what I want from a pure integration point of view.


Nikos
Sponsored Links
Entire Thread
Subject Posted By Posted
Hivemail integration msula 03/12/2003 1:05 AM
Re: Hivemail integration dimopoulos 03/14/2003 6:16 AM
Re: Hivemail integration msula 03/16/2003 1:29 AM
Re: Hivemail integration dimopoulos 03/16/2003 2:54 AM
Re: Hivemail integration jluerken 03/17/2003 11:56 AM
Re: Hivemail integration dimopoulos 03/18/2003 1:22 AM
Re: Hivemail integration donJulio 03/25/2003 12:57 AM
Re: Hivemail integration msula 03/26/2003 5:49 AM
Re: Hivemail integration jluerken 03/26/2003 12:23 PM
Re: Hivemail integration AllenAyres 04/19/2003 12:44 AM
Re: Hivemail integration jluerken 07/07/2003 9:27 AM

Link Copied to Clipboard
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
bluehost
InterServer
Visit us on Facebook
Member Spotlight
hatter
hatter
USA
Posts: 69
Joined: January 2001
Forum Statistics
Forums63
Topics37,575
Posts293,932
Members13,824
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,835
Greg Hard 4,625
Top Posters(30 Days)
Gizmo 2
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)