<?
##========== COOLFORUM INTEGRATION BY HellsAngels ===========##
////////////// http://www.mega-video-php.com //////////////
##=========================================================##
require_once("include/functions.php");
dbconn();
loggedinonly();
stdhead("Forum");
function unix_timestamp($date)
{
$date = str_replace(array(' ', ':'), '-', $date);
$c = explode('-', $date);
$c = array_pad($c, 6, 0);
array_walk($c, 'intval');
return mktime($c[3], $c[4], $c[5], $c[1], $c[2], $c[0]);
}
$lng = 'fr';
//begin_frame("Forum");
mysql_query(" TRUNCATE `cf_user`");
$ret = mysql_query("SELECT id, username, password, email, added, class, title, last_browse FROM users ");
while ($res = mysql_fetch_array($ret)) {
if ($res['class'] == 7){ //check user class
$cf_groups_id = 4; // set admin group
}
elseif ($res['class'] == 6){ //check user class
$cf_groups_id = 3; // set moderator group
}
elseif ($res['class'] == 1){ //check user class
$cf_groups_id = 2; // set member group
}
else
{
$cf_groups_id = 1; // set invité group
}
$ins_ary[] = array(
'userid' => $res['id'],
'login' => $res['username'],
'password' => md5($res['password']),
'userstatus' => $cf_groups_id,
'registerdate' => unix_timestamp($res['added']),
'usermail' => $res['email'],
'lng' => $lng,
'lastvisit' => $res['last_browse'],
);
}
mysql_free_result($ret);
begin_frame("Convertisseur de Membres", center);
echo '<div align="center">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
<tr>
<td class="forum_col1" width="600" colspan="2"><p align="center"><b>Convertion des membres de MVP vers FluxBB</b></td>
</tr></table>
</div>';
for ( $i = 0; $i < sizeof($ins_ary); ++$i ) {
$fields = $values = array();
foreach ( $ins_ary[$i] as $key => $var ) {
$fields[] = $key;
$values[] = "'" . mysql_real_escape_string($var) . "'";
}
mysql_query("DELETE FROM cf_user WHERE `cf_user`.`id` = " . $values[0] . "");
$sql1 = "INSERT INTO cf_user (" . implode(', ', $fields) . ") VALUES (" . implode(', ', $values) . ")";
mysql_query($sql1);
echo '<div align="center">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
<tr>
<td class="forum_col1" width="300">
<p align="center">'. $values[2].'</td>
<td class="forum_col2" width="300">
<p align=COOLFORUM