Execute this on your database:
Code:
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spGetGambleItemList] Script Date: 12/26/2009 02:19:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spGetGambleItemList]
AS
BEGIN
SET NOCOUNT ON
SELECT GIID, Name, Description, Price
, DATEDIFF(mi, GETDATE(), StartDate) AS 'StartDate'
, LifeTimeHour * 60 as 'LifeTimeHour', Opened, IsCash
FROM GambleItem(NOLOCK)
END
It is recommended that you use my database to avoid all sorts of errors.
http://forum.ragezone.com/f245/compl...tabase-696228/