Creating users ..."; $query = "SELECT * FROM ".$dbprefix."users"; $result = mysql_query($query); while ($register = mysql_fetch_assoc($result)){ //Simple users $pending[]="INSERT INTO ".$destdbprefix."users set id='$register[id]', user_login='$register[username]', user_pass=MD5('$admin_passwd'), user_nicename='$register[username]', user_email='$register[email]', user_registered='$register[registerDate]', display_name='$register[username]'"; $usernames[]=$register[username]; $ids[]=$register[id]; //Stuff For comments $username=$register[username]; $user[$username]=$register[id]; //Roles if($register[usertype] == "Super Administrator"){ $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='wp_capabilities', meta_value='a:1:{s:13:\"administrator\";b:1;}'"; $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='wp_user_level', meta_value='10'"; } else if($register[usertype] == "Author"){ $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='wp_capabilities', meta_value='a:1:{s:6:\"author\";b:1;}'"; $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='wp_user_level', meta_value='2'"; } else { $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='wp_capabilities', meta_value='a:1:{s:10:\"subscriber\";b:1;}'"; } $metas[]="INSERT INTO ".$destdbprefix."usermeta set user_id='$register[id]', meta_key='last_name', meta_value='$register[name]'"; } //Writing the users table for($i=0;$iDuplicate username at ".$usernames[$i].'
'; die('Please clean the following tables:

• wp_comments
• wp_posts
• wp_terms
• wp_term_taxonomy
• wp_term_relationships
• wp_users
• wp_usermeta
• wp_links

'); } } //Writing the users meta information for($i=0;$idone!.
"; /************************** Categories ***************************/ echo "Creating categories ..."; //Frist sections $query = "SELECT * FROM ".$dbprefix."sections"; $result = mysql_query($query); while ($register = mysql_fetch_assoc($result)){ $sections[]="INSERT INTO ".$destdbprefix."terms set term_id='$register[id]', name='$register[name]', slug='$register[alias]'"; $relations[]="INSERT INTO ".$destdbprefix."term_taxonomy set term_taxonomy_id='$register[id]' , term_id='$register[id]', taxonomy='category', parent='0', description='$register[description]'"; } //Then categories $query = "SELECT * FROM ".$dbprefix."categories"; $result = mysql_query($query); while($register = mysql_fetch_assoc($result)){ $newid=$register[id]+10; if($register[section]=='com_weblinks') { $sections[]="INSERT INTO ".$destdbprefix."terms set term_id='$newid', name='$register[name]', slug='$register[alias]'"; $relations[]="INSERT INTO ".$destdbprefix."term_taxonomy set term_taxonomy_id='$newid' , term_id='$newid', taxonomy='link_category', parent='$register[section]', description='$register[description]'"; } if(is_numeric($register[section])){ $sections[]="INSERT INTO ".$destdbprefix."terms set term_id='$newid', name='$register[name]', slug='$register[alias]'"; $relations[]="INSERT INTO ".$destdbprefix."term_taxonomy set term_taxonomy_id='$newid' , term_id='$newid', taxonomy='category', parent='$register[section]', description='$register[description]'"; } } //And write for($i=0;$idone!.
"; /************************** Posts ***************************/ echo "Creating articles ..."; $query = "SELECT * FROM ".$dbprefix."content"; $result = mysql_query($query); while ($register = mysql_fetch_assoc($result)){ $newid=$register[catid]+10; $posts[]="INSERT INTO ".$destdbprefix."posts set ID='$register[id]', post_author='$register[created_by]' , post_date='$register[created]', post_content='".addslashes($register[introtext]).addslashes($register[fulltext])."', post_title='$register[title]', guid='http://$siteurl?p=$register[id]', post_status='publish', comment_status='open', ping_status='open', post_name='$register[alias]'"; $taxonomy[]="INSERT INTO ".$destdbprefix."term_relationships set object_id='$register[id]', term_taxonomy_id='$register[sectionid]', term_order='0'"; $taxonomy[]="INSERT INTO ".$destdbprefix."term_relationships set object_id='$register[id]', term_taxonomy_id='$newid', term_order='0'"; $count_posts[$register[sectionid]]++; $count_posts2[$newid]++; } for($i=0;$idone!.
"; /************************** Comments ***************************/ echo "Creating comments ..."; $query = "SELECT * FROM ".$dbprefix."mxc_comments"; $result = mysql_query($query); while ($register = mysql_fetch_assoc($result)){ $id=$register[name]; $comments[]="INSERT INTO ".$destdbprefix."comments set comment_post_ID='$register[contentid]', comment_author='$register[name]', comment_author_IP='', comment_date='$register[date]', comment_content='".addslashes($register[title]).' '.addslashes($register[comment])."', comment_karma='0', comment_approved='1', user_id='$user[$id]'"; $count_comments[$register[contentid]]++; } for($i=0;$idone!.
"; /************************** Weblinks ***************************/ echo "Creating weblinks ..."; $query = "SELECT * FROM ".$dbprefix."weblinks"; $result = mysql_query($query); while ($register = mysql_fetch_assoc($result)){ $links[]="INSERT INTO ".$destdbprefix."links set link_id='1000$register[id]', link_url='$register[url]', link_name='$register[title]', link_target='_blank', link_description='$register[description]', link_visible='Y', link_owner='62', link_rating='0'"; $newid=$register[catid]+10; $relate[]="INSERT INTO ".$destdbprefix."term_relationships set object_id='1000$register[id]', term_taxonomy_id='$newid', term_order='0'"; } for($i=0;$idone!.
"; //DONE mysql_close($link); echo "
All Done!"; ?>