Show Posts
91
Mods & Plugins (Requests & Discussions) / [MOD] 1 zu 1 Registrierung / Register to Wordpress
« 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.
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.
