<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="bbPress/1.1" -->
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
		>
	<channel>
		<title>bbPress Support Forums &#187; Topic: Help integrate bbPress users and WordPress MU users</title>
		<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users</link>
		<description>bbPress Support Forums &#187; Topic: Help integrate bbPress users and WordPress MU users</description>
		<language>en-US</language>
		<pubDate>Fri, 25 May 2012 11:28:55 +0000</pubDate>
		<generator>http://bbpress.org/?v=1.1</generator>
				<atom:link href="http://bbpress.org/forums/rss/topic/help-integrate-bbpress-users-and-wordpress-mu-users" rel="self" type="application/rss+xml" />

		<item>
			<title>agl666 on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-63062</link>
			<pubDate>Mon, 11 Jan 2010 17:41:00 +0000</pubDate>
			<dc:creator>agl666</dc:creator>
			<guid isPermaLink="false">63062@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>I've done like you explained.</p>
<p>First, I've exported all IDs into Excel, then fill out new IDs (exactly bigger than can be in WPMU base - starting from 10000), then I searched for duplicate emails in wp_users and bb_users, exported to Excel and changed new_IDs of duplicated users to IDs_from_WPMU (something like that :).</p>
<p>Then i've created array $old=&#62;$new</p>
<pre><code>$change=array(
1=&#62;10001,2=&#62;10002,3=&#62;10003,5=&#62;10004,7=&#62;10005,8=&#62;10006,10=&#62;10007,11=&#62;10008,12=&#62;10009,13=&#62;10010,14=&#62;10011,15=&#62;10012,16=&#62;10013,17=&#62;10014,18=&#62;10015,19=&#62;10016,20=&#62;10017,21=&#62;10018,22=&#62;10019,23=&#62;10020,24=&#62;10021,25=&#62;10022,26=&#62;10023,27=&#62;10024,28=&#62;10025,29=&#62;10026,30=&#62;10027,31=&#62;10028,32=&#62;10029,33=&#62;10030,34=&#62;10031,35=&#62;10032,36=&#62;10033,37=&#62;10034,38=&#62;10035,39=&#62;10036,40=&#62;10037,41=&#62;10038,43=&#62;10039,44=&#62;10040,46=&#62;10041,47=&#62;10042,48=&#62;10043,49=&#62;10044,50=&#62;10045,51=&#62;10046,52=&#62;10047,53=&#62;10048,54=&#62;10049,55=&#62;10050,56=&#62;10051,57=&#62;10052,58=&#62;10053,59=&#62;10054,60=&#62;10055,61=&#62;10056,62=&#62;10057,63=&#62;10058,64=&#62;10059,65=&#62;10060,66=&#62;10061,67=&#62;10062,68=&#62;10063,69=&#62;10064,70=&#62;10065,71=&#62;10066,72=&#62;10067,73=&#62;10068,74=&#62;10069,75=&#62;10070,76=&#62;10071,77=&#62;10072,78=&#62;10073,82=&#62;10074,83=&#62;10075,86=&#62;10076,89=&#62;10077,92=&#62;10078,94=&#62;10079,95=&#62;10080,97=&#62;10081,99=&#62;10082,100=&#62;10083,101=&#62;10084,102=&#62;10085,103=&#62;10086,105=&#62;10087,106=&#62;10088,107=&#62;10089,109=&#62;10090,110=&#62;10091,111=&#62;10092,113=&#62;10093,114=&#62;10094,115=&#62;10095,116=&#62;10096,117=&#62;10097,118=&#62;10098,119=&#62;10099,121=&#62;10100,122=&#62;10101,123=&#62;10102,124=&#62;10103,125=&#62;10104,126=&#62;10105,667=&#62;10106,669=&#62;10107,670=&#62;10108,671=&#62;10109,672=&#62;10110,673=&#62;10111,675=&#62;10112,676=&#62;10113,678=&#62;10114,679=&#62;10115,680=&#62;10116,681=&#62;10117,682=&#62;10118,683=&#62;10119,684=&#62;10120,685=&#62;10121,686=&#62;10122,687=&#62;10123,688=&#62;10124,689=&#62;10125,690=&#62;10126,691=&#62;10127,692=&#62;10128,693=&#62;10129,695=&#62;10130,696=&#62;10131,697=&#62;10132,698=&#62;10133,699=&#62;10134,700=&#62;10135,701=&#62;10136,702=&#62;10137,703=&#62;10138,704=&#62;10139,705=&#62;10140,706=&#62;10141,707=&#62;10142,708=&#62;10143,710=&#62;10144,711=&#62;10145,712=&#62;10146,713=&#62;10147,715=&#62;10148,716=&#62;10149,717=&#62;10150,718=&#62;10151,719=&#62;10152,720=&#62;10153,721=&#62;10154,722=&#62;10155,723=&#62;10156,724=&#62;10157,726=&#62;10158,727=&#62;10159,728=&#62;10160,729=&#62;10161,730=&#62;10162,731=&#62;10163,732=&#62;10164,733=&#62;10165,734=&#62;10166,735=&#62;10167,736=&#62;10168,739=&#62;10169,740=&#62;10170,741=&#62;10171,742=&#62;10172,743=&#62;10173,744=&#62;10174,745=&#62;10175,746=&#62;10176,747=&#62;10177,748=&#62;10178,750=&#62;10179,751=&#62;10180,752=&#62;10181,753=&#62;10182,755=&#62;10183,756=&#62;10184,759=&#62;10185,761=&#62;10186,762=&#62;10187,763=&#62;10188,767=&#62;10189,769=&#62;10190,771=&#62;10191,772=&#62;10192,773=&#62;10193,774=&#62;10194,775=&#62;10195,776=&#62;10196,777=&#62;10197,779=&#62;10198,780=&#62;10199,794=&#62;10200,795=&#62;10201,796=&#62;10202,797=&#62;10203,798=&#62;10204,799=&#62;10205,801=&#62;10206,803=&#62;10207,810=&#62;10208,811=&#62;10209,815=&#62;10210,837=&#62;10211,842=&#62;10212,847=&#62;10213,848=&#62;10214,857=&#62;10215,861=&#62;10216,871=&#62;10217,872=&#62;10218,880=&#62;10219,905=&#62;10220,926=&#62;10221,936=&#62;10222,937=&#62;10223,943=&#62;10224,944=&#62;10225,955=&#62;10226,961=&#62;10227,962=&#62;10228,964=&#62;10229,965=&#62;10230,967=&#62;10231,968=&#62;10232,969=&#62;10233,972=&#62;10234,973=&#62;10235,974=&#62;10236,976=&#62;10237,977=&#62;10238,978=&#62;10239,979=&#62;10240,980=&#62;10241,981=&#62;10242,982=&#62;10243,983=&#62;10244,985=&#62;10245,987=&#62;10246,988=&#62;10247,993=&#62;10248,994=&#62;10249,996=&#62;10250,997=&#62;10251,998=&#62;10252,999=&#62;10253,1000=&#62;10254,1001=&#62;10255,1002=&#62;10256,1003=&#62;10257,1008=&#62;10258,1011=&#62;10259,1018=&#62;10260,1019=&#62;10261,1021=&#62;10262,1024=&#62;10263,1061=&#62;10264,1062=&#62;10265,1063=&#62;10266,1064=&#62;10267,1065=&#62;10268,1073=&#62;10269,1074=&#62;10270,1076=&#62;10271,1077=&#62;10272,1078=&#62;10273,1090=&#62;10274,1091=&#62;10275,1092=&#62;10276,1093=&#62;10277,1094=&#62;10278,1096=&#62;10279,1097=&#62;10280,1098=&#62;10281,1099=&#62;10282,1101=&#62;10283,1102=&#62;10284,1103=&#62;10285,1104=&#62;10286,1128=&#62;10287,1129=&#62;10288,1130=&#62;10289,1131=&#62;10290,1132=&#62;10291,1133=&#62;10292,1135=&#62;10293,1136=&#62;10294,1137=&#62;10295,1138=&#62;10296,1139=&#62;10297,1140=&#62;10298,1143=&#62;10299,1144=&#62;10300,1145=&#62;10301,1212=&#62;10302,1408=&#62;10303,1410=&#62;10304,1412=&#62;10305,1413=&#62;10306,1415=&#62;10307,1416=&#62;10308,1417=&#62;10309,1418=&#62;10310,1419=&#62;10311,1420=&#62;10312,1421=&#62;10313,1422=&#62;10314,1423=&#62;10315,1424=&#62;10316,1425=&#62;10317,1426=&#62;10318,1427=&#62;10319,1428=&#62;10320,1429=&#62;10321,1430=&#62;10322,1431=&#62;10323,1432=&#62;10324,1433=&#62;10325,1434=&#62;10326,1435=&#62;10327,1436=&#62;10328,1437=&#62;10329,1438=&#62;10330,1439=&#62;10331,1440=&#62;10332,1441=&#62;10333,1442=&#62;10334,1443=&#62;10335,1444=&#62;10336,1445=&#62;10337,1446=&#62;10338,1447=&#62;10339,1448=&#62;10340,1449=&#62;10341,1450=&#62;10342,
10001=&#62;5,10002=&#62;31,10050=&#62;1095,10205=&#62;22,10267=&#62;23,10055=&#62;2,10274=&#62;40,10280=&#62;32,10306=&#62;15,10303=&#62;1096,10314=&#62;29,10322=&#62;11,10327=&#62;9,10325=&#62;35,10341=&#62;1092);

echo &#34;
&#60;pre&#62;&#34;;
foreach($change as $old=&#62;$new){
echo&#34;
UPDATE bb_users SET ID=$new WHERE ID=$old;
UPDATE bb_usermeta SET user_id=$new WHERE user_id=$old;
UPDATE bb_topics SET topic_poster=$new WHERE topic_poster=$old;
UPDATE bb_topics SET topic_last_poster=$new WHERE topic_last_poster=$old;
UPDATE bb_term_relationships SET user_id=$new WHERE user_id=$old;
UPDATE bb_posts SET poster_id=$new WHERE poster_id =$old;
&#34;;

}
echo&#34;&#60;/pre&#62;
&#34;;</code></pre>
<p>This script returns SQL code changing old_IDs to new_IDs everywhere (or everywhere I could find) in bb_* tables.</p>
<p>And, finally, export bb_users and import it to wp_users.</p>
<p>Note!<br />
Use "Complete inserts" and REPLACE or UPDATE instead of INSERT, otherwise you will get 1) incomplete query (cause wp_users have 2-3 additional columns) 2)"duplicatу key" error
</p>]]></description>
					</item>
		<item>
			<title>Hard Seat Sleeper on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-63059</link>
			<pubDate>Mon, 11 Jan 2010 17:03:35 +0000</pubDate>
			<dc:creator>Hard Seat Sleeper</dc:creator>
			<guid isPermaLink="false">63059@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>Yes sorry, I should have explained more.</p>
