Page 1 of 1

Integrate your software with my User Manager

Posted: Tue Apr 26, 2005 5:09 pm
by esqueleto
Hello

I have a community WebSite where i give some features to my comunity. The users of the WebSite alredy have a login and password to access the features that I provide.

how can I integrate your BLOG with my User Table. I don't want them to create another record in you blog system, I want them to use the one they have to access you system.

There is any API to do that?

Specifications:
WebServer: Apache
Language: PHP
Database: MySQL


tkx in advance
Esqueleto
Odivelas - Portugal

Re: Integrate your software with my User Manager

Posted: Tue Apr 26, 2005 5:26 pm
by garvinhicking
There is no API for this specific issue. Serendipity needs its own user table, you cannot bypass it because there are many DB SQL joins involved which need to be joined to the serendipity_authors table.

But I suggest you to look at the http://cvs.sourceforge.net/viewcvs.py/p ... ernalauth/ plugin. This plugin mirrors LDAP user accounts to the Serendipity user account table on request.

You could build a similar synchronization feature using your own MySQL database lookup instead of a LDAP lookup.

Another approach, but a hard one, would be to match your usertable with the columns in serendipity_authors and then rename your usertable to serendipity_authors and adapt your own interface to use the authors table to query your useraccounts. Of course your "new" authors table can have more columns which may not be needed by Serendipity but by your application.

Regards,
Garvin

The way!!!

Posted: Thu Apr 28, 2005 3:16 am
by esqueleto
My big problem is when the user change from our framework to your blog framework.

I really don't know how that can be possible and I really don't undestand the example in the link that you give me.

can you explain it a bit more in detail ???


(())
Esqueleto
Odivelas - Portugal

MySQL table

Posted: Thu Apr 28, 2005 3:19 am
by esqueleto
I will use my own MySQL table where my users will be with the columns (example)

Table: MyUserTable
UserID AS int with auto_increment
Name AS varchar(50) NOT NULL
HaveBlog AS bit with default 0

Can you please explain how can i can make the bridge for you BLOG system?


Tkx in advance
(())
Esqueleto
Odivelas - Portugal

Re: MySQL table

Posted: Thu Apr 28, 2005 2:27 pm
by garvinhicking
Which bridge method do you want to use?



1. The hard way of database adjustment to one solution

2. The easy way of user cloning like the LDAP plugin does but which creates duplicate tables

Please look at the externalauth plugin. If you do not understand its example, I must admit you'll not be able to go the whole way to make it work, I'm sorry.

Yours is a very special need which is dependant on your used framework, so you'll either have to programm it yourself or you could hire a programmer (or find one for free) who could do your special work...

Regards,
Garvin