Integrating with other Database

So I am writing a custom plugin to integrate with another database so I can pull the subscription data I have been following the instructions here http://manual.amember.com/Creating_New_Integration_Plugins and I cannot seem to find any guidance on how to write custom SQL queries against the integrated database. I am assuming that we use something like

Code:

function recipes_integration_rebuild(&$members){
    global $config, $db, $plugin_config;
    $this_config = $plugin_config['protect']['recipes_integration'];
    foreach( $members as $login => $rec ) 
	{
		
		$s =  mysql_query(SELECT count(username)  FROM users WHERE username='$member[login]');
		$count = mysql_result($s,0);
		if($count==0)
		{
			//Add the user
			$t =  mysql_query(INSERT INTO users VALUES(WHERE username='$member[login]');

......

but as far as I can tell the $members only contains the loginname and the product array (per the referenced instructions) and so how do I get the password and email etc to add the new user to the integrated database.

Do you recommend an easier way to get to what I am trying to do. Basically I want a c# application to call a web service that tells me whether the user has an active subscription and that is is....

thanks... A

Cool, thanks, I ended up getting all the products and looping through them using foreach and converting the dates to a timestamp and then getting last valid expiry date which I brought back into the application and then did Simple AES encryption on that and store it as a variable in the settings class, for comparison while the app is running as this only meant a single ping against the server. I also on app first run require the data to register someone and add a free product registration into the amember database. Finally I put all the functions into a webservices WSDL

PHP:

include("config.inc.php");
    $q= $db->query($sql = "SELECT member_id FROM {$db->config[prefix]}members WHERE login = '$username' and pass='$password'");
    $member_id=getDataResult($q);
    
    $p=$db->get_user_payments($member_id, $completed) ;
    
    $i = 0;
    $validproduct =0;
    $finaltimestamp=0; 
    foreach ($p as $k => $v) 
    {
        
        foreach ($v as $y => $v2) 
        {
                //echo "$y:$v2\n";
            if($y=='product_id')
            {
                if($v2==1 || $v2==2 || $v2==3)
                {
                    $validproduct=1;
                }
            }
            if($y=='expire_date' && $validproduct==1)
            {
                //echo 'date is '.$v2.'<br>';
                list($year, $month, $day) = explode('-', $v2);
                $timestamp = mktime(0, 0, 0, $month, $day, $year);
                
                if($timestamp >$finaltimestamp)
                {    
                    $finaltimestamp = $timestamp;
                }
            }
            
            }
            $validproduct=0;
        $i++;
    }

    $bestdate = getdate($finaltimestamp);
    //print_r($bestdate);
    $result['year']=$bestdate['year'];
    $result['month']=sprintf("%02d", $bestdate['mon']);
    $result['day']=sprintf("%02d", $bestdate['mday']);
    return $result;


If there is something in there that is bad let me know...
Many thanks works a treat.... Andrew