<?php
include (’../wp-config.php’);
$sql_select_command = <<<END
SELECT user_nicename
, meta_value
FROM wp_usermeta
, wp_users
WHERE 1
AND wp_users.ID = wp_usermeta.user_id
AND meta_key = ‘ym_user’
END;
$mysqli = mysqli_connect( constant(‘DB_HOST’), constant(‘DB_USER’), DB_PASSWORD, DB_NAME);
if (!$mysqli) {
printf(“Connect failed: %s\n”, mysqli_connect_error());
exit();
}
if ($result = mysqli_query($mysqli, $sql_select_command) ) { echo ‘
‘;
while ( $row = mysqli_fetch_assoc($result) ) {
echo $row[‘user_nicename’];
print “—>”;
$data = unserialize($row[‘meta_value’]);
print $data->expire_date; // expire_date is contained in the serialize
print “\n”;
}
echo ‘‘;
mysqli_free_result($result);}
mysqli_close($mysqli);
?>