sorry2all, dass ich mich so lange nicht gemeldet und auch eure emails und posts nicht beantwortet habe - dass war nicht böswillig - ich bin einfach nicht dazugekommen, da mein bischen freizeit seit meiner letzten post meiner kleinen tochter gehört...
ich werde jetzt mal mit der erklärung anfangen und wirklich versuchen, es so einfach wie möglich zu machen und das ganze in einer woche so gut es geht zu vervollständigen, da ich mir meine änderungen erst raussuchen muss - here we go...
1.) User-Registrierung und Daten-Editierung:
Wenn sich ein User im Typo3 registriertoder seine Daten ändert, werden die Registrierungsdaten zusätzlich zur Typo3-DB in die phpbb-DB geschrieben – bei der Registrierung über das phpbb-Forum wird der User zur Typo3 Registrierung weitergeleitet.
=> Diese Weiterleitung vom phpbb muss geändert werden - wo und was folgt später...
Typo3-Extension: Front End User Registration
Extension Key: sr_feuser_register
Version: 1.3.13
Extension Ordner: sr_feuser_register
File Name: class.tx_srfeuserregister_pi1.php
Download des kompletten File inkl. MOD:
http://www.mwa-networks.com/typo3_to_phpbb/class.tx_srfeuserregister_pi1.zip
Source-Code:
Zeile 1702:
/***************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger START */
/***************************************************************/
/* mwa-networks@explanation: define sql-parameter, check the connection and define the send_sql function */
//$server_mwa = "63.244.17.99"; // mysql-server
$server_mwa = "127.0.0.1"; // mysql-server
$user_mwa = "p9988"; // mysql-user
$pass_mwa = "password"; // mysql-pw
$db_typo3 = "usr_p9988_1"; // typo3-db
$db_phpbb = "usr_p9988_4"; // phpbb-db
$conn_mwa = mysql_connect($server_mwa, $user_mwa, $pass_mwa);
if($conn_mwa) {
mysql_select_db($db_typo3, $conn_mwa);
} else {
die("<b>Verbindung zum Server konnte nicht hergestellt werden! </b>");
}
function send_sql_mwa($db,$sql) {
if (! $res=mysql_db_query($db, $sql)) {
echo mysql_error();
exit;
}
return $res;
}
/**************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger STOP */
/**************************************************************/
Zeile 1767:
/***************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger START */
/***************************************************************/
/* mwa-networks@explanation: get the actual userdata after typo3-userdata-edit from typo3-db */
$uid_mwa_edit_all = strstr($query, 'uid');
$uid_mwa_edit = substr($uid_mwa_edit_all, 4);
$query_typo3_mwa = "SELECT username, password, email, crdate, city FROM fe_users WHERE uid='$uid_mwa_edit'";
$typo3_mwa_id = send_sql_mwa($db_typo3, $query_typo3_mwa);
/* mwa-networks@explanation: open TEMPORARY textfile */
/* $fh_mwa=fopen("mwa_temp_register.txt","r");
$str_mwa=fread($fh_mwa,20000);
fclose($fh_mwa); */
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "EDIT USER \n";
$str_mwa .= "count of SELECT-query-rows: " . mysql_num_rows($typo3_mwa_id) . "\n"; */
$typo3_mwa_values = mysql_fetch_array($typo3_mwa_id);
$mwa_username = $typo3_mwa_values['username'];
$mwa_password = $typo3_mwa_values['password'];
$mwa_password_md5 = md5($mwa_password);
$mwa_email = $typo3_mwa_values['email'];
$mwa_date = $typo3_mwa_values['crdate'];
$mwa_city = $typo3_mwa_values['city'];
/* mwa-networks@explanation: write modified userdata into phpbb-db */
$query_phpbb_mwa = "UPDATE phpbb_users SET user_password='$mwa_password_md5', user_email='$mwa_email', user_from='$mwa_city' WHERE username='$mwa_username'";
$phpbb_mwa_id = send_sql_mwa($db_phpbb, $query_phpbb_mwa);
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "query_phpbb_mwa: " . $query_phpbb_mwa . "\n";
$str_mwa .= "count of UPDATE-query-rows: " . mysql_affected_rows() . "\n\n"; */
/* mwa-networks@explanation: close TEMPORARY textfile */
/* $fh_mwa=fopen("mwa_temp_register.txt","w");
fwrite($fh_mwa,$str_mwa);
fclose($fh_mwa); */
/**************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger STOP */
/**************************************************************/
Zeile 1904:
/***************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger START */
/***************************************************************/
/* mwa-networks@explanation: get the actual userdata after typo3-userdata-edit from typo3-db */
$uid_mwa_create_all = strstr($query, 'uid');
$uid_mwa_create = substr($uid_mwa_create_all, 4);
$query_typo3_mwa = "SELECT username, password, email, crdate, city FROM fe_users WHERE uid='$uid_mwa_create'";
$typo3_mwa_id = send_sql_mwa($db_typo3, $query_typo3_mwa);
/* mwa-networks@explanation: open TEMPORARY textfile */
/* $fh_mwa=fopen("mwa_temp_register.txt","r");
$str_mwa=fread($fh_mwa,20000);
fclose($fh_mwa); */
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "CREATE USER \n";
$str_mwa .= "query_typo3_mwa: $query_typo3_mwa \n";
$str_mwa .= "count of SELECT-query-rows: " . mysql_num_rows($typo3_mwa_id) . "\n"; */
$typo3_mwa_values = mysql_fetch_array($typo3_mwa_id);
$mwa_username = $typo3_mwa_values['username'];
$mwa_password = $typo3_mwa_values['password'];
$mwa_password_md5 = md5($mwa_password);
$mwa_email = $typo3_mwa_values['email'];
$mwa_date = $typo3_mwa_values['crdate'];
$mwa_city = $typo3_mwa_values['city'];
/* mwa-networks@explanation: calculate new user_id value for inserting user-data into phpbb_users */
$query_phpbb_mwa_uid_max = "SELECT MAX(user_id) AS total FROM phpbb_users";
$query_phpbb_mwa_uid_max_id = send_sql_mwa($db_phpbb, $query_phpbb_mwa_uid_max);
$query_phpbb_mwa_uid_max_id_values = mysql_fetch_array($query_phpbb_mwa_uid_max_id);
$phpbb_mwa_uid_max = $query_phpbb_mwa_uid_max_id_values['total'];
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "phpbb_mwa_uid_max: $phpbb_mwa_uid_max \n"; */
$phpbb_mwa_uid_new = $phpbb_mwa_uid_max + 1;
/* mwa-networks@explanation: insert userdata with standard-settings into table phpbb_users */
$query_phpbb_mwa_insert_users = 'INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey, user_rank, user_allowavatar, user_last_privmsg, user_unread_privmsg, user_new_privmsg, user_posts, user_lastvisit, user_session_page, user_session_time) VALUES (' . $phpbb_mwa_uid_new . ', "' . $mwa_username . '", ' . $mwa_date . ', "' . $mwa_password_md5 . '", "' . $mwa_email . '", "", "", "", "' . $mwa_city . '", "", "", "", "", 0, 1, "", "", "", 1, 1, 1, 1, 1, 1, 1, 1, "2.00", "D M d, Y g:i a", "german", 1, 0, 1, 1, "", 0, 1, 0, 0, 0, 0, 0, 0, 0)';
$phpbb_mwa_insert_users = send_sql_mwa($db_phpbb, $query_phpbb_mwa_insert_users);
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "query_phpbb_mwa_insert_users: $query_phpbb_mwa_insert_users \n";
$str_mwa .= "count of INSERT-query-rows: " . mysql_affected_rows() . "\n"; */
/* mwa-networks@explanation: insert record into table phpbb_groups */
$query_phpbb_mwa_insert_groups = "INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_single_user, group_moderator) VALUES ($phpbb_mwa_uid_new, 1, '', 'Personal User', 1, 0)";
$phpbb_mwa_insert_groups = send_sql_mwa($db_phpbb, $query_phpbb_mwa_insert_groups);
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "query_phpbb_mwa_insert_groups: $query_phpbb_mwa_insert_groups \n";
$str_mwa .= "count of INSERT-query-rows: " . mysql_affected_rows() . "\n"; */
/* mwa-networks@explanation: insert record into table phpbb_user_group */
$query_phpbb_mwa_insert_user_group = "INSERT INTO phpbb_user_group (user_id, group_id, user_pending) VALUES ($phpbb_mwa_uid_new, $phpbb_mwa_uid_new, 0)";
$phpbb_mwa_insert_user_group = send_sql_mwa($db_phpbb, $query_phpbb_mwa_insert_user_group);
/* mwa-networks@explanation: output message to TEMPORARY textfile */
/* $str_mwa .= "query_phpbb_mwa_insert_user_group: $query_phpbb_mwa_insert_user_group \n";
$str_mwa .= "count of INSERT-query-rows: " . mysql_affected_rows() . "\n\n"; */
/* mwa-networks@explanation: close TEMPORARY textfile */
/* $fh_mwa=fopen("mwa_temp_register.txt","w");
fwrite($fh_mwa,$str_mwa);
fclose($fh_mwa); */
/**************************************************************/
/* modified by mwa-networks, Ing. Roland Maldoner-Jaeger STOP */
/**************************************************************/
versuche, heute abend wieder weiter zu machen und euch den quellcode per zip anzuhängen...
bis später & lg,
roli
leider kann hier kein file angehängt werden => versuchs per url...
http://www.mwa-networks.com/typo3_to_phpbb/class.tx_srfeuserregister_pi1.zip