/***************************************************************
Loads the given instance from the database and returns
a new Instance object.
****************************************************************/
CInstance* loadInstance(CInstanceHandler* hand, uint16 bcnmid, INSTANCETYPE type){
const int8* fmtQuery = "SELECT name, bcnmId, fastestName, fastestTime, timeLimit, levelCap, lootDropId, rules, partySize, zoneId \
FROM bcnm_info \
WHERE bcnmId = %u";
int32 ret = Sql_Query(SqlHandle, fmtQuery, bcnmid);
if (ret == SQL_ERROR ||
Sql_NumRows(SqlHandle) == 0 ||
Sql_NextRow(SqlHandle) != SQL_SUCCESS)
{
ShowError("Cannot load instance BCNM:%i \n",bcnmid);
}
else
{
CInstance* PInstance = new CInstance(hand,Sql_GetUIntData(SqlHandle,1), type);
int8* tmpName;
Sql_GetData(SqlHandle,0,&tmpName,NULL);
PInstance->setBcnmName(tmpName);
PInstance->setTimeLimit(Sql_GetUIntData(SqlHandle,4));
PInstance->setLevelCap(Sql_GetUIntData(SqlHandle,5));
PInstance->setLootId(Sql_GetUIntData(SqlHandle,6));
PInstance->setMaxParticipants(Sql_GetUIntData(SqlHandle,8));
PInstance->setZoneId(Sql_GetUIntData(SqlHandle,9));
PInstance->m_RuleMask = (uint16)Sql_GetUIntData(SqlHandle,7);
return PInstance;
}
return NULL;
}