<p>I just did something similar with a single install of wp.</p>
<p>Keep in mind that when you use wp for user data, it will use all the ids in the wp_users table. When you click the option to use that db for user data, it doesn't merge anything at all! So for example, if one user has an id of 5 in bbpress, when you use the wp db for user data whoever is 5 in that db suddenly gets the bbpress guy's data.</p>
<p>So! To get your data into shape, what you need to do is map the bbpress guys to the wp guys. So 5 in wp should be the same guy in bbpress. You might need to change the id of that user in the bbpress db.</p>
<p>Also! there is a bbpress user metadata table, so be sure to change the id there, too.</p>
<p>This is how I tackled it. There might be an easier way, or some tool, but if there is, I couldn't find it. I just did some SQL on the db directly to get it structured as I needed it, then turned on integration.
</p>]]></description>
					</item>
		<item>
			<title>agl666 on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-63004</link>
			<pubDate>Sun, 10 Jan 2010 11:34:23 +0000</pubDate>
			<dc:creator>agl666</dc:creator>
			<guid isPermaLink="false">63004@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>thanks, i had thoughts about it, but hoped that someone already had had that problem and solved ;)
</p>]]></description>
					</item>
		<item>
			<title>chrishajer on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62993</link>
			<pubDate>Sun, 10 Jan 2010 03:05:13 +0000</pubDate>
			<dc:creator>chrishajer</dc:creator>
			<guid isPermaLink="false">62993@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>I think conceptually you're going to need to renumber some members, and then change all the places where their old ID was being used, to the new ID.
