Only has an impact on the mod user's experience, even if said player is the host. The two most common types of clientside mod are texture and sound mods these modify the textures or sounds of various objects, characters or environment. ClientSide (/Mod_override) mods are generally safe to use in online play - they often have little (if any) impact on the experience of other users, and will be unnoticeable to other players.
