Club Alpin Ile-de-France

Code : Tout sélectionner

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/nayseven/www/importCoolForum v2.php on line 52
table forums : 0 ligne(s)

Code : Tout sélectionner

<?php
$host = "xxx"; // serveur hôte
$user = "xxx"; // nom utilisateur
$pass = "xxx"; // mot de passe de connexion
$bdd  = "xxx"; // nom de la base de données

$connexion = mysql_connect($host, $user, $pass);
mysql_select_db($bdd, $connexion);

// table temporaire de premiers messages par topic
mysql_query("drop table if exists tmp_postopic");
mysql_query("create table if not exists tmp_postopic (
idTopic int(11) NOT NULL,
idFirstPost int(11) NOT NULL,
PRIMARY KEY (idTopic), KEY idFirstPost (idFirstPost)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs");
mysql_query("insert into tmp_postopic(idTopic, idFirstPost)
select idtopic, CF_firstPost.idPost
from CF_topics, (select min(idpost) as idPost, parent from CF_posts group by parent) as CF_firstPost
where CF_topics.idtopic = CF_firstPost.parent");

// table temporaire de sondage
mysql_query("drop table if exists tmp_sondage");
mysql_query("create table if not exists tmp_sondage (
id int(11) NOT NULL AUTO_INCREMENT,
idTopic int(11) NOT NULL,
`date` int(11) NOT NULL DEFAULT '0',
question text COLLATE latin1_general_ci NOT NULL,
choix text COLLATE latin1_general_ci NOT NULL,
rep text COLLATE latin1_general_ci NOT NULL,
votants text COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs");
mysql_query("insert into tmp_sondage(id, idTopic, date, question, choix, rep, votants)
select id, idTopic, CF_poll.date, question, choix, rep, votants
from CF_poll, CF_topics
where id = poll");

// forum
$index = 1;
$requete = "";
$resultat = mysql_query("select forumid, forumtitle, forumcomment, forumtopic, forumposts, lastTopic.sujet, lastTopic.idderpost, lastTopic.userid, lastTopic.derposter, lastTopic.datederrep
from CF_forums,
(
select CF_topics.idforum, sujet, idderpost, userid, derposter, datederrep as datederrep
from CF_topics, CF_user, (select idforum, max(idderpost) as maxpost from CF_topics group by idforum) as lastPost
where CF_topics.derposter = CF_user.login
and idderpost in (lastPost.maxpost)
) as lastTopic
where forumid = idforum
order by forumid asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
 $requete .= sprintf("insert into phpbb_forums(forum_id, left_id, right_id, forum_name, forum_desc, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_type, prune_days) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 1, 7);\n",
 $ligne["forumid"], 2 * $index - 1, 2 * $index, getDBParam($ligne["forumtitle"]), getDBParam($ligne["forumcomment"]), $ligne["forumposts"], $ligne["forumtopic"],
 $ligne["forumtopic"] , $ligne["idderpost"], shiftUser($ligne["userid"]), getDBParam($ligne["sujet"]), $ligne["datederrep"], getDBParam($ligne["derposter"]));
 $index++;
}
$session = fopen("forum.sql", "w");
fwrite($session, $requete);
fclose($session);
echo "table forums : ".($index - 1). " ligne(s)<br/>";

// topic & topics_posted
$index = 1;
$requete = "";
$requete2 = "";
$resultat = mysql_query("select CF_topics.idtopic, idforum, sujet, CF_topics.date as date, nbrep, nbvues, datederrep, derposter, idderpost, pseudo, userid, idFirstPost, tmp_sondage.date as dateSondage, question
from (CF_topics, CF_user, tmp_postopic) left join tmp_sondage
on (tmp_sondage.idTopic = CF_topics.idtopic)
where login = derposter and
tmp_postopic.idTopic = CF_topics.idtopic
order by CF_topics.idtopic asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
 $sondage = (trim($ligne["question"]) != "");
 $requete .= sprintf("insert into phpbb_topics(topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_replies_real, topic_first_post_id, topic_first_poster_name, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_subject, topic_last_post_time, topic_last_view_time, poll_title, poll_start, poll_length, poll_max_options, poll_last_vote, poll_vote_change) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 1, %s, 0);\n",
 $ligne["idtopic"],
 $ligne["idforum"],
 getDBParam($ligne["sujet"]),
 shiftUser($ligne["userid"]),
 $ligne["date"],
 $ligne["nbvues"],
 $ligne["nbrep"],
 $ligne["nbrep"],
 $ligne["idFirstPost"],
 getDBParam($ligne["pseudo"]),
 $ligne["idderpost"],
 shiftUser($ligne["userid"]),
 getDBParam($ligne["derposter"]),
 getDBParam($ligne["sujet"]),
 $ligne["datederrep"],
 $ligne["datederrep"],
 getDBParam($ligne["question"]),
 (($sondage)?$ligne["dateSondage"]:0),
 (($sondage)?1296000:0),
 (($sondage)?($ligne["dateSondage"] + 1209600):0));
 $requete2 .= sprintf("insert ignore into phpbb_topics_posted(user_id, topic_id, topic_posted) values (%s, %s, 1);\n",
 shiftUser($ligne["userid"]),
 $ligne["idtopic"]);
 $index++;
}
$session = fopen("topic.sql", "w");
fwrite($session, $requete);
fclose($session);
echo "table topics : ".($index - 1). " ligne(s)<br/>";
$session = fopen("topics_posted.sql", "w");
fwrite($session, $requete2);
fclose($session);
echo "table topics_posted : ".($index - 1). " ligne(s)<br/>";

//users & user_group
$index = 1;
$requete = "";
$requete2 = "";
$resultat = mysql_query("select userid, login, registerdate, usermail, lastpost, usermsg
from CF_user
order by userid asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
 $requete .= sprintf("insert into phpbb_users(user_id, group_id, user_permissions, user_ip, user_regdate, username, username_clean, user_password, user_email, user_email_hash, user_posts, user_lang, user_timezone, user_dst) values (%s, 2, 0x3030303030303030303036787271656977770a716c633470693030303030300a716c617135323030303030300a716c633470693030303030300a716c633470693030303030300a716c63347069303030303030, '127.0.0.1', %s, %s, %s, 'zzzzzzzzzzzzzzzzzzzzzz', %s, %s, %s, 'fr', '1.0', 1);\n",
 shiftUser($ligne["userid"]), $ligne["registerdate"], getDBParam($ligne["login"]),
 getDBParam(strtolower(trim(preg_replace('# {2,}#', ' ', preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $ligne["login"]))))), getDBParam($ligne["usermail"]), sprintf('%u', crc32(strtolower($ligne["usermail"]))).strlen($ligne["usermail"]), $ligne["usermsg"]);
 $requete2 .= sprintf("insert into phpbb_user_group(user_id, group_id, user_pending) values (%s, 2, 0);\n", shiftUser($ligne["userid"]));
 $index++;
}
$session = fopen("user.sql", "w");
fwrite($session, $requete);
fclose($session);
echo "table users : ".($index - 1). " ligne(s)<br/>";
$session = fopen("user_group.sql", "w");
fwrite($session, $requete2);
fclose($session);
echo "table user_group : ".($index - 1). " ligne(s)<br/>";

//posts
$index = 1;
$requete = "";
$resultat = mysql_query("select idpost, idforum, sujet, date, parent, msg, pseudo, postip, userid
from CF_posts, CF_user
where login = pseudo
order by idPost asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
 $message = transformeBalise($ligne["msg"]);
 $requete .= sprintf("insert into phpbb_posts(post_id, topic_id, forum_id, poster_id, poster_ip, post_time, post_subject, post_text, post_checksum, bbcode_bitfield, bbcode_uid) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, '/4A=', '2eax45kp');\n",
 $ligne["idpost"], $ligne["parent"], $ligne["idforum"], shiftUser($ligne["userid"]),
 getDBParam($ligne["postip"]), $ligne["date"], getDBParam($ligne["sujet"]), getDBParam($message), getDBParam(md5($message)));
 $index++;
}
$session = fopen("posts.sql", "w");
fwrite($session, $requete);
fclose($session);
echo "table posts : ".($index - 1). " ligne(s)<br/>";

//poll_options & poll_votes
$index = 1;
$index2 = 1;
$requete = "";
$requete2 = "";
$resultat = mysql_query("select id, idTopic, date, question, choix, rep, votants
from tmp_sondage");
while ($ligne = mysql_fetch_assoc($resultat)) {
 $tChoix = explode(" >> ", $ligne["choix"]);
 $tReponse = explode(" >> ", $ligne["rep"]);
 for ($i = 0; $i < count($tChoix); $i++) {
  $requete .= sprintf("insert into phpbb_poll_options(poll_option_id, topic_id, poll_option_text, poll_option_total) values (%s, %s, %s, %s);\n",
$i + 1, $ligne["idTopic"], getDBParam($tChoix[$i]), $tReponse[$i]);
  for ($j = 0; $j < $tReponse[$i]; $j++) {
   $requete2 .= sprintf("insert into phpbb_poll_votes(topic_id, poll_option_id, vote_user_id, vote_user_ip) values (%s, %s, 2, '127.0.0.1');\n",
   $ligne["idTopic"],
   $i + 1);
   $index2++;
  }
  $index++;
 }
}
$session = fopen("poll_options.sql", "w");
fwrite($session, $requete);
fclose($session);
echo "table poll_options : ".($index - 1). " ligne(s)<br/>";
$session = fopen("poll_votes.sql", "w");
fwrite($session, $requete2);
fclose($session);
echo "table poll_votes : ".($index2 - 1). " ligne(s)<br/>";

mysql_query("drop table if exists tmp_postopic");
mysql_query("drop table if exists tmp_sondage");

function getDBParam($valeur)
{
 if (get_magic_quotes_gpc()) $valeur = stripslashes($valeur);
 return "'".mysql_real_escape_string($valeur)."'";
}
function shiftUser($idUser) // pour ne pas écraser les users existants dans phpbb :  à adapter
{
 $retour = ($idUser <= 53) ? $idUser + 4349 : $idUser;
 return $retour;
}
function transformeBalise($message)
{
 $retour = $message;
 $retour = str_replace("<br>", "", $retour);
 $retour = str_replace("<br />", "", $retour);
 $retour = str_replace("\r", "", $retour);
 $retour = str_replace("[bold]", "[b:2eax45kp]", $retour);
 $retour = str_replace("[/bold]", "[/b:2eax45kp]", $retour);
 $retour = str_replace("[under]", "[u:2eax45kp]", $retour);
 $retour = str_replace("[/under]", "[/u:2eax45kp]", $retour);
 $retour = str_replace("[ita]", "[i:2eax45kp]", $retour);
 $retour = str_replace("[/ita]", "[/i:2eax45kp]", $retour);
 $retour = str_replace("[center]", "", $retour);
 $retour = str_replace("[/center]", "", $retour);
 $retour = str_replace("[middle]", "", $retour);
 $retour = str_replace("[/middle]", "", $retour);
 $retour = str_replace("[left]", "", $retour);
 $retour = str_replace("[/left]", "", $retour);
 $retour = str_replace("[right]", "", $retour);
 $retour = str_replace("[/right]", "", $retour);
 $retour = str_replace("[quote]", "[quote:2eax45kp]", $retour);
 $retour = str_replace("[/quote]", "[/quote:2eax45kp]", $retour);
 $retour = str_replace("[quote4]", "", $retour);
 $retour = str_replace("[/quote4]", "", $retour);
 $retour = str_replace("[quote5]", "", $retour);
 $retour = str_replace("[/quote5]", "", $retour);
 $retour = str_replace("[quote6]", "", $retour);
 $retour = str_replace("[/quote6]", "", $retour);
 $retour = str_replace("[code]", "[code:2eax45kp]", $retour);
 $retour = str_replace("

Code : Tout sélectionner

<?php
$host	= "xxx"; // serveur hôte
$user	= "xxx";	// nom d'utilisateur
$pass	= "xxx";	// mot de passe de connexion
$bdd	= "xxx";	// nom de la base de données

$connexion = mysql_connect($host, $user, $pass);
mysql_select_db($bdd, $connexion);

// table temporaire de premiers messages par topic
mysql_query("drop table if exists postopic");
mysql_query("create table if not exists postopic (
  idTopic int(11) NOT NULL,
  idFirstPost int(11) NOT NULL,
  PRIMARY KEY (idTopic), KEY idFirstPost (idFirstPost)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs");
mysql_query("insert into postopic(idTopic, idFirstPost) 
select idtopic, CF_firstPost.idPost 
from CF_topics, (select min(idpost) as idPost, parent from CF_posts group by parent) as CF_firstPost
where CF_topics.idtopic = CF_firstPost.parent");

// forum
$index = 1;
$requete = "";
$resultat = mysql_query("select forumid, forumtitle, forumcomment, forumtopic, forumposts, lastTopic.sujet, lastTopic.idderpost, lastTopic.userid, lastTopic.derposter, lastTopic.datederrep
from CF_forums, 
(
select CF_topics.idforum, sujet, idderpost, userid, derposter, datederrep as datederrep
from CF_topics, CF_user, (select idforum, max(idderpost) as maxpost from CF_topics group by idforum) as lastPost
where CF_topics.derposter = CF_user.login
and idderpost in (lastPost.maxpost)
) as lastTopic
where forumid = idforum
order by forumid asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
	$requete .= sprintf("insert into forums(forum_id, left_id, right_id, forum_name, forum_desc, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_type, prune_days) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, 1, 7);\n", 
$ligne["forumid"], 2 * $index - 1, 2 * $index, getDBParam($ligne["forumtitle"]), getDBParam($ligne["forumcomment"]), $ligne["forumposts"], $ligne["forumtopic"], 
$ligne["forumtopic"] , $ligne["idderpost"], shiftUser($ligne["userid"]), getDBParam($ligne["sujet"]), $ligne["datederrep"], getDBParam($ligne["derposter"]));
	$index++;
}
$session = fopen("forum.sql", "w");
fwrite($session, $requete);
fclose($session);
echo $index. " forums importés<br/>";

// topic & topics_posted
$index = 1;
$requete = "";
$requete2 = "";
$resultat = mysql_query("select CF_topics.idtopic, idforum, sujet, date, nbrep, nbvues, datederrep, derposter, idderpost, pseudo, userid, idFirstPost
from CF_topics, CF_user, postopic
where login = derposter and
postopic.idTopic = CF_topics.idtopic
order by CF_topics.idtopic asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
	$requete .= sprintf("insert into topics(topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_replies_real, topic_first_post_id, topic_first_poster_name, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_post_subject, topic_last_post_time, topic_last_view_time) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);\n", 
$ligne["idtopic"], $ligne["idforum"], getDBParam($ligne["sujet"]), shiftUser($ligne["userid"]), 
$ligne["date"], $ligne["nbvues"], $ligne["nbrep"], $ligne["nbrep"], $ligne["idFirstPost"], getDBParam($ligne["pseudo"]), $ligne["idderpost"], 
shiftUser($ligne["userid"]), getDBParam($ligne["derposter"]), 
getDBParam($ligne["sujet"]), $ligne["datederrep"], $ligne["datederrep"]);
	$requete2 .= sprintf("insert ignore into topics_posted(user_id, topic_id, topic_posted) values (%s, %s, 1);\n", shiftUser($ligne["userid"]), $ligne["idtopic"]);
	$index++;
}
$session = fopen("topic.sql", "w");
fwrite($session, $requete);
fclose($session);
echo $index. " topics importés<br/>";
$session = fopen("topics_posted.sql", "w");
fwrite($session, $requete2);
fclose($session);
echo $index. " topics_posted importés<br/>";

//users & user_group
$index = 1;
$requete = "";
$requete2 = "";
$resultat = mysql_query("select userid, login, registerdate, usermail, lastpost, usermsg
from CF_user
order by userid asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
	$requete .= sprintf("insert into users(user_id, group_id, user_permissions, user_ip, user_regdate, username, username_clean, user_password, user_email, user_email_hash, user_posts, user_lang, user_timezone, user_dst) values (%s, 2, 0x3030303030303030303036787271656977770a716c633470693030303030300a716c617135323030303030300a716c633470693030303030300a716c633470693030303030300a716c63347069303030303030, '127.0.0.1', %s, %s, %s, 'zzzzzzzzzzzzzzzzzzzzzz', %s, %s, %s, 'fr', '1.0', 1);\n", 
shiftUser($ligne["userid"]), $ligne["registerdate"], getDBParam($ligne["login"]), 
getDBParam(strtolower(trim(preg_replace('# {2,}#', ' ', preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $ligne["login"]))))), getDBParam($ligne["usermail"]), sprintf('%u', crc32(strtolower($ligne["usermail"]))).strlen($ligne["usermail"]), $ligne["usermsg"]);
	$requete2 .= sprintf("insert into user_group(user_id, group_id, user_pending) values (%s, 2, 0);\n", shiftUser($ligne["userid"]));
	$index++;
}
$session = fopen("user.sql", "w");
fwrite($session, $requete);
fclose($session);
echo $index. " users importés<br/>";
$session = fopen("user_group.sql", "w");
fwrite($session, $requete2);
fclose($session);
echo $index. " user_group importés<br/>";

//posts
$index = 1;
$requete = "";
$resultat = mysql_query("select idpost, idforum, sujet, date, parent, msg, pseudo, postip, userid
from CF_posts, CF_user
where login = pseudo
order by idPost asc");
while ($ligne = mysql_fetch_assoc($resultat)) {
	$message = transformeBalise($ligne["msg"]);
	$requete .= sprintf("insert into posts(post_id, topic_id, forum_id, poster_id, poster_ip, post_time, post_subject, post_text, post_checksum, bbcode_bitfield, bbcode_uid) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, '/4A=', '2eax45kp');\n", 
$ligne["idpost"], $ligne["parent"], $ligne["idforum"], shiftUser($ligne["userid"]), 
getDBParam($ligne["postip"]), $ligne["date"], getDBParam($ligne["sujet"]), getDBParam($message), getDBParam(md5($message)));
	$index++;
}
$session = fopen("posts.sql", "w");
fwrite($session, $requete);
fclose($session);
echo $index. " posts importés<br/>";

mysql_query("drop table if exists postopic");

function getDBParam($valeur)
{
	if (get_magic_quotes_gpc()) $valeur = stripslashes($valeur);
	return "'".mysql_real_escape_string($valeur)."'";
}
function shiftUser($idUser) // pour ne pas écraser les users existants dans phpbb :  à adapter
{
	$retour = $idUser;
	switch ($idUser) {
		case 1:
			$retour = 53;
			break;
		case 7:
			$retour = 54;
			break;
		case 32:
			$retour = 55;
			break;
	}
	return $retour;
}
function transformeBalise($message)
{
	$retour = $message;
	$retour = str_replace("<br>", "", $retour);
	$retour = str_replace("<br />", "", $retour);
	$retour = str_replace("\r", "", $retour);
	$retour = str_replace("[bold]", "[b:2eax45kp]", $retour);
	$retour = str_replace("[/bold]", "[/b:2eax45kp]", $retour);
	$retour = str_replace("[under]", "[u:2eax45kp]", $retour);
	$retour = str_replace("[/under]", "[/u:2eax45kp]", $retour);
	$retour = str_replace("[ita]", "[i:2eax45kp]", $retour);
	$retour = str_replace("[/ita]", "[/i:2eax45kp]", $retour);
	$retour = str_replace("[center]", "", $retour);
	$retour = str_replace("[/center]", "", $retour);
	$retour = str_replace("[middle]", "", $retour);
	$retour = str_replace("[/middle]", "", $retour);
	$retour = str_replace("[left]", "", $retour);
	$retour = str_replace("[/left]", "", $retour);
	$retour = str_replace("[right]", "", $retour);
	$retour = str_replace("[/right]", "", $retour);
	$retour = str_replace("[quote]", "[quote:2eax45kp]", $retour);
	$retour = str_replace("[/quote]", "[/quote:2eax45kp]", $retour);
	$retour = str_replace("[quote4]", "", $retour);
	$retour = str_replace("[/quote4]", "", $retour);
	$retour = str_replace("[quote5]", "", $retour);
	$retour = str_replace("[/quote5]", "", $retour);
	$retour = str_replace("[quote6]", "", $retour);
	$retour = str_replace("[/quote6]", "", $retour);
	$retour = str_replace("[code]", "[code:2eax45kp]", $retour);
	$retour = str_replace("