<?
##========== 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