/*************************************************************** 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; }