$stmt->execute(); $stmt->close(); LogLine("{$locale} tblDBCPet"); $battlePetReader = new Reader($dirnm . '/BattlePetSpecies.db2'); $battlePetReader->setFieldNames(['npc']); $creatureReader = new Reader($dirnm . '/Creature.db2'); $creatureReader->setFieldNames([4 => 'name']); $stmt = $db->prepare("insert into tblDBCPet (id, name_{$locale}) values (?, ?) on duplicate key update name_{$locale} = values(name_{$locale})"); $species = $name = null; $stmt->bind_param('is', $species, $name); $x = 0; $recordCount = count($battlePetReader->getIds()); foreach ($battlePetReader->generateRecords() as $id => $rec) { EchoProgress(++$x / $recordCount); $species = $id; $creature = $creatureReader->getRecord($rec['npc']); if (is_null($creature)) { continue; } $name = $creature['name']; $stmt->execute(); } $stmt->close(); EchoProgress(false); unset($creatureReader); unset($battlePetReader); /* */ } /* */ LogLine("Done.\n"); function LogLine($msg)