#pragma once

class CKnightsUserSet : public OdbcRecordset
{
public:
	CKnightsUserSet(OdbcConnection * dbConnection, void * dummy) 
		: OdbcRecordset(dbConnection) {}

	virtual tstring GetTableName() { return _T("KNIGHTS_USER"); }
	virtual tstring GetColumns() { return _T("sIDNum, strUserID, nDonatedNP"); }

	virtual bool Fetch()
	{
		uint16 sIDNum;
		std::string strUserID;
		uint32 nDonatedNP;

		_dbCommand->FetchUInt16(1, sIDNum);
		_dbCommand->FetchString(2, strUserID);
		_dbCommand->FetchUInt32(3, nDonatedNP);

		CKnightsManager::AddKnightsUser(sIDNum, strUserID);
		CKnightsManager::LoadUserDonatedNP(sIDNum, strUserID, nDonatedNP, false);
		return true;
	}
};