agl666 (@agl666)

Forum Replies Created

Viewing 7 replies - 1 through 7 (of 7 total)
  • I’ve done like you explained.

    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 :).

    Then i’ve created array $old=>$new

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

    echo "
    <pre>";
    foreach($change as $old=>$new){
    echo"
    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;
    ";

    }
    echo"</pre>
    ";

    This script returns SQL code changing old_IDs to new_IDs everywhere (or everywhere I could find) in bb_* tables.

    And, finally, export bb_users and import it to wp_users.

    Note!

    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

    thanks, i had thoughts about it, but hoped that someone already had had that problem and solved ;)

    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?

    HSeatSleeper

    it’s a great idea but you miss something: there are a lot of duplicate IDs and users :)

    _ck_

    Try deactivating a few plugins at a time?

    You now, I’ve deactivated first plugin and edititng started to work :) that plugin was your “Post Count Plus”. Don’t you know that’s the trouble?

    Because that would be a nice one to share with others.

    I also think so, so that I will write it… some day :)

    _ck_

    yes, of course, there’s no topic with 11178. Look:

    1.http://forum.ttl79.ru/edit.php?id=11178

    2.http://forum.ttl79.ru/topic.php?id=11178

    First link points to post #11178 editing page, second to where it redirect. eg. post’s id is used for redirecting to topic.

    To convert minibb base I haven’t writed any script, I’ve converted it simply by exporting db, changing something and importing. It know it was so foolish, but I’ve had a lot of time to play with it :) And you now, it was very easy: structures are so simple and similar ;)

    But as I’ve said, editing doesn’t work even with native bbPress posts (e.g. added via bbpress). If you wish, I can give you db’s dump.

    In reply to: Plugin: Avatar Upload

    Hi! Thanks for such a useful plugin :)

    But unfogtunately I have a little bug, let me name it like that. Profile page have two “Avatar” tabs. Like showed on this screenshot: http://www.picamatic.com/show/2008/08/03/12/741682_804x186.jpg

    What can I do with that?

Viewing 7 replies - 1 through 7 (of 7 total)