Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 12:54 pm EST
Geeklog Forums
Existing User Database
Mike D
Anonymous
Dear Forum,
I currently run a website, and I would like my users to have access to the GeekLog as an additional set of features. If it is possible I would like them to not have to sign up again to use GeekLog.
Here is the setup of my current user database:
Name: pbf_database
Table: myuser
In this table listed are the users username and password under the following listings:
Username: usrUsrName
Password: usrUsrPaswd
In summary, I am asking how to setup GeekLog so that it pulls registration information from the existing database OR the SQL command to pull this information out of the current database and add it to the GeekLog database.
Also, is it possible for GeekLog to share the same user cookie as my existing site, so that users dont even have to log in again?
Thanks,
Mike D
I currently run a website, and I would like my users to have access to the GeekLog as an additional set of features. If it is possible I would like them to not have to sign up again to use GeekLog.
Here is the setup of my current user database:
Name: pbf_database
Table: myuser
In this table listed are the users username and password under the following listings:
Username: usrUsrName
Password: usrUsrPaswd
In summary, I am asking how to setup GeekLog so that it pulls registration information from the existing database OR the SQL command to pull this information out of the current database and add it to the GeekLog database.
Also, is it possible for GeekLog to share the same user cookie as my existing site, so that users dont even have to log in again?
Thanks,
Mike D
7
4
Quote
Status: offline
Robin
Forum User
Full Member
Registered: 02/15/02
Posts: 725
I would do the following to achieve that:
Using for example phpMyAdmin, I'd export (data only) the existing table myuser and save as file.
You would get something like this:
INSERT INTO myuser VALUES ('username', 'password';
INSERT INTO myuser VALUES ('username1', 'password1';
and so on
then you would need to edit it to something like this:
INSERT INTO gl_users VALUES ('','username', '', 'password', NULL, NULL, '', '0000-00-00 00:00:00', 0, NULL, NULL, NULL, NULL);
INSERT INTO gl_users VALUES ('','username1', '', 'password2', NULL, NULL, '', '0000-00-00 00:00:00', 0, NULL, NULL, NULL, NULL);
and so on
After you completed the changes, save the file and upload it to Geeklog database via for example phpMy Admin. Click on SQL tab -> Location of the textfile : -> Browse -> Go
Voila
Should be ok
Unfortunately I don't know about the cookies.
Geeklog Polish Support Team
Using for example phpMyAdmin, I'd export (data only) the existing table myuser and save as file.
You would get something like this:
INSERT INTO myuser VALUES ('username', 'password';
INSERT INTO myuser VALUES ('username1', 'password1';
and so on
then you would need to edit it to something like this:
INSERT INTO gl_users VALUES ('','username', '', 'password', NULL, NULL, '', '0000-00-00 00:00:00', 0, NULL, NULL, NULL, NULL);
INSERT INTO gl_users VALUES ('','username1', '', 'password2', NULL, NULL, '', '0000-00-00 00:00:00', 0, NULL, NULL, NULL, NULL);
and so on
After you completed the changes, save the file and upload it to Geeklog database via for example phpMy Admin. Click on SQL tab -> Location of the textfile : -> Browse -> Go
Voila
Should be ok
Unfortunately I don't know about the cookies.
Geeklog Polish Support Team
7
9
Quote
Mike D
Anonymous
Robin thank you sooo much!!
I cant wait to try it!
- Mike
I cant wait to try it!
- Mike
9
24
Quote
All times are EST. The time is now 12:54 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content