</p>]]></description>
					</item>
		<item>
			<title>agl666 on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62981</link>
			<pubDate>Sat, 09 Jan 2010 23:00:39 +0000</pubDate>
			<dc:creator>agl666</dc:creator>
			<guid isPermaLink="false">62981@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>but duplicates, owing some content! for example, if ceronimo of WPMU (ID# 23) have comments in WPMU and ceronimo of bbPress (ID# 333) have topics in bbPress, what to do then?
</p>]]></description>
					</item>
		<item>
			<title>Hard Seat Sleeper on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62980</link>
			<pubDate>Sat, 09 Jan 2010 22:37:02 +0000</pubDate>
			<dc:creator>Hard Seat Sleeper</dc:creator>
			<guid isPermaLink="false">62980@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>Yes, remove the duplicates.
</p>]]></description>
					</item>
		<item>
			<title>agl666 on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62953</link>
			<pubDate>Fri, 08 Jan 2010 22:36:04 +0000</pubDate>
			<dc:creator>agl666</dc:creator>
			<guid isPermaLink="false">62953@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>HSeatSleeper</p>
<p>it's a great idea but you miss something: there are a lot of duplicate IDs and users :)
</p>]]></description>
					</item>
		<item>
			<title>Hard Seat Sleeper on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62952</link>
			<pubDate>Fri, 08 Jan 2010 22:30:07 +0000</pubDate>
			<dc:creator>Hard Seat Sleeper</dc:creator>
			<guid isPermaLink="false">62952@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>agl666 I'm no whiz but i would export both databases and merge them into an sql file, then dump back into your wpmu install. This will be a tricky operation, but unless someone else has a better idea I see no other way to do it.
</p>]]></description>
					</item>
		<item>
			<title>agl666 on "Help integrate bbPress users and WordPress MU users"</title>
			<link>http://bbpress.org/forums/topic/help-integrate-bbpress-users-and-wordpress-mu-users#post-62928</link>
			<pubDate>Fri, 08 Jan 2010 14:41:00 +0000</pubDate>
			<dc:creator>agl666</dc:creator>
			<guid isPermaLink="false">62928@http://bbpress.org/forums/</guid>
			<description><![CDATA[<p>Hi!</p>
<p>I have a forum running on bbPress and a WordPress MU, which I installed later. Both have users, some of them is present in both bases. </p>
<p>So, we have two bases with some duplicate IDs and users. How can I integrate bbPress users into a WPMU database with less price?</p>
<p>Thanks
</p>]]></description>
					</item>

	</channel>
</rss>

