Hello,
I have created a script that create automatic phpbb membership from your database :
<?
require ("data.php");
$db = mysql_connect ( $serveur, $login, $pass);
mysql_select_db ($base, $db);
//read your members
$requete="SELECT * from `members`";
$result=mysql_query($requete,$db);
while ($row = mysql_fetch_array($result))
{
$alm_login=$row['alm_login'];
$alm_password=$row['alm_password'];
$alm_email=$row['alm_email'];
$alm_nom=$row['alm_nom'];
$alm_prenom=$row['alm_prenom'];
$sql_result =0;
// Affect the field of the phpbb website
$username=$alm_login;
$new_password=$alm_password;
$email=$alm_email;
$icq="";
$website="";
$occupation="";
$location="";
$interests="";
$signature="$alm_nom $alm_prenom, membre de $mysite";
$signature_bbcode_uid="";
$avatar_sql="";
$viewemail=0;
$aim="";
$yim="";
$msn="";
$attachsig=1;
$allowsmilies=1;
$allowhtml=1;
$allowbbcode=1;
$allowviewonline=1;
$notifyreply=0;
$notifypm=1;
$popup_pm=1;
$user_timezone="1.00";
$user_dateformat="D M d, Y g:i a";
$user_lang="french";
$user_style=3;
$avatar_sql="'',''";
$sql = "SELECT MAX(user_id) AS total FROM phpbb_users";
$result2=mysql_query($sql,$db);
$sql_result += mysql_errno();
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
$row = mysql_fetch_array($result2);
$user_id = $row['total'] + 1;
//
// Get current date
//
$new_password = md5($new_password);
$sql = "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)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
$sql .= "1, '')";
$result2=mysql_query($sql,$db);
$sql_result += mysql_errno();
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
$sql = "INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator)
VALUES ('', 'Personal User', 1, 0)";
$result2=mysql_query($sql,$db);
$sql_result += mysql_errno();
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
$sql = "SELECT MAX(group_id) AS total FROM phpbb_user_group";
$result2=mysql_query($sql,$db);
$sql_result += mysql_errno();
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
$row = mysql_fetch_array($result2);
$group_id = $row['total'] + 1;
$sql = "INSERT INTO phpbb_user_group (user_id, group_id, user_pending)
VALUES ($user_id, $group_id, 0)";
$result2=mysql_query($sql,$db);
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
$sql_result += mysql_errno();
//***********************
//Affect user to a group
//***********************
$sql = "INSERT INTO phpbb_user_group (user_id, group_id, user_pending)
VALUES ($user_id, 3, 0)";
$result2=mysql_query($sql,$db);
$sql_result += mysql_errno();
//echo "<hr>\$sql=$sql ".mysql_errno().mysql_error();
if ($sql_result == 0)
{
echo "<font color=\"#00ff00\"> OK </font>";
echo "<br>";
?> <a href="http://www.mindklik.com/forum/login.php">Accéder au Forum</a>
<?
}
else
{
echo "<font color=\"#FF0000\"> ERREUR </font>";
}
} // while
?>
Any questions just visit http://www.surfkipeut.com