How do I install Half-Life 1 and 2?

Question

I'm trying to take the data from multiple tables and import them into other tables. The destination use identity id's and the source tables have different id's. I need to get the new identity id's from the inserts and add them to another table in the destination DB. Here is what I have so far but not sure how to get it to work. I tried adding the TMMYId to the OUTPUT but that isn't working.

DECLARE @MakeModels TABLE (MakeId int, ModelId int, YearId int, TMMYId int)

INSERT INTO @MakeModels (MakeId, ModelId, YearId, TMMYId)
SELECT MakeID, ModelID, YearID, T.id TypeMakeModelYear T 
JOIN Fitment F 
ON F.TMMYID = T.id JOIN PartToAppCombo P ON F.PartToAppComboID = P.ID
WHERE P.PartmasterID IN (SELECT PP.PartMasterID FROM PartPriceInv PP WHERE Discontinued   
= 0)

DECLARE @MakeOutput TABLE (MakeId int, TMMYId int)
DECLARE @ModelOutput TABLE (ModelId int, TMMYId int)
DECLARE @YearOutput TABLE (YearId int, TMMYId int)

INSERT INTO Class1 (Name, Active) 
OUTPUT INSERTED.Class1Id, MM.TMMYId INTO @MakeOutput
SELECT M.Description, 1 FROM Makes M JOIN @MakeModels MM ON M.id = MM.MakeId
WHERE NOT EXISTS (SELECT Class1Id FROM Class1 WHERE Name = M.Description )

INSERT INTO Class2 (Name, Active) 
OUTPUT INSERTED.Class2Id, MM.TMMYId INTO @ModelOutput
SELECT M.Description, 1 FROM Models M JOIN @MakeModels MM ON M.id = MM.ModelId
WHERE NOT EXISTS (SELECT Class2Id FROM Class2 WHERE Name = M.Description)

INSERT INTO Class3 (Name, Active) 
OUTPUT INSERTED.Class3Id, MM.TMMYId INTO @YearOutput
SELECT M.Description, 1 FROM Years M JOIN @MakeModels MM ON M.id = MM.YearId
WHERE NOT EXISTS (SELECT Class3Id FROM Class3 WHERE Name = M.Description)

INSERT INTO MMY (class1Id, class2Id, class3Id) 
SELECT M.MakeId, MO.ModelId, Y.YearId FROM @MakeOutput M JOIN @ModelOutput MO ON    
M.TMMYId = MO.TMMYId
JOIN @YearOutput Y ON MO.TMMYId = Y.TMMYId

Solution 1

If you came here to play HL, HL2 or any other Steam for Linux released game see How can I install Steam? for the answer which is a lot simpler than this. This one only apply to games outside the Steam environment or not yet on steam. Also know that Half-Life is natively supported in Ubuntu. Most likely HL2 will follow.

To play both, HL and HL2 (Not through steam) you first need the Wine PPA (It is much better than the actual version that comes with Ubuntu). So first install the Wine PPA (Does not matter if you already have PlayOnLinux installed). PlayOnLinux can work without the need of having Wine installed since it will eventually download its own version of Wine if it detects you do not have one (Including addons which are similar in use as winetricks). It also downloads specific Wine versions even if you have Wine install for some specific cases (Some games in PoL depend on specific Wine versions).

If you use Wine PPA or PlaOnLinux the game should work with no problem.

1. Follow this guide to install the latest Wine: http://www.winehq.org/download/ubuntu

2. After that go to Software Center and look for Wine with version 1.5.x. Right now it is 1.5.23. Install it. You can also install it via the terminal with sudo apt-get install wine.

3. Download PlayOnLinux from their website and install it.

4. Execute PlayOnLinux at least once so it can download the needed Fonts and configures itself for use.

5. If you try to run the games with Wine, first try to download, any needed libraries and additional packages the game needs. This can be done with winetricks. You can run winetricks from the Dash or from the terminal like winetricks --gui. For HL, HL2 and many other games I have tested, including but not limited to: Trine, Trine2, Portal, Portal2 and many others I recommend the following Winetricks installation:

   Open Winetricks and select Select the default wineprefix

   

   Select **Install a windows DLL or component

   

   Install all that I have marked (and any additional you need for a specific app). This should cover many apps and games. I have not had any additional problems after installing this with many games:

   

   

   

   

   The Physx component, even if you do not have Nvidia, you still need to install it for games that require it.

   Now simply right click the installer for HL1 or HL2 and select Open with Wine. Tested again with both games. Working perfectly (Not the Steam version, only the older CD/DVD versions).

6. If you try to run the game through PlayOnLinux, the app will guide you step by step on how to install the game and will take care of many aspects of it's installation including needed DLL and other components to make it work right.

Solution 2

Half-life 1 is now released for native Linux. It is available from Steam (http://steampowered.com)

• How can I install Steam?

Solution 3

Install playonlinux. It is a wrapper around wine with some extra patches. It is free.

Solution 4

Check out this page for install instructions.

Currently there is no Steam or Source Engine for Linux, but recently there have been (more substantial than previous) rumors of a Steam Client for Linux, as well as a Source Engine port.

View more solutions

Comments

[RobotHumans]

They're both supported by playonlinunx playonlinux.com/repository/?cat=1&type=0

[Anwar]

Can PlayOnLinux be installed without WINE?

[Luis Alvarado]

@Anwar yes but PoL will eventually download its version of Wine if it detects you do not have one (Including addons which are similar to using winetricks). It also downloads specific Wine versions even if you have Wine install for some specific cases (Some games in PoL depend on specific Wine versions).

[Luis Alvarado]

@Aditya actually, the answer provided in that link covers everything about steam (Even the additional components recommended by steam). I can only cover here how to install everything to use HL and HL2 without steam support.