<?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);
?>