In 1.3, the game works as a server. In theory, all mods would work in SMP if made after that point. But a lot of mods definitely would have trouble converting to SMP for functionality. They want Minecraft 1.4 to have the Mod API, we'll see. Should at least get partially implemented by then.