4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: Sunny C. on July 02, 2010, 01:04:36 PM

Title: [MOD] 1 zu 1 Registrierung / Register to Wordpress
Post by: Sunny C. on July 02, 2010, 01:04:36 PM

Wordpress must in the Same DB at 4images
Wordpress muss in der gleichen DB liegen wie 4images


Open register.php
Öffne register.php
Search / Suche:
    $sql = "INSERT INTO ".USERS_TABLE."
            (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq").$additional_field_sql.")
            VALUES
            ($user_id, $user_level, '$user_name', '".md5($user_password)."', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq'".$additional_value_sql.")";
    $result = $site_db->query($sql);
Add after / Danach einfügen:
// Wordpress Register START
$sql = "INSERT INTO wp_users
(ID, user_login, user_pass, user_nicename, user_email, user_registered)
VALUES
('".$user_id."', '".$user_name."', '".md5($user_password)."', '".$user_name."', '".$user_email."', '".$current_time."')";
$result = $site_db->query($sql);
$umetaID = mysql_insert_id();
$schreiber = 'a:1:{s:10:"subscriber";s:1:"1";}';

/* User Meta Config */
$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'nickname', '".$user_name."')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'rich_editing', 'true')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'comment_shortcuts', 'false')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'admin_color', 'fresh')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'use_ssl', '0')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'wp_capabilities', '".$schreiber."')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'wp_user_level', '0')";
$result = $site_db->query($sql);

$sql = "INSERT INTO wp_usermeta
(user_id, meta_key, meta_value)
VALUES
('".$user_id."', 'default_password_nag', '1')";
$result = $site_db->query($sql);
// Wordpress Register ENDE!

Eine bessere Variante habe ich nicht geschafft zu erstellen. Eventuell hilft es jemanden weiter.