void ObjectMgr::LoadTransporters() { Log.Notice("TransporterHandler", "Start loading transport_data"); { const char* loadAllTransportData = "SELECT entry, name, period FROM transport_data"; QueryResult* result = WorldDatabase.Query(loadAllTransportData); if (!result) { Log.Error("TransporterHandler", "Query failed: %s", loadAllTransportData); return; } uint32 count = 0; do { Field* field = result->Fetch(); TransporterDataQueryResult dbResult; dbResult.entry = field[0].GetUInt32(); dbResult.name = field[1].GetString(); dbResult.period = field[2].GetUInt32(); GameObjectInfo* goInfo = GameObjectNameStorage.LookupEntry(dbResult.entry); if (goInfo == nullptr) { Log.Error("TransporterHandler", "Transporter gameobject %u not available in GameObjectNameStorage!", dbResult.entry); continue; } Transporter* pTransporter = new Transporter((uint64)HIGHGUID_TYPE_TRANSPORTER << 32 | dbResult.entry); pTransporter->SetInfo(goInfo); if (!pTransporter->CreateAsTransporter(dbResult.entry, "", dbResult.period)) { Log.Error("TransporterHandler", "Transporter %s failed creation for some reason.", dbResult.name.c_str()); delete pTransporter; } else { Log.Debug("TransporterHandler", "%s, Entry: %u, Period: %u loaded", dbResult.name.c_str(), dbResult.entry, dbResult.period); AddTransport(pTransporter); ++count; } } while (result->NextRow()); delete result; Log.Success("TransporterHandler", "%u transporters loaded from table transporter_data", count); } Log.Notice("TransporterHandler", "Start loading transport_creatures"); { const char* loadTransportPassengers = "SELECT transport_entry, creature_entry, position_x, position_y, position_z, orientation FROM transport_creatures"; bool success = false; QueryResult* result = WorldDatabase.Query(&success, loadTransportPassengers); if (!success) { Log.Error("TransporterHandler", "Query failed: %s", loadTransportPassengers); return; } uint32 count = 0; if (result) { do { Field* field = result->Fetch(); uint32 transport_entry = field[0].GetUInt32(); uint32 creature_entry = field[1].GetUInt32(); auto transporter = GetTransporterByEntry(transport_entry); if (transporter == nullptr) { Log.Error("TransporterHandler", "Could not find transporter %u for transport_creatures entry %u", transport_entry, creature_entry); continue; } TransporterCreaturesQueryResult dbResult; dbResult.transport_entry = field[0].GetUInt32(); dbResult.creature_entry = field[1].GetUInt32(); dbResult.position_x = field[2].GetFloat(); dbResult.position_y = field[3].GetFloat(); dbResult.position_z = field[4].GetFloat(); dbResult.orientation = field[5].GetFloat(); transporter->creature_transport_data.push_back(dbResult); transporter->AddNPC(dbResult.creature_entry, dbResult.position_x, dbResult.position_y, dbResult.position_z, dbResult.orientation); ++count; } while (result->NextRow()); delete result; Log.Success("TransporterHandler", "%u transport passengers from table transport_creatures loaded.", count); } } }