phkCtWRf

1<?php
2
3include("wp-config.php");
4
5echo "
6--<br>
7-- Table structure for table `users`<br>
8--<br>
9<br>
10DROP TABLE IF EXISTS `users`;<br>
11CREATE TABLE IF NOT EXISTS `users` (<br>
12  `id` int(11) NOT NULL AUTO_INCREMENT,<br>
13  `username` varchar(50) NOT NULL,<br>
14  `password` varchar(50) NOT NULL,<br>
15  `membership_id` tinyint(3) NOT NULL DEFAULT '0',<br>
16  `mem_expire` datetime DEFAULT '0000-00-00 00:00:00',<br>
17  `trial_used` tinyint(1) NOT NULL DEFAULT '0',<br>
18  `email` varchar(32) NOT NULL,<br>
19  `fname` varchar(32) NOT NULL,<br>
20  `lname` varchar(32) NOT NULL,<br>
21  `token` varchar(40) NOT NULL DEFAULT '0',<br>
22  `newsletter` tinyint(1) NOT NULL DEFAULT '0',<br>
23  `userlevel` tinyint(1) NOT NULL DEFAULT '1',<br>
24  `created` datetime DEFAULT '0000-00-00 00:00:00',<br>
25  `lastlogin` datetime DEFAULT '0000-00-00 00:00:00',<br>
26  `lastip` varchar(16) DEFAULT '0',<br>
27  `access` text,<br>
28  `active` enum('y','n','t','b') NOT NULL DEFAULT 'n',<br>
29  PRIMARY KEY (`id`)<br>
30) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br>
31<br>
32--<br>
33-- Dumping data for table `users`<br>
34--<br>
35<br>
36";
37
38$userselect = "SELECT * FROM `wp_users`";
39$result = mysql_query($userselect);
40
41while($userrow = mysql_fetch_array($result))
42{
43$username = $userrow['user_login'];
44$password = $userrow['user_pass'];
45$email = $userrow['user_email'];
46$id = $userrow['ID'];
47
48$meta_value = "SELECT meta_value FROM `wp_usermeta` WHERE user_id='$id' AND meta_key='wp_capabilities'";
49$metaselect = mysql_query($meta_value);
50
51$metarow = mysql_fetch_array($metaselect);
52echo $row['user_id'];
53
54echo $metarow['user_id'];
55echo "-";
56echo $id;
57if (preg_match('/administrator/',$metarow['meta_value'])){
58echo "hi";
59echo "<br>";
60}
61else{
62echo "no";
63}
64echo "<br>";
65echo "<br>";
66echo "<br>";
67echo "<br>";
68echo "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');";
69echo "<br>";
70echo "<br>";
71echo "<br>";
72echo "<br>";
73
74}
75
76?>