When i look on google video, i found a doom style stargate game clip. where can i get the game from?
Http://video.google.co.uk/videoplay?docid=6505181000357226656&q=stargate
Answer
Its an unreal tournament mod. you will need the right version of unreal tournament, then you download the mod. mods are written by people to convert a game reusing parts of the engine.
http://www.utzone.de/include.php?path=content/download.php&contentid=5100
