CMS Made Simple Forums

Code: Select all

     
    $q = "SELECT * FROM ".cms_db_prefix()."module_feusers_users WHERE id = ? AND expires > NOW()";
    $dbresult = $db->Execute( $q, array( $uid ) );

Code: Select all

  // userid api function
  // returns array
  function AddUser( $name, $password, $expires )
  {
    $db =& $this->GetDb();
    
    // see if it exists already or not (by name)
    $q = "SELECT * FROM ".cms_db_prefix().
      "module_feusers_users WHERE username = ?";
    $dbresult = $db->Execute( $q, array( $name ) );
    if( !$dbresult )
      {
	return array(FALSE,$db->ErrorMsg());
      }
    $row = $dbresult->FetchRow();
    if( $row )
      {
	$module =& $this->GetModule();
	return array(FALSE,$module->Lang('error_username_exists'));
      }
    
    // generate the sequence
    $uid = 
      $db->GenID( cms_db_prefix()."module_feusers_users_seq" );

    // insert the record
    $q = "INSERT INTO ".cms_db_prefix().
      "module_feusers_users VALUES (?,?,?,?,?)";
    $dbresult = $db->Execute( $q, array( 
			$uid, 
			$name, 
			md5($password), 
			trim( $db->DBTimeStamp(   time()   ) , "'") ,
			trim( $db->DBTimeStamp( $expires ) , "'")
		)
	);
    if( !$dbresult )
      {
	return array(FALSE,$db->ErrorMsg());
      }
    return array(TRUE,$uid);
  }

Code: Select all

  function IsAccountExpired( $uid )
  {
    $db =& $this->GetDb();
    
    $q = "SELECT * FROM ".cms_db_prefix()."module_feusers_users WHERE id = ? AND expires > NOW()";
    $dbresult = $db->Execute( $q, array( $uid ) );

    if( $dbresult && $dbresult->RecordCount() )
      {
	return false;
      }

    return true;
  }