/**
* Execute changes made in WordPress 2.0.
*
* @since 2.0.0
*/
function upgrade_160()
{
global $wpdb, $wp_current_db_version;
populate_roles_160();
$users = $wpdb->get_results("SELECT * FROM {$wpdb->users}");
foreach ($users as $user) {
if (!empty($user->user_firstname)) {
update_user_meta($user->ID, 'first_name', $wpdb->escape($user->user_firstname));
}
if (!empty($user->user_lastname)) {
update_user_meta($user->ID, 'last_name', $wpdb->escape($user->user_lastname));
}
if (!empty($user->user_nickname)) {
update_user_meta($user->ID, 'nickname', $wpdb->escape($user->user_nickname));
}
if (!empty($user->user_level)) {
update_user_meta($user->ID, $wpdb->prefix . 'user_level', $user->user_level);
}
if (!empty($user->user_icq)) {
update_user_meta($user->ID, 'icq', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_aim)) {
update_user_meta($user->ID, 'aim', $wpdb->escape($user->user_aim));
}
if (!empty($user->user_msn)) {
update_user_meta($user->ID, 'msn', $wpdb->escape($user->user_msn));
}
if (!empty($user->user_yim)) {
update_user_meta($user->ID, 'yim', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_description)) {
update_user_meta($user->ID, 'description', $wpdb->escape($user->user_description));
}
if (isset($user->user_idmode)) {
$idmode = $user->user_idmode;
if ($idmode == 'nickname') {
$id = $user->user_nickname;
}
if ($idmode == 'login') {
$id = $user->user_login;
}
if ($idmode == 'firstname') {
$id = $user->user_firstname;
}
if ($idmode == 'lastname') {
$id = $user->user_lastname;
}
if ($idmode == 'namefl') {
$id = $user->user_firstname . ' ' . $user->user_lastname;
}
if ($idmode == 'namelf') {
$id = $user->user_lastname . ' ' . $user->user_firstname;
}
if (!$idmode) {
$id = $user->user_nickname;
}
$wpdb->update($wpdb->users, array('display_name' => $id), array('ID' => $user->ID));
}
// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.
$caps = get_user_meta($user->ID, $wpdb->prefix . 'capabilities');
if (empty($caps) || defined('RESET_CAPS')) {
$level = get_user_meta($user->ID, $wpdb->prefix . 'user_level', true);
$role = translate_level_to_role($level);
update_user_meta($user->ID, $wpdb->prefix . 'capabilities', array($role => true));
}
}
$old_user_fields = array('user_firstname', 'user_lastname', 'user_icq', 'user_aim', 'user_msn', 'user_yim', 'user_idmode', 'user_ip', 'user_domain', 'user_browser', 'user_description', 'user_nickname', 'user_level');
$wpdb->hide_errors();
foreach ($old_user_fields as $old) {
$wpdb->query("ALTER TABLE {$wpdb->users} DROP {$old}");
}
$wpdb->show_errors();
// populate comment_count field of posts table
$comments = $wpdb->get_results("SELECT comment_post_ID, COUNT(*) as c FROM {$wpdb->comments} WHERE comment_approved = '1' GROUP BY comment_post_ID");
if (is_array($comments)) {
foreach ($comments as $comment) {
$wpdb->update($wpdb->posts, array('comment_count' => $comment->c), array('ID' => $comment->comment_post_ID));
}
}
// Some alpha versions used a post status of object instead of attachment and put
// the mime type in post_type instead of post_mime_type.
if ($wp_current_db_version > 2541 && $wp_current_db_version <= 3091) {
$objects = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts} WHERE post_status = 'object'");
foreach ($objects as $object) {
$wpdb->update($wpdb->posts, array('post_status' => 'attachment', 'post_mime_type' => $object->post_type, 'post_type' => ''), array('ID' => $object->ID));
$meta = get_post_meta($object->ID, 'imagedata', true);
if (!empty($meta['file'])) {
update_attached_file($object->ID, $meta['file']);
}
}
}
}
function upgrade_160()
{
global $wpdb, $table_prefix, $wp_current_db_version;
populate_roles_160();
$users = $wpdb->get_results("SELECT * FROM {$wpdb->users}");
foreach ($users as $user) {
if (!empty($user->user_firstname)) {
update_usermeta($user->ID, 'first_name', $wpdb->escape($user->user_firstname));
}
if (!empty($user->user_lastname)) {
update_usermeta($user->ID, 'last_name', $wpdb->escape($user->user_lastname));
}
if (!empty($user->user_nickname)) {
update_usermeta($user->ID, 'nickname', $wpdb->escape($user->user_nickname));
}
if (!empty($user->user_level)) {
update_usermeta($user->ID, $table_prefix . 'user_level', $user->user_level);
}
if (!empty($user->user_icq)) {
update_usermeta($user->ID, 'icq', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_aim)) {
update_usermeta($user->ID, 'aim', $wpdb->escape($user->user_aim));
}
if (!empty($user->user_msn)) {
update_usermeta($user->ID, 'msn', $wpdb->escape($user->user_msn));
}
if (!empty($user->user_yim)) {
update_usermeta($user->ID, 'yim', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_description)) {
update_usermeta($user->ID, 'description', $wpdb->escape($user->user_description));
}
if (isset($user->user_idmode)) {
$idmode = $user->user_idmode;
if ($idmode == 'nickname') {
$id = $user->user_nickname;
}
if ($idmode == 'login') {
$id = $user->user_login;
}
if ($idmode == 'firstname') {
$id = $user->user_firstname;
}
if ($idmode == 'lastname') {
$id = $user->user_lastname;
}
if ($idmode == 'namefl') {
$id = $user->user_firstname . ' ' . $user->user_lastname;
}
if ($idmode == 'namelf') {
$id = $user->user_lastname . ' ' . $user->user_firstname;
}
if (!$idmode) {
$id = $user->user_nickname;
}
$id = $wpdb->escape($id);
$wpdb->query("UPDATE {$wpdb->users} SET display_name = '{$id}' WHERE ID = '{$user->ID}'");
}
// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.
$caps = get_usermeta($user->ID, $table_prefix . 'capabilities');
if (empty($caps) || defined('RESET_CAPS')) {
$level = get_usermeta($user->ID, $table_prefix . 'user_level');
$role = translate_level_to_role($level);
update_usermeta($user->ID, $table_prefix . 'capabilities', array($role => true));
}
}
$old_user_fields = array('user_firstname', 'user_lastname', 'user_icq', 'user_aim', 'user_msn', 'user_yim', 'user_idmode', 'user_ip', 'user_domain', 'user_browser', 'user_description', 'user_nickname', 'user_level');
$wpdb->hide_errors();
foreach ($old_user_fields as $old) {
$wpdb->query("ALTER TABLE {$wpdb->users} DROP {$old}");
}
$wpdb->show_errors();
if (0 == $wpdb->get_var("SELECT SUM(category_count) FROM {$wpdb->categories}")) {
// Create counts
$categories = $wpdb->get_col("SELECT cat_ID FROM {$wpdb->categories}");
foreach ($categories as $cat_id) {
$count = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->post2cat}, {$wpdb->posts} WHERE {$wpdb->posts}.ID={$wpdb->post2cat}.post_id AND post_status='publish' AND category_id = '{$cat_id}'");
$wpdb->query("UPDATE {$wpdb->categories} SET category_count = '{$count}' WHERE cat_ID = '{$cat_id}'");
}
}
// populate comment_count field of posts table
$comments = $wpdb->get_results("SELECT comment_post_ID, COUNT(*) as c FROM {$wpdb->comments} WHERE comment_approved = '1' GROUP BY comment_post_ID");
if (is_array($comments)) {
foreach ($comments as $comment) {
$wpdb->query("UPDATE {$wpdb->posts} SET comment_count = {$comment->c} WHERE ID = '{$comment->comment_post_ID}'");
}
}
// Some alpha versions used a post status of object instead of attachment and put
// the mime type in post_type instead of post_mime_type.
if ($wp_current_db_version > 2541 && $wp_current_db_version <= 3091) {
$objects = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts} WHERE post_status = 'object'");
foreach ($objects as $object) {
$wpdb->query("UPDATE {$wpdb->posts} SET post_status = 'attachment',\n\t\t\tpost_mime_type = '{$object->post_type}',\n\t\t\tpost_type = ''\n\t\t\tWHERE ID = {$object->ID}");
$meta = get_post_meta($object->ID, 'imagedata', true);
if (!empty($meta['file'])) {
add_post_meta($object->ID, '_wp_attached_file', $meta['file']);
}
}
}
}
/**
* Execute changes made in WordPress 2.0.
*
* @since 2.0.0
*/
function upgrade_160_helper($users)
{
global $wpdb;
populate_roles_160();
foreach ($users as $user_details) {
$user = $wpdb->get_results("SELECT * FROM {$wpdb->users} WHERE ID = '" . $user_details['user_id'] . "'");
if (!empty($user->user_firstname)) {
update_usermeta($user->ID, 'first_name', $wpdb->escape($user->user_firstname));
}
if (!empty($user->user_lastname)) {
update_usermeta($user->ID, 'last_name', $wpdb->escape($user->user_lastname));
}
if (!empty($user->user_nickname)) {
update_usermeta($user->ID, 'nickname', $wpdb->escape($user->user_nickname));
}
if (!empty($user->user_level)) {
update_usermeta($user->ID, $wpdb->prefix . 'user_level', $user->user_level);
}
if (!empty($user->user_icq)) {
update_usermeta($user->ID, 'icq', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_aim)) {
update_usermeta($user->ID, 'aim', $wpdb->escape($user->user_aim));
}
if (!empty($user->user_msn)) {
update_usermeta($user->ID, 'msn', $wpdb->escape($user->user_msn));
}
if (!empty($user->user_yim)) {
update_usermeta($user->ID, 'yim', $wpdb->escape($user->user_icq));
}
if (!empty($user->user_description)) {
update_usermeta($user->ID, 'description', $wpdb->escape($user->user_description));
}
if (isset($user->user_idmode)) {
$idmode = $user->user_idmode;
if ($idmode == 'nickname') {
$id = $user->user_nickname;
}
if ($idmode == 'login') {
$id = $user->user_login;
}
if ($idmode == 'firstname') {
$id = $user->user_firstname;
}
if ($idmode == 'lastname') {
$id = $user->user_lastname;
}
if ($idmode == 'namefl') {
$id = $user->user_firstname . ' ' . $user->user_lastname;
}
if ($idmode == 'namelf') {
$id = $user->user_lastname . ' ' . $user->user_firstname;
}
if (!$idmode) {
$id = $user->user_nickname;
}
$wpdb->update($wpdb->users, array('display_name' => $id), array('ID' => $user->ID));
}
// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.
$caps = get_usermeta($user->ID, $wpdb->prefix . 'capabilities');
if (empty($caps) || defined('RESET_CAPS')) {
$level = get_usermeta($user->ID, $wpdb->prefix . 'user_level');
$role = translate_level_to_role($level);
update_usermeta($user->ID, $wpdb->prefix . 'capabilities', array($role => true));
}
}
}
function DoSimpleLogin($args = '')
{
global $user_ID, $current_user, $login_errors, $user_level;
get_currentuserinfo();
extract($args);
if ($user_ID != '') {
require_once ABSPATH . '/wp-admin/includes/upgrade.php';
$user_role = translate_level_to_role($user_level);
$dashboard_link = $this->GetOption('dashboard_link');
$profile_link = $this->GetOption('profile_link');
echo $before_widget . $before_title . __('Welcome', 'simpelogin') . ', ' . $current_user->display_name . $after_title . "\n";
if ($this->GetOption('show_gravatar') == true) {
echo '<div class="simplelogin-avatar">' . get_avatar($user_ID, $size = $this->GetOption('gravatar_size')) . '</div>' . "\n";
}
do_action('simplelogin_avatar', $current_user);
echo '<ul class="simplelogin-links">' . "\n";
if ($dashboard_link[$user_role] == true) {
$dashboard_url = $this->GetOption('dashboard_url');
$dashboard_url = !empty($dashboard_url) ? $dashboard_url : admin_url();
echo '<li><a href="' . $dashboard_url . '">' . __('Dashboard', 'simpelogin') . '</a></li>' . "\n";
}
if ($profile_link[$user_role] == true) {
$profile_url = $this->GetOption('profile_url');
$profile_url = !empty($profile_url) ? $profile_url : admin_url('profile.php');
echo '<li><a href="' . $profile_url . '">' . __('Profile', 'simpelogin') . '</a></li>' . "\n";
}
do_action('simplelogin_custom_links', $user_role);
echo '<li><a href="' . wp_nonce_url(simplelogin_url(array('action' => 'logout', 'redirect_to' => simplelogin_url())), 'log-out') . '">' . __('Logout', 'simpelogin') . '</a></li>' . "\n";
echo '</ul>' . "\n";
} else {
require WP_PLUGIN_DIR . '/simplelogin/includes/wp-login-forms.php';
}
echo $after_widget;
}
