I added those fields manually to the generated .sql files with empty values and it worked, but it took me a whilemembers.sql: ok
bots.sql:
Script line: 2 Field 'user_permissions' doesn't have a default value
Script line: 2 Field 'user_sig' doesn't have a default value
Script line: 2 Field 'user_occ' doesn't have a default value
Script line: 2 Field 'user_interests' doesn't have a default value
categories_forums.sql:
Script line: 7 Field 'forum_parents' doesn't have a default value
Script line: 7 Field 'forum_rules' doesn't have a default value
topics_posts.sql: ok
Code: Select all
PM_data.write("%s|%s\n"%(dat[1],passnumber))
Code: Select all
PM_data.write("%s|%s|%s\n"%(dat[1],dat[3],passnumber))
Code: Select all
<?php
//Change values acording to your needs
$password_file="pm_passwords.txt";
$mail_from="From: Your Name <admin@your-forum.com>";
$mail_subject="Your new password!";
$mail_message="Hello \n We have moved to http://your-forum.com\n You can access the forum using your username and new password: ";
// END Change
//open file
$fp = @fopen ($password_file, "r");
if ($fp) {
while(!feof($fp)) {
$this_line = fgets($fp);
$kw = explode("|", $this_line);
$mail_message.="$kw[0] and $kw[2]";
$mail_to="$kw[1]";
// SEND Email
//Check for success/failure of delivery
if(mail($mail_to,$mail_subject,$mail_message,$mail_from))
echo "<div>E-mail has been sent successfully to $mail_to</div>";
else
echo "<div>Failed to send the E-mail to $mail_to</div>";
sleep(0.1); //Increase or decrease value
}
//close file
fclose($fp);
}
?>
I thank you for his comments so I have tried to understand and very satisfying results. you are the best. thanks.d0h wrote:For anyone who had the same problem here it is how I did it:
1. Open the file members_topics_posts_phpBB3.py with any text editor (or right click -> Edit with IDLE if you installed corectly Python)
2. FIND the line:3. REPLACE it with:Code: Select all
PM_data.write("%s|%s\n"%(dat[1],passnumber))
Start the converting process according to Instructions.txtCode: Select all
PM_data.write("%s|%s|%s\n"%(dat[1],dat[3],passnumber))
After that if you open pm_passwords.txt you'll have on each line: User|User@email|Password
Sending emails to each user can be done in two different ways (I succesfully tested both)
I. Use any MASS MAILER software. I tried Fast Mailer Pro. Import pm_passwords.txt identifying the 3 fields (user/email/password -> Recipient Name/Recipient Email/Recipient Phone or any field you like). Create a message including the field for password (%PHONE% for this example). Setup the SMTP server providing server/port/user/password and start sending.
II. Upload pm_passwords.txt to your server. Create a new file mail.php, edit the file and insert the following:I tested this code only for 40 users; the server may timeout if the number of users is much higher. In this case try splitting the file pm_passwords.txtCode: Select all
<?php //Change values acording to your needs $password_file="pm_passwords.txt"; $mail_from="From: Your Name <admin@your-forum.com>"; $mail_subject="Your new password!"; $mail_message="Hello \n We have moved to http://your-forum.com\n You can access the forum using your username and new password: "; // END Change //open file $fp = @fopen ($password_file, "r"); if ($fp) { while(!feof($fp)) { $this_line = fgets($fp); $kw = explode("|", $this_line); $mail_message.="$kw[0] and $kw[2]"; $mail_to="$kw[1]"; // SEND Email //Check for success/failure of delivery if(mail($mail_to,$mail_subject,$mail_message,$mail_from)) echo "<div>E-mail has been sent successfully to $mail_to</div>"; else echo "<div>Failed to send the E-mail to $mail_to</div>"; sleep(0.1); //Increase or decrease value } //close file fclose($fp); } ?>
Good luck!
I'm not exactly sure what a "prefix" is in respect to a forum - could someone clarify this for me? Thanks!instructions.txt wrote:2) Change some settings in settings.py (edit the file)
table_prefix
When you set up your forum software, what prefix did you use (default will depend on the exact software used; it's usually the product name plus an underscore)
instructions.txt wrote:lockimage
Location of the "Locked" image which appears in place of the usual "Post Reply" button.