that greatly depends on the game actually...

U/UT - Unreal Scripting + C++ DLL linking(optional) (comes with the game)
Quake* - Edit the DLL Source (C/ASM) (download it)
HL - SDK (download it)