[Fix] Mount Bug (All Mounts!)

[djcovi56]

So Today i wanna release the fix to get all Mounts (White+Black+Behemoth)
1st:
Rename TSaveMount(TGAME_GSP|Functions) to TSavePet
2nd:
Delete the Code and Change it to this one!

ALTER PROCEDURE [dbo].[TSavePet]
 [MENTION=2966893]Dwc[/MENTION]harID INT,
 [MENTION=834370]wpe[/MENTION]tID SMALLINT,
 [MENTION=624221]szn[/MENTION]ame VARCHAR(50),
 [MENTION=989881]timeus[/MENTION]e SMALLDATETIME
AS
DECLARE @dwUserID INT

SET @dwUserID = (SELECT dwUserID FROM TCHARTABLE WHERE dwCharID = [MENTION=2966893]Dwc[/MENTION]harID)

BEGIN TRAN TSAVEMOUNT
IF NOT EXISTS(SELECT TOP 1 [MENTION=834370]wpe[/MENTION]tID FROM TPETTABLE WHERE dwUserID = @dwUserID AND wPetID = [MENTION=834370]wpe[/MENTION]tID)
BEGIN
	INSERT INTO TPETTABLE(dwUserID, wPetID, szName, timeUse) 
	VALUES(@dwUserID, [MENTION=834370]wpe[/MENTION]tID, [MENTION=624221]szn[/MENTION]ame, [MENTION=989881]timeus[/MENTION]e)
END
ELSE
BEGIN
	UPDATE TPETTABLE SET
		szName = [MENTION=624221]szn[/MENTION]ame, timeUse = [MENTION=989881]timeus[/MENTION]e
	WHERE dwUserID = @dwUserID AND wPetID = [MENTION=834370]wpe[/MENTION]tID
END
COMMIT TRAN TSAVEMOUNT

3rd:
Rename the TITEMCHART to TITEMCHART_BACKUP
and insert the TITEMCHART you can download below!

DONE

Credits (for the TSavePet): MacRisen

[Crowlyseq]

It's better to use new mount system.

[djcovi56]

Originally Posted by Crowlyseq

It's better to use new mount system.

yes of course but if u have 3.5 files and want to use the mounts... :P