MyBB Community Forums

Full Version: Help me with script Ucoz >> MYBB
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
so i found a script that inserts users from ucoz to SMF but i don't wanna install SMF 2 RC3 and after that to merge them to MYBB so script is something like this ;

if(isset($_GET['step1']))
{
$filename = "../ucoz/_s1/users.txt";

$fd = fopen($filename, "r");

$i = 0;

mysql_query("SET CHARACTER SET cp1251");

echo "Ëîã êîâåðòèðîâàíèÿ<br>";
	while (!feof ($fd)) 
		{
 
			$bufer[$i] = fgets($fd, 4096);
			
			$bufer[$i] = iconv("UTF-8", "Windows-1251", "$bufer[$i]");
			 			
			$arr = explode("|", $bufer[$i]);
	
			$i++;
			if($arr[0] != ""){
			
			$query = "INSERT IGNORE INTO smf_members (`member_ip`,`birthdate`,`last_login`,`id_group`,`member_name`,`real_name`,`is_activated`,`email_address`, `passwd`, `posts`, `date_registered`, `icq`) VALUES
('$arr[16]','$arr[22]','$arr[2]','4','$arr[0]','$arr[5]','1','$arr[7]', '$arr[2]', '0', '$arr[15]', '$arr[9]');
";
			$result = mysql_query($query);
			
			 if(!$result) { echo ("<font color=red>MySQL âåðíóëà îøèáêó <br><
			 <br></font>");} else echo "<textarea name=\"html\" style=\"width:600px; height:100px\" cols=\"60\" rows=\"5\" tabindex=\"1\">
Ïîëüçîâàòåëü «$arr[0]» óñïåøíî ñêîíâåðòèðîâàí	</textarea>";
			 }
			
		}
		
fclose($fd);
	
}

Example from database
interaser10|0|$1$xcXQ$NIloxqFf6GLvSu2/HNb2o1||19|Val K|1|[email protected]||414220037|125|||||1270405864|92.115.132.229|6fifamania||Da|ADSL|1|1985-05-24|0||1270405864

val3ntyno|0|$1$fNVI$8xfpTCYmLh4E7VGVAnHQa0||19|Miscov Valentin|1|[email protected]|||168|||||1270414190|79.114.32.23|6fifamania||DA|LAN|1|1991-09-18|102606088||1270414190

Database structure
user
unetID
password
avatar
flags
fullname
gender
email
homepage
icq
country
state
city
signature
title
regdate
ip
o ld-field
aol
msn
yahoo
ispm
birthday
verify
options
lastmodified



ok i have script and databases and it's structure can someone just edit this and make it for mybb :\ i think for someone who has experience with mybb can do this easy