<?php

include("wp-config.php");

echo "
--<br>
-- Table structure for table `users`<br>
--<br>
<br>
DROP TABLE IF EXISTS `users`;<br>
CREATE TABLE IF NOT EXISTS `users` (<br>
  `id` int(11) NOT NULL AUTO_INCREMENT,<br>
  `username` varchar(50) NOT NULL,<br>
  `password` varchar(50) NOT NULL,<br>
  `membership_id` tinyint(3) NOT NULL DEFAULT '0',<br>
  `mem_expire` datetime DEFAULT '0000-00-00 00:00:00',<br>
  `trial_used` tinyint(1) NOT NULL DEFAULT '0',<br>
  `email` varchar(32) NOT NULL,<br>
  `fname` varchar(32) NOT NULL,<br>
  `lname` varchar(32) NOT NULL,<br>
  `token` varchar(40) NOT NULL DEFAULT '0',<br>
  `newsletter` tinyint(1) NOT NULL DEFAULT '0',<br>
  `userlevel` tinyint(1) NOT NULL DEFAULT '1',<br>
  `created` datetime DEFAULT '0000-00-00 00:00:00',<br>
  `lastlogin` datetime DEFAULT '0000-00-00 00:00:00',<br>
  `lastip` varchar(16) DEFAULT '0',<br>
  `access` text,<br>
  `active` enum('y','n','t','b') NOT NULL DEFAULT 'n',<br>
  PRIMARY KEY (`id`)<br>
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br>
<br>
--<br>
-- Dumping data for table `users`<br>
--<br>
<br>
";

$userselect = "SELECT * FROM `wp_users`";
$result = mysql_query($userselect);

while($userrow = mysql_fetch_array($result))
{
$username = $userrow['user_login'];
$password = $userrow['user_pass'];
$email = $userrow['user_email'];
$id = $userrow['ID'];

$meta_value = "SELECT user_id FROM `wp_usermeta` WHERE `meta_value` LIKE '%administrator%'";
$metaselect = mysql_query($meta_value);

$metarow = mysql_fetch_array($metaselect);
echo $row['user_id'];

echo $metarow['user_id'];
echo "-";
echo $id;
if ($id == $metarow['user_id']){
echo "hi";
echo "<br>";
}
else{
echo "no";
}
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";
echo "INSERT INTO `users` (`id`, `username`, `password`, `membership_id`, `mem_expire`, `trial_used`, `email`, `fname`, `lname`, `token`, `newsletter`, `userlevel`, `created`, `lastlogin`, `lastip`, `access`, `active`) VALUES (".$id.", '".$username."', '".$password."', 0, '0000-00-00 00:00:00', 0, '".$email."', '', '', '0', 0, 9, '1969-01-01 12:00:00', '1969-01-01 12:00:00', '127.0.0.1', NULL, 'y');";
echo "<br>";
echo "<br>";
echo "<br>";
echo "<br>";

}

?>