".print_r($results)."

"; echo "

e-Commerce Subscribers

"; echo ""; echo ""; echo ""; echo ""; if ($results != NULL){ $now = time(); foreach ($results as $user){ $user_info = $wpdb->get_results('SELECT * FROM '.$wpdb->prefix.'users WHERE id='.$user['user_id'], ARRAY_A); $user_subscription = $wpdb->get_results('SELECT active FROM '.$wpdb->prefix.'wpsc_logged_subscriptions WHERE user_id='.$user['user_id'].' AND start_time < '.$now.' AND (start_time+length) > '.$now.'',ARRAY_A); //echo "

".print_r($user_info,true)."

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } echo "

".TXT_WPSC_USERID."	".TXT_WPSC_NAME."	".TXT_WPSC_EMAIL."	".TXT_WPSC_REGISTEREDDATE."	".TXT_WPSC_SUSPEND."/".TXT_WPSC_ACTIVATE."
"; echo $user_info[0]['ID']; echo "	"; echo $user_info[0]['display_name']; echo "	"; echo $user_info[0]['user_email']; echo "	"; echo $user_info[0]['user_registered']; echo "	"; if ($user_subscription[0]['active']==1) { echo ""; } else { echo ""; } echo "

"; echo "