2010-11-15, 05:45 PM
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 ;
Example from database
Database structure
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
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