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
 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'Wink;
INSERT INTO myuser VALUES ('username1', 'password1'Wink;
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
 Quote

Mike D

Anonymous
Robin thank you sooo much!! Big Grin
I cant wait to try it!
- Mike
 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