MultiPLIGG

[submitlink]

I have almost set up my 2 pligg sites... YAH!


I would like to save my users time by allowing them to have the same user/login info for each site.


Maybe this would be a good idea to have as admin feature so we can allow niche pliggs sites or subdomains.... kinda like what team sugar does.


.....

some other great features of digg, teamsugar, etc

whos online
users pligg blogg
post my story to my blogg (requires user to fill out his blog login)

[en3r0]

I don't think its to hard to do, just configure the user tables to work together... not sure how to do that though.

[silversow]

I was thinking about doing this too. It would be nice if there was a central database somewhere (maybe here) that all Pligg sites that wished to could use. Some kind of Pligg-net where anytime a user joins a participating Pligg site their login and password are duplicated in this central database that all the sites can use. I'm not sure if this is far fetched though.

[Yankidank]

I did this on one of my sites that I'll probably never get around to finishing. It's pretty simple to setup, but you will need to have the user table installed on the same database name on both of your pligg installs. I set it up so that it would share the user names/passwords, private messages and friends list between several Pligg installs that all get their information from the same database. I will write up a detailed post about what I did on the Pligg blog sometime soon.

For now I will give you a brief example, by demonstrating what you can do.


Open config.php and edit lines 134-147. If you just want to only share user names and passwords between your sites you will need to edit line 141.

Step 1
Create a new database table global_users.
Log in to phpmyadmin and insert this sql into your database:
These settings do not apply to all language variations or Pligg versions, a more accurate way to do this is to just rename your pligg_users table to global_users. If you rename pligg_users to global_users you can skip this step.

CREATE TABLE `global_users` (
  `user_id` int(20) NOT NULL auto_increment,
  `user_login` varchar(32) NOT NULL default '',
  `user_level` enum('normal','special','blogger','admin','god') NOT NULL default 'normal',
  `user_modification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `user_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `user_pass` varchar(64) NOT NULL default '',
  `user_email` varchar(128) NOT NULL default '',
  `user_names` varchar(128) NOT NULL default '',
  `user_lang` int(11) NOT NULL default '1',
  `user_karma` decimal(10,2) default '10.00',
  `user_url` varchar(128) NOT NULL default '',
  `user_lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `user_aim` varchar(64) NOT NULL default '',
  `user_msn` varchar(64) NOT NULL default '',
  `user_yahoo` varchar(64) NOT NULL default '',
  `user_gtalk` varchar(64) NOT NULL default '',
  `user_skype` varchar(64) NOT NULL default '',
  `user_irc` varchar(64) NOT NULL default '',
  `public_email` varchar(64) NOT NULL default '',
  `user_avatar_source` varchar(255) NOT NULL default '',
  `user_ip` varchar(20) default '0',
  `user_lastip` varchar(20) default '0',
  `last_reset_request` timestamp NOT NULL default '0000-00-00 00:00:00',
  `user_location` varchar(255) default NULL,
  `user_occupation` varchar(255) default NULL,
  `google_adsense_id` varchar(64) NOT NULL,
  `google_adsense_channel` varchar(64) NOT NULL,
  `google_adsense_percent` tinyint(3) unsigned NOT NULL default '50',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_login` (`user_login`),
  KEY `user_email` (`user_email`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

INSERT INTO `pligg_users` (`user_id`, `user_login`, `user_level`, `user_modification`, `user_date`, `user_pass`, `user_email`, `user_names`, `user_lang`, `user_karma`, `user_url`, `user_lastlogin`, `user_aim`, `user_msn`, `user_yahoo`, `user_gtalk`, `user_skype`, `user_irc`, `public_email`, `user_avatar_source`, `user_ip`, `user_lastip`, `last_reset_request`, `user_location`, `user_occupation`) VALUES (1, 'god', 'god', '2007-02-08 20:40:43', '2007-02-04 00:01:44', '1e41c3f5a260b83dd316809b221f581cdbba8c1489e6d5896', 'blank@pligg.com', '', 1, 10.00, 'www.pligg.com', '2007-02-08 20:40:43', '', '', '', '', '', '', '', '', '0', '68.51.132.108', '0000-00-00 00:00:00', '', '');

Step 2
Find:

PHP Code:

if(!defined('table_users')){ define('table_users', table_prefix . "users" ); } 


Replace with:

PHP Code:

if(!defined('table_users')){ define('table_users', "global_users" ); } 


As you can see I replaced

PHP Code:

table_prefix . "users" 


with:

PHP Code:

"global_users" 


Repeat these steps for each table that you wish to share across multiple Pligg installs.

If many people express interest in having a global pligg user database please let us know so we can look into it.

[sanch]

Thanks! This opens up some interesting possibilities!

Looking forward to the detailed write up.

[submitlink]

I made a donation today ... paypal shows it went out... I then got the thankyou for your donation of $0.00 page = odd

It was thanks for helping on the multipligg idea

Other functions that id love to see/donate for...

1 whos online
2 paypal donate for articles like http://www.plugim.com/story/Why_Bots...es_My_Opinion/

3 integrate multipligg users db
4. users can create their own blog

... ill think of more

[dollars5]

user blogs - is what I am looking forward too.

[Aqui]

i really believe the only 'safe' implementation for this is thru openid , i made a suggestion earlier abt developing a mod using openid here:

http://www.pligg.com/forum/showthread.php?t=3600

if some one can make this happen, it wud b really great =]

[submitlink]

I am talking about my users using their same id for only my pligg sites... not a free for all.

[lcct83]

i have already installed two of my seperate pligg sites. and both of them have been inserted with lots of news.

both of the are on the same server sharing the same mysql database, only different prefixes.

now, a user of my site has pointed out that I should combine the both together in terms of username/password, private messages and friends lists.

so now i'm stuck. Can someone please point out how I could solve this predicament? ;-P