Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
... es ist schon eigenartig wie viele User mit "1 Beitrag" (und offensichtlich aus dem Nahen Osten) sich hier bedanken ...
... misteriös ... und ein Schelm wer hier Übeles denkt ...
this little simple php script:
<?php
/******************************************
* import 4images 1.7.6 users to phpBB 3.0.4
* v0.1.4 by honsa
* 24. März 2009
*
* place it in your "/gallery/admin/" folder
*
* http://www.4homepages.de
* http://www.phpbb.de
******************************************/
define('ROOT_PATH', '../');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');
if(0 < $site_sess->user_info['user_id']){
$sql = "SELECT user_id,user_name, LOWER(user_name) as username_clean,
user_password,user_email,user_showemail,
user_joindate,user_homepage,user_icq,user_invisible,user_level
FROM 4img_users";
$result = mysql_query($sql);
if (!$result) {
echo "Anfrage ($sql) konnte nicht ausgeführt werden : " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "Keine Zeilen gefunden, nichts auszugeben, daher Abbruch";
exit;
}
//get 4images users
$i=0;
while ($row = mysql_fetch_assoc($result)) {
//only "real" and activated users
if($row["user_name"] != "Guest" && 1 < $row['user_level']) {
$username[$i] = $row["user_name"];
$username_clean[$i] = $row["username_clean"];
$user_password[$i] = $row["user_password"];
$user_email[$i] = $row["user_email"];
$user_allow_viewemail[$i] = $row['user_showemail'];
if($row["user_invisible"] == 0)
$user_allow_viewonline[$i] = 1;
else
$user_allow_viewonline[$i] = 0;
$user_icq[$i] = $row['user_icq'];
$user_regdate[$i] = $row['user_joindate'];
$user_website[$i] = $row['user_homepage'];
//change values if you need
$group_id[$i] = 7;
$user_type[$i] = 0;
$user_perm_from[$i] = 0;
$user_passchg[$i] = 0;
$user_pass_convert[$i] = 0;
$user_email_hash[$i] = 0;
$user_last_search[$i] = 0;
$user_warnings[$i] = 0;
$user_last_warning[$i] = 0;
$user_login_attempts[$i] = 0;
$user_inactive_reason[$i] = 0;
$user_inactive_time = 0;
$user_posts[$i] = 0;
$user_timezone[$i] = 1.00;
$user_dst[$i] = 0;
$user_dateformat[$i] = 'l j. F Y, H:i';
$user_style[$i] = 1;
$user_rank[$i] = 0;
$user_new_privmsg[$i] = 0;
$user_unread_privmsg[$i] = 0;
$user_last_privmsg[$i] = 0;
$user_message_rules[$i] = 0;
$user_full_folder[$i] = -3;
$user_emailtime[$i] = 0;
$user_topic_show_days[$i] = 0;
$user_topic_sortby_type[$i] = 't';
$user_topic_sortby_dir[$i] = 'd';
$user_post_show_days[$i] = 0;
$user_post_sortby_type[$i] = 't';
$user_post_sortby_dir[$i] = 'a';
$user_notify[$i] = 0;
$user_notify_pm[$i] = 1;
$user_notify_type[$i] = 0;
$user_allow_pm[$i] = 1;
$user_allow_massemail[$i] = 1;
$user_options[$i] = 895;
$user_avatar_type[$i] = 0;
$user_avatar_width[$i] = 0;
$user_avatar_height[$i] = 0;
$user_lang[$i] = 'de';
}
else
$i--;
$i++;
}
mysql_free_result($result);
echo "4images Users:";
echo"<pre>";
print_r($username);
echo"</pre>";
echo "phpBB Users:<ol>";
$i=$i-1;
//write into phpbb db new users error if duplicate exists
while(0 <= $i) {
echo "<li>".$username[$i]." ". $user_email[$i] . "</li>";
//change prefix if you need
$insertmysql="INSERT INTO phpbb_users(
username,
username_clean,
user_password,
user_email,
user_allow_viewemail,
user_icq,
user_regdate,
user_website,
group_id,
user_type,
user_perm_from,
user_passchg,
user_pass_convert,
user_email_hash,
user_last_search,
user_warnings,
user_last_warning,
user_login_attempts,
user_inactive_reason,
user_inactive_time,
user_posts,
user_timezone,
user_dst,
user_dateformat,
user_style,
user_rank,
user_new_privmsg,
user_unread_privmsg,
user_last_privmsg,
user_message_rules,
user_full_folder,
user_emailtime,
user_topic_show_days,
user_topic_sortby_type,
user_topic_sortby_dir,
user_post_show_days,
user_post_sortby_type,
user_post_sortby_dir,
user_notify,
user_notify_pm,
user_notify_type,
user_allow_pm,
user_allow_massemail,
user_options,
user_avatar_type,
user_avatar_width,
user_avatar_height,
user_lang)
VALUES(
'".$username[$i]."',
'".$username_clean[$i]."',
'".$user_password[$i]."',
'".$user_email[$i]."',
'".$user_allow_viewemail[$i]."',
'".$user_icq[$i]."',
'".$user_regdate[$i]."',
'".$user_website[$i]."',
'".$group_id[$i]."',
'".$user_type[$i]."',
'".$user_perm_from[$i]."',
'".$user_passchg[$i]."',
'".$user_pass_convert[$i]."',
'".$user_email_hash[$i]."',
'".$user_last_search[$i]."',
'".$user_warnings[$i]."',
'".$user_last_warning[$i]."',
'".$user_login_attempts[$i]."',
'".$user_inactive_reason[$i]."',
'".$user_inactive_time[$i]."',
'".$user_posts[$i]."',
'".$user_timezone[$i]."',
'".$user_dst[$i]."',
'".$user_dateformat[$i]."',
'".$user_style[$i]."',
'".$user_rank[$i]."',
'".$user_new_privmsg[$i]."',
'".$user_unread_privmsg[$i]."',
'".$user_last_privmsg[$i]."',
'".$user_message_rules[$i]."',
'".$user_full_folder[$i]."',
'".$user_emailtime[$i]."',
'".$user_topic_show_days[$i]."',
'".$user_topic_sortby_type[$i]."',
'".$user_topic_sortby_dir[$i]."',
'".$user_post_show_days[$i]."',
'".$user_post_sortby_type[$i]."',
'".$user_post_sortby_dir[$i]."',
'".$user_notify[$i]."',
'".$user_notify_pm[$i]."',
'".$user_notify_type[$i]."',
'".$user_allow_pm[$i]."',
'".$user_allow_massemail[$i]."',
'".$user_options[$i]."',
'".$user_avatar_type[$i]."',
'".$user_avatar_width[$i]."',
'".$user_avatar_height[$i]."',
'".$user_lang[$i]."')";
$result = mysql_query($insertmysql);
if (!$result) {
echo '<ul style="list-style-type:disc; color:red; font-weight:bold;">
<li >Anfrage konnte nicht ausgeführt werden : ' . mysql_error() .'</li>
</ul>';
}
else {
echo '<ul style="list-style-type:disc; color:green; font-weight:bold;">
<li >Anfrage wurde ausgeführt</li>
</ul>';
}
$i--;
mysql_free_result($result);
}
echo "</ol>";
}
else
echo "Login!";
?>
.