Search Results for 'test'
-
Search Results
-
I have recently migrated my entire phpBB over to bbPress and now want to move the bbPress users into wordpress mu so I can use wordpress integration the problem was that there is no easy way to migrate and check the users aren’t doubling up…
I wrote a simple php script to do just that and it allowed me to list out the users where manual attention is required, it can be run just from the command line like this…. ‘php -f file.php’ and will move the users over perfectly (at least for me)…
Note there has been no testing of this code it worked for me and may cause you issues, back up your database first!
Comments on the code appreciated for future improvement.
‘<?php
echo “n”;
echo “+
+n”;echo “| bbPress to WordPress User Migration |n”;
echo “+
+n”;echo “| Created by: |n”;
echo “| Tom Lynch |n”;
echo “+
+n”;echo “n”;
echo “Messages:n”;
echo “n”;
echo “Username Messagen”;
echo ”
n”;function printSpaces($username) {
$spaces = 25 – strlen($username);
echo $username;
for ($i = 0; $i < $spaces+1; $i++) {
echo ” “;
}
}
// Enter your database host, username and password here…
mysql_connect(‘localhost’, ‘username’, ‘password’);
// Enter your database name here (both tables must be in same database – sorry)
mysql_select_db(‘database’);
$migrated = 0;
$errors = 0;
$query = mysql_query(“SELECT user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_status, display_name FROM bb_users WHERE user_pass LIKE ‘$P$B%’;”);
while ($data = mysql_fetch_assoc($query)) {
$query2 = mysql_query(“SELECT user_login, user_email FROM wp_users WHERE user_login = ‘”.$data.”‘ || user_email = ‘”.$data.”‘;”);
if (mysql_num_rows($query2) > 0) {
$data2 = mysql_fetch_assoc($query2);
if ($data == $data2 && $data == $data2) {
// Suppressing already migrated users error
//echo printSpaces($data) . ” has already been migrated by the looks of it!n”;
} else if ($data == $data2) {
echo printSpaces($data) . ” could not be migrated, that user name is already taken! (“.$data.”)n”;
$errors++;
} else if ($data == $data2) {
echo printSpaces($data) . ” could not be migrated, that email address is already taken! (“.$data.”)n”;
$errors++;
}
} else {
mysql_query(“INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_status, display_name) VALUES (‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘, ‘” . $data . “‘);”);
// Suppressing user migrated message
//echo $data . ” was migratedn”;
$migrated++;
}
}
$alreadyDone = ((mysql_num_rows($query) – $errors) – $migrated);
echo “n”;
echo “Stats:n”;
echo “n”;
echo “Users Migrated: ” . $migrated . “n”;
echo “Already Migrated: ” . $alreadyDone . “n”;
echo “Not Migrated: ” . $errors . “n”;
echo “=======================================n”;
echo “Total: ” . mysql_num_rows($query) . “n”;
echo “n”;
?>’
Topic: No Setting Screen
Hi,
i have installes the latest 1.0-Alpha-6. When i login as admin i cannot see the Settings Menu. I have full administrator rights.
All is see is Users and Manage
Any idea?
Best,
Karl
I managed to do it with
if ($topic->forum_id != 3)
but then it’s still counting them as part of the loop therefore it ends up with ‘Number of Discussions to display – Number of discussions in that forum’.
How can I do it so it just leaves them out but leaves the latest discussion length intact?