Simple Machines Community Forum

figured out problem.. thanks anyways.. ( http://www.sazcart.com )

Can ya post what you figured out?  I was interested in doing the same thing . . . . .

umm, let see.. ill just post the code i used.. this is what i do after getting some user info.. you can contact me direct to answer any questions... or to program anything for you

                   $saz = mysql_query("select * from ".$_saz['settings']['smf_prefix']."members where memberName='".$info['un']."'");
                                              if(!$saz){
                                                      print ('<br />Invalid query: ' . mysql_error().'<br /><br />');
                                              }
                   if(mysql_num_rows($saz)!==0){
                           print $_saz['errors']['008'];
                           return false;
                           break;
                   }
                   $saz = mysql_query("select * from ".$_saz['settings']['smf_prefix']."members where emailAddress='".$info['email']."'");
                   if(mysql_num_rows($saz)!==0){
                           print $_saz['errors']['009'];
                           return false;
                           break;
                   }

$memberName = $info['un'];
$emailAddress = $info['email'];
$passwd = $this -> md5_hmac($info['pw'], strtolower($info['un']));
$posts = 0;
$dateRegistered = time();
$memberIP = $_SERVER['REMOTE_ADDR'];
$is_activated = 1;
$realName = $info['un'];
$im_email_notify = 1;
$ID_THEME = 0;
$ID_POST_GROUP = 4;

$saz1 = mysql_query("insert into ".$_saz['settings']['smf_prefix']."members (memberName, emailAddress, passwd, posts, dateRegistered, memberIP, is_activated, realName, im_email_notify, ID_THEME, ID_POST_GROUP) values ('$memberName', '$emailAddress', '$passwd', '$posts', '$dateRegistered', '$memberIP', '$is_activated', '$realName', '$im_email_notify', '$ID_THEME', '$ID_POST_GROUP')");
                      if(!$saz1){
                           print ('<br />Invalid query: ' . mysql_error().'<br /><br />');
return false;
                      }
                      else{
$result = mysql_query("
SELECT COUNT(ID_MEMBER), MAX(ID_MEMBER)
FROM ".$_saz['settings']['smf_prefix']."members");
list ($memberCount, $latestmember) = mysql_fetch_row($result);
mysql_free_result($result);

// Get the latest member's display name.
$result = mysql_query("
SELECT IFNULL(realName, memberName) AS realName
FROM ".$_saz['settings']['smf_prefix']."members
WHERE ID_MEMBER = " . (int) $latestmember . "
LIMIT 1");
list ($latestRealName) = mysql_fetch_row($result);
mysql_free_result($result);

$this -> updateSettings(array(
'latestMember' => $latestmember,
'latestRealName' => $latestRealName,
'memberCount' => $memberCount,
'unapprovedMembers' => $unapprovedCount
));

return true;
                      }

Tony~!